From 21a4f8e0883c8d92bdacdb81296d2ff8f4e6d9d1 Mon Sep 17 00:00:00 2001 From: Nay Date: Mon, 10 Sep 2012 11:56:37 +0100 Subject: Rename SQL and update characters_database.sql --- sql/base/characters_database.sql | 36 ++++++++++++++----- .../2012_09_08_00_characters_guild_finder_434.sql | 40 ---------------------- .../2012_09_10_00_characters_guild_finder_434.sql | 40 ++++++++++++++++++++++ 3 files changed, 67 insertions(+), 49 deletions(-) delete mode 100644 sql/updates/characters/2012_09_08_00_characters_guild_finder_434.sql create mode 100644 sql/updates/characters/2012_09_10_00_characters_guild_finder_434.sql diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 115047173ae..e3f8596c7d6 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -1851,9 +1851,9 @@ LOCK TABLES `guild_eventlog` WRITE; /*!40000 ALTER TABLE `guild_eventlog` ENABLE KEYS */; UNLOCK TABLES; ---- ---- Table structure for table `guild_finder_applicant` ---- +-- +-- Table structure for table `guild_finder_applicant` +-- DROP TABLE IF EXISTS `guild_finder_applicant`; /*!40101 SET @saved_cs_client = @@character_set_client */; @@ -1867,12 +1867,21 @@ CREATE TABLE `guild_finder_applicant` ( `comment` varchar(255) DEFAULT NULL, `submitTime` int(10) unsigned DEFAULT NULL, UNIQUE KEY `guildId` (`guildId`,`playerGuid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT="Guild finder membership requests"; +) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; ---- ---- Table structure for table `guild_finder_guild_settings` ---- +-- +-- Dumping data for table `guild_finder_applicant` +-- + +LOCK TABLES `guild_finder_applicant` WRITE; +/*!40000 ALTER TABLE `guild_finder_applicant` DISABLE KEYS */; +/*!40000 ALTER TABLE `guild_finder_applicant` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `guild_finder_guild_settings` +-- DROP TABLE IF EXISTS `guild_finder_guild_settings`; /*!40101 SET @saved_cs_client = @@character_set_client */; @@ -1886,9 +1895,18 @@ CREATE TABLE `guild_finder_guild_settings` ( `listed` tinyint(3) unsigned NOT NULL DEFAULT '0', `comment` varchar(255) DEFAULT NULL, PRIMARY KEY (`guildId`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT="Guild finder guild-releated settings storage"; +) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; +-- +-- Dumping data for table `guild_finder_guild_settings` +-- + +LOCK TABLES `guild_finder_guild_settings` WRITE; +/*!40000 ALTER TABLE `guild_finder_guild_settings` DISABLE KEYS */; +/*!40000 ALTER TABLE `guild_finder_guild_settings` ENABLE KEYS */; +UNLOCK TABLES; + -- -- Table structure for table `guild_member` -- @@ -2485,4 +2503,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2012-09-10 0:40:44 +-- Dump completed on 2012-09-10 11:54:51 diff --git a/sql/updates/characters/2012_09_08_00_characters_guild_finder_434.sql b/sql/updates/characters/2012_09_08_00_characters_guild_finder_434.sql deleted file mode 100644 index d4d524e0bef..00000000000 --- a/sql/updates/characters/2012_09_08_00_characters_guild_finder_434.sql +++ /dev/null @@ -1,40 +0,0 @@ -/*!40101 SET NAMES utf8 */; - -/*!40101 SET SQL_MODE=''*/; - -/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; -/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; -/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -/* Table structure for table `guild_finder_applicant` */ - -DROP TABLE IF EXISTS `guild_finder_applicant`; - -CREATE TABLE `guild_finder_applicant` ( - `guildId` int(10) unsigned DEFAULT NULL, - `playerGuid` int(10) unsigned DEFAULT NULL, - `availability` tinyint(3) unsigned DEFAULT '0', - `classRole` tinyint(3) unsigned DEFAULT '0', - `interests` tinyint(3) unsigned DEFAULT '0', - `comment` varchar(255) DEFAULT NULL, - `submitTime` int(10) unsigned DEFAULT NULL, - UNIQUE KEY `guildId` (`guildId`,`playerGuid`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; - -/* Table structure for table `guild_finder_guild_settings` */ - -DROP TABLE IF EXISTS `guild_finder_guild_settings`; - -CREATE TABLE `guild_finder_guild_settings` ( - `guildId` int(10) unsigned NOT NULL, - `availability` tinyint(3) unsigned NOT NULL DEFAULT '0', - `classRoles` tinyint(3) unsigned NOT NULL DEFAULT '0', - `interests` tinyint(3) unsigned NOT NULL DEFAULT '0', - `level` tinyint(3) unsigned NOT NULL DEFAULT '1', - `listed` tinyint(3) unsigned NOT NULL DEFAULT '0', - `comment` varchar(255) DEFAULT NULL, - PRIMARY KEY (`guildId`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; - -/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; -/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; -/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; diff --git a/sql/updates/characters/2012_09_10_00_characters_guild_finder_434.sql b/sql/updates/characters/2012_09_10_00_characters_guild_finder_434.sql new file mode 100644 index 00000000000..d4d524e0bef --- /dev/null +++ b/sql/updates/characters/2012_09_10_00_characters_guild_finder_434.sql @@ -0,0 +1,40 @@ +/*!40101 SET NAMES utf8 */; + +/*!40101 SET SQL_MODE=''*/; + +/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; +/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; +/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; +/* Table structure for table `guild_finder_applicant` */ + +DROP TABLE IF EXISTS `guild_finder_applicant`; + +CREATE TABLE `guild_finder_applicant` ( + `guildId` int(10) unsigned DEFAULT NULL, + `playerGuid` int(10) unsigned DEFAULT NULL, + `availability` tinyint(3) unsigned DEFAULT '0', + `classRole` tinyint(3) unsigned DEFAULT '0', + `interests` tinyint(3) unsigned DEFAULT '0', + `comment` varchar(255) DEFAULT NULL, + `submitTime` int(10) unsigned DEFAULT NULL, + UNIQUE KEY `guildId` (`guildId`,`playerGuid`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +/* Table structure for table `guild_finder_guild_settings` */ + +DROP TABLE IF EXISTS `guild_finder_guild_settings`; + +CREATE TABLE `guild_finder_guild_settings` ( + `guildId` int(10) unsigned NOT NULL, + `availability` tinyint(3) unsigned NOT NULL DEFAULT '0', + `classRoles` tinyint(3) unsigned NOT NULL DEFAULT '0', + `interests` tinyint(3) unsigned NOT NULL DEFAULT '0', + `level` tinyint(3) unsigned NOT NULL DEFAULT '1', + `listed` tinyint(3) unsigned NOT NULL DEFAULT '0', + `comment` varchar(255) DEFAULT NULL, + PRIMARY KEY (`guildId`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; +/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; +/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- cgit v1.2.3