Difference between revisions of "Building types (Database Table)"

Table Structure Field Type Unsigned Autoinc Null Key Default Value Description

Related Tags 25% This document has been partially completed. Database This document relates to the SWGANH Database Schema. DB Table This document relates to the SWGANH Database Schema.

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)