Difference between revisions of "Banks (Database Table)"
From SWGANH Wiki
(New page: {{PageHeader|Database Table|banks}} {| border="0" width="90%" cellpadding=6 |- |valign=top| ==Table Structure== {| align="center" |- || {| class = "wikitable" |- align="center" style="b...) |
m (Protected "Banks (Database Table)": Page is complete. [edit=sysop:move=sysop]) |
||
| (4 intermediate revisions by the same user not shown) | |||
| 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| | ||
| Line 25: | Line 24: | ||
{|align="center" | {|align="center" | ||
|- | |- | ||
| − | ||{{ | + | ||{{D100%}} |
|- | |- | ||
||{{Database}} | ||{{Database}} | ||
| Line 36: | Line 35: | ||
==Table Create Script== | ==Table Create Script== | ||
<pre> | <pre> | ||
| − | + | 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; | ||
</pre> | </pre> | ||
==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> | ||
Latest 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 Structure
|
Related Tags
|
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)
