Badge categories (Database Table)

From SWGANH Wiki
Revision as of 11:41, 6 June 2007 by Snow (Talk | contribs) (New page: {{PageHeader|Database Table|badge_categories}} {| border="0" width="90%" cellpadding=6 |- |valign=top| ==Table Structure== {| align="center" |- || {| class = "wikitable" |- align="cente...)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Database Table - badge_categories

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)