-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `softlicoltd_cms`
--

-- --------------------------------------------------------

--
-- Table structure for table `smartend_analytics_pages`
--

CREATE TABLE `smartend_analytics_pages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `visitor_id` bigint(20) UNSIGNED NOT NULL,
  `ip` varchar(191) DEFAULT NULL,
  `title` text DEFAULT NULL,
  `name` varchar(191) DEFAULT NULL,
  `query` text DEFAULT NULL,
  `load_time` varchar(191) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `time` time DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `smartend_analytics_pages`
--

INSERT INTO `smartend_analytics_pages` (`id`, `visitor_id`, `ip`, `title`, `name`, `query`, `load_time`, `date`, `time`, `created_at`, `updated_at`) VALUES
(1, 1, '103.134.3.18', 'Dashboard &raquo; Sign in to CONTROL', 'unknown', 'http://cms.softlico.com/admin/login', '0.02137208', '2025-01-04', '14:15:36', '2025-01-04 09:15:36', '2025-01-04 09:15:36'),
(2, 1, '103.134.3.18', 'Site Title', 'unknown', 'http://cms.softlico.com/', '0.10104084', '2025-01-04', '14:15:41', '2025-01-04 09:15:41', '2025-01-04 09:15:41'),
(3, 1, '103.134.3.18', 'Dashboard &raquo; Site Title', 'unknown', 'http://cms.softlico.com/admin', '0.04511809', '2025-01-04', '14:16:01', '2025-01-04 09:16:01', '2025-01-04 09:16:01'),
(4, 1, '103.134.3.18', 'Dashboard &raquo; Ad. Banners', 'unknown', 'http://cms.softlico.com/admin/banners', '0.026438', '2025-01-04', '14:16:08', '2025-01-04 09:16:08', '2025-01-04 09:16:08'),
(5, 1, '103.134.3.18', 'Dashboard &raquo; Ad. Banners', 'unknown', 'http://cms.softlico.com/admin/banners/3/edit', '0.02903819', '2025-01-04', '14:16:11', '2025-01-04 09:16:11', '2025-01-04 09:16:11'),
(6, 1, '103.134.3.18', 'Dashboard &raquo; Our Staff', 'unknown', 'http://cms.softlico.com/admin/12/topics', '0.0398941', '2025-01-04', '14:16:45', '2025-01-04 09:16:45', '2025-01-04 09:16:45'),
(7, 2, '205.169.39.107', 'Site Title', 'unknown', 'http://cms.softlico.com/', '0.08201814', '2025-01-04', '14:17:23', '2025-01-04 09:17:23', '2025-01-04 09:17:23'),
(8, 1, '103.134.3.18', 'Dashboard &raquo; Site pages', 'unknown', 'http://cms.softlico.com/admin/1/topics', '0.0235219', '2025-01-04', '14:17:29', '2025-01-04 09:17:29', '2025-01-04 09:17:29'),
(9, 1, '103.134.3.18', 'Dashboard &raquo; System Settings', 'unknown', 'http://cms.softlico.com/admin/webmaster', '0.05463386', '2025-01-04', '14:17:36', '2025-01-04 09:17:36', '2025-01-04 09:17:36'),
(10, 1, '103.134.3.18', 'Dashboard &raquo; Home Welcome', 'unknown', 'http://cms.softlico.com/admin/1/topics/5/edit', '0.03832412', '2025-01-04', '14:21:49', '2025-01-04 09:21:49', '2025-01-04 09:21:49'),
(11, 1, '103.134.3.18', 'Dashboard &raquo; Photos', 'unknown', 'http://cms.softlico.com/admin/4/topics', '0.03051901', '2025-01-04', '14:22:45', '2025-01-04 09:22:45', '2025-01-04 09:22:45'),
(12, 1, '103.134.3.18', 'Dashboard &raquo; System Modules', 'unknown', 'http://cms.softlico.com/admin/modules', '0.16253686', '2025-01-04', '14:24:05', '2025-01-04 09:24:05', '2025-01-04 09:24:05'),
(13, 1, '103.134.3.18', 'Photos', 'unknown', 'http://cms.softlico.com/photos', '0.05545211', '2025-01-04', '14:24:24', '2025-01-04 09:24:24', '2025-01-04 09:24:24'),
(14, 1, '103.134.3.18', 'Dashboard &raquo; Services', 'unknown', 'http://cms.softlico.com/admin/2/topics', '0.16128302', '2025-01-04', '14:25:43', '2025-01-04 09:25:43', '2025-01-04 09:25:43'),
(15, 1, '103.134.3.18', 'Dashboard &raquo; Testimonials', 'unknown', 'http://cms.softlico.com/admin/11/topics', '0.03120995', '2025-01-04', '14:25:56', '2025-01-04 09:25:56', '2025-01-04 09:25:56'),
(16, 1, '103.134.3.18', 'Dashboard &raquo; Branches', 'unknown', 'http://cms.softlico.com/admin/13/topics', '0.02236485', '2025-01-04', '14:26:06', '2025-01-04 09:26:06', '2025-01-04 09:26:06'),
(17, 1, '103.134.3.18', 'Dashboard &raquo; Tags', 'unknown', 'http://cms.softlico.com/admin/tags', '0.03327799', '2025-01-04', '14:26:26', '2025-01-04 09:26:26', '2025-01-04 09:26:26'),
(18, 1, '103.134.3.18', 'Dashboard &raquo; Partners', 'unknown', 'http://cms.softlico.com/admin/9/topics', '0.02998805', '2025-01-04', '14:26:45', '2025-01-04 09:26:45', '2025-01-04 09:26:45'),
(19, 1, '103.134.3.18', 'Dashboard &raquo; FAQ', 'unknown', 'http://cms.softlico.com/admin/10/topics', '0.03188705', '2025-01-04', '14:27:48', '2025-01-04 09:27:48', '2025-01-04 09:27:48'),
(20, 1, '103.134.3.18', 'Dashboard &raquo; Inbox', 'unknown', 'http://cms.softlico.com/admin/webmails', '0.03585196', '2025-01-04', '14:28:20', '2025-01-04 09:28:20', '2025-01-04 09:28:20'),
(21, 3, '45.134.212.72', 'Site Title', 'unknown', 'http://cms.softlico.com/', '0.22372198', '2025-01-04', '14:55:00', '2025-01-04 09:55:00', '2025-01-04 09:55:00'),
(22, 4, '104.166.80.205', 'Site Title', 'unknown', 'http://www.cms.softlico.com/', '0.22963619', '2025-01-04', '14:57:49', '2025-01-04 09:57:49', '2025-01-04 09:57:49'),
(23, 5, '54.200.255.238', 'Site Title', 'unknown', 'http://cms.softlico.com/', '0.33401299', '2025-01-04', '15:02:21', '2025-01-04 10:02:21', '2025-01-04 10:02:21'),
(24, 6, '54.200.255.238', 'Site Title', 'unknown', 'http://cms.softlico.com/', '0.32740808', '2025-01-04', '15:02:21', '2025-01-04 10:02:21', '2025-01-04 10:02:21'),
(25, 7, '172.56.163.72', 'Site Title', 'unknown', 'http://cms.softlico.com/', '0.07256389', '2025-01-04', '15:02:21', '2025-01-04 10:02:21', '2025-01-04 10:02:21'),
(26, 8, '172.56.33.191', 'Site Title', 'unknown', 'http://cms.softlico.com/', '0.05739093', '2025-01-04', '15:02:22', '2025-01-04 10:02:22', '2025-01-04 10:02:22'),
(27, 9, '149.102.230.117', 'Site Title', 'unknown', 'http://cms.softlico.com:80/', '0.07325983', '2025-01-04', '15:02:24', '2025-01-04 10:02:24', '2025-01-04 10:02:24'),
(28, 10, '149.102.230.119', 'Site Title', 'unknown', 'http://cms.softlico.com:80/', '0.05631495', '2025-01-04', '15:02:24', '2025-01-04 10:02:24', '2025-01-04 10:02:24'),
(29, 11, '149.102.230.118', 'Site Title', 'unknown', 'http://cms.softlico.com:80/', '0.06476402', '2025-01-04', '15:02:25', '2025-01-04 10:02:25', '2025-01-04 10:02:25'),
(30, 12, '54.247.57.72', 'Site Title', 'unknown', 'http://www.cms.softlico.com/', '0.23117495', '2025-01-04', '15:12:04', '2025-01-04 10:12:04', '2025-01-04 10:12:04'),
(31, 12, '54.247.57.72', 'Site Title', 'unknown', 'http://cms.softlico.com/', '0.059865', '2025-01-04', '15:12:17', '2025-01-04 10:12:17', '2025-01-04 10:12:17'),
(32, 13, '54.200.105.213', 'Site Title', 'unknown', 'http://cms.softlico.com/', '0.24215794', '2025-01-04', '15:33:13', '2025-01-04 10:33:13', '2025-01-04 10:33:13'),
(33, 14, '104.166.80.245', 'Site Title', 'unknown', 'http://cms.softlico.com/', '0.23141098', '2025-01-04', '15:57:49', '2025-01-04 10:57:49', '2025-01-04 10:57:49'),
(34, 15, '54.188.126.80', 'Site Title', 'unknown', 'http://cms.softlico.com/', '0.22899008', '2025-01-04', '16:01:06', '2025-01-04 11:01:06', '2025-01-04 11:01:06'),
(35, 16, '192.175.111.253', 'Site Title', 'unknown', 'http://cms.softlico.com/', '0.21534181', '2025-01-04', '16:03:20', '2025-01-04 11:03:20', '2025-01-04 11:03:20'),
(36, 17, '192.175.111.237', 'Site Title', 'unknown', 'http://cms.softlico.com/', '0.06348014', '2025-01-04', '16:03:29', '2025-01-04 11:03:29', '2025-01-04 11:03:29'),
(37, 18, '64.15.129.121', 'Site Title', 'unknown', 'http://cms.softlico.com/', '0.06119394', '2025-01-04', '16:03:31', '2025-01-04 11:03:31', '2025-01-04 11:03:31'),
(38, 19, '192.175.111.248', 'Site Title', 'unknown', 'http://www.cms.softlico.com/', '0.10034013', '2025-01-04', '16:03:37', '2025-01-04 11:03:37', '2025-01-04 11:03:37'),
(39, 20, '192.175.111.249', 'Site Title', 'unknown', 'http://www.cms.softlico.com/', '0.07928896', '2025-01-04', '16:03:39', '2025-01-04 11:03:39', '2025-01-04 11:03:39'),
(40, 21, '44.243.188.92', 'Site Title', 'unknown', 'http://cms.softlico.com/', '0.21536112', '2025-01-04', '16:16:50', '2025-01-04 11:16:50', '2025-01-04 11:16:50'),
(41, 22, '52.42.6.165', 'Site Title', 'unknown', 'http://cms.softlico.com/', '0.23496819', '2025-01-04', '16:35:00', '2025-01-04 11:35:00', '2025-01-04 11:35:00'),
(42, 23, '35.89.126.72', 'Site Title', 'unknown', 'http://www.cms.softlico.com/', '0.2489922', '2025-01-04', '18:19:00', '2025-01-04 13:19:00', '2025-01-04 13:19:00'),
(43, 24, '54.202.24.187', 'Site Title', 'unknown', 'http://cms.softlico.com/', '0.28016591', '2025-01-04', '18:39:01', '2025-01-04 13:39:01', '2025-01-04 13:39:01'),
(44, 25, '34.211.233.18', 'Site Title', 'unknown', 'http://www.cms.softlico.com/', '0.09453201', '2025-01-04', '18:40:21', '2025-01-04 13:40:21', '2025-01-04 13:40:21'),
(45, 26, '44.245.4.70', 'Site Title', 'unknown', 'http://cms.softlico.com/', '0.23080492', '2025-01-04', '18:42:57', '2025-01-04 13:42:57', '2025-01-04 13:42:57'),
(46, 27, '167.94.138.193', 'Site Title', 'unknown', 'http://www.cms.softlico.com/', '1.24238205', '2025-01-05', '01:20:23', '2025-01-04 20:20:23', '2025-01-04 20:20:23'),
(47, 28, '167.94.138.180', 'Site Title', 'unknown', 'http://www.cms.softlico.com/', '0.22757792', '2025-01-05', '01:49:08', '2025-01-04 20:49:08', '2025-01-04 20:49:08'),
(48, 29, '167.94.138.205', 'Site Title', 'unknown', 'http://cms.softlico.com/', '0.27907109', '2025-01-05', '02:09:36', '2025-01-04 21:09:36', '2025-01-04 21:09:36'),
(49, 30, '104.164.173.33', 'Site Title', 'unknown', 'http://cms.softlico.com/', '0.27831507', '2025-01-05', '03:00:15', '2025-01-04 22:00:15', '2025-01-04 22:00:15'),
(50, 31, '107.172.166.73', 'Site Title', 'unknown', 'http://cms.softlico.com/', '0.10060096', '2025-01-05', '03:01:13', '2025-01-04 22:01:13', '2025-01-04 22:01:13'),
(51, 32, '176.223.104.195', 'Site Title', 'unknown', 'http://cms.softlico.com/', '0.11387897', '2025-01-05', '03:01:13', '2025-01-04 22:01:13', '2025-01-04 22:01:13'),
(52, 33, '78.138.40.246', 'Site Title', 'unknown', 'http://www.cms.softlico.com/', '0.093925', '2025-01-05', '03:01:13', '2025-01-04 22:01:13', '2025-01-04 22:01:13'),
(53, 34, '107.172.166.45', 'Site Title', 'unknown', 'http://www.cms.softlico.com/', '0.08623409', '2025-01-05', '03:01:13', '2025-01-04 22:01:13', '2025-01-04 22:01:13'),
(54, 35, '103.134.3.18', 'Site Title', 'unknown', 'http://cms.softlico.com/', '0.35293794', '2025-01-05', '07:54:34', '2025-01-05 02:54:34', '2025-01-05 02:54:34'),
(55, 35, '103.134.3.18', 'Dashboard &raquo; Sign in to CONTROL', 'unknown', 'http://cms.softlico.com/admin/login', '0.10018921', '2025-01-05', '08:08:35', '2025-01-05 03:08:35', '2025-01-05 03:08:35'),
(56, 35, '103.134.3.18', 'Dashboard &raquo; Site Title', 'unknown', 'http://cms.softlico.com/admin', '0.05336404', '2025-01-05', '08:08:48', '2025-01-05 03:08:48', '2025-01-05 03:08:48'),
(57, 35, '103.134.3.18', 'Dashboard &raquo; System Settings', 'unknown', 'http://cms.softlico.com/admin/webmaster?tab=license', '0.10106111', '2025-01-05', '08:09:18', '2025-01-05 03:09:18', '2025-01-05 03:09:18'),
(58, 35, '103.134.3.18', 'Information Science', 'unknown', 'http://cms.softlico.com/products/educational-books/information-science', '0.0766809', '2025-01-05', '08:10:17', '2025-01-05 03:10:17', '2025-01-05 03:10:17'),
(59, 35, '103.134.3.18', 'Photos', 'unknown', 'http://cms.softlico.com/photos', '0.04789209', '2025-01-05', '08:10:26', '2025-01-05 03:10:26', '2025-01-05 03:10:26'),
(60, 35, '103.134.3.18', 'Audio books', 'unknown', 'http://cms.softlico.com/audio/audio-books', '0.08022285', '2025-01-05', '08:10:35', '2025-01-05 03:10:35', '2025-01-05 03:10:35'),
(61, 35, '103.134.3.18', 'Blog', 'unknown', 'http://cms.softlico.com/blog', '0.07811117', '2025-01-05', '08:10:41', '2025-01-05 03:10:41', '2025-01-05 03:10:41'),
(62, 35, '103.134.3.18', 'FAQ', 'unknown', 'http://cms.softlico.com/faq', '0.04377913', '2025-01-05', '08:10:57', '2025-01-05 03:10:57', '2025-01-05 03:10:57'),
(63, 35, '103.134.3.18', 'Dashboard &raquo; Site Title', 'unknown', 'http://cms.softlico.com/admin/search?q=recent+work', '0.03751802', '2025-01-05', '08:13:20', '2025-01-05 03:13:20', '2025-01-05 03:13:20'),
(64, 35, '103.134.3.18', 'Dashboard &raquo; Site Title', 'unknown', 'http://cms.softlico.com/admin/search?q=projects', '0.10039306', '2025-01-05', '08:13:37', '2025-01-05 03:13:37', '2025-01-05 03:13:37'),
(65, 35, '103.134.3.18', 'Dashboard &raquo; Categories of  Products', 'unknown', 'http://cms.softlico.com/admin/8/categories', '0.03513813', '2025-01-05', '08:13:45', '2025-01-05 03:13:45', '2025-01-05 03:13:45'),
(66, 35, '103.134.3.18', 'Dashboard &raquo; News', 'unknown', 'http://cms.softlico.com/admin/3/topics', '0.03845', '2025-01-05', '08:14:03', '2025-01-05 03:14:03', '2025-01-05 03:14:03'),
(67, 35, '103.134.3.18', 'Dashboard &raquo; System Modules', 'unknown', 'http://cms.softlico.com/admin/modules/3/edit', '0.0379591', '2025-01-05', '08:14:36', '2025-01-05 03:14:36', '2025-01-05 03:14:36'),
(68, 36, '223.123.11.128', 'Dashboard &raquo; Photos', 'unknown', 'http://cms.softlico.com/admin/4/topics', '0.17128205', '2025-01-05', '08:20:08', '2025-01-05 03:20:08', '2025-01-05 03:20:08'),
(69, 36, '223.123.11.128', 'Dashboard &raquo; System Settings', 'unknown', 'http://cms.softlico.com/admin/webmaster?tab=license', '0.1780448', '2025-01-05', '08:29:07', '2025-01-05 03:29:07', '2025-01-05 03:29:07'),
(70, 36, '223.123.11.128', 'Site Title', 'unknown', 'http://cms.softlico.com/', '0.07218218', '2025-01-05', '08:29:44', '2025-01-05 03:29:44', '2025-01-05 03:29:44'),
(71, 36, '223.123.11.128', 'Dashboard &raquo; Sign in to CONTROL', 'unknown', 'http://cms.softlico.com/admin/login', '0.02579379', '2025-01-05', '08:29:47', '2025-01-05 03:29:47', '2025-01-05 03:29:47'),
(72, 36, '223.123.11.128', 'Dashboard &raquo; Site Title', 'unknown', 'http://cms.softlico.com/admin', '0.03453088', '2025-01-05', '08:29:55', '2025-01-05 03:29:55', '2025-01-05 03:29:55'),
(73, 36, '223.123.11.128', 'Dashboard &raquo; System Settings', 'unknown', 'http://cms.softlico.com/admin/webmaster', '0.04534197', '2025-01-05', '08:30:53', '2025-01-05 03:30:53', '2025-01-05 03:30:53'),
(74, 36, '223.123.11.128', 'Dashboard &raquo; Site pages', 'unknown', 'http://cms.softlico.com/admin/1/topics', '0.03912807', '2025-01-05', '08:42:19', '2025-01-05 03:42:19', '2025-01-05 03:42:19'),
(75, 36, '223.123.11.128', 'Dashboard &raquo; Services', 'unknown', 'http://cms.softlico.com/admin/2/topics', '0.02791905', '2025-01-05', '08:42:35', '2025-01-05 03:42:35', '2025-01-05 03:42:35'),
(76, 36, '223.123.11.128', 'Dashboard &raquo; Videos', 'unknown', 'http://cms.softlico.com/admin/5/topics', '0.03603601', '2025-01-05', '08:43:33', '2025-01-05 03:43:33', '2025-01-05 03:43:33'),
(77, 36, '223.123.11.128', 'Dashboard &raquo; Categories of  Products', 'unknown', 'http://cms.softlico.com/admin/8/categories', '0.03134394', '2025-01-05', '08:44:24', '2025-01-05 03:44:24', '2025-01-05 03:44:24'),
(78, 36, '223.123.11.128', 'Dashboard &raquo; Products', 'unknown', 'http://cms.softlico.com/admin/8/topics', '0.01999211', '2025-01-05', '08:44:38', '2025-01-05 03:44:38', '2025-01-05 03:44:38'),
(79, 36, '223.123.11.128', 'Dashboard &raquo; News', 'unknown', 'http://cms.softlico.com/admin/3/topics', '0.0202291', '2025-01-05', '08:44:53', '2025-01-05 03:44:53', '2025-01-05 03:44:53'),
(80, 36, '223.123.11.128', 'Dashboard &raquo; Categories of  Videos', 'unknown', 'http://cms.softlico.com/admin/5/categories', '0.02577615', '2025-01-05', '08:45:13', '2025-01-05 03:45:13', '2025-01-05 03:45:13'),
(81, 36, '223.123.11.128', 'Dashboard &raquo; Categories of  Audio', 'unknown', 'http://cms.softlico.com/admin/6/categories', '0.02174091', '2025-01-05', '08:45:31', '2025-01-05 03:45:31', '2025-01-05 03:45:31'),
(82, 36, '223.123.11.128', 'Dashboard &raquo; Audio', 'unknown', 'http://cms.softlico.com/admin/6/topics', '0.01967001', '2025-01-05', '08:45:42', '2025-01-05 03:45:42', '2025-01-05 03:45:42'),
(83, 36, '223.123.11.128', 'Dashboard &raquo; Categories of  Blog', 'unknown', 'http://cms.softlico.com/admin/7/categories', '0.02363491', '2025-01-05', '08:45:56', '2025-01-05 03:45:56', '2025-01-05 03:45:56'),
(84, 36, '223.123.11.128', 'Dashboard &raquo; Blog', 'unknown', 'http://cms.softlico.com/admin/7/topics', '0.02122998', '2025-01-05', '08:45:59', '2025-01-05 03:45:59', '2025-01-05 03:45:59'),
(85, 36, '223.123.11.128', 'Dashboard &raquo; Partners', 'unknown', 'http://cms.softlico.com/admin/9/topics', '0.0274241', '2025-01-05', '08:48:11', '2025-01-05 03:48:11', '2025-01-05 03:48:11'),
(86, 36, '223.123.11.128', 'Dashboard &raquo; Categories of  FAQ', 'unknown', 'http://cms.softlico.com/admin/10/categories', '0.02284908', '2025-01-05', '08:48:27', '2025-01-05 03:48:27', '2025-01-05 03:48:27'),
(87, 36, '223.123.11.128', 'Dashboard &raquo; FAQ', 'unknown', 'http://cms.softlico.com/admin/10/topics', '0.01992583', '2025-01-05', '08:48:38', '2025-01-05 03:48:38', '2025-01-05 03:48:38'),
(88, 36, '223.123.11.128', 'Dashboard &raquo; Testimonials', 'unknown', 'http://cms.softlico.com/admin/11/topics', '0.0201571', '2025-01-05', '08:48:49', '2025-01-05 03:48:49', '2025-01-05 03:48:49'),
(89, 36, '223.123.11.128', 'Dashboard &raquo; Our Staff', 'unknown', 'http://cms.softlico.com/admin/12/topics', '0.02885199', '2025-01-05', '08:48:59', '2025-01-05 03:48:59', '2025-01-05 03:48:59'),
(90, 36, '223.123.11.128', 'Dashboard &raquo; Branches', 'unknown', 'http://cms.softlico.com/admin/13/topics', '0.02034903', '2025-01-05', '08:49:11', '2025-01-05 03:49:11', '2025-01-05 03:49:11'),
(91, 36, '223.123.11.128', 'Dashboard &raquo; Branches', 'unknown', 'http://cms.softlico.com/admin/13/topics/create', '0.02486992', '2025-01-05', '08:49:36', '2025-01-05 03:49:36', '2025-01-05 03:49:36'),
(92, 36, '223.123.11.128', 'Dashboard &raquo; Quote Request', 'unknown', 'http://cms.softlico.com/admin/14/topics', '0.02273202', '2025-01-05', '08:49:51', '2025-01-05 03:49:51', '2025-01-05 03:49:51'),
(93, 36, '223.123.11.128', 'Dashboard &raquo; System Settings', 'unknown', 'http://cms.softlico.com/admin/settings', '0.03217006', '2025-01-05', '08:50:22', '2025-01-05 03:50:22', '2025-01-05 03:50:22'),
(94, 36, '223.123.11.128', 'Dashboard &raquo; Categories of  Blog', 'unknown', 'http://cms.softlico.com/admin/7/categories/create', '0.02198386', '2025-01-05', '08:53:30', '2025-01-05 03:53:30', '2025-01-05 03:53:30'),
(95, 36, '223.123.11.128', 'Dashboard &raquo; Blog', 'unknown', 'http://cms.softlico.com/admin/7/topics/create', '0.02137995', '2025-01-05', '08:54:11', '2025-01-05 03:54:11', '2025-01-05 03:54:11'),
(96, 36, '223.123.11.128', 'Dashboard &raquo; Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod', 'unknown', 'http://cms.softlico.com/admin/7/topics/121/edit', '0.03896594', '2025-01-05', '08:55:05', '2025-01-05 03:55:05', '2025-01-05 03:55:05'),
(97, 36, '223.123.11.128', 'Dashboard &raquo; Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod - Copy', 'unknown', 'http://cms.softlico.com/admin/7/topics/122/edit', '0.02964497', '2025-01-05', '08:56:39', '2025-01-05 03:56:39', '2025-01-05 03:56:39'),
(98, 36, '223.123.11.128', 'Dashboard &raquo; Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod - Copy', 'unknown', 'http://cms.softlico.com/admin/7/topics/123/edit', '0.02582097', '2025-01-05', '08:56:54', '2025-01-05 03:56:54', '2025-01-05 03:56:54'),
(99, 36, '223.123.11.128', 'Dashboard &raquo; Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod - Copy - Copy', 'unknown', 'http://cms.softlico.com/admin/7/topics/124/edit', '0.02809596', '2025-01-05', '09:01:24', '2025-01-05 04:01:24', '2025-01-05 04:01:24'),
(100, 36, '223.123.11.128', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod - Copy', 'unknown', 'http://cms.softlico.com/blog/data-science/lorem-ipsum-dolor-sit-amet,-consectetur-adipisicing-elit,-sed-do-eiusmod-2', '0.04655194', '2025-01-05', '09:03:14', '2025-01-05 04:03:14', '2025-01-05 04:03:14'),
(101, 36, '223.123.11.128', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod - Copy - Copy', 'unknown', 'http://cms.softlico.com/blog/data-science/lorem-ipsum-dolor-sit-amet,-consectetur-adipisicing-elit,-sed-do-eiusmod-copy', '0.04028201', '2025-01-05', '09:03:26', '2025-01-05 04:03:26', '2025-01-05 04:03:26'),
(102, 36, '223.123.11.128', 'Dashboard &raquo; System Modules', 'unknown', 'http://cms.softlico.com/admin/modules', '0.03012395', '2025-01-05', '09:04:04', '2025-01-05 04:04:04', '2025-01-05 04:04:04'),
(103, 36, '223.123.11.128', 'Dashboard &raquo; System Modules', 'unknown', 'http://cms.softlico.com/admin/modules/create', '0.02912807', '2025-01-05', '09:05:36', '2025-01-05 04:05:36', '2025-01-05 04:05:36'),
(104, 36, '223.123.11.128', 'Dashboard &raquo; System Modules', 'unknown', 'http://cms.softlico.com/admin/modules/15/edit', '0.03146505', '2025-01-05', '09:06:50', '2025-01-05 04:06:50', '2025-01-05 04:06:50'),
(105, 36, '223.123.11.128', 'Dashboard &raquo; Research Centres', 'unknown', 'http://cms.softlico.com/admin/15/topics', '0.02474809', '2025-01-05', '09:06:55', '2025-01-05 04:06:55', '2025-01-05 04:06:55'),
(106, 36, '223.123.11.128', 'Dashboard &raquo; Research Centres', 'unknown', 'http://cms.softlico.com/admin/15/topics/create', '0.02451801', '2025-01-05', '09:06:58', '2025-01-05 04:06:58', '2025-01-05 04:06:58'),
(107, 36, '223.123.11.128', 'Dashboard &raquo; Centre for Policy Research in Agriculture and Rural Development', 'unknown', 'http://cms.softlico.com/admin/15/topics/125/edit', '0.03248906', '2025-01-05', '09:08:22', '2025-01-05 04:08:22', '2025-01-05 04:08:22'),
(108, 36, '223.123.11.128', 'Dashboard &raquo; Users &amp; Permissions', 'unknown', 'http://cms.softlico.com/admin/users', '0.03077888', '2025-01-05', '09:13:31', '2025-01-05 04:13:31', '2025-01-05 04:13:31'),
(109, 36, '223.123.11.128', 'Dashboard &raquo; Home Welcome', 'unknown', 'http://cms.softlico.com/admin/1/topics/5/edit', '0.02525306', '2025-01-05', '09:34:36', '2025-01-05 04:34:36', '2025-01-05 04:34:36'),
(110, 36, '223.123.11.128', 'Dashboard &raquo; Popups', 'unknown', 'http://cms.softlico.com/admin/popups', '0.03222394', '2025-01-05', '09:40:50', '2025-01-05 04:40:50', '2025-01-05 04:40:50'),
(111, 36, '223.123.11.128', 'Dashboard &raquo; Ad. Banners', 'unknown', 'http://cms.softlico.com/admin/banners', '0.02228093', '2025-01-05', '09:40:52', '2025-01-05 04:40:52', '2025-01-05 04:40:52'),
(112, 37, '223.123.23.162', 'Site Title', 'unknown', 'http://cms.softlico.com/', '0.04558921', '2025-01-05', '11:01:58', '2025-01-05 06:01:58', '2025-01-05 06:01:58'),
(113, 37, '223.123.23.162', 'Dashboard &raquo; Sign in to CONTROL', 'unknown', 'http://cms.softlico.com/admin/login', '0.016855', '2025-01-05', '11:02:05', '2025-01-05 06:02:05', '2025-01-05 06:02:05'),
(114, 37, '223.123.23.162', 'Dashboard &raquo; Site Title', 'unknown', 'http://cms.softlico.com/admin', '0.02801704', '2025-01-05', '11:02:12', '2025-01-05 06:02:12', '2025-01-05 06:02:12'),
(115, 37, '223.123.23.162', 'Dashboard &raquo; Research Centres', 'unknown', 'http://cms.softlico.com/admin/15/topics', '0.02513289', '2025-01-05', '11:02:20', '2025-01-05 06:02:20', '2025-01-05 06:02:20'),
(116, 37, '223.123.23.162', 'Dashboard &raquo; Centre for Policy Research in Agriculture and Rural Development', 'unknown', 'http://cms.softlico.com/admin/15/topics/125/edit', '0.02656913', '2025-01-05', '11:02:24', '2025-01-05 06:02:24', '2025-01-05 06:02:24'),
(117, 38, '138.197.143.150', 'Site Title', 'unknown', 'http://cms.softlico.com/', '0.17297792', '2025-01-05', '12:24:41', '2025-01-05 07:24:41', '2025-01-05 07:24:41'),
(118, 39, '174.138.19.131', 'Site Title', 'unknown', 'http://cms.softlico.com/', '0.03953505', '2025-01-05', '13:41:13', '2025-01-05 08:41:13', '2025-01-05 08:41:13'),
(119, 40, '104.166.80.115', 'Site Title', 'unknown', 'http://cms.softlico.com/', '1.09637785', '2025-01-05', '15:05:53', '2025-01-05 10:05:53', '2025-01-05 10:05:53'),
(120, 41, '104.166.80.147', 'Site Title', 'unknown', 'http://www.cms.softlico.com/', '0.17157316', '2025-01-05', '15:34:25', '2025-01-05 10:34:25', '2025-01-05 10:34:25'),
(121, 42, '44.245.201.183', 'Site Title', 'unknown', 'http://cms.softlico.com/', '0.16610289', '2025-01-05', '15:36:11', '2025-01-05 10:36:11', '2025-01-05 10:36:11'),
(122, 43, '34.218.80.196', 'Site Title', 'unknown', 'http://cms.softlico.com/', '0.1712749', '2025-01-05', '15:36:13', '2025-01-05 10:36:13', '2025-01-05 10:36:13'),
(123, 44, '104.164.173.62', 'Site Title', 'unknown', 'http://cms.softlico.com/', '0.17734385', '2025-01-05', '17:05:28', '2025-01-05 12:05:28', '2025-01-05 12:05:28'),
(124, 45, '207.241.236.83', 'Site Title', 'unknown', 'http://www.cms.softlico.com/', '0.173177', '2025-01-05', '17:18:53', '2025-01-05 12:18:53', '2025-01-05 12:18:53'),
(125, 46, '223.123.6.216', 'Site Title', 'unknown', 'http://cms.softlico.com/', '1.1137619', '2025-01-06', '12:06:48', '2025-01-06 07:06:48', '2025-01-06 07:06:48'),
(126, 46, '223.123.6.216', 'Dashboard &raquo; Sign in to CONTROL', 'unknown', 'http://cms.softlico.com/admin/login', '0.02828693', '2025-01-06', '12:08:46', '2025-01-06 07:08:46', '2025-01-06 07:08:46'),
(127, 46, '223.123.6.216', 'Dashboard &raquo; Site Title', 'unknown', 'http://cms.softlico.com/admin', '0.037848', '2025-01-06', '12:08:57', '2025-01-06 07:08:57', '2025-01-06 07:08:57'),
(128, 46, '223.123.6.216', 'Dashboard &raquo; Research Centres', 'unknown', 'http://cms.softlico.com/admin/15/topics', '0.02835679', '2025-01-06', '12:09:03', '2025-01-06 07:09:03', '2025-01-06 07:09:03'),
(129, 46, '223.123.6.216', 'Dashboard &raquo; Centre for Policy Research in Agriculture and Rural Development', 'unknown', 'http://cms.softlico.com/admin/15/topics/125/edit', '0.02632499', '2025-01-06', '12:09:18', '2025-01-06 07:09:18', '2025-01-06 07:09:18'),
(130, 47, '103.134.3.18', 'Site Title', 'unknown', 'http://cms.softlico.com/', '0.02546406', '2025-01-06', '12:29:45', '2025-01-06 07:29:45', '2025-01-06 07:29:45'),
(131, 47, '103.134.3.18', 'Dashboard &raquo; Centre for Policy Research in Agriculture and Rural Development', 'unknown', 'http://cms.softlico.com/admin/15/topics/125/edit', '0.16529799', '2025-01-06', '12:52:04', '2025-01-06 07:52:04', '2025-01-06 07:52:04'),
(132, 48, '209.38.39.20', 'Site Title', 'unknown', 'http://www.cms.softlico.com/', '0.16208601', '2025-01-06', '13:54:48', '2025-01-06 08:54:48', '2025-01-06 08:54:48'),
(133, 49, '104.166.80.177', 'Site Title', 'unknown', 'http://www.cms.softlico.com/', '0.33071017', '2025-01-06', '15:28:11', '2025-01-06 10:28:11', '2025-01-06 10:28:11'),
(134, 50, '104.166.80.181', 'Site Title', 'unknown', 'http://cms.softlico.com/', '0.16058397', '2025-01-06', '15:28:49', '2025-01-06 10:28:49', '2025-01-06 10:28:49'),
(135, 47, '103.134.3.18', 'Dashboard &raquo; Sign in to CONTROL', 'unknown', 'http://cms.softlico.com/admin/login', '0.01620984', '2025-01-06', '15:56:06', '2025-01-06 10:56:06', '2025-01-06 10:56:06'),
(136, 47, '103.134.3.18', 'Dashboard &raquo; Site Title', 'unknown', 'http://cms.softlico.com/admin', '0.03320003', '2025-01-06', '15:56:20', '2025-01-06 10:56:20', '2025-01-06 10:56:20'),
(137, 47, '103.134.3.18', 'Dashboard &raquo; Research Centres', 'unknown', 'http://cms.softlico.com/admin/15/topics', '0.02640295', '2025-01-06', '15:56:25', '2025-01-06 10:56:25', '2025-01-06 10:56:25'),
(138, 51, '34.217.67.1', 'Site Title', 'unknown', 'http://cms.softlico.com/', '0.16990995', '2025-01-06', '16:29:13', '2025-01-06 11:29:13', '2025-01-06 11:29:13'),
(139, 47, '103.134.3.18', 'Dashboard &raquo; 403', 'unknown', 'http://cms.softlico.com/admin/oops', '0.14207602', '2025-01-06', '16:56:04', '2025-01-06 11:56:04', '2025-01-06 11:56:04'),
(140, 52, '18.236.169.245', 'Site Title', 'unknown', 'http://cms.softlico.com/', '1.08047414', '2025-01-06', '22:36:13', '2025-01-06 17:36:13', '2025-01-06 17:36:13'),
(141, 53, '103.134.3.18', 'Site Title', 'unknown', 'http://cms.softlico.com/', '1.00658393', '2025-01-07', '08:45:18', '2025-01-07 03:45:18', '2025-01-07 03:45:18'),
(142, 53, '103.134.3.18', 'Dashboard &raquo; Site Title', 'unknown', 'http://cms.softlico.com/admin', '0.03297591', '2025-01-07', '08:45:28', '2025-01-07 03:45:28', '2025-01-07 03:45:28'),
(143, 53, '103.134.3.18', 'Dashboard &raquo; Research Centres', 'unknown', 'http://cms.softlico.com/admin/15/topics', '0.03498888', '2025-01-07', '08:45:47', '2025-01-07 03:45:47', '2025-01-07 03:45:47'),
(144, 53, '103.134.3.18', 'Dashboard &raquo; Centre for Policy Research in Agriculture and Rural Development', 'unknown', 'http://cms.softlico.com/admin/15/topics/125/edit', '0.02748108', '2025-01-07', '08:45:50', '2025-01-07 03:45:50', '2025-01-07 03:45:50'),
(145, 53, '103.134.3.18', 'Dashboard &raquo; Sign in to CONTROL', 'unknown', 'http://cms.softlico.com/admin/login', '0.02014089', '2025-01-07', '09:09:05', '2025-01-07 04:09:05', '2025-01-07 04:09:05'),
(146, 53, '103.134.3.18', 'Centre for Policy Research in Agriculture and Rural Development', 'unknown', 'http://cms.softlico.com/research-centres/centre-for-policy-research-in-agriculture-and-rural-development', '0.03358412', '2025-01-07', '10:43:50', '2025-01-07 05:43:50', '2025-01-07 05:43:50'),
(147, 53, '103.134.3.18', 'Dashboard &raquo; System Modules', 'unknown', 'http://cms.softlico.com/admin/modules/15/edit', '0.15046883', '2025-01-07', '10:46:14', '2025-01-07 05:46:14', '2025-01-07 05:46:14'),
(148, 54, '207.241.237.21', 'Site Title', 'unknown', 'http://cms.softlico.com/', '0.16460299', '2025-01-07', '13:10:26', '2025-01-07 08:10:26', '2025-01-07 08:10:26'),
(149, 55, '209.38.239.58', 'Site Title', 'unknown', 'http://cms.softlico.com/', '0.16118813', '2025-01-07', '14:00:30', '2025-01-07 09:00:30', '2025-01-07 09:00:30'),
(150, 56, '34.211.122.156', 'Site Title', 'unknown', 'http://cms.softlico.com/', '0.16904998', '2025-01-07', '15:29:14', '2025-01-07 10:29:14', '2025-01-07 10:29:14'),
(151, 57, '103.150.37.76', 'Site Title', 'unknown', 'http://cms.softlico.com/', '0.44464684', '2025-01-07', '17:21:15', '2025-01-07 12:21:15', '2025-01-07 12:21:15'),
(152, 58, '103.150.37.76', 'Site Title', 'unknown', 'http://cms.softlico.com/', '0.44448304', '2025-01-07', '17:21:15', '2025-01-07 12:21:15', '2025-01-07 12:21:15'),
(153, 59, '52.36.173.237', 'Site Title', 'unknown', 'http://cms.softlico.com/', '0.16153908', '2025-01-07', '17:49:55', '2025-01-07 12:49:55', '2025-01-07 12:49:55'),
(154, 60, '103.134.3.18', 'Site Title', 'unknown', 'http://cms.softlico.com/', '0.95235395', '2025-01-08', '07:09:15', '2025-01-08 02:09:15', '2025-01-08 02:09:15'),
(155, 60, '103.134.3.18', 'Dashboard &raquo; Site Title', 'unknown', 'http://cms.softlico.com/admin', '0.03285098', '2025-01-08', '07:09:25', '2025-01-08 02:09:25', '2025-01-08 02:09:25'),
(156, 60, '103.134.3.18', 'Centre for Policy Research in Agriculture and Rural Development', 'unknown', 'http://cms.softlico.com/research-centres/centre-for-policy-research-in-agriculture-and-rural-development', '0.03738904', '2025-01-08', '07:10:04', '2025-01-08 02:10:04', '2025-01-08 02:10:04'),
(157, 60, '103.134.3.18', 'Research Centres', 'unknown', 'http://cms.softlico.com/research-centres/topic-ayan.php', '0.02780604', '2025-01-08', '08:14:41', '2025-01-08 03:14:41', '2025-01-08 03:14:41'),
(158, 60, '103.134.3.18', 'Dashboard &raquo; Research Centres', 'unknown', 'http://cms.softlico.com/admin/15/topics', '0.15988803', '2025-01-08', '08:40:50', '2025-01-08 03:40:50', '2025-01-08 03:40:50'),
(159, 60, '103.134.3.18', 'Dashboard &raquo; Centre for Policy Research in Agriculture and Rural Development', 'unknown', 'http://cms.softlico.com/admin/15/topics/125/edit', '0.02842116', '2025-01-08', '08:40:55', '2025-01-08 03:40:55', '2025-01-08 03:40:55'),
(160, 60, '103.134.3.18', 'Research Centres', 'unknown', 'http://cms.softlico.com/research-centres', '0.15575004', '2025-01-08', '10:53:29', '2025-01-08 05:53:29', '2025-01-08 05:53:29'),
(161, 60, '103.134.3.18', 'Dashboard &raquo; Centre for Policy Research in Agriculture and Rural Development - Copy', 'unknown', 'http://cms.softlico.com/admin/15/topics/126/edit', '0.02519608', '2025-01-08', '11:12:10', '2025-01-08 06:12:10', '2025-01-08 06:12:10'),
(162, 60, '103.134.3.18', 'Dashboard &raquo; Centre for Policy Research in Agriculture and Rural Development - Copy - Copy', 'unknown', 'http://cms.softlico.com/admin/15/topics/127/edit', '0.02305984', '2025-01-08', '11:12:31', '2025-01-08 06:12:31', '2025-01-08 06:12:31'),
(163, 61, '162.142.125.34', 'Site Title', 'unknown', 'http://www.cms.softlico.com/', '0.03653002', '2025-01-08', '11:48:54', '2025-01-08 06:48:54', '2025-01-08 06:48:54'),
(164, 60, '103.134.3.18', 'Dashboard &raquo; System Settings', 'unknown', 'http://cms.softlico.com/admin/settings', '0.2268939', '2025-01-08', '11:58:02', '2025-01-08 06:58:02', '2025-01-08 06:58:02'),
(165, 60, '103.134.3.18', 'Dashboard &raquo; System Modules', 'unknown', 'http://cms.softlico.com/admin/modules', '0.02665901', '2025-01-08', '11:58:36', '2025-01-08 06:58:36', '2025-01-08 06:58:36'),
(166, 60, '103.134.3.18', 'Dashboard &raquo; System Settings', 'unknown', 'http://cms.softlico.com/admin/webmaster', '0.036726', '2025-01-08', '11:58:44', '2025-01-08 06:58:44', '2025-01-08 06:58:44'),
(167, 62, '159.65.24.209', 'Site Title', 'unknown', 'http://www.cms.softlico.com/', '0.16622496', '2025-01-08', '13:08:50', '2025-01-08 08:08:50', '2025-01-08 08:08:50'),
(168, 63, '104.166.80.111', 'Site Title', 'unknown', 'http://cms.softlico.com/', '0.25494099', '2025-01-08', '15:21:58', '2025-01-08 10:21:58', '2025-01-08 10:21:58'),
(169, 64, '104.166.80.62', 'Site Title', 'unknown', 'http://www.cms.softlico.com/', '0.16549087', '2025-01-08', '15:23:26', '2025-01-08 10:23:26', '2025-01-08 10:23:26'),
(170, 60, '103.134.3.18', 'Dashboard &raquo; System Modules', 'unknown', 'http://cms.softlico.com/admin/modules/create', '0.0194869', '2025-01-08', '16:26:36', '2025-01-08 11:26:36', '2025-01-08 11:26:36'),
(171, 60, '103.134.3.18', 'Dashboard &raquo; System Modules', 'unknown', 'http://cms.softlico.com/admin/modules/16/edit', '0.04354692', '2025-01-08', '16:27:55', '2025-01-08 11:27:55', '2025-01-08 11:27:55'),
(172, 60, '103.134.3.18', 'Dashboard &raquo; Categories of  Recent Publications', 'unknown', 'http://cms.softlico.com/admin/16/categories', '0.02088594', '2025-01-08', '16:28:05', '2025-01-08 11:28:05', '2025-01-08 11:28:05'),
(173, 60, '103.134.3.18', 'Dashboard &raquo; Categories of  Recent Publications', 'unknown', 'http://cms.softlico.com/admin/16/categories/create', '0.01838517', '2025-01-08', '16:28:07', '2025-01-08 11:28:07', '2025-01-08 11:28:07'),
(174, 60, '103.134.3.18', 'Dashboard &raquo; Recent Publications', 'unknown', 'http://cms.softlico.com/admin/16/topics', '0.0252521', '2025-01-08', '16:29:00', '2025-01-08 11:29:00', '2025-01-08 11:29:00'),
(175, 60, '103.134.3.18', 'Dashboard &raquo; Recent Publications', 'unknown', 'http://cms.softlico.com/admin/16/topics/create', '0.03354001', '2025-01-08', '16:29:18', '2025-01-08 11:29:18', '2025-01-08 11:29:18'),
(176, 60, '103.134.3.18', 'Dashboard &raquo; Enhancing the Collaboration between TVET Institutions and the Private Sector in Cambodia: Implications for Skills Provision', 'unknown', 'http://cms.softlico.com/admin/16/topics/128/edit', '0.04298806', '2025-01-08', '16:29:32', '2025-01-08 11:29:32', '2025-01-08 11:29:32'),
(177, 60, '103.134.3.18', 'Dashboard &raquo; Enhancing the Collaboration between TVET Institutions and the Private Sector in Cambodia: Implications for Skills Provision', 'unknown', 'http://cms.softlico.com/admin/16/topics/129/edit', '0.03122807', '2025-01-08', '16:41:36', '2025-01-08 11:41:36', '2025-01-08 11:41:36'),
(178, 60, '103.134.3.18', 'Recent Publications', 'unknown', 'http://cms.softlico.com/recent-publications', '0.02676201', '2025-01-08', '16:43:12', '2025-01-08 11:43:12', '2025-01-08 11:43:12'),
(179, 60, '103.134.3.18', 'Enhancing the Collaboration between TVET Institutions and the Private Sector in Cambodia: Implications for Skills Provision', 'unknown', 'http://cms.softlico.com/recent-publications/working-papers-150/enhancing-the-collaboration-between-tvet-institutions-and-the-private-sector-in-cambodia:-implications-for-skills-provision', '0.03143096', '2025-01-08', '16:43:21', '2025-01-08 11:43:21', '2025-01-08 11:43:21'),
(180, 60, '103.134.3.18', 'Enhancing the Collaboration between TVET Institutions and the Private Sector in Cambodia: Implications for Skills Provision', 'unknown', 'http://cms.softlico.com/recent-publications/working-papers-150/enhancing-the-collaboration-between-tvet-institutions-and-the-private-sector-in-cambodia:-implications-for-skills-provision-1', '0.03000784', '2025-01-08', '17:06:03', '2025-01-08 12:06:03', '2025-01-08 12:06:03'),
(181, 60, '103.134.3.18', 'Site Title', 'unknown', 'http://cms.softlico.com/?sdfsafsad', '0.04219794', '2025-01-08', '17:12:47', '2025-01-08 12:12:47', '2025-01-08 12:12:47'),
(182, 60, '103.134.3.18', 'Dashboard &raquo; System Modules', 'unknown', 'http://cms.softlico.com/admin/modules/17/edit', '0.02476716', '2025-01-08', '17:35:29', '2025-01-08 12:35:29', '2025-01-08 12:35:29'),
(183, 60, '103.134.3.18', 'Dashboard &raquo; Recent Projects', 'unknown', 'http://cms.softlico.com/admin/17/topics', '0.02674198', '2025-01-08', '17:35:36', '2025-01-08 12:35:36', '2025-01-08 12:35:36'),
(184, 60, '103.134.3.18', 'Dashboard &raquo; Recent Projects', 'unknown', 'http://cms.softlico.com/admin/17/topics/create', '0.02344799', '2025-01-08', '17:35:42', '2025-01-08 12:35:42', '2025-01-08 12:35:42'),
(185, 60, '103.134.3.18', 'Dashboard &raquo; Lifting Barriers: Educated Boys for Gender Equality', 'unknown', 'http://cms.softlico.com/admin/17/topics/130/edit', '0.03877306', '2025-01-08', '17:36:27', '2025-01-08 12:36:27', '2025-01-08 12:36:27'),
(186, 60, '103.134.3.18', 'Dashboard &raquo; Categories of  Recent Projects', 'unknown', 'http://cms.softlico.com/admin/17/categories', '0.02216291', '2025-01-08', '17:38:15', '2025-01-08 12:38:15', '2025-01-08 12:38:15'),
(187, 60, '103.134.3.18', 'Dashboard &raquo; Categories of  Recent Projects', 'unknown', 'http://cms.softlico.com/admin/17/categories/create', '0.01905084', '2025-01-08', '17:38:17', '2025-01-08 12:38:17', '2025-01-08 12:38:17'),
(188, 60, '103.134.3.18', 'Dashboard &raquo; Sign in to CONTROL', 'unknown', 'http://cms.softlico.com/admin/login', '0.01868296', '2025-01-08', '18:00:36', '2025-01-08 13:00:36', '2025-01-08 13:00:36'),
(189, 60, '103.134.3.18', 'Site pages', 'unknown', 'http://cms.softlico.com/site-pages?search_word=TVET+INSTitution', '0.03484392', '2025-01-08', '18:22:24', '2025-01-08 13:22:24', '2025-01-08 13:22:24'),
(190, 60, '103.134.3.18', 'Site pages', 'unknown', 'http://cms.softlico.com/site-pages?search_word=Agriculture', '0.03222799', '2025-01-08', '18:22:35', '2025-01-08 13:22:35', '2025-01-08 13:22:35'),
(191, 60, '103.134.3.18', 'About Us', 'unknown', 'http://cms.softlico.com/about', '0.03720284', '2025-01-08', '18:29:38', '2025-01-08 13:29:38', '2025-01-08 13:29:38'),
(192, 60, '103.134.3.18', 'Privacy Policy', 'unknown', 'http://cms.softlico.com/privacy', '0.03198981', '2025-01-08', '18:29:50', '2025-01-08 13:29:50', '2025-01-08 13:29:50'),
(193, 60, '103.134.3.18', 'Terms & Conditions', 'unknown', 'http://cms.softlico.com/terms', '0.03114104', '2025-01-08', '18:29:52', '2025-01-08 13:29:52', '2025-01-08 13:29:52'),
(194, 60, '103.134.3.18', 'Contact Us', 'unknown', 'http://cms.softlico.com/contact', '0.02585411', '2025-01-08', '18:29:55', '2025-01-08 13:29:55', '2025-01-08 13:29:55'),
(195, 60, '103.134.3.18', 'Blog', 'unknown', 'http://cms.softlico.com/blog', '0.03287292', '2025-01-08', '18:30:42', '2025-01-08 13:30:42', '2025-01-08 13:30:42'),
(196, 60, '103.134.3.18', 'Dashboard &raquo; Site Menus', 'unknown', 'http://cms.softlico.com/admin/menus', '0.025841', '2025-01-08', '18:30:55', '2025-01-08 13:30:55', '2025-01-08 13:30:55'),
(197, 60, '103.134.3.18', 'Dashboard &raquo; Site Menus', 'unknown', 'http://cms.softlico.com/admin/menus/create/1', '0.02735496', '2025-01-08', '18:31:10', '2025-01-08 13:31:10', '2025-01-08 13:31:10'),
(198, 65, '18.246.35.134', 'DATA COLABX', 'unknown', 'http://cms.softlico.com/', '0.04129791', '2025-01-08', '18:57:50', '2025-01-08 13:57:50', '2025-01-08 13:57:50'),
(199, 60, '103.134.3.18', 'Dashboard &raquo; Analytics', 'unknown', 'http://cms.softlico.com/admin/analytics/date', '0.03254414', '2025-01-08', '19:01:28', '2025-01-08 14:01:28', '2025-01-08 14:01:28'),
(200, 60, '103.134.3.18', 'Dashboard &raquo; Analytics', 'unknown', 'http://cms.softlico.com/admin/analytics/os', '0.02970719', '2025-01-08', '19:01:33', '2025-01-08 14:01:33', '2025-01-08 14:01:33'),
(201, 60, '103.134.3.18', 'Dashboard &raquo; Analytics', 'unknown', 'http://cms.softlico.com/admin/analytics/referrer', '0.02113414', '2025-01-08', '19:01:35', '2025-01-08 14:01:35', '2025-01-08 14:01:35'),
(202, 60, '103.134.3.18', 'Dashboard &raquo; Popups', 'unknown', 'http://cms.softlico.com/admin/popups', '0.02149892', '2025-01-08', '19:01:38', '2025-01-08 14:01:38', '2025-01-08 14:01:38'),
(203, 66, '34.221.80.249', 'DATA COLABX', 'unknown', 'http://cms.softlico.com/', '0.16683698', '2025-01-08', '19:10:42', '2025-01-08 14:10:42', '2025-01-08 14:10:42'),
(204, 67, '209.38.46.8', 'DATA COLABX', 'unknown', 'http://cms.softlico.com/', '0.98642397', '2025-01-09', '14:34:51', '2025-01-09 09:34:51', '2025-01-09 09:34:51'),
(205, 68, '35.163.128.89', 'DATA COLABX', 'unknown', 'http://cms.softlico.com/', '0.22448587', '2025-01-09', '16:41:56', '2025-01-09 11:41:56', '2025-01-09 11:41:56'),
(206, 69, '167.94.138.120', 'DATA COLABX', 'unknown', 'http://cms.softlico.com/', '0.16929412', '2025-01-09', '16:56:25', '2025-01-09 11:56:25', '2025-01-09 11:56:25'),
(207, 70, '162.142.125.116', 'DATA COLABX', 'unknown', 'http://cms.softlico.com/', '0.16627502', '2025-01-09', '16:59:14', '2025-01-09 11:59:14', '2025-01-09 11:59:14'),
(208, 71, '54.244.142.228', 'DATA COLABX', 'unknown', 'http://cms.softlico.com/', '0.16818905', '2025-01-09', '17:12:38', '2025-01-09 12:12:38', '2025-01-09 12:12:38'),
(209, 72, '167.94.138.168', 'DATA COLABX', 'unknown', 'http://cms.softlico.com/', '0.1678102', '2025-01-09', '17:45:25', '2025-01-09 12:45:25', '2025-01-09 12:45:25'),
(210, 73, '64.227.115.227', 'DATA COLABX', 'unknown', 'http://cms.softlico.com/', '1.03864598', '2025-01-10', '02:49:45', '2025-01-09 21:49:45', '2025-01-09 21:49:45'),
(211, 74, '167.94.138.32', 'DATA COLABX', 'unknown', 'http://cms.softlico.com/', '1.18391085', '2025-01-10', '06:21:26', '2025-01-10 01:21:26', '2025-01-10 01:21:26'),
(212, 75, '34.222.125.142', 'DATA COLABX', 'unknown', 'http://cms.softlico.com/', '0.97100496', '2025-01-10', '12:34:07', '2025-01-10 07:34:07', '2025-01-10 07:34:07'),
(213, 76, '35.90.158.179', 'DATA COLABX', 'unknown', 'http://cms.softlico.com/', '0.16969514', '2025-01-10', '12:37:41', '2025-01-10 07:37:41', '2025-01-10 07:37:41'),
(214, 77, '120.229.184.45', 'DATA COLABX', 'unknown', 'http://cms.softlico.com/', '0.90853405', '2025-01-11', '07:50:13', '2025-01-11 02:50:13', '2025-01-11 02:50:13'),
(215, 78, '27.47.107.250', 'DATA COLABX', 'unknown', 'http://cms.softlico.com/', '0.04025102', '2025-01-11', '07:51:38', '2025-01-11 02:51:38', '2025-01-11 02:51:38'),
(216, 79, '54.91.117.144', 'DATA COLABX', 'unknown', 'http://www.cms.softlico.com/', '0.19242096', '2025-01-11', '09:31:44', '2025-01-11 04:31:44', '2025-01-11 04:31:44'),
(217, 80, '54.185.5.155', 'DATA COLABX', 'unknown', 'http://cms.softlico.com/', '0.87162399', '2025-01-11', '12:55:48', '2025-01-11 07:55:48', '2025-01-11 07:55:48'),
(218, 81, '44.245.236.41', 'DATA COLABX', 'unknown', 'http://cms.softlico.com/', '0.18271804', '2025-01-11', '14:28:08', '2025-01-11 09:28:08', '2025-01-11 09:28:08'),
(219, 82, '103.150.37.78', 'DATA COLABX', 'unknown', 'http://cms.softlico.com/', '0.28710389', '2025-01-11', '15:03:10', '2025-01-11 10:03:10', '2025-01-11 10:03:10'),
(220, 83, '103.150.37.78', 'DATA COLABX', 'unknown', 'http://cms.softlico.com/', '0.286623', '2025-01-11', '15:03:10', '2025-01-11 10:03:10', '2025-01-11 10:03:10'),
(221, 84, '104.166.80.96', 'DATA COLABX', 'unknown', 'http://www.cms.softlico.com/', '0.17049599', '2025-01-11', '15:22:28', '2025-01-11 10:22:28', '2025-01-11 10:22:28'),
(222, 85, '104.166.80.237', 'DATA COLABX', 'unknown', 'http://cms.softlico.com/', '0.02994108', '2025-01-11', '15:22:37', '2025-01-11 10:22:37', '2025-01-11 10:22:37'),
(223, 86, '54.191.234.250', 'DATA COLABX', 'unknown', 'http://cms.softlico.com/', '0.90883303', '2025-01-12', '15:24:14', '2025-01-12 10:24:14', '2025-01-12 10:24:14'),
(224, 87, '52.42.43.206', 'DATA COLABX', 'unknown', 'http://cms.softlico.com/', '0.16526413', '2025-01-12', '15:40:57', '2025-01-12 10:40:57', '2025-01-12 10:40:57'),
(225, 88, '54.91.117.144', 'DATA COLABX', 'unknown', 'http://cms.softlico.com/', '0.96045399', '2025-01-13', '07:14:18', '2025-01-13 02:14:18', '2025-01-13 02:14:18'),
(226, 89, '223.123.6.96', 'DATA COLABX', 'unknown', 'http://cms.softlico.com/', '0.16800904', '2025-01-13', '07:21:34', '2025-01-13 02:21:34', '2025-01-13 02:21:34'),
(227, 89, '223.123.6.96', 'Dashboard &raquo; DATA COLABX', 'unknown', 'http://cms.softlico.com/admin?captcha', '0.18667603', '2025-01-13', '07:23:34', '2025-01-13 02:23:34', '2025-01-13 02:23:34'),
(228, 89, '223.123.6.96', 'Dashboard &raquo; Analytics', 'unknown', 'http://cms.softlico.com/admin/analytics/country', '0.16268682', '2025-01-13', '07:31:38', '2025-01-13 02:31:38', '2025-01-13 02:31:38'),
(229, 89, '223.123.6.96', 'Dashboard &raquo; DATA COLABX', 'unknown', 'http://cms.softlico.com/admin', '0.17942905', '2025-01-13', '07:38:01', '2025-01-13 02:38:01', '2025-01-13 02:38:01'),
(230, 89, '223.123.6.96', 'Dashboard &raquo; Analytics', 'unknown', 'http://cms.softlico.com/admin/analytics/browser', '0.0306952', '2025-01-13', '07:38:17', '2025-01-13 02:38:17', '2025-01-13 02:38:17'),
(231, 90, '103.134.3.18', 'Dashboard &raquo; System Settings', 'unknown', 'http://cms.softlico.com/admin/settings', '0.15249586', '2025-01-13', '07:51:10', '2025-01-13 02:51:10', '2025-01-13 02:51:10'),
(232, 90, '103.134.3.18', 'DATA COLABX', 'unknown', 'http://cms.softlico.com/', '0.04055595', '2025-01-13', '07:51:19', '2025-01-13 02:51:19', '2025-01-13 02:51:19'),
(233, 90, '103.134.3.18', 'Dashboard &raquo; System Settings', 'unknown', 'http://cms.softlico.com/admin/webmaster', '0.04411197', '2025-01-13', '07:52:42', '2025-01-13 02:52:42', '2025-01-13 02:52:42'),
(234, 91, '223.123.8.47', 'DATA COLABX', 'unknown', 'http://cms.softlico.com/', '0.20579791', '2025-01-13', '08:41:18', '2025-01-13 03:41:18', '2025-01-13 03:41:18'),
(235, 91, '223.123.8.47', 'Dashboard &raquo; DATA COLABX', 'unknown', 'http://cms.softlico.com/admin?captcha', '0.03793001', '2025-01-13', '08:46:19', '2025-01-13 03:46:19', '2025-01-13 03:46:19'),
(236, 91, '223.123.8.47', 'Dashboard &raquo; Sign in to CONTROL', 'unknown', 'http://cms.softlico.com/admin/login', '0.01788402', '2025-01-13', '08:46:31', '2025-01-13 03:46:31', '2025-01-13 03:46:31'),
(237, 91, '223.123.8.47', 'Dashboard &raquo; DATA COLABX', 'unknown', 'http://cms.softlico.com/admin', '0.03094292', '2025-01-13', '08:46:57', '2025-01-13 03:46:57', '2025-01-13 03:46:57'),
(238, 92, '202.56.3.34', 'DATA COLABX', 'unknown', 'http://cms.softlico.com/', '0.18074894', '2025-01-13', '09:33:40', '2025-01-13 04:33:40', '2025-01-13 04:33:40');

-- --------------------------------------------------------

--
-- Table structure for table `smartend_analytics_visitors`
--

CREATE TABLE `smartend_analytics_visitors` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `ip` varchar(191) DEFAULT NULL,
  `city` varchar(191) DEFAULT NULL,
  `country_code` varchar(191) DEFAULT NULL,
  `country` varchar(191) DEFAULT NULL,
  `region` varchar(191) DEFAULT NULL,
  `full_address` varchar(191) DEFAULT NULL,
  `location_cor1` varchar(191) DEFAULT NULL,
  `location_cor2` varchar(191) DEFAULT NULL,
  `os` varchar(191) DEFAULT NULL,
  `browser` varchar(191) DEFAULT NULL,
  `resolution` varchar(191) DEFAULT NULL,
  `referrer` text DEFAULT NULL,
  `hostname` varchar(191) DEFAULT NULL,
  `org` varchar(191) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `time` time DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `smartend_analytics_visitors`
--

INSERT INTO `smartend_analytics_visitors` (`id`, `ip`, `city`, `country_code`, `country`, `region`, `full_address`, `location_cor1`, `location_cor2`, `os`, `browser`, `resolution`, `referrer`, `hostname`, `org`, `date`, `time`, `created_at`, `updated_at`) VALUES
(1, '103.134.3.18', 'Narowal', 'PK', 'Pakistan', 'Punjab', NULL, '32.102', '74.873', 'Mac OS X', 'Chrome', 'unknown', 'https://cms.softlico.com/install/final', 'Unknown', 'Asia/Karachi', '2025-01-04', '14:15:36', '2025-01-04 09:15:36', '2025-01-04 09:15:36'),
(2, '205.169.39.107', 'Dallas', 'US', 'United States', 'Texas', NULL, '32.7767', '-96.797', 'Windows 7', 'Chrome', 'unknown', 'unknown', 'Unknown', 'America/Chicago', '2025-01-04', '14:17:23', '2025-01-04 09:17:23', '2025-01-04 09:17:23'),
(3, '45.134.212.72', 'Warsaw', 'PL', 'Poland', 'Mazovia', NULL, '52.2296', '21.0067', 'Windows 10', 'Chrome', 'unknown', 'unknown', 'Unknown', 'Europe/Warsaw', '2025-01-04', '14:55:00', '2025-01-04 09:55:00', '2025-01-04 09:55:00'),
(4, '104.166.80.205', 'Los Angeles', 'US', 'United States', 'California', NULL, '34.0544', '-118.2441', 'Linux', 'Firefox', 'unknown', 'unknown', 'Unknown', 'America/Los_Angeles', '2025-01-04', '14:57:49', '2025-01-04 09:57:49', '2025-01-04 09:57:49'),
(5, '54.200.255.238', 'Portland', 'US', 'United States', 'Oregon', NULL, '45.5235', '-122.676', 'Windows 10', 'Chrome', 'unknown', 'unknown', 'Unknown', 'America/Los_Angeles', '2025-01-04', '15:02:21', '2025-01-04 10:02:21', '2025-01-04 10:02:21'),
(6, '54.200.255.238', 'Portland', 'US', 'United States', 'Oregon', NULL, '45.5235', '-122.676', 'iPhone', 'Safari', 'unknown', 'unknown', 'Unknown', 'America/Los_Angeles', '2025-01-04', '15:02:21', '2025-01-04 10:02:21', '2025-01-04 10:02:21'),
(7, '172.56.163.72', 'Brooklyn', 'US', 'United States', 'New York', NULL, '40.7162', '-73.9229', 'Windows 10', 'Chrome', 'unknown', 'unknown', 'Unknown', 'America/New_York', '2025-01-04', '15:02:21', '2025-01-04 10:02:21', '2025-01-04 10:02:21'),
(8, '172.56.33.191', 'Arlington', 'US', 'United States', 'Virginia', NULL, '38.8574', '-77.1', 'iPhone', 'Safari', 'unknown', 'unknown', 'Unknown', 'America/New_York', '2025-01-04', '15:02:22', '2025-01-04 10:02:22', '2025-01-04 10:02:22'),
(9, '149.102.230.117', 'Frankfurt am Main', 'DE', 'Germany', 'Hesse', NULL, '50.1187', '8.6842', 'unknown', NULL, 'unknown', 'unknown', 'Unknown', 'Europe/Berlin', '2025-01-04', '15:02:24', '2025-01-04 10:02:24', '2025-01-04 10:02:24'),
(10, '149.102.230.119', 'Frankfurt am Main', 'DE', 'Germany', 'Hesse', NULL, '50.1187', '8.6842', 'unknown', NULL, 'unknown', 'unknown', 'Unknown', 'Europe/Berlin', '2025-01-04', '15:02:24', '2025-01-04 10:02:24', '2025-01-04 10:02:24'),
(11, '149.102.230.118', 'Frankfurt am Main', 'DE', 'Germany', 'Hesse', NULL, '50.1187', '8.6842', 'unknown', NULL, 'unknown', 'unknown', 'Unknown', 'Europe/Berlin', '2025-01-04', '15:02:25', '2025-01-04 10:02:25', '2025-01-04 10:02:25'),
(12, '54.247.57.72', 'Dublin', 'IE', 'Ireland', 'Leinster', NULL, '53.3498', '-6.26031', 'Linux', 'Firefox', 'unknown', 'unknown', 'Unknown', 'Europe/Dublin', '2025-01-04', '15:12:04', '2025-01-04 10:12:04', '2025-01-04 10:12:04'),
(13, '54.200.105.213', 'Portland', 'US', 'United States', 'Oregon', NULL, '45.5235', '-122.676', 'Windows 10', 'Chrome', 'unknown', 'unknown', 'Unknown', 'America/Los_Angeles', '2025-01-04', '15:33:13', '2025-01-04 10:33:13', '2025-01-04 10:33:13'),
(14, '104.166.80.245', 'Los Angeles', 'US', 'United States', 'California', NULL, '34.0544', '-118.2441', 'Linux', 'Firefox', 'unknown', 'unknown', 'Unknown', 'America/Los_Angeles', '2025-01-04', '15:57:49', '2025-01-04 10:57:49', '2025-01-04 10:57:49'),
(15, '54.188.126.80', 'Portland', 'US', 'United States', 'Oregon', NULL, '45.5235', '-122.676', 'Mac OS X', 'Chrome', 'unknown', 'unknown', 'Unknown', 'America/Los_Angeles', '2025-01-04', '16:01:06', '2025-01-04 11:01:06', '2025-01-04 11:01:06'),
(16, '192.175.111.253', 'Montreal', 'CA', 'Canada', 'Quebec', NULL, '45.4681', '-73.5387', 'Windows 10', 'Chrome', 'unknown', 'unknown', 'Unknown', 'America/Toronto', '2025-01-04', '16:03:20', '2025-01-04 11:03:20', '2025-01-04 11:03:20'),
(17, '192.175.111.237', 'Montreal', 'CA', 'Canada', 'Quebec', NULL, '45.5019', '-73.5674', 'Windows 10', 'Chrome', 'unknown', 'unknown', 'Unknown', 'America/Toronto', '2025-01-04', '16:03:29', '2025-01-04 11:03:29', '2025-01-04 11:03:29'),
(18, '64.15.129.121', 'Montreal', 'CA', 'Canada', 'Quebec', NULL, '45.4681', '-73.5387', 'Windows 10', 'Chrome', 'unknown', 'unknown', 'Unknown', 'America/Toronto', '2025-01-04', '16:03:31', '2025-01-04 11:03:31', '2025-01-04 11:03:31'),
(19, '192.175.111.248', 'Montreal', 'CA', 'Canada', 'Quebec', NULL, '45.4681', '-73.5387', 'Windows 10', 'Chrome', 'unknown', 'unknown', 'Unknown', 'America/Toronto', '2025-01-04', '16:03:37', '2025-01-04 11:03:37', '2025-01-04 11:03:37'),
(20, '192.175.111.249', 'Montreal', 'CA', 'Canada', 'Quebec', NULL, '45.4681', '-73.5387', 'Windows 10', 'Chrome', 'unknown', 'unknown', 'Unknown', 'America/Toronto', '2025-01-04', '16:03:39', '2025-01-04 11:03:39', '2025-01-04 11:03:39'),
(21, '44.243.188.92', 'Portland', 'US', 'United States', 'Oregon', NULL, '45.5235', '-122.676', 'Windows 10', 'Chrome', 'unknown', 'unknown', 'Unknown', 'America/Los_Angeles', '2025-01-04', '16:16:50', '2025-01-04 11:16:50', '2025-01-04 11:16:50'),
(22, '52.42.6.165', 'Portland', 'US', 'United States', 'Oregon', NULL, '45.5235', '-122.676', 'Windows 10', 'Chrome', 'unknown', 'unknown', 'Unknown', 'America/Los_Angeles', '2025-01-04', '16:35:00', '2025-01-04 11:35:00', '2025-01-04 11:35:00'),
(23, '35.89.126.72', 'Portland', 'US', 'United States', 'Oregon', NULL, '45.5235', '-122.676', 'Windows 10', 'Chrome', 'unknown', 'unknown', 'Unknown', 'America/Los_Angeles', '2025-01-04', '18:19:00', '2025-01-04 13:19:00', '2025-01-04 13:19:00'),
(24, '54.202.24.187', 'Portland', 'US', 'United States', 'Oregon', NULL, '45.5235', '-122.676', 'Mac OS X', 'Chrome', 'unknown', 'unknown', 'Unknown', 'America/Los_Angeles', '2025-01-04', '18:39:01', '2025-01-04 13:39:01', '2025-01-04 13:39:01'),
(25, '34.211.233.18', 'Portland', 'US', 'United States', 'Oregon', NULL, '45.5235', '-122.676', 'Windows 10', 'Chrome', 'unknown', 'unknown', 'Unknown', 'America/Los_Angeles', '2025-01-04', '18:40:21', '2025-01-04 13:40:21', '2025-01-04 13:40:21'),
(26, '44.245.4.70', 'Portland', 'US', 'United States', 'Oregon', NULL, '45.5235', '-122.676', 'Windows 10', 'Chrome', 'unknown', 'unknown', 'Unknown', 'America/Los_Angeles', '2025-01-04', '18:42:57', '2025-01-04 13:42:57', '2025-01-04 13:42:57'),
(27, '167.94.138.193', 'Ann Arbor', 'US', 'United States', 'Michigan', NULL, '42.2809', '-83.7489', 'unknown', NULL, 'unknown', 'unknown', 'Unknown', 'America/Detroit', '2025-01-05', '01:20:23', '2025-01-04 20:20:23', '2025-01-04 20:20:23'),
(28, '167.94.138.180', 'Ann Arbor', 'US', 'United States', 'Michigan', NULL, '42.2809', '-83.7489', 'unknown', NULL, 'unknown', 'unknown', 'Unknown', 'America/Detroit', '2025-01-05', '01:49:08', '2025-01-04 20:49:08', '2025-01-04 20:49:08'),
(29, '167.94.138.205', 'Ann Arbor', 'US', 'United States', 'Michigan', NULL, '42.2809', '-83.7489', 'unknown', NULL, 'unknown', 'unknown', 'Unknown', 'America/Detroit', '2025-01-05', '02:09:36', '2025-01-04 21:09:36', '2025-01-04 21:09:36'),
(30, '104.164.173.33', 'Santa Clara', 'US', 'United States', 'California', NULL, '37.3541', '-121.9552', 'Linux', 'Chrome', 'unknown', 'unknown', 'Unknown', 'America/Los_Angeles', '2025-01-05', '03:00:15', '2025-01-04 22:00:15', '2025-01-04 22:00:15'),
(31, '107.172.166.73', 'Los Angeles', 'US', 'United States', 'California', NULL, '34.0544', '-118.2441', 'iPhone', 'Safari', 'unknown', 'unknown', 'Unknown', 'America/Los_Angeles', '2025-01-05', '03:01:13', '2025-01-04 22:01:13', '2025-01-04 22:01:13'),
(32, '176.223.104.195', 'Dallas', 'US', 'United States', 'Texas', NULL, '32.7724', '-96.8172', 'iPhone', 'Safari', 'unknown', 'unknown', 'Unknown', 'America/Chicago', '2025-01-05', '03:01:13', '2025-01-04 22:01:13', '2025-01-04 22:01:13'),
(33, '78.138.40.246', 'Los Angeles', 'US', 'United States', 'California', NULL, '34.0544', '-118.2441', 'iPhone', 'Safari', 'unknown', 'unknown', 'Unknown', 'America/Los_Angeles', '2025-01-05', '03:01:13', '2025-01-04 22:01:13', '2025-01-04 22:01:13'),
(34, '107.172.166.45', 'Los Angeles', 'US', 'United States', 'California', NULL, '34.0544', '-118.2441', 'iPhone', 'Safari', 'unknown', 'unknown', 'Unknown', 'America/Los_Angeles', '2025-01-05', '03:01:13', '2025-01-04 22:01:13', '2025-01-04 22:01:13'),
(35, '103.134.3.18', 'Narowal', 'PK', 'Pakistan', 'Punjab', NULL, '32.102', '74.873', 'Mac OS X', 'Chrome', 'unknown', 'unknown', 'Unknown', 'Asia/Karachi', '2025-01-05', '07:54:34', '2025-01-05 02:54:34', '2025-01-05 02:54:34'),
(36, '223.123.11.128', 'Kahna Nau', 'PK', 'Pakistan', 'Punjab', NULL, '31.3671', '74.369', 'Mac OS X', 'Chrome', 'unknown', 'https://cms.softlico.com/admin/3/topics', 'Unknown', 'Asia/Karachi', '2025-01-05', '08:20:08', '2025-01-05 03:20:08', '2025-01-05 03:20:08'),
(37, '223.123.23.162', 'Lahore', 'PK', 'Pakistan', 'Punjab', NULL, '31.5826', '74.3276', 'Mac OS X', 'Chrome', 'unknown', 'https://cms.softlico.com/admin/1/topics', 'Unknown', 'Asia/Karachi', '2025-01-05', '11:01:58', '2025-01-05 06:01:58', '2025-01-05 06:01:58'),
(38, '138.197.143.150', 'Toronto', 'CA', 'Canada', 'Ontario', NULL, '43.6547', '-79.3623', 'unknown', NULL, 'unknown', 'unknown', 'Unknown', 'America/Toronto', '2025-01-05', '12:24:41', '2025-01-05 07:24:41', '2025-01-05 07:24:41'),
(39, '174.138.19.131', 'Singapore', 'SG', 'Singapore', 'South West', NULL, '1.32123', '103.695', 'Android', 'Chrome', 'unknown', 'http://cms.softlico.com/wp-admin/setup-config.php?step=1', 'Unknown', 'Asia/Singapore', '2025-01-05', '13:41:13', '2025-01-05 08:41:13', '2025-01-05 08:41:13'),
(40, '104.166.80.115', 'Los Angeles', 'US', 'United States', 'California', NULL, '34.0544', '-118.2441', 'Linux', 'Firefox', 'unknown', 'unknown', 'Unknown', 'America/Los_Angeles', '2025-01-05', '15:05:53', '2025-01-05 10:05:53', '2025-01-05 10:05:53'),
(41, '104.166.80.147', 'Los Angeles', 'US', 'United States', 'California', NULL, '34.0544', '-118.2441', 'Linux', 'Firefox', 'unknown', 'unknown', 'Unknown', 'America/Los_Angeles', '2025-01-05', '15:34:25', '2025-01-05 10:34:25', '2025-01-05 10:34:25'),
(42, '44.245.201.183', 'Portland', 'US', 'United States', 'Oregon', NULL, '45.5235', '-122.676', 'Mac OS X', 'Chrome', 'unknown', 'unknown', 'Unknown', 'America/Los_Angeles', '2025-01-05', '15:36:11', '2025-01-05 10:36:11', '2025-01-05 10:36:11'),
(43, '34.218.80.196', 'Portland', 'US', 'United States', 'Oregon', NULL, '45.5235', '-122.676', 'Mac OS X', 'Chrome', 'unknown', 'unknown', 'Unknown', 'America/Los_Angeles', '2025-01-05', '15:36:13', '2025-01-05 10:36:13', '2025-01-05 10:36:13'),
(44, '104.164.173.62', 'Santa Clara', 'US', 'United States', 'California', NULL, '37.3541', '-121.9552', 'Mac OS X', 'Chrome', 'unknown', 'unknown', 'Unknown', 'America/Los_Angeles', '2025-01-05', '17:05:28', '2025-01-05 12:05:28', '2025-01-05 12:05:28'),
(45, '207.241.236.83', 'San Francisco', 'US', 'United States', 'California', NULL, '37.7823', '-122.472', 'unknown', NULL, 'unknown', 'unknown', 'Unknown', 'America/Los_Angeles', '2025-01-05', '17:18:53', '2025-01-05 12:18:53', '2025-01-05 12:18:53'),
(46, '223.123.6.216', 'Lahore', 'PK', 'Pakistan', 'Punjab', NULL, '31.5826', '74.3276', 'Mac OS X', 'Chrome', 'unknown', 'unknown', 'Unknown', 'Asia/Karachi', '2025-01-06', '12:06:48', '2025-01-06 07:06:48', '2025-01-06 07:06:48'),
(47, '103.134.3.18', 'Narowal', 'PK', 'Pakistan', 'Punjab', NULL, '32.102', '74.873', 'Mac OS X', 'Chrome', 'unknown', 'unknown', 'Unknown', 'Asia/Karachi', '2025-01-06', '12:29:45', '2025-01-06 07:29:45', '2025-01-06 07:29:45'),
(48, '209.38.39.20', 'Amsterdam', 'NL', 'The Netherlands', 'North Holland', NULL, '52.3759', '4.8975', 'unknown', NULL, 'unknown', 'unknown', 'Unknown', 'Europe/Amsterdam', '2025-01-06', '13:54:48', '2025-01-06 08:54:48', '2025-01-06 08:54:48'),
(49, '104.166.80.177', 'Los Angeles', 'US', 'United States', 'California', NULL, '34.0544', '-118.2441', 'Linux', 'Firefox', 'unknown', 'unknown', 'Unknown', 'America/Los_Angeles', '2025-01-06', '15:28:11', '2025-01-06 10:28:11', '2025-01-06 10:28:11'),
(50, '104.166.80.181', 'Los Angeles', 'US', 'United States', 'California', NULL, '34.0544', '-118.2441', 'Linux', 'Firefox', 'unknown', 'unknown', 'Unknown', 'America/Los_Angeles', '2025-01-06', '15:28:49', '2025-01-06 10:28:49', '2025-01-06 10:28:49'),
(51, '34.217.67.1', 'Portland', 'US', 'United States', 'Oregon', NULL, '45.5235', '-122.676', 'iPhone', 'Safari', 'unknown', 'unknown', 'Unknown', 'America/Los_Angeles', '2025-01-06', '16:29:13', '2025-01-06 11:29:13', '2025-01-06 11:29:13'),
(52, '18.236.169.245', 'Portland', 'US', 'United States', 'Oregon', NULL, '45.5235', '-122.676', 'iPhone', 'Safari', 'unknown', 'unknown', 'Unknown', 'America/Los_Angeles', '2025-01-06', '22:36:13', '2025-01-06 17:36:13', '2025-01-06 17:36:13'),
(53, '103.134.3.18', 'Narowal', 'PK', 'Pakistan', 'Punjab', NULL, '32.102', '74.873', 'Mac OS X', 'Chrome', 'unknown', 'unknown', 'Unknown', 'Asia/Karachi', '2025-01-07', '08:45:18', '2025-01-07 03:45:18', '2025-01-07 03:45:18'),
(54, '207.241.237.21', 'San Francisco', 'US', 'United States', 'California', NULL, '37.7823', '-122.472', 'unknown', NULL, 'unknown', 'unknown', 'Unknown', 'America/Los_Angeles', '2025-01-07', '13:10:26', '2025-01-07 08:10:26', '2025-01-07 08:10:26'),
(55, '209.38.239.58', 'Frankfurt am Main', 'DE', 'Germany', 'Hesse', NULL, '50.1187', '8.6842', 'unknown', NULL, 'unknown', 'unknown', 'Unknown', 'Europe/Berlin', '2025-01-07', '14:00:30', '2025-01-07 09:00:30', '2025-01-07 09:00:30'),
(56, '34.211.122.156', 'Portland', 'US', 'United States', 'Oregon', NULL, '45.5235', '-122.676', 'Windows 10', 'Chrome', 'unknown', 'unknown', 'Unknown', 'America/Los_Angeles', '2025-01-07', '15:29:14', '2025-01-07 10:29:14', '2025-01-07 10:29:14'),
(57, '103.150.37.76', 'Taichung', 'TW', 'Taiwan', 'Taichung City', NULL, '24.144', '120.6844', 'Windows 10', 'Chrome', 'unknown', 'unknown', 'Unknown', 'Asia/Taipei', '2025-01-07', '17:21:15', '2025-01-07 12:21:15', '2025-01-07 12:21:15'),
(58, '103.150.37.76', 'Taichung', 'TW', 'Taiwan', 'Taichung City', NULL, '24.144', '120.6844', 'Windows 10', 'Chrome', 'unknown', 'unknown', 'Unknown', 'Asia/Taipei', '2025-01-07', '17:21:15', '2025-01-07 12:21:15', '2025-01-07 12:21:15'),
(59, '52.36.173.237', 'Portland', 'US', 'United States', 'Oregon', NULL, '45.5235', '-122.676', 'Windows 10', 'Chrome', 'unknown', 'unknown', 'Unknown', 'America/Los_Angeles', '2025-01-07', '17:49:55', '2025-01-07 12:49:55', '2025-01-07 12:49:55'),
(60, '103.134.3.18', 'Narowal', 'PK', 'Pakistan', 'Punjab', NULL, '32.102', '74.873', 'Mac OS X', 'Chrome', 'unknown', 'unknown', 'Unknown', 'Asia/Karachi', '2025-01-08', '07:09:15', '2025-01-08 02:09:15', '2025-01-08 02:09:15'),
(61, '162.142.125.34', 'Ann Arbor', 'US', 'United States', 'Michigan', NULL, '42.2809', '-83.7489', 'unknown', NULL, 'unknown', 'unknown', 'Unknown', 'America/Detroit', '2025-01-08', '11:48:54', '2025-01-08 06:48:54', '2025-01-08 06:48:54'),
(62, '159.65.24.209', 'Slough', 'GB', 'United Kingdom', 'England', NULL, '51.5368', '-0.6718', 'unknown', NULL, 'unknown', 'unknown', 'Unknown', 'Europe/London', '2025-01-08', '13:08:50', '2025-01-08 08:08:50', '2025-01-08 08:08:50'),
(63, '104.166.80.111', 'Los Angeles', 'US', 'United States', 'California', NULL, '34.0544', '-118.2441', 'Linux', 'Firefox', 'unknown', 'unknown', 'Unknown', 'America/Los_Angeles', '2025-01-08', '15:21:58', '2025-01-08 10:21:58', '2025-01-08 10:21:58'),
(64, '104.166.80.62', 'Los Angeles', 'US', 'United States', 'California', NULL, '34.0544', '-118.2441', 'Linux', 'Firefox', 'unknown', 'unknown', 'Unknown', 'America/Los_Angeles', '2025-01-08', '15:23:26', '2025-01-08 10:23:26', '2025-01-08 10:23:26'),
(65, '18.246.35.134', 'Portland', 'US', 'United States', 'Oregon', NULL, '45.5235', '-122.676', 'Android', 'Chrome', 'unknown', 'unknown', 'Unknown', 'America/Los_Angeles', '2025-01-08', '18:57:50', '2025-01-08 13:57:50', '2025-01-08 13:57:50'),
(66, '34.221.80.249', 'Portland', 'US', 'United States', 'Oregon', NULL, '45.5235', '-122.676', 'Android', 'Chrome', 'unknown', 'unknown', 'Unknown', 'America/Los_Angeles', '2025-01-08', '19:10:42', '2025-01-08 14:10:42', '2025-01-08 14:10:42'),
(67, '209.38.46.8', 'Amsterdam', 'NL', 'The Netherlands', 'North Holland', NULL, '52.3759', '4.8975', 'unknown', NULL, 'unknown', 'unknown', 'Unknown', 'Europe/Amsterdam', '2025-01-09', '14:34:51', '2025-01-09 09:34:51', '2025-01-09 09:34:51'),
(68, '35.163.128.89', 'Portland', 'US', 'United States', 'Oregon', NULL, '45.5235', '-122.676', 'Windows 10', 'Chrome', 'unknown', 'unknown', 'Unknown', 'America/Los_Angeles', '2025-01-09', '16:41:56', '2025-01-09 11:41:56', '2025-01-09 11:41:56'),
(69, '167.94.138.120', 'Ann Arbor', 'US', 'United States', 'Michigan', NULL, '42.2809', '-83.7489', 'unknown', NULL, 'unknown', 'unknown', 'Unknown', 'America/Detroit', '2025-01-09', '16:56:25', '2025-01-09 11:56:25', '2025-01-09 11:56:25'),
(70, '162.142.125.116', 'Ann Arbor', 'US', 'United States', 'Michigan', NULL, '42.2809', '-83.7489', 'unknown', NULL, 'unknown', 'unknown', 'Unknown', 'America/Detroit', '2025-01-09', '16:59:14', '2025-01-09 11:59:14', '2025-01-09 11:59:14'),
(71, '54.244.142.228', 'Portland', 'US', 'United States', 'Oregon', NULL, '45.5235', '-122.676', 'Windows 10', 'Chrome', 'unknown', 'unknown', 'Unknown', 'America/Los_Angeles', '2025-01-09', '17:12:38', '2025-01-09 12:12:38', '2025-01-09 12:12:38'),
(72, '167.94.138.168', 'Ann Arbor', 'US', 'United States', 'Michigan', NULL, '42.2809', '-83.7489', 'unknown', NULL, 'unknown', 'unknown', 'Unknown', 'America/Detroit', '2025-01-09', '17:45:25', '2025-01-09 12:45:25', '2025-01-09 12:45:25'),
(73, '64.227.115.227', 'Frankfurt am Main', 'DE', 'Germany', 'Hesse', NULL, '50.1187', '8.6842', 'unknown', NULL, 'unknown', 'unknown', 'Unknown', 'Europe/Berlin', '2025-01-10', '02:49:45', '2025-01-09 21:49:45', '2025-01-09 21:49:45'),
(74, '167.94.138.32', 'Ann Arbor', 'US', 'United States', 'Michigan', NULL, '42.2809', '-83.7489', 'unknown', NULL, 'unknown', 'unknown', 'Unknown', 'America/Detroit', '2025-01-10', '06:21:26', '2025-01-10 01:21:26', '2025-01-10 01:21:26'),
(75, '34.222.125.142', 'Portland', 'US', 'United States', 'Oregon', NULL, '45.5235', '-122.676', 'Android', 'Chrome', 'unknown', 'unknown', 'Unknown', 'America/Los_Angeles', '2025-01-10', '12:34:07', '2025-01-10 07:34:07', '2025-01-10 07:34:07'),
(76, '35.90.158.179', 'Portland', 'US', 'United States', 'Oregon', NULL, '45.5235', '-122.676', 'Android', 'Chrome', 'unknown', 'unknown', 'Unknown', 'America/Los_Angeles', '2025-01-10', '12:37:41', '2025-01-10 07:37:41', '2025-01-10 07:37:41'),
(77, '120.229.184.45', 'Guangzhou', 'CN', 'China', 'Guangdong', NULL, '23.1317', '113.266', 'Mac OS X', 'Chrome', 'unknown', 'unknown', 'Unknown', 'Asia/Shanghai', '2025-01-11', '07:50:13', '2025-01-11 02:50:13', '2025-01-11 02:50:13'),
(78, '27.47.107.250', 'Guangzhou', 'CN', 'China', 'Guangdong', NULL, '23.1291', '113.264', 'Mac OS X', 'Chrome', 'unknown', 'unknown', 'Unknown', 'Asia/Shanghai', '2025-01-11', '07:51:38', '2025-01-11 02:51:38', '2025-01-11 02:51:38'),
(79, '54.91.117.144', 'Ashburn', 'US', 'United States', 'Virginia', NULL, '39.0438', '-77.4874', 'Windows 10', 'Chrome', 'unknown', 'unknown', 'Unknown', 'America/New_York', '2025-01-11', '09:31:44', '2025-01-11 04:31:44', '2025-01-11 04:31:44'),
(80, '54.185.5.155', 'Portland', 'US', 'United States', 'Oregon', NULL, '45.5235', '-122.676', 'Windows 10', 'Chrome', 'unknown', 'unknown', 'Unknown', 'America/Los_Angeles', '2025-01-11', '12:55:48', '2025-01-11 07:55:48', '2025-01-11 07:55:48'),
(81, '44.245.236.41', 'Portland', 'US', 'United States', 'Oregon', NULL, '45.5235', '-122.676', 'Windows 10', 'Chrome', 'unknown', 'unknown', 'Unknown', 'America/Los_Angeles', '2025-01-11', '14:28:08', '2025-01-11 09:28:08', '2025-01-11 09:28:08'),
(82, '103.150.37.78', 'Taichung', 'TW', 'Taiwan', 'Taichung City', NULL, '24.144', '120.6844', 'Windows 10', 'Chrome', 'unknown', 'unknown', 'Unknown', 'Asia/Taipei', '2025-01-11', '15:03:10', '2025-01-11 10:03:10', '2025-01-11 10:03:10'),
(83, '103.150.37.78', 'Taichung', 'TW', 'Taiwan', 'Taichung City', NULL, '24.144', '120.6844', 'Windows 10', 'Chrome', 'unknown', 'unknown', 'Unknown', 'Asia/Taipei', '2025-01-11', '15:03:10', '2025-01-11 10:03:10', '2025-01-11 10:03:10'),
(84, '104.166.80.96', 'Los Angeles', 'US', 'United States', 'California', NULL, '34.0544', '-118.2441', 'Linux', 'Firefox', 'unknown', 'unknown', 'Unknown', 'America/Los_Angeles', '2025-01-11', '15:22:28', '2025-01-11 10:22:28', '2025-01-11 10:22:28'),
(85, '104.166.80.237', 'Los Angeles', 'US', 'United States', 'California', NULL, '34.0544', '-118.2441', 'Linux', 'Firefox', 'unknown', 'unknown', 'Unknown', 'America/Los_Angeles', '2025-01-11', '15:22:37', '2025-01-11 10:22:37', '2025-01-11 10:22:37'),
(86, '54.191.234.250', 'Portland', 'US', 'United States', 'Oregon', NULL, '45.5235', '-122.676', 'iPhone', 'Safari', 'unknown', 'unknown', 'Unknown', 'America/Los_Angeles', '2025-01-12', '15:24:14', '2025-01-12 10:24:14', '2025-01-12 10:24:14'),
(87, '52.42.43.206', 'Portland', 'US', 'United States', 'Oregon', NULL, '45.5235', '-122.676', 'iPhone', 'Safari', 'unknown', 'unknown', 'Unknown', 'America/Los_Angeles', '2025-01-12', '15:40:57', '2025-01-12 10:40:57', '2025-01-12 10:40:57'),
(88, '54.91.117.144', 'Ashburn', 'US', 'United States', 'Virginia', NULL, '39.0438', '-77.4874', 'Windows 10', 'Chrome', 'unknown', 'unknown', 'Unknown', 'America/New_York', '2025-01-13', '07:14:18', '2025-01-13 02:14:18', '2025-01-13 02:14:18'),
(89, '223.123.6.96', 'Lahore', 'PK', 'Pakistan', 'Punjab', NULL, '31.5826', '74.3276', 'Mac OS X', 'Chrome', 'unknown', 'unknown', 'Unknown', 'Asia/Karachi', '2025-01-13', '07:21:34', '2025-01-13 02:21:34', '2025-01-13 02:21:34'),
(90, '103.134.3.18', 'Narowal', 'PK', 'Pakistan', 'Punjab', NULL, '32.102', '74.873', 'Mac OS X', 'Chrome', 'unknown', 'https://cms.softlico.com/admin', 'Unknown', 'Asia/Karachi', '2025-01-13', '07:51:10', '2025-01-13 02:51:10', '2025-01-13 02:51:10'),
(91, '223.123.8.47', 'Burewala', 'PK', 'Pakistan', 'Punjab', NULL, '30.1667', '72.65', 'unknown', NULL, 'unknown', 'unknown', 'Unknown', 'Asia/Karachi', '2025-01-13', '08:41:18', '2025-01-13 03:41:18', '2025-01-13 03:41:18'),
(92, '202.56.3.34', 'Phnom Penh', 'KH', 'Cambodia', 'Phnom Penh', NULL, '11.5583', '104.9121', 'iPhone', 'Safari', 'unknown', 'unknown', 'Unknown', 'Asia/Phnom_Penh', '2025-01-13', '09:33:40', '2025-01-13 04:33:40', '2025-01-13 04:33:40');

-- --------------------------------------------------------

--
-- Table structure for table `smartend_attach_files`
--

CREATE TABLE `smartend_attach_files` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `topic_id` bigint(20) UNSIGNED NOT NULL,
  `file` varchar(191) DEFAULT NULL,
  `title_en` varchar(191) DEFAULT NULL,
  `row_no` int(11) NOT NULL DEFAULT 0,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `title_km` varchar(191) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `smartend_banners`
--

CREATE TABLE `smartend_banners` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `section_id` bigint(20) UNSIGNED NOT NULL,
  `title_en` varchar(191) DEFAULT NULL,
  `details_en` text DEFAULT NULL,
  `code` text DEFAULT NULL,
  `file_en` varchar(191) DEFAULT NULL,
  `video_type` tinyint(4) DEFAULT NULL,
  `youtube_link` varchar(191) DEFAULT NULL,
  `link_url` varchar(191) DEFAULT NULL,
  `link_ar` varchar(191) DEFAULT NULL,
  `link_en` varchar(191) DEFAULT NULL,
  `link_ch` varchar(191) DEFAULT NULL,
  `link_hi` varchar(191) DEFAULT NULL,
  `link_es` varchar(191) DEFAULT NULL,
  `link_ru` varchar(191) DEFAULT NULL,
  `link_pt` varchar(191) DEFAULT NULL,
  `link_fr` varchar(191) DEFAULT NULL,
  `link_de` varchar(191) DEFAULT NULL,
  `link_th` varchar(191) DEFAULT NULL,
  `link_br` varchar(191) DEFAULT NULL,
  `icon` varchar(191) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `visits` int(11) NOT NULL DEFAULT 0,
  `row_no` int(11) NOT NULL DEFAULT 0,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `title_km` varchar(191) DEFAULT NULL,
  `details_km` text DEFAULT NULL,
  `file_km` varchar(191) DEFAULT NULL,
  `link_km` varchar(191) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `smartend_banners`
--

INSERT INTO `smartend_banners` (`id`, `section_id`, `title_en`, `details_en`, `code`, `file_en`, `video_type`, `youtube_link`, `link_url`, `link_ar`, `link_en`, `link_ch`, `link_hi`, `link_es`, `link_ru`, `link_pt`, `link_fr`, `link_de`, `link_th`, `link_br`, `icon`, `status`, `visits`, `row_no`, `created_by`, `updated_by`, `created_at`, `updated_at`, `title_km`, `details_km`, `file_km`, `link_km`) VALUES
(1, 1, 'Banner #1', 'It is a long established fact that a reader will be distracted by the readable content of a page. It is a long established fact that a reader will be distracted.', NULL, 'noimg.png', NULL, NULL, '#', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 1, 1, NULL, '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Banner #1', 'It is a long established fact that a reader will be distracted by the readable content of a page. It is a long established fact that a reader will be distracted.', NULL, NULL),
(2, 1, 'Banner #2', 'It is a long established fact that a reader will be distracted by the readable content of a page. It is a long established fact that a reader will be distracted.', NULL, 'noimg.png', NULL, NULL, '#', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, 2, 1, NULL, '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Banner #2', 'It is a long established fact that a reader will be distracted by the readable content of a page. It is a long established fact that a reader will be distracted.', NULL, NULL),
(3, 2, 'Responsive Design', 'It is a long established fact that a reader will be distracted by the readable content of a page.', NULL, '', NULL, NULL, '#', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'fa-object-group', 0, 0, 1, 1, NULL, '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Responsive Design', 'It is a long established fact that a reader will be distracted by the readable content of a page.', NULL, NULL),
(4, 2, 'HTML5 & CSS3', 'It is a long established fact that a reader will be distracted by the readable content of a page.', NULL, '', NULL, NULL, '#', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'fa-html5', 0, 0, 2, 1, NULL, '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'HTML5 & CSS3', 'It is a long established fact that a reader will be distracted by the readable content of a page.', NULL, NULL),
(5, 2, 'Bootstrap Used', 'It is a long established fact that a reader will be distracted by the readable content of a page.', NULL, '', NULL, NULL, '#', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'fa-code', 0, 0, 3, 1, NULL, '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Bootstrap Used', 'It is a long established fact that a reader will be distracted by the readable content of a page.', NULL, NULL),
(6, 2, 'Classic Design', 'It is a long established fact that a reader will be distracted by the readable content of a page.', NULL, '', NULL, NULL, '#', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'fa-laptop', 0, 0, 4, 1, NULL, '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Classic Design', 'It is a long established fact that a reader will be distracted by the readable content of a page.', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `smartend_comments`
--

CREATE TABLE `smartend_comments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `topic_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) DEFAULT NULL,
  `email` varchar(191) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `row_no` int(11) NOT NULL DEFAULT 0,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `smartend_contacts_groups`
--

CREATE TABLE `smartend_contacts_groups` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `smartend_contacts_groups`
--

INSERT INTO `smartend_contacts_groups` (`id`, `name`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, 'Newsletter Emails', 1, NULL, '2025-01-04 09:15:30', '2025-01-04 09:15:30');

-- --------------------------------------------------------

--
-- Table structure for table `smartend_countries`
--

CREATE TABLE `smartend_countries` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `code` varchar(191) DEFAULT NULL,
  `title_en` varchar(191) DEFAULT NULL,
  `tel` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `title_km` varchar(191) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `smartend_countries`
--

INSERT INTO `smartend_countries` (`id`, `code`, `title_en`, `tel`, `created_at`, `updated_at`, `title_km`) VALUES
(1, 'AL', 'Albania', '355', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Albania'),
(2, 'DZ', 'Algeria', '213', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Algeria'),
(3, 'AS', 'American Samoa', '1-684', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'American Samoa'),
(4, 'AD', 'Andorra', '376', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Andorra'),
(5, 'AO', 'Angola', '244', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Angola'),
(6, 'AI', 'Anguilla', '1-264', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Anguilla'),
(7, 'AR', 'Argentina', '54', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Argentina'),
(8, 'AM', 'Armenia', '374', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Armenia'),
(9, 'AW', 'Aruba', '297', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Aruba'),
(10, 'AU', 'Australia', '61', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Australia'),
(11, 'AT', 'Austria', '43', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Austria'),
(12, 'AZ', 'Azerbaijan', '994', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Azerbaijan'),
(13, 'BS', 'Bahamas', '1-242', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Bahamas'),
(14, 'BH', 'Bahrain', '973', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Bahrain'),
(15, 'BD', 'Bangladesh', '880', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Bangladesh'),
(16, 'BB', 'Barbados', '1-246', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Barbados'),
(17, 'BY', 'Belarus', '375', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Belarus'),
(18, 'BE', 'Belgium', '32', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Belgium'),
(19, 'BZ', 'Belize', '501', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Belize'),
(20, 'BJ', 'Benin', '229', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Benin'),
(21, 'BM', 'Bermuda', '1-441', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Bermuda'),
(22, 'BT', 'Bhutan', '975', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Bhutan'),
(23, 'BO', 'Bolivia', '591', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Bolivia'),
(24, 'BA', 'Bosnia and Herzegovina', '387', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Bosnia and Herzegovina'),
(25, 'BW', 'Botswana', '267', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Botswana'),
(26, 'BR', 'Brazil', '55', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Brazil'),
(27, 'VG', 'British Virgin Islands', '1-284', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'British Virgin Islands'),
(28, 'IO', 'British Indian Ocean Territory', '246', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'British Indian Ocean Territory'),
(29, 'BN', 'Brunei Darussalam', '673', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Brunei Darussalam'),
(30, 'BG', 'Bulgaria', '359', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Bulgaria'),
(31, 'BF', 'Burkina Faso', '226', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Burkina Faso'),
(32, 'BI', 'Burundi', '257', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Burundi'),
(33, 'KH', 'Cambodia', '855', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Cambodia'),
(34, 'CM', 'Cameroon', '237', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Cameroon'),
(35, 'CA', 'Canada', '1', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Canada'),
(36, 'CV', 'Cape Verde', '238', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Cape Verde'),
(37, 'KY', 'Cayman Islands', '1-345', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Cayman Islands'),
(38, 'CF', 'Central African Republic', '236', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Central African Republic'),
(39, 'TD', 'Chad', '235', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Chad'),
(40, 'CL', 'Chile', '56', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Chile'),
(41, 'CN', 'China', '86', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'China'),
(42, 'HK', 'Hong Kong', '852', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Hong Kong'),
(43, 'MO', 'Macao', '853', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Macao'),
(44, 'CX', 'Christmas Island', '61', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Christmas Island'),
(45, 'CC', 'Cocos (Keeling) Islands', '61', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Cocos (Keeling) Islands'),
(46, 'CO', 'Colombia', '57', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Colombia'),
(47, 'KM', 'Comoros', '269', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Comoros'),
(48, 'CK', 'Cook Islands', '682', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Cook Islands'),
(49, 'CR', 'Costa Rica', '506', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Costa Rica'),
(50, 'HR', 'Croatia', '385', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Croatia'),
(51, 'CU', 'Cuba', '53', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Cuba'),
(52, 'CY', 'Cyprus', '357', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Cyprus'),
(53, 'CZ', 'Czech Republic', '420', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Czech Republic'),
(54, 'DK', 'Denmark', '45', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Denmark'),
(55, 'DJ', 'Djibouti', '253', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Djibouti'),
(56, 'DM', 'Dominica', '1-767', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Dominica'),
(57, 'DO', 'Dominican Republic', '1-809', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Dominican Republic'),
(58, 'EC', 'Ecuador', '593', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Ecuador'),
(59, 'EG', 'Egypt', '20', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Egypt'),
(60, 'SV', 'El Salvador', '503', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'El Salvador'),
(61, 'GQ', 'Equatorial Guinea', '240', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Equatorial Guinea'),
(62, 'ER', 'Eritrea', '291', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Eritrea'),
(63, 'EE', 'Estonia', '372', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Estonia'),
(64, 'ET', 'Ethiopia', '251', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Ethiopia'),
(65, 'FO', 'Faroe Islands', '298', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Faroe Islands'),
(66, 'FJ', 'Fiji', '679', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Fiji'),
(67, 'FI', 'Finland', '358', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Finland'),
(68, 'FR', 'France', '33', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'France'),
(69, 'GF', 'French Guiana', '689', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'French Guiana'),
(70, 'GA', 'Gabon', '241', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Gabon'),
(71, 'GM', 'Gambia', '220', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Gambia'),
(72, 'GE', 'Georgia', '995', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Georgia'),
(73, 'DE', 'Germany', '49', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Germany'),
(74, 'GH', 'Ghana', '233', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Ghana'),
(75, 'GI', 'Gibraltar', '350', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Gibraltar'),
(76, 'GR', 'Greece', '30', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Greece'),
(77, 'GL', 'Greenland', '299', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Greenland'),
(78, 'GD', 'Grenada', '1-473', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Grenada'),
(79, 'GU', 'Guam', '1-671', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Guam'),
(80, 'GT', 'Guatemala', '502', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Guatemala'),
(81, 'GN', 'Guinea', '224', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Guinea'),
(82, 'GW', 'Guinea-Bissau', '245', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Guinea-Bissau'),
(83, 'GY', 'Guyana', '592', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Guyana'),
(84, 'HT', 'Haiti', '509', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Haiti'),
(85, 'HN', 'Honduras', '504', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Honduras'),
(86, 'HU', 'Hungary', '36', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Hungary'),
(87, 'IS', 'Iceland', '354', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Iceland'),
(88, 'IN', 'India', '91', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'India'),
(89, 'ID', 'Indonesia', '62', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Indonesia'),
(90, 'IR', 'Iran, Islamic Republic of', '98', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Iran, Islamic Republic of'),
(91, 'IQ', 'Iraq', '964', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Iraq'),
(92, 'IE', 'Ireland', '353', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Ireland'),
(93, 'IM', 'Isle of Man', '44-1624', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Isle of Man'),
(94, 'IL', 'Israel', '972', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Israel'),
(95, 'IT', 'Italy', '39', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Italy'),
(96, 'JM', 'Jamaica', '1-876', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Jamaica'),
(97, 'JP', 'Japan', '81', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Japan'),
(98, 'JE', 'Jersey', '44-1534', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Jersey'),
(99, 'JO', 'Jordan', '962', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Jordan'),
(100, 'KZ', 'Kazakhstan', '7', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Kazakhstan'),
(101, 'KE', 'Kenya', '254', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Kenya'),
(102, 'KI', 'Kiribati', '686', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Kiribati'),
(103, 'KW', 'Kuwait', '965', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Kuwait'),
(104, 'KG', 'Kyrgyzstan', '996', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Kyrgyzstan'),
(105, 'LV', 'Latvia', '371', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Latvia'),
(106, 'LB', 'Lebanon', '961', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Lebanon'),
(107, 'LS', 'Lesotho', '266', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Lesotho'),
(108, 'LR', 'Liberia', '231', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Liberia'),
(109, 'LY', 'Libya', '218', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Libya'),
(110, 'LI', 'Liechtenstein', '423', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Liechtenstein'),
(111, 'LT', 'Lithuania', '370', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Lithuania'),
(112, 'LU', 'Luxembourg', '352', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Luxembourg'),
(113, 'MK', 'Macedonia', '389', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Macedonia'),
(114, 'MG', 'Madagascar', '261', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Madagascar'),
(115, 'MW', 'Malawi', '265', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Malawi'),
(116, 'MY', 'Malaysia', '60', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Malaysia'),
(117, 'MV', 'Maldives', '960', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Maldives'),
(118, 'ML', 'Mali', '223', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Mali'),
(119, 'MT', 'Malta', '356', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Malta'),
(120, 'MH', 'Marshall Islands', '692', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Marshall Islands'),
(121, 'MR', 'Mauritania', '222', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Mauritania'),
(122, 'MU', 'Mauritius', '230', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Mauritius'),
(123, 'YT', 'Mayotte', '262', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Mayotte'),
(124, 'MX', 'Mexico', '52', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Mexico'),
(125, 'FM', 'Micronesia', '691', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Micronesia'),
(126, 'MD', 'Moldova', '373', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Moldova'),
(127, 'MC', 'Monaco', '377', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Monaco'),
(128, 'MN', 'Mongolia', '976', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Mongolia'),
(129, 'ME', 'Montenegro', '382', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Montenegro'),
(130, 'MS', 'Montserrat', '1-664', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Montserrat'),
(131, 'MA', 'Morocco', '212', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Morocco'),
(132, 'MZ', 'Mozambique', '258', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Mozambique'),
(133, 'MM', 'Myanmar', '95', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Myanmar'),
(134, 'NA', 'Namibia', '264', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Namibia'),
(135, 'NR', 'Nauru', '674', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Nauru'),
(136, 'NP', 'Nepal', '977', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Nepal'),
(137, 'NL', 'Netherlands', '31', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Netherlands'),
(138, 'AN', 'Netherlands Antilles', '599', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Netherlands Antilles'),
(139, 'NC', 'New Caledonia', '687', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'New Caledonia'),
(140, 'NZ', 'New Zealand', '64', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'New Zealand'),
(141, 'NI', 'Nicaragua', '505', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Nicaragua'),
(142, 'NE', 'Niger', '227', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Niger'),
(143, 'NG', 'Nigeria', '234', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Nigeria'),
(144, 'NU', 'Niue', '683', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Niue'),
(145, 'NO', 'Norway', '47', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Norway'),
(146, 'OM', 'Oman', '968', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Oman'),
(147, 'PK', 'Pakistan', '92', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Pakistan'),
(148, 'PW', 'Palau', '680', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Palau'),
(149, 'PS', 'Palestinian', '972', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Palestinian'),
(150, 'PA', 'Panama', '507', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Panama'),
(151, 'PY', 'Paraguay', '595', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Paraguay'),
(152, 'PE', 'Peru', '51', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Peru'),
(153, 'PH', 'Philippines', '63', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Philippines'),
(154, 'PN', 'Pitcairn', '870', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Pitcairn'),
(155, 'PL', 'Poland', '48', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Poland'),
(156, 'PT', 'Portugal', '351', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Portugal'),
(157, 'PR', 'Puerto Rico', '1-787', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Puerto Rico'),
(158, 'QA', 'Qatar', '974', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Qatar'),
(159, 'RO', 'Romania', '40', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Romania'),
(160, 'RU', 'Russian Federation', '7', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Russian Federation'),
(161, 'RW', 'Rwanda', '250', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Rwanda'),
(162, 'SH', 'Saint Helena', '290', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Saint Helena'),
(163, 'KN', 'Saint Kitts and Nevis', '1-869', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Saint Kitts and Nevis'),
(164, 'LC', 'Saint Lucia', '1-758', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Saint Lucia'),
(165, 'PM', 'Saint Pierre and Miquelon', '508', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Saint Pierre and Miquelon'),
(166, 'VC', 'Saint Vincent and Grenadines', '1-784', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Saint Vincent and Grenadines'),
(167, 'WS', 'Samoa', '685', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Samoa'),
(168, 'SM', 'San Marino', '378', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'San Marino'),
(169, 'ST', 'Sao Tome and Principe', '239', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Sao Tome and Principe'),
(170, 'SA', 'Saudi Arabia', '966', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Saudi Arabia'),
(171, 'SN', 'Senegal', '221', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Senegal'),
(172, 'RS', 'Serbia', '381', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Serbia'),
(173, 'SC', 'Seychelles', '248', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Seychelles'),
(174, 'SL', 'Sierra Leone', '232', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Sierra Leone'),
(175, 'SG', 'Singapore', '65', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Singapore'),
(176, 'SK', 'Slovakia', '421', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Slovakia'),
(177, 'SI', 'Slovenia', '386', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Slovenia'),
(178, 'SB', 'Solomon Islands', '677', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Solomon Islands'),
(179, 'SO', 'Somalia', '252', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Somalia'),
(180, 'ZA', 'South Africa', '27', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'South Africa'),
(181, 'ES', 'Spain', '34', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Spain'),
(182, 'LK', 'Sri Lanka', '94', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Sri Lanka'),
(183, 'SD', 'Sudan', '249', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Sudan'),
(184, 'SR', 'Suriname', '597', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Suriname'),
(185, 'SJ', 'Svalbard and Jan Mayen Islands', '47', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Svalbard and Jan Mayen Islands'),
(186, 'SZ', 'Swaziland', '268', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Swaziland'),
(187, 'SE', 'Sweden', '46', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Sweden'),
(188, 'CH', 'Switzerland', '41', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Switzerland'),
(189, 'SY', 'Syrian Arab Republic', '963', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Syrian Arab Republic'),
(190, 'TW', 'Taiwan, Republic of China', '886', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Taiwan, Republic of China'),
(191, 'TJ', 'Tajikistan', '992', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Tajikistan'),
(192, 'TZ', 'Tanzania', '255', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Tanzania'),
(193, 'TH', 'Thailand', '66', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Thailand'),
(194, 'TG', 'Togo', '228', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Togo'),
(195, 'TK', 'Tokelau', '690', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Tokelau'),
(196, 'TO', 'Tonga', '676', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Tonga'),
(197, 'TT', 'Trinidad and Tobago', '1-868', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Trinidad and Tobago'),
(198, 'TN', 'Tunisia', '216', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Tunisia'),
(199, 'TR', 'Turkey', '90', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Turkey'),
(200, 'TM', 'Turkmenistan', '993', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Turkmenistan'),
(201, 'TC', 'Turks and Caicos Islands', '1-649', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Turks and Caicos Islands'),
(202, 'TV', 'Tuvalu', '688', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Tuvalu'),
(203, 'UG', 'Uganda', '256', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Uganda'),
(204, 'UA', 'Ukraine', '380', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Ukraine'),
(205, 'AE', 'United Arab Emirates', '971', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'United Arab Emirates'),
(206, 'GB', 'United Kingdom', '44', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'United Kingdom'),
(207, 'US', 'United States of America', '1', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'United States of America'),
(208, 'UY', 'Uruguay', '598', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Uruguay'),
(209, 'UZ', 'Uzbekistan', '998', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Uzbekistan'),
(210, 'VU', 'Vanuatu', '678', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Vanuatu'),
(211, 'VE', 'Venezuela', '58', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Venezuela'),
(212, 'VN', 'Viet Nam', '84', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Viet Nam'),
(213, 'WF', 'Wallis and Futuna Islands', '681', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Wallis and Futuna Islands'),
(214, 'YE', 'Yemen', '967', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Yemen'),
(215, 'ZM', 'Zambia', '260', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Zambia'),
(216, 'ZW', 'Zimbabwe', '263', '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Zimbabwe');

-- --------------------------------------------------------

--
-- Table structure for table `smartend_events`
--

CREATE TABLE `smartend_events` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `type` tinyint(4) NOT NULL DEFAULT 0,
  `title` varchar(191) DEFAULT NULL,
  `details` text DEFAULT NULL,
  `start_date` datetime DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  `color` varchar(191) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `smartend_failed_jobs`
--

CREATE TABLE `smartend_failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(191) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `smartend_languages`
--

