Database
CREATE TABLE `announcements` ( `id` int(11) NOT NULL AUTO_INCREMENT, `message` text NOT NULL, `target_user_id` int(11) DEFAULT NULL, `is_active` tinyint(1) NOT NULL DEFAULT 1, `start_date` datetime NOT NULL DEFAULT current_timestamp(), `end_date` datetime NOT NULL DEFAULT '2099-12-31 23:59:59', `bg_color` varchar(30) DEFAULT '#FFFBEA', `icon_color` varchar(30) DEFAULT '#F59E0B', `icon_class` varchar(100) DEFAULT 'fas fa-bullhorn', `created_at` timestamp NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci CREATE TABLE `category` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci CREATE TABLE `countries` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `code` char(2) NOT NULL...