Difference between revisions of "Attributes (Database Table)"

Table Structure Field Type Unsigned Autoinc Null Key Default Value Description id int(11) NO Primary Null Attribute ID name char(255) YES Unique Null Attribute Name internal tinyint(3) NO 0 Attribute Description attribute_internal_description text NO Null Attribute Description item_tool_internal int(10) NO 0 Attribute Description item_tool_internal_2 int(10) NO 0 Attribute Description

Related Tags 100% This document is complete. Database This document relates to the SWGANH Database Schema. DB Table This document relates to the SWGANH Database Schema.

Table Create Script

DROP TABLE IF EXISTS `attributes`;
CREATE TABLE `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,
  `item_tool_internal` int(10) unsigned NOT NULL default '0',
  `item_tool_internal_2` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `pk_attributes_name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=2060 DEFAULT CHARSET=utf8;

Table Describe

mysql> describe 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    |                |
| item_tool_internal             | int(10) unsigned    | NO   |     | 0       |                |
| item_tool_internal_2           | int(10) unsigned    | NO   |     | 0       |                |
+--------------------------------+---------------------+------+-----+---------+----------------+
6 rows in set (0.23 sec)