diff options
| author | megamage <none@none> | 2009-02-20 15:18:23 -0600 |
|---|---|---|
| committer | megamage <none@none> | 2009-02-20 15:18:23 -0600 |
| commit | 01bd4a8121b9ef95bdad313e9dc754eda04b65b1 (patch) | |
| tree | 16a7bc1738c9447dca2fc7bfb42429534e49a4cf | |
| parent | 0250f9bf49aee02296e64de302db7615922d98e0 (diff) | |
[7307] Add primary key for table `arena_team_member`. Author: VladimirMangos
--HG--
branch : trunk
| -rw-r--r-- | sql/characters.sql | 5 | ||||
| -rw-r--r-- | sql/updates/7307_01_characters_arena_team_member.sql | 4 | ||||
| -rw-r--r-- | src/shared/revision_nr.h | 2 |
3 files changed, 8 insertions, 3 deletions
diff --git a/sql/characters.sql b/sql/characters.sql index 8433c343233..4149459543a 100644 --- a/sql/characters.sql +++ b/sql/characters.sql @@ -21,7 +21,7 @@ DROP TABLE IF EXISTS `character_db_version`; CREATE TABLE `character_db_version` ( - `required_7267_01_characters_auctionhouse` bit(1) default NULL + `required_7307_01_characters_arena_team_member` bit(1) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Last applied sql update to DB'; -- @@ -96,7 +96,8 @@ CREATE TABLE `arena_team_member` ( `wons_week` int(10) unsigned NOT NULL default '0', `played_season` int(10) unsigned NOT NULL default '0', `wons_season` int(10) unsigned NOT NULL default '0', - `personal_rating` int(10) UNSIGNED NOT NULL DEFAULT '0' + `personal_rating` int(10) UNSIGNED NOT NULL DEFAULT '0', + PRIMARY KEY (`arenateamid`,`guid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- diff --git a/sql/updates/7307_01_characters_arena_team_member.sql b/sql/updates/7307_01_characters_arena_team_member.sql new file mode 100644 index 00000000000..b18006f8f0e --- /dev/null +++ b/sql/updates/7307_01_characters_arena_team_member.sql @@ -0,0 +1,4 @@ +ALTER TABLE character_db_version CHANGE COLUMN required_7267_01_characters_auctionhouse required_7307_01_characters_arena_team_member bit; + +ALTER TABLE arena_team_member + ADD PRIMARY KEY (arenateamid,guid); diff --git a/src/shared/revision_nr.h b/src/shared/revision_nr.h index 64aedd277f4..d70d1b4a5df 100644 --- a/src/shared/revision_nr.h +++ b/src/shared/revision_nr.h @@ -1,4 +1,4 @@ #ifndef __REVISION_NR_H__ #define __REVISION_NR_H__ - #define REVISION_NR "7306" + #define REVISION_NR "7307" #endif // __REVISION_NR_H__ |