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

START TRANSACTION;



--
-- Database: `bstorydb`
--

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

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

CREATE TABLE `smartend_analytics_pages` (
  `id` int(10) UNSIGNED NOT NULL,
  `visitor_id` int(11) NOT NULL,
  `ip` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `query` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `load_time` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` date NOT NULL,
  `time` time 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_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, '::1', 'Smartend Laravel Site Preview', 'unknown', 'http://localhost/black-story/public/', '0.69807696', '2021-02-07', '04:15:12', '2021-02-06 22:15:12', '2021-02-06 22:15:12'),
(2, 2, '127.0.0.1', 'Smartend Laravel Site Preview', 'unknown', 'http://127.0.0.1:8000/', '0.93832517', '2021-02-07', '04:15:44', '2021-02-06 22:15:44', '2021-02-06 22:15:44'),
(3, 2, '127.0.0.1', 'http://127.0.0.1:8000/login', 'unknown', 'http://127.0.0.1:8000/login', '0.25125408', '2021-02-07', '04:15:58', '2021-02-06 22:15:58', '2021-02-06 22:15:58'),
(4, 2, '127.0.0.1', 'http://127.0.0.1:8000/admin', 'unknown', 'http://127.0.0.1:8000/admin', '0.54270482', '2021-02-07', '04:17:10', '2021-02-06 22:17:10', '2021-02-06 22:17:10'),
(5, 2, '127.0.0.1', 'http://127.0.0.1:8000/admin/settings', 'unknown', 'http://127.0.0.1:8000/admin/settings', '0.5195291', '2021-02-07', '04:19:48', '2021-02-06 22:19:48', '2021-02-06 22:19:48'),
(6, 2, '127.0.0.1', 'http://127.0.0.1:8000/admin/settings?_pjax=%23view', 'unknown', 'http://127.0.0.1:8000/admin/settings?_pjax=%23view', '0.80458808', '2021-02-07', '04:19:49', '2021-02-06 22:19:49', '2021-02-06 22:19:49'),
(7, 2, '127.0.0.1', 'http://127.0.0.1:8000/admin/webmaster', 'unknown', 'http://127.0.0.1:8000/admin/webmaster', '0.43602514', '2021-02-07', '04:20:15', '2021-02-06 22:20:15', '2021-02-06 22:20:15'),
(8, 2, '127.0.0.1', 'http://127.0.0.1:8000/admin/webmaster?_pjax=%23view', 'unknown', 'http://127.0.0.1:8000/admin/webmaster?_pjax=%23view', '0.64614916', '2021-02-07', '04:20:15', '2021-02-06 22:20:15', '2021-02-06 22:20:15'),
(9, 2, '127.0.0.1', 'http://127.0.0.1:8000/admin/webmaster/sections?_pjax=%23view', 'unknown', 'http://127.0.0.1:8000/admin/webmaster/sections?_pjax=%23view', '0.50590181', '2021-02-07', '04:49:39', '2021-02-06 22:49:39', '2021-02-06 22:49:39'),
(10, 2, '127.0.0.1', 'http://127.0.0.1:8000/admin/webmaster/banners?_pjax=%23view', 'unknown', 'http://127.0.0.1:8000/admin/webmaster/banners?_pjax=%23view', '0.50226212', '2021-02-07', '04:49:47', '2021-02-06 22:49:47', '2021-02-06 22:49:47'),
(11, 2, '127.0.0.1', 'Black Story | Gallery Cosmos', 'unknown', 'http://127.0.0.1:8000/home', '0.87108207', '2021-02-07', '05:03:48', '2021-02-06 23:03:48', '2021-02-06 23:03:48'),
(12, 2, '127.0.0.1', 'http://127.0.0.1:8000/public/frontend/img/slides/1.jpg', 'unknown', 'http://127.0.0.1:8000/public/frontend/img/slides/1.jpg', '0.7247951', '2021-02-07', '05:24:51', '2021-02-06 23:24:51', '2021-02-06 23:24:51'),
(13, 3, '127.0.0.1', 'Black Story | Gallery Cosmos', 'unknown', 'http://127.0.0.1:8000/', '0.81037903', '2021-02-08', '13:04:04', '2021-02-08 07:04:04', '2021-02-08 07:04:04'),
(14, 3, '127.0.0.1', 'Black Story | Gallery Cosmos', 'unknown', 'http://127.0.0.1:8000/home', '0.45899701', '2021-02-08', '13:07:05', '2021-02-08 07:07:05', '2021-02-08 07:07:05'),
(15, 3, '127.0.0.1', 'Black Story | Gallery Cosmos', 'unknown', 'http://localhost:8000/', '0.47459102', '2021-02-08', '15:37:41', '2021-02-08 09:37:41', '2021-02-08 09:37:41'),
(16, 3, '127.0.0.1', 'Black Story | Gallery Cosmos', 'unknown', 'http://localhost:8000/home', '0.44209099', '2021-02-08', '16:18:42', '2021-02-08 10:18:42', '2021-02-08 10:18:42'),
(17, 4, '127.0.0.1', 'Black Story | Gallery Cosmos', 'unknown', 'http://127.0.0.1:8000/', '0.57326198', '2021-02-09', '02:00:06', '2021-02-08 20:00:06', '2021-02-08 20:00:06'),
(18, 4, '127.0.0.1', 'http://127.0.0.1:8000/login', 'unknown', 'http://127.0.0.1:8000/login', '0.39167094', '2021-02-09', '02:16:05', '2021-02-08 20:16:05', '2021-02-08 20:16:05'),
(19, 4, '127.0.0.1', 'http://127.0.0.1:8000/admin', 'unknown', 'http://127.0.0.1:8000/admin', '0.62402391', '2021-02-09', '02:16:26', '2021-02-08 20:16:26', '2021-02-08 20:16:26'),
(20, 4, '127.0.0.1', 'http://127.0.0.1:8000/admin/5/topics?_pjax=%23view', 'unknown', 'http://127.0.0.1:8000/admin/5/topics?_pjax=%23view', '0.60629702', '2021-02-09', '02:16:34', '2021-02-08 20:16:34', '2021-02-08 20:16:34'),
(21, 4, '127.0.0.1', 'http://127.0.0.1:8000/admin/5/topics/create', 'unknown', 'http://127.0.0.1:8000/admin/5/topics/create', '0.35554194', '2021-02-09', '02:16:38', '2021-02-08 20:16:38', '2021-02-08 20:16:38'),
(22, 4, '127.0.0.1', 'Black Story | Gallery Cosmos', 'unknown', 'http://127.0.0.1:8000/home', '1.49483705', '2021-02-09', '02:34:09', '2021-02-08 20:34:09', '2021-02-08 20:34:09'),
(23, 5, '127.0.0.1', 'Black Story | Gallery Cosmos', 'unknown', 'http://127.0.0.1:8000/', '0.89794493', '2021-02-11', '02:50:32', '2021-02-10 20:50:32', '2021-02-10 20:50:32'),
(24, 5, '127.0.0.1', 'http://127.0.0.1:8000/login', 'unknown', 'http://127.0.0.1:8000/login', '0.39580894', '2021-02-11', '03:00:20', '2021-02-10 21:00:20', '2021-02-10 21:00:20'),
(25, 5, '127.0.0.1', 'http://127.0.0.1:8000/backEnd/assets/bootstrap/dist/css/bootstrap.min.css.map', 'unknown', 'http://127.0.0.1:8000/backEnd/assets/bootstrap/dist/css/bootstrap.min.css.map', '0.56332707', '2021-02-11', '03:01:03', '2021-02-10 21:01:03', '2021-02-10 21:01:03'),
(26, 5, '127.0.0.1', 'http://127.0.0.1:8000/admin', 'unknown', 'http://127.0.0.1:8000/admin', '0.70103693', '2021-02-11', '03:01:27', '2021-02-10 21:01:27', '2021-02-10 21:01:27'),
(27, 5, '127.0.0.1', 'http://127.0.0.1:8000/admin/7/topics?_pjax=%23view', 'unknown', 'http://127.0.0.1:8000/admin/7/topics?_pjax=%23view', '0.53755093', '2021-02-11', '03:01:39', '2021-02-10 21:01:39', '2021-02-10 21:01:39'),
(28, 5, '127.0.0.1', 'http://127.0.0.1:8000/admin/7/topics/create', 'unknown', 'http://127.0.0.1:8000/admin/7/topics/create', '0.35687613', '2021-02-11', '03:01:42', '2021-02-10 21:01:42', '2021-02-10 21:01:42'),
(29, 5, '127.0.0.1', 'http://127.0.0.1:8000/admin/webmaster/banners?_pjax=%23view', 'unknown', 'http://127.0.0.1:8000/admin/webmaster/banners?_pjax=%23view', '0.42792797', '2021-02-11', '03:03:10', '2021-02-10 21:03:10', '2021-02-10 21:03:10'),
(30, 5, '127.0.0.1', 'http://127.0.0.1:8000/admin/webmaster/sections?_pjax=%23view', 'unknown', 'http://127.0.0.1:8000/admin/webmaster/sections?_pjax=%23view', '0.43739486', '2021-02-11', '03:03:17', '2021-02-10 21:03:17', '2021-02-10 21:03:17'),
(31, 5, '127.0.0.1', 'http://127.0.0.1:8000/admin/webmaster?_pjax=%23view', 'unknown', 'http://127.0.0.1:8000/admin/webmaster?_pjax=%23view', '0.47811723', '2021-02-11', '03:03:20', '2021-02-10 21:03:20', '2021-02-10 21:03:20'),
(32, 5, '127.0.0.1', 'http://127.0.0.1:8000/admin/webmaster', 'unknown', 'http://127.0.0.1:8000/admin/webmaster', '0.56573701', '2021-02-11', '03:03:21', '2021-02-10 21:03:21', '2021-02-10 21:03:21'),
(33, 5, '127.0.0.1', 'http://127.0.0.1:8000/admin/webmails?_pjax=%23view', 'unknown', 'http://127.0.0.1:8000/admin/webmails?_pjax=%23view', '0.63630795', '2021-02-11', '03:04:20', '2021-02-10 21:04:20', '2021-02-10 21:04:20'),
(34, 5, '127.0.0.1', 'http://127.0.0.1:8000/admin/webmails/create', 'unknown', 'http://127.0.0.1:8000/admin/webmails/create', '0.31572413', '2021-02-11', '03:04:28', '2021-02-10 21:04:28', '2021-02-10 21:04:28'),
(35, 5, '127.0.0.1', 'http://127.0.0.1:8000/admin/webmails', 'unknown', 'http://127.0.0.1:8000/admin/webmails', '0.33404708', '2021-02-11', '03:04:40', '2021-02-10 21:04:40', '2021-02-10 21:04:40'),
(36, 5, '127.0.0.1', 'http://127.0.0.1:8000/admin/calendar', 'unknown', 'http://127.0.0.1:8000/admin/calendar', '0.41628695', '2021-02-11', '03:04:49', '2021-02-10 21:04:49', '2021-02-10 21:04:49'),
(37, 5, '127.0.0.1', 'http://127.0.0.1:8000/admin/calendar?_pjax=%23view', 'unknown', 'http://127.0.0.1:8000/admin/calendar?_pjax=%23view', '0.55994105', '2021-02-11', '03:04:50', '2021-02-10 21:04:50', '2021-02-10 21:04:50'),
(38, 5, '127.0.0.1', 'http://127.0.0.1:8000/admin/1/topics?_pjax=%23view', 'unknown', 'http://127.0.0.1:8000/admin/1/topics?_pjax=%23view', '0.4848721', '2021-02-11', '03:04:52', '2021-02-10 21:04:52', '2021-02-10 21:04:52'),
(39, 5, '127.0.0.1', 'http://127.0.0.1:8000/admin/3/topics?_pjax=%23view', 'unknown', 'http://127.0.0.1:8000/admin/3/topics?_pjax=%23view', '0.43656802', '2021-02-11', '03:04:56', '2021-02-10 21:04:56', '2021-02-10 21:04:56'),
(40, 5, '127.0.0.1', 'http://127.0.0.1:8000/admin/4/topics?_pjax=%23view', 'unknown', 'http://127.0.0.1:8000/admin/4/topics?_pjax=%23view', '0.41439009', '2021-02-11', '03:04:58', '2021-02-10 21:04:58', '2021-02-10 21:04:58'),
(41, 5, '127.0.0.1', 'http://127.0.0.1:8000/admin/6/topics?_pjax=%23view', 'unknown', 'http://127.0.0.1:8000/admin/6/topics?_pjax=%23view', '0.40283298', '2021-02-11', '03:05:08', '2021-02-10 21:05:08', '2021-02-10 21:05:08'),
(42, 5, '127.0.0.1', 'Black Story | Gallery Cosmos', 'unknown', 'http://127.0.0.1:8000/home', '0.48684287', '2021-02-11', '03:05:09', '2021-02-10 21:05:09', '2021-02-10 21:05:09'),
(43, 5, '127.0.0.1', 'http://127.0.0.1:8000/admin/6/topics/create', 'unknown', 'http://127.0.0.1:8000/admin/6/topics/create', '0.33532596', '2021-02-11', '03:05:10', '2021-02-10 21:05:10', '2021-02-10 21:05:10'),
(44, 5, '127.0.0.1', 'http://127.0.0.1:8000/admin?_pjax=%23view', 'unknown', 'http://127.0.0.1:8000/admin?_pjax=%23view', '0.58888602', '2021-02-11', '03:12:48', '2021-02-10 21:12:48', '2021-02-10 21:12:48'),
(45, 5, '127.0.0.1', 'http://127.0.0.1:8000/admin/1/topics', 'unknown', 'http://127.0.0.1:8000/admin/1/topics', '0.32912207', '2021-02-11', '03:13:06', '2021-02-10 21:13:06', '2021-02-10 21:13:06'),
(46, 5, '127.0.0.1', 'http://127.0.0.1:8000/frontEnd/css/public/frontEnd/img/slides/popup.jpg', 'unknown', 'http://127.0.0.1:8000/frontEnd/css/public/frontEnd/img/slides/popup.jpg', '0.47828913', '2021-02-11', '04:50:18', '2021-02-10 22:50:18', '2021-02-10 22:50:18'),
(47, 5, '127.0.0.1', 'http://127.0.0.1:8000/public/frontEnd/img/slides/popup.jpg', 'unknown', 'http://127.0.0.1:8000/public/frontEnd/img/slides/popup.jpg', '1.40131021', '2021-02-11', '04:51:50', '2021-02-10 22:51:50', '2021-02-10 22:51:50'),
(48, 5, '127.0.0.1', 'http://127.0.0.1:8000/frontEnd/frontEnd/img/slides/popup.jpg', 'unknown', 'http://127.0.0.1:8000/frontEnd/frontEnd/img/slides/popup.jpg', '1.65290499', '2021-02-11', '04:52:55', '2021-02-10 22:52:55', '2021-02-10 22:52:55'),
(49, 5, '127.0.0.1', 'http://127.0.0.1:8000/admin/9/topics?_pjax=%23view', 'unknown', 'http://127.0.0.1:8000/admin/9/topics?_pjax=%23view', '0.50524306', '2021-02-11', '06:23:26', '2021-02-11 00:23:26', '2021-02-11 00:23:26'),
(50, 5, '127.0.0.1', 'http://127.0.0.1:8000/admin/webmaster/sections/2/edit', 'unknown', 'http://127.0.0.1:8000/admin/webmaster/sections/2/edit', '0.36782098', '2021-02-11', '06:41:37', '2021-02-11 00:41:37', '2021-02-11 00:41:37'),
(51, 5, '127.0.0.1', 'http://127.0.0.1:8000/admin/ip?_pjax=%23view', 'unknown', 'http://127.0.0.1:8000/admin/ip?_pjax=%23view', '0.43422794', '2021-02-11', '06:42:00', '2021-02-11 00:42:00', '2021-02-11 00:42:00'),
(52, 5, '127.0.0.1', 'http://127.0.0.1:8000/admin/contacts?_pjax=%23view', 'unknown', 'http://127.0.0.1:8000/admin/contacts?_pjax=%23view', '0.49015093', '2021-02-11', '06:42:04', '2021-02-11 00:42:04', '2021-02-11 00:42:04'),
(53, 5, '127.0.0.1', 'http://127.0.0.1:8000/admin/contacts/1', 'unknown', 'http://127.0.0.1:8000/admin/contacts/1', '0.31526804', '2021-02-11', '06:42:07', '2021-02-11 00:42:07', '2021-02-11 00:42:07'),
(54, 5, '127.0.0.1', 'Contact Us', 'unknown', 'http://127.0.0.1:8000/contact', '0.86377883', '2021-02-11', '07:02:54', '2021-02-11 01:02:54', '2021-02-11 01:02:54'),
(55, 6, '127.0.0.1', 'Black Story | Gallery Cosmos', 'unknown', 'http://127.0.0.1:8000/', '3.237499', '2021-02-14', '02:36:22', '2021-02-13 20:36:22', '2021-02-13 20:36:22'),
(56, 6, '127.0.0.1', 'Contact Us', 'unknown', 'http://127.0.0.1:8000/contact', '0.89523387', '2021-02-14', '03:09:45', '2021-02-13 21:09:45', '2021-02-13 21:09:45'),
(57, 6, '127.0.0.1', 'Black Story | Gallery Cosmos', 'unknown', 'http://127.0.0.1:8000/home', '0.77224994', '2021-02-14', '03:35:22', '2021-02-13 21:35:22', '2021-02-13 21:35:22'),
(58, 6, '127.0.0.1', 'http://127.0.0.1:8000/login', 'unknown', 'http://127.0.0.1:8000/login', '0.29215407', '2021-02-14', '04:38:04', '2021-02-13 22:38:04', '2021-02-13 22:38:04'),
(59, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin', 'unknown', 'http://127.0.0.1:8000/admin', '0.45209908', '2021-02-14', '04:38:15', '2021-02-13 22:38:15', '2021-02-13 22:38:15'),
(60, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/5/topics?_pjax=%23view', 'unknown', 'http://127.0.0.1:8000/admin/5/topics?_pjax=%23view', '0.41350007', '2021-02-14', '04:38:26', '2021-02-13 22:38:26', '2021-02-13 22:38:26'),
(61, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/5/topics/create', 'unknown', 'http://127.0.0.1:8000/admin/5/topics/create', '0.32632399', '2021-02-14', '04:38:31', '2021-02-13 22:38:31', '2021-02-13 22:38:31'),
(62, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/4/topics?_pjax=%23view', 'unknown', 'http://127.0.0.1:8000/admin/4/topics?_pjax=%23view', '0.58917499', '2021-02-14', '04:39:00', '2021-02-13 22:39:00', '2021-02-13 22:39:00'),
(63, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/4/topics/create', 'unknown', 'http://127.0.0.1:8000/admin/4/topics/create', '0.36016488', '2021-02-14', '04:39:06', '2021-02-13 22:39:06', '2021-02-13 22:39:06'),
(64, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/5/topics/50/edit', 'unknown', 'http://127.0.0.1:8000/admin/5/topics/50/edit', '0.42788506', '2021-02-14', '04:40:05', '2021-02-13 22:40:05', '2021-02-13 22:40:05'),
(65, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/5/topics', 'unknown', 'http://127.0.0.1:8000/admin/5/topics', '0.40452409', '2021-02-14', '04:41:52', '2021-02-13 22:41:52', '2021-02-13 22:41:52'),
(66, 6, '127.0.0.1', 'http://127.0.0.1:8000/backEnd/assets/bootstrap/dist/css/bootstrap.min.css.map', 'unknown', 'http://127.0.0.1:8000/backEnd/assets/bootstrap/dist/css/bootstrap.min.css.map', '0.63206506', '2021-02-14', '04:46:00', '2021-02-13 22:46:00', '2021-02-13 22:46:00'),
(67, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/5/topics/1/edit', 'unknown', 'http://127.0.0.1:8000/admin/5/topics/1/edit', '0.37856698', '2021-02-14', '04:47:54', '2021-02-13 22:47:54', '2021-02-13 22:47:54'),
(68, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/5/sections?_pjax=%23view', 'unknown', 'http://127.0.0.1:8000/admin/5/sections?_pjax=%23view', '0.69705892', '2021-02-14', '05:03:15', '2021-02-13 23:03:15', '2021-02-13 23:03:15'),
(69, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/4/topics/2/edit', 'unknown', 'http://127.0.0.1:8000/admin/4/topics/2/edit', '0.4264009', '2021-02-14', '05:03:39', '2021-02-13 23:03:39', '2021-02-13 23:03:39'),
(70, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/5/sections', 'unknown', 'http://127.0.0.1:8000/admin/5/sections', '0.44015384', '2021-02-14', '05:05:44', '2021-02-13 23:05:44', '2021-02-13 23:05:44'),
(71, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/5/sections/create', 'unknown', 'http://127.0.0.1:8000/admin/5/sections/create', '0.32424998', '2021-02-14', '05:06:20', '2021-02-13 23:06:20', '2021-02-13 23:06:20'),
(72, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/6/sections?_pjax=%23view', 'unknown', 'http://127.0.0.1:8000/admin/6/sections?_pjax=%23view', '0.42662191', '2021-02-14', '05:20:57', '2021-02-13 23:20:57', '2021-02-13 23:20:57'),
(73, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/7/sections?_pjax=%23view', 'unknown', 'http://127.0.0.1:8000/admin/7/sections?_pjax=%23view', '0.39493203', '2021-02-14', '05:21:01', '2021-02-13 23:21:01', '2021-02-13 23:21:01'),
(74, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/8/topics?_pjax=%23view', 'unknown', 'http://127.0.0.1:8000/admin/8/topics?_pjax=%23view', '0.36225295', '2021-02-14', '05:21:05', '2021-02-13 23:21:05', '2021-02-13 23:21:05'),
(75, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/8/sections?_pjax=%23view', 'unknown', 'http://127.0.0.1:8000/admin/8/sections?_pjax=%23view', '0.34129095', '2021-02-14', '05:21:08', '2021-02-13 23:21:08', '2021-02-13 23:21:08'),
(76, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/8/topics/create', 'unknown', 'http://127.0.0.1:8000/admin/8/topics/create', '0.34131885', '2021-02-14', '05:21:12', '2021-02-13 23:21:12', '2021-02-13 23:21:12'),
(77, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/menus?_pjax=%23view', 'unknown', 'http://127.0.0.1:8000/admin/menus?_pjax=%23view', '0.70067501', '2021-02-14', '05:35:03', '2021-02-13 23:35:03', '2021-02-13 23:35:03'),
(78, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/webmaster?_pjax=%23view', 'unknown', 'http://127.0.0.1:8000/admin/webmaster?_pjax=%23view', '0.37617397', '2021-02-14', '05:35:11', '2021-02-13 23:35:11', '2021-02-13 23:35:11'),
(79, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/webmaster', 'unknown', 'http://127.0.0.1:8000/admin/webmaster', '0.43160701', '2021-02-14', '05:35:11', '2021-02-13 23:35:11', '2021-02-13 23:35:11'),
(80, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/webmaster/sections?_pjax=%23view', 'unknown', 'http://127.0.0.1:8000/admin/webmaster/sections?_pjax=%23view', '0.49739099', '2021-02-14', '05:35:31', '2021-02-13 23:35:31', '2021-02-13 23:35:31'),
(81, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/webmaster/sections/8/edit', 'unknown', 'http://127.0.0.1:8000/admin/webmaster/sections/8/edit', '0.37452698', '2021-02-14', '05:35:46', '2021-02-13 23:35:46', '2021-02-13 23:35:46'),
(82, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/webmaster/sections/4/edit', 'unknown', 'http://127.0.0.1:8000/admin/webmaster/sections/4/edit', '0.36718297', '2021-02-14', '05:36:12', '2021-02-13 23:36:12', '2021-02-13 23:36:12'),
(83, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/4/topics', 'unknown', 'http://127.0.0.1:8000/admin/4/topics', '0.43467498', '2021-02-14', '05:37:38', '2021-02-13 23:37:38', '2021-02-13 23:37:38'),
(84, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/menus/10/edit/1', 'unknown', 'http://127.0.0.1:8000/admin/menus/10/edit/1', '0.31514001', '2021-02-14', '05:40:12', '2021-02-13 23:40:12', '2021-02-13 23:40:12'),
(85, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/settings', 'unknown', 'http://127.0.0.1:8000/admin/settings', '0.43791413', '2021-02-14', '05:40:22', '2021-02-13 23:40:22', '2021-02-13 23:40:22'),
(86, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/settings?_pjax=%23view', 'unknown', 'http://127.0.0.1:8000/admin/settings?_pjax=%23view', '0.88410091', '2021-02-14', '05:40:23', '2021-02-13 23:40:23', '2021-02-13 23:40:23'),
(87, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/users?_pjax=%23view', 'unknown', 'http://127.0.0.1:8000/admin/users?_pjax=%23view', '0.39683199', '2021-02-14', '05:40:38', '2021-02-13 23:40:38', '2021-02-13 23:40:38'),
(88, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/users/1/edit', 'unknown', 'http://127.0.0.1:8000/admin/users/1/edit', '0.32018781', '2021-02-14', '05:40:47', '2021-02-13 23:40:47', '2021-02-13 23:40:47'),
(89, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/4/sections', 'unknown', 'http://127.0.0.1:8000/admin/4/sections', '0.45829606', '2021-02-14', '05:42:33', '2021-02-13 23:42:33', '2021-02-13 23:42:33'),
(90, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/4/sections/create', 'unknown', 'http://127.0.0.1:8000/admin/4/sections/create', '0.61151195', '2021-02-14', '05:42:37', '2021-02-13 23:42:37', '2021-02-13 23:42:37'),
(91, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/webmaster/sections', 'unknown', 'http://127.0.0.1:8000/admin/webmaster/sections', '0.56711388', '2021-02-14', '05:43:05', '2021-02-13 23:43:05', '2021-02-13 23:43:05'),
(92, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/7/sections', 'unknown', 'http://127.0.0.1:8000/admin/7/sections', '0.57080817', '2021-02-14', '05:43:31', '2021-02-13 23:43:31', '2021-02-13 23:43:31'),
(93, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/7/sections/create', 'unknown', 'http://127.0.0.1:8000/admin/7/sections/create', '0.40531898', '2021-02-14', '05:43:34', '2021-02-13 23:43:34', '2021-02-13 23:43:34'),
(94, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/menus', 'unknown', 'http://127.0.0.1:8000/admin/menus', '0.45211792', '2021-02-14', '05:43:49', '2021-02-13 23:43:49', '2021-02-13 23:43:49'),
(95, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/menus/7/edit/1', 'unknown', 'http://127.0.0.1:8000/admin/menus/7/edit/1', '0.42186093', '2021-02-14', '05:43:54', '2021-02-13 23:43:54', '2021-02-13 23:43:54'),
(96, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/menus/8/edit/1', 'unknown', 'http://127.0.0.1:8000/admin/menus/8/edit/1', '0.47241688', '2021-02-14', '05:44:02', '2021-02-13 23:44:02', '2021-02-13 23:44:02'),
(97, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/4/sections?_pjax=%23view', 'unknown', 'http://127.0.0.1:8000/admin/4/sections?_pjax=%23view', '0.43975592', '2021-02-14', '05:45:55', '2021-02-13 23:45:55', '2021-02-13 23:45:55'),
(98, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/4/sections/28/edit', 'unknown', 'http://127.0.0.1:8000/admin/4/sections/28/edit', '0.36394882', '2021-02-14', '05:46:15', '2021-02-13 23:46:15', '2021-02-13 23:46:15'),
(99, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin?_pjax=%23view', 'unknown', 'http://127.0.0.1:8000/admin?_pjax=%23view', '0.87363815', '2021-02-14', '05:50:25', '2021-02-13 23:50:25', '2021-02-13 23:50:25'),
(100, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/1/topics?_pjax=%23view', 'unknown', 'http://127.0.0.1:8000/admin/1/topics?_pjax=%23view', '0.51088095', '2021-02-14', '05:52:37', '2021-02-13 23:52:37', '2021-02-13 23:52:37'),
(101, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/2/topics?_pjax=%23view', 'unknown', 'http://127.0.0.1:8000/admin/2/topics?_pjax=%23view', '0.31575799', '2021-02-14', '05:52:39', '2021-02-13 23:52:39', '2021-02-13 23:52:39'),
(102, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/3/topics?_pjax=%23view', 'unknown', 'http://127.0.0.1:8000/admin/3/topics?_pjax=%23view', '0.3198359', '2021-02-14', '05:52:41', '2021-02-13 23:52:41', '2021-02-13 23:52:41'),
(103, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/webmaster/sections/1/edit', 'unknown', 'http://127.0.0.1:8000/admin/webmaster/sections/1/edit', '0.33412504', '2021-02-14', '05:52:56', '2021-02-13 23:52:56', '2021-02-13 23:52:56'),
(104, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/webmaster/sections/2/edit', 'unknown', 'http://127.0.0.1:8000/admin/webmaster/sections/2/edit', '0.34454298', '2021-02-14', '05:53:14', '2021-02-13 23:53:14', '2021-02-13 23:53:14'),
(105, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/webmaster/sections/3/edit', 'unknown', 'http://127.0.0.1:8000/admin/webmaster/sections/3/edit', '0.3617692', '2021-02-14', '05:53:29', '2021-02-13 23:53:29', '2021-02-13 23:53:29'),
(106, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/webmaster/sections/9/edit', 'unknown', 'http://127.0.0.1:8000/admin/webmaster/sections/9/edit', '0.35402679', '2021-02-14', '05:54:05', '2021-02-13 23:54:05', '2021-02-13 23:54:05'),
(107, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/webmaster/banners?_pjax=%23view', 'unknown', 'http://127.0.0.1:8000/admin/webmaster/banners?_pjax=%23view', '0.55075002', '2021-02-14', '05:54:19', '2021-02-13 23:54:19', '2021-02-13 23:54:19'),
(108, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/banners?_pjax=%23view', 'unknown', 'http://127.0.0.1:8000/admin/banners?_pjax=%23view', '0.66488409', '2021-02-14', '05:54:29', '2021-02-13 23:54:29', '2021-02-13 23:54:29'),
(109, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/7/topics?_pjax=%23view', 'unknown', 'http://127.0.0.1:8000/admin/7/topics?_pjax=%23view', '0.84905601', '2021-02-14', '06:13:33', '2021-02-14 00:13:33', '2021-02-14 00:13:33'),
(110, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/7/topics/create', 'unknown', 'http://127.0.0.1:8000/admin/7/topics/create', '0.42952108', '2021-02-14', '06:13:35', '2021-02-14 00:13:35', '2021-02-14 00:13:35'),
(111, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/4/topics/3/edit', 'unknown', 'http://127.0.0.1:8000/admin/4/topics/3/edit', '0.48551202', '2021-02-14', '06:20:42', '2021-02-14 00:20:42', '2021-02-14 00:20:42'),
(112, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/4/topics/4/edit', 'unknown', 'http://127.0.0.1:8000/admin/4/topics/4/edit', '0.42630601', '2021-02-14', '06:21:55', '2021-02-14 00:21:55', '2021-02-14 00:21:55'),
(113, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/4/topics/6/edit', 'unknown', 'http://127.0.0.1:8000/admin/4/topics/6/edit', '0.45094895', '2021-02-14', '06:22:45', '2021-02-14 00:22:45', '2021-02-14 00:22:45'),
(114, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/4/topics/7/edit', 'unknown', 'http://127.0.0.1:8000/admin/4/topics/7/edit', '0.58297896', '2021-02-14', '06:23:42', '2021-02-14 00:23:42', '2021-02-14 00:23:42'),
(115, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/4/topics/8/edit', 'unknown', 'http://127.0.0.1:8000/admin/4/topics/8/edit', '0.49243402', '2021-02-14', '06:24:12', '2021-02-14 00:24:12', '2021-02-14 00:24:12'),
(116, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/4/topics/9/edit', 'unknown', 'http://127.0.0.1:8000/admin/4/topics/9/edit', '0.38597012', '2021-02-14', '06:24:42', '2021-02-14 00:24:42', '2021-02-14 00:24:42'),
(117, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/4/topics/10/edit', 'unknown', 'http://127.0.0.1:8000/admin/4/topics/10/edit', '0.41035199', '2021-02-14', '06:25:27', '2021-02-14 00:25:27', '2021-02-14 00:25:27'),
(118, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/4/topics/11/edit', 'unknown', 'http://127.0.0.1:8000/admin/4/topics/11/edit', '0.58143306', '2021-02-14', '06:26:00', '2021-02-14 00:26:00', '2021-02-14 00:26:00'),
(119, 6, '127.0.0.1', 'http://127.0.0.1:8000/admin/4/topics/12/edit', 'unknown', 'http://127.0.0.1:8000/admin/4/topics/12/edit', '0.41546988', '2021-02-14', '06:26:36', '2021-02-14 00:26:36', '2021-02-14 00:26:36'),
(120, 6, '127.0.0.1', 'http://127.0.0.1:8000/public/upload/topics/16132836423544.jpg', 'unknown', 'http://127.0.0.1:8000/public/upload/topics/16132836423544.jpg', '0.86877394', '2021-02-14', '08:23:51', '2021-02-14 02:23:51', '2021-02-14 02:23:51'),
(121, 6, '127.0.0.1', 'http://127.0.0.1:8000/public/upload/topics/16132837154528.jpg', 'unknown', 'http://127.0.0.1:8000/public/upload/topics/16132837154528.jpg', '1.00500703', '2021-02-14', '08:23:52', '2021-02-14 02:23:52', '2021-02-14 02:23:52'),
(122, 6, '127.0.0.1', 'http://127.0.0.1:8000/public/upload/topics/16132837495011.jpg', 'unknown', 'http://127.0.0.1:8000/public/upload/topics/16132837495011.jpg', '0.64839315', '2021-02-14', '08:23:53', '2021-02-14 02:23:53', '2021-02-14 02:23:53'),
(123, 6, '127.0.0.1', 'http://127.0.0.1:8000/public/upload/topics/16132838214410.jpg', 'unknown', 'http://127.0.0.1:8000/public/upload/topics/16132838214410.jpg', '0.72289109', '2021-02-14', '08:23:54', '2021-02-14 02:23:54', '2021-02-14 02:23:54'),
(124, 6, '127.0.0.1', 'http://127.0.0.1:8000/public/upload/topics/16132838519887.jpg', 'unknown', 'http://127.0.0.1:8000/public/upload/topics/16132838519887.jpg', '0.6465621', '2021-02-14', '08:23:55', '2021-02-14 02:23:55', '2021-02-14 02:23:55'),
(125, 6, '127.0.0.1', 'http://127.0.0.1:8000/public/upload/topics/16132838817830.jpg', 'unknown', 'http://127.0.0.1:8000/public/upload/topics/16132838817830.jpg', '0.46480179', '2021-02-14', '08:23:55', '2021-02-14 02:23:55', '2021-02-14 02:23:55'),
(126, 6, '127.0.0.1', 'http://127.0.0.1:8000/public/uploads/topics/16132836423544.jpg', 'unknown', 'http://127.0.0.1:8000/public/uploads/topics/16132836423544.jpg', '0.80891514', '2021-02-14', '08:25:38', '2021-02-14 02:25:38', '2021-02-14 02:25:38'),
(127, 6, '127.0.0.1', 'http://127.0.0.1:8000/public/uploads/topics/16132837154528.jpg', 'unknown', 'http://127.0.0.1:8000/public/uploads/topics/16132837154528.jpg', '0.4632051', '2021-02-14', '08:25:38', '2021-02-14 02:25:38', '2021-02-14 02:25:38'),
(128, 6, '127.0.0.1', 'http://127.0.0.1:8000/public/uploads/topics/16132837495011.jpg', 'unknown', 'http://127.0.0.1:8000/public/uploads/topics/16132837495011.jpg', '0.43242908', '2021-02-14', '08:25:39', '2021-02-14 02:25:39', '2021-02-14 02:25:39'),
(129, 6, '127.0.0.1', 'http://127.0.0.1:8000/public/uploads/topics/16132838214410.jpg', 'unknown', 'http://127.0.0.1:8000/public/uploads/topics/16132838214410.jpg', '0.57592487', '2021-02-14', '08:25:48', '2021-02-14 02:25:48', '2021-02-14 02:25:48'),
(130, 6, '127.0.0.1', 'http://127.0.0.1:8000/public/uploads/topics/16132838817830.jpg', 'unknown', 'http://127.0.0.1:8000/public/uploads/topics/16132838817830.jpg', '0.5193429', '2021-02-14', '08:25:48', '2021-02-14 02:25:48', '2021-02-14 02:25:48'),
(131, 6, '127.0.0.1', 'http://127.0.0.1:8000/public/uploads/topics/16132838519887.jpg', 'unknown', 'http://127.0.0.1:8000/public/uploads/topics/16132838519887.jpg', '0.45551896', '2021-02-14', '08:25:49', '2021-02-14 02:25:49', '2021-02-14 02:25:49'),
(132, 7, '127.0.0.1', 'Black Story | Gallery Cosmos', 'unknown', 'http://127.0.0.1:8000/', '1.13745713', '2021-02-17', '04:24:05', '2021-02-16 22:24:05', '2021-02-16 22:24:05'),
(133, 7, '127.0.0.1', 'Black Story | Gallery Cosmos', 'unknown', 'http://127.0.0.1:8000/home', '1.69100595', '2021-02-17', '04:34:37', '2021-02-16 22:34:37', '2021-02-16 22:34:37'),
(134, 7, '127.0.0.1', 'http://127.0.0.1:8000/login', 'unknown', 'http://127.0.0.1:8000/login', '0.40827203', '2021-02-17', '05:04:34', '2021-02-16 23:04:34', '2021-02-16 23:04:34'),
(135, 7, '127.0.0.1', 'http://127.0.0.1:8000/admin', 'unknown', 'http://127.0.0.1:8000/admin', '0.54058695', '2021-02-17', '05:05:06', '2021-02-16 23:05:06', '2021-02-16 23:05:06'),
(136, 7, '127.0.0.1', 'http://127.0.0.1:8000/admin/webmails?_pjax=%23view', 'unknown', 'http://127.0.0.1:8000/admin/webmails?_pjax=%23view', '0.43353415', '2021-02-17', '05:05:12', '2021-02-16 23:05:12', '2021-02-16 23:05:12'),
(137, 7, '127.0.0.1', 'http://127.0.0.1:8000/admin/webmails', 'unknown', 'http://127.0.0.1:8000/admin/webmails', '0.37284398', '2021-02-17', '05:05:32', '2021-02-16 23:05:32', '2021-02-16 23:05:32'),
(138, 7, '127.0.0.1', 'http://127.0.0.1:8000/admin/4/sections?_pjax=%23view', 'unknown', 'http://127.0.0.1:8000/admin/4/sections?_pjax=%23view', '0.42494297', '2021-02-17', '05:05:54', '2021-02-16 23:05:54', '2021-02-16 23:05:54'),
(139, 7, '127.0.0.1', 'http://127.0.0.1:8000/admin/4/sections', 'unknown', 'http://127.0.0.1:8000/admin/4/sections', '1.21280718', '2021-02-17', '05:06:20', '2021-02-16 23:06:20', '2021-02-16 23:06:20'),
(140, 7, '127.0.0.1', 'http://127.0.0.1:8000/admin/4/topics', 'unknown', 'http://127.0.0.1:8000/admin/4/topics', '0.45764494', '2021-02-17', '05:10:01', '2021-02-16 23:10:01', '2021-02-16 23:10:01'),
(141, 7, '127.0.0.1', 'http://127.0.0.1:8000/admin/4/topics/create', 'unknown', 'http://127.0.0.1:8000/admin/4/topics/create', '0.62818885', '2021-02-17', '05:10:33', '2021-02-16 23:10:33', '2021-02-16 23:10:33'),
(142, 7, '127.0.0.1', 'http://127.0.0.1:8000/admin/4/topics/13/edit', 'unknown', 'http://127.0.0.1:8000/admin/4/topics/13/edit', '0.44385791', '2021-02-17', '05:15:41', '2021-02-16 23:15:41', '2021-02-16 23:15:41'),
(143, 7, '127.0.0.1', 'http://127.0.0.1:8000/admin/4/topics?_pjax=%23view', 'unknown', 'http://127.0.0.1:8000/admin/4/topics?_pjax=%23view', '0.43975782', '2021-02-17', '05:15:50', '2021-02-16 23:15:50', '2021-02-16 23:15:50'),
(144, 7, '127.0.0.1', 'http://127.0.0.1:8000/admin/4/topics/14/edit', 'unknown', 'http://127.0.0.1:8000/admin/4/topics/14/edit', '0.55663085', '2021-02-17', '05:16:26', '2021-02-16 23:16:26', '2021-02-16 23:16:26'),
(145, 7, '127.0.0.1', 'http://127.0.0.1:8000/admin/4/topics/15/edit', 'unknown', 'http://127.0.0.1:8000/admin/4/topics/15/edit', '0.39575696', '2021-02-17', '05:17:07', '2021-02-16 23:17:07', '2021-02-16 23:17:07'),
(146, 7, '127.0.0.1', 'http://127.0.0.1:8000/admin/4/topics/16/edit', 'unknown', 'http://127.0.0.1:8000/admin/4/topics/16/edit', '0.49404407', '2021-02-17', '05:18:10', '2021-02-16 23:18:10', '2021-02-16 23:18:10'),
(147, 7, '127.0.0.1', 'http://127.0.0.1:8000/admin/4/topics/17/edit', 'unknown', 'http://127.0.0.1:8000/admin/4/topics/17/edit', '0.40534496', '2021-02-17', '05:21:46', '2021-02-16 23:21:46', '2021-02-16 23:21:46'),
(148, 7, '127.0.0.1', 'http://127.0.0.1:8000/admin/4/topics/18/edit', 'unknown', 'http://127.0.0.1:8000/admin/4/topics/18/edit', '0.40784597', '2021-02-17', '05:22:24', '2021-02-16 23:22:24', '2021-02-16 23:22:24'),
(149, 7, '127.0.0.1', 'http://127.0.0.1:8000/admin/4/topics/19/edit', 'unknown', 'http://127.0.0.1:8000/admin/4/topics/19/edit', '0.38432002', '2021-02-17', '05:25:09', '2021-02-16 23:25:09', '2021-02-16 23:25:09'),
(150, 7, '127.0.0.1', 'http://127.0.0.1:8000/admin/4/topics/20/edit', 'unknown', 'http://127.0.0.1:8000/admin/4/topics/20/edit', '0.39065504', '2021-02-17', '05:26:03', '2021-02-16 23:26:03', '2021-02-16 23:26:03'),
(151, 7, '127.0.0.1', 'http://127.0.0.1:8000/admin/4/topics/21/edit', 'unknown', 'http://127.0.0.1:8000/admin/4/topics/21/edit', '0.39134908', '2021-02-17', '05:26:36', '2021-02-16 23:26:36', '2021-02-16 23:26:36'),
(152, 7, '127.0.0.1', 'http://127.0.0.1:8000/admin/4/topics/22/edit', 'unknown', 'http://127.0.0.1:8000/admin/4/topics/22/edit', '0.40612292', '2021-02-17', '05:27:19', '2021-02-16 23:27:19', '2021-02-16 23:27:19'),
(153, 7, '127.0.0.1', 'http://127.0.0.1:8000/admin/4/topics/23/edit', 'unknown', 'http://127.0.0.1:8000/admin/4/topics/23/edit', '0.39693904', '2021-02-17', '05:30:00', '2021-02-16 23:30:00', '2021-02-16 23:30:00'),
(154, 7, '127.0.0.1', 'http://127.0.0.1:8000/admin/4/topics/24/edit', 'unknown', 'http://127.0.0.1:8000/admin/4/topics/24/edit', '0.39793396', '2021-02-17', '05:30:47', '2021-02-16 23:30:47', '2021-02-16 23:30:47'),
(155, 7, '127.0.0.1', 'http://127.0.0.1:8000/admin/4/topics/25/edit', 'unknown', 'http://127.0.0.1:8000/admin/4/topics/25/edit', '0.493541', '2021-02-17', '05:31:22', '2021-02-16 23:31:22', '2021-02-16 23:31:22'),
(156, 7, '127.0.0.1', 'http://127.0.0.1:8000/admin/4/topics/26/edit', 'unknown', 'http://127.0.0.1:8000/admin/4/topics/26/edit', '0.41785979', '2021-02-17', '05:32:11', '2021-02-16 23:32:11', '2021-02-16 23:32:11'),
(157, 7, '127.0.0.1', 'http://127.0.0.1:8000/admin/4/topics/27/edit', 'unknown', 'http://127.0.0.1:8000/admin/4/topics/27/edit', '0.43554902', '2021-02-17', '05:32:42', '2021-02-16 23:32:42', '2021-02-16 23:32:42'),
(158, 8, '127.0.0.1', 'Black Story | Gallery Cosmos', 'unknown', 'http://127.0.0.1:8000/', '1.10161805', '2021-02-18', '04:12:30', '2021-02-17 22:12:30', '2021-02-17 22:12:30'),
(159, 8, '127.0.0.1', 'http://127.0.0.1:8000/login', 'unknown', 'http://127.0.0.1:8000/login', '0.51371503', '2021-02-18', '04:15:08', '2021-02-17 22:15:08', '2021-02-17 22:15:08'),
(160, 8, '127.0.0.1', 'http://127.0.0.1:8000/admin', 'unknown', 'http://127.0.0.1:8000/admin', '0.53330898', '2021-02-18', '04:15:17', '2021-02-17 22:15:17', '2021-02-17 22:15:17'),
(161, 8, '127.0.0.1', 'http://127.0.0.1:8000/admin/settings?_pjax=%23view', 'unknown', 'http://127.0.0.1:8000/admin/settings?_pjax=%23view', '0.61353111', '2021-02-18', '04:15:30', '2021-02-17 22:15:30', '2021-02-17 22:15:30'),
(162, 8, '127.0.0.1', 'http://127.0.0.1:8000/admin/settings', 'unknown', 'http://127.0.0.1:8000/admin/settings', '0.63332796', '2021-02-18', '04:15:31', '2021-02-17 22:15:31', '2021-02-17 22:15:31'),
(163, 8, '127.0.0.1', 'http://127.0.0.1:8000/admin/webmaster?_pjax=%23view', 'unknown', 'http://127.0.0.1:8000/admin/webmaster?_pjax=%23view', '0.46550894', '2021-02-18', '04:17:41', '2021-02-17 22:17:41', '2021-02-17 22:17:41'),
(164, 8, '127.0.0.1', 'http://127.0.0.1:8000/admin/webmaster', 'unknown', 'http://127.0.0.1:8000/admin/webmaster', '0.54275489', '2021-02-18', '04:17:42', '2021-02-17 22:17:42', '2021-02-17 22:17:42'),
(165, 8, '127.0.0.1', 'http://127.0.0.1:8000/admin/webmaster/sections?_pjax=%23view', 'unknown', 'http://127.0.0.1:8000/admin/webmaster/sections?_pjax=%23view', '0.55262399', '2021-02-18', '04:18:05', '2021-02-17 22:18:05', '2021-02-17 22:18:05'),
(166, 8, '127.0.0.1', 'http://127.0.0.1:8000/admin/webmaster/banners?_pjax=%23view', 'unknown', 'http://127.0.0.1:8000/admin/webmaster/banners?_pjax=%23view', '0.407444', '2021-02-18', '04:18:15', '2021-02-17 22:18:15', '2021-02-17 22:18:15'),
(167, 8, '127.0.0.1', 'http://127.0.0.1:8000/admin/webmaster/banners/1/edit', 'unknown', 'http://127.0.0.1:8000/admin/webmaster/banners/1/edit', '0.40101314', '2021-02-18', '04:18:21', '2021-02-17 22:18:21', '2021-02-17 22:18:21'),
(168, 8, '127.0.0.1', 'http://127.0.0.1:8000/admin/webmaster/banners', 'unknown', 'http://127.0.0.1:8000/admin/webmaster/banners', '0.52151513', '2021-02-18', '04:18:25', '2021-02-17 22:18:25', '2021-02-17 22:18:25'),
(169, 8, '127.0.0.1', 'http://127.0.0.1:8000/admin?_pjax=%23view', 'unknown', 'http://127.0.0.1:8000/admin?_pjax=%23view', '0.40619707', '2021-02-18', '04:18:29', '2021-02-17 22:18:29', '2021-02-17 22:18:29'),
(170, 8, '127.0.0.1', 'Black Story | Gallery Cosmos', 'unknown', 'http://127.0.0.1:8000/home', '0.86155605', '2021-02-18', '04:19:34', '2021-02-17 22:19:34', '2021-02-17 22:19:34'),
(171, 8, '127.0.0.1', 'http://127.0.0.1:8000/frontend/img/slides/banner-protest.jpg', 'unknown', 'http://127.0.0.1:8000/frontend/img/slides/banner-protest.jpg', '0.73095012', '2021-02-18', '05:52:41', '2021-02-17 23:52:41', '2021-02-17 23:52:41');

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

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

CREATE TABLE `smartend_analytics_visitors` (
  `id` int(10) UNSIGNED NOT NULL,
  `ip` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country_code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `region` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `full_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `location_cor1` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `location_cor2` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `os` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `browser` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `resolution` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `referrer` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hostname` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `org` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` date NOT NULL,
  `time` time 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_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, '::1', 'unknown', 'unknown', 'unknown', 'unknown', 'unknown, unknown, unknown', 'unknown', 'unknown', 'unknown', 'Chrome', 'unknown', 'http://localhost/black-story/', 'No Hostname', 'unknown', '2021-02-07', '04:15:12', '2021-02-06 22:15:12', '2021-02-06 22:15:12'),