CREATE TABLE `smartend_languages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) DEFAULT NULL,
  `code` varchar(191) DEFAULT NULL,
  `direction` varchar(191) DEFAULT NULL,
  `left` varchar(191) DEFAULT NULL,
  `right` varchar(191) DEFAULT NULL,
  `icon` varchar(191) DEFAULT NULL,
  `box_status` tinyint(4) DEFAULT 1,
  `status` tinyint(4) DEFAULT 1,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `smartend_languages`
--

INSERT INTO `smartend_languages` (`id`, `title`, `code`, `direction`, `left`, `right`, `icon`, `box_status`, `status`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, 'English', 'en', 'ltr', 'left', 'right', 'us', 1, 1, 1, NULL, '2025-01-04 09:15:30', '2025-01-04 09:15:30'),
(12, 'Khmer', 'km', 'ltr', 'left', 'right', 'kh', 1, 1, 1, NULL, '2025-01-04 09:21:09', '2025-01-04 09:21:09');

-- --------------------------------------------------------

--
-- Table structure for table `smartend_maps`
--

CREATE TABLE `smartend_maps` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `topic_id` bigint(20) UNSIGNED NOT NULL,
  `longitude` varchar(191) DEFAULT NULL,
  `latitude` varchar(191) DEFAULT NULL,
  `title_en` varchar(191) DEFAULT NULL,
  `details_en` text DEFAULT NULL,
  `icon` tinyint(4) NOT NULL DEFAULT 0,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `row_no` int(11) NOT NULL DEFAULT 0,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `title_km` varchar(191) DEFAULT NULL,
  `details_km` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `smartend_menus`
--

CREATE TABLE `smartend_menus` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `row_no` int(11) NOT NULL DEFAULT 0,
  `father_id` int(11) NOT NULL DEFAULT 0,
  `title_en` varchar(191) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `type` tinyint(4) NOT NULL DEFAULT 0,
  `cat_id` int(11) DEFAULT NULL,
  `link` varchar(191) DEFAULT NULL,
  `link_en` varchar(191) DEFAULT NULL,
  `icon` varchar(191) DEFAULT NULL,
  `target` tinyint(4) NOT NULL DEFAULT 0,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `title_km` varchar(191) DEFAULT NULL,
  `link_km` varchar(191) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `smartend_menus`
--

INSERT INTO `smartend_menus` (`id`, `row_no`, `father_id`, `title_en`, `status`, `type`, `cat_id`, `link`, `link_en`, `icon`, `target`, `created_by`, `updated_by`, `created_at`, `updated_at`, `title_km`, `link_km`) VALUES
(1, 1, 0, 'Main Menu', 1, 0, 0, '', NULL, NULL, 0, 1, NULL, '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Main Menu', NULL),
(2, 2, 0, 'Footer Menu', 1, 0, 0, '', NULL, NULL, 0, 1, NULL, '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Footer Menu', NULL),
(3, 1, 1, 'Home', 1, 1, 0, '/', '/', NULL, 0, 1, NULL, '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Home', '/'),
(4, 2, 1, 'About', 1, 0, 0, '', NULL, NULL, 0, 1, NULL, '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'About', NULL),
(11, 9, 1, 'Blog', 1, 2, 7, '', NULL, NULL, 0, 1, NULL, '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Blog', NULL),
(13, 11, 1, 'Contact', 1, 1, 0, 'contact', 'contact', NULL, 0, 1, NULL, '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Contact', 'contact'),
(14, 1, 4, 'Company profile', 1, 1, 0, 'about', 'about', 'fa-bookmark-o', 0, 1, NULL, '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Company profile', 'about'),
(18, 2, 2, 'Our Company', 1, 0, 0, '', NULL, NULL, 0, 1, NULL, '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Our Company', NULL),
(19, 2, 2, 'Quick Links', 1, 0, 0, '', NULL, NULL, 0, 1, NULL, '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Quick Links', NULL),
(20, 1, 18, 'About', 1, 1, 0, 'about', 'about', NULL, 0, 1, NULL, '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'About', 'about'),
(23, 4, 18, 'Privacy', 1, 1, 0, 'privacy', 'privacy', NULL, 0, 1, NULL, '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Privacy', 'privacy'),
(24, 5, 18, 'Terms & Conditions', 1, 1, 0, 'terms', 'terms', NULL, 0, 1, NULL, '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Terms & Conditions', 'terms'),
(25, 6, 18, 'Contact', 1, 1, 0, 'contact', 'contact', NULL, 0, 1, NULL, '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Contact', 'contact'),
(29, 4, 19, 'Blog', 1, 2, 7, '', NULL, NULL, 0, 1, NULL, '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Blog', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `smartend_migrations`
--

CREATE TABLE `smartend_migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(191) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `smartend_migrations`
--

