hoteldb.sql

酒店管理系统,您酒店物业管理的好帮手

insert nationality values(1664,'蒙特塞拉特岛','Montserrat Is','MS')
insert nationality values(212,'摩洛哥','Morocco','MA')
insert nationality values(258,'莫桑比克','Mozambique','MZ')
insert nationality values(264,'纳米比亚','Namibia ','NA')
insert nationality values(674,'瑙鲁','Nauru','NR')
insert nationality values(977,'尼泊尔','Nepal','NP')
insert nationality values(31,'荷兰','Netherlands','NL')
insert nationality values(64,'新西兰','New Zealand','NZ')
insert nationality values(505,'尼加拉瓜','Nicaragua','NI')
insert nationality values(227,'尼日尔','Niger','NE')
insert nationality values(234,'尼日利亚','Nigeria','NG')
insert nationality values(850,'朝鲜','North Korea','KP')
insert nationality values(47,'挪威','Norway','NO')
insert nationality values(968,'阿曼','Oman','OM')
insert nationality values(92,'巴基斯坦','Pakistan','PK')
insert nationality values(507,'巴拿马','Panama','PA')
insert nationality values(675,'巴布亚新几内亚','Papua New Cuinea','PG')
insert nationality values(595,'巴拉圭','Paraguay','PY')
insert nationality values(51,'秘鲁','Peru','PE')
insert nationality values(63,'菲律宾','Philippines','PH')
insert nationality values(48,'波兰','Poland','PL')
insert nationality values(689,'法属玻利尼西亚','French Polynesia','PF')
insert nationality values(351,'葡萄牙','Portugal','PT')
insert nationality values(1787,'波多黎各','Puerto Rico','PR')
insert nationality values(974,'卡塔尔','Qatar','QA')
insert nationality values(40,'罗马尼亚','Romania','RO')
insert nationality values(7,'俄罗斯','Russia','RU')
insert nationality values(1758,'圣卢西亚','Saint Lueia','LC')
insert nationality values(1784,'圣文森特岛','Saint Vincent','VC')
insert nationality values(378,'圣马力诺','San Marino','SM')  
insert nationality values(239,'圣多美和普林西比','Sao Tome and Principe','ST')
insert nationality values(966,'沙特阿拉伯','Saudi Arabia','SA')
insert nationality values(221,'塞内加尔','Senegal','SN')
insert nationality values(248,'塞舌尔','Seychelles','SC')
insert nationality values(232,'塞拉利昂','Sierra Leone','SL')
insert nationality values(65,'新加坡','Singapore','SG')
insert nationality values(421,'斯洛伐克','Slovakia','SK')
insert nationality values(386,'斯洛文尼亚','Slovenia','SI')
insert nationality values(677,'所罗门群岛','Solomon Is','SB')
insert nationality values(252,'索马里','Somali','SO')
insert nationality values(27,'南非','South Africa','ZA')
insert nationality values(34,'西班牙','Spain','ES')
insert nationality values(94,'斯里兰卡','Sri Lanka','LK')
insert nationality values(1758,'圣卢西亚','St.Lucia','LC')
insert nationality values(1784,'圣文森特','St.Vincent','VC')
insert nationality values(249,'苏丹','Sudan','SD')
insert nationality values(597,'苏里南','Suriname','SR')
insert nationality values(268,'斯威士兰','Swaziland','SZ')
insert nationality values(46,'瑞典','Sweden','SE')
insert nationality values(41,'瑞士','Switzerland','CH')
insert nationality values(963,'叙利亚','Syria','SY')
insert nationality values(886,'台湾省','Taiwan','TW')
insert nationality values(992,'塔吉克斯坦','Tajikstan','TJ')
insert nationality values(255,'坦桑尼亚','Tanzania','TZ')
insert nationality values(66,'泰国','Thailand','TH')
insert nationality values(228,'多哥','Togo','TG')
insert nationality values(676,'汤加','Tonga','TO')
insert nationality values(1809,'特立尼达和多巴哥','Trinidad and Tobago','TT')
insert nationality values(216,'突尼斯','Tunisia','TN')
insert nationality values(90,'土耳其','Turkey','TR')
insert nationality values(993,'土库曼斯坦','Turkmenistan ','TM')
insert nationality values(256,'乌干达','Uganda','UG')
insert nationality values(380,'乌克兰','Ukraine','UA')
insert nationality values(971,'阿拉伯联合酋长国','United Arab Emirates','AE')
insert nationality values(44,'英国','United Kiongdom','GB')
insert nationality values(1,'美国','United States of ','US')
insert nationality values(598,'乌拉圭','Uruguay','UY')
insert nationality values(233,'乌兹别克斯坦','Uzbekistan','UZ')
insert nationality values(58,'委内瑞拉','Venezuela','VE')
insert nationality values(84,'越南','Vietnam','VN')
insert nationality values(967,'也门','Yemen','YE')
insert nationality values(381,'南斯拉夫','Yugoslavia','YU')
insert nationality values(263,'津巴布韦','Zimbabwe','ZW')
insert nationality values(243,'扎伊尔','Zaire','ZR')
insert nationality values(260,'赞比亚','Zambia','ZM')

