AlliancesTable: Difference between revisions

Latest revision as of 14:19, 11 January 2022


UE	Field	Type	Key Type	Default	Extra	Description
	id	int(11)	PRI		auto_increment
DIF	date_created	timestamp		CURRENT_TIMESTAMP		Nullable used to be 'YES' in PSLegacy.
	name	varchar(25)	UNI
	leading_guild	int(11)				The leading guild of the alliance

@@ Line 1: / Line 1: @@
-{| border=1
+{| class="wikitable"
+|+
+!UE
+!Field
+!Type
+!Key Type
+!Default
+!Extra
+!Description
 |-
-! field
+|
-! type
+|id
-! foreign key
+|int(11)
-! description
+|PRI
+|
+|auto_increment
+|
 |-
-| id
+|DIF
-| int(11)
+|date_created
-| N
+|timestamp
-| Primary Key
+|
+|CURRENT_TIMESTAMP
+|
+|  Nullable used to be 'YES' in PSLegacy.
 |-
-| name
+|
-| varchar(25)
+|name
-| N
+|varchar(25)
-| Alliance Name
+|UNI
+|
+|
+|
 |-
-| leading_guild
+|
-| int(11)
+|leading_guild
-| Y [[GuildsTable|guilds.id]]
+|int(11)
-| The leading guild.
+|
+|
+|
+|The leading guild of the alliance
 |}
 [[Category:Engine documents]]