Codex locationsTable: Difference between revisions
		
		
		
		Jump to navigation
		Jump to search
		
|  Created page with "{| class="wikitable" |+ !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..." | 
| (No difference) | 
Latest revision as of 13:46, 11 January 2022
| 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 |