-----------------省份------------------

select * from province
insert province values('广东省')
insert province values('福建省')

-------------------证件类型---------------------

select * from certificate
insert certificate values('身份证')
insert certificate values('军官证')




------------------插入数据

select * from buyer

insert buyer values('李鹏','1986-9-8',1,'440905198609085689','男',15912345644,'天来公司',1,1,'海淀区',default,'无')
insert buyer values('张芝','1987-4-8',1,'440905198704085684','女',13512345644,'航运公司',1,1,'广州市天河',default,'无')
insert buyer values('周华健','1939-7-7',1,'440905193907075889','男',13845678932,'(无)',1,1,'台北',default,'无')
insert buyer values('张小微','1976-5-8',1,'440905197605085684','女',13512785644,'航运公司',1,1,'广州市',default,'无')
insert buyer values('黄妍珍','1978-9-8',1,'422025197809084321','女',13154968648,'(无)',1,1,'台北',default,'无')
insert buyer values('黄娅','1986-9-8',1,'440905198609085689','男',15912095644,'天来公司',1,1,'海淀区',default,'无')
insert buyer values('李婷','1987-4-8',1,'440905198704085684','女',13512145644,'航运公司',1,1,'广州市天河',default,'无')
insert buyer values('朱国玲 ','1966-7-7',1,'440905196607075889','男',13844678932,'(无)',1,1,'台北',default,'无')
insert buyer values('吴宇 ','1986-9-8',1,'440905198609085689','男',15912435644,'天来公司',1,1,'海淀区',default,'无')
insert buyer values('房彩凤','1987-4-8',1,'440905198704085684','女',13989345644,'航运公司',1,1,'广州市天河',default,'无')
insert buyer values('王小五','1939-7-7',1,'440905193907075889','男',13849873932,'(无)',1,1,'台北',default,'无')
insert buyer values('张是三','1986-9-8',1,'440905198609085689','女',15910985644,'天来公司',1,1,'海淀区',default,'无')
insert buyer values('福容王','1987-4-8',1,'440905198704085684','女',13513125644,'航运公司',1,1,'广州市天河',default,'无')
insert buyer values('黄畅','1939-7-7',1,'440905193907075889','女',13396781932,'(无)',1,1,'台北',default,'无')
insert buyer values('向敏','1987-4-8',1,'440905198704085684','女',13512742644,'航运公司',1,1,'广州市天河',default,'无')
insert buyer values('张无计 ','1939-7-7',1,'440905193907075889','男',13844588932,'(无)',1,1,'台北',default,'无')
insert buyer values('阿牛','1976-08-08 ',1,' 440905197608088568 ','女',13512585644,'航运公司',1,1,'广州市',default,'无')
insert buyer values('张柏芝','1958-04-01',1,' 441034195804012628','女',13154967848,'(无)',1,1,'台北',default,'无')
insert buyer values('黄一哒','1978-01-02 ',1,' 456189197801023362','男',15492095455,'天来公司',1,1,'海淀区',default,'无')
insert buyer values('王三小','1970-08-23',1,'468752197008295856','女',13756145644,'航运公司',1,1,'广州市天河',default,'无')
insert buyer values('张劣 ','1988-08-29',1,' 431529198808294562','男',13412678932,'(无)',1,1,'台北',default,'无')
insert buyer values('谷素娟 ','1988-08-18',1,'431022198808182229','男',15903235644,'天来公司',1,1,'海淀区',default,'无')
insert buyer values('谭艳 ','1987-4-8',1,'440905198704085684','女',13989300644,'航运公司',1,1,'广州市天河',default,'无')
insert buyer values('例常全','1988-10-23 ',1,'435691198810234558','男',13119873932,'(无)',1,1,'台北',default,'无')
insert buyer values('李洪 ',' 1988-08-04 ',1,' 431025198808044585 ','女',12220985644,'天来公司',1,1,'海淀区',default,'无')
insert buyer values('白郎宁','1985-01-02',1,'430426198501012012','女',13515555644,'航运公司',1,1,'广州市天河',default,'无')
insert buyer values('琼瑶','1974-12-05 ',1,'431022197412054158','女',13457861932,'(无)',1,1,'台北',default,'无')
insert buyer values('周枉','1967-08-26 ',1,'467312196708268534','女',13512345644,'航运公司',1,1,'广州市天河',default,'无')
insert buyer values('萨斯比亚','1956-03-30',1,'487672195603304324','男',13845678932,'(无)',1,1,'台北',default,'无')
insert buyer values('高尔基 ','1959-01-1',1,'432121195901168764','女',13512785644,'航运公司',1,1,'广州市',default,'无')
insert buyer values('邱秋','1989-09-21',1,'432136198909216543','女',13154968648,'(无)',1,1,'台北',default,'无')
insert buyer values('莱尼斯','1987-03-05',1,'487876198703056431','男',15912095644,'天来公司',1,1,'海淀区',default,'无')
insert buyer values('朗费罗','1998-11-15',1,'479872199811151321','女',13512145644,'航运公司',1,1,'广州市天河',default,'无')
insert buyer values('朱曦 ',' 1943-03-19',1,'443224194303194212','男',13844678932,'(无)',1,1,'台北',default,'无')
insert buyer values('方志敏 ','1923-11-17',1,'443254192311175423','男',15912435644,'天来公司',1,1,'海淀区',default,'无')
insert buyer values('程英','1987-06-16',1,' 412312198706161363','女',13989345644,'航运公司',1,1,'广州市天河',default,'无')
insert buyer values('徐香','1932-08-26',1,'421365193208264412 ','男',13849873932,'(无)',1,1,'台北',default,'无')
insert buyer values('陆俊',' 1987-09-28 ',1,'487654198709284124','女',15910985644,'天来公司',1,1,'海淀区',default,'无')
insert buyer values('冯飞','1987-4-8',1,'440905198704085684','女',13513125644,'航运公司',1,1,'广州市天河',default,'无')
insert buyer values('李勇','1939-7-7',1,'440905193907075889','女',13396781932,'(无)',1,1,'台北',default,'无')
insert buyer values('郭喃喃','1989-05-05',1,'412287198905054232 ','女',13512742644,'航运公司',1,1,'广州市天河',default,'无')
insert buyer values('高伟 ','1939-7-7',1,'440905193907075889','男',13844588932,'(无)',1,1,'台北',default,'无')
insert buyer values('梁景光','1976-08-08 ',1,' 440905197608088568 ','女',13512585644,'航运公司',1,1,'广州市',default,'无')
insert buyer values('藿西 ','1958-04-01',1,' 441034195804012628','女',13154967848,'(无)',1,1,'台北',default,'无')
insert buyer values('黄江煞 ','1978-01-02 ',1,' 456189197801023362','男',15492095455,'天来公司',1,1,'海淀区',default,'无')
insert buyer values('王列宁','1970-08-23',1,'468752197008295856','女',13756145644,'航运公司',1,1,'广州市天河',default,'无')
insert buyer values('邓中夏 ','1988-08-29',1,' 431529198808294562','男',13412678932,'(无)',1,1,'台北',default,'无')
insert buyer values('钱三强  ','1988-08-18',1,'431022198808182229','男',15903235644,'天来公司',1,1,'海淀区',default,'无')
insert buyer values('张美铃 ','1987-4-8',1,'440905198704085684','女',13989300644,'航运公司',1,1,'广州市天河',default,'无')
insert buyer values('欧广勇','1988-10-23 ',1,'435691198810234558','男',13119873932,'(无)',1,1,'台北',default,'无')
insert buyer values('洪民生  ',' 1988-08-04 ',1,' 431025198808044585 ','女',12220985644,'天来公司',1,1,'海淀区',default,'无')
insert buyer values('张海 ','1985-01-02',1,'430426198501012012','女',13515555644,'航运公司',1,1,'广州市天河',default,'无')
insert buyer values('刘恒 ','1974-12-05 ',1,'431022197412054158','女',13457861932,'(无)',1,1,'台北',default,'无')





