J8Bgnjbz

1DROP DATABASE IF EXISTS peli;
2CREATE DATABASE peli;
3USE peli;
4
5#DROP TABLE IF EXISTS Door;
6#DROP TABLE IF EXISTS OBJECT;
7#DROP TABLE IF EXISTS LOCATION;
8#DROP TABLE IF EXISTS DIRECTION;
9
10CREATE TABLE Location
11(
12  locationId VARCHAR(50)  NOT NULL,
13  Description VARCHAR(50)  NOT NULL,
14  Details VARCHAR(50)  NOT NULL,
15  PRIMARY KEY (locationId)
16);
17
18CREATE TABLE Object
19(
20  ObjectId VARCHAR(50)  NOT NULL,
21  Item VARCHAR(80)  NOT NULL, #Kuvaus esineestä
22  Name VARCHAR(50)  NOT NULL,
23  ODetails VARCHAR(80)  NOT NULL, #KUn tutkit esinettä
24 # OLocation VARCHAR(50)  NOT NULL,
25  Useability BOOLEAN,
26  Takeable BOOLEAN,
27  Hidden BOOLEAN, 
28  locationId VARCHAR(50) NOT NULL,
29  PRIMARY KEY (ObjectId),
30  FOREIGN KEY (LocationId) REFERENCES Location(locationId)
31);
32
33#SELECT Item FROM Object WHERE Hidden = FALSE; Testailtiin vähäsen
34
35
36
37CREATE TABLE Direction
38(
39  DirectionId VARCHAR(50)  NOT NULL,
40  Value VARCHAR(50)  NOT NULL,
41  PRIMARY KEY (DirectionId)
42);
43
44CREATE TABLE Door
45(
46
47  DoorId VARCHAR(50),
48  Locked BOOLEAN NOT NULL,
49  Note VARCHAR(50)  NOT NULL,
50  #Directionid VARCHAR(10),
51  jotain VARCHAR(20),
52  startingpoint VARCHAR(50),
53  finishpoint VARCHAR(50),
54  PRIMARY KEY (DoorId),
55  FOREIGN KEY (jotain) REFERENCES Direction(DirectionId),
56  FOREIGN KEY (startingpoint) REFERENCES Location(locationId),
57  FOREIGN KEY (finishpoint) REFERENCES Location(locationId)
58);
59
60
61
62
63
64
65
66
67INSERT INTO Location VALUES('ROOM1','first room','awesome first room');
68INSERT INTO Location VALUES('ROOM2','second room','awesome second room');
69INSERT INTO Location VALUES('ROOM3','third room','awesome third room');
70INSERT INTO Location VALUES('ROOM4','fourth room','awesome fouth room');
71INSERT INTO Location VALUES('ROOM5','fifth room','awesome fifth room');
72INSERT INTO Location VALUES('ROOM6','sixth room','awesome sixth room');
73INSERT INTO Location VALUES('ROOM7','seventh room','awesome seventh room');
74
75INSERT INTO Direction VALUES('N', 'North');
76INSERT INTO Direction VALUES('S', 'South');
77INSERT INTO Direction VALUES('E', 'East');
78INSERT INTO Direction VALUES('W', 'West');
79
80INSERT INTO Object VALUES('KEY1','this is key','key','the key looks like it fits perfectly into your ass',FALSE,TRUE,TRUE,'ROOM2');
81INSERT INTO Object VALUES('KEY2','this is key','key','the key looks like it fits perfectly into your ass',FALSE,TRUE,TRUE,'ROOM5');
82INSERT INTO Object VALUES('KEY3','this is key','key','the key looks like it fits perfectly into your pussy',FALSE,TRUE,TRUE,'ROOM4');
83INSERT INTO Object VALUES('FANNYPACK','Neoncolor fannypack (also your inventory so pick it up!)','fannypack','the fannypack looks like it fits perfectly into your ass',FALSE,TRUE,FALSE,'ROOM1');
84INSERT INTO Object VALUES('POSTER','Poster of Half naked David Hasselhoff that makes you questionable your sexuality','poster','POLTTAAA ',TRUE,TRUE,FALSE,'ROOM1');
85INSERT INTO Object VALUES('ROD','this is rod','Rod','the rod looks like it is perfect for fishing fucks to give',FALSE,TRUE,TRUE,'ROOM5');
86INSERT INTO Object VALUES('CODELOCK','Futuristic codekey with Knight Rider design','key','the key looks like it fits perfectly into your ass',TRUE,FALSE,FALSE,'ROOM1');
87INSERT INTO Object VALUES('CODELOCK2','this is codekey','key','the key looks like it fits perfectly into your ass',TRUE,FALSE,FALSE,'ROOM3');
88INSERT INTO Object VALUES('NOTE1','Welcoming message','note','Welcome! Here is one fucking hard puzzle to solve',TRUE,TRUE,FALSE,'ROOM1');
89INSERT INTO Object VALUES('NOTE2','clue','note','This is the shitty mathematic puzzle',TRUE,TRUE,FALSE,'ROOM2');
90INSERT INTO Object VALUES('FAXNOTE','clue','fax','This is the clue which comes out of the telefax',TRUE,TRUE,TRUE,'ROOM4');
91INSERT INTO Object VALUES('TELEFAX','Its an old telefax machine','telefax','Here comes the fax',FALSE,FALSE,FALSE,'ROOM4');
92INSERT INTO Object VALUES('PUZZLE','Its a jigsaw puzzle','puzzle','This is mates puzzle',FALSE,TRUE,FALSE,'ROOM2');
93INSERT INTO Object VALUES('BOX','Wooden box with code lock','box','Lets open the box!',FALSE,FALSE,FALSE,'ROOM2');
94INSERT INTO Object VALUES('FISH TANK','Tank full of glow fishes','fish tank','Fish tank full of glow fishes, key in it',TRUE,FALSE,FALSE,'ROOM5');
95INSERT INTO Object VALUES('TABLE','Wooden box with code lock','table','Lets open the box!',FALSE,FALSE,FALSE,'ROOM2');
96INSERT INTO Object VALUES('BOOKSHELF','Shel full of books','bookshelf','jeijei',FALSE,FALSE,FALSE,'ROOM5');
97
98
99
100
101
102
103
104
105INSERT INTO Door VALUES('R12',TRUE, 'The door is locked', 'E', 'Room1', 'Room2');
106INSERT INTO Door VALUES('R21',TRUE, 'The door is locked', 'W', 'Room2', 'Room1');
107INSERT INTO Door VALUES('R23',TRUE, 'The door is locked', 'S', 'Room2', 'Room3');
108INSERT INTO Door VALUES('R32',TRUE, 'The door is locked', 'N', 'Room3', 'Room2');
109INSERT INTO Door VALUES('R34',TRUE, 'The door is locked', 'S', 'Room3', 'Room4');
110INSERT INTO Door VALUES('R43',TRUE, 'The door is locked', 'N', 'Room4', 'Room3');
111INSERT INTO Door VALUES('R45',TRUE, 'The door is locked', 'E', 'Room4', 'Room5');
112INSERT INTO Door VALUES('R54',TRUE, 'The door is locked', 'W', 'Room5', 'Room4');
113INSERT INTO Door VALUES('R56',TRUE, 'The door is locked', 'N', 'Room5', 'Room6');
114INSERT INTO Door VALUES('R65',TRUE, 'The door is locked', 'S', 'Room6', 'Room5');
115INSERT INTO Door VALUES('R67',FALSE, 'The door is not locked', 'E', 'Room6', 'Room7');
116INSERT INTO Door VALUES('R76',FALSE, 'The door is not locked', 'W', 'Room7', 'Room6');