Attributes (Database Table) - Revision history

Nebula at 03:28, 13 March 2010

2010-03-13T03:28:35Z

Snow: /* Table Create Script */

2008-12-26T17:50:48Z

‎Table Create Script

Snow: /* Related Tags */

2008-06-17T00:17:39Z

‎Related Tags

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

2008-06-17T00:16:22Z

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

New page

{{PageHeader|Database Table|Attributes}}
{| border="0" width="90%" cellpadding=6
|-
|valign=top|
==Table Structure==
{| align="center"
|-
||
{| class = "anhsmalltable"
|- align="center" style="background-color:#ffffcc;"
|width="100px"|'''Field'''||width="60px"|'''Type'''||width="60px"|'''Unsigned'''||width="60px"|'''Autoinc'''||width="40px"|'''Null'''||width="40px"|'''Key'''||width="100px"|'''Default Value'''||width="200px"|'''Description'''
|- align="center"
|align="left"|id||int(11)||align="center"|[[Image:Symbol OK.png|10px]]||align="center"|[[Image:Symbol OK.png|10px]]||NO||Primary||Null||Attribute ID
|- align="center" style="background-color:#F1F1F1;"
|align="left"|name||char(255)||align="center"| ||align="center"| ||YES||Unique||Null||Attribute Name
|- align="center"
|align="left"|internal||tinyint(3)||align="center"|[[Image:Symbol OK.png|10px]]||align="center"| ||NO|| ||0||Attribute Description
|- align="center" style="background-color:#F1F1F1;"
|align="left"|attribute_internal_description||text||align="center"| ||align="center"| ||NO|| ||Null||Attribute Description
|}
|}
|valign=top|

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

==Table Create Script==
<pre>
DROP TABLE IF EXISTS `swganh`.`attributes`;
CREATE TABLE `swganh`.`attributes` (
`id` int(11) unsigned NOT NULL auto_increment,
`name` char(255) default NULL,
`internal` tinyint(3) unsigned NOT NULL default '0',
`attribute_internal_description` text NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `pk_attributes_name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=837 DEFAULT CHARSET=utf8;
</pre>

==Table Describe==
<pre>
mysql> desc attributes;
+--------------------------------+---------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------------------------+---------------------+------+-----+---------+----------------+
| id | int(11) unsigned | NO | PRI | NULL | auto_increment |
| name | char(255) | YES | UNI | NULL | |
| internal | tinyint(3) unsigned | NO | | 0 | |
| attribute_internal_description | text | NO | | NULL | |
+--------------------------------+---------------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)
</pre>

@@ Line 18: / Line 18: @@
 |- align="center" style="background-color:#F1F1F1;"
 |align="left"|attribute_internal_description||text||align="center"| ||align="center"| ||NO|| ||Null||Attribute Description
 |}
 |}
@@ Line 38: / Line 42: @@
 DROP TABLE IF EXISTS `attributes`;
 CREATE TABLE `attributes` (
-   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
+   `id` int(11) unsigned NOT NULL auto_increment,
-   `name` char(255) DEFAULT NULL,
+   `name` char(255) default NULL,
-   `internal` tinyint(3) unsigned NOT NULL DEFAULT '0',
+   `internal` tinyint(3) unsigned NOT NULL default '0',
    `attribute_internal_description` text NOT NULL,
-   PRIMARY KEY (`id`),
+  `item_tool_internal` int(10) unsigned NOT NULL default '0',
    UNIQUE KEY `pk_attributes_name` (`name`)
-) ENGINE=InnoDB AUTO_INCREMENT=1289 DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB AUTO_INCREMENT=2060 DEFAULT CHARSET=utf8;
 </pre>
 ==Table Describe==
 <pre>
-mysql> desc attributes;
+mysql> describe attributes;
 +--------------------------------+---------------------+------+-----+---------+----------------+
 | Field                          | Type                | Null | Key | Default | Extra          |
@@ Line 57: / Line 63: @@
 | internal                       | tinyint(3) unsigned | NO   |     | 0       |                |
 | attribute_internal_description | text                | NO   |     | NULL    |                |
 +--------------------------------+---------------------+------+-----+---------+----------------+
-rows in set (0.00 sec)
+rows in set (0.23 sec)
 </pre>

@@ Line 25: / Line 25: @@
 {|align="center"
 |-
-||{{D75%}}
+||{{D100%}}
 |-
 ||{{Database}}
@@ Line 33: / Line 33: @@
 |}
 |}
 ==Table Create Script==