Biography planet (Database Table) - Revision history

Snow at 19:03, 26 April 2009

2009-04-26T19:03:04Z

Snow: /* Table Structure */

2009-04-26T19:01:52Z

‎Table Structure

Snow: /* Table Create Script */

2007-06-15T04:26:28Z

‎Table Create Script

Snow: /* Table Create Script */

2007-06-15T04:26:13Z

‎Table Create Script

Snow: New page: {{PageHeader|Database Table|biography_planet}} {| border="0" width="90%" cellpadding=6 |- |valign=top| ==Table Structure== {| align="center" |- || {| class = "wikitable" |- align="cente...

2007-06-07T01:31:19Z

New page: {{PageHeader|Database Table|biography_planet}} {| border="0" width="90%" cellpadding=6 |- |valign=top| ==Table Structure== {| align="center" |- || {| class = "wikitable" |- align="cente...

New page

{{PageHeader|Database Table|biography_planet}}

{| border="0" width="90%" cellpadding=6
|-
|valign=top|

==Table Structure==
{| align="center"
|-
||
{| class = "wikitable"
|- align="center" style="background-color:#ffffcc;"
||'''Field'''||'''Type'''||'''Unsigned'''||'''Autoinc'''||'''Null'''||'''Key'''||'''Default Value'''||'''Description'''
|- align="center"
|align="left"| || ||align="center"|[[Image:Symbol OK.png|10px]]||align="center"|[[Image:Symbol OK.png|10px]]|| || || ||
|- align="center" style="background-color:#F1F1F1;"
|| || ||align="center"| ||align="center"| || || || ||
|-
|}
|}

|valign=top|

== Related Tags ==
{|align="center"
|-
||{{D25%}}
|-
||{{Database}}
|-
||{{DatabaseTable}}
|-
|}
|}

==Table Create Script==
<pre>

</pre>

==Table Describe==
<pre>

</pre>

@@ Line 13: / Line 13: @@
 ||'''Field'''||'''Type'''||'''Unsigned'''||'''Autoinc'''||'''Null'''||'''Key'''||'''Default Value'''||'''Description'''
 |- 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"| ||align="center"| || || || ||
+|align="left"|planet||varchar(45)||align="center"| ||align="center"| || || || ||Planet Name
 |-
 |}
@@ Line 38: / Line 38: @@
 CREATE TABLE `biography_planet` (
    `id` int(10) unsigned NOT NULL auto_increment,
-   `planet` varchar(45) character set latin1 NOT NULL,
+   `planet` varchar(45) NOT NULL,
    PRIMARY KEY  (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

@@ Line 36: / Line 36: @@
 ==Table Create Script==
 <pre>
 CREATE TABLE `biography_planet` (
    `id` int(10) unsigned NOT NULL auto_increment,
@@ Line 42: / Line 41: @@
    PRIMARY KEY  (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 </pre>

@@ Line 36: / Line 36: @@
 ==Table Create Script==
 <pre>
+  /* Formatted on 2007/06/15 01:26 (MySQL Formatter v5.34) */
 </pre>