/*
SQLyog Ultimate v11.11 (64 bit)
MySQL - 5.5.5-10.1.9-MariaDB : Database - rtangga-db-live
*********************************************************************
*/




/*Table structure for table `budgets` */


CREATE TABLE `budgets` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `cost_center_id` bigint(20) NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `amount` decimal(20,0) NOT NULL DEFAULT '0',
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint(20) DEFAULT NULL,
  `updated_by` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `cost_center_id` (`cost_center_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*Data for the table `budgets` */

insert  into `budgets`(`id`,`cost_center_id`,`name`,`amount`,`description`,`created_at`,`updated_at`,`created_by`,`updated_by`) values (1,1,'Lainnya - Perayaan/Pertemuan',1348750000,'Biaya rapat/pertemuan selama 1 (satu) Tahun','2023-11-06 03:32:47','2023-11-06 03:32:47',1,1);

/*Table structure for table `cost_centers` */


CREATE TABLE `cost_centers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint(20) DEFAULT NULL,
  `updated_by` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*Data for the table `cost_centers` */

insert  into `cost_centers`(`id`,`name`,`description`,`created_at`,`updated_at`,`created_by`,`updated_by`) values (1,'690120002','Lainnya - Rapat/Pertemuan','2023-11-06 03:28:38','2023-11-06 03:28:38',1,1);

/*Table structure for table `delivery_mans` */


CREATE TABLE `delivery_mans` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `badge` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `status` int(11) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint(20) DEFAULT NULL,
  `updated_by` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*Data for the table `delivery_mans` */

/*Table structure for table `distribution_place_user` */


CREATE TABLE `distribution_place_user` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) NOT NULL,
  `distribution_place_id` int(10) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint(20) DEFAULT NULL,
  `updated_by` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `distribution_place_user` */

/*Table structure for table `distribution_places` */


CREATE TABLE `distribution_places` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(40) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `created_by` bigint(20) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

/*Data for the table `distribution_places` */

insert  into `distribution_places`(`id`,`name`,`created_at`,`created_by`,`updated_at`,`updated_by`) values (1,'Wisma',NULL,NULL,NULL,NULL),(2,'Gedung CO',NULL,NULL,NULL,NULL);

/*Table structure for table `events` */


CREATE TABLE `events` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint(20) DEFAULT NULL,
  `updated_by` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*Data for the table `events` */

insert  into `events`(`id`,`name`,`description`,`created_at`,`updated_at`,`created_by`,`updated_by`) values (1,'Lembur Rutin','Nasi Lembur Rutin untuk Karyawan','2023-11-06 03:55:04','2023-11-06 04:00:09',1,1),(2,'Lembur Shurdown','-','2023-11-06 03:55:59','2023-11-06 04:00:19',1,1),(3,'Lembur Perta','-','2023-11-06 03:56:36','2023-11-06 03:59:49',1,1),(4,'Open Storage','Air Mineral,  Soft Drink, Gula, Kopi dan Teh','2023-11-06 03:57:59','2023-11-06 04:01:31',1,1),(5,'Extra Fooding Shift','-','2023-11-06 03:58:37','2023-11-06 03:58:37',1,1),(6,'Extra Fooding SKJ','-','2023-11-06 03:59:01','2023-11-06 03:59:01',1,1),(7,'Rapat Internal','Rapat Internal Unit Kerja','2023-12-05 03:08:20','2023-12-05 03:08:20',25,25);

/*Table structure for table `guests` */


CREATE TABLE `guests` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint(20) DEFAULT NULL,
  `updated_by` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*Data for the table `guests` */

insert  into `guests`(`id`,`name`,`description`,`created_at`,`updated_at`,`created_by`,`updated_by`) values (1,'VIP',NULL,'2023-11-06 04:04:41','2023-11-06 04:04:41',1,NULL),(2,'VVIP',NULL,'2023-11-06 04:04:54','2023-11-06 04:04:54',1,NULL),(3,'Regular',NULL,'2023-11-06 04:05:11','2023-11-06 04:05:11',1,NULL),(4,'Standar',NULL,'2023-11-06 04:05:31','2023-11-06 04:05:31',1,NULL),(5,'PERTA',NULL,'2023-11-06 04:06:20','2023-11-06 04:06:20',1,NULL);

/*Table structure for table `invoice_details` */


CREATE TABLE `invoice_details` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `invoice_id` bigint(20) DEFAULT NULL,
  `menu_id` bigint(20) DEFAULT NULL,
  `menu_serve_of_order_id` bigint(20) DEFAULT NULL,
  `detail_menu_name` varchar(255) DEFAULT NULL,
  `unit_id` int(11) DEFAULT NULL,
  `qty` int(11) DEFAULT NULL,
  `price` decimal(20,2) DEFAULT '0.00',
  `total_price` decimal(20,2) DEFAULT '0.00',
  `status` smallint(1) DEFAULT NULL,
  `is_buffe` smallint(1) DEFAULT NULL,
  `created_by` bigint(20) DEFAULT NULL,
  `updated_by` bigint(20) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

/*Data for the table `invoice_details` */

insert  into `invoice_details`(`id`,`invoice_id`,`menu_id`,`menu_serve_of_order_id`,`detail_menu_name`,`unit_id`,`qty`,`price`,`total_price`,`status`,`is_buffe`,`created_by`,`updated_by`,`created_at`,`updated_at`) values (7,3,8,2,'paket lengkap + kerupuk',1,20,25000.00,500000.00,1,NULL,23,NULL,'2023-12-05 01:41:04','2023-12-05 01:41:04');

