DROP DATABASE testdb;
CREATE DATABASE testdb;
USE testdb;
DROP TABLE IF EXISTS `t_price`;
CREATE TABLE `t_price` (
  `PriceCode` varchar(32) NOT NULL default '',
  `Version` int(10) unsigned NOT NULL default '0',
  `HotelCode` varchar(32) NOT NULL default '',
  `RoomTypeCode` int(10) unsigned NOT NULL default '0',
  `StartDate` date NOT NULL default '0000-00-00',
  `EndDate` date NOT NULL default '0000-00-00',
  `PriceName` varchar(32) NOT NULL default '',
  `Monday` tinyint(1) NOT NULL default '0',
  `Tuesday` tinyint(1) NOT NULL default '0',
  `Wednesday` tinyint(1) NOT NULL default '0',
  `Thursday` tinyint(1) NOT NULL default '0',
  `Friday` tinyint(1) NOT NULL default '0',
  `Saturday` tinyint(1) NOT NULL default '0',
  `Sunday` tinyint(1) NOT NULL default '0',
  `TouristCompanyCode` varchar(32) default '0',
  `PricePurchasePrice1` decimal(16,2) NOT NULL default '0.00',
  `PricePurchasePrice2` decimal(16,2) NOT NULL default '0.00',
  `PriceSellPrice1` decimal(16,2) NOT NULL default '0.00',
  `PriceSellPrice2` decimal(16,2) NOT NULL default '0.00',
  `PriceCounterPrice` decimal(16,2) NOT NULL default '0.00',
  `PriceHKPurchasePrice` decimal(16,2) default '0.00',
  `PriceHKSellPrice` decimal(16,2) default '0.00',
  `PriceHKExchangeRate` decimal(16,2) default '0.00',
  `PriceUSPurchasePrice` decimal(16,2) default '0.00',
  `PriceUSSellPrice` decimal(16,2) default '0.00',
  `PriceUSExchangeRate` decimal(16,2) default '0.00',
  `ServiceFeeRatio` decimal(5,2) NOT NULL default '0.00',
  `RebateRatio` decimal(5,2) NOT NULL default '0.00',
  `PriceDelFlag` tinyint(1) NOT NULL default '0',
  `PriceMaskFlag` tinyint(1) NOT NULL default '0',
  `PriceVisible` tinyint(1) NOT NULL default '0',
  `PriceSpecialFlag` tinyint(1) NOT NULL default '0',
  `PriceCreateDate` datetime NOT NULL default '0000-00-00 00:00:00',
  `PriceCreator` int(10) unsigned NOT NULL default '0',
  `PriceMemo` varchar(128) default '',
  `PriceWebsiteUpdate` tinyint(1) NOT NULL default '0',
  `PayOnCounter` tinyint(1) default '0',
  `PayOnDeposit` tinyint(1) default '0',
  `PayOnMonth` tinyint(1) default '0',
  `PriceRecommend` tinyint(3) NOT NULL default '0',
  `PriceWebsiteVisible` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`PriceCode`,`Version`),
  KEY `HOTEL_IDX` (`HotelCode`,`RoomTypeCode`),
  KEY `DATE_IDX` (`StartDate`,`EndDate`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;


/*!40000 ALTER TABLE `t_price` DISABLE KEYS */;
LOCK TABLES `t_price` WRITE;
INSERT INTO `t_price` VALUES ('PRICE1',1,'0002',1,'2004-12-24','2004-12-31','fff',1,1,1,1,1,1,1,NULL,'538.00','598.00','538.00','598.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2004-12-24 14:06:15',4,NULL,0,1,1,NULL,0,0),('PRICE10',1,'0002',1,'2004-12-24','2004-12-31','周末',0,0,0,0,1,1,1,NULL,'448.00','448.00','498.00','498.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2004-12-24 15:29:42',4,NULL,0,1,1,NULL,0,0),('PRICE10',2,'0002',1,'2004-12-24','2004-12-31','周末',0,0,0,0,1,1,1,NULL,'448.00','448.00','498.00','498.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2004-12-24 00:00:00',4,NULL,0,1,1,NULL,0,0),('PRICE10',3,'0002',1,'2004-12-24','2004-12-31','周末',0,0,0,0,1,1,1,NULL,'448.00','448.00','498.00','498.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-24 00:00:00',4,NULL,0,1,1,NULL,0,0),('PRICE100',1,'0214073',2,'2005-01-05','2005-02-28','',1,1,1,1,1,1,1,NULL,'378.00','378.00','428.00','428.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-05 15:16:32',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE101',1,'0213061',548,'2005-01-05','2005-02-28','',1,1,1,1,1,1,1,NULL,'476.00','476.00','528.00','528.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-05 15:17:52',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE102',1,'0214078',137,'2005-01-05','2005-01-10','',1,1,1,1,1,1,1,NULL,'405.00','405.00','450.00','450.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-05 15:19:30',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE103',1,'0214010',1099,'2005-01-05','2005-02-28','',1,1,1,1,1,1,1,NULL,'600.00','600.00','650.00','650.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2005-01-05 15:21:23',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE103',2,'0214010',1099,'2005-01-05','2005-02-28','',0,1,1,1,1,0,0,NULL,'600.00','600.00','650.00','650.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-05 00:00:00',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE104',1,'0214009',1111,'2005-01-05','2005-12-31','',1,1,1,1,1,1,1,NULL,'568.00','568.00','628.00','628.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-05 15:22:45',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE105',1,'0255009',173,'2005-01-05','2005-12-31','',1,1,1,1,1,1,1,NULL,'530.00','530.00','598.00','598.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-05 15:23:49',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE106',1,'0285004',686,'2005-01-05','2005-12-31','',1,1,1,1,1,1,1,NULL,'478.00','478.00','568.00','568.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-05 15:25:18',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE107',1,'0214092',173,'2005-01-05','2005-02-28','',1,1,1,1,1,1,1,NULL,'498.00','498.00','588.00','588.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-05 15:41:50',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE108',1,'0252001',2,'2005-01-06','2005-12-31','',1,1,1,1,1,1,1,NULL,'300.00','300.00','400.00','400.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2005-01-06 09:43:19',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE108',2,'0252001',2,'2005-01-06','2005-12-31','',1,1,1,1,0,0,0,NULL,'300.00','300.00','400.00','400.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-06 00:00:00',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE109',1,'0252001',548,'2005-01-06','2005-03-31','',0,0,0,0,1,1,1,NULL,'300.00','300.00','400.00','400.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-06 09:48:15',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE11',1,'0002',4,'2004-12-24','2004-12-31','平日',1,1,1,1,1,1,1,NULL,'592.00','592.00','658.00','658.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-24 15:30:05',4,NULL,0,1,1,NULL,0,0),('PRICE110',1,'0252001',378,'2005-02-09','2005-02-14','',1,1,1,1,1,1,1,NULL,'300.00','300.00','400.00','400.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,1,'2005-01-06 09:49:15',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE111',1,'0252001',3,'2005-02-01','2005-02-28','',1,1,1,1,1,1,1,NULL,'500.00','500.00','600.00','600.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2005-01-06 10:15:52',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE111',2,'0252001',3,'2005-02-01','2005-02-04','',1,1,1,1,1,1,1,NULL,'500.00','500.00','600.00','600.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-06 00:00:00',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE112',1,'0252001',3,'2005-02-05','2005-02-28','',1,1,1,1,1,1,1,NULL,'600.00','600.00','700.00','700.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-06 10:16:07',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE113',1,'5745003',423,'2005-01-01','2005-12-31','',1,1,1,1,1,1,1,NULL,'518.00','518.00','568.00','568.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2005-01-06 15:21:41',2,NULL,0,NULL,NULL,NULL,0,0),('PRICE113',2,'5745003',423,'2005-01-01','2005-12-31','',1,1,1,1,1,1,1,NULL,'518.00','518.00','568.00','568.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-06 00:00:00',2,NULL,0,NULL,NULL,NULL,0,0),('PRICE114',1,'0212008',10,'2005-01-01','2005-12-31','',1,1,1,1,1,1,1,NULL,'480.00','480.00','530.00','530.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2005-01-06 15:56:12',2,NULL,0,NULL,NULL,NULL,0,0),('PRICE115',1,'0212008',8,'2005-01-01','2005-02-28','',1,1,1,1,1,1,1,NULL,'340.00','340.00','390.00','390.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2005-01-06 15:57:35',2,NULL,0,NULL,NULL,NULL,0,0),('PRICE115',2,'0212008',8,'2005-01-01','2005-02-28','',1,1,1,1,1,1,1,NULL,'340.00','340.00','390.00','390.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,1,'2005-01-06 00:00:00',2,NULL,0,NULL,NULL,NULL,0,0),('PRICE116',1,'0214002',909,'2005-01-10','2005-01-31','',1,1,1,1,1,1,1,NULL,'996.00','1046.00','1096.00','1145.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-06 16:49:51',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE117',1,'5714009',486,'2005-01-01','2005-12-31','',1,1,1,1,1,1,1,NULL,'338.00','338.00','398.00','398.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2005-01-06 16:51:07',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE117',2,'5714009',486,'2004-01-01','2005-12-31','',1,1,1,1,1,1,1,NULL,'338.00','338.00','398.00','398.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-06 00:00:00',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE118',1,'0215025',671,'2005-01-11','2005-02-28','',1,1,1,1,1,1,1,NULL,'985.00','985.00','1079.00','1079.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-06 16:53:31',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE119',1,'0212008',6,'2005-01-01','2005-12-31','',1,1,1,1,1,1,1,NULL,'480.00','480.00','530.00','530.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,0,0,0,'2005-01-07 14:24:42',2,NULL,0,NULL,NULL,NULL,0,0),('PRICE12',1,'0002',5,'2004-12-24','2004-12-31','平日',1,1,1,1,1,1,1,NULL,'628.00','628.00','698.00','698.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-24 15:30:22',4,NULL,0,1,1,NULL,0,0),('PRICE120',1,'0212008',6,'2005-01-01','2005-02-28','',1,1,1,1,1,1,1,NULL,'340.00','340.00','390.00','390.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,1,'2005-01-07 14:24:59',2,NULL,0,NULL,NULL,NULL,0,0),('PRICE121',1,'0215005',6,'2005-01-07','2005-02-15','',1,1,1,1,1,1,1,NULL,'1255.00','1255.00','1374.00','1374.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-07 15:18:55',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE122',1,'0255006',6,'2005-01-07','2005-01-31','',1,1,1,1,0,0,0,NULL,'583.00','583.00','648.00','648.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-07 15:21:28',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE123',1,'0255006',6,'2005-01-07','2005-01-31','',0,0,0,0,1,1,1,NULL,'475.00','475.00','528.00','528.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-07 15:21:47',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE124',1,'5325003',5,'2005-01-07','2005-02-28','',1,1,1,1,1,0,0,NULL,'701.00','701.00','768.00','768.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-07 15:27:34',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE125',1,'5325003',5,'2005-01-07','2005-04-30','',0,0,0,0,0,1,1,NULL,'659.00','659.00','722.00','722.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-07 15:28:09',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE126',1,'0214006',176,'2005-01-04','2005-02-06','',1,1,1,1,1,1,1,NULL,'700.00','700.00','800.00','800.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-07 16:19:57',2,NULL,0,NULL,NULL,NULL,0,0),('PRICE127',1,'0214006',91,'2005-01-04','2005-02-06','',1,1,1,1,1,1,1,NULL,'850.00','850.00','950.00','950.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2005-01-07 16:22:53',2,NULL,0,NULL,NULL,NULL,0,0),('PRICE127',2,'0214006',91,'2005-01-04','2005-02-06','',1,1,1,1,1,1,1,NULL,'850.00','850.00','950.00','950.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-07 00:00:00',2,NULL,0,NULL,NULL,NULL,0,0),('PRICE128',1,'0214006',92,'2005-01-04','2005-02-06','',1,1,1,1,1,1,1,NULL,'850.00','850.00','950.00','950.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-07 16:25:29',2,NULL,0,NULL,NULL,NULL,0,0),('PRICE129',1,'0214010',2,'2005-01-01','2005-02-28','',1,1,1,1,1,1,1,NULL,'550.00','550.00','600.00','600.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2005-01-10 16:15:02',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE129',2,'0214010',2,'2005-01-01','2005-02-28','',0,1,1,1,1,0,0,NULL,'550.00','550.00','600.00','600.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2005-01-10 00:00:00',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE129',3,'0214010',2,'2005-01-01','2005-02-28','',1,0,0,0,0,1,1,NULL,'500.00','500.00','550.00','550.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2005-01-10 00:00:00',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE129',4,'0214010',2,'2005-01-01','2005-02-28','',1,0,0,0,0,1,1,NULL,'500.00','500.00','550.00','550.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-10 00:00:00',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE13',1,'0002',6,'2004-12-24','2004-12-31','平日',1,1,1,1,1,1,1,NULL,'898.00','898.00','998.00','998.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2004-12-24 15:30:40',4,NULL,0,1,1,NULL,0,0),('PRICE13',2,'0002',6,'2004-12-24','2004-12-31','平日',1,1,1,1,1,1,1,NULL,'898.00','898.00','998.00','998.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-24 00:00:00',4,NULL,0,1,1,NULL,0,0),('PRICE130',1,'0214010',2,'2005-01-01','2005-02-28','',0,1,1,1,1,0,0,NULL,'550.00','550.00','600.00','600.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-10 16:28:39',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE131',1,'0214010',1099,'2005-01-05','2005-02-28','',1,0,0,0,0,1,1,NULL,'500.00','500.00','550.00','550.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-10 16:29:36',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE132',1,'0213020',71,'2005-01-10','2005-02-04','',1,1,1,1,0,0,0,NULL,'540.00','558.00','590.00','620.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2005-01-10 16:34:25',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE132',2,'0213020',71,'2005-01-10','2005-02-04','',0,0,0,0,1,1,1,NULL,'540.00','472.50','590.00','525.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2005-01-10 00:00:00',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE132',3,'0213020',71,'2005-01-10','2005-02-04','',1,1,1,1,0,0,0,NULL,'540.00','558.00','590.00','620.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-10 00:00:00',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE133',1,'0213020',71,'2005-01-10','2005-02-04','',0,0,0,0,1,1,1,NULL,'540.00','472.50','590.00','525.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2005-01-10 16:40:57',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE133',2,'0213020',71,'2005-01-10','2005-02-04','',0,0,0,0,1,1,1,NULL,'540.00','472.50','590.00','525.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-10 00:00:00',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE134',1,'0212050',797,'2005-01-10','2005-06-30','',1,1,1,1,1,1,1,NULL,'180.00','180.00','220.00','220.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-10 16:44:40',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE135',1,'0214027',2,'2005-01-10','2005-02-28','',1,1,1,1,0,0,0,NULL,'540.00','540.00','590.00','590.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-10 16:49:28',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE136',1,'0214027',2,'2005-01-10','2005-02-28','',0,0,0,0,1,1,1,NULL,'500.00','500.00','550.00','550.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-10 16:50:06',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE137',1,'0214027',2,'2005-01-10','2005-02-18','',0,0,0,0,1,1,1,NULL,'400.00','400.00','450.00','450.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,1,'2005-01-10 16:50:36',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE138',1,'0214027',2,'2005-01-10','2005-02-18','',1,1,1,1,0,0,0,NULL,'440.00','440.00','490.00','490.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,1,'2005-01-10 16:50:49',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE139',1,'5714016',6,'2005-01-11','2005-02-28','',1,1,1,1,1,1,1,NULL,'310.00','310.00','360.00','360.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-11 16:32:09',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE14',1,'0002',7,'2004-12-24','2004-12-31','平日',1,1,1,1,1,1,1,NULL,'1080.00','1080.00','1200.00','1200.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2004-12-24 15:31:06',4,NULL,0,1,1,NULL,0,0),('PRICE14',2,'0002',7,'2004-12-24','2004-12-31','平日',1,1,1,1,1,1,1,NULL,'1080.00','1080.00','1200.00','1200.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2004-12-24 00:00:00',4,NULL,0,1,1,NULL,0,0),('PRICE14',3,'0002',7,'2004-12-24','2004-12-31','平日',1,1,1,1,1,1,1,NULL,'1080.00','1080.00','1200.00','1200.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2004-12-24 00:00:00',4,NULL,0,1,1,NULL,0,0),('PRICE14',4,'0002',7,'2004-12-24','2004-12-31','平日',1,1,1,1,1,1,1,NULL,'1080.00','1080.00','1200.00','1200.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-24 00:00:00',4,NULL,0,1,1,NULL,0,0),('PRICE140',1,'0104025',890,'2005-01-11','2005-02-27','',1,1,1,1,1,1,1,NULL,'310.00','310.00','360.00','360.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-11 16:34:19',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE141',1,'0214046',548,'2005-01-11','2005-01-31','',1,1,1,1,1,1,1,NULL,'320.00','320.00','368.00','368.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-11 16:36:44',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE142',1,'0213087',2,'2005-01-11','2005-02-28','',1,1,1,1,1,1,1,NULL,'438.00','438.00','488.00','488.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-11 16:38:08',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE143',1,'0214001',6,'2005-01-13','2005-01-31','',1,1,1,1,1,1,1,NULL,'628.00','628.00','698.00','698.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-13 15:25:22',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE144',1,'0214020',676,'2005-01-13','2005-02-28','',1,1,1,1,1,1,1,NULL,'358.00','358.00','398.00','398.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-13 15:26:27',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE145',1,'0245003',5,'2005-01-01','2005-01-31','',1,1,1,1,1,1,1,NULL,'652.05','652.05','621.00','621.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','15.00','10.00',1,1,0,0,'2005-01-18 20:03:25',1,NULL,0,NULL,NULL,NULL,0,0),('PRICE145',2,'0245003',5,'2005-01-01','2005-01-31','',1,1,1,1,1,1,1,NULL,'0.00','0.00','621.00','621.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','15.00','10.00',1,1,0,0,'2005-01-18 00:00:00',1,NULL,0,NULL,NULL,NULL,0,0),('PRICE145',3,'0245003',5,'2005-01-01','2005-01-31','',1,1,1,1,1,1,1,NULL,'652.00','652.00','680.00','680.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','15.00','10.00',1,1,0,0,'2005-01-18 00:00:00',1,NULL,0,NULL,NULL,NULL,0,0),('PRICE145',4,'0245003',5,'2005-01-01','2005-01-31','',1,1,1,1,1,1,1,NULL,'652.00','652.00','680.00','680.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','15.00','10.00',1,1,0,0,'2005-01-18 00:00:00',1,NULL,0,NULL,NULL,NULL,0,0),('PRICE145',5,'0245003',5,'2005-01-01','2005-01-31','',1,1,1,1,1,1,1,NULL,'652.00','652.00','680.00','680.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','15.00','10.00',0,1,0,0,'2005-01-18 00:00:00',1,NULL,0,NULL,NULL,NULL,0,0),('PRICE146',1,'0215001',74,'2005-01-03','2005-01-31','',1,1,1,1,1,1,1,NULL,'0.00','0.00','1300.00','1300.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-18 20:13:44',1,NULL,0,NULL,NULL,NULL,0,0),('PRICE147',1,'5713016',374,'2005-01-19','2005-03-15','',1,1,1,1,1,1,1,NULL,'230.00','230.00','280.00','280.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-19 15:42:20',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE148',1,'0214031',548,'2005-01-19','2005-02-28','',1,1,1,1,1,1,1,NULL,'338.00','338.00','438.00','438.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2005-01-19 15:44:10',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE148',2,'0214031',548,'2005-01-19','2005-02-28','',1,1,1,1,1,1,1,'24','338.00','338.00','438.00','438.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-19 00:00:00',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE149',1,'0214018',5,'2005-01-19','2005-02-28','',1,1,1,1,1,1,1,NULL,'448.00','448.00','498.00','498.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-19 15:45:23',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE15',1,'0004',1,'2004-12-24','2005-01-02','平日',1,1,1,1,1,1,1,NULL,'0.00','0.00','588.00','588.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-24 15:32:21',4,NULL,0,1,1,NULL,0,0),('PRICE150',1,'0214018',41,'2005-01-19','2005-02-28','',1,1,1,1,1,1,1,NULL,'918.00','918.00','968.00','968.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-19 15:45:45',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE151',1,'0213018',2,'2005-01-19','2005-12-31','',1,1,1,1,1,1,1,NULL,'340.00','340.00','388.00','388.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-19 16:08:47',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE152',1,'0215007',169,'2005-01-19','2005-02-28','',1,1,1,1,0,0,0,NULL,'1230.00','1228.50','1280.00','1345.50','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2005-01-19 16:13:24',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE153',1,'0215007',169,'2005-01-19','2005-02-28','',0,0,0,0,1,1,1,NULL,'1050.00','1050.00','1100.00','1150.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2005-01-19 16:14:00',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE154',1,'0215007',207,'2005-01-19','2005-02-28','',0,0,0,0,1,1,1,NULL,'1050.00','1050.00','1100.00','1150.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2005-01-19 16:15:39',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE154',2,'0215007',207,'2005-01-10','2005-02-28','',0,0,0,0,1,1,1,NULL,'1050.00','1050.00','1100.00','1150.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-19 00:00:00',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE155',1,'0215007',207,'2005-01-19','2005-02-28','',1,1,1,1,0,0,0,NULL,'1230.00','1228.50','1280.00','1345.50','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2005-01-19 16:18:08',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE155',2,'0215007',207,'2005-01-10','2005-02-28','',1,1,1,1,0,0,0,NULL,'1230.00','1228.50','1280.00','1345.50','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-19 00:00:00',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE156',1,'0203020',6,'2005-01-01','2005-12-31','',1,1,1,1,1,1,1,NULL,'280.00','280.00','320.00','320.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-19 16:20:57',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE157',1,'0214011',2,'2005-01-19','2005-02-28','',1,1,1,1,1,1,1,NULL,'538.00','538.00','588.00','588.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-19 16:22:51',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE158',1,'0214011',41,'2005-01-19','2005-02-28','',1,1,1,1,1,1,1,NULL,'588.00','588.00','638.00','638.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-19 16:23:20',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE159',1,'0205001',6,'2004-12-03','2004-12-31','',1,1,1,1,1,1,1,NULL,'600.00','600.00','700.00','700.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-19 16:24:07',2,NULL,0,NULL,1,NULL,0,0),('PRICE16',1,'0004',5,'2004-12-24','2005-01-02','平日',1,1,1,1,1,1,1,NULL,'0.00','0.00','748.00','748.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-24 15:32:34',4,NULL,0,1,1,NULL,0,0),('PRICE160',1,'0214007',890,'2005-01-19','2005-02-28','',1,1,1,1,1,1,1,NULL,'468.00','468.00','518.00','518.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-19 16:24:40',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE161',1,'0205001',6,'2004-12-03','2004-12-31','',1,1,1,1,1,1,1,'4','480.00','520.00','550.00','600.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-19 16:25:23',2,NULL,0,NULL,1,NULL,0,0),('PRICE162',1,'0214003',2,'2004-10-17','2004-10-18','',1,1,1,1,1,1,1,'23','870.00','870.00','970.00','900.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2005-01-19 16:57:22',2,NULL,0,NULL,NULL,NULL,0,0),('PRICE162',2,'0214003',2,'2004-10-17','2005-03-17','',1,1,1,1,1,1,1,'23','870.00','870.00','970.00','900.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-19 00:00:00',2,NULL,0,NULL,NULL,NULL,0,0),('PRICE163',1,'0212001',2,'2005-02-17','2006-02-17','',1,1,1,1,1,0,0,NULL,'500.00','700.00','600.00','800.00','900.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-02-17 20:53:33',1,NULL,0,NULL,NULL,NULL,0,0),('PRICE164',1,'0212001',2,'2005-02-17','2006-02-17','',0,0,0,0,0,1,1,NULL,'600.00','800.00','700.00','900.00','1000.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-02-17 20:54:07',1,NULL,0,NULL,NULL,NULL,0,0),('PRICE17',1,'0005',8,'2004-12-24','2005-12-31','平日',1,1,1,1,1,1,1,NULL,'358.00','358.00','398.00','398.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-24 15:36:33',4,NULL,0,1,1,NULL,0,0),('PRICE18',1,'0005',3,'2004-12-24','2005-12-31','平日',1,1,1,1,1,1,1,NULL,'448.00','448.00','498.00','498.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-24 15:36:53',4,NULL,0,1,1,NULL,0,0),('PRICE19',1,'0005',9,'2004-12-24','2005-12-31','平日',1,1,1,1,1,1,1,NULL,'538.00','538.00','598.00','598.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-24 15:38:32',4,NULL,0,1,1,NULL,0,0),('PRICE2',1,'0002',1,'2004-12-24','2004-12-31','12月份价格',1,1,1,1,1,1,1,NULL,'538.00','598.00','538.00','598.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2004-12-24 14:34:04',4,NULL,0,1,1,NULL,0,0),('PRICE2',2,'0002',1,'2004-12-24','2004-12-31','12月份价格',0,0,0,0,1,1,1,NULL,'448.00','498.00','448.00','498.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2004-12-24 00:00:00',4,NULL,0,1,1,NULL,0,0),('PRICE20',1,'0005',10,'2004-12-24','2005-12-31','平日',1,1,1,1,1,1,1,NULL,'583.00','583.00','648.00','648.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-24 15:38:49',4,NULL,0,1,1,NULL,0,0),('PRICE21',1,'0005',11,'2004-12-24','2005-12-31','平日',1,1,1,1,1,1,1,NULL,'808.00','808.00','898.00','898.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-24 15:39:05',4,NULL,0,1,1,NULL,0,0),('PRICE22',1,'0005',12,'2004-12-24','2005-12-31','平日',1,1,1,1,1,1,1,NULL,'1069.00','1069.00','1188.00','1188.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-24 15:39:23',4,NULL,0,1,1,NULL,0,0),('PRICE23',1,'0006',4,'2004-12-24','2004-12-31','平日',1,1,1,1,1,1,1,NULL,'360.00','360.00','400.00','400.00','680.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2004-12-24 15:45:57',4,NULL,0,1,1,NULL,0,0),('PRICE23',2,'0006',4,'2004-12-24','2004-12-31','平日',1,1,1,1,1,1,1,NULL,'360.00','360.00','400.00','400.00','680.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2004-12-24 00:00:00',4,NULL,0,1,1,NULL,0,0),('PRICE23',3,'0006',4,'2004-12-24','2004-12-31','平日',1,1,1,1,1,1,1,NULL,'360.00','360.00','400.00','400.00','680.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-24 00:00:00',4,NULL,0,1,1,NULL,0,0),('PRICE24',1,'0006',5,'2004-12-24','2004-12-31','平日',1,1,1,1,1,1,1,NULL,'400.00','400.00','450.00','450.00','780.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-24 15:49:34',4,NULL,0,1,1,NULL,0,0),('PRICE25',1,'0006',5,'2004-12-24','2004-12-31','平日',1,1,1,1,1,1,1,NULL,'480.00','480.00','530.00','530.00','780.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2004-12-24 15:50:48',4,NULL,0,1,1,NULL,0,0),('PRICE25',2,'0006',5,'2005-01-01','2005-12-31','平日',1,1,1,1,1,1,1,NULL,'480.00','480.00','530.00','530.00','780.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-24 00:00:00',4,NULL,0,1,1,NULL,0,0),('PRICE26',1,'0006',5,'2004-12-25','2005-02-28','特价',1,1,1,1,1,1,1,NULL,'340.00','340.00','390.00','390.00','780.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,1,'2004-12-24 15:51:31',4,NULL,0,1,1,NULL,0,0),('PRICE27',1,'0006',6,'2004-12-24','2004-12-31','平日',1,1,1,1,1,1,1,NULL,'550.00','550.00','600.00','600.00','980.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-24 15:52:10',4,NULL,0,1,1,NULL,0,0),('PRICE28',1,'0006',6,'2005-01-01','2005-12-31','平日',1,1,1,1,1,1,1,NULL,'590.00','590.00','650.00','650.00','980.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-24 15:52:41',4,NULL,0,1,1,NULL,0,0),('PRICE29',1,'0006',6,'2004-12-25','2005-02-28','特价',1,1,1,1,1,1,1,NULL,'480.00','480.00','530.00','530.00','980.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,1,'2004-12-24 15:53:05',4,NULL,0,1,1,NULL,0,0),('PRICE3',1,'0002',1,'2004-12-24','2004-12-31','12月份房价',1,1,1,1,1,1,1,NULL,'538.00','598.00','538.00','598.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,0,0,0,'2004-12-24 14:57:22',4,NULL,0,1,1,NULL,0,0),('PRICE30',1,'0006',3,'2004-12-24','2004-12-31','平日',1,1,1,1,1,1,1,NULL,'720.00','720.00','800.00','800.00','1180.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-24 15:53:42',4,NULL,0,1,1,NULL,0,0),('PRICE31',1,'0006',3,'2005-01-01','2005-12-31','平日',1,1,1,1,1,1,1,NULL,'860.00','860.00','940.00','940.00','1180.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-24 15:54:05',4,NULL,0,1,1,NULL,0,0),('PRICE32',1,'0007',1,'2004-12-24','2005-02-28','平日',1,1,1,1,1,1,1,NULL,'476.00','476.00','528.00','528.00','1288.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2004-12-24 15:58:40',4,NULL,0,NULL,1,1,0,0),('PRICE33',1,'0007',1,'2004-12-24','2005-02-28','平日',1,1,1,1,1,1,1,NULL,'530.00','530.00','588.00','588.00','1288.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2004-12-24 15:58:57',4,NULL,0,NULL,1,1,0,0),('PRICE34',1,'0007',1,'2004-12-24','2005-02-28','平日',1,1,1,1,1,1,1,NULL,'476.00','476.00','528.00','528.00','1288.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-24 16:04:53',4,NULL,0,1,1,NULL,0,0),('PRICE35',1,'0007',1,'2004-12-24','2005-02-28','平日',1,1,1,1,1,1,1,NULL,'530.00','530.00','588.00','588.00','1288.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-24 16:05:33',4,NULL,0,1,1,NULL,0,0),('PRICE36',1,'0007',13,'2004-12-24','2005-02-28','平日',1,1,1,1,1,1,1,NULL,'620.00','620.00','688.00','688.00','1888.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-24 16:05:57',4,NULL,0,1,1,NULL,0,0),('PRICE37',1,'0007',14,'2004-12-24','2005-02-28','平日',1,1,1,1,1,1,1,NULL,'710.00','710.00','788.00','788.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-24 16:06:57',4,NULL,0,1,1,NULL,0,0),('PRICE38',1,'0007',15,'2004-12-24','2005-02-28','平日',1,1,1,1,1,1,1,NULL,'890.00','890.00','988.00','988.00','3888.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-24 16:07:15',4,NULL,0,1,1,NULL,0,0),('PRICE39',1,'0003',1,'2004-12-24','2005-01-09','中宾平日',1,1,1,1,1,1,1,NULL,'0.00','0.00','676.00','676.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-24 16:10:02',4,NULL,0,1,1,NULL,0,0),('PRICE4',1,'0002',1,'2004-12-24','2004-12-31','12月份房价',0,0,0,0,1,1,1,NULL,'448.00','498.00','448.00','498.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2004-12-24 14:59:51',4,NULL,0,1,1,NULL,0,0),('PRICE40',1,'0003',1,'2005-02-05','2005-02-17','中宾平日',1,1,1,1,1,1,1,NULL,'0.00','0.00','676.00','676.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-24 16:10:24',4,NULL,0,1,1,NULL,0,0),('PRICE41',1,'0003',1,'2005-01-10','2005-02-04','中宾平日',1,1,1,1,1,1,1,NULL,'0.00','0.00','1021.00','1021.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2004-12-24 16:10:48',4,NULL,0,1,1,NULL,0,0),('PRICE41',2,'0003',1,'2005-02-18','2005-02-28','中宾平日',1,1,1,1,1,1,1,NULL,'0.00','0.00','1021.00','1021.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-24 00:00:00',4,NULL,0,1,1,NULL,0,0),('PRICE42',1,'0003',16,'2004-12-24','2005-01-09','外宾平日',1,1,1,1,1,1,1,NULL,'0.00','0.00','1320.00','1320.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-24 16:11:59',4,NULL,0,1,1,NULL,0,0),('PRICE43',1,'0003',1,'2005-02-05','2005-02-17','外宾平日',1,1,1,1,1,1,1,NULL,'0.00','0.00','1320.00','1320.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2004-12-24 16:12:14',4,NULL,0,1,1,NULL,0,0),('PRICE44',1,'0003',1,'2005-01-10','2005-02-04','中宾平日',1,1,1,1,1,1,1,NULL,'0.00','0.00','1021.00','1021.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-24 16:14:12',4,NULL,0,1,1,NULL,0,0),('PRICE45',1,'0003',16,'2005-02-05','2005-02-17','外宾平日',1,1,1,1,1,1,1,NULL,'0.00','0.00','1320.00','1320.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-24 16:14:49',4,NULL,0,1,1,NULL,0,0),('PRICE46',1,'0003',16,'2005-01-10','2005-02-04','外宾平日',1,1,1,1,1,1,1,NULL,'0.00','0.00','1320.00','1320.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-24 16:15:12',4,NULL,0,1,1,NULL,0,0),('PRICE47',1,'0003',16,'2005-02-18','2005-02-28','外宾平日',1,1,1,1,1,1,1,NULL,'0.00','0.00','1320.00','1320.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-24 16:15:27',4,NULL,0,1,1,NULL,0,0),('PRICE48',1,'0003',17,'2004-12-24','2005-02-28','外宾平日',1,1,1,1,1,1,1,NULL,'0.00','0.00','1516.00','1516.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-24 16:16:01',4,NULL,0,1,1,NULL,0,0),('PRICE49',1,'0214068',1,'2004-12-27','2004-12-31','12月房价',1,1,1,1,1,1,1,NULL,'490.00','540.00','490.00','540.00','720.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-27 17:04:21',4,NULL,0,1,1,NULL,0,0),('PRICE5',1,'0002',4,'2004-12-24','2004-12-31','12月份房价',1,1,1,1,1,1,1,NULL,'592.00','658.00','592.00','658.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2004-12-24 15:00:13',4,NULL,0,1,1,NULL,0,0),('PRICE50',1,'0214068',6,'2004-12-27','2004-12-31','12月房价',1,1,1,1,1,1,1,NULL,'610.00','650.00','610.00','650.00','850.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-27 17:05:07',4,NULL,0,1,1,NULL,0,0),('PRICE51',1,'0214068',15,'2004-12-27','2004-12-31','12月房价',1,1,1,1,1,1,1,NULL,'790.00','850.00','790.00','850.00','1180.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-27 17:05:28',4,NULL,0,1,1,NULL,0,0),('PRICE52',1,'0214068',18,'2004-12-27','2004-12-31','12月房价',1,1,1,1,1,1,1,NULL,'510.00','560.00','510.00','560.00','850.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-27 17:07:06',4,NULL,0,1,1,NULL,0,0),('PRICE53',1,'0214068',20,'2004-12-27','2004-12-31','12月房价',1,1,1,1,1,1,1,NULL,'860.00','950.00','860.00','950.00','1380.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-27 17:07:24',4,NULL,0,1,1,NULL,0,0),('PRICE54',1,'0214033',4,'2004-12-27','2004-12-31','12月房价',1,1,1,1,1,1,1,NULL,'331.00','368.00','331.00','368.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-27 17:14:29',4,NULL,0,1,1,NULL,0,0),('PRICE55',1,'0214033',4,'2005-01-01','2005-02-08','1-2月房价',1,1,1,1,1,1,1,NULL,'331.00','368.00','331.00','368.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-27 17:15:03',4,NULL,0,1,1,NULL,0,0),('PRICE56',1,'0214033',5,'2004-12-27','2005-02-08','12-2月房价',1,1,1,1,1,1,1,NULL,'398.00','468.00','398.00','468.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-27 17:15:48',4,NULL,0,1,1,NULL,0,0),('PRICE57',1,'0214033',13,'2004-12-27','2005-02-08','12-2月房价',1,1,1,1,1,1,1,NULL,'449.00','528.00','449.00','528.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-27 17:16:11',4,NULL,0,1,1,NULL,0,0),('PRICE58',1,'0214033',7,'2004-12-27','2005-02-08','12-2月房价',1,1,1,1,1,1,1,NULL,'800.00','920.00','800.00','920.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-27 17:16:46',4,NULL,0,1,1,NULL,0,0),('PRICE59',1,'0214033',21,'2004-12-27','2004-12-31','12月房价',1,1,1,1,1,1,1,NULL,'1000.00','1150.00','1000.00','1150.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-27 17:18:00',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE6',1,'0002',5,'2004-12-24','2004-12-31','12月份房价',1,1,1,1,1,1,1,NULL,'628.00','698.00','628.00','698.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2004-12-24 15:00:30',4,NULL,0,1,1,NULL,0,0),('PRICE60',1,'0214033',21,'2005-01-01','2005-02-08','1-2月房价',1,1,1,1,1,1,1,NULL,'1000.00','1150.00','1000.00','1150.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-27 17:18:25',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE61',1,'0215001',2,'2004-12-28','2005-01-02','12月份价格',1,1,1,1,1,1,1,NULL,'0.00','0.00','588.00','588.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2004-12-28 16:41:09',4,NULL,0,1,1,NULL,0,0),('PRICE61',2,'0215001',2,'2004-12-28','2005-01-02','12月份价格',0,0,0,0,1,1,1,NULL,'0.00','0.00','488.00','488.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2004-12-28 00:00:00',4,NULL,0,1,1,NULL,0,0),('PRICE62',1,'0215001',150,'2004-12-28','2005-01-02','12月份价格',1,1,1,1,1,1,1,NULL,'1100.00','1100.00','1200.00','1200.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2004-12-28 16:44:13',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE63',1,'0215001',2,'2005-01-01','2005-12-31','12月份房价',1,1,1,1,1,1,1,NULL,'0.00','0.00','300.00','300.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2004-12-28 16:54:18',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE64',1,'0215001',548,'2005-01-01','2005-12-31','12月份周末房价',0,0,0,0,1,1,1,NULL,'0.00','0.00','400.00','400.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2004-12-28 16:54:55',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE64',2,'0215001',548,'2005-01-01','2005-03-31','12月份周末房价',0,0,0,0,1,1,1,NULL,'0.00','0.00','400.00','400.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2004-12-28 00:00:00',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE64',3,'0215001',548,'2005-01-01','2005-03-31','12月份周末房价',0,0,0,0,1,1,1,NULL,'0.00','0.00','250.00','250.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2004-12-28 00:00:00',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE65',1,'0215001',378,'2005-01-10','2005-01-20','12月份特价房价',1,1,1,1,1,1,1,NULL,'0.00','0.00','500.00','500.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,1,'2004-12-28 16:56:13',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE65',2,'0215001',378,'2005-01-10','2005-01-20','12月份特价房价',1,1,1,1,1,1,1,NULL,'0.00','0.00','200.00','200.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,1,'2004-12-28 00:00:00',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE66',1,'0215002',5,'2004-12-17','2005-02-04','12月下旬到2月4日',1,1,1,1,1,1,1,NULL,'682.20','682.20','758.00','758.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2004-12-30 10:50:01',3,NULL,0,1,NULL,NULL,0,0),('PRICE66',2,'0215002',5,'2004-12-17','2005-02-04','12月下旬到2月4日',1,1,1,1,1,1,1,NULL,'682.20','682.20','758.00','758.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,0,0,0,'2004-12-30 00:00:00',3,NULL,0,1,NULL,NULL,0,0),('PRICE66',3,'0215002',5,'2004-12-17','2005-02-04','12月下旬到2月4日',1,1,1,1,1,1,1,NULL,'682.20','682.20','758.00','758.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-30 00:00:00',3,NULL,0,1,1,NULL,0,0),('PRICE67',1,'0215002',6,'2004-12-17','2005-02-04','12月下旬到2月4日',1,1,1,1,1,1,1,NULL,'862.20','862.20','958.00','958.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,0,0,0,'2004-12-30 10:52:12',3,NULL,0,1,NULL,NULL,0,0),('PRICE67',2,'0215002',6,'2004-12-17','2005-02-04','12月下旬到2月4日',1,1,1,1,1,1,1,NULL,'862.20','862.20','958.00','958.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-30 00:00:00',3,NULL,0,1,1,NULL,0,0),('PRICE68',1,'0215002',526,'2004-12-17','2005-02-04','12月下旬到2月4日',1,1,1,1,1,1,1,NULL,'1269.90','1269.90','1411.00','1411.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,0,0,0,'2004-12-30 10:54:16',3,NULL,0,1,NULL,NULL,0,0),('PRICE68',2,'0215002',526,'2004-12-17','2005-02-04','12月下旬到2月4日',1,1,1,1,1,1,1,NULL,'1269.90','1269.90','1411.00','1411.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2004-12-30 00:00:00',3,'无',0,1,NULL,NULL,0,0),('PRICE68',3,'0215002',526,'2004-12-17','2005-02-04','12月下旬到2月4日',1,1,1,1,1,1,1,NULL,'1269.90','1269.90','1411.00','1411.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-30 00:00:00',3,NULL,0,1,NULL,NULL,0,0),('PRICE69',1,'0215002',174,'2004-12-17','2005-02-04','12月下旬到2月4日',1,1,1,1,1,1,1,NULL,'1814.40','1814.40','2016.00','2016.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-30 10:55:49',3,NULL,0,1,NULL,NULL,0,0),('PRICE7',1,'0002',6,'2004-12-24','2004-12-31','12月份房价',1,1,1,1,1,1,1,NULL,'898.00','998.00','898.00','998.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2004-12-24 15:00:53',4,NULL,0,1,1,NULL,0,0),('PRICE7',2,'0002',6,'2004-12-24','2004-12-31','12月份房价',1,1,1,1,1,1,1,NULL,'898.00','898.00','998.00','998.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,0,0,0,'2004-12-24 00:00:00',4,NULL,0,1,1,NULL,0,0),('PRICE70',1,'0215004',6,'2004-12-01','2005-02-28','12.01-2005.02.28',1,1,1,1,1,0,0,NULL,'745.20','745.20','828.00','828.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,0,0,0,'2004-12-30 11:03:40',3,NULL,0,1,NULL,NULL,0,0),('PRICE71',1,'0215004',6,'2004-12-01','2005-02-28','12.01-2005.02.28',0,0,0,0,0,1,1,NULL,'619.20','619.20','688.00','688.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,2,0,0,'2004-12-30 11:04:07',3,NULL,0,1,NULL,NULL,0,0),('PRICE71',2,'0215004',6,'2004-12-01','2005-02-28','',0,0,0,0,0,1,1,NULL,'619.20','619.20','688.00','700.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,2,0,0,'2004-12-30 00:00:00',3,NULL,0,1,NULL,NULL,0,0),('PRICE71',3,'0215004',6,'2004-12-01','2005-02-28','',0,0,0,0,0,1,1,NULL,'619.20','619.20','688.00','700.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,2,0,1,'2004-12-30 00:00:00',3,NULL,0,1,NULL,NULL,0,0),('PRICE72',1,'0215008',399,'2004-12-30','2005-01-09','2',1,1,1,1,1,1,1,NULL,'0.00','0.00','676.00','676.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-30 14:12:41',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE73',1,'0215008',399,'2005-02-05','2005-02-17','2',1,1,1,1,1,1,1,NULL,'0.00','0.00','676.00','676.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-30 14:14:04',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE74',1,'0215008',399,'2005-01-10','2005-02-04','2',1,1,1,1,1,1,1,NULL,'0.00','0.00','1021.00','1021.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-30 14:14:40',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE75',1,'0215008',399,'2005-02-18','2005-02-28','2',1,1,1,1,1,1,1,NULL,'0.00','0.00','1021.00','1021.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-30 14:14:57',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE76',1,'0215008',400,'2005-02-18','2005-02-28','2',1,1,1,1,1,1,1,NULL,'0.00','0.00','1021.00','1021.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-30 14:15:34',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE77',1,'0215008',400,'2005-01-10','2005-02-04','2',1,1,1,1,1,1,1,NULL,'0.00','0.00','1021.00','1021.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-30 14:15:44',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE78',1,'0215008',400,'2004-12-30','2005-01-09','2',1,1,1,1,1,1,1,NULL,'0.00','0.00','676.00','676.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2004-12-30 14:16:05',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE78',2,'0215008',400,'2005-02-05','2005-02-17','2',1,1,1,1,1,1,1,NULL,'0.00','0.00','676.00','676.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-30 00:00:00',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE79',1,'0215008',401,'2004-12-30','2005-02-28','2',1,1,1,1,1,1,1,NULL,'0.00','0.00','1149.00','1149.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-30 14:16:58',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE8',1,'0002',7,'2004-12-24','2004-12-31','12月份房价',1,1,1,1,1,1,1,NULL,'1080.00','1200.00','1080.00','1200.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2004-12-24 15:01:11',4,NULL,0,1,1,NULL,0,0),('PRICE8',2,'0002',7,'2004-12-24','2004-12-31','12月份房价',1,1,1,1,1,1,1,NULL,'1080.00','1080.00','1200.00','1200.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,0,0,0,'2004-12-24 00:00:00',4,NULL,0,1,1,NULL,0,0),('PRICE80',1,'0215008',402,'2004-12-30','2005-02-28','2',1,1,1,1,1,1,1,NULL,'0.00','0.00','1321.00','1321.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-30 14:17:23',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE81',1,'0214001',2,'2004-12-30','2005-01-31','2',1,1,1,1,1,1,1,NULL,'538.00','538.00','598.00','598.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2004-12-30 14:20:23',4,NULL,0,1,1,NULL,0,0),('PRICE81',2,'0214001',2,'2004-12-30','2005-01-31','2',1,1,1,1,0,0,0,NULL,'538.00','538.00','598.00','598.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-30 00:00:00',4,NULL,0,1,1,NULL,0,0),('PRICE82',1,'0214001',2,'2004-12-30','2005-01-31','2',0,0,0,0,1,1,1,NULL,'448.00','448.00','498.00','498.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-30 14:20:47',4,NULL,0,1,1,NULL,0,0),('PRICE83',1,'0214007',763,'2004-12-30','2005-02-28','2',1,1,1,1,1,1,1,NULL,'548.00','548.00','598.00','598.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-30 14:22:27',4,NULL,0,1,1,NULL,0,0),('PRICE84',1,'0215009',3,'2004-12-01','2004-12-31','2',1,1,1,1,1,1,1,NULL,'1200.00','1396.50','1250.00','1529.50','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-30 14:25:41',4,NULL,0,1,1,NULL,0,0),('PRICE85',1,'0215009',3,'2004-12-01','2004-12-31','2',0,0,0,0,1,1,1,NULL,'918.00','918.00','998.00','998.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-30 14:26:30',4,NULL,0,1,1,NULL,0,0),('PRICE86',1,'0213068',2,'2004-12-31','2005-01-02','2',1,1,1,1,1,1,1,NULL,'320.00','320.00','380.00','380.00','558.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-30 14:37:41',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE87',1,'0214003',377,'2005-01-06','2005-01-10','2',1,1,1,1,1,1,1,NULL,'680.00','680.00','710.00','710.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2004-12-30 14:42:25',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE87',2,'0214003',377,'2005-01-06','2005-01-10','',1,1,1,1,1,1,1,'23','680.00','680.00','710.00','710.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-30 00:00:00',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE88',1,'0214002',418,'2005-01-09','2005-01-10','2',1,1,1,1,1,1,1,NULL,'0.00','1016.40','0.00','1131.20','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,1,0,0,'2004-12-30 14:45:07',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE89',1,'0215019',688,'2005-01-01','2005-12-31','2',1,1,1,1,1,1,1,NULL,'2835.00','2835.00','2935.00','3105.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-30 14:51:02',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE9',1,'0002',1,'2004-12-24','2004-12-31','平日',1,1,1,1,1,1,1,NULL,'538.00','538.00','598.00','598.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-24 15:29:18',4,NULL,0,1,1,NULL,0,0),('PRICE90',1,'0212002',448,'2005-01-01','2005-02-28','2',1,1,1,1,1,1,1,NULL,'350.00','350.00','400.00','400.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,2,0,0,'2004-12-30 14:53:13',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE90',2,'0212002',448,'2005-01-01','2005-02-28','',1,1,1,1,1,1,1,NULL,'350.00','350.00','400.00','400.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,2,0,1,'2004-12-30 00:00:00',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE91',1,'0215008',400,'2004-12-30','2005-01-09','2',1,1,1,1,1,1,1,NULL,'0.00','0.00','676.00','676.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-30 14:59:44',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE92',1,'0215009',273,'2005-01-29','2005-02-02','2',1,1,1,1,1,1,1,NULL,'0.00','1547.70','0.00','1695.10','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-30 15:43:00',1,NULL,0,NULL,NULL,NULL,0,0),('PRICE93',1,'0215001',2,'2004-12-31','2005-01-02','2',1,1,1,1,1,1,1,NULL,'0.00','0.00','588.00','588.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-31 13:47:07',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE94',1,'0215001',2,'2005-01-03','2005-01-31','2',1,1,1,1,1,1,1,NULL,'0.00','0.00','799.00','799.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-31 13:52:43',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE95',1,'0212003',2,'2004-12-31','2005-12-31','2',1,1,1,1,1,1,1,NULL,'168.00','168.00','218.00','218.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,2,0,0,'2004-12-31 14:02:48',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE95',2,'0212003',2,'2004-12-31','2005-12-31','',1,1,1,1,1,1,1,NULL,'168.00','168.00','218.00','218.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,2,0,1,'2004-12-31 00:00:00',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE96',1,'0214041',5,'2004-12-31','2005-02-15','2',1,1,1,1,1,1,1,NULL,'421.00','421.00','468.00','468.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2004-12-31 14:10:47',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE97',1,'4114019',2,'2005-01-04','2005-03-30','',1,1,1,1,1,1,1,NULL,'328.00','328.00','378.00','378.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-04 15:11:55',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE98',1,'0214019',797,'2005-01-04','2005-02-28','',1,1,1,1,1,1,1,NULL,'664.00','664.00','738.00','738.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-04 15:16:30',4,NULL,0,NULL,NULL,NULL,0,0),('PRICE99',1,'0214062',1099,'2005-01-04','2005-02-28','',1,1,1,1,1,1,1,NULL,'348.00','348.00','398.00','398.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,1,0,0,'2005-01-04 15:20:06',4,NULL,0,NULL,NULL,NULL,0,0);
UNLOCK TABLES;
/*!40000 ALTER TABLE `t_price` ENABLE KEYS */;

DROP TABLE IF EXISTS `t_reserve`;
CREATE TABLE `t_reserve` (
  `ReserveCode` varchar(32) NOT NULL default '',
  `ReserveCustomer` varchar(32) NOT NULL default '',
  `ReserveHotel` varchar(32) NOT NULL default '',
  `ReserveFax` varchar(32) default '',
  `ReservePhone` varchar(32) default '',
  `ReserveAddress` varchar(255) default '',
  `ReserveDate` date NOT NULL default '0000-00-00',
  `ReserveVersion` int(10) unsigned NOT NULL default '0',
  `ReserveDelflag` tinyint(1) NOT NULL default '0',
  `ReserveOperator` int(10) unsigned NOT NULL default '0',
  `ReserveLastUpdateDate` datetime NOT NULL default '0000-00-00 00:00:00',
  `ReserveLastUpdateOperator` int(10) unsigned NOT NULL default '0',
  `ReserveMemo` varchar(255) default '',
  `ReserveNum` int(10) unsigned NOT NULL default '0',
  `ReserveDebitType` int(10) unsigned NOT NULL default '0',
  `ReserveCredittype` int(10) unsigned NOT NULL default '0',
  `ReserveLatestCheckInTime` varchar(32) default '',
  `ReserveFinanceModified` tinyint(3) default '0',
  PRIMARY KEY  (`ReserveCode`,`ReserveVersion`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

--
-- Dumping data for table `t_reserve`
--


/*!40000 ALTER TABLE `t_reserve` DISABLE KEYS */;
LOCK TABLES `t_reserve` WRITE;
INSERT INTO `t_reserve` VALUES ('R05020502','0001','0215004','63234825','63236615','中山东一路7号五楼','2005-02-09',1,0,1,'2005-02-09 22:12:45',1,NULL,1,1,1,NULL,NULL);
UNLOCK TABLES;
/*!40000 ALTER TABLE `t_reserve` ENABLE KEYS */;

--
-- Table structure for table `t_reservedetail`
--

DROP TABLE IF EXISTS `t_reservedetail`;
CREATE TABLE `t_reservedetail` (
  `ReserveCode` varchar(32) NOT NULL default '',
  `ReserveVersion` int(10) unsigned NOT NULL default '0',
  `ReserveDetailNo` int(10) unsigned NOT NULL default '0',
  `ReserveCustomerName` varchar(32) NOT NULL default '',
  `ReserveRoomNo` varchar(32) default '',
  `ReserveConfirmNo` varchar(32) default '',
  `ReserveDetailState` int(10) unsigned NOT NULL default '0',
  `ReserveMemo` varchar(128) default '',
  `ReserveCheckInDate` datetime NOT NULL default '0000-00-00 00:00:00',
  `ReserveCheckOutDate` datetime NOT NULL default '0000-00-00 00:00:00',
  `ReserveRealCheckInDate` datetime default NULL,
  `ReserveRealCheckOutDate` datetime default NULL,
  `ReserveDebit` decimal(15,2) default '0.00',
  `ReserveCredit` decimal(15,2) default '0.00',
  `ReserveDummyDebit` decimal(15,2) default '0.00',
  `ReserveDummyCredit` decimal(15,2) default '0.00',
  `ReserveDebitCommitted` decimal(15,2) default '0.00',
  `ReserveCreditCommitted` decimal(15,2) default '0.00',
  `ReserveRebatePoint` decimal(15,2) default '0.00',
  `ReserveRebateDate` datetime default NULL,
  `ReserveNightAuditOp` tinyint(3) default '0',
  `ReserveOpIncome` decimal(15,2) default '0.00',
  `ReserveSalesIncome` decimal(15,2) default '0.00',
  `ReserveDebitCommitDay` datetime default NULL,
  `ReserveCreditCommitDay` datetime default NULL,
  `ReserveRebateRate` decimal(15,2) default '0.00',
  PRIMARY KEY  (`ReserveCode`,`ReserveVersion`,`ReserveDetailNo`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

--
-- Dumping data for table `t_reservedetail`
--


/*!40000 ALTER TABLE `t_reservedetail` DISABLE KEYS */;
LOCK TABLES `t_reservedetail` WRITE;
INSERT INTO `t_reservedetail` VALUES ('R05020502',1,1,'WL',NULL,NULL,2,'','2005-02-01 00:00:00','2005-02-08 00:00:00',NULL,NULL,'0.00','0.00','5516.00','4964.40','0.00','0.00','0.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL);
UNLOCK TABLES;
/*!40000 ALTER TABLE `t_reservedetail` ENABLE KEYS */;

DROP TABLE IF EXISTS `m_hotel`;
CREATE TABLE `m_hotel` (
  `HotelCode` varchar(32) NOT NULL default '',
  `HotelName` varchar(255) NOT NULL default '',
  `HotelEnglishName` varchar(255) default '',
  `HotelCity` int(10) unsigned NOT NULL default '0',
  `HotelRate` int(10) unsigned NOT NULL default '0',
  `HotelAddress` varchar(255) default '',
  `HotelAccountNo` varchar(32) default '',
  `HotelContactPerson` varchar(32) default '',
  `HotelPhone` varchar(32) default '',
  `HotelFax` varchar(32) default '',
  `HotelMobile` varchar(32) default '',
  `HotelDelFlag` tinyint(1) unsigned NOT NULL default '0',
  `HotelEmail` varchar(64) default '',
  `HotelWebsite` varchar(64) default '',
  `HotelManagement` varchar(32) default '',
  `HotelOpenYear` varchar(8) default '',
  `HotelLastDecoration` varchar(8) default '',
  `HotelArea` int(10) unsigned default '0',
  `HotelMainLine` varchar(32) default '',
  `HotelFreePhone` varchar(32) default '',
  `HotelEmergencyPhone` varchar(32) default '',
  `HotelFinanceContactPerson` varchar(32) default '',
  `HotelFinancePhone` varchar(32) default '',
  `HotelFinanceFax` varchar(32) default '',
  `HotelCrossRoad` varchar(64) default '',
  `HotelDistanceToCenter` varchar(16) default '',
  `HotelDistanceToAirport1` varchar(16) default '',
  `HotelDistanceToAirport2` varchar(16) default '',
  `HotelDistanceToRailwayStation` varchar(16) default '',
  `HotelViewPoint` varchar(128) default '',
  `HotelNumOfRoom` varchar(4) default '',
  `HotelNumOfRoomType1` varchar(4) default '',
  `HotelNumOfRoomType2` varchar(4) default '',
  `HotelNumOfRoomType3` varchar(4) default '',
  `HotelNumOfRoomType4` varchar(4) default '',
  `HotelNumOfRoomType5` varchar(4) default '',
  `HotelNumOfRoomType6` varchar(4) default '',
  `HotelNumOfRoomType7` varchar(4) default '',
  `HotelNumOfRoomType8` varchar(4) default '',
  `HotelNumOfOtherRoomType` varchar(32) default '',
  `HotelRoomInnerFacility` varchar(64) default '0000000000000000000000000000000000000000000000000000000000000000',
  `HotelFacility` varchar(32) default '00000000000000000000000000000000',
  `HotelEnterFacility` varchar(32) default '00000000000000000000000000000000',
  `HotelOtherEnterFacility` varchar(32) default '',
  `HotelBusinessFacility` varchar(32) default '00000000000000000000000000000000',
  `HotelBusinessFacilityFee` varchar(32) default '',
  `HotelNumOfCoffee` varchar(4) default '',
  `HotelNumOfChineseRest` varchar(4) default '',
  `HotelChineseRestIntro` varchar(32) default '',
  `HotelNumOfWesternRest` varchar(4) default '',
  `HotelWesternRestIntro` varchar(32) default '',
  `HotelDeliveryService` tinyint(1) default '0',
  `HotelDeliveryStartTime` varchar(4) default '',
  `HotelDeliveryEndTime` varchar(4) default '',
  `HotelOtherDelivery` varchar(32) default '',
  `HotelCreditCard` varchar(16) default '0000000000000000',
  `HotelOtherCreditCard` varchar(32) default '',
  `HotelPost` varchar(16) default '',
  `HotelCreateDate` datetime NOT NULL default '0000-00-00 00:00:00',
  `HotelMarketOp` int(10) unsigned NOT NULL default '0',
  `HotelPriceMemo` varchar(255) default '',
  `HotelPayOnCounter` tinyint(1) unsigned NOT NULL default '1',
  `HotelPayOnDeposit` tinyint(1) unsigned NOT NULL default '1',
  `HotelPayOnMonth` tinyint(1) unsigned NOT NULL default '1',
  PRIMARY KEY  (`HotelCode`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;


/*!40000 ALTER TABLE `m_hotel` DISABLE KEYS */;
LOCK TABLES `m_hotel` WRITE;
INSERT INTO `m_hotel` VALUES ('0215004','ff','Huating Tower',1,5,'ff','','ff','33','33','333',0,'','','','','',0,'','','','','','','','','','','','','','','','','','','','','','','0000000000000000000000000000000000000000000000000000000000000000','00000000000000000000000000000000','00000000000000000000000000000000','','00000000000000000000000000000000','','','','','','',0,'','','','0000000000000000','','200030','2005-01-01 00:01:42',1,'',1,1,1);
UNLOCK TABLES;
/*!40000 ALTER TABLE `m_hotel` ENABLE KEYS */;


DROP TABLE IF EXISTS `m_user`;
CREATE TABLE `m_user` (
  `UserID` int(10) unsigned NOT NULL auto_increment,
  `UserName` varchar(32) NOT NULL default '',
  `UserRealName` varchar(32) NOT NULL default '',
  `UserPassword` varchar(32) NOT NULL default '',
  `UserEmail` varchar(64) NOT NULL default '',
  `UserMarket` tinyint(1) NOT NULL default '0',
  `UserMarketManager` tinyint(1) NOT NULL default '0',
  `UserSales` tinyint(1) NOT NULL default '0',
  `UserSalesManager` tinyint(1) NOT NULL default '0',
  `UserFinance` tinyint(1) NOT NULL default '0',
  `UserFinanceManager` tinyint(1) NOT NULL default '0',
  `UserReserve` tinyint(1) NOT NULL default '0',
  `UserReserveManager` tinyint(1) NOT NULL default '0',
  `UserNightAudit` tinyint(1) NOT NULL default '0',
  `UserAdmin` tinyint(1) NOT NULL default '0',
  `UserActiveFlag` tinyint(1) NOT NULL default '0',
  `UserDelFlag` tinyint(1) NOT NULL default '0',
  `UserBasicInfo` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`UserID`),
  UNIQUE KEY `UserName` (`UserName`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;


/*!40000 ALTER TABLE `m_user` DISABLE KEYS */;
LOCK TABLES `m_user` WRITE;
INSERT INTO `m_user` VALUES (1,'Admin','ff','Admin','Admin@Admin.com',1,1,1,1,1,1,1,1,1,1,1,0,0);
UNLOCK TABLES;
/*!40000 ALTER TABLE `m_user` ENABLE KEYS */;


DROP TABLE IF EXISTS `m_roomtype`;
CREATE TABLE `m_roomtype` (
  `ROOMCODE` int(10) unsigned NOT NULL auto_increment,
  `ROOMNAME` varchar(64) NOT NULL default '',
  `ROOMMEMO` varchar(128) default '',
  PRIMARY KEY  (`ROOMCODE`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;


/*!40000 ALTER TABLE `m_roomtype` DISABLE KEYS */;
LOCK TABLES `m_roomtype` WRITE;
INSERT INTO `m_roomtype` VALUES (1,'aa',''),(2,'bb',''),(3,'dd','');
UNLOCK TABLES;
/*!40000 ALTER TABLE `m_roomtype` ENABLE KEYS */;

DROP TABLE IF EXISTS `t_price`;
CREATE TABLE `t_price` (
  `PriceCode` varchar(32) NOT NULL default '',
  `Version` int(10) unsigned NOT NULL default '0',
  `HotelCode` varchar(32) NOT NULL default '',
  `RoomTypeCode` int(10) unsigned NOT NULL default '0',
  `StartDate` date NOT NULL default '0000-00-00',
  `EndDate` date NOT NULL default '0000-00-00',
  `PriceName` varchar(32) NOT NULL default '',
  `Monday` tinyint(1) NOT NULL default '0',
  `Tuesday` tinyint(1) NOT NULL default '0',
  `Wednesday` tinyint(1) NOT NULL default '0',
  `Thursday` tinyint(1) NOT NULL default '0',
  `Friday` tinyint(1) NOT NULL default '0',
  `Saturday` tinyint(1) NOT NULL default '0',
  `Sunday` tinyint(1) NOT NULL default '0',
  `TouristCompanyCode` varchar(32) default '0',
  `PricePurchasePrice1` decimal(16,2) NOT NULL default '0.00',
  `PricePurchasePrice2` decimal(16,2) NOT NULL default '0.00',
  `PriceSellPrice1` decimal(16,2) NOT NULL default '0.00',
  `PriceSellPrice2` decimal(16,2) NOT NULL default '0.00',
  `PriceCounterPrice` decimal(16,2) NOT NULL default '0.00',
  `PriceHKPurchasePrice` decimal(16,2) default '0.00',
  `PriceHKSellPrice` decimal(16,2) default '0.00',
  `PriceHKExchangeRate` decimal(16,2) default '0.00',
  `PriceUSPurchasePrice` decimal(16,2) default '0.00',
  `PriceUSSellPrice` decimal(16,2) default '0.00',
  `PriceUSExchangeRate` decimal(16,2) default '0.00',
  `ServiceFeeRatio` decimal(5,2) NOT NULL default '0.00',
  `RebateRatio` decimal(5,2) NOT NULL default '0.00',
  `PriceDelFlag` tinyint(1) NOT NULL default '0',
  `PriceMaskFlag` tinyint(1) NOT NULL default '0',
  `PriceVisible` tinyint(1) NOT NULL default '0',
  `PriceSpecialFlag` tinyint(1) NOT NULL default '0',
  `PriceCreateDate` datetime NOT NULL default '0000-00-00 00:00:00',
  `PriceCreator` int(10) unsigned NOT NULL default '0',
  `PriceMemo` varchar(128) default '',
  `PriceWebsiteUpdate` tinyint(1) NOT NULL default '0',
  `PayOnCounter` tinyint(1) default '0',
  `PayOnDeposit` tinyint(1) default '0',
  `PayOnMonth` tinyint(1) default '0',
  `PriceRecommend` tinyint(3) NOT NULL default '0',
  `PriceWebsiteVisible` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`PriceCode`,`Version`),
  KEY `HOTEL_IDX` (`HotelCode`,`RoomTypeCode`),
  KEY `DATE_IDX` (`StartDate`,`EndDate`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;

LOCK TABLES `t_price` WRITE;
INSERT INTO `t_price` VALUES ('PRICE70',1,'0215004',6,'2004-12-01','2005-02-28','12.01-2005.02.28',1,1,1,1,1,0,0,NULL,'745.20','745.20','828.00','828.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,0,0,0,'2004-12-30 11:03:40',3,NULL,0,1,NULL,NULL,0,0),('PRICE71',1,'0215004',6,'2004-12-01','2005-02-28','12.01-2005.02.28',0,0,0,0,0,1,1,NULL,'619.20','619.20','688.00','688.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,2,0,0,'2004-12-30 11:04:07',3,NULL,0,1,NULL,NULL,0,0),('PRICE71',2,'0215004',6,'2004-12-01','2005-02-28','',0,0,0,0,0,1,1,NULL,'619.20','619.20','688.00','700.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',1,2,0,0,'2004-12-30 00:00:00',3,NULL,0,1,NULL,NULL,0,0),('PRICE71',3,'0215004',6,'2004-12-01','2005-02-28','',0,0,0,0,0,1,1,NULL,'619.20','619.20','688.00','700.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00','0.00',0,2,0,1,'2004-12-30 00:00:00',3,NULL,0,1,NULL,NULL,0,0);
UNLOCK TABLES;

DROP TABLE IF EXISTS `t_reservedetailprice`;
CREATE TABLE `t_reservedetailprice` (
  `ReserveCode` varchar(32) NOT NULL default '',
  `ReserveVersion` int(10) unsigned NOT NULL default '0',
  `ReserveDetailNo` int(10) unsigned NOT NULL default '0',
  `ReserveStartDate` date NOT NULL default '0000-00-00',
  `ReserveEndDate` date NOT NULL default '0000-00-00',
  `ReserveSpecialPrice` decimal(15,2) NOT NULL default '0.00',
  `ReservePriceCode` varchar(32) NOT NULL default '',
  `ReservePriceVersion` int(10) unsigned NOT NULL default '0',
  `ReserveTouristPrice` decimal(15,2) NOT NULL default '0.00',
  PRIMARY KEY  (`ReserveCode`,`ReserveVersion`,`ReserveDetailNo`,`ReserveStartDate`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;


/*!40000 ALTER TABLE `t_reservedetailprice` DISABLE KEYS */;
LOCK TABLES `t_reservedetailprice` WRITE;
INSERT INTO `t_reservedetailprice` VALUES ('R05020502',1,1,'2005-02-01','2005-02-05','0.00','PRICE70',1,'0.00'),('R05020502',1,1,'2005-02-05','2005-02-07','0.00','PRICE71',1,'0.00'),('R05020502',1,1,'2005-02-07','2005-02-08','0.00','PRICE70',1,'0.00');
UNLOCK TABLES;
/*!40000 ALTER TABLE `t_reservedetailprice` ENABLE KEYS */;


#valid reserves(max version)
create view v_validreserve as
select t.* from t_reserve t
where reservedelflag=0;

#valid reservedetails
create view v_validreservedetail as 
select t.* from t_reservedetail t,v_validreserve v
where t.reservecode=v.reservecode
and t.reserveversion=v.reserveversion;

#valid reserve detail price
create view v_validreservedetailprice as 
select t.* from T_ReserveDetailPrice t,v_validreserve v
where t.reservecode=v.reservecode
and t.reserveversion=v.reserveversion;

#night audit list
create view v_normalnightaudit as
select D.ReserveCode,D.ReserveVersion,D.ReserveDetailNo,D.ReserveCustomerName,
D.ReserveConfirmNo,D.ReserveRoomNo,D.ReserveDetailState,D.ReserveCheckInDate,
D.ReserveCheckOutDate,D.ReserveRealCheckInDate,D.ReserveRealCheckOutDate,
H.HotelName,U.UserRealName,R.RoomName,T.ReserveHotel
from v_validreserve T,v_validreservedetail D,
v_validreservedetailprice P,T_Price E,
M_Hotel H,M_User U,M_RoomType R 
where P.ReserveCode=T.ReserveCode
and TO_DAYS(P.ReserveStartDate)=TO_DAYS(D.ReserveCheckInDate)
and D.ReserveDetailNo=P.ReserveDetailNo
and P.ReservePriceCode=E.PriceCode
and P.ReservePriceVersion=E.Version
and R.RoomCode=E.RoomTypeCode
and T.ReserveCode=D.ReserveCode
and T.ReserveHotel=H.HotelCode
and T.ReserveLastUpdateOperator=U.UserID    
and ((D.ReserveCheckInDate<=CurDate() AND D.ReserveRealCheckInDate IS NULL 
AND (D.ReserveDetailState='2' OR D.ReserveDetailState='1'))
or (D.ReserveDetailState='8' AND D.ReserveRealCheckInDate IS NOT NULL 
AND D.ReserveRealCheckOutDate IS NULL))
order by IF(D.ReserveRealCheckInDate IS NULL,1,2),D.ReserveCheckOutDate;