Difference between revisions of "Building types (Database Table)"
From SWGANH Wiki
(→Table Create Script) |
(→Table Describe) |
||
Line 51: | Line 51: | ||
==Table Describe== | ==Table Describe== | ||
<pre> | <pre> | ||
− | + | mysql> desc building_types; | |
+ | +--------+---------------------+------+-----+-------------------------------+----------------+ | ||
+ | | Field | Type | Null | Key | Default | Extra | | ||
+ | +--------+---------------------+------+-----+-------------------------------+----------------+ | ||
+ | | id | int(11) | NO | PRI | NULL | auto_increment | | ||
+ | | model | char(255) | NO | UNI | | | | ||
+ | | cells | tinyint(2) unsigned | NO | | 1 | | | ||
+ | | width | float | NO | | 128 | | | ||
+ | | height | float | NO | | 128 | | | ||
+ | | file | char(255) | NO | | building_name | | | ||
+ | | name | char(255) | NO | | housing_general_small_style_1 | | | ||
+ | +--------+---------------------+------+-----+-------------------------------+----------------+ | ||
+ | 7 rows in set (0.00 sec) | ||
+ | |||
</pre> | </pre> |
Latest revision as of 00:29, 15 June 2007
Database Table - building_types
SWGANH Wiki is a repository of Star Wars Galaxies Developer information. This site is only meant to be used by SWGANH Developer team.
Table Create Script
CREATE TABLE `building_types` ( `id` int(11) NOT NULL auto_increment, `model` char(255) NOT NULL, `cells` tinyint(2) unsigned NOT NULL default '1', `width` float NOT NULL default '128', `height` float NOT NULL default '128', `file` char(255) NOT NULL default 'building_name', `name` char(255) NOT NULL default 'housing_general_small_style_1', PRIMARY KEY (`id`), UNIQUE KEY `pk_buildingtypes_objstr` (`model`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Table Describe
mysql> desc building_types; +--------+---------------------+------+-----+-------------------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------+---------------------+------+-----+-------------------------------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | model | char(255) | NO | UNI | | | | cells | tinyint(2) unsigned | NO | | 1 | | | width | float | NO | | 128 | | | height | float | NO | | 128 | | | file | char(255) | NO | | building_name | | | name | char(255) | NO | | housing_general_small_style_1 | | +--------+---------------------+------+-----+-------------------------------+----------------+ 7 rows in set (0.00 sec)