Difference between revisions of "Attacks (Database Table)"

From SWGANH Wiki
Jump to: navigation, search
(New page: {{PageHeader|Database Table|Accounts}} ==Table Structure== {| align="center" |- || {| class = "wikitable" |- align="center" ||'''Field'''||'''Type'''||'''Unsigned'''||'''Autoinc'''||'''Nu...)
 
(Table Structure)
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
{{PageHeader|Database Table|Accounts}}
 
{{PageHeader|Database Table|Accounts}}
 +
 +
{| border="0" width="90%" cellpadding=6
 +
|-
 +
|valign=top|
  
 
==Table Structure==
 
==Table Structure==
Line 6: Line 10:
 
||
 
||
 
{| class = "wikitable"
 
{| class = "wikitable"
|- align="center"
+
|- align="center" style="background-color:#ffffcc;"
 
||'''Field'''||'''Type'''||'''Unsigned'''||'''Autoinc'''||'''Null'''||'''Key'''||'''Default Value'''||'''Description'''
 
||'''Field'''||'''Type'''||'''Unsigned'''||'''Autoinc'''||'''Null'''||'''Key'''||'''Default Value'''||'''Description'''
 +
|- align="center"
 +
|align="left"|id||int(10)||align="center"|[[Image:Symbol OK.png|10px]]||align="center"|[[Image:Symbol OK.png|10px]]||NO||Primary||Null||Attack ID
 +
|- align="center" style="background-color:#F1F1F1;"
 +
||attackname||char(32)||align="center"| ||align="center"| ||NO|| || ||Attack Name
 
|-
 
|-
||id||int(10)||align="center"|[[Image:Symbol OK.png|10px]]||align="center"|[[Image:Symbol OK.png|10px]]||NO||Primary||Null||Account ID
+
|}
 +
|}
 +
 
 +
|valign=top|
 +
 
 +
== Related Tags ==
 +
{|align="center"
 
|-
 
|-
||attackname||char(32)||align="center"| ||align="center"| ||NO|| || ||Attack Name
+
||{{D75%}}
 +
|-
 +
||{{Database}}
 +
|-
 +
||{{DatabaseTable}}
 
|-
 
|-
 
|}
 
|}

Latest revision as of 00:54, 6 June 2007

Database Table - Accounts

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 int(10) Symbol OK.png Symbol OK.png NO Primary Null Attack ID
attackname char(32) NO Attack Name

Related Tags

75% This document is nearing completion.

Database This document relates to the SWGANH Database Schema.

DB Table This document relates to the SWGANH Database Schema.

Table Create Script

--
-- Definition of table `attacks`
--

DROP TABLE IF EXISTS `attacks`;
CREATE TABLE `attacks` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `attackname` char(32) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Table Describe

mysql> desc attacks;
+------------+------------------+------+-----+---------+----------------+
| Field      | Type             | Null | Key | Default | Extra          |
+------------+------------------+------+-----+---------+----------------+
| id         | int(10) unsigned | NO   | PRI | NULL    | auto_increment | 
| attackname | char(32)         | YES  |     | NULL    |                | 
+------------+------------------+------+-----+---------+----------------+
2 rows in set (0.00 sec)