Buildings (Database Table)

From SWGANH Wiki
Revision as of 23:29, 14 June 2007 by Snow (Talk | contribs) (Table Describe)

Jump to: navigation, search

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
Symbol OK.png Symbol OK.png

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

 

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)