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 Create Script) |
||
| 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> | ||
Revision as of 23:30, 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;
