Difference between revisions of "Banks (Database Table)"

From SWGANH Wiki
Jump to: navigation, search
(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 Structure

Field Type Unsigned Autoinc Null Key Default Value Description
Symbol OK.png Symbol OK.png

Related Tags

25% This document has been partially completed.

Database This document relates to the SWGANH Database Schema.

DB Table This document relates to the SWGANH Database Schema.

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)