8
roomId int PRIMARY KEY,
18
CREATE TABLE furniture
20
furnId int PRIMARY KEY,
29
rugId int PRIMARY KEY,
36
lampId int PRIMARY KEY,
43
INSERT INTO testrooms VALUES (10, 100, 'testroom1', 'someguy', 10, 10, 20, 20);
44
INSERT INTO testrooms VALUES (11, 100, 'testroom2', 'someguy', 30, 10, 20, 20);
45
INSERT INTO testrooms VALUES (12, 100, 'testroom3', 'someguy', 50, 10, 20, 20);
47
INSERT INTO furniture VALUES (50, 10, 'chair1', 10, 10);
48
INSERT INTO furniture VALUES (51, 10, 'chair2', 14, 10);
49
INSERT INTO furniture VALUES (52, 12, 'chair3', 14, 10);
50
INSERT INTO furniture VALUES (53, 12, 'chair4', 10, 12);
51
INSERT INTO furniture VALUES (54, 12, 'chair5', 18, 13);
52
INSERT INTO furniture VALUES (55, 12, 'couch', 22, 3);
54
INSERT INTO rugs VALUES (81, 10, 'a big rug');
55
INSERT INTO rugs VALUES (82, 10, 'a blue rug');
56
INSERT INTO rugs VALUES (83, 11, 'a red rug');
57
INSERT INTO rugs VALUES (84, 11, 'a green rug');
58
INSERT INTO rugs VALUES (85, 12, 'a dirty rug');
60
INSERT INTO lamps VALUES (21, 50, 'chair1', 'a big lamp1');
61
INSERT INTO lamps VALUES (22, 50, 'chair1', 'a big lamp2');
62
INSERT INTO lamps VALUES (23, 53, 'chair4', 'a big lamp3');
63
INSERT INTO lamps VALUES (24, 53, 'chair4', 'a big lamp4');
64
INSERT INTO lamps VALUES (25, 53, 'chair4', 'a big lamp5');
65
INSERT INTO lamps VALUES (26, 54, 'couch', 'a big lamp6');