INSERT INTO `smartend_migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_11_000000_create_permissions_table', 1),
(2, '2014_10_12_000000_create_users_table', 1),
(3, '2014_10_12_100000_create_password_resets_table', 1),
(4, '2014_10_12_200000_add_two_factor_columns_to_users_table', 1),
(5, '2019_08_19_000000_create_failed_jobs_table', 1),
(6, '2020_09_11_160850_create_sessions_table', 1),
(7, '2020_09_11_190632_create_webmaster_settings_table', 1),
(8, '2020_09_11_190633_create_webmaster_sections_table', 1),
(9, '2020_09_11_190635_create_webmaster_banners_table', 1),
(10, '2020_09_11_190637_create_webmails_groups_table', 1),
(11, '2020_09_11_190637_create_webmails_table', 1),
(12, '2020_09_11_190638_create_webmails_files_table', 1),
(13, '2020_09_11_190640_create_sections_table', 1),
(14, '2020_09_11_190641_create_topics_table', 1),
(15, '2020_09_11_190643_create_settings_table', 1),
(16, '2020_09_11_190647_create_photos_table', 1),
(17, '2020_09_11_190650_create_menus_table', 1),
(18, '2020_09_11_190652_create_maps_table', 1),
(19, '2020_09_11_190654_create_events_table', 1),
(20, '2020_09_11_190656_create_countries_table', 1),
(21, '2020_09_11_190657_create_contacts_groups_table', 1),
(22, '2020_09_11_190659_create_contacts_table', 1),
(23, '2020_09_11_190701_create_comments_table', 1),
(24, '2020_09_11_190703_create_banners_table', 1),
(25, '2020_09_11_190704_create_attach_files_table', 1),
(26, '2020_09_11_190706_create_analytics_visitors_table', 1),
(27, '2020_09_11_190708_create_analytics_pages_table', 1),
(28, '2020_09_11_190912_create_related_topics_table', 1),
(29, '2020_09_11_190914_create_topic_categories_table', 1),
(30, '2020_09_11_190915_create_webmaster_section_fields_table', 1),
(31, '2020_09_11_190916_create_topic_fields_table', 1),
(32, '2020_09_11_201046_create_languages_table', 1),
(33, '2024_06_20_022426_create_tags_table', 1),
(34, '2024_06_20_023951_create_topic_tags_table', 1),
(35, '2024_07_18_172916_create_popups_table', 1);

-- --------------------------------------------------------

--
-- Table structure for table `smartend_permissions`
--

CREATE TABLE `smartend_permissions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) NOT NULL,
  `view_status` tinyint(4) NOT NULL DEFAULT 0,
  `add_status` tinyint(4) NOT NULL DEFAULT 0,
  `edit_status` tinyint(4) NOT NULL DEFAULT 0,
  `delete_status` tinyint(4) NOT NULL DEFAULT 0,
  `active_status` tinyint(4) NOT NULL DEFAULT 0,
  `analytics_status` tinyint(4) NOT NULL DEFAULT 0,
  `inbox_status` tinyint(4) NOT NULL DEFAULT 0,
  `newsletter_status` tinyint(4) NOT NULL DEFAULT 0,
  `calendar_status` tinyint(4) NOT NULL DEFAULT 0,
  `banners_status` tinyint(4) NOT NULL DEFAULT 0,
  `settings_status` tinyint(4) NOT NULL DEFAULT 0,
  `roles_status` tinyint(4) NOT NULL DEFAULT 0,
  `tags_status` tinyint(4) NOT NULL DEFAULT 0,
  `popups_status` tinyint(4) NOT NULL DEFAULT 0,
  `menus_status` tinyint(4) NOT NULL DEFAULT 0,
  `file_manager_status` tinyint(4) NOT NULL DEFAULT 0,
  `webmaster_status` tinyint(4) NOT NULL DEFAULT 0,
  `modules_status` tinyint(4) NOT NULL DEFAULT 0,
  `data_sections` varchar(191) DEFAULT NULL,
  `home_status` tinyint(4) NOT NULL DEFAULT 0,
  `home_links` text DEFAULT NULL,
  `home_details_ar` longtext DEFAULT NULL,
  `home_details_en` longtext DEFAULT NULL,
  `home_details_ch` longtext DEFAULT NULL,
  `home_details_hi` longtext DEFAULT NULL,
  `home_details_es` longtext DEFAULT NULL,
  `home_details_ru` longtext DEFAULT NULL,
  `home_details_pt` longtext DEFAULT NULL,
  `home_details_fr` longtext DEFAULT NULL,
  `home_details_de` longtext DEFAULT NULL,
  `home_details_th` longtext DEFAULT NULL,
  `home_details_br` longtext DEFAULT NULL,
  `status` tinyint(4) NOT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `home_details_km` varchar(191) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `smartend_permissions`
