
INSERT INTO public.location VALUES (10, 'Street<br>You are standing outside your house. You can see your front door.');
INSERT INTO public.location VALUES (11, 'Inside house<br>You are inside your house, at last! There is a chair in the middle of the room, other than that, the room is very sparse.');
INSERT INTO public.location VALUES (9, 'Alleyway<br>You are at a dead end. There is a 6'' brick wall  preventing you going  any further. The only way our is the way you came in. A drunken man  is in  the corner drinking  a bottle of beer');
INSERT INTO public.location VALUES (8, 'Alleyway<br>You are standing in an alleyway. You see that it continues east.  You can go east,  north and south');
INSERT INTO public.location VALUES (7, 'Cavern<br>Althought it is quite dark, you can just see that the cavern is roughtly circular and appears to have no  exists apart from the one you just came  in by');
INSERT INTO public.location VALUES (6, 'The Park<br>You are walking along a pathway in the park. You can go north  to the playground or south to an alleyway');
INSERT INTO public.location VALUES (5, 'Roundabout<br>You are  on the roundabout.  You can leave the roundabout by going west.');
INSERT INTO public.location VALUES (4, 'Playground<br>Although it is the middle of the day, the absence of the children seems rather suspicious. To the west you can see a swing,  to the east a roundabout.  Other exits are north and south');
INSERT INTO public.location VALUES (3, 'The swing<br>You are sitting on a swing. A faint gust of wind touches your face and pushes the swing forward slightly.');
INSERT INTO public.location VALUES (2, 'A field<br>You are standing in the middle of a field. To the souch you can see a large playground.');
INSERT INTO public.location VALUES (0, 'The example Adventure by Debby  Howard<br><br>
This fully playable demo has been written in conjunction with Simon Avery''s book "Using The Quill - a short guide". It''s intention is to show the programmer how a Quilled adventure looks like using many facilities The Quill can offer.<br><br>
Type INFO  for more information');
INSERT INTO public.location VALUES (1, 'The scenario<br>
You are Simon and you''ve managed to lock you out of your house by  losing your frontdoor keys.<br><br>
Your task is simple : find your keys and retour to (and enter) your house to finish the adventure.<br><br>
However things are not as simple as that in  the adventure world and you''ve to overcome many obstacle before obtaining the keys.<br><br>
Good Luck ! And may  all your location have exits.');


INSERT INTO public.move VALUES (2, 2, 4);
INSERT INTO public.move VALUES (3, 3, 4);
INSERT INTO public.move VALUES (4, 1, 2);
INSERT INTO public.move VALUES (5, 4, 4);
INSERT INTO public.move VALUES (6, 2, 8);
INSERT INTO public.move VALUES (6, 1, 4);
INSERT INTO public.move VALUES (8, 1, 6);
INSERT INTO public.move VALUES (9, 4, 8);
INSERT INTO public.move VALUES (10, 1, 8);
INSERT INTO public.move VALUES (11, 10, 10);


INSERT INTO public.msg VALUES (0, 'I see nothing special.');
INSERT INTO public.msg VALUES (1, 'You notice that something  has been hidden underneath the roundabout.');
INSERT INTO public.msg VALUES (2, 'You climb onto the swing.');
INSERT INTO public.msg VALUES (3, 'You go on the roundabout.');
INSERT INTO public.msg VALUES (4, 'The large goblin is looking at you and licking his lips.');
INSERT INTO public.msg VALUES (6, 'The nasty goblin jumps in your way, preventing you from going south.');
INSERT INTO public.msg VALUES (7, 'You lift up the manhole but it''s too heavy for you to carry.<br>You''ve managed to move it far enough to  reveal a hole though.');
INSERT INTO public.msg VALUES (8, 'A poster has been attached to the wall');
INSERT INTO public.msg VALUES (9, 'The field is covered in grass which is about 2" high and green');
INSERT INTO public.msg VALUES (10, 'The goblin looks at you very strangely and then  utter the word : "yuk!"');
INSERT INTO public.msg VALUES (11, 'As you lean forward to  kick the goblin he quickly moves out of the way and you fall flat on your face.');
INSERT INTO public.msg VALUES (12, 'You try to kill the goblin with your bare hands, but he just laughs at your feeble antics.');
INSERT INTO public.msg VALUES (13, 'It looks very inviting indeed. Oh, how would you love to play on the swings!');
INSERT INTO public.msg VALUES (14, 'It''s round in shape and moves by pushing or pulling it.');
INSERT INTO public.msg VALUES (15, 'The sword is stuck in the goblin. He is very DEAD !!!');
INSERT INTO public.msg VALUES (16, 'The path has seen better days. It has potholes every few yards.');
INSERT INTO public.msg VALUES (17, 'It''s quite dark and damp, not the sort of place you like to hang around in.');
INSERT INTO public.msg VALUES (18, 'It is about 3'' and weight a ton  (literally). I don''t think you could carry this as it looks too heavy.');
INSERT INTO public.msg VALUES (19, 'It has a picture of a knight on it. Written underneath  are the words "Saint Georges".');
INSERT INTO public.msg VALUES (20, 'It is made  of bricks cemented together. What do you think a brick wall should look like ?');
INSERT INTO public.msg VALUES (21, 'Something prevents you  from entering the hole.');
INSERT INTO public.msg VALUES (22, 'The dragon spots the picture of St. Georges and gets very angry. He breathes a fiery breath onto the poster turning it to ash and then stomps off<br><br>
He has left something behind !');
INSERT INTO public.msg VALUES (23, 'You unlock the front door and climb up the stairs. You feel very tired after today''s events.');
INSERT INTO public.msg VALUES (24, 'The drunken man grabs hold of your leg and won''t let go.');
INSERT INTO public.msg VALUES (25, 'The drunk''s eyes pop out of their sockets when he sees the bottle. He quickly grabs it and crawls back down the alley to drink  the beer.');
INSERT INTO public.msg VALUES (26, 'As the roundabout turns, you hear a grating noise coming from underneath.');
INSERT INTO public.msg VALUES (27, 'The hole is about 3'' in diameter and looks just large enough  to squeeze into.');
INSERT INTO public.msg VALUES (28, 'The sword is very sharp.');
INSERT INTO public.msg VALUES (29, 'The sword is stuck firmly in the dead goblin.');
INSERT INTO public.msg VALUES (30, 'It''s painted green and has a keyhole about shoulder level.');
INSERT INTO public.msg VALUES (31, 'It looks very much like the one you use to open your door.');
INSERT INTO public.msg VALUES (32, 'Read the description of the location dummy.');
INSERT INTO public.msg VALUES (33, 'The dragon looks at you very strangely and says : "Not now darling, I''ve a terrible headache".');
INSERT INTO public.msg VALUES (34, 'As you lift up your foot to kick the dragon, you notice the sad look in  his eyes. You lose your heart and change your mind.');
INSERT INTO public.msg VALUES (5, 'You plunge the sword through the goblin''s heart,  killing him  instantly.');
INSERT INTO public.msg VALUES (35, 'Have you ever tried to kill a dragon with your bare hands ? No I didn''t think so! Not one of your best ideas.');
INSERT INTO public.msg VALUES (36, 'It''s very damp. It must have rained the night before.');
INSERT INTO public.msg VALUES (37, 'It''s just a plain ol'' bottle of beer.');
INSERT INTO public.msg VALUES (38, 'Don''t be stupid!');
INSERT INTO public.msg VALUES (39, 'What ? And break your neck ? Not likely!');
INSERT INTO public.msg VALUES (40, 'They are just  hole in the ground. I would  watch where I go if I were you.');
INSERT INTO public.msg VALUES (41, 'He looks at you expectantly. He seems to  want something.');
INSERT INTO public.msg VALUES (42, '"Hello mate. Got a drink for an ol'' seafarer ?"');
INSERT INTO public.msg VALUES (43, 'You attempt to kiss the man, but he looks at you and says : "I might be drunk, but I''m  not quite that drunk. Get lost !". With that he swings a punch at you.');
INSERT INTO public.msg VALUES (44, 'Look, I know this is an adventure but do you have to kill everything you see ?');
INSERT INTO public.msg VALUES (45, 'He kicks you back.');
INSERT INTO public.msg VALUES (46, 'You can''t, it''s too heavy for you.');
INSERT INTO public.msg VALUES (47, 'It''s a picture of St. Georges.');
INSERT INTO public.msg VALUES (48, '"Gobble, gobble, I''m a goblin and I love children. But I couldn''t eat two of them at the same time."');
INSERT INTO public.msg VALUES (49, 'Dead goblins don''t talk, silly!');
INSERT INTO public.msg VALUES (50, 'You don''t know any Dragonese to talk to him!');
INSERT INTO public.msg VALUES (51, 'You flop into the chair,  relived to get all the weight off your feet. It''s been one of those days when you should have stayed in the bed. <br><br>
Just at that moment, you hear a faint noise, which gets louder and louder, then you  realise that you must have fallen asleep in front of the television. You are sitting in your favorite chair.<br><br>
It has just occurred that you must have been dreaming. Still you''ve thought of a few ideas for a great adventure and you get up to turn on your computer.<br><br>
THE END.');
INSERT INTO public.msg VALUES (52, 'wouldn''t you rather find your keys though ?');
INSERT INTO public.msg VALUES (53, 'You''re already sitting on the roundabout, dumbo.');
INSERT INTO public.msg VALUES (54, 'Good idea, now what ?');
INSERT INTO public.msg VALUES (55, 'You start to move the swing higher and higher, but after a while you begin to feel nauseous so you bring it back to a gentle rock.');
INSERT INTO public.msg VALUES (56, 'It has a metal frame with two chains attached to the top about 3'' away from each other. At the bottom, a wooden plank is attached to the chains.<br><br>
Didn''t your mum let you play on the swings ? Most people know what a swing looks like.');
INSERT INTO public.msg VALUES (57, 'How can you kill a goblin when he is already dead ?');
INSERT INTO public.msg VALUES (58, 'The wall is too high to climb.');
INSERT INTO public.msg VALUES (59, 'A brick is a brick is a brick.');
INSERT INTO public.msg VALUES (60, 'Don''t be stupid, how can  you get an hole ?');
INSERT INTO public.msg VALUES (61, 'You can''t open the door, it is locked.');
INSERT INTO public.msg VALUES (62, 'You drink the beer.');
INSERT INTO public.msg VALUES (63, 'It looks very comfortable.');
INSERT INTO public.msg VALUES (64, '"Thanks for the drink  matey"');
INSERT INTO public.msg VALUES (65, 'Some verbs used in this adventure are <br>
climb, play, kill, kick, drink, sit, swing, enter, in, open, unlock,  talk,  jump, stab, lift.');



INSERT INTO public.obj VALUES (0, 'Source of Light', -1, NULL);
INSERT INTO public.obj VALUES (3, 'A dead goblin.', -1, NULL);
INSERT INTO public.obj VALUES (6, 'A hole in the ground.', -1, NULL);
INSERT INTO public.obj VALUES (13, 'A chair.', -1, NULL);
INSERT INTO public.obj VALUES (1, 'A Goblin.', 4, NULL);
INSERT INTO public.obj VALUES (4, 'A bottle of beer.', 6, NULL);
INSERT INTO public.obj VALUES (5, 'A manhole.', 8, NULL);
INSERT INTO public.obj VALUES (10, 'A drunken man.', 8, NULL);
INSERT INTO public.obj VALUES (2, 'A sword.', -1, 20);
INSERT INTO public.obj VALUES (9, 'A  poster.', -1, 25);
INSERT INTO public.obj VALUES (11, 'A picture of St Georges.', -1, 26);
INSERT INTO public.obj VALUES (12, 'An empty bottle.', -1, 21);
INSERT INTO public.obj VALUES (8, 'A dragon.', 7, NULL);
INSERT INTO public.obj VALUES (7, 'A key.', -1, 24);


INSERT INTO public.params VALUES ('wordsize', 4);
INSERT INTO public.params VALUES ('maxobj', 10);


INSERT INTO public.vocab VALUES (1, 'N');
INSERT INTO public.vocab VALUES (1, 'NORTH');
INSERT INTO public.vocab VALUES (2, 'S');
INSERT INTO public.vocab VALUES (2, 'SOUTH');
INSERT INTO public.vocab VALUES (3, 'E');
INSERT INTO public.vocab VALUES (3, 'EAST');
INSERT INTO public.vocab VALUES (4, 'W');
INSERT INTO public.vocab VALUES (4, 'WEST');
INSERT INTO public.vocab VALUES (10, 'D');
INSERT INTO public.vocab VALUES (10, 'DOWN');
INSERT INTO public.vocab VALUES (5, 'NE');
INSERT INTO public.vocab VALUES (6, 'NW');
INSERT INTO public.vocab VALUES (7, 'SE');
INSERT INTO public.vocab VALUES (8, 'SW');
INSERT INTO public.vocab VALUES (9, 'U');
INSERT INTO public.vocab VALUES (9, 'UP');
INSERT INTO public.vocab VALUES (9, 'CLIMB');
INSERT INTO public.vocab VALUES (20, 'SWORD');
INSERT INTO public.vocab VALUES (21, 'BOTTLE');
INSERT INTO public.vocab VALUES (21, 'BEER');
INSERT INTO public.vocab VALUES (22, 'LID');
INSERT INTO public.vocab VALUES (22, 'MANHOLE');
INSERT INTO public.vocab VALUES (24, 'KEY');
INSERT INTO public.vocab VALUES (25, 'POSTER');
INSERT INTO public.vocab VALUES (26, 'PICTURE');
INSERT INTO public.vocab VALUES (100, 'GET');
INSERT INTO public.vocab VALUES (100, 'TAKE');
INSERT INTO public.vocab VALUES (100, 'LIFT');
INSERT INTO public.vocab VALUES (101, 'DROP');
INSERT INTO public.vocab VALUES (102, 'REMOVE');
INSERT INTO public.vocab VALUES (103, 'WEAR');
INSERT INTO public.vocab VALUES (104, 'I');
INSERT INTO public.vocab VALUES (104, 'INVENTORY');
INSERT INTO public.vocab VALUES (105, 'L');
INSERT INTO public.vocab VALUES (105, 'LOOK');
INSERT INTO public.vocab VALUES (106, 'QUIT');
INSERT INTO public.vocab VALUES (107, 'SAVE');
INSERT INTO public.vocab VALUES (108, 'LOAD');
INSERT INTO public.vocab VALUES (109, 'X');
INSERT INTO public.vocab VALUES (109, 'EXAMINE');
INSERT INTO public.vocab VALUES (110, 'PLAY');
INSERT INTO public.vocab VALUES (111, 'KILL');
INSERT INTO public.vocab VALUES (111, 'STAB');
INSERT INTO public.vocab VALUES (112, 'IN');
INSERT INTO public.vocab VALUES (112, 'GO');
INSERT INTO public.vocab VALUES (112, 'ENTER');
INSERT INTO public.vocab VALUES (113, 'KISS');
INSERT INTO public.vocab VALUES (114, 'KICK');
INSERT INTO public.vocab VALUES (115, 'UNLOCK');
INSERT INTO public.vocab VALUES (116, 'GIVE');
INSERT INTO public.vocab VALUES (117, 'PUSH');
INSERT INTO public.vocab VALUES (118, 'JUMP');
INSERT INTO public.vocab VALUES (119, 'TALK');
INSERT INTO public.vocab VALUES (120, 'SIT');
INSERT INTO public.vocab VALUES (121, 'OPEN');
INSERT INTO public.vocab VALUES (122, 'DRINK');
INSERT INTO public.vocab VALUES (200, 'GOBLIN');
INSERT INTO public.vocab VALUES (201, 'ROUNDABOUT');
INSERT INTO public.vocab VALUES (202, 'SWING');
INSERT INTO public.vocab VALUES (203, 'HOLE');
INSERT INTO public.vocab VALUES (204, 'WALL');
INSERT INTO public.vocab VALUES (205, 'FIELD');
INSERT INTO public.vocab VALUES (206, 'PATH');
INSERT INTO public.vocab VALUES (207, 'ALLEYWAY');
INSERT INTO public.vocab VALUES (208, 'DOOR');
INSERT INTO public.vocab VALUES (209, 'DRAGON');
INSERT INTO public.vocab VALUES (210, 'CAVE');
INSERT INTO public.vocab VALUES (211, 'GRASS');
INSERT INTO public.vocab VALUES (212, 'POTHOLE');
INSERT INTO public.vocab VALUES (214, 'CHAIR');
INSERT INTO public.vocab VALUES (215, 'BRICK');
INSERT INTO public.vocab VALUES (216, 'INFO');
INSERT INTO public.vocab VALUES (217, 'HELP');
INSERT INTO public.vocab VALUES (217, 'HINT');
INSERT INTO public.vocab VALUES (213, 'MAN');
INSERT INTO public.vocab VALUES (213, 'DRUNKEN');

SELECT pg_catalog.setval('public.location_rid_seq', 11, true);
SELECT pg_catalog.setval('public.msg_mid_seq', 65, true);
SELECT pg_catalog.setval('public.obj_objid_seq', 13, true);