/*Table structure for table `invoices` */


CREATE TABLE `invoices` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `invoice_number` varchar(20) DEFAULT NULL,
  `order_id` bigint(20) DEFAULT NULL,
  `invoice_date` date DEFAULT NULL,
  `created_by` bigint(20) DEFAULT NULL,
  `updated_by` bigint(20) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

/*Data for the table `invoices` */

insert  into `invoices`(`id`,`invoice_number`,`order_id`,`invoice_date`,`created_by`,`updated_by`,`created_at`,`updated_at`) values (3,'INV/0231204/0001',4,'2023-12-04',23,NULL,'2023-12-05 01:41:04','2023-12-05 01:41:04');

/*Table structure for table `menu_of_order_time` */


CREATE TABLE `menu_of_order_time` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `menu_of_order_id` int(10) NOT NULL,
  `time_id` int(10) NOT NULL,
  `created_by` bigint(20) DEFAULT NULL,
  `updated_by` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_at` bigint(20) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;

/*Data for the table `menu_of_order_time` */

insert  into `menu_of_order_time`(`id`,`menu_of_order_id`,`time_id`,`created_by`,`updated_by`,`created_at`,`updated_at`) values (8,1,1,NULL,'2023-12-01 14:17:46',2023,'2023-12-01 07:17:46'),(10,4,4,NULL,'2023-12-01 14:18:58',2023,'2023-12-01 07:18:58'),(11,3,3,NULL,'2023-12-01 14:19:00',2023,'2023-12-01 07:19:00'),(12,2,2,NULL,'2023-12-01 14:19:02',2023,'2023-12-01 07:19:02'),(13,7,3,NULL,'2023-12-01 14:20:18',2023,'2023-12-01 07:20:18'),(14,6,2,NULL,'2023-12-01 14:20:19',2023,'2023-12-01 07:20:19'),(15,5,1,NULL,'2023-12-01 14:20:21',2023,'2023-12-01 07:20:21'),(16,8,1,NULL,'2023-12-04 13:52:16',2023,'2023-12-04 06:52:16'),(17,8,2,NULL,'2023-12-04 13:52:16',2023,'2023-12-04 06:52:16'),(18,8,3,NULL,'2023-12-04 13:52:16',2023,'2023-12-04 06:52:16'),(19,8,4,NULL,'2023-12-04 13:52:16',2023,'2023-12-04 06:52:16'),(20,8,5,NULL,'2023-12-04 13:52:16',2023,'2023-12-04 06:52:16');

/*Table structure for table `menu_of_order_unit` */


CREATE TABLE `menu_of_order_unit` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `menu_of_order_id` int(10) NOT NULL,
  `unit_id` int(10) NOT NULL,
  `created_by` bigint(20) DEFAULT NULL,
  `updated_by` bigint(20) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=latin1;

/*Data for the table `menu_of_order_unit` */

insert  into `menu_of_order_unit`(`id`,`menu_of_order_id`,`unit_id`,`created_by`,`updated_by`,`created_at`,`updated_at`) values (1,1,1,NULL,NULL,'2023-12-01 07:17:46','2023-12-01 07:17:46'),(2,1,2,NULL,NULL,'2023-12-01 07:17:46','2023-12-01 07:17:46'),(3,1,8,NULL,NULL,'2023-12-01 07:17:46','2023-12-01 07:17:46'),(4,1,19,NULL,NULL,'2023-12-01 07:17:46','2023-12-01 07:17:46'),(5,1,4,NULL,NULL,'2023-12-01 07:17:46','2023-12-01 07:17:46'),(11,4,1,NULL,NULL,'2023-12-01 07:18:58','2023-12-01 07:18:58'),(12,4,2,NULL,NULL,'2023-12-01 07:18:58','2023-12-01 07:18:58'),(13,4,8,NULL,NULL,'2023-12-01 07:18:58','2023-12-01 07:18:58'),(14,4,19,NULL,NULL,'2023-12-01 07:18:58','2023-12-01 07:18:58'),(15,4,4,NULL,NULL,'2023-12-01 07:18:58','2023-12-01 07:18:58'),(16,3,1,NULL,NULL,'2023-12-01 07:19:00','2023-12-01 07:19:00'),(17,3,2,NULL,NULL,'2023-12-01 07:19:00','2023-12-01 07:19:00'),(18,3,8,NULL,NULL,'2023-12-01 07:19:00','2023-12-01 07:19:00'),(19,3,19,NULL,NULL,'2023-12-01 07:19:00','2023-12-01 07:19:00'),(20,3,4,NULL,NULL,'2023-12-01 07:19:00','2023-12-01 07:19:00'),(21,2,1,NULL,NULL,'2023-12-01 07:19:02','2023-12-01 07:19:02'),(22,2,2,NULL,NULL,'2023-12-01 07:19:02','2023-12-01 07:19:02'),(23,2,8,NULL,NULL,'2023-12-01 07:19:02','2023-12-01 07:19:02'),(24,2,19,NULL,NULL,'2023-12-01 07:19:02','2023-12-01 07:19:02'),(25,2,4,NULL,NULL,'2023-12-01 07:19:02','2023-12-01 07:19:02'),(26,7,10,NULL,NULL,'2023-12-01 07:20:18','2023-12-01 07:20:18'),(27,7,8,NULL,NULL,'2023-12-01 07:20:18','2023-12-01 07:20:18'),(28,7,19,NULL,NULL,'2023-12-01 07:20:18','2023-12-01 07:20:18'),(29,7,12,NULL,NULL,'2023-12-01 07:20:18','2023-12-01 07:20:18'),(30,7,4,NULL,NULL,'2023-12-01 07:20:18','2023-12-01 07:20:18'),(31,6,10,NULL,NULL,'2023-12-01 07:20:19','2023-12-01 07:20:19'),(32,6,8,NULL,NULL,'2023-12-01 07:20:19','2023-12-01 07:20:19'),(33,6,19,NULL,NULL,'2023-12-01 07:20:19','2023-12-01 07:20:19'),(34,6,12,NULL,NULL,'2023-12-01 07:20:19','2023-12-01 07:20:19'),(35,6,4,NULL,NULL,'2023-12-01 07:20:19','2023-12-01 07:20:19'),(36,5,10,NULL,NULL,'2023-12-01 07:20:21','2023-12-01 07:20:21'),(37,5,8,NULL,NULL,'2023-12-01 07:20:21','2023-12-01 07:20:21'),(38,5,19,NULL,NULL,'2023-12-01 07:20:21','2023-12-01 07:20:21'),(39,5,12,NULL,NULL,'2023-12-01 07:20:21','2023-12-01 07:20:21'),(40,5,4,NULL,NULL,'2023-12-01 07:20:21','2023-12-01 07:20:21'),(41,8,1,NULL,NULL,'2023-12-04 06:52:16','2023-12-04 06:52:16');

/*Table structure for table `menu_of_orders` */


CREATE TABLE `menu_of_orders` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint(20) DEFAULT NULL,
  `updated_by` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*Data for the table `menu_of_orders` */

insert  into `menu_of_orders`(`id`,`name`,`description`,`created_at`,`updated_at`,`created_by`,`updated_by`) values (1,'Makan Pagi',NULL,'2023-11-06 04:13:24','2023-11-06 04:13:24',1,1),(2,'Makan Siang',NULL,'2023-11-06 04:13:35','2023-11-06 04:13:35',1,1),(3,'Makan Sore',NULL,'2023-11-06 04:13:50','2023-11-06 04:13:50',1,1),(4,'Makan Malam',NULL,'2023-11-06 04:14:01','2023-11-06 04:14:01',1,1),(5,'Snack Pagi',NULL,'2023-11-06 04:14:18','2023-11-06 04:14:18',1,1),(6,'Snack Siang',NULL,'2023-11-06 04:14:31','2023-11-06 04:14:31',1,1),(7,'Snack Sore',NULL,'2023-11-06 04:14:47','2023-11-06 04:14:47',1,1),(8,'Lembur Rutin','Konsumsii untuk lembur rutin','2023-12-04 06:52:16','2023-12-04 06:52:16',22,22);

/*Table structure for table `menu_serve_of_orders` */


CREATE TABLE `menu_serve_of_orders` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `budget_id` bigint(20) NOT NULL,
  `vendor_id` bigint(20) NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `price` decimal(20,0) NOT NULL DEFAULT '0',
  `margin_status` int(11) NOT NULL DEFAULT '0',
  `event_status` int(11) NOT NULL DEFAULT '0',
  `is_buffe` smallint(1) NOT NULL DEFAULT '0',
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint(20) DEFAULT NULL,
  `updated_by` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*Data for the table `menu_serve_of_orders` */

insert  into `menu_serve_of_orders`(`id`,`budget_id`,`vendor_id`,`name`,`price`,`margin_status`,`event_status`,`is_buffe`,`description`,`created_at`,`updated_at`,`created_by`,`updated_by`) values (1,1,1,'Soto Semarang',33500,1,1,1,NULL,'2023-11-06 04:18:34','2023-11-06 04:18:34',1,1),(2,1,1,'Soto Semarang',25000,1,1,0,NULL,'2023-11-06 04:19:54','2023-11-06 04:19:54',1,1),(3,2,1,'Snack Pagi',15000,1,1,0,'Makanan cemilan (2 Gorengan, 1 Kue Basah, 1Buah Segar, 1Air Mineral Gelas)','2023-11-23 00:22:06','2023-11-23 00:22:06',1,1),(4,2,7,'Snack',10000,1,1,1,'OK','2023-12-04 05:00:56','2023-12-04 05:00:56',29,29);

/*Table structure for table `menus` */


CREATE TABLE `menus` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `icon` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `parent_id` bigint(20) DEFAULT NULL,
  `number` bigint(20) NOT NULL,
  `is_active` int(11) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*Data for the table `menus` */

insert  into `menus`(`id`,`name`,`icon`,`slug`,`parent_id`,`number`,`is_active`,`created_at`,`updated_at`) values (1,'MONITORING','fa-tachometer-alt','dashboard',NULL,1,1,NULL,NULL),(2,'SETTING','fa fa-cogs','settings',NULL,2,1,NULL,NULL),(3,'MASTER','fa fa-cubes','master',NULL,3,1,NULL,NULL),(4,'TRANSAKSI','fa fa-history','transaksi',NULL,4,1,NULL,NULL),(6,'GL Account','fa-money-check-alt','cost-center',3,1,1,NULL,NULL),(7,'Budget','fa-tag','budget',3,2,1,NULL,NULL),(8,'Satuan','fa-balance-scale','unit',3,3,1,NULL,NULL),(9,'Mitra','fa fa-utensils','vendor',3,4,1,NULL,NULL),(10,'Kegiatan','fa fa-calendar','event',3,5,1,NULL,NULL),(11,'Kurir','fa fa-biking','kurir',3,6,1,NULL,NULL),(12,'Tamu','fa fa-child','tamu',3,7,1,NULL,NULL),(13,'Menu Order','fa-list','order-menus',3,8,1,NULL,NULL),(14,'Menu Order Layanan','fa-list-alt','serve-order-menus',3,9,1,NULL,NULL),(15,'Alamat Pengiriman','fa-address-card','place-of-delivery',3,10,1,NULL,NULL),(16,'Pesanan','fa-bars','orders',4,1,1,NULL,NULL),(17,'Pengiriman','fa-shipping-fast','shippings',4,2,1,NULL,NULL),(18,'Penerimaan','fa-hand-holding','delivery',4,3,1,NULL,NULL),(20,'Kelola Groups','fa-users','role',2,1,1,NULL,NULL),(21,'Kelola Pengguna','fa-user','users',2,2,1,NULL,NULL),(22,'Laporan','fa-list','report',NULL,5,1,'2023-11-23 00:00:00','2023-11-23 00:00:00'),(23,'Pesanan','fa-th-list','order_report',22,1,1,'2023-11-23 00:00:00','2023-11-23 00:00:00'),(24,'Waktu','fa-clock','time',3,7,1,'2023-12-01 00:00:00','2023-12-01 00:00:00');

/*Table structure for table `migrations` */


CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*Data for the table `migrations` */

insert  into `migrations`(`id`,`migration`,`batch`) values (1,'2023_06_11_141621_create_users_table',1),(2,'2023_06_11_144937_create_roles_table',1),(3,'2023_06_11_145052_create_role_user_table',1),(4,'2023_07_02_065811_create_init_table',1),(5,'2023_07_02_071234_create_order_table',1),(6,'2023_08_18_100001_create_menus_table',1);

/*Table structure for table `notifications` */


CREATE TABLE `notifications` (
  `id` char(36) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `notifiable_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `notifiable_id` bigint(20) unsigned NOT NULL,
  `data` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `read_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `notifications` */

/*Table structure for table `order_delivery_mans` */


CREATE TABLE `order_delivery_mans` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint(20) NOT NULL,
  `user_id` int(10) NOT NULL,
  `distribution_place_id` int(10) NOT NULL,
  `delivery_date` date NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint(20) DEFAULT NULL,
  `updated_by` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*Data for the table `order_delivery_mans` */

/*Table structure for table `order_details` */


CREATE TABLE `order_details` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint(20) NOT NULL,
  `menu_id` bigint(20) NOT NULL,
  `menu_serve_of_order_id` bigint(20) NOT NULL,
  `detail_menu_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `unit_id` int(11) NOT NULL,
  `qty` int(11) NOT NULL,
  `price` decimal(20,2) NOT NULL DEFAULT '0.00',
  `total_price` decimal(20,2) NOT NULL DEFAULT '0.00',
  `status` int(11) NOT NULL DEFAULT '1',
  `is_buffe` smallint(1) DEFAULT '0',
  `created_by` bigint(20) DEFAULT NULL,
  `updated_by` bigint(20) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*Data for the table `order_details` */

