Buildings (Database Table)

Database Table - buildings

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 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)