-- 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=140 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,'460','180',60,NULL,NULL,NULL),(117,24,0,'53',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'460','100',59,NULL,NULL,NULL),(116,24,0,'52',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'460','260',58,NULL,NULL,NULL),(115,24,0,'51',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'380','260',57,NULL,NULL,NULL),(114,24,0,'50',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'380','180',56,NULL,NULL,NULL),(113,25,0,'64',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'780','20',41,NULL,NULL,NULL),(112,25,0,'63',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'640','20',42,NULL,NULL,NULL),(111,25,0,'62',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'580','20',43,NULL,NULL,NULL),(110,25,0,'61',NULL,1002,'2023-07-06','2023-07-07',NULL,NULL,'Checked In',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'580','100',44,NULL,NULL,NULL),(109,25,0,'49',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'380','100',45,NULL,NULL,NULL),(108,25,0,'48',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'380','20',46,NULL,NULL,NULL),(107,25,0,'47',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'320','10',47,NULL,NULL,NULL),(106,25,0,'46',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'320','100',48,NULL,NULL,NULL),(105,25,0,'45',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'320','180',49,NULL,NULL,NULL),(104,25,0,'44',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'320','260',50,NULL,NULL,NULL),(103,25,0,'43',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'220','260',51,NULL,NULL,NULL),(102,25,0,'42',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'220','180',52,NULL,NULL,NULL),(101,25,0,'41',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'180','90',53,NULL,NULL,NULL),(100,25,0,'40',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'180','10',54,NULL,NULL,NULL),(99,26,0,'39',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Cleaned','Operational','00:00:00',NULL,NULL,'120','10',4,NULL,NULL,NULL),(98,26,0,'38',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'120','90',7,NULL,NULL,NULL),(97,26,0,'37',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'160','180',5,NULL,NULL,NULL),(96,32,0,'36',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'160','260',2,NULL,NULL,NULL),(95,26,0,'35',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'580','180',3,NULL,NULL,NULL),(94,26,0,'34',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Cleaned','Operational','00:00:00',NULL,NULL,'1180','10',6,NULL,NULL,NULL),(93,26,0,'33',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'1180','90',8,NULL,NULL,NULL),(92,26,0,'32',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'1180','170',9,NULL,NULL,NULL),(91,26,0,'31',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Cleaned','Operational','00:00:00',NULL,NULL,'1180','250',10,NULL,NULL,NULL),(90,26,0,'30',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'1060','250',11,NULL,NULL,NULL),(89,26,0,'29',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'640','170',12,NULL,NULL,NULL),(88,26,0,'28',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'780','180',13,NULL,NULL,NULL),(87,26,0,'27',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'1060','170',14,NULL,NULL,NULL),(86,26,0,'26',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'1060','90',15,NULL,NULL,NULL),(85,26,0,'25',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Cleaned','Operational','00:00:00',NULL,NULL,'1060','10',16,NULL,NULL,NULL),(84,26,0,'24',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'1000','10',17,NULL,NULL,NULL),(83,26,0,'23',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'1000','90',18,NULL,NULL,NULL),(82,26,0,'22',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Cleaned','Operational','00:00:00',NULL,NULL,'1000','170',19,NULL,NULL,NULL),(81,26,0,'21',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'1000','240',20,NULL,NULL,NULL),(80,26,0,'20',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'160','380',21,NULL,NULL,NULL),(79,26,0,'19',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'220','380',22,NULL,NULL,NULL),(78,26,0,'18',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'320','380',23,NULL,NULL,NULL),(77,26,0,'17',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'380','380',24,NULL,NULL,NULL),(76,26,0,'16',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'460','380',25,NULL,NULL,NULL),(75,26,0,'15',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Cleaned','Operational','00:00:00',NULL,NULL,'740','400',40,NULL,NULL,NULL),(74,26,0,'14',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'580','380',39,NULL,NULL,NULL),(73,26,0,'13',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'1060','370',38,NULL,NULL,NULL),(72,26,0,'12',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'580','250',37,NULL,NULL,NULL),(71,26,0,'11',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'1000','370',36,NULL,NULL,NULL),(70,26,0,'10',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'1180','370',35,NULL,NULL,NULL),(69,26,0,'9',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'640','250',34,NULL,NULL,NULL),(68,26,0,'8',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'840','180',33,NULL,NULL,NULL),(67,26,0,'7',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'20','20',32,NULL,NULL,NULL),(66,26,0,'6',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'20','100',31,NULL,NULL,NULL),(65,26,0,'5',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'20','180',30,NULL,NULL,NULL),(64,26,0,'4',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'20','260',29,NULL,NULL,NULL),(63,26,0,'3',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'20','380',28,NULL,NULL,NULL),(62,26,0,'2',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'840','100',27,NULL,NULL,NULL),(61,26,0,'1',NULL,NULL,NULL,NULL,NULL,'','Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'840','20',26,NULL,NULL,NULL),(119,24,0,'55',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'460','20',61,NULL,NULL,NULL),(122,25,0,'99',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Cleaned','Operational','00:00:00',NULL,NULL,'780','100',55,NULL,NULL,NULL),(139,0,NULL,'2:00PM Slot 2',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Cleaned','Operational','00:00:00',NULL,'1',NULL,NULL,NULL,'14:00:00','SUN,MON,TUE,WED,THU,FRI,SAT','29,30,31'),(124,0,NULL,'12:30PM',NULL,1002,'2023-06-12','2023-06-12',NULL,NULL,'Checked In',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,'1','300','20',NULL,'12:30:00','SUN,MON,TUE,WED,THU,FRI,SAT','34'),(128,28,0,'70',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'640','100',62,NULL,NULL,NULL),(138,0,NULL,'10:05AM',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,'1',NULL,NULL,NULL,'10:05:00','SUN,MON,TUE,WED,THU,FRI,SAT','34'),(134,0,NULL,'1:30PM',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,'1','60','20',NULL,'13:30:00','SUN,MON,TUE,WED,THU,FRI,SAT','34'),(135,0,NULL,'2:30PM',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Cleaned','Operational','00:00:00',NULL,'1','60','120',NULL,'14:30:00','SUN,MON,TUE,WED,THU,FRI,SAT','34'),(137,0,NULL,'1:30PM Slot 1',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Cleaned','Operational','00:00:00',NULL,'1',NULL,NULL,NULL,'13:30:00','SUN,MON,TUE,WED,THU,FRI,SAT','29,30,31'),(136,33,0,'DC1',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'820','420',1,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=234 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]',''),(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]',''),(43,10043,'data:image/png;base64,[BLOB]',''),(44,10019,'data:image/png;base64,[BLOB]',''),(45,10047,'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]',''),(56,10066,'data:image/png;base64,[BLOB]',''),(57,10056,'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]',''),(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]',''),(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]',''),(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]',''),(123,10162,'data:image/png;base64,[BLOB]',''),(124,10160,'data:image/png;base64,[BLOB]',''),(125,10141,'data:image/png;base64,[BLOB]',''),(126,10015,'data:image/png;base64,[BLOB]',''),(127,10161,'data:image/png;base64,[BLOB]',''),(128,10067,'data:image/png;base64,[BLOB]',''),(129,10168,'data:image/png;base64,[BLOB]',''),(130,10089,'data:image/png;base64,[BLOB]',''),(131,10166,'data:image/png;base64,[BLOB]',''),(132,10167,'data:image/png;base64,[BLOB]',''),(133,10169,'data:image/png;base64,[BLOB]',''),(134,10174,'data:image/png;base64,[BLOB]',''),(135,10152,'data:image/png;base64,[BLOB]',''),(136,10129,'data:image/png;base64,[BLOB]',''),(137,10176,'data:image/png;base64,[BLOB]',''),(138,10177,'data:image/png;base64,[BLOB]',''),(139,10149,'data:image/png;base64,[BLOB]',''),(140,10179,'data:image/png;base64,[BLOB]',''),(141,10154,'data:image/png;base64,[BLOB]',''),(142,10182,'data:image/png;base64,[BLOB]',''),(143,10170,'data:image/png;base64,[BLOB]',''),(144,10041,'data:image/png;base64,[BLOB]',''),(146,10156,'data:image/png;base64,[BLOB]',''),(147,10164,'data:image/png;base64,[BLOB]',''),(148,10165,'data:image/png;base64,[BLOB]',''),(149,10185,'data:image/png;base64,[BLOB]',''),(151,10187,'data:image/png;base64,[BLOB]',''),(152,10188,'data:image/png;base64,[BLOB]',''),(153,10189,'data:image/png;base64,[BLOB]',''),(154,10190,'data:image/png;base64,[BLOB]',''),(155,10191,'data:image/png;base64,[BLOB]',''),(156,10192,'data:image/png;base64,[BLOB]',''),(157,10184,'data:image/png;base64,[BLOB]',''),(158,10196,'data:image/png;base64,[BLOB]',''),(159,10198,'data:image/png;base64,[BLOB]',''),(160,10132,'data:image/png;base64,[BLOB]',''),(161,10181,'data:image/png;base64,[BLOB]',''),