TribesTable: Difference between revisions
		
		
		
		Jump to navigation
		Jump to search
		
|  Created page with '{| border="1" |- ! field ! type ! foreign key ! description |- | id | integer |  |  |- | name | varchar |  |  |- | home_sector_id | integer |  |  |- | home_x | real |  |  |- | ho…' | mNo edit summary | ||
| (7 intermediate revisions by 6 users not shown) | |||
| Line 1: | Line 1: | ||
| {|  | |||
| {| class="wikitable" | |||
| |+ | |||
| !UE | |||
| !Field | |||
| !Type | |||
| !Key Type | |||
| !Default | |||
| !Extra | |||
| !Description | |||
| |- | |- | ||
| | | |||
| |id | |||
| |int(10) | |||
| |PRI | |||
| | | |||
| |auto_increment | |||
| |The ID of the tribe.  | |||
| |- | |- | ||
| |  | | | ||
| |  | |name | ||
| |varchar(30) | |||
| | | |||
| | | |||
| | | |||
| |   | |   | ||
| |- | |||
| | | |||
| |home_sector_id | |||
| |int(10) unsigned | |||
| | | |||
| |0 | |||
| | | |||
| |   | |   | ||
| |- | |- | ||
| |  | | | ||
| |  | |home_x | ||
| |float(10,2) | |||
| | | |||
| |0.00 | |||
| | | |||
| |   | |   | ||
| |- | |||
| | | |||
| |home_y | |||
| |float(10,2) | |||
| | | |||
| |0.00 | |||
| | | |||
| |   | |   | ||
| |- | |- | ||
| |  | | | ||
| |  | |home_z | ||
| |float(10,2) | |||
| | | |||
| |0.00 | |||
| | | |||
| |   | |   | ||
| |- | |||
| | | |||
| |home_radius | |||
| |float(10,2) | |||
| | | |||
| |0.00 | |||
| | | |||
| |   | |   | ||
| |- | |- | ||
| |  | | | ||
| |  | |max_size | ||
| |int(10) | |||
| | | |||
| |0 | |||
| | | |||
| |   | |   | ||
| |- | |||
| | | |||
| |wealth_resource_name | |||
| |varchar(30) | |||
| | | |||
| | | |||
| | | |||
| |   | |   | ||
| |- | |- | ||
| |  | | | ||
| |  | |wealth_resource_nick | ||
| |varchar(30) | |||
| | | |||
| | | |||
| | | |||
| |   | |   | ||
| |- | |||
| | | |||
| |wealth_resource_area | |||
| |varchar(30) | |||
| | | |||
| | | |||
| | | |||
| |   | |   | ||
| |- | |- | ||
| |  | | | ||
| |  | |wealth_gather_need | ||
| |   | |varchar(30) | ||
| | | |||
| | | |||
| | | |||
| |The need used to gather resources  | |||
| |- | |||
| | | |||
| |wealth_resource_growth | |||
| |float(10,2) | |||
| | | |||
| |0.00 | |||
| | | |||
| |   | |   | ||
| |- | |- | ||
| |  | | | ||
| |  | |wealth_resource_growth_active | ||
| |   | |float(10,2) | ||
| | | |||
| |0.00 | |||
| | | |||
| |   | |   | ||
| |- | |- | ||
| |  | | | ||
| |  | |wealth_resource_growth_active_limit | ||
| |   | |int(10) | ||
| | | |||
| |0 | |||
| | | |||
| |   | |   | ||
| |- | |- | ||
| |  | | | ||
| |  | |reproduction_cost | ||
| |   | |int(10) | ||
| | | |||
| |0 | |||
| | | |||
| |   | |   | ||
| |- | |- | ||
| |  | | | ||
| | varchar | |npc_idle_behavior | ||
| |   | |varchar(30) | ||
| | | |||
| |do nothing | |||
| | | |||
| |   | |   | ||
| |- | |- | ||
| |  | | | ||
| |  | |tribal_recipe | ||
| |   | |int(5) | ||
| | | |||
| | | |||
| | | |||
| |   | |   | ||
| |- | |- | ||
| |  | |ADD | ||
| |  | |enabled | ||
| |   | |tinyint(4) | ||
| |   | | | ||
| |1 | |||
| | | |||
| |Is this tribe enabled or not  | |||
| |} | |} | ||
Latest revision as of 15:19, 11 January 2022
| UE | Field | Type | Key Type | Default | Extra | Description | 
|---|---|---|---|---|---|---|
| id | int(10) | PRI | auto_increment | The ID of the tribe. | ||
| name | varchar(30) | |||||
| home_sector_id | int(10) unsigned | 0 | ||||
| home_x | float(10,2) | 0.00 | ||||
| home_y | float(10,2) | 0.00 | ||||
| home_z | float(10,2) | 0.00 | ||||
| home_radius | float(10,2) | 0.00 | ||||
| max_size | int(10) | 0 | ||||
| wealth_resource_name | varchar(30) | |||||
| wealth_resource_nick | varchar(30) | |||||
| wealth_resource_area | varchar(30) | |||||
| wealth_gather_need | varchar(30) | The need used to gather resources | ||||
| wealth_resource_growth | float(10,2) | 0.00 | ||||
| wealth_resource_growth_active | float(10,2) | 0.00 | ||||
| wealth_resource_growth_active_limit | int(10) | 0 | ||||
| reproduction_cost | int(10) | 0 | ||||
| npc_idle_behavior | varchar(30) | do nothing | ||||
| tribal_recipe | int(5) | |||||
| ADD | enabled | tinyint(4) | 1 | Is this tribe enabled or not |