/*Table structure for table `order_statuses` */


CREATE TABLE `order_statuses` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint(20) NOT NULL,
  `status_id` int(10) NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `image` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint(20) DEFAULT NULL,
  `updated_by` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*Data for the table `order_statuses` */

/*Table structure for table `orders` */


CREATE TABLE `orders` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_number` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `event_id` bigint(20) NOT NULL,
  `event_detail_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `vendor_id` bigint(20) NOT NULL,
  `guest_id` int(11) NOT NULL,
  `guest_description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `place_of_order_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `place_of_order_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `customer_id` bigint(20) NOT NULL,
  `customer_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `customer_head1_id` bigint(20) NOT NULL,
  `customer_head1_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `customer_head2_id` bigint(20) NOT NULL,
  `customer_head2_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `place_of_delivery_order_id` bigint(20) NOT NULL,
  `place_of_delivery_order_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `delivery_order_date` date NOT NULL,
  `transaction_date` date NOT NULL,
  `time_id` int(10) NOT NULL,
  `total_price` decimal(20,2) NOT NULL DEFAULT '0.00',
  `description_order` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description_serve` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `source` varchar(1) COLLATE utf8_unicode_ci NOT NULL,
  `id_corpev` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `is_new` smallint(1) NOT NULL DEFAULT '1',
  `is_remove` smallint(1) NOT NULL DEFAULT '0',
  `created_by` bigint(20) DEFAULT NULL,
  `updated_by` bigint(20) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*Data for the table `orders` */

