From 3973d1b45444c0c8fcd7aa1e033be4329dce05ae Mon Sep 17 00:00:00 2001
From: Azazel <azazel.kon@gmail.com>
Date: Fri, 11 Mar 2011 17:18:17 +0600
Subject: CharDB Schema/Cleanup: cleanup channels table: * rename columns
 (remove m_ prefix and convert to lowerCamel case); * rename prepared
 statements to conform to standards (there is no CLEAN statement).

---
 sql/base/characters_database.sql                         | 16 ++++++++--------
 .../auth_char/2011_03_11_0_characters_channels.sql       |  7 +++++++
 2 files changed, 15 insertions(+), 8 deletions(-)
 create mode 100644 sql/updates/auth_char/2011_03_11_0_characters_channels.sql

(limited to 'sql')

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 */;
 
diff --git a/sql/updates/auth_char/2011_03_11_0_characters_channels.sql b/sql/updates/auth_char/2011_03_11_0_characters_channels.sql
new file mode 100644
index 00000000000..8c399617998
--- /dev/null
+++ b/sql/updates/auth_char/2011_03_11_0_characters_channels.sql
@@ -0,0 +1,7 @@
+ALTER TABLE `channels` CHANGE COLUMN `m_name` `name` varchar(128) NOT NULL,
+  CHANGE COLUMN `m_team` `team` int(10) unsigned NOT NULL,
+  CHANGE COLUMN `m_announce` `announce` tinyint(3) unsigned NOT NULL DEFAULT '1',
+  CHANGE COLUMN `m_ownership` `ownership` tinyint(3) unsigned NOT NULL DEFAULT '1',
+  CHANGE COLUMN `m_password` `password` varchar(32) DEFAULT NULL,
+  CHANGE COLUMN `BannedList` `bannedList` text,
+  CHANGE COLUMN `last_used` `lastUsed` int(10) unsigned NOT NULL;
-- 
cgit v1.2.3