From cd25b30aa3ec032a907471cf424ed5a511f4179b Mon Sep 17 00:00:00 2001 From: joschiwald Date: Mon, 6 Nov 2017 20:26:21 +0100 Subject: Rename 9999_99_99_99_hotfixes.sql to 2017_11_05_00_hotfixes.sql --- .../hotfixes/master/2017_11_05_00_hotfixes.sql | 28 ++++++++++++++++++++++ .../hotfixes/master/9999_99_99_99_hotfixes.sql | 28 ---------------------- 2 files changed, 28 insertions(+), 28 deletions(-) create mode 100644 sql/updates/hotfixes/master/2017_11_05_00_hotfixes.sql delete mode 100644 sql/updates/hotfixes/master/9999_99_99_99_hotfixes.sql (limited to 'sql') diff --git a/sql/updates/hotfixes/master/2017_11_05_00_hotfixes.sql b/sql/updates/hotfixes/master/2017_11_05_00_hotfixes.sql new file mode 100644 index 00000000000..6654e5d42dd --- /dev/null +++ b/sql/updates/hotfixes/master/2017_11_05_00_hotfixes.sql @@ -0,0 +1,28 @@ +-- +-- Table structure for table `world_effect` +-- + +DROP TABLE IF EXISTS `world_effect`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `world_effect` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `TargetAsset` int(10) unsigned NOT NULL DEFAULT '0', + `CombatConditionID` smallint(5) unsigned NOT NULL DEFAULT '0', + `TargetType` tinyint(3) unsigned NOT NULL DEFAULT '0', + `WhenToDisplay` tinyint(3) unsigned NOT NULL DEFAULT '0', + `QuestFeedbackEffectID` int(10) unsigned NOT NULL DEFAULT '0', + `PlayerConditionID` int(10) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `world_effect` +-- + +LOCK TABLES `world_effect` WRITE; +/*!40000 ALTER TABLE `world_effect` DISABLE KEYS */; +/*!40000 ALTER TABLE `world_effect` ENABLE KEYS */; +UNLOCK TABLES; diff --git a/sql/updates/hotfixes/master/9999_99_99_99_hotfixes.sql b/sql/updates/hotfixes/master/9999_99_99_99_hotfixes.sql deleted file mode 100644 index 6654e5d42dd..00000000000 --- a/sql/updates/hotfixes/master/9999_99_99_99_hotfixes.sql +++ /dev/null @@ -1,28 +0,0 @@ --- --- Table structure for table `world_effect` --- - -DROP TABLE IF EXISTS `world_effect`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `world_effect` ( - `ID` int(10) unsigned NOT NULL DEFAULT '0', - `TargetAsset` int(10) unsigned NOT NULL DEFAULT '0', - `CombatConditionID` smallint(5) unsigned NOT NULL DEFAULT '0', - `TargetType` tinyint(3) unsigned NOT NULL DEFAULT '0', - `WhenToDisplay` tinyint(3) unsigned NOT NULL DEFAULT '0', - `QuestFeedbackEffectID` int(10) unsigned NOT NULL DEFAULT '0', - `PlayerConditionID` int(10) unsigned NOT NULL DEFAULT '0', - `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', - PRIMARY KEY (`ID`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - --- --- Dumping data for table `world_effect` --- - -LOCK TABLES `world_effect` WRITE; -/*!40000 ALTER TABLE `world_effect` DISABLE KEYS */; -/*!40000 ALTER TABLE `world_effect` ENABLE KEYS */; -UNLOCK TABLES; -- cgit v1.2.3