WordPress database error: [Invalid default value for 'created_at']CREATE TABLE IF NOT EXISTS BFc_embedpress_analytics_content (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
content_id varchar(255) NOT NULL,
content_type varchar(50) NOT NULL DEFAULT 'unknown',
embed_type varchar(100) NOT NULL,
embed_url text NOT NULL,
post_id bigint(20) unsigned DEFAULT NULL,
page_url text DEFAULT NULL,
title varchar(500) DEFAULT NULL,
total_views bigint(20) unsigned DEFAULT 0,
total_impressions bigint(20) unsigned DEFAULT 0,
total_clicks bigint(20) unsigned DEFAULT 0,
created_at datetime DEFAULT CURRENT_TIMESTAMP,
updated_at datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (id),
UNIQUE KEY unique_page_embed (page_url(255), embed_type),
KEY idx_content_type (content_type),
KEY idx_embed_type (embed_type),
KEY idx_post_id (post_id),
KEY idx_created_at (created_at),
KEY idx_total_views (total_views)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'json DEFAULT NULL,
view_duration int(11) unsigned DEFAULT 0,
' at line 11]CREATE TABLE IF NOT EXISTS BFc_embedpress_analytics_views (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
content_id varchar(255) NOT NULL,
user_id varchar(255) DEFAULT NULL,
session_id varchar(255) NOT NULL,
user_ip varchar(45) DEFAULT NULL,
user_agent text DEFAULT NULL,
referrer_url text DEFAULT NULL,
page_url text DEFAULT NULL,
interaction_type enum('impression', 'click', 'view', 'play', 'pause', 'complete') NOT NULL DEFAULT 'impression',
interaction_data json DEFAULT NULL,
view_duration int(11) unsigned DEFAULT 0,
created_at datetime DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id),
KEY idx_content_id (content_id),
KEY idx_user_id (user_id),
KEY idx_session_id (session_id),
KEY idx_interaction_type (interaction_type),
KEY idx_created_at (created_at),
KEY idx_user_ip (user_ip),
KEY idx_content_interaction (content_id, interaction_type),
KEY idx_daily_stats (content_id, interaction_type, created_at),
KEY idx_user_content_interaction (user_id, content_id, interaction_type),
KEY idx_deduplication (user_id, content_id, interaction_type, created_at)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
WordPress database error: [Invalid default value for 'created_at']CREATE TABLE IF NOT EXISTS BFc_embedpress_analytics_browser_info (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
user_id varchar(255) DEFAULT NULL,
session_id varchar(255) NOT NULL,
browser_fingerprint varchar(64) DEFAULT NULL,
browser_name varchar(100) DEFAULT NULL,
browser_version varchar(50) DEFAULT NULL,
operating_system varchar(100) DEFAULT NULL,
device_type enum('desktop', 'mobile', 'tablet', 'unknown') DEFAULT 'unknown',
screen_resolution varchar(20) DEFAULT NULL,
language varchar(10) DEFAULT NULL,
timezone varchar(50) DEFAULT NULL,
country varchar(100) DEFAULT NULL,
city varchar(100) DEFAULT NULL,
user_agent text DEFAULT NULL,
created_at datetime DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id),
UNIQUE KEY unique_user_fingerprint (user_id, browser_fingerprint),
KEY idx_user_id (user_id),
KEY idx_session_id (session_id),
KEY idx_browser_fingerprint (browser_fingerprint),
KEY idx_browser_name (browser_name),
KEY idx_operating_system (operating_system),
KEY idx_device_type (device_type),
KEY idx_country (country),
KEY idx_created_at (created_at)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
WordPress database error: [Invalid default value for 'achieved_at']CREATE TABLE IF NOT EXISTS BFc_embedpress_analytics_milestones (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
milestone_type enum('total_views', 'total_embeds', 'daily_views', 'monthly_views') NOT NULL,
milestone_value bigint(20) unsigned NOT NULL,
achieved_value bigint(20) unsigned NOT NULL,
is_notified tinyint(1) DEFAULT 0,
achieved_at datetime DEFAULT CURRENT_TIMESTAMP,
notified_at datetime DEFAULT NULL,
PRIMARY KEY (id),
KEY idx_milestone_type (milestone_type),
KEY idx_milestone_value (milestone_value),
KEY idx_is_notified (is_notified),
KEY idx_achieved_at (achieved_at)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
WordPress database error: [Invalid default value for 'first_visit']CREATE TABLE IF NOT EXISTS BFc_embedpress_analytics_referrers (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
referrer_url text NOT NULL,
referrer_domain varchar(255) NOT NULL,
referrer_source varchar(100) DEFAULT NULL,
utm_source varchar(100) DEFAULT NULL,
utm_medium varchar(100) DEFAULT NULL,
utm_campaign varchar(255) DEFAULT NULL,
utm_term varchar(255) DEFAULT NULL,
utm_content varchar(255) DEFAULT NULL,
total_views bigint(20) unsigned DEFAULT 0,
total_clicks bigint(20) unsigned DEFAULT 0,
unique_visitors bigint(20) unsigned DEFAULT 0,
first_visit datetime DEFAULT CURRENT_TIMESTAMP,
last_visit datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
created_at datetime DEFAULT CURRENT_TIMESTAMP,
updated_at datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (id),
UNIQUE KEY unique_referrer_url (referrer_url(255)),
KEY idx_referrer_domain (referrer_domain),
KEY idx_referrer_source (referrer_source),
KEY idx_utm_source (utm_source),
KEY idx_utm_medium (utm_medium),
KEY idx_utm_campaign (utm_campaign),
KEY idx_total_views (total_views),
KEY idx_total_clicks (total_clicks),
KEY idx_unique_visitors (unique_visitors),
KEY idx_first_visit (first_visit),
KEY idx_last_visit (last_visit),
KEY idx_created_at (created_at)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
The concept of the Small and Medium Enterprise Finance Project /SMEFP/ originated from a study conducted by World Bank in 2014 on the financing of small and medium enterprises (SMEs) in Ethiopia which discovered the phenomenon called ‘‘missing middle’’ where small and medium enterprises are more credit constrained than micro and large enterprises.
The study suggested a solution:
Strengthen the financial capacity of microfinance institutions (MFIs) and provide them with training to serve small and medium enterprises with high credit demand.
Commercial banks should also review their lending policy and focus on supporting small and medium enterprises in addition to the financial support of large enterprises, which should be based on the existing lending needs of small and medium enterprises.
Based on this study, the Small and Medium Enterprises Finance Project was realized through an agreement between the Government of Ethiopia and the World Bank. Accordingly, the loan agreement was signed between the Government of Ethiopia and the World Bank on 15 June 2016.
The project has four components. The Project Coordination Office under the Ethiopian Enterprise Development /EED/ is responsible for the overall coordination role and direct implementation of the second, third and fourth components.
The component is being implemented by the Development Bank of Ethiopia with a budget of $ 269 million and an additional $ 180 million is added to the fund.
The credit line of the project has two lending windows:
This Component is carrying out by the National Bank of Ethiopia and the Project Coordination Office with a budget of $ 1.87 million. The activities under this framework are “Centralized electronic collateral registry and diagnostic survey on insolvency and creditors/debtors regime”. There is also additional activity to be implemented by the National Bank of Ethiopian /NBA/ and the Project Coordination Office which is earmarked $ 3 million for the development of Movable Asset Based Lending and strengthening the credit system in the additional finance.
This component aims to build firm capabilities through selected value chains and broaden SMEs’ access to market by implementing a firm capability-building program and e-commerce platform in Ethiopia. It is implementing by the Project Coordination Office and Ethiopian Postal Service /EPS/. The budget for the parent project is $ 2.26 million, $ 15 million allocated for the additional finance.
It is implementing by the Project Coordination Office and has a budget of $ 2.86 million in the parent project; $ 2 million is earmarked for additional finance.
