Difference between revisions of "Cells (Database Table)"
From SWGANH Wiki
(New page: {{PageHeader|Database Table|cells}} {| border="0" width="90%" cellpadding=6 |- |valign=top| ==Table Structure== {| align="center" |- || {| class = "wikitable" |- align="center" style="b...) |
(→Table Describe) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 36: | Line 36: | ||
==Table Create Script== | ==Table Create Script== | ||
<pre> | <pre> | ||
| − | + | CREATE TABLE `cells` ( | |
| + | `id` bigint(20) unsigned NOT NULL default '0', | ||
| + | `parent_id` bigint(20) unsigned NOT NULL default '0', | ||
| + | PRIMARY KEY (`id`), | ||
| + | KEY `fk_st_cells_parent_parent` (`parent_id`), | ||
| + | CONSTRAINT `fk_cells_building_building` FOREIGN KEY (`parent_id`) REFERENCES `buildings` (`id`) ON DELETE CASCADE ON UPDATE CASCADE | ||
| + | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ||
</pre> | </pre> | ||
==Table Describe== | ==Table Describe== | ||
<pre> | <pre> | ||
| − | + | mysql> desc cells; | |
| + | +-----------+---------------------+------+-----+---------+-------+ | ||
| + | | Field | Type | Null | Key | Default | Extra | | ||
| + | +-----------+---------------------+------+-----+---------+-------+ | ||
| + | | id | bigint(20) unsigned | NO | PRI | 0 | | | ||
| + | | parent_id | bigint(20) unsigned | NO | MUL | 0 | | | ||
| + | +-----------+---------------------+------+-----+---------+-------+ | ||
| + | 2 rows in set (0.00 sec) | ||
</pre> | </pre> | ||
Latest revision as of 23:31, 14 June 2007
Database Table - cells
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
CREATE TABLE `cells` ( `id` bigint(20) unsigned NOT NULL default '0', `parent_id` bigint(20) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `fk_st_cells_parent_parent` (`parent_id`), CONSTRAINT `fk_cells_building_building` FOREIGN KEY (`parent_id`) REFERENCES `buildings` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Table Describe
mysql> desc cells; +-----------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+---------------------+------+-----+---------+-------+ | id | bigint(20) unsigned | NO | PRI | 0 | | | parent_id | bigint(20) unsigned | NO | MUL | 0 | | +-----------+---------------------+------+-----+---------+-------+ 2 rows in set (0.00 sec)
