Difference between revisions of "Banks (Database Table)"
From SWGANH Wiki
(→Table Create Script) |
(→Table Describe) |
||
Line 45: | Line 45: | ||
==Table Describe== | ==Table Describe== | ||
<pre> | <pre> | ||
− | + | 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) | ||
</pre> | </pre> |
Revision as of 23:34, 14 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)