Difference between revisions of "Building types (Database Table)"
From SWGANH Wiki
(New page: {{PageHeader|Database Table|building_types}} {| border="0" width="90%" cellpadding=6 |- |valign=top| ==Table Structure== {| align="center" |- || {| class = "wikitable" |- align="center"...) |
(→Table Create Script) |
||
Line 36: | Line 36: | ||
==Table Create Script== | ==Table Create Script== | ||
<pre> | <pre> | ||
− | + | 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; | ||
</pre> | </pre> | ||
Revision as of 00:28, 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;