Hi,
Someone requested forgot password, here is your new password :
[password]
--
Regards,
Admin
', '[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 = 48 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of cms_logs -- ---------------------------- -- ---------------------------- -- 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 = 3 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'); INSERT INTO `cms_users` VALUES (2, 'Saiful Anwar', NULL, 'saiful.coder@gmail.com', '$2y$10$AtnJU4LKaZP6BHrgVrVecub5XRLVxMX3UdIi/6nPXJ/NRJmQCvNPm', 1, '2023-03-13 16:29:37', 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 = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of device -- ---------------------------- INSERT INTO `device` VALUES (1, 1, '085647166877', 'saiful', NULL, NULL, '2023-06-13 04:10:19', 'AUTHENTICATED', NULL); -- ---------------------------- -- 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(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `created_at` datetime NULL DEFAULT NULL, `id_device` int NULL DEFAULT NULL, `type` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, `url_file` varchar(255) 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 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;