diff options
| author | Shauren <shauren.trinity@gmail.com> | 2021-05-11 15:47:58 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2021-05-11 15:47:58 +0200 |
| commit | d9d242bea4e9fd000098d24a5a5c5d11ea4725e4 (patch) | |
| tree | a89103ff8849f2fd42c438a7338ee64c1bf5d874 /sql/base | |
| parent | 2ffedf30a9f177ba848bb74c1b41375ac6d734a9 (diff) | |
Core/Quests: Set quest accept time updatefield
Diffstat (limited to 'sql/base')
| -rw-r--r-- | sql/base/characters_database.sql | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 1da375e450c..280477bb168 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -1251,7 +1251,8 @@ CREATE TABLE `character_queststatus` ( `quest` int(10) unsigned NOT NULL DEFAULT '0', `status` tinyint(3) unsigned NOT NULL DEFAULT '0', `explored` tinyint(3) unsigned NOT NULL DEFAULT '0', - `timer` bigint(20) NOT NULL DEFAULT '0', + `acceptTime` bigint(20) NOT NULL DEFAULT '0', + `endTime` bigint(20) NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`quest`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -3854,7 +3855,8 @@ INSERT INTO `updates` VALUES ('2020_12_13_00_characters.sql','6AC743240033DED2C402ECB894A59D79EF607920','RELEASED','2020-12-13 18:36:58',0), ('2021_03_27_00_characters_aura_stored_location.sql','BF772ABC2DF186AF0A5DC56D5E824A2F4813BA69','RELEASED','2021-03-27 15:53:04',0), ('2021_04_05_00_characters.sql','33D656995E0F3578FFE1A658ED1692CA5310AB30','RELEASED','2021-04-05 23:44:54',0), -('2021_05_10_00_characters.sql','0A406242BC18BDA5A65CDE3E2AFEE760D79F819F','RELEASED','2021-05-10 23:30:34',0); +('2021_05_10_00_characters.sql','0A406242BC18BDA5A65CDE3E2AFEE760D79F819F','RELEASED','2021-05-10 23:30:34',0), +('2021_05_11_00_characters.sql','C3F0337CE8363F970AB4FDB9D23BBB7C650A0B0E','RELEASED','2021-05-11 15:39:26',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; |