CREATE TABLE `tb_roomassigns` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`RESERVNO` decimal(10,0) NOT NULL,
`ROOMNO` varchar(5) NOT NULL,
`ARRIVE` datetime NOT NULL,
`DEPART` datetime NOT NULL,
`OLDARRIVE` datetime DEFAULT NULL,
`OLDDEPART` datetime DEFAULT NULL,
`GUESTNO` decimal(10,0) DEFAULT NULL,
`RMRATE` decimal(10,2) NOT NULL,
`TOTALRATE` decimal(10,2) NOT NULL,
`USERID` varchar(20) NOT NULL,
`USERID_UPDATE` varchar(20) DEFAULT NULL,
`ASSIGN_DATE` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`ASSIGN_UPDATE` datetime DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`ID`),
UNIQUE KEY `ROOMNO` (`ROOMNO`,`ARRIVE`,`DEPART`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Assingn Room' AUTO_INCREMENT=1 ;
CREATE TABLE `tb_rooms` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`RMTYPE` varchar(6) NOT NULL,
`ROOMNO` varchar(5) NOT NULL,
`RMSTATUS` varchar(2) DEFAULT NULL,
`HKSTATUS` varchar(2) DEFAULT NULL,
`FOSTATUS` varchar(2) DEFAULT NULL,
`RMNIGHT` decimal(10,0) DEFAULT NULL,
`ROOMVIEW` varchar(40) DEFAULT NULL,
`NUM_OFBED` int(4) DEFAULT '1',
PRIMARY KEY (`ID`),
UNIQUE KEY `IXROOM` (`ROOMNO`),
UNIQUE KEY `RMTYPE` (`RMTYPE`,`ROOMNO`),
KEY `IDXFLOORROOM` (`ROOMNO`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=37 ;
--
-- Dumping data for table `tb_rooms`
--
INSERT INTO `tb_rooms` VALUES (1, 'SRBA', 'A1', NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `tb_rooms` VALUES (2, 'SRBA', 'A2', NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `tb_rooms` VALUES (3, 'SRBA', 'A3', NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `tb_rooms` VALUES (4, 'SRBA', 'A4', NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `tb_rooms` VALUES (5, 'SRBA', 'A5', NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `tb_rooms` VALUES (6, 'SRBA', 'A6', NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `tb_rooms` VALUES (7, 'SRBB', 'B1', NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `tb_rooms` VALUES (8, 'SRBB', 'B2', NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `tb_rooms` VALUES (9, 'SRBB', 'B3', NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `tb_rooms` VALUES (10, 'SRBB', 'B4', NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `tb_rooms` VALUES (11, 'SRBB', 'B5', NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `tb_rooms` VALUES (12, 'SRBB', 'B6', NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `tb_rooms` VALUES (13, 'SRBB', 'B7', NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `tb_rooms` VALUES (14, 'SRBB', 'B8', NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `tb_rooms` VALUES (15, 'SRBB', 'B9', NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `tb_rooms` VALUES (16, 'SRBB', 'B10', NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `tb_rooms` VALUES (17, 'SRBB', 'B11', NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `tb_rooms` VALUES (18, 'SRBB', 'B12', NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `tb_rooms` VALUES (19, 'SRBB', 'B13', NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `tb_rooms` VALUES (20, 'SRBB', 'B14', NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `tb_rooms` VALUES (21, 'SRBB', 'B15', NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `tb_rooms` VALUES (22, 'SRBB', 'B16', NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `tb_rooms` VALUES (23, 'SRBB', 'B17', NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `tb_rooms` VALUES (24, 'SRBB', 'B18', NULL, NULL, NULL, NULL, NULL, 2);
INSERT INTO `tb_rooms` VALUES (25, 'SRBB', 'B19', NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `tb_rooms` VALUES (26, 'SRBB', 'B20', NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `tb_rooms` VALUES (27, 'SRBB', 'B21', NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `tb_rooms` VALUES (28, 'SRBB', 'B22', NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `tb_rooms` VALUES (29, 'SRBB', 'B23', NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `tb_rooms` VALUES (30, 'SRBB', 'B24', NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `tb_rooms` VALUES (31, 'SRBB', 'B25', NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `tb_rooms` VALUES (32, 'SRBB', 'B26', NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `tb_rooms` VALUES (33, 'SRBB', 'B27', NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `tb_rooms` VALUES (34, 'SRBB', 'B28', NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `tb_rooms` VALUES (35, 'SRBR', 'R1', NULL, NULL, NULL, NULL, NULL, 1);
INSERT INTO `tb_rooms` VALUES (36, 'SRBR', 'R2', NULL, NULL, NULL, NULL, NULL, 1);
พัฒนาเว็บไซต์
