Codex locationsTable
| UE | Field | Type | Key Type | Default | Extra | Description |
|---|---|---|---|---|---|---|
| ADD | id | int(11) | PRI | auto_increment | ||
| ADD | item_type | varchar(100) | 1 = location on main map, 2 = submap owned, 3 = NPC | |||
| ADD | item_name | varchar(100) | ex.: Stone Labirynths, Hydlaa City, Ojaveda, ... | |||
| ADD | item_desc | text | the knowledge we provide to the player | |||
| ADD | item_icon | varchar(100) | ||||
| ADD | mainmap_id | int(11) | if item_type is submap, this points to the main map item id | |||
| ADD | npc_id | int(11) | if is an NPC, this points to characters.id | |||
| ADD | coords_X | int(11) | if item_type is NPC these are the coordinates on the submap | |||
| ADD | coords_Y | varchar(100) | if item_type is NPC these are the coordinates on the submap |