Difference between revisions of "Attacks (Database Table)"

Table Structure Field Type Unsigned Autoinc Null Key Default Value Description id int(10) 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)