(2, '127.0.0.1', 'unknown', 'unknown', 'unknown', 'unknown', 'unknown, unknown, unknown', 'unknown', 'unknown', 'unknown', 'Chrome', 'unknown', 'unknown', 'No Hostname', 'unknown', '2021-02-07', '04:15:44', '2021-02-06 22:15:44', '2021-02-06 22:15:44'),
(3, '127.0.0.1', 'unknown', 'unknown', 'unknown', 'unknown', 'unknown, unknown, unknown', 'unknown', 'unknown', 'unknown', 'Chrome', 'unknown', 'unknown', 'No Hostname', 'unknown', '2021-02-08', '13:04:04', '2021-02-08 07:04:04', '2021-02-08 07:04:04'),
(4, '127.0.0.1', 'unknown', 'unknown', 'unknown', 'unknown', 'unknown, unknown, unknown', 'unknown', 'unknown', 'unknown', 'Chrome', 'unknown', 'unknown', 'No Hostname', 'unknown', '2021-02-09', '02:00:06', '2021-02-08 20:00:06', '2021-02-08 20:00:06'),
(5, '127.0.0.1', 'unknown', 'unknown', 'unknown', 'unknown', 'unknown, unknown, unknown', 'unknown', 'unknown', 'unknown', 'Chrome', 'unknown', 'unknown', 'No Hostname', 'unknown', '2021-02-11', '02:50:32', '2021-02-10 20:50:32', '2021-02-10 20:50:32'),
(6, '127.0.0.1', 'unknown', 'unknown', 'unknown', 'unknown', 'unknown, unknown, unknown', 'unknown', 'unknown', 'unknown', 'Chrome', 'unknown', 'unknown', 'No Hostname', 'unknown', '2021-02-14', '02:36:21', '2021-02-13 20:36:21', '2021-02-13 20:36:21'),
(7, '127.0.0.1', 'unknown', 'unknown', 'unknown', 'unknown', 'unknown, unknown, unknown', 'unknown', 'unknown', 'unknown', 'Chrome', 'unknown', 'unknown', 'No Hostname', 'unknown', '2021-02-17', '04:24:05', '2021-02-16 22:24:05', '2021-02-16 22:24:05'),
(8, '127.0.0.1', 'unknown', 'unknown', 'unknown', 'unknown', 'unknown, unknown, unknown', 'unknown', 'unknown', 'unknown', 'Chrome', 'unknown', 'unknown', 'No Hostname', 'unknown', '2021-02-18', '04:12:30', '2021-02-17 22:12:30', '2021-02-17 22:12:30');

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

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