/*Table structure for table `payments` */


CREATE TABLE `payments` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `payment_number` varchar(20) NOT NULL,
  `invoice_id` bigint(20) NOT NULL,
  `payment_date` date NOT NULL,
  `bank_account` varchar(40) DEFAULT NULL,
  `account_name` varchar(50) DEFAULT NULL,
  `account_number` varchar(20) DEFAULT NULL,
  `recipient_bank_account` varchar(40) DEFAULT NULL,
  `recipient_account_name` varchar(40) DEFAULT NULL,
  `amount` decimal(20,0) DEFAULT NULL,
  `file` varchar(50) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `created_by` bigint(20) DEFAULT NULL,
  `updated_by` bigint(20) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `payments` */

/*Table structure for table `place_of_deliveries` */


CREATE TABLE `place_of_deliveries` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint(20) DEFAULT NULL,
  `updated_by` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*Data for the table `place_of_deliveries` */

insert  into `place_of_deliveries`(`id`,`name`,`description`,`created_at`,`updated_at`,`created_by`,`updated_by`) values (1,'Gedung LC',NULL,'2023-11-06 04:09:07','2023-11-06 04:09:07',1,1),(2,'Gedung Pusat Administrasi',NULL,'2023-11-06 04:09:36','2023-11-06 04:09:36',1,1),(3,'Gedung Purna Bhakti',NULL,'2023-11-06 04:09:53','2023-11-06 04:09:53',1,1),(4,'Gedung Anggrek',NULL,'2023-11-06 04:10:05','2023-11-06 04:10:05',1,1),(5,'Gedung Mawar',NULL,'2023-11-06 04:10:16','2023-11-06 04:10:16',1,1),(6,'Gedung Melati',NULL,'2023-11-06 04:10:29','2023-11-06 04:10:29',1,1),(7,'Gedung Maintenance Office',NULL,'2023-11-06 04:11:25','2023-11-06 04:11:25',1,1),(8,'Gedung Contraction Office',NULL,'2023-11-06 04:11:58','2023-11-06 04:11:58',1,1),(9,'Ruang 101 K',NULL,'2023-11-06 04:12:30','2023-11-06 04:12:30',1,1);

