Difference between revisions of "Banks (Database Table)"

Table Structure Field Type Unsigned Autoinc Null Key Default Value Description id bigint(20) 0 credits int(11) 0

Related Tags 100% This document is complete. 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)