【SQL开源代码栏目提醒】:网学会员为需要SQL开源代码的朋友们搜集整理了HTL07B.SQL相关资料,希望对各位网友有所帮助!
/* Insert all the data for the tbl_Hotels table */
INSERT tbl_hotels VALUES(1,'Grand View Hotel')
INSERT tbl_hotels VALUES(2,'Mountain Side Resort')
INSERT tbl_hotels VALUES(3,'Hard Days Inn')
INSERT tbl_hotels VALUES(4,'Gunners Lodge')
/* tbl_PaymentTypes */
INSERT tbl_PaymentTypes VALUES ( 1, 'Check')
INSERT tbl_PaymentTypes VALUES ( 2, 'MasterCard')
INSERT tbl_PaymentTypes VALUES ( 3, 'Visa')
INSERT tbl_PaymentTypes VALUES ( 4, 'American Express')
INSERT tbl_PaymentTypes VALUES ( 5, 'Cash')
/* tbl_RoomTypes */
INSERT tbl_RoomTypes VALUES ( 10, 1, 'Double; Non-smoking')
INSERT tbl_RoomTypes VALUES ( 11, 2, 'Double; Non-smoking')
INSERT tbl_RoomTypes VALUES ( 12, 1, 'Double; Non-smoking; Kitchenette')
INSERT tbl_RoomTypes VALUES ( 13, 2, 'Double; Non-smoking; Kitchenette')
INSERT tbl_RoomTypes VALUES ( 15, 1, 'Double; Smoking')
INSERT tbl_RoomTypes VALUES ( 16, 2, 'Double; Smoking')
INSERT tbl_RoomTypes VALUES ( 17, 1, 'Double; Smoking; Kitchenette')
INSERT tbl_RoomTypes VALUES ( 18, 2, 'Double; Smoking; Kitchenette')
INSERT tbl_RoomTypes VALUES ( 14, 1, 'Double; Non-smoking; Whirlpool')
INSERT tbl_RoomTypes VALUES ( 19, 1, 'Double; Smoking; Whirlpool')
INSERT tbl_RoomTypes VALUES ( 20, 1, 'Queen; Non-smoking')
INSERT tbl_RoomTypes VALUES ( 21, 2, 'Queen; Non-smoking')
INSERT tbl_RoomTypes VALUES ( 22, 1, 'Queen; Non-smoking; Kitchenette')
INSERT tbl_RoomTypes VALUES ( 23, 2, 'Queen; Non-smoking; Kitchenette')
INSERT tbl_RoomTypes VALUES ( 24, 1, 'Queen; Non-smoking; Whirlpool')
INSERT tbl_RoomTypes VALUES ( 25, 1, 'Queen; Smoking')
INSERT tbl_RoomTypes VALUES ( 26, 2, 'Queen; Smoking')
INSERT tbl_RoomTypes VALUES ( 27, 1, 'Queen; Smoking; Kitchenette')
INSERT tbl_RoomTypes VALUES ( 28, 2, 'Queen; Smoking; Kitchenette')
INSERT tbl_RoomTypes VALUES ( 29, 1, 'Queen; Smoking; Whirlpool')
INSERT tbl_RoomTypes VALUES ( 30, 1, 'King; Non-smoking')
INSERT tbl_RoomTypes VALUES ( 31, 2, 'King; Non-smoking')
INSERT tbl_RoomTypes VALUES ( 32, 1, 'King; Non-smoking; Kitchenette')
INSERT tbl_RoomTypes VALUES ( 33, 2, 'King; Non-smoking; Kitchenette')
INSERT tbl_RoomTypes VALUES ( 34, 1, 'King; Non-smoking; Whirlpool')
INSERT tbl_RoomTypes VALUES ( 35, 1, 'King; Smoking')
INSERT tbl_RoomTypes VALUES ( 36, 2, 'King; Smoking')
INSERT tbl_RoomTypes VALUES ( 37, 1, 'King; Smoking; Kitchenette')
INSERT tbl_RoomTypes VALUES ( 38, 2, 'King; Smoking; Kitchenette')
INSERT tbl_RoomTypes VALUES ( 39, 1, 'King; Smoking; Whirlpool')
INSERT tbl_RoomTypes VALUES ( 40, 1, 'Suite w/ King')
INSERT tbl_RoomTypes VALUES ( 41, 1, 'Suite w/ King & Whirlpool')
INSERT tbl_RoomTypes VALUES ( 42, 1, 'Penhouse w/ King')
/* tbl_Rooms */
INSERT tbl_Rooms VALUES ( 1, 1110, 10, 75.00, '','0')
INSERT tbl_Rooms VALUES ( 1, 1220, 10, 75.00, '','0')
INSERT tbl_Rooms VALUES ( 1, 1330, 10, 75.00, '','0')
INSERT tbl_Rooms VALUES ( 1, 1440, 10, 75.00, '','0')
INSERT tbl_Rooms VALUES ( 1, 1550, 11, 90.00, '','0')
INSERT tbl_Rooms VALUES ( 1, 1660, 11, 90.00, '','0')
INSERT tbl_Rooms VALUES ( 1, 1770, 11, 90.00, '','0')
INSERT tbl_Rooms VALUES ( 1, 1880, 12, 85.00, '','0')
INSERT tbl_Rooms VALUES ( 1, 1990, 12, 85.00, '','0')
INSERT tbl_Rooms VALUES ( 1, 2100, 12, 85.00, '','0')
INSERT tbl_Rooms VALUES ( 1, 2210, 13, 100.00, '','0')
INSERT tbl_Rooms VALUES ( 1, 2320, 13, 100.00, '','0')
INSERT tbl_Rooms VALUES ( 1, 2430, 13, 100.00, '','0')
INSERT tbl_Rooms VALUES ( 1, 2540, 14, 125.00, '','0')
INSERT tbl_Rooms VALUES ( 1, 2650, 14, 125.00, '','0')
INSERT tbl_Rooms VALUES ( 1, 2760, 15, 75.00 , '','0')
INSERT tbl_Rooms VALUES ( 1, 2870, 15, 75.00 , '','0')
INSERT tbl_Rooms VALUES ( 1, 3090, 16, 90.00 , '','0')
INSERT tbl_Rooms VALUES ( 1, 3200, 16, 90.00 , '','0')
INSERT tbl_Rooms VALUES ( 1, 3310, 17, 85.00 , '','0')
INSERT tbl_Rooms VALUES ( 1, 3420, 17, 85.00 , '','0')
INSERT tbl_Rooms VALUES ( 1, 3530, 18, 100.00, '','0')
INSERT tbl_Rooms VALUES ( 1, 3640, 18, 100.00, '','0')
INSERT tbl_Rooms VALUES ( 1, 3750, 19, 125.00, '','0')
INSERT tbl_Rooms VALUES ( 1, 3860, 19, 125.00, '','0')
INSERT tbl_Rooms VALUES ( 1, 3970, 20, 80.00 , '','0')
INSERT tbl_Rooms VALUES ( 1, 4080, 20, 80.00 , '','0')
INSERT tbl_Rooms VALUES ( 1, 4190, 20, 80.00 , '','0')
INSERT tbl_Rooms VALUES ( 1, 4300, 20, 80.00 , '','0')
INSERT tbl_Rooms VALUES ( 1, 4410, 20, 80.00 , '','0')
INSERT tbl_Rooms VALUES ( 1, 4520, 21, 95.00 , '','0')
INSERT tbl_Rooms VALUES ( 1, 4630, 21, 95.00 , '','0')
INSERT tbl_Rooms VALUES ( 1, 4740, 21, 95.0