From c30c87a69067bcd6e0650337bacec5f82b7a5191 Mon Sep 17 00:00:00 2001 From: runningnak3d Date: Tue, 23 Dec 2008 10:14:58 +0000 Subject: * Last of the SQL clean up (for now -- until someone commits some crap again * :P ) --HG-- branch : trunk --- sql/updates/262_characters.sql | 2 +- sql/updates/262_realmd.sql | 2 +- sql/updates/410_characters.sql | 2 +- sql/updates/541_characters.sql | 2 +- sql/updates/542_characters.sql | 2 +- sql/updates/559_characters.sql | 2 +- 6 files changed, 6 insertions(+), 6 deletions(-) (limited to 'sql/updates') diff --git a/sql/updates/262_characters.sql b/sql/updates/262_characters.sql index fc08d8cda85..b3caa9704f0 100644 --- a/sql/updates/262_characters.sql +++ b/sql/updates/262_characters.sql @@ -2,4 +2,4 @@ ALTER TABLE `guild_bank_tab` CHANGE COLUMN `TabText` `TabText` text; ALTER TABLE `character_aura` ADD `stackcount` INT NOT NULL DEFAULT '1' AFTER `effect_index` ; -ALTER TABLE `pet_aura` ADD `stackcount` INT NOT NULL DEFAULT '1' AFTER `effect_index` ; \ No newline at end of file +ALTER TABLE `pet_aura` ADD `stackcount` INT NOT NULL DEFAULT '1' AFTER `effect_index`; diff --git a/sql/updates/262_realmd.sql b/sql/updates/262_realmd.sql index facffa9a7d1..1953f19fe28 100644 --- a/sql/updates/262_realmd.sql +++ b/sql/updates/262_realmd.sql @@ -1,2 +1,2 @@ ALTER TABLE `account` - CHANGE COLUMN `email` `email` text; \ No newline at end of file + CHANGE COLUMN `email` `email` text; diff --git a/sql/updates/410_characters.sql b/sql/updates/410_characters.sql index 0e47f296e7e..483b991e19e 100644 --- a/sql/updates/410_characters.sql +++ b/sql/updates/410_characters.sql @@ -1,2 +1,2 @@ ALTER TABLE `guild_member` DROP INDEX `guid_key` , -ADD UNIQUE `guid_key` ( `guid` ); \ No newline at end of file +ADD UNIQUE `guid_key` ( `guid` ); diff --git a/sql/updates/541_characters.sql b/sql/updates/541_characters.sql index 7c74135157a..0cca696278b 100644 --- a/sql/updates/541_characters.sql +++ b/sql/updates/541_characters.sql @@ -10,4 +10,4 @@ ALTER TABLE arena_team_member CHANGE wins_season wons_season int(10) unsigned NO ALTER TABLE `arena_team_member` DROP COLUMN `points_to_add`; ALTER TABLE `arena_team_member` ADD COLUMN `personal_rating` int(10) UNSIGNED NOT NULL DEFAULT '0'; -ALTER TABLE `characters` ADD COLUMN `arena_pending_points` int(10) UNSIGNED NOT NULL default '0' AFTER `taxi_path`; \ No newline at end of file +ALTER TABLE `characters` ADD COLUMN `arena_pending_points` int(10) UNSIGNED NOT NULL default '0' AFTER `taxi_path`; diff --git a/sql/updates/542_characters.sql b/sql/updates/542_characters.sql index cf5e85dbd31..4cc3bebea80 100644 --- a/sql/updates/542_characters.sql +++ b/sql/updates/542_characters.sql @@ -71,4 +71,4 @@ SET `a`.`personal_rating` = `b`.`atpr` WHERE `a`.`arenateamid` = `b`.`atid` AND - `a`.`guid` = `b`.`b_guid`; \ No newline at end of file + `a`.`guid` = `b`.`b_guid`; diff --git a/sql/updates/559_characters.sql b/sql/updates/559_characters.sql index 15b99f2f4b0..4544be275b2 100644 --- a/sql/updates/559_characters.sql +++ b/sql/updates/559_characters.sql @@ -1,2 +1,2 @@ ALTER TABLE characters - CHANGE COLUMN gmstate extra_flags int(11) unsigned NOT NULL default '0'; \ No newline at end of file + CHANGE COLUMN gmstate extra_flags int(11) unsigned NOT NULL default '0'; -- cgit v1.2.3