From d45852e338f53be6d7ba0632c7dcc1dacfc7089e Mon Sep 17 00:00:00 2001 From: maanuel Date: Tue, 22 Dec 2009 12:46:30 -0300 Subject: Corrected sql name, sorry my typo. --HG-- branch : trunk --- sql/updates/6686_world_creature_template.sql | 1 - sql/updates/6686_world_scriptname.sql | 1 + 2 files changed, 1 insertion(+), 1 deletion(-) delete mode 100644 sql/updates/6686_world_creature_template.sql create mode 100644 sql/updates/6686_world_scriptname.sql (limited to 'sql') diff --git a/sql/updates/6686_world_creature_template.sql b/sql/updates/6686_world_creature_template.sql deleted file mode 100644 index 7315d1e47b3..00000000000 --- a/sql/updates/6686_world_creature_template.sql +++ /dev/null @@ -1 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_released_offspring_harkoa' WHERE `entry`=28526; diff --git a/sql/updates/6686_world_scriptname.sql b/sql/updates/6686_world_scriptname.sql new file mode 100644 index 00000000000..7315d1e47b3 --- /dev/null +++ b/sql/updates/6686_world_scriptname.sql @@ -0,0 +1 @@ +UPDATE `creature_template` SET `ScriptName`='npc_released_offspring_harkoa' WHERE `entry`=28526; -- cgit v1.2.3 From ce3073111e4365b7502efc4443038a437419e239 Mon Sep 17 00:00:00 2001 From: maanuel Date: Tue, 22 Dec 2009 15:03:33 -0300 Subject: Fixed realmd.sql, remove assigning the gmlevel when gmlevel isn't in account anymore by Sundark and zero389. --HG-- branch : trunk --- sql/realmd.sql | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) (limited to 'sql') diff --git a/sql/realmd.sql b/sql/realmd.sql index af983e72d30..0e782eda71d 100644 --- a/sql/realmd.sql +++ b/sql/realmd.sql @@ -58,8 +58,7 @@ CREATE TABLE `account` ( `mutetime` bigint(40) unsigned NOT NULL default '0', `locale` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`id`), - UNIQUE KEY `idx_username` (`username`), - KEY `idx_gmlevel` (`gmlevel`) + UNIQUE KEY `idx_username` (`username`) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci ROW_FORMAT=DYNAMIC COMMENT='Account System'; -- -- cgit v1.2.3