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

START TRANSACTION;



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

--
-- Table structure for table `admin_modules`
--

CREATE TABLE `admin_modules` (
  `am_id` int(11) UNSIGNED NOT NULL,
  `am_name` varchar(100) NOT NULL,
  `am_slug` varchar(100) NOT NULL,
  `am_description` varchar(255) NOT NULL,
  `am_class` varchar(50) NOT NULL,
  `am_method` varchar(50) NOT NULL,
  `am_insert_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `am_update_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(),
  `am_active` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `admin_modules`
--

INSERT INTO `admin_modules` (`am_id`, `am_name`, `am_slug`, `am_description`, `am_class`, `am_method`, `am_insert_at`, `am_update_at`, `am_active`) VALUES
(1, 'Admin Get All', 'admin-get-all', 'Admin Get All', '\\App\\Controllers\\Admin', 'getAll', '2021-07-20 08:40:39', '2022-03-04 07:58:13', 1),
(2, 'Admin Get By ID', 'admin-get-by-id', 'Admin Get By ID', '\\App\\Controllers\\Admin', 'getByID', '2021-07-20 08:40:39', '2021-07-23 15:33:13', 1),
(3, 'Admin Add', 'admin-add', 'Admin Add', '\\App\\Controllers\\Admin', 'addAdmin', '2021-07-20 08:44:28', '2021-07-23 15:33:14', 1),
(4, 'Admin Update', 'admin-update', 'Admin Update', '\\App\\Controllers\\Admin', 'updateAdmin', '2021-07-20 08:44:28', '2021-07-23 15:33:15', 1),
(5, 'Admin Delete', 'admin-delete', 'Admin Delete', '\\App\\Controllers\\Admin', 'deleteAdmin', '2021-07-20 08:44:57', '2021-09-28 05:56:09', 1),
(6, 'Admin Role Get All', 'admin-role-get-all', 'Admin Role Get All', '\\App\\Controllers\\AdminRole', 'getAll', '2021-07-20 08:44:57', '2021-07-23 15:33:18', 1),
(7, 'Admin Role Get By ID', 'admin-role-get-by-id', 'Admin Role Get By ID', '\\App\\Controllers\\AdminRole', 'getByID', '2021-07-20 08:44:57', '2021-07-23 16:10:00', 1),
(8, 'Admin Role Add', 'admin-role-add', 'Admin Role Add', '\\App\\Controllers\\AdminRole', 'addAdminRole', '2021-07-20 08:44:57', '2021-09-28 05:56:53', 1),
(9, 'Admin Role Update', 'admin-role-update', 'Admin Role Update', '\\App\\Controllers\\AdminRole', 'updateAdminRole', '2021-07-20 08:44:57', '2021-09-28 05:56:56', 1),
(10, 'Admin Role Delete', 'admin-role-delete', 'Admin Role Delete', '\\App\\Controllers\\AdminRole', 'deleteAdminRole', '2021-07-20 08:44:57', '2021-09-28 05:57:00', 1),
(11, 'Admin Module Get All', 'admin-module-get-all', 'Admin Module Get All', '\\App\\Controllers\\AdminModule', 'getAll', '2021-07-20 08:44:57', '2021-07-23 15:48:02', 1),
(12, 'Admin Module Get By ID', 'admin-module-get-by-id', 'Admin Module Get By ID', '\\App\\Controllers\\AdminModule', 'getByID', '2021-07-20 08:44:57', '2021-07-23 16:10:02', 1),
(13, 'Admin Module Add', 'admin-module-add', 'Admin Module Add', '\\App\\Controllers\\AdminModule', 'addModule', '2021-07-20 08:44:57', '2021-07-23 15:48:04', 1),
(14, 'Admin Module Update', 'admin-module-update', 'Admin Module Update', '\\App\\Controllers\\AdminModule', 'updateModule', '2021-07-20 08:44:57', '2021-07-23 15:48:05', 1),
(15, 'Admin Module Delete', 'admin-module-delete', 'Admin Module Delete', '\\App\\Controllers\\AdminModule', 'deleteModule', '2021-07-20 08:44:57', '2021-07-23 15:48:06', 1),
(16, 'Admin Role Module Get All', 'admin-role-module-get-all', 'Admin Role Module Get All', '\\App\\Controllers\\AdminRoleModule', 'getAll', '2021-07-20 08:44:57', '2021-07-23 15:48:08', 1),
(17, 'Admin Role Module Get By ID', 'admin-role-module-get-by-id', 'Admin Role Module Get By ID', '\\App\\Controllers\\AdminRoleModule', 'getByID', '2021-07-20 08:44:57', '2021-07-23 16:10:04', 1),
(18, 'Admin Role Module Get By Role ID', 'admin-role-module-get-by-role-id', 'Admin Role Module Get By Role ID', '\\App\\Controllers\\AdminRoleModule', 'getByRoleID', '2021-07-20 08:44:57', '2021-07-23 16:10:10', 1),
(19, 'Admin Role Module Add', 'admin-role-module-add', 'Admin Role Module Add', '\\App\\Controllers\\AdminRoleModule', 'addRoleModule', '2021-07-20 08:44:57', '2021-07-23 15:56:46', 1),
(20, 'Admin Role Module Add Bulk', 'admin-role-module-add-bulk', 'Admin Role Module Add Bulk', '\\App\\Controllers\\AdminRoleModule', 'addRoleModuleBulk', '2021-07-20 08:44:57', '2021-09-28 06:35:43', 1),
(21, 'Admin Role Module Update', 'admin-role-module-update', 'Admin Role Module Update', '\\App\\Controllers\\AdminRoleModule', 'updateRoleModule', '2021-07-20 08:44:57', '2021-09-28 06:35:05', 1),
(22, 'Admin Role Module Delete', 'admin-role-module-delete', 'Admin Role Module Delete', '\\App\\Controllers\\AdminRoleModule', 'deleteRoleModule', '2021-07-20 08:44:57', '2021-09-28 06:35:04', 1),
(23, 'Admin Role Permission Get All', 'admin-role-permission-get-all', 'Admin Role Permission Get All', '\\App\\Controllers\\AdminPermission', 'getAll', '2021-07-20 08:44:57', '2021-09-28 06:35:02', 1),
(24, 'Admin Role Permission Get By ID', 'admin-role-permission-get-by-id', 'Admin Role Permission Get By ID', '\\App\\Controllers\\AdminPermission', 'getByID', '2021-07-20 08:44:57', '2021-09-28 06:34:57', 1),
(25, 'Admin Role Permission Get By Admin ID', 'admin-role-permission-get-by-admin-id', 'Admin Role Permission Get By Admin ID', '\\App\\Controllers\\AdminPermission', 'getByAdminID', '2021-07-20 08:44:57', '2021-09-28 06:34:55', 1),
(26, 'Admin Role Permission Get By Role ID', 'admin-role-permission-get-by-role-id', 'Admin Role Permission Get By Role ID', '\\App\\Controllers\\AdminPermission', 'getByRoleID', '2021-07-20 08:44:57', '2021-09-28 06:34:54', 1),
(27, 'Admin Role Permission Add', 'admin-role-permission-add', 'Admin Role Permission Add', '\\App\\Controllers\\AdminPermission', 'addAdminPermission', '2021-07-20 08:44:57', '2021-12-15 08:15:07', 1),
(28, 'Admin Role Permission Update', 'admin-role-permission-update', 'Admin Role Permission Update', '\\App\\Controllers\\AdminPermission', 'updateAdminPermission', '2021-07-20 08:44:57', '2021-12-15 08:15:12', 1),
(29, 'Admin Role Permission Delete', 'admin-role-permission-delete', 'Admin Role Permission Delete', '\\App\\Controllers\\AdminPermission', 'deleteAdminPermission', '2021-07-20 08:44:57', '2021-12-15 08:15:17', 1),
(30, 'Tree Get All', 'tree-get-all', 'Tree Get All', '\\App\\Controllers\\Tree', 'getAll', '2021-07-20 08:44:57', '2022-05-14 07:00:10', 1),
(31, 'Tree Get By ID', 'tree-get-by-id', 'Tree Get By ID', '\\App\\Controllers\\Tree', 'getByID', '2021-07-20 08:44:57', '2022-05-14 07:00:10', 1),
(32, 'Tree Add', 'tree-add', 'Tree Add', '\\App\\Controllers\\Tree', 'addTree', '2021-07-20 08:44:57', '2022-05-14 07:00:20', 1),
(33, 'Tree Update', 'tree-update', 'Tree Update', '\\App\\Controllers\\Tree', 'updateTree', '2021-07-20 08:44:57', '2022-05-14 07:00:22', 1),
(34, 'Tree Delete', 'tree-delete', 'Tree Delete', '\\App\\Controllers\\Tree', 'deleteTree', '2021-07-20 08:44:57', '2022-05-14 07:00:25', 1),
(35, 'Size Get All', 'size-get-all', 'Size Get All', '\\App\\Controllers\\Size', 'getAll', '2022-05-30 04:20:15', '2022-05-30 04:27:44', 1),
(36, 'Size Get By ID', 'size-get-by-id', 'Size Get By ID', '\\App\\Controllers\\Size', 'getByID', '2022-05-30 04:20:25', '2022-05-30 04:28:05', 1),
(37, 'Size Add', 'size-add', 'Size Add', '\\App\\Controllers\\Size', 'addSize', '2022-05-30 04:20:32', '2022-05-30 04:29:24', 1),
(38, 'Size Update', 'size-update', 'Size Update', '\\App\\Controllers\\Size', 'updateSize', '2022-05-30 04:20:41', '2022-05-30 04:29:30', 1),
(39, 'Size Delete', 'size-delete', 'Size Delete', '\\App\\Controllers\\Size', 'deleteSize', '2022-05-30 04:20:50', '2022-05-30 04:29:36', 1),
(40, 'Category Get All', 'category-get-all', 'Category Get All', '\\App\\Controllers\\Category', 'getAll', '2022-05-30 04:32:51', '2022-05-30 04:48:09', 1),
(41, 'Category Get By ID', 'category-get-by-id', 'Category Get By ID', '\\App\\Controllers\\Category', 'getByID', '2022-05-30 04:32:57', '2022-05-30 04:48:15', 1),
(42, 'Category Add', 'category-add', 'Category Add', '\\App\\Controllers\\Category', 'addCategory', '2022-05-30 04:33:05', '2022-05-30 04:48:30', 1),
(43, 'Category Update', 'category-update', 'Category Update', '\\App\\Controllers\\Category', 'updateCategory', '2022-05-30 04:33:11', '2022-05-30 04:48:42', 1),
(44, 'Category Delete', 'category-delete', 'Category Delete', '\\App\\Controllers\\Category', 'deleteCategory', '2022-05-30 04:33:22', '2022-05-30 04:48:49', 1),
(45, 'Item Get All', 'item-get-all', 'Item Get All', '\\App\\Controllers\\Item', 'getAll', '2022-05-30 07:06:09', '2022-05-30 07:11:57', 1),
(46, 'Item Get By ID', 'item-get-by-id', 'Item Get By ID', '\\App\\Controllers\\Item', 'getByID', '2022-05-30 07:06:11', '2022-05-30 07:12:02', 1),
(47, 'Item Add', 'item-add', 'Item Add', '\\App\\Controllers\\Item', 'addItem', '2022-05-30 07:06:16', '2022-05-30 07:12:15', 1),
(48, 'Item Update', 'item-update', 'Item Update', '\\App\\Controllers\\Item', 'updateItem', '2022-05-30 07:06:20', '2022-05-30 07:12:27', 1),
(49, 'Item Delete', 'item-delete', 'Item Delete', '\\App\\Controllers\\Item', 'deleteItem', '2022-05-30 07:06:23', '2022-05-30 07:12:33', 1),
(50, 'Gold Content Get All', 'gold-content-get-all', 'Gold Content Get All', '\\App\\Controllers\\GoldContent', 'getAll', '2022-05-30 07:16:25', '2022-05-30 07:18:00', 1),
(51, 'Gold Content Get By ID', 'gold-content-get-by-id', 'Gold Content Get By ID', '\\App\\Controllers\\GoldContent', 'getByID', '2022-05-30 07:16:28', '2022-05-30 07:19:56', 1),
(52, 'Gold Content Add', 'gold-content-add', 'Gold Content Add', '\\App\\Controllers\\GoldContent', 'AddGoldContent', '2022-05-30 07:16:32', '2022-05-30 07:23:38', 1),
(53, 'Gold Content Update', 'gold-content-edit', 'Gold Content Edit', '\\App\\Controllers\\GoldContent', 'UpdateGoldContent', '2022-05-30 07:16:35', '2022-05-30 07:24:21', 1),
(54, 'Gold Content Delete', 'gold-content-delete', 'Gold Content Delete', '\\App\\Controllers\\GoldContent', 'DeleteGoldContent', '2022-05-30 07:16:39', '2022-05-30 07:24:15', 1),
(55, 'Workflow Get All', 'workflow-get-all', 'Workflow Get All', '\\App\\Controllers\\Workflow', 'getAll', '2022-05-30 09:58:19', '2022-05-30 10:05:33', 1),
(56, 'Workflow Get By ID', 'workflow-get-by-id', 'Workflow Get By ID', '\\App\\Controllers\\Workflow', 'getByID', '2022-05-30 09:58:22', '2022-05-30 10:31:56', 1),
(57, 'Workflow Add', 'workflow-add', 'Workflow Add', '\\App\\Controllers\\Workflow', 'AddWorkflow', '2022-05-30 09:58:27', '2022-06-04 04:43:22', 1),
(58, 'Workflow Update', 'workflow-update', 'Workflow Update', '\\App\\Controllers\\Workflow', 'UpdateWorkflow', '2022-05-30 09:58:34', '2022-06-04 04:44:15', 1),
(59, 'Workflow Delete', 'workflow-delete', 'Workflow Delete', '\\App\\Controllers\\Workflow', 'DeleteWorkflow', '2022-05-30 09:58:42', '2022-06-04 04:44:27', 1),
(60, 'Order Get All', 'order-get-all', 'Order Get All', '\\App\\Controllers\\Order', 'getAll', '2022-06-04 04:28:58', '2022-06-04 04:33:08', 1),
(61, 'Order Get By ID', 'order-get-by-id', 'Order Get By ID', '\\App\\Controllers\\Order', 'getByID', '2022-06-04 04:29:02', '2022-06-04 04:33:15', 1),
(62, 'Order Add', 'order-add', 'Order Add', '\\App\\Controllers\\Order', 'addOrder', '2022-06-04 04:29:07', '2022-06-04 04:45:40', 1),
(63, 'Order Edit', 'order-edit', 'Order Edit', '\\App\\Controllers\\Order', 'editOrder', '2022-06-04 04:29:13', '2022-06-04 04:45:46', 1),
(64, 'Order Delete', 'order-delete', 'Order Delete', '\\App\\Controllers\\Order', 'deleteOrder', '2022-06-04 04:29:39', '2022-06-04 04:45:55', 1);

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

--
-- Table structure for table `admin_permissions`
--

CREATE TABLE `admin_permissions` (
  `ap_id` int(11) UNSIGNED NOT NULL,
  `ap_admin_id` int(11) UNSIGNED NOT NULL,
  `ap_role_id` int(11) UNSIGNED NOT NULL,
  `ap_insert_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `ap_insert_admin_id` int(11) UNSIGNED NOT NULL,
  `ap_update_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(),
  `ap_update_admin_id` int(11) UNSIGNED DEFAULT NULL,
  `ap_delete_at` timestamp NULL DEFAULT NULL,
  `ap_delete_admin_id` int(11) UNSIGNED DEFAULT NULL,
  `ap_active` int(11) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `admin_permissions`
--

INSERT INTO `admin_permissions` (`ap_id`, `ap_admin_id`, `ap_role_id`, `ap_insert_at`, `ap_insert_admin_id`, `ap_update_at`, `ap_update_admin_id`, `ap_delete_at`, `ap_delete_admin_id`, `ap_active`) VALUES
(1, 1, 1, '2022-05-26 02:03:00', 1, '2022-05-27 02:50:26', NULL, NULL, NULL, 1),
(2, 5, 1, '2022-05-26 14:57:29', 1, '2022-05-27 03:30:27', NULL, '2022-05-27 03:30:27', 1, 0),
(3, 5, 2, '2022-05-27 02:19:50', 1, '2022-05-27 03:30:27', NULL, '2022-05-27 03:30:27', 1, 0),
(4, 5, 2, '2022-05-27 02:19:57', 1, '2022-05-27 03:30:27', NULL, '2022-05-27 03:30:27', 1, 0),
(5, 5, 2, '2022-05-27 02:20:19', 1, '2022-05-27 03:30:27', NULL, '2022-05-27 03:30:27', 1, 0),
(6, 5, 2, '2022-05-27 02:21:02', 1, '2022-05-27 03:30:27', NULL, '2022-05-27 03:30:27', 1, 0),
(7, 5, 1, '2022-05-27 02:24:01', 1, '2022-05-27 03:30:27', NULL, '2022-05-27 03:30:27', 1, 0),
(8, 5, 2, '2022-05-27 02:24:09', 1, '2022-05-27 03:30:27', NULL, '2022-05-27 03:30:27', 1, 0),
(9, 5, 2, '2022-05-27 02:27:59', 1, '2022-05-27 03:30:27', NULL, '2022-05-27 03:30:27', 1, 0),
(10, 5, 1, '2022-05-27 03:30:17', 1, '2022-05-27 03:30:27', NULL, '2022-05-27 03:30:27', 1, 0),
(11, 5, 2, '2022-05-27 03:30:27', 1, NULL, NULL, NULL, NULL, 1);

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

--
-- Table structure for table `admin_roles`
--

CREATE TABLE `admin_roles` (
  `ar_id` int(11) UNSIGNED NOT NULL,
  `ar_name` varchar(50) NOT NULL,
  `ar_slug` varchar(50) NOT NULL,
  `ar_description` varchar(255) NOT NULL,
  `ar_insert_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `ar_insert_admin_id` int(11) UNSIGNED NOT NULL,
  `ar_update_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(),
  `ar_update_admin_id` int(11) UNSIGNED NOT NULL,
  `ar_delete_at` timestamp NULL DEFAULT NULL,
  `ar_delete_admin_id` int(11) UNSIGNED DEFAULT NULL,
  `ar_active` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `admin_roles`
--

INSERT INTO `admin_roles` (`ar_id`, `ar_name`, `ar_slug`, `ar_description`, `ar_insert_at`, `ar_insert_admin_id`, `ar_update_at`, `ar_update_admin_id`, `ar_delete_at`, `ar_delete_admin_id`, `ar_active`) VALUES
(1, 'Master Admin', 'master-admin', 'Master Admin ', '2021-07-23 09:27:20', 1, '2022-05-27 01:55:08', 1, NULL, NULL, 1),
(2, 'Master Role', 'master-role', 'Master Role', '2022-05-27 01:54:31', 1, '2022-05-27 01:55:13', 0, NULL, NULL, 1),
(3, 'Role 2', 'role-2', 'Role 2', '2022-05-27 04:05:39', 1, '2022-05-27 04:21:02', 1, NULL, NULL, 1);

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

--
-- Table structure for table `admin_role_modules`
--

CREATE TABLE `admin_role_modules` (
  `arm_id` int(11) UNSIGNED NOT NULL,
  `arm_role_id` int(11) UNSIGNED NOT NULL,
  `arm_module_id` int(11) UNSIGNED NOT NULL,
  `arm_insert_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `arm_insert_admin_id` int(11) UNSIGNED NOT NULL,
  `arm_update_at` timestamp NULL DEFAULT NULL,
  `arm_update_admin_id` int(11) UNSIGNED DEFAULT NULL,
  `arm_delete_at` timestamp NULL DEFAULT NULL,
  `arm_delete_admin_id` int(11) UNSIGNED DEFAULT NULL,
  `arm_active` int(11) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `admin_role_modules`
--

INSERT INTO `admin_role_modules` (`arm_id`, `arm_role_id`, `arm_module_id`, `arm_insert_at`, `arm_insert_admin_id`, `arm_update_at`, `arm_update_admin_id`, `arm_delete_at`, `arm_delete_admin_id`, `arm_active`) VALUES
(1, 1, 1, '2022-05-26 02:03:28', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(2, 1, 2, '2022-05-26 02:03:30', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(3, 1, 3, '2022-05-26 02:03:42', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(4, 1, 4, '2022-05-26 02:03:45', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(5, 1, 5, '2022-05-26 02:03:56', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(6, 1, 6, '2022-05-26 02:04:12', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(7, 1, 7, '2022-05-26 02:04:24', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(9, 1, 9, '2022-05-26 02:04:39', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(10, 1, 10, '2022-05-26 02:04:44', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(11, 1, 11, '2022-05-26 02:04:47', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(12, 1, 12, '2022-05-26 02:04:48', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(13, 1, 13, '2022-05-26 02:04:49', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(14, 1, 14, '2022-05-26 02:04:50', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(15, 1, 15, '2022-05-26 02:04:51', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(16, 1, 16, '2022-05-26 02:04:52', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(17, 1, 17, '2022-05-26 02:04:53', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(18, 1, 18, '2022-05-26 02:04:54', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(19, 1, 19, '2022-05-26 02:04:54', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(20, 1, 20, '2022-05-26 02:04:54', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(21, 1, 21, '2022-05-26 02:05:09', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(22, 1, 22, '2022-05-26 02:05:11', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(23, 1, 23, '2022-05-26 02:05:13', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(24, 1, 24, '2022-05-26 02:05:14', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(25, 1, 25, '2022-05-26 02:06:42', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(26, 1, 26, '2022-05-26 02:06:44', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(27, 1, 27, '2022-05-26 02:06:45', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(28, 1, 28, '2022-05-26 02:06:47', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(29, 1, 29, '2022-05-26 02:06:48', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(30, 3, 1, '2022-05-27 04:05:39', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(31, 3, 2, '2022-05-27 04:05:39', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(32, 3, 3, '2022-05-27 04:05:39', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(33, 3, 4, '2022-05-27 04:05:39', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(34, 3, 5, '2022-05-27 04:05:39', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(35, 3, 6, '2022-05-27 04:05:39', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(36, 3, 7, '2022-05-27 04:05:39', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(37, 3, 8, '2022-05-27 04:05:39', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(38, 3, 9, '2022-05-27 04:05:39', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(39, 3, 10, '2022-05-27 04:05:39', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(40, 3, 11, '2022-05-27 04:05:39', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(41, 3, 12, '2022-05-27 04:05:39', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(42, 3, 13, '2022-05-27 04:05:39', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(43, 3, 14, '2022-05-27 04:05:39', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(44, 3, 15, '2022-05-27 04:05:39', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(45, 3, 16, '2022-05-27 04:05:39', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(46, 3, 17, '2022-05-27 04:05:39', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(47, 3, 18, '2022-05-27 04:05:39', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(48, 3, 19, '2022-05-27 04:05:39', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(49, 3, 20, '2022-05-27 04:05:39', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(50, 3, 21, '2022-05-27 04:05:39', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(51, 3, 22, '2022-05-27 04:05:39', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(52, 3, 23, '2022-05-27 04:05:39', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(53, 3, 24, '2022-05-27 04:05:39', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(54, 3, 25, '2022-05-27 04:05:39', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(55, 3, 26, '2022-05-27 04:05:39', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(56, 3, 27, '2022-05-27 04:05:39', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(57, 3, 28, '2022-05-27 04:05:39', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(58, 3, 29, '2022-05-27 04:05:39', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(59, 3, 30, '2022-05-27 04:05:39', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(60, 3, 31, '2022-05-27 04:05:39', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(61, 3, 32, '2022-05-27 04:05:39', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(62, 3, 33, '2022-05-27 04:05:39', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(63, 3, 34, '2022-05-27 04:05:39', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(64, 3, 1, '2022-05-27 04:21:02', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(65, 3, 2, '2022-05-27 04:21:02', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(66, 3, 3, '2022-05-27 04:21:02', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(67, 3, 4, '2022-05-27 04:21:02', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(68, 3, 5, '2022-05-27 04:21:02', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(69, 3, 6, '2022-05-27 04:21:02', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(70, 3, 7, '2022-05-27 04:21:02', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(71, 3, 8, '2022-05-27 04:21:02', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(72, 3, 9, '2022-05-27 04:21:02', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(73, 3, 10, '2022-05-27 04:21:02', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(74, 3, 11, '2022-05-27 04:21:02', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(75, 3, 12, '2022-05-27 04:21:02', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(76, 3, 13, '2022-05-27 04:21:02', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(77, 3, 14, '2022-05-27 04:21:02', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(78, 3, 15, '2022-05-27 04:21:02', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(79, 3, 16, '2022-05-27 04:21:02', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(80, 3, 17, '2022-05-27 04:21:02', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(81, 3, 18, '2022-05-27 04:21:02', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(82, 3, 19, '2022-05-27 04:21:02', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(83, 3, 20, '2022-05-27 04:21:02', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(84, 3, 21, '2022-05-27 04:21:02', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(85, 3, 22, '2022-05-27 04:21:02', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(86, 3, 23, '2022-05-27 04:21:02', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(87, 3, 24, '2022-05-27 04:21:02', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(88, 3, 25, '2022-05-27 04:21:02', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(89, 3, 26, '2022-05-27 04:21:02', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(90, 3, 27, '2022-05-27 04:21:02', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(91, 3, 28, '2022-05-27 04:21:02', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(92, 3, 29, '2022-05-27 04:21:02', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(93, 3, 30, '2022-05-27 04:21:02', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(94, 3, 31, '2022-05-27 04:21:02', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(95, 3, 32, '2022-05-27 04:21:02', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(96, 3, 33, '2022-05-27 04:21:02', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(97, 3, 34, '2022-05-27 04:21:02', 1, NULL, NULL, '2022-05-27 04:21:24', 1, 0),
(98, 3, 1, '2022-05-27 04:21:24', 1, NULL, NULL, NULL, NULL, 1),
(99, 3, 2, '2022-05-27 04:21:24', 1, NULL, NULL, NULL, NULL, 1),
(100, 3, 3, '2022-05-27 04:21:24', 1, NULL, NULL, NULL, NULL, 1),
(101, 3, 4, '2022-05-27 04:21:24', 1, NULL, NULL, NULL, NULL, 1),
(102, 3, 5, '2022-05-27 04:21:24', 1, NULL, NULL, NULL, NULL, 1),
(103, 3, 6, '2022-05-27 04:21:24', 1, NULL, NULL, NULL, NULL, 1),
(104, 3, 7, '2022-05-27 04:21:24', 1, NULL, NULL, NULL, NULL, 1),
(105, 3, 8, '2022-05-27 04:21:24', 1, NULL, NULL, NULL, NULL, 1),
(106, 3, 9, '2022-05-27 04:21:24', 1, NULL, NULL, NULL, NULL, 1),
(107, 3, 10, '2022-05-27 04:21:24', 1, NULL, NULL, NULL, NULL, 1),
(108, 3, 11, '2022-05-27 04:21:24', 1, NULL, NULL, NULL, NULL, 1),
(109, 3, 12, '2022-05-27 04:21:24', 1, NULL, NULL, NULL, NULL, 1),
(110, 3, 13, '2022-05-27 04:21:24', 1, NULL, NULL, NULL, NULL, 1),
(111, 3, 14, '2022-05-27 04:21:24', 1, NULL, NULL, NULL, NULL, 1),
(112, 3, 15, '2022-05-27 04:21:24', 1, NULL, NULL, NULL, NULL, 1),
(113, 3, 16, '2022-05-27 04:21:24', 1, NULL, NULL, NULL, NULL, 1),
(114, 3, 17, '2022-05-27 04:21:24', 1, NULL, NULL, NULL, NULL, 1),
(115, 3, 18, '2022-05-27 04:21:24', 1, NULL, NULL, NULL, NULL, 1),
(116, 3, 19, '2022-05-27 04:21:24', 1, NULL, NULL, NULL, NULL, 1),
(117, 3, 20, '2022-05-27 04:21:24', 1, NULL, NULL, NULL, NULL, 1),
(118, 3, 21, '2022-05-27 04:21:24', 1, NULL, NULL, NULL, NULL, 1),
(119, 3, 22, '2022-05-27 04:21:24', 1, NULL, NULL, NULL, NULL, 1),
(120, 3, 23, '2022-05-27 04:21:24', 1, NULL, NULL, NULL, NULL, 1),
(121, 3, 24, '2022-05-27 04:21:24', 1, NULL, NULL, NULL, NULL, 1),
(122, 3, 25, '2022-05-27 04:21:24', 1, NULL, NULL, NULL, NULL, 1),
(123, 3, 26, '2022-05-27 04:21:24', 1, NULL, NULL, NULL, NULL, 1),
(124, 3, 27, '2022-05-27 04:21:24', 1, NULL, NULL, NULL, NULL, 1),
(125, 3, 28, '2022-05-27 04:21:24', 1, NULL, NULL, NULL, NULL, 1),
(126, 3, 29, '2022-05-27 04:21:24', 1, NULL, NULL, NULL, NULL, 1),
(127, 3, 30, '2022-05-27 04:21:24', 1, NULL, NULL, NULL, NULL, 1),
(128, 3, 31, '2022-05-27 04:21:24', 1, NULL, NULL, NULL, NULL, 1),
(129, 3, 32, '2022-05-27 04:21:24', 1, NULL, NULL, NULL, NULL, 1),
(130, 3, 33, '2022-05-27 04:21:24', 1, NULL, NULL, NULL, NULL, 1),
(131, 3, 34, '2022-05-27 04:21:24', 1, NULL, NULL, NULL, NULL, 1),
(132, 1, 1, '2022-05-30 01:25:40', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(133, 1, 2, '2022-05-30 01:25:40', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(134, 1, 3, '2022-05-30 01:25:40', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(135, 1, 4, '2022-05-30 01:25:40', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(136, 1, 5, '2022-05-30 01:25:40', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(137, 1, 6, '2022-05-30 01:25:40', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(138, 1, 7, '2022-05-30 01:25:40', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(139, 1, 8, '2022-05-30 01:25:40', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(140, 1, 9, '2022-05-30 01:25:40', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(141, 1, 10, '2022-05-30 01:25:40', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(142, 1, 11, '2022-05-30 01:25:40', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(143, 1, 12, '2022-05-30 01:25:40', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(144, 1, 13, '2022-05-30 01:25:40', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(145, 1, 14, '2022-05-30 01:25:40', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(146, 1, 15, '2022-05-30 01:25:40', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(147, 1, 16, '2022-05-30 01:25:40', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(148, 1, 17, '2022-05-30 01:25:40', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(149, 1, 18, '2022-05-30 01:25:40', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(150, 1, 19, '2022-05-30 01:25:40', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(151, 1, 20, '2022-05-30 01:25:40', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(152, 1, 21, '2022-05-30 01:25:40', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(153, 1, 22, '2022-05-30 01:25:40', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(154, 1, 23, '2022-05-30 01:25:40', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(155, 1, 24, '2022-05-30 01:25:40', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(156, 1, 25, '2022-05-30 01:25:40', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(157, 1, 26, '2022-05-30 01:25:40', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(158, 1, 27, '2022-05-30 01:25:40', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(159, 1, 28, '2022-05-30 01:25:40', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(160, 1, 29, '2022-05-30 01:25:40', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(161, 1, 30, '2022-05-30 01:25:40', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(162, 1, 31, '2022-05-30 01:25:40', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(163, 1, 32, '2022-05-30 01:25:40', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(164, 1, 33, '2022-05-30 01:25:40', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(165, 1, 34, '2022-05-30 01:25:40', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(166, 1, 1, '2022-05-30 04:56:19', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(167, 1, 2, '2022-05-30 04:56:19', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(168, 1, 3, '2022-05-30 04:56:19', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(169, 1, 4, '2022-05-30 04:56:19', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(170, 1, 5, '2022-05-30 04:56:19', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(171, 1, 6, '2022-05-30 04:56:19', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(172, 1, 7, '2022-05-30 04:56:19', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(173, 1, 8, '2022-05-30 04:56:19', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(174, 1, 9, '2022-05-30 04:56:19', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(175, 1, 10, '2022-05-30 04:56:19', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(176, 1, 11, '2022-05-30 04:56:19', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(177, 1, 12, '2022-05-30 04:56:19', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(178, 1, 13, '2022-05-30 04:56:19', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(179, 1, 14, '2022-05-30 04:56:19', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(180, 1, 15, '2022-05-30 04:56:19', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(181, 1, 16, '2022-05-30 04:56:19', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(182, 1, 17, '2022-05-30 04:56:19', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(183, 1, 18, '2022-05-30 04:56:19', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(184, 1, 19, '2022-05-30 04:56:19', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(185, 1, 20, '2022-05-30 04:56:19', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(186, 1, 21, '2022-05-30 04:56:19', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(187, 1, 22, '2022-05-30 04:56:19', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(188, 1, 23, '2022-05-30 04:56:19', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(189, 1, 24, '2022-05-30 04:56:19', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(190, 1, 25, '2022-05-30 04:56:19', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(191, 1, 26, '2022-05-30 04:56:19', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(192, 1, 27, '2022-05-30 04:56:19', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(193, 1, 28, '2022-05-30 04:56:19', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(194, 1, 29, '2022-05-30 04:56:19', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(195, 1, 30, '2022-05-30 04:56:19', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(196, 1, 31, '2022-05-30 04:56:19', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(197, 1, 32, '2022-05-30 04:56:19', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(198, 1, 33, '2022-05-30 04:56:19', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(199, 1, 34, '2022-05-30 04:56:19', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(200, 1, 35, '2022-05-30 04:56:19', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(201, 1, 36, '2022-05-30 04:56:19', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(202, 1, 37, '2022-05-30 04:56:19', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(203, 1, 38, '2022-05-30 04:56:19', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(204, 1, 39, '2022-05-30 04:56:19', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(205, 1, 40, '2022-05-30 04:56:19', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(206, 1, 41, '2022-05-30 04:56:19', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(207, 1, 42, '2022-05-30 04:56:19', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(208, 1, 43, '2022-05-30 04:56:19', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(209, 1, 44, '2022-05-30 04:56:19', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(210, 1, 1, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(211, 1, 2, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(212, 1, 3, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(213, 1, 4, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(214, 1, 5, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(215, 1, 6, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(216, 1, 7, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(217, 1, 8, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(218, 1, 9, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(219, 1, 10, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(220, 1, 11, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(221, 1, 12, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(222, 1, 13, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(223, 1, 14, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(224, 1, 15, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(225, 1, 16, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(226, 1, 17, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(227, 1, 18, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(228, 1, 19, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(229, 1, 20, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(230, 1, 21, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(231, 1, 22, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(232, 1, 23, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(233, 1, 24, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(234, 1, 25, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(235, 1, 26, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(236, 1, 27, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(237, 1, 28, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(238, 1, 29, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(239, 1, 30, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(240, 1, 31, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(241, 1, 32, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(242, 1, 33, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(243, 1, 34, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(244, 1, 35, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(245, 1, 36, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(246, 1, 37, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(247, 1, 38, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(248, 1, 39, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(249, 1, 40, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(250, 1, 41, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(251, 1, 42, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(252, 1, 43, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(253, 1, 44, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(254, 1, 45, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(255, 1, 46, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(256, 1, 47, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(257, 1, 48, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(258, 1, 49, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(259, 1, 50, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(260, 1, 51, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(261, 1, 52, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(262, 1, 53, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(263, 1, 54, '2022-05-30 07:30:08', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(264, 1, 1, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(265, 1, 2, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(266, 1, 3, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(267, 1, 4, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(268, 1, 5, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(269, 1, 6, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(270, 1, 7, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(271, 1, 8, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(272, 1, 9, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(273, 1, 10, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(274, 1, 11, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(275, 1, 12, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(276, 1, 13, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(277, 1, 14, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(278, 1, 15, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(279, 1, 16, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(280, 1, 17, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(281, 1, 18, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(282, 1, 19, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(283, 1, 20, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(284, 1, 21, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(285, 1, 22, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(286, 1, 23, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(287, 1, 24, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(288, 1, 25, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(289, 1, 26, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(290, 1, 27, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(291, 1, 28, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(292, 1, 29, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(293, 1, 30, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(294, 1, 31, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(295, 1, 32, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(296, 1, 33, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(297, 1, 34, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(298, 1, 35, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(299, 1, 36, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(300, 1, 37, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(301, 1, 38, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(302, 1, 39, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(303, 1, 40, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(304, 1, 41, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(305, 1, 42, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(306, 1, 43, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(307, 1, 44, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(308, 1, 45, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(309, 1, 46, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(310, 1, 47, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(311, 1, 48, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(312, 1, 49, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(313, 1, 50, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(314, 1, 51, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(315, 1, 52, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(316, 1, 53, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(317, 1, 54, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(318, 1, 55, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(319, 1, 56, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(320, 1, 57, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(321, 1, 58, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(322, 1, 59, '2022-05-31 04:14:43', 1, NULL, NULL, '2022-06-04 04:34:48', 1, 0),
(323, 1, 1, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(324, 1, 2, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(325, 1, 3, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(326, 1, 4, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(327, 1, 5, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(328, 1, 6, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(329, 1, 7, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(330, 1, 8, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(331, 1, 9, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(332, 1, 10, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(333, 1, 11, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(334, 1, 12, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(335, 1, 13, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(336, 1, 14, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(337, 1, 15, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(338, 1, 16, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(339, 1, 17, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(340, 1, 18, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(341, 1, 19, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(342, 1, 20, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(343, 1, 21, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(344, 1, 22, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(345, 1, 23, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(346, 1, 24, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(347, 1, 25, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(348, 1, 26, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(349, 1, 27, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(350, 1, 28, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(351, 1, 29, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(352, 1, 30, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(353, 1, 31, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(354, 1, 32, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(355, 1, 33, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(356, 1, 34, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(357, 1, 35, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(358, 1, 36, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(359, 1, 37, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(360, 1, 38, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(361, 1, 39, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(362, 1, 40, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(363, 1, 41, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(364, 1, 42, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(365, 1, 43, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(366, 1, 44, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(367, 1, 45, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(368, 1, 46, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(369, 1, 47, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(370, 1, 48, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(371, 1, 49, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(372, 1, 50, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(373, 1, 51, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(374, 1, 52, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(375, 1, 53, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(376, 1, 54, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(377, 1, 55, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(378, 1, 56, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(379, 1, 57, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(380, 1, 58, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(381, 1, 59, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(382, 1, 60, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(383, 1, 61, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(384, 1, 62, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(385, 1, 63, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1),
(386, 1, 64, '2022-06-04 04:34:48', 1, NULL, NULL, NULL, NULL, 1);

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `category_id` int(11) NOT NULL,
  `category_code` varchar(255) NOT NULL,
  `category_name` varchar(255) NOT NULL,
  `category_insert_at` timestamp NULL DEFAULT current_timestamp(),
  `category_insert_admin_id` int(11) DEFAULT NULL,
  `category_update_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `category_update_admin_id` int(11) DEFAULT NULL,
  `category_delete_at` timestamp NULL DEFAULT NULL,
  `category_delete_admin_id` int(11) DEFAULT NULL,
  `category_active` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`category_id`, `category_code`, `category_name`, `category_insert_at`, `category_insert_admin_id`, `category_update_at`, `category_update_admin_id`, `category_delete_at`, `category_delete_admin_id`, `category_active`) VALUES
(1, 'test', 'test', '2022-05-30 04:30:32', NULL, '2022-05-30 08:10:06', 1, NULL, NULL, 1),
(2, 'sdsd', 'sdsd', '2022-05-30 08:20:03', 1, '2022-05-30 08:20:03', NULL, NULL, NULL, 1),
(3, 'sd', 'sd', '2022-05-30 08:20:19', 1, '2022-05-30 08:20:19', NULL, NULL, NULL, 1),
(4, 'sddd', 'sddd', '2022-05-30 08:20:21', 1, '2022-05-30 08:20:21', NULL, NULL, NULL, 1),
(5, 'sddddd', 'sddddd', '2022-05-30 08:20:22', 1, '2022-05-30 08:20:22', NULL, NULL, NULL, 1),
(6, 'sddddds', 'sddddds', '2022-05-30 08:20:25', 1, '2022-05-30 08:20:25', NULL, NULL, NULL, 1);

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

--
-- Table structure for table `customers`
--

CREATE TABLE `customers` (
  `customer_id` int(11) NOT NULL,
  `customer_type` varchar(255) NOT NULL,
  `customer_code` varchar(255) NOT NULL,
  `customer_name` varchar(255) NOT NULL,
  `customer_address` varchar(255) NOT NULL,
  `customer_bank` varchar(255) NOT NULL,
  `customer_bank_account_no` varchar(255) NOT NULL,
  `customer_bank_account_name` varchar(255) NOT NULL,
  `customer_email` varchar(255) NOT NULL,
  `customer_phone` varchar(255) NOT NULL,
  `customer_insert_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `customer_insert_admin_id` int(11) NOT NULL,
  `customer_update_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `customer_update_admin_id` int(11) DEFAULT NULL,
  `customer_delete_at` timestamp NULL DEFAULT NULL,
  `customer_delete_admin_id` int(11) DEFAULT NULL,
  `customer_active` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `customers` (`customer_id`, `customer_type`, `customer_code`, `customer_name`, `customer_address`, `customer_bank`, `customer_bank_account_no`, `customer_bank_account_name`, `customer_email`, `customer_phone`, `customer_insert_at`, `customer_insert_admin_id`, `customer_update_at`, `customer_update_admin_id`, `customer_delete_at`, `customer_delete_admin_id`, `customer_active`) VALUES
(1, 'Toko', '121212', 'Alif', 'Klaten', 'BCA', '2348997789', 'Alif', 'fmuhalif12@gmail.com', '08633737388', '2022-06-04 05:22:38', 1, '2022-06-04 05:22:50', NULL, NULL, NULL, 1);

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

--
-- Table structure for table `gold_contents`
--

CREATE TABLE `gold_contents` (
  `gc_id` int(11) NOT NULL,
  `gc_code` varchar(25) NOT NULL,
  `gc_name` varchar(255) NOT NULL,
  `gc_multiplier` decimal(65,2) NOT NULL,
  `gc_insert_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `gc_insert_admin_id` int(11) NOT NULL,
  `gc_update_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `gc_update_admin_id` int(11) DEFAULT NULL,
  `gc_delete_at` timestamp NULL DEFAULT NULL,
  `gc_delete_admin_id` int(11) DEFAULT NULL,
  `gc_active` int(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `gold_contents`
--

INSERT INTO `gold_contents` (`gc_id`, `gc_code`, `gc_name`, `gc_multiplier`, `gc_insert_at`, `gc_insert_admin_id`, `gc_update_at`, `gc_update_admin_id`, `gc_delete_at`, `gc_delete_admin_id`, `gc_active`) VALUES
(1, 'test', 'test', '23.00', '2022-05-30 09:14:21', 1, '2022-05-30 09:29:50', NULL, '2022-05-30 09:29:50', 1, 0),
(2, 'ddd33', 'ddd33', '12.00', '2022-05-30 09:28:12', 1, '2022-05-30 09:29:55', 1, NULL, NULL, 1);

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

--
-- Table structure for table `gold_content_histories`
--

CREATE TABLE `gold_content_histories` (
  `gch_id` int(11) NOT NULL,
  `gch_gc_id` int(11) NOT NULL,
  `gch_multiplier_from` decimal(65,2) NOT NULL,
  `gch_multiplier_to` decimal(65,2) NOT NULL,
  `gch_description` varchar(255) NOT NULL,
  `gch_update_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `gch_update_admin_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `items`
--

CREATE TABLE `items` (
  `item_id` int(11) NOT NULL,
  `item_sku` varchar(255) NOT NULL,
  `item_name` varchar(255) NOT NULL,
  `item_workflow_id` int(11) DEFAULT NULL,
  `item_category_id` int(11) NOT NULL,
  `item_gc_id` int(11) NOT NULL,
  `item_weight` decimal(65,2) NOT NULL,
  `item_size_id` int(11) NOT NULL,
  `item_stone_type` varchar(255) NOT NULL,
  `item_use_wire` varchar(255) NOT NULL,
  `item_image_1` varchar(255) NOT NULL,
  `item_image_2` int(11) NOT NULL,
  `item_image_3` varchar(255) NOT NULL,
  `item_print_no` varchar(255) NOT NULL,
  `item_cad_file` varchar(255) NOT NULL,
  `item_insert_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `item_insert_admin_id` int(11) NOT NULL,
  `item_update_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `item_update_admin_id` int(11) DEFAULT NULL,
  `item_delete_at` timestamp NULL DEFAULT NULL,
  `item_delete_admin_id` int(11) DEFAULT NULL,
  `item_active` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `items`
--

INSERT INTO `items` (`item_id`, `item_sku`, `item_name`, `item_workflow_id`, `item_category_id`, `item_gc_id`, `item_weight`, `item_size_id`, `item_stone_type`, `item_use_wire`, `item_image_1`, `item_image_2`, `item_image_3`, `item_print_no`, `item_cad_file`, `item_insert_at`, `item_insert_admin_id`, `item_update_at`, `item_update_admin_id`, `item_delete_at`, `item_delete_admin_id`, `item_active`) VALUES
(1, 'cek', 'cek', 2, 6, 2, '12.00', 6, '123', '12', '', 0, '', '123', '123', '2022-06-02 07:08:49', 1, '2022-06-02 07:58:32', NULL, '2022-06-02 07:58:32', 1, 0),
(2, 'test', 'test', 2, 5, 2, '22.00', 6, '123', '123', '', 0, '', '123', '123', '2022-06-02 07:58:26', 1, '2022-06-02 07:58:26', NULL, NULL, NULL, 1);

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

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `order_id` int(11) NOT NULL,
  `order_note` varchar(255) NOT NULL,
  `order_customer_id` int(11) NOT NULL,
  `order_date` date NOT NULL,
  `order_due_date` date NOT NULL,
  `order_description` varchar(255) NOT NULL,
  `order_status` varchar(25) NOT NULL,
  `order_insert_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `order_insert_admin_id` int(11) NOT NULL,
  `order_update_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `order_update_admin_id` int(11) DEFAULT NULL,
  `order_delete_at` timestamp NULL DEFAULT NULL,
  `order_delete_admin_id` int(11) DEFAULT NULL,
  `order_active` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `orders`
--

INSERT INTO `orders` (`order_id`, `order_note`, `order_customer_id`, `order_date`, `order_due_date`, `order_description`, `order_status`, `order_insert_at`, `order_insert_admin_id`, `order_update_at`, `order_update_admin_id`, `order_delete_at`, `order_delete_admin_id`, `order_active`) VALUES
(1, '2357890', 1, '2022-06-04', '2022-06-04', 'cek', '', '2022-06-04 06:04:56', 1, '2022-06-04 06:04:56', NULL, NULL, NULL, 1);

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

--
-- Table structure for table `order_items`
--

CREATE TABLE `order_items` (
  `oi_id` int(11) NOT NULL,
  `oi_order_id` int(11) DEFAULT NULL,
  `oi_item_id` int(11) NOT NULL,
  `oi_date` date NOT NULL,
  `oi_start_date` date DEFAULT NULL,
  `oi_due_date` date NOT NULL,
  `oi_completed_date` date DEFAULT NULL,
  `oi_item_name` varchar(255) NOT NULL,
  `oi_gc_id` int(11) NOT NULL,
  `oi_size_id` int(11) NOT NULL,
  `oi_weight` decimal(65,2) NOT NULL,
  `oi_quantity` int(11) NOT NULL,
  `oi_description` varchar(255) NOT NULL,
  `oi_sample_note` varchar(255) NOT NULL,
  `oi_image_1` varchar(255) NOT NULL,
  `oi_image_2` varchar(255) NOT NULL,
  `oi_status` varchar(25) NOT NULL,
  `oi_insert_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `oi_insert_admin_id` int(11) NOT NULL,
  `oi_update_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `oi_update_admin_id` int(11) DEFAULT NULL,
  `oi_delete_at` timestamp NULL DEFAULT NULL,
  `oi_delete_admin_id` int(11) DEFAULT NULL,
  `oi_active` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `sizes`
--

CREATE TABLE `sizes` (
  `size_id` int(11) NOT NULL,
  `size_code` varchar(255) NOT NULL,
  `size_name` varchar(255) NOT NULL,
  `size_insert_at` timestamp NULL DEFAULT current_timestamp(),
  `size_insert_admin_id` int(11) DEFAULT NULL,
  `size_update_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `size_update_admin_id` int(11) DEFAULT NULL,
  `size_delete_at` timestamp NULL DEFAULT NULL,
  `size_delete_admin_id` int(11) DEFAULT NULL,
  `size_active` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `sizes`
--

INSERT INTO `sizes` (`size_id`, `size_code`, `size_name`, `size_insert_at`, `size_insert_admin_id`, `size_update_at`, `size_update_admin_id`, `size_delete_at`, `size_delete_admin_id`, `size_active`) VALUES
(1, 'test', 'test', '2022-05-30 07:46:07', 1, '2022-05-30 07:47:17', NULL, '2022-05-30 07:47:17', 1, 0),
(2, 'test233', 'test233', '2022-05-30 07:47:14', 1, '2022-05-30 07:50:39', 1, NULL, NULL, 1),
(3, 'tete', 'tete', '2022-05-30 08:11:00', 1, '2022-05-30 08:11:00', NULL, NULL, NULL, 1),
(4, 'ttw', 'ttw', '2022-05-30 08:12:27', 1, '2022-05-30 08:12:27', NULL, NULL, NULL, 1),
(5, 'test2', 'test2', '2022-05-30 08:17:11', 1, '2022-05-30 08:17:11', NULL, NULL, NULL, 1),
(6, 'test2d', 'test2d', '2022-05-30 08:17:59', 1, '2022-05-30 08:17:59', NULL, NULL, NULL, 1);

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

--
-- Table structure for table `tasks`
--

CREATE TABLE `tasks` (
  `task_id` int(11) NOT NULL,
  `task_code` varchar(255) NOT NULL,
  `task_name` varchar(255) NOT NULL,
  `task_input_list` varchar(255) NOT NULL,
  `task_output_list` varchar(255) NOT NULL,
  `task_input_notification_list` varchar(255) NOT NULL,
  `task_output_notification_list` varchar(255) NOT NULL,
  `task_pic_admin_id` int(11) NOT NULL,
  `task_insert_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `task_insert_admin_id` int(11) NOT NULL,
  `task_update_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `task_update_admin_id` int(11) DEFAULT NULL,
  `task_delete_at` timestamp NULL DEFAULT NULL,
  `task_delete_admin_id` int(11) DEFAULT NULL,
  `task_active` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `trees`
--

CREATE TABLE `trees` (
  `tree_id` int(11) NOT NULL,
  `tree_code` varchar(255) NOT NULL,
  `tree_name` varchar(255) NOT NULL,
  `tree_weight` decimal(65,2) NOT NULL,
  `tree_insert_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `tree_insert_admin_id` int(11) NOT NULL,
  `tree_update_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(),
  `tree_update_admin_id` int(11) NOT NULL,
  `tree_delete_at` timestamp NULL DEFAULT NULL,
  `tree_delete_admin_id` int(11) NOT NULL,
  `tree_active` int(11) DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `trees`
--

INSERT INTO `trees` (`tree_id`, `tree_code`, `tree_name`, `tree_weight`, `tree_insert_at`, `tree_insert_admin_id`, `tree_update_at`, `tree_update_admin_id`, `tree_delete_at`, `tree_delete_admin_id`, `tree_active`) VALUES
(1, 'Coba', 'Coba', '12.00', '2022-05-30 02:35:35', 1, '2022-05-30 03:39:37', 0, '2022-05-30 03:39:37', 1, 0),
(2, 'Cobq', 'Cobq', '12.00', '2022-05-30 02:50:13', 1, '2022-05-30 03:39:42', 0, '2022-05-30 03:39:42', 1, 0),
(3, 'coba-2', 'coba-2', '12.00', '2022-05-30 02:50:29', 1, NULL, 0, NULL, 0, 1),
(4, 'tree3', 'tree3', '12.00', '2022-05-30 02:53:00', 1, NULL, 0, NULL, 0, 1),
(5, 'tree-2', 'Tree 2', '22.00', '2022-05-30 03:00:06', 1, '2022-05-30 03:38:28', 1, NULL, 0, 1);

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

--
-- Table structure for table `tree_histories`
--

CREATE TABLE `tree_histories` (
  `th_id` int(11) NOT NULL,
  `th_tree_id` int(11) NOT NULL,
  `th_weight_from` decimal(65,2) NOT NULL,
  `th_weight_to` decimal(65,2) NOT NULL,
  `th_description` varchar(255) NOT NULL,
  `th_update_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `th_update_admin_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `workflows`
--

CREATE TABLE `workflows` (
  `workflow_id` int(11) NOT NULL,
  `workflow_code` varchar(255) NOT NULL,
  `workflow_name` varchar(255) NOT NULL,
  `workflow_insert_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `workflow_insert_admin_id` int(11) NOT NULL,
  `workflow_update_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `workflow_update_admin_id` int(11) DEFAULT NULL,
  `workflow_delete_at` timestamp NULL DEFAULT NULL,
  `workflow_delete_admin_id` int(11) DEFAULT NULL,
  `workflow_active` int(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `workflows`
--

INSERT INTO `workflows` (`workflow_id`, `workflow_code`, `workflow_name`, `workflow_insert_at`, `workflow_insert_admin_id`, `workflow_update_at`, `workflow_update_admin_id`, `workflow_delete_at`, `workflow_delete_admin_id`, `workflow_active`) VALUES
(1, '22222-aaa', '22222 aaa', '2022-05-31 04:19:13', 1, '2022-05-31 04:20:41', 1, '2022-05-31 04:20:41', 1, 0),
(2, 'tets', 'tets', '2022-06-02 06:52:51', 1, '2022-06-02 06:52:51', NULL, NULL, NULL, 1);

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

--
-- Table structure for table `workflow_tasks`
--

CREATE TABLE `workflow_tasks` (
  `wt_id` int(11) NOT NULL,
  `wt_workflow_id` int(11) NOT NULL,
  `wt_task_id` int(11) NOT NULL,
  `wt_order` int(11) NOT NULL,
  `wt_insert_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `wt_insert_admin_id` int(11) NOT NULL,
  `wt_update_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(),
  `wt_update_admin_id` int(11) DEFAULT NULL,
  `wt_delete_at` timestamp NULL DEFAULT NULL,
  `wt_delete_admin_id` int(11) DEFAULT NULL,
  `wt_active` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Indexes for table `admin_modules`
--
ALTER TABLE `admin_modules`
  ADD PRIMARY KEY (`am_id`),
  ADD KEY `am_slug` (`am_slug`),
  ADD KEY `am_class` (`am_class`),
  ADD KEY `am_method` (`am_method`);

--
-- Indexes for table `admin_permissions`
--
ALTER TABLE `admin_permissions`
  ADD PRIMARY KEY (`ap_id`),
  ADD KEY `ap_admin_id` (`ap_admin_id`),
  ADD KEY `ap_role_id` (`ap_role_id`);

--
-- Indexes for table `admin_roles`
--
ALTER TABLE `admin_roles`
  ADD PRIMARY KEY (`ar_id`),
  ADD KEY `ar_slug` (`ar_slug`);

--
-- Indexes for table `admin_role_modules`
--
ALTER TABLE `admin_role_modules`
  ADD PRIMARY KEY (`arm_id`),
  ADD KEY `arm_role_id` (`arm_role_id`),
  ADD KEY `arm_module_id` (`arm_module_id`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`category_id`);

--
-- Indexes for table `customers`
--
ALTER TABLE `customers`
  ADD PRIMARY KEY (`customer_id`),
  ADD KEY `customer_code` (`customer_code`),
  ADD KEY `customer_name` (`customer_name`);

--
-- Indexes for table `gold_contents`
--
ALTER TABLE `gold_contents`
  ADD PRIMARY KEY (`gc_id`);

--
-- Indexes for table `gold_content_histories`
--
ALTER TABLE `gold_content_histories`
  ADD PRIMARY KEY (`gch_id`),
  ADD KEY `gch_gc_id` (`gch_gc_id`);

--
-- Indexes for table `items`
--
ALTER TABLE `items`
  ADD PRIMARY KEY (`item_id`),
  ADD KEY `item_sku` (`item_sku`),
  ADD KEY `item_category_id` (`item_category_id`),
  ADD KEY `item_gc_id` (`item_gc_id`),
  ADD KEY `item_size_id` (`item_size_id`);

--
-- Indexes for table `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`order_id`),
  ADD KEY `order_note` (`order_note`),
  ADD KEY `order_customer_id` (`order_customer_id`);

--
-- Indexes for table `order_items`
--
ALTER TABLE `order_items`
  ADD PRIMARY KEY (`oi_id`),
  ADD KEY `oi_item_id` (`oi_item_id`),
  ADD KEY `oi_gc_id` (`oi_gc_id`),
  ADD KEY `oi_size_id` (`oi_size_id`),
  ADD KEY `oi_order_id` (`oi_order_id`);

--
-- Indexes for table `sizes`
--
ALTER TABLE `sizes`
  ADD PRIMARY KEY (`size_id`);

--
-- Indexes for table `tasks`
--
ALTER TABLE `tasks`
  ADD PRIMARY KEY (`task_id`);

--
-- Indexes for table `trees`
--
ALTER TABLE `trees`
  ADD PRIMARY KEY (`tree_id`),
  ADD KEY `tree_code` (`tree_code`);

--
-- Indexes for table `tree_histories`
--
ALTER TABLE `tree_histories`
  ADD PRIMARY KEY (`th_id`),
  ADD KEY `th_tree_id` (`th_tree_id`);

--
-- Indexes for table `workflows`
--
ALTER TABLE `workflows`
  ADD PRIMARY KEY (`workflow_id`);

--
-- Indexes for table `workflow_tasks`
--
ALTER TABLE `workflow_tasks`
  ADD PRIMARY KEY (`wt_id`),
  ADD KEY `wt_workflow_id` (`wt_workflow_id`),
  ADD KEY `wt_task_id` (`wt_task_id`);

--
-- AUTO_INCREMENT for table `admin_modules`
--
ALTER TABLE `admin_modules`
  MODIFY `am_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=65;

--
-- AUTO_INCREMENT for table `admin_permissions`
--
ALTER TABLE `admin_permissions`
  MODIFY `ap_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `admin_roles`
--
ALTER TABLE `admin_roles`
  MODIFY `ar_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `admin_role_modules`
--
ALTER TABLE `admin_role_modules`
  MODIFY `arm_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=387;

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `category_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `customers`
--
ALTER TABLE `customers`
  MODIFY `customer_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `gold_contents`
--
ALTER TABLE `gold_contents`
  MODIFY `gc_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `gold_content_histories`
--
ALTER TABLE `gold_content_histories`
  MODIFY `gch_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `items`
--
ALTER TABLE `items`
  MODIFY `item_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `orders`
--
ALTER TABLE `orders`
  MODIFY `order_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `order_items`
--
ALTER TABLE `order_items`
  MODIFY `oi_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sizes`
--
ALTER TABLE `sizes`
  MODIFY `size_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `tasks`
--
ALTER TABLE `tasks`
  MODIFY `task_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `trees`
--
ALTER TABLE `trees`
  MODIFY `tree_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `tree_histories`
--
ALTER TABLE `tree_histories`
  MODIFY `th_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `workflows`
--
ALTER TABLE `workflows`
  MODIFY `workflow_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `workflow_tasks`
--
ALTER TABLE `workflow_tasks`
  MODIFY `wt_id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