/*Table structure for table `place_of_orders` */


CREATE TABLE `place_of_orders` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint(20) DEFAULT NULL,
  `updated_by` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*Data for the table `place_of_orders` */

/*Table structure for table `role_user` */


CREATE TABLE `role_user` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `role_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint(20) DEFAULT NULL,
  `updated_by` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*Data for the table `role_user` */

insert  into `role_user`(`id`,`user_id`,`role_id`,`created_at`,`updated_at`,`created_by`,`updated_by`) values (1,1,1,'2023-09-20 14:14:49','2023-09-20 14:14:49',NULL,NULL),(2,2,2,'2023-09-20 14:14:49','2023-09-20 14:14:49',NULL,NULL),(62,23,6,'2023-12-04 07:01:13','2023-12-04 07:01:13',NULL,NULL);

/*Table structure for table `roles` */


CREATE TABLE `roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `permissions` text COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint(20) DEFAULT NULL,
  `updated_by` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*Data for the table `roles` */

insert  into `roles`(`id`,`title`,`slug`,`description`,`permissions`,`created_at`,`updated_at`,`created_by`,`updated_by`) values (1,'Super Admin','superadmin','Akses penuh ke dalam seluruh sistem aplikasi dan setting konfigurasi aplikasi','a:69:{i:0;s:13:\"viewDashboard\";i:1;s:10:\"createRole\";i:2;s:10:\"updateRole\";i:3;s:8:\"viewRole\";i:4;s:10:\"deleteRole\";i:5;s:11:\"createUsers\";i:6;s:11:\"updateUsers\";i:7;s:9:\"viewUsers\";i:8;s:11:\"deleteUsers\";i:9;s:17:\"createCost-center\";i:10;s:17:\"updateCost-center\";i:11;s:15:\"viewCost-center\";i:12;s:17:\"deleteCost-center\";i:13;s:12:\"createBudget\";i:14;s:12:\"updateBudget\";i:15;s:10:\"viewBudget\";i:16;s:12:\"deleteBudget\";i:17;s:10:\"createUnit\";i:18;s:10:\"updateUnit\";i:19;s:8:\"viewUnit\";i:20;s:10:\"deleteUnit\";i:21;s:12:\"createVendor\";i:22;s:12:\"updateVendor\";i:23;s:10:\"viewVendor\";i:24;s:12:\"deleteVendor\";i:25;s:11:\"createEvent\";i:26;s:11:\"updateEvent\";i:27;s:9:\"viewEvent\";i:28;s:11:\"deleteEvent\";i:29;s:11:\"createKurir\";i:30;s:11:\"updateKurir\";i:31;s:9:\"viewKurir\";i:32;s:11:\"deleteKurir\";i:33;s:10:\"createTamu\";i:34;s:10:\"updateTamu\";i:35;s:8:\"viewTamu\";i:36;s:10:\"deleteTamu\";i:37;s:10:\"createTime\";i:38;s:10:\"updateTime\";i:39;s:8:\"viewTime\";i:40;s:10:\"deleteTime\";i:41;s:17:\"createOrder-menus\";i:42;s:17:\"updateOrder-menus\";i:43;s:15:\"viewOrder-menus\";i:44;s:17:\"deleteOrder-menus\";i:45;s:23:\"createServe-order-menus\";i:46;s:23:\"updateServe-order-menus\";i:47;s:21:\"viewServe-order-menus\";i:48;s:23:\"deleteServe-order-menus\";i:49;s:23:\"createPlace-of-delivery\";i:50;s:23:\"updatePlace-of-delivery\";i:51;s:21:\"viewPlace-of-delivery\";i:52;s:23:\"deletePlace-of-delivery\";i:53;s:12:\"createOrders\";i:54;s:12:\"updateOrders\";i:55;s:10:\"viewOrders\";i:56;s:12:\"deleteOrders\";i:57;s:15:\"createShippings\";i:58;s:15:\"updateShippings\";i:59;s:13:\"viewShippings\";i:60;s:15:\"deleteShippings\";i:61;s:14:\"createDelivery\";i:62;s:14:\"updateDelivery\";i:63;s:12:\"viewDelivery\";i:64;s:14:\"deleteDelivery\";i:65;s:18:\"createOrder_report\";i:66;s:18:\"updateOrder_report\";i:67;s:16:\"viewOrder_report\";i:68;s:18:\"deleteOrder_report\";}',NULL,'2023-12-01 07:14:51',NULL,1),(2,'Admin','admin','Akses penuh ke dalam sistem aplikasi','a:65:{i:0;s:13:\"viewDashboard\";i:1;s:11:\"createUsers\";i:2;s:11:\"updateUsers\";i:3;s:9:\"viewUsers\";i:4;s:11:\"deleteUsers\";i:5;s:17:\"createCost-center\";i:6;s:17:\"updateCost-center\";i:7;s:15:\"viewCost-center\";i:8;s:17:\"deleteCost-center\";i:9;s:12:\"createBudget\";i:10;s:12:\"updateBudget\";i:11;s:10:\"viewBudget\";i:12;s:12:\"deleteBudget\";i:13;s:10:\"createUnit\";i:14;s:10:\"updateUnit\";i:15;s:8:\"viewUnit\";i:16;s:10:\"deleteUnit\";i:17;s:12:\"createVendor\";i:18;s:12:\"updateVendor\";i:19;s:10:\"viewVendor\";i:20;s:12:\"deleteVendor\";i:21;s:11:\"createEvent\";i:22;s:11:\"updateEvent\";i:23;s:9:\"viewEvent\";i:24;s:11:\"deleteEvent\";i:25;s:11:\"createKurir\";i:26;s:11:\"updateKurir\";i:27;s:9:\"viewKurir\";i:28;s:11:\"deleteKurir\";i:29;s:10:\"createTamu\";i:30;s:10:\"updateTamu\";i:31;s:8:\"viewTamu\";i:32;s:10:\"deleteTamu\";i:33;s:10:\"createTime\";i:34;s:10:\"updateTime\";i:35;s:8:\"viewTime\";i:36;s:10:\"deleteTime\";i:37;s:17:\"createOrder-menus\";i:38;s:17:\"updateOrder-menus\";i:39;s:15:\"viewOrder-menus\";i:40;s:17:\"deleteOrder-menus\";i:41;s:23:\"createServe-order-menus\";i:42;s:23:\"updateServe-order-menus\";i:43;s:21:\"viewServe-order-menus\";i:44;s:23:\"deleteServe-order-menus\";i:45;s:23:\"createPlace-of-delivery\";i:46;s:23:\"updatePlace-of-delivery\";i:47;s:21:\"viewPlace-of-delivery\";i:48;s:23:\"deletePlace-of-delivery\";i:49;s:12:\"createOrders\";i:50;s:12:\"updateOrders\";i:51;s:10:\"viewOrders\";i:52;s:12:\"deleteOrders\";i:53;s:15:\"createShippings\";i:54;s:15:\"updateShippings\";i:55;s:13:\"viewShippings\";i:56;s:15:\"deleteShippings\";i:57;s:14:\"createDelivery\";i:58;s:14:\"updateDelivery\";i:59;s:12:\"viewDelivery\";i:60;s:14:\"deleteDelivery\";i:61;s:18:\"createOrder_report\";i:62;s:18:\"updateOrder_report\";i:63;s:16:\"viewOrder_report\";i:64;s:18:\"deleteOrder_report\";}',NULL,'2023-12-01 07:15:01',NULL,1),(3,'Manager','manager','Akses penuh ke dalam sistem aplikasi [approval]','a:55:{i:0;s:13:\"viewDashboard\";i:1;s:17:\"createCost-center\";i:2;s:17:\"updateCost-center\";i:3;s:15:\"viewCost-center\";i:4;s:17:\"deleteCost-center\";i:5;s:12:\"createBudget\";i:6;s:12:\"updateBudget\";i:7;s:10:\"viewBudget\";i:8;s:12:\"deleteBudget\";i:9;s:10:\"createUnit\";i:10;s:10:\"updateUnit\";i:11;s:8:\"viewUnit\";i:12;s:10:\"deleteUnit\";i:13;s:12:\"createVendor\";i:14;s:12:\"updateVendor\";i:15;s:10:\"viewVendor\";i:16;s:12:\"deleteVendor\";i:17;s:11:\"createEvent\";i:18;s:11:\"updateEvent\";i:19;s:9:\"viewEvent\";i:20;s:11:\"deleteEvent\";i:21;s:11:\"createKurir\";i:22;s:11:\"updateKurir\";i:23;s:9:\"viewKurir\";i:24;s:11:\"deleteKurir\";i:25;s:10:\"createTamu\";i:26;s:10:\"updateTamu\";i:27;s:8:\"viewTamu\";i:28;s:10:\"deleteTamu\";i:29;s:10:\"createTime\";i:30;s:10:\"updateTime\";i:31;s:8:\"viewTime\";i:32;s:10:\"deleteTime\";i:33;s:17:\"createOrder-menus\";i:34;s:17:\"updateOrder-menus\";i:35;s:15:\"viewOrder-menus\";i:36;s:17:\"deleteOrder-menus\";i:37;s:23:\"createServe-order-menus\";i:38;s:23:\"updateServe-order-menus\";i:39;s:21:\"viewServe-order-menus\";i:40;s:23:\"deleteServe-order-menus\";i:41;s:23:\"createPlace-of-delivery\";i:42;s:23:\"updatePlace-of-delivery\";i:43;s:21:\"viewPlace-of-delivery\";i:44;s:23:\"deletePlace-of-delivery\";i:45;s:12:\"createOrders\";i:46;s:12:\"updateOrders\";i:47;s:10:\"viewOrders\";i:48;s:12:\"deleteOrders\";i:49;s:13:\"viewShippings\";i:50;s:12:\"viewDelivery\";i:51;s:18:\"createOrder_report\";i:52;s:18:\"updateOrder_report\";i:53;s:16:\"viewOrder_report\";i:54;s:18:\"deleteOrder_report\";}',NULL,'2023-12-01 07:15:08',NULL,1),(4,'Pegawai','employee','Staff yang ada di lingkungan rumah tangga','a:42:{i:0;s:13:\"viewDashboard\";i:1;s:17:\"createCost-center\";i:2;s:17:\"updateCost-center\";i:3;s:15:\"viewCost-center\";i:4;s:10:\"viewBudget\";i:5;s:10:\"createUnit\";i:6;s:10:\"updateUnit\";i:7;s:8:\"viewUnit\";i:8;s:12:\"createVendor\";i:9;s:12:\"updateVendor\";i:10;s:10:\"viewVendor\";i:11;s:11:\"createEvent\";i:12;s:11:\"updateEvent\";i:13;s:9:\"viewEvent\";i:14;s:11:\"createKurir\";i:15;s:11:\"updateKurir\";i:16;s:9:\"viewKurir\";i:17;s:10:\"createTamu\";i:18;s:10:\"updateTamu\";i:19;s:8:\"viewTamu\";i:20;s:10:\"createTime\";i:21;s:10:\"updateTime\";i:22;s:8:\"viewTime\";i:23;s:17:\"createOrder-menus\";i:24;s:17:\"updateOrder-menus\";i:25;s:15:\"viewOrder-menus\";i:26;s:23:\"createServe-order-menus\";i:27;s:23:\"updateServe-order-menus\";i:28;s:21:\"viewServe-order-menus\";i:29;s:23:\"createPlace-of-delivery\";i:30;s:23:\"updatePlace-of-delivery\";i:31;s:21:\"viewPlace-of-delivery\";i:32;s:12:\"createOrders\";i:33;s:12:\"updateOrders\";i:34;s:10:\"viewOrders\";i:35;s:15:\"createShippings\";i:36;s:15:\"updateShippings\";i:37;s:13:\"viewShippings\";i:38;s:12:\"viewDelivery\";i:39;s:18:\"createOrder_report\";i:40;s:18:\"updateOrder_report\";i:41;s:16:\"viewOrder_report\";}',NULL,'2023-12-01 07:15:30',NULL,1),(5,'Kurir','mesengger','Kurir','a:1:{i:0;s:13:\"viewShippings\";}',NULL,'2023-12-05 16:18:52',NULL,1),(6,'Vendor','vendor','Mitra','a:5:{i:0;s:13:\"viewDashboard\";i:1;s:15:\"viewOrder-menus\";i:2;s:21:\"viewServe-order-menus\";i:3;s:12:\"updateOrders\";i:4;s:10:\"viewOrders\";}',NULL,'2023-12-05 16:19:03',NULL,1),(7,'Demplon User','demplon','User Demplon yang membuat pesanan dan approval dari aplikasi demplon','a:1:{i:0;s:10:\"viewOrders\";}','2023-11-09 03:31:51','2023-11-09 03:31:51',1,1);

