text: -- --------------------------------------------------------
  -- Host:                         127.0.0.1
  -- Server version:               10.1.32-MariaDB - mariadb.org binary distribution
  -- Server OS:                    Win32
  -- HeidiSQL Version:             9.5.0.5280
  -- --------------------------------------------------------
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET NAMES utf8 */;
  /*!50503 SET NAMES utf8mb4 */;
  /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  
  -- Dumping structure for table prisma_pos.app_install
  DROP TABLE IF EXISTS `app_install`;
  CREATE TABLE IF NOT EXISTS `app_install` (
    `install_id` int(11) NOT NULL AUTO_INCREMENT,
    `type_id` int(1) NOT NULL DEFAULT '0',
    `install_status` tinyint(1) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`install_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.app_install: ~0 rows (approximately)
  DELETE FROM `app_install`;
  /*!40000 ALTER TABLE `app_install` DISABLE KEYS */;
  INSERT INTO `app_install` (`install_id`, `type_id`, `install_status`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	(1, 3, 1, '2018-04-18 12:14:03', 'System', '2018-08-24 10:21:42', 'System', 1, 0);
  /*!40000 ALTER TABLE `app_install` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.app_type
  DROP TABLE IF EXISTS `app_type`;
  CREATE TABLE IF NOT EXISTS `app_type` (
    `type_id` int(11) NOT NULL AUTO_INCREMENT,
    `type_name` varchar(32) NOT NULL,
    `type_icon` varchar(32) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`type_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.app_type: ~5 rows (approximately)
  DELETE FROM `app_type`;
  /*!40000 ALTER TABLE `app_type` DISABLE KEYS */;
  INSERT INTO `app_type` (`type_id`, `type_name`, `type_icon`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	(1, 'Prisma Retail', 'shopping-cart', '2018-04-18 12:15:09', 'System', '2018-04-18 12:25:11', 'System', 1, 0),
  	(2, 'Prisma Restaurant', 'cutlery', '2018-04-18 12:15:36', 'System', '2018-04-18 12:20:19', 'System', 1, 0),
  	(3, 'Prisma Hotel', 'hotel', '2018-04-18 12:15:36', 'System', '2018-04-18 12:24:27', 'System', 1, 0),
  	(4, 'Prisma Karaoke', 'microphone', '2018-04-18 12:16:07', 'System', '2018-04-18 12:25:06', 'System', 1, 0),
  	(5, 'Prisma Parking', 'car', '2018-05-17 11:33:54', 'System', '0000-00-00 00:00:00', 'System', 1, 0);
  /*!40000 ALTER TABLE `app_type` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.app_version
  DROP TABLE IF EXISTS `app_version`;
  CREATE TABLE IF NOT EXISTS `app_version` (
    `version_id` int(11) NOT NULL AUTO_INCREMENT,
    `version_now` varchar(10) NOT NULL DEFAULT '0',
    `version_release` timestamp NULL DEFAULT NULL,
    `version_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`version_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.app_version: ~23 rows (approximately)
  DELETE FROM `app_version`;
  /*!40000 ALTER TABLE `app_version` DISABLE KEYS */;
  INSERT INTO `app_version` (`version_id`, `version_now`, `version_release`, `version_updated`) VALUES
  	(1, '1.0', '2018-07-05 18:00:00', '2018-08-18 09:34:21'),
  	(2, '1.1', '2018-07-09 14:16:00', '2018-08-18 09:34:22'),
  	(3, '1.2', '2018-07-16 11:20:00', '2018-08-18 09:34:23'),
  	(4, '1.3', '2018-07-17 10:00:00', '2018-08-18 09:34:23'),
  	(5, '1.4', '2018-07-17 10:41:00', '2018-08-18 09:34:29'),
  	(6, '1.5', '2018-07-18 11:52:00', '2018-08-18 09:34:32'),
  	(7, '1.6', '2018-07-22 19:47:00', '2018-08-18 09:34:33'),
  	(8, '1.7', '2018-08-07 10:46:00', '2018-08-18 09:34:34'),
  	(9, '1.8', '2018-08-07 12:12:00', '2018-08-18 09:34:35'),
  	(10, '1.9', '2018-08-07 14:12:00', '2018-08-18 09:34:37'),
  	(11, '2.0', '2018-08-08 11:15:00', '2018-08-18 09:34:40'),
  	(12, '2.1', '2018-08-13 12:12:00', '2018-08-18 09:34:48'),
  	(14, '2.2.1', '2018-08-18 09:00:00', '2018-08-20 05:22:33'),
  	(16, '2.2.2', '2018-08-20 09:00:00', '2018-08-20 05:33:20'),
  	(17, '2.2.3', '2018-08-21 09:40:00', '2018-08-20 09:46:35'),
  	(18, '2.2.4', '2018-08-21 10:20:00', '2018-08-20 10:21:11'),
  	(19, '2.2.5', '2018-08-21 10:20:00', '2018-08-20 11:17:41'),
  	(20, '2.2.6', '2018-08-21 14:45:00', '2018-08-20 14:45:51'),
  	(21, '2.2.7', '2018-08-21 14:56:00', '2018-08-20 15:10:40'),
  	(22, '2.2.8', '2018-08-21 14:56:00', '2018-08-20 15:14:20'),
  	(23, '2.2.9', '2018-08-21 15:13:00', '2018-08-20 15:14:20'),
  	(26, '2.3.0', '2018-08-21 15:20:00', '2018-08-21 08:33:03'),
  	(27, '2.3.1', '2018-08-22 08:30:00', '2018-08-21 08:33:04');
  /*!40000 ALTER TABLE `app_version` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.hot_billing
  DROP TABLE IF EXISTS `hot_billing`;
  CREATE TABLE IF NOT EXISTS `hot_billing` (
    `billing_id` int(11) NOT NULL AUTO_INCREMENT,
    `billing_receipt_no` varchar(50) NOT NULL,
    `guest_type` tinyint(1) NOT NULL DEFAULT '0',
    `guest_id` int(11) NOT NULL,
    `guest_name` varchar(128) NOT NULL,
    `guest_gender` char(1) NOT NULL,
    `guest_phone` varchar(15) NOT NULL,
    `guest_id_type` tinyint(1) NOT NULL,
    `guest_id_no` varchar(20) NOT NULL,
    `user_id` int(11) NOT NULL,
    `user_realname` varchar(128) NOT NULL,
    `billing_date_in` date NOT NULL,
    `billing_time_in` time NOT NULL,
    `billing_date_out` date NOT NULL,
    `billing_time_out` time NOT NULL,
    `billing_num_day` int(11) NOT NULL,
    `billing_sub_total` float(10,2) NOT NULL,
    `billing_grand_total` float(10,2) NOT NULL,
    `billing_payment_type` tinyint(1) NOT NULL,
    `billing_down_payment` float(10,2) NOT NULL,
    `billing_payment` float(10,2) NOT NULL,
    `billing_change` float(10,2) NOT NULL,
    `billing_cancel_note` varchar(128) NOT NULL,
    `billing_status` tinyint(1) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(50) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `updated_by` varchar(50) NOT NULL,
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`billing_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.hot_billing: ~0 rows (approximately)
  DELETE FROM `hot_billing`;
  /*!40000 ALTER TABLE `hot_billing` DISABLE KEYS */;
  INSERT INTO `hot_billing` (`billing_id`, `billing_receipt_no`, `guest_type`, `guest_id`, `guest_name`, `guest_gender`, `guest_phone`, `guest_id_type`, `guest_id_no`, `user_id`, `user_realname`, `billing_date_in`, `billing_time_in`, `billing_date_out`, `billing_time_out`, `billing_num_day`, `billing_sub_total`, `billing_grand_total`, `billing_payment_type`, `billing_down_payment`, `billing_payment`, `billing_change`, `billing_cancel_note`, `billing_status`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	(1, '180828000001', 0, 0, 'Paimain', 'L', '', 1, '', 0, '', '2018-08-28', '13:45:26', '2018-08-28', '13:45:26', 0, 0.00, 0.00, 0, 0.00, 0.00, 0.00, '', 1, '2018-08-28 13:45:26', 'System', '0000-00-00 00:00:00', '', 1, 0),
  	(2, '180828000002', 0, 0, 'Painem', 'P', '123124123', 2, '123456', 0, '', '2018-08-28', '13:58:40', '2018-08-28', '13:58:40', 0, 0.00, 0.00, 0, 0.00, 0.00, 0.00, '', 1, '2018-08-28 13:48:20', 'System', '0000-00-00 00:00:00', '', 1, 0),
  	(3, '180828000003', 0, 0, 'Budi Raharyanto', 'L', '', 1, '', 0, '', '2018-08-28', '14:22:32', '2018-08-29', '14:22:32', 0, 0.00, 0.00, 0, 0.00, 0.00, 0.00, '', 1, '2018-08-28 14:22:32', 'System', '0000-00-00 00:00:00', '', 1, 0),
  	(4, '180828000004', 0, 0, 'afdasdfa', 'L', '', 1, '', 0, '', '2018-08-28', '14:23:10', '2018-08-29', '14:23:10', 1, 0.00, 0.00, 0, 0.00, 0.00, 0.00, '', 1, '2018-08-28 14:23:10', 'System', '0000-00-00 00:00:00', '', 1, 0),
  	(5, '180828000005', 0, 0, 'Suparjo', 'L', '', 1, '', 0, '', '2018-08-28', '14:23:31', '2018-08-30', '14:23:31', 1, 0.00, 0.00, 0, 0.00, 0.00, 0.00, '', 1, '2018-08-28 14:23:31', 'System', '0000-00-00 00:00:00', '', 1, 0),
  	(6, '180828000006', 0, 0, 'fadsfa', 'L', '', 1, '', 0, '', '2018-08-28', '14:24:12', '2018-09-01', '14:24:12', 4, 0.00, 0.00, 0, 0.00, 0.00, 0.00, '', 1, '2018-08-28 14:24:12', 'System', '0000-00-00 00:00:00', '', 1, 0),
  	(7, '180828000007', 0, 0, 'Budiman', 'L', '', 1, '', 0, '', '2018-08-28', '14:24:45', '2018-08-29', '14:24:45', 2, 0.00, 0.00, 0, 0.00, 0.00, 0.00, '', 1, '2018-08-28 14:24:45', 'System', '0000-00-00 00:00:00', '', 1, 0),
  	(8, '180828000008', 0, 0, 'Tukijo', 'L', '', 1, '', 0, '', '2018-08-28', '15:16:23', '2018-08-28', '15:16:23', 1, 0.00, 0.00, 0, 0.00, 0.00, 0.00, '', 1, '2018-08-28 15:16:16', 'System', '0000-00-00 00:00:00', '', 1, 0),
  	(9, '180828000009', 0, 0, '', '', '', 0, '', 0, '', '0000-00-00', '00:00:00', '0000-00-00', '00:00:00', 0, 0.00, 0.00, 0, 0.00, 0.00, 0.00, '', 0, '2018-08-28 15:25:06', 'System', '0000-00-00 00:00:00', '', 1, 0);
  /*!40000 ALTER TABLE `hot_billing` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.hot_billing_extra
  DROP TABLE IF EXISTS `hot_billing_extra`;
  CREATE TABLE IF NOT EXISTS `hot_billing_extra` (
    `billing_extra_id` int(11) NOT NULL AUTO_INCREMENT,
    `billing_id` int(11) NOT NULL DEFAULT '0',
    `extra_id` int(11) NOT NULL,
    `extra_name` varchar(128) NOT NULL,
    `extra_charge` float(10,2) NOT NULL,
    `extra_amount` float(10,2) NOT NULL,
    `extra_total` float(10,2) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(50) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `updated_by` varchar(20) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`billing_extra_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  
  -- Dumping data for table prisma_pos.hot_billing_extra: ~0 rows (approximately)
  DELETE FROM `hot_billing_extra`;
  /*!40000 ALTER TABLE `hot_billing_extra` DISABLE KEYS */;
  INSERT INTO `hot_billing_extra` (`billing_extra_id`, `billing_id`, `extra_id`, `extra_name`, `extra_charge`, `extra_amount`, `extra_total`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	(1, 8, 1, 'Single bed', 100000.00, 2.00, 200000.00, '2018-08-28 15:16:31', 'Super Hotel', '0000-00-00 00:00:00', 'System', 1, 0),
  	(2, 8, 2, 'Double Bed', 250000.00, 3.00, 750000.00, '2018-08-28 15:16:36', 'Super Hotel', '0000-00-00 00:00:00', 'System', 1, 0);
  /*!40000 ALTER TABLE `hot_billing_extra` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.hot_billing_fnb
  DROP TABLE IF EXISTS `hot_billing_fnb`;
  CREATE TABLE IF NOT EXISTS `hot_billing_fnb` (
    `billing_fnb_id` int(11) NOT NULL AUTO_INCREMENT,
    `billing_id` int(11) NOT NULL DEFAULT '0',
    `fnb_id` int(11) NOT NULL,
    `fnb_name` varchar(128) NOT NULL,
    `fnb_charge` float(10,2) NOT NULL,
    `fnb_amount` float(10,2) NOT NULL,
    `fnb_total` float(10,2) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(50) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `updated_by` varchar(20) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`billing_fnb_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  
  -- Dumping data for table prisma_pos.hot_billing_fnb: ~0 rows (approximately)
  DELETE FROM `hot_billing_fnb`;
  /*!40000 ALTER TABLE `hot_billing_fnb` DISABLE KEYS */;
  /*!40000 ALTER TABLE `hot_billing_fnb` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.hot_billing_room
  DROP TABLE IF EXISTS `hot_billing_room`;
  CREATE TABLE IF NOT EXISTS `hot_billing_room` (
    `billing_room_id` int(11) NOT NULL AUTO_INCREMENT,
    `billing_id` int(11) NOT NULL DEFAULT '0',
    `room_id` int(11) NOT NULL,
    `room_name` varchar(128) NOT NULL,
    `room_type_id` int(11) NOT NULL,
    `room_type_name` varchar(128) NOT NULL,
    `room_type_charge` float(10,2) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(50) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `updated_by` varchar(20) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`billing_room_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  
  -- Dumping data for table prisma_pos.hot_billing_room: ~0 rows (approximately)
  DELETE FROM `hot_billing_room`;
  /*!40000 ALTER TABLE `hot_billing_room` DISABLE KEYS */;
  INSERT INTO `hot_billing_room` (`billing_room_id`, `billing_id`, `room_id`, `room_name`, `room_type_id`, `room_type_name`, `room_type_charge`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	(1, 1, 110, 'Melati - 10', 1, 'Melati', 100000.00, '2018-08-28 13:43:52', 'Super Hotel', '0000-00-00 00:00:00', 'System', 1, 0),
  	(2, 2, 13, 'Melati - 03', 1, 'Melati', 100000.00, '2018-08-28 14:17:38', 'Super Hotel', '0000-00-00 00:00:00', 'System', 1, 0),
  	(3, 2, 12, 'Melati - 02', 1, 'Melati', 100000.00, '2018-08-28 14:17:43', 'Super Hotel', '0000-00-00 00:00:00', 'System', 1, 0),
  	(4, 7, 12, 'Melati - 02', 1, 'Melati', 100000.00, '2018-08-28 14:25:00', 'Super Hotel', '0000-00-00 00:00:00', 'System', 1, 0);
  /*!40000 ALTER TABLE `hot_billing_room` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.hot_billing_service
  DROP TABLE IF EXISTS `hot_billing_service`;
  CREATE TABLE IF NOT EXISTS `hot_billing_service` (
    `billing_service_id` int(11) NOT NULL AUTO_INCREMENT,
    `billing_id` int(11) NOT NULL DEFAULT '0',
    `service_id` int(11) NOT NULL,
    `service_name` varchar(128) NOT NULL,
    `service_charge` float(10,2) NOT NULL,
    `service_amount` float(10,2) NOT NULL,
    `service_total` float(10,2) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(50) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `updated_by` varchar(20) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`billing_service_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  
  -- Dumping data for table prisma_pos.hot_billing_service: ~0 rows (approximately)
  DELETE FROM `hot_billing_service`;
  /*!40000 ALTER TABLE `hot_billing_service` DISABLE KEYS */;
  /*!40000 ALTER TABLE `hot_billing_service` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.hot_booking
  DROP TABLE IF EXISTS `hot_booking`;
  CREATE TABLE IF NOT EXISTS `hot_booking` (
    `booking_id` int(11) NOT NULL AUTO_INCREMENT,
    `booking_code` varchar(128) NOT NULL,
    `guest_id` int(155) NOT NULL,
    `service_id` int(155) DEFAULT NULL,
    `number_of_days` int(155) NOT NULL,
    `room_id` int(155) NOT NULL,
    `date_booking` date NOT NULL,
    `date_booking_from` date NOT NULL,
    `date_booking_to` date NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    `opsi_hari` int(155) DEFAULT '0',
    PRIMARY KEY (`booking_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  
  -- Dumping data for table prisma_pos.hot_booking: ~0 rows (approximately)
  DELETE FROM `hot_booking`;
  /*!40000 ALTER TABLE `hot_booking` DISABLE KEYS */;
  /*!40000 ALTER TABLE `hot_booking` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.hot_booking_diskon
  DROP TABLE IF EXISTS `hot_booking_diskon`;
  CREATE TABLE IF NOT EXISTS `hot_booking_diskon` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `booking_id` int(155) NOT NULL,
    `diskon_id` int(155) NOT NULL,
    `price` int(155) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  
  -- Dumping data for table prisma_pos.hot_booking_diskon: ~0 rows (approximately)
  DELETE FROM `hot_booking_diskon`;
  /*!40000 ALTER TABLE `hot_booking_diskon` DISABLE KEYS */;
  /*!40000 ALTER TABLE `hot_booking_diskon` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.hot_booking_room
  DROP TABLE IF EXISTS `hot_booking_room`;
  CREATE TABLE IF NOT EXISTS `hot_booking_room` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `booking_id` int(155) NOT NULL,
    `room_id` int(155) NOT NULL,
    `price` int(155) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  
  -- Dumping data for table prisma_pos.hot_booking_room: ~0 rows (approximately)
  DELETE FROM `hot_booking_room`;
  /*!40000 ALTER TABLE `hot_booking_room` DISABLE KEYS */;
  /*!40000 ALTER TABLE `hot_booking_room` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.hot_booking_service
  DROP TABLE IF EXISTS `hot_booking_service`;
  CREATE TABLE IF NOT EXISTS `hot_booking_service` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `booking_id` int(155) NOT NULL,
    `service_id` int(155) NOT NULL,
    `price` int(155) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  
  -- Dumping data for table prisma_pos.hot_booking_service: ~0 rows (approximately)
  DELETE FROM `hot_booking_service`;
  /*!40000 ALTER TABLE `hot_booking_service` DISABLE KEYS */;
  /*!40000 ALTER TABLE `hot_booking_service` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.hot_category
  DROP TABLE IF EXISTS `hot_category`;
  CREATE TABLE IF NOT EXISTS `hot_category` (
    `category_id` int(11) NOT NULL AUTO_INCREMENT,
    `category_name` varchar(128) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    `category_price` int(155) DEFAULT NULL,
    `category_desc` text,
    `status` int(155) DEFAULT NULL,
    `before_tax` int(155) DEFAULT NULL,
    `tax` int(155) DEFAULT NULL,
    `after_tax` int(155) DEFAULT NULL,
    `service_hotel` int(155) DEFAULT NULL,
    PRIMARY KEY (`category_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  
  -- Dumping data for table prisma_pos.hot_category: ~0 rows (approximately)
  DELETE FROM `hot_category`;
  /*!40000 ALTER TABLE `hot_category` DISABLE KEYS */;
  /*!40000 ALTER TABLE `hot_category` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.hot_charge_type
  DROP TABLE IF EXISTS `hot_charge_type`;
  CREATE TABLE IF NOT EXISTS `hot_charge_type` (
    `charge_type_id` int(11) NOT NULL AUTO_INCREMENT,
    `charge_type_code` varchar(15) NOT NULL,
    `charge_type_name` varchar(128) NOT NULL,
    `charge_type_ratio` float(10,2) NOT NULL DEFAULT '0.00',
    `charge_type_desc` varchar(128) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(128) NOT NULL DEFAULT 'System',
    `updated` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(128) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`charge_type_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.hot_charge_type: ~3 rows (approximately)
  DELETE FROM `hot_charge_type`;
  /*!40000 ALTER TABLE `hot_charge_type` DISABLE KEYS */;
  INSERT INTO `hot_charge_type` (`charge_type_id`, `charge_type_code`, `charge_type_name`, `charge_type_ratio`, `charge_type_desc`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	(1, '1.1.1.01.05', 'Pajak Daerah Hotel ', 10.00, 'Pajak Daerah', '2018-08-20 10:21:11', 'System', '2018-08-24 10:48:53', 'Super Restaurant', 1, 0),
  	(2, 'SRV', 'Servis Hotel', 10.00, 'Biaya Servis', '2018-08-20 10:21:11', 'System', '2018-08-25 20:21:59', 'Super Hotel', 0, 0),
  	(3, 'OTR', 'Biaya lain-lain', 1.00, '', '2018-08-24 10:45:15', 'Super Restaurant', '2018-08-25 20:22:04', 'Super Hotel', 0, 0);
  /*!40000 ALTER TABLE `hot_charge_type` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.hot_client
  DROP TABLE IF EXISTS `hot_client`;
  CREATE TABLE IF NOT EXISTS `hot_client` (
    `client_id` varchar(32) NOT NULL,
    `client_name` varchar(32) NOT NULL,
    `client_brand` varchar(32) NOT NULL,
    `client_status` varchar(32) NOT NULL,
    `client_street` varchar(128) NOT NULL,
    `client_subdistrict` varchar(32) NOT NULL,
    `client_district` varchar(32) NOT NULL,
    `client_city` varchar(32) NOT NULL,
    `client_province` varchar(32) NOT NULL,
    `client_email` varchar(32) NOT NULL,
    `client_phone_1` varchar(15) NOT NULL,
    `client_phone_2` varchar(15) NOT NULL,
    `client_npwp` varchar(64) NOT NULL,
    `client_npwpd` varchar(64) NOT NULL,
    `client_owner_name` varchar(64) NOT NULL,
    `client_owner_address` text NOT NULL,
    `client_notes` text NOT NULL,
    `client_serial_number` varchar(20) NOT NULL,
    `client_keyboard_status` tinyint(1) NOT NULL DEFAULT '1',
    `client_logo` varchar(255) DEFAULT NULL,
    `client_is_taxed` tinyint(1) NOT NULL DEFAULT '1',
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`client_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.hot_client: ~0 rows (approximately)
  DELETE FROM `hot_client`;
  /*!40000 ALTER TABLE `hot_client` DISABLE KEYS */;
  INSERT INTO `hot_client` (`client_id`, `client_name`, `client_brand`, `client_status`, `client_street`, `client_subdistrict`, `client_district`, `client_city`, `client_province`, `client_email`, `client_phone_1`, `client_phone_2`, `client_npwp`, `client_npwpd`, `client_owner_name`, `client_owner_address`, `client_notes`, `client_serial_number`, `client_keyboard_status`, `client_logo`, `client_is_taxed`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	('1', 'CV Prisma Hotel', 'Prisma Hotel', 'sendiri', 'Jalan Gajahmada 56', 'Warungboto', 'Umbulharjo', 'Yogyakarta', 'Daerah Istimewa Yogyakarta', 'buat@gmail.com', '123', '123', '1234', '1234', 'Sujo', 'jalan manggis\r\n', 'Tidak ada', '1234-1234-1234', 0, NULL, 0, '2018-05-08 10:26:03', 'System', '2018-08-27 10:27:19', 'Super Hotel', 1, 0);
  /*!40000 ALTER TABLE `hot_client` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.hot_discount
  DROP TABLE IF EXISTS `hot_discount`;
  CREATE TABLE IF NOT EXISTS `hot_discount` (
    `discount_id` int(11) NOT NULL AUTO_INCREMENT,
    `discount_name` varchar(128) NOT NULL,
    `discount_type` tinyint(1) NOT NULL DEFAULT '1',
    `discount_amount` float(10,2) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(50) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(20) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`discount_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  
  -- Dumping data for table prisma_pos.hot_discount: ~2 rows (approximately)
  DELETE FROM `hot_discount`;
  /*!40000 ALTER TABLE `hot_discount` DISABLE KEYS */;
  INSERT INTO `hot_discount` (`discount_id`, `discount_name`, `discount_type`, `discount_amount`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	(1, 'Hut RI', 1, 10.00, '2018-08-21 08:33:21', 'Super Hotel', '0000-00-00 00:00:00', 'System', 1, 0),
  	(2, 'HUr', 2, 10000.00, '2018-08-21 08:33:29', 'Super Hotel', '0000-00-00 00:00:00', 'System', 1, 0);
  /*!40000 ALTER TABLE `hot_discount` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.hot_diskon
  DROP TABLE IF EXISTS `hot_diskon`;
  CREATE TABLE IF NOT EXISTS `hot_diskon` (
    `diskon_id` int(11) NOT NULL AUTO_INCREMENT,
    `diskon_name` varchar(128) NOT NULL,
    `diskon_price` int(155) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    `nominal` int(155) DEFAULT NULL,
    PRIMARY KEY (`diskon_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  
  -- Dumping data for table prisma_pos.hot_diskon: ~0 rows (approximately)
  DELETE FROM `hot_diskon`;
  /*!40000 ALTER TABLE `hot_diskon` DISABLE KEYS */;
  /*!40000 ALTER TABLE `hot_diskon` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.hot_extra
  DROP TABLE IF EXISTS `hot_extra`;
  CREATE TABLE IF NOT EXISTS `hot_extra` (
    `extra_id` int(11) NOT NULL AUTO_INCREMENT,
    `extra_name` varchar(128) NOT NULL,
    `extra_charge` float(10,2) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(50) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(20) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`extra_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  
  -- Dumping data for table prisma_pos.hot_extra: ~2 rows (approximately)
  DELETE FROM `hot_extra`;
  /*!40000 ALTER TABLE `hot_extra` DISABLE KEYS */;
  INSERT INTO `hot_extra` (`extra_id`, `extra_name`, `extra_charge`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	(1, 'Single bed', 100000.00, '2018-08-22 20:33:52', 'Super Hotel', '0000-00-00 00:00:00', 'System', 1, 0),
  	(2, 'Double Bed', 250000.00, '2018-08-22 20:34:00', 'Super Hotel', '0000-00-00 00:00:00', 'System', 1, 0);
  /*!40000 ALTER TABLE `hot_extra` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.hot_fnb
  DROP TABLE IF EXISTS `hot_fnb`;
  CREATE TABLE IF NOT EXISTS `hot_fnb` (
    `fnb_id` int(11) NOT NULL AUTO_INCREMENT,
    `fnb_name` varchar(128) NOT NULL,
    `fnb_charge` float(10,2) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(50) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `updated_by` varchar(20) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`fnb_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  
  -- Dumping data for table prisma_pos.hot_fnb: ~2 rows (approximately)
  DELETE FROM `hot_fnb`;
  /*!40000 ALTER TABLE `hot_fnb` DISABLE KEYS */;
  INSERT INTO `hot_fnb` (`fnb_id`, `fnb_name`, `fnb_charge`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	(1, 'Roti Mari', 50000.00, '2018-08-22 20:57:27', 'Super Hotel', '0000-00-00 00:00:00', 'System', 1, 0),
  	(2, 'Roti Tawar', 7000.00, '2018-08-22 20:57:34', 'Super Hotel', '0000-00-00 00:00:00', 'System', 1, 0);
  /*!40000 ALTER TABLE `hot_fnb` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.hot_guest
  DROP TABLE IF EXISTS `hot_guest`;
  CREATE TABLE IF NOT EXISTS `hot_guest` (
    `guest_id` int(11) NOT NULL AUTO_INCREMENT,
    `guest_name` varchar(128) NOT NULL,
    `guest_gender` char(1) NOT NULL,
    `guest_type` tinyint(1) NOT NULL DEFAULT '0',
    `guest_phone` varchar(128) NOT NULL,
    `guest_address` varchar(255) NOT NULL,
    `guest_id_type` tinyint(1) NOT NULL DEFAULT '1',
    `guest_id_no` varchar(20) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `created_by` varchar(50) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `updated_by` varchar(20) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`guest_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.hot_guest: ~0 rows (approximately)
  DELETE FROM `hot_guest`;
  /*!40000 ALTER TABLE `hot_guest` DISABLE KEYS */;
  INSERT INTO `hot_guest` (`guest_id`, `guest_name`, `guest_gender`, `guest_type`, `guest_phone`, `guest_address`, `guest_id_type`, `guest_id_no`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	(1, 'Budi Raharyanto', 'L', 1, '1235', '', 2, '123344531231231231', '2018-08-26 06:26:13', 'Super Hotel', '0000-00-00 00:00:00', 'Super Hotel', 1, 0);
  /*!40000 ALTER TABLE `hot_guest` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.hot_log
  DROP TABLE IF EXISTS `hot_log`;
  CREATE TABLE IF NOT EXISTS `hot_log` (
    `log_id` int(11) NOT NULL AUTO_INCREMENT,
    `user_id` int(11) NOT NULL,
    `user_realname` varchar(128) NOT NULL,
    `log_type` enum('Sign In','Sign Out') NOT NULL,
    `log_date` date NOT NULL,
    `log_time` time NOT NULL,
    PRIMARY KEY (`log_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  
  -- Dumping data for table prisma_pos.hot_log: ~47 rows (approximately)
  DELETE FROM `hot_log`;
  /*!40000 ALTER TABLE `hot_log` DISABLE KEYS */;
  INSERT INTO `hot_log` (`log_id`, `user_id`, `user_realname`, `log_type`, `log_date`, `log_time`) VALUES
  	(1, 1, 'Super Hotel', 'Sign In', '2018-08-20', '05:19:05'),
  	(2, 1, 'Super Hotel', 'Sign Out', '2018-08-20', '05:22:32'),
  	(3, 1, 'Super Hotel', 'Sign In', '2018-08-20', '05:22:51'),
  	(4, 1, 'Super Hotel', 'Sign Out', '2018-08-20', '05:25:20'),
  	(5, 2, 'Admin Hotel', 'Sign In', '2018-08-20', '05:25:27'),
  	(6, 2, 'Admin Hotel', 'Sign Out', '2018-08-20', '05:25:38'),
  	(7, 3, 'Cashier Hotel', 'Sign In', '2018-08-20', '05:25:46'),
  	(8, 3, 'Cashier Hotel', 'Sign Out', '2018-08-20', '05:25:54'),
  	(9, 2, 'Admin Hotel', 'Sign In', '2018-08-20', '05:34:04'),
  	(10, 2, 'Admin Hotel', 'Sign Out', '2018-08-20', '05:34:14'),
  	(11, 1, 'Super Hotel', 'Sign In', '2018-08-20', '05:43:33'),
  	(12, 1, 'Super Hotel', 'Sign In', '2018-08-20', '09:46:44'),
  	(13, 1, 'Super Hotel', 'Sign In', '2018-08-20', '09:49:25'),
  	(14, 1, 'Super Hotel', 'Sign Out', '2018-08-20', '14:45:49'),
  	(15, 1, 'Super Hotel', 'Sign In', '2018-08-20', '14:45:55'),
  	(16, 1, 'Super Hotel', 'Sign Out', '2018-08-20', '14:46:04'),
  	(17, 1, 'Super Hotel', 'Sign In', '2018-08-20', '14:46:08'),
  	(18, 1, 'Super Hotel', 'Sign Out', '2018-08-20', '14:46:34'),
  	(19, 1, 'Super Hotel', 'Sign In', '2018-08-20', '14:46:35'),
  	(20, 1, 'Super Hotel', 'Sign In', '2018-08-20', '14:55:19'),
  	(21, 1, 'Super Hotel', 'Sign Out', '2018-08-20', '15:10:39'),
  	(22, 1, 'Super Hotel', 'Sign In', '2018-08-20', '15:11:18'),
  	(23, 1, 'Super Hotel', 'Sign In', '2018-08-20', '15:14:22'),
  	(24, 1, 'Super Hotel', 'Sign In', '2018-08-20', '15:14:54'),
  	(25, 1, 'Super Hotel', 'Sign In', '2018-08-20', '15:15:21'),
  	(26, 1, 'Super Hotel', 'Sign In', '2018-08-20', '15:15:55'),
  	(27, 1, 'Super Hotel', 'Sign In', '2018-08-20', '15:17:16'),
  	(28, 1, 'Super Hotel', 'Sign In', '2018-08-20', '15:24:50'),
  	(29, 1, 'Super Hotel', 'Sign In', '2018-08-21', '08:25:29'),
  	(30, 1, 'Super Hotel', 'Sign Out', '2018-08-21', '08:29:50'),
  	(31, 1, 'Super Hotel', 'Sign In', '2018-08-21', '08:30:54'),
  	(32, 1, 'Super Hotel', 'Sign In', '2018-08-21', '08:33:13'),
  	(33, 1, 'Super Hotel', 'Sign In', '2018-08-22', '14:50:44'),
  	(34, 1, 'Super Hotel', 'Sign In', '2018-08-22', '19:55:08'),
  	(35, 1, 'Super Hotel', 'Sign In', '2018-08-23', '09:56:01'),
  	(36, 1, 'Super Hotel', 'Sign In', '2018-08-23', '14:25:33'),
  	(37, 1, 'Super Hotel', 'Sign In', '2018-08-24', '07:37:16'),
  	(38, 1, 'Super Hotel', 'Sign In', '2018-08-24', '07:38:39'),
  	(39, 1, 'Super Hotel', 'Sign In', '2018-08-24', '08:00:43'),
  	(40, 1, 'Super Hotel', 'Sign Out', '2018-08-24', '10:17:47'),
  	(41, 1, 'Super Hotel', 'Sign In', '2018-08-25', '19:06:16'),
  	(42, 1, 'Super Hotel', 'Sign In', '2018-08-26', '16:41:12'),
  	(43, 1, 'Super Hotel', 'Sign In', '2018-08-27', '05:51:21'),
  	(44, 1, 'Super Hotel', 'Sign In', '2018-08-27', '08:09:20'),
  	(45, 1, 'Super Hotel', 'Sign In', '2018-08-27', '18:36:53'),
  	(46, 1, 'Super Hotel', 'Sign In', '2018-08-27', '18:54:24'),
  	(47, 1, 'Super Hotel', 'Sign In', '2018-08-28', '08:45:28');
  /*!40000 ALTER TABLE `hot_log` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.hot_member
  DROP TABLE IF EXISTS `hot_member`;
  CREATE TABLE IF NOT EXISTS `hot_member` (
    `member_id` int(11) NOT NULL AUTO_INCREMENT,
    `member_name` varchar(128) NOT NULL,
    `member_gender` char(1) NOT NULL,
    `member_phone` varchar(128) NOT NULL,
    `member_address` varchar(255) NOT NULL,
    `member_id_type` tinyint(1) NOT NULL DEFAULT '1',
    `member_id_no` varchar(20) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `created_by` varchar(50) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `updated_by` varchar(20) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`member_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.hot_member: ~2 rows (approximately)
  DELETE FROM `hot_member`;
  /*!40000 ALTER TABLE `hot_member` DISABLE KEYS */;
  INSERT INTO `hot_member` (`member_id`, `member_name`, `member_gender`, `member_phone`, `member_address`, `member_id_type`, `member_id_no`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	(1, 'Suparman', 'L', '', '', 1, '', '2018-08-21 11:04:16', 'Super Hotel', '0000-00-00 00:00:00', 'System', 1, 0),
  	(2, 'AA123AA', 'P', '12345', '', 2, '12312312319826387125', '2018-08-21 12:12:22', 'Super Hotel', '0000-00-00 00:00:00', 'Super Hotel', 1, 0);
  /*!40000 ALTER TABLE `hot_member` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.hot_module
  DROP TABLE IF EXISTS `hot_module`;
  CREATE TABLE IF NOT EXISTS `hot_module` (
    `module_id` varchar(15) NOT NULL,
    `module_parent` varchar(15) NOT NULL,
    `module_name` varchar(32) NOT NULL,
    `module_folder` varchar(32) NOT NULL,
    `module_controller` varchar(32) NOT NULL,
    `module_url` varchar(32) NOT NULL,
    `module_icon` varchar(32) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_actived` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`module_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.hot_module: ~22 rows (approximately)
  DELETE FROM `hot_module`;
  /*!40000 ALTER TABLE `hot_module` DISABLE KEYS */;
  INSERT INTO `hot_module` (`module_id`, `module_parent`, `module_name`, `module_folder`, `module_controller`, `module_url`, `module_icon`, `created`, `created_by`, `updated`, `updated_by`, `is_actived`, `is_deleted`) VALUES
  	('01', '', 'Dashboard', 'hot_dashboard', 'hot_dashboard', 'index', 'dashboard', '2018-08-18 05:51:24', '', '2018-08-18 05:51:24', '', 0, 0),
  	('02', '', 'Master', '', '', '#', 'cubes', '2018-08-18 05:51:24', '', '2018-08-18 05:51:24', '', 0, 0),
  	('02.01', '02', 'Jenis Biaya', 'hot_charge_type', 'hot_charge_type', 'index', '', '2018-08-18 05:51:24', '', '2018-08-18 05:51:24', '', 0, 0),
  	('02.02', '02', 'Tipe Kamar', 'hot_room_type', 'hot_room_type', 'index', '', '2018-08-18 05:51:24', '', '2018-08-18 05:51:24', '', 0, 0),
  	('02.03', '02', 'Kamar', 'hot_room', 'hot_room', 'index', '', '2018-08-18 05:51:24', '', '2018-08-18 05:51:24', '', 0, 0),
  	('02.05', '02', 'Tamu', 'hot_guest', 'hot_guest', 'index', '', '2018-08-18 05:51:24', '', '2018-08-18 05:51:24', '', 0, 0),
  	('02.06', '02', 'Pelayanan', 'hot_service', 'hot_service', 'index', '', '2018-08-18 05:51:24', '', '2018-08-18 05:51:24', '', 0, 0),
  	('02.07', '02', 'Ekstra', 'hot_extra', 'hot_extra', 'index', '', '2018-08-18 05:51:24', '', '2018-08-18 05:51:24', '', 0, 0),
  	('02.08', '02', 'FnB', 'hot_fnb', 'hot_fnb', 'index', '', '2018-08-18 05:51:24', '', '2018-08-18 05:51:24', '', 0, 0),
  	('02.09', '02', 'Diskon', 'hot_discount', 'hot_discount', 'index', '', '2018-08-18 05:51:24', '', '2018-08-18 05:51:24', '', 0, 0),
  	('03', '', 'Reservasi', 'hot_reservation', 'hot_reservation', 'index', 'address-book-o', '2018-08-18 05:51:24', '', '2018-08-18 05:51:24', '', 0, 0),
  	('04', '', 'Laporan', '', '', '#', 'files-o', '2018-08-18 05:51:24', '', '2018-08-18 05:51:24', '', 0, 0),
  	('04.01', '04', 'Laporan Reservasi (semua)', 'hot_report_reservation', 'hot_report_reservation', 'index', '', '2018-08-18 05:51:24', '', '2018-08-18 05:51:24', '', 0, 0),
  	('04.02', '04', 'Laporan Reservasi  (resepsionis)', 'hot_report_receptionist', 'hot_report_receptionist', 'index', '', '2018-08-18 05:51:24', '', '2018-08-18 05:51:24', '', 0, 0),
  	('04.03', '04', 'Laporan Pembayaran', 'hot_report_payment', 'hot_report_payment', 'index', '', '2018-08-18 05:51:24', '', '2018-08-18 05:51:24', '', 0, 0),
  	('04.04', '04', 'Laporan Piutang', 'hot_report_credit', 'hot_report_credit', 'index', '', '2018-08-18 05:51:24', '', '2018-08-18 05:51:24', '', 0, 0),
  	('99', '', 'Pengaturan', '', '', '#', 'gears', '2018-08-18 05:51:24', '', '2018-08-18 05:51:24', '', 0, 0),
  	('99.01', '99', 'Modul', 'hot_module', 'hot_module', 'index', '', '2018-08-18 05:51:24', '', '2018-08-18 05:51:24', '', 0, 0),
  	('99.02', '99', 'Role', 'hot_role', 'hot_role', 'index', '', '2018-08-18 05:51:24', '', '2018-08-18 05:51:24', '', 0, 0),
  	('99.03', '99', 'Pengguna', 'hot_user', 'hot_user', 'index', '', '2018-08-18 05:51:24', '', '2018-08-18 05:51:24', '', 0, 0),
  	('99.04', '99', 'Hak Akses', 'hot_permission', 'hot_permission', 'index', '', '2018-08-18 05:51:24', '', '2018-08-18 05:51:24', '', 0, 0),
  	('99.05', '99', 'Client', 'hot_client', 'hot_client', 'index', '', '2018-08-18 05:51:24', '', '2018-08-18 05:51:24', '', 0, 0);
  /*!40000 ALTER TABLE `hot_module` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.hot_payment
  DROP TABLE IF EXISTS `hot_payment`;
  CREATE TABLE IF NOT EXISTS `hot_payment` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `booking_id` int(155) NOT NULL,
    `subtotal` int(155) DEFAULT '0',
    `disc` int(155) DEFAULT '0',
    `grand_total` int(155) DEFAULT '0',
    `bayar` int(155) DEFAULT NULL,
    `sisa` int(155) DEFAULT NULL,
    `cashed` int(155) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    `posting_st` tinyint(1) NOT NULL DEFAULT '0',
    `posting_date` datetime DEFAULT NULL,
    `status` int(155) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  
  -- Dumping data for table prisma_pos.hot_payment: ~0 rows (approximately)
  DELETE FROM `hot_payment`;
  /*!40000 ALTER TABLE `hot_payment` DISABLE KEYS */;
  /*!40000 ALTER TABLE `hot_payment` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.hot_permission
  DROP TABLE IF EXISTS `hot_permission`;
  CREATE TABLE IF NOT EXISTS `hot_permission` (
    `permission_id` int(11) NOT NULL AUTO_INCREMENT,
    `role_id` int(11) NOT NULL,
    `module_id` varchar(25) NOT NULL,
    `_create` int(1) DEFAULT NULL,
    `_read` int(1) DEFAULT NULL,
    `_update` int(1) DEFAULT NULL,
    `_delete` int(1) DEFAULT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(255) NOT NULL,
    PRIMARY KEY (`permission_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.hot_permission: ~45 rows (approximately)
  DELETE FROM `hot_permission`;
  /*!40000 ALTER TABLE `hot_permission` DISABLE KEYS */;
  INSERT INTO `hot_permission` (`permission_id`, `role_id`, `module_id`, `_create`, `_read`, `_update`, `_delete`, `created`, `created_by`) VALUES
  	(1, 0, '01', 1, 1, 1, 1, '2018-08-20 05:33:20', 'System'),
  	(2, 0, '02', 1, 1, 1, 1, '2018-08-20 05:33:20', 'System'),
  	(3, 0, '02.01', 1, 1, 1, 1, '2018-08-20 05:33:20', 'System'),
  	(4, 0, '02.02', 1, 1, 1, 1, '2018-08-20 05:33:20', 'System'),
  	(5, 0, '02.03', 1, 1, 1, 1, '2018-08-20 05:33:20', 'System'),
  	(6, 0, '02.04', 1, 1, 1, 1, '2018-08-20 05:33:20', 'System'),
  	(7, 0, '02.05', 1, 1, 1, 1, '2018-08-20 05:33:20', 'System'),
  	(8, 0, '02.06', 1, 1, 1, 1, '2018-08-20 05:33:20', 'System'),
  	(9, 0, '02.07', 1, 1, 1, 1, '2018-08-20 05:33:20', 'System'),
  	(10, 0, '02.08', 1, 1, 1, 1, '2018-08-20 05:33:20', 'System'),
  	(11, 0, '02.09', 1, 1, 1, 1, '2018-08-20 05:33:20', 'System'),
  	(12, 0, '03', 1, 1, 1, 1, '2018-08-20 05:33:20', 'System'),
  	(13, 0, '04', 1, 1, 1, 1, '2018-08-20 05:33:20', 'System'),
  	(14, 0, '04.01', 1, 1, 1, 1, '2018-08-20 05:33:20', 'System'),
  	(15, 0, '04.02', 1, 1, 1, 1, '2018-08-20 05:33:20', 'System'),
  	(16, 0, '04.03', 1, 1, 1, 1, '2018-08-20 05:33:20', 'System'),
  	(17, 0, '04.04', 1, 1, 1, 1, '2018-08-20 05:33:20', 'System'),
  	(18, 0, '99', 1, 1, 1, 1, '2018-08-20 05:33:20', 'System'),
  	(19, 0, '99.01', 1, 1, 1, 1, '2018-08-20 05:33:20', 'System'),
  	(20, 0, '99.02', 1, 1, 1, 1, '2018-08-20 05:33:20', 'System'),
  	(21, 0, '99.03', 1, 1, 1, 1, '2018-08-20 05:33:20', 'System'),
  	(22, 0, '99.04', 1, 1, 1, 1, '2018-08-20 05:33:20', 'System'),
  	(23, 0, '99.05', 1, 1, 1, 1, '2018-08-20 05:33:20', 'System'),
  	(24, 1, '01', 1, 1, 1, 1, '2018-08-20 05:33:20', 'System'),
  	(25, 1, '02', 1, 1, 1, 1, '2018-08-20 05:33:20', 'System'),
  	(26, 1, '02.01', 1, 1, 1, 1, '2018-08-20 05:33:20', 'System'),
  	(27, 1, '02.02', 1, 1, 1, 1, '2018-08-20 05:33:20', 'System'),
  	(28, 1, '02.03', 1, 1, 1, 1, '2018-08-20 05:33:20', 'System'),
  	(29, 1, '02.04', 1, 1, 1, 1, '2018-08-20 05:33:20', 'System'),
  	(30, 1, '02.05', 1, 1, 1, 1, '2018-08-20 05:33:20', 'System'),
  	(31, 1, '02.06', 1, 1, 1, 1, '2018-08-20 05:33:20', 'System'),
  	(32, 1, '02.07', 1, 1, 1, 1, '2018-08-20 05:33:20', 'System'),
  	(33, 1, '02.08', 1, 1, 1, 1, '2018-08-20 05:33:20', 'System'),
  	(34, 1, '02.09', 1, 1, 1, 1, '2018-08-20 05:33:20', 'System'),
  	(35, 1, '03', 1, 1, 1, 1, '2018-08-20 05:33:20', 'System'),
  	(36, 1, '04', 1, 1, 1, 1, '2018-08-20 05:33:20', 'System'),
  	(37, 1, '04.01', 1, 1, 1, 1, '2018-08-20 05:33:20', 'System'),
  	(38, 1, '04.02', 1, 1, 1, 1, '2018-08-20 05:33:20', 'System'),
  	(39, 1, '04.03', 1, 1, 1, 1, '2018-08-20 05:33:20', 'System'),
  	(40, 1, '04.04', 1, 1, 1, 1, '2018-08-20 05:33:20', 'System'),
  	(41, 1, '99', 1, 1, 1, 1, '2018-08-20 05:33:20', 'System'),
  	(42, 1, '99.03', 1, 1, 1, 1, '2018-08-20 05:33:20', 'System'),
  	(43, 1, '99.05', 1, 1, 1, 1, '2018-08-20 05:33:20', 'System'),
  	(44, 3, '01', 1, 1, 1, 1, '2018-08-20 05:33:20', 'System'),
  	(45, 3, '03', 1, 1, 1, 1, '2018-08-20 05:33:20', 'System');
  /*!40000 ALTER TABLE `hot_permission` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.hot_role
  DROP TABLE IF EXISTS `hot_role`;
  CREATE TABLE IF NOT EXISTS `hot_role` (
    `role_id` int(11) NOT NULL AUTO_INCREMENT,
    `role_name` varchar(255) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`role_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.hot_role: ~3 rows (approximately)
  DELETE FROM `hot_role`;
  /*!40000 ALTER TABLE `hot_role` DISABLE KEYS */;
  INSERT INTO `hot_role` (`role_id`, `role_name`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	(0, 'Super Administrator Hotel', '2018-03-30 11:16:36', 'Super Administrator', '2018-05-18 13:44:46', 'Super Administrator', 1, 0),
  	(1, 'Administrator Hotel', '2018-03-30 11:18:19', 'Super Administrator', '2018-05-18 13:44:51', 'Super Administrator', 1, 0),
  	(3, 'Cashier Hotel', '2018-05-08 13:42:21', 'Admin Hotel', '2018-05-18 13:45:02', 'Super Retail', 1, 0);
  /*!40000 ALTER TABLE `hot_role` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.hot_room
  DROP TABLE IF EXISTS `hot_room`;
  CREATE TABLE IF NOT EXISTS `hot_room` (
    `room_id` varchar(50) NOT NULL,
    `room_name` varchar(50) NOT NULL DEFAULT '0',
    `room_type_id` int(11) NOT NULL DEFAULT '0',
    `room_no` varchar(10) NOT NULL DEFAULT '0',
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(128) NOT NULL DEFAULT 'System',
    `updated` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(128) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`room_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.hot_room: ~10 rows (approximately)
  DELETE FROM `hot_room`;
  /*!40000 ALTER TABLE `hot_room` DISABLE KEYS */;
  INSERT INTO `hot_room` (`room_id`, `room_name`, `room_type_id`, `room_no`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	('11', 'Melati - 01', 1, '1', '2018-08-21 15:27:11', 'Super Hotel', NULL, 'System', 1, 0),
  	('110', 'Melati - 10', 1, '10', '2018-08-21 15:27:12', 'Super Hotel', NULL, 'System', 1, 0),
  	('12', 'Melati - 02', 1, '2', '2018-08-21 15:27:11', 'Super Hotel', NULL, 'System', 1, 0),
  	('13', 'Melati - 03', 1, '3', '2018-08-21 15:27:11', 'Super Hotel', NULL, 'System', 1, 0),
  	('14', 'Melati - 04', 1, '4', '2018-08-21 15:27:12', 'Super Hotel', NULL, 'System', 1, 0),
  	('15', 'Melati - 05', 1, '5', '2018-08-21 15:27:12', 'Super Hotel', NULL, 'System', 1, 0),
  	('16', 'Melati - 06', 1, '6', '2018-08-21 15:27:12', 'Super Hotel', NULL, 'System', 1, 0),
  	('17', 'Melati - 07', 1, '7', '2018-08-21 15:27:12', 'Super Hotel', NULL, 'System', 1, 0),
  	('18', 'Melati - 08', 1, '8', '2018-08-21 15:27:12', 'Super Hotel', NULL, 'System', 1, 0),
  	('19', 'Melati - 09', 1, '9', '2018-08-21 15:27:12', 'Super Hotel', NULL, 'System', 1, 0);
  /*!40000 ALTER TABLE `hot_room` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.hot_room_type
  DROP TABLE IF EXISTS `hot_room_type`;
  CREATE TABLE IF NOT EXISTS `hot_room_type` (
    `room_type_id` int(11) NOT NULL AUTO_INCREMENT,
    `room_type_name` varchar(128) NOT NULL,
    `room_type_charge` float(10,2) NOT NULL,
    `room_type_desc` varchar(128) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(128) NOT NULL DEFAULT 'System',
    `updated` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(128) NOT NULL,
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`room_type_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.hot_room_type: ~1 rows (approximately)
  DELETE FROM `hot_room_type`;
  /*!40000 ALTER TABLE `hot_room_type` DISABLE KEYS */;
  INSERT INTO `hot_room_type` (`room_type_id`, `room_type_name`, `room_type_charge`, `room_type_desc`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	(1, 'Melati', 100000.00, '', '2018-08-21 15:27:11', 'Super Hotel', NULL, '', 1, 0),
  	(2, 'fasdfasd', 90909.09, '', '2018-08-25 20:31:26', 'System', NULL, '', 1, 0);
  /*!40000 ALTER TABLE `hot_room_type` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.hot_service
  DROP TABLE IF EXISTS `hot_service`;
  CREATE TABLE IF NOT EXISTS `hot_service` (
    `service_id` int(11) NOT NULL AUTO_INCREMENT,
    `service_name` varchar(128) NOT NULL,
    `service_charge` float(10,2) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`service_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  
  -- Dumping data for table prisma_pos.hot_service: ~0 rows (approximately)
  DELETE FROM `hot_service`;
  /*!40000 ALTER TABLE `hot_service` DISABLE KEYS */;
  INSERT INTO `hot_service` (`service_id`, `service_name`, `service_charge`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	(1, 'handuk', 10000.00, '2018-08-20 15:16:18', 'Super Hotel', '0000-00-00 00:00:00', 'System', 1, 0);
  /*!40000 ALTER TABLE `hot_service` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.hot_tax
  DROP TABLE IF EXISTS `hot_tax`;
  CREATE TABLE IF NOT EXISTS `hot_tax` (
    `tax_id` int(11) NOT NULL AUTO_INCREMENT,
    `tax_code` varchar(15) NOT NULL,
    `tax_name` varchar(128) NOT NULL,
    `tax_ratio` float(10,2) NOT NULL COMMENT 'in percent',
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`tax_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  
  -- Dumping data for table prisma_pos.hot_tax: ~0 rows (approximately)
  DELETE FROM `hot_tax`;
  /*!40000 ALTER TABLE `hot_tax` DISABLE KEYS */;
  INSERT INTO `hot_tax` (`tax_id`, `tax_code`, `tax_name`, `tax_ratio`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	(1, '1.1.1.01.05\r\n', 'Pajak Hotel', 10.00, '2018-07-05 09:49:40', 'System', '0000-00-00 00:00:00', 'System', 1, 0);
  /*!40000 ALTER TABLE `hot_tax` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.hot_user
  DROP TABLE IF EXISTS `hot_user`;
  CREATE TABLE IF NOT EXISTS `hot_user` (
    `user_id` int(11) NOT NULL AUTO_INCREMENT,
    `user_name` varchar(32) NOT NULL,
    `role_id` int(11) NOT NULL,
    `user_password` varchar(32) NOT NULL,
    `user_realname` varchar(128) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`user_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.hot_user: ~3 rows (approximately)
  DELETE FROM `hot_user`;
  /*!40000 ALTER TABLE `hot_user` DISABLE KEYS */;
  INSERT INTO `hot_user` (`user_id`, `user_name`, `role_id`, `user_password`, `user_realname`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	(1, 'superhotel', 0, '21232f297a57a5a743894a0e4a801fc3', 'Super Hotel', '2018-04-04 10:45:37', 'System', '2018-05-17 14:51:48', 'System', 1, 0),
  	(2, 'adminhotel', 1, '21232f297a57a5a743894a0e4a801fc3', 'Admin Hotel', '2018-05-08 13:40:40', 'System', '2018-05-17 14:51:52', 'System', 1, 0),
  	(3, 'cashierhotel', 3, '21232f297a57a5a743894a0e4a801fc3', 'Cashier Hotel', '2018-05-08 13:43:54', 'System', '2018-05-17 14:51:57', 'System', 1, 0);
  /*!40000 ALTER TABLE `hot_user` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.kar_bank
  DROP TABLE IF EXISTS `kar_bank`;
  CREATE TABLE IF NOT EXISTS `kar_bank` (
    `bank_id` int(11) NOT NULL AUTO_INCREMENT,
    `payment_type_id` int(11) NOT NULL,
    `bank_name` varchar(128) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`bank_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  
  -- Dumping data for table prisma_pos.kar_bank: ~0 rows (approximately)
  DELETE FROM `kar_bank`;
  /*!40000 ALTER TABLE `kar_bank` DISABLE KEYS */;
  /*!40000 ALTER TABLE `kar_bank` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.kar_billing
  DROP TABLE IF EXISTS `kar_billing`;
  CREATE TABLE IF NOT EXISTS `kar_billing` (
    `tx_id` int(11) NOT NULL AUTO_INCREMENT,
    `tx_receipt_no` varchar(12) NOT NULL DEFAULT '0',
    `user_id` int(11) NOT NULL,
    `user_realname` varchar(255) NOT NULL,
    `member_id` int(11) NOT NULL,
    `member_name` varchar(255) NOT NULL,
    `room_id` int(11) NOT NULL,
    `room_name` varchar(128) NOT NULL,
    `tx_room_price` float(10,2) NOT NULL,
    `tx_duration` int(11) NOT NULL,
    `tx_room_price_total` float(10,2) NOT NULL,
    `tx_date` date NOT NULL,
    `tx_time_start` time NOT NULL,
    `tx_time_end` time NOT NULL,
    `payment_type_id` int(11) NOT NULL,
    `tx_payment` float(10,2) NOT NULL,
    `tx_status` int(1) NOT NULL DEFAULT '0',
    `tx_cancel_notes` text,
    `bank_id` int(11) NOT NULL,
    `bank_card_no` varchar(32) NOT NULL,
    `tx_total_tax` float(10,2) NOT NULL,
    `tx_total_discount` float(10,2) NOT NULL,
    `tx_total_before_tax` float(10,2) NOT NULL,
    `tx_total_after_tax` float(10,2) NOT NULL,
    `tx_total_grand` float(10,2) NOT NULL,
    `tx_change` float(10,2) NOT NULL,
    `created` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    `posting_st` tinyint(1) NOT NULL DEFAULT '0',
    `posting_date` datetime DEFAULT NULL,
    PRIMARY KEY (`tx_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  
  -- Dumping data for table prisma_pos.kar_billing: ~0 rows (approximately)
  DELETE FROM `kar_billing`;
  /*!40000 ALTER TABLE `kar_billing` DISABLE KEYS */;
  /*!40000 ALTER TABLE `kar_billing` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.kar_billing_service_charge
  DROP TABLE IF EXISTS `kar_billing_service_charge`;
  CREATE TABLE IF NOT EXISTS `kar_billing_service_charge` (
    `tx_service_charge_id` int(11) NOT NULL AUTO_INCREMENT,
    `tx_id` int(11) NOT NULL,
    `service_charge_id` int(11) NOT NULL,
    `service_charge_name` varchar(128) NOT NULL,
    `service_charge_price` float(10,2) NOT NULL,
    `service_charge_amount` int(11) NOT NULL,
    `service_charge_total` float(10,2) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`tx_service_charge_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  
  -- Dumping data for table prisma_pos.kar_billing_service_charge: ~0 rows (approximately)
  DELETE FROM `kar_billing_service_charge`;
  /*!40000 ALTER TABLE `kar_billing_service_charge` DISABLE KEYS */;
  /*!40000 ALTER TABLE `kar_billing_service_charge` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.kar_client
  DROP TABLE IF EXISTS `kar_client`;
  CREATE TABLE IF NOT EXISTS `kar_client` (
    `client_id` varchar(32) NOT NULL,
    `client_name` varchar(32) NOT NULL,
    `client_brand` varchar(32) NOT NULL,
    `client_status` varchar(32) NOT NULL,
    `client_street` varchar(128) NOT NULL,
    `client_subdistrict` varchar(32) NOT NULL,
    `client_district` varchar(32) NOT NULL,
    `client_city` varchar(32) NOT NULL,
    `client_province` varchar(32) NOT NULL,
    `client_email` varchar(32) NOT NULL,
    `client_phone_1` varchar(15) NOT NULL,
    `client_phone_2` varchar(15) NOT NULL,
    `client_npwp` varchar(64) NOT NULL,
    `client_npwpd` varchar(64) NOT NULL,
    `client_owner_name` varchar(64) NOT NULL,
    `client_owner_address` text NOT NULL,
    `client_notes` text NOT NULL,
    `client_serial_number` varchar(20) NOT NULL,
    `client_keyboard_status` tinyint(1) NOT NULL DEFAULT '1',
    `client_receipt_is_taxed` tinyint(1) NOT NULL DEFAULT '1',
    `client_logo` varchar(255) DEFAULT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`client_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.kar_client: ~0 rows (approximately)
  DELETE FROM `kar_client`;
  /*!40000 ALTER TABLE `kar_client` DISABLE KEYS */;
  INSERT INTO `kar_client` (`client_id`, `client_name`, `client_brand`, `client_status`, `client_street`, `client_subdistrict`, `client_district`, `client_city`, `client_province`, `client_email`, `client_phone_1`, `client_phone_2`, `client_npwp`, `client_npwpd`, `client_owner_name`, `client_owner_address`, `client_notes`, `client_serial_number`, `client_keyboard_status`, `client_receipt_is_taxed`, `client_logo`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	('1', 'CV Prisma Karaoke', 'Prisma Karaoke', 'sendiri', 'Jalan Gajahmada 56', 'Warungboto', 'Umbulharjo', 'Yogyakarta', 'Daerah Istimewa Yogyakarta', 'buat@gmail.com', '123', '123', '1234', '1234', 'Sujo', 'jalan manggis\r\n', 'Tidak ada', '1234-1234-1234', 0, 1, NULL, '2018-05-08 10:26:03', 'System', '2018-06-25 09:32:58', 'Super Karaoke', 1, 0);
  /*!40000 ALTER TABLE `kar_client` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.kar_log
  DROP TABLE IF EXISTS `kar_log`;
  CREATE TABLE IF NOT EXISTS `kar_log` (
    `log_id` int(11) NOT NULL AUTO_INCREMENT,
    `user_id` int(11) NOT NULL,
    `user_realname` varchar(128) NOT NULL,
    `log_type` enum('Sign In','Sign Out') NOT NULL,
    `log_date` date NOT NULL,
    `log_time` time NOT NULL,
    PRIMARY KEY (`log_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  
  -- Dumping data for table prisma_pos.kar_log: ~0 rows (approximately)
  DELETE FROM `kar_log`;
  /*!40000 ALTER TABLE `kar_log` DISABLE KEYS */;
  /*!40000 ALTER TABLE `kar_log` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.kar_member
  DROP TABLE IF EXISTS `kar_member`;
  CREATE TABLE IF NOT EXISTS `kar_member` (
    `member_id` int(11) NOT NULL AUTO_INCREMENT,
    `member_type_id` int(11) NOT NULL DEFAULT '0',
    `member_name` varchar(255) NOT NULL,
    `member_phone` varchar(20) NOT NULL,
    `member_fax` varchar(20) NOT NULL,
    `member_email` varchar(255) NOT NULL,
    `member_address` text NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(255) NOT NULL,
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `updated_by` varchar(255) NOT NULL,
    `is_active` int(1) NOT NULL DEFAULT '1',
    `is_deleted` int(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`member_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  
  -- Dumping data for table prisma_pos.kar_member: ~0 rows (approximately)
  DELETE FROM `kar_member`;
  /*!40000 ALTER TABLE `kar_member` DISABLE KEYS */;
  /*!40000 ALTER TABLE `kar_member` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.kar_member_type
  DROP TABLE IF EXISTS `kar_member_type`;
  CREATE TABLE IF NOT EXISTS `kar_member_type` (
    `member_type_id` int(11) NOT NULL AUTO_INCREMENT,
    `member_type_name` varchar(128) NOT NULL DEFAULT '0',
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(128) NOT NULL DEFAULT 'System',
    `updated` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(128) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`member_type_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.kar_member_type: ~0 rows (approximately)
  DELETE FROM `kar_member_type`;
  /*!40000 ALTER TABLE `kar_member_type` DISABLE KEYS */;
  /*!40000 ALTER TABLE `kar_member_type` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.kar_module
  DROP TABLE IF EXISTS `kar_module`;
  CREATE TABLE IF NOT EXISTS `kar_module` (
    `module_id` varchar(15) NOT NULL,
    `module_parent` varchar(15) NOT NULL,
    `module_name` varchar(32) NOT NULL,
    `module_folder` varchar(32) NOT NULL,
    `module_controller` varchar(32) NOT NULL,
    `module_url` varchar(32) NOT NULL,
    `module_icon` varchar(32) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_actived` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`module_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.kar_module: ~24 rows (approximately)
  DELETE FROM `kar_module`;
  /*!40000 ALTER TABLE `kar_module` DISABLE KEYS */;
  INSERT INTO `kar_module` (`module_id`, `module_parent`, `module_name`, `module_folder`, `module_controller`, `module_url`, `module_icon`, `created`, `created_by`, `updated`, `updated_by`, `is_actived`, `is_deleted`) VALUES
  	('01', '', 'Dashboard', 'kar_dashboard', 'kar_dashboard', 'index', 'dashboard', '2018-04-04 10:26:27', 'Super Administrator', '2018-05-18 10:41:20', 'Super Administrator', 1, 0),
  	('02', '', 'Master', '', '', '#', 'cubes', '2018-06-01 20:12:17', 'Super Karaoke', '0000-00-00 00:00:00', 'System', 1, 0),
  	('02.01', '02', 'Waktu', 'kar_time', 'kar_time', 'index', 'clock-o', '2018-06-01 21:06:07', 'Super Karaoke', '2018-06-01 21:17:41', 'Super Karaoke', 1, 0),
  	('02.02', '02', 'Tipe Ruang', 'kar_room_type', 'kar_room_type', 'index', 'home', '2018-06-01 20:21:07', 'Super Karaoke', '2018-06-02 06:30:00', 'Super Karaoke', 1, 0),
  	('02.03', '02', 'Ruang', 'kar_room', 'kar_room', 'index', 'home', '2018-06-01 22:23:54', 'Super Karaoke', '0000-00-00 00:00:00', 'System', 1, 0),
  	('02.04', '02', 'Tipe Member', 'kar_member_type', 'kar_member_type', 'index', 'users', '2018-06-02 08:39:21', 'Super Karaoke', '0000-00-00 00:00:00', 'System', 1, 0),
  	('02.05', '02', 'Member', 'kar_member', 'kar_member', 'index', 'user', '2018-06-02 08:56:52', 'Super Karaoke', '0000-00-00 00:00:00', 'System', 1, 0),
  	('02.06', '02', 'Service Charge', 'kar_service_charge', 'kar_service_charge', 'index', 'plus', '2018-06-02 09:08:35', 'Super Karaoke', '0000-00-00 00:00:00', 'System', 1, 0),
  	('02.07', '02', 'Bank', 'kar_bank', 'kar_bank', 'index', 'university', '2018-06-02 16:20:27', 'Super Karaoke', '0000-00-00 00:00:00', 'System', 1, 0),
  	('03', '', 'Kasir', 'kar_cashier', 'kar_cashier', 'index', 'laptop', '2018-06-02 12:00:37', 'Super Karaoke', '0000-00-00 00:00:00', 'System', 1, 0),
  	('04', '', 'Laporan', '', '', 'index', 'files-o', '2018-06-03 15:38:31', 'Super Karaoke', '0000-00-00 00:00:00', 'System', 1, 0),
  	('04.01', '04', 'Penyewaan (Semua)', 'kar_report_billing', 'kar_report_billing', 'index', 'file', '2018-06-03 15:40:53', 'Super Karaoke', '0000-00-00 00:00:00', 'System', 1, 0),
  	('04.02', '04', 'Penyewaan (Kasir)', 'kar_report_billing_cashier', 'kar_report_billing_cashier', 'index', 'laptop', '2018-06-03 20:58:38', 'Super Karaoke', '0000-00-00 00:00:00', 'System', 1, 0),
  	('04.03', '04', 'Penyewaan (Member)', 'kar_report_billing_member', 'kar_report_billing_member', 'index', 'users', '2018-06-03 21:17:10', 'Super Karaoke', '0000-00-00 00:00:00', 'System', 1, 0),
  	('04.04', '04', 'Shift', 'kar_report_shift', 'kar_report_shift', 'index', 'user', '2018-06-03 21:38:26', 'Super Karaoke', '2018-06-03 21:40:01', 'Super Karaoke', 1, 0),
  	('04.05', '04', 'Log Akses', 'kar_report_log', 'kar_report_log', 'index', 'users', '2018-06-05 08:21:20', 'Super Karaoke', '0000-00-00 00:00:00', 'System', 1, 0),
  	('04.06', '04', 'Piutang', 'kar_report_credit', 'kar_report_credit', 'index', 'credit-card', '2018-06-08 10:30:50', 'Super Karaoke', '2018-06-08 10:40:14', 'Super Karaoke', 1, 0),
  	('99', '', 'Pengaturan', '', '', '#', 'gears', '2018-04-04 09:41:46', 'Super Administrator', '0000-00-00 00:00:00', '', 1, 0),
  	('99.01', '99', 'Modul', 'kar_module', 'kar_module', 'index', 'window-restore', '2018-04-04 09:44:01', 'Super Administrator', '2018-05-18 10:41:46', 'Super Administrator', 1, 0),
  	('99.02', '99', 'Role', 'kar_role', 'kar_role', 'index', 'users', '2018-04-04 09:46:50', 'Super Administrator', '2018-05-18 10:41:49', 'Super Administrator', 1, 0),
  	('99.03', '99', 'Pengguna', 'kar_user', 'kar_user', 'index', '', '2018-04-04 10:37:41', 'Super Administrator', '2018-05-18 10:41:52', 'Super Administrator', 1, 0),
  	('99.04', '99', 'Hak Akses', 'kar_permission', 'kar_permission', 'index', 'list', '2018-04-05 08:20:56', 'Super Administrator', '2018-05-18 10:41:55', '', 1, 0),
  	('99.05', '99', 'Client', 'kar_client', 'kar_client', 'index', 'th-large', '2018-04-05 17:31:04', 'Super Administrator', '2018-05-18 10:41:58', 'Super Administrator', 1, 0),
  	('99.06', '99', 'Struk', 'kar_receipt', 'kar_receipt', 'index', 'print', '2018-06-07 09:27:58', 'Super Karaoke', '0000-00-00 00:00:00', 'System', 1, 0);
  /*!40000 ALTER TABLE `kar_module` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.kar_payment_type
  DROP TABLE IF EXISTS `kar_payment_type`;
  CREATE TABLE IF NOT EXISTS `kar_payment_type` (
    `payment_type_id` int(11) NOT NULL AUTO_INCREMENT,
    `payment_type_name` varchar(32) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`payment_type_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  
  -- Dumping data for table prisma_pos.kar_payment_type: ~3 rows (approximately)
  DELETE FROM `kar_payment_type`;
  /*!40000 ALTER TABLE `kar_payment_type` DISABLE KEYS */;
  INSERT INTO `kar_payment_type` (`payment_type_id`, `payment_type_name`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	(1, 'Cash', '2018-04-19 19:34:04', 'System', '0000-00-00 00:00:00', 'System', 1, 0),
  	(2, 'Debit Card', '2018-04-19 19:34:04', 'System', '0000-00-00 00:00:00', 'System', 1, 0),
  	(3, 'Credit Card', '2018-04-19 19:34:12', 'System', '0000-00-00 00:00:00', 'System', 1, 0);
  /*!40000 ALTER TABLE `kar_payment_type` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.kar_permission
  DROP TABLE IF EXISTS `kar_permission`;
  CREATE TABLE IF NOT EXISTS `kar_permission` (
    `permission_id` int(11) NOT NULL AUTO_INCREMENT,
    `role_id` int(11) NOT NULL,
    `module_id` varchar(25) NOT NULL,
    `_create` int(1) DEFAULT NULL,
    `_read` int(1) DEFAULT NULL,
    `_update` int(1) DEFAULT NULL,
    `_delete` int(1) DEFAULT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(255) NOT NULL,
    PRIMARY KEY (`permission_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=902 DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.kar_permission: ~24 rows (approximately)
  DELETE FROM `kar_permission`;
  /*!40000 ALTER TABLE `kar_permission` DISABLE KEYS */;
  INSERT INTO `kar_permission` (`permission_id`, `role_id`, `module_id`, `_create`, `_read`, `_update`, `_delete`, `created`, `created_by`) VALUES
  	(878, 0, '01', 1, 1, 1, 1, '2018-06-08 10:39:00', 'Super Karaoke'),
  	(879, 0, '02', 1, 1, 1, 1, '2018-06-08 10:39:00', 'Super Karaoke'),
  	(880, 0, '02.01', 1, 1, 1, 1, '2018-06-08 10:39:00', 'Super Karaoke'),
  	(881, 0, '02.02', 1, 1, 1, 1, '2018-06-08 10:39:00', 'Super Karaoke'),
  	(882, 0, '02.03', 1, 1, 1, 1, '2018-06-08 10:39:00', 'Super Karaoke'),
  	(883, 0, '02.04', 1, 1, 1, 1, '2018-06-08 10:39:00', 'Super Karaoke'),
  	(884, 0, '02.05', 1, 1, 1, 1, '2018-06-08 10:39:00', 'Super Karaoke'),
  	(885, 0, '02.06', 1, 1, 1, 1, '2018-06-08 10:39:00', 'Super Karaoke'),
  	(886, 0, '02.07', 1, 1, 1, 1, '2018-06-08 10:39:00', 'Super Karaoke'),
  	(887, 0, '03', 1, 1, 1, 1, '2018-06-08 10:39:00', 'Super Karaoke'),
  	(888, 0, '04', 1, 1, 1, 1, '2018-06-08 10:39:00', 'Super Karaoke'),
  	(889, 0, '04.01', 1, 1, 1, 1, '2018-06-08 10:39:00', 'Super Karaoke'),
  	(890, 0, '04.02', 1, 1, 1, 1, '2018-06-08 10:39:00', 'Super Karaoke'),
  	(891, 0, '04.03', 1, 1, 1, 1, '2018-06-08 10:39:00', 'Super Karaoke'),
  	(892, 0, '04.04', 1, 1, 1, 1, '2018-06-08 10:39:00', 'Super Karaoke'),
  	(893, 0, '04.05', 1, 1, 1, 1, '2018-06-08 10:39:00', 'Super Karaoke'),
  	(894, 0, '04.06', 1, 1, 1, 1, '2018-06-08 10:39:00', 'Super Karaoke'),
  	(895, 0, '99', 1, 1, 1, 1, '2018-06-08 10:39:00', 'Super Karaoke'),
  	(896, 0, '99.01', 1, 1, 1, 1, '2018-06-08 10:39:00', 'Super Karaoke'),
  	(897, 0, '99.02', 1, 1, 1, 1, '2018-06-08 10:39:01', 'Super Karaoke'),
  	(898, 0, '99.03', 1, 1, 1, 1, '2018-06-08 10:39:01', 'Super Karaoke'),
  	(899, 0, '99.04', 1, 1, 1, 1, '2018-06-08 10:39:01', 'Super Karaoke'),
  	(900, 0, '99.05', 1, 1, 1, 1, '2018-06-08 10:39:01', 'Super Karaoke'),
  	(901, 0, '99.06', 1, 1, 1, 1, '2018-06-08 10:39:01', 'Super Karaoke');
  /*!40000 ALTER TABLE `kar_permission` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.kar_role
  DROP TABLE IF EXISTS `kar_role`;
  CREATE TABLE IF NOT EXISTS `kar_role` (
    `role_id` int(11) NOT NULL AUTO_INCREMENT,
    `role_name` varchar(255) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`role_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.kar_role: ~4 rows (approximately)
  DELETE FROM `kar_role`;
  /*!40000 ALTER TABLE `kar_role` DISABLE KEYS */;
  INSERT INTO `kar_role` (`role_id`, `role_name`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	(0, 'Super Administrator Karaoke', '2018-03-30 11:16:36', 'Super Administrator', '2018-05-18 10:44:11', 'Super Administrator', 1, 0),
  	(1, 'Administrator Karaoke', '2018-03-30 11:18:19', 'Super Administrator', '2018-05-18 10:44:21', 'Super Administrator', 1, 0),
  	(2, 'Cashier Karaoke', '2018-05-08 13:42:21', 'Admin Retail', '2018-06-03 21:04:44', 'Super Retail', 1, 0),
  	(5, 'a', '2018-05-18 10:44:41', 'Super Karaoke', '2018-05-18 10:44:44', 'System', 1, 1);
  /*!40000 ALTER TABLE `kar_role` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.kar_room
  DROP TABLE IF EXISTS `kar_room`;
  CREATE TABLE IF NOT EXISTS `kar_room` (
    `room_id` int(11) NOT NULL AUTO_INCREMENT,
    `room_code` varchar(128) NOT NULL,
    `room_type_id` int(11) NOT NULL,
    `room_name` varchar(128) NOT NULL,
    `room_is_used` tinyint(1) NOT NULL DEFAULT '0',
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`room_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  
  -- Dumping data for table prisma_pos.kar_room: ~0 rows (approximately)
  DELETE FROM `kar_room`;
  /*!40000 ALTER TABLE `kar_room` DISABLE KEYS */;
  /*!40000 ALTER TABLE `kar_room` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.kar_room_type
  DROP TABLE IF EXISTS `kar_room_type`;
  CREATE TABLE IF NOT EXISTS `kar_room_type` (
    `room_type_id` int(11) NOT NULL AUTO_INCREMENT,
    `room_type_name` varchar(128) NOT NULL,
    `room_type_capacity` int(11) NOT NULL,
    `weekday_happy_hours` float(10,2) NOT NULL,
    `weekday_business_hours` float(10,2) NOT NULL,
    `weekend_happy_hours` float(10,2) NOT NULL,
    `weekend_business_hours` float(10,2) NOT NULL,
    `holiday_happy_hours` float(10,2) NOT NULL,
    `holiday_business_hours` float(10,2) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`room_type_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  
  -- Dumping data for table prisma_pos.kar_room_type: ~0 rows (approximately)
  DELETE FROM `kar_room_type`;
  /*!40000 ALTER TABLE `kar_room_type` DISABLE KEYS */;
  /*!40000 ALTER TABLE `kar_room_type` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.kar_service_charge
  DROP TABLE IF EXISTS `kar_service_charge`;
  CREATE TABLE IF NOT EXISTS `kar_service_charge` (
    `service_charge_id` int(11) NOT NULL AUTO_INCREMENT,
    `service_charge_name` varchar(128) NOT NULL DEFAULT '0',
    `service_charge_price` float(10,2) NOT NULL DEFAULT '0.00',
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(128) NOT NULL DEFAULT 'System',
    `updated` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(128) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`service_charge_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  
  -- Dumping data for table prisma_pos.kar_service_charge: ~0 rows (approximately)
  DELETE FROM `kar_service_charge`;
  /*!40000 ALTER TABLE `kar_service_charge` DISABLE KEYS */;
  /*!40000 ALTER TABLE `kar_service_charge` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.kar_shift
  DROP TABLE IF EXISTS `kar_shift`;
  CREATE TABLE IF NOT EXISTS `kar_shift` (
    `shift_id` int(11) NOT NULL AUTO_INCREMENT,
    `user_id` int(11) NOT NULL,
    `user_realname` varchar(128) NOT NULL,
    `shift_in_status` tinyint(1) NOT NULL,
    `shift_out_status` tinyint(1) NOT NULL,
    `shift_in_date` date DEFAULT NULL,
    `shift_in_time` time DEFAULT NULL,
    `shift_out_date` date DEFAULT NULL,
    `shift_out_time` time DEFAULT NULL,
    `money_in_100k` int(11) NOT NULL DEFAULT '0',
    `money_in_50k` int(11) NOT NULL DEFAULT '0',
    `money_in_20k` int(11) NOT NULL DEFAULT '0',
    `money_in_10k` int(11) NOT NULL DEFAULT '0',
    `money_in_5k` int(11) NOT NULL DEFAULT '0',
    `money_in_2k` int(11) NOT NULL DEFAULT '0',
    `money_in_1k` int(11) NOT NULL DEFAULT '0',
    `money_in_total` int(11) NOT NULL DEFAULT '0',
    `coin_in_1k` int(11) NOT NULL DEFAULT '0',
    `coin_in_500` int(11) NOT NULL DEFAULT '0',
    `coin_in_200` int(11) NOT NULL DEFAULT '0',
    `coin_in_100` int(11) NOT NULL DEFAULT '0',
    `coin_in_50` int(11) NOT NULL DEFAULT '0',
    `coin_in_25` int(11) NOT NULL DEFAULT '0',
    `coin_in_total` int(11) NOT NULL DEFAULT '0',
    `total_in` int(11) NOT NULL DEFAULT '0',
    `money_out_100k` int(11) NOT NULL DEFAULT '0',
    `money_out_50k` int(11) NOT NULL DEFAULT '0',
    `money_out_20k` int(11) NOT NULL DEFAULT '0',
    `money_out_10k` int(11) NOT NULL DEFAULT '0',
    `money_out_5k` int(11) NOT NULL DEFAULT '0',
    `money_out_2k` int(11) NOT NULL DEFAULT '0',
    `money_out_1k` int(11) NOT NULL DEFAULT '0',
    `money_out_total` int(11) NOT NULL DEFAULT '0',
    `coin_out_1k` int(11) NOT NULL DEFAULT '0',
    `coin_out_500` int(11) NOT NULL DEFAULT '0',
    `coin_out_200` int(11) NOT NULL DEFAULT '0',
    `coin_out_100` int(11) NOT NULL DEFAULT '0',
    `coin_out_50` int(11) NOT NULL DEFAULT '0',
    `coin_out_25` int(11) NOT NULL DEFAULT '0',
    `coin_out_total` int(11) NOT NULL DEFAULT '0',
    `total_out` int(11) NOT NULL DEFAULT '0',
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(128) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `updated_by` varchar(128) NOT NULL DEFAULT 'System',
    PRIMARY KEY (`shift_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  
  -- Dumping data for table prisma_pos.kar_shift: ~6 rows (approximately)
  DELETE FROM `kar_shift`;
  /*!40000 ALTER TABLE `kar_shift` DISABLE KEYS */;
  INSERT INTO `kar_shift` (`shift_id`, `user_id`, `user_realname`, `shift_in_status`, `shift_out_status`, `shift_in_date`, `shift_in_time`, `shift_out_date`, `shift_out_time`, `money_in_100k`, `money_in_50k`, `money_in_20k`, `money_in_10k`, `money_in_5k`, `money_in_2k`, `money_in_1k`, `money_in_total`, `coin_in_1k`, `coin_in_500`, `coin_in_200`, `coin_in_100`, `coin_in_50`, `coin_in_25`, `coin_in_total`, `total_in`, `money_out_100k`, `money_out_50k`, `money_out_20k`, `money_out_10k`, `money_out_5k`, `money_out_2k`, `money_out_1k`, `money_out_total`, `coin_out_1k`, `coin_out_500`, `coin_out_200`, `coin_out_100`, `coin_out_50`, `coin_out_25`, `coin_out_total`, `total_out`, `created`, `created_by`, `updated`, `updated_by`) VALUES
  	(1, 1, 'Super Retail', 1, 1, '2018-05-28', '10:13:28', '2018-05-28', '10:14:30', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2018-05-28 10:13:28', 'Super Retail', '0000-00-00 00:00:00', 'Super Retail'),
  	(2, 1, 'Super Retail', 1, 1, '2018-05-28', '10:17:11', '2018-05-28', '10:17:17', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2018-05-28 10:17:11', 'Super Retail', '0000-00-00 00:00:00', 'Super Retail'),
  	(3, 1, 'Super Retail', 1, 1, '2018-05-28', '10:19:49', '2018-05-30', '20:57:05', 1, 1, 1, 12, 1, 1, 0, 297000, 5, 5, 51, 1, 1, 1, 17875, 314875, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2018-05-28 10:19:49', 'Super Retail', '0000-00-00 00:00:00', 'Super Retail'),
  	(4, 1, 'Super Karaoke', 1, 1, '2018-05-30', '20:57:07', '2018-06-02', '16:35:50', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2018-05-30 20:57:07', 'Super Retail', '0000-00-00 00:00:00', 'Super Karaoke'),
  	(5, 1, 'Super Karaoke', 1, 1, '2018-06-02', '16:35:54', '2018-06-03', '07:26:35', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2018-06-02 16:35:54', 'Super Karaoke', '0000-00-00 00:00:00', 'Super Karaoke'),
  	(6, 1, 'Super Karaoke', 1, 0, '2018-06-03', '07:26:53', NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2018-06-03 07:26:53', 'Super Karaoke', '0000-00-00 00:00:00', 'System');
  /*!40000 ALTER TABLE `kar_shift` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.kar_tax
  DROP TABLE IF EXISTS `kar_tax`;
  CREATE TABLE IF NOT EXISTS `kar_tax` (
    `tax_id` int(11) NOT NULL AUTO_INCREMENT,
    `tax_code` varchar(15) NOT NULL,
    `tax_name` varchar(128) NOT NULL,
    `tax_ratio` float(10,2) NOT NULL COMMENT 'in percent',
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`tax_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  
  -- Dumping data for table prisma_pos.kar_tax: ~0 rows (approximately)
  DELETE FROM `kar_tax`;
  /*!40000 ALTER TABLE `kar_tax` DISABLE KEYS */;
  INSERT INTO `kar_tax` (`tax_id`, `tax_code`, `tax_name`, `tax_ratio`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	(1, '1.1.1.03.05', 'Pajak Diskotek, Karaoke, dan Klab MalamDiskotek, Karaoke, dan Klab Malam', 15.00, '2018-07-05 14:11:05', 'System', '0000-00-00 00:00:00', 'System', 1, 0);
  /*!40000 ALTER TABLE `kar_tax` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.kar_time
  DROP TABLE IF EXISTS `kar_time`;
  CREATE TABLE IF NOT EXISTS `kar_time` (
    `time_id` int(11) NOT NULL AUTO_INCREMENT,
    `time_name` varchar(128) NOT NULL,
    `time_start` time NOT NULL DEFAULT '00:00:00',
    `time_end` time NOT NULL DEFAULT '00:00:00',
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(128) NOT NULL DEFAULT 'System',
    `updated` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(128) NOT NULL DEFAULT 'System',
    `is_active` tinyint(4) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(4) NOT NULL DEFAULT '0',
    PRIMARY KEY (`time_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.kar_time: ~2 rows (approximately)
  DELETE FROM `kar_time`;
  /*!40000 ALTER TABLE `kar_time` DISABLE KEYS */;
  INSERT INTO `kar_time` (`time_id`, `time_name`, `time_start`, `time_end`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	(1, 'Happy Hours', '08:00:00', '18:00:00', '2018-06-01 21:19:36', 'Super Karaoke', '2018-06-04 08:21:10', 'System', 1, 0),
  	(2, 'Business Hours', '18:01:00', '24:00:00', '2018-06-01 21:22:20', 'Super Karaoke', '2018-06-03 20:43:16', 'System', 1, 0);
  /*!40000 ALTER TABLE `kar_time` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.kar_user
  DROP TABLE IF EXISTS `kar_user`;
  CREATE TABLE IF NOT EXISTS `kar_user` (
    `user_id` int(11) NOT NULL AUTO_INCREMENT,
    `user_name` varchar(32) NOT NULL,
    `role_id` int(11) NOT NULL,
    `user_password` varchar(32) NOT NULL,
    `user_realname` varchar(128) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`user_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.kar_user: ~3 rows (approximately)
  DELETE FROM `kar_user`;
  /*!40000 ALTER TABLE `kar_user` DISABLE KEYS */;
  INSERT INTO `kar_user` (`user_id`, `user_name`, `role_id`, `user_password`, `user_realname`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	(1, 'superkaraoke', 0, '21232f297a57a5a743894a0e4a801fc3', 'Super Karaoke', '2018-04-04 10:45:37', 'System', '2018-05-18 10:32:05', 'System', 1, 0),
  	(2, 'adminkaraoke', 1, '21232f297a57a5a743894a0e4a801fc3', 'Admin Karaoke', '2018-05-08 13:40:40', 'System', '2018-05-18 10:32:10', 'System', 1, 0),
  	(3, 'cashierkaraoke', 3, '21232f297a57a5a743894a0e4a801fc3', 'Cashier Karaoke', '2018-05-08 13:43:54', 'System', '2018-05-18 10:32:16', 'System', 1, 0);
  /*!40000 ALTER TABLE `kar_user` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.par_billing
  DROP TABLE IF EXISTS `par_billing`;
  CREATE TABLE IF NOT EXISTS `par_billing` (
    `billing_id` int(11) NOT NULL AUTO_INCREMENT,
    `receipt_no` varchar(12) NOT NULL DEFAULT '0',
    `user_id_in` int(11) NOT NULL,
    `user_realname_in` varchar(128) NOT NULL,
    `user_id_out` int(11) DEFAULT NULL,
    `user_realname_out` varchar(128) DEFAULT NULL,
    `brand_id` int(11) NOT NULL,
    `brand_name` varchar(128) NOT NULL,
    `category_id` int(11) NOT NULL,
    `category_name` varchar(128) NOT NULL,
    `category_rate` float(10,2) NOT NULL,
    `category_not_flat` tinyint(1) NOT NULL,
    `category_per_hour` float(10,2) NOT NULL,
    `billing_tnkb` varchar(128) NOT NULL,
    `billing_status_in` tinyint(1) NOT NULL,
    `billing_status_out` tinyint(1) NOT NULL,
    `billing_date_in` date NOT NULL,
    `billing_time_in` time NOT NULL,
    `billing_date_out` date NOT NULL,
    `billing_time_out` time NOT NULL,
    `billing_duration` int(11) NOT NULL,
    `billing_subtotal` float(10,2) NOT NULL,
    `billing_tax` float(10,2) NOT NULL,
    `billing_total_grand` float(10,2) NOT NULL,
    `billing_payment` float(10,2) NOT NULL,
    `billing_change` float(10,2) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(128) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(128) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    `posting_st` tinyint(1) NOT NULL DEFAULT '0',
    `posting_date` datetime DEFAULT NULL,
    PRIMARY KEY (`billing_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.par_billing: ~0 rows (approximately)
  DELETE FROM `par_billing`;
  /*!40000 ALTER TABLE `par_billing` DISABLE KEYS */;
  /*!40000 ALTER TABLE `par_billing` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.par_brand
  DROP TABLE IF EXISTS `par_brand`;
  CREATE TABLE IF NOT EXISTS `par_brand` (
    `brand_id` int(11) NOT NULL AUTO_INCREMENT,
    `brand_name` varchar(128) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(128) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `update_by` varchar(128) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`brand_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.par_brand: ~0 rows (approximately)
  DELETE FROM `par_brand`;
  /*!40000 ALTER TABLE `par_brand` DISABLE KEYS */;
  INSERT INTO `par_brand` (`brand_id`, `brand_name`, `created`, `created_by`, `updated`, `update_by`, `is_active`, `is_deleted`) VALUES
  	(0, 'Lainnya\r\n', '2018-05-22 10:20:18', 'System', '2018-07-05 15:42:49', 'System', 1, 0);
  /*!40000 ALTER TABLE `par_brand` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.par_category
  DROP TABLE IF EXISTS `par_category`;
  CREATE TABLE IF NOT EXISTS `par_category` (
    `category_id` int(11) NOT NULL AUTO_INCREMENT,
    `category_name` varchar(128) NOT NULL,
    `category_not_flat` tinyint(1) NOT NULL DEFAULT '0',
    `category_rate` float(10,2) NOT NULL,
    `category_per_hour` float(10,2) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`category_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.par_category: ~0 rows (approximately)
  DELETE FROM `par_category`;
  /*!40000 ALTER TABLE `par_category` DISABLE KEYS */;
  /*!40000 ALTER TABLE `par_category` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.par_client
  DROP TABLE IF EXISTS `par_client`;
  CREATE TABLE IF NOT EXISTS `par_client` (
    `client_id` varchar(32) NOT NULL,
    `client_name` varchar(32) NOT NULL,
    `client_brand` varchar(32) NOT NULL,
    `client_status` varchar(32) NOT NULL,
    `client_street` varchar(128) NOT NULL,
    `client_subdistrict` varchar(32) NOT NULL,
    `client_district` varchar(32) NOT NULL,
    `client_city` varchar(32) NOT NULL,
    `client_province` varchar(32) NOT NULL,
    `client_email` varchar(32) NOT NULL,
    `client_phone_1` varchar(15) NOT NULL,
    `client_phone_2` varchar(15) NOT NULL,
    `client_npwp` varchar(64) NOT NULL,
    `client_npwpd` varchar(64) NOT NULL,
    `client_owner_name` varchar(64) NOT NULL,
    `client_owner_address` text NOT NULL,
    `client_notes` text NOT NULL,
    `client_serial_number` varchar(20) NOT NULL,
    `client_keyboard_status` tinyint(1) NOT NULL DEFAULT '1',
    `client_receipt_is_taxed` tinyint(1) NOT NULL DEFAULT '1',
    `client_logo` varchar(255) DEFAULT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`client_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.par_client: ~0 rows (approximately)
  DELETE FROM `par_client`;
  /*!40000 ALTER TABLE `par_client` DISABLE KEYS */;
  INSERT INTO `par_client` (`client_id`, `client_name`, `client_brand`, `client_status`, `client_street`, `client_subdistrict`, `client_district`, `client_city`, `client_province`, `client_email`, `client_phone_1`, `client_phone_2`, `client_npwp`, `client_npwpd`, `client_owner_name`, `client_owner_address`, `client_notes`, `client_serial_number`, `client_keyboard_status`, `client_receipt_is_taxed`, `client_logo`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	('1', 'CV Prisma Parking', 'Prisma Parking', 'sendiri', 'Jalan Gajahmada 56', 'Warungboto', 'Umbulharjo', 'Yogyakarta', 'Daerah Istimewa Yogyakarta', 'buat@gmail.com', '123', '123', '1234', '1234', 'Sujo', 'jalan manggis\r\n', 'Tidak ada', '1234-1234-1234', 0, 1, NULL, '2018-05-08 10:26:03', 'System', '2018-06-25 09:32:58', 'Super Parking', 1, 0);
  /*!40000 ALTER TABLE `par_client` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.par_log
  DROP TABLE IF EXISTS `par_log`;
  CREATE TABLE IF NOT EXISTS `par_log` (
    `log_id` int(11) NOT NULL AUTO_INCREMENT,
    `user_id` int(11) NOT NULL,
    `user_realname` varchar(128) NOT NULL,
    `log_type` enum('Sign In','Sign Out') NOT NULL,
    `log_date` date NOT NULL,
    `log_time` time NOT NULL,
    PRIMARY KEY (`log_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  
  -- Dumping data for table prisma_pos.par_log: ~0 rows (approximately)
  DELETE FROM `par_log`;
  /*!40000 ALTER TABLE `par_log` DISABLE KEYS */;
  /*!40000 ALTER TABLE `par_log` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.par_module
  DROP TABLE IF EXISTS `par_module`;
  CREATE TABLE IF NOT EXISTS `par_module` (
    `module_id` varchar(15) NOT NULL,
    `module_parent` varchar(15) NOT NULL,
    `module_name` varchar(32) NOT NULL,
    `module_folder` varchar(32) NOT NULL,
    `module_controller` varchar(32) NOT NULL,
    `module_url` varchar(32) NOT NULL,
    `module_icon` varchar(32) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_actived` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`module_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.par_module: ~19 rows (approximately)
  DELETE FROM `par_module`;
  /*!40000 ALTER TABLE `par_module` DISABLE KEYS */;
  INSERT INTO `par_module` (`module_id`, `module_parent`, `module_name`, `module_folder`, `module_controller`, `module_url`, `module_icon`, `created`, `created_by`, `updated`, `updated_by`, `is_actived`, `is_deleted`) VALUES
  	('01', '', 'Dashboard', 'par_dashboard', 'par_dashboard', 'index', 'dashboard', '2018-04-04 10:26:27', 'Super Administrator', '2018-05-17 13:53:19', 'Super Administrator', 1, 0),
  	('02', '', 'Master', '', '', '#', 'cubes', '2018-05-17 14:14:25', 'Super Parking', '2018-05-17 14:34:37', 'Super Parking', 1, 0),
  	('02.01', '02', 'Kategori & Tarif', 'par_category', 'par_category', 'index', '', '2018-05-17 14:39:24', 'Super Parking', '2018-05-22 09:17:28', 'Super Parking', 1, 0),
  	('02.02', '02', 'Merek', 'par_brand', 'par_brand', 'index', 'car', '2018-05-22 10:16:30', 'Super Parking', '2018-05-22 10:20:56', 'Super Parking', 1, 0),
  	('04', '', 'Parkir Masuk', 'par_parking_in', 'par_parking_in', 'index', 'sign-in', '2018-05-22 09:57:57', 'Super Parking', '0000-00-00 00:00:00', 'System', 1, 0),
  	('05', '', 'Parkir Keluar', 'par_parking_out', 'par_parking_out', 'index', 'sign-out', '2018-05-22 14:55:42', 'Super Parking', '2018-05-23 11:46:46', 'Super Parking', 1, 0),
  	('06', '', 'Laporan', '', '', '#', 'files-o', '2018-05-24 15:02:11', 'Super Parking', '2018-05-24 15:16:44', 'Super Parking', 1, 0),
  	('06.01', '06', 'Parkir Masuk', 'par_report_parking_in', 'par_report_parking_in', 'index', 'sign-in', '2018-05-24 15:18:48', 'Super Parking', '0000-00-00 00:00:00', 'System', 1, 0),
  	('06.02', '06', 'Parkir Keluar', 'par_report_parking_out', 'par_report_parking_out', 'index', 'sign-out', '2018-05-25 13:55:34', 'Super Parking', '0000-00-00 00:00:00', 'System', 1, 0),
  	('06.03', '06', 'Pendapatan', 'par_report_income', 'par_report_income', 'index', 'money', '2018-05-25 14:27:28', 'Super Parking', '0000-00-00 00:00:00', 'System', 1, 0),
  	('06.04', '06', 'Pendapatan (Kasir)', 'par_report_income_user', 'par_report_income_user', 'index', 'users', '2018-06-05 09:12:38', 'Super Parking', '2018-06-05 09:13:03', 'System', 1, 0),
  	('06.06', '06', 'Shift', 'par_report_shift', 'par_report_shift', 'index', 'transfer', '2018-05-27 09:18:33', 'Super Parking', '2018-06-08 10:56:05', 'System', 1, 0),
  	('06.07', '06', 'Log Akses', 'par_report_log', 'par_report_log', 'index', 'users', '2018-06-05 08:34:09', 'Super Parking', '2018-06-08 10:56:01', 'System', 1, 0),
  	('99', '', 'Pengaturan', '', '', '#', 'gears', '2018-04-04 09:41:46', 'Super Administrator', '0000-00-00 00:00:00', '', 1, 0),
  	('99.01', '99', 'Modul', 'par_module', 'par_module', 'index', 'window-restore', '2018-04-04 09:44:01', 'Super Administrator', '2018-05-17 13:53:48', 'Super Administrator', 1, 0),
  	('99.02', '99', 'Role', 'par_role', 'par_role', 'index', 'users', '2018-04-04 09:46:50', 'Super Administrator', '2018-05-17 13:53:51', 'Super Administrator', 1, 0),
  	('99.03', '99', 'Pengguna', 'par_user', 'par_user', 'index', '', '2018-04-04 10:37:41', 'Super Administrator', '2018-05-17 13:53:55', 'Super Administrator', 1, 0),
  	('99.04', '99', 'Hak Akses', 'par_permission', 'par_permission', 'index', 'list', '2018-04-05 08:20:56', 'Super Administrator', '2018-05-17 13:53:42', '', 1, 0),
  	('99.05', '99', 'Client', 'par_client', 'par_client', 'index', 'th-large', '2018-04-05 17:31:04', 'Super Administrator', '2018-05-17 13:53:58', 'Super Administrator', 1, 0);
  /*!40000 ALTER TABLE `par_module` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.par_permission
  DROP TABLE IF EXISTS `par_permission`;
  CREATE TABLE IF NOT EXISTS `par_permission` (
    `permission_id` int(11) NOT NULL AUTO_INCREMENT,
    `role_id` int(11) NOT NULL,
    `module_id` varchar(25) NOT NULL,
    `_create` int(1) DEFAULT NULL,
    `_read` int(1) DEFAULT NULL,
    `_update` int(1) DEFAULT NULL,
    `_delete` int(1) DEFAULT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(255) NOT NULL,
    PRIMARY KEY (`permission_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=799 DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.par_permission: ~37 rows (approximately)
  DELETE FROM `par_permission`;
  /*!40000 ALTER TABLE `par_permission` DISABLE KEYS */;
  INSERT INTO `par_permission` (`permission_id`, `role_id`, `module_id`, `_create`, `_read`, `_update`, `_delete`, `created`, `created_by`) VALUES
  	(722, 3, '01', 1, 1, 1, 1, '2018-05-27 10:37:25', 'Super Parking'),
  	(723, 3, '04', 1, 1, 1, 1, '2018-05-27 10:37:25', 'Super Parking'),
  	(726, 1, '01', 1, 1, 1, 1, '2018-05-27 10:41:08', 'Super Parking'),
  	(727, 1, '02', 1, 1, 1, 1, '2018-05-27 10:41:08', 'Super Parking'),
  	(728, 1, '02.01', 1, 1, 1, 1, '2018-05-27 10:41:08', 'Super Parking'),
  	(729, 1, '02.02', 1, 1, 1, 1, '2018-05-27 10:41:08', 'Super Parking'),
  	(730, 1, '06', 1, 1, 1, 1, '2018-05-27 10:41:08', 'Super Parking'),
  	(731, 1, '06.01', 1, 1, 1, 1, '2018-05-27 10:41:08', 'Super Parking'),
  	(732, 1, '06.02', 1, 1, 1, 1, '2018-05-27 10:41:08', 'Super Parking'),
  	(733, 1, '06.03', 1, 1, 1, 1, '2018-05-27 10:41:08', 'Super Parking'),
  	(734, 1, '06.04', 1, 1, 1, 1, '2018-05-27 10:41:08', 'Super Parking'),
  	(735, 1, '99', 1, 1, 1, 1, '2018-05-27 10:41:08', 'Super Parking'),
  	(736, 1, '99.03', 1, 1, 1, 1, '2018-05-27 10:41:08', 'Super Parking'),
  	(737, 1, '99.05', 1, 1, 1, 1, '2018-05-27 10:41:08', 'Super Parking'),
  	(738, 5, '01', 1, 1, 1, 1, '2018-05-27 10:42:50', 'Super Parking'),
  	(739, 5, '05', 1, 1, 1, 1, '2018-05-27 10:42:50', 'Super Parking'),
  	(778, 0, '01', 1, 1, 1, 1, '2018-06-08 10:54:50', 'Super Parking'),
  	(779, 0, '02', 1, 1, 1, 1, '2018-06-08 10:54:50', 'Super Parking'),
  	(780, 0, '02.01', 1, 1, 1, 1, '2018-06-08 10:54:50', 'Super Parking'),
  	(781, 0, '02.02', 1, 1, 1, 1, '2018-06-08 10:54:50', 'Super Parking'),
  	(782, 0, '04', 1, 1, 1, 1, '2018-06-08 10:54:50', 'Super Parking'),
  	(783, 0, '05', 1, 1, 1, 1, '2018-06-08 10:54:50', 'Super Parking'),
  	(784, 0, '06', 1, 1, 1, 1, '2018-06-08 10:54:50', 'Super Parking'),
  	(785, 0, '06.01', 1, 1, 1, 1, '2018-06-08 10:54:50', 'Super Parking'),
  	(786, 0, '06.02', 1, 1, 1, 1, '2018-06-08 10:54:50', 'Super Parking'),
  	(787, 0, '06.03', 1, 1, 1, 1, '2018-06-08 10:54:50', 'Super Parking'),
  	(788, 0, '06.04', 1, 1, 1, 1, '2018-06-08 10:54:50', 'Super Parking'),
  	(789, 0, '06.05', 1, 1, 1, 1, '2018-06-08 10:54:50', 'Super Parking'),
  	(790, 0, '06.06', 1, 1, 1, 1, '2018-06-08 10:54:51', 'Super Parking'),
  	(791, 0, '06.07', 1, 1, 1, 1, '2018-06-08 10:54:51', 'Super Parking'),
  	(792, 0, '99', 1, 1, 1, 1, '2018-06-08 10:54:51', 'Super Parking'),
  	(793, 0, '99.01', 1, 1, 1, 1, '2018-06-08 10:54:51', 'Super Parking'),
  	(794, 0, '99.02', 1, 1, 1, 1, '2018-06-08 10:54:51', 'Super Parking'),
  	(795, 0, '99.03', 1, 1, 1, 1, '2018-06-08 10:54:51', 'Super Parking'),
  	(796, 0, '99.04', 1, 1, 1, 1, '2018-06-08 10:54:51', 'Super Parking'),
  	(797, 0, '99.05', 1, 1, 1, 1, '2018-06-08 10:54:51', 'Super Parking'),
  	(798, 0, '99.06', 1, 1, 1, 1, '2018-06-08 10:54:51', 'Super Parking');
  /*!40000 ALTER TABLE `par_permission` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.par_role
  DROP TABLE IF EXISTS `par_role`;
  CREATE TABLE IF NOT EXISTS `par_role` (
    `role_id` int(11) NOT NULL AUTO_INCREMENT,
    `role_name` varchar(255) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`role_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.par_role: ~4 rows (approximately)
  DELETE FROM `par_role`;
  /*!40000 ALTER TABLE `par_role` DISABLE KEYS */;
  INSERT INTO `par_role` (`role_id`, `role_name`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	(0, 'Super Administrator Parking', '2018-03-30 11:16:36', 'Super Administrator', '2018-05-17 13:50:14', 'Super Administrator', 1, 0),
  	(1, 'Administrator Parking', '2018-03-30 11:18:19', 'Super Administrator', '2018-05-17 13:50:10', 'Super Administrator', 1, 0),
  	(2, 'Cashier Parking In', '2018-05-08 13:42:21', 'Admin Retail', '2018-07-05 15:43:44', 'Super Parking', 1, 0),
  	(3, 'Cashier Parking Out', '2018-05-24 15:03:20', 'Super Parking', '2018-07-05 15:43:47', 'System', 1, 0);
  /*!40000 ALTER TABLE `par_role` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.par_shift
  DROP TABLE IF EXISTS `par_shift`;
  CREATE TABLE IF NOT EXISTS `par_shift` (
    `shift_id` int(11) NOT NULL AUTO_INCREMENT,
    `user_id` int(11) NOT NULL,
    `user_realname` varchar(128) NOT NULL,
    `parking_type` tinyint(1) NOT NULL,
    `shift_in_status` tinyint(1) NOT NULL,
    `shift_out_status` tinyint(1) NOT NULL,
    `shift_in_date` date DEFAULT NULL,
    `shift_in_time` time DEFAULT NULL,
    `shift_out_date` date DEFAULT NULL,
    `shift_out_time` time DEFAULT NULL,
    `money_in_100k` int(11) NOT NULL DEFAULT '0',
    `money_in_50k` int(11) NOT NULL DEFAULT '0',
    `money_in_20k` int(11) NOT NULL DEFAULT '0',
    `money_in_10k` int(11) NOT NULL DEFAULT '0',
    `money_in_5k` int(11) NOT NULL DEFAULT '0',
    `money_in_2k` int(11) NOT NULL DEFAULT '0',
    `money_in_1k` int(11) NOT NULL DEFAULT '0',
    `money_in_total` int(11) NOT NULL DEFAULT '0',
    `coin_in_1k` int(11) NOT NULL DEFAULT '0',
    `coin_in_500` int(11) NOT NULL DEFAULT '0',
    `coin_in_200` int(11) NOT NULL DEFAULT '0',
    `coin_in_100` int(11) NOT NULL DEFAULT '0',
    `coin_in_50` int(11) NOT NULL DEFAULT '0',
    `coin_in_25` int(11) NOT NULL DEFAULT '0',
    `coin_in_total` int(11) NOT NULL DEFAULT '0',
    `total_in` int(11) NOT NULL DEFAULT '0',
    `money_out_100k` int(11) NOT NULL DEFAULT '0',
    `money_out_50k` int(11) NOT NULL DEFAULT '0',
    `money_out_20k` int(11) NOT NULL DEFAULT '0',
    `money_out_10k` int(11) NOT NULL DEFAULT '0',
    `money_out_5k` int(11) NOT NULL DEFAULT '0',
    `money_out_2k` int(11) NOT NULL DEFAULT '0',
    `money_out_1k` int(11) NOT NULL DEFAULT '0',
    `money_out_total` int(11) NOT NULL DEFAULT '0',
    `coin_out_1k` int(11) NOT NULL DEFAULT '0',
    `coin_out_500` int(11) NOT NULL DEFAULT '0',
    `coin_out_200` int(11) NOT NULL DEFAULT '0',
    `coin_out_100` int(11) NOT NULL DEFAULT '0',
    `coin_out_50` int(11) NOT NULL DEFAULT '0',
    `coin_out_25` int(11) NOT NULL DEFAULT '0',
    `coin_out_total` int(11) NOT NULL DEFAULT '0',
    `total_out` int(11) NOT NULL DEFAULT '0',
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(128) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(128) NOT NULL DEFAULT 'System',
    PRIMARY KEY (`shift_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  
  -- Dumping data for table prisma_pos.par_shift: ~0 rows (approximately)
  DELETE FROM `par_shift`;
  /*!40000 ALTER TABLE `par_shift` DISABLE KEYS */;
  /*!40000 ALTER TABLE `par_shift` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.par_tax
  DROP TABLE IF EXISTS `par_tax`;
  CREATE TABLE IF NOT EXISTS `par_tax` (
    `tax_id` int(11) NOT NULL AUTO_INCREMENT,
    `tax_code` varchar(15) NOT NULL,
    `tax_name` varchar(128) NOT NULL,
    `tax_ratio` float(10,2) NOT NULL COMMENT 'in percent',
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`tax_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  
  -- Dumping data for table prisma_pos.par_tax: ~0 rows (approximately)
  DELETE FROM `par_tax`;
  /*!40000 ALTER TABLE `par_tax` DISABLE KEYS */;
  INSERT INTO `par_tax` (`tax_id`, `tax_code`, `tax_name`, `tax_ratio`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	(1, '1.1.1.07.01\r\n', 'Pajak Parkir', 15.00, '2018-07-05 09:49:40', 'System', '0000-00-00 00:00:00', 'System', 1, 0);
  /*!40000 ALTER TABLE `par_tax` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.par_user
  DROP TABLE IF EXISTS `par_user`;
  CREATE TABLE IF NOT EXISTS `par_user` (
    `user_id` int(11) NOT NULL AUTO_INCREMENT,
    `user_name` varchar(32) NOT NULL,
    `role_id` int(11) NOT NULL,
    `user_password` varchar(32) NOT NULL,
    `user_realname` varchar(128) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`user_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.par_user: ~4 rows (approximately)
  DELETE FROM `par_user`;
  /*!40000 ALTER TABLE `par_user` DISABLE KEYS */;
  INSERT INTO `par_user` (`user_id`, `user_name`, `role_id`, `user_password`, `user_realname`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	(1, 'superparking', 0, '21232f297a57a5a743894a0e4a801fc3', 'Super Parking', '2018-04-04 10:45:37', 'System', '2018-05-17 11:39:14', 'System', 1, 0),
  	(2, 'adminparking', 1, '21232f297a57a5a743894a0e4a801fc3', 'Admin Parking', '2018-05-08 13:40:40', 'System', '2018-05-17 11:39:09', 'System', 1, 0),
  	(3, 'cashierparkingin', 2, '21232f297a57a5a743894a0e4a801fc3', 'Cashier Parking In', '2018-05-08 13:43:54', 'System', '2018-07-05 15:44:08', 'Super Parking', 1, 0),
  	(4, 'cashierparkingout', 3, '21232f297a57a5a743894a0e4a801fc3', 'Cashier Parking Out', '2018-05-24 15:04:06', 'Super Parking', '2018-07-05 15:44:18', 'System', 1, 0);
  /*!40000 ALTER TABLE `par_user` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.res_bank
  DROP TABLE IF EXISTS `res_bank`;
  CREATE TABLE IF NOT EXISTS `res_bank` (
    `bank_id` int(11) NOT NULL AUTO_INCREMENT,
    `payment_type_id` int(11) NOT NULL,
    `bank_name` varchar(128) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`bank_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.res_bank: ~0 rows (approximately)
  DELETE FROM `res_bank`;
  /*!40000 ALTER TABLE `res_bank` DISABLE KEYS */;
  /*!40000 ALTER TABLE `res_bank` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.res_billing
  DROP TABLE IF EXISTS `res_billing`;
  CREATE TABLE IF NOT EXISTS `res_billing` (
    `tx_id` int(11) NOT NULL AUTO_INCREMENT,
    `tx_receipt_no` varchar(12) NOT NULL DEFAULT '0',
    `user_id` int(11) NOT NULL,
    `user_realname` varchar(255) NOT NULL,
    `customer_id` int(11) NOT NULL,
    `customer_name` varchar(255) NOT NULL,
    `tx_type` varchar(3) NOT NULL,
    `tx_date` date NOT NULL,
    `tx_time` time NOT NULL,
    `tx_notes` text NOT NULL,
    `payment_type_id` int(11) NOT NULL,
    `tx_payment` float(10,2) NOT NULL,
    `tx_status` int(1) NOT NULL DEFAULT '0',
    `tx_cancel_notes` text,
    `bank_id` int(11) NOT NULL,
    `bank_card_no` varchar(32) NOT NULL,
    `bank_reference_no` varchar(32) NOT NULL,
    `tx_total_buy_average` float(10,2) NOT NULL,
    `tx_total_tax` float(10,2) NOT NULL,
    `tx_total_discount` float(10,2) NOT NULL,
    `tx_total_before_tax` float(10,2) NOT NULL,
    `tx_total_after_tax` float(10,2) NOT NULL,
    `tx_total_grand` float(10,2) NOT NULL,
    `tx_change` float(10,2) NOT NULL,
    `tx_total_profit_before_tax` float(10,2) NOT NULL,
    `tx_total_profit_after_tax` float(10,2) NOT NULL,
    `created` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    `posting_st` tinyint(1) NOT NULL DEFAULT '0',
    `posting_date` datetime DEFAULT NULL,
    PRIMARY KEY (`tx_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.res_billing: ~2 rows (approximately)
  DELETE FROM `res_billing`;
  /*!40000 ALTER TABLE `res_billing` DISABLE KEYS */;
  INSERT INTO `res_billing` (`tx_id`, `tx_receipt_no`, `user_id`, `user_realname`, `customer_id`, `customer_name`, `tx_type`, `tx_date`, `tx_time`, `tx_notes`, `payment_type_id`, `tx_payment`, `tx_status`, `tx_cancel_notes`, `bank_id`, `bank_card_no`, `bank_reference_no`, `tx_total_buy_average`, `tx_total_tax`, `tx_total_discount`, `tx_total_before_tax`, `tx_total_after_tax`, `tx_total_grand`, `tx_change`, `tx_total_profit_before_tax`, `tx_total_profit_after_tax`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`, `posting_st`, `posting_date`) VALUES
  	(1, '180824000001', 1, 'Super Restaurant', 1, 'Umum', 'TXS', '2018-08-24', '10:20:00', '', 0, 0.00, -1, NULL, 0, '', '', 0.00, 12000.00, 13200.00, 120000.00, 132000.00, 118800.00, 0.00, 106800.00, 94800.00, '2018-08-24 10:20:07', 'Super Restaurant', '2018-08-24 10:27:45', 'System', 1, 0, 0, NULL),
  	(2, '180824000002', 1, 'Super Restaurant', 1, 'Umum', 'TXS', '2018-08-24', '10:35:52', '', 0, 0.00, 0, NULL, 0, '', '', 0.00, 8000.00, 0.00, 80000.00, 88000.00, 88000.00, 0.00, 80000.00, 72000.00, '2018-08-24 10:35:58', 'Super Restaurant', '0000-00-00 00:00:00', 'System', 1, 0, 0, NULL);
  /*!40000 ALTER TABLE `res_billing` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.res_billing_buyall
  DROP TABLE IF EXISTS `res_billing_buyall`;
  CREATE TABLE IF NOT EXISTS `res_billing_buyall` (
    `billing_buyall_id` int(11) NOT NULL AUTO_INCREMENT,
    `tx_id` int(11) NOT NULL,
    `tx_type` varchar(3) NOT NULL,
    `promo_buyall_id` int(11) NOT NULL,
    `buy_amount` float(10,2) NOT NULL,
    `get_discount` int(11) NOT NULL,
    `get_discount_amount` float(10,2) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(128) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(128) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL,
    `is_deleted` tinyint(1) NOT NULL,
    PRIMARY KEY (`billing_buyall_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.res_billing_buyall: ~2 rows (approximately)
  DELETE FROM `res_billing_buyall`;
  /*!40000 ALTER TABLE `res_billing_buyall` DISABLE KEYS */;
  INSERT INTO `res_billing_buyall` (`billing_buyall_id`, `tx_id`, `tx_type`, `promo_buyall_id`, `buy_amount`, `get_discount`, `get_discount_amount`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	(1, 0, 'PRA', 1, 6.00, 10, 0.00, '2018-08-24 10:19:28', 'System', '0000-00-00 00:00:00', 'System', 0, 0),
  	(2, 1, 'PRA', 1, 6.00, 10, 0.00, '2018-08-24 10:20:07', 'System', '0000-00-00 00:00:00', 'System', 0, 0);
  /*!40000 ALTER TABLE `res_billing_buyall` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.res_billing_buyget
  DROP TABLE IF EXISTS `res_billing_buyget`;
  CREATE TABLE IF NOT EXISTS `res_billing_buyget` (
    `billing_buyget_id` int(11) NOT NULL AUTO_INCREMENT,
    `tx_id` int(11) NOT NULL,
    `tx_type` varchar(3) NOT NULL,
    `promo_buyget_id` int(11) NOT NULL,
    `buy_item_id` int(11) NOT NULL,
    `buy_amount` float(10,2) NOT NULL,
    `get_item_id` int(11) NOT NULL,
    `get_amount` float(10,2) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(128) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(128) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL,
    `is_deleted` tinyint(1) NOT NULL,
    PRIMARY KEY (`billing_buyget_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.res_billing_buyget: ~0 rows (approximately)
  DELETE FROM `res_billing_buyget`;
  /*!40000 ALTER TABLE `res_billing_buyget` DISABLE KEYS */;
  /*!40000 ALTER TABLE `res_billing_buyget` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.res_billing_buyitem
  DROP TABLE IF EXISTS `res_billing_buyitem`;
  CREATE TABLE IF NOT EXISTS `res_billing_buyitem` (
    `billing_buyitem_id` int(11) NOT NULL AUTO_INCREMENT,
    `tx_id` int(11) NOT NULL,
    `tx_type` varchar(3) NOT NULL,
    `promo_buyitem_id` int(11) NOT NULL,
    `buy_item_id` int(11) NOT NULL,
    `buy_amount` float(10,2) NOT NULL,
    `get_discount` int(11) NOT NULL,
    `get_discount_amount` float(10,2) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(128) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(128) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL,
    `is_deleted` tinyint(1) NOT NULL,
    PRIMARY KEY (`billing_buyitem_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.res_billing_buyitem: ~0 rows (approximately)
  DELETE FROM `res_billing_buyitem`;
  /*!40000 ALTER TABLE `res_billing_buyitem` DISABLE KEYS */;
  /*!40000 ALTER TABLE `res_billing_buyitem` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.res_billing_detail
  DROP TABLE IF EXISTS `res_billing_detail`;
  CREATE TABLE IF NOT EXISTS `res_billing_detail` (
    `billing_detail_id` int(11) NOT NULL AUTO_INCREMENT,
    `tx_id` int(11) NOT NULL,
    `tx_type` varchar(3) NOT NULL,
    `item_id` int(11) NOT NULL,
    `item_name` varchar(128) NOT NULL,
    `item_price_before_tax` float(10,2) NOT NULL,
    `item_price_after_tax` float(10,2) NOT NULL,
    `item_price_buy_average` float(10,2) NOT NULL,
    `tx_amount` float NOT NULL,
    `tx_subtotal_tax` float(10,2) NOT NULL,
    `tx_subtotal_discount` float(10,2) NOT NULL,
    `tx_subtotal_buy_average` float(10,2) NOT NULL,
    `tx_subtotal_before_tax` float(10,2) NOT NULL,
    `tx_subtotal_after_tax` float(10,2) NOT NULL,
    `tx_subtotal_profit_before_tax` float(10,2) NOT NULL,
    `tx_subtotal_profit_after_tax` float(10,2) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(128) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `updated_by` varchar(128) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`billing_detail_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  
  -- Dumping data for table prisma_pos.res_billing_detail: ~3 rows (approximately)
  DELETE FROM `res_billing_detail`;
  /*!40000 ALTER TABLE `res_billing_detail` DISABLE KEYS */;
  INSERT INTO `res_billing_detail` (`billing_detail_id`, `tx_id`, `tx_type`, `item_id`, `item_name`, `item_price_before_tax`, `item_price_after_tax`, `item_price_buy_average`, `tx_amount`, `tx_subtotal_tax`, `tx_subtotal_discount`, `tx_subtotal_buy_average`, `tx_subtotal_before_tax`, `tx_subtotal_after_tax`, `tx_subtotal_profit_before_tax`, `tx_subtotal_profit_after_tax`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	(1, 0, 'TXS', 1, 'Ayam Bakar', 20000.00, 22000.00, 0.00, 6, 12000.00, 0.00, 0.00, 120000.00, 132000.00, 120000.00, 108000.00, '2018-08-24 10:19:28', 'System', '0000-00-00 00:00:00', 'System', 1, 0),
  	(2, 1, 'TXS', 1, 'Ayam Bakar', 20000.00, 22000.00, 0.00, 6, 12000.00, 0.00, 0.00, 120000.00, 132000.00, 120000.00, 108000.00, '2018-08-24 10:20:07', 'System', '0000-00-00 00:00:00', 'System', 1, 0),
  	(3, 2, 'TXS', 1, 'Ayam Bakar', 20000.00, 22000.00, 0.00, 4, 8000.00, 0.00, 0.00, 80000.00, 88000.00, 80000.00, 72000.00, '2018-08-24 10:35:58', 'System', '0000-00-00 00:00:00', 'System', 1, 0);
  /*!40000 ALTER TABLE `res_billing_detail` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.res_category
  DROP TABLE IF EXISTS `res_category`;
  CREATE TABLE IF NOT EXISTS `res_category` (
    `category_id` int(11) NOT NULL AUTO_INCREMENT,
    `category_name` varchar(128) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`category_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.res_category: ~0 rows (approximately)
  DELETE FROM `res_category`;
  /*!40000 ALTER TABLE `res_category` DISABLE KEYS */;
  INSERT INTO `res_category` (`category_id`, `category_name`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	(0, 'Tidak Terkategori', '2018-05-08 13:26:31', 'System', '2018-05-08 13:26:44', 'System', 1, 0);
  /*!40000 ALTER TABLE `res_category` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.res_client
  DROP TABLE IF EXISTS `res_client`;
  CREATE TABLE IF NOT EXISTS `res_client` (
    `client_id` varchar(32) NOT NULL,
    `client_name` varchar(32) NOT NULL,
    `client_brand` varchar(32) NOT NULL,
    `client_status` varchar(32) NOT NULL,
    `client_street` varchar(128) NOT NULL,
    `client_subdistrict` varchar(32) NOT NULL,
    `client_district` varchar(32) NOT NULL,
    `client_city` varchar(32) NOT NULL,
    `client_province` varchar(32) NOT NULL,
    `client_email` varchar(32) NOT NULL,
    `client_phone_1` varchar(15) NOT NULL,
    `client_phone_2` varchar(15) NOT NULL,
    `client_npwp` varchar(64) NOT NULL,
    `client_npwpd` varchar(64) NOT NULL,
    `client_owner_name` varchar(64) NOT NULL,
    `client_owner_address` text NOT NULL,
    `client_notes` text NOT NULL,
    `client_serial_number` varchar(20) NOT NULL,
    `client_keyboard_status` tinyint(1) NOT NULL DEFAULT '1',
    `client_receipt_is_taxed` tinyint(1) NOT NULL DEFAULT '1',
    `client_logo` varchar(255) DEFAULT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`client_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.res_client: ~0 rows (approximately)
  DELETE FROM `res_client`;
  /*!40000 ALTER TABLE `res_client` DISABLE KEYS */;
  INSERT INTO `res_client` (`client_id`, `client_name`, `client_brand`, `client_status`, `client_street`, `client_subdistrict`, `client_district`, `client_city`, `client_province`, `client_email`, `client_phone_1`, `client_phone_2`, `client_npwp`, `client_npwpd`, `client_owner_name`, `client_owner_address`, `client_notes`, `client_serial_number`, `client_keyboard_status`, `client_receipt_is_taxed`, `client_logo`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	('1', 'CV Prisma Restaurant', 'Prisma Restaurant', 'sendiri', 'Jalan Gajahmada 56', 'Warungboto', 'Umbulharjo', 'Yogyakarta', 'Daerah Istimewa Yogyakarta', 'buat@gmail.com', '123', '123', '1234', '1234', 'Sujo', 'jalan manggis\r\n', 'Tidak ada', '1234-1234-1234', 0, 1, NULL, '2018-05-08 10:26:03', 'System', '2018-06-25 09:32:58', 'Super Restaurant', 1, 0);
  /*!40000 ALTER TABLE `res_client` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.res_customer
  DROP TABLE IF EXISTS `res_customer`;
  CREATE TABLE IF NOT EXISTS `res_customer` (
    `customer_id` int(11) NOT NULL AUTO_INCREMENT,
    `customer_name` varchar(255) NOT NULL,
    `customer_phone` varchar(20) NOT NULL,
    `customer_fax` varchar(20) NOT NULL,
    `customer_email` varchar(255) NOT NULL,
    `customer_address` text NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(255) NOT NULL,
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(255) NOT NULL,
    `is_active` int(1) NOT NULL DEFAULT '1',
    `is_deleted` int(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`customer_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.res_customer: ~1 rows (approximately)
  DELETE FROM `res_customer`;
  /*!40000 ALTER TABLE `res_customer` DISABLE KEYS */;
  INSERT INTO `res_customer` (`customer_id`, `customer_name`, `customer_phone`, `customer_fax`, `customer_email`, `customer_address`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	(1, 'Umum', '123', '', '', '', '2018-08-24 10:19:57', 'Super Restaurant', '0000-00-00 00:00:00', '', 1, 0);
  /*!40000 ALTER TABLE `res_customer` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.res_item
  DROP TABLE IF EXISTS `res_item`;
  CREATE TABLE IF NOT EXISTS `res_item` (
    `item_id` int(11) NOT NULL AUTO_INCREMENT,
    `category_id` int(11) NOT NULL,
    `unit_id` int(11) NOT NULL,
    `tax_id` int(11) NOT NULL,
    `item_name` varchar(255) NOT NULL,
    `item_barcode` varchar(255) NOT NULL,
    `item_desc` text NOT NULL,
    `item_price_before_tax` float(10,2) NOT NULL,
    `item_tax` float(10,2) NOT NULL,
    `item_price_after_tax` float(10,2) NOT NULL,
    `is_package` tinyint(1) NOT NULL DEFAULT '0',
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(255) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(255) NOT NULL DEFAULT 'System',
    `is_active` int(1) NOT NULL DEFAULT '1',
    `is_deleted` int(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`item_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.res_item: ~1 rows (approximately)
  DELETE FROM `res_item`;
  /*!40000 ALTER TABLE `res_item` DISABLE KEYS */;
  INSERT INTO `res_item` (`item_id`, `category_id`, `unit_id`, `tax_id`, `item_name`, `item_barcode`, `item_desc`, `item_price_before_tax`, `item_tax`, `item_price_after_tax`, `is_package`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	(1, 0, 0, 1, 'Ayam Bakar', '', '', 20000.00, 2000.00, 22000.00, 0, '2018-08-24 10:19:17', 'Super Restaurant', '0000-00-00 00:00:00', 'System', 1, 0);
  /*!40000 ALTER TABLE `res_item` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.res_item_package
  DROP TABLE IF EXISTS `res_item_package`;
  CREATE TABLE IF NOT EXISTS `res_item_package` (
    `item_package_id` int(11) NOT NULL AUTO_INCREMENT,
    `item_id` int(11) NOT NULL,
    `item_detail_id` int(11) NOT NULL,
    `item_detail_price` float(10,2) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(128) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(128) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`item_package_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.res_item_package: ~0 rows (approximately)
  DELETE FROM `res_item_package`;
  /*!40000 ALTER TABLE `res_item_package` DISABLE KEYS */;
  /*!40000 ALTER TABLE `res_item_package` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.res_location
  DROP TABLE IF EXISTS `res_location`;
  CREATE TABLE IF NOT EXISTS `res_location` (
    `location_id` int(11) NOT NULL AUTO_INCREMENT,
    `location_name` varchar(128) NOT NULL,
    `location_code` varchar(128) NOT NULL,
    `is_available` tinyint(1) NOT NULL DEFAULT '1',
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(128) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(128) NOT NULL,
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`location_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.res_location: ~0 rows (approximately)
  DELETE FROM `res_location`;
  /*!40000 ALTER TABLE `res_location` DISABLE KEYS */;
  /*!40000 ALTER TABLE `res_location` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.res_log
  DROP TABLE IF EXISTS `res_log`;
  CREATE TABLE IF NOT EXISTS `res_log` (
    `log_id` int(11) NOT NULL AUTO_INCREMENT,
    `user_id` int(11) NOT NULL,
    `user_realname` varchar(128) NOT NULL,
    `log_type` enum('Sign In','Sign Out') NOT NULL,
    `log_date` date NOT NULL,
    `log_time` time NOT NULL,
    PRIMARY KEY (`log_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  
  -- Dumping data for table prisma_pos.res_log: ~3 rows (approximately)
  DELETE FROM `res_log`;
  /*!40000 ALTER TABLE `res_log` DISABLE KEYS */;
  INSERT INTO `res_log` (`log_id`, `user_id`, `user_realname`, `log_type`, `log_date`, `log_time`) VALUES
  	(1, 1, 'Super Restaurant', 'Sign In', '2018-08-23', '09:24:58'),
  	(2, 1, 'Super Restaurant', 'Sign Out', '2018-08-23', '09:55:53'),
  	(3, 1, 'Super Restaurant', 'Sign In', '2018-08-24', '10:18:00');
  /*!40000 ALTER TABLE `res_log` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.res_module
  DROP TABLE IF EXISTS `res_module`;
  CREATE TABLE IF NOT EXISTS `res_module` (
    `module_id` varchar(15) NOT NULL,
    `module_parent` varchar(15) NOT NULL,
    `module_name` varchar(32) NOT NULL,
    `module_folder` varchar(32) NOT NULL,
    `module_controller` varchar(32) NOT NULL,
    `module_url` varchar(32) NOT NULL,
    `module_icon` varchar(32) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_actived` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`module_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.res_module: ~38 rows (approximately)
  DELETE FROM `res_module`;
  /*!40000 ALTER TABLE `res_module` DISABLE KEYS */;
  INSERT INTO `res_module` (`module_id`, `module_parent`, `module_name`, `module_folder`, `module_controller`, `module_url`, `module_icon`, `created`, `created_by`, `updated`, `updated_by`, `is_actived`, `is_deleted`) VALUES
  	('01', '', 'Dashboard', 'res_dashboard', 'res_dashboard', 'index', 'dashboard', '2018-04-04 10:26:27', 'Super Administrator', '2018-04-19 10:40:13', 'Super Administrator', 1, 0),
  	('02', '', 'Master', '', '', '#', 'cubes', '2018-04-05 19:44:13', 'superadmin', '2018-04-05 19:45:13', 'superadmin', 1, 0),
  	('02.01', '02', 'Kategori', 'res_category', 'res_category', 'index', 'paperclip', '2018-04-05 19:47:02', 'superadmin', '2018-04-05 21:22:37', 'Super Administrator', 1, 0),
  	('02.02', '02', 'Satuan', 'res_unit', 'res_unit', 'index', 'dot-circle-o', '2018-04-05 22:14:53', 'Super Administrator', '0000-00-00 00:00:00', '', 1, 0),
  	('02.03', '02', 'Item', 'res_item', 'res_item', 'index', 'list', '2018-04-07 15:49:43', 'Super Administrator', '0000-00-00 00:00:00', '', 1, 0),
  	('02.04', '02', 'Suplier', 'res_supplier', 'res_supplier', 'index', 'truck', '2018-04-09 18:13:11', 'Super Administrator', '2018-04-09 18:53:55', 'Super Administrator', 1, 0),
  	('02.05', '02', 'Pelanggan', 'res_customer', 'res_customer', 'index', 'users', '2018-04-10 08:56:24', 'Super Administrator', '0000-00-00 00:00:00', '', 1, 0),
  	('02.06', '02', 'Bank', 'res_bank', 'res_bank', 'index', 'bank', '2018-04-18 08:38:55', 'Super Administrator', '0000-00-00 00:00:00', '', 1, 0),
  	('02.07', '02', 'Pajak', 'res_tax', 'res_tax', 'index', 'chain', '2018-04-19 19:48:06', 'Super Administrator', '0000-00-00 00:00:00', 'System', 1, 0),
  	('02.08', '02', 'Promo', 'res_promo', 'res_promo', 'index', 'ticket', '2018-04-20 09:21:42', 'Super Administrator', '0000-00-00 00:00:00', 'System', 1, 0),
  	('03', '', 'Transaksi', '', '', '#', 'exchange', '2018-04-17 10:05:10', 'Super Administrator', '2018-06-07 11:17:10', 'Super Restaurant', 1, 0),
  	('03.01', '03', 'Kasir', 'res_cashier', 'res_cashier', 'index', 'laptop', '2018-06-07 11:17:32', 'Super Restaurant', '0000-00-00 00:00:00', 'System', 1, 0),
  	('03.02', '03', 'Retur', 'res_return', 'res_return', 'index', 'undo', '2018-06-07 11:19:02', 'Super Restaurant', '0000-00-00 00:00:00', 'System', 1, 0),
  	('03.03', '03', 'Void', 'res_void', 'res_void', 'index', 'ban', '2018-06-07 14:17:41', 'Super Restaurant', '0000-00-00 00:00:00', 'System', 1, 0),
  	('04', '', 'Inventori', '', '', '#', 'archive', '2018-04-10 10:37:46', 'Super Administrator', '2018-06-08 12:26:52', 'Super Restaurant', 1, 0),
  	('04.01', '04', 'Stok Masuk', 'res_stock_in', 'res_stock_in', 'index', 'sign-in', '2018-04-10 10:54:00', 'Super Administrator', '0000-00-00 00:00:00', '', 1, 0),
  	('04.02', '04', 'Stok Keluar', 'res_stock_out', 'res_stock_out', 'index', 'sign-out', '2018-04-11 10:48:29', 'Super Administrator', '0000-00-00 00:00:00', '', 1, 0),
  	('04.03', '04', 'Stok Opname', 'res_stock_opname', 'res_stock_opname', 'index', 'exchange', '2018-04-11 13:54:55', 'Super Administrator', '2018-04-11 14:01:18', 'Super Administrator', 1, 0),
  	('04.04', '04', 'Rekap Stok', 'res_stock_recap', 'res_stock_recap', 'index', 'files-o', '2018-04-11 14:11:28', 'Super Administrator', '0000-00-00 00:00:00', '', 1, 0),
  	('04.05', '04', 'Purchace Order', 'res_po', 'res_po', 'index', 'file-text', '2018-04-12 12:36:57', 'Super Administrator', '0000-00-00 00:00:00', '', 1, 0),
  	('05', '', 'Laporan', '', '', '#', 'files-o', '2018-05-04 09:10:39', 'Super Administrator', '2018-05-28 10:30:22', 'Super Restaurant', 1, 0),
  	('05.01', '05', 'Penjualan (Semua)', 'res_report_selling', 'res_report_selling', 'index', 'money', '2018-05-28 10:32:42', 'Super Restaurant', '2018-05-28 10:53:56', 'Super Restaurant', 1, 0),
  	('05.02', '05', 'Penjualan (Pelanggan)', 'res_report_selling_customer', 'res_report_selling_customer', 'index', 'users', '2018-05-28 10:52:44', 'Super Restaurant', '2018-05-28 10:53:42', 'Super Restaurant', 1, 0),
  	('05.03', '05', 'Penjualan (Kategori)', 'res_report_selling_category', 'res_report_selling_category', 'index', 'cubes', '2018-05-28 11:41:33', 'Super Restaurant', '2018-05-28 14:18:04', 'Super Restaurant', 1, 0),
  	('05.04', '05', 'Penjualan (Kasir)', 'res_report_selling_user', 'res_report_selling_user', 'index', 'laptop', '2018-06-04 09:06:23', 'Super Restaurant', '2018-06-04 09:18:32', 'Super Restaurant', 1, 0),
  	('05.05', '05', 'Penjualan (Item)', 'res_report_selling_item', 'res_report_selling_item', 'index', 'cube', '2018-05-28 14:17:59', 'Super Restaurant', '2018-06-04 09:08:45', 'System', 1, 0),
  	('05.06', '05', 'Omzet (Semua)', 'res_report_profit', 'res_report_profit', 'index', 'bar-chart', '2018-05-28 14:58:02', 'Super Restaurant', '2018-06-04 09:08:40', 'Super Restaurant', 1, 0),
  	('05.07', '05', 'Omzet (Kasir)', 'res_report_profit_cashier', 'res_report_profit_cashier', 'index', 'laptop', '2018-05-28 15:33:42', 'Super Restaurant', '2018-06-08 10:20:55', 'Super Restaurant', 1, 0),
  	('05.08', '05', 'Piutang', 'res_report_credit', 'res_report_credit', 'index', 'credit-card', '2018-06-08 09:51:51', 'Super Restaurant', '2018-06-08 10:20:49', 'Super Restaurant', 1, 0),
  	('05.09', '05', 'Stok Barang', 'res_report_stock', 'res_report_stock', 'index', 'archive', '2018-05-29 21:31:00', 'Super Restaurant', '2018-06-08 09:52:48', 'System', 1, 0),
  	('05.10', '05', 'Shift', 'res_report_shift', 'res_report_shift', 'index', 'transfer', '2018-05-29 21:58:13', 'Super Restaurant', '2018-06-08 09:52:41', 'System', 1, 0),
  	('05.11', '05', 'Log Akses', 'res_report_log', 'res_report_log', 'index', 'files-o', '2018-06-04 14:33:00', 'Super Restaurant', '2018-06-08 09:52:36', 'Super Restaurant', 1, 0),
  	('99', '', 'Pengaturan', '', '', '#', 'gears', '2018-04-04 09:41:46', 'Super Administrator', '0000-00-00 00:00:00', '', 1, 0),
  	('99.01', '99', 'Modul', 'res_module', 'res_module', 'index', 'window-restore', '2018-04-04 09:44:01', 'Super Administrator', '2018-04-19 10:40:32', 'Super Administrator', 1, 0),
  	('99.02', '99', 'Role', 'res_role', 'res_role', 'index', 'users', '2018-04-04 09:46:50', 'Super Administrator', '2018-04-19 10:40:40', 'Super Administrator', 1, 0),
  	('99.03', '99', 'Pengguna', 'res_user', 'res_user', 'index', '', '2018-04-04 10:37:41', 'Super Administrator', '2018-04-19 10:40:49', 'Super Administrator', 1, 0),
  	('99.04', '99', 'Hak Akses', 'res_permission', 'res_permission', 'index', 'list', '2018-04-05 08:20:56', 'Super Administrator', '2018-04-19 10:40:56', '', 1, 0),
  	('99.05', '99', 'Client', 'res_client', 'res_client', 'index', 'th-large', '2018-04-05 17:31:04', 'Super Administrator', '2018-04-20 08:15:47', 'Super Administrator', 1, 0);
  /*!40000 ALTER TABLE `res_module` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.res_payment_type
  DROP TABLE IF EXISTS `res_payment_type`;
  CREATE TABLE IF NOT EXISTS `res_payment_type` (
    `payment_type_id` int(11) NOT NULL AUTO_INCREMENT,
    `payment_type_name` varchar(32) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`payment_type_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.res_payment_type: ~3 rows (approximately)
  DELETE FROM `res_payment_type`;
  /*!40000 ALTER TABLE `res_payment_type` DISABLE KEYS */;
  INSERT INTO `res_payment_type` (`payment_type_id`, `payment_type_name`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	(1, 'Cash', '2018-04-19 19:34:04', 'System', '0000-00-00 00:00:00', 'System', 1, 0),
  	(2, 'Debit Card', '2018-04-19 19:34:04', 'System', '0000-00-00 00:00:00', 'System', 1, 0),
  	(3, 'Credit Card', '2018-04-19 19:34:12', 'System', '0000-00-00 00:00:00', 'System', 1, 0);
  /*!40000 ALTER TABLE `res_payment_type` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.res_permission
  DROP TABLE IF EXISTS `res_permission`;
  CREATE TABLE IF NOT EXISTS `res_permission` (
    `permission_id` int(11) NOT NULL AUTO_INCREMENT,
    `role_id` int(11) NOT NULL,
    `module_id` varchar(25) NOT NULL,
    `_create` int(1) DEFAULT NULL,
    `_read` int(1) DEFAULT NULL,
    `_update` int(1) DEFAULT NULL,
    `_delete` int(1) DEFAULT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(255) NOT NULL,
    PRIMARY KEY (`permission_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=81 DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.res_permission: ~80 rows (approximately)
  DELETE FROM `res_permission`;
  /*!40000 ALTER TABLE `res_permission` DISABLE KEYS */;
  INSERT INTO `res_permission` (`permission_id`, `role_id`, `module_id`, `_create`, `_read`, `_update`, `_delete`, `created`, `created_by`) VALUES
  	(1, 0, '01', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(2, 0, '02', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(3, 0, '02.01', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(4, 0, '02.02', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(5, 0, '02.03', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(6, 0, '02.04', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(7, 0, '02.05', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(8, 0, '02.06', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(9, 0, '02.07', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(10, 0, '02.08', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(11, 0, '03', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(12, 0, '03.01', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(13, 0, '03.02', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(14, 0, '03.03', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(15, 0, '04', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(16, 0, '04.01', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(17, 0, '04.02', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(18, 0, '04.03', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(19, 0, '04.04', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(20, 0, '04.05', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(21, 0, '05', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(22, 0, '05.01', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(23, 0, '05.02', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(24, 0, '05.03', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(25, 0, '05.04', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(26, 0, '05.05', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(27, 0, '05.06', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(28, 0, '05.07', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(29, 0, '05.08', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(30, 0, '05.09', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(31, 0, '05.10', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(32, 0, '05.11', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(33, 0, '99', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(34, 0, '99.01', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(35, 0, '99.02', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(36, 0, '99.03', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(37, 0, '99.04', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(38, 0, '99.05', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(39, 0, '99.06', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(40, 1, '01', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(41, 1, '02', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(42, 1, '02.01', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(43, 1, '02.02', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(44, 1, '02.03', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(45, 1, '02.04', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(46, 1, '02.05', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(47, 1, '02.06', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(48, 1, '02.08', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(49, 1, '03', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(50, 1, '03.01', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(51, 1, '03.02', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(52, 1, '03.03', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(53, 1, '04', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(54, 1, '04.01', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(55, 1, '04.02', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(56, 1, '04.03', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(57, 1, '04.04', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(58, 1, '04.05', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(59, 1, '05', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(60, 1, '05.01', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(61, 1, '05.02', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(62, 1, '05.03', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(63, 1, '05.04', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(64, 1, '05.05', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(65, 1, '05.06', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(66, 1, '05.07', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(67, 1, '05.08', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(68, 1, '05.09', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(69, 1, '05.10', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(70, 1, '05.11', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(71, 1, '99', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(72, 1, '99.03', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(73, 1, '99.05', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(74, 2, '01', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(75, 2, '03', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(76, 2, '03.01', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(77, 2, '03.02', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(78, 2, '03.03', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(79, 2, '05', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System'),
  	(80, 2, '05.04', 1, 1, 1, 1, '2018-08-18 09:34:34', 'System');
  /*!40000 ALTER TABLE `res_permission` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.res_po
  DROP TABLE IF EXISTS `res_po`;
  CREATE TABLE IF NOT EXISTS `res_po` (
    `tx_id` int(11) NOT NULL AUTO_INCREMENT,
    `tx_receipt_no` varchar(12) NOT NULL,
    `supplier_id` int(11) NOT NULL,
    `tx_type` varchar(3) NOT NULL,
    `tx_date` date NOT NULL,
    `tx_po_no` varchar(255) NOT NULL,
    `tx_po_receiver` varchar(255) NOT NULL,
    `tx_notes` text NOT NULL,
    `tx_status` int(1) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(255) NOT NULL DEFAULT 'System',
    PRIMARY KEY (`tx_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.res_po: ~0 rows (approximately)
  DELETE FROM `res_po`;
  /*!40000 ALTER TABLE `res_po` DISABLE KEYS */;
  /*!40000 ALTER TABLE `res_po` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.res_po_detail
  DROP TABLE IF EXISTS `res_po_detail`;
  CREATE TABLE IF NOT EXISTS `res_po_detail` (
    `stock_id` int(11) NOT NULL AUTO_INCREMENT,
    `tx_id` int(11) NOT NULL,
    `tx_type` varchar(3) NOT NULL,
    `tx_date` date NOT NULL,
    `item_id` int(11) NOT NULL,
    `stock_demand` float(10,2) NOT NULL,
    `stock_receive` float(10,2) NOT NULL,
    `stock_price` float(10,2) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(255) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(255) NOT NULL,
    PRIMARY KEY (`stock_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.res_po_detail: ~0 rows (approximately)
  DELETE FROM `res_po_detail`;
  /*!40000 ALTER TABLE `res_po_detail` DISABLE KEYS */;
  /*!40000 ALTER TABLE `res_po_detail` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.res_promo
  DROP TABLE IF EXISTS `res_promo`;
  CREATE TABLE IF NOT EXISTS `res_promo` (
    `promo_id` int(11) NOT NULL AUTO_INCREMENT,
    `promo_type_id` int(1) NOT NULL,
    `promo_name` varchar(255) NOT NULL,
    `promo_date_start` date NOT NULL,
    `promo_date_end` date NOT NULL,
    `promo_time_start` time NOT NULL,
    `promo_time_end` time NOT NULL,
    `promo_sunday` tinyint(1) NOT NULL DEFAULT '0',
    `promo_monday` tinyint(1) NOT NULL DEFAULT '0',
    `promo_tuesday` tinyint(1) NOT NULL DEFAULT '0',
    `promo_wednesday` tinyint(1) NOT NULL DEFAULT '0',
    `promo_thursday` tinyint(1) NOT NULL DEFAULT '0',
    `promo_friday` tinyint(1) NOT NULL DEFAULT '0',
    `promo_saturday` tinyint(1) NOT NULL DEFAULT '0',
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(128) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(128) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`promo_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.res_promo: ~1 rows (approximately)
  DELETE FROM `res_promo`;
  /*!40000 ALTER TABLE `res_promo` DISABLE KEYS */;
  INSERT INTO `res_promo` (`promo_id`, `promo_type_id`, `promo_name`, `promo_date_start`, `promo_date_end`, `promo_time_start`, `promo_time_end`, `promo_sunday`, `promo_monday`, `promo_tuesday`, `promo_wednesday`, `promo_thursday`, `promo_friday`, `promo_saturday`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	(1, 3, 'Beli 100000 dapet 10%', '2018-08-24', '2018-08-31', '00:00:01', '23:59:59', 1, 1, 1, 1, 1, 1, 1, '2018-08-24 10:18:40', 'Super Restaurant', '0000-00-00 00:00:00', 'System', 1, 0);
  /*!40000 ALTER TABLE `res_promo` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.res_promo_buyall
  DROP TABLE IF EXISTS `res_promo_buyall`;
  CREATE TABLE IF NOT EXISTS `res_promo_buyall` (
    `promo_buyall_id` int(11) NOT NULL AUTO_INCREMENT,
    `promo_id` int(11) NOT NULL,
    `buy_amount` float(10,2) NOT NULL,
    `get_discount` float(10,2) NOT NULL COMMENT 'in_percent',
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(128) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(128) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`promo_buyall_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.res_promo_buyall: ~1 rows (approximately)
  DELETE FROM `res_promo_buyall`;
  /*!40000 ALTER TABLE `res_promo_buyall` DISABLE KEYS */;
  INSERT INTO `res_promo_buyall` (`promo_buyall_id`, `promo_id`, `buy_amount`, `get_discount`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	(1, 1, 100000.00, 10.00, '2018-08-24 10:18:40', 'Super Restaurant', '0000-00-00 00:00:00', 'System', 1, 0);
  /*!40000 ALTER TABLE `res_promo_buyall` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.res_promo_buyget
  DROP TABLE IF EXISTS `res_promo_buyget`;
  CREATE TABLE IF NOT EXISTS `res_promo_buyget` (
    `promo_buyget_id` int(11) NOT NULL AUTO_INCREMENT,
    `promo_id` int(11) NOT NULL,
    `buy_item_id` int(11) NOT NULL,
    `buy_amount` float(10,2) NOT NULL,
    `get_item_id` int(11) NOT NULL,
    `get_amount` float(10,2) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(128) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(128) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`promo_buyget_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.res_promo_buyget: ~0 rows (approximately)
  DELETE FROM `res_promo_buyget`;
  /*!40000 ALTER TABLE `res_promo_buyget` DISABLE KEYS */;
  /*!40000 ALTER TABLE `res_promo_buyget` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.res_promo_buyitem
  DROP TABLE IF EXISTS `res_promo_buyitem`;
  CREATE TABLE IF NOT EXISTS `res_promo_buyitem` (
    `promo_buyitem_id` int(11) NOT NULL AUTO_INCREMENT,
    `promo_id` int(11) NOT NULL,
    `buy_item_id` int(11) NOT NULL,
    `buy_amount` float(10,2) NOT NULL,
    `get_discount` float(10,2) NOT NULL COMMENT 'in_percent',
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(128) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(128) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`promo_buyitem_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.res_promo_buyitem: ~0 rows (approximately)
  DELETE FROM `res_promo_buyitem`;
  /*!40000 ALTER TABLE `res_promo_buyitem` DISABLE KEYS */;
  /*!40000 ALTER TABLE `res_promo_buyitem` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.res_promo_type
  DROP TABLE IF EXISTS `res_promo_type`;
  CREATE TABLE IF NOT EXISTS `res_promo_type` (
    `promo_type_id` int(11) NOT NULL AUTO_INCREMENT,
    `promo_type_code` varchar(3) NOT NULL,
    `promo_type_name` varchar(128) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(128) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(128) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`promo_type_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.res_promo_type: ~3 rows (approximately)
  DELETE FROM `res_promo_type`;
  /*!40000 ALTER TABLE `res_promo_type` DISABLE KEYS */;
  INSERT INTO `res_promo_type` (`promo_type_id`, `promo_type_code`, `promo_type_name`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	(1, 'PRB', 'Promo Buy Get', '2018-07-05 15:36:45', 'System', '0000-00-00 00:00:00', 'System', 1, 0),
  	(2, 'PRI', 'Promo Buy Item', '2018-07-05 15:36:55', 'System', '0000-00-00 00:00:00', 'System', 1, 0),
  	(3, 'PRA', 'Promo Buy All', '2018-07-05 15:38:53', 'System', '0000-00-00 00:00:00', 'System', 1, 0);
  /*!40000 ALTER TABLE `res_promo_type` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.res_return
  DROP TABLE IF EXISTS `res_return`;
  CREATE TABLE IF NOT EXISTS `res_return` (
    `tx_id` int(11) NOT NULL AUTO_INCREMENT,
    `tx_id_source` int(11) NOT NULL COMMENT 'Billing Id',
    `tx_receipt_no` varchar(12) NOT NULL DEFAULT '0',
    `tx_type` varchar(3) NOT NULL DEFAULT 'TXR',
    `user_id` int(11) NOT NULL,
    `user_realname` varchar(128) NOT NULL,
    `customer_id` int(11) NOT NULL,
    `customer_name` varchar(128) NOT NULL,
    `tx_date` date NOT NULL,
    `tx_time` time NOT NULL,
    `return_notes` text NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`tx_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  
  -- Dumping data for table prisma_pos.res_return: ~0 rows (approximately)
  DELETE FROM `res_return`;
  /*!40000 ALTER TABLE `res_return` DISABLE KEYS */;
  /*!40000 ALTER TABLE `res_return` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.res_return_detail
  DROP TABLE IF EXISTS `res_return_detail`;
  CREATE TABLE IF NOT EXISTS `res_return_detail` (
    `return_detail_id` int(11) NOT NULL AUTO_INCREMENT,
    `tx_id` int(11) NOT NULL,
    `tx_type` varchar(3) NOT NULL DEFAULT 'TXR',
    `item_id` int(11) NOT NULL,
    `item_name` varchar(128) NOT NULL,
    `item_price_after_tax` float(10,2) NOT NULL,
    `tx_amount` float NOT NULL,
    `return_amount` float NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(128) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `updated_by` varchar(128) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`return_detail_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  
  -- Dumping data for table prisma_pos.res_return_detail: ~0 rows (approximately)
  DELETE FROM `res_return_detail`;
  /*!40000 ALTER TABLE `res_return_detail` DISABLE KEYS */;
  /*!40000 ALTER TABLE `res_return_detail` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.res_role
  DROP TABLE IF EXISTS `res_role`;
  CREATE TABLE IF NOT EXISTS `res_role` (
    `role_id` int(11) NOT NULL AUTO_INCREMENT,
    `role_name` varchar(255) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`role_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.res_role: ~3 rows (approximately)
  DELETE FROM `res_role`;
  /*!40000 ALTER TABLE `res_role` DISABLE KEYS */;
  INSERT INTO `res_role` (`role_id`, `role_name`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	(0, 'Super Administrator Restaurant', '2018-03-30 11:16:36', 'Super Administrator', '2018-05-08 13:40:17', 'Super Administrator', 1, 0),
  	(1, 'Administrator Restaurant', '2018-03-30 11:18:19', 'Super Administrator', '2018-04-19 11:04:57', 'Super Administrator', 1, 0),
  	(2, 'Cashier Restaurant', '2018-05-08 13:42:21', 'Admin Restaurant', '2018-05-28 22:17:09', 'Super Restaurant', 1, 0);
  /*!40000 ALTER TABLE `res_role` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.res_shift
  DROP TABLE IF EXISTS `res_shift`;
  CREATE TABLE IF NOT EXISTS `res_shift` (
    `shift_id` int(11) NOT NULL AUTO_INCREMENT,
    `user_id` int(11) NOT NULL,
    `user_realname` varchar(128) NOT NULL,
    `shift_in_status` tinyint(1) NOT NULL,
    `shift_out_status` tinyint(1) NOT NULL,
    `shift_in_date` date DEFAULT NULL,
    `shift_in_time` time DEFAULT NULL,
    `shift_out_date` date DEFAULT NULL,
    `shift_out_time` time DEFAULT NULL,
    `money_in_100k` int(11) NOT NULL DEFAULT '0',
    `money_in_50k` int(11) NOT NULL DEFAULT '0',
    `money_in_20k` int(11) NOT NULL DEFAULT '0',
    `money_in_10k` int(11) NOT NULL DEFAULT '0',
    `money_in_5k` int(11) NOT NULL DEFAULT '0',
    `money_in_2k` int(11) NOT NULL DEFAULT '0',
    `money_in_1k` int(11) NOT NULL DEFAULT '0',
    `money_in_total` int(11) NOT NULL DEFAULT '0',
    `coin_in_1k` int(11) NOT NULL DEFAULT '0',
    `coin_in_500` int(11) NOT NULL DEFAULT '0',
    `coin_in_200` int(11) NOT NULL DEFAULT '0',
    `coin_in_100` int(11) NOT NULL DEFAULT '0',
    `coin_in_50` int(11) NOT NULL DEFAULT '0',
    `coin_in_25` int(11) NOT NULL DEFAULT '0',
    `coin_in_total` int(11) NOT NULL DEFAULT '0',
    `total_in` int(11) NOT NULL DEFAULT '0',
    `money_out_100k` int(11) NOT NULL DEFAULT '0',
    `money_out_50k` int(11) NOT NULL DEFAULT '0',
    `money_out_20k` int(11) NOT NULL DEFAULT '0',
    `money_out_10k` int(11) NOT NULL DEFAULT '0',
    `money_out_5k` int(11) NOT NULL DEFAULT '0',
    `money_out_2k` int(11) NOT NULL DEFAULT '0',
    `money_out_1k` int(11) NOT NULL DEFAULT '0',
    `money_out_total` int(11) NOT NULL DEFAULT '0',
    `coin_out_1k` int(11) NOT NULL DEFAULT '0',
    `coin_out_500` int(11) NOT NULL DEFAULT '0',
    `coin_out_200` int(11) NOT NULL DEFAULT '0',
    `coin_out_100` int(11) NOT NULL DEFAULT '0',
    `coin_out_50` int(11) NOT NULL DEFAULT '0',
    `coin_out_25` int(11) NOT NULL DEFAULT '0',
    `coin_out_total` int(11) NOT NULL DEFAULT '0',
    `total_out` int(11) NOT NULL DEFAULT '0',
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(128) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `updated_by` varchar(128) NOT NULL DEFAULT 'System',
    PRIMARY KEY (`shift_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  
  -- Dumping data for table prisma_pos.res_shift: ~1 rows (approximately)
  DELETE FROM `res_shift`;
  /*!40000 ALTER TABLE `res_shift` DISABLE KEYS */;
  INSERT INTO `res_shift` (`shift_id`, `user_id`, `user_realname`, `shift_in_status`, `shift_out_status`, `shift_in_date`, `shift_in_time`, `shift_out_date`, `shift_out_time`, `money_in_100k`, `money_in_50k`, `money_in_20k`, `money_in_10k`, `money_in_5k`, `money_in_2k`, `money_in_1k`, `money_in_total`, `coin_in_1k`, `coin_in_500`, `coin_in_200`, `coin_in_100`, `coin_in_50`, `coin_in_25`, `coin_in_total`, `total_in`, `money_out_100k`, `money_out_50k`, `money_out_20k`, `money_out_10k`, `money_out_5k`, `money_out_2k`, `money_out_1k`, `money_out_total`, `coin_out_1k`, `coin_out_500`, `coin_out_200`, `coin_out_100`, `coin_out_50`, `coin_out_25`, `coin_out_total`, `total_out`, `created`, `created_by`, `updated`, `updated_by`) VALUES
  	(1, 1, 'Super Restaurant', 1, 0, '2018-08-24', '10:18:48', NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2018-08-24 10:18:48', 'Super Restaurant', '0000-00-00 00:00:00', 'System');
  /*!40000 ALTER TABLE `res_shift` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.res_stock
  DROP TABLE IF EXISTS `res_stock`;
  CREATE TABLE IF NOT EXISTS `res_stock` (
    `stock_id` int(11) NOT NULL AUTO_INCREMENT,
    `tx_id` int(11) NOT NULL,
    `tx_type` varchar(3) NOT NULL,
    `tx_date` date NOT NULL,
    `item_id` int(11) NOT NULL,
    `stock_in` float(10,2) NOT NULL,
    `stock_out` float(10,2) NOT NULL,
    `stock_adjustment` float(10,2) NOT NULL,
    `stock_price` float(10,2) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(255) NOT NULL DEFAULT 'System',
    PRIMARY KEY (`stock_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.res_stock: ~0 rows (approximately)
  DELETE FROM `res_stock`;
  /*!40000 ALTER TABLE `res_stock` DISABLE KEYS */;
  /*!40000 ALTER TABLE `res_stock` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.res_stock_in
  DROP TABLE IF EXISTS `res_stock_in`;
  CREATE TABLE IF NOT EXISTS `res_stock_in` (
    `tx_id` int(11) NOT NULL AUTO_INCREMENT,
    `tx_receipt_no` varchar(12) NOT NULL DEFAULT '0',
    `tx_type` varchar(3) NOT NULL,
    `tx_date` date NOT NULL,
    `tx_notes` text NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(255) NOT NULL DEFAULT 'System',
    PRIMARY KEY (`tx_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.res_stock_in: ~0 rows (approximately)
  DELETE FROM `res_stock_in`;
  /*!40000 ALTER TABLE `res_stock_in` DISABLE KEYS */;
  /*!40000 ALTER TABLE `res_stock_in` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.res_stock_opname
  DROP TABLE IF EXISTS `res_stock_opname`;
  CREATE TABLE IF NOT EXISTS `res_stock_opname` (
    `tx_id` int(11) NOT NULL AUTO_INCREMENT,
    `tx_receipt_no` varchar(12) NOT NULL DEFAULT '0',
    `tx_type` varchar(3) NOT NULL,
    `tx_date` date NOT NULL,
    `tx_notes` text NOT NULL,
    `tx_status` tinyint(1) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(255) NOT NULL DEFAULT 'System',
    PRIMARY KEY (`tx_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.res_stock_opname: ~0 rows (approximately)
  DELETE FROM `res_stock_opname`;
  /*!40000 ALTER TABLE `res_stock_opname` DISABLE KEYS */;
  /*!40000 ALTER TABLE `res_stock_opname` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.res_stock_opname_detail
  DROP TABLE IF EXISTS `res_stock_opname_detail`;
  CREATE TABLE IF NOT EXISTS `res_stock_opname_detail` (
    `stock_id` int(11) NOT NULL AUTO_INCREMENT,
    `tx_id` int(11) NOT NULL,
    `tx_type` varchar(3) NOT NULL,
    `tx_date` date NOT NULL,
    `item_id` int(11) NOT NULL,
    `stock_last` float(10,2) NOT NULL,
    `stock_now` float(10,2) NOT NULL,
    `stock_adjustment` float(10,2) NOT NULL,
    `stock_price` float(10,2) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(255) NOT NULL DEFAULT 'System',
    PRIMARY KEY (`stock_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.res_stock_opname_detail: ~0 rows (approximately)
  DELETE FROM `res_stock_opname_detail`;
  /*!40000 ALTER TABLE `res_stock_opname_detail` DISABLE KEYS */;
  /*!40000 ALTER TABLE `res_stock_opname_detail` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.res_stock_out
  DROP TABLE IF EXISTS `res_stock_out`;
  CREATE TABLE IF NOT EXISTS `res_stock_out` (
    `tx_id` int(11) NOT NULL AUTO_INCREMENT,
    `tx_receipt_no` varchar(12) NOT NULL DEFAULT '0',
    `tx_type` varchar(3) NOT NULL,
    `tx_date` date NOT NULL,
    `tx_notes` text NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(255) NOT NULL DEFAULT 'System',
    PRIMARY KEY (`tx_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.res_stock_out: ~0 rows (approximately)
  DELETE FROM `res_stock_out`;
  /*!40000 ALTER TABLE `res_stock_out` DISABLE KEYS */;
  /*!40000 ALTER TABLE `res_stock_out` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.res_supplier
  DROP TABLE IF EXISTS `res_supplier`;
  CREATE TABLE IF NOT EXISTS `res_supplier` (
    `supplier_id` int(11) NOT NULL AUTO_INCREMENT,
    `supplier_name` varchar(255) NOT NULL,
    `supplier_phone` varchar(20) NOT NULL,
    `supplier_fax` varchar(20) NOT NULL,
    `supplier_email` varchar(255) NOT NULL,
    `supplier_address` text NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(255) NOT NULL,
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(255) NOT NULL,
    `is_active` int(1) NOT NULL DEFAULT '1',
    `is_deleted` int(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`supplier_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.res_supplier: ~0 rows (approximately)
  DELETE FROM `res_supplier`;
  /*!40000 ALTER TABLE `res_supplier` DISABLE KEYS */;
  /*!40000 ALTER TABLE `res_supplier` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.res_tax
  DROP TABLE IF EXISTS `res_tax`;
  CREATE TABLE IF NOT EXISTS `res_tax` (
    `tax_id` int(11) NOT NULL AUTO_INCREMENT,
    `tax_code` varchar(15) NOT NULL,
    `tax_name` varchar(128) NOT NULL,
    `tax_ratio` float(10,2) NOT NULL COMMENT 'in percent',
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`tax_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.res_tax: ~0 rows (approximately)
  DELETE FROM `res_tax`;
  /*!40000 ALTER TABLE `res_tax` DISABLE KEYS */;
  INSERT INTO `res_tax` (`tax_id`, `tax_code`, `tax_name`, `tax_ratio`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	(1, '1.1.1.02.01', 'Pajak Restoran', 10.00, '2018-05-08 11:05:43', 'Super Administrator', '2018-07-05 15:45:07', 'System', 1, 0);
  /*!40000 ALTER TABLE `res_tax` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.res_tx_type
  DROP TABLE IF EXISTS `res_tx_type`;
  CREATE TABLE IF NOT EXISTS `res_tx_type` (
    `tx_type` varchar(3) NOT NULL,
    `tx_name` varchar(255) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `created_by` varchar(255) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(255) NOT NULL,
    PRIMARY KEY (`tx_type`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.res_tx_type: ~6 rows (approximately)
  DELETE FROM `res_tx_type`;
  /*!40000 ALTER TABLE `res_tx_type` DISABLE KEYS */;
  INSERT INTO `res_tx_type` (`tx_type`, `tx_name`, `created`, `created_by`, `updated`, `updated_by`) VALUES
  	('TXA', 'Adjustment', '2018-04-11 13:59:45', 'System', '0000-00-00 00:00:00', ''),
  	('TXI', 'In Stock', '2018-04-10 12:56:36', 'System', '0000-00-00 00:00:00', ''),
  	('TXO', 'Out Stock', '2018-04-10 12:56:36', 'System', '0000-00-00 00:00:00', ''),
  	('TXP', 'Purchase Order\r\n', '2018-04-12 14:15:57', 'System', '0000-00-00 00:00:00', ''),
  	('TXR', 'Receive Order', '2018-04-10 12:57:16', 'System', '0000-00-00 00:00:00', ''),
  	('TXS', 'Selling ', '2018-04-10 12:57:16', 'System', '0000-00-00 00:00:00', '');
  /*!40000 ALTER TABLE `res_tx_type` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.res_unit
  DROP TABLE IF EXISTS `res_unit`;
  CREATE TABLE IF NOT EXISTS `res_unit` (
    `unit_id` int(11) NOT NULL AUTO_INCREMENT,
    `unit_code` varchar(10) NOT NULL,
    `unit_name` varchar(255) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(255) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(255) NOT NULL,
    `is_active` int(1) NOT NULL DEFAULT '1',
    `is_deleted` int(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`unit_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.res_unit: ~7 rows (approximately)
  DELETE FROM `res_unit`;
  /*!40000 ALTER TABLE `res_unit` DISABLE KEYS */;
  INSERT INTO `res_unit` (`unit_id`, `unit_code`, `unit_name`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	(0, 'pcs', 'Pieces', '2018-05-08 13:31:41', 'System', '2018-06-04 09:01:43', '', 1, 0),
  	(1, 'gr', 'Gram', '2018-06-04 09:02:07', 'System', '2018-06-04 09:02:10', '', 1, 0),
  	(2, 'kg', 'Kilogram', '2018-06-04 09:02:32', 'System', '0000-00-00 00:00:00', '', 1, 0),
  	(3, 'doz', 'Lusin', '2018-06-04 09:02:46', 'System', '0000-00-00 00:00:00', '', 1, 0),
  	(4, 'pks', 'Packs', '2018-06-04 09:03:03', 'System', '0000-00-00 00:00:00', '', 1, 0),
  	(5, 'gross', 'Gross', '2018-06-04 09:03:16', 'System', '0000-00-00 00:00:00', '', 1, 0),
  	(6, 'krtn', 'Karton', '2018-06-04 09:03:28', 'System', '0000-00-00 00:00:00', '', 1, 0);
  /*!40000 ALTER TABLE `res_unit` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.res_user
  DROP TABLE IF EXISTS `res_user`;
  CREATE TABLE IF NOT EXISTS `res_user` (
    `user_id` int(11) NOT NULL AUTO_INCREMENT,
    `user_name` varchar(32) NOT NULL,
    `role_id` int(11) NOT NULL,
    `user_password` varchar(32) NOT NULL,
    `user_realname` varchar(128) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`user_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.res_user: ~3 rows (approximately)
  DELETE FROM `res_user`;
  /*!40000 ALTER TABLE `res_user` DISABLE KEYS */;
  INSERT INTO `res_user` (`user_id`, `user_name`, `role_id`, `user_password`, `user_realname`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	(1, 'superrestaurant', 0, '21232f297a57a5a743894a0e4a801fc3', 'Super Restaurant', '2018-04-04 10:45:37', '', '2018-05-08 13:40:06', 'Super Administrator', 1, 0),
  	(2, 'adminrestaurant', 1, '21232f297a57a5a743894a0e4a801fc3', 'Admin Restaurant', '2018-05-08 13:40:40', 'Super Administrator', '0000-00-00 00:00:00', 'System', 1, 0),
  	(4, 'cashierrestaurant', 2, '21232f297a57a5a743894a0e4a801fc3', 'Cashier Restaurant', '2018-06-04 09:27:29', 'Super Restaurant', '0000-00-00 00:00:00', 'System', 1, 0);
  /*!40000 ALTER TABLE `res_user` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.res_void
  DROP TABLE IF EXISTS `res_void`;
  CREATE TABLE IF NOT EXISTS `res_void` (
    `tx_id` int(11) NOT NULL AUTO_INCREMENT,
    `tx_receipt_no` varchar(12) NOT NULL DEFAULT '0',
    `tx_id_source` int(11) NOT NULL COMMENT 'Billing Id',
    `tx_type` varchar(3) NOT NULL DEFAULT 'TXV',
    `user_id` int(11) NOT NULL,
    `user_realname` varchar(128) NOT NULL,
    `customer_id` int(11) NOT NULL,
    `customer_name` varchar(128) NOT NULL,
    `tx_date` date NOT NULL,
    `tx_time` time NOT NULL,
    `void_notes` text NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`tx_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  
  -- Dumping data for table prisma_pos.res_void: ~0 rows (approximately)
  DELETE FROM `res_void`;
  /*!40000 ALTER TABLE `res_void` DISABLE KEYS */;
  /*!40000 ALTER TABLE `res_void` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.res_void_detail
  DROP TABLE IF EXISTS `res_void_detail`;
  CREATE TABLE IF NOT EXISTS `res_void_detail` (
    `void_detail_id` int(11) NOT NULL AUTO_INCREMENT,
    `tx_id` int(11) NOT NULL,
    `tx_type` varchar(3) NOT NULL DEFAULT 'TXV',
    `item_id` int(11) NOT NULL,
    `item_name` varchar(128) NOT NULL,
    `item_price_after_tax` float(10,2) NOT NULL,
    `tx_amount` float NOT NULL,
    `void_amount` float NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(128) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `updated_by` varchar(128) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`void_detail_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  
  -- Dumping data for table prisma_pos.res_void_detail: ~0 rows (approximately)
  DELETE FROM `res_void_detail`;
  /*!40000 ALTER TABLE `res_void_detail` DISABLE KEYS */;
  /*!40000 ALTER TABLE `res_void_detail` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.ret_bank
  DROP TABLE IF EXISTS `ret_bank`;
  CREATE TABLE IF NOT EXISTS `ret_bank` (
    `bank_id` int(11) NOT NULL AUTO_INCREMENT,
    `payment_type_id` int(11) NOT NULL,
    `bank_name` varchar(128) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`bank_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.ret_bank: ~0 rows (approximately)
  DELETE FROM `ret_bank`;
  /*!40000 ALTER TABLE `ret_bank` DISABLE KEYS */;
  /*!40000 ALTER TABLE `ret_bank` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.ret_billing
  DROP TABLE IF EXISTS `ret_billing`;
  CREATE TABLE IF NOT EXISTS `ret_billing` (
    `tx_id` int(11) NOT NULL AUTO_INCREMENT,
    `tx_receipt_no` varchar(12) NOT NULL DEFAULT '0',
    `user_id` int(11) NOT NULL,
    `user_realname` varchar(255) NOT NULL,
    `customer_id` int(11) NOT NULL,
    `customer_name` varchar(255) NOT NULL,
    `tx_type` varchar(3) NOT NULL,
    `tx_date` date NOT NULL,
    `tx_time` time NOT NULL,
    `tx_notes` text NOT NULL,
    `payment_type_id` int(11) NOT NULL,
    `tx_payment` float(10,2) NOT NULL,
    `tx_status` int(1) NOT NULL DEFAULT '0',
    `tx_cancel_notes` text,
    `bank_id` int(11) NOT NULL,
    `bank_card_no` varchar(32) NOT NULL,
    `bank_reference_no` varchar(32) NOT NULL,
    `tx_total_buy_average` float(10,2) NOT NULL,
    `tx_total_tax` float(10,2) NOT NULL,
    `tx_total_discount` float(10,2) NOT NULL,
    `tx_total_before_tax` float(10,2) NOT NULL,
    `tx_total_after_tax` float(10,2) NOT NULL,
    `tx_total_grand` float(10,2) NOT NULL,
    `tx_change` float(10,2) NOT NULL,
    `tx_total_profit_before_tax` float(10,2) NOT NULL,
    `tx_total_profit_after_tax` float(10,2) NOT NULL,
    `created` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    `posting_st` tinyint(1) NOT NULL DEFAULT '0',
    `posting_date` datetime DEFAULT NULL,
    PRIMARY KEY (`tx_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.ret_billing: ~0 rows (approximately)
  DELETE FROM `ret_billing`;
  /*!40000 ALTER TABLE `ret_billing` DISABLE KEYS */;
  /*!40000 ALTER TABLE `ret_billing` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.ret_billing_buyall
  DROP TABLE IF EXISTS `ret_billing_buyall`;
  CREATE TABLE IF NOT EXISTS `ret_billing_buyall` (
    `billing_buyall_id` int(11) NOT NULL AUTO_INCREMENT,
    `tx_id` int(11) NOT NULL,
    `tx_type` varchar(3) NOT NULL,
    `promo_buyall_id` int(11) NOT NULL,
    `buy_amount` float(10,2) NOT NULL,
    `get_discount` int(11) NOT NULL,
    `get_discount_amount` float(10,2) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(128) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(128) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL,
    `is_deleted` tinyint(1) NOT NULL,
    PRIMARY KEY (`billing_buyall_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.ret_billing_buyall: ~0 rows (approximately)
  DELETE FROM `ret_billing_buyall`;
  /*!40000 ALTER TABLE `ret_billing_buyall` DISABLE KEYS */;
  /*!40000 ALTER TABLE `ret_billing_buyall` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.ret_billing_buyget
  DROP TABLE IF EXISTS `ret_billing_buyget`;
  CREATE TABLE IF NOT EXISTS `ret_billing_buyget` (
    `billing_buyget_id` int(11) NOT NULL AUTO_INCREMENT,
    `tx_id` int(11) NOT NULL,
    `tx_type` varchar(3) NOT NULL,
    `promo_buyget_id` int(11) NOT NULL,
    `buy_item_id` int(11) NOT NULL,
    `buy_amount` float(10,2) NOT NULL,
    `get_item_id` int(11) NOT NULL,
    `get_amount` float(10,2) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(128) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(128) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL,
    `is_deleted` tinyint(1) NOT NULL,
    PRIMARY KEY (`billing_buyget_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.ret_billing_buyget: ~0 rows (approximately)
  DELETE FROM `ret_billing_buyget`;
  /*!40000 ALTER TABLE `ret_billing_buyget` DISABLE KEYS */;
  /*!40000 ALTER TABLE `ret_billing_buyget` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.ret_billing_buyitem
  DROP TABLE IF EXISTS `ret_billing_buyitem`;
  CREATE TABLE IF NOT EXISTS `ret_billing_buyitem` (
    `billing_buyitem_id` int(11) NOT NULL AUTO_INCREMENT,
    `tx_id` int(11) NOT NULL,
    `tx_type` varchar(3) NOT NULL,
    `promo_buyitem_id` int(11) NOT NULL,
    `buy_item_id` int(11) NOT NULL,
    `buy_amount` float(10,2) NOT NULL,
    `get_discount` int(11) NOT NULL,
    `get_discount_amount` float(10,2) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(128) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(128) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL,
    `is_deleted` tinyint(1) NOT NULL,
    PRIMARY KEY (`billing_buyitem_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.ret_billing_buyitem: ~0 rows (approximately)
  DELETE FROM `ret_billing_buyitem`;
  /*!40000 ALTER TABLE `ret_billing_buyitem` DISABLE KEYS */;
  /*!40000 ALTER TABLE `ret_billing_buyitem` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.ret_billing_detail
  DROP TABLE IF EXISTS `ret_billing_detail`;
  CREATE TABLE IF NOT EXISTS `ret_billing_detail` (
    `billing_detail_id` int(11) NOT NULL AUTO_INCREMENT,
    `tx_id` int(11) NOT NULL,
    `tx_type` varchar(3) NOT NULL,
    `item_id` int(11) NOT NULL,
    `item_name` varchar(128) NOT NULL,
    `item_price_before_tax` float(10,2) NOT NULL,
    `item_price_after_tax` float(10,2) NOT NULL,
    `item_price_buy_average` float(10,2) NOT NULL,
    `tx_amount` float NOT NULL,
    `tx_subtotal_tax` float(10,2) NOT NULL,
    `tx_subtotal_discount` float(10,2) NOT NULL,
    `tx_subtotal_buy_average` float(10,2) NOT NULL,
    `tx_subtotal_before_tax` float(10,2) NOT NULL,
    `tx_subtotal_after_tax` float(10,2) NOT NULL,
    `tx_subtotal_profit_before_tax` float(10,2) NOT NULL,
    `tx_subtotal_profit_after_tax` float(10,2) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(128) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `updated_by` varchar(128) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`billing_detail_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  
  -- Dumping data for table prisma_pos.ret_billing_detail: ~0 rows (approximately)
  DELETE FROM `ret_billing_detail`;
  /*!40000 ALTER TABLE `ret_billing_detail` DISABLE KEYS */;
  /*!40000 ALTER TABLE `ret_billing_detail` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.ret_category
  DROP TABLE IF EXISTS `ret_category`;
  CREATE TABLE IF NOT EXISTS `ret_category` (
    `category_id` int(11) NOT NULL AUTO_INCREMENT,
    `category_name` varchar(128) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`category_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.ret_category: ~0 rows (approximately)
  DELETE FROM `ret_category`;
  /*!40000 ALTER TABLE `ret_category` DISABLE KEYS */;
  INSERT INTO `ret_category` (`category_id`, `category_name`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	(0, 'Tidak Terkategori', '2018-05-08 13:26:31', 'System', '2018-05-08 13:26:44', 'System', 1, 0);
  /*!40000 ALTER TABLE `ret_category` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.ret_client
  DROP TABLE IF EXISTS `ret_client`;
  CREATE TABLE IF NOT EXISTS `ret_client` (
    `client_id` varchar(32) NOT NULL,
    `client_name` varchar(32) NOT NULL,
    `client_brand` varchar(32) NOT NULL,
    `client_status` varchar(32) NOT NULL,
    `client_street` varchar(128) NOT NULL,
    `client_subdistrict` varchar(32) NOT NULL,
    `client_district` varchar(32) NOT NULL,
    `client_city` varchar(32) NOT NULL,
    `client_province` varchar(32) NOT NULL,
    `client_email` varchar(32) NOT NULL,
    `client_phone_1` varchar(15) NOT NULL,
    `client_phone_2` varchar(15) NOT NULL,
    `client_npwp` varchar(64) NOT NULL,
    `client_npwpd` varchar(64) NOT NULL,
    `client_owner_name` varchar(64) NOT NULL,
    `client_owner_address` text NOT NULL,
    `client_notes` text NOT NULL,
    `client_serial_number` varchar(20) NOT NULL,
    `client_keyboard_status` tinyint(1) NOT NULL DEFAULT '1',
    `client_receipt_is_taxed` tinyint(1) NOT NULL DEFAULT '1',
    `client_logo` varchar(255) DEFAULT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`client_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.ret_client: ~0 rows (approximately)
  DELETE FROM `ret_client`;
  /*!40000 ALTER TABLE `ret_client` DISABLE KEYS */;
  INSERT INTO `ret_client` (`client_id`, `client_name`, `client_brand`, `client_status`, `client_street`, `client_subdistrict`, `client_district`, `client_city`, `client_province`, `client_email`, `client_phone_1`, `client_phone_2`, `client_npwp`, `client_npwpd`, `client_owner_name`, `client_owner_address`, `client_notes`, `client_serial_number`, `client_keyboard_status`, `client_receipt_is_taxed`, `client_logo`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	('1', 'CV Prisma Retail', 'Prisma Retail', 'sendiri', 'Jalan Gajahmada 56', 'Warungboto', 'Umbulharjo', 'Yogyakarta', 'Daerah Istimewa Yogyakarta', 'buat@gmail.com', '123', '123', '1234', '1234', 'Sujo', 'jalan manggis\r\n', 'Tidak ada', '1234-1234-1234', 0, 1, NULL, '2018-05-08 10:26:03', 'System', '2018-06-25 09:32:58', 'Super Retail', 1, 0);
  /*!40000 ALTER TABLE `ret_client` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.ret_customer
  DROP TABLE IF EXISTS `ret_customer`;
  CREATE TABLE IF NOT EXISTS `ret_customer` (
    `customer_id` int(11) NOT NULL AUTO_INCREMENT,
    `customer_name` varchar(255) NOT NULL,
    `customer_phone` varchar(20) NOT NULL,
    `customer_fax` varchar(20) NOT NULL,
    `customer_email` varchar(255) NOT NULL,
    `customer_address` text NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(255) NOT NULL,
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(255) NOT NULL,
    `is_active` int(1) NOT NULL DEFAULT '1',
    `is_deleted` int(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`customer_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.ret_customer: ~0 rows (approximately)
  DELETE FROM `ret_customer`;
  /*!40000 ALTER TABLE `ret_customer` DISABLE KEYS */;
  INSERT INTO `ret_customer` (`customer_id`, `customer_name`, `customer_phone`, `customer_fax`, `customer_email`, `customer_address`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	(0, 'Umum', '1234567890', '1234567890', 'umum@umum.com', 'Umum', '2018-05-08 11:07:30', 'Super Administrator', '2018-05-08 13:33:20', '', 1, 0);
  /*!40000 ALTER TABLE `ret_customer` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.ret_item
  DROP TABLE IF EXISTS `ret_item`;
  CREATE TABLE IF NOT EXISTS `ret_item` (
    `item_id` int(11) NOT NULL AUTO_INCREMENT,
    `category_id` int(11) NOT NULL,
    `unit_id` int(11) NOT NULL,
    `tax_id` int(11) NOT NULL,
    `item_name` varchar(255) NOT NULL,
    `item_barcode` varchar(255) NOT NULL,
    `item_desc` text NOT NULL,
    `item_price_before_tax` float(10,2) NOT NULL,
    `is_package` tinyint(1) NOT NULL DEFAULT '0',
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(255) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(255) NOT NULL DEFAULT 'System',
    `is_active` int(1) NOT NULL DEFAULT '1',
    `is_deleted` int(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`item_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.ret_item: ~0 rows (approximately)
  DELETE FROM `ret_item`;
  /*!40000 ALTER TABLE `ret_item` DISABLE KEYS */;
  /*!40000 ALTER TABLE `ret_item` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.ret_item_package
  DROP TABLE IF EXISTS `ret_item_package`;
  CREATE TABLE IF NOT EXISTS `ret_item_package` (
    `item_package_id` int(11) NOT NULL AUTO_INCREMENT,
    `item_id` int(11) NOT NULL,
    `item_detail_id` int(11) NOT NULL,
    `item_detail_price` float(10,2) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(128) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(128) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`item_package_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.ret_item_package: ~0 rows (approximately)
  DELETE FROM `ret_item_package`;
  /*!40000 ALTER TABLE `ret_item_package` DISABLE KEYS */;
  /*!40000 ALTER TABLE `ret_item_package` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.ret_log
  DROP TABLE IF EXISTS `ret_log`;
  CREATE TABLE IF NOT EXISTS `ret_log` (
    `log_id` int(11) NOT NULL AUTO_INCREMENT,
    `user_id` int(11) NOT NULL,
    `user_realname` varchar(128) NOT NULL,
    `log_type` enum('Sign In','Sign Out') NOT NULL,
    `log_date` date NOT NULL,
    `log_time` time NOT NULL,
    PRIMARY KEY (`log_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  
  -- Dumping data for table prisma_pos.ret_log: ~0 rows (approximately)
  DELETE FROM `ret_log`;
  /*!40000 ALTER TABLE `ret_log` DISABLE KEYS */;
  /*!40000 ALTER TABLE `ret_log` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.ret_module
  DROP TABLE IF EXISTS `ret_module`;
  CREATE TABLE IF NOT EXISTS `ret_module` (
    `module_id` varchar(15) NOT NULL,
    `module_parent` varchar(15) NOT NULL,
    `module_name` varchar(32) NOT NULL,
    `module_folder` varchar(32) NOT NULL,
    `module_controller` varchar(32) NOT NULL,
    `module_url` varchar(32) NOT NULL,
    `module_icon` varchar(32) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_actived` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`module_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.ret_module: ~38 rows (approximately)
  DELETE FROM `ret_module`;
  /*!40000 ALTER TABLE `ret_module` DISABLE KEYS */;
  INSERT INTO `ret_module` (`module_id`, `module_parent`, `module_name`, `module_folder`, `module_controller`, `module_url`, `module_icon`, `created`, `created_by`, `updated`, `updated_by`, `is_actived`, `is_deleted`) VALUES
  	('01', '', 'Dashboard', 'ret_dashboard', 'ret_dashboard', 'index', 'dashboard', '2018-04-04 10:26:27', 'Super Administrator', '2018-04-19 10:40:13', 'Super Administrator', 1, 0),
  	('02', '', 'Master', '', '', '#', 'cubes', '2018-04-05 19:44:13', 'superadmin', '2018-04-05 19:45:13', 'superadmin', 1, 0),
  	('02.01', '02', 'Kategori', 'ret_category', 'ret_category', 'index', 'paperclip', '2018-04-05 19:47:02', 'superadmin', '2018-04-05 21:22:37', 'Super Administrator', 1, 0),
  	('02.02', '02', 'Satuan', 'ret_unit', 'ret_unit', 'index', 'dot-circle-o', '2018-04-05 22:14:53', 'Super Administrator', '0000-00-00 00:00:00', '', 1, 0),
  	('02.03', '02', 'Item', 'ret_item', 'ret_item', 'index', 'list', '2018-04-07 15:49:43', 'Super Administrator', '0000-00-00 00:00:00', '', 1, 0),
  	('02.04', '02', 'Suplier', 'ret_supplier', 'ret_supplier', 'index', 'truck', '2018-04-09 18:13:11', 'Super Administrator', '2018-04-09 18:53:55', 'Super Administrator', 1, 0),
  	('02.05', '02', 'Pelanggan', 'ret_customer', 'ret_customer', 'index', 'users', '2018-04-10 08:56:24', 'Super Administrator', '0000-00-00 00:00:00', '', 1, 0),
  	('02.06', '02', 'Bank', 'ret_bank', 'ret_bank', 'index', 'bank', '2018-04-18 08:38:55', 'Super Administrator', '0000-00-00 00:00:00', '', 1, 0),
  	('02.07', '02', 'Pajak', 'ret_tax', 'ret_tax', 'index', 'chain', '2018-04-19 19:48:06', 'Super Administrator', '0000-00-00 00:00:00', 'System', 1, 0),
  	('02.08', '02', 'Promo', 'ret_promo', 'ret_promo', 'index', 'ticket', '2018-04-20 09:21:42', 'Super Administrator', '0000-00-00 00:00:00', 'System', 1, 0),
  	('03', '', 'Transaksi', '', '', '#', 'exchange', '2018-04-17 10:05:10', 'Super Administrator', '2018-06-07 11:17:10', 'Super Retail', 1, 0),
  	('03.01', '03', 'Kasir', 'ret_cashier', 'ret_cashier', 'index', 'laptop', '2018-06-07 11:17:32', 'Super Retail', '0000-00-00 00:00:00', 'System', 1, 0),
  	('03.02', '03', 'Retur', 'ret_return', 'ret_return', 'index', 'undo', '2018-06-07 11:19:02', 'Super Retail', '0000-00-00 00:00:00', 'System', 1, 0),
  	('03.03', '03', 'Void', 'ret_void', 'ret_void', 'index', 'ban', '2018-06-07 14:17:41', 'Super Retail', '0000-00-00 00:00:00', 'System', 1, 0),
  	('04', '', 'Inventori', '', '', '#', 'archive', '2018-04-10 10:37:46', 'Super Administrator', '2018-06-08 12:26:52', 'Super Retail', 1, 0),
  	('04.01', '04', 'Stok Masuk', 'ret_stock_in', 'ret_stock_in', 'index', 'sign-in', '2018-04-10 10:54:00', 'Super Administrator', '0000-00-00 00:00:00', '', 1, 0),
  	('04.02', '04', 'Stok Keluar', 'ret_stock_out', 'ret_stock_out', 'index', 'sign-out', '2018-04-11 10:48:29', 'Super Administrator', '0000-00-00 00:00:00', '', 1, 0),
  	('04.03', '04', 'Stok Opname', 'ret_stock_opname', 'ret_stock_opname', 'index', 'exchange', '2018-04-11 13:54:55', 'Super Administrator', '2018-04-11 14:01:18', 'Super Administrator', 1, 0),
  	('04.04', '04', 'Rekap Stok', 'ret_stock_recap', 'ret_stock_recap', 'index', 'files-o', '2018-04-11 14:11:28', 'Super Administrator', '0000-00-00 00:00:00', '', 1, 0),
  	('04.05', '04', 'Purchace Order', 'ret_po', 'ret_po', 'index', 'file-text', '2018-04-12 12:36:57', 'Super Administrator', '0000-00-00 00:00:00', '', 1, 0),
  	('05', '', 'Laporan', '', '', '#', 'files-o', '2018-05-04 09:10:39', 'Super Administrator', '2018-05-28 10:30:22', 'Super Retail', 1, 0),
  	('05.01', '05', 'Penjualan (Semua)', 'ret_report_selling', 'ret_report_selling', 'index', 'money', '2018-05-28 10:32:42', 'Super Retail', '2018-05-28 10:53:56', 'Super Retail', 1, 0),
  	('05.02', '05', 'Penjualan (Pelanggan)', 'ret_report_selling_customer', 'ret_report_selling_customer', 'index', 'users', '2018-05-28 10:52:44', 'Super Retail', '2018-05-28 10:53:42', 'Super Retail', 1, 0),
  	('05.03', '05', 'Penjualan (Kategori)', 'ret_report_selling_category', 'ret_report_selling_category', 'index', 'cubes', '2018-05-28 11:41:33', 'Super Retail', '2018-05-28 14:18:04', 'Super Retail', 1, 0),
  	('05.04', '05', 'Penjualan (Kasir)', 'ret_report_selling_user', 'ret_report_selling_user', 'index', 'laptop', '2018-06-04 09:06:23', 'Super Retail', '2018-06-04 09:18:32', 'Super Retail', 1, 0),
  	('05.05', '05', 'Penjualan (Item)', 'ret_report_selling_item', 'ret_report_selling_item', 'index', 'cube', '2018-05-28 14:17:59', 'Super Retail', '2018-06-04 09:08:45', 'System', 1, 0),
  	('05.06', '05', 'Omzet (Semua)', 'ret_report_profit', 'ret_report_profit', 'index', 'bar-chart', '2018-05-28 14:58:02', 'Super Retail', '2018-06-04 09:08:40', 'Super Retail', 1, 0),
  	('05.07', '05', 'Omzet (Kasir)', 'ret_report_profit_cashier', 'ret_report_profit_cashier', 'index', 'laptop', '2018-05-28 15:33:42', 'Super Retail', '2018-06-08 10:20:55', 'Super Retail', 1, 0),
  	('05.08', '05', 'Piutang', 'ret_report_credit', 'ret_report_credit', 'index', 'credit-card', '2018-06-08 09:51:51', 'Super Retail', '2018-06-08 10:20:49', 'Super Retail', 1, 0),
  	('05.09', '05', 'Stok Barang', 'ret_report_stock', 'ret_report_stock', 'index', 'archive', '2018-05-29 21:31:00', 'Super Retail', '2018-06-08 09:52:48', 'System', 1, 0),
  	('05.10', '05', 'Shift', 'ret_report_shift', 'ret_report_shift', 'index', 'transfer', '2018-05-29 21:58:13', 'Super Retail', '2018-06-08 09:52:41', 'System', 1, 0),
  	('05.11', '05', 'Log Akses', 'ret_report_log', 'ret_report_log', 'index', 'files-o', '2018-06-04 14:33:00', 'Super Retail', '2018-06-08 09:52:36', 'Super Retail', 1, 0),
  	('99', '', 'Pengaturan', '', '', '#', 'gears', '2018-04-04 09:41:46', 'Super Administrator', '0000-00-00 00:00:00', '', 1, 0),
  	('99.01', '99', 'Modul', 'ret_module', 'ret_module', 'index', 'window-restore', '2018-04-04 09:44:01', 'Super Administrator', '2018-04-19 10:40:32', 'Super Administrator', 1, 0),
  	('99.02', '99', 'Role', 'ret_role', 'ret_role', 'index', 'users', '2018-04-04 09:46:50', 'Super Administrator', '2018-04-19 10:40:40', 'Super Administrator', 1, 0),
  	('99.03', '99', 'Pengguna', 'ret_user', 'ret_user', 'index', '', '2018-04-04 10:37:41', 'Super Administrator', '2018-04-19 10:40:49', 'Super Administrator', 1, 0),
  	('99.04', '99', 'Hak Akses', 'ret_permission', 'ret_permission', 'index', 'list', '2018-04-05 08:20:56', 'Super Administrator', '2018-04-19 10:40:56', '', 1, 0),
  	('99.05', '99', 'Client', 'ret_client', 'ret_client', 'index', 'th-large', '2018-04-05 17:31:04', 'Super Administrator', '2018-04-20 08:15:47', 'Super Administrator', 1, 0);
  /*!40000 ALTER TABLE `ret_module` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.ret_payment_type
  DROP TABLE IF EXISTS `ret_payment_type`;
  CREATE TABLE IF NOT EXISTS `ret_payment_type` (
    `payment_type_id` int(11) NOT NULL AUTO_INCREMENT,
    `payment_type_name` varchar(32) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`payment_type_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.ret_payment_type: ~3 rows (approximately)
  DELETE FROM `ret_payment_type`;
  /*!40000 ALTER TABLE `ret_payment_type` DISABLE KEYS */;
  INSERT INTO `ret_payment_type` (`payment_type_id`, `payment_type_name`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	(1, 'Cash', '2018-04-19 19:34:04', 'System', '0000-00-00 00:00:00', 'System', 1, 0),
  	(2, 'Debit Card', '2018-04-19 19:34:04', 'System', '0000-00-00 00:00:00', 'System', 1, 0),
  	(3, 'Credit Card', '2018-04-19 19:34:12', 'System', '0000-00-00 00:00:00', 'System', 1, 0);
  /*!40000 ALTER TABLE `ret_payment_type` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.ret_permission
  DROP TABLE IF EXISTS `ret_permission`;
  CREATE TABLE IF NOT EXISTS `ret_permission` (
    `permission_id` int(11) NOT NULL AUTO_INCREMENT,
    `role_id` int(11) NOT NULL,
    `module_id` varchar(25) NOT NULL,
    `_create` int(1) DEFAULT NULL,
    `_read` int(1) DEFAULT NULL,
    `_update` int(1) DEFAULT NULL,
    `_delete` int(1) DEFAULT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(255) NOT NULL,
    PRIMARY KEY (`permission_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=1093 DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.ret_permission: ~76 rows (approximately)
  DELETE FROM `ret_permission`;
  /*!40000 ALTER TABLE `ret_permission` DISABLE KEYS */;
  INSERT INTO `ret_permission` (`permission_id`, `role_id`, `module_id`, `_create`, `_read`, `_update`, `_delete`, `created`, `created_by`) VALUES
  	(521, 3, '01', 1, 1, 1, 1, '2018-05-08 13:42:51', 'Admin Retail'),
  	(522, 3, '03', 1, 1, 1, 1, '2018-05-08 13:42:51', 'Admin Retail'),
  	(523, 3, '03.01', 1, 1, 1, 1, '2018-05-08 13:42:51', 'Admin Retail'),
  	(524, 3, '03.02', 1, 1, 1, 1, '2018-05-08 13:42:51', 'Admin Retail'),
  	(807, 1, '01', 1, 1, 1, 1, '2018-06-01 07:50:53', 'Super Retail'),
  	(808, 1, '02', 1, 1, 1, 1, '2018-06-01 07:50:54', 'Super Retail'),
  	(809, 1, '02.01', 1, 1, 1, 1, '2018-06-01 07:50:54', 'Super Retail'),
  	(810, 1, '02.02', 1, 1, 1, 1, '2018-06-01 07:50:54', 'Super Retail'),
  	(811, 1, '02.03', 1, 1, 1, 1, '2018-06-01 07:50:54', 'Super Retail'),
  	(812, 1, '02.04', 1, 1, 1, 1, '2018-06-01 07:50:54', 'Super Retail'),
  	(813, 1, '02.05', 1, 1, 1, 1, '2018-06-01 07:50:54', 'Super Retail'),
  	(814, 1, '02.06', 1, 1, 1, 1, '2018-06-01 07:50:54', 'Super Retail'),
  	(815, 1, '02.07', 1, 1, 1, 1, '2018-06-01 07:50:54', 'Super Retail'),
  	(816, 1, '02.08', 1, 1, 1, 1, '2018-06-01 07:50:54', 'Super Retail'),
  	(817, 1, '03', 1, 1, 1, 1, '2018-06-01 07:50:54', 'Super Retail'),
  	(818, 1, '04', 1, 1, 1, 1, '2018-06-01 07:50:54', 'Super Retail'),
  	(819, 1, '04.01', 1, 1, 1, 1, '2018-06-01 07:50:54', 'Super Retail'),
  	(820, 1, '04.02', 1, 1, 1, 1, '2018-06-01 07:50:54', 'Super Retail'),
  	(821, 1, '04.03', 1, 1, 1, 1, '2018-06-01 07:50:54', 'Super Retail'),
  	(822, 1, '04.04', 1, 1, 1, 1, '2018-06-01 07:50:54', 'Super Retail'),
  	(823, 1, '04.05', 1, 1, 1, 1, '2018-06-01 07:50:54', 'Super Retail'),
  	(824, 1, '05', 1, 1, 1, 1, '2018-06-01 07:50:54', 'Super Retail'),
  	(825, 1, '05.01', 1, 1, 1, 1, '2018-06-01 07:50:54', 'Super Retail'),
  	(826, 1, '05.02', 1, 1, 1, 1, '2018-06-01 07:50:54', 'Super Retail'),
  	(827, 1, '05.03', 1, 1, 1, 1, '2018-06-01 07:50:55', 'Super Retail'),
  	(828, 1, '05.04', 1, 1, 1, 1, '2018-06-01 07:50:55', 'Super Retail'),
  	(829, 1, '05.05', 1, 1, 1, 1, '2018-06-01 07:50:55', 'Super Retail'),
  	(830, 1, '05.06', 1, 1, 1, 1, '2018-06-01 07:50:55', 'Super Retail'),
  	(831, 1, '05.07', 1, 1, 1, 1, '2018-06-01 07:50:55', 'Super Retail'),
  	(832, 1, '05.08', 1, 1, 1, 1, '2018-06-01 07:50:55', 'Super Retail'),
  	(833, 1, '99', 1, 1, 1, 1, '2018-06-01 07:50:55', 'Super Retail'),
  	(834, 1, '99.03', 1, 1, 1, 1, '2018-06-01 07:50:55', 'Super Retail'),
  	(835, 1, '99.05', 1, 1, 1, 1, '2018-06-01 07:50:55', 'Super Retail'),
  	(836, 2, '01', 1, 1, 1, 1, '2018-06-04 09:26:38', 'Super Retail'),
  	(837, 2, '03', 1, 1, 1, 1, '2018-06-04 09:26:39', 'Super Retail'),
  	(838, 2, '05', 1, 1, 1, 1, '2018-06-04 09:26:39', 'Super Retail'),
  	(839, 2, '05.04', 1, 1, 1, 1, '2018-06-04 09:26:39', 'Super Retail'),
  	(1054, 0, '01', 1, 1, 1, 1, '2018-06-08 09:53:19', 'Super Retail'),
  	(1055, 0, '02', 1, 1, 1, 1, '2018-06-08 09:53:19', 'Super Retail'),
  	(1056, 0, '02.01', 1, 1, 1, 1, '2018-06-08 09:53:19', 'Super Retail'),
  	(1057, 0, '02.02', 1, 1, 1, 1, '2018-06-08 09:53:19', 'Super Retail'),
  	(1058, 0, '02.03', 1, 1, 1, 1, '2018-06-08 09:53:19', 'Super Retail'),
  	(1059, 0, '02.04', 1, 1, 1, 1, '2018-06-08 09:53:19', 'Super Retail'),
  	(1060, 0, '02.05', 1, 1, 1, 1, '2018-06-08 09:53:19', 'Super Retail'),
  	(1061, 0, '02.06', 1, 1, 1, 1, '2018-06-08 09:53:19', 'Super Retail'),
  	(1062, 0, '02.07', 1, 1, 1, 1, '2018-06-08 09:53:19', 'Super Retail'),
  	(1063, 0, '02.08', 1, 1, 1, 1, '2018-06-08 09:53:19', 'Super Retail'),
  	(1064, 0, '03', 1, 1, 1, 1, '2018-06-08 09:53:19', 'Super Retail'),
  	(1065, 0, '03.01', 1, 1, 1, 1, '2018-06-08 09:53:19', 'Super Retail'),
  	(1066, 0, '03.02', 1, 1, 1, 1, '2018-06-08 09:53:19', 'Super Retail'),
  	(1067, 0, '03.03', 1, 1, 1, 1, '2018-06-08 09:53:19', 'Super Retail'),
  	(1068, 0, '04', 1, 1, 1, 1, '2018-06-08 09:53:19', 'Super Retail'),
  	(1069, 0, '04.01', 1, 1, 1, 1, '2018-06-08 09:53:19', 'Super Retail'),
  	(1070, 0, '04.02', 1, 1, 1, 1, '2018-06-08 09:53:19', 'Super Retail'),
  	(1071, 0, '04.03', 1, 1, 1, 1, '2018-06-08 09:53:19', 'Super Retail'),
  	(1072, 0, '04.04', 1, 1, 1, 1, '2018-06-08 09:53:19', 'Super Retail'),
  	(1073, 0, '04.05', 1, 1, 1, 1, '2018-06-08 09:53:19', 'Super Retail'),
  	(1074, 0, '05', 1, 1, 1, 1, '2018-06-08 09:53:20', 'Super Retail'),
  	(1075, 0, '05.01', 1, 1, 1, 1, '2018-06-08 09:53:20', 'Super Retail'),
  	(1076, 0, '05.02', 1, 1, 1, 1, '2018-06-08 09:53:20', 'Super Retail'),
  	(1077, 0, '05.03', 1, 1, 1, 1, '2018-06-08 09:53:20', 'Super Retail'),
  	(1078, 0, '05.04', 1, 1, 1, 1, '2018-06-08 09:53:20', 'Super Retail'),
  	(1079, 0, '05.05', 1, 1, 1, 1, '2018-06-08 09:53:20', 'Super Retail'),
  	(1080, 0, '05.06', 1, 1, 1, 1, '2018-06-08 09:53:20', 'Super Retail'),
  	(1081, 0, '05.07', 1, 1, 1, 1, '2018-06-08 09:53:20', 'Super Retail'),
  	(1082, 0, '05.08', 1, 1, 1, 1, '2018-06-08 09:53:20', 'Super Retail'),
  	(1083, 0, '05.09', 1, 1, 1, 1, '2018-06-08 09:53:20', 'Super Retail'),
  	(1084, 0, '05.10', 1, 1, 1, 1, '2018-06-08 09:53:20', 'Super Retail'),
  	(1085, 0, '05.11', 1, 1, 1, 1, '2018-06-08 09:53:20', 'Super Retail'),
  	(1086, 0, '99', 1, 1, 1, 1, '2018-06-08 09:53:20', 'Super Retail'),
  	(1087, 0, '99.01', 1, 1, 1, 1, '2018-06-08 09:53:20', 'Super Retail'),
  	(1088, 0, '99.02', 1, 1, 1, 1, '2018-06-08 09:53:20', 'Super Retail'),
  	(1089, 0, '99.03', 1, 1, 1, 1, '2018-06-08 09:53:20', 'Super Retail'),
  	(1090, 0, '99.04', 1, 1, 1, 1, '2018-06-08 09:53:20', 'Super Retail'),
  	(1091, 0, '99.05', 1, 1, 1, 1, '2018-06-08 09:53:20', 'Super Retail'),
  	(1092, 0, '99.06', 1, 1, 1, 1, '2018-06-08 09:53:20', 'Super Retail');
  /*!40000 ALTER TABLE `ret_permission` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.ret_po
  DROP TABLE IF EXISTS `ret_po`;
  CREATE TABLE IF NOT EXISTS `ret_po` (
    `tx_id` int(11) NOT NULL AUTO_INCREMENT,
    `tx_receipt_no` varchar(12) NOT NULL,
    `supplier_id` int(11) NOT NULL,
    `tx_type` varchar(3) NOT NULL,
    `tx_date` date NOT NULL,
    `tx_po_no` varchar(255) NOT NULL,
    `tx_po_receiver` varchar(255) NOT NULL,
    `tx_notes` text NOT NULL,
    `tx_status` int(1) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(255) NOT NULL DEFAULT 'System',
    PRIMARY KEY (`tx_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.ret_po: ~0 rows (approximately)
  DELETE FROM `ret_po`;
  /*!40000 ALTER TABLE `ret_po` DISABLE KEYS */;
  /*!40000 ALTER TABLE `ret_po` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.ret_po_detail
  DROP TABLE IF EXISTS `ret_po_detail`;
  CREATE TABLE IF NOT EXISTS `ret_po_detail` (
    `stock_id` int(11) NOT NULL AUTO_INCREMENT,
    `tx_id` int(11) NOT NULL,
    `tx_type` varchar(3) NOT NULL,
    `tx_date` date NOT NULL,
    `item_id` int(11) NOT NULL,
    `stock_demand` float(10,2) NOT NULL,
    `stock_receive` float(10,2) NOT NULL,
    `stock_price` float(10,2) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(255) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(255) NOT NULL,
    PRIMARY KEY (`stock_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.ret_po_detail: ~0 rows (approximately)
  DELETE FROM `ret_po_detail`;
  /*!40000 ALTER TABLE `ret_po_detail` DISABLE KEYS */;
  /*!40000 ALTER TABLE `ret_po_detail` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.ret_promo
  DROP TABLE IF EXISTS `ret_promo`;
  CREATE TABLE IF NOT EXISTS `ret_promo` (
    `promo_id` int(11) NOT NULL AUTO_INCREMENT,
    `promo_type_id` int(1) NOT NULL,
    `promo_name` varchar(255) NOT NULL,
    `promo_date_start` date NOT NULL,
    `promo_date_end` date NOT NULL,
    `promo_time_start` time NOT NULL,
    `promo_time_end` time NOT NULL,
    `promo_sunday` tinyint(1) NOT NULL DEFAULT '0',
    `promo_monday` tinyint(1) NOT NULL DEFAULT '0',
    `promo_tuesday` tinyint(1) NOT NULL DEFAULT '0',
    `promo_wednesday` tinyint(1) NOT NULL DEFAULT '0',
    `promo_thursday` tinyint(1) NOT NULL DEFAULT '0',
    `promo_friday` tinyint(1) NOT NULL DEFAULT '0',
    `promo_saturday` tinyint(1) NOT NULL DEFAULT '0',
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(128) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(128) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`promo_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.ret_promo: ~0 rows (approximately)
  DELETE FROM `ret_promo`;
  /*!40000 ALTER TABLE `ret_promo` DISABLE KEYS */;
  /*!40000 ALTER TABLE `ret_promo` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.ret_promo_buyall
  DROP TABLE IF EXISTS `ret_promo_buyall`;
  CREATE TABLE IF NOT EXISTS `ret_promo_buyall` (
    `promo_buyall_id` int(11) NOT NULL AUTO_INCREMENT,
    `promo_id` int(11) NOT NULL,
    `buy_amount` float(10,2) NOT NULL,
    `get_discount` float(10,2) NOT NULL COMMENT 'in_percent',
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(128) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(128) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`promo_buyall_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.ret_promo_buyall: ~0 rows (approximately)
  DELETE FROM `ret_promo_buyall`;
  /*!40000 ALTER TABLE `ret_promo_buyall` DISABLE KEYS */;
  /*!40000 ALTER TABLE `ret_promo_buyall` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.ret_promo_buyget
  DROP TABLE IF EXISTS `ret_promo_buyget`;
  CREATE TABLE IF NOT EXISTS `ret_promo_buyget` (
    `promo_buyget_id` int(11) NOT NULL AUTO_INCREMENT,
    `promo_id` int(11) NOT NULL,
    `buy_item_id` int(11) NOT NULL,
    `buy_amount` float(10,2) NOT NULL,
    `get_item_id` int(11) NOT NULL,
    `get_amount` float(10,2) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(128) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(128) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`promo_buyget_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.ret_promo_buyget: ~0 rows (approximately)
  DELETE FROM `ret_promo_buyget`;
  /*!40000 ALTER TABLE `ret_promo_buyget` DISABLE KEYS */;
  /*!40000 ALTER TABLE `ret_promo_buyget` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.ret_promo_buyitem
  DROP TABLE IF EXISTS `ret_promo_buyitem`;
  CREATE TABLE IF NOT EXISTS `ret_promo_buyitem` (
    `promo_buyitem_id` int(11) NOT NULL AUTO_INCREMENT,
    `promo_id` int(11) NOT NULL,
    `buy_item_id` int(11) NOT NULL,
    `buy_amount` float(10,2) NOT NULL,
    `get_discount` float(10,2) NOT NULL COMMENT 'in_percent',
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(128) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(128) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`promo_buyitem_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.ret_promo_buyitem: ~0 rows (approximately)
  DELETE FROM `ret_promo_buyitem`;
  /*!40000 ALTER TABLE `ret_promo_buyitem` DISABLE KEYS */;
  /*!40000 ALTER TABLE `ret_promo_buyitem` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.ret_promo_type
  DROP TABLE IF EXISTS `ret_promo_type`;
  CREATE TABLE IF NOT EXISTS `ret_promo_type` (
    `promo_type_id` int(11) NOT NULL AUTO_INCREMENT,
    `promo_type_code` varchar(3) NOT NULL,
    `promo_type_name` varchar(128) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(128) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(128) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`promo_type_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.ret_promo_type: ~3 rows (approximately)
  DELETE FROM `ret_promo_type`;
  /*!40000 ALTER TABLE `ret_promo_type` DISABLE KEYS */;
  INSERT INTO `ret_promo_type` (`promo_type_id`, `promo_type_code`, `promo_type_name`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	(1, 'PRB', 'Promo Buy Get', '2018-05-08 14:09:30', 'System', '0000-00-00 00:00:00', 'System', 1, 0),
  	(2, 'PRI', 'Promo Buy Item', '2018-05-08 14:09:30', 'System', '0000-00-00 00:00:00', 'System', 1, 0),
  	(3, 'PRA', 'Promo Buy All\r\n', '2018-05-08 14:09:49', 'System', '0000-00-00 00:00:00', 'System', 1, 0);
  /*!40000 ALTER TABLE `ret_promo_type` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.ret_return
  DROP TABLE IF EXISTS `ret_return`;
  CREATE TABLE IF NOT EXISTS `ret_return` (
    `tx_id` int(11) NOT NULL AUTO_INCREMENT,
    `tx_id_source` int(11) NOT NULL COMMENT 'Billing Id',
    `tx_receipt_no` varchar(12) NOT NULL DEFAULT '0',
    `tx_type` varchar(3) NOT NULL DEFAULT 'TXR',
    `user_id` int(11) NOT NULL,
    `user_realname` varchar(128) NOT NULL,
    `customer_id` int(11) NOT NULL,
    `customer_name` varchar(128) NOT NULL,
    `tx_date` date NOT NULL,
    `tx_time` time NOT NULL,
    `return_notes` text NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`tx_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  
  -- Dumping data for table prisma_pos.ret_return: ~0 rows (approximately)
  DELETE FROM `ret_return`;
  /*!40000 ALTER TABLE `ret_return` DISABLE KEYS */;
  /*!40000 ALTER TABLE `ret_return` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.ret_return_detail
  DROP TABLE IF EXISTS `ret_return_detail`;
  CREATE TABLE IF NOT EXISTS `ret_return_detail` (
    `return_detail_id` int(11) NOT NULL AUTO_INCREMENT,
    `tx_id` int(11) NOT NULL,
    `tx_type` varchar(3) NOT NULL DEFAULT 'TXR',
    `item_id` int(11) NOT NULL,
    `item_name` varchar(128) NOT NULL,
    `item_price_after_tax` float(10,2) NOT NULL,
    `tx_amount` float NOT NULL,
    `return_amount` float NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(128) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `updated_by` varchar(128) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`return_detail_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  
  -- Dumping data for table prisma_pos.ret_return_detail: ~0 rows (approximately)
  DELETE FROM `ret_return_detail`;
  /*!40000 ALTER TABLE `ret_return_detail` DISABLE KEYS */;
  /*!40000 ALTER TABLE `ret_return_detail` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.ret_role
  DROP TABLE IF EXISTS `ret_role`;
  CREATE TABLE IF NOT EXISTS `ret_role` (
    `role_id` int(11) NOT NULL AUTO_INCREMENT,
    `role_name` varchar(255) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`role_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.ret_role: ~3 rows (approximately)
  DELETE FROM `ret_role`;
  /*!40000 ALTER TABLE `ret_role` DISABLE KEYS */;
  INSERT INTO `ret_role` (`role_id`, `role_name`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	(0, 'Super Administrator Retail', '2018-03-30 11:16:36', 'Super Administrator', '2018-05-08 13:40:17', 'Super Administrator', 1, 0),
  	(1, 'Administrator Retail', '2018-03-30 11:18:19', 'Super Administrator', '2018-04-19 11:04:57', 'Super Administrator', 1, 0),
  	(2, 'Cashier Retail', '2018-05-08 13:42:21', 'Admin Retail', '2018-05-28 22:17:09', 'Super Retail', 1, 0);
  /*!40000 ALTER TABLE `ret_role` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.ret_shift
  DROP TABLE IF EXISTS `ret_shift`;
  CREATE TABLE IF NOT EXISTS `ret_shift` (
    `shift_id` int(11) NOT NULL AUTO_INCREMENT,
    `user_id` int(11) NOT NULL,
    `user_realname` varchar(128) NOT NULL,
    `shift_in_status` tinyint(1) NOT NULL,
    `shift_out_status` tinyint(1) NOT NULL,
    `shift_in_date` date DEFAULT NULL,
    `shift_in_time` time DEFAULT NULL,
    `shift_out_date` date DEFAULT NULL,
    `shift_out_time` time DEFAULT NULL,
    `money_in_100k` int(11) NOT NULL DEFAULT '0',
    `money_in_50k` int(11) NOT NULL DEFAULT '0',
    `money_in_20k` int(11) NOT NULL DEFAULT '0',
    `money_in_10k` int(11) NOT NULL DEFAULT '0',
    `money_in_5k` int(11) NOT NULL DEFAULT '0',
    `money_in_2k` int(11) NOT NULL DEFAULT '0',
    `money_in_1k` int(11) NOT NULL DEFAULT '0',
    `money_in_total` int(11) NOT NULL DEFAULT '0',
    `coin_in_1k` int(11) NOT NULL DEFAULT '0',
    `coin_in_500` int(11) NOT NULL DEFAULT '0',
    `coin_in_200` int(11) NOT NULL DEFAULT '0',
    `coin_in_100` int(11) NOT NULL DEFAULT '0',
    `coin_in_50` int(11) NOT NULL DEFAULT '0',
    `coin_in_25` int(11) NOT NULL DEFAULT '0',
    `coin_in_total` int(11) NOT NULL DEFAULT '0',
    `total_in` int(11) NOT NULL DEFAULT '0',
    `money_out_100k` int(11) NOT NULL DEFAULT '0',
    `money_out_50k` int(11) NOT NULL DEFAULT '0',
    `money_out_20k` int(11) NOT NULL DEFAULT '0',
    `money_out_10k` int(11) NOT NULL DEFAULT '0',
    `money_out_5k` int(11) NOT NULL DEFAULT '0',
    `money_out_2k` int(11) NOT NULL DEFAULT '0',
    `money_out_1k` int(11) NOT NULL DEFAULT '0',
    `money_out_total` int(11) NOT NULL DEFAULT '0',
    `coin_out_1k` int(11) NOT NULL DEFAULT '0',
    `coin_out_500` int(11) NOT NULL DEFAULT '0',
    `coin_out_200` int(11) NOT NULL DEFAULT '0',
    `coin_out_100` int(11) NOT NULL DEFAULT '0',
    `coin_out_50` int(11) NOT NULL DEFAULT '0',
    `coin_out_25` int(11) NOT NULL DEFAULT '0',
    `coin_out_total` int(11) NOT NULL DEFAULT '0',
    `total_out` int(11) NOT NULL DEFAULT '0',
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(128) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `updated_by` varchar(128) NOT NULL DEFAULT 'System',
    PRIMARY KEY (`shift_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  
  -- Dumping data for table prisma_pos.ret_shift: ~0 rows (approximately)
  DELETE FROM `ret_shift`;
  /*!40000 ALTER TABLE `ret_shift` DISABLE KEYS */;
  /*!40000 ALTER TABLE `ret_shift` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.ret_stock
  DROP TABLE IF EXISTS `ret_stock`;
  CREATE TABLE IF NOT EXISTS `ret_stock` (
    `stock_id` int(11) NOT NULL AUTO_INCREMENT,
    `tx_id` int(11) NOT NULL,
    `tx_type` varchar(3) NOT NULL,
    `tx_date` date NOT NULL,
    `item_id` int(11) NOT NULL,
    `stock_in` float(10,2) NOT NULL,
    `stock_out` float(10,2) NOT NULL,
    `stock_adjustment` float(10,2) NOT NULL,
    `stock_price` float(10,2) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(255) NOT NULL DEFAULT 'System',
    PRIMARY KEY (`stock_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.ret_stock: ~0 rows (approximately)
  DELETE FROM `ret_stock`;
  /*!40000 ALTER TABLE `ret_stock` DISABLE KEYS */;
  /*!40000 ALTER TABLE `ret_stock` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.ret_stock_in
  DROP TABLE IF EXISTS `ret_stock_in`;
  CREATE TABLE IF NOT EXISTS `ret_stock_in` (
    `tx_id` int(11) NOT NULL AUTO_INCREMENT,
    `tx_receipt_no` varchar(12) NOT NULL DEFAULT '0',
    `tx_type` varchar(3) NOT NULL,
    `tx_date` date NOT NULL,
    `tx_notes` text NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(255) NOT NULL DEFAULT 'System',
    PRIMARY KEY (`tx_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.ret_stock_in: ~0 rows (approximately)
  DELETE FROM `ret_stock_in`;
  /*!40000 ALTER TABLE `ret_stock_in` DISABLE KEYS */;
  /*!40000 ALTER TABLE `ret_stock_in` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.ret_stock_opname
  DROP TABLE IF EXISTS `ret_stock_opname`;
  CREATE TABLE IF NOT EXISTS `ret_stock_opname` (
    `tx_id` int(11) NOT NULL AUTO_INCREMENT,
    `tx_receipt_no` varchar(12) NOT NULL DEFAULT '0',
    `tx_type` varchar(3) NOT NULL,
    `tx_date` date NOT NULL,
    `tx_notes` text NOT NULL,
    `tx_status` tinyint(1) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(255) NOT NULL DEFAULT 'System',
    PRIMARY KEY (`tx_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.ret_stock_opname: ~0 rows (approximately)
  DELETE FROM `ret_stock_opname`;
  /*!40000 ALTER TABLE `ret_stock_opname` DISABLE KEYS */;
  /*!40000 ALTER TABLE `ret_stock_opname` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.ret_stock_opname_detail
  DROP TABLE IF EXISTS `ret_stock_opname_detail`;
  CREATE TABLE IF NOT EXISTS `ret_stock_opname_detail` (
    `stock_id` int(11) NOT NULL AUTO_INCREMENT,
    `tx_id` int(11) NOT NULL,
    `tx_type` varchar(3) NOT NULL,
    `tx_date` date NOT NULL,
    `item_id` int(11) NOT NULL,
    `stock_last` float(10,2) NOT NULL,
    `stock_now` float(10,2) NOT NULL,
    `stock_adjustment` float(10,2) NOT NULL,
    `stock_price` float(10,2) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(255) NOT NULL DEFAULT 'System',
    PRIMARY KEY (`stock_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.ret_stock_opname_detail: ~0 rows (approximately)
  DELETE FROM `ret_stock_opname_detail`;
  /*!40000 ALTER TABLE `ret_stock_opname_detail` DISABLE KEYS */;
  /*!40000 ALTER TABLE `ret_stock_opname_detail` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.ret_stock_out
  DROP TABLE IF EXISTS `ret_stock_out`;
  CREATE TABLE IF NOT EXISTS `ret_stock_out` (
    `tx_id` int(11) NOT NULL AUTO_INCREMENT,
    `tx_receipt_no` varchar(12) NOT NULL DEFAULT '0',
    `tx_type` varchar(3) NOT NULL,
    `tx_date` date NOT NULL,
    `tx_notes` text NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(255) NOT NULL DEFAULT 'System',
    PRIMARY KEY (`tx_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.ret_stock_out: ~0 rows (approximately)
  DELETE FROM `ret_stock_out`;
  /*!40000 ALTER TABLE `ret_stock_out` DISABLE KEYS */;
  /*!40000 ALTER TABLE `ret_stock_out` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.ret_supplier
  DROP TABLE IF EXISTS `ret_supplier`;
  CREATE TABLE IF NOT EXISTS `ret_supplier` (
    `supplier_id` int(11) NOT NULL AUTO_INCREMENT,
    `supplier_name` varchar(255) NOT NULL,
    `supplier_phone` varchar(20) NOT NULL,
    `supplier_fax` varchar(20) NOT NULL,
    `supplier_email` varchar(255) NOT NULL,
    `supplier_address` text NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(255) NOT NULL,
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(255) NOT NULL,
    `is_active` int(1) NOT NULL DEFAULT '1',
    `is_deleted` int(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`supplier_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.ret_supplier: ~0 rows (approximately)
  DELETE FROM `ret_supplier`;
  /*!40000 ALTER TABLE `ret_supplier` DISABLE KEYS */;
  /*!40000 ALTER TABLE `ret_supplier` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.ret_tax
  DROP TABLE IF EXISTS `ret_tax`;
  CREATE TABLE IF NOT EXISTS `ret_tax` (
    `tax_id` int(11) NOT NULL AUTO_INCREMENT,
    `tax_code` varchar(8) NOT NULL,
    `tax_name` varchar(128) NOT NULL,
    `tax_ratio` float(10,2) NOT NULL COMMENT 'in percent',
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`tax_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.ret_tax: ~0 rows (approximately)
  DELETE FROM `ret_tax`;
  /*!40000 ALTER TABLE `ret_tax` DISABLE KEYS */;
  INSERT INTO `ret_tax` (`tax_id`, `tax_code`, `tax_name`, `tax_ratio`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	(1, 'PPn', 'Pajak Penjualan', 10.00, '2018-05-08 11:05:43', 'Super Administrator', '2018-05-09 08:35:14', 'System', 1, 0);
  /*!40000 ALTER TABLE `ret_tax` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.ret_tx_type
  DROP TABLE IF EXISTS `ret_tx_type`;
  CREATE TABLE IF NOT EXISTS `ret_tx_type` (
    `tx_type` varchar(3) NOT NULL,
    `tx_name` varchar(255) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `created_by` varchar(255) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(255) NOT NULL,
    PRIMARY KEY (`tx_type`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.ret_tx_type: ~6 rows (approximately)
  DELETE FROM `ret_tx_type`;
  /*!40000 ALTER TABLE `ret_tx_type` DISABLE KEYS */;
  INSERT INTO `ret_tx_type` (`tx_type`, `tx_name`, `created`, `created_by`, `updated`, `updated_by`) VALUES
  	('TXA', 'Adjustment', '2018-04-11 13:59:45', 'System', '0000-00-00 00:00:00', ''),
  	('TXI', 'In Stock', '2018-04-10 12:56:36', 'System', '0000-00-00 00:00:00', ''),
  	('TXO', 'Out Stock', '2018-04-10 12:56:36', 'System', '0000-00-00 00:00:00', ''),
  	('TXP', 'Purchase Order\r\n', '2018-04-12 14:15:57', 'System', '0000-00-00 00:00:00', ''),
  	('TXR', 'Receive Order', '2018-04-10 12:57:16', 'System', '0000-00-00 00:00:00', ''),
  	('TXS', 'Selling ', '2018-04-10 12:57:16', 'System', '0000-00-00 00:00:00', '');
  /*!40000 ALTER TABLE `ret_tx_type` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.ret_unit
  DROP TABLE IF EXISTS `ret_unit`;
  CREATE TABLE IF NOT EXISTS `ret_unit` (
    `unit_id` int(11) NOT NULL AUTO_INCREMENT,
    `unit_code` varchar(10) NOT NULL,
    `unit_name` varchar(255) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(255) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(255) NOT NULL,
    `is_active` int(1) NOT NULL DEFAULT '1',
    `is_deleted` int(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`unit_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.ret_unit: ~7 rows (approximately)
  DELETE FROM `ret_unit`;
  /*!40000 ALTER TABLE `ret_unit` DISABLE KEYS */;
  INSERT INTO `ret_unit` (`unit_id`, `unit_code`, `unit_name`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	(0, 'pcs', 'Pieces', '2018-05-08 13:31:41', 'System', '2018-06-04 09:01:43', '', 1, 0),
  	(1, 'gr', 'Gram', '2018-06-04 09:02:07', 'System', '2018-06-04 09:02:10', '', 1, 0),
  	(2, 'kg', 'Kilogram', '2018-06-04 09:02:32', 'System', '0000-00-00 00:00:00', '', 1, 0),
  	(3, 'doz', 'Lusin', '2018-06-04 09:02:46', 'System', '0000-00-00 00:00:00', '', 1, 0),
  	(4, 'pks', 'Packs', '2018-06-04 09:03:03', 'System', '0000-00-00 00:00:00', '', 1, 0),
  	(5, 'gross', 'Gross', '2018-06-04 09:03:16', 'System', '0000-00-00 00:00:00', '', 1, 0),
  	(6, 'krtn', 'Karton', '2018-06-04 09:03:28', 'System', '0000-00-00 00:00:00', '', 1, 0);
  /*!40000 ALTER TABLE `ret_unit` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.ret_user
  DROP TABLE IF EXISTS `ret_user`;
  CREATE TABLE IF NOT EXISTS `ret_user` (
    `user_id` int(11) NOT NULL AUTO_INCREMENT,
    `user_name` varchar(32) NOT NULL,
    `role_id` int(11) NOT NULL,
    `user_password` varchar(32) NOT NULL,
    `user_realname` varchar(128) NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`user_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
  
  -- Dumping data for table prisma_pos.ret_user: ~3 rows (approximately)
  DELETE FROM `ret_user`;
  /*!40000 ALTER TABLE `ret_user` DISABLE KEYS */;
  INSERT INTO `ret_user` (`user_id`, `user_name`, `role_id`, `user_password`, `user_realname`, `created`, `created_by`, `updated`, `updated_by`, `is_active`, `is_deleted`) VALUES
  	(1, 'superretail', 0, '21232f297a57a5a743894a0e4a801fc3', 'Super Retail', '2018-04-04 10:45:37', '', '2018-05-08 13:40:06', 'Super Administrator', 1, 0),
  	(2, 'adminretail', 1, '21232f297a57a5a743894a0e4a801fc3', 'Admin Retail', '2018-05-08 13:40:40', 'Super Administrator', '0000-00-00 00:00:00', 'System', 1, 0),
  	(4, 'cashierretail', 2, '21232f297a57a5a743894a0e4a801fc3', 'Cashier Retail', '2018-06-04 09:27:29', 'Super Retail', '0000-00-00 00:00:00', 'System', 1, 0);
  /*!40000 ALTER TABLE `ret_user` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.ret_void
  DROP TABLE IF EXISTS `ret_void`;
  CREATE TABLE IF NOT EXISTS `ret_void` (
    `tx_id` int(11) NOT NULL AUTO_INCREMENT,
    `tx_receipt_no` varchar(12) NOT NULL DEFAULT '0',
    `tx_id_source` int(11) NOT NULL COMMENT 'Billing Id',
    `tx_type` varchar(3) NOT NULL DEFAULT 'TXV',
    `user_id` int(11) NOT NULL,
    `user_realname` varchar(128) NOT NULL,
    `customer_id` int(11) NOT NULL,
    `customer_name` varchar(128) NOT NULL,
    `tx_date` date NOT NULL,
    `tx_time` time NOT NULL,
    `void_notes` text NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(32) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `updated_by` varchar(32) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`tx_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  
  -- Dumping data for table prisma_pos.ret_void: ~0 rows (approximately)
  DELETE FROM `ret_void`;
  /*!40000 ALTER TABLE `ret_void` DISABLE KEYS */;
  /*!40000 ALTER TABLE `ret_void` ENABLE KEYS */;
  
  -- Dumping structure for table prisma_pos.ret_void_detail
  DROP TABLE IF EXISTS `ret_void_detail`;
  CREATE TABLE IF NOT EXISTS `ret_void_detail` (
    `void_detail_id` int(11) NOT NULL AUTO_INCREMENT,
    `tx_id` int(11) NOT NULL,
    `tx_type` varchar(3) NOT NULL DEFAULT 'TXV',
    `item_id` int(11) NOT NULL,
    `item_name` varchar(128) NOT NULL,
    `item_price_after_tax` float(10,2) NOT NULL,
    `tx_amount` float NOT NULL,
    `void_amount` float NOT NULL,
    `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `created_by` varchar(128) NOT NULL DEFAULT 'System',
    `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
    `updated_by` varchar(128) NOT NULL DEFAULT 'System',
    `is_active` tinyint(1) NOT NULL DEFAULT '1',
    `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`void_detail_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  
  -- Dumping data for table prisma_pos.ret_void_detail: ~0 rows (approximately)
  DELETE FROM `ret_void_detail`;
  /*!40000 ALTER TABLE `ret_void_detail` DISABLE KEYS */;
  /*!40000 ALTER TABLE `ret_void_detail` ENABLE KEYS */;
  
  /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
  /*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  