TribesTable: Difference between revisions

From PSwiki
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…'
 
Grimston (talk | contribs)
mNo edit summary
 
(7 intermediate revisions by 6 users not shown)
Line 1: Line 1:
{| border="1"
 
 
{| class="wikitable"
|+
!UE
!Field
!Type
!Key Type
!Default
!Extra
!Description
|-
|-
! field
|
! type
|id
! foreign key
|int(10)
! description
|PRI
|
|auto_increment
|The ID of the tribe.
|-
|-
| id
|
| integer
|name
|varchar(30)
|
|
|
|  
|  
|-
|
|home_sector_id
|int(10) unsigned
|
|0
|
|  
|  
|-
|-
| name
|
| varchar
|home_x
|float(10,2)
|
|0.00
|
|  
|  
|-
|
|home_y
|float(10,2)
|
|0.00
|
|  
|  
|-
|-
| home_sector_id
|
| integer
|home_z
|float(10,2)
|
|0.00
|
|  
|  
|-
|
|home_radius
|float(10,2)
|
|0.00
|
|  
|  
|-
|-
| home_x
|
| real
|max_size
|int(10)
|
|0
|
|  
|  
|-
|
|wealth_resource_name
|varchar(30)
|
|
|
|  
|  
|-
|-
| home_y
|
| real
|wealth_resource_nick
|varchar(30)
|
|
|
|  
|  
|-
|
|wealth_resource_area
|varchar(30)
|
|
|
|  
|  
|-
|-
| home_z
|
| real
|wealth_gather_need
|  
|varchar(30)
|
|
|
|The need used to gather resources
|-
|
|wealth_resource_growth
|float(10,2)
|
|0.00
|
|  
|  
|-
|-
| home_radius
|
| real
|wealth_resource_growth_active
|  
|float(10,2)
|
|0.00
|
|  
|  
|-
|-
| max_size
|
| integer
|wealth_resource_growth_active_limit
|  
|int(10)
|
|0
|
|  
|  
|-
|-
| wealth_resource_name
|
| varchar
|reproduction_cost
|  
|int(10)
|
|0
|
|  
|  
|-
|-
| wealth_resource_nick
|
| varchar
|npc_idle_behavior
|  
|varchar(30)
|
|do nothing
|
|  
|  
|-
|-
| wealth_resource_area
|
| varchar
|tribal_recipe
|  
|int(5)
|
|
|
|  
|  
|-
|-
| reproduction_cost
|ADD
| integer
|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