Difference between revisions of "Badge categories (Database Table)"

Table Structure Field Type Unsigned Autoinc Null Key Default Value Description Id int(11) NO Primary 0 ID name char(255) YES Unique NULL Badge Category Name

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

--
-- Definition of table `badge_categories`
--

DROP TABLE IF EXISTS `badge_categories`;
CREATE TABLE `badge_categories` (
  `Id` int(11) unsigned NOT NULL default '0',
  `name` char(255) default NULL,
  PRIMARY KEY  (`Id`),
  UNIQUE KEY `pk_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=REDUNDANT;

Table Describe

mysql> describe badge_categories;
+-------+------------------+------+-----+---------+-------+
| Field | Type             | Null | Key | Default | Extra |
+-------+------------------+------+-----+---------+-------+
| Id    | int(11) unsigned | NO   | PRI | 0       |       |
| name  | char(255)        | YES  | UNI | NULL    |       |
+-------+------------------+------+-----+---------+-------+
2 rows in set (0.10 sec)