--

INSERT INTO `smartend_permissions` (`id`, `name`, `view_status`, `add_status`, `edit_status`, `delete_status`, `active_status`, `analytics_status`, `inbox_status`, `newsletter_status`, `calendar_status`, `banners_status`, `settings_status`, `roles_status`, `tags_status`, `popups_status`, `menus_status`, `file_manager_status`, `webmaster_status`, `modules_status`, `data_sections`, `home_status`, `home_links`, `home_details_ar`, `home_details_en`, `home_details_ch`, `home_details_hi`, `home_details_es`, `home_details_ru`, `home_details_pt`, `home_details_fr`, `home_details_de`, `home_details_th`, `home_details_br`, `status`, `created_by`, `updated_by`, `created_at`, `updated_at`, `home_details_km`) VALUES
(1, 'Webmaster', 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, NULL, '2025-01-04 09:15:30', '2025-01-08 12:35:28', NULL),
(2, 'Website Manager', 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, '1,2,3,4,5,6,7,8,9,10,11,12,13,14', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, NULL, '2025-01-04 09:15:30', '2025-01-04 09:21:09', NULL),
(3, 'Limited User', 1, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, '1,2,3,4,5,6,7,8,9,10,11,12,13,14', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, NULL, '2025-01-04 09:15:30', '2025-01-04 09:21:09', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `smartend_photos`
--

CREATE TABLE `smartend_photos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `topic_id` bigint(20) UNSIGNED NOT NULL,
  `file` varchar(191) DEFAULT NULL,
  `title` varchar(191) DEFAULT NULL,
  `row_no` int(11) NOT NULL DEFAULT 0,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `smartend_photos`
--

INSERT INTO `smartend_photos` (`id`, `topic_id`, `file`, `title`, `row_no`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(49, 124, '17360677492598.jpeg', 'pic 01', 1, 1, NULL, '2025-01-05 04:02:29', '2025-01-05 04:02:29'),
(50, 124, '17360677536877.jpg', '17082055474903', 2, 1, NULL, '2025-01-05 04:02:33', '2025-01-05 04:02:33'),
(51, 124, '17360677795736.jpg', 'img_03', 3, 1, NULL, '2025-01-05 04:02:59', '2025-01-05 04:02:59'),
(52, 124, '17360677859932.jpg', 'img_10', 4, 1, NULL, '2025-01-05 04:03:05', '2025-01-05 04:03:05');

-- --------------------------------------------------------

--
-- Table structure for table `smartend_popups`
--

CREATE TABLE `smartend_popups` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `row_no` int(11) NOT NULL DEFAULT 0,
  `form_id` int(11) DEFAULT NULL,
  `show_in` int(11) DEFAULT NULL,
  `title_ar` varchar(191) DEFAULT NULL,
  `title_en` varchar(191) DEFAULT NULL,
  `title_ch` varchar(191) DEFAULT NULL,
  `title_hi` varchar(191) DEFAULT NULL,
  `title_es` varchar(191) DEFAULT NULL,
  `title_ru` varchar(191) DEFAULT NULL,
  `title_pt` varchar(191) DEFAULT NULL,
  `title_fr` varchar(191) DEFAULT NULL,
  `title_de` varchar(191) DEFAULT NULL,
  `title_th` varchar(191) DEFAULT NULL,
  `title_br` varchar(191) DEFAULT NULL,
  `details_ar` longtext DEFAULT NULL,
  `details_en` longtext DEFAULT NULL,
  `details_ch` longtext DEFAULT NULL,
  `details_hi` longtext DEFAULT NULL,
  `details_es` longtext DEFAULT NULL,
  `details_ru` longtext DEFAULT NULL,
  `details_pt` longtext DEFAULT NULL,
  `details_fr` longtext DEFAULT NULL,
  `details_de` longtext DEFAULT NULL,
  `details_th` longtext DEFAULT NULL,
  `details_br` longtext DEFAULT NULL,
  `photo` varchar(191) DEFAULT NULL,
  `settings` text DEFAULT NULL,
  `code` longtext DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `title_km` varchar(191) DEFAULT NULL,
  `details_km` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `smartend_popups`
--

INSERT INTO `smartend_popups` (`id`, `row_no`, `form_id`, `show_in`, `title_ar`, `title_en`, `title_ch`, `title_hi`, `title_es`, `title_ru`, `title_pt`, `title_fr`, `title_de`, `title_th`, `title_br`, `details_ar`, `details_en`, `details_ch`, `details_hi`, `details_es`, `details_ru`, `details_pt`, `details_fr`, `details_de`, `details_th`, `details_br`, `photo`, `settings`, `code`, `status`, `created_by`, `updated_by`, `created_at`, `updated_at`, `title_km`, `details_km`) VALUES
(1, 1, -1, 0, 'نافذة منبثقة للاشتراك في النشرة الإخبارية', 'Newsletter subscribe popup', '时事通讯订阅弹出窗口', 'न्यूज़लैटर सदस्यता पॉपअप', 'Ventana emergente de suscripción al boletín informativo', 'Всплывающее окно подписки на рассылку новостей', 'Pop-up de subscrição de newsletters', 'Fenêtre contextuelle d\'inscription à la newsletter', 'Popup zum Abonnieren des Newsletters', 'ป๊อปอัปสมัครรับจดหมายข่าว', 'Pop-up de inscrição no boletim informativo', '<br><div><h1>النشرة البريدية</h1><p>اشترك الآن في النشرة البريدية لدينا لتلقي آخر التحديثات.</p></div><br>', '<br><div><h1>Subscribe Now</h1><p>Sign up for our newsletter to receive the latest updates.</p></div><br>', '<br><div><h1>立即订阅</h1><p>注册我们的新闻通讯以接收最新更新。</p></div><br>', '<br><div><h1>अभी सदस्यता लें</h1><p>नवीनतम अपडेट प्राप्त करने के लिए हमारे न्यूज़लेटर के लिए साइन अप करें।</p></div><br>', '<br><div><h1>Suscríbete ahora</h1><p>Suscríbete a nuestro boletín para recibir las últimas novedades.</p></div><br>', '<br><div><h1>Подпишитесь сейчас</h1><p>Подпишитесь на нашу рассылку, чтобы получать последние обновления.</p></div><br>', '<br><div><h1>Inscreva-se já</h1><p>Subscreva a nossa newsletter para receber as últimas atualizações.</p></div><br>', '<br><div><h1>Abonnez-vous maintenant</h1><p>Inscrivez-vous à notre newsletter pour recevoir les dernières mises à jour.</p></div><br>', '<br><div><h1>Jetzt abonnieren</h1><p>Melden Sie sich für unseren Newsletter an, um die neuesten Updates zu erhalten.</p></div><br>', '<br><div><h1>สมัครสมาชิกทันที</h1><p>สมัครรับจดหมายข่าวของเราเพื่อรับข้อมูลอัปเดตล่าสุด</p></div><br>', '<br><div><h1>Assine agora</h1><p>Assine nossa newsletter para receber as últimas atualizações.</p></div><br>', 'newsletter.png', '{\"background_color\":\"#ffffff\",\"period\":\"0\",\"closable\":\"1\",\"delay\":\"5\",\"width\":\"700\",\"height\":\"320\",\"backdrop_opacity\":\"70\",\"photo_position\":\"1\"}', NULL, 1, 1, NULL, '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Newsletter subscribe popup', '<br><div><h1>Subscribe Now</h1><p>Sign up for our newsletter to receive the latest updates.</p></div><br>');

-- --------------------------------------------------------

--
-- Table structure for table `smartend_related_topics`
--

CREATE TABLE `smartend_related_topics` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `topic_id` bigint(20) UNSIGNED NOT NULL,
  `topic2_id` bigint(20) UNSIGNED NOT NULL,
  `row_no` int(11) NOT NULL DEFAULT 0,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `smartend_sections`
--

CREATE TABLE `smartend_sections` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title_en` varchar(191) DEFAULT NULL,
  `photo` varchar(191) DEFAULT NULL,
  `icon` varchar(191) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `visits` int(11) NOT NULL DEFAULT 0,
  `webmaster_id` bigint(20) UNSIGNED NOT NULL,
  `father_id` int(11) NOT NULL DEFAULT 0,
  `row_no` int(11) NOT NULL DEFAULT 0,
  `popup_id` int(11) DEFAULT NULL,
  `seo_title_en` varchar(191) DEFAULT NULL,
  `seo_description_en` varchar(191) DEFAULT NULL,
  `seo_keywords_en` varchar(191) DEFAULT NULL,
  `seo_url_slug_en` varchar(191) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `title_km` varchar(191) DEFAULT NULL,
  `seo_title_km` varchar(191) DEFAULT NULL,
  `seo_description_km` varchar(191) DEFAULT NULL,
  `seo_keywords_km` varchar(191) DEFAULT NULL,
  `seo_url_slug_km` varchar(191) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `smartend_sections`
--

INSERT INTO `smartend_sections` (`id`, `title_en`, `photo`, `icon`, `status`, `visits`, `webmaster_id`, `father_id`, `row_no`, `popup_id`, `seo_title_en`, `seo_description_en`, `seo_keywords_en`, `seo_url_slug_en`, `created_by`, `updated_by`, `created_at`, `updated_at`, `title_km`, `seo_title_km`, `seo_description_km`, `seo_keywords_km`, `seo_url_slug_km`) VALUES
(30, 'Data Science', NULL, 'fa-database', 1, 0, 7, 0, 1, NULL, 'Data Science', NULL, NULL, 'data-science', 1, NULL, '2025-01-05 03:54:05', '2025-01-05 03:54:05', 'Data Science', 'Data Science', NULL, NULL, 'data-science'),
(31, 'Working Papers 150', NULL, NULL, 1, 0, 16, 0, 1, NULL, 'Working Papers 150', NULL, NULL, 'working-papers-150', 1, NULL, '2025-01-08 11:28:57', '2025-01-08 11:28:57', 'Working Papers 150', 'Working Papers 150', NULL, NULL, 'working-papers-150'),
(32, 'UNESCO', NULL, NULL, 1, 0, 17, 0, 1, NULL, 'UNESCO', NULL, NULL, 'unesco', 1, NULL, '2025-01-08 12:38:27', '2025-01-08 12:38:27', 'UNESCO', 'UNESCO', NULL, NULL, 'unesco');

-- --------------------------------------------------------

--
-- Table structure for table `smartend_sessions`
--

CREATE TABLE `smartend_sessions` (
  `id` varchar(191) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` text NOT NULL,
  `last_activity` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `smartend_settings`
--

CREATE TABLE `smartend_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `site_title_en` varchar(191) DEFAULT NULL,
  `site_desc_en` varchar(191) DEFAULT NULL,
  `site_keywords_en` text DEFAULT NULL,
  `site_webmails` varchar(191) DEFAULT NULL,
  `notify_messages_status` tinyint(4) DEFAULT NULL,
  `notify_comments_status` tinyint(4) DEFAULT NULL,
  `notify_orders_status` tinyint(4) DEFAULT NULL,
  `notify_table_status` tinyint(4) DEFAULT NULL,
  `notify_private_status` tinyint(4) DEFAULT NULL,
  `site_url` varchar(191) DEFAULT NULL,
  `site_status` tinyint(4) NOT NULL DEFAULT 0,
  `close_msg` text DEFAULT NULL,
  `social_link1` varchar(191) DEFAULT NULL,
  `social_link2` varchar(191) DEFAULT NULL,
  `social_link3` varchar(191) DEFAULT NULL,
  `social_link4` varchar(191) DEFAULT NULL,
  `social_link5` varchar(191) DEFAULT NULL,
  `social_link6` varchar(191) DEFAULT NULL,
  `social_link7` varchar(191) DEFAULT NULL,
  `social_link8` varchar(191) DEFAULT NULL,
  `social_link9` varchar(191) DEFAULT NULL,
  `social_link10` varchar(191) DEFAULT NULL,
  `contact_t1_en` varchar(191) DEFAULT NULL,
  `contact_t3` varchar(191) DEFAULT NULL,
  `contact_t4` varchar(191) DEFAULT NULL,
  `contact_t5` varchar(191) DEFAULT NULL,
  `contact_t6` varchar(191) DEFAULT NULL,
  `contact_t7_en` varchar(191) DEFAULT NULL,
  `style_logo_en` varchar(191) DEFAULT NULL,
  `style_fav` varchar(191) DEFAULT NULL,
  `style_apple` varchar(191) DEFAULT NULL,
  `style_color1` varchar(191) DEFAULT NULL,
  `style_color2` varchar(191) DEFAULT NULL,
  `style_color3` varchar(191) DEFAULT NULL,
  `style_color4` varchar(191) DEFAULT NULL,
  `style_type` tinyint(4) DEFAULT NULL,
  `style_change` tinyint(4) DEFAULT NULL,
  `style_bg_type` tinyint(4) DEFAULT NULL,
  `style_bg_pattern` varchar(191) DEFAULT NULL,
  `style_bg_color` varchar(191) DEFAULT NULL,
  `style_bg_image` varchar(191) DEFAULT NULL,
  `style_subscribe` tinyint(4) DEFAULT NULL,
  `style_footer` tinyint(4) DEFAULT NULL,
  `style_header` tinyint(4) DEFAULT NULL,
  `style_footer_bg` varchar(191) DEFAULT NULL,
  `style_preload` tinyint(4) DEFAULT NULL,
  `css` longtext DEFAULT NULL,
  `js` longtext DEFAULT NULL,
  `body` longtext DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `site_title_km` varchar(191) DEFAULT NULL,
  `site_desc_km` varchar(191) DEFAULT NULL,
  `site_keywords_km` text DEFAULT NULL,
  `contact_t1_km` varchar(191) DEFAULT NULL,
  `contact_t7_km` varchar(191) DEFAULT NULL,
  `style_logo_km` varchar(191) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `smartend_settings`
--

INSERT INTO `smartend_settings` (`id`, `site_title_en`, `site_desc_en`, `site_keywords_en`, `site_webmails`, `notify_messages_status`, `notify_comments_status`, `notify_orders_status`, `notify_table_status`, `notify_private_status`, `site_url`, `site_status`, `close_msg`, `social_link1`, `social_link2`, `social_link3`, `social_link4`, `social_link5`, `social_link6`, `social_link7`, `social_link8`, `social_link9`, `social_link10`, `contact_t1_en`, `contact_t3`, `contact_t4`, `contact_t5`, `contact_t6`, `contact_t7_en`, `style_logo_en`, `style_fav`, `style_apple`, `style_color1`, `style_color2`, `style_color3`, `style_color4`, `style_type`, `style_change`, `style_bg_type`, `style_bg_pattern`, `style_bg_color`, `style_bg_image`, `style_subscribe`, `style_footer`, `style_header`, `style_footer_bg`, `style_preload`, `css`, `js`, `body`, `created_by`, `updated_by`, `created_at`, `updated_at`, `site_title_km`, `site_desc_km`, `site_keywords_km`, `contact_t1_km`, `contact_t7_km`, `style_logo_km`) VALUES
(1, 'DATA COLABX', 'Website description and some little information about it', 'key, words, website, web', 'info@sitename.com', 1, 1, 1, 0, 0, 'WWW.DATACOLABX.ORG', 1, '<div class=\'text-center\'><img src=\'/assets/frontend/images/maintenance.gif\' width=\'400\'><h1>Website Under Maintenance</h1><h4>Coming Soon</h4></div>', '#', '#', NULL, '#', '#', '#', '#', '#', '#', '923227428732', '‍#PA59, Street RailwayBorey Piphop Thmei Chhuk Var 2Kakap village, Sangkat Kakab 2Khan Posenchey, Phnom Penh, Cambodia', '+(855) 16 705 118', NULL, '+(855) 16 705 118', 'PRODUCT@DATACOLABX.ORG', 'Sunday to Thursday 08:00 AM to 05:00 PM', '17363602908701.png', '17363602909590.png', '17363602903628.png', '#2e9dff', '#2e3e4e', '#edf3f2', '#dfeae8', 0, 1, 0, NULL, NULL, NULL, 1, 1, 1, 'footer-bg.webp', 1, NULL, NULL, NULL, 1, 1, '2025-01-04 09:15:30', '2025-01-08 14:16:32', 'DATA COLABX', 'Website description and some little information about it', 'key, words, website, web', '‍#PA59, Street RailwayBorey Piphop Thmei Chhuk Var 2Kakap village, Sangkat Kakab 2Khan Posenchey, Phnom Penh, Cambodia', 'Sunday to Thursday 08:00 AM to 05:00 PM', '17363602396924.png');

-- --------------------------------------------------------

--
-- Table structure for table `smartend_tags`
--

CREATE TABLE `smartend_tags` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) DEFAULT NULL,
  `seo_url` varchar(191) DEFAULT NULL,
  `details` longtext DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `visits` int(11) NOT NULL DEFAULT 0,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `smartend_topics`
--

CREATE TABLE `smartend_topics` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title_en` varchar(191) DEFAULT NULL,
  `details_en` longtext DEFAULT NULL,
  `date` date DEFAULT NULL,
  `expire_date` date DEFAULT NULL,
  `video_type` tinyint(4) DEFAULT NULL,
  `photo_file` varchar(191) DEFAULT NULL,
  `attach_file` varchar(191) DEFAULT NULL,
  `video_file` text DEFAULT NULL,
  `audio_file` varchar(191) DEFAULT NULL,
  `icon` varchar(191) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `visits` int(11) NOT NULL DEFAULT 0,
  `webmaster_id` bigint(20) UNSIGNED NOT NULL,
  `section_id` int(11) DEFAULT NULL,
  `row_no` int(11) NOT NULL DEFAULT 0,
  `form_id` int(11) DEFAULT NULL,
  `popup_id` int(11) DEFAULT NULL,
  `topic_id` int(11) DEFAULT NULL,
  `seo_title_en` varchar(191) DEFAULT NULL,
  `seo_description_en` varchar(191) DEFAULT NULL,
  `seo_keywords_en` varchar(191) DEFAULT NULL,
  `seo_url_slug_en` varchar(191) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `title_km` varchar(191) DEFAULT NULL,
  `details_km` longtext DEFAULT NULL,
  `seo_title_km` varchar(191) DEFAULT NULL,
  `seo_description_km` varchar(191) DEFAULT NULL,
  `seo_keywords_km` varchar(191) DEFAULT NULL,
  `seo_url_slug_km` varchar(191) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `smartend_topics`
--

INSERT INTO `smartend_topics` (`id`, `title_en`, `details_en`, `date`, `expire_date`, `video_type`, `photo_file`, `attach_file`, `video_file`, `audio_file`, `icon`, `status`, `visits`, `webmaster_id`, `section_id`, `row_no`, `form_id`, `popup_id`, `topic_id`, `seo_title_en`, `seo_description_en`, `seo_keywords_en`, `seo_url_slug_en`, `created_by`, `updated_by`, `created_at`, `updated_at`, `title_km`, `details_km`, `seo_title_km`, `seo_description_km`, `seo_keywords_km`, `seo_url_slug_km`) VALUES
(1, 'About Us', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed at ante. Mauris eleifend, quam a vulputate dictum, massa quam dapibus leo, eget vulputate orci purus ut lorem. In fringilla mi in ligula. Pellentesque aliquam quam vel dolor. Nunc adipiscing. Sed quam odio, tempus ac, aliquam molestie, varius ac, tellus. Vestibulum ut nulla aliquam risus rutrum interdum. Pellentesque lorem. Curabitur sit amet erat quis risus feugiat viverra. Pellentesque augue justo, sagittis et, lacinia at, venenatis non, arcu. Nunc nec libero. In cursus dictum risus. Etiam tristique nisl a nulla. Ut a orci. Curabitur dolor nunc, egestas at, accumsan at, malesuada nec, magna.<br>\nNulla facilisi. Nunc volutpat. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Ut sit amet orci vel mauris blandit vehicula. Nullam quis enim. Integer dignissim viverra velit. Curabitur in odio. In hac habitasse platea dictumst. Ut consequat, tellus eu volutpat varius, justo orci elementum dolor, sed imperdiet nulla tellus ut diam. Vestibulum ipsum ante, malesuada quis, tempus ac, placerat sit amet, elit.<br>\nSed eget turpis a pede tempor malesuada. Vivamus quis mi at leo pulvinar hendrerit. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Pellentesque aliquet lacus vitae pede. Nullam mollis dolor ac nisi. Phasellus sit amet urna. Praesent pellentesque sapien sed lacus. Donec lacinia odio in odio. In sit amet elit. Maecenas gravida interdum urna. Integer pretium, arcu vitae imperdiet facilisis, elit tellus tempor nisi, vel feugiat ante velit sit amet mauris. Vivamus arcu. Integer pharetra magna ac lacus. Aliquam vitae sapien in nibh vehicula auctor. Suspendisse leo mauris, pulvinar sed, tempor et, consequat ac, lacus. Proin velit. Nulla semper lobortis mauris. Duis urna erat, ornare et, imperdiet eu, suscipit sit amet, massa. Nulla nulla nisi, pellentesque at, egestas quis, fringilla eu, diam.<br>\nDonec semper, sem nec tristique tempus, justo neque commodo nisl, ut gravida sem tellus suscipit nunc. Aliquam erat volutpat. Ut tincidunt pretium elit. Aliquam pulvinar. Nulla cursus. Suspendisse potenti. Etiam condimentum hendrerit felis. Duis iaculis aliquam enim. Donec dignissim augue vitae orci. Curabitur luctus felis a metus. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. In varius neque at enim. Suspendisse massa nulla, viverra in, bibendum vitae, tempor quis, lorem.<br>\nDonec dapibus orci sit amet elit. Maecenas rutrum ultrices lectus. Aliquam suscipit, lacus a iaculis adipiscing, eros orci pellentesque nisl, non pharetra dolor urna nec dolor. Integer cursus dolor vel magna. Integer ultrices feugiat sem. Proin nec nibh. Duis eu dui quis nunc sagittis lobortis. Fusce pharetra, enim ut sodales luctus, lectus arcu rhoncus purus, in fringilla augue elit vel lacus. In hac habitasse platea dictumst. Aliquam erat volutpat. Fusce iaculis elit id tellus. Ut accumsan malesuada turpis. Suspendisse potenti. Vestibulum lacus augue, lobortis mattis, laoreet in, varius at, nisi. Nunc gravida. Phasellus faucibus. In hac habitasse platea dictumst. Integer tempor lacus eget lectus. Praesent fringilla augue fringilla dui.', '2025-01-04', NULL, NULL, 'default.png', NULL, NULL, NULL, NULL, 1, 4, 1, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, 'about', 1, NULL, '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'About Us', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed at ante. Mauris eleifend, quam a vulputate dictum, massa quam dapibus leo, eget vulputate orci purus ut lorem. In fringilla mi in ligula. Pellentesque aliquam quam vel dolor. Nunc adipiscing. Sed quam odio, tempus ac, aliquam molestie, varius ac, tellus. Vestibulum ut nulla aliquam risus rutrum interdum. Pellentesque lorem. Curabitur sit amet erat quis risus feugiat viverra. Pellentesque augue justo, sagittis et, lacinia at, venenatis non, arcu. Nunc nec libero. In cursus dictum risus. Etiam tristique nisl a nulla. Ut a orci. Curabitur dolor nunc, egestas at, accumsan at, malesuada nec, magna.<br>\nNulla facilisi. Nunc volutpat. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Ut sit amet orci vel mauris blandit vehicula. Nullam quis enim. Integer dignissim viverra velit. Curabitur in odio. In hac habitasse platea dictumst. Ut consequat, tellus eu volutpat varius, justo orci elementum dolor, sed imperdiet nulla tellus ut diam. Vestibulum ipsum ante, malesuada quis, tempus ac, placerat sit amet, elit.<br>\nSed eget turpis a pede tempor malesuada. Vivamus quis mi at leo pulvinar hendrerit. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Pellentesque aliquet lacus vitae pede. Nullam mollis dolor ac nisi. Phasellus sit amet urna. Praesent pellentesque sapien sed lacus. Donec lacinia odio in odio. In sit amet elit. Maecenas gravida interdum urna. Integer pretium, arcu vitae imperdiet facilisis, elit tellus tempor nisi, vel feugiat ante velit sit amet mauris. Vivamus arcu. Integer pharetra magna ac lacus. Aliquam vitae sapien in nibh vehicula auctor. Suspendisse leo mauris, pulvinar sed, tempor et, consequat ac, lacus. Proin velit. Nulla semper lobortis mauris. Duis urna erat, ornare et, imperdiet eu, suscipit sit amet, massa. Nulla nulla nisi, pellentesque at, egestas quis, fringilla eu, diam.<br>\nDonec semper, sem nec tristique tempus, justo neque commodo nisl, ut gravida sem tellus suscipit nunc. Aliquam erat volutpat. Ut tincidunt pretium elit. Aliquam pulvinar. Nulla cursus. Suspendisse potenti. Etiam condimentum hendrerit felis. Duis iaculis aliquam enim. Donec dignissim augue vitae orci. Curabitur luctus felis a metus. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. In varius neque at enim. Suspendisse massa nulla, viverra in, bibendum vitae, tempor quis, lorem.<br>\nDonec dapibus orci sit amet elit. Maecenas rutrum ultrices lectus. Aliquam suscipit, lacus a iaculis adipiscing, eros orci pellentesque nisl, non pharetra dolor urna nec dolor. Integer cursus dolor vel magna. Integer ultrices feugiat sem. Proin nec nibh. Duis eu dui quis nunc sagittis lobortis. Fusce pharetra, enim ut sodales luctus, lectus arcu rhoncus purus, in fringilla augue elit vel lacus. In hac habitasse platea dictumst. Aliquam erat volutpat. Fusce iaculis elit id tellus. Ut accumsan malesuada turpis. Suspendisse potenti. Vestibulum lacus augue, lobortis mattis, laoreet in, varius at, nisi. Nunc gravida. Phasellus faucibus. In hac habitasse platea dictumst. Integer tempor lacus eget lectus. Praesent fringilla augue fringilla dui.', NULL, NULL, NULL, NULL),
(2, 'Contact Us', NULL, '2025-01-04', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 1, 0, 2, NULL, NULL, NULL, NULL, NULL, NULL, 'contact', 1, NULL, '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Contact Us', NULL, NULL, NULL, NULL, NULL),
(3, 'Privacy Policy', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed at ante. Mauris eleifend, quam a vulputate dictum, massa quam dapibus leo, eget vulputate orci purus ut lorem. In fringilla mi in ligula. Pellentesque aliquam quam vel dolor. Nunc adipiscing. Sed quam odio, tempus ac, aliquam molestie, varius ac, tellus. Vestibulum ut nulla aliquam risus rutrum interdum. Pellentesque lorem. Curabitur sit amet erat quis risus feugiat viverra. Pellentesque augue justo, sagittis et, lacinia at, venenatis non, arcu. Nunc nec libero. In cursus dictum risus. Etiam tristique nisl a nulla. Ut a orci. Curabitur dolor nunc, egestas at, accumsan at, malesuada nec, magna.<br>\nNulla facilisi. Nunc volutpat. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Ut sit amet orci vel mauris blandit vehicula. Nullam quis enim. Integer dignissim viverra velit. Curabitur in odio. In hac habitasse platea dictumst. Ut consequat, tellus eu volutpat varius, justo orci elementum dolor, sed imperdiet nulla tellus ut diam. Vestibulum ipsum ante, malesuada quis, tempus ac, placerat sit amet, elit.<br>\nSed eget turpis a pede tempor malesuada. Vivamus quis mi at leo pulvinar hendrerit. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Pellentesque aliquet lacus vitae pede. Nullam mollis dolor ac nisi. Phasellus sit amet urna. Praesent pellentesque sapien sed lacus. Donec lacinia odio in odio. In sit amet elit. Maecenas gravida interdum urna. Integer pretium, arcu vitae imperdiet facilisis, elit tellus tempor nisi, vel feugiat ante velit sit amet mauris. Vivamus arcu. Integer pharetra magna ac lacus. Aliquam vitae sapien in nibh vehicula auctor. Suspendisse leo mauris, pulvinar sed, tempor et, consequat ac, lacus. Proin velit. Nulla semper lobortis mauris. Duis urna erat, ornare et, imperdiet eu, suscipit sit amet, massa. Nulla nulla nisi, pellentesque at, egestas quis, fringilla eu, diam.<br>\nDonec semper, sem nec tristique tempus, justo neque commodo nisl, ut gravida sem tellus suscipit nunc. Aliquam erat volutpat. Ut tincidunt pretium elit. Aliquam pulvinar. Nulla cursus. Suspendisse potenti. Etiam condimentum hendrerit felis. Duis iaculis aliquam enim. Donec dignissim augue vitae orci. Curabitur luctus felis a metus. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. In varius neque at enim. Suspendisse massa nulla, viverra in, bibendum vitae, tempor quis, lorem.<br>\nDonec dapibus orci sit amet elit. Maecenas rutrum ultrices lectus. Aliquam suscipit, lacus a iaculis adipiscing, eros orci pellentesque nisl, non pharetra dolor urna nec dolor. Integer cursus dolor vel magna. Integer ultrices feugiat sem. Proin nec nibh. Duis eu dui quis nunc sagittis lobortis. Fusce pharetra, enim ut sodales luctus, lectus arcu rhoncus purus, in fringilla augue elit vel lacus. In hac habitasse platea dictumst. Aliquam erat volutpat. Fusce iaculis elit id tellus. Ut accumsan malesuada turpis. Suspendisse potenti. Vestibulum lacus augue, lobortis mattis, laoreet in, varius at, nisi. Nunc gravida. Phasellus faucibus. In hac habitasse platea dictumst. Integer tempor lacus eget lectus. Praesent fringilla augue fringilla dui.', '2025-01-04', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 1, 0, 3, NULL, NULL, NULL, NULL, NULL, NULL, 'privacy', 1, NULL, '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Privacy Policy', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed at ante. Mauris eleifend, quam a vulputate dictum, massa quam dapibus leo, eget vulputate orci purus ut lorem. In fringilla mi in ligula. Pellentesque aliquam quam vel dolor. Nunc adipiscing. Sed quam odio, tempus ac, aliquam molestie, varius ac, tellus. Vestibulum ut nulla aliquam risus rutrum interdum. Pellentesque lorem. Curabitur sit amet erat quis risus feugiat viverra. Pellentesque augue justo, sagittis et, lacinia at, venenatis non, arcu. Nunc nec libero. In cursus dictum risus. Etiam tristique nisl a nulla. Ut a orci. Curabitur dolor nunc, egestas at, accumsan at, malesuada nec, magna.<br>\nNulla facilisi. Nunc volutpat. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Ut sit amet orci vel mauris blandit vehicula. Nullam quis enim. Integer dignissim viverra velit. Curabitur in odio. In hac habitasse platea dictumst. Ut consequat, tellus eu volutpat varius, justo orci elementum dolor, sed imperdiet nulla tellus ut diam. Vestibulum ipsum ante, malesuada quis, tempus ac, placerat sit amet, elit.<br>\nSed eget turpis a pede tempor malesuada. Vivamus quis mi at leo pulvinar hendrerit. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Pellentesque aliquet lacus vitae pede. Nullam mollis dolor ac nisi. Phasellus sit amet urna. Praesent pellentesque sapien sed lacus. Donec lacinia odio in odio. In sit amet elit. Maecenas gravida interdum urna. Integer pretium, arcu vitae imperdiet facilisis, elit tellus tempor nisi, vel feugiat ante velit sit amet mauris. Vivamus arcu. Integer pharetra magna ac lacus. Aliquam vitae sapien in nibh vehicula auctor. Suspendisse leo mauris, pulvinar sed, tempor et, consequat ac, lacus. Proin velit. Nulla semper lobortis mauris. Duis urna erat, ornare et, imperdiet eu, suscipit sit amet, massa. Nulla nulla nisi, pellentesque at, egestas quis, fringilla eu, diam.<br>\nDonec semper, sem nec tristique tempus, justo neque commodo nisl, ut gravida sem tellus suscipit nunc. Aliquam erat volutpat. Ut tincidunt pretium elit. Aliquam pulvinar. Nulla cursus. Suspendisse potenti. Etiam condimentum hendrerit felis. Duis iaculis aliquam enim. Donec dignissim augue vitae orci. Curabitur luctus felis a metus. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. In varius neque at enim. Suspendisse massa nulla, viverra in, bibendum vitae, tempor quis, lorem.<br>\nDonec dapibus orci sit amet elit. Maecenas rutrum ultrices lectus. Aliquam suscipit, lacus a iaculis adipiscing, eros orci pellentesque nisl, non pharetra dolor urna nec dolor. Integer cursus dolor vel magna. Integer ultrices feugiat sem. Proin nec nibh. Duis eu dui quis nunc sagittis lobortis. Fusce pharetra, enim ut sodales luctus, lectus arcu rhoncus purus, in fringilla augue elit vel lacus. In hac habitasse platea dictumst. Aliquam erat volutpat. Fusce iaculis elit id tellus. Ut accumsan malesuada turpis. Suspendisse potenti. Vestibulum lacus augue, lobortis mattis, laoreet in, varius at, nisi. Nunc gravida. Phasellus faucibus. In hac habitasse platea dictumst. Integer tempor lacus eget lectus. Praesent fringilla augue fringilla dui.', NULL, NULL, NULL, NULL),
(4, 'Terms & Conditions', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed at ante. Mauris eleifend, quam a vulputate dictum, massa quam dapibus leo, eget vulputate orci purus ut lorem. In fringilla mi in ligula. Pellentesque aliquam quam vel dolor. Nunc adipiscing. Sed quam odio, tempus ac, aliquam molestie, varius ac, tellus. Vestibulum ut nulla aliquam risus rutrum interdum. Pellentesque lorem. Curabitur sit amet erat quis risus feugiat viverra. Pellentesque augue justo, sagittis et, lacinia at, venenatis non, arcu. Nunc nec libero. In cursus dictum risus. Etiam tristique nisl a nulla. Ut a orci. Curabitur dolor nunc, egestas at, accumsan at, malesuada nec, magna.<br>\nNulla facilisi. Nunc volutpat. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Ut sit amet orci vel mauris blandit vehicula. Nullam quis enim. Integer dignissim viverra velit. Curabitur in odio. In hac habitasse platea dictumst. Ut consequat, tellus eu volutpat varius, justo orci elementum dolor, sed imperdiet nulla tellus ut diam. Vestibulum ipsum ante, malesuada quis, tempus ac, placerat sit amet, elit.<br>\nSed eget turpis a pede tempor malesuada. Vivamus quis mi at leo pulvinar hendrerit. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Pellentesque aliquet lacus vitae pede. Nullam mollis dolor ac nisi. Phasellus sit amet urna. Praesent pellentesque sapien sed lacus. Donec lacinia odio in odio. In sit amet elit. Maecenas gravida interdum urna. Integer pretium, arcu vitae imperdiet facilisis, elit tellus tempor nisi, vel feugiat ante velit sit amet mauris. Vivamus arcu. Integer pharetra magna ac lacus. Aliquam vitae sapien in nibh vehicula auctor. Suspendisse leo mauris, pulvinar sed, tempor et, consequat ac, lacus. Proin velit. Nulla semper lobortis mauris. Duis urna erat, ornare et, imperdiet eu, suscipit sit amet, massa. Nulla nulla nisi, pellentesque at, egestas quis, fringilla eu, diam.<br>\nDonec semper, sem nec tristique tempus, justo neque commodo nisl, ut gravida sem tellus suscipit nunc. Aliquam erat volutpat. Ut tincidunt pretium elit. Aliquam pulvinar. Nulla cursus. Suspendisse potenti. Etiam condimentum hendrerit felis. Duis iaculis aliquam enim. Donec dignissim augue vitae orci. Curabitur luctus felis a metus. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. In varius neque at enim. Suspendisse massa nulla, viverra in, bibendum vitae, tempor quis, lorem.<br>\nDonec dapibus orci sit amet elit. Maecenas rutrum ultrices lectus. Aliquam suscipit, lacus a iaculis adipiscing, eros orci pellentesque nisl, non pharetra dolor urna nec dolor. Integer cursus dolor vel magna. Integer ultrices feugiat sem. Proin nec nibh. Duis eu dui quis nunc sagittis lobortis. Fusce pharetra, enim ut sodales luctus, lectus arcu rhoncus purus, in fringilla augue elit vel lacus. In hac habitasse platea dictumst. Aliquam erat volutpat. Fusce iaculis elit id tellus. Ut accumsan malesuada turpis. Suspendisse potenti. Vestibulum lacus augue, lobortis mattis, laoreet in, varius at, nisi. Nunc gravida. Phasellus faucibus. In hac habitasse platea dictumst. Integer tempor lacus eget lectus. Praesent fringilla augue fringilla dui.', '2025-01-04', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 1, 0, 4, NULL, NULL, NULL, NULL, NULL, NULL, 'terms', 1, NULL, '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Terms & Conditions', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed at ante. Mauris eleifend, quam a vulputate dictum, massa quam dapibus leo, eget vulputate orci purus ut lorem. In fringilla mi in ligula. Pellentesque aliquam quam vel dolor. Nunc adipiscing. Sed quam odio, tempus ac, aliquam molestie, varius ac, tellus. Vestibulum ut nulla aliquam risus rutrum interdum. Pellentesque lorem. Curabitur sit amet erat quis risus feugiat viverra. Pellentesque augue justo, sagittis et, lacinia at, venenatis non, arcu. Nunc nec libero. In cursus dictum risus. Etiam tristique nisl a nulla. Ut a orci. Curabitur dolor nunc, egestas at, accumsan at, malesuada nec, magna.<br>\nNulla facilisi. Nunc volutpat. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Ut sit amet orci vel mauris blandit vehicula. Nullam quis enim. Integer dignissim viverra velit. Curabitur in odio. In hac habitasse platea dictumst. Ut consequat, tellus eu volutpat varius, justo orci elementum dolor, sed imperdiet nulla tellus ut diam. Vestibulum ipsum ante, malesuada quis, tempus ac, placerat sit amet, elit.<br>\nSed eget turpis a pede tempor malesuada. Vivamus quis mi at leo pulvinar hendrerit. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Pellentesque aliquet lacus vitae pede. Nullam mollis dolor ac nisi. Phasellus sit amet urna. Praesent pellentesque sapien sed lacus. Donec lacinia odio in odio. In sit amet elit. Maecenas gravida interdum urna. Integer pretium, arcu vitae imperdiet facilisis, elit tellus tempor nisi, vel feugiat ante velit sit amet mauris. Vivamus arcu. Integer pharetra magna ac lacus. Aliquam vitae sapien in nibh vehicula auctor. Suspendisse leo mauris, pulvinar sed, tempor et, consequat ac, lacus. Proin velit. Nulla semper lobortis mauris. Duis urna erat, ornare et, imperdiet eu, suscipit sit amet, massa. Nulla nulla nisi, pellentesque at, egestas quis, fringilla eu, diam.<br>\nDonec semper, sem nec tristique tempus, justo neque commodo nisl, ut gravida sem tellus suscipit nunc. Aliquam erat volutpat. Ut tincidunt pretium elit. Aliquam pulvinar. Nulla cursus. Suspendisse potenti. Etiam condimentum hendrerit felis. Duis iaculis aliquam enim. Donec dignissim augue vitae orci. Curabitur luctus felis a metus. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. In varius neque at enim. Suspendisse massa nulla, viverra in, bibendum vitae, tempor quis, lorem.<br>\nDonec dapibus orci sit amet elit. Maecenas rutrum ultrices lectus. Aliquam suscipit, lacus a iaculis adipiscing, eros orci pellentesque nisl, non pharetra dolor urna nec dolor. Integer cursus dolor vel magna. Integer ultrices feugiat sem. Proin nec nibh. Duis eu dui quis nunc sagittis lobortis. Fusce pharetra, enim ut sodales luctus, lectus arcu rhoncus purus, in fringilla augue elit vel lacus. In hac habitasse platea dictumst. Aliquam erat volutpat. Fusce iaculis elit id tellus. Ut accumsan malesuada turpis. Suspendisse potenti. Vestibulum lacus augue, lobortis mattis, laoreet in, varius at, nisi. Nunc gravida. Phasellus faucibus. In hac habitasse platea dictumst. Integer tempor lacus eget lectus. Praesent fringilla augue fringilla dui.', NULL, NULL, NULL, NULL),
(5, 'Home Welcome', '<div style=\"text-align: center\"><h1><br></h1></div>', '2025-01-04', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 1, 0, 5, NULL, NULL, NULL, NULL, NULL, NULL, 'home', 1, 1, '2025-01-04 09:15:30', '2025-01-04 09:22:21', 'Home Welcome', '<div style=\"text-align: center\"><h1><br></h1></div>', NULL, NULL, NULL, NULL),
(123, 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod - Copy', '<div dir=\"ltr\"><div dir=\"ltr\">Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod</div><div dir=\"ltr\">tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam,</div><div dir=\"ltr\">quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo</div><div dir=\"ltr\">consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse</div><div dir=\"ltr\">cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non</div><div dir=\"ltr\">proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</div></div>', '2025-01-05', NULL, NULL, '17360676288022.jpg', NULL, NULL, NULL, NULL, 1, 1, 7, 0, 1, NULL, NULL, NULL, 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod - Copy', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmodtempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam,quis nostrud exer', NULL, 'lorem-ipsum-dolor-sit-amet,-consectetur-adipisicing-elit,-sed-do-eiusmod-2', 1, 1, '2025-01-05 03:56:54', '2025-01-05 04:00:28', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod - Copy', '<div dir=\"ltr\"><div dir=\"ltr\">Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod</div><div dir=\"ltr\">tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam,</div><div dir=\"ltr\">quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo</div><div dir=\"ltr\">consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse</div><div dir=\"ltr\">cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non</div><div dir=\"ltr\">proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</div></div>', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod - Copy', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmodtempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam,quis nostrud exer', NULL, 'lorem-ipsum-dolor-sit-amet,-consectetur-adipisicing-elit,-sed-do-eiusmod-2'),
(124, 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod', '<div dir=\"ltr\"><div dir=\"ltr\">Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod</div><div dir=\"ltr\">tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam,</div><div dir=\"ltr\">quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo</div><div dir=\"ltr\">consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse</div><div dir=\"ltr\">cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non</div><div dir=\"ltr\">proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</div></div>', '2025-01-05', NULL, NULL, 'c17360676288022.jpg', NULL, NULL, NULL, NULL, 1, 1, 7, 0, 1, NULL, NULL, NULL, 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod - Copy - Copy', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmodtempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam,quis nostrud exer', NULL, 'lorem-ipsum-dolor-sit-amet,-consectetur-adipisicing-elit,-sed-do-eiusmod-copy', 1, 1, '2025-01-05 04:01:23', '2025-01-05 04:03:08', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod', '<div dir=\"ltr\"><div dir=\"ltr\">Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod</div><div dir=\"ltr\">tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam,</div><div dir=\"ltr\">quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo</div><div dir=\"ltr\">consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse</div><div dir=\"ltr\">cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non</div><div dir=\"ltr\">proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</div></div>', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod - Copy - Copy', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmodtempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam,quis nostrud exer', NULL, 'lorem-ipsum-dolor-sit-amet,-consectetur-adipisicing-elit,-sed-do-eiusmod-copy'),
(125, 'Centre for Policy Research in Agriculture and Rural Development', '<body id=\"ixb5\"><img src=\"https://static.vecteezy.com/system/resources/previews/037/980/818/non_2x/ai-generated-top-aerial-view-of-green-fields-and-meadows-landscape-with-lines-of-fields-grass-trees-indicating-healthy-crop-growth-ai-generated-free-photo.jpg\" class=\"img-fluid\"/><div class=\"container\"><h1>Bootstrap heading</h1><p id=\"i9vws\">Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. <br/><br/>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p><ul role=\"tablist\" class=\"nav nav-tabs\"><li class=\"nav-item\"><a id=\"home-tab\" data-toggle=\"tab\" href=\"#home\" role=\"tab\" aria-controls=\"home\" aria-selected=\"true\" class=\"nav-link active\">Tab 1</a></li><li class=\"nav-item\"><a id=\"profile-tab\" data-toggle=\"tab\" href=\"#profile\" role=\"tab\" aria-controls=\"profile\" aria-selected=\"false\" class=\"nav-link\">Tab 2</a></li><li class=\"nav-item\"><a id=\"contact-tab\" data-toggle=\"tab\" href=\"#contact\" role=\"tab\" aria-controls=\"contact\" aria-selected=\"false\" class=\"nav-link\">Tab 3</a></li></ul><div class=\"tab-content\"><div id=\"home\" role=\"tabpanel\" aria-labelledby=\"home-tab\" class=\"tab-pane fade show active\"><iframe allowfullscreen=\"allowfullscreen\" id=\"itrvm\" src=\"https://www.youtube.com/embed/KxOQyIuOL5A?&loop=1&playlist=KxOQyIuOL5A&modestbranding=1\"></iframe></div><div id=\"profile\" role=\"tabpanel\" aria-labelledby=\"profile-tab\" class=\"tab-pane fade\"><p id=\"ikg2a\">Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. <br/><br/>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p></div><div id=\"contact\" role=\"tabpanel\" aria-labelledby=\"contact-tab\" class=\"tab-pane fade\"><iframe allowfullscreen=\"allowfullscreen\" id=\"i8sm6\" src=\"https://www.youtube.com/embed/KxOQyIuOL5A?&loop=1&playlist=KxOQyIuOL5A&modestbranding=1\"></iframe></div></div></div></body><style>* { box-sizing: border-box; } body {margin: 0;}.img-fluid{width:100%;height:300px;margin:0 0 10px 0;}.container{padding:20px 0 0 0;}.tab-pane.fade.show.active{padding:20px 20px 20px 20px;}#i9vws{text-align:justify;}#itrvm{height:350px;width:615px;text-align:center;}.nav.nav-pills{margin:20px 0 0 0;}#ikg2a{text-align:justify;}#i8sm6{height:350px;width:615px;text-align:center;}</style>', '2025-01-05', NULL, NULL, '17363337735913.png', NULL, NULL, NULL, NULL, 1, 54, 15, 0, 1, NULL, NULL, NULL, 'Centre for Policy Research in Agriculture and Rural Development', '', NULL, 'centre-for-policy-research-in-agriculture-and-rural-development', 1, 1, '2025-01-05 04:08:21', '2025-01-08 05:56:13', 'Centre for Policy Research in Agriculture and Rural Development', '<div dir=ltr><br></div>', 'Centre for Policy Research in Agriculture and Rural Development', '', NULL, 'centre-for-policy-research-in-agriculture-and-rural-development'),
(126, 'Research in Agriculture and Rural Development', '<body id=\"ixb5\"><img src=\"https://static.vecteezy.com/system/resources/previews/037/980/818/non_2x/ai-generated-top-aerial-view-of-green-fields-and-meadows-landscape-with-lines-of-fields-grass-trees-indicating-healthy-crop-growth-ai-generated-free-photo.jpg\" class=\"img-fluid\"/><div class=\"container\"><h1>Bootstrap heading</h1><p id=\"i9vws\">Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. <br/><br/>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p><ul role=\"tablist\" class=\"nav nav-tabs\"><li class=\"nav-item\"><a id=\"home-tab\" data-toggle=\"tab\" href=\"#home\" role=\"tab\" aria-controls=\"home\" aria-selected=\"true\" class=\"nav-link active\">Tab 1</a></li><li class=\"nav-item\"><a id=\"profile-tab\" data-toggle=\"tab\" href=\"#profile\" role=\"tab\" aria-controls=\"profile\" aria-selected=\"false\" class=\"nav-link\">Tab 2</a></li><li class=\"nav-item\"><a id=\"contact-tab\" data-toggle=\"tab\" href=\"#contact\" role=\"tab\" aria-controls=\"contact\" aria-selected=\"false\" class=\"nav-link\">Tab 3</a></li></ul><div class=\"tab-content\"><div id=\"home\" role=\"tabpanel\" aria-labelledby=\"home-tab\" class=\"tab-pane fade show active\"><iframe allowfullscreen=\"allowfullscreen\" id=\"itrvm\" src=\"https://www.youtube.com/embed/KxOQyIuOL5A?&loop=1&playlist=KxOQyIuOL5A&modestbranding=1\"></iframe></div><div id=\"profile\" role=\"tabpanel\" aria-labelledby=\"profile-tab\" class=\"tab-pane fade\"><p id=\"ikg2a\">Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. <br/><br/>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p></div><div id=\"contact\" role=\"tabpanel\" aria-labelledby=\"contact-tab\" class=\"tab-pane fade\"><iframe allowfullscreen=\"allowfullscreen\" id=\"i8sm6\" src=\"https://www.youtube.com/embed/KxOQyIuOL5A?&loop=1&playlist=KxOQyIuOL5A&modestbranding=1\"></iframe></div></div></div></body><style>* { box-sizing: border-box; } body {margin: 0;}.img-fluid{width:100%;height:300px;margin:0 0 10px 0;}.container{padding:20px 0 0 0;}.tab-pane.fade.show.active{padding:20px 20px 20px 20px;}#i9vws{text-align:justify;}#itrvm{height:350px;width:615px;text-align:center;}.nav.nav-pills{margin:20px 0 0 0;}#ikg2a{text-align:justify;}#i8sm6{height:350px;width:615px;text-align:center;}</style>', '2025-01-05', NULL, NULL, 'c17363337735913.png', NULL, NULL, NULL, NULL, 1, 0, 15, 0, 1, NULL, NULL, NULL, 'Centre for Policy Research in Agriculture and Rural Development - Copy', '', NULL, 'centre-for-policy-research-in-agriculture-and-rural-development-1', 1, 1, '2025-01-08 06:12:10', '2025-01-08 06:13:37', 'Research in Agriculture and Rural Development', '<div dir=ltr><br></div>', 'Centre for Policy Research in Agriculture and Rural Development - Copy', '', NULL, 'centre-for-policy-research-in-agriculture-and-rural-development-1'),
(127, 'Agriculture and Rural Development', '<body id=\"ixb5\"><img src=\"https://static.vecteezy.com/system/resources/previews/037/980/818/non_2x/ai-generated-top-aerial-view-of-green-fields-and-meadows-landscape-with-lines-of-fields-grass-trees-indicating-healthy-crop-growth-ai-generated-free-photo.jpg\" class=\"img-fluid\"/><div class=\"container\"><h1>Bootstrap heading</h1><p id=\"i9vws\">Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. <br/><br/>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p><ul role=\"tablist\" class=\"nav nav-tabs\"><li class=\"nav-item\"><a id=\"home-tab\" data-toggle=\"tab\" href=\"#home\" role=\"tab\" aria-controls=\"home\" aria-selected=\"true\" class=\"nav-link active\">Tab 1</a></li><li class=\"nav-item\"><a id=\"profile-tab\" data-toggle=\"tab\" href=\"#profile\" role=\"tab\" aria-controls=\"profile\" aria-selected=\"false\" class=\"nav-link\">Tab 2</a></li><li class=\"nav-item\"><a id=\"contact-tab\" data-toggle=\"tab\" href=\"#contact\" role=\"tab\" aria-controls=\"contact\" aria-selected=\"false\" class=\"nav-link\">Tab 3</a></li></ul><div class=\"tab-content\"><div id=\"home\" role=\"tabpanel\" aria-labelledby=\"home-tab\" class=\"tab-pane fade show active\"><iframe allowfullscreen=\"allowfullscreen\" id=\"itrvm\" src=\"https://www.youtube.com/embed/KxOQyIuOL5A?&loop=1&playlist=KxOQyIuOL5A&modestbranding=1\"></iframe></div><div id=\"profile\" role=\"tabpanel\" aria-labelledby=\"profile-tab\" class=\"tab-pane fade\"><p id=\"ikg2a\">Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. <br/><br/>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p></div><div id=\"contact\" role=\"tabpanel\" aria-labelledby=\"contact-tab\" class=\"tab-pane fade\"><iframe allowfullscreen=\"allowfullscreen\" id=\"i8sm6\" src=\"https://www.youtube.com/embed/KxOQyIuOL5A?&loop=1&playlist=KxOQyIuOL5A&modestbranding=1\"></iframe></div></div></div></body><style>* { box-sizing: border-box; } body {margin: 0;}.img-fluid{width:100%;height:300px;margin:0 0 10px 0;}.container{padding:20px 0 0 0;}.tab-pane.fade.show.active{padding:20px 20px 20px 20px;}#i9vws{text-align:justify;}#itrvm{height:350px;width:615px;text-align:center;}.nav.nav-pills{margin:20px 0 0 0;}#ikg2a{text-align:justify;}#i8sm6{height:350px;width:615px;text-align:center;}</style>', '2025-01-05', NULL, NULL, 'cc17363337735913.png', NULL, NULL, NULL, NULL, 1, 0, 15, 0, 1, NULL, NULL, NULL, 'Centre for Policy Research in Agriculture and Rural Development - Copy - Copy', '', NULL, 'centre-for-policy-research-in-agriculture-and-rural-development-copy', 1, 1, '2025-01-08 06:12:30', '2025-01-08 06:13:10', 'Agriculture and Rural Development', '<div dir=ltr><br></div>', 'Centre for Policy Research in Agriculture and Rural Development - Copy - Copy', '', NULL, 'centre-for-policy-research-in-agriculture-and-rural-development-copy');
INSERT INTO `smartend_topics` (`id`, `title_en`, `details_en`, `date`, `expire_date`, `video_type`, `photo_file`, `attach_file`, `video_file`, `audio_file`, `icon`, `status`, `visits`, `webmaster_id`, `section_id`, `row_no`, `form_id`, `popup_id`, `topic_id`, `seo_title_en`, `seo_description_en`, `seo_keywords_en`, `seo_url_slug_en`, `created_by`, `updated_by`, `created_at`, `updated_at`, `title_km`, `details_km`, `seo_title_km`, `seo_description_km`, `seo_keywords_km`, `seo_url_slug_km`) VALUES
(129, 'Enhancing the Collaboration between TVET Institutions and the Private Sector in Cambodia: Implications for Skills Provision', '<body><div class=\"row\"><div data-type=\"container-content\" class=\"col-sm-12 ui-resizable\"><div data-type=\"component-text\"><div dir=\"ltr\"><h5 id=\"izms\"><span id=\"ig22\">Abstract/Summary</span></h5><p id=\"ixdee\">Collaboration with the private sector has been an influential tool in addressing a variety of complex issues or problems in both developed and developing economies around the globe. Like many countries, Cambodia has strongly promoted collaboration with the private sector across all education sectors. In the Cambodian TVET sector, the Royal Government of Cambodia has emphasised public-private partnerships (PPP) in its national TVET Policy 2017-2025 and Skills Development Roadmap 2023-2035. Such collaboration can make TVET more industry-relevant by increasing the private sector’s role, duties, and participation in Cambodia’s workforce skills development by strengthening and expanding the linkage between training providers and companies nationwide. TVET institutions often highly value their collaborative activities with the private sector. However, there is still scepticism about the forms, benefits, and degrees of collaboration between training providers and private companies. In this respect, ramping up research into private-sector collaboration in the Cambodian TVET sector is timely. To that end, this study aims to investigate different forms, benefits, and degrees of collaboration between training providers and the private sector. It also examines the challenges training providers face in collaboration with the private sector. An exploration of the perspectives of key stakeholders regarding collaboration gives insights into the under-researched collaborations within the context of the Cambodian TVET sector. The evidence from the study enables training providers, policymakers, practitioners, and relevant stakeholders to address collaboration issues and further build and strengthen collaboration efforts to align skills provision with industrial skills needs. </p><p id=\"iqupg\">The study is based on a qualitative analysis of the data from the “Skills for Industry” project. The phase-1 data includes 36 interviews with 18 case-study companies. The phase-2 data comprises 36 interviews with 20 training providers, nine government bodies, four industry associations, and three labour unions. The study adopted a qualitative content analysis approach to analyse different perspectives of key stakeholders on collaboration-related aspects. A qualitative data matrix using an Excel programme enabled the collation of relevant data and information corresponding to codes and themes predefined and emerging during the analysis stage.</p><p id=\"ir2ff\">The study found that training providers use different identified forms of collaboration with the private sector. These included student internships, job announcement dissemination, participation in curriculum development, consultative meetings/workshops, workplace visits/tours, the provision of industrial skills training, and joint engagement in research and development activities. These collaborative activities benefited training providers and employers, explicitly and implicitly. The benefits included collection of input for increasing the relevance of newly developed or updated curriculum development/update to meet industrial skills needs; knowledge and skills transfer; access to advanced training facilities, equipment, tools, and materials; and funding for training-related research and development activities. Most training providers had conducted collaborative activities, though these were limited to student internships, job announcement dissemination, participation in curriculum development, consultative meetings/workshops, and workplace visits/tours, commonly executed less regularly and ad hoc, making collaboration efforts less effective and sustainable. Some forms of collaborative activities, like the provision of industrial skills training and joint research and development activities, were relatively small-scale or even absent. As repeatedly reported by various training providers, collaborations could not be built, strengthened or intensified due to several key factors. These factors were insufficient critical conditions including the availability of funding, the capacity of institutions and instructors, the extent of trust in the relevance and quality of TVET programmes, the extent of integration with action plans and implementation, the extent of legal enforcement of frameworks and policies supporting collaboration, and the perception of mutual benefits for the parties. These conditions affected the scope and quality of collaboration with private companies.</p><p id=\"iob91\">Based on the findings, the study advances the following recommendations for training providers, policymakers, practitioners, and relevant stakeholders for consideration when building and implementing collaborations with one another.</p><ul id=\"idb8h\"><li id=\"iq1lf\">Ensure mutual benefits between collaborators or stakeholders: All stakeholders, especially training providers and companies, should openly discuss their concerns, needs, and expectations when collaborating. Identifying both explicit and implicit advantages is essential to ensure all parties concur on and commit to formal agreements. Formal agreements should clearly define the level of formalisation, co-decision-making, goals, resource sharing, and other key actors in the collaboration.</li><li id=\"i202e\">Strengthen institutional and instructor capacity: Training providers need to enhance their institutional capacities and resources to ensure that training outcomes are aligned with industrial skills needs. Instructors need to improve their skills through professional development and hands-on training at partner companies. TVET institutions also require further support from the government and stakeholders to better anticipate and develop skills required by the labour market.</li><li id=\"i5bpp\">Enforce supportive frameworks and policies for collaborations: It is essential to formulate and enforce clear legal frameworks, policies, or guidelines with full support for the school-industry cooperation. The government and industry associations should facilitate such cooperation by identifying incentives (tax/levy exemptions or special conditions) for employers who voluntarily collaborate with training providers. Additionally, a monitoring and evaluation system should be implemented to track the progress of these collaborations at the national level.</li><li id=\"il7qd\">Streamline collaboration activities through full integration and implementation: Training providers need to fully integrate the collaboration efforts into their school action plan and implementation. Establishing an industrial liaison unit (ILU) with a clear direction, action plan, and adequate resources can strengthen ties with the private sector. ILUs should consult with all relevant stakeholders, including instructors and employers, to ensure effective and consistent implementation that fosters their collaboration with the private sector.</li></ul></div></div></div></div></body><style>* { box-sizing: border-box; } body {margin: 0;}*{box-sizing:border-box;}body{margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;}*{box-sizing:border-box;}body{margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;}#izms{box-sizing:border-box;margin-right:0px;margin-bottom:15px;margin-left:0px;line-height:1.2;font-family:Roboto, sans-serif;color:rgb(33, 37, 41);background-color:rgb(236, 236, 236);}#ig22{box-sizing:border-box;font-weight:bolder;}#ixdee{box-sizing:border-box;margin-right:0px;margin-bottom:15px;margin-left:0px;color:rgb(51, 51, 51);font-size:14px;font-family:Roboto, sans-serif;background-color:rgb(236, 236, 236);}#iqupg{box-sizing:border-box;margin-right:0px;margin-bottom:15px;margin-left:0px;color:rgb(51, 51, 51);font-size:14px;font-family:Roboto, sans-serif;background-color:rgb(236, 236, 236);}#ir2ff{box-sizing:border-box;margin-right:0px;margin-bottom:15px;margin-left:0px;color:rgb(51, 51, 51);font-size:14px;font-family:Roboto, sans-serif;background-color:rgb(236, 236, 236);}#iob91{box-sizing:border-box;margin-right:0px;margin-bottom:15px;margin-left:0px;color:rgb(51, 51, 51);font-size:14px;font-family:Roboto, sans-serif;background-color:rgb(236, 236, 236);}#idb8h{box-sizing:border-box;color:rgb(33, 37, 41);font-family:Roboto, sans-serif;font-size:14px;background-color:rgb(236, 236, 236);}#iq1lf{box-sizing:border-box;}#i202e{box-sizing:border-box;}#i5bpp{box-sizing:border-box;}#il7qd{box-sizing:border-box;}</style>', '2025-01-08', NULL, NULL, '17363544946358.jpeg', '17363544943368.pdf', NULL, NULL, NULL, 1, 1, 16, 0, 2, NULL, NULL, NULL, 'Enhancing the Collaboration between TVET Institutions and the Private Sector in Cambodia: Implications for Skills Provision', 'Abstract/SummaryCollaboration with the private sector has been an influential tool in addressing a variety of complex issues or problems in both developed and develo', NULL, 'enhancing-the-collaboration-between-tvet-institutions-and-the-private-sector-in-cambodia:-implications-for-skills-provision-1', 1, 1, '2025-01-08 11:41:36', '2025-01-08 13:05:12', 'Enhancing the Collaboration between TVET Institutions and the Private Sector in Cambodia: Implications for Skills Provision', '<div dir=\"ltr\"><h5 style=\"box-sizing: border-box; margin-right: 0px; margin-bottom: 15px; margin-left: 0px; line-height: 1.2; font-family: Roboto, sans-serif; color: rgb(33, 37, 41); background-color: rgb(236, 236, 236);\"><span style=\"box-sizing: border-box; font-weight: bolder;\">Abstract/Summary</span></h5><p style=\"box-sizing: border-box; margin-right: 0px; margin-bottom: 15px; margin-left: 0px; color: rgb(51, 51, 51); font-size: 14px; font-family: Roboto, sans-serif; background-color: rgb(236, 236, 236);\">Collaboration with the private sector has been an influential tool in addressing a variety of complex issues or problems in both developed and developing economies around the globe. Like many countries, Cambodia has strongly promoted collaboration with the private sector across all education sectors. In the Cambodian TVET sector, the Royal Government of Cambodia has emphasised public-private partnerships (PPP) in its national TVET Policy 2017-2025 and Skills Development Roadmap 2023-2035. Such collaboration can make TVET more industry-relevant by increasing the private sector’s role, duties, and participation in Cambodia’s workforce skills development by strengthening and expanding the linkage between training providers and companies nationwide. TVET institutions often highly value their collaborative activities with the private sector. However, there is still scepticism about the forms, benefits, and degrees of collaboration between training providers and private companies. In this respect, ramping up research into private-sector collaboration in the Cambodian TVET sector is timely. To that end, this study aims to investigate different forms, benefits, and degrees of collaboration between training providers and the private sector. It also examines the challenges training providers face in collaboration with the private sector. An exploration of the perspectives of key stakeholders regarding collaboration gives insights into the under-researched collaborations within the context of the Cambodian TVET sector. The evidence from the study enables training providers, policymakers, practitioners, and relevant stakeholders to address collaboration issues and further build and strengthen collaboration efforts to align skills provision with industrial skills needs. </p><p style=\"box-sizing: border-box; margin-right: 0px; margin-bottom: 15px; margin-left: 0px; color: rgb(51, 51, 51); font-size: 14px; font-family: Roboto, sans-serif; background-color: rgb(236, 236, 236);\">The study is based on a qualitative analysis of the data from the “Skills for Industry” project. The phase-1 data includes 36 interviews with 18 case-study companies. The phase-2 data comprises 36 interviews with 20 training providers, nine government bodies, four industry associations, and three labour unions. The study adopted a qualitative content analysis approach to analyse different perspectives of key stakeholders on collaboration-related aspects. A qualitative data matrix using an Excel programme enabled the collation of relevant data and information corresponding to codes and themes predefined and emerging during the analysis stage.</p><p style=\"box-sizing: border-box; margin-right: 0px; margin-bottom: 15px; margin-left: 0px; color: rgb(51, 51, 51); font-size: 14px; font-family: Roboto, sans-serif; background-color: rgb(236, 236, 236);\">The study found that training providers use different identified forms of collaboration with the private sector. These included student internships, job announcement dissemination, participation in curriculum development, consultative meetings/workshops, workplace visits/tours, the provision of industrial skills training, and joint engagement in research and development activities. These collaborative activities benefited training providers and employers, explicitly and implicitly. The benefits included collection of input for increasing the relevance of newly developed or updated curriculum development/update to meet industrial skills needs; knowledge and skills transfer; access to advanced training facilities, equipment, tools, and materials; and funding for training-related research and development activities. Most training providers had conducted collaborative activities, though these were limited to student internships, job announcement dissemination, participation in curriculum development, consultative meetings/workshops, and workplace visits/tours, commonly executed less regularly and ad hoc, making collaboration efforts less effective and sustainable. Some forms of collaborative activities, like the provision of industrial skills training and joint research and development activities, were relatively small-scale or even absent. As repeatedly reported by various training providers, collaborations could not be built, strengthened or intensified due to several key factors. These factors were insufficient critical conditions including the availability of funding, the capacity of institutions and instructors, the extent of trust in the relevance and quality of TVET programmes, the extent of integration with action plans and implementation, the extent of legal enforcement of frameworks and policies supporting collaboration, and the perception of mutual benefits for the parties. These conditions affected the scope and quality of collaboration with private companies.</p><p style=\"box-sizing: border-box; margin-right: 0px; margin-bottom: 15px; margin-left: 0px; color: rgb(51, 51, 51); font-size: 14px; font-family: Roboto, sans-serif; background-color: rgb(236, 236, 236);\">Based on the findings, the study advances the following recommendations for training providers, policymakers, practitioners, and relevant stakeholders for consideration when building and implementing collaborations with one another.</p><ul style=\"box-sizing: border-box; color: rgb(33, 37, 41); font-family: Roboto, sans-serif; font-size: 14px; background-color: rgb(236, 236, 236);\"><li style=\"box-sizing: border-box;\">Ensure mutual benefits between collaborators or stakeholders: All stakeholders, especially training providers and companies, should openly discuss their concerns, needs, and expectations when collaborating. Identifying both explicit and implicit advantages is essential to ensure all parties concur on and commit to formal agreements. Formal agreements should clearly define the level of formalisation, co-decision-making, goals, resource sharing, and other key actors in the collaboration.</li><li style=\"box-sizing: border-box;\">Strengthen institutional and instructor capacity: Training providers need to enhance their institutional capacities and resources to ensure that training outcomes are aligned with industrial skills needs. Instructors need to improve their skills through professional development and hands-on training at partner companies. TVET institutions also require further support from the government and stakeholders to better anticipate and develop skills required by the labour market.</li><li style=\"box-sizing: border-box;\">Enforce supportive frameworks and policies for collaborations: It is essential to formulate and enforce clear legal frameworks, policies, or guidelines with full support for the school-industry cooperation. The government and industry associations should facilitate such cooperation by identifying incentives (tax/levy exemptions or special conditions) for employers who voluntarily collaborate with training providers. Additionally, a monitoring and evaluation system should be implemented to track the progress of these collaborations at the national level.</li><li style=\"box-sizing: border-box;\">Streamline collaboration activities through full integration and implementation: Training providers need to fully integrate the collaboration efforts into their school action plan and implementation. Establishing an industrial liaison unit (ILU) with a clear direction, action plan, and adequate resources can strengthen ties with the private sector. ILUs should consult with all relevant stakeholders, including instructors and employers, to ensure effective and consistent implementation that fosters their collaboration with the private sector.</li></ul></div>', 'Enhancing the Collaboration between TVET Institutions and the Private Sector in Cambodia: Implications for Skills Provision', 'Abstract/SummaryCollaboration with the private sector has been an influential tool in addressing a variety of complex issues or problems in both developed and develo', NULL, 'enhancing-the-collaboration-between-tvet-institutions-and-the-private-sector-in-cambodia:-implications-for-skills-provision-1'),
(130, 'Lifting Barriers: Educated Boys for Gender Equality', '<div dir=\"ltr\"><span style=\"box-sizing: border-box; font-weight: bolder; color: rgb(33, 37, 41); font-family: Roboto, sans-serif; font-size: 14px;\"><span class=\"project-desc\" style=\"box-sizing: border-box; font-size: 20px !important; color: rgb(51, 102, 102);\">Project Description</span></span><span style=\"color: rgb(33, 37, 41); font-family: Roboto, sans-serif; font-size: 14px;\"></span><hr style=\"height: 1px; margin: 0px 0px 1em; border-top-color: rgb(204, 204, 204); padding: 0px; color: rgb(33, 37, 41); font-family: Roboto, sans-serif; font-size: 14px;\"><span style=\"color: rgb(33, 37, 41); font-family: Roboto, sans-serif; font-size: 14px;\">Gender norms and disparities in education impact both boys and girls. Globally, more boys are out of school, and their learning performances are also decreasing compared to girls. These issues affect educational attainment and societal gender equality. Cambodia recognises the importance of addressing gender disparities in education and has initiated efforts to understand and tackle the root causes of boys\' underperformance, aligning with global commitments to achieve gender parity and inclusive education. In light of this, and through collaboration between CDRI and UNESCO Cambodia, two research studies will be conducted.</span><br style=\"box-sizing: border-box; color: rgb(33, 37, 41); font-family: Roboto, sans-serif; font-size: 14px;\"><span style=\"box-sizing: border-box; font-weight: bolder; color: rgb(33, 37, 41); font-family: Roboto, sans-serif; font-size: 14px;\"><span class=\"project-desc\" style=\"box-sizing: border-box; font-size: 20px !important; color: rgb(51, 102, 102);\">Project Objective</span></span><span style=\"color: rgb(33, 37, 41); font-family: Roboto, sans-serif; font-size: 14px;\"></span><hr style=\"height: 1px; margin: 0px 0px 1em; border-top-color: rgb(204, 204, 204); padding: 0px; color: rgb(33, 37, 41); font-family: Roboto, sans-serif; font-size: 14px;\"><p style=\"box-sizing: border-box; margin-right: 0px; margin-bottom: 15px; margin-left: 0px; color: rgb(51, 51, 51); font-size: 14px; font-family: Roboto, sans-serif;\"><span style=\"box-sizing: border-box; font-weight: bolder;\">Study 1| Research on Innovation_Life Skill for Equality Project (LSEP) of Room to Read</span></p><ul style=\"box-sizing: border-box; color: rgb(33, 37, 41); font-family: Roboto, sans-serif; font-size: 14px;\"><li style=\"box-sizing: border-box;\">To determine the extent to which LSEP increased boys\' school engagement, learning, and the promotion of gender-equitable attitudes, values, and behaviours.</li><li style=\"box-sizing: border-box;\">To identify key components and enabling factors of LSEP effectiveness</li><li style=\"box-sizing: border-box;\">To explore the scaling potential and barriers of LSEP nationwide and in other countries</li></ul><p style=\"box-sizing: border-box; margin-right: 0px; margin-bottom: 15px; margin-left: 0px; color: rgb(51, 51, 51); font-size: 14px; font-family: Roboto, sans-serif;\"><span style=\"box-sizing: border-box; font-weight: bolder;\">Study 2| Boys’ Disengagement from Education_Cambodia Case Study</span></p><ul style=\"box-sizing: border-box; color: rgb(33, 37, 41); font-family: Roboto, sans-serif; font-size: 14px;\"><li style=\"box-sizing: border-box;\">To review the current situation related to boys’ educational participation, learning achievement, and completion.</li><li style=\"box-sizing: border-box;\">To identify and analyse the structural and gender-related determinants impacting boys’ educational outcomes at individual, familial, community, school, and societal levels.</li><li style=\"box-sizing: border-box;\">To document and evaluate promising policy and interventions aimed at improving boys’ educational outcomes, assessing their effectiveness in specific contexts and potential for wider application.</li></ul></div>', '2025-01-08', NULL, NULL, '17363578602112.jpeg', NULL, NULL, NULL, NULL, 1, 0, 17, 0, 1, NULL, NULL, NULL, 'Lifting Barriers: Educated Boys for Gender Equality', '', NULL, 'lifting-barriers:-educated-boys-for-gender-equality', 1, 1, '2025-01-08 12:36:27', '2025-01-08 12:37:40', 'Lifting Barriers: Educated Boys for Gender Equality', '<div dir=\"ltr\"><span style=\"box-sizing: border-box; font-weight: bolder; color: rgb(33, 37, 41); font-family: Roboto, sans-serif; font-size: 14px;\"><span class=\"project-desc\" style=\"box-sizing: border-box; font-size: 20px !important; color: rgb(51, 102, 102);\">Project Description</span></span><span style=\"color: rgb(33, 37, 41); font-family: Roboto, sans-serif; font-size: 14px;\"></span><hr style=\"height: 1px; margin: 0px 0px 1em; border-top-color: rgb(204, 204, 204); padding: 0px; color: rgb(33, 37, 41); font-family: Roboto, sans-serif; font-size: 14px;\"><span style=\"color: rgb(33, 37, 41); font-family: Roboto, sans-serif; font-size: 14px;\">Gender norms and disparities in education impact both boys and girls. Globally, more boys are out of school, and their learning performances are also decreasing compared to girls. These issues affect educational attainment and societal gender equality. Cambodia recognises the importance of addressing gender disparities in education and has initiated efforts to understand and tackle the root causes of boys\' underperformance, aligning with global commitments to achieve gender parity and inclusive education. In light of this, and through collaboration between CDRI and UNESCO Cambodia, two research studies will be conducted.</span><br style=\"box-sizing: border-box; color: rgb(33, 37, 41); font-family: Roboto, sans-serif; font-size: 14px;\"><span style=\"box-sizing: border-box; font-weight: bolder; color: rgb(33, 37, 41); font-family: Roboto, sans-serif; font-size: 14px;\"><span class=\"project-desc\" style=\"box-sizing: border-box; font-size: 20px !important; color: rgb(51, 102, 102);\">Project Objective</span></span><span style=\"color: rgb(33, 37, 41); font-family: Roboto, sans-serif; font-size: 14px;\"></span><hr style=\"height: 1px; margin: 0px 0px 1em; border-top-color: rgb(204, 204, 204); padding: 0px; color: rgb(33, 37, 41); font-family: Roboto, sans-serif; font-size: 14px;\"><p style=\"box-sizing: border-box; margin-right: 0px; margin-bottom: 15px; margin-left: 0px; color: rgb(51, 51, 51); font-size: 14px; font-family: Roboto, sans-serif;\"><span style=\"box-sizing: border-box; font-weight: bolder;\">Study 1| Research on Innovation_Life Skill for Equality Project (LSEP) of Room to Read</span></p><ul style=\"box-sizing: border-box; color: rgb(33, 37, 41); font-family: Roboto, sans-serif; font-size: 14px;\"><li style=\"box-sizing: border-box;\">To determine the extent to which LSEP increased boys\' school engagement, learning, and the promotion of gender-equitable attitudes, values, and behaviours.</li><li style=\"box-sizing: border-box;\">To identify key components and enabling factors of LSEP effectiveness</li><li style=\"box-sizing: border-box;\">To explore the scaling potential and barriers of LSEP nationwide and in other countries</li></ul><p style=\"box-sizing: border-box; margin-right: 0px; margin-bottom: 15px; margin-left: 0px; color: rgb(51, 51, 51); font-size: 14px; font-family: Roboto, sans-serif;\"><span style=\"box-sizing: border-box; font-weight: bolder;\">Study 2| Boys’ Disengagement from Education_Cambodia Case Study</span></p><ul style=\"box-sizing: border-box; color: rgb(33, 37, 41); font-family: Roboto, sans-serif; font-size: 14px;\"><li style=\"box-sizing: border-box;\">To review the current situation related to boys’ educational participation, learning achievement, and completion.</li><li style=\"box-sizing: border-box;\">To identify and analyse the structural and gender-related determinants impacting boys’ educational outcomes at individual, familial, community, school, and societal levels.</li><li style=\"box-sizing: border-box;\">To document and evaluate promising policy and interventions aimed at improving boys’ educational outcomes, assessing their effectiveness in specific contexts and potential for wider application.</li></ul></div>', 'Lifting Barriers: Educated Boys for Gender Equality', '', NULL, 'lifting-barriers:-educated-boys-for-gender-equality');

-- --------------------------------------------------------

--
-- Table structure for table `smartend_topic_categories`
--

CREATE TABLE `smartend_topic_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `topic_id` bigint(20) UNSIGNED NOT NULL,
  `section_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `smartend_topic_categories`
--

INSERT INTO `smartend_topic_categories` (`id`, `topic_id`, `section_id`, `created_at`, `updated_at`) VALUES
(72, 123, 30, '2025-01-05 04:00:29', '2025-01-05 04:00:29'),
(75, 124, 30, '2025-01-05 04:03:08', '2025-01-05 04:03:08'),
(80, 130, 32, '2025-01-08 12:38:39', '2025-01-08 12:38:39'),
(83, 129, 31, '2025-01-08 13:04:54', '2025-01-08 13:04:54');

-- --------------------------------------------------------

--
-- Table structure for table `smartend_topic_fields`
--

CREATE TABLE `smartend_topic_fields` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `topic_id` bigint(20) UNSIGNED NOT NULL,
  `field_id` bigint(20) UNSIGNED NOT NULL,
  `field_value` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `smartend_topic_tags`
--

CREATE TABLE `smartend_topic_tags` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `topic_id` bigint(20) UNSIGNED NOT NULL,
  `tag_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `smartend_webmails`
--

CREATE TABLE `smartend_webmails` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `cat_id` int(11) NOT NULL DEFAULT 0,
  `group_id` int(11) DEFAULT NULL,
  `contact_id` int(11) DEFAULT NULL,
  `father_id` int(11) DEFAULT NULL,
  `title` varchar(191) DEFAULT NULL,
  `details` longtext DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `from_email` varchar(191) DEFAULT NULL,
  `from_name` varchar(191) DEFAULT NULL,
  `from_phone` varchar(191) DEFAULT NULL,
  `to_email` varchar(191) DEFAULT NULL,
  `to_name` varchar(191) DEFAULT NULL,
  `to_cc` varchar(191) DEFAULT NULL,
  `to_bcc` varchar(191) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `flag` tinyint(4) NOT NULL DEFAULT 0,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `smartend_webmails_files`
--

CREATE TABLE `smartend_webmails_files` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `webmail_id` bigint(20) UNSIGNED NOT NULL,
  `file` varchar(191) DEFAULT NULL,
  `title` varchar(191) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `smartend_webmails_groups`
--

CREATE TABLE `smartend_webmails_groups` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) DEFAULT NULL,
  `color` varchar(191) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `smartend_webmails_groups`
