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

From SWGANH Wiki
Jump to: navigation, search
(Table Structure)
 
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"|id|| ||align="center"|[[Image:Symbol OK.png|10px]]||align="center"|[[Image:Symbol OK.png|10px]]|| || || ||  
+
|align="left"|id||int(10)||align="center"|[[Image:Symbol OK.png|10px]]||align="center"|[[Image:Symbol OK.png|10px]]|| || || ||Biography ID
 
|- align="center" style="background-color:#F1F1F1;"
 
|- align="center" style="background-color:#F1F1F1;"
|| || ||align="center"| ||align="center"| || || || ||  
+
|align="left"|planet||varchar(45)||align="center"| ||align="center"| || || || ||Planet Name
 
|-
 
|-
 
|}
 
|}
Line 38: Line 38:
 
CREATE TABLE `biography_planet` (
 
CREATE TABLE `biography_planet` (
 
   `id` int(10) unsigned NOT NULL auto_increment,
 
   `id` int(10) unsigned NOT NULL auto_increment,
   `planet` varchar(45) character set latin1 NOT NULL,
+
   `planet` varchar(45) NOT NULL,
 
   PRIMARY KEY  (`id`)
 
   PRIMARY KEY  (`id`)
 
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Latest revision as of 15:03, 26 April 2009

Database Table - biography_planet

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 Biography ID
planet varchar(45) Planet Name

Related Tags

25% This document has been partially completed.

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_planet` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `planet` varchar(45) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Table Describe