Difference between revisions of "Banks (Database Table)"

From SWGANH Wiki
Jump to: navigation, search
(Table Describe)
m (Protected "Banks (Database Table)": Page is complete. [edit=sysop:move=sysop])
 
(2 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"
 
|-
 
|-
||{{D25%}}
+
||{{D100%}}
 
|-
 
|-
 
||{{Database}}
 
||{{Database}}

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

Field Type Unsigned Autoinc Null Key Default Value Description
id bigint(20) Symbol OK.png Symbol OK.png 0
credits int(11) Symbol OK.png 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)