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
Empowering Manufacturing SMEs for National Economic Transformation and Societal Prosperity !
Dr. Alebachew Nigussie, Director General of EED
“The project has recorded performance beyond its initial targets!”
Dr. Alebachew Nigussie, Director General of EED
Addis Ababa, August 39, 2025 (EED)-Marking the successful completion of the SME Finance Project, Ethiopian Enterprise Development (EED) presented a comprehensive report summarizing the overall achievements of the project.
Speaking on the occasion, Dr. Alebachew Nigussie, Director General of EED, stated that an independent assessment conducted by the Ethiopian Policy Studies Institute confirmed that the project had achieved results beyond the targets set at its inception.
He explained that through coordinated collaboration with various stakeholders, the project was able to strengthen capital goods leasing companies by building their capacity, bridge technical skill gaps, improve product quality, competitiveness, and market performance, and introduce to Ethiopia a new, innovative financing mechanism that has proven responsive to the challenges of small and medium manufacturing enterprises.
Dr. Alebachew emphasized that these achievements are the outcome of strong institutional collaboration and joint effort. He also reaffirmed that the provision of machine lease financing, working capital loans, and business development services (BDS) will continue without interruption, while preparations for anew alternative project are already underway to further strengthen and scale up the results.
The closing event also featured reflections and discussions on the experiences, challenges, and lessons learned from the SME Finance Project.
