-- phpMyAdmin SQL Dump
-- version 4.8.5
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Nov 17, 2021 at 10:08 AM
-- Server version: 10.1.38-MariaDB
-- PHP Version: 7.3.4

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- 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 `customers`
--

CREATE TABLE `customers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `identity_card_number` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `approved` tinyint(1) DEFAULT '0',
  `dob` date DEFAULT NULL,
  `shipping_address` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` datetime DEFAULT NULL,
  `password` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remember_token` 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,
  `state_id` bigint(20) UNSIGNED DEFAULT NULL,
  `city_id` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `customers`
--

INSERT INTO `customers` (`id`, `name`, `email`, `phone`, `identity_card_number`, `approved`, `dob`, `shipping_address`, `email_verified_at`, `password`, `remember_token`, `status`, `created_at`, `updated_at`, `deleted_at`, `state_id`, `city_id`) VALUES
(1, 'User', 'user@user.com', '', '', 1, NULL, '', NULL, '$2y$10$hMHxx.8CwjMPXAakQ4LYq.KUKCFLgv9fpZUohnLQyzoc2cREPLAFW', NULL, '1', NULL, NULL, NULL, NULL, NULL),
(2, 'kristy', 'it@thethymespa.com', '0177569933', '111', 0, '1982-09-19', '105', NULL, '$2y$10$yJHKYgzI7gGHK1xGM/Y70OW1lVpTBcKCYBsWpZvwv04NhLCYx4Tf.', NULL, '1', '2021-10-26 15:25:25', '2021-10-26 15:25:25', NULL, 3, 627),
(3, 'kristy 3', 'it2@thethymespa.com', '1341341', '13134121', 0, NULL, 'dfasdfsa', NULL, '$2y$10$/TckavrKPXVL31NyQMXTRODmJn5lEGnHXG3rfS5srB9G6Ezkzei/a', NULL, '1', '2021-11-10 14:52:46', '2021-11-10 14:52:46', NULL, 3, 627);

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

--
-- 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 `employees`
--

CREATE TABLE `employees` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `identity_card_number` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `approved` tinyint(1) DEFAULT '0',
  `dob` date DEFAULT NULL,
  `address` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` datetime DEFAULT NULL,
  `password` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remember_token` 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,
  `state_id` bigint(20) UNSIGNED DEFAULT NULL,
  `city_id` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `employees`
--

INSERT INTO `employees` (`id`, `name`, `email`, `phone`, `identity_card_number`, `approved`, `dob`, `address`, `email_verified_at`, `password`, `remember_token`, `status`, `created_at`, `updated_at`, `deleted_at`, `state_id`, `city_id`) VALUES
(1, 'Admin', 'admin@admin.com', '', '', 1, NULL, '', NULL, '$2y$10$JNQX12HALreBBTm9Ifu/6Osbx4wZOhwVtHapp6KcyGO3QEVEpAv9i', NULL, '1', NULL, NULL, NULL, NULL, NULL),
(2, 'kristy cs', 'kristykl@gmail.com', '1111', '11', 0, '2021-11-02', '131341', NULL, '$2y$10$pu0eBl74ELL91IEKmrRioe9TAH1WdUA2mre43MXoUkCCd7P/jeD2e', NULL, '1', '2021-11-09 05:02:49', '2021-11-09 05:02:49', NULL, 3, 571);

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

--
-- 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 `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `password_resets`
--

INSERT INTO `password_resets` (`email`, `token`, `created_at`) VALUES
('it@thethymespa.com', '$2y$10$hyV.BcGPqIYsymw.G1GJMu.qGtpFy5F0Aa5ZmTKr9JFebHlcDfs2q', '2021-11-01 07:43:31');

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

--
-- 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_clerks`
--

CREATE TABLE `shipping_clerks` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `identity_card_number` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `approved` tinyint(1) DEFAULT '0',
  `dob` date DEFAULT NULL,
  `adress` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` datetime DEFAULT NULL,
  `password` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remember_token` 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,
  `state_id` bigint(20) UNSIGNED DEFAULT NULL,
  `city_id` bigint(20) UNSIGNED DEFAULT 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);

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `identity_card_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `address_1` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_verified_at` datetime DEFAULT NULL,
  `password` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remember_token` 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,
  `state_id` bigint(20) UNSIGNED DEFAULT NULL,
  `city_id` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- 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 `customers`
--
ALTER TABLE `customers`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `customers_identity_card_number_unique` (`identity_card_number`),
  ADD UNIQUE KEY `customers_email_unique` (`email`),
  ADD KEY `state_fk_5106642` (`state_id`),
  ADD KEY `city_fk_5099953` (`city_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 `employees`
--
ALTER TABLE `employees`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `employees_identity_card_number_unique` (`identity_card_number`),
  ADD UNIQUE KEY `employees_email_unique` (`email`),
  ADD KEY `state_fk_5099970` (`state_id`),
  ADD KEY `city_fk_5099971` (`city_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 `password_resets`
--
ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`);

--
-- 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_clerks`
--
ALTER TABLE `shipping_clerks`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `shipping_clerks_identity_card_number_unique` (`identity_card_number`),
  ADD UNIQUE KEY `shipping_clerks_email_unique` (`email`),
  ADD KEY `state_fk_5106607` (`state_id`),
  ADD KEY `city_fk_5106608` (`city_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`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`),
  ADD KEY `state_fk_5099924` (`state_id`),
  ADD KEY `city_fk_5099925` (`city_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 `customers`
--
ALTER TABLE `customers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- 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 `employees`
--
ALTER TABLE `employees`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- 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_clerks`
--
ALTER TABLE `shipping_clerks`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

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

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

--
-- 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 `customers`
--
ALTER TABLE `customers`
  ADD CONSTRAINT `city_fk_5099953` FOREIGN KEY (`city_id`) REFERENCES `cities` (`id`),
  ADD CONSTRAINT `state_fk_5106642` FOREIGN KEY (`state_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 `employees`
--
ALTER TABLE `employees`
  ADD CONSTRAINT `city_fk_5099971` FOREIGN KEY (`city_id`) REFERENCES `cities` (`id`),
  ADD CONSTRAINT `state_fk_5099970` FOREIGN KEY (`state_id`) REFERENCES `states` (`id`);

--
-- 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_clerks`
--
ALTER TABLE `shipping_clerks`
  ADD CONSTRAINT `city_fk_5106608` FOREIGN KEY (`city_id`) REFERENCES `cities` (`id`),
  ADD CONSTRAINT `state_fk_5106607` FOREIGN KEY (`state_id`) REFERENCES `states` (`id`);

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

--
-- Constraints for table `users`
--
ALTER TABLE `users`
  ADD CONSTRAINT `city_fk_5099925` FOREIGN KEY (`city_id`) REFERENCES `cities` (`id`),
  ADD CONSTRAINT `state_fk_5099924` FOREIGN KEY (`state_id`) REFERENCES `states` (`id`);
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;