diff options
| author | DDuarte <dnpd.dd@gmail.com> | 2014-10-19 00:23:18 +0100 |
|---|---|---|
| committer | DDuarte <dnpd.dd@gmail.com> | 2014-10-19 00:23:18 +0100 |
| commit | 98f98fa17fde4a1294b3e9227973ce5df70fbd6b (patch) | |
| tree | 911710fb74f5b3665c8c88a0608969f2d9c2fbf4 /sql/base/characters_database.sql | |
| parent | 8936723291985d1759a4903901c7a29cc54fdcbf (diff) | |
| parent | eb68b116271780f36d34e432cd6f2e9ad12d2b54 (diff) | |
Merge remote-tracking branch 'origin/4.3.4' into 6.x
Diffstat (limited to 'sql/base/characters_database.sql')
| -rw-r--r-- | sql/base/characters_database.sql | 34 |
1 files changed, 31 insertions, 3 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 4f58caf0888..100bd007b35 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 5.6.9-rc, for Win64 (x86_64) +-- MySQL dump 10.13 Distrib 5.5.40, for debian-linux-gnu (x86_64) -- -- Host: localhost Database: characters_4x -- ------------------------------------------------------ --- Server version 5.6.9-rc +-- Server version 5.5.40-0ubuntu0.14.04.1 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -2666,6 +2666,34 @@ LOCK TABLES `pvpstats_players` WRITE; UNLOCK TABLES; -- +-- Table structure for table `quest_tracker` +-- + +DROP TABLE IF EXISTS `quest_tracker`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `quest_tracker` ( + `id` mediumint(8) unsigned NOT NULL DEFAULT '0', + `character_guid` int(10) unsigned NOT NULL DEFAULT '0', + `quest_accept_time` datetime NOT NULL, + `quest_complete_time` datetime DEFAULT NULL, + `quest_abandon_time` datetime DEFAULT NULL, + `completed_by_gm` tinyint(1) NOT NULL DEFAULT '0', + `core_hash` varchar(120) NOT NULL DEFAULT '0', + `core_revision` varchar(120) NOT NULL DEFAULT '0' +) ENGINE=InnoDB DEFAULT CHARSET=latin1; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `quest_tracker` +-- + +LOCK TABLES `quest_tracker` WRITE; +/*!40000 ALTER TABLE `quest_tracker` DISABLE KEYS */; +/*!40000 ALTER TABLE `quest_tracker` ENABLE KEYS */; +UNLOCK TABLES; + +-- -- Table structure for table `reserved_name` -- @@ -2744,4 +2772,4 @@ UNLOCK TABLES; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2014-08-28 15:30:47 +-- Dump completed on 2014-10-18 18:02:06 |