--

INSERT INTO `smartend_webmails_groups` (`id`, `name`, `color`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, 'Support', '#00bcd4', 1, NULL, '2025-01-04 09:15:31', '2025-01-04 09:15:31'),
(2, 'Orders', '#f44336', 1, NULL, '2025-01-04 09:15:31', '2025-01-04 09:15:31'),
(3, 'Queries', '#8bc34a', 1, NULL, '2025-01-04 09:15:31', '2025-01-04 09:15:31');

-- --------------------------------------------------------

--
-- Table structure for table `smartend_webmaster_banners`
--

CREATE TABLE `smartend_webmaster_banners` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `row_no` int(11) NOT NULL DEFAULT 0,
  `title_en` varchar(191) DEFAULT NULL,
  `width` int(11) NOT NULL DEFAULT 0,
  `height` int(11) NOT NULL DEFAULT 0,
  `desc_status` tinyint(4) NOT NULL DEFAULT 0,
  `link_status` tinyint(4) NOT NULL DEFAULT 0,
  `type` tinyint(4) NOT NULL DEFAULT 0,
  `icon_status` tinyint(4) NOT NULL DEFAULT 0,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `title_km` varchar(191) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `smartend_webmaster_banners`
--

INSERT INTO `smartend_webmaster_banners` (`id`, `row_no`, `title_en`, `width`, `height`, `desc_status`, `link_status`, `type`, `icon_status`, `status`, `created_by`, `updated_by`, `created_at`, `updated_at`, `title_km`) VALUES
(1, 1, 'Home Banners', 1600, 600, 1, 1, 1, 0, 1, 1, NULL, '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Home Banners'),
(2, 2, 'Text Banners', 400, 400, 1, 1, 0, 1, 1, 1, NULL, '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Text Banners'),
(3, 3, 'Side Banners', 400, 400, 0, 1, 1, 0, 1, 1, NULL, '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Side Banners');