/*Table structure for table `statuses` */


CREATE TABLE `statuses` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `bg_colour` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `icon` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `title` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  `created_by` bigint(20) DEFAULT NULL,
  `updated_by` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*Data for the table `statuses` */

insert  into `statuses`(`id`,`name`,`description`,`bg_colour`,`icon`,`title`,`created_at`,`updated_at`,`created_by`,`updated_by`) values (1,'created','Pesanan Dibuat','bg-primary','fa-check','Setujui Pesanan Baru','2023-11-04 14:44:15','2023-09-20 14:15:17',1,1),(2,'revised','Pesanan Direvisi','bg-warning','fa-edit','Pesanan diperbaharui','2023-11-04 14:38:27','2023-09-20 14:15:17',1,1),(3,'approved1','Pesanan Disetujui[1]','bg-fuchsia','fa-check-double','Pesanan disetujui [2]','2023-11-10 18:27:12','2023-09-20 14:15:17',1,1),(4,'approved2','Pesanan Disetujui[2]','bg-pink','fa-thumbtack','Buat Menu','2023-11-04 15:21:28','2023-10-06 17:30:24',1,1),(5,'applied','Pesanan Dilayani','bg-teal','fa-list-check','Pesanan dilayani','2023-11-04 14:38:33','2023-09-20 14:15:17',1,1),(6,'senttovendor','Pesanan Dikirim ke Mitra','bg-maroon','fa-clipboard-list fa-lg','Proses Pesanan','2023-11-04 16:34:30','2023-09-20 14:15:17',1,1),(7,'processed','Pesanan DiProses Mitra','bg-orange','fa-clipboard-check fa-lg text-white','Atur pengiriman Pesanan','2023-11-24 10:19:41','2023-09-20 14:15:17',1,1),(8,'prepared','Pesanan telah diatur untuk pengiriman','bg-olive','fa-check-circle','Proses Pengiriman','2023-11-24 14:19:43','2023-09-20 14:15:17',1,1),(9,'delivery','Pesanan sedang dalam perjalanan','bg-success','fa-file-invoice-dollar','Selesaikan Pesanan','2023-11-24 14:19:34','2023-09-20 14:15:17',1,1),(10,'received','Pesanan Diterima','bg-success','fa-file-invoice-dollar','Cetak Tagihan','2023-11-24 14:19:04','2023-09-20 14:15:17',1,1),(11,'invoiced','Cetak Tagihan','bg-success','fa-money-bill-wave','Pembayaran Tagihan','2023-11-24 14:15:47','0000-00-00 00:00:00',NULL,NULL),(12,'paid','Tagihan sudah dibayar','bg-indigo','',NULL,'2023-11-24 14:15:45','0000-00-00 00:00:00',NULL,NULL),(13,'cancelled','Pesanan dibatalkan','bg-danger',NULL,NULL,'2023-11-24 14:15:22','0000-00-00 00:00:00',NULL,NULL);

