1 drop table if exists NonPlayerCharacter;
2 drop table if exists NonPlayerCharacterPath;
3 drop table if exists BoundingBox;
4 drop table if exists MapObject;
5 drop table if exists Container;
6 drop table if exists Hardpoints;
7 drop table if exists Tiles;
9 create table NonPlayerCharacter
11 MapObjectId integer(10) not null,
12 speed integer(10) null,
13 foreign key (MapObjectId) references MapObject(MapObjectId)
16 create table NonPlayerCharacterPath
18 MapObjectId integer(10) not null,
19 WC_X integer(10) not null,
20 WC_Y integer(10) not null,
21 PathIndex integer(10) not null,
22 foreign key (MapObjectId) references MapObject(MapObjectId)
26 create table BoundingBox
28 BoundingBoxID integer(10) not null,
29 WC_X integer(10) null,
30 WC_Y integer(10) null,
31 Height integer(10) null,
32 Width integer(10) null
35 create table MapObject
37 MapObjectID integer(10) not null,
38 WC_X integer(10) null,
39 WC_Y integer(10) null,
40 Height integer(10) null,
41 Width integer(10) null,
42 BoundingBoxID integer(10) null,
43 primary key(MapObjectID)
46 create table Container
48 MapObjectID integer(10) null,
49 item0 integer(10) null,
50 item1 integer(10) null,
51 item2 integer(10) null,
52 item3 integer(10) null,
53 item4 integer(10) null,
54 item5 integer(10) null,
55 item6 integer(10) null,
56 item7 integer(10) null,
57 item8 integer(10) null,
58 item9 integer(10) null,
59 item10 integer(10) null,
60 item11 integer(10) null,
61 item12 integer(10) null,
62 item13 integer(10) null,
63 item14 integer(10) null,
64 foreign key(MapObjectID) references MapObject(MapObjectID)
67 create table Hardpoints
69 MapObjectId integer(10) not null,
70 RelativeX integer(10) not null,
71 RelativeY integer(10) not null,
72 HardpointType integer(10) not null,
73 Width integer(10) null,
74 Height integer(10) null,
75 Radius integer(10) null,
76 primary key (MapObjectId, RelativeX, RelativeY, HardpointType),
77 foreign key (MapObjectId) references MapObject(MapObjectId)
82 MapObjectID integer(10) not null,
83 TileType integer(10) null,
84 foreign key (MapObjectId) references MapObject(MapObjectId)