Badge categories (Database Table)

From SWGANH Wiki
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(11) Symbol OK.png 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)