/*Table structure for table `times` */


CREATE TABLE `times` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) DEFAULT NULL,
  `start_time` time DEFAULT NULL,
  `end_time` time DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `created_by` bigint(20) DEFAULT NULL,
  `updated_by` bigint(20) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

/*Data for the table `times` */

insert  into `times`(`id`,`name`,`start_time`,`end_time`,`description`,`created_by`,`updated_by`,`created_at`,`updated_at`) values (1,'Pagi','07:00:00','10:29:00',NULL,NULL,NULL,'2023-11-25 05:52:58',NULL),(2,'Siang','10:30:00','12:59:00',NULL,NULL,NULL,'2023-11-25 05:53:26',NULL),(3,'Sore','13:00:00','17:59:00',NULL,NULL,NULL,'2023-11-25 05:53:43',NULL),(4,'Malam','18:00:00','21:59:00',NULL,NULL,NULL,'2023-11-25 05:54:09',NULL),(5,'Tengah Malam','22:00:00','23:59:00',NULL,NULL,NULL,'2023-11-25 05:54:32',NULL);

/*Table structure for table `units` */


CREATE TABLE `units` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint(20) DEFAULT NULL,
  `updated_by` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*Data for the table `units` */

insert  into `units`(`id`,`name`,`created_at`,`updated_at`,`created_by`,`updated_by`) values (1,'Box','2023-11-06 03:41:58','2023-11-06 03:41:58',1,1),(2,'Bungkus','2023-11-06 03:42:19','2023-11-06 03:42:19',1,1),(3,'Dus','2023-11-06 03:42:29','2023-11-06 03:42:29',1,1),(4,'Porsi','2023-11-06 03:42:45','2023-11-06 03:42:45',1,1),(5,'Tampah','2023-11-06 03:43:03','2023-11-06 03:43:03',1,1),(6,'Keranjang','2023-11-06 03:43:15','2023-11-06 03:43:15',1,1),(7,'Toples','2023-11-06 03:43:36','2023-11-06 03:43:36',1,1),(8,'Paket','2023-11-06 03:43:54','2023-11-06 03:43:54',1,1),(9,'Kg','2023-11-06 03:44:24','2023-11-06 03:44:24',1,1),(10,'Pack','2023-11-06 03:44:42','2023-11-06 03:44:42',1,1),(11,'Sachet','2023-11-06 03:45:00','2023-11-06 03:45:00',1,1),(12,'Pcs','2023-11-06 03:45:40','2023-11-06 03:45:40',1,1),(13,'Cup','2023-11-06 03:45:48','2023-11-06 03:45:48',1,1),(14,'Botol','2023-11-06 03:46:01','2023-11-06 03:46:01',1,1),(15,'Galon','2023-11-06 03:46:17','2023-11-06 03:46:17',1,1),(16,'Butir','2023-11-06 03:46:58','2023-11-06 03:46:58',1,1),(17,'Lusin','2023-11-06 03:47:46','2023-11-06 03:47:46',1,1),(18,'Krat','2023-11-06 03:48:30','2023-11-06 03:48:30',1,1),(19,'Pax','2023-11-06 03:49:44','2023-11-06 03:49:44',1,1),(20,'Tusuk','2023-11-06 03:50:01','2023-11-06 03:50:01',1,1),(21,'ls','2023-11-06 03:50:30','2023-11-06 03:50:30',1,1);

/*Table structure for table `vendors` */


CREATE TABLE `vendors` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `margin` int(11) NOT NULL,
  `address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `pic1` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `pic2` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint(20) DEFAULT NULL,
  `updated_by` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*Data for the table `vendors` */

insert  into `vendors`(`id`,`name`,`margin`,`address`,`phone`,`pic1`,`pic2`,`description`,`created_at`,`updated_at`,`created_by`,`updated_by`) values (1,'Bidus PIKA',0,'JL. Baugenville No.39 Dauwan Cikampek','081382776693',NULL,NULL,'Snack\r\nKonsumsi\r\nBahan Minum','2023-11-06 03:52:28','2023-11-06 03:52:28',12,12);

/*Table structure for table `visitors` */


CREATE TABLE `visitors` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint(20) DEFAULT NULL,
  `updated_by` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*Data for the table `visitors` */

