aboutsummaryrefslogtreecommitdiff
path: root/sql/base
diff options
context:
space:
mode:
Diffstat (limited to 'sql/base')
-rw-r--r--sql/base/characters_database.sql16
1 files changed, 8 insertions, 8 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 9f7766dac4c..2640c894443 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -267,14 +267,14 @@ DROP TABLE IF EXISTS `channels`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `channels` (
- `m_name` varchar(128) NOT NULL,
- `m_team` int(10) unsigned NOT NULL,
- `m_announce` tinyint(3) unsigned NOT NULL DEFAULT '1',
- `m_ownership` tinyint(3) unsigned NOT NULL DEFAULT '1',
- `m_password` varchar(32) DEFAULT NULL,
- `BannedList` text,
- `last_used` int(10) unsigned NOT NULL,
- PRIMARY KEY (`m_name`,`m_team`)
+ `name` varchar(128) NOT NULL,
+ `team` int(10) unsigned NOT NULL,
+ `announce` tinyint(3) unsigned NOT NULL DEFAULT '1',
+ `ownership` tinyint(3) unsigned NOT NULL DEFAULT '1',
+ `password` varchar(32) DEFAULT NULL,
+ `bannedList` text,
+ `lastUsed` int(10) unsigned NOT NULL,
+ PRIMARY KEY (`name`,`team`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Channel System';
/*!40101 SET character_set_client = @saved_cs_client */;