update location set roomdesc='A field<br>You are standing in the middle of a field. To the souch you can see a large playground.' where rid=0;

insert into location(roomdesc) values 
  ('The swing<br>You are sitting on a swing. A faint gust of wind touches your face and pushes the swing forward slightly.'),
  ('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'),
  ('Roundabout<br>You are  on the roundabout.  You can leave the roundabout by going west.'),
  ('The Park<br>You are walking along a pathway in the park. You can go north  to the playground or south to an alleyway'),
  ('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'),
  ('Alleyway<br>You are standing in an alleyway. You see that it continues east.  You can go east,  north and south'),
  ('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'),
  ('Street<br>You are standing outside your house. You can see your front door.'),
  ('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 move(rid,wid,newroom) values
  (0,2,2),
  (1,3,2),
  (2,1,0),(2,2,4),(2,3,3),(2,4,1),
  (3,4,2),
  (4,2,6),(4,1,2),
  (6,1,4),(6,2,8),(6,3,7),
  (7,4,6),
  (8,1,6),
  (9,10,8);

insert into vocab(wid,word)  values
  (1,'N'),(1,'NORTH'),
  (2,'S'),(2,'SOUTH'),
  (3,'E'),(3,'EAST'),
  (4,'W'),(4,'WEST'),
  (10,'D'),(10,'DOWN');