-- --------------------------------------------------------

--
-- Table structure for table `smartend_webmaster_sections`
--

CREATE TABLE `smartend_webmaster_sections` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `row_no` int(11) NOT NULL DEFAULT 0,
  `title_en` varchar(191) DEFAULT NULL,
  `type` tinyint(4) NOT NULL DEFAULT 0,
  `title_status` tinyint(4) NOT NULL DEFAULT 1,
  `photo_status` tinyint(4) NOT NULL DEFAULT 1,
  `tags_status` tinyint(4) NOT NULL DEFAULT 0,
  `case_status` tinyint(4) NOT NULL DEFAULT 1,
  `visits_status` tinyint(4) NOT NULL DEFAULT 1,
  `sections_status` tinyint(4) NOT NULL DEFAULT 0,
  `comments_status` tinyint(4) NOT NULL DEFAULT 0,
  `date_status` tinyint(4) NOT NULL DEFAULT 0,
  `expire_date_status` tinyint(4) NOT NULL DEFAULT 0,
  `longtext_status` tinyint(4) NOT NULL DEFAULT 0,
  `editor_status` tinyint(4) NOT NULL DEFAULT 0,
  `attach_file_status` tinyint(4) NOT NULL DEFAULT 0,
  `extra_attach_file_status` tinyint(4) NOT NULL DEFAULT 0,
  `multi_images_status` tinyint(4) NOT NULL DEFAULT 0,
  `section_icon_status` tinyint(4) NOT NULL DEFAULT 0,
  `icon_status` tinyint(4) NOT NULL DEFAULT 0,
  `maps_status` tinyint(4) NOT NULL DEFAULT 0,
  `order_status` tinyint(4) NOT NULL DEFAULT 0,
  `related_status` tinyint(4) NOT NULL DEFAULT 0,
  `seo_status` tinyint(4) NOT NULL DEFAULT 1,
  `no_status` tinyint(4) NOT NULL DEFAULT 1,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `seo_title_en` varchar(191) DEFAULT NULL,
  `seo_description_en` varchar(191) DEFAULT NULL,
  `seo_keywords_en` varchar(191) DEFAULT NULL,
  `seo_url_slug_en` varchar(191) DEFAULT NULL,
  `photo` varchar(191) DEFAULT NULL,
  `popup_id` int(11) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `title_km` varchar(191) DEFAULT NULL,
  `seo_title_km` varchar(191) DEFAULT NULL,
  `seo_description_km` varchar(191) DEFAULT NULL,
  `seo_keywords_km` varchar(191) DEFAULT NULL,
  `seo_url_slug_km` varchar(191) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `smartend_webmaster_sections`
