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...) |
(→Related Tags) |
||
| Line 25: | Line 25: | ||
{|align="center" | {|align="center" | ||
|- | |- | ||
| − | ||{{ | + | ||{{D100%}} |
|- | |- | ||
||{{Database}} | ||{{Database}} | ||
| Line 33: | Line 33: | ||
|} | |} | ||
|} | |} | ||
| − | |||
| − | |||
==Table Create Script== | ==Table Create Script== | ||
Revision as of 19:17, 16 June 2008
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 `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;
Table Describe
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)
