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

START TRANSACTION;



--
-- Database: `hgluckydraw2022v1`
--

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

--
-- Table structure for table `audit_logs`
--

CREATE TABLE `audit_logs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject_id` bigint(20) UNSIGNED DEFAULT NULL,
  `subject_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `properties` text COLLATE utf8mb4_unicode_ci,
  `host` varchar(46) 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 `audit_logs`
--

INSERT INTO `audit_logs` (`id`, `description`, `subject_id`, `subject_type`, `user_id`, `properties`, `host`, `created_at`, `updated_at`) VALUES
(1, 'audit:updated', 8, 'App\\Models\\LuckDrawData#8', 1, '{\"is_used\":1,\"updated_at\":\"2021-10-26 22:05:31\",\"id\":8}', '::1', '2021-10-26 14:05:31', '2021-10-26 14:05:31'),
(2, 'audit:created', 1, 'App\\Models\\CustomerLuckDrawData#1', 1, '{\"luck_draw_data_id\":8,\"customer_id\":1,\"entered_happy_code\":\"HHH\",\"status\":0,\"updated_at\":\"2021-10-26 22:05:31\",\"created_at\":\"2021-10-26 22:05:31\",\"id\":1,\"upload_photo\":null,\"media\":[]}', '::1', '2021-10-26 14:05:31', '2021-10-26 14:05:31'),
(3, 'audit:created', 2, 'App\\Models\\Customer#2', NULL, '{\"name\":\"kristy\",\"email\":\"it@thethymespa.com\",\"phone\":\"0177569933\",\"identity_card_number\":\"111\",\"dob\":\"1982-09-19\",\"shipping_address\":\"105\",\"state_id\":\"3\",\"city_id\":\"627\",\"status\":1,\"updated_at\":\"2021-10-26 23:25:25\",\"created_at\":\"2021-10-26 23:25:25\",\"id\":2,\"image\":null,\"media\":[]}', '::1', '2021-10-26 15:25:25', '2021-10-26 15:25:25'),
(4, 'audit:created', 1, 'App\\Models\\Survey#1', NULL, '{\"customer_id\":2,\"value_1\":\"Choco Grains\",\"value_2\":\"{\\\"2\\\":\\\"Kurma\\\"}\",\"updated_at\":\"2021-10-26 23:25:25\",\"created_at\":\"2021-10-26 23:25:25\",\"id\":1}', '::1', '2021-10-26 15:25:25', '2021-10-26 15:25:25'),
(5, 'audit:created', 2, 'App\\Models\\CustomerLuckDrawData#2', 2, '{\"customer_id\":2,\"entered_happy_code\":\"1234\",\"status\":4,\"updated_at\":\"2021-10-26 23:26:22\",\"created_at\":\"2021-10-26 23:26:22\",\"id\":2,\"upload_photo\":null,\"media\":[]}', '::1', '2021-10-26 15:26:22', '2021-10-26 15:26:22'),
(6, 'audit:updated', 2, 'App\\Models\\LuckDrawData#2', 2, '{\"is_used\":1,\"updated_at\":\"2021-10-27 21:11:40\",\"id\":2}', '::1', '2021-10-27 13:11:40', '2021-10-27 13:11:40'),
(7, 'audit:created', 3, 'App\\Models\\CustomerLuckDrawData#3', 2, '{\"luck_draw_data_id\":2,\"customer_id\":2,\"entered_happy_code\":\"BBB\",\"status\":0,\"updated_at\":\"2021-10-27 21:11:40\",\"created_at\":\"2021-10-27 21:11:40\",\"id\":3,\"upload_photo\":null,\"media\":[]}', '::1', '2021-10-27 13:11:40', '2021-10-27 13:11:40'),
(8, 'audit:created', 4, 'App\\Models\\CustomerLuckDrawData#4', 2, '{\"customer_id\":2,\"entered_happy_code\":\"1345444\",\"status\":6,\"updated_at\":\"2021-10-27 21:23:38\",\"created_at\":\"2021-10-27 21:23:38\",\"id\":4,\"upload_photo\":null,\"media\":[]}', '::1', '2021-10-27 13:23:38', '2021-10-27 13:23:38'),
(9, 'audit:created', 5, 'App\\Models\\CustomerLuckDrawData#5', 2, '{\"customer_id\":2,\"entered_happy_code\":\"131513111\",\"status\":6,\"updated_at\":\"2021-10-29 12:32:11\",\"created_at\":\"2021-10-29 12:32:11\",\"id\":5,\"upload_photo\":null,\"media\":[]}', '::1', '2021-10-29 04:32:12', '2021-10-29 04:32:12'),
(10, 'audit:created', 6, 'App\\Models\\CustomerLuckDrawData#6', 2, '{\"customer_id\":2,\"entered_happy_code\":\"13131514533\",\"status\":6,\"updated_at\":\"2021-10-29 12:44:33\",\"created_at\":\"2021-10-29 12:44:33\",\"id\":6,\"upload_photo\":null,\"media\":[]}', '::1', '2021-10-29 04:44:33', '2021-10-29 04:44:33'),
(11, 'audit:created', 7, 'App\\Models\\CustomerLuckDrawData#7', 2, '{\"customer_id\":2,\"entered_happy_code\":\"134142413413\",\"status\":6,\"updated_at\":\"2021-10-29 12:46:20\",\"created_at\":\"2021-10-29 12:46:20\",\"id\":7,\"upload_photo\":null,\"media\":[]}', '::1', '2021-10-29 04:46:20', '2021-10-29 04:46:20'),
(12, 'audit:created', 8, 'App\\Models\\CustomerLuckDrawData#8', 2, '{\"customer_id\":2,\"entered_happy_code\":\"14232341\",\"status\":6,\"updated_at\":\"2021-10-29 12:59:00\",\"created_at\":\"2021-10-29 12:59:00\",\"id\":8,\"upload_photo\":null,\"media\":[]}', '::1', '2021-10-29 04:59:00', '2021-10-29 04:59:00'),
(13, 'audit:created', 9, 'App\\Models\\CustomerLuckDrawData#9', 2, '{\"customer_id\":2,\"entered_happy_code\":\"134135432231111\",\"status\":6,\"updated_at\":\"2021-10-29 13:08:21\",\"created_at\":\"2021-10-29 13:08:21\",\"id\":9,\"upload_photo\":null,\"media\":[]}', '::1', '2021-10-29 05:08:21', '2021-10-29 05:08:21'),
(14, 'audit:created', 10, 'App\\Models\\CustomerLuckDrawData#10', 2, '{\"customer_id\":2,\"entered_happy_code\":\"132311313454\",\"status\":6,\"updated_at\":\"2021-10-29 18:36:09\",\"created_at\":\"2021-10-29 18:36:09\",\"id\":10,\"upload_photo\":null,\"media\":[]}', '::1', '2021-10-29 10:36:09', '2021-10-29 10:36:09'),
(15, 'audit:updated', 10, 'App\\Models\\CustomerLuckDrawData#10', 2, '{\"picture\":\"20211029_183609_HC_132311313454.jpg\",\"id\":10,\"upload_photo\":null,\"media\":[]}', '::1', '2021-10-29 10:36:09', '2021-10-29 10:36:09'),
(16, 'audit:updated', 9, 'App\\Models\\LuckyDrawItem#9', 1, '{\"updated_at\":\"2021-11-05 17:41:23\",\"picture_path\":\"luckyDrawItems\\/picture\\/BeLucky.jpg\",\"id\":9,\"picture\":[{\"id\":21,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":9,\"collection_name\":\"picture\",\"name\":\"617bfa7a0db6c_BeLucky\",\"file_name\":\"617bfa7a0db6c_BeLucky.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":139582,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":20,\"created_at\":\"2021-10-29T13:43:24.000000Z\",\"updated_at\":\"2021-10-29T13:43:25.000000Z\",\"url\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/21\\/617bfa7a0db6c_BeLucky.jpg\",\"thumbnail\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/21\\/conversions\\/617bfa7a0db6c_BeLucky-thumb.jpg\",\"preview\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/21\\/conversions\\/617bfa7a0db6c_BeLucky-preview.jpg\"}],\"display_picture\":[],\"media\":[{\"id\":21,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":9,\"collection_name\":\"picture\",\"name\":\"617bfa7a0db6c_BeLucky\",\"file_name\":\"617bfa7a0db6c_BeLucky.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":139582,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":20,\"created_at\":\"2021-10-29T13:43:24.000000Z\",\"updated_at\":\"2021-10-29T13:43:25.000000Z\",\"url\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/21\\/617bfa7a0db6c_BeLucky.jpg\",\"thumbnail\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/21\\/conversions\\/617bfa7a0db6c_BeLucky-thumb.jpg\",\"preview\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/21\\/conversions\\/617bfa7a0db6c_BeLucky-preview.jpg\"}]}', '::1', '2021-11-05 09:41:23', '2021-11-05 09:41:23'),
(17, 'audit:updated', 9, 'App\\Models\\LuckyDrawItem#9', 1, '{\"display_picture_path\":\"luckyDrawItems\\/displayPicture\\/BeLucky.jpg\",\"id\":9,\"picture\":[{\"id\":21,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":9,\"collection_name\":\"picture\",\"name\":\"617bfa7a0db6c_BeLucky\",\"file_name\":\"617bfa7a0db6c_BeLucky.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":139582,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":20,\"created_at\":\"2021-10-29T13:43:24.000000Z\",\"updated_at\":\"2021-10-29T13:43:25.000000Z\",\"url\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/21\\/617bfa7a0db6c_BeLucky.jpg\",\"thumbnail\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/21\\/conversions\\/617bfa7a0db6c_BeLucky-thumb.jpg\",\"preview\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/21\\/conversions\\/617bfa7a0db6c_BeLucky-preview.jpg\"}],\"display_picture\":[],\"media\":[{\"id\":21,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":9,\"collection_name\":\"picture\",\"name\":\"617bfa7a0db6c_BeLucky\",\"file_name\":\"617bfa7a0db6c_BeLucky.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":139582,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":20,\"created_at\":\"2021-10-29T13:43:24.000000Z\",\"updated_at\":\"2021-10-29T13:43:25.000000Z\",\"url\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/21\\/617bfa7a0db6c_BeLucky.jpg\",\"thumbnail\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/21\\/conversions\\/617bfa7a0db6c_BeLucky-thumb.jpg\",\"preview\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/21\\/conversions\\/617bfa7a0db6c_BeLucky-preview.jpg\"}]}', '::1', '2021-11-05 09:41:23', '2021-11-05 09:41:23'),
(18, 'audit:updated', 8, 'App\\Models\\LuckyDrawItem#8', 1, '{\"updated_at\":\"2021-11-05 17:41:55\",\"picture_path\":\"luckyDrawItems\\/picture\\/BeSurprised.jpg\",\"id\":8,\"picture\":[{\"id\":10,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":8,\"collection_name\":\"picture\",\"name\":\"6175568a17e4d_BeSurprised\",\"file_name\":\"6175568a17e4d_BeSurprised.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":143499,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":9,\"created_at\":\"2021-10-24T12:50:19.000000Z\",\"updated_at\":\"2021-10-24T12:50:19.000000Z\",\"url\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/10\\/6175568a17e4d_BeSurprised.jpg\",\"thumbnail\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/10\\/conversions\\/6175568a17e4d_BeSurprised-thumb.jpg\",\"preview\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/10\\/conversions\\/6175568a17e4d_BeSurprised-preview.jpg\"}],\"display_picture\":[],\"media\":[{\"id\":10,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":8,\"collection_name\":\"picture\",\"name\":\"6175568a17e4d_BeSurprised\",\"file_name\":\"6175568a17e4d_BeSurprised.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":143499,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":9,\"created_at\":\"2021-10-24T12:50:19.000000Z\",\"updated_at\":\"2021-10-24T12:50:19.000000Z\",\"url\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/10\\/6175568a17e4d_BeSurprised.jpg\",\"thumbnail\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/10\\/conversions\\/6175568a17e4d_BeSurprised-thumb.jpg\",\"preview\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/10\\/conversions\\/6175568a17e4d_BeSurprised-preview.jpg\"}]}', '::1', '2021-11-05 09:41:55', '2021-11-05 09:41:55'),
(19, 'audit:updated', 8, 'App\\Models\\LuckyDrawItem#8', 1, '{\"display_picture_path\":\"luckyDrawItems\\/displayPicture\\/BeSurprised.jpg\",\"id\":8,\"picture\":[{\"id\":10,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":8,\"collection_name\":\"picture\",\"name\":\"6175568a17e4d_BeSurprised\",\"file_name\":\"6175568a17e4d_BeSurprised.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":143499,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":9,\"created_at\":\"2021-10-24T12:50:19.000000Z\",\"updated_at\":\"2021-10-24T12:50:19.000000Z\",\"url\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/10\\/6175568a17e4d_BeSurprised.jpg\",\"thumbnail\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/10\\/conversions\\/6175568a17e4d_BeSurprised-thumb.jpg\",\"preview\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/10\\/conversions\\/6175568a17e4d_BeSurprised-preview.jpg\"}],\"display_picture\":[],\"media\":[{\"id\":10,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":8,\"collection_name\":\"picture\",\"name\":\"6175568a17e4d_BeSurprised\",\"file_name\":\"6175568a17e4d_BeSurprised.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":143499,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":9,\"created_at\":\"2021-10-24T12:50:19.000000Z\",\"updated_at\":\"2021-10-24T12:50:19.000000Z\",\"url\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/10\\/6175568a17e4d_BeSurprised.jpg\",\"thumbnail\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/10\\/conversions\\/6175568a17e4d_BeSurprised-thumb.jpg\",\"preview\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/10\\/conversions\\/6175568a17e4d_BeSurprised-preview.jpg\"}]}', '::1', '2021-11-05 09:41:56', '2021-11-05 09:41:56'),
(20, 'audit:updated', 7, 'App\\Models\\LuckyDrawItem#7', 1, '{\"updated_at\":\"2021-11-05 17:42:19\",\"picture_path\":\"luckyDrawItems\\/picture\\/BePowerful.jpg\",\"id\":7,\"picture\":[{\"id\":9,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":7,\"collection_name\":\"picture\",\"name\":\"61755683c2cbc_BePowerful\",\"file_name\":\"61755683c2cbc_BePowerful.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":173834,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":8,\"created_at\":\"2021-10-24T12:50:12.000000Z\",\"updated_at\":\"2021-10-24T12:50:13.000000Z\",\"url\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/9\\/61755683c2cbc_BePowerful.jpg\",\"thumbnail\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/9\\/conversions\\/61755683c2cbc_BePowerful-thumb.jpg\",\"preview\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/9\\/conversions\\/61755683c2cbc_BePowerful-preview.jpg\"}],\"display_picture\":[],\"media\":[{\"id\":9,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":7,\"collection_name\":\"picture\",\"name\":\"61755683c2cbc_BePowerful\",\"file_name\":\"61755683c2cbc_BePowerful.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":173834,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":8,\"created_at\":\"2021-10-24T12:50:12.000000Z\",\"updated_at\":\"2021-10-24T12:50:13.000000Z\",\"url\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/9\\/61755683c2cbc_BePowerful.jpg\",\"thumbnail\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/9\\/conversions\\/61755683c2cbc_BePowerful-thumb.jpg\",\"preview\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/9\\/conversions\\/61755683c2cbc_BePowerful-preview.jpg\"}]}', '::1', '2021-11-05 09:42:19', '2021-11-05 09:42:19'),
(21, 'audit:updated', 7, 'App\\Models\\LuckyDrawItem#7', 1, '{\"display_picture_path\":\"luckyDrawItems\\/displayPicture\\/BePowerful.jpg\",\"id\":7,\"picture\":[{\"id\":9,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":7,\"collection_name\":\"picture\",\"name\":\"61755683c2cbc_BePowerful\",\"file_name\":\"61755683c2cbc_BePowerful.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":173834,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":8,\"created_at\":\"2021-10-24T12:50:12.000000Z\",\"updated_at\":\"2021-10-24T12:50:13.000000Z\",\"url\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/9\\/61755683c2cbc_BePowerful.jpg\",\"thumbnail\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/9\\/conversions\\/61755683c2cbc_BePowerful-thumb.jpg\",\"preview\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/9\\/conversions\\/61755683c2cbc_BePowerful-preview.jpg\"}],\"display_picture\":[],\"media\":[{\"id\":9,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":7,\"collection_name\":\"picture\",\"name\":\"61755683c2cbc_BePowerful\",\"file_name\":\"61755683c2cbc_BePowerful.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":173834,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":8,\"created_at\":\"2021-10-24T12:50:12.000000Z\",\"updated_at\":\"2021-10-24T12:50:13.000000Z\",\"url\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/9\\/61755683c2cbc_BePowerful.jpg\",\"thumbnail\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/9\\/conversions\\/61755683c2cbc_BePowerful-thumb.jpg\",\"preview\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/9\\/conversions\\/61755683c2cbc_BePowerful-preview.jpg\"}]}', '::1', '2021-11-05 09:42:20', '2021-11-05 09:42:20'),
(22, 'audit:created', 9, 'App\\Models\\LuckDrawData#9', 1, '{\"lucky_draw_item_id\":\"8\",\"happy_code\":\"114441331\",\"is_used\":0,\"status\":\"0\",\"updated_at\":\"2021-11-05 17:44:04\",\"created_at\":\"2021-11-05 17:44:04\",\"id\":9}', '::1', '2021-11-05 09:44:04', '2021-11-05 09:44:04'),
(23, 'audit:updated', 9, 'App\\Models\\LuckDrawData#9', 1, '{\"status\":\"1\",\"updated_at\":\"2021-11-05 17:44:16\",\"id\":9}', '::1', '2021-11-05 09:44:16', '2021-11-05 09:44:16'),
(24, 'audit:created', 11, 'App\\Models\\CustomerLuckDrawData#11', 2, '{\"customer_id\":2,\"entered_happy_code\":\"14411\",\"remark\":\"Invalid Happy Code\",\"status\":4,\"updated_at\":\"2021-11-05 18:05:53\",\"created_at\":\"2021-11-05 18:05:53\",\"id\":11,\"upload_photo\":null,\"media\":[]}', '::1', '2021-11-05 10:05:53', '2021-11-05 10:05:53'),
(25, 'audit:updated', 11, 'App\\Models\\CustomerLuckDrawData#11', 2, '{\"picture\":\"20211105_180553_HC_14411.jpg\",\"id\":11,\"upload_photo\":null,\"media\":[]}', '::1', '2021-11-05 10:05:53', '2021-11-05 10:05:53'),
(26, 'audit:updated', 7, 'App\\Models\\LuckDrawData#7', 2, '{\"is_used\":1,\"updated_at\":\"2021-11-05 18:07:00\",\"id\":7}', '::1', '2021-11-05 10:07:00', '2021-11-05 10:07:00'),
(27, 'audit:created', 12, 'App\\Models\\CustomerLuckDrawData#12', 2, '{\"luck_draw_data_id\":7,\"customer_id\":2,\"entered_happy_code\":\"GGG\",\"remark\":\"Pending Verification\",\"status\":0,\"updated_at\":\"2021-11-05 18:07:00\",\"created_at\":\"2021-11-05 18:07:00\",\"id\":12,\"upload_photo\":null,\"media\":[]}', '::1', '2021-11-05 10:07:00', '2021-11-05 10:07:00'),
(28, 'audit:updated', 12, 'App\\Models\\CustomerLuckDrawData#12', 2, '{\"picture\":\"20211105_180700_HC_GGG.jpg\",\"id\":12,\"upload_photo\":null,\"media\":[]}', '::1', '2021-11-05 10:07:00', '2021-11-05 10:07:00'),
(29, 'audit:created', 13, 'App\\Models\\CustomerLuckDrawData#13', 2, '{\"customer_id\":2,\"entered_happy_code\":\"1341\",\"remark\":\"Invalid Happy Code\",\"status\":4,\"updated_at\":\"2021-11-05 18:08:27\",\"created_at\":\"2021-11-05 18:08:27\",\"id\":13,\"upload_photo\":null,\"media\":[]}', '::1', '2021-11-05 10:08:27', '2021-11-05 10:08:27'),
(30, 'audit:updated', 13, 'App\\Models\\CustomerLuckDrawData#13', 2, '{\"picture\":\"20211105_180827_HC_1341.jpg\",\"id\":13,\"upload_photo\":null,\"media\":[]}', '::1', '2021-11-05 10:08:27', '2021-11-05 10:08:27'),
(31, 'audit:created', 10, 'App\\Models\\LuckDrawData#10', 1, '{\"lucky_draw_item_id\":\"1\",\"happy_code\":\"131314\",\"is_used\":0,\"status\":\"1\",\"updated_at\":\"2021-11-05 18:09:12\",\"created_at\":\"2021-11-05 18:09:12\",\"id\":10}', '::1', '2021-11-05 10:09:12', '2021-11-05 10:09:12'),
(32, 'audit:updated', 10, 'App\\Models\\LuckDrawData#10', 2, '{\"is_used\":1,\"updated_at\":\"2021-11-05 18:09:33\",\"id\":10}', '::1', '2021-11-05 10:09:33', '2021-11-05 10:09:33'),
(33, 'audit:created', 14, 'App\\Models\\CustomerLuckDrawData#14', 2, '{\"luck_draw_data_id\":10,\"customer_id\":2,\"entered_happy_code\":\"131314\",\"remark\":\"Pending Verification\",\"status\":0,\"updated_at\":\"2021-11-05 18:09:33\",\"created_at\":\"2021-11-05 18:09:33\",\"id\":14,\"upload_photo\":null,\"media\":[]}', '::1', '2021-11-05 10:09:33', '2021-11-05 10:09:33'),
(34, 'audit:updated', 14, 'App\\Models\\CustomerLuckDrawData#14', 2, '{\"picture\":\"20211105_180933_HC_131314.jpg\",\"id\":14,\"upload_photo\":null,\"media\":[]}', '::1', '2021-11-05 10:09:33', '2021-11-05 10:09:33'),
(35, 'audit:updated', 14, 'App\\Models\\CustomerLuckDrawData#14', 1, '{\"remark\":\"Approved\",\"status\":1,\"updated_at\":\"2021-11-05 20:39:03\",\"id\":14,\"upload_photo\":null,\"luck_draw_data\":{\"id\":10,\"happy_code\":\"131314\",\"is_used\":\"1\",\"status\":\"1\",\"created_at\":\"2021-11-05 18:09:12\",\"updated_at\":\"2021-11-05 18:09:33\",\"deleted_at\":null,\"lucky_draw_item_id\":1,\"lucky_draw_item\":{\"id\":1,\"name\":\"Lumos\",\"video_link\":null,\"description\":null,\"status\":\"1\",\"created_at\":\"2021-10-19 14:20:48\",\"updated_at\":\"2021-10-19 14:20:48\",\"deleted_at\":null,\"picture_path\":null,\"display_picture_path\":null,\"picture\":[{\"id\":22,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":1,\"collection_name\":\"picture\",\"name\":\"617bfaa5ada70_Lumos\",\"file_name\":\"617bfaa5ada70_Lumos.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":144988,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":21,\"created_at\":\"2021-10-29T13:44:08.000000Z\",\"updated_at\":\"2021-10-29T13:44:09.000000Z\",\"url\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/617bfaa5ada70_Lumos.jpg\",\"thumbnail\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/conversions\\/617bfaa5ada70_Lumos-thumb.jpg\",\"preview\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/conversions\\/617bfaa5ada70_Lumos-preview.jpg\"}],\"display_picture\":[{\"id\":23,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":1,\"collection_name\":\"display_picture\",\"name\":\"617bfabc9a223_Lumos\",\"file_name\":\"617bfabc9a223_Lumos.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":144988,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":22,\"created_at\":\"2021-10-29T13:44:30.000000Z\",\"updated_at\":\"2021-10-29T13:44:31.000000Z\"}],\"media\":[{\"id\":22,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":1,\"collection_name\":\"picture\",\"name\":\"617bfaa5ada70_Lumos\",\"file_name\":\"617bfaa5ada70_Lumos.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":144988,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":21,\"created_at\":\"2021-10-29T13:44:08.000000Z\",\"updated_at\":\"2021-10-29T13:44:09.000000Z\",\"url\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/617bfaa5ada70_Lumos.jpg\",\"thumbnail\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/conversions\\/617bfaa5ada70_Lumos-thumb.jpg\",\"preview\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/conversions\\/617bfaa5ada70_Lumos-preview.jpg\"},{\"id\":23,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":1,\"collection_name\":\"display_picture\",\"name\":\"617bfabc9a223_Lumos\",\"file_name\":\"617bfabc9a223_Lumos.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":144988,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":22,\"created_at\":\"2021-10-29T13:44:30.000000Z\",\"updated_at\":\"2021-10-29T13:44:31.000000Z\"}]}},\"media\":[]}', '::1', '2021-11-05 12:39:04', '2021-11-05 12:39:04'),
(36, 'audit:updated', 14, 'App\\Models\\CustomerLuckDrawData#14', 1, '{\"status\":1,\"updated_at\":\"2021-11-05 20:40:10\",\"id\":14,\"upload_photo\":null,\"luck_draw_data\":{\"id\":10,\"happy_code\":\"131314\",\"is_used\":\"1\",\"status\":\"1\",\"created_at\":\"2021-11-05 18:09:12\",\"updated_at\":\"2021-11-05 18:09:33\",\"deleted_at\":null,\"lucky_draw_item_id\":1,\"lucky_draw_item\":{\"id\":1,\"name\":\"Lumos\",\"video_link\":null,\"description\":null,\"status\":\"1\",\"created_at\":\"2021-10-19 14:20:48\",\"updated_at\":\"2021-10-19 14:20:48\",\"deleted_at\":null,\"picture_path\":null,\"display_picture_path\":null,\"picture\":[{\"id\":22,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":1,\"collection_name\":\"picture\",\"name\":\"617bfaa5ada70_Lumos\",\"file_name\":\"617bfaa5ada70_Lumos.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":144988,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":21,\"created_at\":\"2021-10-29T13:44:08.000000Z\",\"updated_at\":\"2021-10-29T13:44:09.000000Z\",\"url\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/617bfaa5ada70_Lumos.jpg\",\"thumbnail\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/conversions\\/617bfaa5ada70_Lumos-thumb.jpg\",\"preview\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/conversions\\/617bfaa5ada70_Lumos-preview.jpg\"}],\"display_picture\":[{\"id\":23,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":1,\"collection_name\":\"display_picture\",\"name\":\"617bfabc9a223_Lumos\",\"file_name\":\"617bfabc9a223_Lumos.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":144988,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":22,\"created_at\":\"2021-10-29T13:44:30.000000Z\",\"updated_at\":\"2021-10-29T13:44:31.000000Z\"}],\"media\":[{\"id\":22,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":1,\"collection_name\":\"picture\",\"name\":\"617bfaa5ada70_Lumos\",\"file_name\":\"617bfaa5ada70_Lumos.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":144988,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":21,\"created_at\":\"2021-10-29T13:44:08.000000Z\",\"updated_at\":\"2021-10-29T13:44:09.000000Z\",\"url\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/617bfaa5ada70_Lumos.jpg\",\"thumbnail\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/conversions\\/617bfaa5ada70_Lumos-thumb.jpg\",\"preview\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/conversions\\/617bfaa5ada70_Lumos-preview.jpg\"},{\"id\":23,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":1,\"collection_name\":\"display_picture\",\"name\":\"617bfabc9a223_Lumos\",\"file_name\":\"617bfabc9a223_Lumos.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":144988,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":22,\"created_at\":\"2021-10-29T13:44:30.000000Z\",\"updated_at\":\"2021-10-29T13:44:31.000000Z\"}]}},\"media\":[]}', '::1', '2021-11-05 12:40:10', '2021-11-05 12:40:10'),
(37, 'audit:updated', 1, 'App\\Models\\CustomerLuckDrawData#1', 1, '{\"remark\":\"Rejected\",\"status\":2,\"updated_at\":\"2021-11-05 20:41:53\",\"id\":1,\"upload_photo\":{\"id\":12,\"model_type\":\"App\\\\Models\\\\CustomerLuckDrawData\",\"model_id\":1,\"collection_name\":\"upload_photo\",\"name\":\"20211026_220531_HC_HHH\",\"file_name\":\"20211026_220531_HC_HHH.png\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"customerPhoto\",\"size\":98174,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":11,\"created_at\":\"2021-10-26T14:05:31.000000Z\",\"updated_at\":\"2021-10-26T14:05:31.000000Z\",\"url\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/customerLuckDrawData\\/12\\/20211026_220531_HC_HHH.png\",\"thumbnail\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/customerLuckDrawData\\/12\\/conversions\\/20211026_220531_HC_HHH-thumb.jpg\",\"preview\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/customerLuckDrawData\\/12\\/conversions\\/20211026_220531_HC_HHH-preview.jpg\"},\"media\":[{\"id\":12,\"model_type\":\"App\\\\Models\\\\CustomerLuckDrawData\",\"model_id\":1,\"collection_name\":\"upload_photo\",\"name\":\"20211026_220531_HC_HHH\",\"file_name\":\"20211026_220531_HC_HHH.png\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"customerPhoto\",\"size\":98174,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":11,\"created_at\":\"2021-10-26T14:05:31.000000Z\",\"updated_at\":\"2021-10-26T14:05:31.000000Z\",\"url\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/customerLuckDrawData\\/12\\/20211026_220531_HC_HHH.png\",\"thumbnail\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/customerLuckDrawData\\/12\\/conversions\\/20211026_220531_HC_HHH-thumb.jpg\",\"preview\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/customerLuckDrawData\\/12\\/conversions\\/20211026_220531_HC_HHH-preview.jpg\"}]}', '::1', '2021-11-05 12:41:53', '2021-11-05 12:41:53'),
(38, 'audit:created', 1, 'App\\Models\\RejectCustomerLuckDrawData#1', 1, '{\"reject_type\":0,\"remark\":\"Invalid uploaded photo\",\"status\":0,\"customer_luck_draw_data_id\":1,\"updated_at\":\"2021-11-05 20:41:53\",\"created_at\":\"2021-11-05 20:41:53\",\"id\":1,\"uploaded_photo\":null,\"media\":[]}', '::1', '2021-11-05 12:41:53', '2021-11-05 12:41:53'),
(39, 'audit:updated', 14, 'App\\Models\\CustomerLuckDrawData#14', 1, '{\"status\":1,\"updated_at\":\"2021-11-05 20:46:37\",\"id\":14,\"upload_photo\":null,\"luck_draw_data\":{\"id\":10,\"happy_code\":\"131314\",\"is_used\":\"1\",\"status\":\"1\",\"created_at\":\"2021-11-05 18:09:12\",\"updated_at\":\"2021-11-05 18:09:33\",\"deleted_at\":null,\"lucky_draw_item_id\":1,\"lucky_draw_item\":{\"id\":1,\"name\":\"Lumos\",\"video_link\":null,\"description\":null,\"status\":\"1\",\"created_at\":\"2021-10-19 14:20:48\",\"updated_at\":\"2021-10-19 14:20:48\",\"deleted_at\":null,\"picture_path\":null,\"display_picture_path\":null,\"picture\":[{\"id\":22,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":1,\"collection_name\":\"picture\",\"name\":\"617bfaa5ada70_Lumos\",\"file_name\":\"617bfaa5ada70_Lumos.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":144988,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":21,\"created_at\":\"2021-10-29T13:44:08.000000Z\",\"updated_at\":\"2021-10-29T13:44:09.000000Z\",\"url\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/617bfaa5ada70_Lumos.jpg\",\"thumbnail\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/conversions\\/617bfaa5ada70_Lumos-thumb.jpg\",\"preview\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/conversions\\/617bfaa5ada70_Lumos-preview.jpg\"}],\"display_picture\":[{\"id\":23,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":1,\"collection_name\":\"display_picture\",\"name\":\"617bfabc9a223_Lumos\",\"file_name\":\"617bfabc9a223_Lumos.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":144988,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":22,\"created_at\":\"2021-10-29T13:44:30.000000Z\",\"updated_at\":\"2021-10-29T13:44:31.000000Z\"}],\"media\":[{\"id\":22,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":1,\"collection_name\":\"picture\",\"name\":\"617bfaa5ada70_Lumos\",\"file_name\":\"617bfaa5ada70_Lumos.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":144988,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":21,\"created_at\":\"2021-10-29T13:44:08.000000Z\",\"updated_at\":\"2021-10-29T13:44:09.000000Z\",\"url\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/617bfaa5ada70_Lumos.jpg\",\"thumbnail\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/conversions\\/617bfaa5ada70_Lumos-thumb.jpg\",\"preview\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/conversions\\/617bfaa5ada70_Lumos-preview.jpg\"},{\"id\":23,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":1,\"collection_name\":\"display_picture\",\"name\":\"617bfabc9a223_Lumos\",\"file_name\":\"617bfabc9a223_Lumos.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":144988,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":22,\"created_at\":\"2021-10-29T13:44:30.000000Z\",\"updated_at\":\"2021-10-29T13:44:31.000000Z\"}]}},\"media\":[]}', '::1', '2021-11-05 12:46:37', '2021-11-05 12:46:37'),
(40, 'audit:created', 1, 'App\\Models\\ShippingLuckyDraw#1', 1, '{\"lucky_draw_items_id\":1,\"status\":0,\"customer_luck_draw_data_id\":14,\"updated_at\":\"2021-11-05 20:46:37\",\"created_at\":\"2021-11-05 20:46:37\",\"id\":1}', '::1', '2021-11-05 12:46:37', '2021-11-05 12:46:37'),
(41, 'audit:updated', 14, 'App\\Models\\CustomerLuckDrawData#14', 1, '{\"status\":1,\"updated_at\":\"2021-11-05 20:48:29\",\"id\":14,\"upload_photo\":null,\"luck_draw_data\":{\"id\":10,\"happy_code\":\"131314\",\"is_used\":\"1\",\"status\":\"1\",\"created_at\":\"2021-11-05 18:09:12\",\"updated_at\":\"2021-11-05 18:09:33\",\"deleted_at\":null,\"lucky_draw_item_id\":1,\"lucky_draw_item\":{\"id\":1,\"name\":\"Lumos\",\"video_link\":null,\"description\":null,\"status\":\"1\",\"created_at\":\"2021-10-19 14:20:48\",\"updated_at\":\"2021-10-19 14:20:48\",\"deleted_at\":null,\"picture_path\":null,\"display_picture_path\":null,\"picture\":[{\"id\":22,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":1,\"collection_name\":\"picture\",\"name\":\"617bfaa5ada70_Lumos\",\"file_name\":\"617bfaa5ada70_Lumos.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":144988,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":21,\"created_at\":\"2021-10-29T13:44:08.000000Z\",\"updated_at\":\"2021-10-29T13:44:09.000000Z\",\"url\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/617bfaa5ada70_Lumos.jpg\",\"thumbnail\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/conversions\\/617bfaa5ada70_Lumos-thumb.jpg\",\"preview\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/conversions\\/617bfaa5ada70_Lumos-preview.jpg\"}],\"display_picture\":[{\"id\":23,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":1,\"collection_name\":\"display_picture\",\"name\":\"617bfabc9a223_Lumos\",\"file_name\":\"617bfabc9a223_Lumos.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":144988,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":22,\"created_at\":\"2021-10-29T13:44:30.000000Z\",\"updated_at\":\"2021-10-29T13:44:31.000000Z\"}],\"media\":[{\"id\":22,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":1,\"collection_name\":\"picture\",\"name\":\"617bfaa5ada70_Lumos\",\"file_name\":\"617bfaa5ada70_Lumos.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":144988,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":21,\"created_at\":\"2021-10-29T13:44:08.000000Z\",\"updated_at\":\"2021-10-29T13:44:09.000000Z\",\"url\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/617bfaa5ada70_Lumos.jpg\",\"thumbnail\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/conversions\\/617bfaa5ada70_Lumos-thumb.jpg\",\"preview\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/conversions\\/617bfaa5ada70_Lumos-preview.jpg\"},{\"id\":23,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":1,\"collection_name\":\"display_picture\",\"name\":\"617bfabc9a223_Lumos\",\"file_name\":\"617bfabc9a223_Lumos.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":144988,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":22,\"created_at\":\"2021-10-29T13:44:30.000000Z\",\"updated_at\":\"2021-10-29T13:44:31.000000Z\"}]}},\"media\":[]}', '::1', '2021-11-05 12:48:29', '2021-11-05 12:48:29'),
(42, 'audit:created', 2, 'App\\Models\\ShippingLuckyDraw#2', 1, '{\"lucky_draw_items_id\":1,\"status\":0,\"customer_luck_draw_data_id\":14,\"updated_at\":\"2021-11-05 20:48:29\",\"created_at\":\"2021-11-05 20:48:29\",\"id\":2}', '::1', '2021-11-05 12:48:29', '2021-11-05 12:48:29'),
(43, 'audit:created', 15, 'App\\Models\\CustomerLuckDrawData#15', 1, '{\"customer_id\":1,\"entered_happy_code\":\"131314\",\"remark\":\"The entered happy code (131314) is existed and entered by kristy (0177569933)\",\"status\":0,\"updated_at\":\"2021-11-05 20:59:13\",\"created_at\":\"2021-11-05 20:59:13\",\"id\":15,\"upload_photo\":null,\"media\":[]}', '::1', '2021-11-05 12:59:13', '2021-11-05 12:59:13'),
(44, 'audit:updated', 15, 'App\\Models\\CustomerLuckDrawData#15', 1, '{\"picture\":\"20211105_205913_HC_131314.jpg\",\"id\":15,\"upload_photo\":null,\"media\":[]}', '::1', '2021-11-05 12:59:13', '2021-11-05 12:59:13'),
(45, 'audit:created', 16, 'App\\Models\\CustomerLuckDrawData#16', 2, '{\"customer_id\":2,\"entered_happy_code\":\"131314\",\"remark\":\"The entered happy code (131314) is existed and entered by User ()\",\"status\":0,\"updated_at\":\"2021-11-05 21:01:44\",\"created_at\":\"2021-11-05 21:01:44\",\"id\":16,\"upload_photo\":null,\"media\":[]}', '::1', '2021-11-05 13:01:44', '2021-11-05 13:01:44'),
(46, 'audit:updated', 16, 'App\\Models\\CustomerLuckDrawData#16', 2, '{\"picture\":\"20211105_210144_HC_131314.jpg\",\"id\":16,\"upload_photo\":null,\"media\":[]}', '::1', '2021-11-05 13:01:44', '2021-11-05 13:01:44'),
(47, 'audit:created', 11, 'App\\Models\\LuckDrawData#11', 1, '{\"lucky_draw_item_id\":\"3\",\"happy_code\":\"191919\",\"is_used\":0,\"status\":\"0\",\"updated_at\":\"2021-11-08 17:49:16\",\"created_at\":\"2021-11-08 17:49:16\",\"id\":11}', '::1', '2021-11-08 09:49:16', '2021-11-08 09:49:16'),
(48, 'audit:created', 12, 'App\\Models\\LuckDrawData#12', 1, '{\"lucky_draw_item_id\":\"3\",\"happy_code\":\"191922\",\"is_used\":0,\"status\":\"0\",\"updated_at\":\"2021-11-08 17:49:16\",\"created_at\":\"2021-11-08 17:49:16\",\"id\":12}', '::1', '2021-11-08 09:49:16', '2021-11-08 09:49:16'),
(49, 'audit:updated', 11, 'App\\Models\\LuckDrawData#11', 1, '{\"status\":\"1\",\"updated_at\":\"2021-11-08 17:49:30\",\"id\":11}', '::1', '2021-11-08 09:49:30', '2021-11-08 09:49:30'),
(50, 'audit:updated', 12, 'App\\Models\\LuckDrawData#12', 1, '{\"status\":\"1\",\"updated_at\":\"2021-11-08 17:49:30\",\"id\":12}', '::1', '2021-11-08 09:49:30', '2021-11-08 09:49:30'),
(51, 'audit:updated', 11, 'App\\Models\\LuckDrawData#11', 2, '{\"is_used\":1,\"updated_at\":\"2021-11-08 17:50:06\",\"id\":11}', '::1', '2021-11-08 09:50:06', '2021-11-08 09:50:06'),
(52, 'audit:created', 17, 'App\\Models\\CustomerLuckDrawData#17', 2, '{\"luck_draw_data_id\":11,\"customer_id\":2,\"entered_happy_code\":\"191919\",\"remark\":\"Pending Verification\",\"status\":0,\"updated_at\":\"2021-11-08 17:50:06\",\"created_at\":\"2021-11-08 17:50:06\",\"id\":17,\"upload_photo\":null,\"media\":[]}', '::1', '2021-11-08 09:50:06', '2021-11-08 09:50:06'),
(53, 'audit:updated', 17, 'App\\Models\\CustomerLuckDrawData#17', 2, '{\"picture\":\"20211108_175006_HC_191919.jpg\",\"id\":17,\"upload_photo\":null,\"media\":[]}', '::1', '2021-11-08 09:50:06', '2021-11-08 09:50:06'),
(54, 'audit:updated', 3, 'App\\Models\\LuckyDrawItem#3', 1, '{\"updated_at\":\"2021-11-08 17:50:40\",\"picture_path\":\"luckyDrawItems\\/picture\\/Freezer.jpg\",\"id\":3,\"picture\":[{\"id\":5,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":3,\"collection_name\":\"picture\",\"name\":\"6175566840518_Freezer\",\"file_name\":\"6175566840518_Freezer.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":144492,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":4,\"created_at\":\"2021-10-24T12:49:45.000000Z\",\"updated_at\":\"2021-10-24T12:49:46.000000Z\",\"url\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/5\\/6175566840518_Freezer.jpg\",\"thumbnail\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/5\\/conversions\\/6175566840518_Freezer-thumb.jpg\",\"preview\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/5\\/conversions\\/6175566840518_Freezer-preview.jpg\"}],\"display_picture\":[],\"media\":[{\"id\":5,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":3,\"collection_name\":\"picture\",\"name\":\"6175566840518_Freezer\",\"file_name\":\"6175566840518_Freezer.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":144492,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":4,\"created_at\":\"2021-10-24T12:49:45.000000Z\",\"updated_at\":\"2021-10-24T12:49:46.000000Z\",\"url\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/5\\/6175566840518_Freezer.jpg\",\"thumbnail\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/5\\/conversions\\/6175566840518_Freezer-thumb.jpg\",\"preview\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/5\\/conversions\\/6175566840518_Freezer-preview.jpg\"}]}', '::1', '2021-11-08 09:50:40', '2021-11-08 09:50:40'),
(55, 'audit:updated', 1, 'App\\Models\\LuckyDrawItem#1', 1, '{\"updated_at\":\"2021-11-08 17:50:58\",\"picture_path\":\"luckyDrawItems\\/picture\\/Lumos.jpg\",\"id\":1,\"picture\":[{\"id\":22,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":1,\"collection_name\":\"picture\",\"name\":\"617bfaa5ada70_Lumos\",\"file_name\":\"617bfaa5ada70_Lumos.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":144988,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":21,\"created_at\":\"2021-10-29T13:44:08.000000Z\",\"updated_at\":\"2021-10-29T13:44:09.000000Z\",\"url\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/617bfaa5ada70_Lumos.jpg\",\"thumbnail\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/conversions\\/617bfaa5ada70_Lumos-thumb.jpg\",\"preview\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/conversions\\/617bfaa5ada70_Lumos-preview.jpg\"}],\"display_picture\":[{\"id\":23,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":1,\"collection_name\":\"display_picture\",\"name\":\"617bfabc9a223_Lumos\",\"file_name\":\"617bfabc9a223_Lumos.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":144988,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":22,\"created_at\":\"2021-10-29T13:44:30.000000Z\",\"updated_at\":\"2021-10-29T13:44:31.000000Z\"}],\"media\":[{\"id\":22,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":1,\"collection_name\":\"picture\",\"name\":\"617bfaa5ada70_Lumos\",\"file_name\":\"617bfaa5ada70_Lumos.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":144988,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":21,\"created_at\":\"2021-10-29T13:44:08.000000Z\",\"updated_at\":\"2021-10-29T13:44:09.000000Z\",\"url\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/617bfaa5ada70_Lumos.jpg\",\"thumbnail\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/conversions\\/617bfaa5ada70_Lumos-thumb.jpg\",\"preview\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/conversions\\/617bfaa5ada70_Lumos-preview.jpg\"},{\"id\":23,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":1,\"collection_name\":\"display_picture\",\"name\":\"617bfabc9a223_Lumos\",\"file_name\":\"617bfabc9a223_Lumos.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":144988,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":22,\"created_at\":\"2021-10-29T13:44:30.000000Z\",\"updated_at\":\"2021-10-29T13:44:31.000000Z\"}]}', '::1', '2021-11-08 09:50:58', '2021-11-08 09:50:58'),
(56, 'audit:created', 13, 'App\\Models\\LuckDrawData#13', 1, '{\"lucky_draw_item_id\":\"1\",\"happy_code\":\"198219\",\"is_used\":0,\"status\":\"0\",\"updated_at\":\"2021-11-08 17:51:15\",\"created_at\":\"2021-11-08 17:51:15\",\"id\":13}', '::1', '2021-11-08 09:51:15', '2021-11-08 09:51:15'),
(57, 'audit:updated', 13, 'App\\Models\\LuckDrawData#13', 1, '{\"status\":\"1\",\"updated_at\":\"2021-11-08 17:51:45\",\"id\":13}', '::1', '2021-11-08 09:51:46', '2021-11-08 09:51:46'),
(58, 'audit:updated', 13, 'App\\Models\\LuckDrawData#13', 2, '{\"is_used\":1,\"updated_at\":\"2021-11-08 17:52:14\",\"id\":13}', '::1', '2021-11-08 09:52:14', '2021-11-08 09:52:14'),
(59, 'audit:created', 18, 'App\\Models\\CustomerLuckDrawData#18', 2, '{\"luck_draw_data_id\":13,\"customer_id\":2,\"entered_happy_code\":\"198219\",\"remark\":\"Pending Verification\",\"status\":0,\"updated_at\":\"2021-11-08 17:52:14\",\"created_at\":\"2021-11-08 17:52:14\",\"id\":18,\"upload_photo\":null,\"media\":[]}', '::1', '2021-11-08 09:52:14', '2021-11-08 09:52:14'),
(60, 'audit:updated', 18, 'App\\Models\\CustomerLuckDrawData#18', 2, '{\"updated_at\":\"2021-11-08 17:52:15\",\"picture\":\"20211108_175214_HC_198219.jpg\",\"id\":18,\"upload_photo\":null,\"media\":[]}', '::1', '2021-11-08 09:52:15', '2021-11-08 09:52:15'),
(61, 'audit:updated', 12, 'App\\Models\\LuckDrawData#12', 2, '{\"is_used\":1,\"updated_at\":\"2021-11-08 17:52:59\",\"id\":12}', '::1', '2021-11-08 09:53:01', '2021-11-08 09:53:01'),
(62, 'audit:created', 19, 'App\\Models\\CustomerLuckDrawData#19', 2, '{\"luck_draw_data_id\":12,\"customer_id\":2,\"entered_happy_code\":\"191922\",\"remark\":\"Pending Verification\",\"status\":0,\"updated_at\":\"2021-11-08 17:53:01\",\"created_at\":\"2021-11-08 17:53:01\",\"id\":19,\"upload_photo\":null,\"media\":[]}', '::1', '2021-11-08 09:53:02', '2021-11-08 09:53:02'),
(63, 'audit:updated', 19, 'App\\Models\\CustomerLuckDrawData#19', 2, '{\"updated_at\":\"2021-11-08 17:53:03\",\"picture\":\"20211108_175303_HC_191922.jpg\",\"id\":19,\"upload_photo\":null,\"media\":[]}', '::1', '2021-11-08 09:53:04', '2021-11-08 09:53:04'),
(64, 'audit:created', 20, 'App\\Models\\CustomerLuckDrawData#20', 1, '{\"customer_id\":1,\"entered_happy_code\":\"191919\",\"remark\":\"The entered happy code (191919) is existed and entered by kristy (0177569933)\",\"status\":0,\"updated_at\":\"2021-11-08 17:54:01\",\"created_at\":\"2021-11-08 17:54:01\",\"id\":20,\"upload_photo\":null,\"media\":[]}', '::1', '2021-11-08 09:54:01', '2021-11-08 09:54:01'),
(65, 'audit:updated', 20, 'App\\Models\\CustomerLuckDrawData#20', 1, '{\"picture\":\"20211108_175401_HC_191919.jpg\",\"id\":20,\"upload_photo\":null,\"media\":[]}', '::1', '2021-11-08 09:54:01', '2021-11-08 09:54:01'),
(66, 'audit:created', 14, 'App\\Models\\LuckDrawData#14', 1, '{\"lucky_draw_item_id\":\"1\",\"happy_code\":\"919099\",\"is_used\":0,\"status\":\"0\",\"updated_at\":\"2021-11-08 20:50:41\",\"created_at\":\"2021-11-08 20:50:41\",\"id\":14}', '::1', '2021-11-08 12:50:41', '2021-11-08 12:50:41');
INSERT INTO `audit_logs` (`id`, `description`, `subject_id`, `subject_type`, `user_id`, `properties`, `host`, `created_at`, `updated_at`) VALUES
(67, 'audit:updated', 20, 'App\\Models\\CustomerLuckDrawData#20', 1, '{\"status\":1,\"updated_at\":\"2021-11-08 20:51:07\",\"id\":20,\"upload_photo\":null,\"luck_draw_data\":null,\"media\":[]}', '::1', '2021-11-08 12:51:07', '2021-11-08 12:51:07'),
(68, 'audit:updated', 14, 'App\\Models\\LuckDrawData#14', 1, '{\"status\":\"1\",\"updated_at\":\"2021-11-08 20:52:17\",\"id\":14}', '::1', '2021-11-08 12:52:18', '2021-11-08 12:52:18'),
(69, 'audit:updated', 14, 'App\\Models\\LuckDrawData#14', 2, '{\"is_used\":1,\"updated_at\":\"2021-11-08 20:53:07\",\"id\":14}', '::1', '2021-11-08 12:53:07', '2021-11-08 12:53:07'),
(70, 'audit:created', 21, 'App\\Models\\CustomerLuckDrawData#21', 2, '{\"luck_draw_data_id\":14,\"customer_id\":2,\"entered_happy_code\":\"919099\",\"remark\":\"Pending Verification\",\"status\":0,\"updated_at\":\"2021-11-08 20:53:07\",\"created_at\":\"2021-11-08 20:53:07\",\"id\":21,\"upload_photo\":null,\"media\":[]}', '::1', '2021-11-08 12:53:07', '2021-11-08 12:53:07'),
(71, 'audit:updated', 21, 'App\\Models\\CustomerLuckDrawData#21', 2, '{\"picture\":\"20211108_205307_HC_919099.jpg\",\"id\":21,\"upload_photo\":null,\"media\":[]}', '::1', '2021-11-08 12:53:07', '2021-11-08 12:53:07'),
(72, 'audit:updated', 21, 'App\\Models\\CustomerLuckDrawData#21', 1, '{\"remark\":\"You have won Lumos\",\"status\":1,\"updated_at\":\"2021-11-08 20:54:55\",\"id\":21,\"upload_photo\":null,\"luck_draw_data\":{\"id\":14,\"happy_code\":\"919099\",\"is_used\":\"1\",\"status\":\"1\",\"created_at\":\"2021-11-08 20:50:41\",\"updated_at\":\"2021-11-08 20:53:07\",\"deleted_at\":null,\"lucky_draw_item_id\":1,\"lucky_draw_item\":{\"id\":1,\"name\":\"Lumos\",\"video_link\":null,\"description\":null,\"status\":\"1\",\"created_at\":\"2021-10-19 14:20:48\",\"updated_at\":\"2021-11-08 17:50:58\",\"deleted_at\":null,\"picture_path\":\"luckyDrawItems\\/picture\\/Lumos.jpg\",\"display_picture_path\":null,\"picture\":[{\"id\":22,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":1,\"collection_name\":\"picture\",\"name\":\"617bfaa5ada70_Lumos\",\"file_name\":\"617bfaa5ada70_Lumos.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":144988,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":21,\"created_at\":\"2021-10-29T13:44:08.000000Z\",\"updated_at\":\"2021-10-29T13:44:09.000000Z\",\"url\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/617bfaa5ada70_Lumos.jpg\",\"thumbnail\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/conversions\\/617bfaa5ada70_Lumos-thumb.jpg\",\"preview\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/conversions\\/617bfaa5ada70_Lumos-preview.jpg\"}],\"display_picture\":[{\"id\":23,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":1,\"collection_name\":\"display_picture\",\"name\":\"617bfabc9a223_Lumos\",\"file_name\":\"617bfabc9a223_Lumos.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":144988,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":22,\"created_at\":\"2021-10-29T13:44:30.000000Z\",\"updated_at\":\"2021-10-29T13:44:31.000000Z\"}],\"media\":[{\"id\":22,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":1,\"collection_name\":\"picture\",\"name\":\"617bfaa5ada70_Lumos\",\"file_name\":\"617bfaa5ada70_Lumos.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":144988,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":21,\"created_at\":\"2021-10-29T13:44:08.000000Z\",\"updated_at\":\"2021-10-29T13:44:09.000000Z\",\"url\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/617bfaa5ada70_Lumos.jpg\",\"thumbnail\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/conversions\\/617bfaa5ada70_Lumos-thumb.jpg\",\"preview\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/conversions\\/617bfaa5ada70_Lumos-preview.jpg\"},{\"id\":23,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":1,\"collection_name\":\"display_picture\",\"name\":\"617bfabc9a223_Lumos\",\"file_name\":\"617bfabc9a223_Lumos.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":144988,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":22,\"created_at\":\"2021-10-29T13:44:30.000000Z\",\"updated_at\":\"2021-10-29T13:44:31.000000Z\"}]}},\"media\":[]}', '::1', '2021-11-08 12:54:56', '2021-11-08 12:54:56'),
(73, 'audit:created', 3, 'App\\Models\\ShippingLuckyDraw#3', 1, '{\"lucky_draw_items_id\":1,\"status\":0,\"customer_luck_draw_data_id\":21,\"updated_at\":\"2021-11-08 20:54:56\",\"created_at\":\"2021-11-08 20:54:56\",\"id\":3}', '::1', '2021-11-08 12:54:56', '2021-11-08 12:54:56'),
(74, 'audit:updated', 3, 'App\\Models\\ShippingLuckyDraw#3', 1, '{\"tracking_number\":\"ABX14411\",\"description\":\"<p>Test<\\/p>\",\"updated_at\":\"2021-11-08 20:59:04\",\"shipment_date\":\"2021-11-08\",\"couriers_id\":\"1\",\"id\":3}', '::1', '2021-11-08 12:59:04', '2021-11-08 12:59:04'),
(75, 'audit:updated', 3, 'App\\Models\\ShippingLuckyDraw#3', 1, '{\"status\":1,\"updated_at\":\"2021-11-08 20:59:44\",\"id\":3}', '::1', '2021-11-08 12:59:44', '2021-11-08 12:59:44'),
(76, 'audit:updated', 2, 'App\\Models\\ShippingLuckyDraw#2', 1, '{\"status\":1,\"updated_at\":\"2021-11-08 21:26:17\",\"id\":2}', '::1', '2021-11-08 13:26:18', '2021-11-08 13:26:18'),
(77, 'audit:created', 2, 'App\\Models\\Employee#2', 1, '{\"name\":\"kristy cs\",\"email\":\"kristykl@gmail.com\",\"phone\":\"1111\",\"identity_card_number\":\"11\",\"approved\":\"0\",\"dob\":\"2021-11-02\",\"address\":\"131341\",\"state_id\":\"3\",\"city_id\":\"571\",\"status\":\"1\",\"updated_at\":\"2021-11-09 13:02:49\",\"created_at\":\"2021-11-09 13:02:49\",\"id\":2,\"image\":null,\"media\":[]}', '::1', '2021-11-09 05:02:49', '2021-11-09 05:02:49'),
(78, 'audit:created', 3, 'App\\Models\\Customer#3', NULL, '{\"name\":\"kristy 3\",\"email\":\"it2@thethymespa.com\",\"phone\":\"1341341\",\"identity_card_number\":\"13134121\",\"shipping_address\":\"dfasdfsa\",\"state_id\":\"3\",\"city_id\":\"627\",\"status\":1,\"updated_at\":\"2021-11-10 22:52:46\",\"created_at\":\"2021-11-10 22:52:46\",\"id\":3,\"image\":null,\"media\":[]}', '::1', '2021-11-10 14:52:46', '2021-11-10 14:52:46'),
(79, 'audit:created', 2, 'App\\Models\\Survey#2', NULL, '{\"customer_id\":3,\"value_1\":\"Original Mixed Grains\",\"value_2\":\"{\\\"3\\\":\\\"Beetroot\\\"}\",\"updated_at\":\"2021-11-10 22:52:46\",\"created_at\":\"2021-11-10 22:52:46\",\"id\":2}', '::1', '2021-11-10 14:52:46', '2021-11-10 14:52:46'),
(80, 'audit:updated', 19, 'App\\Models\\CustomerLuckDrawData#19', 1, '{\"remark\":\"You have won Dual Function Freezer\",\"status\":1,\"updated_at\":\"2021-11-11 12:44:00\",\"id\":19,\"upload_photo\":null,\"luck_draw_data\":{\"id\":12,\"happy_code\":\"191922\",\"is_used\":\"1\",\"status\":\"1\",\"created_at\":\"2021-11-08 17:49:16\",\"updated_at\":\"2021-11-08 17:52:59\",\"deleted_at\":null,\"lucky_draw_item_id\":3,\"lucky_draw_item\":{\"id\":3,\"name\":\"Dual Function Freezer\",\"video_link\":null,\"description\":null,\"status\":\"1\",\"created_at\":\"2021-10-24 20:43:28\",\"updated_at\":\"2021-11-08 17:50:40\",\"deleted_at\":null,\"picture_path\":\"luckyDrawItems\\/picture\\/Freezer.jpg\",\"display_picture_path\":null,\"picture\":[{\"id\":5,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":3,\"collection_name\":\"picture\",\"name\":\"6175566840518_Freezer\",\"file_name\":\"6175566840518_Freezer.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":144492,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":4,\"created_at\":\"2021-10-24T12:49:45.000000Z\",\"updated_at\":\"2021-10-24T12:49:46.000000Z\",\"url\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/5\\/6175566840518_Freezer.jpg\",\"thumbnail\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/5\\/conversions\\/6175566840518_Freezer-thumb.jpg\",\"preview\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/5\\/conversions\\/6175566840518_Freezer-preview.jpg\"}],\"display_picture\":[],\"media\":[{\"id\":5,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":3,\"collection_name\":\"picture\",\"name\":\"6175566840518_Freezer\",\"file_name\":\"6175566840518_Freezer.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":144492,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":4,\"created_at\":\"2021-10-24T12:49:45.000000Z\",\"updated_at\":\"2021-10-24T12:49:46.000000Z\",\"url\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/5\\/6175566840518_Freezer.jpg\",\"thumbnail\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/5\\/conversions\\/6175566840518_Freezer-thumb.jpg\",\"preview\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/5\\/conversions\\/6175566840518_Freezer-preview.jpg\"}]}},\"media\":[]}', '::1', '2021-11-11 04:44:00', '2021-11-11 04:44:00'),
(81, 'audit:created', 4, 'App\\Models\\ShippingLuckyDraw#4', 1, '{\"lucky_draw_items_id\":3,\"status\":0,\"customer_luck_draw_data_id\":19,\"updated_at\":\"2021-11-11 12:44:00\",\"created_at\":\"2021-11-11 12:44:00\",\"id\":4}', '::1', '2021-11-11 04:44:00', '2021-11-11 04:44:00'),
(82, 'audit:created', 10, 'App\\Models\\LuckyDrawItem#10', 1, '{\"name\":\"1 x Wireless Hand Mixer\",\"video_link\":null,\"description\":null,\"status\":\"1\",\"updated_at\":\"2021-11-11 16:45:47\",\"created_at\":\"2021-11-11 16:45:47\",\"id\":10,\"picture\":[],\"display_picture\":[],\"media\":[]}', '::1', '2021-11-11 08:45:47', '2021-11-11 08:45:47'),
(83, 'audit:updated', 10, 'App\\Models\\LuckyDrawItem#10', 1, '{\"picture_path\":\"luckyDrawItems\\/picture\\/P18_WirelessHandMixer.jpg\",\"id\":10,\"picture\":[],\"display_picture\":[],\"media\":[]}', '::1', '2021-11-11 08:45:47', '2021-11-11 08:45:47'),
(84, 'audit:created', 22, 'App\\Models\\CustomerLuckDrawData#22', 2, '{\"customer_id\":2,\"entered_happy_code\":\"13133\",\"remark\":\"Invalid Happy Code\",\"status\":0,\"updated_at\":\"2021-11-12 18:16:04\",\"created_at\":\"2021-11-12 18:16:04\",\"id\":22,\"upload_photo\":null,\"media\":[]}', '::1', '2021-11-12 10:16:04', '2021-11-12 10:16:04'),
(85, 'audit:updated', 22, 'App\\Models\\CustomerLuckDrawData#22', 2, '{\"updated_at\":\"2021-11-12 18:16:05\",\"picture\":\"20211112_181604_HC_13133.jpg\",\"id\":22,\"upload_photo\":null,\"media\":[]}', '::1', '2021-11-12 10:16:05', '2021-11-12 10:16:05'),
(86, 'audit:created', 23, 'App\\Models\\CustomerLuckDrawData#23', 2, '{\"customer_id\":2,\"entered_happy_code\":\"14121\",\"remark\":\"Invalid Happy Code\",\"status\":0,\"updated_at\":\"2021-11-15 16:35:24\",\"created_at\":\"2021-11-15 16:35:24\",\"id\":23,\"upload_photo\":null,\"media\":[]}', '::1', '2021-11-15 08:35:24', '2021-11-15 08:35:24'),
(87, 'audit:updated', 23, 'App\\Models\\CustomerLuckDrawData#23', 2, '{\"updated_at\":\"2021-11-15 16:35:25\",\"picture\":\"20211115_163524_HC_14121.jpg\",\"id\":23,\"upload_photo\":null,\"media\":[]}', '::1', '2021-11-15 08:35:25', '2021-11-15 08:35:25'),
(88, 'audit:created', 24, 'App\\Models\\CustomerLuckDrawData#24', 2, '{\"customer_id\":2,\"entered_happy_code\":\"11221\",\"remark\":\"Invalid Happy Code\",\"status\":0,\"updated_at\":\"2021-11-15 16:36:11\",\"created_at\":\"2021-11-15 16:36:11\",\"id\":24,\"upload_photo\":null,\"media\":[]}', '::1', '2021-11-15 08:36:11', '2021-11-15 08:36:11'),
(89, 'audit:updated', 24, 'App\\Models\\CustomerLuckDrawData#24', 2, '{\"updated_at\":\"2021-11-15 16:36:12\",\"picture\":\"20211115_163612_HC_11221.jpg\",\"id\":24,\"upload_photo\":null,\"media\":[]}', '::1', '2021-11-15 08:36:12', '2021-11-15 08:36:12'),
(90, 'audit:created', 25, 'App\\Models\\CustomerLuckDrawData#25', 2, '{\"customer_id\":2,\"entered_happy_code\":\"13121\",\"remark\":\"Invalid Happy Code\",\"status\":0,\"updated_at\":\"2021-11-15 17:02:45\",\"created_at\":\"2021-11-15 17:02:45\",\"id\":25,\"upload_photo\":null,\"media\":[]}', '::1', '2021-11-15 09:02:45', '2021-11-15 09:02:45'),
(91, 'audit:updated', 25, 'App\\Models\\CustomerLuckDrawData#25', 2, '{\"updated_at\":\"2021-11-15 17:02:46\",\"picture\":\"20211115_170245_HC_13121.jpg\",\"id\":25,\"upload_photo\":null,\"media\":[]}', '::1', '2021-11-15 09:02:46', '2021-11-15 09:02:46'),
(92, 'audit:created', 26, 'App\\Models\\CustomerLuckDrawData#26', 2, '{\"customer_id\":2,\"entered_happy_code\":\"12123\",\"remark\":\"Invalid Happy Code\",\"status\":0,\"updated_at\":\"2021-11-17 10:03:50\",\"created_at\":\"2021-11-17 10:03:50\",\"id\":26,\"upload_photo\":null,\"media\":[]}', '::1', '2021-11-17 02:03:50', '2021-11-17 02:03:50'),
(93, 'audit:updated', 26, 'App\\Models\\CustomerLuckDrawData#26', 2, '{\"picture\":\"20211117_100350_HC_12123.jpg\",\"id\":26,\"upload_photo\":null,\"media\":[]}', '::1', '2021-11-17 02:03:51', '2021-11-17 02:03:51'),
(94, 'audit:created', 15, 'App\\Models\\LuckDrawData#15', 1, '{\"lucky_draw_item_id\":\"2\",\"happy_code\":\"11331\",\"is_used\":0,\"status\":\"1\",\"updated_at\":\"2021-11-17 10:06:03\",\"created_at\":\"2021-11-17 10:06:03\",\"id\":15}', '::1', '2021-11-17 02:06:03', '2021-11-17 02:06:03'),
(95, 'audit:created', 16, 'App\\Models\\LuckDrawData#16', 1, '{\"lucky_draw_item_id\":\"2\",\"happy_code\":\"14411\",\"is_used\":0,\"status\":\"1\",\"updated_at\":\"2021-11-17 10:06:03\",\"created_at\":\"2021-11-17 10:06:03\",\"id\":16}', '::1', '2021-11-17 02:06:03', '2021-11-17 02:06:03'),
(96, 'audit:created', 17, 'App\\Models\\LuckDrawData#17', 1, '{\"lucky_draw_item_id\":\"2\",\"happy_code\":\"19190\",\"is_used\":0,\"status\":\"1\",\"updated_at\":\"2021-11-17 10:06:03\",\"created_at\":\"2021-11-17 10:06:03\",\"id\":17}', '::1', '2021-11-17 02:06:03', '2021-11-17 02:06:03'),
(97, 'audit:updated', 17, 'App\\Models\\LuckDrawData#17', 2, '{\"is_used\":1,\"updated_at\":\"2021-11-17 10:06:28\",\"id\":17,\"lucky_draw_item\":{\"id\":2,\"name\":\"Apple Ipad\",\"video_link\":null,\"description\":null,\"status\":\"1\",\"created_at\":\"2021-10-19 14:21:01\",\"updated_at\":\"2021-10-19 14:21:01\",\"deleted_at\":null,\"picture_path\":null,\"display_picture_path\":null,\"picture\":[{\"id\":3,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":2,\"collection_name\":\"picture\",\"name\":\"61755652463f2_AppleiPad\",\"file_name\":\"61755652463f2_AppleiPad.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":143852,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":2,\"created_at\":\"2021-10-24T12:49:23.000000Z\",\"updated_at\":\"2021-10-24T12:49:24.000000Z\",\"url\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/3\\/61755652463f2_AppleiPad.jpg\",\"thumbnail\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/3\\/conversions\\/61755652463f2_AppleiPad-thumb.jpg\",\"preview\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/3\\/conversions\\/61755652463f2_AppleiPad-preview.jpg\"}],\"display_picture\":[],\"media\":[{\"id\":3,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":2,\"collection_name\":\"picture\",\"name\":\"61755652463f2_AppleiPad\",\"file_name\":\"61755652463f2_AppleiPad.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":143852,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":2,\"created_at\":\"2021-10-24T12:49:23.000000Z\",\"updated_at\":\"2021-10-24T12:49:24.000000Z\",\"url\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/3\\/61755652463f2_AppleiPad.jpg\",\"thumbnail\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/3\\/conversions\\/61755652463f2_AppleiPad-thumb.jpg\",\"preview\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/3\\/conversions\\/61755652463f2_AppleiPad-preview.jpg\"}]}}', '::1', '2021-11-17 02:06:28', '2021-11-17 02:06:28'),
(98, 'audit:created', 27, 'App\\Models\\CustomerLuckDrawData#27', 2, '{\"luck_draw_data_id\":17,\"customer_id\":2,\"entered_happy_code\":\"19190\",\"status\":0,\"updated_at\":\"2021-11-17 10:06:28\",\"created_at\":\"2021-11-17 10:06:28\",\"id\":27,\"upload_photo\":null,\"media\":[]}', '::1', '2021-11-17 02:06:28', '2021-11-17 02:06:28'),
(99, 'audit:updated', 27, 'App\\Models\\CustomerLuckDrawData#27', 2, '{\"picture\":\"20211117_100628_HC_19190.jpg\",\"id\":27,\"upload_photo\":null,\"media\":[]}', '::1', '2021-11-17 02:06:28', '2021-11-17 02:06:28'),
(100, 'audit:updated', 16, 'App\\Models\\LuckDrawData#16', 1, '{\"updated_at\":\"2021-11-17 10:07:17\",\"lucky_draw_item_id\":\"1\",\"id\":16}', '::1', '2021-11-17 02:07:17', '2021-11-17 02:07:17'),
(101, 'audit:updated', 15, 'App\\Models\\LuckDrawData#15', 1, '{\"updated_at\":\"2021-11-17 10:07:29\",\"lucky_draw_item_id\":\"3\",\"id\":15}', '::1', '2021-11-17 02:07:29', '2021-11-17 02:07:29'),
(102, 'audit:updated', 16, 'App\\Models\\LuckDrawData#16', 1, '{\"happy_code\":\"17819\",\"updated_at\":\"2021-11-17 10:09:24\",\"id\":16}', '::1', '2021-11-17 02:09:24', '2021-11-17 02:09:24'),
(103, 'audit:updated', 16, 'App\\Models\\LuckDrawData#16', 2, '{\"is_used\":1,\"updated_at\":\"2021-11-17 10:09:39\",\"id\":16,\"lucky_draw_item\":{\"id\":1,\"name\":\"Lumos\",\"video_link\":null,\"description\":null,\"status\":\"1\",\"created_at\":\"2021-10-19 14:20:48\",\"updated_at\":\"2021-11-08 17:50:58\",\"deleted_at\":null,\"picture_path\":\"luckyDrawItems\\/picture\\/Lumos.jpg\",\"display_picture_path\":null,\"picture\":[{\"id\":22,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":1,\"collection_name\":\"picture\",\"name\":\"617bfaa5ada70_Lumos\",\"file_name\":\"617bfaa5ada70_Lumos.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":144988,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":21,\"created_at\":\"2021-10-29T13:44:08.000000Z\",\"updated_at\":\"2021-10-29T13:44:09.000000Z\",\"url\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/617bfaa5ada70_Lumos.jpg\",\"thumbnail\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/conversions\\/617bfaa5ada70_Lumos-thumb.jpg\",\"preview\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/conversions\\/617bfaa5ada70_Lumos-preview.jpg\"}],\"display_picture\":[{\"id\":23,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":1,\"collection_name\":\"display_picture\",\"name\":\"617bfabc9a223_Lumos\",\"file_name\":\"617bfabc9a223_Lumos.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":144988,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":22,\"created_at\":\"2021-10-29T13:44:30.000000Z\",\"updated_at\":\"2021-10-29T13:44:31.000000Z\"}],\"media\":[{\"id\":22,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":1,\"collection_name\":\"picture\",\"name\":\"617bfaa5ada70_Lumos\",\"file_name\":\"617bfaa5ada70_Lumos.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":144988,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":21,\"created_at\":\"2021-10-29T13:44:08.000000Z\",\"updated_at\":\"2021-10-29T13:44:09.000000Z\",\"url\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/617bfaa5ada70_Lumos.jpg\",\"thumbnail\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/conversions\\/617bfaa5ada70_Lumos-thumb.jpg\",\"preview\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/conversions\\/617bfaa5ada70_Lumos-preview.jpg\"},{\"id\":23,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":1,\"collection_name\":\"display_picture\",\"name\":\"617bfabc9a223_Lumos\",\"file_name\":\"617bfabc9a223_Lumos.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":144988,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":22,\"created_at\":\"2021-10-29T13:44:30.000000Z\",\"updated_at\":\"2021-10-29T13:44:31.000000Z\"}]}}', '::1', '2021-11-17 02:09:39', '2021-11-17 02:09:39'),
(104, 'audit:created', 28, 'App\\Models\\CustomerLuckDrawData#28', 2, '{\"luck_draw_data_id\":16,\"customer_id\":2,\"entered_happy_code\":\"17819\",\"status\":0,\"updated_at\":\"2021-11-17 10:09:39\",\"created_at\":\"2021-11-17 10:09:39\",\"id\":28,\"upload_photo\":null,\"media\":[]}', '::1', '2021-11-17 02:09:39', '2021-11-17 02:09:39'),
(105, 'audit:updated', 28, 'App\\Models\\CustomerLuckDrawData#28', 2, '{\"picture\":\"20211117_100939_HC_17819.jpg\",\"id\":28,\"upload_photo\":null,\"media\":[]}', '::1', '2021-11-17 02:09:39', '2021-11-17 02:09:39'),
(106, 'audit:updated', 15, 'App\\Models\\LuckDrawData#15', 1, '{\"happy_code\":\"12312\",\"updated_at\":\"2021-11-17 10:11:47\",\"id\":15}', '::1', '2021-11-17 02:11:48', '2021-11-17 02:11:48'),
(107, 'audit:updated', 15, 'App\\Models\\LuckDrawData#15', 1, '{\"happy_code\":\"99714\",\"updated_at\":\"2021-11-17 10:13:27\",\"id\":15}', '::1', '2021-11-17 02:13:27', '2021-11-17 02:13:27'),
(108, 'audit:updated', 15, 'App\\Models\\LuckDrawData#15', 2, '{\"is_used\":1,\"updated_at\":\"2021-11-17 10:13:55\",\"id\":15,\"lucky_draw_item\":{\"id\":3,\"name\":\"Dual Function Freezer\",\"video_link\":null,\"description\":null,\"status\":\"1\",\"created_at\":\"2021-10-24 20:43:28\",\"updated_at\":\"2021-11-08 17:50:40\",\"deleted_at\":null,\"picture_path\":\"luckyDrawItems\\/picture\\/Freezer.jpg\",\"display_picture_path\":null,\"picture\":[{\"id\":5,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":3,\"collection_name\":\"picture\",\"name\":\"6175566840518_Freezer\",\"file_name\":\"6175566840518_Freezer.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":144492,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":4,\"created_at\":\"2021-10-24T12:49:45.000000Z\",\"updated_at\":\"2021-10-24T12:49:46.000000Z\",\"url\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/5\\/6175566840518_Freezer.jpg\",\"thumbnail\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/5\\/conversions\\/6175566840518_Freezer-thumb.jpg\",\"preview\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/5\\/conversions\\/6175566840518_Freezer-preview.jpg\"}],\"display_picture\":[],\"media\":[{\"id\":5,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":3,\"collection_name\":\"picture\",\"name\":\"6175566840518_Freezer\",\"file_name\":\"6175566840518_Freezer.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":144492,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":4,\"created_at\":\"2021-10-24T12:49:45.000000Z\",\"updated_at\":\"2021-10-24T12:49:46.000000Z\",\"url\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/5\\/6175566840518_Freezer.jpg\",\"thumbnail\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/5\\/conversions\\/6175566840518_Freezer-thumb.jpg\",\"preview\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/5\\/conversions\\/6175566840518_Freezer-preview.jpg\"}]}}', '::1', '2021-11-17 02:13:55', '2021-11-17 02:13:55'),
(109, 'audit:created', 29, 'App\\Models\\CustomerLuckDrawData#29', 2, '{\"luck_draw_data_id\":15,\"customer_id\":2,\"entered_happy_code\":\"99714\",\"status\":0,\"updated_at\":\"2021-11-17 10:13:55\",\"created_at\":\"2021-11-17 10:13:55\",\"id\":29,\"upload_photo\":null,\"media\":[]}', '::1', '2021-11-17 02:13:55', '2021-11-17 02:13:55'),
(110, 'audit:updated', 29, 'App\\Models\\CustomerLuckDrawData#29', 2, '{\"picture\":\"20211117_101355_HC_99714.jpg\",\"id\":29,\"upload_photo\":null,\"media\":[]}', '::1', '2021-11-17 02:13:55', '2021-11-17 02:13:55'),
(111, 'audit:created', 18, 'App\\Models\\LuckDrawData#18', 1, '{\"lucky_draw_item_id\":\"1\",\"happy_code\":\"88798\",\"is_used\":0,\"status\":\"1\",\"updated_at\":\"2021-11-17 10:18:34\",\"created_at\":\"2021-11-17 10:18:34\",\"id\":18}', '::1', '2021-11-17 02:18:34', '2021-11-17 02:18:34'),
(112, 'audit:created', 19, 'App\\Models\\LuckDrawData#19', 1, '{\"lucky_draw_item_id\":\"1\",\"happy_code\":\"91778\",\"is_used\":0,\"status\":\"1\",\"updated_at\":\"2021-11-17 10:18:34\",\"created_at\":\"2021-11-17 10:18:34\",\"id\":19}', '::1', '2021-11-17 02:18:34', '2021-11-17 02:18:34'),
(113, 'audit:created', 20, 'App\\Models\\LuckDrawData#20', 1, '{\"lucky_draw_item_id\":\"1\",\"happy_code\":\"61681\",\"is_used\":0,\"status\":\"1\",\"updated_at\":\"2021-11-17 10:18:34\",\"created_at\":\"2021-11-17 10:18:34\",\"id\":20}', '::1', '2021-11-17 02:18:34', '2021-11-17 02:18:34'),
(114, 'audit:created', 21, 'App\\Models\\LuckDrawData#21', 1, '{\"lucky_draw_item_id\":\"1\",\"happy_code\":\"68629\",\"is_used\":0,\"status\":\"1\",\"updated_at\":\"2021-11-17 10:18:34\",\"created_at\":\"2021-11-17 10:18:34\",\"id\":21}', '::1', '2021-11-17 02:18:34', '2021-11-17 02:18:34'),
(115, 'audit:updated', 21, 'App\\Models\\LuckDrawData#21', 2, '{\"is_used\":1,\"updated_at\":\"2021-11-17 10:18:56\",\"id\":21,\"lucky_draw_item\":{\"id\":1,\"name\":\"Lumos\",\"video_link\":null,\"description\":null,\"status\":\"1\",\"created_at\":\"2021-10-19 14:20:48\",\"updated_at\":\"2021-11-08 17:50:58\",\"deleted_at\":null,\"picture_path\":\"luckyDrawItems\\/picture\\/Lumos.jpg\",\"display_picture_path\":null,\"picture\":[{\"id\":22,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":1,\"collection_name\":\"picture\",\"name\":\"617bfaa5ada70_Lumos\",\"file_name\":\"617bfaa5ada70_Lumos.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":144988,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":21,\"created_at\":\"2021-10-29T13:44:08.000000Z\",\"updated_at\":\"2021-10-29T13:44:09.000000Z\",\"url\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/617bfaa5ada70_Lumos.jpg\",\"thumbnail\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/conversions\\/617bfaa5ada70_Lumos-thumb.jpg\",\"preview\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/conversions\\/617bfaa5ada70_Lumos-preview.jpg\"}],\"display_picture\":[{\"id\":23,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":1,\"collection_name\":\"display_picture\",\"name\":\"617bfabc9a223_Lumos\",\"file_name\":\"617bfabc9a223_Lumos.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":144988,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":22,\"created_at\":\"2021-10-29T13:44:30.000000Z\",\"updated_at\":\"2021-10-29T13:44:31.000000Z\"}],\"media\":[{\"id\":22,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":1,\"collection_name\":\"picture\",\"name\":\"617bfaa5ada70_Lumos\",\"file_name\":\"617bfaa5ada70_Lumos.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":144988,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":21,\"created_at\":\"2021-10-29T13:44:08.000000Z\",\"updated_at\":\"2021-10-29T13:44:09.000000Z\",\"url\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/617bfaa5ada70_Lumos.jpg\",\"thumbnail\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/conversions\\/617bfaa5ada70_Lumos-thumb.jpg\",\"preview\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/conversions\\/617bfaa5ada70_Lumos-preview.jpg\"},{\"id\":23,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":1,\"collection_name\":\"display_picture\",\"name\":\"617bfabc9a223_Lumos\",\"file_name\":\"617bfabc9a223_Lumos.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":144988,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":22,\"created_at\":\"2021-10-29T13:44:30.000000Z\",\"updated_at\":\"2021-10-29T13:44:31.000000Z\"}]}}', '::1', '2021-11-17 02:18:56', '2021-11-17 02:18:56'),
(116, 'audit:created', 30, 'App\\Models\\CustomerLuckDrawData#30', 2, '{\"luck_draw_data_id\":21,\"customer_id\":2,\"entered_happy_code\":\"68629\",\"status\":0,\"updated_at\":\"2021-11-17 10:18:56\",\"created_at\":\"2021-11-17 10:18:56\",\"id\":30,\"upload_photo\":null,\"media\":[]}', '::1', '2021-11-17 02:18:56', '2021-11-17 02:18:56'),
(117, 'audit:updated', 30, 'App\\Models\\CustomerLuckDrawData#30', 2, '{\"picture\":\"20211117_101856_HC_68629.jpg\",\"id\":30,\"upload_photo\":null,\"media\":[]}', '::1', '2021-11-17 02:18:56', '2021-11-17 02:18:56'),
(118, 'audit:updated', 20, 'App\\Models\\LuckDrawData#20', 2, '{\"is_used\":1,\"updated_at\":\"2021-11-17 10:52:55\",\"id\":20,\"lucky_draw_item\":{\"id\":1,\"name\":\"Lumos\",\"video_link\":null,\"description\":null,\"status\":\"1\",\"created_at\":\"2021-10-19 14:20:48\",\"updated_at\":\"2021-11-08 17:50:58\",\"deleted_at\":null,\"picture_path\":\"luckyDrawItems\\/picture\\/Lumos.jpg\",\"display_picture_path\":\"luckyDrawItems\\/displayPicture\\/Lumos.jpg\",\"picture\":[{\"id\":22,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":1,\"collection_name\":\"picture\",\"name\":\"617bfaa5ada70_Lumos\",\"file_name\":\"617bfaa5ada70_Lumos.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":144988,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":21,\"created_at\":\"2021-10-29T13:44:08.000000Z\",\"updated_at\":\"2021-10-29T13:44:09.000000Z\",\"url\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/617bfaa5ada70_Lumos.jpg\",\"thumbnail\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/conversions\\/617bfaa5ada70_Lumos-thumb.jpg\",\"preview\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/conversions\\/617bfaa5ada70_Lumos-preview.jpg\"}],\"display_picture\":[{\"id\":23,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":1,\"collection_name\":\"display_picture\",\"name\":\"617bfabc9a223_Lumos\",\"file_name\":\"617bfabc9a223_Lumos.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":144988,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":22,\"created_at\":\"2021-10-29T13:44:30.000000Z\",\"updated_at\":\"2021-10-29T13:44:31.000000Z\"}],\"media\":[{\"id\":22,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":1,\"collection_name\":\"picture\",\"name\":\"617bfaa5ada70_Lumos\",\"file_name\":\"617bfaa5ada70_Lumos.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":144988,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":21,\"created_at\":\"2021-10-29T13:44:08.000000Z\",\"updated_at\":\"2021-10-29T13:44:09.000000Z\",\"url\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/617bfaa5ada70_Lumos.jpg\",\"thumbnail\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/conversions\\/617bfaa5ada70_Lumos-thumb.jpg\",\"preview\":\"https:\\/\\/localhost:8080\\/hgluckydrawcny2022\\/public\\/storage\\/app\\/public\\/22\\/conversions\\/617bfaa5ada70_Lumos-preview.jpg\"},{\"id\":23,\"model_type\":\"App\\\\Models\\\\LuckyDrawItem\",\"model_id\":1,\"collection_name\":\"display_picture\",\"name\":\"617bfabc9a223_Lumos\",\"file_name\":\"617bfabc9a223_Lumos.jpg\",\"mime_type\":\"image\\/jpeg\",\"disk\":\"public\",\"size\":144988,\"manipulations\":[],\"custom_properties\":{\"generated_conversions\":{\"thumb\":true,\"preview\":true}},\"responsive_images\":[],\"order_column\":22,\"created_at\":\"2021-10-29T13:44:30.000000Z\",\"updated_at\":\"2021-10-29T13:44:31.000000Z\"}]}}', '::1', '2021-11-17 02:52:56', '2021-11-17 02:52:56'),
(119, 'audit:created', 31, 'App\\Models\\CustomerLuckDrawData#31', 2, '{\"luck_draw_data_id\":20,\"customer_id\":2,\"entered_happy_code\":\"61681\",\"status\":0,\"updated_at\":\"2021-11-17 10:52:56\",\"created_at\":\"2021-11-17 10:52:56\",\"id\":31,\"upload_photo\":null,\"media\":[]}', '::1', '2021-11-17 02:52:56', '2021-11-17 02:52:56'),
(120, 'audit:updated', 31, 'App\\Models\\CustomerLuckDrawData#31', 2, '{\"picture\":\"20211117_105256_HC_61681.jpg\",\"id\":31,\"upload_photo\":null,\"media\":[]}', '::1', '2021-11-17 02:52:56', '2021-11-17 02:52:56'),
(121, 'audit:created', 32, 'App\\Models\\CustomerLuckDrawData#32', 1, '{\"customer_id\":1,\"entered_happy_code\":\"61681\",\"is_duplicate\":1,\"remark\":\"The entered happy code (61681) is existed.\",\"status\":0,\"updated_at\":\"2021-11-17 11:02:17\",\"created_at\":\"2021-11-17 11:02:17\",\"id\":32,\"upload_photo\":null,\"media\":[]}', '::1', '2021-11-17 03:02:17', '2021-11-17 03:02:17'),
(122, 'audit:updated', 32, 'App\\Models\\CustomerLuckDrawData#32', 1, '{\"updated_at\":\"2021-11-17 11:02:18\",\"picture\":\"20211117_110217_HC_61681.jpg\",\"id\":32,\"upload_photo\":null,\"media\":[]}', '::1', '2021-11-17 03:02:18', '2021-11-17 03:02:18');

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

--
-- Table structure for table `cities`
--

CREATE TABLE `cities` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `city_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `zipcode` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sort` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `province_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cities`
--

INSERT INTO `cities` (`id`, `city_name`, `zipcode`, `sort`, `created_at`, `updated_at`, `deleted_at`, `province_id`) VALUES
(9, 'Ayer Tawar', '', 0, NULL, NULL, NULL, 5),
(10, 'Bagan Datoh', '', 0, NULL, NULL, NULL, 5),
(11, 'Bagan Serai', '', 0, NULL, NULL, NULL, 5),
(37, 'Klang', '', 0, NULL, NULL, NULL, 14),
(38, 'Labuan', '', 0, NULL, NULL, NULL, 15),
(396, 'Alam Impian', '', 0, NULL, NULL, NULL, 14),
(397, 'Aman Perdana', '', 0, NULL, NULL, NULL, 14),
(398, 'Ambang Botanic', '', 0, NULL, NULL, NULL, 14),
(399, 'Ampang', '', 0, NULL, NULL, NULL, 14),
(400, 'Ara Damansara', '', 0, NULL, NULL, NULL, 14),
(401, 'Balakong', '', 0, NULL, NULL, NULL, 14),
(402, 'Bandar Botanic', '', 0, NULL, NULL, NULL, 14),
(403, 'Bandar Bukit Raja', '', 0, NULL, NULL, NULL, 14),
(404, 'Bandar Bukit Tinggi', '', 0, NULL, NULL, NULL, 14),
(405, 'Bandar Kinrara', '', 0, NULL, NULL, NULL, 14),
(406, 'Bandar Mahkota Cheras', '', 0, NULL, NULL, NULL, 14),
(407, 'Bandar Puncak Alam', '', 0, NULL, NULL, NULL, 14),
(408, 'Bandar Puteri Puchong', '', 0, NULL, NULL, NULL, 14),
(409, 'Bandar Saujana Putra', '', 0, NULL, NULL, NULL, 14),
(410, 'Bandar Sri Damansara', '', 0, NULL, NULL, NULL, 14),
(411, 'Bandar Sungai Long', '', 0, NULL, NULL, NULL, 14),
(412, 'Bandar Sunway', '', 0, NULL, NULL, NULL, 14),
(413, 'Bandar Utama', '', 0, NULL, NULL, NULL, 14),
(414, 'Bangi', '', 0, NULL, NULL, NULL, 14),
(415, 'Banting', '', 0, NULL, NULL, NULL, 14),
(416, 'Batang Berjuntai', '', 0, NULL, NULL, NULL, 14),
(417, 'Batang Kali', '', 0, NULL, NULL, NULL, 14),
(418, 'Batu Arang', '', 0, NULL, NULL, NULL, 14),
(419, 'Batu Caves', '', 0, NULL, NULL, NULL, 14),
(420, 'Beranang', '', 0, NULL, NULL, NULL, 14),
(421, 'Bukit Beruntung', '', 0, NULL, NULL, NULL, 14),
(422, 'Bukit Jelutong', '', 0, NULL, NULL, NULL, 14),
(423, 'Bukit Rahman Putra', '', 0, NULL, NULL, NULL, 14),
(424, 'Bukit Rotan', '', 0, NULL, NULL, NULL, 14),
(425, 'Bukit Subang', '', 0, NULL, NULL, NULL, 14),
(426, 'Cheras', '', 0, NULL, NULL, NULL, 14),
(427, 'Country Heights', '', 0, NULL, NULL, NULL, 14),
(428, 'Cyberjaya', '', 0, NULL, NULL, NULL, 14),
(429, 'Damansara Damai', '', 0, NULL, NULL, NULL, 14),
(430, 'Damansara Intan', '', 0, NULL, NULL, NULL, 14),
(431, 'Damansara Jaya', '', 0, NULL, NULL, NULL, 14),
(432, 'Damansara Kim', '', 0, NULL, NULL, NULL, 14),
(433, 'Damansara Perdana', '', 0, NULL, NULL, NULL, 14),
(434, 'Damansara Utama', '', 0, NULL, NULL, NULL, 14),
(435, 'Denai Alam', '', 0, NULL, NULL, NULL, 14),
(436, 'Dengkil', '', 0, NULL, NULL, NULL, 14),
(437, 'Glenmarie', '', 0, NULL, NULL, NULL, 14),
(438, 'Gombak', '', 0, NULL, NULL, NULL, 14),
(439, 'Hulu Langat', '', 0, NULL, NULL, NULL, 14),
(440, 'Hulu Selangor', '', 0, NULL, NULL, NULL, 14),
(441, 'I-City', '', 0, NULL, NULL, NULL, 14),
(442, 'Ijok', '', 0, NULL, NULL, NULL, 14),
(443, 'Jade Hills', '', 0, NULL, NULL, NULL, 14),
(444, 'Jenjarom', '', 0, NULL, NULL, NULL, 14),
(445, 'Kajang', '', 0, NULL, NULL, NULL, 14),
(446, 'Kapar', '', 0, NULL, NULL, NULL, 14),
(447, 'Kayu Ara', '', 0, NULL, NULL, NULL, 14),
(448, 'Kelana Jaya', '', 0, NULL, NULL, NULL, 14),
(449, 'Kepong', '', 0, NULL, NULL, NULL, 14),
(450, 'Kerling', '', 0, NULL, NULL, NULL, 14),
(451, 'Klang', '', 0, NULL, NULL, NULL, 14),
(452, 'Kota Damansara', '', 0, NULL, NULL, NULL, 14),
(453, 'Kota Emerald', '', 0, NULL, NULL, NULL, 14),
(454, 'Kota Kemuning', '', 0, NULL, NULL, NULL, 14),
(455, 'Kuala Kubu Baru', '', 0, NULL, NULL, NULL, 14),
(456, 'Kuala Langat', '', 0, NULL, NULL, NULL, 14),
(457, 'Kuala Selangor', '', 0, NULL, NULL, NULL, 14),
(458, 'Kuang', '', 0, NULL, NULL, NULL, 14),
(459, 'Kundang', '', 0, NULL, NULL, NULL, 14),
(460, 'Mutiara Damansara', '', 0, NULL, NULL, NULL, 14),
(461, 'Nilai', '', 0, NULL, NULL, NULL, 14),
(462, 'Pandamaran', '', 0, NULL, NULL, NULL, 14),
(463, 'Petaling Jaya', '', 0, NULL, NULL, NULL, 14),
(464, 'Port Klang', '', 0, NULL, NULL, NULL, 14),
(465, 'Puchong', '', 0, NULL, NULL, NULL, 14),
(466, 'Puchong South', '', 0, NULL, NULL, NULL, 14),
(467, 'Pulau Indah ( Pulau Lumut)', '', 0, NULL, NULL, NULL, 14),
(468, 'Pulau Carey', '', 0, NULL, NULL, NULL, 14),
(469, 'Pulau Ketam', '', 0, NULL, NULL, NULL, 14),
(470, 'Puncak Jalil', '', 0, NULL, NULL, NULL, 14),
(471, 'Putra Heights', '', 0, NULL, NULL, NULL, 14),
(472, 'Rasa', '', 0, NULL, NULL, NULL, 14),
(473, 'Rawang', '', 0, NULL, NULL, NULL, 14),
(474, 'Sabak Bernam', '', 0, NULL, NULL, NULL, 14),
(475, 'Saujana', '', 0, NULL, NULL, NULL, 14),
(476, 'Saujana Utama', '', 0, NULL, NULL, NULL, 14),
(477, 'Sekinchan', '', 0, NULL, NULL, NULL, 14),
(478, 'Selayang', '', 0, NULL, NULL, NULL, 14),
(479, 'Semenyih', '', 0, NULL, NULL, NULL, 14),
(480, 'Sepang', '', 0, NULL, NULL, NULL, 14),
(481, 'Serdang', '', 0, NULL, NULL, NULL, 14),
(482, 'Serendah', '', 0, NULL, NULL, NULL, 14),
(483, 'Seri Kembangan', '', 0, NULL, NULL, NULL, 14),
(484, 'Setia Alam', '', 0, NULL, NULL, NULL, 14),
(485, 'Setia Eco Park', '', 0, NULL, NULL, NULL, 14),
(486, 'Shah Alam', '', 0, NULL, NULL, NULL, 14),
(487, 'SierraMas', '', 0, NULL, NULL, NULL, 14),
(488, 'SS2', '', 0, NULL, NULL, NULL, 14),
(489, 'Subang Bestari', '', 0, NULL, NULL, NULL, 14),
(490, 'Subang Heights', '', 0, NULL, NULL, NULL, 14),
(491, 'Subang Jaya', '', 0, NULL, NULL, NULL, 14),
(492, 'Sungai Ayer Tawar', '', 0, NULL, NULL, NULL, 14),
(493, 'Sungai Besar', '', 0, NULL, NULL, NULL, 14),
(494, 'Sungai Buloh', '', 0, NULL, NULL, NULL, 14),
(495, 'Sungai Pelek', '', 0, NULL, NULL, NULL, 14),
(496, 'Taman Melawati', '', 0, NULL, NULL, NULL, 14),
(497, 'Taman TTDI Jaya', '', 0, NULL, NULL, NULL, 14),
(498, 'Tanjong Duabelas', '', 0, NULL, NULL, NULL, 14),
(499, 'Tanjong Karang', '', 0, NULL, NULL, NULL, 14),
(500, 'Tanjong Sepat', '', 0, NULL, NULL, NULL, 14),
(501, 'Telok Panglima Garang', '', 0, NULL, NULL, NULL, 14),
(502, 'Tropicana', '', 0, NULL, NULL, NULL, 14),
(503, 'Ulu Bernam', '', 0, NULL, NULL, NULL, 14),
(504, 'Ulu Klang', '', 0, NULL, NULL, NULL, 14),
(505, 'Ulu Langat', '', 0, NULL, NULL, NULL, 14),
(506, 'USJ', '', 0, NULL, NULL, NULL, 14),
(507, 'USJ Heights', '', 0, NULL, NULL, NULL, 14),
(508, 'Valencia', '', 0, NULL, NULL, NULL, 14),
(509, 'Ampang', '', 0, NULL, NULL, NULL, 2),
(510, 'Ampang Hilir', '', 0, NULL, NULL, NULL, 2),
(511, 'Bandar Damai Perdana', '', 0, NULL, NULL, NULL, 2),
(512, 'Bandar Menjalara', '', 0, NULL, NULL, NULL, 2),
(513, 'Bandar Tasik Selatan', '', 0, NULL, NULL, NULL, 2),
(514, 'Bangsar', '', 0, NULL, NULL, NULL, 2),
(515, 'Batu Caves', '', 0, NULL, NULL, NULL, 2),
(516, 'Brickfields', '', 0, NULL, NULL, NULL, 2),
(517, 'Bukit Bintang', '', 0, NULL, NULL, NULL, 2),
(518, 'Bukit Jalil', '', 0, NULL, NULL, NULL, 2),
(519, 'Bukit Kiara', '', 0, NULL, NULL, NULL, 2),
(520, 'Bukit Ledang', '', 0, NULL, NULL, NULL, 2),
(521, 'Bukit Tunku (Kenny Hills)', '', 0, NULL, NULL, NULL, 2),
(522, 'Chan Sow Lin', '', 0, NULL, NULL, NULL, 2),
(523, 'Cheras', '', 0, NULL, NULL, NULL, 2),
(524, 'City Centre', '', 0, NULL, NULL, NULL, 2),
(525, 'Country Heights Damansara', '', 0, NULL, NULL, NULL, 2),
(526, 'Damansara', '', 0, NULL, NULL, NULL, 2),
(527, 'Damansara Heights', '', 0, NULL, NULL, NULL, 2),
(528, 'Desa Pandan', '', 0, NULL, NULL, NULL, 2),
(529, 'Desa ParkCity', '', 0, NULL, NULL, NULL, 2),
(530, 'Desa Petaling', '', 0, NULL, NULL, NULL, 2),
(531, 'Dutamas', '', 0, NULL, NULL, NULL, 2),
(532, 'Federal Hill', '', 0, NULL, NULL, NULL, 2),
(533, 'Jalan Ipoh', '', 0, NULL, NULL, NULL, 2),
(534, 'Jalan Klang Lama (Old Klang Road)', '', 0, NULL, NULL, NULL, 2),
(535, 'Jalan Kuching', '', 0, NULL, NULL, NULL, 2),
(536, 'Jalan Sultan Ismail', '', 0, NULL, NULL, NULL, 2),
(537, 'Jinjang', '', 0, NULL, NULL, NULL, 2),
(538, 'Kampung Kerinchi (Bangsar South)', '', 0, NULL, NULL, NULL, 2),
(539, 'Kepong', '', 0, NULL, NULL, NULL, 2),
(540, 'Keramat', '', 0, NULL, NULL, NULL, 2),
(541, 'KL City', '', 0, NULL, NULL, NULL, 2),
(542, 'KL Eco City', '', 0, NULL, NULL, NULL, 2),
(543, 'KL Sentral', '', 0, NULL, NULL, NULL, 2),
(544, 'KLCC', '', 0, NULL, NULL, NULL, 2),
(545, 'Kuchai Lama', '', 0, NULL, NULL, NULL, 2),
(546, 'Mid Valley City', '', 0, NULL, NULL, NULL, 2),
(547, 'Mont Kiara', '', 0, NULL, NULL, NULL, 2),
(548, 'OUG', '', 0, NULL, NULL, NULL, 2),
(549, 'Pandan Indah', '', 0, NULL, NULL, NULL, 2),
(550, 'Pandan Jaya', '', 0, NULL, NULL, NULL, 2),
(551, 'Pandan Perdana', '', 0, NULL, NULL, NULL, 2),
(552, 'Pantai', '', 0, NULL, NULL, NULL, 2),
(553, 'Puchong', '', 0, NULL, NULL, NULL, 2),
(554, 'Salak Selatan', '', 0, NULL, NULL, NULL, 2),
(555, 'Segambut', '', 0, NULL, NULL, NULL, 2),
(556, 'Sentul', '', 0, NULL, NULL, NULL, 2),
(557, 'Seputeh', '', 0, NULL, NULL, NULL, 2),
(558, 'Setapak', '', 0, NULL, NULL, NULL, 2),
(559, 'Setiawangsa', '', 0, NULL, NULL, NULL, 2),
(560, 'Sri Hartamas', '', 0, NULL, NULL, NULL, 2),
(561, 'Sri Petaling', '', 0, NULL, NULL, NULL, 2),
(562, 'Sungai Besi', '', 0, NULL, NULL, NULL, 2),
(563, 'Sungai Penchala', '', 0, NULL, NULL, NULL, 2),
(564, 'Sunway SPK', '', 0, NULL, NULL, NULL, 2),
(565, 'Taman Desa', '', 0, NULL, NULL, NULL, 2),
(566, 'Taman Duta', '', 0, NULL, NULL, NULL, 2),
(567, 'Taman Melawati', '', 0, NULL, NULL, NULL, 2),
(568, 'Taman Tun Dr Ismail', '', 0, NULL, NULL, NULL, 2),
(569, 'Titiwangsa', '', 0, NULL, NULL, NULL, 2),
(570, 'Wangsa Maju', '', 0, NULL, NULL, NULL, 2),
(571, 'Ayer Baloi', '', 0, NULL, NULL, NULL, 3),
(572, 'Ayer Hitam', '', 0, NULL, NULL, NULL, 3),
(573, 'Bakri', '', 0, NULL, NULL, NULL, 3),
(574, 'Batu Anam', '', 0, NULL, NULL, NULL, 3),
(575, 'Batu Pahat', '', 0, NULL, NULL, NULL, 3),
(576, 'Bekok', '', 0, NULL, NULL, NULL, 3),
(577, 'Benut', '', 0, NULL, NULL, NULL, 3),
(578, 'Bukit Gambir', '', 0, NULL, NULL, NULL, 3),
(579, 'Bukit Pasir', '', 0, NULL, NULL, NULL, 3),
(580, 'Bukit Serampang', '', 0, NULL, NULL, NULL, 3),
(581, 'Chaah', '', 0, NULL, NULL, NULL, 3),
(582, 'Endau', '', 0, NULL, NULL, NULL, 3),
(583, 'Gelang Patah', '', 0, NULL, NULL, NULL, 3),
(584, 'Gerisek', '', 0, NULL, NULL, NULL, 3),
(585, 'Gugusan Taib Andak', '', 0, NULL, NULL, NULL, 3),
(586, 'Horizon Hills', '', 0, NULL, NULL, NULL, 3),
(587, 'Iskandar Puteri (Nusajaya)', '', 0, NULL, NULL, NULL, 3),
(588, 'Jementah', '', 0, NULL, NULL, NULL, 3),
(589, 'Johor Bahru', '', 0, NULL, NULL, NULL, 3),
(590, 'Kahang', '', 0, NULL, NULL, NULL, 3),
(591, 'Kampung Kenangan Tun Dr Ismail', '', 0, NULL, NULL, NULL, 3),
(592, 'Kluang', '', 0, NULL, NULL, NULL, 3),
(593, 'Kota Tinggi', '', 0, NULL, NULL, NULL, 3),
(594, 'Kukup', '', 0, NULL, NULL, NULL, 3),
(595, 'Kulai', '', 0, NULL, NULL, NULL, 3),
(596, 'Labis', '', 0, NULL, NULL, NULL, 3),
(597, 'Layang Layang', '', 0, NULL, NULL, NULL, 3),
(598, 'Masai', '', 0, NULL, NULL, NULL, 3),
(599, 'Medini', '', 0, NULL, NULL, NULL, 3),
(600, 'Mersing', '', 0, NULL, NULL, NULL, 3),
(601, 'Muar', '', 0, NULL, NULL, NULL, 3),
(602, 'Pagoh', '', 0, NULL, NULL, NULL, 3),
(603, 'Paloh', '', 0, NULL, NULL, NULL, 3),
(604, 'Panchor', '', 0, NULL, NULL, NULL, 3),
(605, 'Parit Jawa', '', 0, NULL, NULL, NULL, 3),
(606, 'Parit Raja', '', 0, NULL, NULL, NULL, 3),
(607, 'Parit Sulong', '', 0, NULL, NULL, NULL, 3),
(608, 'Pasir Gudang', '', 0, NULL, NULL, NULL, 3),
(609, 'Pekan Nanas', '', 0, NULL, NULL, NULL, 3),
(610, 'Pengerang', '', 0, NULL, NULL, NULL, 3),
(611, 'Perling', '', 0, NULL, NULL, NULL, 3),
(612, 'Permas Jaya', '', 0, NULL, NULL, NULL, 3),
(613, 'Plentong', '', 0, NULL, NULL, NULL, 3),
(614, 'Pontian', '', 0, NULL, NULL, NULL, 3),
(615, 'Puteri Harbour', '', 0, NULL, NULL, NULL, 3),
(616, 'Rengam', '', 0, NULL, NULL, NULL, 3),
(617, 'Rengit', '', 0, NULL, NULL, NULL, 3),
(618, 'Segamat', '', 0, NULL, NULL, NULL, 3),
(619, 'Semerah', '', 0, NULL, NULL, NULL, 3),
(620, 'Senai', '', 0, NULL, NULL, NULL, 3),
(621, 'Senggarang', '', 0, NULL, NULL, NULL, 3),
(622, 'Senibong', '', 0, NULL, NULL, NULL, 3),
(623, 'Seri Gadang', '', 0, NULL, NULL, NULL, 3),
(624, 'Setia Indah', '', 0, NULL, NULL, NULL, 3),
(625, 'Setia Tropika', '', 0, NULL, NULL, NULL, 3),
(626, 'Simpang Rengam', '', 0, NULL, NULL, NULL, 3),
(627, 'Skudai', '', 0, NULL, NULL, NULL, 3),
(628, 'Sungai Mati', '', 0, NULL, NULL, NULL, 3),
(629, 'Tampoi', '', 0, NULL, NULL, NULL, 3),
(630, 'Tangkak', '', 0, NULL, NULL, NULL, 3),
(631, 'Tebrau', '', 0, NULL, NULL, NULL, 3),
(632, 'Ulu Tiram', '', 0, NULL, NULL, NULL, 3),
(633, 'Yong Peng', '', 0, NULL, NULL, NULL, 3),
(634, 'Air Tawar', '', 0, NULL, NULL, NULL, 35),
(635, 'Alma', '', 0, NULL, NULL, NULL, 35),
(636, 'Ayer Itam', '', 0, NULL, NULL, NULL, 35),
(637, 'Bagan Ajam', '', 0, NULL, NULL, NULL, 35),
(638, 'Bagan Jermal', '', 0, NULL, NULL, NULL, 35),
(639, 'Bagan Lallang', '', 0, NULL, NULL, NULL, 35),
(640, 'Balik Pulau', '', 0, NULL, NULL, NULL, 35),
(641, 'Bandar Perda', '', 0, NULL, NULL, NULL, 35),
(642, 'Batu Ferringhi', '', 0, NULL, NULL, NULL, 35),
(643, 'Batu Kawan', '', 0, NULL, NULL, NULL, 35),
(644, 'Batu Maung', '', 0, NULL, NULL, NULL, 35),
(645, 'Batu Uban', '', 0, NULL, NULL, NULL, 35),
(646, 'Bayan Baru', '', 0, NULL, NULL, NULL, 35),
(647, 'Bayan Lepas', '', 0, NULL, NULL, NULL, 35),
(648, 'Berapit', '', 0, NULL, NULL, NULL, 35),
(649, 'Bertam', '', 0, NULL, NULL, NULL, 35),
(650, 'Bukit Dumbar', '', 0, NULL, NULL, NULL, 35),
(651, 'Bukit Jambul', '', 0, NULL, NULL, NULL, 35),
(652, 'Bukit Mertajam', '', 0, NULL, NULL, NULL, 35),
(653, 'Bukit Minyak', '', 0, NULL, NULL, NULL, 35),
(654, 'Bukit Tambun', '', 0, NULL, NULL, NULL, 35),
(655, 'Bukit Tengah', '', 0, NULL, NULL, NULL, 35),
(656, 'Butterworth', '', 0, NULL, NULL, NULL, 35),
(657, 'Gelugor', '', 0, NULL, NULL, NULL, 35),
(658, 'Georgetown', '', 0, NULL, NULL, NULL, 35),
(659, 'Gertak Sangul', '', 0, NULL, NULL, NULL, 35),
(660, 'Greenlane', '', 0, NULL, NULL, NULL, 35),
(661, 'Gurney', '', 0, NULL, NULL, NULL, 35),
(662, 'Jawi', '', 0, NULL, NULL, NULL, 35),
(663, 'Jelutong', '', 0, NULL, NULL, NULL, 35),
(664, 'Juru', '', 0, NULL, NULL, NULL, 35),
(665, 'Kepala Batas', '', 0, NULL, NULL, NULL, 35),
(666, 'Kubang Semang', '', 0, NULL, NULL, NULL, 35),
(667, 'Mak Mandin', '', 0, NULL, NULL, NULL, 35),
(668, 'Minden Heights', '', 0, NULL, NULL, NULL, 35),
(669, 'Nibong Tebal', '', 0, NULL, NULL, NULL, 35),
(670, 'Pauh Jaya', '', 0, NULL, NULL, NULL, 35),
(671, 'Paya Terubong', '', 0, NULL, NULL, NULL, 35),
(672, 'Penaga', '', 0, NULL, NULL, NULL, 35),
(673, 'Penang Hill', '', 0, NULL, NULL, NULL, 35),
(674, 'Penanti', '', 0, NULL, NULL, NULL, 35),
(675, 'Perai', '', 0, NULL, NULL, NULL, 35),
(676, 'Permatang Kuching', '', 0, NULL, NULL, NULL, 35),
(677, 'Permatang Pauh', '', 0, NULL, NULL, NULL, 35),
(678, 'Permatang Tinggi', '', 0, NULL, NULL, NULL, 35),
(679, 'Pulau Betong', '', 0, NULL, NULL, NULL, 35),
(680, 'Pulau Tikus', '', 0, NULL, NULL, NULL, 35),
(681, 'Raja Uda', '', 0, NULL, NULL, NULL, 35),
(682, 'Relau', '', 0, NULL, NULL, NULL, 35),
(683, 'Scotland', '', 0, NULL, NULL, NULL, 35),
(684, 'Seberang Jaya', '', 0, NULL, NULL, NULL, 35),
(685, 'Seberang Perai', '', 0, NULL, NULL, NULL, 35),
(686, 'Serdang', '', 0, NULL, NULL, NULL, 35),
(687, 'Simpang Ampat', '', 0, NULL, NULL, NULL, 35),
(688, 'Sungai Ara', '', 0, NULL, NULL, NULL, 35),
(689, 'Sungai Bakap', '', 0, NULL, NULL, NULL, 35),
(690, 'Sungai Dua', '', 0, NULL, NULL, NULL, 35),
(691, 'Sungai Jawi', '', 0, NULL, NULL, NULL, 35),
(692, 'Sungai Nibong', '', 0, NULL, NULL, NULL, 35),
(693, 'Sungai Pinang', '', 0, NULL, NULL, NULL, 35),
(694, 'Tanjong Tokong', '', 0, NULL, NULL, NULL, 35),
(695, 'Tanjung Bungah', '', 0, NULL, NULL, NULL, 35),
(696, 'Tasek Gelugor', '', 0, NULL, NULL, NULL, 35),
(697, 'Teluk Bahang', '', 0, NULL, NULL, NULL, 35),
(698, 'Teluk Kumbar', '', 0, NULL, NULL, NULL, 35),
(699, 'USM', '', 0, NULL, NULL, NULL, 35),
(700, 'Valdor', '', 0, NULL, NULL, NULL, 35),
(701, 'Ampangan', '', 0, NULL, NULL, NULL, 8),
(702, 'Bahau', '', 0, NULL, NULL, NULL, 8),
(703, 'Bandar Baru Serting', '', 0, NULL, NULL, NULL, 8),
(704, 'Bandar Enstek', '', 0, NULL, NULL, NULL, 8),
(705, 'Bandar Sri Sendayan', '', 0, NULL, NULL, NULL, 8),
(706, 'Batang Melaka', '', 0, NULL, NULL, NULL, 8),
(707, 'Batu Kikir', '', 0, NULL, NULL, NULL, 8),
(708, 'Bukit Kepayang', '', 0, NULL, NULL, NULL, 8),
(709, 'Gemas', '', 0, NULL, NULL, NULL, 8),
(710, 'Gemencheh', '', 0, NULL, NULL, NULL, 8),
(711, 'Jelebu', '', 0, NULL, NULL, NULL, 8),
(712, 'Jempol', '', 0, NULL, NULL, NULL, 8),
(713, 'Jimah', '', 0, NULL, NULL, NULL, 8),
(714, 'Johol', '', 0, NULL, NULL, NULL, 8),
(715, 'Juasseh', '', 0, NULL, NULL, NULL, 8),
(716, 'Kota', '', 0, NULL, NULL, NULL, 8),
(717, 'Kuala Klawang', '', 0, NULL, NULL, NULL, 8),
(718, 'Kuala Pilah', '', 0, NULL, NULL, NULL, 8),
(719, 'Labu', '', 0, NULL, NULL, NULL, 8),
(720, 'Lenggeng', '', 0, NULL, NULL, NULL, 8),
(721, 'Linggi', '', 0, NULL, NULL, NULL, 8),
(722, 'Lukut', '', 0, NULL, NULL, NULL, 8),
(723, 'Mantin', '', 0, NULL, NULL, NULL, 8),
(724, 'Nilai', '', 0, NULL, NULL, NULL, 8),
(725, 'Pantai', '', 0, NULL, NULL, NULL, 8),
(726, 'Paroi', '', 0, NULL, NULL, NULL, 8),
(727, 'Pasir Panjang', '', 0, NULL, NULL, NULL, 8),
(728, 'Pedas', '', 0, NULL, NULL, NULL, 8),
(729, 'Port Dickson', '', 0, NULL, NULL, NULL, 8),
(730, 'Rantau', '', 0, NULL, NULL, NULL, 8),
(731, 'Rasah', '', 0, NULL, NULL, NULL, 8),
(732, 'Rembau', '', 0, NULL, NULL, NULL, 8),
(733, 'Rompin', '', 0, NULL, NULL, NULL, 8),
(734, 'Senawang', '', 0, NULL, NULL, NULL, 8),
(735, 'Seremban', '', 0, NULL, NULL, NULL, 8),
(736, 'Seremban 2', '', 0, NULL, NULL, NULL, 8),
(737, 'Sikamat', '', 0, NULL, NULL, NULL, 8),
(738, 'Siliau', '', 0, NULL, NULL, NULL, 8),
(739, 'Simpang Durian', '', 0, NULL, NULL, NULL, 8),
(740, 'Simpang Pertang', '', 0, NULL, NULL, NULL, 8),
(741, 'Sri Menant', '', 0, NULL, NULL, NULL, 8),
(742, 'Sri Rusa', '', 0, NULL, NULL, NULL, 8),
(743, 'Tampin', '', 0, NULL, NULL, NULL, 8),
(744, 'Tanjong Ipoh', '', 0, NULL, NULL, NULL, 8),
(745, 'Telok Kemang', '', 0, NULL, NULL, NULL, 8),
(746, 'Titi', '', 0, NULL, NULL, NULL, 8),
(747, 'Alai', '', 0, NULL, NULL, NULL, 4),
(748, 'Alor Gajah', '', 0, NULL, NULL, NULL, 4),
(749, 'Asahan', '', 0, NULL, NULL, NULL, 4),
(750, 'Ayer Keroh', '', 0, NULL, NULL, NULL, 4),
(751, 'Ayer Molek', '', 0, NULL, NULL, NULL, 4),
(752, 'Bachang', '', 0, NULL, NULL, NULL, 4),
(753, 'Balai Panjang', '', 0, NULL, NULL, NULL, 4),
(754, 'Bandar Hilir', '', 0, NULL, NULL, NULL, 4),
(755, 'Batu Berendam', '', 0, NULL, NULL, NULL, 4),
(756, 'Bemban', '', 0, NULL, NULL, NULL, 4),
(757, 'Bertam', '', 0, NULL, NULL, NULL, 4),
(758, 'Bukit Baru', '', 0, NULL, NULL, NULL, 4),
(759, 'Bukit Beruang', '', 0, NULL, NULL, NULL, 4),
(760, 'Bukit Katil', '', 0, NULL, NULL, NULL, 4),
(761, 'Bukit Rambai', '', 0, NULL, NULL, NULL, 4),
(762, 'Cheng', '', 0, NULL, NULL, NULL, 4),
(763, 'Durian Tunggal', '', 0, NULL, NULL, NULL, 4),
(764, 'Duyong', '', 0, NULL, NULL, NULL, 4),
(765, 'Jasin', '', 0, NULL, NULL, NULL, 4),
(766, 'Klebang', '', 0, NULL, NULL, NULL, 4),
(767, 'Krubong', '', 0, NULL, NULL, NULL, 4),
(768, 'Kuala Linggi', '', 0, NULL, NULL, NULL, 4),
(769, 'Kuala Sungai Baru', '', 0, NULL, NULL, NULL, 4),
(770, 'Lubok China', '', 0, NULL, NULL, NULL, 4),
(771, 'Masjid Tanah', '', 0, NULL, NULL, NULL, 4),
(772, 'Melaka City', '', 0, NULL, NULL, NULL, 4),
(773, 'Melaka Tengah', '', 0, NULL, NULL, NULL, 4),
(774, 'Merlimau', '', 0, NULL, NULL, NULL, 4),
(775, 'Paya Rumput', '', 0, NULL, NULL, NULL, 4),
(776, 'Pegoh', '', 0, NULL, NULL, NULL, 4),
(777, 'Rembia', '', 0, NULL, NULL, NULL, 4),
(778, 'Selandar', '', 0, NULL, NULL, NULL, 4),
(779, 'Semabok', '', 0, NULL, NULL, NULL, 4),
(780, 'Sungai Rambai', '', 0, NULL, NULL, NULL, 4),
(781, 'Sungai Udang', '', 0, NULL, NULL, NULL, 4),
(782, 'Sungei Baru Tengah', '', 0, NULL, NULL, NULL, 4),
(783, 'Sungei Petai', '', 0, NULL, NULL, NULL, 4),
(784, 'Tanjong Kling', '', 0, NULL, NULL, NULL, 4),
(785, 'Tanjong Minyak', '', 0, NULL, NULL, NULL, 4),
(786, 'Telok Mas', '', 0, NULL, NULL, NULL, 4),
(787, 'Ujong Pasir', '', 0, NULL, NULL, NULL, 4),
(788, 'Umbai', '', 0, NULL, NULL, NULL, 4),
(789, 'Balok', '', 0, NULL, NULL, NULL, 9),
(790, 'Bandar Pusat Jengka', '', 0, NULL, NULL, NULL, 9),
(791, 'Bandar Tun Abdul Razak', '', 0, NULL, NULL, NULL, 9),
(792, 'Benta', '', 0, NULL, NULL, NULL, 9),
(793, 'Bentong', '', 0, NULL, NULL, NULL, 9),
(794, 'Bera', '', 0, NULL, NULL, NULL, 9),
(795, 'Brinchang', '', 0, NULL, NULL, NULL, 9),
(796, 'Bukit Fraser', '', 0, NULL, NULL, NULL, 9),
(797, 'Cameron Highlands', '', 0, NULL, NULL, NULL, 9),
(798, 'Chenor', '', 0, NULL, NULL, NULL, 9),
(799, 'Daerah Rompin', '', 0, NULL, NULL, NULL, 9),
(800, 'Damak', '', 0, NULL, NULL, NULL, 9),
(801, 'Dong', '', 0, NULL, NULL, NULL, 9),
(802, 'Genting Highlands', '', 0, NULL, NULL, NULL, 9),
(803, 'Hulu Lepar', '', 0, NULL, NULL, NULL, 9),
(804, 'Hulu Telom', '', 0, NULL, NULL, NULL, 9),
(805, 'Jerantut', '', 0, NULL, NULL, NULL, 9),
(806, 'Karak', '', 0, NULL, NULL, NULL, 9),
(807, 'Kuala Lipis', '', 0, NULL, NULL, NULL, 9),
(808, 'Kuala Rompin', '', 0, NULL, NULL, NULL, 9),
(809, 'Kuantan', '', 0, NULL, NULL, NULL, 9),
(810, 'Lanchang', '', 0, NULL, NULL, NULL, 9),
(811, 'Lurah Bilut', '', 0, NULL, NULL, NULL, 9),
(812, 'Maran', '', 0, NULL, NULL, NULL, 9),
(813, 'Mengkarak', '', 0, NULL, NULL, NULL, 9),
(814, 'Mentakab', '', 0, NULL, NULL, NULL, 9),
(815, 'Muadzam Shah', '', 0, NULL, NULL, NULL, 9),
(816, 'Padang Tengku', '', 0, NULL, NULL, NULL, 9),
(817, 'Pekan', '', 0, NULL, NULL, NULL, 9),
(818, 'Raub', '', 0, NULL, NULL, NULL, 9),
(819, 'Ringlet', '', 0, NULL, NULL, NULL, 9),
(820, 'Rompin', '', 0, NULL, NULL, NULL, 9),
(821, 'Sabai', '', 0, NULL, NULL, NULL, 9),
(822, 'Sega', '', 0, NULL, NULL, NULL, 9),
(823, 'Sungai Karang', '', 0, NULL, NULL, NULL, 9),
(824, 'Sungai Koyan', '', 0, NULL, NULL, NULL, 9),
(825, 'Sungai Lembing', '', 0, NULL, NULL, NULL, 9),
(826, 'Sungai Ruan', '', 0, NULL, NULL, NULL, 9),
(827, 'Tanah Rata', '', 0, NULL, NULL, NULL, 9),
(828, 'Temerloh', '', 0, NULL, NULL, NULL, 9),
(829, 'Teras', '', 0, NULL, NULL, NULL, 9),
(830, 'Triang', '', 0, NULL, NULL, NULL, 9),
(831, 'Beaufort', '', 0, NULL, NULL, NULL, 6),
(832, 'Beluran', '', 0, NULL, NULL, NULL, 6),
(833, 'Bongawan', '', 0, NULL, NULL, NULL, 6),
(834, 'Keningau', '', 0, NULL, NULL, NULL, 6),
(835, 'Kota Belud', '', 0, NULL, NULL, NULL, 6),
(836, 'Kota Kinabalu', '', 0, NULL, NULL, NULL, 6),
(837, 'Kota Kinabatangan', '', 0, NULL, NULL, NULL, 6),
(838, 'Kota Marudu', '', 0, NULL, NULL, NULL, 6),
(839, 'Kuala Penyu', '', 0, NULL, NULL, NULL, 6),
(840, 'Kudat', '', 0, NULL, NULL, NULL, 6),
(841, 'Kunak', '', 0, NULL, NULL, NULL, 6),
(842, 'Lahad Datu', '', 0, NULL, NULL, NULL, 6),
(843, 'Likas', '', 0, NULL, NULL, NULL, 6),
(844, 'Membakut', '', 0, NULL, NULL, NULL, 6),
(845, 'Menumbok', '', 0, NULL, NULL, NULL, 6),
(846, 'Nabawan', '', 0, NULL, NULL, NULL, 6),
(847, 'Pamol', '', 0, NULL, NULL, NULL, 6),
(848, 'Papar', '', 0, NULL, NULL, NULL, 6),
(849, 'Penampang', '', 0, NULL, NULL, NULL, 6),
(850, 'Pitas', '', 0, NULL, NULL, NULL, 6),
(851, 'Putatan', '', 0, NULL, NULL, NULL, 6),
(852, 'Ranau', '', 0, NULL, NULL, NULL, 6),
(853, 'Sandakan', '', 0, NULL, NULL, NULL, 6),
(854, 'Semporna', '', 0, NULL, NULL, NULL, 6),
(855, 'Sipitang', '', 0, NULL, NULL, NULL, 6),
(856, 'Tambunan', '', 0, NULL, NULL, NULL, 6),
(857, 'Tamparuli', '', 0, NULL, NULL, NULL, 6),
(858, 'Tawau', '', 0, NULL, NULL, NULL, 6),
(859, 'Tenom', '', 0, NULL, NULL, NULL, 6),
(860, 'Tuaran', '', 0, NULL, NULL, NULL, 6),
(861, 'Asajaya', '', 0, NULL, NULL, NULL, 12),
(862, 'Balingian', '', 0, NULL, NULL, NULL, 12),
(863, 'Baram', '', 0, NULL, NULL, NULL, 12),
(864, 'Bau', '', 0, NULL, NULL, NULL, 12),
(865, 'Bekenu', '', 0, NULL, NULL, NULL, 12),
(866, 'Belaga', '', 0, NULL, NULL, NULL, 12),
(867, 'Belawai', '', 0, NULL, NULL, NULL, 12),
(868, 'Betong', '', 0, NULL, NULL, NULL, 12),
(869, 'Bintagor', '', 0, NULL, NULL, NULL, 12),
(870, 'Bintulu', '', 0, NULL, NULL, NULL, 12),
(871, 'Dalat', '', 0, NULL, NULL, NULL, 12),
(872, 'Daro', '', 0, NULL, NULL, NULL, 12),
(873, 'Debak', '', 0, NULL, NULL, NULL, 12),
(874, 'Engkilili', '', 0, NULL, NULL, NULL, 12),
(875, 'Julau', '', 0, NULL, NULL, NULL, 12),
(876, 'Kabong', '', 0, NULL, NULL, NULL, 12),
(877, 'Kanowit', '', 0, NULL, NULL, NULL, 12),
(878, 'Kapit', '', 0, NULL, NULL, NULL, 12),
(879, 'Kota Samarahan', '', 0, NULL, NULL, NULL, 12),
(880, 'Kuching', '', 0, NULL, NULL, NULL, 12),
(881, 'Lawas', '', 0, NULL, NULL, NULL, 12),
(882, 'Limbang', '', 0, NULL, NULL, NULL, 12),
(883, 'Lingga', '', 0, NULL, NULL, NULL, 12),
(884, 'Long Lama', '', 0, NULL, NULL, NULL, 12),
(885, 'Lubok Antu', '', 0, NULL, NULL, NULL, 12),
(886, 'Lundu', '', 0, NULL, NULL, NULL, 12),
(887, 'Lutong', '', 0, NULL, NULL, NULL, 12),
(888, 'Maradong', '', 0, NULL, NULL, NULL, 12),
(889, 'Marudi', '', 0, NULL, NULL, NULL, 12),
(890, 'Matu', '', 0, NULL, NULL, NULL, 12),
(891, 'Miri', '', 0, NULL, NULL, NULL, 12),
(892, 'Mukah', '', 0, NULL, NULL, NULL, 12),
(893, 'Nanga Medamit', '', 0, NULL, NULL, NULL, 12),
(894, 'Niah', '', 0, NULL, NULL, NULL, 12),
(895, 'Pusa', '', 0, NULL, NULL, NULL, 12),
(896, 'Roban', '', 0, NULL, NULL, NULL, 12),
(897, 'Saratok', '', 0, NULL, NULL, NULL, 12),
(898, 'Sarikei', '', 0, NULL, NULL, NULL, 12),
(899, 'Sebauh', '', 0, NULL, NULL, NULL, 12),
(900, 'Sebuyau', '', 0, NULL, NULL, NULL, 12),
(901, 'Serian', '', 0, NULL, NULL, NULL, 12),
(902, 'Sibu', '', 0, NULL, NULL, NULL, 12),
(903, 'Simunjan', '', 0, NULL, NULL, NULL, 12),
(904, 'Song', '', 0, NULL, NULL, NULL, 12),
(905, 'Spaoh', '', 0, NULL, NULL, NULL, 12),
(906, 'Sri Aman', '', 0, NULL, NULL, NULL, 12),
(907, 'Sundar', '', 0, NULL, NULL, NULL, 12),
(908, 'Tanjung Kidurong', '', 0, NULL, NULL, NULL, 12),
(909, 'Tatau', '', 0, NULL, NULL, NULL, 12),
(910, 'Alor Setar', '', 0, NULL, NULL, NULL, 10),
(911, 'Ayer Hitam', '', 0, NULL, NULL, NULL, 10),
(912, 'Baling', '', 0, NULL, NULL, NULL, 10),
(913, 'Bandar Baharu', '', 0, NULL, NULL, NULL, 10),
(914, 'Bedong', '', 0, NULL, NULL, NULL, 10),
(915, 'Bukit Kayu Hitam', '', 0, NULL, NULL, NULL, 10),
(916, 'Guar Chempedak', '', 0, NULL, NULL, NULL, 10),
(917, 'Gurun', '', 0, NULL, NULL, NULL, 10),
(918, 'Jitra', '', 0, NULL, NULL, NULL, 10),
(919, 'Karangan', '', 0, NULL, NULL, NULL, 10),
(920, 'Kepala Batas', '', 0, NULL, NULL, NULL, 10),
(921, 'Kodiang', '', 0, NULL, NULL, NULL, 10),
(922, 'Kota Sarang Semut', '', 0, NULL, NULL, NULL, 10),
(923, 'Kuah', '', 0, NULL, NULL, NULL, 10),
(924, 'Kuala Kedah', '', 0, NULL, NULL, NULL, 10),
(925, 'Kuala Ketil', '', 0, NULL, NULL, NULL, 10),
(926, 'Kuala Muda', '', 0, NULL, NULL, NULL, 10),
(927, 'Kuala Nerang', '', 0, NULL, NULL, NULL, 10),
(928, 'Kubang Pasu', '', 0, NULL, NULL, NULL, 10),
(929, 'Kulim', '', 0, NULL, NULL, NULL, 10),
(930, 'Kupang', '', 0, NULL, NULL, NULL, 10),
(931, 'Langgar', '', 0, NULL, NULL, NULL, 10),
(932, 'Langkawi', '', 0, NULL, NULL, NULL, 10),
(933, 'Lunas', '', 0, NULL, NULL, NULL, 10),
(934, 'Merbok', '', 0, NULL, NULL, NULL, 10),
(935, 'Padang Matsirat', '', 0, NULL, NULL, NULL, 10),
(936, 'Padang Serai', '', 0, NULL, NULL, NULL, 10),
(937, 'Padang Terap', '', 0, NULL, NULL, NULL, 10),
(938, 'Pendang', '', 0, NULL, NULL, NULL, 10),
(939, 'Pinang Tunggal', '', 0, NULL, NULL, NULL, 10),
(940, 'Pokok Sena', '', 0, NULL, NULL, NULL, 10),
(941, 'Pulau Langkawi', '', 0, NULL, NULL, NULL, 10),
(942, 'Serdang', '', 0, NULL, NULL, NULL, 10),
(943, 'Sik', '', 0, NULL, NULL, NULL, 10),
(944, 'Simpang Empat', '', 0, NULL, NULL, NULL, 10),
(945, 'Sungai Lalang', '', 0, NULL, NULL, NULL, 10),
(946, 'Sungai Petani', '', 0, NULL, NULL, NULL, 10),
(947, 'Teloi Kiri', '', 0, NULL, NULL, NULL, 10),
(948, 'Temin', '', 0, NULL, NULL, NULL, 10),
(949, 'Univesity Utara', '', 0, NULL, NULL, NULL, 10),
(950, 'Yan', '', 0, NULL, NULL, NULL, 10),
(951, 'Putrajaya', '', 0, NULL, NULL, NULL, 36),
(952, 'Ayer Lanas', '', 0, NULL, NULL, NULL, 7),
(953, 'Bachok', '', 0, NULL, NULL, NULL, 7),
(954, 'Cherang Ruku', '', 0, NULL, NULL, NULL, 7),
(955, 'Dabong', '', 0, NULL, NULL, NULL, 7),
(956, 'Gua Musang', '', 0, NULL, NULL, NULL, 7),
(957, 'Jeli', '', 0, NULL, NULL, NULL, 7),
(958, 'Kem Desa Pahwalan', '', 0, NULL, NULL, NULL, 7),
(959, 'Kenali', '', 0, NULL, NULL, NULL, 7),
(960, 'Ketereh', '', 0, NULL, NULL, NULL, 7),
(961, 'Kota Bharu', '', 0, NULL, NULL, NULL, 7),
(962, 'Kuala Balah', '', 0, NULL, NULL, NULL, 7),
(963, 'Kuala Kerai', '', 0, NULL, NULL, NULL, 7),
(964, 'Machang', '', 0, NULL, NULL, NULL, 7),
(965, 'Melor', '', 0, NULL, NULL, NULL, 7),
(966, 'Padang Enggang', '', 0, NULL, NULL, NULL, 7),
(967, 'Pasir Mas', '', 0, NULL, NULL, NULL, 7),
(968, 'Pasir Puteh', '', 0, NULL, NULL, NULL, 7),
(969, 'Pengkalan Chepa', '', 0, NULL, NULL, NULL, 7),
(970, 'Pulai Chondong', '', 0, NULL, NULL, NULL, 7),
(971, 'Rantau Panjang', '', 0, NULL, NULL, NULL, 7),
(972, 'Selising', '', 0, NULL, NULL, NULL, 7),
(973, 'Tanah Merah', '', 0, NULL, NULL, NULL, 7),
(974, 'Tawang', '', 0, NULL, NULL, NULL, 7),
(975, 'Telok', '', 0, NULL, NULL, NULL, 7),
(976, 'Temangan', '', 0, NULL, NULL, NULL, 7),
(977, 'Tumpat', '', 0, NULL, NULL, NULL, 7),
(978, 'Wakaf Baru', '', 0, NULL, NULL, NULL, 7),
(979, 'Besut', '', 0, NULL, NULL, NULL, 11),
(980, 'Cabang Tiga', '', 0, NULL, NULL, NULL, 11),
(981, 'Dungun', '', 0, NULL, NULL, NULL, 11),
(982, 'Hulu Terengganu', '', 0, NULL, NULL, NULL, 11),
(983, 'Kemaman', '', 0, NULL, NULL, NULL, 11),
(984, 'Kerteh', '', 0, NULL, NULL, NULL, 11),
(985, 'Kijal', '', 0, NULL, NULL, NULL, 11),
(986, 'Kuala Ibai', '', 0, NULL, NULL, NULL, 11),
(987, 'Kuala Terengganu', '', 0, NULL, NULL, NULL, 11),
(988, 'Marang', '', 0, NULL, NULL, NULL, 11),
(989, 'Setiu', '', 0, NULL, NULL, NULL, 11),
(990, 'Arau', '', 0, NULL, NULL, NULL, 13),
(991, 'Kaki Bukit', '', 0, NULL, NULL, NULL, 13),
(992, 'Kangar', '', 0, NULL, NULL, NULL, 13),
(993, 'Kuala Perlis', '', 0, NULL, NULL, NULL, 13),
(994, 'Padang Besar', '', 0, NULL, NULL, NULL, 13),
(995, 'Pauh', '', 0, NULL, NULL, NULL, 13),
(996, 'Simpang Ampat', '', 0, NULL, NULL, NULL, 13),
(997, 'Titi Tinggi', '', 0, NULL, NULL, NULL, 13),
(998, 'Batu Gajah', '', 0, NULL, NULL, NULL, 5),
(999, 'Batu Kurau', '', 0, NULL, NULL, NULL, 5),
(1000, 'Behrang Stesen', '', 0, NULL, NULL, NULL, 5),
(1001, 'Beruas', '', 0, NULL, NULL, NULL, 5),
(1002, 'Bidor', '', 0, NULL, NULL, NULL, 5),
(1003, 'Bota', '', 0, NULL, NULL, NULL, 5),
(1004, 'Changkat Jering', '', 0, NULL, NULL, NULL, 5),
(1005, 'Changkat Keruing', '', 0, NULL, NULL, NULL, 5),
(1006, 'Chemor', '', 0, NULL, NULL, NULL, 5),
(1007, 'Chenderiang', '', 0, NULL, NULL, NULL, 5),
(1008, 'Chenderong Balai', '', 0, NULL, NULL, NULL, 5),
(1009, 'Chikus', '', 0, NULL, NULL, NULL, 5),
(1010, 'Enggor', '', 0, NULL, NULL, NULL, 5),
(1011, 'Gerik', '', 0, NULL, NULL, NULL, 5),
(1012, 'Gopeng', '', 0, NULL, NULL, NULL, 5),
(1013, 'Hutan Melintang', '', 0, NULL, NULL, NULL, 5),
(1014, 'Intan', '', 0, NULL, NULL, NULL, 5),
(1015, 'Ipoh', '', 0, NULL, NULL, NULL, 5),
(1016, 'Jeram', '', 0, NULL, NULL, NULL, 5),
(1017, 'Kampar', '', 0, NULL, NULL, NULL, 5),
(1018, 'Kampong Gajah', '', 0, NULL, NULL, NULL, 5),
(1019, 'Kampong Kepayang', '', 0, NULL, NULL, NULL, 5),
(1020, 'Kamunting', '', 0, NULL, NULL, NULL, 5),
(1021, 'Kuala Kangsar', '', 0, NULL, NULL, NULL, 5),
(1022, 'Kuala Kurau', '', 0, NULL, NULL, NULL, 5),
(1023, 'Kuala Sepetang', '', 0, NULL, NULL, NULL, 5),
(1024, 'Lahat', '', 0, NULL, NULL, NULL, 5),
(1025, 'Lambor Kanan', '', 0, NULL, NULL, NULL, 5),
(1026, 'Langkap', '', 0, NULL, NULL, NULL, 5),
(1027, 'Lenggong', '', 0, NULL, NULL, NULL, 5),
(1028, 'Lumut', '', 0, NULL, NULL, NULL, 5),
(1029, 'Malim Nawar', '', 0, NULL, NULL, NULL, 5),
(1030, 'Mambang Diawan', '', 0, NULL, NULL, NULL, 5),
(1031, 'Manong', '', 0, NULL, NULL, NULL, 5),
(1032, 'Matang', '', 0, NULL, NULL, NULL, 5),
(1033, 'Menglembu', '', 0, NULL, NULL, NULL, 5),
(1034, 'Padang Rengas', '', 0, NULL, NULL, NULL, 5),
(1035, 'Pangkor', '', 0, NULL, NULL, NULL, 5),
(1036, 'Pantai Remis', '', 0, NULL, NULL, NULL, 5),
(1037, 'Parit', '', 0, NULL, NULL, NULL, 5),
(1038, 'Parit Buntar', '', 0, NULL, NULL, NULL, 5),
(1039, 'Pengkalan Hulu', '', 0, NULL, NULL, NULL, 5),
(1040, 'Pusing', '', 0, NULL, NULL, NULL, 5),
(1041, 'Rantau Panjang', '', 0, NULL, NULL, NULL, 5),
(1042, 'Sauk', '', 0, NULL, NULL, NULL, 5),
(1043, 'Selama', '', 0, NULL, NULL, NULL, 5),
(1044, 'Selekoh', '', 0, NULL, NULL, NULL, 5),
(1045, 'Selinsing', '', 0, NULL, NULL, NULL, 5),
(1046, 'Semanggol', '', 0, NULL, NULL, NULL, 5),
(1047, 'Seri Iskandar', '', 0, NULL, NULL, NULL, 5),
(1048, 'Seri Manjong', '', 0, NULL, NULL, NULL, 5),
(1049, 'Simpang', '', 0, NULL, NULL, NULL, 5),
(1050, 'Simpang Pulai', '', 0, NULL, NULL, NULL, 5),
(1051, 'Sitiawan', '', 0, NULL, NULL, NULL, 5),
(1052, 'Slim River', '', 0, NULL, NULL, NULL, 5),
(1053, 'Sungai Siput', '', 0, NULL, NULL, NULL, 5),
(1054, 'Sungai Sumun', '', 0, NULL, NULL, NULL, 5),
(1055, 'Sungkai', '', 0, NULL, NULL, NULL, 5),
(1056, 'Taiping', '', 0, NULL, NULL, NULL, 5),
(1057, 'Tambun', '', 0, NULL, NULL, NULL, 5),
(1058, 'Tanjong Piandang', '', 0, NULL, NULL, NULL, 5),
(1059, 'Tanjong Rambutan', '', 0, NULL, NULL, NULL, 5),
(1060, 'Tanjong Tualang', '', 0, NULL, NULL, NULL, 5),
(1061, 'Tanjung Malim', '', 0, NULL, NULL, NULL, 5),
(1062, 'Tapah', '', 0, NULL, NULL, NULL, 5),
(1063, 'Teluk Intan', '', 0, NULL, NULL, NULL, 5),
(1064, 'Temoh', '', 0, NULL, NULL, NULL, 5),
(1065, 'TLDM Lumut', '', 0, NULL, NULL, NULL, 5),
(1066, 'Trolak', '', 0, NULL, NULL, NULL, 5),
(1067, 'Trong', '', 0, NULL, NULL, NULL, 5),
(1068, 'Tronoh', '', 0, NULL, NULL, NULL, 5),
(1069, 'Ulu Bernam', '', 0, NULL, NULL, NULL, 5),
(1070, 'Ulu Kinta', '', 0, NULL, NULL, NULL, 5),
(1071, 'Bandar Puteri Klang\n', '', 0, NULL, NULL, NULL, 14);

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

--
-- Table structure for table `couriers`
--

CREATE TABLE `couriers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `homepage` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `picture` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `couriers`
--