--

INSERT INTO `smartend_webmaster_sections` (`id`, `row_no`, `title_en`, `type`, `title_status`, `photo_status`, `tags_status`, `case_status`, `visits_status`, `sections_status`, `comments_status`, `date_status`, `expire_date_status`, `longtext_status`, `editor_status`, `attach_file_status`, `extra_attach_file_status`, `multi_images_status`, `section_icon_status`, `icon_status`, `maps_status`, `order_status`, `related_status`, `seo_status`, `no_status`, `status`, `seo_title_en`, `seo_description_en`, `seo_keywords_en`, `seo_url_slug_en`, `photo`, `popup_id`, `created_by`, `updated_by`, `created_at`, `updated_at`, `title_km`, `seo_title_km`, `seo_description_km`, `seo_keywords_km`, `seo_url_slug_km`) VALUES
(1, 1, 'Site pages', 0, 1, 1, 0, 1, 1, 0, 0, 0, 0, 1, 1, 1, 0, 1, 1, 0, 1, 0, 0, 1, 1, 1, 'Site pages', NULL, NULL, 'site-pages', 'nav-bg.png', NULL, 1, NULL, '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Site pages', 'Site pages', NULL, NULL, NULL),
(7, 8, 'Blog', 0, 1, 1, 1, 1, 1, 1, 1, 0, 0, 1, 1, 0, 0, 1, 1, 0, 0, 0, 1, 1, 1, 1, 'Blog', NULL, NULL, 'blog', 'nav-bg.png', NULL, 1, NULL, '2025-01-04 09:15:30', '2025-01-04 09:21:09', 'Blog', 'Blog', NULL, NULL, NULL),
(15, 9, 'Research Centres', 0, 1, 1, 1, 1, 1, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, NULL, NULL, NULL, 'research-centres', NULL, NULL, 1, NULL, '2025-01-05 04:06:50', '2025-01-05 04:06:50', 'Research Centres', NULL, NULL, NULL, 'research-centres'),
(16, 10, 'Recent Publications', 0, 1, 1, 1, 1, 1, 2, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, NULL, NULL, NULL, 'recent-publications', NULL, NULL, 1, 1, '2025-01-08 11:27:54', '2025-01-08 11:30:33', 'Recent Publications', NULL, NULL, NULL, 'recent-publications'),
(17, 11, 'Recent Projects', 0, 1, 1, 1, 1, 1, 2, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, NULL, NULL, NULL, 'recent-projects', NULL, NULL, 1, 1, '2025-01-08 12:35:28', '2025-01-08 12:38:10', 'Recent Projects', NULL, NULL, NULL, 'recent-projects');

