text: /*
   Navicat Premium Data Transfer
  
   Source Server         : localhost mysql
   Source Server Type    : MySQL
   Source Server Version : 100424
   Source Host           : 127.0.1.1:3306
   Source Schema         : whatsapp_server
  
   Target Server Type    : MySQL
   Target Server Version : 100424
   File Encoding         : 65001
  
   Date: 22/04/2022 10:48:00
  */
  
  SET NAMES utf8mb4;
  SET FOREIGN_KEY_CHECKS = 0;
  
  -- ----------------------------
  -- Table structure for cms_apicustom
  -- ----------------------------
  DROP TABLE IF EXISTS `cms_apicustom`;
  CREATE TABLE `cms_apicustom`  (
    `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
    `permalink` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `tabel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `aksi` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `kolom` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `orderby` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `sub_query_1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `sql_where` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `nama` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `keterangan` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `parameter` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `method_type` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `parameters` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
    `responses` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of cms_apicustom
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for cms_apikey
  -- ----------------------------
  DROP TABLE IF EXISTS `cms_apikey`;
  CREATE TABLE `cms_apikey`  (
    `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
    `screetkey` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `hit` int NULL DEFAULT NULL,
    `status` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of cms_apikey
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for cms_dashboard
  -- ----------------------------
  DROP TABLE IF EXISTS `cms_dashboard`;
  CREATE TABLE `cms_dashboard`  (
    `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
    `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `id_cms_privileges` int NULL DEFAULT NULL,
    `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of cms_dashboard
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for cms_email_queues
  -- ----------------------------
  DROP TABLE IF EXISTS `cms_email_queues`;
  CREATE TABLE `cms_email_queues`  (
    `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
    `send_at` datetime NULL DEFAULT NULL,
    `email_recipient` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `email_from_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `email_from_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `email_cc_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `email_subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `email_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
    `email_attachments` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
    `is_sent` tinyint(1) NULL DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of cms_email_queues
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for cms_email_templates
  -- ----------------------------
  DROP TABLE IF EXISTS `cms_email_templates`;
  CREATE TABLE `cms_email_templates`  (
    `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
    `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
    `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `from_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `from_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `cc_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of cms_email_templates
  -- ----------------------------
  INSERT INTO `cms_email_templates` VALUES (1, 'Email Template Forgot Password Backend', 'forgot_password_backend', NULL, '<p>Hi,</p><p>Someone requested forgot password, here is your new password : </p><p>[password]</p><p><br></p><p>--</p><p>Regards,</p><p>Admin</p>', '[password]', 'System', 'system@crudbooster.com', NULL, '2022-04-15 06:06:21', NULL);
  
  -- ----------------------------
  -- Table structure for cms_logs
  -- ----------------------------
  DROP TABLE IF EXISTS `cms_logs`;
  CREATE TABLE `cms_logs`  (
    `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
    `ipaddress` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `useragent` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
    `id_cms_users` int NULL DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of cms_logs
  -- ----------------------------
  INSERT INTO `cms_logs` VALUES (1, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:99.0) Gecko/20100101 Firefox/99.0', 'http://localhost/admin/login', 'admin@crudbooster.com login with IP Address 127.0.0.1', '', 1, '2022-04-15 06:07:12', NULL);
  INSERT INTO `cms_logs` VALUES (2, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:99.0) Gecko/20100101 Firefox/99.0', 'http://localhost/admin/device/add-save', 'Add New Data nomer m3 at Device', '', 1, '2022-04-15 06:13:42', NULL);
  INSERT INTO `cms_logs` VALUES (3, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:99.0) Gecko/20100101 Firefox/99.0', 'http://laravel-whatsapp-server.test/admin/login', 'admin@crudbooster.com login with IP Address 127.0.0.1', '', 1, '2022-04-15 06:17:05', NULL);
  INSERT INTO `cms_logs` VALUES (4, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:99.0) Gecko/20100101 Firefox/99.0', 'http://laravel-whatsapp-server.test/admin/login', 'admin@crudbooster.com login with IP Address 127.0.0.1', '', 1, '2022-04-17 18:04:18', NULL);
  INSERT INTO `cms_logs` VALUES (5, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/102.0.0.0 Safari/537.36', 'http://laravel-whatsapp-server.test/admin/login', 'admin@crudbooster.com login with IP Address 127.0.0.1', '', 1, '2022-04-17 18:07:57', NULL);
  
  -- ----------------------------
  -- Table structure for cms_menus
  -- ----------------------------
  DROP TABLE IF EXISTS `cms_menus`;
  CREATE TABLE `cms_menus`  (
    `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
    `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'url',
    `path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `parent_id` int NULL DEFAULT NULL,
    `is_active` tinyint(1) NOT NULL DEFAULT 1,
    `is_dashboard` tinyint(1) NOT NULL DEFAULT 0,
    `id_cms_privileges` int NULL DEFAULT NULL,
    `sorting` int NULL DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of cms_menus
  -- ----------------------------
  INSERT INTO `cms_menus` VALUES (1, 'Device', 'Route', 'AdminDeviceControllerGetIndex', NULL, 'fa fa-qrcode', 0, 1, 0, 1, 1, '2022-02-06 02:49:42', NULL);
  INSERT INTO `cms_menus` VALUES (2, 'Contact', 'Route', 'AdminContactControllerGetIndex', NULL, 'fa fa-book', 0, 0, 0, 1, 1, '2022-02-06 02:53:46', NULL);
  INSERT INTO `cms_menus` VALUES (3, 'Outbox', 'Route', 'AdminOutboxControllerGetIndex', NULL, 'fa fa-send', 0, 1, 0, 1, 3, '2022-02-06 02:59:55', NULL);
  
  -- ----------------------------
  -- Table structure for cms_menus_privileges
  -- ----------------------------
  DROP TABLE IF EXISTS `cms_menus_privileges`;
  CREATE TABLE `cms_menus_privileges`  (
    `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
    `id_cms_menus` int NULL DEFAULT NULL,
    `id_cms_privileges` int NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of cms_menus_privileges
  -- ----------------------------
  INSERT INTO `cms_menus_privileges` VALUES (1, 1, 1);
  INSERT INTO `cms_menus_privileges` VALUES (2, 2, 1);
  INSERT INTO `cms_menus_privileges` VALUES (3, 3, 1);
  
  -- ----------------------------
  -- Table structure for cms_moduls
  -- ----------------------------
  DROP TABLE IF EXISTS `cms_moduls`;
  CREATE TABLE `cms_moduls`  (
    `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
    `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `table_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `controller` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `is_protected` tinyint(1) NOT NULL DEFAULT 0,
    `is_active` tinyint(1) NOT NULL DEFAULT 0,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `deleted_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of cms_moduls
  -- ----------------------------
  INSERT INTO `cms_moduls` VALUES (1, 'Notifications', 'fa fa-cog', 'notifications', 'cms_notifications', 'NotificationsController', 1, 1, '2022-02-04 09:46:11', NULL, NULL);
  INSERT INTO `cms_moduls` VALUES (2, 'Privileges', 'fa fa-cog', 'privileges', 'cms_privileges', 'PrivilegesController', 1, 1, '2022-02-04 09:46:11', NULL, NULL);
  INSERT INTO `cms_moduls` VALUES (3, 'Privileges Roles', 'fa fa-cog', 'privileges_roles', 'cms_privileges_roles', 'PrivilegesRolesController', 1, 1, '2022-02-04 09:46:11', NULL, NULL);
  INSERT INTO `cms_moduls` VALUES (4, 'Users Management', 'fa fa-users', 'users', 'cms_users', 'AdminCmsUsersController', 0, 1, '2022-02-04 09:46:11', NULL, NULL);
  INSERT INTO `cms_moduls` VALUES (5, 'Settings', 'fa fa-cog', 'settings', 'cms_settings', 'SettingsController', 1, 1, '2022-02-04 09:46:11', NULL, NULL);
  INSERT INTO `cms_moduls` VALUES (6, 'Module Generator', 'fa fa-database', 'module_generator', 'cms_moduls', 'ModulsController', 1, 1, '2022-02-04 09:46:11', NULL, NULL);
  INSERT INTO `cms_moduls` VALUES (7, 'Menu Management', 'fa fa-bars', 'menu_management', 'cms_menus', 'MenusController', 1, 1, '2022-02-04 09:46:11', NULL, NULL);
  INSERT INTO `cms_moduls` VALUES (8, 'Email Templates', 'fa fa-envelope-o', 'email_templates', 'cms_email_templates', 'EmailTemplatesController', 1, 1, '2022-02-04 09:46:11', NULL, NULL);
  INSERT INTO `cms_moduls` VALUES (9, 'Statistic Builder', 'fa fa-dashboard', 'statistic_builder', 'cms_statistics', 'StatisticBuilderController', 1, 1, '2022-02-04 09:46:11', NULL, NULL);
  INSERT INTO `cms_moduls` VALUES (10, 'API Generator', 'fa fa-cloud-download', 'api_generator', '', 'ApiCustomController', 1, 1, '2022-02-04 09:46:11', NULL, NULL);
  INSERT INTO `cms_moduls` VALUES (11, 'Log User Access', 'fa fa-flag-o', 'logs', 'cms_logs', 'LogsController', 1, 1, '2022-02-04 09:46:11', NULL, NULL);
  INSERT INTO `cms_moduls` VALUES (12, 'Device', 'fa fa-qrcode', 'device', 'device', 'AdminDeviceController', 0, 0, '2022-02-06 02:49:42', NULL, NULL);
  INSERT INTO `cms_moduls` VALUES (13, 'Contact', 'fa fa-book', 'contact', 'contact', 'AdminContactController', 0, 0, '2022-02-06 02:53:46', NULL, NULL);
  INSERT INTO `cms_moduls` VALUES (14, 'Outbox', 'fa fa-send', 'outbox', 'outbox', 'AdminOutboxController', 0, 0, '2022-02-06 02:59:55', NULL, NULL);
  
  -- ----------------------------
  -- Table structure for cms_notifications
  -- ----------------------------
  DROP TABLE IF EXISTS `cms_notifications`;
  CREATE TABLE `cms_notifications`  (
    `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
    `id_cms_users` int NULL DEFAULT NULL,
    `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `is_read` tinyint(1) NULL DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of cms_notifications
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for cms_privileges
  -- ----------------------------
  DROP TABLE IF EXISTS `cms_privileges`;
  CREATE TABLE `cms_privileges`  (
    `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
    `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `is_superadmin` tinyint(1) NULL DEFAULT NULL,
    `theme_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of cms_privileges
  -- ----------------------------
  INSERT INTO `cms_privileges` VALUES (1, 'Super Administrator', 1, 'skin-red', '2022-04-15 06:06:21', NULL);
  
  -- ----------------------------
  -- Table structure for cms_privileges_roles
  -- ----------------------------
  DROP TABLE IF EXISTS `cms_privileges_roles`;
  CREATE TABLE `cms_privileges_roles`  (
    `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
    `is_visible` tinyint(1) NULL DEFAULT NULL,
    `is_create` tinyint(1) NULL DEFAULT NULL,
    `is_read` tinyint(1) NULL DEFAULT NULL,
    `is_edit` tinyint(1) NULL DEFAULT NULL,
    `is_delete` tinyint(1) NULL DEFAULT NULL,
    `id_cms_privileges` int NULL DEFAULT NULL,
    `id_cms_moduls` int NULL DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of cms_privileges_roles
  -- ----------------------------
  INSERT INTO `cms_privileges_roles` VALUES (1, 1, 0, 0, 0, 0, 1, 1, '2022-04-15 06:06:21', NULL);
  INSERT INTO `cms_privileges_roles` VALUES (2, 1, 1, 1, 1, 1, 1, 2, '2022-04-15 06:06:21', NULL);
  INSERT INTO `cms_privileges_roles` VALUES (3, 0, 1, 1, 1, 1, 1, 3, '2022-04-15 06:06:21', NULL);
  INSERT INTO `cms_privileges_roles` VALUES (4, 1, 1, 1, 1, 1, 1, 4, '2022-04-15 06:06:21', NULL);
  INSERT INTO `cms_privileges_roles` VALUES (5, 1, 1, 1, 1, 1, 1, 5, '2022-04-15 06:06:21', NULL);
  INSERT INTO `cms_privileges_roles` VALUES (6, 1, 1, 1, 1, 1, 1, 6, '2022-04-15 06:06:21', NULL);
  INSERT INTO `cms_privileges_roles` VALUES (7, 1, 1, 1, 1, 1, 1, 7, '2022-04-15 06:06:21', NULL);
  INSERT INTO `cms_privileges_roles` VALUES (8, 1, 1, 1, 1, 1, 1, 8, '2022-04-15 06:06:21', NULL);
  INSERT INTO `cms_privileges_roles` VALUES (9, 1, 1, 1, 1, 1, 1, 9, '2022-04-15 06:06:21', NULL);
  INSERT INTO `cms_privileges_roles` VALUES (10, 1, 1, 1, 1, 1, 1, 10, '2022-04-15 06:06:21', NULL);
  INSERT INTO `cms_privileges_roles` VALUES (11, 1, 0, 1, 0, 1, 1, 11, '2022-04-15 06:06:21', NULL);
  
  -- ----------------------------
  -- Table structure for cms_settings
  -- ----------------------------
  DROP TABLE IF EXISTS `cms_settings`;
  CREATE TABLE `cms_settings`  (
    `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
    `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
    `content_input_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `dataenum` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `helper` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `group_setting` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of cms_settings
  -- ----------------------------
  INSERT INTO `cms_settings` VALUES (1, 'login_background_color', NULL, 'text', NULL, 'Input hexacode', '2022-02-04 09:46:11', NULL, 'Login Register Style', 'Login Background Color');
  INSERT INTO `cms_settings` VALUES (2, 'login_font_color', NULL, 'text', NULL, 'Input hexacode', '2022-02-04 09:46:11', NULL, 'Login Register Style', 'Login Font Color');
  INSERT INTO `cms_settings` VALUES (3, 'login_background_image', NULL, 'upload_image', NULL, NULL, '2022-02-04 09:46:11', NULL, 'Login Register Style', 'Login Background Image');
  INSERT INTO `cms_settings` VALUES (4, 'email_sender', 'support@crudbooster.com', 'text', NULL, NULL, '2022-02-04 09:46:11', NULL, 'Email Setting', 'Email Sender');
  INSERT INTO `cms_settings` VALUES (5, 'smtp_driver', 'mail', 'select', 'smtp,mail,sendmail', NULL, '2022-02-04 09:46:11', NULL, 'Email Setting', 'Mail Driver');
  INSERT INTO `cms_settings` VALUES (6, 'smtp_host', '', 'text', NULL, NULL, '2022-02-04 09:46:11', NULL, 'Email Setting', 'SMTP Host');
  INSERT INTO `cms_settings` VALUES (7, 'smtp_port', '25', 'text', NULL, 'default 25', '2022-02-04 09:46:11', NULL, 'Email Setting', 'SMTP Port');
  INSERT INTO `cms_settings` VALUES (8, 'smtp_username', '', 'text', NULL, NULL, '2022-02-04 09:46:11', NULL, 'Email Setting', 'SMTP Username');
  INSERT INTO `cms_settings` VALUES (9, 'smtp_password', '', 'text', NULL, NULL, '2022-02-04 09:46:11', NULL, 'Email Setting', 'SMTP Password');
  INSERT INTO `cms_settings` VALUES (10, 'appname', 'CRUDBooster', 'text', NULL, NULL, '2022-02-04 09:46:11', NULL, 'Application Setting', 'Application Name');
  INSERT INTO `cms_settings` VALUES (11, 'default_paper_size', 'Legal', 'text', NULL, 'Paper size, ex : A4, Legal, etc', '2022-02-04 09:46:11', NULL, 'Application Setting', 'Default Paper Print Size');
  INSERT INTO `cms_settings` VALUES (12, 'logo', '', 'upload_image', NULL, NULL, '2022-02-04 09:46:11', NULL, 'Application Setting', 'Logo');
  INSERT INTO `cms_settings` VALUES (13, 'favicon', '', 'upload_image', NULL, NULL, '2022-02-04 09:46:11', NULL, 'Application Setting', 'Favicon');
  INSERT INTO `cms_settings` VALUES (14, 'api_debug_mode', 'true', 'select', 'true,false', NULL, '2022-02-04 09:46:11', NULL, 'Application Setting', 'API Debug Mode');
  INSERT INTO `cms_settings` VALUES (15, 'google_api_key', '', 'text', NULL, NULL, '2022-02-04 09:46:11', NULL, 'Application Setting', 'Google API Key');
  INSERT INTO `cms_settings` VALUES (16, 'google_fcm_key', '', 'text', NULL, NULL, '2022-02-04 09:46:11', NULL, 'Application Setting', 'Google FCM Key');
  
  -- ----------------------------
  -- Table structure for cms_statistic_components
  -- ----------------------------
  DROP TABLE IF EXISTS `cms_statistic_components`;
  CREATE TABLE `cms_statistic_components`  (
    `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
    `id_cms_statistics` int NULL DEFAULT NULL,
    `componentID` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `component_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `area_name` varchar(55) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `sorting` int NULL DEFAULT NULL,
    `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `config` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of cms_statistic_components
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for cms_statistics
  -- ----------------------------
  DROP TABLE IF EXISTS `cms_statistics`;
  CREATE TABLE `cms_statistics`  (
    `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
    `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of cms_statistics
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for cms_users
  -- ----------------------------
  DROP TABLE IF EXISTS `cms_users`;
  CREATE TABLE `cms_users`  (
    `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
    `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `photo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `id_cms_privileges` int NULL DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `status` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of cms_users
  -- ----------------------------
  INSERT INTO `cms_users` VALUES (1, 'Super Admin', NULL, 'admin@crudbooster.com', '$2y$10$AtnJU4LKaZP6BHrgVrVecub5XRLVxMX3UdIi/6nPXJ/NRJmQCvNPm', 1, '2022-04-15 06:06:21', NULL, 'Active');
  
  -- ----------------------------
  -- Table structure for contact
  -- ----------------------------
  DROP TABLE IF EXISTS `contact`;
  CREATE TABLE `contact`  (
    `id` int NOT NULL AUTO_INCREMENT,
    `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `multidevice` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `id_users` int NULL DEFAULT NULL,
    `id_device` int NULL DEFAULT NULL,
    `created_at` datetime NULL DEFAULT NULL,
    `updated_at` datetime NULL DEFAULT NULL,
    `deleted_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of contact
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for device
  -- ----------------------------
  DROP TABLE IF EXISTS `device`;
  CREATE TABLE `device`  (
    `id` int NOT NULL AUTO_INCREMENT,
    `id_users` int NULL DEFAULT NULL,
    `number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `created_at` datetime NULL DEFAULT NULL,
    `updated_at` datetime NULL DEFAULT NULL,
    `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `multidevice` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of device
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for failed_jobs
  -- ----------------------------
  DROP TABLE IF EXISTS `failed_jobs`;
  CREATE TABLE `failed_jobs`  (
    `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
    `uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `failed_at` timestamp NOT NULL DEFAULT current_timestamp,
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE INDEX `failed_jobs_uuid_unique`(`uuid` ASC) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of failed_jobs
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for migrations
  -- ----------------------------
  DROP TABLE IF EXISTS `migrations`;
  CREATE TABLE `migrations`  (
    `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
    `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `batch` int NOT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 28 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of migrations
  -- ----------------------------
  INSERT INTO `migrations` VALUES (1, '2016_08_07_145904_add_table_cms_apicustom', 1);
  INSERT INTO `migrations` VALUES (2, '2016_08_07_150834_add_table_cms_dashboard', 1);
  INSERT INTO `migrations` VALUES (3, '2016_08_07_151210_add_table_cms_logs', 1);
  INSERT INTO `migrations` VALUES (4, '2016_08_07_151211_add_details_cms_logs', 1);
  INSERT INTO `migrations` VALUES (5, '2016_08_07_152014_add_table_cms_privileges', 1);
  INSERT INTO `migrations` VALUES (6, '2016_08_07_152214_add_table_cms_privileges_roles', 1);
  INSERT INTO `migrations` VALUES (7, '2016_08_07_152320_add_table_cms_settings', 1);
  INSERT INTO `migrations` VALUES (8, '2016_08_07_152421_add_table_cms_users', 1);
  INSERT INTO `migrations` VALUES (9, '2016_08_07_154624_add_table_cms_menus_privileges', 1);
  INSERT INTO `migrations` VALUES (10, '2016_08_07_154624_add_table_cms_moduls', 1);
  INSERT INTO `migrations` VALUES (11, '2016_08_17_225409_add_status_cms_users', 1);
  INSERT INTO `migrations` VALUES (12, '2016_08_20_125418_add_table_cms_notifications', 1);
  INSERT INTO `migrations` VALUES (13, '2016_09_04_033706_add_table_cms_email_queues', 1);
  INSERT INTO `migrations` VALUES (14, '2016_09_16_035347_add_group_setting', 1);
  INSERT INTO `migrations` VALUES (15, '2016_09_16_045425_add_label_setting', 1);
  INSERT INTO `migrations` VALUES (16, '2016_09_17_104728_create_nullable_cms_apicustom', 1);
  INSERT INTO `migrations` VALUES (17, '2016_10_01_141740_add_method_type_apicustom', 1);
  INSERT INTO `migrations` VALUES (18, '2016_10_01_141846_add_parameters_apicustom', 1);
  INSERT INTO `migrations` VALUES (19, '2016_10_01_141934_add_responses_apicustom', 1);
  INSERT INTO `migrations` VALUES (20, '2016_10_01_144826_add_table_apikey', 1);
  INSERT INTO `migrations` VALUES (21, '2016_11_14_141657_create_cms_menus', 1);
  INSERT INTO `migrations` VALUES (22, '2016_11_15_132350_create_cms_email_templates', 1);
  INSERT INTO `migrations` VALUES (23, '2016_11_15_190410_create_cms_statistics', 1);
  INSERT INTO `migrations` VALUES (24, '2016_11_17_102740_create_cms_statistic_components', 1);
  INSERT INTO `migrations` VALUES (25, '2017_06_06_164501_add_deleted_at_cms_moduls', 1);
  INSERT INTO `migrations` VALUES (26, '2019_12_14_000001_create_personal_access_tokens_table', 1);
  INSERT INTO `migrations` VALUES (27, '2022_02_06_161234_create_laravel_wa_server_table', 1);
  
  -- ----------------------------
  -- Table structure for outbox
  -- ----------------------------
  DROP TABLE IF EXISTS `outbox`;
  CREATE TABLE `outbox`  (
    `id` int NOT NULL AUTO_INCREMENT,
    `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
    `status` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `created_at` datetime NULL DEFAULT NULL,
    `id_device` int NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of outbox
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for password_resets
  -- ----------------------------
  DROP TABLE IF EXISTS `password_resets`;
  CREATE TABLE `password_resets`  (
    `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    INDEX `password_resets_email_index`(`email` ASC) USING BTREE
  ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of password_resets
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for personal_access_tokens
  -- ----------------------------
  DROP TABLE IF EXISTS `personal_access_tokens`;
  CREATE TABLE `personal_access_tokens`  (
    `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
    `tokenable_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `tokenable_id` bigint UNSIGNED NOT NULL,
    `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `token` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `abilities` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
    `last_used_at` timestamp NULL DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE INDEX `personal_access_tokens_token_unique`(`token` ASC) USING BTREE,
    INDEX `personal_access_tokens_tokenable_type_tokenable_id_index`(`tokenable_type` ASC, `tokenable_id` ASC) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of personal_access_tokens
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for users
  -- ----------------------------
  DROP TABLE IF EXISTS `users`;
  CREATE TABLE `users`  (
    `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
    `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `email_verified_at` timestamp NULL DEFAULT NULL,
    `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE INDEX `users_email_unique`(`email` ASC) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of users
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for whatsapp_log
  -- ----------------------------
  DROP TABLE IF EXISTS `whatsapp_log`;
  CREATE TABLE `whatsapp_log`  (
    `id` int NOT NULL AUTO_INCREMENT,
    `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `message` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `session_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `tgl` datetime NULL DEFAULT current_timestamp,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of whatsapp_log
  -- ----------------------------
  
  SET FOREIGN_KEY_CHECKS = 1;
  