INSERT INTO `couriers` (`id`, `name`, `code`, `phone`, `homepage`, `type`, `picture`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Poslaju', 'poslaju', '+603 7626 1900', 'https://www.pos.com.my', '1', NULL, '1', '2021-11-08 02:46:14', '2021-11-08 02:46:14', NULL),
(2, 'Ninja Van Malaysia', 'ninjavan-my', '+60 111 7225600', 'https://www.ninjavan.co/en-my', '1', NULL, '1', '2021-11-08 02:46:14', '2021-11-08 02:46:14', NULL),
(3, 'JT Express MY', 'jtexpress-my', '1300-80-9000', 'https://www.jtexpress.my', '1', NULL, '1', '2021-11-08 02:46:14', '2021-11-08 02:46:14', NULL),
(4, 'EasyParcel', 'easyparcel', NULL, 'https://easyparcel.com/my/en/', '1', NULL, '1', '2021-11-08 02:46:14', '2021-11-08 02:46:14', NULL),
(5, 'DHL', 'dhl', '+1 800-225-5345', 'http://www.dhl.com/', '1', NULL, '1', '2021-11-08 02:46:14', '2021-11-08 02:46:14', NULL);

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

--
-- Table structure for table `customer_luck_draw_datas`
--

CREATE TABLE `customer_luck_draw_datas` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `entered_happy_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remark` longtext COLLATE utf8mb4_unicode_ci,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `luck_draw_data_id` bigint(20) UNSIGNED DEFAULT NULL,
  `customer_id` bigint(20) UNSIGNED NOT NULL,
  `picture` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reject_remark` longtext COLLATE utf8mb4_unicode_ci,
  `is_duplicate` tinyint(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `customer_luck_draw_datas`
--

INSERT INTO `customer_luck_draw_datas` (`id`, `entered_happy_code`, `remark`, `status`, `created_at`, `updated_at`, `deleted_at`, `luck_draw_data_id`, `customer_id`, `picture`, `reject_remark`, `is_duplicate`) VALUES
(1, 'HHH', 'Rejected', '2', '2021-10-26 14:05:31', '2021-11-05 12:41:53', NULL, 8, 1, NULL, NULL, 0),
(2, '1234', NULL, '0', '2021-10-26 15:26:22', '2021-10-26 15:26:22', NULL, NULL, 2, NULL, NULL, 0),
(3, 'BBB', NULL, '0', '2021-10-27 13:11:40', '2021-10-27 13:11:40', NULL, 2, 2, NULL, NULL, 0),
(4, '1345444', NULL, '0', '2021-10-27 13:23:38', '2021-10-27 13:23:38', NULL, NULL, 2, NULL, NULL, 0),
(5, '131513111', NULL, '0', '2021-10-29 04:32:11', '2021-10-29 04:32:11', NULL, NULL, 2, NULL, NULL, 0),
(6, '13131514533', NULL, '0', '2021-10-29 04:44:33', '2021-10-29 04:44:33', NULL, NULL, 2, NULL, NULL, 0),
(7, '134142413413', NULL, '0', '2021-10-29 04:46:20', '2021-10-29 04:46:20', NULL, NULL, 2, NULL, NULL, 0),
(8, '14232341', NULL, '0', '2021-10-29 04:59:00', '2021-10-29 04:59:00', NULL, NULL, 2, NULL, NULL, 0),
(9, '134135432231111', NULL, '0', '2021-10-29 05:08:21', '2021-10-29 05:08:21', NULL, NULL, 2, NULL, NULL, 0),
(10, '132311313454', NULL, '0', '2021-10-29 10:36:09', '2021-10-29 10:36:09', NULL, NULL, 2, '20211029_183609_HC_132311313454.jpg', NULL, 0),
(11, '14411', 'Invalid Happy Code', '0', '2021-11-05 10:05:53', '2021-11-05 10:05:53', NULL, NULL, 2, '20211105_180553_HC_14411.jpg', NULL, 0),
(12, 'GGG', 'Pending Verification', '0', '2021-11-05 10:07:00', '2021-11-05 10:07:00', NULL, 7, 2, '20211105_180700_HC_GGG.jpg', NULL, 0),
(13, '1341', 'Invalid Happy Code', '0', '2021-11-05 10:08:27', '2021-11-05 10:08:27', NULL, NULL, 2, '20211105_180827_HC_1341.jpg', NULL, 0),
(14, '131314', 'Approved', '1', '2021-11-05 10:09:33', '2021-11-05 12:48:29', NULL, 10, 2, '20211105_180933_HC_131314.jpg', NULL, 0),
(15, '131314', 'The entered happy code (131314) is existed and entered by kristy (0177569933)', '0', '2021-11-05 12:59:13', '2021-11-05 12:59:13', NULL, NULL, 1, '20211105_205913_HC_131314.jpg', NULL, 0),
(16, '131314', 'The entered happy code (131314) is existed and entered by User ()', '0', '2021-11-05 13:01:44', '2021-11-05 13:01:44', NULL, NULL, 2, '20211105_210144_HC_131314.jpg', NULL, 0),
(17, '191919', 'Pending Verification', '0', '2021-11-08 09:50:06', '2021-11-08 09:50:06', NULL, 11, 2, '20211108_175006_HC_191919.jpg', NULL, 0),
(18, '198219', 'Pending Verification', '0', '2021-11-08 09:52:14', '2021-11-08 09:52:15', NULL, 13, 2, '20211108_175214_HC_198219.jpg', NULL, 0),
(19, '191922', 'You have won Dual Function Freezer', '1', '2021-11-08 09:53:01', '2021-11-11 04:44:00', NULL, 12, 2, '20211108_175303_HC_191922.jpg', NULL, 0),
(20, '191919', 'The entered happy code (191919) is existed and entered by kristy (0177569933)', '1', '2021-11-08 09:54:01', '2021-11-08 12:51:07', NULL, NULL, 1, '20211108_175401_HC_191919.jpg', NULL, 0),
(21, '919099', 'You have won Lumos', '0', '2021-11-08 12:53:07', '2021-11-08 12:54:55', NULL, 14, 2, '20211108_205307_HC_919099.jpg', NULL, 0),
(22, '13133', 'Invalid Happy Code', '0', '2021-11-12 10:16:04', '2021-11-12 10:16:05', NULL, NULL, 2, '20211112_181604_HC_13133.jpg', NULL, 0),
(23, '14121', 'Invalid Happy Code', '0', '2021-11-15 08:35:24', '2021-11-15 08:35:25', NULL, NULL, 2, '20211115_163524_HC_14121.jpg', NULL, 0),
(24, '11221', 'Invalid Happy Code', '0', '2021-11-15 08:36:11', '2021-11-15 08:36:12', NULL, NULL, 2, '20211115_163612_HC_11221.jpg', NULL, 0),
(25, '13121', 'Invalid Happy Code', '0', '2021-11-15 09:02:45', '2021-11-15 09:02:46', NULL, NULL, 2, '20211115_170245_HC_13121.jpg', NULL, 0),
(26, '12123', 'Invalid Happy Code', '0', '2021-11-17 02:03:50', '2021-11-17 02:03:50', NULL, NULL, 2, '20211117_100350_HC_12123.jpg', NULL, 0),
(27, '19190', NULL, '0', '2021-11-17 02:06:28', '2021-11-17 02:06:28', NULL, 17, 2, '20211117_100628_HC_19190.jpg', NULL, 0),
(28, '17819', NULL, '0', '2021-11-17 02:09:39', '2021-11-17 02:09:39', NULL, 16, 2, '20211117_100939_HC_17819.jpg', NULL, 0),
(29, '99714', NULL, '0', '2021-11-17 02:13:55', '2021-11-17 02:13:55', NULL, 15, 2, '20211117_101355_HC_99714.jpg', NULL, 0),
(30, '68629', NULL, '0', '2021-11-17 02:18:56', '2021-11-17 02:18:56', NULL, 21, 2, '20211117_101856_HC_68629.jpg', NULL, 0),
(31, '61681', NULL, '0', '2021-11-17 02:52:56', '2021-11-17 02:52:56', NULL, 20, 2, '20211117_105256_HC_61681.jpg', NULL, 0),
(32, '61681', 'The entered happy code (61681) is existed.', '0', '2021-11-17 03:02:17', '2021-11-17 03:02:18', NULL, NULL, 1, '20211117_110217_HC_61681.jpg', NULL, 1);

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

--
-- Table structure for table `customer_role`
--

CREATE TABLE `customer_role` (
  `customer_id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `customer_role`
--

INSERT INTO `customer_role` (`customer_id`, `role_id`) VALUES
(1, 3),
(2, 3),
(3, 4);

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

--
-- Table structure for table `employee_role`
--

CREATE TABLE `employee_role` (
  `employee_id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `employee_role`
--

INSERT INTO `employee_role` (`employee_id`, `role_id`) VALUES
(1, 1),
(2, 3);

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

--
-- Table structure for table `lucky_draw_items`
--

CREATE TABLE `lucky_draw_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `video_link` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `picture_path` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `display_picture_path` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `lucky_draw_items`
--

INSERT INTO `lucky_draw_items` (`id`, `name`, `video_link`, `description`, `status`, `created_at`, `updated_at`, `deleted_at`, `picture_path`, `display_picture_path`) VALUES
(1, 'Lumos', NULL, NULL, '1', '2021-10-19 06:20:48', '2021-11-08 09:50:58', NULL, 'luckyDrawItems/picture/Lumos.jpg', 'luckyDrawItems/displayPicture/Lumos.jpg'),
(2, 'Apple Ipad', NULL, NULL, '1', '2021-10-19 06:21:01', '2021-10-19 06:21:01', NULL, NULL, NULL),
(3, 'Dual Function Freezer', NULL, NULL, '1', '2021-10-24 12:43:28', '2021-11-08 09:50:40', NULL, 'luckyDrawItems/picture/Freezer.jpg', 'luckyDrawItems/displayPicture/Freezer.jpg'),
(4, 'Air Fryer', NULL, NULL, '1', '2021-10-24 12:43:42', '2021-10-24 12:43:42', NULL, NULL, NULL),
(5, '1 Year Happy Grains Supply', NULL, NULL, '1', '2021-10-24 12:44:04', '2021-10-24 12:44:04', NULL, NULL, NULL),
(6, 'Be Happy', NULL, NULL, '1', '2021-10-24 12:44:19', '2021-10-24 12:44:19', NULL, NULL, NULL),
(7, 'Be Powerful', NULL, NULL, '1', '2021-10-24 12:44:31', '2021-11-05 09:42:19', NULL, 'luckyDrawItems/picture/BePowerful.jpg', 'luckyDrawItems/displayPicture/BePowerful.jpg'),
(8, 'Be Surprised', NULL, NULL, '1', '2021-10-24 12:44:43', '2021-11-05 09:41:55', NULL, 'luckyDrawItems/picture/BeSurprised.jpg', 'luckyDrawItems/displayPicture/BeSurprised.jpg'),
(9, 'Be Lucky', NULL, NULL, '1', '2021-10-24 12:44:53', '2021-11-05 09:41:23', NULL, 'luckyDrawItems/picture/BeLucky.jpg', 'luckyDrawItems/displayPicture/BeLucky.jpg'),
(10, '1 x Wireless Hand Mixer', NULL, NULL, '1', '2021-11-11 08:45:47', '2021-11-11 08:45:47', NULL, 'luckyDrawItems/picture/P18_WirelessHandMixer.jpg', 'luckyDrawItems/displayPicture/P18_WirelessHandMixer.jpg');

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

--
-- Table structure for table `luck_draw_datas`
--

CREATE TABLE `luck_draw_datas` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `happy_code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_used` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `lucky_draw_item_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `luck_draw_datas`
--

INSERT INTO `luck_draw_datas` (`id`, `happy_code`, `is_used`, `status`, `created_at`, `updated_at`, `deleted_at`, `lucky_draw_item_id`) VALUES
(1, 'AAA', '0', '0', '2021-10-19 06:21:16', '2021-10-19 06:21:16', NULL, 2),
(2, 'BBB', '1', '0', '2021-10-19 06:21:16', '2021-10-27 13:11:40', NULL, 2),
(3, 'CCC', '0', '0', '2021-10-19 06:21:16', '2021-10-19 06:21:16', NULL, 2),
(4, 'DDD', '0', '1', '2021-10-19 06:21:16', '2021-10-19 06:21:59', NULL, 2),
(5, 'EEE', '0', '1', '2021-10-19 06:21:16', '2021-10-19 06:21:59', NULL, 2),
(6, 'FFF', '0', '0', '2021-10-19 06:21:40', '2021-10-19 06:21:40', NULL, 1),
(7, 'GGG', '1', '1', '2021-10-19 06:21:40', '2021-11-05 10:07:00', NULL, 1),
(8, 'HHH', '1', '1', '2021-10-19 06:21:40', '2021-10-26 14:05:31', NULL, 1),
(9, '114441331', '0', '1', '2021-11-05 09:44:04', '2021-11-05 09:44:16', NULL, 8),
(10, '131314', '1', '1', '2021-11-05 10:09:12', '2021-11-05 10:09:33', NULL, 1),
(11, '191919', '1', '1', '2021-11-08 09:49:16', '2021-11-08 09:50:06', NULL, 3),
(12, '191922', '1', '1', '2021-11-08 09:49:16', '2021-11-08 09:52:59', NULL, 3),
(13, '198219', '1', '1', '2021-11-08 09:51:15', '2021-11-08 09:52:14', NULL, 1),
(14, '919099', '1', '1', '2021-11-08 12:50:41', '2021-11-08 12:53:07', NULL, 1),
(15, '99714', '1', '1', '2021-11-17 02:06:03', '2021-11-17 02:13:55', NULL, 3),
(16, '17819', '1', '1', '2021-11-17 02:06:03', '2021-11-17 02:09:39', NULL, 1),
(17, '19190', '1', '1', '2021-11-17 02:06:03', '2021-11-17 02:06:28', NULL, 2),
(18, '88798', '0', '1', '2021-11-17 02:18:34', '2021-11-17 02:18:34', NULL, 1),
(19, '91778', '0', '1', '2021-11-17 02:18:34', '2021-11-17 02:18:34', NULL, 1),
(20, '61681', '1', '1', '2021-11-17 02:18:34', '2021-11-17 02:52:55', NULL, 1),
(21, '68629', '1', '1', '2021-11-17 02:18:34', '2021-11-17 02:18:56', NULL, 1);

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

--
-- Table structure for table `media`
--

CREATE TABLE `media` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL,
  `collection_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mime_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `disk` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `size` int(10) UNSIGNED NOT NULL,
  `manipulations` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `custom_properties` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `responsive_images` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `order_column` int(10) UNSIGNED 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 `media`
--

INSERT INTO `media` (`id`, `model_type`, `model_id`, `collection_name`, `name`, `file_name`, `mime_type`, `disk`, `size`, `manipulations`, `custom_properties`, `responsive_images`, `order_column`, `created_at`, `updated_at`) VALUES
(3, 'App\\Models\\LuckyDrawItem', 2, 'picture', '61755652463f2_AppleiPad', '61755652463f2_AppleiPad.jpg', 'image/jpeg', 'public', 143852, '[]', '{\"generated_conversions\":{\"thumb\":true,\"preview\":true}}', '[]', 2, '2021-10-24 12:49:23', '2021-10-24 12:49:24'),
(5, 'App\\Models\\LuckyDrawItem', 3, 'picture', '6175566840518_Freezer', '6175566840518_Freezer.jpg', 'image/jpeg', 'public', 144492, '[]', '{\"generated_conversions\":{\"thumb\":true,\"preview\":true}}', '[]', 4, '2021-10-24 12:49:45', '2021-10-24 12:49:46'),
(6, 'App\\Models\\LuckyDrawItem', 5, 'picture', '6175566f0320b_1yearHappyGrains', '6175566f0320b_1yearHappyGrains.jpg', 'image/jpeg', 'public', 169459, '[]', '{\"generated_conversions\":{\"thumb\":true,\"preview\":true}}', '[]', 5, '2021-10-24 12:49:52', '2021-10-24 12:49:52'),
(7, 'App\\Models\\LuckyDrawItem', 6, 'picture', '617556756ce9d_BeHappy', '617556756ce9d_BeHappy.jpg', 'image/jpeg', 'public', 138755, '[]', '{\"generated_conversions\":{\"thumb\":true,\"preview\":true}}', '[]', 6, '2021-10-24 12:49:59', '2021-10-24 12:50:00'),
(8, 'App\\Models\\LuckyDrawItem', 4, 'picture', '6175567cbd592_AirFryer', '6175567cbd592_AirFryer.jpg', 'image/jpeg', 'public', 139883, '[]', '{\"generated_conversions\":{\"thumb\":true,\"preview\":true}}', '[]', 7, '2021-10-24 12:50:06', '2021-10-24 12:50:07'),
(9, 'App\\Models\\LuckyDrawItem', 7, 'picture', '61755683c2cbc_BePowerful', '61755683c2cbc_BePowerful.jpg', 'image/jpeg', 'public', 173834, '[]', '{\"generated_conversions\":{\"thumb\":true,\"preview\":true}}', '[]', 8, '2021-10-24 12:50:12', '2021-10-24 12:50:13'),
(10, 'App\\Models\\LuckyDrawItem', 8, 'picture', '6175568a17e4d_BeSurprised', '6175568a17e4d_BeSurprised.jpg', 'image/jpeg', 'public', 143499, '[]', '{\"generated_conversions\":{\"thumb\":true,\"preview\":true}}', '[]', 9, '2021-10-24 12:50:19', '2021-10-24 12:50:19'),
(12, 'App\\Models\\CustomerLuckDrawData', 1, 'upload_photo', '20211026_220531_HC_HHH', '20211026_220531_HC_HHH.png', 'image/jpeg', 'customerPhoto', 98174, '[]', '{\"generated_conversions\":{\"thumb\":true,\"preview\":true}}', '[]', 11, '2021-10-26 14:05:31', '2021-10-26 14:05:31'),
(13, 'App\\Models\\CustomerLuckDrawData', 2, 'upload_photo', '20211026_232622_HC_1234', '20211026_232622_HC_1234.jpg', 'image/jpeg', 'customerPhoto', 7737, '[]', '{\"generated_conversions\":{\"thumb\":true,\"preview\":true}}', '[]', 12, '2021-10-26 15:26:22', '2021-10-26 15:26:23'),
(14, 'App\\Models\\CustomerLuckDrawData', 3, 'upload_photo', '20211027_211140_HC_BBB', '20211027_211140_HC_BBB.jpg', 'image/jpeg', 'customerPhoto', 7737, '[]', '{\"generated_conversions\":{\"thumb\":true,\"preview\":true}}', '[]', 13, '2021-10-27 13:11:40', '2021-10-27 13:11:41'),
(15, 'App\\Models\\CustomerLuckDrawData', 4, 'upload_photo', '20211027_212338_HC_1345444', '20211027_212338_HC_1345444.jpg', 'image/jpeg', 'customerPhoto', 7737, '[]', '{\"generated_conversions\":{\"thumb\":true,\"preview\":true}}', '[]', 14, '2021-10-27 13:23:38', '2021-10-27 13:23:39'),
(16, 'App\\Models\\CustomerLuckDrawData', 5, 'upload_photo', '20211029_123212_HC_131513111', '20211029_123212_HC_131513111.jpg', 'image/jpeg', 'customerPhoto', 7737, '[]', '{\"generated_conversions\":{\"thumb\":true,\"preview\":true}}', '[]', 15, '2021-10-29 04:32:12', '2021-10-29 04:32:12'),
(17, 'App\\Models\\CustomerLuckDrawData', 6, 'upload_photo', '20211029_124433_HC_13131514533', '20211029_124433_HC_13131514533.jpg', 'image/jpeg', 'customerPhoto', 7737, '[]', '{\"generated_conversions\":{\"thumb\":true,\"preview\":true}}', '[]', 16, '2021-10-29 04:44:33', '2021-10-29 04:44:34'),
(18, 'App\\Models\\CustomerLuckDrawData', 7, 'upload_photo', '20211029_124620_HC_134142413413', '20211029_124620_HC_134142413413.jpg', 'image/jpeg', 'customerPhoto', 7737, '[]', '{\"generated_conversions\":{\"thumb\":true,\"preview\":true}}', '[]', 17, '2021-10-29 04:46:20', '2021-10-29 04:46:21'),
(19, 'App\\Models\\CustomerLuckDrawData', 8, 'upload_photo', '20211029_125900_HC_14232341', '20211029_125900_HC_14232341.png', 'image/jpeg', 'customerPhoto', 408925, '[]', '{\"generated_conversions\":{\"thumb\":true,\"preview\":true}}', '[]', 18, '2021-10-29 04:59:01', '2021-10-29 04:59:03'),
(20, 'App\\Models\\CustomerLuckDrawData', 9, 'upload_photo', '20211029_130822_HC_134135432231111', '20211029_130822_HC_134135432231111.jpeg', 'image/jpeg', 'customerPhoto', 107202, '[]', '{\"generated_conversions\":{\"thumb\":true,\"preview\":true}}', '[]', 19, '2021-10-29 05:08:22', '2021-10-29 05:08:22'),
(21, 'App\\Models\\LuckyDrawItem', 9, 'picture', '617bfa7a0db6c_BeLucky', '617bfa7a0db6c_BeLucky.jpg', 'image/jpeg', 'public', 139582, '[]', '{\"generated_conversions\":{\"thumb\":true,\"preview\":true}}', '[]', 20, '2021-10-29 13:43:24', '2021-10-29 13:43:25'),
(22, 'App\\Models\\LuckyDrawItem', 1, 'picture', '617bfaa5ada70_Lumos', '617bfaa5ada70_Lumos.jpg', 'image/jpeg', 'public', 144988, '[]', '{\"generated_conversions\":{\"thumb\":true,\"preview\":true}}', '[]', 21, '2021-10-29 13:44:08', '2021-10-29 13:44:09'),
(23, 'App\\Models\\LuckyDrawItem', 1, 'display_picture', '617bfabc9a223_Lumos', '617bfabc9a223_Lumos.jpg', 'image/jpeg', 'public', 144988, '[]', '{\"generated_conversions\":{\"thumb\":true,\"preview\":true}}', '[]', 22, '2021-10-29 13:44:30', '2021-10-29 13:44:31');

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `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 `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_100000_create_password_resets_table', 1),
(2, '2021_10_13_000001_create_media_table', 1),
(3, '2021_10_13_000002_create_audit_logs_table', 1),
(4, '2021_10_13_000003_create_states_table', 1),
(5, '2021_10_13_000004_create_reject_customer_luck_draw_datas_table', 1),
(6, '2021_10_13_000005_create_shipping_lucky_draws_table', 1),
(7, '2021_10_13_000006_create_customer_luck_draw_datas_table', 1),
(8, '2021_10_13_000007_create_luck_draw_datas_table', 1),
(9, '2021_10_13_000008_create_shipping_clerks_table', 1),
(10, '2021_10_13_000009_create_surveys_table', 1),
(11, '2021_10_13_000010_create_employees_table', 1),
(12, '2021_10_13_000011_create_lucky_draw_items_table', 1),
(13, '2021_10_13_000012_create_cities_table', 1),
(14, '2021_10_13_000013_create_customers_table', 1),
(15, '2021_10_13_000014_create_users_table', 1),
(16, '2021_10_13_000015_create_permissions_table', 1),
(17, '2021_10_13_000016_create_products_table', 1),
(18, '2021_10_13_000017_create_product_tags_table', 1),
(19, '2021_10_13_000018_create_product_categories_table', 1),
(20, '2021_10_13_000019_create_roles_table', 1),
(21, '2021_10_13_000020_create_product_product_tag_pivot_table', 1),
(22, '2021_10_13_000021_create_customer_role_pivot_table', 1),
(23, '2021_10_13_000022_create_employee_role_pivot_table', 1),
(24, '2021_10_13_000023_create_product_product_category_pivot_table', 1),
(25, '2021_10_13_000024_create_role_user_pivot_table', 1),
(26, '2021_10_13_000025_create_role_shipping_clerk_pivot_table', 1),
(27, '2021_10_13_000026_create_permission_role_pivot_table', 1),
(28, '2021_10_13_000027_add_relationship_fields_to_shipping_lucky_draws_table', 1),
(29, '2021_10_13_000028_add_relationship_fields_to_customer_luck_draw_datas_table', 1),
(30, '2021_10_13_000029_add_relationship_fields_to_surveys_table', 1),
(31, '2021_10_13_000030_add_relationship_fields_to_luck_draw_datas_table', 1),
(32, '2021_10_13_000031_add_relationship_fields_to_shipping_clerks_table', 1),
(33, '2021_10_13_000032_add_relationship_fields_to_users_table', 1),
(34, '2021_10_13_000033_add_relationship_fields_to_employees_table', 1),
(35, '2021_10_13_000034_add_relationship_fields_to_customers_table', 1),
(36, '2021_10_13_000035_add_relationship_fields_to_cities_table', 1),
(37, '2021_10_13_000036_add_relationship_fields_to_reject_customer_luck_draw_datas_table', 1);

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

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` (`id`, `title`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'user_management_access', NULL, NULL, NULL),
(2, 'permission_create', NULL, NULL, NULL),
(3, 'permission_edit', NULL, NULL, NULL),
(4, 'permission_show', NULL, NULL, NULL),
(5, 'permission_delete', NULL, NULL, NULL),
(6, 'permission_access', NULL, NULL, NULL),
(7, 'role_create', NULL, NULL, NULL),
(8, 'role_edit', NULL, NULL, NULL),
(9, 'role_show', NULL, NULL, NULL),
(10, 'role_delete', NULL, NULL, NULL),
(11, 'role_access', NULL, NULL, NULL),
(12, 'user_create', NULL, NULL, NULL),
(13, 'user_edit', NULL, NULL, NULL),
(14, 'user_show', NULL, NULL, NULL),
(15, 'user_delete', NULL, NULL, NULL),
(16, 'user_access', NULL, NULL, NULL),
(17, 'audit_log_show', NULL, NULL, NULL),
(18, 'audit_log_access', NULL, NULL, NULL),
(19, 'product_management_access', NULL, NULL, NULL),
(20, 'product_category_create', NULL, NULL, NULL),
(21, 'product_category_edit', NULL, NULL, NULL),
(22, 'product_category_show', NULL, NULL, NULL),
(23, 'product_category_delete', NULL, NULL, NULL),
(24, 'product_category_access', NULL, NULL, NULL),
(25, 'product_tag_create', NULL, NULL, NULL),
(26, 'product_tag_edit', NULL, NULL, NULL),
(27, 'product_tag_show', NULL, NULL, NULL),
(28, 'product_tag_delete', NULL, NULL, NULL),
(29, 'product_tag_access', NULL, NULL, NULL),
(30, 'product_create', NULL, NULL, NULL),
(31, 'product_edit', NULL, NULL, NULL),
(32, 'product_show', NULL, NULL, NULL),
(33, 'product_delete', NULL, NULL, NULL),
(34, 'product_access', NULL, NULL, NULL),
(35, 'master_management_access', NULL, NULL, NULL),
(36, 'state_create', NULL, NULL, NULL),
(37, 'state_edit', NULL, NULL, NULL),
(38, 'state_show', NULL, NULL, NULL),
(39, 'state_delete', NULL, NULL, NULL),
(40, 'state_access', NULL, NULL, NULL),
(41, 'city_create', NULL, NULL, NULL),
(42, 'city_edit', NULL, NULL, NULL),
(43, 'city_show', NULL, NULL, NULL),
(44, 'city_delete', NULL, NULL, NULL),
(45, 'city_access', NULL, NULL, NULL),
(46, 'lucky_draw_management_access', NULL, NULL, NULL),
(47, 'lucky_draw_item_create', NULL, NULL, NULL),
(48, 'lucky_draw_item_edit', NULL, NULL, NULL),
(49, 'lucky_draw_item_show', NULL, NULL, NULL),
(50, 'lucky_draw_item_delete', NULL, NULL, NULL),
(51, 'lucky_draw_item_access', NULL, NULL, NULL),
(52, 'customer_create', NULL, NULL, NULL),
(53, 'customer_edit', NULL, NULL, NULL),
(54, 'customer_show', NULL, NULL, NULL),
(55, 'customer_delete', NULL, NULL, NULL),
(56, 'customer_access', NULL, NULL, NULL),
(57, 'employee_create', NULL, NULL, NULL),
(58, 'employee_edit', NULL, NULL, NULL),
(59, 'employee_show', NULL, NULL, NULL),
(60, 'employee_delete', NULL, NULL, NULL),
(61, 'employee_access', NULL, NULL, NULL),
(62, 'survey_management_access', NULL, NULL, NULL),
(63, 'survey_create', NULL, NULL, NULL),
(64, 'survey_edit', NULL, NULL, NULL),
(65, 'survey_show', NULL, NULL, NULL),
(66, 'survey_delete', NULL, NULL, NULL),
(67, 'survey_access', NULL, NULL, NULL),
(68, 'shipping_clerk_create', NULL, NULL, NULL),
(69, 'shipping_clerk_edit', NULL, NULL, NULL),
(70, 'shipping_clerk_show', NULL, NULL, NULL),
(71, 'shipping_clerk_delete', NULL, NULL, NULL),
(72, 'shipping_clerk_access', NULL, NULL, NULL),
(73, 'luck_draw_data_create', NULL, NULL, NULL),
(74, 'luck_draw_data_edit', NULL, NULL, NULL),
(75, 'luck_draw_data_show', NULL, NULL, NULL),
(76, 'luck_draw_data_delete', NULL, NULL, NULL),
(77, 'luck_draw_data_access', NULL, NULL, NULL),
(78, 'customer_luck_draw_data_create', NULL, NULL, NULL),
(79, 'customer_luck_draw_data_edit', NULL, NULL, NULL),
(80, 'customer_luck_draw_data_show', NULL, NULL, NULL),
(81, 'customer_luck_draw_data_delete', NULL, NULL, NULL),
(82, 'customer_luck_draw_data_approve', NULL, NULL, NULL),
(83, 'customer_luck_draw_data_reject', NULL, NULL, NULL),
(84, 'customer_luck_draw_data_access', NULL, NULL, NULL),
(85, 'shipping_management_access', NULL, NULL, NULL),
(86, 'shipping_lucky_draw_create', NULL, NULL, NULL),
(87, 'shipping_lucky_draw_edit', NULL, NULL, NULL),
(88, 'shipping_lucky_draw_update', NULL, NULL, NULL),
(89, 'shipping_lucky_draw_show', NULL, NULL, NULL),
(90, 'shipping_lucky_draw_delete', NULL, NULL, NULL),
(91, 'shipping_lucky_draw_access', NULL, NULL, NULL),
(92, 'shipped_lucky_draw_create', NULL, NULL, NULL),
(93, 'shipped_lucky_draw_edit', NULL, NULL, NULL),
(94, 'shipped_lucky_draw_update', NULL, NULL, NULL),
(95, 'shipped_lucky_draw_show', NULL, NULL, NULL),
(96, 'shipped_lucky_draw_delete', NULL, NULL, NULL),
(97, 'shipped_lucky_draw_access', NULL, NULL, NULL),
(98, 'reject_customer_luck_draw_data_create', NULL, NULL, NULL),
(99, 'reject_customer_luck_draw_data_edit', NULL, NULL, NULL),
(100, 'reject_customer_luck_draw_data_show', NULL, NULL, NULL),
(101, 'reject_customer_luck_draw_data_delete', NULL, NULL, NULL),
(102, 'reject_customer_luck_draw_data_access', NULL, NULL, NULL),
(103, 'profile_password_edit', NULL, NULL, NULL),
(104, 'courier_create', NULL, NULL, NULL),
(105, 'courier_edit', NULL, NULL, NULL),
(106, 'courier_show', NULL, NULL, NULL),
(107, 'courier_delete', NULL, NULL, NULL),
(108, 'courier_access', NULL, NULL, NULL);

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

--
-- Table structure for table `permission_role`
--

CREATE TABLE `permission_role` (
  `role_id` bigint(20) UNSIGNED NOT NULL,
  `permission_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permission_role`
--

INSERT INTO `permission_role` (`role_id`, `permission_id`) VALUES
(1, 1),
(1, 2),
(1, 3),
(1, 4),
(1, 5),
(1, 6),
(1, 7),
(1, 8),
(1, 9),
(1, 10),
(1, 11),
(1, 17),
(1, 18),
(1, 19),
(1, 20),
(1, 21),
(1, 22),
(1, 23),
(1, 24),
(1, 25),
(1, 26),
(1, 27),
(1, 28),
(1, 29),
(1, 30),
(1, 31),
(1, 32),
(1, 33),
(1, 34),
(1, 35),
(1, 36),
(1, 37),
(1, 38),
(1, 39),
(1, 40),
(1, 41),
(1, 42),
(1, 43),
(1, 44),
(1, 45),
(1, 46),
(1, 47),
(1, 48),
(1, 49),
(1, 50),
(1, 51),
(1, 52),
(1, 53),
(1, 54),
(1, 55),
(1, 56),
(1, 57),
(1, 58),
(1, 59),
(1, 60),
(1, 61),
(1, 62),
(1, 63),
(1, 64),
(1, 65),
(1, 66),
(1, 67),
(1, 68),
(1, 69),
(1, 70),
(1, 71),
(1, 72),
(1, 73),
(1, 74),
(1, 75),
(1, 76),
(1, 77),
(1, 78),
(1, 79),
(1, 80),
(1, 81),
(1, 82),
(1, 83),
(1, 84),
(1, 85),
(1, 86),
(1, 87),
(1, 88),
(1, 89),
(1, 90),
(1, 91),
(1, 92),
(1, 93),
(1, 94),
(1, 95),
(1, 96),
(1, 97),
(1, 98),
(1, 99),
(1, 100),
(1, 101),
(1, 102),
(1, 103),
(1, 104),
(1, 105),
(1, 106),
(1, 107),
(1, 108),
(2, 1),
(2, 2),
(2, 3),
(2, 4),
(2, 5),
(2, 6),
(2, 7),
(2, 8),
(2, 9),
(2, 10),
(2, 11),
(2, 17),
(2, 18),
(2, 19),
(2, 20),
(2, 21),
(2, 22),
(2, 23),
(2, 24),
(2, 25),
(2, 26),
(2, 27),
(2, 28),
(2, 29),
(2, 30),
(2, 31),
(2, 32),
(2, 33),
(2, 34),
(2, 35),
(2, 36),
(2, 37),
(2, 38),
(2, 39),
(2, 40),
(2, 41),
(2, 42),
(2, 43),
(2, 44),
(2, 45),
(2, 46),
(2, 47),
(2, 48),
(2, 49),
(2, 50),
(2, 51),
(2, 52),
(2, 53),
(2, 54),
(2, 55),
(2, 56),
(2, 57),
(2, 58),
(2, 59),
(2, 60),
(2, 61),
(2, 62),
(2, 63),
(2, 64),
(2, 65),
(2, 66),
(2, 67),
(2, 68),
(2, 69),
(2, 70),
(2, 71),
(2, 72),
(2, 73),
(2, 74),
(2, 75),
(2, 76),
(2, 77),
(2, 78),
(2, 79),
(2, 80),
(2, 81),
(2, 82),
(2, 83),
(2, 84),
(2, 85),
(2, 86),
(2, 87),
(2, 88),
(2, 89),
(2, 90),
(2, 91),
(2, 92),
(2, 93),
(2, 94),
(2, 95),
(2, 96),
(2, 97),
(2, 98),
(2, 99),
(2, 100),
(2, 101),
(2, 102),
(2, 103),
(2, 104),
(2, 105),
(2, 106),
(2, 107),
(2, 108),
(3, 46),
(3, 79),
(3, 80),
(3, 82),
(3, 83),
(3, 84),
(4, 103);

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

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `price` decimal(15,2) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `product_categories`
--

CREATE TABLE `product_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `product_product_category`
--

CREATE TABLE `product_product_category` (
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `product_category_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `product_product_tag`
--

CREATE TABLE `product_product_tag` (
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `product_tag_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `product_tags`
--

CREATE TABLE `product_tags` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `reject_customer_luck_draw_datas`
--

CREATE TABLE `reject_customer_luck_draw_datas` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `updated_correct_happy_code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reject_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remark` longtext COLLATE utf8mb4_unicode_ci,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `customer_luck_draw_data_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `reject_customer_luck_draw_datas`
--

INSERT INTO `reject_customer_luck_draw_datas` (`id`, `updated_correct_happy_code`, `reject_type`, `remark`, `status`, `created_at`, `updated_at`, `deleted_at`, `customer_luck_draw_data_id`) VALUES
(1, NULL, '0', 'Invalid uploaded photo', '0', '2021-11-05 12:41:53', '2021-11-05 12:41:53', NULL, 1);

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `title`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Admin', NULL, NULL, NULL),
(2, 'Employee', NULL, NULL, NULL),
(3, 'Customer Service', NULL, NULL, NULL),
(4, 'Customer', NULL, NULL, NULL),
(5, 'User', NULL, NULL, NULL);

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

--
-- Table structure for table `role_shipping_clerk`
--

CREATE TABLE `role_shipping_clerk` (
  `shipping_clerk_id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `role_user`
--

CREATE TABLE `role_user` (
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `shipping_lucky_draws`
--

CREATE TABLE `shipping_lucky_draws` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `courier_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tracking_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `customer_luck_draw_data_id` bigint(20) UNSIGNED NOT NULL,
  `lucky_draw_items_id` bigint(20) UNSIGNED NOT NULL,
  `ref_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipment_date` date DEFAULT NULL,
  `couriers_id` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `shipping_lucky_draws`
--

INSERT INTO `shipping_lucky_draws` (`id`, `courier_name`, `tracking_number`, `description`, `status`, `created_at`, `updated_at`, `deleted_at`, `customer_luck_draw_data_id`, `lucky_draw_items_id`, `ref_no`, `shipment_date`, `couriers_id`) VALUES
(2, '', '', NULL, '1', '2021-11-05 12:48:29', '2021-11-08 13:26:17', NULL, 14, 1, NULL, NULL, NULL),
(3, '', 'ABX14411', '<p>Test</p>', '1', '2021-11-08 12:54:56', '2021-11-08 12:59:44', NULL, 21, 1, NULL, '2021-11-08', 1),
(4, '', '', NULL, '0', '2021-11-11 04:44:00', '2021-11-11 04:44:00', NULL, 19, 3, NULL, NULL, NULL);

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

--
-- Table structure for table `states`
--

CREATE TABLE `states` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `area` int(11) DEFAULT NULL,
  `province_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sort` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `states`
--

INSERT INTO `states` (`id`, `area`, `province_name`, `sort`, `created_at`, `updated_at`, `deleted_at`) VALUES
(2, 0, 'Kuala Lumpur ', 0, NULL, NULL, NULL),
(3, 0, 'Johor', 0, NULL, NULL, NULL),
(4, 0, 'Melaka', 0, NULL, NULL, NULL),
(5, 0, 'Perak', 0, NULL, NULL, NULL),
(6, 0, 'Sabah', 0, NULL, NULL, NULL),
(7, 0, 'Kelantan', 0, NULL, NULL, NULL),
(8, 0, 'Negeri Sembilan', 0, NULL, NULL, NULL),
(9, 0, 'Pahang', 0, NULL, NULL, NULL),
(10, 0, 'Kedah', 0, NULL, NULL, NULL),
(11, 0, 'Terengganu', 0, NULL, NULL, NULL),
(12, 0, 'Sarawak', 0, NULL, NULL, NULL),
(13, 0, 'Perlis', 0, NULL, NULL, NULL),
(14, 0, 'Selangor', 0, NULL, NULL, NULL),
(15, 0, 'Labuan', 0, NULL, NULL, NULL),
(35, 0, 'Penang', 0, NULL, NULL, NULL),
(36, 0, 'Putrajaya', 0, NULL, NULL, NULL);

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

--
-- Table structure for table `surveys`
--

CREATE TABLE `surveys` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `value_1` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value_2` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `customer_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `surveys`
--

INSERT INTO `surveys` (`id`, `value_1`, `value_2`, `created_at`, `updated_at`, `deleted_at`, `customer_id`) VALUES
(1, 'Choco Grains', '{\"2\":\"Kurma\"}', '2021-10-26 15:25:25', '2021-10-26 15:25:25', NULL, 2),
(2, 'Original Mixed Grains', '{\"3\":\"Beetroot\"}', '2021-11-10 14:52:46', '2021-11-10 14:52:46', NULL, 3);

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `cities`
--
ALTER TABLE `cities`
  ADD PRIMARY KEY (`id`),
  ADD KEY `province_fk_5099913` (`province_id`);

--
-- Indexes for table `customer_luck_draw_datas`
--
ALTER TABLE `customer_luck_draw_datas`
  ADD PRIMARY KEY (`id`),
  ADD KEY `luck_draw_data_fk_5107113` (`luck_draw_data_id`),
  ADD KEY `customer_fk_5107033` (`customer_id`);

--
-- Indexes for table `customer_role`
--
ALTER TABLE `customer_role`
  ADD KEY `customer_id_fk_5099956` (`customer_id`),
  ADD KEY `role_id_fk_5099956` (`role_id`);

--
-- Indexes for table `employee_role`
--
ALTER TABLE `employee_role`
  ADD KEY `employee_id_fk_5099974` (`employee_id`),
  ADD KEY `role_id_fk_5099974` (`role_id`);

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

--
-- Indexes for table `luck_draw_datas`
--
ALTER TABLE `luck_draw_datas`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `luck_draw_datas_happy_code_unique` (`happy_code`),
  ADD KEY `lucky_draw_item_fk_5107034` (`lucky_draw_item_id`);

--
-- Indexes for table `media`
--
ALTER TABLE `media`
  ADD PRIMARY KEY (`id`),
  ADD KEY `media_model_type_model_id_index` (`model_type`,`model_id`);

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

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

--
-- Indexes for table `permission_role`
--
ALTER TABLE `permission_role`
  ADD KEY `role_id_fk_5099837` (`role_id`),
  ADD KEY `permission_id_fk_5099837` (`permission_id`);

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

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

--
-- Indexes for table `product_product_category`
--
ALTER TABLE `product_product_category`
  ADD KEY `product_id_fk_5099899` (`product_id`),
  ADD KEY `product_category_id_fk_5099899` (`product_category_id`);

--
-- Indexes for table `product_product_tag`
--
ALTER TABLE `product_product_tag`
  ADD KEY `product_id_fk_5099900` (`product_id`),
  ADD KEY `product_tag_id_fk_5099900` (`product_tag_id`);

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

--
-- Indexes for table `reject_customer_luck_draw_datas`
--
ALTER TABLE `reject_customer_luck_draw_datas`
  ADD PRIMARY KEY (`id`),
  ADD KEY `customer_luck_draw_data_fk_5107523` (`customer_luck_draw_data_id`);

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

--
-- Indexes for table `role_shipping_clerk`
--
ALTER TABLE `role_shipping_clerk`
  ADD KEY `shipping_clerk_id_fk_5106611` (`shipping_clerk_id`),
  ADD KEY `role_id_fk_5106611` (`role_id`);

--
-- Indexes for table `role_user`
--
ALTER TABLE `role_user`
  ADD KEY `user_id_fk_5099846` (`user_id`),
  ADD KEY `role_id_fk_5099846` (`role_id`);

--
-- Indexes for table `shipping_lucky_draws`
--
ALTER TABLE `shipping_lucky_draws`
  ADD PRIMARY KEY (`id`),
  ADD KEY `customer_luck_draw_data_fk_5107002` (`customer_luck_draw_data_id`),
  ADD KEY `lucky_draw_items_fk_5106748` (`lucky_draw_items_id`);

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

--
-- Indexes for table `surveys`
--
ALTER TABLE `surveys`
  ADD PRIMARY KEY (`id`),
  ADD KEY `customer_fk_5099983` (`customer_id`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `cities`
--
ALTER TABLE `cities`
  ADD CONSTRAINT `province_fk_5099913` FOREIGN KEY (`province_id`) REFERENCES `states` (`id`);

--
-- Constraints for table `customer_luck_draw_datas`
--
ALTER TABLE `customer_luck_draw_datas`
  ADD CONSTRAINT `customer_fk_5107033` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`),
  ADD CONSTRAINT `luck_draw_data_fk_5107113` FOREIGN KEY (`luck_draw_data_id`) REFERENCES `luck_draw_datas` (`id`);

--
-- Constraints for table `customer_role`
--
ALTER TABLE `customer_role`
  ADD CONSTRAINT `customer_id_fk_5099956` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `role_id_fk_5099956` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `employee_role`
--
ALTER TABLE `employee_role`
  ADD CONSTRAINT `employee_id_fk_5099974` FOREIGN KEY (`employee_id`) REFERENCES `employees` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `role_id_fk_5099974` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `luck_draw_datas`
--
ALTER TABLE `luck_draw_datas`
  ADD CONSTRAINT `lucky_draw_item_fk_5107034` FOREIGN KEY (`lucky_draw_item_id`) REFERENCES `lucky_draw_items` (`id`);

--
-- Constraints for table `permission_role`
--
ALTER TABLE `permission_role`
  ADD CONSTRAINT `permission_id_fk_5099837` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `role_id_fk_5099837` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `product_product_category`
--
ALTER TABLE `product_product_category`
  ADD CONSTRAINT `product_category_id_fk_5099899` FOREIGN KEY (`product_category_id`) REFERENCES `product_categories` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `product_id_fk_5099899` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `product_product_tag`
--
ALTER TABLE `product_product_tag`
  ADD CONSTRAINT `product_id_fk_5099900` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `product_tag_id_fk_5099900` FOREIGN KEY (`product_tag_id`) REFERENCES `product_tags` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `reject_customer_luck_draw_datas`
--
ALTER TABLE `reject_customer_luck_draw_datas`
  ADD CONSTRAINT `customer_luck_draw_data_fk_5107523` FOREIGN KEY (`customer_luck_draw_data_id`) REFERENCES `customer_luck_draw_datas` (`id`);

--
-- Constraints for table `role_shipping_clerk`
--
ALTER TABLE `role_shipping_clerk`
  ADD CONSTRAINT `role_id_fk_5106611` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `shipping_clerk_id_fk_5106611` FOREIGN KEY (`shipping_clerk_id`) REFERENCES `shipping_clerks` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `role_user`
--
ALTER TABLE `role_user`
  ADD CONSTRAINT `role_id_fk_5099846` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `user_id_fk_5099846` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `shipping_lucky_draws`
--
ALTER TABLE `shipping_lucky_draws`
  ADD CONSTRAINT `customer_luck_draw_data_fk_5107002` FOREIGN KEY (`customer_luck_draw_data_id`) REFERENCES `customer_luck_draw_datas` (`id`),
  ADD CONSTRAINT `lucky_draw_items_fk_5106748` FOREIGN KEY (`lucky_draw_items_id`) REFERENCES `lucky_draw_items` (`id`);

--
-- Constraints for table `surveys`
--
ALTER TABLE `surveys`
  ADD CONSTRAINT `customer_fk_5099983` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`);
COMMIT;

