-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathexit
More file actions
42 lines (42 loc) · 3.22 KB
/
exit
File metadata and controls
42 lines (42 loc) · 3.22 KB
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
CREATE TABLE EXIT (exitID int not null, roomID int not null, direction text not null, destination int not null, PRIMARY KEY (exitID), FOREIGN KEY (roomID) REFERENCES ROOM(roomNumber))
INSERT INTO EXIT(exitID, roomID, direction, destination) Values(1|east|2)
INSERT INTO EXIT(exitID, roomID, direction, destination) Values(2|west|1)
INSERT INTO EXIT(exitID, roomID, direction, destination) Values(2|east|3)
INSERT INTO EXIT(exitID, roomID, direction, destination) Values(3|north|6)
INSERT INTO EXIT(exitID, roomID, direction, destination) Values(4|south|6)
INSERT INTO EXIT(exitID, roomID, direction, destination) Values(4|east|5)
INSERT INTO EXIT(exitID, roomID, direction, destination) Values(5|west|4)
INSERT INTO EXIT(exitID, roomID, direction, destination) Values(5|north|7)
INSERT INTO EXIT(exitID, roomID, direction, destination) Values(6|south|8)
INSERT INTO EXIT(exitID, roomID, direction, destination) Values(7|north|9)
INSERT INTO EXIT(exitID, roomID, direction, destination) Values(8|west|7)
INSERT INTO EXIT(exitID, roomID, direction, destination) Values(8|south|10)
INSERT INTO EXIT(exitID, roomID, direction, destination) Values(9|east|10)
INSERT INTO EXIT(exitID, roomID, direction, destination) Values(10|east|11)
INSERT INTO EXIT(exitID, roomID, direction, destination) Values(11|west|10)
INSERT INTO EXIT(exitID, roomID, direction, destination) Values(12|north|13)
INSERT INTO EXIT(exitID, roomID, direction, destination) Values(12|south|14)
INSERT INTO EXIT(exitID, roomID, direction, destination) Values(13|east|15)
INSERT INTO EXIT(exitID, roomID, direction, destination) Values(14|west|12)
INSERT INTO EXIT(exitID, roomID, direction, destination) Values(14|north|16)
INSERT INTO EXIT(exitID, roomID, direction, destination) Values(15|south|17)
INSERT INTO EXIT(exitID, roomID, direction, destination) Values(16|north|18)
INSERT INTO EXIT(exitID, roomID, direction, destination) Values(16|east|19)
INSERT INTO EXIT(exitID, roomID, direction, destination) Values(17|south|20)
INSERT INTO EXIT(exitID, roomID, direction, destination) Values(18|east|19
INSERT INTO EXIT(exitID, roomID, direction, destination) Values(19|west|18)
INSERT INTO EXIT(exitID, roomID, direction, destination) Values(20|east|21)
INSERT INTO EXIT(exitID, roomID, direction, destination) Values(21|west|20)
INSERT INTO EXIT(exitID, roomID, direction, destination) Values(22|north|23)
INSERT INTO EXIT(exitID, roomID, direction, destination) Values(22|east|24)
INSERT INTO EXIT(exitID, roomID, direction, destination) Values(23|south|22)
INSERT INTO EXIT(exitID, roomID, direction, destination) Values(23|east|25)
INSERT INTO EXIT(exitID, roomID, direction, destination) Values(24|west|22)
INSERT INTO EXIT(exitID, roomID, direction, destination) Values(24|north|26)
INSERT INTO EXIT(exitID, roomID, direction, destination) Values(25|south|27)
INSERT INTO EXIT(exitID, roomID, direction, destination) Values(26|north|28)
INSERT INTO EXIT(exitID, roomID, direction, destination) Values(26|west|24)
INSERT INTO EXIT(exitID, roomID, direction, destination) Values(27|east|28)
INSERT INTO EXIT(exitID, roomID, direction, destination) Values(28|north|29)
INSERT INTO EXIT(exitID, roomID, direction, destination) Values(28|south|26)
INSERT INTO EXIT(exitID, roomID, direction, destination) Values(29|south|30)