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

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)