Badge categories (Database Table) - Revision history

Nebula at 03:54, 13 March 2010

2010-03-13T03:54:21Z

Snow: /* Table Structure */

2007-06-06T16:42:33Z

‎Table Structure

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

2007-06-06T16:41:07Z

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

New page

{{PageHeader|Database Table|badge_categories}}

{| 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"|id||int(10)||align="center"|[[Image:Symbol OK.png|10px]]||align="center"|[[Image:Symbol OK.png|10px]]||NO||Primary||Null||Attack ID
|- align="center" style="background-color:#F1F1F1;"
||attackname||char(32)||align="center"| ||align="center"| ||NO|| || ||Attack Name
|-
|}
|}

|valign=top|

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

==Table Create Script==
<pre>
--
-- Definition of table `attacks`
--

DROP TABLE IF EXISTS `attacks`;
CREATE TABLE `attacks` (
`id` int(10) unsigned NOT NULL auto_increment,
`attackname` char(32) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
</pre>

==Table Describe==
<pre>
mysql> desc attacks;
+------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+------------------+------+-----+---------+----------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| attackname | char(32) | YES | | NULL | |
+------------+------------------+------+-----+---------+----------------+
2 rows in set (0.00 sec)
</pre>

@@ Line 13: / Line 13: @@
 ||'''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="left"|Id||int(11)||align="center"|[[Image:Symbol OK.png|10px]]||align="center"| ||NO||Primary||0||ID
 |- align="center" style="background-color:#F1F1F1;"
-|| || ||align="center"| ||align="center"| || || || ||
+|align="left"|name||char(255)||align="center"| ||align="center"| ||YES||Unique||NULL||Badge Category Name
 |-
 |}
@@ Line 25: / Line 25: @@
 {|align="center"
 |-
-||{{D75%}}
+||{{D100%}}
 |-
 ||{{Database}}
@@ Line 37: / Line 37: @@
 <pre>
 --
--- Definition of table `attacks`
+-- Definition of table `badge_categories`
 --
-DROP TABLE IF EXISTS `attacks`;
+DROP TABLE IF EXISTS `badge_categories`;
-CREATE TABLE `attacks` (
+CREATE TABLE `badge_categories` (
-   `id` int(10) unsigned NOT NULL auto_increment,
+   `Id` int(11) unsigned NOT NULL default '0',
-   `attackname` char(32) default NULL,
+   `name` char(255) default NULL,
-   PRIMARY KEY  (`id`)
+   PRIMARY KEY  (`Id`),
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+  UNIQUE KEY `pk_name` (`name`)
 </pre>
 ==Table Describe==
 <pre>
-mysql> desc attacks;
+mysql> describe badge_categories;
-+------------+------------------+------+-----+---------+----------------+
++-------+------------------+------+-----+---------+-------+
-| Field      | Type             | Null | Key | Default | Extra          |
+| Field | Type             | Null | Key | Default | Extra |
-+------------+------------------+------+-----+---------+----------------+
++-------+------------------+------+-----+---------+-------+
-| id         | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
+| Id    | int(11) unsigned | NO   | PRI | 0       |       |
-| attackname | char(32)         | YES  |     | NULL    |                |
+| name  | char(255)        | YES  | UNI | NULL    |       |
-+------------+------------------+------+-----+---------+----------------+
++-------+------------------+------+-----+---------+-------+
-rows in set (0.00 sec)
+rows in set (0.10 sec)
 </pre>