Difference between revisions of "Banks (Database Table)"
From SWGANH Wiki
(→Table Describe) |
(→Table Structure) |
||
Line 13: | Line 13: | ||
||'''Field'''||'''Type'''||'''Unsigned'''||'''Autoinc'''||'''Null'''||'''Key'''||'''Default Value'''||'''Description''' | ||'''Field'''||'''Type'''||'''Unsigned'''||'''Autoinc'''||'''Null'''||'''Key'''||'''Default Value'''||'''Description''' | ||
|- align="center" | |- align="center" | ||
− | |align="left"| || ||align="center"|[[Image:Symbol OK.png|10px]]||align="center"|[[Image:Symbol OK.png|10px]]|| | + | |align="left"|id||bigint(20)||align="center"|[[Image:Symbol OK.png|10px]]||align="center"| || ||align="center"|[[Image:Symbol OK.png|10px]]||0|| |
|- align="center" style="background-color:#F1F1F1;" | |- align="center" style="background-color:#F1F1F1;" | ||
− | || || ||align="center"| ||align="center"| || || || || | + | ||credits||int(11)||align="center"| ||align="center"| || ||align="center"|[[Image:Symbol OK.png|10px]]||0|| |
|- | |- | ||
|} | |} | ||
|} | |} | ||
− | |||
|valign=top| | |valign=top| | ||
Revision as of 07:01, 25 June 2007
Database Table - banks
SWGANH Wiki is a repository of Star Wars Galaxies Developer information. This site is only meant to be used by SWGANH Developer team.
Table Create Script
CREATE TABLE `banks` ( `id` bigint(20) unsigned NOT NULL default '0', `credits` int(11) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Table Describe
mysql> desc banks; +---------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+---------------------+------+-----+---------+-------+ | id | bigint(20) unsigned | NO | PRI | 0 | | | credits | int(11) unsigned | NO | | 0 | | +---------+---------------------+------+-----+---------+-------+ 2 rows in set (0.00 sec)