diff options
| author | runningnak3d <none@none> | 2008-12-23 10:14:58 +0000 |
|---|---|---|
| committer | runningnak3d <none@none> | 2008-12-23 10:14:58 +0000 |
| commit | c30c87a69067bcd6e0650337bacec5f82b7a5191 (patch) | |
| tree | 8efcbc730a960aebf4612782b8f7d1060c05659d | |
| parent | 30ff870a4e9ad3051a713b46a9b8c67a710a18e4 (diff) | |
* Last of the SQL clean up (for now -- until someone commits some crap again
* :P )
--HG--
branch : trunk
| -rw-r--r-- | sql/updates/262_characters.sql | 2 | ||||
| -rw-r--r-- | sql/updates/262_realmd.sql | 2 | ||||
| -rw-r--r-- | sql/updates/410_characters.sql | 2 | ||||
| -rw-r--r-- | sql/updates/541_characters.sql | 2 | ||||
| -rw-r--r-- | sql/updates/542_characters.sql | 2 | ||||
| -rw-r--r-- | sql/updates/559_characters.sql | 2 |
6 files changed, 6 insertions, 6 deletions
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'; |