-- --------------------------------------------------------

--
-- Table structure for table `smartend_webmaster_section_fields`
--

CREATE TABLE `smartend_webmaster_section_fields` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `webmaster_id` bigint(20) UNSIGNED NOT NULL,
  `type` int(11) NOT NULL DEFAULT 0,
  `title_en` varchar(191) DEFAULT NULL,
  `default_value` varchar(191) DEFAULT NULL,
  `details_en` text DEFAULT NULL,
  `row_no` int(11) NOT NULL DEFAULT 0,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `required` tinyint(4) NOT NULL DEFAULT 0,
  `in_table` tinyint(4) NOT NULL DEFAULT 0,
  `in_search` tinyint(4) NOT NULL DEFAULT 0,
  `in_listing` tinyint(4) NOT NULL DEFAULT 0,
  `in_page` tinyint(4) NOT NULL DEFAULT 0,
  `in_statics` tinyint(4) NOT NULL DEFAULT 0,
  `lang_code` varchar(191) DEFAULT NULL,
  `css_class` varchar(191) DEFAULT NULL,
  `view_permission_groups` varchar(191) DEFAULT NULL,
  `add_permission_groups` varchar(191) DEFAULT NULL,
  `edit_permission_groups` varchar(191) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `title_km` varchar(191) DEFAULT NULL,
  `details_km` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `smartend_analytics_pages`
--
ALTER TABLE `smartend_analytics_pages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `analytics_pages_visitor_id` (`visitor_id`),
  ADD KEY `smartend_analytics_pages_date_time_index` (`date`,`time`);

--
-- Indexes for table `smartend_analytics_visitors`
--
ALTER TABLE `smartend_analytics_visitors`
  ADD PRIMARY KEY (`id`),
  ADD KEY `smartend_analytics_visitors_date_time_country_index` (`date`,`time`,`country`);

--
-- Indexes for table `smartend_attach_files`
--
ALTER TABLE `smartend_attach_files`
  ADD PRIMARY KEY (`id`),
  ADD KEY `attach_files_topic_id` (`topic_id`);

--
-- Indexes for table `smartend_banners`
--
ALTER TABLE `smartend_banners`
  ADD PRIMARY KEY (`id`),
  ADD KEY `banners_section_id` (`section_id`);

--
-- Indexes for table `smartend_comments`
--
ALTER TABLE `smartend_comments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `comments_topic_id` (`topic_id`);

--
-- Indexes for table `smartend_contacts_groups`
--
ALTER TABLE `smartend_contacts_groups`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `smartend_countries`
--
ALTER TABLE `smartend_countries`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `smartend_events`
--
ALTER TABLE `smartend_events`
  ADD PRIMARY KEY (`id`),
  ADD KEY `events_user_id` (`user_id`);

--
-- Indexes for table `smartend_failed_jobs`
--
ALTER TABLE `smartend_failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `smartend_failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `smartend_languages`
--
ALTER TABLE `smartend_languages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `smartend_maps`
--
ALTER TABLE `smartend_maps`
  ADD PRIMARY KEY (`id`),
  ADD KEY `maps_topic_id` (`topic_id`);

--
-- Indexes for table `smartend_menus`
--
ALTER TABLE `smartend_menus`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `smartend_migrations`
--
ALTER TABLE `smartend_migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `smartend_permissions`
--
ALTER TABLE `smartend_permissions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `smartend_photos`
--
ALTER TABLE `smartend_photos`
  ADD PRIMARY KEY (`id`),
  ADD KEY `photos_topic_id` (`topic_id`);

--
-- Indexes for table `smartend_popups`
--
ALTER TABLE `smartend_popups`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `smartend_related_topics`
--
ALTER TABLE `smartend_related_topics`
  ADD PRIMARY KEY (`id`),
  ADD KEY `related_topics_topic_id` (`topic_id`),
  ADD KEY `related_topics_topic2_id` (`topic2_id`);

--
-- Indexes for table `smartend_sections`
--
ALTER TABLE `smartend_sections`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sections_webmaster_id` (`webmaster_id`);

--
-- Indexes for table `smartend_sessions`
--
ALTER TABLE `smartend_sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `smartend_sessions_user_id_index` (`user_id`),
  ADD KEY `smartend_sessions_last_activity_index` (`last_activity`);

--
-- Indexes for table `smartend_settings`
--
ALTER TABLE `smartend_settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `smartend_tags`
--
ALTER TABLE `smartend_tags`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `smartend_topics`
--
ALTER TABLE `smartend_topics`
  ADD PRIMARY KEY (`id`),
  ADD KEY `topics_webmaster_id` (`webmaster_id`);

--
-- Indexes for table `smartend_topic_categories`
--
ALTER TABLE `smartend_topic_categories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `topic_categories_topic_id` (`topic_id`),
  ADD KEY `topic_categories_section_id` (`section_id`);

--
-- Indexes for table `smartend_topic_fields`
--
ALTER TABLE `smartend_topic_fields`
  ADD PRIMARY KEY (`id`),
  ADD KEY `topic_fields_topic_id` (`topic_id`),
  ADD KEY `topic_fields_field_id` (`field_id`);

--
-- Indexes for table `smartend_topic_tags`
--
ALTER TABLE `smartend_topic_tags`
  ADD PRIMARY KEY (`id`),
  ADD KEY `topic_tags_topic_id` (`topic_id`),
  ADD KEY `topic_tags_tag_id` (`tag_id`);

--
-- Indexes for table `smartend_webmails`
--
ALTER TABLE `smartend_webmails`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `smartend_webmails_files`
--
ALTER TABLE `smartend_webmails_files`
  ADD PRIMARY KEY (`id`),
  ADD KEY `webmails_files_webmail_id` (`webmail_id`);

--
-- Indexes for table `smartend_webmails_groups`
--
ALTER TABLE `smartend_webmails_groups`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `smartend_webmaster_banners`
--
ALTER TABLE `smartend_webmaster_banners`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `smartend_webmaster_sections`
--
ALTER TABLE `smartend_webmaster_sections`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `smartend_webmaster_section_fields`
--
ALTER TABLE `smartend_webmaster_section_fields`
  ADD PRIMARY KEY (`id`),
  ADD KEY `webmaster_section_fields_webmaster_id` (`webmaster_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `smartend_analytics_pages`
--
ALTER TABLE `smartend_analytics_pages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=239;

--
-- AUTO_INCREMENT for table `smartend_analytics_visitors`
--
ALTER TABLE `smartend_analytics_visitors`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=93;

--
-- AUTO_INCREMENT for table `smartend_attach_files`
--
ALTER TABLE `smartend_attach_files`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `smartend_banners`
--
ALTER TABLE `smartend_banners`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `smartend_comments`
--
ALTER TABLE `smartend_comments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `smartend_contacts_groups`
--
ALTER TABLE `smartend_contacts_groups`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `smartend_countries`
--
ALTER TABLE `smartend_countries`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=217;

--
-- AUTO_INCREMENT for table `smartend_events`
--
ALTER TABLE `smartend_events`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `smartend_failed_jobs`
--
ALTER TABLE `smartend_failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `smartend_languages`
--
ALTER TABLE `smartend_languages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `smartend_maps`
--
ALTER TABLE `smartend_maps`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `smartend_menus`
--
ALTER TABLE `smartend_menus`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;

--
-- AUTO_INCREMENT for table `smartend_migrations`
--
ALTER TABLE `smartend_migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;

--
-- AUTO_INCREMENT for table `smartend_permissions`
--
ALTER TABLE `smartend_permissions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `smartend_photos`
--
ALTER TABLE `smartend_photos`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=53;

--
-- AUTO_INCREMENT for table `smartend_popups`
--
ALTER TABLE `smartend_popups`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `smartend_related_topics`
--
ALTER TABLE `smartend_related_topics`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `smartend_sections`
--
ALTER TABLE `smartend_sections`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;

--
-- AUTO_INCREMENT for table `smartend_settings`
--
ALTER TABLE `smartend_settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `smartend_tags`
--
ALTER TABLE `smartend_tags`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `smartend_topics`
--
ALTER TABLE `smartend_topics`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=131;

--
-- AUTO_INCREMENT for table `smartend_topic_categories`
--
ALTER TABLE `smartend_topic_categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=84;

--
-- AUTO_INCREMENT for table `smartend_topic_fields`
--
ALTER TABLE `smartend_topic_fields`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=97;

--
-- AUTO_INCREMENT for table `smartend_topic_tags`
--
ALTER TABLE `smartend_topic_tags`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `smartend_webmails`
--
ALTER TABLE `smartend_webmails`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `smartend_webmails_files`
--
ALTER TABLE `smartend_webmails_files`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `smartend_webmails_groups`
--
ALTER TABLE `smartend_webmails_groups`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `smartend_webmaster_banners`
--
ALTER TABLE `smartend_webmaster_banners`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `smartend_webmaster_sections`
--
ALTER TABLE `smartend_webmaster_sections`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `smartend_webmaster_section_fields`
--
ALTER TABLE `smartend_webmaster_section_fields`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `smartend_analytics_pages`
--
ALTER TABLE `smartend_analytics_pages`
  ADD CONSTRAINT `analytics_pages_visitor_id` FOREIGN KEY (`visitor_id`) REFERENCES `smartend_analytics_visitors` (`id`);

--
-- Constraints for table `smartend_attach_files`
--
ALTER TABLE `smartend_attach_files`
  ADD CONSTRAINT `attach_files_topic_id` FOREIGN KEY (`topic_id`) REFERENCES `smartend_topics` (`id`);

--
-- Constraints for table `smartend_banners`
--
ALTER TABLE `smartend_banners`
  ADD CONSTRAINT `banners_section_id` FOREIGN KEY (`section_id`) REFERENCES `smartend_webmaster_banners` (`id`);

--
-- Constraints for table `smartend_comments`
--
ALTER TABLE `smartend_comments`
  ADD CONSTRAINT `comments_topic_id` FOREIGN KEY (`topic_id`) REFERENCES `smartend_topics` (`id`);

--
-- Constraints for table `smartend_events`
--
ALTER TABLE `smartend_events`
  ADD CONSTRAINT `events_user_id` FOREIGN KEY (`user_id`) REFERENCES `smartend_users` (`id`);

--
-- Constraints for table `smartend_maps`
--
ALTER TABLE `smartend_maps`
  ADD CONSTRAINT `maps_topic_id` FOREIGN KEY (`topic_id`) REFERENCES `smartend_topics` (`id`);

--
-- Constraints for table `smartend_photos`
--
ALTER TABLE `smartend_photos`
  ADD CONSTRAINT `photos_topic_id` FOREIGN KEY (`topic_id`) REFERENCES `smartend_topics` (`id`);

--
-- Constraints for table `smartend_related_topics`
--
ALTER TABLE `smartend_related_topics`
  ADD CONSTRAINT `related_topics_topic2_id` FOREIGN KEY (`topic2_id`) REFERENCES `smartend_topics` (`id`),
  ADD CONSTRAINT `related_topics_topic_id` FOREIGN KEY (`topic_id`) REFERENCES `smartend_topics` (`id`);

--
-- Constraints for table `smartend_sections`
--
ALTER TABLE `smartend_sections`
  ADD CONSTRAINT `sections_webmaster_id` FOREIGN KEY (`webmaster_id`) REFERENCES `smartend_webmaster_sections` (`id`);

--
-- Constraints for table `smartend_topics`
--
ALTER TABLE `smartend_topics`
  ADD CONSTRAINT `topics_webmaster_id` FOREIGN KEY (`webmaster_id`) REFERENCES `smartend_webmaster_sections` (`id`);

--
-- Constraints for table `smartend_topic_categories`
--
ALTER TABLE `smartend_topic_categories`
  ADD CONSTRAINT `topic_categories_section_id` FOREIGN KEY (`section_id`) REFERENCES `smartend_sections` (`id`),
  ADD CONSTRAINT `topic_categories_topic_id` FOREIGN KEY (`topic_id`) REFERENCES `smartend_topics` (`id`);

--
-- Constraints for table `smartend_topic_fields`
--
ALTER TABLE `smartend_topic_fields`
  ADD CONSTRAINT `topic_fields_field_id` FOREIGN KEY (`field_id`) REFERENCES `smartend_webmaster_section_fields` (`id`),
  ADD CONSTRAINT `topic_fields_topic_id` FOREIGN KEY (`topic_id`) REFERENCES `smartend_topics` (`id`);

--
-- Constraints for table `smartend_topic_tags`
--
ALTER TABLE `smartend_topic_tags`
  ADD CONSTRAINT `topic_tags_tag_id` FOREIGN KEY (`tag_id`) REFERENCES `smartend_tags` (`id`),
  ADD CONSTRAINT `topic_tags_topic_id` FOREIGN KEY (`topic_id`) REFERENCES `smartend_topics` (`id`);

--
-- Constraints for table `smartend_webmails_files`
--
ALTER TABLE `smartend_webmails_files`
  ADD CONSTRAINT `webmails_files_webmail_id` FOREIGN KEY (`webmail_id`) REFERENCES `smartend_webmails` (`id`);

--
-- Constraints for table `smartend_webmaster_section_fields`
--
ALTER TABLE `smartend_webmaster_section_fields`
  ADD CONSTRAINT `webmaster_section_fields_webmaster_id` FOREIGN KEY (`webmaster_id`) REFERENCES `smartend_webmaster_sections` (`id`);
COMMIT;

