-
Notifications
You must be signed in to change notification settings - Fork 0
/
room.sql
72 lines (64 loc) · 4.6 KB
/
room.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
-- Room_No(PK) Type Rate Status
------------------------------- Single Suite(1+1) -----------------------------
insert into Room values('A001', 'Single Suite(1+1)', '1200', 'FALSE');
insert into Room values('A002', 'Single Suite(1+1)', '1200', 'FALSE');
insert into Room values('A003', 'Single Suite(1+1)', '1200', 'FALSE');
insert into Room values('A004', 'Single Suite(1+1)', '1200', 'FALSE');
insert into Room values('A005', 'Single Suite(1+1)', '1200', 'FALSE');
insert into Room values('A006', 'Single Suite(1+1)', '1200', 'FALSE');
insert into Room values('A007', 'Single Suite(1+1)', '1200', 'FALSE');
insert into Room values('A008', 'Single Suite(1+1)', '1200', 'FALSE');
insert into Room values('A009', 'Single Suite(1+1)', '1200', 'FALSE');
insert into Room values('A010', 'Single Suite(1+1)', '1200', 'FALSE');
insert into Room values('A011', 'Single Suite(1+1)', '1200', 'FALSE');
insert into Room values('A012', 'Single Suite(1+1)', '1200', 'FALSE');
insert into Room values('A013', 'Single Suite(1+1)', '1200', 'FALSE');
insert into Room values('A014', 'Single Suite(1+1)', '1200', 'FALSE');
insert into Room values('A015', 'Single Suite(1+1)', '1200', 'FALSE');
insert into Room values('A016', 'Single Suite(1+1)', '1200', 'FALSE');
insert into Room values('A017', 'Single Suite(1+1)', '1200', 'FALSE');
insert into Room values('A018', 'Single Suite(1+1)', '1200', 'FALSE');
insert into Room values('A019', 'Single Suite(1+1)', '1200', 'FALSE');
insert into Room values('A020', 'Single Suite(1+1)', '1200', 'FALSE');
-------------------------------- Junior Suite(2+2) ----------------------------
insert into Room values('A101', 'Junior Suite(2+2)', '2100', 'FALSE');
insert into Room values('A102', 'Junior Suite(2+2)', '2100', 'FALSE');
insert into Room values('A103', 'Junior Suite(2+2)', '2100', 'FALSE');
insert into Room values('A104', 'Junior Suite(2+2)', '2100', 'FALSE');
insert into Room values('A105', 'Junior Suite(2+2)', '2100', 'FALSE');
insert into Room values('A106', 'Junior Suite(2+2)', '2100', 'FALSE');
insert into Room values('A107', 'Junior Suite(2+2)', '2100', 'FALSE');
insert into Room values('A108', 'Junior Suite(2+2)', '2100', 'FALSE');
insert into Room values('A109', 'Junior Suite(2+2)', '2100', 'FALSE');
insert into Room values('A110', 'Junior Suite(2+2)', '2100', 'FALSE');
------------------------------- Prestige Junior Suite(2+2) --------------------
insert into Room values('A201', 'Prestige Junior Suite(2+2)', '2500', 'FALSE');
insert into Room values('A202', 'Prestige Junior Suite(2+2)', '2500', 'TRUE');
insert into Room values('A203', 'Prestige Junior Suite(2+2)', '2500', 'FALSE');
insert into Room values('A204', 'Prestige Junior Suite(2+2)', '2500', 'FALSE');
insert into Room values('A205', 'Prestige Junior Suite(2+2)', '2500', 'FALSE');
insert into Room values('A206', 'Prestige Junior Suite(2+2)', '2500', 'FALSE');
insert into Room values('A207', 'Prestige Junior Suite(2+2)', '2500', 'FALSE');
insert into Room values('A208', 'Prestige Junior Suite(2+2)', '2500', 'FALSE');
insert into Room values('A209', 'Prestige Junior Suite(2+2)', '2500', 'FALSE');
insert into Room values('A210', 'Prestige Junior Suite(2+2)', '2500', 'FALSE');
-------------------------------- Superior Suite(3+3) --------------------------
insert into Room values('A301', 'Superior Suite(3+3)', '3000', 'FALSE');
insert into Room values('A302', 'Superior Suite(3+3)', '3000', 'FALSE');
insert into Room values('A303', 'Superior Suite(3+3)', '3000', 'FALSE');
insert into Room values('A304', 'Superior Suite(3+3)', '3000', 'FALSE');
insert into Room values('A305', 'Superior Suite(3+3)', '3000', 'FALSE');
-------------------------------- Executive Suite(5+0) -------------------------
insert into Room values('A401', 'Executive Suite(5+0)', '4000', 'TRUE');
insert into Room values('A402', 'Executive Suite(5+0)', '4000', 'TRUE');
insert into Room values('A403', 'Executive Suite(5+0)', '4000', 'FALSE');
insert into Room values('A404', 'Executive Suite(5+0)', '4000', 'FALSE');
insert into Room values('A405', 'Executive Suite(5+0)', '4000', 'FALSE');
insert into Room values('A406', 'Executive Suite(5+0)', '4000', 'FALSE');
insert into Room values('A501', 'Executive Suite(5+0)', '4000', 'FALSE');
insert into Room values('A502', 'Executive Suite(5+0)', '4000', 'FALSE');
insert into Room values('A503', 'Executive Suite(5+0)', '4000', 'TRUE');
insert into Room values('A504', 'Executive Suite(5+0)', '4000', 'TRUE');
insert into Room values('A505', 'Executive Suite(5+0)', '4000', 'FALSE');
insert into Room values('A506', 'Executive Suite(5+0)', '4000', 'FALSE');
-------------------------------------------------------------------------------