From: <ma...@us...> - 2013-02-27 19:07:06
|
Revision: 8617 http://planeshift.svn.sourceforge.net/planeshift/?rev=8617&view=rev Author: magodra Date: 2013-02-27 19:06:58 +0000 (Wed, 27 Feb 2013) Log Message: ----------- - Updated DB tables that didn't have drop. (PS#5913) Modified Paths: -------------- trunk/src/server/database/mysql/character_factions.sql trunk/src/server/database/mysql/character_variables.sql trunk/src/server/database/mysql/item_stats.sql trunk/src/server/database/mysql/loot_modifiers_restrains.sql trunk/src/server/database/mysql/quest_scripts.sql trunk/src/server/database/mysql/quests.sql Modified: trunk/src/server/database/mysql/character_factions.sql =================================================================== --- trunk/src/server/database/mysql/character_factions.sql 2013-02-27 18:42:39 UTC (rev 8616) +++ trunk/src/server/database/mysql/character_factions.sql 2013-02-27 19:06:58 UTC (rev 8617) @@ -1,5 +1,5 @@ - -CREATE TABLE IF NOT EXISTS `character_factions` ( +DROP TABLE IF EXISTS `character_factions`; +CREATE TABLE `character_factions` ( `character_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The PID of the character this faction is assigned to', `faction_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The id of the faction the points are for', `value` int(10) NOT NULL DEFAULT '0' COMMENT 'The amount of points in this faction', Modified: trunk/src/server/database/mysql/character_variables.sql =================================================================== --- trunk/src/server/database/mysql/character_variables.sql 2013-02-27 18:42:39 UTC (rev 8616) +++ trunk/src/server/database/mysql/character_variables.sql 2013-02-27 19:06:58 UTC (rev 8617) @@ -1,4 +1,5 @@ -CREATE TABLE IF NOT EXISTS `character_variables` ( +DROP TABLE IF EXISTS `character_variables`; +CREATE TABLE `character_variables` ( `character_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The character this variable is assigned to', `name` varchar(255) NOT NULL COMMENT 'The name of the variable', `value` varchar(255) NOT NULL COMMENT 'The value of the variable', Modified: trunk/src/server/database/mysql/item_stats.sql =================================================================== --- trunk/src/server/database/mysql/item_stats.sql 2013-02-27 18:42:39 UTC (rev 8616) +++ trunk/src/server/database/mysql/item_stats.sql 2013-02-27 19:06:58 UTC (rev 8617) @@ -19,9 +19,9 @@ -- Table structure for table `item_stats` -- -DROP TABLE IF EXISTS `item_stats`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; +DROP TABLE IF EXISTS `item_stats`; CREATE TABLE `item_stats` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `stat_type` char(1) NOT NULL DEFAULT 'B', Modified: trunk/src/server/database/mysql/loot_modifiers_restrains.sql =================================================================== --- trunk/src/server/database/mysql/loot_modifiers_restrains.sql 2013-02-27 18:42:39 UTC (rev 8616) +++ trunk/src/server/database/mysql/loot_modifiers_restrains.sql 2013-02-27 19:06:58 UTC (rev 8617) @@ -2,6 +2,7 @@ # Table structure for table loot_modifiers_restrains # +DROP TABLE IF EXISTS `loot_modifiers_restrains`; CREATE TABLE `planeshift`.`loot_modifiers_restrains` ( `loot_modifier_id` INTEGER NOT NULL COMMENT 'The id of the loot modifier rule', `item_id` INTEGER NOT NULL COMMENT 'The id of the item included in the loot modifier rule', Modified: trunk/src/server/database/mysql/quest_scripts.sql =================================================================== --- trunk/src/server/database/mysql/quest_scripts.sql 2013-02-27 18:42:39 UTC (rev 8616) +++ trunk/src/server/database/mysql/quest_scripts.sql 2013-02-27 19:06:58 UTC (rev 8617) @@ -14,12 +14,12 @@ /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0*/; -DROP TABLE IF EXISTS `quest_scripts`; # # Table structure for table 'quest_scripts' # +DROP TABLE IF EXISTS `quest_scripts`; CREATE TABLE `quest_scripts` ( `id` int(10) unsigned NOT NULL auto_increment, `quest_id` int(10) NOT NULL default '0' COMMENT 'FK to quests table, or -1 for KA scripts.', Modified: trunk/src/server/database/mysql/quests.sql =================================================================== --- trunk/src/server/database/mysql/quests.sql 2013-02-27 18:42:39 UTC (rev 8616) +++ trunk/src/server/database/mysql/quests.sql 2013-02-27 19:06:58 UTC (rev 8617) @@ -19,9 +19,9 @@ -- Table structure for table `quests` -- -DROP TABLE IF EXISTS `quests`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; +DROP TABLE IF EXISTS `quests`; CREATE TABLE `quests` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(40) NOT NULL DEFAULT '', This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |