-- 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_section` varchar(30) 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_section`, `am_insert_at`, `am_update_at`, `am_active`) VALUES
(1, 'Admin Get All', 'admin-get-all', 'Admin Get All', '\\App\\Controllers\\Admin', 'getAll', 'Admin', '2021-07-20 08:40:39', '2022-06-20 07:20:58', 1),
(2, 'Admin Get By ID', 'admin-get-by-id', 'Admin Get By ID', '\\App\\Controllers\\Admin', 'getByID', 'Admin', '2021-07-20 08:40:39', '2022-06-20 07:32:30', 0),
(3, 'Admin Add', 'admin-add', 'Admin Add', '\\App\\Controllers\\Admin', 'addAdmin', 'Admin', '2021-07-20 08:44:28', '2022-06-20 07:21:04', 1),
(4, 'Admin Update', 'admin-update', 'Admin Update', '\\App\\Controllers\\Admin', 'updateAdmin', 'Admin', '2021-07-20 08:44:28', '2022-06-20 07:21:07', 1),
(5, 'Admin Delete', 'admin-delete', 'Admin Delete', '\\App\\Controllers\\Admin', 'deleteAdmin', 'Admin', '2021-07-20 08:44:57', '2022-06-20 07:21:09', 1),
(6, 'Admin Role Get All', 'admin-role-get-all', 'Admin Role Get All', '\\App\\Controllers\\AdminRole', 'getAll', 'Admin', '2021-07-20 08:44:57', '2022-06-20 07:21:11', 1),
(7, 'Admin Role Get By ID', 'admin-role-get-by-id', 'Admin Role Get By ID', '\\App\\Controllers\\AdminRole', 'getByID', 'Admin', '2021-07-20 08:44:57', '2022-06-20 07:32:39', 0),
(8, 'Admin Role Add', 'admin-role-add', 'Admin Role Add', '\\App\\Controllers\\AdminRole', 'addAdminRole', 'Admin', '2021-07-20 08:44:57', '2022-06-20 07:21:26', 1),
(9, 'Admin Role Update', 'admin-role-update', 'Admin Role Update', '\\App\\Controllers\\AdminRole', 'updateAdminRole', 'Admin', '2021-07-20 08:44:57', '2022-06-20 07:21:31', 1),
(10, 'Admin Role Delete', 'admin-role-delete', 'Admin Role Delete', '\\App\\Controllers\\AdminRole', 'deleteAdminRole', 'Admin', '2021-07-20 08:44:57', '2022-06-20 07:21:34', 1),
(11, 'Admin Module Get All', 'admin-module-get-all', 'Admin Module Get All', '\\App\\Controllers\\AdminModule', 'getAll', 'Admin', '2021-07-20 08:44:57', '2022-06-20 07:21:37', 1),
(12, 'Admin Module Get By ID', 'admin-module-get-by-id', 'Admin Module Get By ID', '\\App\\Controllers\\AdminModule', 'getByID', 'Admin', '2021-07-20 08:44:57', '2022-06-20 07:32:49', 0),
(13, 'Admin Module Add', 'admin-module-add', 'Admin Module Add', '\\App\\Controllers\\AdminModule', 'addModule', 'Admin', '2021-07-20 08:44:57', '2022-06-20 07:21:44', 1),
(14, 'Admin Module Update', 'admin-module-update', 'Admin Module Update', '\\App\\Controllers\\AdminModule', 'updateModule', 'Admin', '2021-07-20 08:44:57', '2022-06-20 07:21:47', 1),
(15, 'Admin Module Delete', 'admin-module-delete', 'Admin Module Delete', '\\App\\Controllers\\AdminModule', 'deleteModule', 'Admin', '2021-07-20 08:44:57', '2022-06-20 07:21:51', 1),
(16, 'Admin Role Module Get All', 'admin-role-module-get-all', 'Admin Role Module Get All', '\\App\\Controllers\\AdminRoleModule', 'getAll', 'Admin', '2021-07-20 08:44:57', '2022-06-20 07:21:54', 1),
(17, 'Admin Role Module Get By ID', 'admin-role-module-get-by-id', 'Admin Role Module Get By ID', '\\App\\Controllers\\AdminRoleModule', 'getByID', 'Admin', '2021-07-20 08:44:57', '2022-06-20 07:33:20', 0),
(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', 'Admin', '2021-07-20 08:44:57', '2022-06-20 07:34:06', 0),
(19, 'Admin Role Module Add', 'admin-role-module-add', 'Admin Role Module Add', '\\App\\Controllers\\AdminRoleModule', 'addRoleModule', 'Admin', '2021-07-20 08:44:57', '2022-06-20 07:22:07', 1),
(20, 'Admin Role Module Add Bulk', 'admin-role-module-add-bulk', 'Admin Role Module Add Bulk', '\\App\\Controllers\\AdminRoleModule', 'addRoleModuleBulk', 'Admin', '2021-07-20 08:44:57', '2022-06-20 07:34:03', 0),
(21, 'Admin Role Module Update', 'admin-role-module-update', 'Admin Role Module Update', '\\App\\Controllers\\AdminRoleModule', 'updateRoleModule', 'Admin', '2021-07-20 08:44:57', '2022-06-20 07:22:24', 1),
(22, 'Admin Role Module Delete', 'admin-role-module-delete', 'Admin Role Module Delete', '\\App\\Controllers\\AdminRoleModule', 'deleteRoleModule', 'Admin', '2021-07-20 08:44:57', '2022-06-20 07:22:28', 1),
(23, 'Admin Role Permission Get All', 'admin-role-permission-get-all', 'Admin Role Permission Get All', '\\App\\Controllers\\AdminPermission', 'getAll', 'Admin', '2021-07-20 08:44:57', '2022-06-20 07:35:10', 0),
(24, 'Admin Role Permission Get By ID', 'admin-role-permission-get-by-id', 'Admin Role Permission Get By ID', '\\App\\Controllers\\AdminPermission', 'getByID', 'Admin', '2021-07-20 08:44:57', '2022-06-20 07:35:13', 0),
(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', 'Admin', '2021-07-20 08:44:57', '2022-06-20 07:35:16', 0),
(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', 'Admin', '2021-07-20 08:44:57', '2022-06-20 07:35:31', 0),
(27, 'Admin Role Permission Add', 'admin-role-permission-add', 'Admin Role Permission Add', '\\App\\Controllers\\AdminPermission', 'addAdminPermission', 'Admin', '2021-07-20 08:44:57', '2022-06-20 07:35:39', 0),
(28, 'Admin Role Permission Update', 'admin-role-permission-update', 'Admin Role Permission Update', '\\App\\Controllers\\AdminPermission', 'updateAdminPermission', 'Admin', '2021-07-20 08:44:57', '2022-06-20 07:23:02', 1),
(29, 'Admin Role Permission Delete', 'admin-role-permission-delete', 'Admin Role Permission Delete', '\\App\\Controllers\\AdminPermission', 'deleteAdminPermission', 'Admin', '2021-07-20 08:44:57', '2022-06-20 07:35:45', 0),
(30, 'Tree Get All', 'tree-get-all', 'Tree Get All', '\\App\\Controllers\\Tree', 'getAll', 'Pohon', '2021-07-20 08:44:57', '2022-06-20 07:24:28', 1),
(31, 'Tree Get By ID', 'tree-get-by-id', 'Tree Get By ID', '\\App\\Controllers\\Tree', 'getByID', 'Pohon', '2021-07-20 08:44:57', '2022-06-20 07:35:50', 0),
(32, 'Tree Add', 'tree-add', 'Tree Add', '\\App\\Controllers\\Tree', 'addTree', 'Pohon', '2021-07-20 08:44:57', '2022-06-20 07:24:48', 1),
(33, 'Tree Update', 'tree-update', 'Tree Update', '\\App\\Controllers\\Tree', 'updateTree', 'Pohon', '2021-07-20 08:44:57', '2022-06-20 07:24:52', 1),
(34, 'Tree Delete', 'tree-delete', 'Tree Delete', '\\App\\Controllers\\Tree', 'deleteTree', 'Pohon', '2021-07-20 08:44:57', '2022-06-20 07:24:57', 1),
(35, 'Size Get All', 'size-get-all', 'Size Get All', '\\App\\Controllers\\Size', 'getAll', 'Ukuran', '2022-05-30 04:20:15', '2022-06-20 07:25:09', 1),
(36, 'Size Get By ID', 'size-get-by-id', 'Size Get By ID', '\\App\\Controllers\\Size', 'getByID', 'Ukuran', '2022-05-30 04:20:25', '2022-06-20 07:35:55', 0),
(37, 'Size Add', 'size-add', 'Size Add', '\\App\\Controllers\\Size', 'addSize', 'Ukuran', '2022-05-30 04:20:32', '2022-06-20 07:25:17', 1),
(38, 'Size Update', 'size-update', 'Size Update', '\\App\\Controllers\\Size', 'updateSize', 'Ukuran', '2022-05-30 04:20:41', '2022-06-20 07:25:21', 1),
(39, 'Size Delete', 'size-delete', 'Size Delete', '\\App\\Controllers\\Size', 'deleteSize', 'Ukuran', '2022-05-30 04:20:50', '2022-06-20 07:25:24', 1),
(40, 'Category Get All', 'category-get-all', 'Category Get All', '\\App\\Controllers\\Category', 'getAll', 'Kategori', '2022-05-30 04:32:51', '2022-06-20 07:25:33', 1),
(41, 'Category Get By ID', 'category-get-by-id', 'Category Get By ID', '\\App\\Controllers\\Category', 'getByID', 'Kategori', '2022-05-30 04:32:57', '2022-06-20 07:36:08', 0),
(42, 'Category Add', 'category-add', 'Category Add', '\\App\\Controllers\\Category', 'addCategory', 'Kategori', '2022-05-30 04:33:05', '2022-06-20 07:25:59', 1),
(43, 'Category Update', 'category-update', 'Category Update', '\\App\\Controllers\\Category', 'updateCategory', 'Kategori', '2022-05-30 04:33:11', '2022-06-20 07:26:03', 1),
(44, 'Category Delete', 'category-delete', 'Category Delete', '\\App\\Controllers\\Category', 'deleteCategory', 'Kategori', '2022-05-30 04:33:22', '2022-06-20 07:26:05', 1),
(45, 'Item Get All', 'item-get-all', 'Item Get All', '\\App\\Controllers\\Item', 'getAll', 'Item', '2022-05-30 07:06:09', '2022-06-20 07:26:12', 1),
(46, 'Item Get By ID', 'item-get-by-id', 'Item Get By ID', '\\App\\Controllers\\Item', 'getByID', 'Item', '2022-05-30 07:06:11', '2022-06-20 07:36:17', 0),
(47, 'Item Add', 'item-add', 'Item Add', '\\App\\Controllers\\Item', 'addItem', 'Item', '2022-05-30 07:06:16', '2022-06-20 07:26:19', 1),
(48, 'Item Update', 'item-update', 'Item Update', '\\App\\Controllers\\Item', 'updateItem', 'Item', '2022-05-30 07:06:20', '2022-06-20 07:26:23', 1),
(49, 'Item Delete', 'item-delete', 'Item Delete', '\\App\\Controllers\\Item', 'deleteItem', 'Item', '2022-05-30 07:06:23', '2022-06-20 07:26:27', 1),
(50, 'Gold Content Get All', 'gold-content-get-all', 'Gold Content Get All', '\\App\\Controllers\\GoldContent', 'getAll', 'Kadar Emas', '2022-05-30 07:16:25', '2022-06-20 07:26:45', 1),
(51, 'Gold Content Get By ID', 'gold-content-get-by-id', 'Gold Content Get By ID', '\\App\\Controllers\\GoldContent', 'getByID', 'Kadar Emas', '2022-05-30 07:16:28', '2022-06-20 07:36:34', 0),
(52, 'Gold Content Add', 'gold-content-add', 'Gold Content Add', '\\App\\Controllers\\GoldContent', 'AddGoldContent', 'Kadar Emas', '2022-05-30 07:16:32', '2022-06-20 07:27:13', 1),
(53, 'Gold Content Update', 'gold-content-edit', 'Gold Content Edit', '\\App\\Controllers\\GoldContent', 'UpdateGoldContent', 'Kadar Emas', '2022-05-30 07:16:35', '2022-06-20 07:27:19', 1),
(54, 'Gold Content Delete', 'gold-content-delete', 'Gold Content Delete', '\\App\\Controllers\\GoldContent', 'DeleteGoldContent', 'Kadar Emas', '2022-05-30 07:16:39', '2022-06-20 07:27:32', 1),
(55, 'Workflow Get All', 'workflow-get-all', 'Workflow Get All', '\\App\\Controllers\\Workflow', 'getAll', 'Alur Kerja', '2022-05-30 09:58:19', '2022-06-20 07:27:47', 1),
(56, 'Workflow Get By ID', 'workflow-get-by-id', 'Workflow Get By ID', '\\App\\Controllers\\Workflow', 'getByID', 'Alur Kerja', '2022-05-30 09:58:22', '2022-06-20 07:36:42', 0),
(57, 'Workflow Add', 'workflow-add', 'Workflow Add', '\\App\\Controllers\\Workflow', 'AddWorkflow', 'Alur Kerja', '2022-05-30 09:58:27', '2022-06-20 07:27:56', 1),
(58, 'Workflow Update', 'workflow-update', 'Workflow Update', '\\App\\Controllers\\Workflow', 'UpdateWorkflow', 'Alur Kerja', '2022-05-30 09:58:34', '2022-06-20 07:27:59', 1),
(59, 'Workflow Delete', 'workflow-delete', 'Workflow Delete', '\\App\\Controllers\\Workflow', 'DeleteWorkflow', 'Alur Kerja', '2022-05-30 09:58:42', '2022-06-20 07:28:03', 1),
(60, 'Order Get All', 'order-get-all', 'Order Get All', '\\App\\Controllers\\Order', 'getAll', 'Order', '2022-06-04 04:28:58', '2022-06-20 07:28:14', 1),
(61, 'Order Get By ID', 'order-get-by-id', 'Order Get By ID', '\\App\\Controllers\\Order', 'getByID', 'Order', '2022-06-04 04:29:02', '2022-06-20 07:36:51', 0),
(62, 'Order Add', 'order-add', 'Order Add', '\\App\\Controllers\\Order', 'addOrder', 'Order', '2022-06-04 04:29:07', '2022-06-20 07:28:20', 1),
(63, 'Order Update', 'order-update', 'Order Update', '\\App\\Controllers\\Order', 'updateOrder', 'Order', '2022-06-04 04:29:13', '2022-06-20 07:28:24', 1),
(64, 'Order Delete', 'order-delete', 'Order Delete', '\\App\\Controllers\\Order', 'deleteOrder', 'Order', '2022-06-04 04:29:39', '2022-06-20 07:28:27', 1),
(65, 'Order Item Get All', 'order-item-get-all', 'Order Item Get All', '\\App\\Controllers\\OrderItem', 'getAll', 'Order Item', '2022-06-08 07:19:34', '2022-06-20 07:28:33', 1),
(66, 'Order Item Get By ID', 'order-item-get-by-id', 'Order Item Get By ID', '\\App\\Controllers\\OrderItem', 'getByID', 'Order Item', '2022-06-08 07:19:37', '2022-06-20 07:37:11', 0),
(67, 'Order Item Update', 'order-item-update', 'Order Item Update', '\\App\\Controllers\\OrderItem', 'updateOrderItem', 'Order Item', '2022-06-08 07:19:42', '2022-06-20 07:28:45', 1),
(68, 'Batch Get All', 'batch-get-all', 'Batch Get All', '\\App\\Controllers\\Batch', 'getAll', 'Batch', '2022-06-08 07:19:45', '2022-06-20 07:28:55', 1),
(69, 'Batch Get By ID', 'batch-get-by-id', 'Batch Get By ID', '\\App\\Controllers\\Batch', 'getByID', 'Batch', '2022-06-08 07:20:25', '2022-06-20 07:37:23', 0),
(70, 'Batch Add', 'batch-add', 'Batch Add', '\\App\\Controllers\\Batch', 'addBatch', 'Batch', '2022-06-08 07:20:42', '2022-06-20 07:29:03', 1),
(71, 'Batch Update', 'batch-update', 'Batch Update', '\\App\\Controllers\\Batch', 'updateBatch', 'Batch', '2022-06-09 08:48:57', '2022-06-20 07:29:05', 1),
(72, 'Batch Delete', 'batch-delete', 'Batch Delete', '\\App\\Controllers\\Batch', 'deleteBatch', 'Batch', '2022-06-09 08:49:01', '2022-06-20 07:29:09', 1),
(73, 'Customer Get All', 'customer-get-all', 'Customer Get All', '\\App\\Controllers\\Customer', 'getAll', 'Customer', '2022-06-09 08:49:06', '2022-06-20 07:29:14', 1),
(74, 'Customer Get By ID', 'customer-get-by-id', 'Customer Get By ID', '\\App\\Controllers\\Customer', 'getByID', 'Customer', '2022-06-09 08:49:09', '2022-06-20 07:37:29', 0),
(75, 'Customer Add', 'customer-add', 'Customer Add', '\\App\\Controllers\\Customer', 'addCustomer', 'Customer', '2022-06-09 08:49:13', '2022-06-20 07:29:22', 1),
(76, 'Customer Update', 'customer-update', 'Customer Update', '\\App\\Controllers\\Customer', 'updateCustomer', 'Customer', '2022-06-09 08:55:29', '2022-06-20 07:29:35', 1),
(77, 'Customer Delete', 'customer-delete', 'Customer-delete', '\\App\\Controllers\\Customer', 'deleteCustomer', 'Customer', '2022-06-09 08:55:31', '2022-06-20 07:29:40', 1),
(78, 'Task Get All', 'task-get-all', 'Task Get All', '\\App\\Controllers\\Task', 'getAll', 'Divisi', '2022-06-09 08:55:31', '2022-06-20 07:29:47', 1),
(79, 'Task Get By ID', 'task-get-by-id', 'Task Get By ID', '\\App\\Controllers\\Task', 'getByID', 'Divisi', '2022-06-20 07:37:42', '2022-06-20 07:41:19', 0),
(80, 'Task Add', 'task-add', 'Task Add', '\\App\\Controllers\\Task', 'addTask', 'Divisi', '2022-06-20 07:37:45', '2022-06-20 07:41:01', 1),
(81, 'Task Update', 'task-update', 'Task Update', '\\App\\Controllers\\Task', 'updateTask', 'Divisi', '2022-06-20 07:37:53', '2022-06-20 07:41:07', 1),
(82, 'Task Delete', 'task-delete', 'Task Delete', '\\App\\Controllers\\Task', 'deleteTask', 'Divisi', '2022-06-20 07:37:58', '2022-06-20 07:41:11', 1),
(83, 'Batch Note', 'batch-note', 'Batch Note', '\\App\\Controllers\\Batch', 'note', 'Batch', '2022-06-20 09:35:22', '2022-06-20 09:36:17', 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-06-20 07:08:59', NULL, '2022-06-20 07:08:59', 6, 0),
(3, 5, 2, '2022-05-27 02:19:50', 1, '2022-06-20 07:08:59', NULL, '2022-06-20 07:08:59', 6, 0),
(4, 5, 2, '2022-05-27 02:19:57', 1, '2022-06-20 07:08:59', NULL, '2022-06-20 07:08:59', 6, 0),
(5, 5, 2, '2022-05-27 02:20:19', 1, '2022-06-20 07:08:59', NULL, '2022-06-20 07:08:59', 6, 0),
(6, 5, 2, '2022-05-27 02:21:02', 1, '2022-06-20 07:08:59', NULL, '2022-06-20 07:08:59', 6, 0),
(7, 5, 1, '2022-05-27 02:24:01', 1, '2022-06-20 07:08:59', NULL, '2022-06-20 07:08:59', 6, 0),
(8, 5, 2, '2022-05-27 02:24:09', 1, '2022-06-20 07:08:59', NULL, '2022-06-20 07:08:59', 6, 0),
(9, 5, 2, '2022-05-27 02:27:59', 1, '2022-06-20 07:08:59', NULL, '2022-06-20 07:08:59', 6, 0),
(10, 5, 1, '2022-05-27 03:30:17', 1, '2022-06-20 07:08:59', NULL, '2022-06-20 07:08:59', 6, 0),
(11, 5, 2, '2022-05-27 03:30:27', 1, '2022-06-20 07:08:59', NULL, '2022-06-20 07:08:59', 6, 0),
(12, 6, 1, '2022-06-11 05:45:07', 1, '2022-06-20 09:03:05', NULL, '2022-06-20 09:03:05', 6, 0),
(13, 7, 3, '2022-06-13 08:31:32', 6, '2022-06-13 08:34:22', NULL, '2022-06-13 07:34:22', 7, 0),
(14, 7, 2, '2022-06-13 08:34:22', 7, NULL, NULL, NULL, NULL, 1),
(15, 5, 0, '2022-06-20 07:05:21', 6, '2022-06-20 07:08:59', NULL, '2022-06-20 07:08:59', 6, 0),
(16, 5, 0, '2022-06-20 07:05:21', 6, '2022-06-20 07:08:59', NULL, '2022-06-20 07:08:59', 6, 0),
(17, 5, 0, '2022-06-20 07:05:22', 6, '2022-06-20 07:08:59', NULL, '2022-06-20 07:08:59', 6, 0),
(18, 5, 0, '2022-06-20 07:05:22', 6, '2022-06-20 07:08:59', NULL, '2022-06-20 07:08:59', 6, 0),
(19, 5, 0, '2022-06-20 07:05:22', 6, '2022-06-20 07:08:59', NULL, '2022-06-20 07:08:59', 6, 0),
(20, 5, 0, '2022-06-20 07:05:22', 6, '2022-06-20 07:08:59', NULL, '2022-06-20 07:08:59', 6, 0),
(21, 5, 0, '2022-06-20 07:05:22', 6, '2022-06-20 07:08:59', NULL, '2022-06-20 07:08:59', 6, 0),
(22, 5, 0, '2022-06-20 07:05:22', 6, '2022-06-20 07:08:59', NULL, '2022-06-20 07:08:59', 6, 0),
(23, 5, 0, '2022-06-20 07:05:22', 6, '2022-06-20 07:08:59', NULL, '2022-06-20 07:08:59', 6, 0),
(24, 5, 0, '2022-06-20 07:05:22', 6, '2022-06-20 07:08:59', NULL, '2022-06-20 07:08:59', 6, 0),
(25, 5, 0, '2022-06-20 07:05:22', 6, '2022-06-20 07:08:59', NULL, '2022-06-20 07:08:59', 6, 0),
(26, 5, 0, '2022-06-20 07:05:22', 6, '2022-06-20 07:08:59', NULL, '2022-06-20 07:08:59', 6, 0),
(27, 5, 0, '2022-06-20 07:05:22', 6, '2022-06-20 07:08:59', NULL, '2022-06-20 07:08:59', 6, 0),
(28, 5, 0, '2022-06-20 07:06:04', 6, '2022-06-20 07:08:59', NULL, '2022-06-20 07:08:59', 6, 0),
(29, 5, 0, '2022-06-20 07:06:04', 6, '2022-06-20 07:08:59', NULL, '2022-06-20 07:08:59', 6, 0),
(30, 5, 0, '2022-06-20 07:06:04', 6, '2022-06-20 07:08:59', NULL, '2022-06-20 07:08:59', 6, 0),
(31, 5, 0, '2022-06-20 07:06:04', 6, '2022-06-20 07:08:59', NULL, '2022-06-20 07:08:59', 6, 0),
(32, 5, 0, '2022-06-20 07:06:04', 6, '2022-06-20 07:08:59', NULL, '2022-06-20 07:08:59', 6, 0),
(33, 5, 0, '2022-06-20 07:06:04', 6, '2022-06-20 07:08:59', NULL, '2022-06-20 07:08:59', 6, 0),
(34, 5, 0, '2022-06-20 07:06:04', 6, '2022-06-20 07:08:59', NULL, '2022-06-20 07:08:59', 6, 0),
(35, 5, 0, '2022-06-20 07:06:04', 6, '2022-06-20 07:08:59', NULL, '2022-06-20 07:08:59', 6, 0),
(36, 5, 0, '2022-06-20 07:06:05', 6, '2022-06-20 07:08:59', NULL, '2022-06-20 07:08:59', 6, 0),
(37, 5, 0, '2022-06-20 07:06:05', 6, '2022-06-20 07:08:59', NULL, '2022-06-20 07:08:59', 6, 0),
(38, 5, 0, '2022-06-20 07:06:05', 6, '2022-06-20 07:08:59', NULL, '2022-06-20 07:08:59', 6, 0),
(39, 5, 0, '2022-06-20 07:06:05', 6, '2022-06-20 07:08:59', NULL, '2022-06-20 07:08:59', 6, 0),
(40, 5, 0, '2022-06-20 07:06:05', 6, '2022-06-20 07:08:59', NULL, '2022-06-20 07:08:59', 6, 0),
(41, 5, 1, '2022-06-20 07:08:59', 6, NULL, NULL, NULL, NULL, 1),
(42, 5, 4, '2022-06-20 07:08:59', 6, NULL, NULL, NULL, NULL, 1),
(43, 5, 5, '2022-06-20 07:08:59', 6, NULL, NULL, NULL, NULL, 1),
(44, 5, 6, '2022-06-20 07:08:59', 6, NULL, NULL, NULL, NULL, 1),
(45, 5, 7, '2022-06-20 07:08:59', 6, NULL, NULL, NULL, NULL, 1),
(46, 5, 8, '2022-06-20 07:08:59', 6, NULL, NULL, NULL, NULL, 1),
(47, 5, 9, '2022-06-20 07:08:59', 6, NULL, NULL, NULL, NULL, 1),
(48, 5, 10, '2022-06-20 07:09:00', 6, NULL, NULL, NULL, NULL, 1),
(49, 5, 11, '2022-06-20 07:09:00', 6, NULL, NULL, NULL, NULL, 1),
(50, 5, 12, '2022-06-20 07:09:00', 6, NULL, NULL, NULL, NULL, 1),
(51, 5, 13, '2022-06-20 07:09:00', 6, NULL, NULL, NULL, NULL, 1),
(52, 5, 14, '2022-06-20 07:09:00', 6, NULL, NULL, NULL, NULL, 1),
(53, 5, 15, '2022-06-20 07:09:00', 6, NULL, NULL, NULL, NULL, 1),
(54, 6, 4, '2022-06-20 07:11:56', 6, '2022-06-20 09:03:05', NULL, '2022-06-20 09:03:05', 6, 0),
(55, 6, 5, '2022-06-20 07:11:56', 6, '2022-06-20 09:03:05', NULL, '2022-06-20 09:03:05', 6, 0),
(56, 6, 6, '2022-06-20 07:11:56', 6, '2022-06-20 09:03:05', NULL, '2022-06-20 09:03:05', 6, 0),
(57, 6, 7, '2022-06-20 07:11:56', 6, '2022-06-20 09:03:05', NULL, '2022-06-20 09:03:05', 6, 0),
(58, 6, 8, '2022-06-20 07:11:56', 6, '2022-06-20 09:03:05', NULL, '2022-06-20 09:03:05', 6, 0),
(59, 6, 9, '2022-06-20 07:11:56', 6, '2022-06-20 09:03:05', NULL, '2022-06-20 09:03:05', 6, 0),
(60, 6, 10, '2022-06-20 07:11:56', 6, '2022-06-20 09:03:05', NULL, '2022-06-20 09:03:05', 6, 0),
(61, 6, 11, '2022-06-20 07:11:56', 6, '2022-06-20 09:03:05', NULL, '2022-06-20 09:03:05', 6, 0),
(62, 6, 12, '2022-06-20 07:11:56', 6, '2022-06-20 09:03:05', NULL, '2022-06-20 09:03:05', 6, 0),
(63, 6, 13, '2022-06-20 07:11:57', 6, '2022-06-20 09:03:05', NULL, '2022-06-20 09:03:05', 6, 0),
(64, 6, 14, '2022-06-20 07:11:57', 6, '2022-06-20 09:03:05', NULL, '2022-06-20 09:03:05', 6, 0),
(65, 6, 15, '2022-06-20 07:11:57', 6, '2022-06-20 09:03:05', NULL, '2022-06-20 09:03:05', 6, 0),
(66, 8, 4, '2022-06-20 07:53:31', 6, '2022-06-20 08:13:52', NULL, '2022-06-20 08:13:52', 6, 0),
(67, 8, 5, '2022-06-20 07:53:31', 6, '2022-06-20 08:13:52', NULL, '2022-06-20 08:13:52', 6, 0),
(68, 8, 6, '2022-06-20 07:53:31', 6, '2022-06-20 08:13:52', NULL, '2022-06-20 08:13:52', 6, 0),
(69, 8, 5, '2022-06-20 08:13:52', 6, NULL, NULL, NULL, NULL, 1),
(70, 8, 6, '2022-06-20 08:13:52', 6, NULL, NULL, NULL, NULL, 1),
(71, 6, 4, '2022-06-20 09:03:05', 6, NULL, NULL, NULL, NULL, 1),
(72, 6, 5, '2022-06-20 09:03:05', 6, NULL, NULL, NULL, NULL, 1),
(73, 6, 6, '2022-06-20 09:03:06', 6, NULL, NULL, NULL, NULL, 1),
(74, 6, 7, '2022-06-20 09:03:06', 6, NULL, NULL, NULL, NULL, 1),
(75, 6, 8, '2022-06-20 09:03:06', 6, NULL, NULL, NULL, NULL, 1),
(76, 6, 9, '2022-06-20 09:03:06', 6, NULL, NULL, NULL, NULL, 1),
(77, 6, 10, '2022-06-20 09:03:06', 6, NULL, NULL, NULL, NULL, 1),
(78, 6, 11, '2022-06-20 09:03:06', 6, NULL, NULL, NULL, NULL, 1),
(79, 6, 12, '2022-06-20 09:03:06', 6, NULL, NULL, NULL, NULL, 1),
(80, 6, 13, '2022-06-20 09:03:06', 6, NULL, NULL, NULL, NULL, 1),
(81, 6, 14, '2022-06-20 09:03:06', 6, NULL, NULL, NULL, NULL, 1),
(82, 6, 15, '2022-06-20 09:03:06', 6, 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-06-20 07:09:33', 1, '2022-06-20 07:09:33', 6, 0),
(2, 'Master Role', 'master-role', 'Master Role', '2022-05-27 01:54:31', 1, '2022-06-20 06:42:12', 0, '2022-06-20 06:42:12', 6, 0),
(3, 'Role 2', 'role-2', 'Role 2', '2022-05-27 04:05:39', 1, '2022-06-20 06:42:09', 1, '2022-06-20 06:42:09', 6, 0),
(4, 'Admin', 'admin', 'Admin', '2022-06-20 06:46:02', 6, NULL, 0, NULL, NULL, 1),
(5, 'Pohon', 'tree', 'Tree', '2022-06-20 06:46:57', 6, '2022-06-20 07:46:43', 0, NULL, NULL, 1),
(6, 'Ukuran', 'size', 'Size', '2022-06-20 06:47:25', 6, '2022-06-20 07:46:48', 0, NULL, NULL, 1),
(7, 'Kategori', 'category', 'Category', '2022-06-20 06:48:02', 6, '2022-06-20 07:46:56', 0, NULL, NULL, 1),
(8, 'Barang', 'item', 'Item', '2022-06-20 06:48:27', 6, '2022-06-20 07:47:00', 0, NULL, NULL, 1),
(9, 'Kadar Emas', 'gold-content', 'Gold Content', '2022-06-20 06:49:34', 6, '2022-06-20 07:47:13', 0, NULL, NULL, 1),
(10, 'Alur Kerja', 'workflow', 'Workflow', '2022-06-20 06:50:10', 6, '2022-06-20 07:47:20', 0, NULL, NULL, 1),
(11, 'Order', 'order', 'Order', '2022-06-20 06:50:38', 6, NULL, 0, NULL, NULL, 1),
(12, 'Order Barang', 'order-item', 'Order Item', '2022-06-20 06:51:10', 6, '2022-06-20 07:48:18', 0, NULL, NULL, 1),
(13, 'Batch', 'batch', 'Batch', '2022-06-20 06:51:30', 6, NULL, 0, NULL, NULL, 1),
(14, 'Pelanggan', 'customer', 'Customer', '2022-06-20 06:51:48', 6, '2022-06-20 07:47:44', 0, NULL, NULL, 1),
(15, 'Divisi', 'task', 'Task', '2022-06-20 06:51:59', 6, '2022-06-20 07:48:10', 0, 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, 4, 1, '2022-06-20 06:46:02', 6, NULL, NULL, NULL, NULL, 1),
(2, 4, 2, '2022-06-20 06:46:02', 6, NULL, NULL, NULL, NULL, 1),
(3, 4, 3, '2022-06-20 06:46:02', 6, NULL, NULL, NULL, NULL, 1),
(4, 4, 4, '2022-06-20 06:46:02', 6, NULL, NULL, NULL, NULL, 1),
(5, 4, 5, '2022-06-20 06:46:02', 6, NULL, NULL, NULL, NULL, 1),
(6, 4, 6, '2022-06-20 06:46:02', 6, NULL, NULL, NULL, NULL, 1),
(7, 4, 7, '2022-06-20 06:46:02', 6, NULL, NULL, NULL, NULL, 1),
(8, 4, 8, '2022-06-20 06:46:02', 6, NULL, NULL, NULL, NULL, 1),
(9, 4, 9, '2022-06-20 06:46:02', 6, NULL, NULL, NULL, NULL, 1),
(10, 4, 10, '2022-06-20 06:46:02', 6, NULL, NULL, NULL, NULL, 1),
(11, 4, 11, '2022-06-20 06:46:02', 6, NULL, NULL, NULL, NULL, 1),
(12, 4, 12, '2022-06-20 06:46:02', 6, NULL, NULL, NULL, NULL, 1),
(13, 4, 13, '2022-06-20 06:46:02', 6, NULL, NULL, NULL, NULL, 1),
(14, 4, 14, '2022-06-20 06:46:02', 6, NULL, NULL, NULL, NULL, 1),
(15, 4, 15, '2022-06-20 06:46:02', 6, NULL, NULL, NULL, NULL, 1),
(16, 4, 16, '2022-06-20 06:46:02', 6, NULL, NULL, NULL, NULL, 1),
(17, 4, 17, '2022-06-20 06:46:02', 6, NULL, NULL, NULL, NULL, 1),
(18, 4, 18, '2022-06-20 06:46:02', 6, NULL, NULL, NULL, NULL, 1),
(19, 4, 19, '2022-06-20 06:46:02', 6, NULL, NULL, NULL, NULL, 1),
(20, 4, 20, '2022-06-20 06:46:02', 6, NULL, NULL, NULL, NULL, 1),
(21, 4, 21, '2022-06-20 06:46:02', 6, NULL, NULL, NULL, NULL, 1),
(22, 4, 22, '2022-06-20 06:46:02', 6, NULL, NULL, NULL, NULL, 1),
(23, 4, 23, '2022-06-20 06:46:02', 6, NULL, NULL, NULL, NULL, 1),
(24, 4, 24, '2022-06-20 06:46:02', 6, NULL, NULL, NULL, NULL, 1),
(25, 4, 25, '2022-06-20 06:46:02', 6, NULL, NULL, NULL, NULL, 1),
(26, 4, 26, '2022-06-20 06:46:02', 6, NULL, NULL, NULL, NULL, 1),
(27, 4, 27, '2022-06-20 06:46:02', 6, NULL, NULL, NULL, NULL, 1),
(28, 4, 28, '2022-06-20 06:46:02', 6, NULL, NULL, NULL, NULL, 1),
(29, 4, 29, '2022-06-20 06:46:02', 6, NULL, NULL, NULL, NULL, 1),
(30, 5, 30, '2022-06-20 06:46:57', 6, NULL, NULL, NULL, NULL, 1),
(31, 5, 31, '2022-06-20 06:46:57', 6, NULL, NULL, NULL, NULL, 1),
(32, 5, 32, '2022-06-20 06:46:57', 6, NULL, NULL, NULL, NULL, 1),
(33, 5, 33, '2022-06-20 06:46:57', 6, NULL, NULL, NULL, NULL, 1),
(34, 5, 34, '2022-06-20 06:46:57', 6, NULL, NULL, NULL, NULL, 1),
(35, 6, 35, '2022-06-20 06:47:26', 6, NULL, NULL, NULL, NULL, 1),
(36, 6, 36, '2022-06-20 06:47:26', 6, NULL, NULL, NULL, NULL, 1),
(37, 6, 37, '2022-06-20 06:47:26', 6, NULL, NULL, NULL, NULL, 1),
(38, 6, 38, '2022-06-20 06:47:26', 6, NULL, NULL, NULL, NULL, 1),
(39, 6, 39, '2022-06-20 06:47:26', 6, NULL, NULL, NULL, NULL, 1),
(40, 7, 40, '2022-06-20 06:48:02', 6, NULL, NULL, NULL, NULL, 1),
(41, 7, 41, '2022-06-20 06:48:02', 6, NULL, NULL, NULL, NULL, 1),
(42, 7, 42, '2022-06-20 06:48:02', 6, NULL, NULL, NULL, NULL, 1),
(43, 7, 43, '2022-06-20 06:48:02', 6, NULL, NULL, NULL, NULL, 1),
(44, 7, 44, '2022-06-20 06:48:02', 6, NULL, NULL, NULL, NULL, 1),
(45, 8, 45, '2022-06-20 06:48:27', 6, NULL, NULL, NULL, NULL, 1),
(46, 8, 46, '2022-06-20 06:48:27', 6, NULL, NULL, NULL, NULL, 1),
(47, 8, 47, '2022-06-20 06:48:27', 6, NULL, NULL, NULL, NULL, 1),
(48, 8, 48, '2022-06-20 06:48:27', 6, NULL, NULL, NULL, NULL, 1),
(49, 8, 49, '2022-06-20 06:48:27', 6, NULL, NULL, NULL, NULL, 1),
(50, 9, 50, '2022-06-20 06:49:34', 6, NULL, NULL, NULL, NULL, 1),
(51, 9, 51, '2022-06-20 06:49:34', 6, NULL, NULL, NULL, NULL, 1),
(52, 9, 52, '2022-06-20 06:49:34', 6, NULL, NULL, NULL, NULL, 1),
(53, 9, 53, '2022-06-20 06:49:34', 6, NULL, NULL, NULL, NULL, 1),
(54, 9, 54, '2022-06-20 06:49:34', 6, NULL, NULL, NULL, NULL, 1),
(55, 10, 55, '2022-06-20 06:50:10', 6, NULL, NULL, NULL, NULL, 1),
(56, 10, 56, '2022-06-20 06:50:10', 6, NULL, NULL, NULL, NULL, 1),
(57, 10, 57, '2022-06-20 06:50:10', 6, NULL, NULL, NULL, NULL, 1),
(58, 10, 58, '2022-06-20 06:50:10', 6, NULL, NULL, NULL, NULL, 1),
(59, 10, 59, '2022-06-20 06:50:10', 6, NULL, NULL, NULL, NULL, 1),
(60, 11, 60, '2022-06-20 06:50:38', 6, NULL, NULL, NULL, NULL, 1),
(61, 11, 61, '2022-06-20 06:50:38', 6, NULL, NULL, NULL, NULL, 1),
(62, 11, 62, '2022-06-20 06:50:38', 6, NULL, NULL, NULL, NULL, 1),
(63, 11, 63, '2022-06-20 06:50:38', 6, NULL, NULL, NULL, NULL, 1),
(64, 11, 64, '2022-06-20 06:50:38', 6, NULL, NULL, NULL, NULL, 1),
(65, 12, 65, '2022-06-20 06:51:10', 6, NULL, NULL, NULL, NULL, 1),
(66, 12, 66, '2022-06-20 06:51:10', 6, NULL, NULL, NULL, NULL, 1),
(67, 12, 67, '2022-06-20 06:51:10', 6, NULL, NULL, NULL, NULL, 1),
(68, 13, 68, '2022-06-20 06:51:30', 6, NULL, NULL, NULL, NULL, 1),
(69, 13, 69, '2022-06-20 06:51:30', 6, NULL, NULL, NULL, NULL, 1),
(70, 13, 70, '2022-06-20 06:51:30', 6, NULL, NULL, NULL, NULL, 1),
(71, 13, 71, '2022-06-20 06:51:30', 6, NULL, NULL, NULL, NULL, 1),
(72, 13, 72, '2022-06-20 06:51:30', 6, NULL, NULL, NULL, NULL, 1),
(73, 14, 73, '2022-06-20 06:51:48', 6, NULL, NULL, NULL, NULL, 1),
(74, 14, 74, '2022-06-20 06:51:48', 6, NULL, NULL, NULL, NULL, 1),
(75, 14, 75, '2022-06-20 06:51:48', 6, NULL, NULL, NULL, NULL, 1),
(76, 14, 76, '2022-06-20 06:51:48', 6, NULL, NULL, NULL, NULL, 1),
(77, 14, 77, '2022-06-20 06:51:48', 6, NULL, NULL, NULL, NULL, 1),
(78, 15, 78, '2022-06-20 06:51:59', 6, NULL, NULL, NULL, NULL, 1);

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

--
-- Table structure for table `batches`
--

CREATE TABLE `batches` (
  `batch_id` int(11) NOT NULL,
  `batch_code` varchar(255) NOT NULL,
  `batch_start_date` date NOT NULL,
  `batch_due_date` date NOT NULL,
  `batch_workflow_id` int(11) NOT NULL,
  `batch_status` varchar(25) NOT NULL,
  `batch_insert_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `batch_insert_admin_id` int(11) NOT NULL,
  `batch_update_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(),
  `batch_update_admin_id` int(11) DEFAULT NULL,
  `batch_delete_at` timestamp NULL DEFAULT NULL,
  `batch_delete_admin_id` int(11) DEFAULT NULL,
  `batch_active` int(1) NOT NULL DEFAULT 1
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `batches`
--

INSERT INTO `batches` (`batch_id`, `batch_code`, `batch_start_date`, `batch_due_date`, `batch_workflow_id`, `batch_status`, `batch_insert_at`, `batch_insert_admin_id`, `batch_update_at`, `batch_update_admin_id`, `batch_delete_at`, `batch_delete_admin_id`, `batch_active`) VALUES
(1, 'c2441344-9de0-47ff-b95d-ac7c6a221a73', '2022-06-10', '2022-06-10', 2, 'Completed', '2022-06-10 09:14:03', 6, '2022-06-11 06:35:35', NULL, NULL, NULL, 1),
(2, '9f3a41fb-dba5-4343-958e-9cda1997529b', '2022-06-10', '2022-06-10', 3, 'Completed', '2022-06-10 09:14:14', 6, '2022-06-11 06:35:54', NULL, NULL, NULL, 1),
(3, '7d6e5fc0-ca53-4292-b2d6-96b7d6a4c27f', '2022-06-10', '2022-06-10', 3, 'Completed', '2022-06-10 09:14:45', 6, '2022-06-11 06:36:02', NULL, NULL, NULL, 1),
(4, '5e5fa4c4-dda5-4392-91b4-08742ac88ce4', '2022-06-12', '2022-06-14', 2, 'Completed', '2022-06-10 09:20:01', 6, '2022-06-11 06:36:39', NULL, NULL, NULL, 1),
(5, '54522718-9460-4120-855f-fee95b76c911', '2022-06-11', '2022-06-10', 5, 'Completed', '2022-06-11 03:46:53', 6, '2022-06-11 06:36:30', NULL, NULL, NULL, 1),
(6, '2ded32f6-63d3-4400-aa20-a51e1f86e1a3', '2022-06-11', '2022-06-11', 5, 'Completed', '2022-06-11 04:03:05', 6, '2022-06-11 06:36:10', NULL, NULL, NULL, 1),
(7, 'aa1a8df8-9bd1-4983-9fd4-5b27e641433d', '2022-06-11', '2022-06-11', 5, 'Completed', '2022-06-11 06:35:27', 6, '2022-06-11 06:36:51', NULL, NULL, NULL, 1),
(8, '9c1728ad-6f47-4c86-95b7-a9b0f15add84', '2022-06-11', '2022-06-16', 5, 'Completed', '2022-06-11 07:59:19', 6, '2022-06-11 07:59:40', NULL, NULL, NULL, 1),
(9, '7a6dd5a5-a776-446e-ae07-1e3a69aa5051', '2022-06-11', '2022-06-11', 2, 'New', '2022-06-11 08:11:07', 6, NULL, NULL, NULL, NULL, 1),
(10, '58f341e2-6fa5-407a-8d5f-e2da2f5b35bc', '2022-06-13', '2022-06-13', 6, 'New', '2022-06-13 08:06:53', 6, NULL, NULL, NULL, NULL, 1),
(11, '0a515e00-cff5-41b3-ae0b-71c50d6ce669', '2022-06-13', '2022-06-13', 7, 'New', '2022-06-13 08:30:40', 6, NULL, NULL, NULL, NULL, 1),
(12, '61735597310602938', '2022-06-14', '2022-06-14', 5, 'New', '2022-06-14 08:16:18', 6, NULL, NULL, NULL, NULL, 1);

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

--
-- Table structure for table `batch_items`
--

CREATE TABLE `batch_items` (
  `bi_id` int(11) NOT NULL,
  `bi_batch_id` int(11) NOT NULL,
  `bi_oi_id` int(11) NOT NULL,
  `bi_insert_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `bi_insert_admin_id` int(11) NOT NULL,
  `bi_update_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(),
  `bi_update_admin_id` int(11) NOT NULL,
  `bi_delete_at` timestamp NULL DEFAULT NULL,
  `bi_delete_admin_id` int(11) DEFAULT NULL,
  `bi_active` int(1) NOT NULL DEFAULT 1
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `batch_items`
--

INSERT INTO `batch_items` (`bi_id`, `bi_batch_id`, `bi_oi_id`, `bi_insert_at`, `bi_insert_admin_id`, `bi_update_at`, `bi_update_admin_id`, `bi_delete_at`, `bi_delete_admin_id`, `bi_active`) VALUES
(1, 1, 1, '2022-06-10 09:14:03', 1, NULL, 0, NULL, NULL, 1),
(2, 2, 4, '2022-06-10 09:14:14', 1, NULL, 0, NULL, NULL, 1),
(3, 3, 3, '2022-06-10 09:14:45', 1, NULL, 0, NULL, NULL, 1),
(4, 3, 2, '2022-06-10 09:14:45', 1, NULL, 0, NULL, NULL, 1),
(5, 4, 5, '2022-06-10 09:20:01', 1, NULL, 0, NULL, NULL, 1),
(6, 5, 8, '2022-06-11 03:46:53', 1, NULL, 0, NULL, NULL, 1),
(7, 6, 10, '2022-06-11 04:03:05', 1, NULL, 0, NULL, NULL, 1),
(8, 7, 9, '2022-06-11 06:35:27', 6, NULL, 0, NULL, NULL, 1),
(9, 7, 7, '2022-06-11 06:35:27', 6, NULL, 0, NULL, NULL, 1),
(10, 7, 6, '2022-06-11 06:35:27', 6, NULL, 0, NULL, NULL, 1),
(11, 8, 13, '2022-06-11 07:59:19', 6, NULL, 0, NULL, NULL, 1),
(12, 8, 12, '2022-06-11 07:59:19', 6, NULL, 0, NULL, NULL, 1),
(13, 8, 11, '2022-06-11 07:59:19', 6, NULL, 0, NULL, NULL, 1),
(14, 9, 19, '2022-06-11 08:11:07', 6, NULL, 0, NULL, NULL, 1),
(15, 10, 20, '2022-06-13 08:06:53', 6, NULL, 0, NULL, NULL, 1),
(16, 11, 23, '2022-06-13 08:30:40', 6, NULL, 0, NULL, NULL, 1),
(17, 11, 16, '2022-06-13 08:30:40', 6, NULL, 0, NULL, NULL, 1),
(18, 12, 18, '2022-06-14 08:16:18', 6, NULL, 0, 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),
(7, 'test33-tt', 'test33 tt', '2022-06-07 08:58:26', 1, '2022-06-07 09:00:49', 1, NULL, NULL, 1),
(8, 'testoo', 'testoo', '2022-06-07 08:59:48', 1, '2022-06-07 09:00:45', NULL, '2022-06-07 09:00:45', 1, 0),
(9, 'eee', 'eee', '2022-06-07 09:00:34', 1, '2022-06-07 09:00:41', NULL, '2022-06-07 09:00:41', 1, 0),
(10, 'sdddd', 'sdddd', '2022-06-11 02:39:31', 1, '2022-06-11 02:58:16', NULL, '2022-06-11 02:58:16', 1, 0),
(11, 'category1', 'Category1', '2022-06-11 02:39:58', 1, '2022-06-11 02:52:01', 1, NULL, NULL, 1),
(12, 'category_1', 'category_1', '2022-06-11 03:51:02', 1, '2022-06-11 03:51:05', NULL, '2022-06-11 02:51:05', 1, 0),
(13, 'anting', 'anting', '2022-06-11 07:53:46', 6, '2022-06-11 07:53:46', NULL, NULL, NULL, 1),
(14, 'cincin-mas', 'Cincin Mas', '2022-06-13 06:52:13', 6, '2022-06-13 06:52:36', 6, '2022-06-13 05:52:36', 6, 0),
(15, 'cincin', 'Cincin', '2022-06-13 06:52:43', 6, '2022-06-13 06:52:43', NULL, NULL, NULL, 1),
(16, 'gelang-guling', 'Gelang Guling', '2022-06-13 06:56:09', 6, '2022-06-13 06:56:19', 6, NULL, NULL, 1),
(17, 'vo102', 'VO102', '2022-06-13 08:11:47', 6, '2022-06-13 08:11:47', 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),
(2, 'Pelanggan', 'abcd', 'Abcd', 'solo', '1', '1', '1', '-', '-', '2022-06-11 03:52:55', 1, '2022-06-11 03:52:59', NULL, '2022-06-11 02:52:59', 1, 0),
(3, 'Toko', '101', 'Cabang Pondok Indah', 'Jl Gajah Mada 12', 'BCA', '119.0990.0999', 'Toko Cabang Pondok Indah', 'toko@gmail.com', '08139999999', '2022-06-13 07:05:31', 6, '2022-06-13 07:05:31', NULL, NULL, NULL, 1),
(4, 'Customer', 'SLO01', 'Indra', 'Jebres', 'Neo', '100100100', 'Indra', 'indra@gmail.com', '0899889988', '2022-06-13 08:23:36', 6, '2022-06-13 08:24:01', 6, NULL, NULL, 1),
(5, 'Pelanggan', 'SLO02', 'Pramana', 'Mojosongo', 'SEA Bank', '100100100', 'Pramana', 'pramana@gmail.com', '098753', '2022-06-13 08:25:09', 6, '2022-06-13 08:25:09', 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, 'ddd333', 'ddd333', '12.00', '2022-05-30 09:28:12', 1, '2022-06-07 07:57:41', 1, NULL, NULL, 1),
(3, 'test3', 'test3', '12233.95', '2022-06-07 07:52:29', 1, '2022-06-10 08:13:41', 1, NULL, NULL, 1),
(4, 'reee', 'reee', '234.00', '2022-06-07 07:57:59', 1, '2022-06-07 07:58:21', NULL, '2022-06-07 07:58:21', 1, 0),
(5, 'twww', 'twww', '324214.00', '2022-06-07 08:09:35', 1, '2022-06-07 08:09:40', NULL, '2022-06-07 08:09:40', 1, 0),
(6, '45', '45', '12.00', '2022-06-11 02:55:55', 1, '2022-06-11 07:53:26', 6, NULL, NULL, 1),
(7, '45', '45', '12.00', '2022-06-11 03:50:32', 1, '2022-06-11 03:50:39', 1, '2022-06-11 02:50:38', 1, 0),
(8, '21K', '21K', '10.00', '2022-06-13 06:50:06', 6, '2022-06-13 06:50:38', 6, '2022-06-13 05:50:38', 6, 0),
(9, '17k', '17K', '0.10', '2022-06-13 06:50:52', 6, '2022-06-13 06:50:52', NULL, NULL, NULL, 1),
(10, '5', '5%', '0.05', '2022-06-13 08:09:36', 6, '2022-06-13 08:10:35', 6, 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;

--
-- Dumping data for table `gold_content_histories`
--

INSERT INTO `gold_content_histories` (`gch_id`, `gch_gc_id`, `gch_multiplier_from`, `gch_multiplier_to`, `gch_description`, `gch_update_at`, `gch_update_admin_id`) VALUES
(1, 3, '12233.00', '12233.00', '', '2022-06-09 09:25:50', 1),
(2, 3, '12233.00', '12233.90', '', '2022-06-09 09:25:59', 1),
(3, 3, '12233.90', '12233.95', '', '2022-06-10 08:13:41', 1),
(4, 6, '12.00', '12.00', '', '2022-06-11 02:56:03', 1),
(5, 6, '12.00', '12.00', '', '2022-06-11 02:56:35', 1),
(6, 6, '12.00', '12.00', '', '2022-06-11 02:56:45', 1),
(7, 6, '12.00', '12.00', '', '2022-06-11 02:56:53', 1),
(8, 7, '12.00', '12.00', '', '2022-06-11 03:50:36', 1),
(9, 6, '12.00', '12.00', '', '2022-06-11 07:53:26', 6),
(10, 8, '9009.00', '10.00', '', '2022-06-13 06:50:33', 6),
(11, 10, '0.05', '0.10', '', '2022-06-13 08:10:02', 6),
(12, 10, '0.10', '0.05', '', '2022-06-13 08:10:35', 6);

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

--
-- Table structure for table `input_fields`
--

CREATE TABLE `input_fields` (
  `if_id` int(11) NOT NULL,
  `if_name` varchar(50) NOT NULL,
  `if_datatype` varchar(25) NOT NULL,
  `if_options` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `input_fields`
--

INSERT INTO `input_fields` (`if_id`, `if_name`, `if_datatype`, `if_options`) VALUES
(1, 'Nama Operator', 'Text', ''),
(2, 'Waktu Awal Pengerjaan', 'Datetime', ''),
(3, 'Berat Awal', 'Decimal', ''),
(4, 'Jumlah Barang', 'Integer', '');

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

--
-- 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, '', 'data1', NULL, 7, 2, '12.00', 5, '12', '', '[\"dev\\/1\\/1654852315_WhatsAppImage20220521at53423PMjpeg\"]', 0, '', '', '', '2022-06-10 09:11:56', 1, '2022-06-10 09:11:56', NULL, NULL, NULL, 1),
(2, '', 'data2', NULL, 4, 2, '23.00', 4, 'test', '', '[\"dev\\/1\\/1654852316_WhatsAppImage20220521at53423PM2jpeg\"]', 0, '', '', '', '2022-06-10 09:11:57', 1, '2022-06-10 09:11:57', NULL, NULL, NULL, 1),
(3, '45678', 'data3', 3, 5, 3, '12.00', 4, '12', 'Ya', '[\"dev\\/1\\/1654852390_WhatsAppImage20220521at53423PM2jpeg\",\"dev\\/1\\/1654852392_WhatsAppImage20220521at53423PM1jpeg\",\"dev\\/6\\/1655191683_JovanCopypng\"]', 0, '', '12', '13', '2022-06-10 09:13:12', 6, '2022-06-14 07:28:04', NULL, NULL, NULL, 1),
(4, '1234567', 'data4', 3, 2, 2, '23.00', 4, '13', '12', '[\"dev\\/1\\/1654852392_WhatsAppImage20220129at23402PM1jpeg\",\"dev\\/1\\/1654852392_WhatsAppImage20220129at23402PMjpeg\"]', 0, '', '123', '132', '2022-06-10 09:13:13', 1, '2022-06-10 09:16:45', NULL, NULL, NULL, 1),
(5, '', 'item1', NULL, 11, 6, '2.00', 5, '12', '', '[\"dev\\/1\\/1654918649_faviconpng\",\"dev\\/1\\/1654918656_WhatsAppImage20220521at53423PM2jpeg\"]', 0, '', '', '', '2022-06-11 03:37:37', 1, '2022-06-11 03:37:37', NULL, NULL, NULL, 1),
(6, '', 'item2', NULL, 11, 3, '23.00', 5, 'tess', '', '[\"dev\\/1\\/1654918657_WhatsAppImage20220521at53422PMjpeg\",\"dev\\/1\\/1654918658_WhatsAppImage20220520at53146PMjpeg\"]', 0, '', '', '', '2022-06-11 03:37:38', 1, '2022-06-11 03:37:38', NULL, NULL, NULL, 1),
(7, '12345673', 'item2', 5, 11, 6, '123.00', 9, '13', '2', '[\"dev\\/1\\/1654919190_WhatsAppImage20220521at53423PM1jpeg\",\"dev\\/1\\/1654919192_WhatsAppImage20220521at53423PMjpeg\"]', 0, '', '12', '12', '2022-06-11 03:46:32', 1, '2022-06-11 04:21:36', NULL, NULL, NULL, 1),
(8, '', 'brg1', NULL, 11, 6, '23.00', 9, 'test', '', '[\"dev\\/6\\/1654929270_absesn03022022Copypng\",\"dev\\/6\\/1654929271_absesn03022022png\"]', 0, '', '', '', '2022-06-11 06:34:31', 6, '2022-06-11 06:34:31', NULL, NULL, NULL, 1),
(9, '', 'brg2', NULL, 11, 6, '12.00', 5, 'test2', '', '[\"dev\\/6\\/1654929271_JovanCopypng\",\"dev\\/6\\/1654929271_Jovanpng\"]', 0, '', '', '', '2022-06-11 06:34:32', 6, '2022-06-11 06:34:32', NULL, NULL, NULL, 1),
(10, '', 'brg3', NULL, 11, 6, '12.00', 5, '12', '', '[\"dev\\/6\\/1654929272_JovanCopypng\",\"dev\\/6\\/1654929272_Jovanpng\"]', 0, '', '', '', '2022-06-11 06:34:32', 6, '2022-06-11 06:34:32', NULL, NULL, NULL, 1),
(11, '', 'item22', NULL, 11, 6, '12.00', 9, '12', '', '[\"dev\\/6\\/1654933979_JovanCopypng\",\"dev\\/6\\/1654933979_Jovanpng\"]', 0, '', '', '', '2022-06-11 07:53:00', 6, '2022-06-11 07:53:00', NULL, NULL, NULL, 1),
(12, 'anting-123', 'Anting Carribea', 5, 13, 6, '4.00', 12, 'Merah', 'Ya', '[\"dev\\/6\\/1654934102_SIPPSKPNKpng\",\"dev\\/6\\/1654934127_SIPPLOGO2PNGpng\"]', 0, '', '', '', '2022-06-11 07:55:02', 6, '2022-06-14 08:16:18', 6, NULL, NULL, 1),
(13, 'A', 'Custom A', 5, 13, 6, '3.00', 12, 'merah', 'Ya', '[\"dev\\/6\\/1654934298_checkoutfaildjpg\"]', 0, '', '', '', '2022-06-11 07:58:19', 6, '2022-06-11 07:58:54', NULL, NULL, NULL, 1),
(14, '', 'gh', NULL, 3, 6, '1.00', 9, 'biru', '', '[\"dev\\/6\\/1654934893_aatnw1jpeg\"]', 0, '', '', '', '2022-06-11 08:08:13', 6, '2022-06-11 08:08:13', NULL, NULL, NULL, 1),
(15, '1.22.1', 'Nikita Wilis', 7, 15, 9, '5.00', 15, 'Diamond', 'Ya', '[\"dev\\/6\\/1655103615_O1lix5eDBFamTQ6T11jpeg\"]', 0, '', '09909', '0909', '2022-06-13 07:00:15', 6, '2022-06-13 07:00:15', NULL, NULL, NULL, 1),
(16, '', 'NW101', NULL, 15, 9, '5.00', 15, 'amethyst', '', '[\"dev\\/6\\/1655104168_uvu9tQY416utlROr11jpeg\"]', 0, '', '', '', '2022-06-13 07:09:28', 6, '2022-06-13 07:09:28', NULL, NULL, NULL, 1),
(17, 'Stock Keeping Unit', 'SILVER', 8, 15, 10, '10.00', 15, 'aquamarine', 'Tidak', '[\"dev\\/6\\/1655108552_uvu9tQY416utlROr11jpeg\"]', 0, '', '102', '102', '2022-06-13 08:21:43', 6, '2022-06-13 08:22:33', NULL, NULL, NULL, 1),
(18, '', '10001000', NULL, 15, 9, '10.00', 12, 'Zaphir', '', '[\"dev\\/6\\/1655108989_uvu9tQY416utlROr11jpeg\"]', 0, '', '', '', '2022-06-13 08:29:50', 6, '2022-06-13 08:29:50', NULL, NULL, NULL, 1),
(19, '', 'fvhj,h,f', NULL, 15, 6, '1.00', 15, 'fdbdf', '', '[\"dev\\/6\\/1655288447_WhatsAppImage20220309at110551jpeg\"]', 0, '', '', '', '2022-06-15 10:20:48', 6, '2022-06-15 10:20:48', NULL, NULL, NULL, 1),
(20, '299292', 'Barang1', NULL, 17, 10, '12.00', 14, '12', '', '[\"dev\\/6\\/1655537964_21032022png\"]', 0, '', '', '', '2022-06-18 07:39:29', 6, '2022-06-18 07:39:29', 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-10', '2022-06-10', '123', 'Completed', '2022-06-10 09:11:55', 1, '2022-06-11 06:36:02', 6, NULL, NULL, 1),
(2, '123456789', 1, '2022-06-10', '2022-06-10', 'test', 'Completed', '2022-06-10 09:13:10', 1, '2022-06-11 06:36:02', 6, NULL, NULL, 1),
(3, '74747484', 1, '2022-06-10', '2022-06-10', 'desc', 'Completed', '2022-06-10 09:18:44', 1, '2022-06-11 06:35:35', 6, NULL, NULL, 1),
(4, '2357890444', 1, '2022-06-11', '2022-06-11', '', 'Completed', '2022-06-11 03:37:29', 1, '2022-06-11 06:36:46', 6, NULL, NULL, 1),
(5, '2357890999', 1, '2022-06-11', '2022-06-11', 'Role', 'Completed', '2022-06-11 03:46:30', 1, '2022-06-11 06:36:30', 6, NULL, NULL, 1),
(6, 'ABCDE', 1, '2022-06-11', '2022-06-11', 'Barang Order', 'Completed', '2022-06-11 03:53:40', 1, '2022-06-11 06:36:51', 6, NULL, NULL, 1),
(7, 'ABCDEFG', 1, '2022-06-11', '2022-06-11', 'sadsa', 'Completed', '2022-06-11 04:02:34', 1, '2022-06-11 06:35:35', 6, NULL, NULL, 1),
(8, '333434', 1, '2022-06-11', '2022-06-11', '323', 'Proses', '2022-06-11 06:34:30', 6, '2022-06-11 07:59:32', 6, NULL, NULL, 1),
(9, '1232135128375', 1, '2022-06-11', '2022-06-11', '12', 'New', '2022-06-11 07:52:59', 6, '2022-06-11 07:59:32', 6, NULL, NULL, 1),
(10, 'ABCDECCC', 1, '2022-06-11', '2022-06-15', 'Anting Carribea', 'New', '2022-06-11 07:58:18', 6, '2022-06-11 07:59:32', 6, NULL, NULL, 1),
(11, '1232313131', 1, '2022-06-11', '2022-06-11', ' ', 'New', '2022-06-11 08:06:59', 6, '2022-06-11 08:06:59', NULL, NULL, NULL, 1),
(12, 'edrg', 1, '2022-06-11', '2022-06-12', 'ghfh', 'New', '2022-06-11 08:08:13', 6, '2022-06-11 08:08:13', NULL, NULL, NULL, 1),
(13, '1221', 3, '2022-06-13', '2022-06-15', 'Permintaan barang 123', 'New', '2022-06-13 07:09:28', 6, '2022-06-13 07:09:28', NULL, NULL, NULL, 1),
(14, '102', 5, '2022-06-13', '2022-06-13', 'vowever 102', 'New', '2022-06-13 08:27:51', 6, '2022-06-13 08:27:51', NULL, NULL, NULL, 1),
(15, '103', 4, '2022-06-13', '2022-06-13', 'nikita wilis', 'New', '2022-06-13 08:29:49', 6, '2022-06-13 08:29:49', NULL, NULL, NULL, 1),
(16, 'asdsada', 4, '2022-06-15', '2022-12-03', 'online urgent', 'New', '2022-06-15 10:20:47', 6, '2022-06-15 10:23:26', 6, NULL, NULL, 1),
(17, 'test', 5, '2022-06-18', '2022-06-18', 'test', 'New', '2022-06-18 07:39:24', 6, '2022-06-18 07:39:24', 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_completed_quantity` int(11) DEFAULT 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;

--
-- Dumping data for table `order_items`
--

INSERT INTO `order_items` (`oi_id`, `oi_order_id`, `oi_item_id`, `oi_date`, `oi_start_date`, `oi_due_date`, `oi_completed_date`, `oi_item_name`, `oi_gc_id`, `oi_size_id`, `oi_weight`, `oi_quantity`, `oi_completed_quantity`, `oi_description`, `oi_sample_note`, `oi_image_1`, `oi_image_2`, `oi_status`, `oi_insert_at`, `oi_insert_admin_id`, `oi_update_at`, `oi_update_admin_id`, `oi_delete_at`, `oi_delete_admin_id`, `oi_active`) VALUES
(1, 1, 1, '2022-06-11', '2022-06-01', '2022-06-25', NULL, 'data1', 2, 5, '12.00', 12, 12, '', '', '[\"dev\\/1\\/1654852315_WhatsAppImage20220521at53423PMjpeg\"]', '', 'Completed', '2022-06-10 09:11:57', 6, '2022-06-11 06:35:35', 1, NULL, NULL, 1),
(2, 1, 2, '2022-06-11', '2022-06-10', '2022-06-25', NULL, 'data2', 2, 4, '23.00', 123, 123, '', '', '[\"dev\\/1\\/1654852316_WhatsAppImage20220521at53423PM2jpeg\"]', '', 'Completed', '2022-06-10 09:11:57', 6, '2022-06-11 06:36:02', 1, NULL, NULL, 1),
(3, 2, 3, '2022-06-11', '2022-06-10', '2022-06-25', NULL, 'data3', 3, 4, '12.00', 11, 11, '', '', '[\"dev\\/1\\/1654852390_WhatsAppImage20220521at53423PM2jpeg\",\"dev\\/1\\/1654852392_WhatsAppImage20220521at53423PM1jpeg\"]', '', 'Completed', '2022-06-10 09:13:13', 6, '2022-06-11 06:36:02', 1, NULL, NULL, 1),
(4, 2, 4, '2022-06-11', '2022-06-01', '2022-06-25', NULL, 'data4', 2, 4, '23.00', 12, 12, '', '', '[\"dev\\/1\\/1654852392_WhatsAppImage20220129at23402PM1jpeg\",\"dev\\/1\\/1654852392_WhatsAppImage20220129at23402PMjpeg\"]', '', 'Completed', '2022-06-10 09:13:13', 6, '2022-06-11 06:35:54', 1, NULL, NULL, 1),
(5, 3, 4, '2022-06-11', '2022-06-12', '2022-06-25', NULL, 'data4', 2, 4, '23.00', 123, 123, '', '', '[]', '', 'Completed', '2022-06-10 09:18:44', 6, '2022-06-11 06:36:39', 1, NULL, NULL, 1),
(6, 4, 5, '2022-06-11', '2022-06-11', '2022-06-25', NULL, 'item1', 6, 5, '2.00', 123, 123, '', '', '[\"dev\\/1\\/1654918649_faviconpng\",\"dev\\/1\\/1654918656_WhatsAppImage20220521at53423PM2jpeg\"]', '', 'Completed', '2022-06-11 03:37:38', 6, '2022-06-11 06:35:43', 6, NULL, NULL, 1),
(7, 4, 6, '2022-06-11', '2022-06-11', '2022-06-25', NULL, 'item2', 3, 5, '23.00', 12, 12, '', '', '[\"dev\\/1\\/1654918657_WhatsAppImage20220521at53422PMjpeg\",\"dev\\/1\\/1654918658_WhatsAppImage20220520at53146PMjpeg\"]', '', 'Completed', '2022-06-11 03:37:38', 6, '2022-06-11 06:36:46', 6, NULL, NULL, 1),
(8, 5, 7, '2022-06-11', '2022-06-11', '2022-06-25', NULL, 'item2', 6, 9, '123.00', 123, 123, '', '', '[\"dev\\/1\\/1654919190_WhatsAppImage20220521at53423PM1jpeg\",\"dev\\/1\\/1654919192_WhatsAppImage20220521at53423PMjpeg\"]', '', 'Completed', '2022-06-11 03:46:32', 6, '2022-06-11 06:36:30', 1, NULL, NULL, 1),
(9, 6, 4, '2022-06-11', '2022-06-11', '2022-06-25', NULL, 'data4', 2, 4, '23.00', 5, 5, '', '', '[]', '', 'Completed', '2022-06-11 03:53:40', 6, '2022-06-11 06:36:51', 6, NULL, NULL, 1),
(10, 7, 3, '2022-06-11', '2022-06-11', '2022-06-25', NULL, 'data3', 3, 4, '12.00', 2, 2, '', '', '[]', '', 'Completed', '2022-06-11 04:02:34', 6, '2022-06-11 06:36:10', 1, NULL, NULL, 1),
(11, 8, 7, '2022-06-11', '2022-06-11', '2022-06-11', NULL, 'item2', 6, 9, '123.00', 12, 12, '', '', '[]', '', 'Completed', '2022-06-11 06:34:32', 6, '2022-06-11 07:59:32', 6, NULL, NULL, 1),
(12, 8, 8, '2022-06-11', '2022-06-11', '2022-06-11', NULL, 'brg1', 6, 9, '23.00', 12, 12, '', '', '[\"dev\\/6\\/1654929270_absesn03022022Copypng\",\"dev\\/6\\/1654929271_absesn03022022png\"]', '', 'Completed', '2022-06-11 06:34:32', 6, '2022-06-11 07:59:37', 6, NULL, NULL, 1),
(13, 8, 9, '2022-06-11', '2022-06-11', '2022-06-11', NULL, 'brg2', 6, 5, '12.00', 12, 12, '', '', '[\"dev\\/6\\/1654929271_JovanCopypng\",\"dev\\/6\\/1654929271_Jovanpng\"]', '', 'Completed', '2022-06-11 06:34:32', 6, '2022-06-11 07:59:40', 6, NULL, NULL, 1),
(14, 8, 10, '2022-06-11', NULL, '2022-06-11', NULL, 'brg3', 6, 5, '12.00', 12, NULL, '', '', '[\"dev\\/6\\/1654929272_JovanCopypng\",\"dev\\/6\\/1654929272_Jovanpng\"]', '', 'New', '2022-06-11 06:34:32', 6, '2022-06-11 06:34:32', NULL, NULL, NULL, 1),
(15, 9, 11, '2022-06-11', NULL, '2022-06-11', NULL, 'item22', 6, 9, '12.00', 12, NULL, '', '', '[\"dev\\/6\\/1654933979_JovanCopypng\",\"dev\\/6\\/1654933979_Jovanpng\"]', '', 'New', '2022-06-11 07:53:00', 6, '2022-06-11 07:53:00', NULL, NULL, NULL, 1),
(16, 9, 7, '2022-06-11', '2022-06-13', '2022-06-11', NULL, 'item2', 6, 9, '123.00', 22, NULL, '', '', '[]', '', 'New', '2022-06-11 07:53:00', 6, '2022-06-13 08:30:40', 6, NULL, NULL, 1),
(17, 10, 13, '2022-06-11', NULL, '2022-06-15', NULL, 'Custom A', 6, 12, '3.00', 3, NULL, '', '', '[\"dev\\/6\\/1654934298_checkoutfaildjpg\"]', '', 'New', '2022-06-11 07:58:19', 6, '2022-06-11 07:58:19', NULL, NULL, NULL, 1),
(18, 11, 12, '2022-06-11', '2022-06-14', '2022-06-11', NULL, 'Anting Carribea', 6, 12, '4.00', 23, NULL, '', '', '[]', '', 'New', '2022-06-11 08:06:59', 6, '2022-06-14 08:16:18', 6, NULL, NULL, 1),
(19, 12, 14, '2022-06-11', '2022-06-11', '2022-06-12', NULL, 'gh', 6, 9, '1.00', 12, NULL, '', '', '[\"dev\\/6\\/1654934893_aatnw1jpeg\"]', '', 'New', '2022-06-11 08:08:13', 6, '2022-06-11 08:11:07', 6, NULL, NULL, 1),
(20, 13, 16, '2022-06-13', '2022-06-13', '2022-06-15', NULL, 'NW101', 9, 15, '5.00', 2, NULL, '', '', '[\"dev\\/6\\/1655104168_uvu9tQY416utlROr11jpeg\"]', '', 'New', '2022-06-13 07:09:28', 6, '2022-06-13 08:06:53', 6, NULL, NULL, 1),
(21, 14, 17, '2022-06-13', NULL, '2022-06-13', NULL, 'SILVER', 10, 15, '10.00', 5, NULL, '', '', '[]', '', 'New', '2022-06-13 08:27:51', 6, '2022-06-13 08:27:51', NULL, NULL, NULL, 1),
(22, 15, 15, '2022-06-13', NULL, '2022-06-13', NULL, 'Nikita Wilis', 9, 15, '5.00', -5, NULL, '', '', '[]', '', 'New', '2022-06-13 08:29:50', 6, '2022-06-13 08:29:50', NULL, NULL, NULL, 1),
(23, 15, 18, '2022-06-13', '2022-06-13', '2022-06-13', NULL, '10001000', 9, 12, '10.00', 2, NULL, '', '', '[\"dev\\/6\\/1655108989_uvu9tQY416utlROr11jpeg\"]', '', 'New', '2022-06-13 08:29:50', 6, '2022-06-13 08:30:40', 6, NULL, NULL, 1),
(24, 16, 19, '2022-06-15', NULL, '2022-05-03', NULL, 'fvhj,h,f', 6, 15, '1.00', 53, NULL, '', '', '[\"dev\\/6\\/1655288447_WhatsAppImage20220309at110551jpeg\"]', '', 'New', '2022-06-15 10:20:48', 6, '2022-06-15 10:20:48', NULL, NULL, NULL, 1),
(25, 17, 20, '2022-06-18', NULL, '2022-06-18', NULL, 'Barang1', 10, 14, '12.00', 12, NULL, '', '', '[\"dev\\/6\\/1655537964_21032022png\"]', '', 'New', '2022-06-18 07:39:29', 6, '2022-06-18 07:39:29', NULL, NULL, NULL, 1);

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

--
-- 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, 'test', 'test', '2022-05-30 08:17:11', 1, '2022-06-11 02:34:31', 1, NULL, NULL, 1),
(6, 'test2d', 'test2d', '2022-05-30 08:17:59', 1, '2022-06-07 08:38:44', NULL, '2022-06-07 08:38:44', 1, 0),
(7, 'testkk', 'testkk', '2022-06-07 08:16:17', 1, '2022-06-07 08:38:42', NULL, '2022-06-07 08:38:42', 1, 0),
(8, 'test-33-m', 'test 33 m', '2022-06-07 08:37:30', 1, '2022-06-07 08:38:39', 1, '2022-06-07 08:38:39', 1, 0),
(9, 'test3', 'test3', '2022-06-11 03:38:01', 1, '2022-06-11 03:38:01', NULL, NULL, NULL, 1),
(10, '11-12', '11-12', '2022-06-11 03:50:45', 1, '2022-06-11 03:50:48', 1, '2022-06-11 02:50:48', 1, 0),
(11, '11-12', '11-12', '2022-06-11 03:50:54', 1, '2022-06-11 03:50:55', NULL, '2022-06-11 02:50:55', 1, 0),
(12, '11-12', '11-12', '2022-06-11 07:53:40', 6, '2022-06-13 06:51:14', 6, NULL, NULL, 1),
(13, '10ct', '10CT', '2022-06-13 06:51:29', 6, '2022-06-13 06:51:43', 6, '2022-06-13 05:51:43', 6, 0),
(14, '10ct', '10CT', '2022-06-13 06:51:52', 6, '2022-06-13 06:51:52', NULL, NULL, NULL, 1),
(15, '10tl', '10TL', '2022-06-13 06:56:32', 6, '2022-06-13 06:57:02', 6, NULL, NULL, 1),
(16, 'vowever-102', 'Vowever 102', '2022-06-13 08:11:24', 6, '2022-06-13 08:16:58', NULL, '2022-06-13 07:16:58', 6, 0);

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

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

--
-- Dumping data for table `tasks`
--

INSERT INTO `tasks` (`task_id`, `task_code`, `task_name`, `task_input_list`, `task_output_list`, `task_input_notification_list`, `task_output_notification_list`, `task_pic_admin_id`, `task_insert_at`, `task_insert_admin_id`, `task_update_at`, `task_update_admin_id`, `task_delete_at`, `task_delete_admin_id`, `task_active`) VALUES
(1, 'tes', 'Tes', '', '', '1,5,6,7', '1,5,6,7', 0, '2022-06-16 08:36:06', 6, '2022-06-16 08:36:06', NULL, NULL, NULL, 1),
(2, 'ccccc', 'ccccc', '', '', '1,5,6,7', '1,5,6,7', 0, '2022-06-16 08:38:12', 6, '2022-06-16 08:38:12', NULL, NULL, NULL, 1),
(3, 'ccccc33', 'ccccc33', '', '', '1,5,6,7', '1,5,6,7', 0, '2022-06-16 08:38:59', 6, '2022-06-16 08:38:59', NULL, NULL, NULL, 1),
(4, 'aku', 'aku', '', '', '1,5,6,7', '1,5,6,7', 0, '2022-06-16 08:39:38', 6, '2022-06-16 08:39:38', NULL, NULL, NULL, 1),
(5, 'poles', 'Poles', '', '', '1,5,6,7', '1,5,6,7', 0, '2022-06-16 09:06:15', 6, '2022-06-16 09:06:15', NULL, NULL, NULL, 1);

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

--
-- Table structure for table `task_input_fields`
--

CREATE TABLE `task_input_fields` (
  `tif_id` int(11) NOT NULL,
  `tif_task_id` int(11) NOT NULL,
  `tif_if_id` int(11) NOT NULL,
  `tif_order` int(11) NOT NULL,
  `tif_is_required` int(11) NOT NULL,
  `tif_type` varchar(10) NOT NULL,
  `tif_insert_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `tif_insert_admin_id` int(11) NOT NULL,
  `tif_update_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(),
  `tif_update_admin_id` int(11) DEFAULT NULL,
  `tif_delete_at` timestamp NULL DEFAULT NULL,
  `tif_delete_admin_id` int(11) DEFAULT NULL,
  `tif_active` int(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `task_input_fields`
--

INSERT INTO `task_input_fields` (`tif_id`, `tif_task_id`, `tif_if_id`, `tif_order`, `tif_is_required`, `tif_type`, `tif_insert_at`, `tif_insert_admin_id`, `tif_update_at`, `tif_update_admin_id`, `tif_delete_at`, `tif_delete_admin_id`, `tif_active`) VALUES
(1, 3, 3, 1, 0, 'input', '2022-06-16 08:38:59', 0, NULL, NULL, NULL, NULL, 0),
(2, 3, 4, 2, 0, 'input', '2022-06-16 08:38:59', 0, NULL, NULL, NULL, NULL, 0),
(3, 3, 1, 3, 0, 'input', '2022-06-16 08:38:59', 0, NULL, NULL, NULL, NULL, 0),
(4, 3, 2, 4, 0, 'input', '2022-06-16 08:38:59', 0, NULL, NULL, NULL, NULL, 0),
(5, 3, 3, 1, 0, 'output', '2022-06-16 08:38:59', 0, NULL, NULL, NULL, NULL, 0),
(6, 3, 4, 2, 0, 'output', '2022-06-16 08:38:59', 0, NULL, NULL, NULL, NULL, 0),
(7, 3, 1, 3, 0, 'output', '2022-06-16 08:38:59', 0, NULL, NULL, NULL, NULL, 0),
(8, 3, 2, 4, 0, 'output', '2022-06-16 08:38:59', 0, NULL, NULL, NULL, NULL, 0),
(9, 4, 3, 1, 1, 'input', '2022-06-16 08:39:39', 0, NULL, NULL, NULL, NULL, 0),
(10, 4, 4, 2, 1, 'input', '2022-06-16 08:39:39', 0, NULL, NULL, NULL, NULL, 0),
(11, 4, 1, 3, 0, 'input', '2022-06-16 08:39:39', 0, NULL, NULL, NULL, NULL, 0),
(12, 4, 2, 4, 0, 'input', '2022-06-16 08:39:39', 0, NULL, NULL, NULL, NULL, 0),
(13, 4, 3, 1, 1, 'output', '2022-06-16 08:39:39', 0, NULL, NULL, NULL, NULL, 0),
(14, 4, 4, 2, 1, 'output', '2022-06-16 08:39:39', 0, NULL, NULL, NULL, NULL, 0),
(15, 4, 1, 3, 0, 'output', '2022-06-16 08:39:39', 0, NULL, NULL, NULL, NULL, 0),
(16, 4, 2, 4, 0, 'output', '2022-06-16 08:39:39', 0, NULL, NULL, NULL, NULL, 0),
(17, 5, 3, 1, 1, 'input', '2022-06-16 09:06:15', 0, NULL, NULL, NULL, NULL, 0),
(18, 5, 4, 2, 1, 'input', '2022-06-16 09:06:15', 0, NULL, NULL, NULL, NULL, 0),
(19, 5, 1, 3, 0, 'input', '2022-06-16 09:06:15', 0, NULL, NULL, NULL, NULL, 0),
(20, 5, 2, 4, 0, 'input', '2022-06-16 09:06:15', 0, NULL, NULL, NULL, NULL, 0),
(21, 5, 3, 1, 1, 'output', '2022-06-16 09:06:15', 0, NULL, NULL, NULL, NULL, 0),
(22, 5, 4, 2, 1, 'output', '2022-06-16 09:06:15', 0, NULL, NULL, NULL, NULL, 0),
(23, 5, 1, 3, 0, 'output', '2022-06-16 09:06:15', 0, NULL, NULL, NULL, NULL, 0),
(24, 5, 2, 4, 0, 'output', '2022-06-16 09:06:15', 0, NULL, NULL, NULL, NULL, 0);

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

--
-- 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.59', '2022-05-30 02:53:00', 1, '2022-06-10 08:12:35', 1, NULL, 0, 1),
(5, 'tree-2', 'Tree 2', '22.00', '2022-05-30 03:00:06', 1, '2022-06-07 09:16:02', 1, '2022-06-07 09:16:02', 1, 0),
(6, 'testee', 'testee', '12.00', '2022-06-07 09:12:46', 1, '2022-06-07 09:15:51', 0, '2022-06-07 09:15:51', 1, 0),
(7, 'test44', 'test44', '124.00', '2022-06-07 09:15:09', 1, '2022-06-07 09:15:46', 1, '2022-06-07 09:15:46', 1, 0),
(8, 'coba345', 'coba345', '244.00', '2022-06-11 02:36:25', 1, '2022-06-13 08:13:45', 1, '2022-06-13 07:13:45', 6, 0),
(9, 'coba34', 'coba34', '12.00', '2022-06-11 02:38:11', 1, '2022-06-13 06:54:56', 0, '2022-06-13 05:54:56', 6, 0),
(10, '12', '12', '150.24', '2022-06-11 03:51:12', 1, '2022-06-11 03:51:17', 1, '2022-06-11 02:51:17', 1, 0),
(11, 'a', 'A', '169.98', '2022-06-11 07:53:55', 6, NULL, 0, NULL, 0, 1),
(12, 'kf94', 'KF94', '10.00', '2022-06-13 06:53:11', 6, '2022-06-13 06:53:25', 6, '2022-06-13 05:53:25', 6, 0),
(13, 'kf94', 'KF94', '0.10', '2022-06-13 06:53:34', 6, '2022-06-13 06:54:30', 6, NULL, 0, 1),
(14, 'kn95', 'KN95', '10.00', '2022-06-13 06:55:47', 6, NULL, 0, NULL, 0, 1),
(15, '201', '201', '10.00', '2022-06-13 08:12:45', 6, '2022-06-13 08:18:48', 6, 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;

--
-- Dumping data for table `tree_histories`
--

INSERT INTO `tree_histories` (`th_id`, `th_tree_id`, `th_weight_from`, `th_weight_to`, `th_description`, `th_update_at`, `th_update_admin_id`) VALUES
(1, 4, '12.00', '12.50', '', '2022-06-10 08:10:51', 1),
(2, 4, '12.50', '12.59', '', '2022-06-10 08:12:35', 1),
(3, 8, '2442.00', '2442.00', '', '2022-06-11 02:43:12', 1),
(4, 8, '2442.00', '2442.00', '', '2022-06-11 02:45:03', 1),
(5, 8, '2442.00', '244.00', '', '2022-06-11 02:46:35', 1),
(6, 10, '150.24', '150.24', '', '2022-06-11 03:51:15', 1),
(7, 12, '5.00', '10.00', '', '2022-06-13 06:53:21', 6),
(8, 13, '10.00', '0.10', '', '2022-06-13 06:54:30', 6),
(9, 13, '0.10', '0.10', '', '2022-06-13 06:54:47', 6),
(10, 15, '10.00', '10.00', '', '2022-06-13 08:18:48', 6);

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

--
-- 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),
(3, 'rerer-ee', 'rerer ee', '2022-06-07 09:32:01', 1, '2022-06-07 09:33:08', 1, NULL, NULL, 1),
(4, '23456', '23456', '2022-06-07 09:32:59', 1, '2022-06-07 09:33:05', NULL, '2022-06-07 09:33:05', 1, 0),
(5, 'alur-kerja-anting-batu', 'alur kerja anting batu', '2022-06-11 02:38:26', 1, '2022-06-11 07:54:07', 6, NULL, NULL, 1),
(6, 'pencetakan', 'Pencetakan', '2022-06-13 06:57:34', 6, '2022-06-13 06:57:34', NULL, NULL, NULL, 1),
(7, 'permintaan-bahan-baku', 'Permintaan Bahan Baku', '2022-06-13 06:57:50', 6, '2022-06-13 06:58:12', 6, NULL, NULL, 1),
(8, 'peleburan', 'Peleburan', '2022-06-13 08:13:06', 6, '2022-06-13 08:13:06', 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 `batches`
--
ALTER TABLE `batches`
  ADD PRIMARY KEY (`batch_id`);

--
-- Indexes for table `batch_items`
--
ALTER TABLE `batch_items`
  ADD PRIMARY KEY (`bi_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 `input_fields`
--
ALTER TABLE `input_fields`
  ADD PRIMARY KEY (`if_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 `task_input_fields`
--
ALTER TABLE `task_input_fields`
  ADD PRIMARY KEY (`tif_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=84;

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

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

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

--
-- AUTO_INCREMENT for table `batches`
--
ALTER TABLE `batches`
  MODIFY `batch_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `batch_items`
--
ALTER TABLE `batch_items`
  MODIFY `bi_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

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

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

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

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

--
-- AUTO_INCREMENT for table `input_fields`
--
ALTER TABLE `input_fields`
  MODIFY `if_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

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

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

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

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

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

--
-- AUTO_INCREMENT for table `task_input_fields`
--
ALTER TABLE `task_input_fields`
  MODIFY `tif_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

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

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

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

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

