diff options
| author | Shocker <none@none> | 2010-09-27 00:38:22 +0300 |
|---|---|---|
| committer | Shocker <none@none> | 2010-09-27 00:38:22 +0300 |
| commit | 894b2081b3837575bd44c71ea4ebc76008b5b5e3 (patch) | |
| tree | 0b951c49e703ad70fbfb003df13674eb543aa972 /sql/base | |
| parent | 75f5e9756ea6f59dac820c50274a955dc69fca01 (diff) | |
Core/DB: Adjust max values for some columns in character_queststatus
--HG--
branch : trunk
Diffstat (limited to 'sql/base')
| -rw-r--r-- | sql/base/characters_database.sql | 28 |
1 files changed, 14 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 */; |