Difference between revisions of "Biography faction (Database Table)"
From SWGANH Wiki
(New page: {{PageHeader|Database Table|biography_faction}} {| border="0" width="90%" cellpadding=6 |- |valign=top| ==Table Structure== {| align="center" |- || {| class = "wikitable" |- align="cent...) |
|||
| (One intermediate revision 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"| | + | |align="left"|faction||varchar(45)||align="center"| ||align="center"| ||NO||Primary||NULL|| |
| − | + | ||
| − | + | ||
| − | | | + | |
|} | |} | ||
|} | |} | ||
| Line 25: | Line 22: | ||
{|align="center" | {|align="center" | ||
|- | |- | ||
| − | ||{{ | + | ||{{D75%}} |
|- | |- | ||
||{{Database}} | ||{{Database}} | ||
| Line 36: | Line 33: | ||
==Table Create Script== | ==Table Create Script== | ||
<pre> | <pre> | ||
| − | + | DROP TABLE IF EXISTS `biography_faction`; | |
| + | CREATE TABLE `biography_faction` ( | ||
| + | `faction` varchar(45) NOT NULL, | ||
| + | PRIMARY KEY (`faction`(1)) | ||
| + | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=REDUNDANT; | ||
</pre> | </pre> | ||
==Table Describe== | ==Table Describe== | ||
<pre> | <pre> | ||
| − | + | mysql> describe biography_faction; | |
| + | +---------+-------------+------+-----+---------+-------+ | ||
| + | | Field | Type | Null | Key | Default | Extra | | ||
| + | +---------+-------------+------+-----+---------+-------+ | ||
| + | | faction | varchar(45) | NO | PRI | NULL | | | ||
| + | +---------+-------------+------+-----+---------+-------+ | ||
| + | 1 row in set (0.09 sec) | ||
</pre> | </pre> | ||
Latest revision as of 23:30, 12 March 2010
Database Table - biography_faction
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
|
Related Tags
|
Table Create Script
DROP TABLE IF EXISTS `biography_faction`; CREATE TABLE `biography_faction` ( `faction` varchar(45) NOT NULL, PRIMARY KEY (`faction`(1)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=REDUNDANT;
Table Describe
mysql> describe biography_faction; +---------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+-------------+------+-----+---------+-------+ | faction | varchar(45) | NO | PRI | NULL | | +---------+-------------+------+-----+---------+-------+ 1 row in set (0.09 sec)
