diff options
| author | leak <leakzx@googlemail.com> | 2011-04-08 15:57:25 +0200 |
|---|---|---|
| committer | leak <leakzx@googlemail.com> | 2011-04-08 15:57:25 +0200 |
| commit | 1e94fc530b5cdf7c6e5f6a24018efec4842f72d9 (patch) | |
| tree | 505c817608d4ac7a6d56d84d273f42d9d626668e | |
| parent | 9f1cc4407a385e1ab3a835fd983e6b3d259aa47c (diff) | |
SQL/Arena: Fix some warnings with missing default values
| -rw-r--r-- | sql/base/characters_database.sql | 4 | ||||
| -rw-r--r-- | sql/updates/auth_char/2011_04_08_02_characters_arena_team.sql | 3 |
2 files changed, 5 insertions, 2 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 4de56b8fb5d..fabd0308899 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -129,12 +129,12 @@ CREATE TABLE `arena_team` ( `name` varchar(24) NOT NULL, `captainGuid` int(10) unsigned NOT NULL DEFAULT '0', `type` tinyint(3) unsigned NOT NULL DEFAULT '0', - `rating` smallint(5) unsigned NOT NULL, + `rating` smallint(5) unsigned NOT NULL DEFAULT '0', `seasonGames` smallint(5) unsigned NOT NULL DEFAULT '0', `seasonWins` smallint(5) unsigned NOT NULL DEFAULT '0', `weekGames` smallint(5) unsigned NOT NULL DEFAULT '0', `weekWins` smallint(5) unsigned NOT NULL DEFAULT '0', - `rank` int(10) unsigned NOT NULL, + `rank` int(10) unsigned NOT NULL DEFAULT '0', `backgroundColor` int(10) unsigned NOT NULL DEFAULT '0', `emblemStyle` tinyint(3) unsigned NOT NULL DEFAULT '0', `emblemColor` int(10) unsigned NOT NULL DEFAULT '0', diff --git a/sql/updates/auth_char/2011_04_08_02_characters_arena_team.sql b/sql/updates/auth_char/2011_04_08_02_characters_arena_team.sql new file mode 100644 index 00000000000..62b51ef1529 --- /dev/null +++ b/sql/updates/auth_char/2011_04_08_02_characters_arena_team.sql @@ -0,0 +1,3 @@ +ALTER TABLE `arena_team` +CHANGE `rating` `rating` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0', +CHANGE `rank` `rank` INT(10) UNSIGNED NOT NULL DEFAULT '0'; |