Difference between revisions of "Buildings (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 `buildings` (
  `id` bigint(20) unsigned NOT NULL default '0',
  `oX` float NOT NULL default '0',
  `oY` float NOT NULL default '0',
  `oZ` float NOT NULL default '0',
  `oW` float NOT NULL default '0',
  `x` float NOT NULL default '0',
  `y` float NOT NULL default '0',
  `z` float NOT NULL default '0',
  `type_id` int(11) NOT NULL default '1',
  `planet_id` int(2) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `fk_static_buildings_planet_planet` (`planet_id`),
  KEY `fk_st_build_type_type` (`type_id`),
  CONSTRAINT `buildings_ibfk_1` FOREIGN KEY (`planet_id`) REFERENCES `planet` (`planet_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `buildings_ibfk_2` FOREIGN KEY (`type_id`) REFERENCES `building_types` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `buildings_ibfk_3` FOREIGN KEY (`planet_id`) REFERENCES `planet` (`planet_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `buildings_ibfk_4` FOREIGN KEY (`type_id`) REFERENCES `building_types` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Table Describe

mysql> desc buildings;
+-----------+---------------------+------+-----+---------+-------+
| Field     | Type                | Null | Key | Default | Extra |
+-----------+---------------------+------+-----+---------+-------+
| id        | bigint(20) unsigned | NO   | PRI | 0       |       | 
| oX        | float               | NO   |     | 0       |       | 
| oY        | float               | NO   |     | 0       |       | 
| oZ        | float               | NO   |     | 0       |       | 
| oW        | float               | NO   |     | 0       |       | 
| x         | float               | NO   |     | 0       |       | 
| y         | float               | NO   |     | 0       |       | 
| z         | float               | NO   |     | 0       |       | 
| type_id   | int(11)             | NO   | MUL | 1       |       | 
| planet_id | int(2)              | NO   | MUL | 0       |       | 
+-----------+---------------------+------+-----+---------+-------+
10 rows in set (0.01 sec)