Difference between revisions of "Attributes (Database Table)"
From SWGANH Wiki
(New page: {{PageHeader|Database Table|Attributes}} {| border="0" width="90%" cellpadding=6 |- |valign=top| ==Table Structure== {| align="center" |- || {| class = "anhsmalltable" |- align="center" s...) |
|||
| (2 intermediate revisions by one other user not shown) | |||
| Line 18: | Line 18: | ||
|- align="center" style="background-color:#F1F1F1;" | |- align="center" style="background-color:#F1F1F1;" | ||
|align="left"|attribute_internal_description||text||align="center"| ||align="center"| ||NO|| ||Null||Attribute Description | |align="left"|attribute_internal_description||text||align="center"| ||align="center"| ||NO|| ||Null||Attribute Description | ||
| + | |- align="center" | ||
| + | |align="left"|item_tool_internal||int(10)||align="center"|[[Image:Symbol OK.png|10px]]||align="center"| ||NO|| ||0||Attribute Description | ||
| + | |- align="center" | ||
| + | |align="left"|item_tool_internal_2||int(10)||align="center"|[[Image:Symbol OK.png|10px]]||align="center"| ||NO|| ||0||Attribute Description | ||
|} | |} | ||
|} | |} | ||
| Line 25: | Line 29: | ||
{|align="center" | {|align="center" | ||
|- | |- | ||
| − | ||{{ | + | ||{{D100%}} |
|- | |- | ||
||{{Database}} | ||{{Database}} | ||
| Line 33: | Line 37: | ||
|} | |} | ||
|} | |} | ||
| − | |||
| − | |||
==Table Create Script== | ==Table Create Script== | ||
<pre> | <pre> | ||
| − | DROP TABLE IF EXISTS | + | DROP TABLE IF EXISTS `attributes`; |
| − | CREATE TABLE | + | 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, | `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`), | PRIMARY KEY (`id`), | ||
UNIQUE KEY `pk_attributes_name` (`name`) | UNIQUE KEY `pk_attributes_name` (`name`) | ||
| − | ) ENGINE=InnoDB AUTO_INCREMENT= | + | ) ENGINE=InnoDB AUTO_INCREMENT=2060 DEFAULT CHARSET=utf8; |
</pre> | </pre> | ||
==Table Describe== | ==Table Describe== | ||
<pre> | <pre> | ||
| − | mysql> | + | mysql> describe attributes; |
+--------------------------------+---------------------+------+-----+---------+----------------+ | +--------------------------------+---------------------+------+-----+---------+----------------+ | ||
| Field | Type | Null | Key | Default | Extra | | | Field | Type | Null | Key | Default | Extra | | ||
| Line 59: | Line 63: | ||
| internal | tinyint(3) unsigned | NO | | 0 | | | | internal | tinyint(3) unsigned | NO | | 0 | | | ||
| attribute_internal_description | text | NO | | NULL | | | | 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) | |
</pre> | </pre> | ||
Latest revision as of 22:28, 12 March 2010
Database Table - Attributes
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
|
Related Tags
|
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)
