From 894b2081b3837575bd44c71ea4ebc76008b5b5e3 Mon Sep 17 00:00:00 2001 From: Shocker Date: Mon, 27 Sep 2010 00:38:22 +0300 Subject: Core/DB: Adjust max values for some columns in character_queststatus --HG-- branch : trunk --- sql/base/characters_database.sql | 28 ++++++++++++++-------------- 1 file changed, 14 insertions(+), 14 deletions(-) (limited to 'sql/base') 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 */; -- cgit v1.2.3