diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/characters_database.sql | 28 | ||||
| -rw-r--r-- | sql/updates/10084_characters_character_queststatus.sql | 9 |
2 files changed, 23 insertions, 14 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index acccb19513a..cd460411e9e 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -855,20 +855,20 @@ DROP TABLE IF EXISTS `character_queststatus`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `character_queststatus` ( - `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier', - `quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier', - `status` int(11) unsigned NOT NULL default '0', - `rewarded` tinyint(1) unsigned NOT NULL default '0', - `explored` tinyint(1) unsigned NOT NULL default '0', - `timer` bigint(20) unsigned NOT NULL default '0', - `mobcount1` int(11) unsigned NOT NULL default '0', - `mobcount2` int(11) unsigned NOT NULL default '0', - `mobcount3` int(11) unsigned NOT NULL default '0', - `mobcount4` int(11) unsigned NOT NULL default '0', - `itemcount1` int(11) unsigned NOT NULL default '0', - `itemcount2` int(11) unsigned NOT NULL default '0', - `itemcount3` int(11) unsigned NOT NULL default '0', - `itemcount4` int(11) unsigned NOT NULL default '0', + `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier', + `quest` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', + `status` tinyint(1) unsigned NOT NULL DEFAULT '0', + `rewarded` tinyint(1) unsigned NOT NULL DEFAULT '0', + `explored` tinyint(1) unsigned NOT NULL DEFAULT '0', + `timer` bigint(20) unsigned NOT NULL DEFAULT '0', + `mobcount1` smallint(3) unsigned NOT NULL DEFAULT '0', + `mobcount2` smallint(3) unsigned NOT NULL DEFAULT '0', + `mobcount3` smallint(3) unsigned NOT NULL DEFAULT '0', + `mobcount4` smallint(3) unsigned NOT NULL DEFAULT '0', + `itemcount1` smallint(3) unsigned NOT NULL DEFAULT '0', + `itemcount2` smallint(3) unsigned NOT NULL DEFAULT '0', + `itemcount3` smallint(3) unsigned NOT NULL DEFAULT '0', + `itemcount4` smallint(3) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`quest`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; diff --git a/sql/updates/10084_characters_character_queststatus.sql b/sql/updates/10084_characters_character_queststatus.sql new file mode 100644 index 00000000000..9b541553eb2 --- /dev/null +++ b/sql/updates/10084_characters_character_queststatus.sql @@ -0,0 +1,9 @@ +ALTER TABLE `character_queststatus` CHANGE `status` `status` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT 0, +CHANGE `mobcount1` `mobcount1` SMALLINT( 3 ) UNSIGNED NOT NULL DEFAULT 0, +CHANGE `mobcount2` `mobcount2` SMALLINT( 3 ) UNSIGNED NOT NULL DEFAULT 0, +CHANGE `mobcount3` `mobcount3` SMALLINT( 3 ) UNSIGNED NOT NULL DEFAULT 0, +CHANGE `mobcount4` `mobcount4` SMALLINT( 3 ) UNSIGNED NOT NULL DEFAULT 0, +CHANGE `itemcount1` `itemcount1` SMALLINT( 3 ) UNSIGNED NOT NULL DEFAULT 0, +CHANGE `itemcount2` `itemcount2` SMALLINT( 3 ) UNSIGNED NOT NULL DEFAULT 0, +CHANGE `itemcount3` `itemcount3` SMALLINT( 3 ) UNSIGNED NOT NULL DEFAULT 0, +CHANGE `itemcount4` `itemcount4` SMALLINT( 3 ) UNSIGNED NOT NULL DEFAULT 0; |