database/populatedb.sql

   1 --Tropical Island
   2 insert into BoundingBox
   3 (BoundingBoxId,WC_X,WC_Y,Height,Width)
   4 values(NULL,0,0,100,100);
   5
   6 --Palm Tree (id = 1)
   7 insert into MapObject
   8 (MapObjectId,WC_X,WC_Y,Height,Width,BoundingBoxId)
   9 values(NULL,3,5,5,5,1);
  10
  11 --Treasure Chest (id = 2)
  12 insert into MapObject
  13 (MapObjectId,WC_X,WC_Y,Height,Width,BoundingBoxId)
  14 values(NULL,40,40,3,7,1);
  15
  16 --Hand (id = 3)
  17 insert into MapObject
  18 (MapObjectId,WC_X,WC_Y,Height,Width,BoundingBoxId)
  19 values(NULL,23,47,3,3,1);
  20
  21 -- Puddle (id = 4)
  22 insert into MapObject
  23 (MapObjectId,WC_X,WC_Y,Height,Width,BoundingBoxId)
  24 values(NULL,1,1,2,2,1);
  25
  26 --Treasure Chest's Container (Saftey Match)
  27 insert into Container
  28 (MapObjectId,item0)
  29 values(2,1);
  30
  31 --Hand's NPC
  32 insert into NonPlayerCharacter
  33 (MapObjectId,Speed)
  34 values(3,1);
  35
  36 --Puddle's Tile
  37 insert into Tiles
  38 (MapObjectId,TileType)
  39 values(4,0);
  40
  41 --Hand's NPC Path
  42 insert into NonPlayerCharacterPath
  43 (MapObjectId,WC_X,WC_Y,PathIndex)
  44 values(3,43,43,0);
  45 insert into NonPlayerCharacterPath
  46 (MapObjectId,WC_X,WC_Y,PathIndex)
  47 values(3,33,25,1);
  48 insert into NonPlayerCharacterPath
  49 (MapObjectId,WC_X,WC_Y,PathIndex)
  50 values(3,55,3,2);
  51 insert into NonPlayerCharacterPath
  52 (MapObjectId,WC_X,WC_Y,PathIndex)
  53 values(3,23,47,3);
  54
  55 --Palm Tree's Hardpoint
  56 --Hardpoint Type = 1 = CircHardPoint
  57 insert into Hardpoints
  58 (MapObjectId,HardpointType,RelativeX,RelativeY,Radius)
  59 values(1,1,0,0,3);
  60
  61 --Treasure Chest's Hardpoint
  62 --Hardpoint Type = 0 = RectHardPoint
  63 insert into Hardpoints
  64 (MapObjectId,HardpointType,RelativeX,RelativeY,Height,Width)
  65 values(2,0,0,0,5,5);
  66
  67 --Hand's Hardpoint
  68 --Hardpoint Type = 1 = CircHardPoint
  69 insert into Hardpoints
  70 (MapObjectId,HardpointType,RelativeX,RelativeY,Radius)
  71 values(3,1,0,0,3);