--
-- Host: localhost    Database: plexclou_petboss2
-- ------------------------------------------------------


--
-- Table structure for table `account`
--

CREATE TABLE `account` (
  `account_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `id` varchar(128) DEFAULT NULL,
  `name` varchar(128) DEFAULT NULL,
  `type` varchar(128) DEFAULT NULL,
  `subtype` varchar(128) DEFAULT NULL,
  `is_header` varchar(10) DEFAULT NULL,
  `is_subheader` varchar(10) DEFAULT NULL,
  `is_bank` varchar(10) DEFAULT NULL,
  `cash_postable` varchar(10) DEFAULT NULL,
  `description` text,
  `datetime` datetime DEFAULT NULL,
  `opening_balance` decimal(20,2) DEFAULT NULL,
  `balance` decimal(20,2) DEFAULT NULL,
  `order` int(11) DEFAULT NULL,
  `integrated` int(1) DEFAULT NULL,
  `integration_type` varchar(128) DEFAULT NULL,
  `default` int(1) DEFAULT NULL,
  `branch_id` int(11) DEFAULT NULL,
  `normal_sign` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`account_id`)
) ENGINE=MyISAM AUTO_INCREMENT=50 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `account`
--

INSERT INTO `account` VALUES (1,'1540','Vehicles','Asset','Other Asset',NULL,NULL,NULL,NULL,'Vehicles',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(2,'1150','Undeposited Funds','Asset','Cash/Bank Account',NULL,NULL,'1','1',NULL,NULL,0.00,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(3,'1541','Accumulated Depreciation on Vehicles','Asset','Other Asset',NULL,NULL,NULL,NULL,'Accumulated Depreciation on Vehicles',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(4,'1190','Petty Cash','Asset','Other Asset',NULL,NULL,NULL,NULL,'Petty Cash',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(5,'1531','Accumulated Depreciation on Computers','Asset','Other Asset',NULL,NULL,NULL,NULL,'Accumulated Depreciation on Computers',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(6,'1120','Savings Account','Asset','Cash/Bank Account',NULL,NULL,'1','1',NULL,NULL,0.00,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(7,'1530','Computers','Asset','Other Asset',NULL,NULL,NULL,NULL,'Computers',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(8,'1510','Furniture','Asset','Other Asset',NULL,NULL,NULL,NULL,'Furniture',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(9,'1511','Accumulated Depreciation on Furniture','Asset','Other Asset',NULL,NULL,NULL,NULL,'Accumulated Depreciation on Furniture',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(10,'1310','Inventory','Asset','Other Asset',NULL,NULL,NULL,NULL,'Inventory',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(11,'1110','Checking Account','Asset','Cash/Bank Account',NULL,NULL,'1','1',NULL,NULL,0.00,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(12,'1210','Accounts Receivable','Asset','Other Asset',NULL,NULL,NULL,NULL,NULL,NULL,0.00,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(13,'4210','Freight Collected','Income',NULL,NULL,NULL,NULL,NULL,'Freight Collected',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Credit'),(14,'4110','General Sales','Income',NULL,NULL,NULL,NULL,NULL,'General Sales',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Credit'),(15,'4910','Interest Revenue','Income',NULL,NULL,NULL,NULL,NULL,'Interest Revenue',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Credit'),(16,'2110','Credit Card','Liability','Credit Card',NULL,NULL,NULL,NULL,NULL,NULL,0.00,NULL,NULL,NULL,NULL,NULL,NULL,'Credit'),(17,'2210','Accounts Payable','Liability','Other Liability',NULL,NULL,NULL,NULL,NULL,NULL,0.00,NULL,NULL,NULL,NULL,NULL,NULL,'Credit'),(18,'2410','Sales Tax Collected','Liability','Other Liability',NULL,NULL,NULL,NULL,'Sales Tax Collected',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Credit'),(19,'2390','Other Taxes Payable','Liability','Other Liability',NULL,NULL,NULL,NULL,'Other Taxes Payable',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Credit'),(20,'2150','Loan','Liability','Loan Account',NULL,NULL,NULL,NULL,NULL,NULL,0.00,NULL,NULL,NULL,NULL,NULL,NULL,'Credit'),(21,'2350','Payroll Tax Payable','Liability','Other Liability',NULL,NULL,NULL,NULL,'Payroll Tax Payable',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Credit'),(22,'2340','Health Insurance Payable','Liability','Other Liability',NULL,NULL,NULL,NULL,'Health Insurance Payable',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Credit'),(23,'2380','Income Tax Payable','Liability','Other Liability',NULL,NULL,NULL,NULL,'Income Tax Payable',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Credit'),(24,'2330','Pension Contributions Payable','Liability','Other Liability',NULL,NULL,NULL,NULL,'Pension Contributions Payable',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Credit'),(25,'2320','Wages Payable','Liability','Other Liability',NULL,NULL,NULL,NULL,'Wages Payable',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Credit'),(26,'6610','Motor Vehicle','Expense','Operating Expense',NULL,NULL,NULL,NULL,'Motor Vehicle',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(27,'6410','Rent','Expense','Operating Expense',NULL,NULL,NULL,NULL,'Rent',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(28,'6210','Wages and Salaries','Expense','Operating Expense',NULL,NULL,NULL,NULL,'Wages and Salaries',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(29,'6510','Insurance','Expense','Non-Operating Expense',NULL,NULL,NULL,NULL,'Insurance',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(30,'6920','Depreciation','Expense','Non-Operating Expense',NULL,NULL,NULL,NULL,'Depreciation',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(31,'6300','Advertising and Promotion','Expense','Non-Operating Expense',NULL,NULL,NULL,NULL,'Advertising and Promotion',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(32,'6260','Subcontractors','Expense','Operating Expense',NULL,NULL,NULL,NULL,'Subcontractors',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(33,'6310','Advertising','Expense','Operating Expense',NULL,NULL,NULL,NULL,'Advertising',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(34,'6930','Income Tax Expense','Expense','Operating Expense',NULL,NULL,NULL,NULL,'Income Tax Expense',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(35,'6110','General Products Purchased','Expense','Cost of Sales',NULL,NULL,NULL,NULL,NULL,NULL,0.00,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(36,'6650','Repairs & Maintenance','Expense','Operating Expense',NULL,NULL,NULL,NULL,'Repairs & Maintenance',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(37,'6320','Website','Expense','Operating Expense',NULL,NULL,NULL,NULL,'Website',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(38,'6910','Interest Expense','Expense','Operating Expense',NULL,NULL,NULL,NULL,'Interest Expense',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(39,'6430','Telephone and Internet','Expense','Operating Expense',NULL,NULL,NULL,NULL,'Telephone and Internet',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(40,'6550','Legal','Expense','Non-Operating Expense',NULL,NULL,NULL,NULL,'Legal',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(41,'6420','Office Expenses','Expense','Operating Expense',NULL,NULL,NULL,NULL,'Office Expenses',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(42,'6580','Accounting','Expense','Operating Expense',NULL,NULL,NULL,NULL,'Accounting',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(43,'6190','Freight Paid','Expense','Operating Expense',NULL,NULL,NULL,NULL,NULL,NULL,0.00,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(44,'6350','Promotions','Expense','Non-Operating Expense',NULL,NULL,NULL,NULL,NULL,NULL,0.00,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(45,'3999','Historical Balancing','Equity','Equity',NULL,NULL,NULL,NULL,NULL,NULL,0.00,NULL,NULL,NULL,NULL,NULL,NULL,'Credit'),(46,'3030','Money Withdrawn','Equity','Equity',NULL,NULL,NULL,NULL,'Money Withdrawn',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Credit'),(47,'3020','Money Invested','Equity','Equity',NULL,NULL,NULL,NULL,'Money Invested',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Credit'),(48,'3040','Dividends Paid','Equity','Equity',NULL,NULL,NULL,NULL,'Dividends Paid',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Credit'),(49,'3010','Issued Capital','Equity','Equity',NULL,NULL,NULL,NULL,'Issued Capital',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Credit');

--
-- Table structure for table `account_transactions`
--

CREATE TABLE `account_transactions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `journal` varchar(128) DEFAULT NULL,
  `account_id` varchar(128) DEFAULT '',
  `account_name` varchar(128) DEFAULT NULL,
  `customer_id` int(11) DEFAULT NULL,
  `amount` decimal(20,2) DEFAULT NULL,
  `type` varchar(10) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `reference` varchar(128) DEFAULT NULL,
  `description` varchar(128) DEFAULT NULL,
  `notes` varchar(128) DEFAULT NULL,
  `group` varchar(128) DEFAULT NULL,
  `applied` varchar(128) DEFAULT NULL,
  `applied_date` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `account_transactions`
--


--
-- Table structure for table `additional`
--

CREATE TABLE `additional` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `group` varchar(128) DEFAULT NULL,
  `invoice_id` int(11) DEFAULT NULL,
  `checkin_id` int(11) DEFAULT NULL,
  `receipt_id` int(11) DEFAULT NULL,
  `room_number` int(11) DEFAULT NULL,
  `item_id` int(11) DEFAULT NULL,
  `item_name` varchar(128) DEFAULT NULL,
  `item_type` varchar(128) DEFAULT NULL,
  `item_desc` varchar(255) DEFAULT NULL,
  `discount` varchar(128) DEFAULT NULL,
  `qty` int(11) DEFAULT NULL,
  `price_per_unit` decimal(20,2) DEFAULT NULL,
  `price` decimal(20,2) DEFAULT NULL,
  `paid` int(1) DEFAULT NULL,
  `staff_id` int(11) DEFAULT NULL,
  `paid_date` datetime DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `grooming_item` int(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=173 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `additional`
--

INSERT INTO `additional` VALUES (154,'16808247636007',NULL,NULL,NULL,NULL,50,'Lion Cut - Long Hair','Grooming','','5%',1,120.00,114.00,NULL,10016,NULL,'2023-04-07 00:00:00',NULL),(155,'16808247636007',NULL,NULL,NULL,NULL,61,'TEST ITEM','TEST','','',1,99.00,99.00,NULL,10016,NULL,'2023-04-07 00:00:00',NULL),(156,'16860407374801',NULL,NULL,NULL,NULL,46,'Vaccine / Ubat Kutu / Ubat Cacing - Below 4kg','Addon',NULL,NULL,1,75.00,75.00,NULL,NULL,NULL,NULL,NULL),(157,'16861146875459',NULL,NULL,NULL,NULL,NULL,' (BULAN)',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,'2023-06-07 13:11:27',NULL),(158,'16861146875459',NULL,NULL,NULL,NULL,NULL,' (test)',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,'2023-06-07 13:11:27',NULL),(159,'16861161054414',NULL,NULL,NULL,NULL,50,'Lion Cut - Long Hair (BULAN)','Grooming',NULL,NULL,1,100.00,100.00,NULL,NULL,NULL,'2023-06-07 13:35:05',NULL),(160,'16861176426986',NULL,NULL,NULL,NULL,50,'Lion Cut - Long Hair (BULAN)','Grooming',NULL,NULL,1,100.00,100.00,NULL,NULL,NULL,'2023-06-07 14:00:42',NULL),(161,'16866361541381',NULL,355,NULL,NULL,50,'Lion Cut - Long Hair (BULAN)','Grooming',NULL,NULL,1,100.00,100.00,NULL,NULL,NULL,'2023-06-13 14:02:34',1),(162,'16866363885473',NULL,357,NULL,NULL,50,'Lion Cut - Long Hair (BULAN)','Grooming',NULL,NULL,1,100.00,100.00,NULL,NULL,NULL,'2023-06-13 14:06:28',1),(163,'16868986915038',NULL,358,NULL,NULL,50,'Lion Cut - Long Hair (BULAN)','Grooming',NULL,NULL,1,100.00,100.00,NULL,NULL,NULL,'2023-06-16 14:58:11',1),(164,'16868988606839',NULL,359,NULL,NULL,50,'Lion Cut - Long Hair (BULAN)','Grooming',NULL,NULL,1,100.00,100.00,NULL,NULL,NULL,'2023-06-16 15:01:00',1),(165,'16869002285121',NULL,360,NULL,NULL,50,'Lion Cut - Long Hair (BULAN)','Grooming',NULL,NULL,1,100.00,100.00,NULL,NULL,NULL,'2023-06-16 15:23:48',1),(166,'16869002285121',NULL,NULL,NULL,NULL,46,'Vaccine / Ubat Kutu / Ubat Cacing - Below 4kg','Addon','BULAN - Double Coat 4.00KG',NULL,1,75.00,75.00,NULL,NULL,NULL,NULL,NULL),(167,'16885237267344',NULL,361,NULL,NULL,50,'Lion Cut - Long Hair (BULAN)','Grooming',NULL,NULL,1,100.00,100.00,NULL,NULL,NULL,'2023-07-05 10:22:06',1),(168,'16885237267344',NULL,NULL,NULL,NULL,43,'Vaccine / Ubat Kutu / Ubat Cacing - Above 4kg','Addon','BULAN - Double Coat 4.00KG',NULL,1,85.00,85.00,NULL,NULL,NULL,NULL,NULL),(169,'16891417755218',NULL,NULL,NULL,NULL,47,'Neutering - Female Cat','Addon','','',1,160.00,160.00,NULL,10016,NULL,'2023-07-13 00:00:00',NULL),(170,'16891417755218',NULL,0,NULL,NULL,50,'Lion Cut - Long Hair (BULAN)','Grooming',NULL,NULL,1,100.00,100.00,NULL,NULL,NULL,'2023-07-13 07:24:18',1),(171,'16892045127887',NULL,0,NULL,NULL,10,'Grooming Adult - Long Hair (Comot)','Grooming',NULL,NULL,1,60.00,60.00,NULL,NULL,NULL,'2023-07-13 07:28:59',1),(172,'16892045127887',NULL,NULL,NULL,NULL,44,'Ubat Kutu / Ubat Cacing - Above 4kg','Addon','','',1,65.00,65.00,NULL,10016,NULL,'2023-07-13 00:00:00',NULL);

--
-- Table structure for table `agents`
--

CREATE TABLE `agents` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `on_behalf` int(11) DEFAULT NULL,
  `registration_number` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `contact_person` varchar(128) DEFAULT NULL,
  `contact_number` varchar(128) DEFAULT NULL,
  `address` text,
  `added_on` datetime DEFAULT NULL,
  `added_by` varchar(128) DEFAULT NULL,
  `modified_on` datetime DEFAULT NULL,
  `modified_by` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `agents`
--


--
-- Table structure for table `block_dates`
--

CREATE TABLE `block_dates` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `room_number` varchar(50) DEFAULT NULL,
  `date` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `block_dates`
--


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

CREATE TABLE `categories` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(128) DEFAULT NULL,
  `code` varchar(10) DEFAULT NULL,
  `description` text,
  `image` text,
  `image2` text,
  `image3` text,
  `pax` int(11) DEFAULT NULL,
  `online_booking_allotment` int(11) DEFAULT NULL,
  `pkey` varchar(255) DEFAULT NULL,
  `type` varchar(30) DEFAULT NULL,
  `first_free` int(11) DEFAULT NULL,
  `order` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=32 DEFAULT CHARSET=latin1;

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

INSERT INTO `categories` VALUES (31,'Lion Cut',NULL,'!! Lion Cut\r\n!! Nail cutting\r\n!! Ear, eye, nose cleaning\r\n!! Coat brushing\r\n!! Degrease syampoo\r\n!! Premium bath syampoo\r\n!! Blow-dry\r\n!! Touch-up\r\n!! Trimming','https://booking.nanacatz.com/assets/Screenshot_2022-12-02_at_1.28.26_PM.png',NULL,NULL,1,1,NULL,'Grooming',0,7),(26,'Standard Room','STD','!! Room cleaned daily\r\n!! 2 times play session daily\r\n!! Includes cat food and cat litter\r\n!! 24/7 Air-conditioned\r\n!! Send cat\'s video to owner upon request','https://booking.nanacatz.com/assets/std-room-alt.jpg',NULL,NULL,2,35,NULL,'Room',2,1),(29,'Grooming Adult',NULL,'!! Nail cutting\r\n!! Ear, eye, nose cleaning\r\n!! Coat brushing\r\n!! Degrease syampoo\r\n!! Premium bath syampoo\r\n!! Blow-dry\r\n!! Touch-up\r\n!! Trimming','https://booking.nanacatz.com/assets/grooming1.jpg','https://booking.nanacatz.com/assets/grooming3.jpg',NULL,0,0,NULL,'Grooming',NULL,5),(30,'Grooming Kitten',NULL,'!! Nail cutting\r\n!! Ear, eye, nose cleaning\r\n!! Coat brushing\r\n!! Degrease syampoo\r\n!! Premium bath syampoo\r\n!! Blow-dry\r\n!! Touch-up\r\n!! Trimming','https://booking.nanacatz.com/assets/grooming4.jpg','https://booking.nanacatz.com/assets/grooming2.jpg',NULL,0,0,NULL,'Grooming',NULL,6),(25,'Deluxe Room','DLX','!! Room cleaned daily\r\n!! 2 times play session daily\r\n!! Includes cat food and cat litter\r\n!! 24/7 Air-conditioned\r\n!! Send cat\'s video to owner upon request','https://booking.nanacatz.com/assets/mansion-room-2.jpg','https://booking.nanacatz.com/assets/mansion-room.jpg',NULL,4,13,NULL,'Room',3,2);

--
-- Table structure for table `checkins`
--

CREATE TABLE `checkins` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(128) DEFAULT NULL,
  `group` varchar(128) DEFAULT NULL,
  `pets` varchar(255) DEFAULT NULL,
  `invoice_id` int(11) DEFAULT NULL,
  `reservation_id` int(11) DEFAULT NULL,
  `check_in` date DEFAULT NULL,
  `check_in_time` time DEFAULT NULL,
  `check_in_by` int(11) DEFAULT NULL,
  `check_out` date DEFAULT NULL,
  `check_out_time` time DEFAULT NULL,
  `check_out_by` int(11) DEFAULT NULL,
  `actual_check_out` datetime DEFAULT NULL,
  `room_id` int(11) DEFAULT NULL,
  `room_number` varchar(40) DEFAULT NULL,
  `guest_id` int(11) DEFAULT NULL,
  `transfer_room` int(11) DEFAULT NULL,
  `status` varchar(128) DEFAULT NULL,
  `regular_rate` decimal(20,2) DEFAULT NULL,
  `rate` decimal(20,2) DEFAULT NULL,
  `amount` decimal(20,2) DEFAULT NULL,
  `regular_amount` decimal(20,2) DEFAULT NULL,
  `key_deposit` decimal(20,2) DEFAULT NULL,
  `tourism_tax` decimal(20,2) DEFAULT NULL,
  `remarks` text,
  `nights` int(11) DEFAULT NULL,
  `regular_day_charge` decimal(20,2) DEFAULT NULL,
  `day_charge` decimal(20,2) DEFAULT NULL,
  `single` int(11) DEFAULT NULL,
  `single_rate` decimal(20,2) DEFAULT NULL,
  `single_rate_first` decimal(20,2) DEFAULT NULL,
  `rate_breakdown` text,
  `regular_rate_breakdown` text,
  `description` text,
  `discount` varchar(128) DEFAULT NULL,
  `notes` text,
  `foc` int(1) DEFAULT NULL,
  `user` varchar(255) DEFAULT NULL,
  `category` varchar(255) DEFAULT NULL,
  `category_name` varchar(255) DEFAULT NULL,
  `channel_id` varchar(255) DEFAULT NULL,
  `channel` varchar(255) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `void` int(11) DEFAULT NULL,
  `seen` int(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=367 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `checkins`
--

INSERT INTO `checkins` VALUES (339,'Boarding','16808247636007','[\"429\"]',NULL,10002,'2023-04-07',NULL,NULL,'2023-04-08',NULL,NULL,NULL,100,'40',1002,NULL,'Reserved',80.00,80.00,NULL,NULL,25.00,NULL,NULL,1,0.00,0.00,0,NULL,NULL,'[80]','[80]',NULL,NULL,NULL,NULL,NULL,'25',NULL,NULL,NULL,'2023-04-07 07:46:03',10016,NULL,NULL),(340,'Boarding','16808539344330','[\"429\"]',NULL,10003,'2023-04-07',NULL,NULL,'2023-04-08',NULL,NULL,NULL,94,'34',1002,NULL,'Hold',55.00,55.00,NULL,NULL,NULL,NULL,NULL,1,0.00,0.00,0,NULL,NULL,'[55]','[55]','',NULL,NULL,NULL,NULL,'26','Standard Room',NULL,NULL,'2023-04-07 15:52:14',0,NULL,NULL),(341,'Boarding','16808540173069','[\"429\"]',NULL,10004,'2023-04-07',NULL,NULL,'2023-04-08',NULL,NULL,NULL,92,'32',1002,NULL,'Hold',55.00,55.00,NULL,NULL,NULL,NULL,NULL,1,0.00,0.00,0,NULL,NULL,'[55]','[55]','',NULL,NULL,NULL,NULL,'26','Standard Room',NULL,NULL,'2023-04-07 15:53:37',0,NULL,NULL),(342,'Boarding','16808540524027','[\"429\"]',NULL,10005,'2023-04-07',NULL,NULL,'2023-04-08',NULL,NULL,NULL,79,'19',1002,NULL,'Hold',55.00,55.00,NULL,NULL,NULL,NULL,NULL,1,0.00,0.00,0,NULL,NULL,'[55]','[55]','',NULL,NULL,NULL,NULL,'26','Standard Room',NULL,NULL,'2023-04-07 15:54:12',0,NULL,NULL),(343,'Boarding','16808543176975','[\"429\"]',NULL,10006,'2023-04-07',NULL,NULL,'2023-04-08',NULL,NULL,NULL,70,'10',1002,NULL,'Hold',55.00,55.00,NULL,NULL,NULL,NULL,NULL,1,0.00,0.00,0,NULL,NULL,'[55]','[55]','',NULL,NULL,NULL,NULL,'26','Standard Room',NULL,NULL,'2023-04-07 15:58:37',0,NULL,NULL),(344,'Boarding','16808550147612','[\"429\"]',NULL,10007,'2023-04-07',NULL,NULL,'2023-04-08',NULL,NULL,NULL,79,'19',1002,NULL,'Reserved',55.00,55.00,NULL,NULL,NULL,NULL,NULL,1,0.00,0.00,0,NULL,NULL,'[55]','[55]','',NULL,NULL,NULL,NULL,'26','Standard Room',NULL,NULL,'2023-04-07 16:10:14',0,NULL,NULL),(345,'Boarding','16808551499790','[\"429\"]',NULL,10008,'2023-04-07',NULL,NULL,'2023-04-08',NULL,NULL,NULL,78,'18',1002,NULL,'Reserved',55.00,55.00,NULL,NULL,NULL,NULL,NULL,1,0.00,0.00,0,NULL,NULL,'[55]','[55]','',NULL,NULL,NULL,NULL,'26','Standard Room',NULL,NULL,'2023-04-07 16:12:30',0,NULL,NULL),(346,'Boarding','16808565363259','[\"429\"]',NULL,10009,'2023-04-07',NULL,NULL,'2023-04-08',NULL,NULL,NULL,84,'24',1002,NULL,'Reserved',55.00,55.00,NULL,NULL,NULL,NULL,NULL,1,0.00,0.00,0,NULL,NULL,'[55]','[55]','',NULL,NULL,NULL,NULL,'26','Standard Room',NULL,NULL,'2023-04-07 16:35:36',0,NULL,NULL),(347,'Boarding','16808572032411','[\"429\"]',NULL,10010,'2023-04-07',NULL,NULL,'2023-04-08',NULL,NULL,NULL,77,'17',1002,NULL,'Reserved',55.00,55.00,NULL,NULL,NULL,NULL,NULL,1,0.00,0.00,0,NULL,NULL,'[55]','[55]','',NULL,NULL,NULL,NULL,'26','Standard Room',NULL,NULL,'2023-04-07 16:46:43',0,NULL,NULL),(348,'Boarding','16808574153480','[\"429\"]',NULL,10011,'2023-04-07',NULL,NULL,'2023-04-08',NULL,NULL,NULL,99,'39',1002,NULL,'Reserved',55.00,55.00,NULL,NULL,NULL,NULL,NULL,1,0.00,0.00,0,NULL,NULL,'[55]','[55]','',NULL,NULL,NULL,NULL,'26','Standard Room',NULL,NULL,'2023-04-07 16:50:16',0,NULL,NULL),(349,'Boarding','16808575375687','[\"429\"]',NULL,10012,'2023-04-07',NULL,NULL,'2023-04-08',NULL,NULL,NULL,90,'30',1002,NULL,'Reserved',55.00,55.00,NULL,NULL,NULL,NULL,NULL,1,0.00,0.00,0,NULL,NULL,'[55]','[55]','',NULL,NULL,NULL,NULL,'26','Standard Room',NULL,NULL,'2023-04-07 16:52:17',0,NULL,NULL),(350,'Boarding','16860407374801','[\"429\"]',NULL,10013,'2023-06-09',NULL,NULL,'2023-06-10',NULL,NULL,NULL,75,'15',1002,NULL,'Reserved',55.00,40.00,40.00,55.00,NULL,NULL,NULL,1,0.00,0.00,0,NULL,NULL,'[40]','[55]','',NULL,NULL,NULL,NULL,'26','Standard Room',NULL,NULL,'2023-06-06 16:38:58',0,NULL,NULL),(351,'Grooming','16861146875459','[\"429\",\"430\"]',NULL,10014,'2023-06-09',NULL,NULL,'2023-06-09',NULL,NULL,NULL,125,'2:00PM',1002,NULL,'Reserved',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'31','Lion Cut',NULL,NULL,'2023-06-07 13:11:27',10016,NULL,NULL),(352,'Grooming','16861146875459','[\"429\",\"430\"]',NULL,10014,'2023-06-09',NULL,NULL,'2023-06-09',NULL,NULL,NULL,123,'11:00AM',1002,NULL,'Reserved',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'31','Lion Cut',NULL,NULL,'2023-06-07 13:11:27',10016,NULL,NULL),(353,'Grooming','16861161054414','[\"429\"]',NULL,10015,'2023-06-12',NULL,NULL,'2023-06-12',NULL,NULL,NULL,123,'11:00AM',1002,NULL,'Reserved',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'31','Lion Cut',NULL,NULL,'2023-06-07 13:35:05',10016,NULL,NULL),(354,'Grooming','16861176426986','[\"429\"]',NULL,10016,'2023-06-11',NULL,NULL,'2023-06-11',NULL,NULL,NULL,123,'11:00AM',1002,NULL,'Reserved',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'31','Lion Cut',NULL,NULL,'2023-06-07 14:00:42',10016,NULL,NULL),(355,'Grooming','16866361541381','[\"429\"]',NULL,10017,'2023-06-13',NULL,NULL,'2023-06-13',NULL,NULL,NULL,123,'11:00AM',1002,NULL,'Reserved',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'31','Lion Cut',NULL,NULL,'2023-06-13 14:02:34',10016,NULL,NULL),(356,'Boarding','16866363412818','[\"429\"]',NULL,10018,'2023-06-17',NULL,NULL,'2023-06-18',NULL,NULL,NULL,70,'10',1002,NULL,'Reserved',55.00,40.00,40.00,55.00,NULL,NULL,NULL,1,0.00,0.00,0,NULL,NULL,'[40]','[55]','',NULL,NULL,NULL,NULL,'26','Standard Room',NULL,NULL,'2023-06-13 14:05:41',0,NULL,NULL),(357,'Grooming','16866363885473','[\"429\"]',NULL,10019,'2023-06-17',NULL,NULL,'2023-06-17',NULL,NULL,NULL,123,'11:00AM',1002,NULL,'Reserved',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'31','Lion Cut',NULL,NULL,'2023-06-13 14:06:28',10016,NULL,NULL),(358,'Grooming','16868986915038','[\"429\"]',NULL,10020,'2023-06-16',NULL,NULL,'2023-06-16',NULL,NULL,NULL,123,'11:00AM',1002,NULL,'Reserved',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'31','Lion Cut',NULL,NULL,'2023-06-16 14:58:11',10016,NULL,NULL),(359,'Grooming','16868988606839','[\"429\"]',NULL,10021,'2023-06-16',NULL,NULL,'2023-06-16',NULL,NULL,NULL,125,'2:00PM',1002,NULL,'Reserved',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'31','Lion Cut',NULL,NULL,'2023-06-16 15:01:00',10016,NULL,NULL),(360,'Grooming','16869002285121','[\"429\"]',NULL,10022,'2023-06-17',NULL,NULL,'2023-06-17',NULL,NULL,NULL,125,'2:00PM',1002,NULL,'Reserved',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'31','Lion Cut',NULL,NULL,'2023-06-16 15:23:48',10016,NULL,NULL),(361,'Grooming','16885237267344','[\"429\"]',NULL,10023,'2023-07-06',NULL,NULL,'2023-07-06',NULL,NULL,NULL,123,'11:00AM',1002,NULL,'Reserved',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'31','Lion Cut',NULL,NULL,'2023-07-05 10:22:06',10016,NULL,NULL),(365,'Boarding','16892045127887',NULL,NULL,10026,'2023-07-13',NULL,NULL,'2023-07-14',NULL,NULL,NULL,NULL,NULL,1002,NULL,'Reserved',80.00,60.00,60.00,80.00,25.00,NULL,NULL,1,0.00,0.00,0,NULL,NULL,'[60]','[80]','',NULL,NULL,NULL,NULL,'25',NULL,NULL,NULL,'2023-07-13 07:28:32',10016,NULL,NULL),(363,'Boarding','16891417755218',NULL,NULL,10024,'2023-07-12',NULL,NULL,'2023-07-13',NULL,NULL,NULL,NULL,NULL,1002,NULL,'Reserved',80.00,60.00,60.00,80.00,25.00,NULL,NULL,1,0.00,0.00,0,NULL,NULL,'[60]','[80]','',NULL,NULL,NULL,NULL,'25',NULL,NULL,NULL,'2023-07-12 14:02:55',10016,NULL,NULL),(364,'Grooming','16891417755218','[\"429\"]',NULL,10024,'2023-07-13',NULL,NULL,'2023-07-13',NULL,NULL,NULL,NULL,NULL,1002,NULL,'Reserved',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'31','Lion Cut',NULL,NULL,'2023-07-13 07:24:18',10016,NULL,NULL),(366,'Grooming','16892045127887','[\"453\"]',NULL,10026,'2023-07-14',NULL,NULL,'2023-07-14',NULL,NULL,NULL,NULL,NULL,1002,NULL,'Reserved',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'29','Grooming Adult',NULL,NULL,'2023-07-13 07:28:59',10016,NULL,NULL);

--
-- Table structure for table `close_out`
--

CREATE TABLE `close_out` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `days` text,
  `description` varchar(255) DEFAULT '',
  `type` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `close_out`
--

INSERT INTO `close_out` VALUES (6,'2022-12-26',NULL,'FULL SLOT','Grooming'),(5,'2022-12-27',NULL,'FULL SLOT','Grooming'),(8,NULL,'WED','Closed every Wednesday','Boarding'),(9,NULL,'WED','Closed every Wednesday','Grooming');

--
-- Table structure for table `commissions`
--

CREATE TABLE `commissions` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `group` varchar(128) DEFAULT NULL,
  `amount` decimal(20,2) DEFAULT NULL,
  `datetime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `commissions`
--


--
-- Table structure for table `config`
--

CREATE TABLE `config` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `config` varchar(128) DEFAULT NULL,
  `value` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=143 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `config`
--

INSERT INTO `config` VALUES (47,'deposit','25.00'),(48,'check_out_time',''),(49,'weekend','Sunday,Saturday'),(50,'max_room','10'),(51,'min_foc_room',NULL),(52,'regular_rate_label','Non-Member'),(53,'agent_rate_label',NULL),(54,'govt_rate_label',NULL),(55,'promo_rate_label','Member'),(56,'booking_header',NULL),(57,'booking_landing',NULL),(58,'booking_footer',NULL),(59,'booking_home_top',NULL),(60,'booking_sidebar',NULL),(61,'booking_cancellation_policy',NULL),(62,'booking_paypal',NULL),(63,'booking_tnc',''),(64,'booking_only',NULL),(65,'booking_css',NULL),(45,'surcharge_label',''),(46,'surcharge_inclusive',NULL),(44,'surcharge','0.00'),(43,'tax_inclusive',NULL),(42,'tax',''),(40,'tax_id',''),(41,'tax_name',''),(35,'hotel_name','Petboss'),(36,'document_header','<p>NO. 2-1, JALAN DIPLOMATIK PRESINT 15, <br>PRESINT DIPLOMATIK, 62050 PUTRAJAYA, <br>WILAYAH PERSEKUTUAN PUTRAJAYA<br></p>'),(37,'thank_you_note','<p>Thank you. Please come again!</p>'),(38,'currency','RM'),(39,'t_tax',NULL),(68,'guest_agreement','<h1 style=\"text-align: center;\">DECLARATION FORM</h1><p style=\"text-align: center;\">HOTEL/GROOMING</p><p><strong><br></strong></p><p><strong>I HAVE READ THE TERMS &amp; CONDITIONS BELOW AND FULLY AGREE TO THE FOLLOWING</strong>:</p><p>1. Deposits are not refundable. Once service effected, no claims shall be entertained.</p><p>2. It is the responsibility of the owner of the cat or by its own act for any or all damages, escape, or loss caused to the cat hotel.</p><p>3. When you sign the declaration form, you will also be consenting to emergency medical care in the event your cat becomes seriously ill. If you leave us an emergency phone number, we will certainly try to reach you and inform you of the situation. However, you can be sure the veterinarians will provide the best care possible for your cat\'s condition. Such charges shall be borne by the owner.</p><p>4. All charges for boarding are to be made in advance and other services are due when the cat is released. If you plan to have someone else pick up your cat, we must be informed in advance by the owner providing all necessary details e.g., name, IC etc.</p><p><br></p><h4>IMPORTANT REMINDER</h4><p>Any unpaid and/or uncollected cats will be disposed off after a period of 14 days from date of collection due date. The management reserves the sole right to do as they deem appropriate thereafter without further notice. The management is then released of their responsibilities for the cats boarded under these terms. All clients shall be in agreement to these terms once they have chosen at their freewill to sign this form and board their cats at THIS IS MEOWNESS CAT BOUTIQUE HOTEL.</p>'),(66,'booking_billplz','03a55f41-ac53-40e5-a9e6-072dd572cfd0'),(67,'booking_billplz_cid','4y46pxwx'),(69,'allow_backdate',NULL),(70,'promo_desc',''),(71,'guest_agreement_nric_required',NULL),(72,'guest_agreement_online_only',NULL),(73,'whatsapp_template_booking',''),(74,'whatsapp_template_invoice',''),(75,'whatsapp_template_quote',''),(76,'whatsapp_template_receipt',''),(77,'booking_brand_name','PetBoss'),(78,'booking_guest',NULL),(79,'booking_guest_email_optional',NULL),(80,'booking_register_text','<p>Register today to and book rooms for your cats more conveniently.</p>'),(81,'booking_nric_optional','1'),(82,'booking_pay_at_hotel','1'),(83,'booking_mp','1'),(84,'booking_mp_instruction','<p>Please transfer your payment to the below account:</p><p><strong></strong></p><p><strong>MAYBANK<br></strong></p><p><strong>562432514750<br></strong></p><p><strong>PURRLOVE TERUSMAJU RESOURCES<br></strong></p><p>Once you have made payment, please send us the transfer slip via Whatsapp to +60126116542</p>'),(85,'booking_mp_instruction_pah',''),(86,'booking_pah_cutoff',''),(87,'boarding_rules','<p class=\"text-left pt-5\">\r\n	Before you confirm your booking, please ensure you adhere to the following rules. We reserved the right to deny your cat\'s stay if the rules are not complied.<br><br>\r\n</p><table class=\"w-full text-left\">\r\n<tbody>\r\n<tr>\r\n	<td class=\"p-1\"><i class=\"fa-solid fa-check text-yellow-500\"></i>\r\n	</td>\r\n	<td>Bring medical card with updated <strong>latest vaccine</strong>\r\n	</td>\r\n</tr>\r\n<tr>\r\n	<td class=\"p-1\"><i class=\"fa-solid fa-check text-yellow-500\"></i>\r\n	</td>\r\n	<td>Cats must complete <strong>2nd dose</strong> of vaccine\r\n	</td>\r\n</tr>\r\n<tr>\r\n	<td class=\"p-1\"><i class=\"fa-solid fa-check text-yellow-500\"></i>\r\n	</td>\r\n	<td>Latest vaccination must be least <strong>7 days</strong> before check in date\r\n	</td>\r\n</tr>\r\n<tr>\r\n	<td class=\"p-1\"><i class=\"fa-solid fa-check text-yellow-500\"></i>\r\n	</td>\r\n	<td>Compulsory to add on <strong>flea medication</strong> RM5/cat\r\n	</td>\r\n</tr>\r\n<tr>\r\n	<td class=\"p-1\"><i class=\"fa-solid fa-check text-yellow-500\"></i>\r\n	</td>\r\n	<td>Cat must be <strong>healthy</strong> and free from flea, fungus &amp; skin infection\r\n	</td>\r\n</tr>\r\n<tr>\r\n	<td class=\"p-1\"><i class=\"fa-solid fa-check text-yellow-500\"></i>\r\n	</td>\r\n	<td>Bring your own <strong>cat food</strong> in if your cat requires special diet\r\n	</td>\r\n</tr>\r\n<tr>\r\n	<td class=\"p-1\"><i class=\"fa-solid fa-check text-yellow-500\"></i>\r\n	</td>\r\n	<td>Only <strong>small can</strong> or <strong>packet</strong> wet food is allowed\r\n	</td>\r\n</tr>\r\n<tr>\r\n	<td class=\"p-1\"><i class=\"fa-solid fa-check text-yellow-500\"></i>\r\n	</td>\r\n	<td>Bring your cat in a <strong>carrier</strong>\r\n	</td>\r\n</tr>\r\n<tr>\r\n	<td class=\"p-1\"><i class=\"fa-solid fa-check text-yellow-500\"></i>\r\n	</td>\r\n	<td>Check in from <strong>10AM</strong>\r\n	</td>\r\n</tr>\r\n<tr>\r\n	<td class=\"p-1\"><i class=\"fa-solid fa-check text-yellow-500\"></i>\r\n	</td>\r\n	<td>Check out before <strong>2PM</strong>\r\n	</td>\r\n</tr>\r\n</tbody>\r\n</table><p><br>\r\n</p>'),(88,'grooming_rules','<p class=\"text-left pt-5\">\r\n	Before you confirm your booking, please ensure you adhere to the following rules. We reserved the right to deny your cat\'s stay if the rules are not complied.<br><br>\r\n</p><table class=\"w-full text-left\">\r\n<tbody>\r\n<tr>\r\n	<td class=\"p-1\"><i class=\"fa-solid fa-check text-yellow-500\"></i>\r\n	</td>\r\n	<td>Cats must be <strong>healthy</strong> and free any kinds of fever and flu\r\n	</td>\r\n</tr>\r\n<tr>\r\n	<td class=\"p-1\"><i class=\"fa-solid fa-check text-yellow-500\"></i>\r\n	</td>\r\n	<td>Cats must complete 7 days if recently vaccinated or applied with flea medication\r\n	</td>\r\n</tr>\r\n<tr>\r\n	<td class=\"p-1\"><i class=\"fa-solid fa-check text-yellow-500\"></i>\r\n	</td>\r\n	<td>Cats that recently had undergone surgery are not allowed for grooming\r\n	</td>\r\n</tr>\r\n</tbody>\r\n</table><p><br>\r\n</p>'),(89,'membership_branding','Petboss Membership'),(90,'boarding_promo_text','<p class=\"text-2xl text-yellow-600 font-bold pb-2\">Sign up with Petboss</p><p class=\"mb-3\">Keep your cat profile and make faster and convenient booking\r\n</p>'),(91,'grooming_promo_text','<p class=\"text-2xl text-yellow-600 font-bold pb-2\">Sign up with Petboss</p><p class=\"mb-3\">Keep your cat profile and make faster and convenient booking\r\n</p>'),(92,'boarding_benefit','<p><strong><i class=\"fa-solid fa-crown text-yellow-500\"></i> Petboss Membership</strong><br>\r\n</p><p>Enjoy membership rates up to 20% discount\r\n</p>'),(93,'grooming_benefit','<p><strong><i class=\"fa-solid fa-crown text-yellow-500\"></i> Petboss Membership</strong><br>\r\n</p><p>Enjoy membership rates up to 10% discount\r\n</p>'),(94,'booking_logo','https://petboss.plexcloud.com/assets/petboss-logo-site.png'),(95,'booking_bg','https://petboss.plexcloud.com/assets/Try-the-Hotel-Out.jpeg'),(96,'hooks_grooming','$coat_type_map = array(\r\n	\'Shorthair\'		=> \'Short Hair\',\r\n	\'Double Coat\'	=> \'Long Hair\',\r\n	\'Longhair\'		=> \'Long Hair\'\r\n);\r\n\r\n$ct = $coat_type_map[$pet->coat_type] ;\r\n$wd = \'\';\r\n$item = $this->db->query(\"SELECT * FROM items WHERE name LIKE ? AND name LIKE ? AND name LIKE ?\", array(\r\n	\'%\'.$package->name.\'%\', \'%\'.$ct.\'%\', \'%\'.$wd.\'%\'\r\n))->row();'),(97,'hooks_grooming_js','var coatMap = {\r\n	\'Shorthair\': \'Short Hair\',\r\n	\'Longhair\': \'Long Hair\',\r\n	\'Double Coat\': \'Long Hair\'\r\n};\r\nvar wd = \'\';\r\n		\r\nvar ct = coatMap[pet.coat_type] ? coatMap[pet.coat_type] : \'\';		\r\n\r\nvar cpackage = gsearch.packages.filter(p => { \r\n	return p.name.toLowerCase().indexOf(category.name.toLowerCase()) > -1 &&\r\n		p.name.toLowerCase().indexOf(ct.toLowerCase()) > -1 &&\r\n		p.name.toLowerCase().indexOf(wd.toLowerCase()) > -1\r\n})[0];\r\n\r\nvar package = JSON.parse(JSON.stringify(cpackage));\r\n'),(98,'hooks_boarding',''),(99,'hooks_boarding_js',NULL),(100,'room_layout',''),(101,'session_layout',''),(102,'boarding_deposit','5'),(103,'grooming_deposit','5'),(104,'email_host','ssl://smtp.hostinger.com'),(105,'email_port','465'),(106,'email_user','petboss@plexcloud.com'),(107,'email_pass','Petbossadmin#123'),(108,'whatsapp_form_template','Owner Name: $GUEST_NAME\r\nPhone Number: $GUEST_CONTACT\r\nCat Name: $CAT_NAME\r\nCat Age: $CAT_AGE\r\nCat Breed: $CAT_BREED\r\nVaccine Status (Yes/No): $CAT_COLOR\r\nRoom Type (RC/PS/LM): $ROOM_TYPE\r\nCheck In Date (d/m/Y): $CHECK_IN\r\nCheck Out Date (d/m/Y): $CHECK_OUT'),(109,'booking_website_url','https://plexcloud.com'),(110,'booking_primary_color','#e26522'),(111,'booking_primary_color_hover','#ac381b'),(114,'booking_show_member_rate',NULL),(112,'booking_simple_pet_details','1'),(113,'booking_simple_guest_details','1'),(119,'whatsapp_bot_enabled','1'),(120,'whatsapp_bot_mode','QA'),(121,'whatsapp_qa','// FINAL\r\n		$proceed = \'You may proceed booking at booking.ritzcatton.com. \r\n			Type \"hooman!\" if you need our human assistance. We will attend you shortly.\r\n			\r\n			To start over, send any text message\';\r\n		\r\n		// QUESTION 0\r\n		$goto[0] = 1;\r\n		$answer[0] = \"\r\n			Hello there, are you interested for boarding or grooming\r\n			Type *1* for boarding\r\n			Type *2* for grooming\r\n		\";\r\n		\r\n		// ERROR ON QUESTION 0\r\n		$answer[1][0] = \"\r\n			Please answer from the choice\r\n		\";\r\n		\r\n		// QUESTION 1\r\n		$goto[1][1] = 2;\r\n		$answer[1][1] = \"\r\n			When do you plan for boarding? Enter date (DD/MM/YYYY)\r\n		\";\r\n		\r\n		$goto[1][2] = 5;\r\n		$answer[1][2] = \"\r\n			What is your concern to groom your cat?\r\n		\r\n			Type *1* for Smelly/dirty\r\n			Type *2* for Fleas/fungus\r\n			Type *3* for Make him/her beautiful\r\n		\";\r\n		\r\n		// QUESTION 2\r\n		$goto[2] = 3;\r\n		$answer[2] = \"\r\n			For how many cats (1-5)\r\n		\";\r\n		\r\n		// QUESTION 3\r\n		\r\n		$goto[3][1] = 0;\r\n		$answer[3][1] =  \"\r\n			Here is our suggestion:\r\n			*Le Meowridien @ RM40/night*\r\n			*Purr Season @ RM55/night*\r\n		\r\n			$proceed\r\n		\";\r\n		$goto[3][2] = 0;\r\n		$answer[3][2] =  \"\r\n			Here is our suggestion:\r\n			*Le Meowridien @ RM40/night*\r\n			*Purr Season @ RM55/night*\r\n			\r\n			$proceed\r\n		\";\r\n		$goto[3][3] = 0;\r\n		$answer[3][3] = \"\r\n			Here is our suggestion:\r\n			*Purr Season @ RM65/night*\r\n			*Ritz Catton @ RM70/night*\r\n		\r\n			$proceed\r\n		\";\r\n		$goto[3][4] = 0;\r\n		$answer[3][4] =  \"\r\n			Here is our suggestion:\r\n			*Ritz Catton @ RM80/night*\r\n		\r\n			$proceed\r\n		\";\r\n		$goto[3][5] = 0;\r\n		$answer[3][5] = $response = \"\r\n			Here is our suggestion:\r\n			*Ritz Catton @ RM90/night*\r\n		\r\n			$proceed\r\n		\";\r\n		$goto[3][0] = 3;\r\n		$answer[3][0] = \"\r\n			Please enter a number from 1 - 5\r\n		\";\r\n		\r\n		\r\n		// QUESTION 5\r\n		$goto[5][0] = 5;\r\n		$goto[5][1] = 0;\r\n		$goto[5][2] = 0;\r\n		$goto[5][3] = 0;\r\n		$answer[5][1] = \"\r\n			Here is our suggestion:\r\n			*Basic Grooming*\r\n			\r\n			$proceed\r\n		\";\r\n		$answer[5][2] = \"\r\n			Here is our suggestion:\r\n			*Medicated Grooming*\r\n			\r\n			$proceed\r\n		\";\r\n		$answer[5][3] = \"\r\n			Here is our suggestion:\r\n			*Beauty Grooming*\r\n			\r\n			$proceed\r\n		\";\r\n		$answer[5][0] = \"\r\n			Please enter from choice 1 - 3\r\n		\";\r\n		\r\n		switch ($session->stage):\r\n			case 0:\r\n				if (strpos(\' \'.strtolower($reply), \'hooman\')){\r\n					$response = \'A hooman will attend you shortly.\';\r\n					$stage = 0;\r\n				} else {\r\n					$response = $answer[0];\r\n					$stage = $goto[0];\r\n					\r\n				}\r\n				break;\r\n			case 1:\r\n				if (strpos(\' \'.strtolower($reply), \'hooman\')){\r\n					$response = \'A hooman will attend you shortly.\';\r\n					$stage = 0;\r\n				} else {\r\n					$reply = intval($reply);\r\n					$stage = $goto[1][$reply] !== null ? $goto[1][$reply] : 1;\r\n					$response = $answer[1][$reply] ? $answer[1][$reply] : $answer[1][0];\r\n					\r\n				}\r\n				break;\r\n			case 2:\r\n				$dmy = explode(\'/\', $reply);\r\n				$ymd = $dmy[2] . \'-\' . $dmy[1] . \'-\' . $dmy[0];\r\n				if (strtotime($ymd) < strtotime(date(\'Y-m-d\'))){\r\n					$stage = 2;\r\n					$response = \'Please enter a valid date that must not be earlier than \'.date(\'d/m/Y\').\' (DD/MM/YYYY)\';\r\n				} else {\r\n					$response = $answer[2];\r\n					$stage = $goto[2];	\r\n				}\r\n				\r\n				break;\r\n			case 3:\r\n				$reply = intval($reply);\r\n				$stage = $goto[3][$reply] !== null ? $goto[3][$reply] : $goto[3][0];\r\n				$response = $answer[3][$reply] ? $answer[3][$reply] : $answer[3][0];\r\n				\r\n				\r\n				break;\r\n			case 5:\r\n				$reply = intval($reply);\r\n				$response = $answer[5][$reply] ? $answer[5][$reply] : $answer[5][0];\r\n				$stage = $goto[5][$reply] !== null ? $goto[5][$reply] : $goto[5][0];\r\n				break;\r\n		endswitch;\r\n		'),(115,'allow_transfer_any_room','1'),(116,'notify_email','shafiq.rizwan@gmail.com'),(117,'whatsapp_welcome_msg','*Welcome to Petboss* \r\n\r\nTo book boarding for your cats, please fill up the form below:\r\n	\r\nOwner Name: \r\nPhone Number: \r\nCat Name:\r\nCat Age: \r\nCat Breed:\r\nCat Colour:\r\nVaccine Status (Yes/No):\r\nRoom Type (RC/PS/LM):\r\nCheck In Date (d/m/Y):\r\nCheck Out Date (d/m/Y): \r\n\r\nFor room type enter the code name accordingly\r\nRitz Catton - RC\r\nPurr Seasons - PS\r\nLe Meowridien - LM\r\n\r\nTo add multiple rooms, enter number in front of the room code e.g. \'2 RC\'\r\n\r\nIf you plan to check in more than 1 cat, use comma \',\' between each names/age/breed/color of your cats'),(118,'whatsapp_confirm_msg','Thank you for booking with us!'),(138,'thank_you_note_receipt',''),(122,'promo_rate_discount',NULL),(123,'booking_prefix','BKG-B-'),(124,'hooks_backend_grooming_js',''),(125,'booking_tos',''),(126,'booking_privacy',''),(127,'booking_cpolicy',''),(128,'booking_registered_only',NULL),(129,'backend_color_tone1','#000000'),(130,'backend_color_tone2','#000000'),(131,'booking_billplz_description',''),(132,'boarding_deposit_peak','5'),(133,'boarding_pay_deposit','1'),(134,'boarding_pay_in_full',NULL),(135,'grooming_deposit_peak','5'),(136,'grooming_pay_deposit','1'),(137,'grooming_pay_in_full',NULL),(139,'thank_you_note_confirmation',''),(140,'thank_you_note_quotation',''),(141,'daily_rates',NULL),(142,'promo_discount_label','');

--
-- Table structure for table `conversation`
--

CREATE TABLE `conversation` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `number` varchar(30) DEFAULT NULL,
  `message` longtext,
  `reply` longtext,
  `datetime` datetime DEFAULT NULL,
  `reply_datetime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `conversation`
--


--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(128) DEFAULT NULL,
  `prefix` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=240 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` VALUES (1,'United States','US'),(2,'Canada','CA'),(3,'Afghanistan','AF'),(4,'Albania','AL'),(5,'Algeria','DZ'),(6,'American Samoa','DS'),(7,'Andorra','AD'),(8,'Angola','AO'),(9,'Anguilla','AI'),(10,'Antarctica','AQ'),(11,'Antigua and/or Barbuda','AG'),(12,'Argentina','AR'),(13,'Armenia','AM'),(14,'Aruba','AW'),(15,'Australia','AU'),(16,'Austria','AT'),(17,'Azerbaijan','AZ'),(18,'Bahamas','BS'),(19,'Bahrain','BH'),(20,'Bangladesh','BD'),(21,'Barbados','BB'),(22,'Belarus','BY'),(23,'Belgium','BE'),(24,'Belize','BZ'),(25,'Benin','BJ'),(26,'Bermuda','BM'),(27,'Bhutan','BT'),(28,'Bolivia','BO'),(29,'Bosnia and Herzegovina','BA'),(30,'Botswana','BW'),(31,'Bouvet Island','BV'),(32,'Brazil','BR'),(33,'British lndian Ocean Territory','IO'),(34,'Brunei Darussalam','BN'),(35,'Bulgaria','BG'),(36,'Burkina Faso','BF'),(37,'Burundi','BI'),(38,'Cambodia','KH'),(39,'Cameroon','CM'),(40,'Cape Verde','CV'),(41,'Cayman Islands','KY'),(42,'Central African Republic','CF'),(43,'Chad','TD'),(44,'Chile','CL'),(45,'China','CN'),(46,'Christmas Island','CX'),(47,'Cocos (Keeling) Islands','CC'),(48,'Colombia','CO'),(49,'Comoros','KM'),(50,'Congo','CG'),(51,'Cook Islands','CK'),(52,'Costa Rica','CR'),(53,'Croatia (Hrvatska)','HR'),(54,'Cuba','CU'),(55,'Cyprus','CY'),(56,'Czech Republic','CZ'),(57,'Denmark','DK'),(58,'Djibouti','DJ'),(59,'Dominica','DM'),(60,'Dominican Republic','DO'),(61,'East Timor','TP'),(62,'Ecudaor','EC'),(63,'Egypt','EG'),(64,'El Salvador','SV'),(65,'Equatorial Guinea','GQ'),(66,'Eritrea','ER'),(67,'Estonia','EE'),(68,'Ethiopia','ET'),(69,'Falkland Islands (Malvinas)','FK'),(70,'Faroe Islands','FO'),(71,'Fiji','FJ'),(72,'Finland','FI'),(73,'France','FR'),(74,'France, Metropolitan','FX'),(75,'French Guiana','GF'),(76,'French Polynesia','PF'),(77,'French Southern Territories','TF'),(78,'Gabon','GA'),(79,'Gambia','GM'),(80,'Georgia','GE'),(81,'Germany','DE'),(82,'Ghana','GH'),(83,'Gibraltar','GI'),(84,'Greece','GR'),(85,'Greenland','GL'),(86,'Grenada','GD'),(87,'Guadeloupe','GP'),(88,'Guam','GU'),(89,'Guatemala','GT'),(90,'Guinea','GN'),(91,'Guinea-Bissau','GW'),(92,'Guyana','GY'),(93,'Haiti','HT'),(94,'Heard and Mc Donald Islands','HM'),(95,'Honduras','HN'),(96,'Hong Kong','HK'),(97,'Hungary','HU'),(98,'Iceland','IS'),(99,'India','IN'),(100,'Indonesia','ID'),(101,'Iran (Islamic Republic of)','IR'),(102,'Iraq','IQ'),(103,'Ireland','IE'),(104,'Israel','IL'),(105,'Italy','IT'),(106,'Ivory Coast','CI'),(107,'Jamaica','JM'),(108,'Japan','JP'),(109,'Jordan','JO'),(110,'Kazakhstan','KZ'),(111,'Kenya','KE'),(112,'Kiribati','KI'),(113,'Korea, Democratic People\'s Republic of','KP'),(114,'Korea, Republic of','KR'),(115,'Kuwait','KW'),(116,'Kyrgyzstan','KG'),(117,'Laos','LA'),(118,'Latvia','LV'),(119,'Lebanon','LB'),(120,'Lesotho','LS'),(121,'Liberia','LR'),(122,'Libyan Arab Jamahiriya','LY'),(123,'Liechtenstein','LI'),(124,'Lithuania','LT'),(125,'Luxembourg','LU'),(126,'Macau','MO'),(127,'Macedonia','MK'),(128,'Madagascar','MG'),(129,'Malawi','MW'),(130,'Malaysia','MY'),(131,'Maldives','MV'),(132,'Mali','ML'),(133,'Malta','MT'),(134,'Marshall Islands','MH'),(135,'Martinique','MQ'),(136,'Mauritania','MR'),(137,'Mauritius','MU'),(138,'Mayotte','TY'),(139,'Mexico','MX'),(140,'Micronesia, Federated States of','FM'),(141,'Moldova, Republic of','MD'),(142,'Monaco','MC'),(143,'Mongolia','MN'),(144,'Montserrat','MS'),(145,'Morocco','MA'),(146,'Mozambique','MZ'),(147,'Myanmar','MM'),(148,'Namibia','NA'),(149,'Nauru','NR'),(150,'Nepal','NP'),(151,'Netherlands','NL'),(152,'Netherlands Antilles','AN'),(153,'New Caledonia','NC'),(154,'New Zealand','NZ'),(155,'Nicaragua','NI'),(156,'Niger','NE'),(157,'Nigeria','NG'),(158,'Niue','NU'),(159,'Norfork Island','NF'),(160,'Northern Mariana Islands','MP'),(161,'Norway','NO'),(162,'Oman','OM'),(163,'Pakistan','PK'),(164,'Palau','PW'),(165,'Panama','PA'),(166,'Papua New Guinea','PG'),(167,'Paraguay','PY'),(168,'Peru','PE'),(169,'Philippines','PH'),(170,'Pitcairn','PN'),(171,'Poland','PL'),(172,'Portugal','PT'),(173,'Puerto Rico','PR'),(174,'Qatar','QA'),(175,'Reunion','RE'),(176,'Romania','RO'),(177,'Russian Federation','RU'),(178,'Rwanda','RW'),(179,'Saint Kitts and Nevis','KN'),(180,'Saint Lucia','LC'),(181,'Saint Vincent and the Grenadines','VC'),(182,'Samoa','WS'),(183,'San Marino','SM'),(184,'Sao Tome and Principe','ST'),(185,'Saudi Arabia','SA'),(186,'Senegal','SN'),(187,'Seychelles','SC'),(188,'Sierra Leone','SL'),(189,'Singapore','SG'),(190,'Slovakia','SK'),(191,'Slovenia','SI'),(192,'Solomon Islands','SB'),(193,'Somalia','SO'),(194,'South Africa','ZA'),(195,'South Georgia South Sandwich Islands','GS'),(196,'Spain','ES'),(197,'Sri Lanka','LK'),(198,'St. Helena','SH'),(199,'St. Pierre and Miquelon','PM'),(200,'Sudan','SD'),(201,'Suriname','SR'),(202,'Svalbarn and Jan Mayen Islands','SJ'),(203,'Swaziland','SZ'),(204,'Sweden','SE'),(205,'Switzerland','CH'),(206,'Syrian Arab Republic','SY'),(207,'Taiwan','TW'),(208,'Tajikistan','TJ'),(209,'Tanzania, United Republic of','TZ'),(210,'Thailand','TH'),(211,'Togo','TG'),(212,'Tokelau','TK'),(213,'Tonga','TO'),(214,'Trinidad and Tobago','TT'),(215,'Tunisia','TN'),(216,'Turkey','TR'),(217,'Turkmenistan','TM'),(218,'Turks and Caicos Islands','TC'),(219,'Tuvalu','TV'),(220,'Uganda','UG'),(221,'Ukraine','UA'),(222,'United Arab Emirates','AE'),(223,'United Kingdom','GB'),(224,'United States minor outlying islands','UM'),(225,'Uruguay','UY'),(226,'Uzbekistan','UZ'),(227,'Vanuatu','VU'),(228,'Vatican City State','VA'),(229,'Venezuela','VE'),(230,'Vietnam','VN'),(231,'Virigan Islands (British)','VG'),(232,'Virgin Islands (U.S.)','VI'),(233,'Wallis and Futuna Islands','WF'),(234,'Western Sahara','EH'),(235,'Yemen','YE'),(236,'Yugoslavia','YU'),(237,'Zaire','ZR'),(238,'Zambia','ZM'),(239,'Zimbabwe','ZW');

--
-- Table structure for table `credit_cards`
--

CREATE TABLE `credit_cards` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `service_charge` varchar(255) DEFAULT NULL,
  `tax` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `credit_cards`
--

INSERT INTO `credit_cards` VALUES (1,'MasterCard',NULL,'undefined','undefined'),(2,'VISA',NULL,'undefined','undefined'),(3,'Grab',NULL,'undefined','undefined'),(4,'MAE',NULL,'undefined','undefined'),(5,'TNG',NULL,'undefined','undefined');

--
-- Table structure for table `deposit`
--

CREATE TABLE `deposit` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `group` varchar(128) DEFAULT NULL,
  `guest_id` varchar(128) DEFAULT NULL,
  `check_in` date DEFAULT NULL,
  `check_in_by` int(11) DEFAULT NULL,
  `check_out` date DEFAULT NULL,
  `check_out_by` int(11) DEFAULT NULL,
  `rate_type` varchar(100) DEFAULT NULL,
  `agent_type` varchar(100) DEFAULT NULL,
  `deposit_type` varchar(32) DEFAULT NULL,
  `mid` varchar(100) DEFAULT NULL,
  `booking_id` varchar(150) DEFAULT NULL,
  `deposit_amount` decimal(20,2) DEFAULT NULL,
  `transfer_amount` decimal(20,2) DEFAULT NULL,
  `key_deposit_amount` decimal(20,2) DEFAULT NULL,
  `deposit_card_type` varchar(128) DEFAULT NULL,
  `deposit_card_no` varchar(128) DEFAULT NULL,
  `deposit_ref_no` varchar(128) DEFAULT NULL,
  `rate` decimal(20,2) DEFAULT NULL,
  `completed` int(11) DEFAULT NULL,
  `datetime` datetime DEFAULT NULL,
  `room_no` varchar(128) DEFAULT NULL,
  `user` varchar(255) DEFAULT NULL,
  `invoice_id` int(11) DEFAULT NULL,
  `reservation_id` int(11) DEFAULT NULL,
  `void` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `deposit`
--

INSERT INTO `deposit` VALUES (1,'1659539573','1','2022-08-03',NULL,'2022-08-04',10016,'Normal',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,1,NULL,NULL),(2,'1659602736','1','2022-08-04',NULL,'2022-08-05',NULL,'promo_',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'1659602895','1','2022-08-04',NULL,'2022-08-05',NULL,'promo_',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'1659681345','1','2022-08-05',10016,'2022-08-06',NULL,'promo_',NULL,'cash',NULL,NULL,65.00,NULL,0.00,NULL,NULL,NULL,NULL,NULL,'2022-08-05 14:37:29',NULL,NULL,NULL,NULL,NULL),(5,'1659692799','1','2022-08-05',10016,'2022-08-06',NULL,'promo_',NULL,'cash',NULL,NULL,55.00,NULL,50.00,NULL,NULL,NULL,NULL,NULL,'2022-08-05 19:04:45',NULL,NULL,NULL,NULL,NULL),(6,'1659692799','1','2022-08-05',10016,'2022-08-06',NULL,'promo_',NULL,'cash',NULL,NULL,55.00,NULL,50.00,NULL,NULL,NULL,NULL,NULL,'2022-08-05 19:04:45',NULL,NULL,NULL,NULL,NULL),(7,'1659697648','1','2022-08-05',10016,'2022-08-06',NULL,'promo_',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'1659697648','1','2022-08-05',10016,'2022-08-06',NULL,'promo_',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `email_tac`
--

CREATE TABLE `email_tac` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(255) DEFAULT NULL,
  `tac` varchar(6) DEFAULT NULL,
  `datetime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `email_tac`
--


--
-- Table structure for table `expenses`
--

CREATE TABLE `expenses` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` varchar(128) DEFAULT NULL,
  `withdrawn_account_id` varchar(128) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `payment_to` varchar(255) DEFAULT NULL,
  `supplier` varchar(255) DEFAULT NULL,
  `supplier_id` int(11) DEFAULT NULL,
  `memo` varchar(255) DEFAULT NULL,
  `reference_no` varchar(255) DEFAULT NULL,
  `amount` decimal(20,2) DEFAULT NULL,
  `net_amount` decimal(20,2) DEFAULT NULL,
  `tax_amount` decimal(20,2) DEFAULT NULL,
  `tax_included` decimal(20,2) DEFAULT NULL,
  `void` int(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `expenses`
--


--
-- Table structure for table `guest_notes`
--

CREATE TABLE `guest_notes` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `guest_id` int(11) DEFAULT NULL,
  `notes` text,
  `datetime` datetime DEFAULT NULL,
  `added_by` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `guest_notes`
--


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

CREATE TABLE `items` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `pos` int(1) DEFAULT NULL,
  `name` varchar(128) DEFAULT NULL,
  `sku` varchar(128) DEFAULT NULL,
  `description` text,
  `price` decimal(20,2) DEFAULT NULL,
  `promo_price` decimal(20,2) DEFAULT NULL,
  `type` varchar(128) DEFAULT NULL,
  `has_stock` int(1) DEFAULT NULL,
  `qty` int(11) DEFAULT NULL,
  `grooming_addon` int(1) DEFAULT NULL,
  `boarding_addon` int(1) DEFAULT NULL,
  `hide_price` int(1) DEFAULT NULL,
  `price_unit` varchar(128) DEFAULT NULL,
  `cid` int(11) DEFAULT NULL,
  `cost` decimal(20,2) DEFAULT NULL,
  `sort_order` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=54 DEFAULT CHARSET=latin1;

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

INSERT INTO `items` VALUES (49,NULL,'Lion Cut - Short Hair',NULL,NULL,100.00,100.00,'Grooming',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(42,NULL,'Adjustment',NULL,NULL,0.00,0.00,'Adjustment',NULL,-17,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(43,NULL,'Vaccine / Ubat Kutu / Ubat Cacing - Above 4kg',NULL,NULL,85.00,85.00,'Addon',NULL,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(44,NULL,'Ubat Kutu / Ubat Cacing - Above 4kg',NULL,NULL,65.00,65.00,'Addon',NULL,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(45,NULL,'Ubat Kutu / Ubat Cacing - Below 4kg',NULL,NULL,55.00,55.00,'Addon',NULL,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(39,NULL,'Grooming Kitten - Short Hair',NULL,NULL,25.00,20.00,'Grooming',NULL,-6,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(40,NULL,'Grooming Kitten - Long Hair',NULL,NULL,35.00,30.00,'Grooming',NULL,-7,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,NULL,'Grooming Adult - Short Hair',NULL,NULL,50.00,40.00,'Grooming',NULL,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,NULL,'Grooming Adult - Long Hair',NULL,NULL,60.00,50.00,'Grooming',NULL,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(46,NULL,'Vaccine / Ubat Kutu / Ubat Cacing - Below 4kg',NULL,NULL,75.00,75.00,'Addon',NULL,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(47,NULL,'Neutering - Female Cat',NULL,NULL,160.00,160.00,'Addon',NULL,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(48,NULL,'Neutering - Male Cat',NULL,NULL,100.00,100.00,'Addon',NULL,-3,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(50,NULL,'Lion Cut - Long Hair',NULL,NULL,100.00,100.00,'Grooming',NULL,-10,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(51,NULL,'Late Checkout',NULL,NULL,20.00,20.00,'Addon',NULL,19,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(52,NULL,'Membership',NULL,NULL,30.00,30.00,'Membership',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(53,NULL,'Discount',NULL,NULL,0.00,0.00,'Discount',NULL,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `logs`
--

CREATE TABLE `logs` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `module` varchar(255) DEFAULT NULL,
  `table` varchar(255) DEFAULT NULL,
  `record_id` varchar(255) DEFAULT NULL,
  `desc_id` varchar(255) DEFAULT '',
  `description` text,
  `datetime` datetime DEFAULT NULL,
  `performed_by` varchar(255) DEFAULT NULL,
  `data` longtext,
  PRIMARY KEY (`id`),
  KEY `module` (`module`),
  KEY `table` (`table`),
  KEY `record_id` (`record_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `logs`
--


--
-- Table structure for table `payment_link`
--

CREATE TABLE `payment_link` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `group` varchar(128) DEFAULT NULL,
  `datetime` datetime DEFAULT NULL,
  `amount` decimal(20,2) DEFAULT NULL,
  `online_payment_id` varchar(128) DEFAULT NULL,
  `online_payment_data` text,
  `online_payment_completed` int(11) DEFAULT NULL,
  `online_payment_url` varchar(128) DEFAULT NULL,
  `callback_url` varchar(128) DEFAULT NULL,
  `remarks` text,
  `description` text,
  `complete_datetime` datetime DEFAULT NULL,
  `payment_method` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `payment_link`
--


--
-- Table structure for table `payment_voucher_breakdown`
--

CREATE TABLE `payment_voucher_breakdown` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `pv_id` int(11) DEFAULT NULL,
  `datetime` datetime DEFAULT NULL,
  `contact` varchar(128) DEFAULT NULL,
  `contact_id` int(11) DEFAULT NULL,
  `account` text,
  `account_id` int(11) DEFAULT NULL,
  `amount` decimal(20,2) DEFAULT NULL,
  `payment_method` varchar(128) DEFAULT NULL,
  `payment_reference` varchar(128) DEFAULT NULL,
  `status` varchar(128) DEFAULT NULL,
  `description` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `payment_voucher_breakdown`
--


--
-- Table structure for table `payment_voucher_items`
--

CREATE TABLE `payment_voucher_items` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `pv_id` int(11) DEFAULT NULL,
  `account_id` int(11) DEFAULT NULL,
  `account` varchar(128) DEFAULT NULL,
  `po_id` int(11) DEFAULT NULL,
  `cn_id` int(11) DEFAULT NULL,
  `dn_id` int(11) DEFAULT NULL,
  `invoice_id` int(11) DEFAULT NULL,
  `asset_id` int(11) DEFAULT NULL,
  `reference` varchar(128) DEFAULT NULL,
  `contact_id` int(11) DEFAULT NULL,
  `contact` varchar(128) DEFAULT NULL,
  `description` text,
  `datetime` datetime DEFAULT NULL,
  `amount_payable` decimal(20,2) DEFAULT NULL,
  `amount` decimal(20,2) DEFAULT NULL,
  `tax_code` varchar(255) DEFAULT NULL,
  `status` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `payment_voucher_items`
--


--
-- Table structure for table `payment_vouchers`
--

CREATE TABLE `payment_vouchers` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(128) DEFAULT NULL,
  `datetime` datetime DEFAULT NULL,
  `account` varchar(128) DEFAULT NULL,
  `account_id` varchar(128) DEFAULT NULL,
  `contact` varchar(128) DEFAULT NULL,
  `contact_id` int(11) DEFAULT NULL,
  `amount_payable` decimal(20,2) DEFAULT NULL,
  `amount` decimal(20,2) DEFAULT NULL,
  `status` varchar(128) DEFAULT NULL,
  `added_on` datetime DEFAULT NULL,
  `added_by` varchar(128) DEFAULT NULL,
  `void_date` datetime DEFAULT NULL,
  `tax` decimal(20,2) DEFAULT NULL,
  `tax_code` decimal(20,2) DEFAULT NULL,
  `tax_inclusive` int(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10001 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `payment_vouchers`
--


--
-- Table structure for table `payments`
--

CREATE TABLE `payments` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `invoice_id` int(11) DEFAULT NULL,
  `datetime` datetime DEFAULT NULL,
  `amount` decimal(20,2) DEFAULT NULL,
  `method` varchar(255) DEFAULT NULL,
  `reference` varchar(255) DEFAULT NULL,
  `is_deposit` int(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `payments`
--


--
-- Table structure for table `pet_deworm`
--

CREATE TABLE `pet_deworm` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `pet_id` int(11) DEFAULT NULL,
  `deworm_date` date DEFAULT NULL,
  `deworm` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pet_deworm`
--


--
-- Table structure for table `pet_fso`
--

CREATE TABLE `pet_fso` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `pet_id` int(11) DEFAULT NULL,
  `flea_spot_on_date` date DEFAULT NULL,
  `flea_spot_on` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pet_fso`
--


--
-- Table structure for table `pet_notes`
--

CREATE TABLE `pet_notes` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `pet_id` int(11) DEFAULT NULL,
  `notes` text,
  `datetime` datetime DEFAULT NULL,
  `added_by` varchar(128) DEFAULT NULL,
  `public` int(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pet_notes`
--


--
-- Table structure for table `pet_photos`
--

CREATE TABLE `pet_photos` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `pet_id` int(11) DEFAULT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `date` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pet_photos`
--


--
-- Table structure for table `pet_vaccine`
--

CREATE TABLE `pet_vaccine` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `pet_id` int(11) DEFAULT NULL,
  `vaccine_date` date DEFAULT NULL,
  `vaccine_expiry_date` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pet_vaccine`
--


--
-- Table structure for table `pet_vaccine_photos`
--

CREATE TABLE `pet_vaccine_photos` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `pet_id` int(11) DEFAULT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `date` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pet_vaccine_photos`
--


--
-- Table structure for table `pet_weight`
--

CREATE TABLE `pet_weight` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `pet_id` int(11) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `weight` decimal(10,1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pet_weight`
--


--
-- Table structure for table `pets`
--

CREATE TABLE `pets` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `guest_id` int(11) DEFAULT NULL,
  `guest_name` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `breed` varchar(255) DEFAULT NULL,
  `gender` varchar(10) DEFAULT NULL,
  `coat_type` varchar(50) DEFAULT NULL,
  `medical_condition` varchar(255) DEFAULT NULL,
  `flea_spot_on` varchar(255) DEFAULT NULL,
  `flea_spot_on_date` date DEFAULT NULL,
  `neutered` int(1) DEFAULT NULL,
  `color` varchar(255) DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `vaccine_date` date DEFAULT NULL,
  `vaccine_expiry_date` date DEFAULT NULL,
  `roaming_status` varchar(255) DEFAULT NULL,
  `weight` decimal(10,2) DEFAULT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `vcard` varchar(255) DEFAULT NULL,
  `vcard_cover` varchar(255) DEFAULT NULL,
  `behavior` varchar(255) DEFAULT NULL,
  `deworm` varchar(255) DEFAULT NULL,
  `deworm_date` date DEFAULT NULL,
  `remarks` text,
  `guest_remarks` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pets`
--


--
-- Table structure for table `pos_sale_items`
--

CREATE TABLE `pos_sale_items` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `sale_id` int(11) DEFAULT NULL,
  `item_id` int(11) DEFAULT NULL,
  `item_name` varchar(255) DEFAULT NULL,
  `unit_price` decimal(20,2) DEFAULT NULL,
  `qty` int(11) DEFAULT NULL,
  `subtotal` decimal(20,2) DEFAULT NULL,
  `amount` decimal(20,2) DEFAULT NULL,
  `discount` varchar(10) DEFAULT NULL,
  `discount_amount` decimal(20,2) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pos_sale_items`
--


--
-- Table structure for table `pos_sales`
--

CREATE TABLE `pos_sales` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `datetime` datetime DEFAULT NULL,
  `pos_datetime` datetime DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `user` varchar(255) DEFAULT NULL,
  `customer_id` int(11) DEFAULT NULL,
  `customer_name` varchar(255) DEFAULT NULL,
  `payment_method` varchar(20) DEFAULT NULL,
  `payment_type` varchar(20) DEFAULT NULL,
  `tendered_amount` decimal(20,2) DEFAULT NULL,
  `change_amount` decimal(20,2) DEFAULT NULL,
  `amount` decimal(20,2) DEFAULT NULL,
  `rounding` decimal(20,2) DEFAULT NULL,
  `subtotal` decimal(20,2) DEFAULT NULL,
  `tax` decimal(20,2) DEFAULT NULL,
  `discount` varchar(20) DEFAULT NULL,
  `discount_amount` decimal(20,2) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `points` int(11) DEFAULT NULL,
  `void_datetime` datetime DEFAULT NULL,
  `void_by` varchar(255) DEFAULT NULL,
  `void_user_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pos_sales`
--


--
-- Table structure for table `public_holidays`
--

CREATE TABLE `public_holidays` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `description` varchar(255) DEFAULT '',
  `rate_type` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `public_holidays`
--


--
-- Table structure for table `rates`
--

CREATE TABLE `rates` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `category` int(11) DEFAULT NULL,
  `rate` decimal(20,2) DEFAULT NULL,
  `rate_single_first` decimal(20,2) DEFAULT NULL,
  `rate_single` decimal(20,2) DEFAULT NULL,
  `rate_day` decimal(20,2) DEFAULT NULL,
  `weekend_rate_day` decimal(20,2) DEFAULT NULL,
  `weekend_rate` decimal(20,2) DEFAULT NULL,
  `weekend_rate_single_first` decimal(20,2) DEFAULT NULL,
  `weekend_rate_single` decimal(20,2) DEFAULT NULL,
  `agent_rate` decimal(20,2) DEFAULT NULL,
  `agent_weekend_rate` decimal(20,2) DEFAULT NULL,
  `govt_rate` decimal(20,2) DEFAULT NULL,
  `govt_weekend_rate` decimal(20,2) DEFAULT NULL,
  `promo_rate` decimal(20,2) DEFAULT NULL,
  `promo_weekend_rate` decimal(20,2) DEFAULT NULL,
  `promo_rate_single_first` decimal(20,2) DEFAULT NULL,
  `promo_rate_single` decimal(20,2) DEFAULT NULL,
  `promo_rate_day` decimal(20,2) DEFAULT NULL,
  `promo_weekend_rate_single_first` decimal(20,2) DEFAULT NULL,
  `promo_weekend_rate_single` decimal(20,2) DEFAULT NULL,
  `promo_weekend_rate_day` decimal(20,2) DEFAULT NULL,
  `added_on` datetime DEFAULT NULL,
  `added_by` varchar(128) DEFAULT NULL,
  `priority` int(11) DEFAULT NULL,
  `agency` varchar(255) DEFAULT NULL,
  `pet_count` int(11) DEFAULT NULL,
  `agency_id` int(11) DEFAULT NULL,
  `promo_status` int(11) DEFAULT NULL,
  `remarks` text,
  `bulk` int(11) DEFAULT NULL,
  `bulk_discount` varchar(30) DEFAULT NULL,
  `bulk_free` int(11) DEFAULT NULL,
  `peak` int(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `rates`
--

INSERT INTO `rates` VALUES (8,'2022-01-01','2023-12-31',26,55.00,NULL,0.00,0.00,0.00,55.00,NULL,0.00,NULL,NULL,NULL,NULL,40.00,40.00,NULL,0.00,0.00,NULL,0.00,0.00,NULL,NULL,0,NULL,2,NULL,0,'',1,NULL,NULL,NULL),(9,'2022-01-01','2023-12-31',25,80.00,NULL,15.00,0.00,0.00,80.00,NULL,15.00,NULL,NULL,NULL,NULL,60.00,60.00,NULL,15.00,0.00,NULL,15.00,0.00,NULL,NULL,0,NULL,3,NULL,0,'',1,NULL,NULL,NULL);

--
-- Table structure for table `receipt`
--

CREATE TABLE `receipt` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(128) DEFAULT NULL,
  `datetime` datetime DEFAULT NULL,
  `account_id` int(11) DEFAULT NULL,
  `account` varchar(128) DEFAULT NULL,
  `contact_id` int(11) DEFAULT NULL,
  `contact` varchar(128) DEFAULT NULL,
  `cost` decimal(20,2) DEFAULT NULL,
  `amount_receivable` decimal(20,2) DEFAULT NULL,
  `amount` decimal(20,2) DEFAULT NULL,
  `amount_fees` double(20,2) DEFAULT NULL,
  `amount_effective` double(20,2) DEFAULT NULL,
  `status` varchar(128) DEFAULT NULL,
  `added_on` datetime DEFAULT NULL,
  `added_by` varchar(128) DEFAULT NULL,
  `void_date` datetime DEFAULT NULL,
  `tax` decimal(20,2) DEFAULT NULL,
  `tax_code` varchar(32) DEFAULT NULL,
  `tax_inclusive` int(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10001 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `receipt`
--


--
-- Table structure for table `receipt_breakdown`
--

CREATE TABLE `receipt_breakdown` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `receipt_id` int(11) DEFAULT NULL,
  `datetime` datetime DEFAULT NULL,
  `contact` varchar(128) DEFAULT NULL,
  `contact_id` int(11) DEFAULT NULL,
  `account` varchar(128) DEFAULT NULL,
  `account_id` int(11) DEFAULT NULL,
  `amount` decimal(20,2) DEFAULT NULL,
  `amount_fees` decimal(20,2) DEFAULT NULL,
  `amount_effective` double(20,2) DEFAULT NULL,
  `payment_method` varchar(128) DEFAULT NULL,
  `payment_reference` varchar(128) DEFAULT NULL,
  `status` varchar(128) DEFAULT NULL,
  `description` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `receipt_breakdown`
--


--
-- Table structure for table `receipt_items`
--

CREATE TABLE `receipt_items` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `receipt_id` int(11) DEFAULT NULL,
  `account_id` int(11) DEFAULT NULL,
  `account` varchar(128) DEFAULT NULL,
  `po_id` int(11) DEFAULT NULL,
  `cn_id` int(11) DEFAULT NULL,
  `dn_id` int(11) DEFAULT NULL,
  `invoice_id` int(11) DEFAULT NULL,
  `asset_id` int(11) DEFAULT NULL,
  `reference` varchar(128) DEFAULT NULL,
  `contact_id` int(11) DEFAULT NULL,
  `contact` varchar(128) DEFAULT NULL,
  `description` text,
  `datetime` datetime DEFAULT NULL,
  `amount_receivable` decimal(20,2) DEFAULT NULL,
  `amount` decimal(20,2) DEFAULT NULL,
  `status` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `receipt_items`
--


--
-- Table structure for table `receipts`
--

CREATE TABLE `receipts` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `datetime` datetime DEFAULT NULL,
  `room_number` int(11) DEFAULT NULL,
  `checkin_id` int(11) DEFAULT NULL,
  `payment_method` varchar(128) DEFAULT NULL,
  `amount` decimal(20,2) DEFAULT NULL,
  `tax` decimal(20,2) DEFAULT NULL,
  `tax_percentage` varchar(128) DEFAULT NULL,
  `grand_total` decimal(20,2) DEFAULT NULL,
  `tendered` decimal(20,2) DEFAULT NULL,
  `change` decimal(20,2) DEFAULT NULL,
  `card_type` int(11) DEFAULT NULL,
  `reference_no` varchar(128) DEFAULT NULL,
  `staff_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10001 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `receipts`
--


--
-- Table structure for table `reservation_notes`
--

CREATE TABLE `reservation_notes` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `group` varchar(128) DEFAULT NULL,
  `datetime` datetime DEFAULT NULL,
  `note` text,
  `added_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `reservation_notes`
--


--
-- Table structure for table `reservations`
--

CREATE TABLE `reservations` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `prefix` varchar(128) DEFAULT NULL,
  `group` varchar(128) DEFAULT NULL,
  `type` varchar(128) DEFAULT NULL,
  `pets` varchar(255) DEFAULT NULL,
  `pet_names` text,
  `check_in` date DEFAULT NULL,
  `check_out` date DEFAULT NULL,
  `eci_time` varchar(255) DEFAULT NULL,
  `eco_time` varchar(255) DEFAULT NULL,
  `guest_id` int(11) DEFAULT NULL,
  `status` varchar(128) DEFAULT NULL,
  `discount` varchar(128) DEFAULT NULL,
  `discount_amount` decimal(20,2) DEFAULT NULL,
  `subtotal` decimal(20,2) DEFAULT NULL,
  `amount` decimal(20,2) DEFAULT NULL,
  `paid_amount` double(20,2) DEFAULT NULL,
  `deposit_amount` decimal(20,2) DEFAULT NULL,
  `rate_type` varchar(120) DEFAULT NULL,
  `agent_type` varchar(120) DEFAULT NULL,
  `payment_method` varchar(128) DEFAULT NULL,
  `date_transfer` date DEFAULT NULL,
  `ref_no` varchar(100) DEFAULT NULL,
  `mid` varchar(100) DEFAULT NULL,
  `booking_id` varchar(150) DEFAULT NULL,
  `remarks` varchar(128) DEFAULT NULL,
  `room_id` int(11) DEFAULT NULL,
  `room_number` int(11) DEFAULT NULL,
  `cancel_reason` text,
  `category` varchar(255) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `online_payment_id` varchar(255) DEFAULT NULL,
  `online_payment_data` text,
  `online_payment_completed` int(1) DEFAULT NULL,
  `seen` int(1) DEFAULT NULL,
  `channel` varchar(30) DEFAULT NULL,
  `peak` int(1) DEFAULT NULL,
  `reminder` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10027 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `reservations`
--

INSERT INTO `reservations` VALUES (10001,NULL,'16765379887839','BOARDING','[\"313\"]',', ','2023-02-16','2023-02-17',NULL,NULL,1113,'Hold',NULL,NULL,NULL,NULL,NULL,0.00,'promo_',NULL,'hotel',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-02-16 16:59:48',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10002,NULL,'16808247636007','BOARDING','[\"429\"]','Bulan, ','2023-04-07','2023-04-08',NULL,NULL,1002,'Confirmed',NULL,NULL,NULL,293.00,0.00,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-04-07 07:46:03',10016,NULL,NULL,NULL,1,NULL,NULL,NULL),(10003,NULL,'16808539344330','BOARDING','[\"429\"]','Bulan, ','2023-04-07','2023-04-08',NULL,NULL,1002,'Hold',NULL,NULL,NULL,0.00,0.00,20.00,'Normal',NULL,'online',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-04-07 15:52:14',NULL,'plxowfwx',NULL,NULL,NULL,NULL,NULL,NULL),(10004,NULL,'16808540173069','BOARDING','[\"429\"]','Bulan, ','2023-04-07','2023-04-08',NULL,NULL,1002,'Hold',NULL,NULL,NULL,0.00,0.00,20.00,'Normal',NULL,'online',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-04-07 15:53:37',NULL,'oaofise7',NULL,NULL,NULL,NULL,NULL,NULL),(10005,NULL,'16808540524027','BOARDING','[\"429\"]','Bulan, ','2023-04-07','2023-04-08',NULL,NULL,1002,'Hold',NULL,NULL,NULL,0.00,0.00,20.00,'Normal',NULL,'online',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-04-07 15:54:12',NULL,'rzfjnv0k',NULL,NULL,NULL,NULL,NULL,NULL),(10006,NULL,'16808543176975','BOARDING','[\"429\"]','Bulan, ','2023-04-07','2023-04-08',NULL,NULL,1002,'Hold',NULL,NULL,NULL,0.00,0.00,20.00,'Normal',NULL,'online',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-04-07 15:58:37',NULL,'mpqqtddt',NULL,NULL,NULL,NULL,NULL,NULL),(10007,NULL,'16808550147612','BOARDING','[\"429\"]','Bulan, ','2023-04-07','2023-04-08',NULL,NULL,1002,'Confirmed',NULL,NULL,NULL,55.00,20.00,20.00,'Normal',NULL,'online',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-04-07 16:10:14',NULL,'jxuyvmqk','{\"id\":\"jxuyvmqk\",\"collection_id\":\"4y46pxwx\",\"paid\":true,\"state\":\"paid\",\"amount\":2000,\"paid_amount\":2000,\"due_at\":\"2023-4-7\",\"email\":\"shafiq.rizwan@gmail.com\",\"mobile\":null,\"name\":\"SHAFIQ RIZWAN\",\"url\":\"https:\\/\\/www.billplz-sandbox.com\\/bills\\/jxuyvmqk\",\"reference_1_label\":\"Reference 1\",\"reference_1\":null,\"reference_2_label\":\"Reference 2\",\"reference_2\":null,\"redirect_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10007\\/branch1\",\"callback_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10007\\/branch1\",\"description\":\" Reservation BKG-10007 Deposit\",\"paid_at\":\"2023-04-07T16:10:26.442+08:00\"}',1,NULL,NULL,NULL,NULL),(10008,'BKG-B-','16808551499790','BOARDING','[\"429\"]','Bulan, ','2023-04-07','2023-04-08',NULL,NULL,1002,'Confirmed',NULL,NULL,NULL,55.00,50.00,50.00,'Normal',NULL,'online',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-04-07 16:12:30',NULL,'ymzeotow','{\"id\":\"ymzeotow\",\"collection_id\":\"4y46pxwx\",\"paid\":true,\"state\":\"paid\",\"amount\":5000,\"paid_amount\":5000,\"due_at\":\"2023-4-7\",\"email\":\"shafiq.rizwan@gmail.com\",\"mobile\":null,\"name\":\"SHAFIQ RIZWAN\",\"url\":\"https:\\/\\/www.billplz-sandbox.com\\/bills\\/ymzeotow\",\"reference_1_label\":\"Reference 1\",\"reference_1\":null,\"reference_2_label\":\"Reference 2\",\"reference_2\":null,\"redirect_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10008\\/branch1\",\"callback_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10008\\/branch1\",\"description\":\" Reservation BKG-10008 Deposit\",\"paid_at\":\"2023-04-07T16:12:55.294+08:00\"}',1,NULL,NULL,NULL,NULL),(10009,'BKG-B-','16808565363259','BOARDING','[\"429\"]','Bulan, ','2023-04-07','2023-04-08',NULL,NULL,1002,'Confirmed',NULL,NULL,NULL,55.00,20.00,20.00,'Normal',NULL,'online',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-04-07 16:35:36',NULL,'phpqhkm3','{\"id\":\"phpqhkm3\",\"collection_id\":\"4y46pxwx\",\"paid\":true,\"state\":\"paid\",\"amount\":2000,\"paid_amount\":2000,\"due_at\":\"2023-4-7\",\"email\":\"shafiq.rizwan@gmail.com\",\"mobile\":null,\"name\":\"SHAFIQ RIZWAN\",\"url\":\"https:\\/\\/www.billplz-sandbox.com\\/bills\\/phpqhkm3\",\"reference_1_label\":\"Reference 1\",\"reference_1\":null,\"reference_2_label\":\"Reference 2\",\"reference_2\":null,\"redirect_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10009\\/branch1\",\"callback_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10009\\/branch1\",\"description\":\" Reservation BKG-B-10009 Deposit\",\"paid_at\":\"2023-04-07T16:35:59.659+08:00\"}',1,NULL,NULL,NULL,NULL),(10010,'BKG-B-','16808572032411','BOARDING','[\"429\"]','Bulan, ','2023-04-07','2023-04-08',NULL,NULL,1002,'Confirmed',NULL,NULL,NULL,55.00,5.00,5.00,'Normal',NULL,'online',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-04-07 16:46:43',NULL,'tdxq015q','{\"id\":\"tdxq015q\",\"collection_id\":\"4y46pxwx\",\"paid\":true,\"state\":\"paid\",\"amount\":500,\"paid_amount\":500,\"due_at\":\"2023-4-7\",\"email\":\"shafiq.rizwan@gmail.com\",\"mobile\":null,\"name\":\"SHAFIQ RIZWAN\",\"url\":\"https:\\/\\/www.billplz-sandbox.com\\/bills\\/tdxq015q\",\"reference_1_label\":\"Reference 1\",\"reference_1\":null,\"reference_2_label\":\"Reference 2\",\"reference_2\":null,\"redirect_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10010\\/branch1\",\"callback_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10010\\/branch1\",\"description\":\" Reservation BKG-B-10010 Deposit\",\"paid_at\":\"2023-04-07T16:46:53.011+08:00\"}',1,NULL,NULL,NULL,NULL),(10011,'BKG-B-','16808574153480','BOARDING','[\"429\"]','Bulan, ','2023-04-07','2023-04-08',NULL,NULL,1002,'Confirmed',NULL,NULL,NULL,55.00,40.00,20.00,'Normal',NULL,'online',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-04-07 16:50:16',NULL,'8fqvgd8o','{\"id\":\"8fqvgd8o\",\"collection_id\":\"4y46pxwx\",\"paid\":true,\"state\":\"paid\",\"amount\":2000,\"paid_amount\":2000,\"due_at\":\"2023-4-7\",\"email\":\"shafiq.rizwan@gmail.com\",\"mobile\":null,\"name\":\"SHAFIQ RIZWAN\",\"url\":\"https:\\/\\/www.billplz-sandbox.com\\/bills\\/8fqvgd8o\",\"reference_1_label\":\"Reference 1\",\"reference_1\":null,\"reference_2_label\":\"Reference 2\",\"reference_2\":null,\"redirect_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10011\\/branch1\",\"callback_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10011\\/branch1\",\"description\":\" Reservation BKG-B-10011 Deposit\",\"paid_at\":\"2023-04-07T16:50:30.602+08:00\"}',1,NULL,NULL,NULL,NULL),(10012,'BKG-B-','16808575375687','BOARDING','[\"429\"]','Bulan, ','2023-04-07','2023-04-08',NULL,NULL,1002,'Confirmed',NULL,NULL,NULL,55.00,20.00,20.00,'Normal',NULL,'online',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-04-07 16:52:17',NULL,'6hrgqgs8','{\"id\":\"6hrgqgs8\",\"collection_id\":\"4y46pxwx\",\"paid\":true,\"state\":\"paid\",\"amount\":2000,\"paid_amount\":2000,\"due_at\":\"2023-4-7\",\"email\":\"shafiq.rizwan@gmail.com\",\"mobile\":null,\"name\":\"SHAFIQ RIZWAN\",\"url\":\"https:\\/\\/www.billplz-sandbox.com\\/bills\\/6hrgqgs8\",\"reference_1_label\":\"Reference 1\",\"reference_1\":null,\"reference_2_label\":\"Reference 2\",\"reference_2\":null,\"redirect_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10012\\/branch1\",\"callback_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10012\\/branch1\",\"description\":\" Reservation BKG-B-10012 Deposit\",\"paid_at\":\"2023-04-07T16:52:27.593+08:00\"}',1,NULL,NULL,NULL,NULL),(10013,'BKG-B-','16860407374801','BOARDING','[\"429\"]',NULL,'2023-06-09','2023-06-10',NULL,NULL,1002,'Confirmed',NULL,0.00,115.00,115.00,20.00,20.00,'promo_',NULL,'online',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-06-06 16:38:57',NULL,'ewodldjz','{\"id\":\"ewodldjz\",\"collection_id\":\"4y46pxwx\",\"paid\":true,\"state\":\"paid\",\"amount\":2000,\"paid_amount\":2000,\"due_at\":\"2023-6-6\",\"email\":\"shafiq.rizwan@gmail.com\",\"mobile\":null,\"name\":\"SHAFIQ RIZWAN\",\"url\":\"https:\\/\\/www.billplz-sandbox.com\\/bills\\/ewodldjz\",\"reference_1_label\":\"Reference 1\",\"reference_1\":null,\"reference_2_label\":\"Reference 2\",\"reference_2\":null,\"redirect_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_redirect\\/10013\\/branch1\",\"callback_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10013\\/branch1\",\"description\":\" Reservation BKG-B-10013 Deposit\",\"paid_at\":\"2023-06-06T16:39:08.235+08:00\"}',1,NULL,NULL,NULL,NULL),(10014,'BKG-B-','16861146875459','GROOMING','[\"429\",\"430\"]',NULL,'2023-06-09','2023-06-09',NULL,NULL,1002,'Confirmed',NULL,0.00,0.00,0.00,0.00,5.00,'promo_',NULL,'online',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-06-07 13:11:27',NULL,'ygfgsqeb','{\"id\":\"ygfgsqeb\",\"collection_id\":\"4y46pxwx\",\"paid\":true,\"state\":\"paid\",\"amount\":500,\"paid_amount\":500,\"due_at\":\"2023-6-7\",\"email\":\"shafiq.rizwan@gmail.com\",\"mobile\":null,\"name\":\"SHAFIQ RIZWAN\",\"url\":\"https:\\/\\/www.billplz-sandbox.com\\/bills\\/ygfgsqeb\",\"reference_1_label\":\"Reference 1\",\"reference_1\":null,\"reference_2_label\":\"Reference 2\",\"reference_2\":null,\"redirect_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_redirect\\/10014\\/branch1\",\"callback_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10014\\/branch1\",\"description\":\" Reservation BKG-B-10014 Deposit\",\"paid_at\":\"2023-06-07T13:11:39.877+08:00\"}',1,NULL,NULL,NULL,NULL),(10015,'BKG-B-','16861161054414','GROOMING','[\"429\"]',NULL,'2023-06-12','2023-06-12',NULL,NULL,1002,'Confirmed',NULL,0.00,100.00,100.00,20.00,20.00,'promo_',NULL,'online',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-06-07 13:35:05',NULL,'mhmaypac','{\"id\":\"mhmaypac\",\"collection_id\":\"4y46pxwx\",\"paid\":true,\"state\":\"paid\",\"amount\":2000,\"paid_amount\":2000,\"due_at\":\"2023-6-7\",\"email\":\"shafiq.rizwan@gmail.com\",\"mobile\":null,\"name\":\"SHAFIQ RIZWAN\",\"url\":\"https:\\/\\/www.billplz-sandbox.com\\/bills\\/mhmaypac\",\"reference_1_label\":\"Reference 1\",\"reference_1\":null,\"reference_2_label\":\"Reference 2\",\"reference_2\":null,\"redirect_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_redirect\\/10015\\/branch1\",\"callback_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10015\\/branch1\",\"description\":\" Reservation BKG-B-10015 Deposit\",\"paid_at\":\"2023-06-07T13:38:44.545+08:00\"}',1,NULL,NULL,NULL,NULL),(10016,'BKG-B-','16861176426986','GROOMING','[\"429\"]',NULL,'2023-06-11','2023-06-11',NULL,NULL,1002,'Confirmed',NULL,0.00,100.00,100.00,5.00,5.00,'promo_',NULL,'online',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-06-07 14:00:42',NULL,'duql26ve','{\"id\":\"duql26ve\",\"collection_id\":\"4y46pxwx\",\"paid\":true,\"state\":\"paid\",\"amount\":500,\"paid_amount\":500,\"due_at\":\"2023-6-7\",\"email\":\"shafiq.rizwan@gmail.com\",\"mobile\":null,\"name\":\"SHAFIQ RIZWAN\",\"url\":\"https:\\/\\/www.billplz-sandbox.com\\/bills\\/duql26ve\",\"reference_1_label\":\"Reference 1\",\"reference_1\":null,\"reference_2_label\":\"Reference 2\",\"reference_2\":null,\"redirect_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_redirect\\/10016\\/branch1\",\"callback_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10016\\/branch1\",\"description\":\" Reservation BKG-B-10016 Deposit\",\"paid_at\":\"2023-06-07T14:00:52.990+08:00\"}',1,NULL,NULL,NULL,NULL),(10017,'BKG-B-','16866361541381','GROOMING','[\"429\"]',NULL,'2023-06-13','2023-06-13',NULL,NULL,1002,'Confirmed',NULL,0.00,100.00,100.00,20.00,20.00,'promo_',NULL,'online',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-06-13 14:02:34',NULL,'suc2hq09','{\"id\":\"suc2hq09\",\"collection_id\":\"4y46pxwx\",\"paid\":true,\"state\":\"paid\",\"amount\":2000,\"paid_amount\":2000,\"due_at\":\"2023-6-13\",\"email\":\"shafiq.rizwan@gmail.com\",\"mobile\":null,\"name\":\"SHAFIQ RIZWAN\",\"url\":\"https:\\/\\/www.billplz-sandbox.com\\/bills\\/suc2hq09\",\"reference_1_label\":\"Reference 1\",\"reference_1\":null,\"reference_2_label\":\"Reference 2\",\"reference_2\":null,\"redirect_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_redirect\\/10017\\/branch1\",\"callback_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10017\\/branch1\",\"description\":\" Reservation BKG-B-10017 Deposit\",\"paid_at\":\"2023-06-13T14:02:44.551+08:00\"}',1,NULL,NULL,NULL,NULL),(10018,'BKG-B-','16866363412818','BOARDING','[\"429\"]',NULL,'2023-06-17','2023-06-18',NULL,NULL,1002,'Confirmed',NULL,0.00,40.00,40.00,20.00,20.00,'promo_',NULL,'online',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-06-13 14:05:41',NULL,'qv1jutz4','{\"id\":\"qv1jutz4\",\"collection_id\":\"4y46pxwx\",\"paid\":true,\"state\":\"paid\",\"amount\":2000,\"paid_amount\":2000,\"due_at\":\"2023-6-13\",\"email\":\"shafiq.rizwan@gmail.com\",\"mobile\":null,\"name\":\"SHAFIQ RIZWAN\",\"url\":\"https:\\/\\/www.billplz-sandbox.com\\/bills\\/qv1jutz4\",\"reference_1_label\":\"Reference 1\",\"reference_1\":null,\"reference_2_label\":\"Reference 2\",\"reference_2\":null,\"redirect_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_redirect\\/10018\\/branch1\",\"callback_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10018\\/branch1\",\"description\":\" Reservation BKG-B-10018 Deposit\",\"paid_at\":\"2023-06-13T14:05:52.074+08:00\"}',1,NULL,NULL,NULL,NULL),(10019,'BKG-B-','16866363885473','GROOMING','[\"429\"]',NULL,'2023-06-17','2023-06-17',NULL,NULL,1002,'Confirmed',NULL,0.00,100.00,100.00,20.00,20.00,'promo_',NULL,'online',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-06-13 14:06:28',NULL,'wccmaxxi','{\"id\":\"wccmaxxi\",\"collection_id\":\"4y46pxwx\",\"paid\":true,\"state\":\"paid\",\"amount\":2000,\"paid_amount\":2000,\"due_at\":\"2023-6-13\",\"email\":\"shafiq.rizwan@gmail.com\",\"mobile\":null,\"name\":\"SHAFIQ RIZWAN\",\"url\":\"https:\\/\\/www.billplz-sandbox.com\\/bills\\/wccmaxxi\",\"reference_1_label\":\"Reference 1\",\"reference_1\":null,\"reference_2_label\":\"Reference 2\",\"reference_2\":null,\"redirect_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_redirect\\/10019\\/branch1\",\"callback_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10019\\/branch1\",\"description\":\" Reservation BKG-B-10019 Deposit\",\"paid_at\":\"2023-06-13T14:06:39.877+08:00\"}',1,NULL,NULL,NULL,NULL),(10020,'BKG-B-','16868986915038','GROOMING','[\"429\"]',NULL,'2023-06-16','2023-06-16',NULL,NULL,1002,'Confirmed',NULL,0.00,100.00,100.00,20.00,20.00,'promo_',NULL,'online',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-06-16 14:58:11',NULL,'vicsracn','{\"id\":\"vicsracn\",\"collection_id\":\"4y46pxwx\",\"paid\":true,\"state\":\"paid\",\"amount\":2000,\"paid_amount\":2000,\"due_at\":\"2023-6-16\",\"email\":\"shafiq.rizwan@gmail.com\",\"mobile\":null,\"name\":\"SHAFIQ RIZWAN\",\"url\":\"https:\\/\\/www.billplz-sandbox.com\\/bills\\/vicsracn\",\"reference_1_label\":\"Reference 1\",\"reference_1\":null,\"reference_2_label\":\"Reference 2\",\"reference_2\":null,\"redirect_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_redirect\\/10020\\/branch1\",\"callback_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10020\\/branch1\",\"description\":\" Reservation BKG-B-10020 Deposit\",\"paid_at\":\"2023-06-16T14:58:22.190+08:00\"}',1,NULL,NULL,NULL,NULL),(10021,'BKG-B-','16868988606839','GROOMING','[\"429\"]',NULL,'2023-06-16','2023-06-16',NULL,NULL,1002,'Confirmed',NULL,0.00,100.00,100.00,20.00,20.00,'promo_',NULL,'online',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-06-16 15:01:00',NULL,'xrbpob6p','{\"id\":\"xrbpob6p\",\"collection_id\":\"4y46pxwx\",\"paid\":true,\"state\":\"paid\",\"amount\":2000,\"paid_amount\":2000,\"due_at\":\"2023-6-16\",\"email\":\"shafiq.rizwan@gmail.com\",\"mobile\":null,\"name\":\"SHAFIQ RIZWAN\",\"url\":\"https:\\/\\/www.billplz-sandbox.com\\/bills\\/xrbpob6p\",\"reference_1_label\":\"Reference 1\",\"reference_1\":null,\"reference_2_label\":\"Reference 2\",\"reference_2\":null,\"redirect_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_redirect\\/10021\\/branch1\",\"callback_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10021\\/branch1\",\"description\":\" Reservation BKG-B-10021 Deposit\",\"paid_at\":\"2023-06-16T15:01:17.571+08:00\"}',1,NULL,NULL,NULL,NULL),(10022,'BKG-B-','16869002285121','GROOMING','[\"429\"]',NULL,'2023-06-17','2023-06-17',NULL,NULL,1002,'Confirmed',NULL,0.00,175.00,175.00,20.00,20.00,'promo_',NULL,'online',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-06-16 15:23:48',NULL,'doiojjuh','{\"id\":\"doiojjuh\",\"collection_id\":\"4y46pxwx\",\"paid\":true,\"state\":\"paid\",\"amount\":2000,\"paid_amount\":2000,\"due_at\":\"2023-6-16\",\"email\":\"shafiq.rizwan@gmail.com\",\"mobile\":null,\"name\":\"SHAFIQ RIZWAN\",\"url\":\"https:\\/\\/www.billplz-sandbox.com\\/bills\\/doiojjuh\",\"reference_1_label\":\"Reference 1\",\"reference_1\":null,\"reference_2_label\":\"Reference 2\",\"reference_2\":null,\"redirect_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_redirect\\/10022\\/branch1\",\"callback_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10022\\/branch1\",\"description\":\" Reservation BKG-B-10022 Deposit\",\"paid_at\":\"2023-06-16T15:24:00.900+08:00\"}',1,NULL,NULL,NULL,NULL),(10023,'BKG-B-','16885237267344','GROOMING','[\"429\"]',NULL,'2023-07-06','2023-07-06',NULL,NULL,1002,'Confirmed',NULL,0.00,185.00,185.00,5.00,5.00,'promo_',NULL,'online',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-07-05 10:22:06',NULL,'uyt0i0lm','{\"id\":\"uyt0i0lm\",\"collection_id\":\"4y46pxwx\",\"paid\":true,\"state\":\"paid\",\"amount\":500,\"paid_amount\":500,\"due_at\":\"2023-7-5\",\"email\":\"shafiq.rizwan@gmail.com\",\"mobile\":null,\"name\":\"SHAFIQ RIZWAN\",\"url\":\"https:\\/\\/www.billplz-sandbox.com\\/bills\\/uyt0i0lm\",\"reference_1_label\":\"Reference 1\",\"reference_1\":null,\"reference_2_label\":\"Reference 2\",\"reference_2\":null,\"redirect_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_redirect\\/10023\\/branch1\",\"callback_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10023\\/branch1\",\"description\":\" Reservation BKG-B-10023 Deposit\",\"paid_at\":\"2023-07-05T10:22:19.465+08:00\"}',1,NULL,NULL,NULL,NULL),(10024,'BKG-B-','16891417755218','BOARDING','[\"429\"]',NULL,'2023-07-12','2023-07-13','12:00 PM','12:00 PM',1002,'Confirmed',NULL,0.00,320.00,320.00,70.00,NULL,'promo_',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-07-12 14:02:55',10016,NULL,NULL,NULL,1,NULL,NULL,NULL),(10025,'BKG-B-','16891417755218','BOARDING','[\"429\"]',NULL,'2023-07-12','2023-07-13','12:00 PM','12:00 PM',1002,'Confirmed',NULL,0.00,320.00,320.00,70.00,NULL,'promo_',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-07-12 14:02:55',10016,NULL,NULL,NULL,1,NULL,NULL,NULL),(10026,'BKG-B-','16892045127887','BOARDING','[\"453\"]',NULL,'2023-07-13','2023-07-14','12:00 PM','12:00 PM',1002,'Confirmed',NULL,0.00,185.00,185.00,70.00,NULL,'promo_',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-07-13 07:28:32',10016,NULL,NULL,NULL,1,NULL,NULL,NULL);

--
-- Table structure for table `rooms`
--

CREATE TABLE `rooms` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `category` int(11) DEFAULT NULL,
  `floor` int(3) DEFAULT NULL,
  `number` varchar(128) DEFAULT NULL,
  `rsvn_id` int(11) DEFAULT NULL,
  `guest_id` int(11) DEFAULT NULL,
  `check_in` date DEFAULT NULL,
  `check_out` date DEFAULT NULL,
  `added_on` datetime DEFAULT NULL,
  `added_by` varchar(128) DEFAULT NULL,
  `status` varchar(128) DEFAULT NULL,
  `modified_on` datetime DEFAULT NULL,
  `modified_by` varchar(128) DEFAULT NULL,
  `housekeeping_status` varchar(128) DEFAULT NULL,
  `maintenance_status` varchar(128) DEFAULT NULL,
  `wakeup_call` time DEFAULT '00:00:00',
  `remarks` text,
  `grooming` varchar(3) DEFAULT NULL,
  `pos_left` varchar(10) DEFAULT NULL,
  `pos_top` varchar(10) DEFAULT NULL,
  `sort_order` int(5) DEFAULT NULL,
  `time` time DEFAULT NULL,
  `days` varchar(50) DEFAULT NULL,
  `exclude` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=133 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `rooms`
--

INSERT INTO `rooms` VALUES (118,24,0,'54',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(117,24,0,'53',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(116,24,0,'52',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(115,24,0,'51',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(114,24,0,'50',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(113,25,0,'64',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(112,25,0,'63',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(111,25,0,'62',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(110,25,0,'61',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(109,25,0,'49',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(108,25,0,'48',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(107,25,0,'47',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(106,25,0,'46',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(105,25,0,'45',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(104,25,0,'44',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(103,25,0,'43',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(102,25,0,'42',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(101,25,0,'41',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(100,25,0,'40',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(99,26,0,'39',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Cleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(98,26,0,'38',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(97,26,0,'37',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(96,26,0,'36',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(95,26,0,'35',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(94,26,0,'34',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Cleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(93,26,0,'33',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Cleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(92,26,0,'32',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(91,26,0,'31',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Cleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(90,26,0,'30',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(89,26,0,'29',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(88,26,0,'28',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(87,26,0,'27',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(86,26,0,'26',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(85,26,0,'25',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Cleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(84,26,0,'24',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(83,26,0,'23',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(82,26,0,'22',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Cleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(81,26,0,'21',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(80,26,0,'20',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(79,26,0,'19',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(78,26,0,'18',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(77,26,0,'17',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(76,26,0,'16',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(75,26,0,'15',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Cleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(74,26,0,'14',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(73,26,0,'13',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(72,26,0,'12',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(71,26,0,'11',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(70,26,0,'10',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(69,26,0,'9',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(68,26,0,'8',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(67,26,0,'7',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Cleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(66,26,0,'6',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(65,26,0,'5',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(64,26,0,'4',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(63,26,0,'3',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(62,26,0,'2',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(61,26,0,'1',NULL,NULL,NULL,NULL,NULL,'','Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(119,24,0,'55',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(120,27,0,'72',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Cleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(121,27,0,'73',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Cleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(122,25,0,'99',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Cleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(123,0,NULL,'11:00AM',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,'1',NULL,NULL,NULL,'11:00:00','SUN,MON,TUE,WED,THU,FRI,SAT',NULL),(124,0,NULL,'12:30PM',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,'1',NULL,NULL,NULL,NULL,'SUN,MON,TUE,WED,THU,FRI,SAT',NULL),(125,0,NULL,'2:00PM',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,'1',NULL,NULL,NULL,'14:00:00',NULL,NULL),(126,NULL,NULL,'3:30PM',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL),(127,NULL,NULL,'5:00PM',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL),(128,28,0,'70',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(129,NULL,NULL,'SLOT 1',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL),(130,NULL,NULL,'SLOT 2',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL),(131,NULL,NULL,'SLOT 3',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL),(132,1,0,'6:00PM',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `signature`
--

CREATE TABLE `signature` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `rsvn_id` int(11) DEFAULT NULL,
  `signature` longtext,
  `nric` varchar(40) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=186 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `signature`
--

INSERT INTO `signature` VALUES (26,10055,'data:image/png;base64,[BLOB]','1'),(30,10001,'data:image/png;base64,[BLOB]',''),(31,10002,'data:image/png;base64,[BLOB]',''),(32,10003,'data:image/png;base64,[BLOB]',''),(33,10004,'data:image/png;base64,[BLOB]',''),(34,10005,'data:image/png;base64,[BLOB]',''),(35,10006,'data:image/png;base64,[BLOB]',''),(36,10007,'data:image/png;base64,[BLOB]',''),(37,10018,'data:image/png;base64,[BLOB]',''),(38,10022,'data:image/png;base64,[BLOB]',''),(39,10035,'data:image/png;base64,[BLOB]',''),(40,10029,'data:image/png;base64,[BLOB]',''),(41,10037,'data:image/png;base64,[BLOB]',''),(42,10008,'data:image/png;base64,[BLOB]',''),(43,10043,'data:image/png;base64,[BLOB]',''),(44,10019,'data:image/png;base64,[BLOB]',''),(45,10047,'data:image/png;base64,[BLOB]',''),(46,10046,'data:image/png;base64,[BLOB]',''),(47,10050,'data:image/png;base64,[BLOB]',''),(48,10051,'data:image/png;base64,[BLOB]',''),(49,10040,'data:image/png;base64,[BLOB]',''),(50,10063,'data:image/png;base64,[BLOB]',''),(51,10062,'data:image/png;base64,[BLOB]',''),(52,10032,'data:image/png;base64,[BLOB]',''),(53,10048,'data:image/png;base64,[BLOB]',''),(54,10045,'data:image/png;base64,[BLOB]',''),(55,10065,'data:image/png;base64,[BLOB]',''),(56,10066,'data:image/png;base64,[BLOB]',''),(57,10056,'data:image/png;base64,[BLOB]',''),(58,10068,'data:image/png;base64,[BLOB]',''),(59,10070,'data:image/png;base64,[BLOB]',''),(60,10069,'data:image/png;base64,[BLOB]',''),(61,10071,'data:image/png;base64,[BLOB]',''),(62,10074,'data:image/png;base64,[BLOB]',''),(63,10072,'data:image/png;base64,[BLOB]',''),(64,10020,'data:image/png;base64,[BLOB]',''),(65,10073,'data:image/png;base64,[BLOB]',''),(66,10080,'data:image/png;base64,[BLOB]',''),(69,10079,'data:image/png;base64,[BLOB]',''),(70,10081,'data:image/png;base64,[BLOB]',''),(71,10082,'data:image/png;base64,[BLOB]',''),(72,10084,'data:image/png;base64,[BLOB]',''),(73,10083,'data:image/png;base64,[BLOB]',''),(74,10088,'data:image/png;base64,[BLOB]',''),(75,10031,'data:image/png;base64,[BLOB]',''),(76,10042,'data:image/png;base64,[BLOB]',''),(77,10095,'data:image/png;base64,[BLOB]',''),(78,10075,'data:image/png;base64,[BLOB]',''),(79,10036,'data:image/png;base64,[BLOB]',''),(80,10034,'data:image/png;base64,[BLOB]',''),(81,10049,'data:image/png;base64,[BLOB]',''),(82,10096,'data:image/png;base64,[BLOB]',''),(83,10097,'data:image/png;base64,[BLOB]',''),(84,10107,'data:image/png;base64,[BLOB]',''),(85,10108,'data:image/png;base64,[BLOB]',''),(86,10105,'data:image/png;base64,[BLOB]',''),(87,10076,'data:image/png;base64,[BLOB]',''),(88,10110,'data:image/png;base64,[BLOB]',''),(89,10111,'data:image/png;base64,[BLOB]',''),(90,10086,'data:image/png;base64,[BLOB]',''),(91,10112,'data:image/png;base64,[BLOB]',''),(92,10113,'data:image/png;base64,[BLOB]',''),(93,10090,'data:image/png;base64,[BLOB]',''),(94,10115,'data:image/png;base64,[BLOB]',''),(95,10118,'data:image/png;base64,[BLOB]',''),(96,10117,'data:image/png;base64,[BLOB]',''),(97,10119,'data:image/png;base64,[BLOB]',''),(98,10121,'data:image/png;base64,[BLOB]',''),(99,10123,'data:image/png;base64,[BLOB]',''),(100,10124,'data:image/png;base64,[BLOB]',''),(101,10120,'data:image/png;base64,[BLOB]',''),(102,10125,'data:image/png;base64,[BLOB]',''),(103,10109,'data:image/png;base64,[BLOB]',''),(104,10126,'data:image/png;base64,[BLOB]',''),(105,10104,'data:image/png;base64,[BLOB]',''),(106,10127,'data:image/png;base64,[BLOB]',''),(107,10116,'data:image/png;base64,[BLOB]',''),(108,10135,'data:image/png;base64,[BLOB]',''),(109,10137,'data:image/png;base64,[BLOB]',''),(110,10144,'data:image/png;base64,[BLOB]',''),(111,10146,'data:image/png;base64,[BLOB]',''),(112,10148,'data:image/png;base64,[BLOB]',''),(113,10147,'data:image/png;base64,[BLOB]',''),(114,10138,'data:image/png;base64,[BLOB]',''),(115,10143,'data:image/png;base64,[BLOB]',''),(116,10150,'data:image/png;base64,[BLOB]',''),(117,10155,'data:image/png;base64,[BLOB]',''),(118,10131,'data:image/png;base64,[BLOB]',''),(119,10114,'data:image/png;base64,[BLOB]',''),(120,10106,'data:image/png;base64,[BLOB]',''),