select * from RoomType

insert roomtype values('标准单人间',280.00,150.00,38.00,200.00,1)
insert roomtype values('标准双人间',380.00,220.00,50.00,250.00,2)
insert roomtype values('豪华单人间',568.00,380.00,98.00,500.00,1)
insert roomtype values('豪华双人间',708.00,458.00,128.00,600.00,2)
insert roomtype values('商务套房',890.00,580.00,280.00,800.00,2)
insert roomtype values('总统套房',1988.00,1588.00,588.00,3000.00,2)


select * from guestRoom

insert guestRoom values('GR201',1,'窗户朝海',80001,'可供','2008-1-1 6:00',default,'无')
insert guestRoom values('GR202',1,'北面朝山',80002,'可供','2008-1-8 6:00',default,'无')
insert guestRoom values('GR302',2,'窗户朝海',80003,'可供','2008-4-5 6:00',default,'无')
insert guestRoom values('GR305',2,'北面朝山',80005,'停用','2008-2-8 7:00',default,'无')
insert guestRoom values('GR407',3,'窗户朝海',80012,'可供','2008-1-5 6:00',default,'无')
insert guestRoom values('GR408',5,'北面朝山',80033,'可供','2008-3-8 6:00',default,'无')
insert guestRoom values('GR303',4,'北面朝山',80022,'可供','2008-3-8 6:00',default,'无')
insert guestRoom values('GR409',4,'北面朝山',80011,'可供','2008-3-8 6:00',default,'无')
insert guestRoom values('GR211',1,'窗户朝海',80050,'可供','2008-1-1 6:00',default,'无')
insert guestRoom values('GR212',1,'北面朝山',80017,'可供','2008-1-8 6:00',default,'无')
insert guestRoom values('GR313',2,'窗户朝海',80027,'可供','2008-4-5 6:00',default,'无')
insert guestRoom values('GR314',2,'北面朝山',80021,'停用','2008-2-8 7:00',default,'无')
insert guestRoom values('GR415',3,'窗户朝海',80032,'可供','2008-1-5 6:00',default,'无')
insert guestRoom values('GR416',5,'北面朝山',80009,'可供','2008-3-8 6:00',default,'无')
insert guestRoom values('GR317',4,'北面朝山',80005,'可供','2008-3-8 6:00',default,'无')
insert guestRoom values('GR417',2,'北面朝山',80033,'可供','2008-3-8 6:00',default,'无')
insert guestRoom values('GR218',2,'窗户朝海',80021,'可供','2008-1-1 6:00',default,'无')
insert guestRoom values('GR219',1,'北面朝山',80087,'可供','2008-1-8 6:00',default,'无')
insert guestRoom values('GR320',2,'窗户朝海',80054,'可供','2008-4-5 6:00',default,'无')
insert guestRoom values('GR321',2,'北面朝山',80070,'停用','2008-2-8 7:00',default,'无')
insert guestRoom values('GR422',3,'窗户朝海',80040,'可供','2008-1-5 6:00',default,'无')
insert guestRoom values('GR423',5,'北面朝山',80060,'可供','2008-3-8 6:00',default,'无')
insert guestRoom values('GR324',4,'北面朝山',80061,'可供','2008-3-8 6:00',default,'无')
insert guestRoom values('GR425',3,'面向大海',80043,'停用','2008-3-8 6:00',default,'无')
insert guestRoom values('GR226',1,'面向大海',80047,'停用','2008-1-1 6:00',default,'无')
insert guestRoom values('GR227',1,'正南',80038,'可供','2008-1-8 6:00',default,'无')
insert guestRoom values('GR328',3,'窗户朝海',80048,'停用','2008-4-5 6:00',default,'无')
insert guestRoom values('GR329',2,'北面朝山',80058,'停用','2008-2-8 7:00',default,'无')
insert guestRoom values('GR430',3,'窗户朝海',80078,'可供','2008-1-5 6:00',default,'无')
insert guestRoom values('GR431',5,'正南',80043,'可供','2008-3-8 6:00',default,'无')
insert guestRoom values('GR332',4,'北面朝山',80093,'可供','2008-3-8 6:00',default,'无')
insert guestRoom values('GR433',4,'正南',80046,'可供','2008-3-8 6:00',default,'无')
insert guestRoom values('GR234',1,'面向大海',80034,'维修','2008-1-1 6:00',default,'无')
insert guestRoom values('GR235',1,'北面朝山',80076,'可供','2008-1-8 6:00',default,'无')
insert guestRoom values('GR336',2,'窗户朝海',80092,'可供','2008-4-5 6:00',default,'无')
insert guestRoom values('GR337',2,'北面朝山',80093,'停用','2008-2-8 7:00',default,'无')
insert guestRoom values('GR438',2,'窗户朝海',80094,'可供','2008-1-5 6:00',default,'无')
insert guestRoom values('GR439',5,'北面朝山',80076,'可供','2008-3-8 6:00',default,'无')
insert guestRoom values('GR340',4,'正向北',80075,'维修','2008-3-8 6:00',default,'无')
insert guestRoom values('GR441',4,'正向北',80032,'维修','2008-3-8 6:00',default,'无')
insert guestRoom values('GR242',1,'正向北',80029,'维修','2008-1-1 6:00',default,'无')
insert guestRoom values('GR243',1,'北面朝山',80087,'可供','2008-1-8 6:00',default,'无')
insert guestRoom values('GR344',2,'窗户朝海',80054,'可供','2008-4-5 6:00',default,'无')
insert guestRoom values('GR345',2,'北面朝山',80084,'停用','2008-2-8 7:00',default,'无')
insert guestRoom values('GR446',3,'窗户朝海',80032,'可供','2008-1-5 6:00',default,'无')
insert guestRoom values('GR447',5,'北面朝山',80021,'维修','2008-3-8 6:00',default,'无')
insert guestRoom values('GR348',4,'北面朝山',80078,'可供','2008-3-8 6:00',default,'无')
insert guestRoom values('GR449',4,'正南',80079,'可供','2008-3-8 6:00',default,'无')
insert guestRoom values('GR457',1,'北面朝山',80002,'可供','2008-1-8 6:00',default,'无')
insert guestRoom values('GR458',1,'窗户朝海',80003,'可供','2008-4-5 6:00',default,'无')
insert guestRoom values('GR459',1,'北面朝山',80005,'停用','2008-2-8 7:00',default,'无')
insert guestRoom values('GR460',1,'窗户朝海',80012,'可供','2008-1-5 6:00',default,'无')
insert guestRoom values('GR461',1,'北面朝山',80033,'可供','2008-3-8 6:00',default,'无')
insert guestRoom values('GR462',1,'北面朝山',80022,'可供','2008-3-8 6:00',default,'无')
insert guestRoom values('GR463',1,'北面朝山',80011,'可供','2008-3-8 6:00',default,'无')
insert guestRoom values('GR464',1,'窗户朝海',80050,'可供','2008-1-1 6:00',default,'无')
insert guestRoom values('GR465',1,'北面朝山',80017,'可供','2008-1-8 6:00',default,'无')
insert guestRoom values('GR466',1,'窗户朝海',80027,'可供','2008-4-5 6:00',default,'无')
insert guestRoom values('GR467',1,'北面朝山',80021,'停用','2008-2-8 7:00',default,'无')
insert guestRoom values('GR468',1,'窗户朝海',80032,'可供','2008-1-5 6:00',default,'无')
insert guestRoom values('GR469',1,'北面朝山',80009,'可供','2008-3-8 6:00',default,'无')
insert guestRoom values('GR470',1,'北面朝山',80005,'可供','2008-3-8 6:00',default,'无')
insert guestRoom values('GR471',1,'北面朝山',80033,'可供','2008-3-8 6:00',default,'无')
insert guestRoom values('GR472',1,'窗户朝海',80021,'可供','2008-1-1 6:00',default,'无')
insert guestRoom values('GR473',1,'北面朝山',80087,'可供','2008-1-8 6:00',default,'无')
insert guestRoom values('GR478',1,'窗户朝海',80054,'可供','2008-4-5 6:00',default,'无')
insert guestRoom values('GR479',1,'北面朝山',80070,'停用','2008-2-8 7:00',default,'无')
insert guestRoom values('GR480',1,'窗户朝海',80040,'可供','2008-1-5 6:00',default,'无')
insert guestRoom values('GR481',1,'北面朝山',80060,'可供','2008-3-8 6:00',default,'无')
insert guestRoom values('GR382',1,'北面朝山',80061,'可供','2008-3-8 6:00',default,'无')
insert guestRoom values('GR483',1,'面向大海',80043,'停用','2008-3-8 6:00',default,'无')
insert guestRoom values('GR284',1,'面向大海',80047,'停用','2008-1-1 6:00',default,'无')
insert guestRoom values('GR285',1,'正南',80038,'可供','2008-1-8 6:00',default,'无')
insert guestRoom values('GR386',1,'窗户朝海',80048,'停用','2008-4-5 6:00',default,'无')
insert guestRoom values('GR387',1,'北面朝山',80058,'停用','2008-2-8 7:00',default,'无')
insert guestRoom values('GR488',1,'窗户朝海',80078,'可供','2008-1-5 6:00',default,'无')
insert guestRoom values('GR489',1,'正南',80043,'可供','2008-3-8 6:00',default,'无')
insert guestRoom values('GR490',1,'北面朝山',80093,'可供','2008-3-8 6:00',default,'无')
insert guestRoom values('GR491',1,'正南',80046,'可供','2008-3-8 6:00',default,'无')
insert guestRoom values('GR292',1,'面向大海',80034,'维修','2008-1-1 6:00',default,'无')
insert guestRoom values('GR293',1,'北面朝山',80076,'可供','2008-1-8 6:00',default,'无')
insert guestRoom values('GR394',2,'窗户朝海',80092,'可供','2008-4-5 6:00',default,'无')
insert guestRoom values('GR395',2,'北面朝山',80093,'停用','2008-2-8 7:00',default,'无')
insert guestRoom values('GR496',2,'窗户朝海',80094,'可供','2008-1-5 6:00',default,'无')
insert guestRoom values('GR497',2,'北面朝山',80076,'可供','2008-3-8 6:00',default,'无')
insert guestRoom values('GR398',2,'正向北',80075,'维修','2008-3-8 6:00',default,'无')
insert guestRoom values('GR499',2,'正向北',80032,'维修','2008-3-8 6:00',default,'无')
insert guestRoom values('GR500',2,'正向北',80029,'维修','2008-1-1 6:00',default,'无')
insert guestRoom values('GR501',2,'北面朝山',80087,'可供','2008-1-8 6:00',default,'无')
insert guestRoom values('GR502',2,'窗户朝海',80054,'可供','2008-4-5 6:00',default,'无')
insert guestRoom values('GR503',2,'北面朝山',80084,'停用','2008-2-8 7:00',default,'无')
insert guestRoom values('GR504',2,'窗户朝海',80032,'可供','2008-1-5 6:00',default,'无')
insert guestRoom values('GR505',2,'北面朝山',80021,'维修','2008-3-8 6:00',default,'无')
insert guestRoom values('GR506',2,'北面朝山',80078,'可供','2008-3-8 6:00',default,'无')
insert guestRoom values('GR507',2,'正南',80079,'可供','2008-3-8 6:00',default,'无')
insert guestRoom values('GR508',2,'正向北',80075,'维修','2008-3-8 6:00',default,'无')
insert guestRoom values('GR509',2,'正向北',80032,'维修','2008-3-8 6:00',default,'无')
insert guestRoom values('GR510',2,'正向北',80029,'维修','2008-1-1 6:00',default,'无')
insert guestRoom values('GR511',2,'北面朝山',80087,'可供','2008-1-8 6:00',default,'无')
insert guestRoom values('GR512',2,'窗户朝海',80054,'可供','2008-4-5 6:00',default,'无')
insert guestRoom values('GR513',2,'北面朝山',80084,'停用','2008-2-8 7:00',default,'无')
insert guestRoom values('GR514',2,'窗户朝海',80032,'可供','2008-1-5 6:00',default,'无')
insert guestRoom values('GR515',2,'北面朝山',80021,'维修','2008-3-8 6:00',default,'无')
insert guestRoom values('GR516',2,'北面朝山',80078,'可供','2008-3-8 6:00',default,'无')
insert guestRoom values('GR517',2,'正南',80079,'可供','2008-3-8 6:00',default,'无')
insert guestRoom values('GR518',3,'北面朝山',80002,'可供','2008-1-8 6:00',default,'无')
insert guestRoom values('GR519',3,'窗户朝海',80003,'可供','2008-4-5 6:00',default,'无')
insert guestRoom values('GR520',3,'北面朝山',80005,'停用','2008-2-8 7:00',default,'无')
insert guestRoom values('GR521',3,'窗户朝海',80012,'可供','2008-1-5 6:00',default,'无')
insert guestRoom values('GR522',3,'北面朝山',80033,'可供','2008-3-8 6:00',default,'无')
insert guestRoom values('GR523',3,'北面朝山',80022,'可供','2008-3-8 6:00',default,'无')
insert guestRoom values('GR524',3,'北面朝山',80011,'可供','2008-3-8 6:00',default,'无')
insert guestRoom values('GR525',3,'窗户朝海',80050,'可供','2008-1-1 6:00',default,'无')
insert guestRoom values('GR526',3,'北面朝山',80017,'可供','2008-1-8 6:00',default,'无')
insert guestRoom values('GR527',3,'窗户朝海',80027,'可供','2008-4-5 6:00',default,'无')
insert guestRoom values('GR528',3,'北面朝山',80021,'停用','2008-2-8 7:00',default,'无')
insert guestRoom values('GR529',3,'窗户朝海',80032,'可供','2008-1-5 6:00',default,'无')
insert guestRoom values('GR530',3,'北面朝山',80009,'可供','2008-3-8 6:00',default,'无')
insert guestRoom values('GR531',3,'北面朝山',80005,'可供','2008-3-8 6:00',default,'无')
insert guestRoom values('GR532',3,'北面朝山',80033,'可供','2008-3-8 6:00',default,'无')
insert guestRoom values('GR533',3,'窗户朝海',80021,'可供','2008-1-1 6:00',default,'无')
insert guestRoom values('GR534',3,'北面朝山',80087,'可供','2008-1-8 6:00',default,'无')
insert guestRoom values('GR535',3,'窗户朝海',80054,'可供','2008-4-5 6:00',default,'无')
insert guestRoom values('GR536',3,'北面朝山',80070,'停用','2008-2-8 7:00',default,'无')
insert guestRoom values('GR537',3,'窗户朝海',80040,'可供','2008-1-5 6:00',default,'无')
insert guestRoom values('GR538',3,'北面朝山',80060,'可供','2008-3-8 6:00',default,'无')
insert guestRoom values('GR539',3,'北面朝山',80061,'可供','2008-3-8 6:00',default,'无')
insert guestRoom values('GR540',3,'面向大海',80043,'停用','2008-3-8 6:00',default,'无')
insert guestRoom values('GR541',3,'面向大海',80047,'停用','2008-1-1 6:00',default,'无')
insert guestRoom values('GR542',3,'正南',80038,'可供','2008-1-8 6:00',default,'无')
insert guestRoom values('GR543',3,'窗户朝海',80048,'停用','2008-4-5 6:00',default,'无')
insert guestRoom values('GR544',3,'北面朝山',80058,'停用','2008-2-8 7:00',default,'无')
insert guestRoom values('GR545',3,'窗户朝海',80078,'可供','2008-1-5 6:00',default,'无')
insert guestRoom values('GR546',3,'正南',80043,'可供','2008-3-8 6:00',default,'无')
insert guestRoom values('GR547',3,'北面朝山',80093,'可供','2008-3-8 6:00',default,'无')
insert guestRoom values('GR548',3,'正南',80046,'可供','2008-3-8 6:00',default,'无')
insert guestRoom values('GR549',3,'面向大海',80034,'维修','2008-1-1 6:00',default,'无')
insert guestRoom values('GR550',3,'北面朝山',80076,'可供','2008-1-8 6:00',default,'无')
insert guestRoom values('GR551',3,'窗户朝海',80092,'可供','2008-4-5 6:00',default,'无')
insert guestRoom values('GR552',3,'北面朝山',80093,'停用','2008-2-8 7:00',default,'无')
insert guestRoom values('GR553',4,'窗户朝海',80094,'可供','2008-1-5 6:00',default,'无')
insert guestRoom values('GR554',4,'北面朝山',80076,'可供','2008-3-8 6:00',default,'无')
insert guestRoom values('GR555',4,'正向北',80075,'维修','2008-3-8 6:00',default,'无')
insert guestRoom values('GR556',4,'正向北',80032,'维修','2008-3-8 6:00',default,'无')
insert guestRoom values('GR557',4,'正向北',80029,'维修','2008-1-1 6:00',default,'无')
insert guestRoom values('GR558',4,'北面朝山',80087,'可供','2008-1-8 6:00',default,'无')
insert guestRoom values('GR559',4,'窗户朝海',80054,'可供','2008-4-5 6:00',default,'无')