Badge categories (Database Table)

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(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)