Difference between revisions of "Biography wars (Database Table)"

From SWGANH Wiki
Jump to: navigation, search
(New page: {{PageHeader|Database Table|biography_wars}} {| border="0" width="90%" cellpadding=6 |- |valign=top| ==Table Structure== {| align="center" |- || {| class = "wikitable" |- align="center"...)
 
(Related Tags)
 
(2 intermediate revisions by the same user not shown)
Line 13: Line 13:
 
||'''Field'''||'''Type'''||'''Unsigned'''||'''Autoinc'''||'''Null'''||'''Key'''||'''Default Value'''||'''Description'''
 
||'''Field'''||'''Type'''||'''Unsigned'''||'''Autoinc'''||'''Null'''||'''Key'''||'''Default Value'''||'''Description'''
 
|- align="center"  
 
|- align="center"  
|align="left"| || ||align="center"|[[Image:Symbol OK.png|10px]]||align="center"|[[Image:Symbol OK.png|10px]]|| || || ||  
+
|align="center"|id||int(10)||align="center"|[[Image:Symbol OK.png|10px]]||align="center"|[[Image:Symbol OK.png|10px]]|| ||[[Image:Symbol OK.png|10px]]|| ||ID
 
|- align="center" style="background-color:#F1F1F1;"
 
|- align="center" style="background-color:#F1F1F1;"
|| || ||align="center"| ||align="center"| || || || ||  
+
||war||char(64)||align="center"| ||align="center"| || || || ||War Name
 
|-
 
|-
 
|}
 
|}
Line 25: Line 25:
 
{|align="center"
 
{|align="center"
 
|-
 
|-
||{{D25%}}
+
||{{D100%}}
 
|-
 
|-
 
||{{Database}}
 
||{{Database}}
Line 36: Line 36:
 
==Table Create Script==
 
==Table Create Script==
 
<pre>
 
<pre>
   
+
CREATE TABLE `biography_wars` (
 +
  `id` int(10) unsigned NOT NULL auto_increment,
 +
  `war` char(64) NOT NULL,
 +
  PRIMARY KEY (`id`)
 +
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
</pre>
 
</pre>
  

Latest revision as of 06:53, 16 June 2007

Database Table - biography_wars

SWGANH Wiki is a repository of Star Wars Galaxies Developer information. This site is only meant to be used by SWGANH Developer team.


Table Structure

Field Type Unsigned Autoinc Null Key Default Value Description
id int(10) Symbol OK.png Symbol OK.png Symbol OK.png ID
war char(64) War Name

Related Tags

100% This document is complete.

Database This document relates to the SWGANH Database Schema.

DB Table This document relates to the SWGANH Database Schema.

Table Create Script

CREATE TABLE `biography_wars` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `war` char(64) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Table Describe