Difference between revisions of "Buildings (Database Table)"
From SWGANH Wiki
(New page: {{PageHeader|Database Table|buildings}} {| border="0" width="90%" cellpadding=6 |- |valign=top| ==Table Structure== {| align="center" |- || {| class = "wikitable" |- align="center" styl...) |
(→Table Describe) |
||
| Line 41: | Line 41: | ||
==Table Describe== | ==Table Describe== | ||
<pre> | <pre> | ||
| − | + | 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) | ||
</pre> | </pre> | ||
Revision as of 00:29, 15 June 2007
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
|
Related Tags
|
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)
