Difference between revisions of "Badge categories (Database Table)"
From SWGANH Wiki
(→Table Structure) |
|||
| Line 13: | Line 13: | ||
||'''Field'''||'''Type'''||'''Unsigned'''||'''Autoinc'''||'''Null'''||'''Key'''||'''Default Value'''||'''Description''' | ||'''Field'''||'''Type'''||'''Unsigned'''||'''Autoinc'''||'''Null'''||'''Key'''||'''Default Value'''||'''Description''' | ||
|- align="center" | |- align="center" | ||
| − | |align="left"| || ||align="center"|[[Image:Symbol OK.png|10px]]||align="center"| | + | |align="left"|Id||int(11)||align="center"|[[Image:Symbol OK.png|10px]]||align="center"| ||NO||Primary||0||ID |
|- align="center" style="background-color:#F1F1F1;" | |- align="center" style="background-color:#F1F1F1;" | ||
| − | || || ||align="center"| ||align="center"| || || || || | + | |align="left"|name||char(255)||align="center"| ||align="center"| ||YES||Unique||NULL||Badge Category Name |
|- | |- | ||
|} | |} | ||
| Line 25: | Line 25: | ||
{|align="center" | {|align="center" | ||
|- | |- | ||
| − | ||{{ | + | ||{{D100%}} |
|- | |- | ||
||{{Database}} | ||{{Database}} | ||
| Line 37: | Line 37: | ||
<pre> | <pre> | ||
-- | -- | ||
| − | -- Definition of table ` | + | -- Definition of table `badge_categories` |
-- | -- | ||
| − | DROP TABLE IF EXISTS ` | + | DROP TABLE IF EXISTS `badge_categories`; |
| − | CREATE TABLE ` | + | CREATE TABLE `badge_categories` ( |
| − | ` | + | `Id` int(11) unsigned NOT NULL default '0', |
| − | ` | + | `name` char(255) default NULL, |
| − | PRIMARY KEY (` | + | PRIMARY KEY (`Id`), |
| − | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | + | UNIQUE KEY `pk_name` (`name`) |
| + | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=REDUNDANT; | ||
</pre> | </pre> | ||
==Table Describe== | ==Table Describe== | ||
<pre> | <pre> | ||
| − | mysql> | + | mysql> describe badge_categories; |
| − | + | + | +-------+------------------+------+-----+---------+-------+ |
| − | | Field | + | | Field | Type | Null | Key | Default | Extra | |
| − | + | + | +-------+------------------+------+-----+---------+-------+ |
| − | | | + | | Id | int(11) unsigned | NO | PRI | 0 | | |
| − | | | + | | name | char(255) | YES | UNI | NULL | | |
| − | + | + | +-------+------------------+------+-----+---------+-------+ |
| − | 2 rows in set (0. | + | 2 rows in set (0.10 sec) |
</pre> | </pre> | ||
Latest revision as of 23:54, 12 March 2010
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
|
Related Tags
|
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)