CREATE TABLE `smartend_attach_files` (
  `id` int(10) UNSIGNED NOT NULL,
  `topic_id` int(11) NOT NULL,
  `file` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title_ar` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title_en` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `row_no` int(11) 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `smartend_banners` (
  `id` int(10) UNSIGNED NOT NULL,
  `section_id` int(11) NOT NULL,
  `title_ar` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title_en` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `details_ar` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `details_en` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_ar` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_en` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `video_type` tinyint(4) DEFAULT NULL,
  `youtube_link` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `link_url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(4) NOT NULL,
  `visits` int(11) NOT NULL,
  `row_no` int(11) 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `smartend_banners` (`id`, `section_id`, `title_ar`, `title_en`, `details_ar`, `details_en`, `code`, `file_ar`, `file_en`, `video_type`, `youtube_link`, `link_url`, `icon`, `status`, `visits`, `row_no`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, 1, 'بنر رقم 3', 'Banner #3', 'هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز على الشكل الخارجي للنص.', 'It is a long established fact that a reader will be distracted by the readable content of a page.', NULL, '14888109018814.jpg', '14888109012163.jpg', NULL, NULL, '#', NULL, 1, 0, 3, 1, 1, '2017-03-06 11:06:24', '2017-03-07 18:27:19'),
(2, 1, 'بنر رقم 2', 'Banner #2', 'هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز على الشكل الخارجي للنص.', 'It is a long established fact that a reader will be distracted by the readable content of a page.', NULL, '14888112232028.jpg', '14888112237145.jpg', NULL, NULL, '#', NULL, 1, 0, 2, 1, 1, '2017-03-06 11:06:24', '2017-03-07 18:27:19'),
(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, '#', 'fa-object-group', 1, 0, 1, 1, NULL, '2017-03-06 11:06:24', '2017-03-07 18:27:19'),
(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, '#', 'fa-html5', 1, 0, 2, 1, NULL, '2017-03-06 11:06:24', '2017-03-07 18:27:19'),
(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, '#', 'fa-code', 1, 0, 3, 1, NULL, '2017-03-06 11:06:24', '2017-03-07 18:27:19'),
(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, '#', 'fa-laptop', 1, 0, 4, 1, NULL, '2017-03-06 11:06:24', '2017-03-07 18:27:19'),
(7, 1, 'بنر رقم 1', 'Banner #1', 'هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز على الشكل الخارجي للنص.', 'It is a long established fact that a reader will be distracted by the readable content of a page.', NULL, '14888126419392.jpg', '14888126415336.jpg', NULL, NULL, '#', NULL, 1, 0, 1, 1, 1, '2017-03-06 13:04:01', '2017-03-07 18:27:19'),
(8, 3, 'بنر جانبي تجريبي', 'Side banner sample', NULL, NULL, NULL, '14888184555359.png', '14888184559632.png', NULL, NULL, '#', NULL, 1, 0, 5, 1, 1, '2017-03-06 14:25:52', '2017-03-07 18:27:19');

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

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

CREATE TABLE `smartend_comments` (
  `id` int(10) UNSIGNED NOT NULL,
  `topic_id` int(11) NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `comment` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(4) NOT NULL,
  `row_no` int(11) 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `smartend_comments`
--

INSERT INTO `smartend_comments` (`id`, `topic_id`, `name`, `email`, `date`, `comment`, `status`, `row_no`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, 9, 'Roza Hesham', 'email@site.com', '2017-03-06 15:55:21', 'Donec 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.', 1, 1, NULL, NULL, '2017-03-06 13:55:21', '2017-03-06 13:55:21'),
(2, 9, 'Adam Ali', 'emm@site.com', '2017-03-06 15:55:59', '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.', 1, 2, NULL, NULL, '2017-03-06 13:55:59', '2017-03-06 13:55:59'),
(6, 90, 'mmmmm', 'eee@ss.ccd', '2017-11-12 05:15:03', 'The topic id field is required.', 1, 1, NULL, NULL, '2017-11-12 03:15:03', '2017-11-12 03:15:03'),
(7, 90, 'mmmmm', 'eee@ss.ccd', '2017-11-12 05:18:26', 'The topic id field is required.', 1, 2, NULL, NULL, '2017-11-12 03:18:26', '2017-11-12 03:18:26');

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

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

CREATE TABLE `smartend_contacts_groups` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci 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
) 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, '2017-03-06 11:06:24', '2017-03-06 11:06:24'),
(2, 'VIP', 1, NULL, '2017-03-07 13:56:11', '2017-03-07 13:56:11'),
(3, 'Customers', 1, NULL, '2017-03-07 13:56:24', '2017-03-07 13:56:24');

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

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

CREATE TABLE `smartend_countries` (
  `id` int(10) UNSIGNED NOT NULL,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title_ar` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title_en` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tel` varchar(191) COLLATE utf8mb4_unicode_ci 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_countries`
--

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

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

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

CREATE TABLE `smartend_events` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL,
  `type` tinyint(4) NOT NULL DEFAULT 0,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `details` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `start_date` datetime NOT NULL,
  `end_date` datetime NOT NULL,
  `color` varchar(191) COLLATE utf8mb4_unicode_ci 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_events`
--

INSERT INTO `smartend_events` (`id`, `user_id`, `type`, `title`, `details`, `start_date`, `end_date`, `color`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, 1, 0, 'test note to my calendar', 'this is a test note to my calendar', '2018-12-07 00:00:00', '2018-12-07 00:00:00', NULL, 1, NULL, '2017-03-07 14:06:32', '2017-03-07 14:06:32'),
(2, 1, 1, 'meeting test for multi purposes', 'meeting test for multi purposes meeting test for multi purposes', '2018-11-07 16:03:00', '2018-11-07 16:03:00', NULL, 1, NULL, '2017-03-07 14:07:06', '2017-03-07 14:07:06'),
(3, 1, 2, 'Test the events on calendar', 'sample to test', '2018-12-07 16:00:00', '2018-12-07 18:00:00', NULL, 1, NULL, '2017-03-07 14:07:53', '2017-03-07 14:07:53'),
(4, 1, 3, 'Site task test will take half month', 'test task', '2018-11-07 00:00:00', '2018-11-22 00:00:00', NULL, 1, NULL, '2017-03-07 14:08:53', '2017-03-07 14:08:53'),
(5, 1, 0, 'my test note i just test', 'my test note i just test', '2018-09-22 00:00:00', '2018-09-22 00:00:00', NULL, 1, NULL, '2017-03-07 14:09:26', '2017-03-07 14:09:26');

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

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

CREATE TABLE `smartend_maps` (
  `id` int(10) UNSIGNED NOT NULL,
  `topic_id` int(11) NOT NULL,
  `longitude` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `latitude` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title_ar` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title_en` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `details_ar` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `details_en` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon` tinyint(4) NOT NULL,
  `status` tinyint(4) NOT NULL,
  `row_no` int(11) 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `smartend_menus` (
  `id` int(10) UNSIGNED NOT NULL,
  `row_no` int(11) NOT NULL,
  `father_id` int(11) NOT NULL,
  `title_ar` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title_en` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(4) NOT NULL,
  `type` tinyint(4) NOT NULL,
  `cat_id` int(11) DEFAULT NULL,
  `link` varchar(191) COLLATE utf8mb4_unicode_ci 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_menus`
--

INSERT INTO `smartend_menus` (`id`, `row_no`, `father_id`, `title_ar`, `title_en`, `status`, `type`, `cat_id`, `link`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, 1, 0, 'القائمة الرئيسية', 'Main Menu', 1, 0, 0, '', 1, NULL, '2017-03-06 11:06:24', '2017-03-06 11:06:24'),
(2, 2, 0, 'روابط سريعة', 'Quick Links', 1, 0, 0, '', 1, NULL, '2017-03-06 11:06:24', '2017-03-06 11:06:24'),
(3, 1, 1, 'الرئيسية', 'Home', 1, 1, 0, 'home', 1, NULL, '2017-03-06 11:06:24', '2017-03-06 11:06:24'),
(4, 2, 1, 'من نحن', 'About', 1, 1, 0, 'topic/about', 1, NULL, '2017-03-06 11:06:24', '2017-03-06 11:06:24'),
(5, 3, 1, 'خدماتنا', 'Services', 1, 3, 2, '', 1, NULL, '2017-03-06 11:06:24', '2017-03-06 11:06:24'),
(6, 4, 1, 'أخبارنا', 'News', 1, 2, 3, '', 1, NULL, '2017-03-06 11:06:24', '2017-03-06 11:06:24'),
(7, 5, 1, 'الصور', 'Photos', 1, 2, 4, '', 1, NULL, '2017-03-06 11:06:24', '2017-03-06 11:06:24'),
(8, 6, 1, 'الفيديو', 'Videos', 1, 3, 5, '', 1, NULL, '2017-03-06 11:06:24', '2017-03-06 11:06:24'),
(9, 7, 1, 'الصوتيات', 'Audio', 1, 3, 6, '', 1, NULL, '2017-03-06 11:06:24', '2017-03-06 11:06:24'),
(10, 8, 1, 'المنتجات', 'Products', 1, 3, 8, '', 1, NULL, '2017-03-06 11:06:24', '2017-03-06 11:06:24'),
(11, 9, 1, 'المدونة', 'Blog', 1, 2, 7, '', 1, NULL, '2017-03-06 11:06:24', '2017-03-06 11:06:24'),
(12, 10, 1, 'اتصل بنا', 'Contact', 1, 1, 0, 'contact', 1, NULL, '2017-03-06 11:06:24', '2017-03-06 11:06:24'),
(13, 1, 2, 'الرئيسية', 'Home', 1, 1, 0, 'home', 1, NULL, '2017-03-06 11:06:24', '2017-03-06 11:06:24'),
(14, 2, 2, 'من نحن', 'About Us', 1, 1, 0, 'topic/about', 1, NULL, '2017-03-06 11:06:24', '2017-03-06 11:06:24'),
(15, 3, 2, 'المدونة', 'Blog', 1, 2, 7, '', 1, NULL, '2017-03-06 11:06:24', '2017-03-06 11:06:24'),
(16, 4, 2, 'الخصوصية', 'Privacy', 1, 1, 0, 'topic/privacy', 1, NULL, '2017-03-06 11:06:24', '2017-03-06 11:06:24'),
(17, 5, 2, 'الشروط والأحكام', 'Terms & Conditions', 1, 1, 0, 'topic/terms', 1, NULL, '2017-03-06 11:06:24', '2017-03-06 11:06:24'),
(18, 6, 2, 'اتصل بنا', 'Contact Us', 1, 1, 0, 'contact', 1, NULL, '2017-03-06 11:06:24', '2017-03-06 11:06:24');

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

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

CREATE TABLE `smartend_migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(191) COLLATE utf8mb4_unicode_ci 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_04_02_193005_create_translations_table', 1),
(2, '2014_10_12_000000_create_users_table', 1),
(3, '2014_10_12_100000_create_password_resets_table', 1),
(4, '2017_09_14_194216_create_webmaster_settings_table', 1),
(5, '2017_09_14_194251_create_webmaster_sections_table', 1),
(6, '2017_09_14_194259_create_webmaster_banners_table', 1),
(7, '2017_09_14_194307_create_webmails_groups_table', 1),
(8, '2017_09_14_194314_create_webmails_files_table', 1),
(9, '2017_09_14_194321_create_webmails_table', 1),
(10, '2017_09_14_194328_create_topics_table', 1),
(11, '2017_09_14_194334_create_settings_table', 1),
(12, '2017_09_14_194342_create_sections_table', 1),
(13, '2017_09_14_194349_create_photos_table', 1),
(14, '2017_09_14_194356_create_permissions_table', 1),
(15, '2017_09_14_194403_create_menus_table', 1),
(16, '2017_09_14_194409_create_maps_table', 1),
(17, '2017_09_14_194417_create_events_table', 1),
(18, '2017_09_14_194424_create_countries_table', 1),
(19, '2017_09_14_194431_create_contacts_groups_table', 1),
(20, '2017_09_14_194438_create_contacts_table', 1),
(21, '2017_09_14_194444_create_comments_table', 1),
(22, '2017_09_14_194452_create_banners_table', 1),
(23, '2017_09_14_194506_create_attach_files_table', 1),
(24, '2017_09_14_194514_create_analytics_visitors_table', 1),
(25, '2017_09_14_194521_create_analytics_pages_table', 1),
(26, '2017_10_06_113629_create_related_topics_table', 1),
(27, '2017_10_07_184011_create_topic_categories_table', 1),
(28, '2017_10_24_194251_create_webmaster_section_fields_table', 1),
(29, '2017_10_24_194304_create_topic_fields_table', 1);

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

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

CREATE TABLE `smartend_permissions` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci 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,
  `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,
  `webmaster_status` tinyint(4) NOT NULL DEFAULT 0,
  `data_sections` varchar(191) COLLATE utf8mb4_unicode_ci 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
) 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`, `analytics_status`, `inbox_status`, `newsletter_status`, `calendar_status`, `banners_status`, `settings_status`, `webmaster_status`, `data_sections`, `status`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, 'Webmaster', 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, '1,2,3,4,5,6,7,8,9', 1, 1, NULL, '2017-11-08 13:20:40', '2017-11-08 13:20:40'),
(2, 'Website Manager', 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, '1,2,3,4,5,6,7,8,9', 1, 1, NULL, '2017-11-08 13:20:40', '2017-11-08 13:20:40'),
(3, 'Limited User', 1, 1, 1, 0, 0, 0, 0, 1, 1, 0, 0, '1,2,3,4,5,6,7,8,9', 1, 1, NULL, '2017-11-08 13:20:40', '2017-11-08 13:20:40');

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

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

CREATE TABLE `smartend_photos` (
  `id` int(10) UNSIGNED NOT NULL,
  `topic_id` int(11) NOT NULL,
  `file` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `row_no` int(11) 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
) 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
(1, 9, '14888159357846.jpg', '14888146802295', 1, 1, NULL, '2017-03-06 13:58:55', '2017-03-06 13:58:55'),
(2, 9, '14888159356958.jpg', '14888146712437', 1, 1, NULL, '2017-03-06 13:58:55', '2017-03-06 13:58:55'),
(3, 9, '14888159357505.jpg', '14888155324481', 2, 1, NULL, '2017-03-06 13:58:55', '2017-03-06 13:58:55'),
(4, 12, '14888160421353.jpg', '14888159357505', 1, 1, NULL, '2017-03-06 14:00:42', '2017-03-06 14:00:42'),
(6, 12, '14888162827801.jpg', '14888159356958', 2, 1, NULL, '2017-03-06 14:04:42', '2017-03-06 14:04:42'),
(7, 23, '14888185569533.jpg', 'picjumbo.com_HNCK0183', 1, 1, NULL, '2017-03-06 14:42:36', '2017-03-06 14:42:36'),
(8, 23, '14888185564870.jpg', 'picjumbo.com_HNCK0210', 1, 1, NULL, '2017-03-06 14:42:36', '2017-03-06 14:42:36'),
(9, 23, '14888185567711.jpg', 'picjumbo.com_HNCK1748', 2, 1, NULL, '2017-03-06 14:42:36', '2017-03-06 14:42:36'),
(10, 23, '14888185565392.jpg', 'picjumbo.com_HNCK5322', 2, 1, NULL, '2017-03-06 14:42:36', '2017-03-06 14:42:36'),
(11, 23, '14888185563329.jpg', 'picjumbo.com_IMG_7167', 3, 1, NULL, '2017-03-06 14:42:36', '2017-03-06 14:42:36'),
(12, 23, '14888185566343.jpg', 'picjumbo.com_IMG_7172', 3, 1, NULL, '2017-03-06 14:42:36', '2017-03-06 14:42:36'),
(13, 23, '14888185561337.jpg', 'picjumbo.com_IMG_8868', 4, 1, NULL, '2017-03-06 14:42:36', '2017-03-06 14:42:36'),
(14, 23, '14888185564002.jpg', 'picjumbo.com_IMG_7961', 4, 1, NULL, '2017-03-06 14:42:36', '2017-03-06 14:42:36'),
(15, 24, '14888186143991.jpg', 'picjumbo.com_HNCK7801', 1, 1, NULL, '2017-03-06 14:43:34', '2017-03-06 14:43:34'),
(16, 24, '14888186147889.jpg', 'picjumbo.com_HNCK7784', 2, 1, NULL, '2017-03-06 14:43:34', '2017-03-06 14:43:34'),
(17, 24, '14888186147423.jpg', 'picjumbo.com_HNCK8360', 3, 1, NULL, '2017-03-06 14:43:34', '2017-03-06 14:43:34'),
(18, 24, '14888186141400.jpg', 'picjumbo.com_HNCK8458', 4, 1, NULL, '2017-03-06 14:43:34', '2017-03-06 14:43:34'),
(19, 24, '14888186147346.jpg', 'picjumbo.com_HNCK9016', 5, 1, NULL, '2017-03-06 14:43:34', '2017-03-06 14:43:34'),
(20, 24, '14888186141502.jpg', 'picjumbo.com_IMG_3212', 5, 1, NULL, '2017-03-06 14:43:34', '2017-03-06 14:43:34'),
(21, 24, '14888186143432.jpg', 'picjumbo.com_IMG_5992', 6, 1, NULL, '2017-03-06 14:43:34', '2017-03-06 14:43:34'),
(22, 24, '14888186147500.jpg', 'picjumbo.com_IMG_3640', 6, 1, NULL, '2017-03-06 14:43:34', '2017-03-06 14:43:34'),
(23, 25, '14888186704977.jpg', 'picjumbo.com_HNCK4011', 1, 1, NULL, '2017-03-06 14:44:30', '2017-03-06 14:44:30'),
(24, 25, '14888186701922.jpg', 'picjumbo.com_HNCK3988', 1, 1, NULL, '2017-03-06 14:44:30', '2017-03-06 14:44:30'),
(25, 25, '14888186716815.jpg', 'picjumbo.com_HNCK7802', 2, 1, NULL, '2017-03-06 14:44:31', '2017-03-06 14:44:31'),
(26, 25, '14888186711726.jpg', 'picjumbo.com_HNCK7775', 2, 1, NULL, '2017-03-06 14:44:31', '2017-03-06 14:44:31'),
(27, 25, '14888186715386.jpg', 'picjumbo.com_HNCK8404', 3, 1, NULL, '2017-03-06 14:44:31', '2017-03-06 14:44:31'),
(28, 25, '14888186717969.jpg', 'picjumbo.com_HNCK8478', 3, 1, NULL, '2017-03-06 14:44:31', '2017-03-06 14:44:31'),
(29, 25, '14888186717433.jpg', 'picjumbo.com_HNCK8495', 4, 1, NULL, '2017-03-06 14:44:31', '2017-03-06 14:44:31'),
(30, 25, '14888186717917.jpg', 'picjumbo.com_HNCK8991', 4, 1, NULL, '2017-03-06 14:44:31', '2017-03-06 14:44:31'),
(31, 26, '14888187058652.jpg', 'picjumbo.com_HNCK0210', 1, 1, NULL, '2017-03-06 14:45:05', '2017-03-06 14:45:05'),
(32, 26, '14888187054122.jpg', 'picjumbo.com_HNCK0183', 1, 1, NULL, '2017-03-06 14:45:05', '2017-03-06 14:45:05'),
(33, 26, '14888187065068.jpg', 'picjumbo.com_HNCK1748', 2, 1, NULL, '2017-03-06 14:45:06', '2017-03-06 14:45:06'),
(34, 26, '14888187067771.jpg', 'picjumbo.com_HNCK5322', 2, 1, NULL, '2017-03-06 14:45:06', '2017-03-06 14:45:06'),
(35, 26, '14888187065221.jpg', 'picjumbo.com_IMG_7167', 3, 1, NULL, '2017-03-06 14:45:06', '2017-03-06 14:45:06'),
(36, 26, '14888187065292.jpg', 'picjumbo.com_IMG_7172', 3, 1, NULL, '2017-03-06 14:45:06', '2017-03-06 14:45:06'),
(37, 26, '14888187061421.jpg', 'picjumbo.com_IMG_8868', 4, 1, NULL, '2017-03-06 14:45:06', '2017-03-06 14:45:06'),
(38, 26, '14888187063601.jpg', 'picjumbo.com_IMG_7961', 4, 1, NULL, '2017-03-06 14:45:06', '2017-03-06 14:45:06');

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

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

CREATE TABLE `smartend_related_topics` (
  `id` int(10) UNSIGNED NOT NULL,
  `topic_id` int(11) NOT NULL,
  `topic2_id` int(11) NOT NULL,
  `row_no` int(11) 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `smartend_related_topics`
--

INSERT INTO `smartend_related_topics` (`id`, `topic_id`, `topic2_id`, `row_no`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, 5, 32, 1, 1, NULL, '2017-11-12 01:30:30', '2017-11-12 01:30:30'),
(2, 5, 33, 2, 1, NULL, '2017-11-12 01:30:30', '2017-11-12 01:30:30');

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

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

CREATE TABLE `smartend_sections` (
  `id` int(10) UNSIGNED NOT NULL,
  `title_ar` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title_en` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `photo` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(4) NOT NULL,
  `visits` int(11) NOT NULL,
  `webmaster_id` int(11) NOT NULL,
  `father_id` int(11) NOT NULL,
  `row_no` int(11) NOT NULL,
  `seo_title_ar` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `seo_title_en` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `seo_description_ar` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `seo_description_en` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `seo_keywords_ar` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `seo_keywords_en` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `seo_url_slug_ar` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `seo_url_slug_en` varchar(191) COLLATE utf8mb4_unicode_ci 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_sections`
--

INSERT INTO `smartend_sections` (`id`, `title_ar`, `title_en`, `photo`, `icon`, `status`, `visits`, `webmaster_id`, `father_id`, `row_no`, `seo_title_ar`, `seo_title_en`, `seo_description_ar`, `seo_description_en`, `seo_keywords_ar`, `seo_keywords_en`, `seo_url_slug_ar`, `seo_url_slug_en`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(28, NULL, 'Alakesh Ghosh', NULL, NULL, 1, 0, 4, 0, 1, NULL, 'ddd', NULL, NULL, NULL, NULL, '', 'ddd', 1, 1, '2021-02-13 23:45:04', '2021-02-13 23:46:50'),
(29, NULL, 'ddd', NULL, NULL, 1, 0, 5, 0, 1, NULL, 'ddd', NULL, NULL, NULL, NULL, '', '', 1, NULL, '2021-02-13 23:45:51', '2021-02-13 23:45:51'),
(30, NULL, 'Bishwajit Goswami', NULL, NULL, 1, 0, 4, 0, 2, NULL, 'Bishwajit Goswami', NULL, NULL, NULL, NULL, '', 'bishwajit-goswami', 1, NULL, '2021-02-13 23:47:16', '2021-02-13 23:47:16'),
(31, NULL, 'Shruti Gupta Kasana', NULL, NULL, 1, 0, 4, 0, 3, NULL, 'Shruti Gupta Kasana', NULL, NULL, NULL, NULL, '', 'shruti-gupta-kasana', 1, NULL, '2021-02-13 23:47:32', '2021-02-13 23:47:32'),
(32, NULL, 'Afrozaa Jamil Konka', NULL, NULL, 1, 0, 4, 0, 4, NULL, 'Afrozaa Jamil Konka', NULL, NULL, NULL, NULL, '', 'afrozaa-jamil-konka', 1, NULL, '2021-02-13 23:47:47', '2021-02-13 23:47:47'),
(33, NULL, 'Sourav Chowdhury', NULL, NULL, 1, 0, 4, 0, 5, NULL, 'Sourav Chowdhury', NULL, NULL, NULL, NULL, '', 'sourav-chowdhury', 1, NULL, '2021-02-13 23:47:58', '2021-02-13 23:47:58');

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

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

CREATE TABLE `smartend_settings` (
  `id` int(10) UNSIGNED NOT NULL,
  `site_title_ar` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `site_title_en` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `site_desc_ar` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `site_desc_en` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `site_keywords_ar` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `site_keywords_en` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `site_webmails` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `notify_messages_status` tinyint(4) DEFAULT NULL,
  `notify_comments_status` tinyint(4) DEFAULT NULL,
  `notify_orders_status` tinyint(4) DEFAULT NULL,
  `site_url` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `site_status` tinyint(4) NOT NULL,
  `close_msg` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `social_link1` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `social_link2` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `social_link3` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `social_link4` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `social_link5` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `social_link6` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `social_link7` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `social_link8` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `social_link9` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `social_link10` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact_t1_ar` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact_t1_en` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact_t3` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact_t4` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact_t5` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact_t6` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact_t7_ar` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact_t7_en` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `style_logo_ar` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `style_logo_en` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `style_fav` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `style_apple` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `style_color1` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `style_color2` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `style_type` tinyint(4) DEFAULT NULL,
  `style_bg_type` tinyint(4) DEFAULT NULL,
  `style_bg_pattern` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `style_bg_color` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `style_bg_image` varchar(191) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `style_preload` tinyint(4) 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_settings`
--

INSERT INTO `smartend_settings` (`id`, `site_title_ar`, `site_title_en`, `site_desc_ar`, `site_desc_en`, `site_keywords_ar`, `site_keywords_en`, `site_webmails`, `notify_messages_status`, `notify_comments_status`, `notify_orders_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_ar`, `contact_t1_en`, `contact_t3`, `contact_t4`, `contact_t5`, `contact_t6`, `contact_t7_ar`, `contact_t7_en`, `style_logo_ar`, `style_logo_en`, `style_fav`, `style_apple`, `style_color1`, `style_color2`, `style_type`, `style_bg_type`, `style_bg_pattern`, `style_bg_color`, `style_bg_image`, `style_subscribe`, `style_footer`, `style_header`, `style_footer_bg`, `style_preload`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, '', 'Black Story | Gallery Cosmos', '', 'Black Story', '', 'key, words, website, web', 'support@smartfordesign.com', 1, 1, 1, '', 1, 'Website under maintenance \r\n<h1>Comming SOON</h1>', '#', '#', '#', '#', '#', '#', '#', '#', '#', '#', '', 'Building, Street name, City, Country', '+(00) 0123456789', '+(00) 0123456789', '+(00) 0123456789', 'info@sitename.com', '', 'Sunday to Thursday 08:00 AM to 05:00 PM', '14888091199919.png', '16136217991621.png', '16136217992583.png', '16136217996547.png', '#188a16', '#2e3e4e', 0, 0, NULL, '#2e3e4e', NULL, 1, 1, 0, '', 0, 1, 1, '2017-03-06 11:06:23', '2021-02-17 22:16:39');

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

--
-- Table structure for table `smartend_subscriber`
--

CREATE TABLE `smartend_subscriber` (
  `id` int(10) NOT NULL,
  `name` varchar(256) NOT NULL,
  `email` varchar(256) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `smartend_subscriber`
--

INSERT INTO `smartend_subscriber` (`id`, `name`, `email`, `created_at`, `updated_at`) VALUES
(1, 'admin example', 'admin@admin.com', '2021-02-13 21:06:55', '2021-02-13 21:06:55'),
(2, 'admin example', 'flimaker@admin.com', '2021-02-13 21:08:45', '2021-02-13 21:08:45'),
(3, 'admin example', 'info@stsit.org', '2021-02-13 21:40:08', '2021-02-13 21:40:08'),
(4, 'admin example', 'me002.hub@gmail.com', '2021-02-13 21:42:59', '2021-02-13 21:42:59'),
(5, 'admin example', 'niloysaha40@gmail.com', '2021-02-13 21:50:16', '2021-02-13 21:50:16'),
(6, 'admin example', 'niloysaha40@gmail.com', '2021-02-13 21:50:16', '2021-02-13 21:50:16'),
(7, 'admin example', 'me002.hub@gmail.com', '2021-02-13 21:52:30', '2021-02-13 21:52:30'),
(8, 'admin example', 'me002.hub@gmail.com', '2021-02-13 21:54:48', '2021-02-13 21:54:48'),
(9, 'admin example', 'me002.hub@gmail.com', '2021-02-13 21:56:42', '2021-02-13 21:56:42'),
(10, 'admin example', 'me002.hub@gmail.com', '2021-02-13 21:57:40', '2021-02-13 21:57:40'),
(11, 'admin example', 'me002.hub@gmail.com', '2021-02-13 21:58:24', '2021-02-13 21:58:24'),
(12, 'asht', 'me002.hub@gmail.com', '2021-02-13 21:59:36', '2021-02-13 21:59:36'),
(13, 'admin example', 'niloysaha40@gmail.com', '2021-02-13 22:03:32', '2021-02-13 22:03:32'),
(14, 'admin example', 'me002.hub@gmail.com', '2021-02-13 22:04:27', '2021-02-13 22:04:27'),
(15, 'admin example', 'me002.hub@gmail.com', '2021-02-13 22:05:37', '2021-02-13 22:05:37'),
(16, 'admin example', 'me002.hub@gmail.com', '2021-02-13 22:34:24', '2021-02-13 22:34:24');

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

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

CREATE TABLE `smartend_topics` (
  `id` int(10) UNSIGNED NOT NULL,
  `title_ar` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title_en` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `details_ar` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `details_en` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` date DEFAULT NULL,
  `expire_date` date DEFAULT NULL,
  `video_type` tinyint(4) DEFAULT NULL,
  `photo_file` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `attach_file` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `video_file` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audio_file` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(4) NOT NULL,
  `visits` int(11) NOT NULL,
  `webmaster_id` int(11) NOT NULL,
  `section_id` int(11) NOT NULL,
  `row_no` int(11) NOT NULL,
  `seo_title_ar` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `seo_title_en` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `seo_description_ar` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `seo_description_en` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `seo_keywords_ar` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `seo_keywords_en` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `seo_url_slug_ar` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `seo_url_slug_en` varchar(191) COLLATE utf8mb4_unicode_ci 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_topics`
--

INSERT INTO `smartend_topics` (`id`, `title_ar`, `title_en`, `details_ar`, `details_en`, `date`, `expire_date`, `video_type`, `photo_file`, `attach_file`, `video_file`, `audio_file`, `icon`, `status`, `visits`, `webmaster_id`, `section_id`, `row_no`, `seo_title_ar`, `seo_title_en`, `seo_description_ar`, `seo_description_en`, `seo_keywords_ar`, `seo_keywords_en`, `seo_url_slug_ar`, `seo_url_slug_en`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(3, NULL, 'GEORGE Floyd', NULL, NULL, '2021-02-14', NULL, NULL, '16132836423544.jpg', NULL, NULL, NULL, NULL, 1, 0, 4, 0, 1, NULL, 'GEORGE Floyd', '', '', NULL, NULL, '', 'george-floyd', 1, NULL, '2021-02-14 00:20:42', '2021-02-14 00:20:42'),
(4, NULL, 'Humanity', NULL, NULL, '2021-02-14', NULL, NULL, '16132837154528.jpg', NULL, NULL, NULL, NULL, 1, 0, 4, 0, 2, NULL, 'Humanit', '', '', NULL, NULL, '', 'humanit', 1, NULL, '2021-02-14 00:21:55', '2021-02-14 00:21:55'),
(5, NULL, 'Black Humanity', NULL, NULL, '2021-02-14', NULL, NULL, '16132837495011.jpg', NULL, NULL, NULL, NULL, 1, 0, 4, 0, 3, NULL, 'Black Humanity', '', '', NULL, NULL, '', 'black-humanity', 1, NULL, '2021-02-14 00:22:29', '2021-02-14 00:22:29'),
(7, NULL, 'Black Humanity', NULL, NULL, '2021-02-14', NULL, NULL, '16132838214410.jpg', NULL, NULL, NULL, NULL, 1, 0, 4, 0, 4, NULL, 'Black Humanity', '', '', NULL, NULL, '', '', 1, NULL, '2021-02-14 00:23:41', '2021-02-14 00:23:41'),
(8, NULL, 'Humanity', NULL, NULL, '2021-02-14', NULL, NULL, '16132838519887.jpg', NULL, NULL, NULL, NULL, 1, 0, 4, 0, 5, NULL, 'Humanity', '', '', NULL, NULL, '', 'humanity', 1, NULL, '2021-02-14 00:24:11', '2021-02-14 00:24:11'),
(9, NULL, 'Martin Luther King', NULL, NULL, '2021-02-14', NULL, NULL, '16132838817830.jpg', NULL, NULL, NULL, NULL, 1, 0, 4, 0, 6, NULL, 'Martin Luther King', '', '', NULL, NULL, '', 'martin-luther-king', 1, NULL, '2021-02-14 00:24:41', '2021-02-14 00:24:41'),
(10, NULL, 'Humanity', NULL, NULL, '2021-02-14', NULL, NULL, '16132839277756.jpg', NULL, NULL, NULL, NULL, 1, 0, 4, 0, 7, NULL, 'Humanity', '', '', NULL, NULL, '', '', 1, NULL, '2021-02-14 00:25:27', '2021-02-14 00:25:27'),
(11, NULL, 'Humanity', NULL, NULL, '2021-02-14', NULL, NULL, '16132839595111.jpg', NULL, NULL, NULL, NULL, 1, 0, 4, 0, 8, NULL, 'Humanity', '', '', NULL, NULL, '', '', 1, NULL, '2021-02-14 00:25:59', '2021-02-14 00:25:59'),
(12, NULL, 'Kamala Harris', NULL, NULL, '2021-02-14', NULL, NULL, '16132839951641.jpeg', NULL, NULL, NULL, NULL, 1, 0, 4, 0, 9, NULL, 'Kamala Harris', '', '', NULL, NULL, '', 'kamala-harris', 1, NULL, '2021-02-14 00:26:35', '2021-02-14 00:26:35'),
(13, NULL, 'I can`t BREATHE 1', NULL, NULL, '2021-02-17', NULL, NULL, '16135389415174.jpg', NULL, NULL, NULL, NULL, 1, 0, 4, 0, 10, NULL, 'I can`t BREATHE 1', '', '', NULL, NULL, '', 'i-cant-breathe-1', 1, NULL, '2021-02-16 23:15:41', '2021-02-16 23:15:41'),
(14, NULL, 'I can\'t BREATHE 2', NULL, NULL, '2021-02-17', NULL, NULL, '16135389857107.jpg', NULL, NULL, NULL, NULL, 1, 0, 4, 0, 11, NULL, 'I can\'t BREATHE 2', '', '', NULL, NULL, '', 'i-cant-breathe-2', 1, NULL, '2021-02-16 23:16:25', '2021-02-16 23:16:25'),
(15, NULL, 'Black Lives Matter', NULL, NULL, '2021-02-17', NULL, NULL, '16135390272261.jpg', NULL, NULL, NULL, NULL, 1, 0, 4, 0, 12, NULL, 'Black Lives Matter', '', '', NULL, NULL, '', 'black-lives-matter', 1, NULL, '2021-02-16 23:17:07', '2021-02-16 23:17:07'),
(16, NULL, 'Harvest of SHAME! Photo manipulation using archival images on cotton field slaves', NULL, NULL, '2021-02-17', NULL, NULL, '16135390897511.jpg', NULL, NULL, NULL, NULL, 1, 0, 4, 0, 13, NULL, 'Harvest of SHAME! Photo manipulation using archival images on cotton field slaves', '', '', NULL, NULL, '', 'harvest-of-shame-photo-manipulation-using-archival-images-on-cotton-field-slaves', 1, NULL, '2021-02-16 23:18:09', '2021-02-16 23:18:09'),
(17, NULL, 'Conservation (Mother & Child)', NULL, NULL, '2021-02-17', NULL, NULL, '16135393056586.jpg', NULL, NULL, NULL, NULL, 1, 0, 4, 0, 14, NULL, 'Conservation (Mother & Child)', '', '', NULL, NULL, '', 'conservation-mother-child', 1, NULL, '2021-02-16 23:21:45', '2021-02-16 23:21:45'),
(18, NULL, 'Shield of family', NULL, NULL, '2021-02-17', NULL, NULL, '16135393441776.jpg', NULL, NULL, NULL, NULL, 1, 0, 4, 0, 15, NULL, 'Shield of family', '', '', NULL, NULL, '', 'shield-of-family', 1, NULL, '2021-02-16 23:22:24', '2021-02-16 23:22:24'),
(19, NULL, 'Beautiful is Beautiful!', NULL, NULL, '2021-02-17', NULL, NULL, '16135395097321.jpg', NULL, NULL, NULL, NULL, 1, 0, 4, 0, 16, NULL, 'Beautiful is Beautiful!', '', '', NULL, NULL, '', 'beautiful-is-beautiful', 1, NULL, '2021-02-16 23:25:09', '2021-02-16 23:25:09'),
(20, NULL, 'The kiss', NULL, NULL, '2021-02-17', NULL, NULL, '16135395638242.jpg', NULL, NULL, NULL, NULL, 1, 0, 4, 0, 17, NULL, 'The kiss', '', '', NULL, NULL, '', 'the-kiss', 1, NULL, '2021-02-16 23:26:03', '2021-02-16 23:26:03'),
(21, NULL, 'Black lives matter 2', NULL, NULL, '2021-02-17', NULL, NULL, '16135395968286.jpg', NULL, NULL, NULL, NULL, 1, 0, 4, 0, 18, NULL, 'Black lives matter 2', '', '', NULL, NULL, '', 'black-lives-matter-2', 1, NULL, '2021-02-16 23:26:36', '2021-02-16 23:26:36'),
(22, NULL, 'Black lives matter 1', NULL, NULL, '2021-02-17', NULL, NULL, '16135396392583.jpg', NULL, NULL, NULL, NULL, 1, 0, 4, 0, 19, NULL, 'Black lives matter 1', '', '', NULL, NULL, '', 'black-lives-matter-1', 1, NULL, '2021-02-16 23:27:19', '2021-02-16 23:27:19'),
(23, NULL, 'Black Lives Matter', NULL, NULL, '2021-02-17', NULL, NULL, '16135397992386.jpg', NULL, NULL, NULL, NULL, 1, 0, 4, 0, 20, NULL, 'Black Lives Matter', '', '', NULL, NULL, '', '', 1, NULL, '2021-02-16 23:29:59', '2021-02-16 23:29:59'),
(24, NULL, 'Black Lives Matter', NULL, NULL, '2021-02-17', NULL, NULL, '16135398461954.jpg', NULL, NULL, NULL, NULL, 1, 0, 4, 0, 21, NULL, 'Black Lives Matter', '', '', NULL, NULL, '', '', 1, NULL, '2021-02-16 23:30:46', '2021-02-16 23:30:46'),
(25, NULL, 'Black Lives Matter', NULL, NULL, '2021-02-17', NULL, NULL, '16135398813035.jpg', NULL, NULL, NULL, NULL, 1, 0, 4, 0, 22, NULL, 'Black Lives Matter', '', '', NULL, NULL, '', '', 1, NULL, '2021-02-16 23:31:21', '2021-02-16 23:31:21'),
(26, NULL, 'Black Lives Matter', NULL, NULL, '2021-02-17', NULL, NULL, '16135399302783.jpg', NULL, NULL, NULL, NULL, 1, 0, 4, 0, 23, NULL, 'Black Lives Matter', '', '', NULL, NULL, '', '', 1, NULL, '2021-02-16 23:32:10', '2021-02-16 23:32:10'),
(27, NULL, 'Black Lives Matter', NULL, NULL, '2021-02-17', NULL, NULL, '16135399627754.jpg', NULL, NULL, NULL, NULL, 1, 0, 4, 0, 24, NULL, 'Black Lives Matter', '', '', NULL, NULL, '', '', 1, NULL, '2021-02-16 23:32:42', '2021-02-16 23:32:42');

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

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

CREATE TABLE `smartend_topic_categories` (
  `id` int(10) UNSIGNED NOT NULL,
  `topic_id` int(11) NOT NULL,
  `section_id` int(11) 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
(1, 27, 8, '2017-11-08 19:39:43', '2017-11-08 19:39:43'),
(2, 27, 9, '2017-11-08 19:39:43', '2017-11-08 19:39:43'),
(3, 27, 12, '2017-11-08 19:39:43', '2017-11-08 19:39:43'),
(4, 28, 8, '2017-11-08 19:39:58', '2017-11-08 19:39:58'),
(5, 28, 9, '2017-11-08 19:39:58', '2017-11-08 19:39:58'),
(6, 28, 10, '2017-11-08 19:39:58', '2017-11-08 19:39:58'),
(7, 28, 14, '2017-11-08 19:39:58', '2017-11-08 19:39:58'),
(8, 29, 8, '2017-11-08 19:40:15', '2017-11-08 19:40:15'),
(9, 29, 9, '2017-11-08 19:40:15', '2017-11-08 19:40:15'),
(10, 29, 10, '2017-11-08 19:40:15', '2017-11-08 19:40:15'),
(11, 29, 12, '2017-11-08 19:40:15', '2017-11-08 19:40:15'),
(12, 36, 15, '2017-11-08 19:40:48', '2017-11-08 19:40:48'),
(13, 36, 16, '2017-11-08 19:40:48', '2017-11-08 19:40:48'),
(14, 36, 18, '2017-11-08 19:40:48', '2017-11-08 19:40:48'),
(15, 37, 16, '2017-11-08 19:40:58', '2017-11-08 19:40:58'),
(16, 37, 17, '2017-11-08 19:40:58', '2017-11-08 19:40:58'),
(17, 15, 1, '2017-11-08 19:42:12', '2017-11-08 19:42:12'),
(18, 15, 2, '2017-11-08 19:42:12', '2017-11-08 19:42:12'),
(19, 16, 5, '2017-11-08 19:42:26', '2017-11-08 19:42:26'),
(20, 16, 6, '2017-11-08 19:42:26', '2017-11-08 19:42:26'),
(21, 17, 3, '2017-11-08 19:42:35', '2017-11-08 19:42:35'),
(22, 18, 1, '2017-11-08 19:42:52', '2017-11-08 19:42:52'),
(23, 18, 6, '2017-11-08 19:42:52', '2017-11-08 19:42:52'),
(24, 19, 1, '2017-11-08 19:43:02', '2017-11-08 19:43:02'),
(25, 20, 3, '2017-11-08 19:43:10', '2017-11-08 19:43:10'),
(26, 21, 1, '2017-11-08 19:43:24', '2017-11-08 19:43:24'),
(27, 21, 2, '2017-11-08 19:43:24', '2017-11-08 19:43:24'),
(28, 21, 3, '2017-11-08 19:43:24', '2017-11-08 19:43:24'),
(29, 22, 2, '2017-11-08 19:43:35', '2017-11-08 19:43:35'),
(30, 22, 4, '2017-11-08 19:43:35', '2017-11-08 19:43:35'),
(42, 32, 19, '2017-11-08 19:47:30', '2017-11-08 19:47:30'),
(43, 32, 20, '2017-11-08 19:47:30', '2017-11-08 19:47:30'),
(44, 33, 22, '2017-11-08 19:48:03', '2017-11-08 19:48:03'),
(45, 34, 21, '2017-11-08 19:48:16', '2017-11-08 19:48:16'),
(46, 35, 19, '2017-11-08 19:48:32', '2017-11-08 19:48:32'),
(47, 35, 20, '2017-11-08 19:48:32', '2017-11-08 19:48:32'),
(48, 35, 21, '2017-11-08 19:48:32', '2017-11-08 19:48:32'),
(49, 50, 8, '2021-02-13 22:40:05', '2021-02-13 22:40:05'),
(52, 3, 28, '2021-02-14 00:20:42', '2021-02-14 00:20:42'),
(53, 4, 28, '2021-02-14 00:21:55', '2021-02-14 00:21:55'),
(54, 5, 28, '2021-02-14 00:22:29', '2021-02-14 00:22:29'),
(56, 7, 28, '2021-02-14 00:23:41', '2021-02-14 00:23:41'),
(57, 8, 28, '2021-02-14 00:24:11', '2021-02-14 00:24:11'),
(58, 9, 28, '2021-02-14 00:24:41', '2021-02-14 00:24:41'),
(59, 10, 28, '2021-02-14 00:25:27', '2021-02-14 00:25:27'),
(60, 11, 28, '2021-02-14 00:25:59', '2021-02-14 00:25:59'),
(61, 12, 28, '2021-02-14 00:26:35', '2021-02-14 00:26:35'),
(62, 13, 30, '2021-02-16 23:15:41', '2021-02-16 23:15:41'),
(63, 14, 30, '2021-02-16 23:16:25', '2021-02-16 23:16:25'),
(64, 15, 30, '2021-02-16 23:17:07', '2021-02-16 23:17:07'),
(65, 16, 30, '2021-02-16 23:18:09', '2021-02-16 23:18:09'),
(66, 17, 31, '2021-02-16 23:21:45', '2021-02-16 23:21:45'),
(67, 18, 31, '2021-02-16 23:22:24', '2021-02-16 23:22:24'),
(68, 19, 32, '2021-02-16 23:25:09', '2021-02-16 23:25:09'),
(69, 20, 32, '2021-02-16 23:26:03', '2021-02-16 23:26:03'),
(70, 21, 32, '2021-02-16 23:26:36', '2021-02-16 23:26:36'),
(71, 22, 32, '2021-02-16 23:27:19', '2021-02-16 23:27:19'),
(72, 23, 33, '2021-02-16 23:29:59', '2021-02-16 23:29:59'),
(73, 24, 33, '2021-02-16 23:30:46', '2021-02-16 23:30:46'),
(74, 25, 33, '2021-02-16 23:31:21', '2021-02-16 23:31:21'),
(75, 26, 33, '2021-02-16 23:32:10', '2021-02-16 23:32:10'),
(76, 27, 33, '2021-02-16 23:32:42', '2021-02-16 23:32:42');

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

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

CREATE TABLE `smartend_topic_fields` (
  `id` int(10) UNSIGNED NOT NULL,
  `topic_id` int(11) NOT NULL,
  `field_id` int(11) NOT NULL,
  `field_value` text COLLATE utf8mb4_unicode_ci 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_topic_fields`
--

INSERT INTO `smartend_topic_fields` (`id`, `topic_id`, `field_id`, `field_value`, `created_at`, `updated_at`) VALUES
(11, 3, 3, 'GEORGE Floyd,\r\n60x45 cm, 2020', '2021-02-14 00:20:42', '2021-02-14 00:20:42'),
(12, 4, 3, 'Humanity,\r\n100x50 cm, 2020', '2021-02-14 00:21:55', '2021-02-14 00:21:55'),
(13, 5, 3, 'Black Humanity,\r\n38x56 cm, 2020', '2021-02-14 00:22:29', '2021-02-14 00:22:29'),
(15, 7, 3, 'Black Humanity,\r\n38x56 cm, 2020', '2021-02-14 00:23:41', '2021-02-14 00:23:41'),
(16, 8, 3, 'Humanity,\r\n60x60 cm, 2020', '2021-02-14 00:24:11', '2021-02-14 00:24:11'),
(17, 9, 3, 'Martin Luther King, Jr.,\r\n50x50 cm, 2020', '2021-02-14 00:24:41', '2021-02-14 00:24:41'),
(18, 10, 3, 'Humanity,\r\n50x60 cm, 2020', '2021-02-14 00:25:27', '2021-02-14 00:25:27'),
(19, 11, 3, 'Humanity,\r\n76x91cm, 2020', '2021-02-14 00:25:59', '2021-02-14 00:25:59'),
(20, 12, 3, 'Kamala Harris,\r\nAcrylic on Canvas,\r\n65x75 cm, 2021', '2021-02-14 00:26:35', '2021-02-14 00:26:35'),
(21, 13, 3, '113X143cm, 2020\r\nCharcoal, color pencil', '2021-02-16 23:15:41', '2021-02-16 23:15:41'),
(22, 14, 3, '50X70 cm, 2020,\r\nAcrylic, ink, pigment colors on\r\ncanvas', '2021-02-16 23:16:25', '2021-02-16 23:16:25'),
(23, 15, 3, '33X42 cm, 2020,\r\nAcrylic, ink, pigment colors on\r\ncanvas', '2021-02-16 23:17:07', '2021-02-16 23:17:07'),
(24, 16, 3, '60X685 cm, 2020\r\nArchival photo print', '2021-02-16 23:18:09', '2021-02-16 23:18:09'),
(25, 17, 3, '61x 46 cm\r\n2021', '2021-02-16 23:21:45', '2021-02-16 23:21:45'),
(26, 18, 3, '68x50 cm, 2021', '2021-02-16 23:22:24', '2021-02-16 23:22:24'),
(27, 19, 3, 'Acrylic on canvas\r\n46x56 cm\r\n2021', '2021-02-16 23:25:09', '2021-02-16 23:25:09'),
(28, 20, 3, 'Acrylic on canvas\r\n46x56 cm\r\n2021', '2021-02-16 23:26:03', '2021-02-16 23:26:03'),
(29, 21, 3, 'Acrylic on Handmade paper\r\n57x77 cm\r\n2021', '2021-02-16 23:26:36', '2021-02-16 23:26:36'),
(30, 22, 3, 'Acrylic on Handmade paper\r\n57x77 cm\r\n2021', '2021-02-16 23:27:19', '2021-02-16 23:27:19'),
(31, 23, 3, 'Acrylic on Canvas,\r\n46x05 cm, 2020', '2021-02-16 23:29:59', '2021-02-16 23:29:59'),
(32, 24, 3, 'Acrylic on Canvas,\r\n27x30 cm, 2020', '2021-02-16 23:30:46', '2021-02-16 23:30:46'),
(33, 25, 3, 'Acrylic on Canvas,\r\n46x05 cm, 2020', '2021-02-16 23:31:21', '2021-02-16 23:31:21'),
(34, 26, 3, 'Acrylic on Canvas,\r\n91x91 cm, 2020', '2021-02-16 23:32:10', '2021-02-16 23:32:10'),
(35, 27, 3, 'Acrylic on Canvas,\r\n91x91 cm, 2020', '2021-02-16 23:32:42', '2021-02-16 23:32:42');

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

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

CREATE TABLE `smartend_webmails` (
  `id` int(10) 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `details` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` datetime NOT NULL,
  `from_email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `from_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `from_phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `to_email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `to_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `to_cc` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `to_bcc` varchar(191) COLLATE utf8mb4_unicode_ci 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;

--
-- Dumping data for table `smartend_webmails`
--

INSERT INTO `smartend_webmails` (`id`, `cat_id`, `group_id`, `contact_id`, `father_id`, `title`, `details`, `date`, `from_email`, `from_name`, `from_phone`, `to_email`, `to_name`, `to_cc`, `to_bcc`, `status`, `flag`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, 0, 2, NULL, NULL, 'ORDER , Qty=12, Nullam mollis dolor', 'dfdfd', '2017-03-07 15:21:20', 'eng_m_mondy@hotmail.com', 'mohamed mondi', '01221485486', 'info@sitename.com', 'Smartend Laravel Site Preview', NULL, NULL, 0, 0, NULL, NULL, '2017-03-07 13:21:20', '2017-11-09 19:21:07'),
(2, 0, NULL, NULL, NULL, 'Need your help', 'Dear sir,\r\nI need your help to subscribe to your team. Please contact me as soon as possible.\r\n\r\nBest Regards', '2017-03-07 16:04:16', 'ayamen@site.com', 'Amar Yamen', '8378-475-466', 'info@sitename.com', 'Smartend Laravel Site Preview', NULL, NULL, 0, 0, NULL, NULL, '2017-03-07 14:04:16', '2017-11-09 19:21:07'),
(3, 0, 3, NULL, NULL, 'My test message to this site', 'I just test sending messages\r\nThanks', '2017-03-07 16:05:32', 'email@site.com', 'Donyo Hawa', '343423-543', 'info@sitename.com', 'Smartend Laravel Site Preview', NULL, NULL, 0, 0, NULL, NULL, '2017-03-07 14:05:32', '2017-11-09 19:21:07'),
(4, 0, 1, NULL, NULL, 'Contact me for support any time', 'This is a test message', '2017-03-07 16:10:29', 'email@site.com', 'MMondi', '7363758', 'info@sitename.com', 'Smartend Laravel Site Preview', NULL, NULL, 0, 0, NULL, NULL, '2017-03-07 14:10:29', '2017-11-09 19:21:07'),
(5, 0, NULL, NULL, NULL, 'Test mail delivery message', 'Dear team,\r\nThis is a Test mail delivery message\r\nThank you', '2017-03-07 21:06:41', 'email@site.com', 'Ramy Adams', '87557home', 'support@smartfordesign.com', 'Smartend Laravel Site Preview', NULL, NULL, 0, 0, NULL, NULL, '2017-03-08 02:06:41', '2017-11-09 19:21:07'),
(6, 0, NULL, NULL, NULL, 'Test mail delivery message', 'Dear team,\r\nThis is a Test mail delivery message\r\nThank you', '2017-03-07 21:08:54', 'email@site.com', 'Adam Ali', '3432423', 'support@smartfordesign.com', 'Smartend Laravel Site Preview', NULL, NULL, 0, 0, NULL, NULL, '2017-03-08 02:08:54', '2017-11-09 19:21:07'),
(7, 0, NULL, NULL, NULL, 'TEST', 'FCFCFC', '2021-02-11 07:32:12', 'niloysaha40@gmail.com', 'admin example', '01677100091', 'support@smartfordesign.com', 'Black Story | Gallery Cosmos', NULL, NULL, 0, 0, NULL, NULL, '2021-02-11 01:32:12', '2021-02-11 01:32:12'),
(8, 0, NULL, NULL, NULL, 'TEST', 'FCFCFC', '2021-02-11 07:32:12', 'niloysaha40@gmail.com', 'admin example', '01677100091', 'support@smartfordesign.com', 'Black Story | Gallery Cosmos', NULL, NULL, 0, 0, NULL, NULL, '2021-02-11 01:32:12', '2021-02-11 01:32:12'),
(9, 0, NULL, NULL, NULL, 'fgdfg', 'cdcd', '2021-02-14 03:09:55', 'niloysaha40@gmail.com', 'admin example', '01677100091', 'support@smartfordesign.com', 'Black Story | Gallery Cosmos', NULL, NULL, 1, 0, NULL, NULL, '2021-02-13 21:09:55', '2021-02-16 23:05:31');

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

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

CREATE TABLE `smartend_webmails_files` (
  `id` int(10) UNSIGNED NOT NULL,
  `webmail_id` int(11) NOT NULL,
  `file` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci 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` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `color` varchar(191) COLLATE utf8mb4_unicode_ci 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
) 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, '2017-03-07 14:10:58', '2017-03-07 14:10:58'),
(2, 'Orders', '#f44336', 1, NULL, '2017-03-07 14:11:04', '2017-03-07 14:11:04'),
(3, 'Queries', '#8bc34a', 1, NULL, '2017-03-07 14:11:37', '2017-03-07 14:11:37');

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

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

CREATE TABLE `smartend_webmaster_banners` (
  `id` int(10) UNSIGNED NOT NULL,
  `row_no` int(11) NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `width` int(11) NOT NULL,
  `height` int(11) NOT NULL,
  `desc_status` tinyint(4) NOT NULL,
  `link_status` tinyint(4) NOT NULL,
  `type` tinyint(4) NOT NULL,
  `icon_status` tinyint(4) NOT 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `smartend_webmaster_banners` (`id`, `row_no`, `name`, `width`, `height`, `desc_status`, `link_status`, `type`, `icon_status`, `status`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, 1, 'homeBanners', 1600, 500, 1, 1, 1, 0, 1, 1, 1, '2017-11-08 13:20:40', '2017-11-12 04:55:02'),
(2, 2, 'textBanners', 330, 330, 1, 1, 0, 1, 1, 1, NULL, '2017-11-08 13:20:40', '2017-11-08 13:20:40'),
(3, 3, 'sideBanners', 330, 330, 0, 1, 1, 0, 1, 1, NULL, '2017-11-08 13:20:40', '2017-11-08 13:20:40');

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

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

CREATE TABLE `smartend_webmaster_sections` (
  `id` int(10) UNSIGNED NOT NULL,
  `row_no` int(11) NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` tinyint(4) NOT NULL,
  `sections_status` tinyint(4) NOT NULL,
  `comments_status` tinyint(4) NOT NULL,
  `date_status` tinyint(4) NOT NULL,
  `expire_date_status` tinyint(4) NOT NULL,
  `longtext_status` tinyint(4) NOT NULL,
  `editor_status` tinyint(4) NOT NULL,
  `attach_file_status` tinyint(4) NOT NULL,
  `extra_attach_file_status` tinyint(4) NOT NULL,
  `multi_images_status` tinyint(4) NOT NULL,
  `section_icon_status` tinyint(4) NOT NULL,
  `icon_status` tinyint(4) NOT NULL,
  `maps_status` tinyint(4) NOT NULL,
  `order_status` tinyint(4) NOT NULL,
  `related_status` tinyint(4) NOT NULL,
  `status` tinyint(4) NOT NULL,
  `seo_title_ar` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `seo_title_en` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `seo_description_ar` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `seo_description_en` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `seo_keywords_ar` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `seo_keywords_en` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `seo_url_slug_ar` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `seo_url_slug_en` varchar(191) COLLATE utf8mb4_unicode_ci 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_webmaster_sections`
--

INSERT INTO `smartend_webmaster_sections` (`id`, `row_no`, `name`, `type`, `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`, `status`, `seo_title_ar`, `seo_title_en`, `seo_description_ar`, `seo_description_en`, `seo_keywords_ar`, `seo_keywords_en`, `seo_url_slug_ar`, `seo_url_slug_en`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, 1, 'sitePages', 0, 0, 0, 0, 0, 1, 1, 1, 0, 1, 1, 0, 1, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, '2017-11-08 13:20:40', '2021-02-13 23:53:02'),
(2, 2, 'services', 0, 0, 0, 0, 0, 1, 1, 1, 1, 1, 1, 0, 0, 1, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, '2017-11-08 13:20:40', '2021-02-13 23:53:19'),
(3, 3, 'news', 0, 0, 1, 1, 0, 1, 1, 0, 0, 1, 1, 0, 0, 0, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, '2017-11-08 13:20:40', '2021-02-13 23:53:34'),
(4, 4, 'Art', 1, 1, 1, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 1, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, '2017-11-08 13:20:40', '2021-02-13 23:56:04'),
(5, 5, 'videos', 2, 1, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2017-11-08 13:20:40', '2017-11-08 13:20:40'),
(6, 6, 'sounds', 3, 1, 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2017-11-08 13:20:40', '2017-11-08 13:20:40'),
(7, 7, 'blog', 0, 1, 1, 1, 0, 1, 1, 0, 0, 1, 1, 0, 0, 0, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2017-11-08 13:20:40', '2017-11-08 13:20:40'),
(8, 8, 'products', 0, 2, 1, 0, 0, 1, 1, 0, 0, 1, 1, 0, 0, 1, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, '2017-11-08 13:20:40', '2021-02-13 23:53:52'),
(9, 9, 'partners', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, '2017-11-08 13:20:40', '2021-02-13 23:54:10');

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

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

CREATE TABLE `smartend_webmaster_section_fields` (
  `id` int(10) UNSIGNED NOT NULL,
  `webmaster_id` int(11) NOT NULL,
  `type` int(11) NOT NULL,
  `title_ar` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title_en` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `default_value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `details_ar` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `details_en` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `row_no` int(11) NOT NULL,
  `status` tinyint(4) NOT NULL,
  `required` tinyint(4) NOT NULL,
  `lang_code` varchar(191) COLLATE utf8mb4_unicode_ci 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_webmaster_section_fields`
--

INSERT INTO `smartend_webmaster_section_fields` (`id`, `webmaster_id`, `type`, `title_ar`, `title_en`, `default_value`, `details_ar`, `details_en`, `row_no`, `status`, `required`, `lang_code`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, 8, 0, 'السعر', 'Price', NULL, NULL, NULL, 1, 1, 0, 'all', 1, NULL, '2017-11-08 19:45:57', '2017-11-08 19:45:57'),
(2, 8, 6, 'الحالة', 'Status', NULL, 'جديد\r\nمستعمل', 'New\r\nUsed', 2, 1, 0, 'all', 1, NULL, '2017-11-08 19:46:23', '2017-11-08 19:46:23'),
(3, 4, 1, NULL, 'Art Detais', 'Null', NULL, NULL, 1, 1, 0, 'en', 1, NULL, '2021-02-14 00:06:22', '2021-02-14 00:06:22');

--
-- Indexes for dumped tables
--

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

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

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

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

--
-- Indexes for table `smartend_comments`
--
ALTER TABLE `smartend_comments`
  ADD PRIMARY KEY (`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`);

--
-- Indexes for table `smartend_maps`
--
ALTER TABLE `smartend_maps`
  ADD PRIMARY KEY (`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`);

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

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

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

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

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

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

--
-- Indexes for table `smartend_topic_fields`
--
ALTER TABLE `smartend_topic_fields`
  ADD PRIMARY KEY (`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`);

--
-- 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`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `smartend_subscriber`
--
ALTER TABLE `smartend_subscriber`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `smartend_webmaster_section_fields`
--
ALTER TABLE `smartend_webmaster_section_fields`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
COMMIT;

