From dedf702248c4eb9a6e9d0e3203cab19b56fa4f3f Mon Sep 17 00:00:00 2001 From: Shauren Date: Sun, 13 Nov 2016 10:22:39 +0100 Subject: SQL: Fix base/characters_database.sql --- sql/base/characters_database.sql | 25 +++++++++++++++++++++++++ 1 file changed, 25 insertions(+) (limited to 'sql/base/characters_database.sql') diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index b6c209edd06..8a78a9bdd36 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -2534,6 +2534,31 @@ INSERT INTO `instance_reset` VALUES (33,2,1426996800),(36,2,1426996800),(249,3,1 /*!40000 ALTER TABLE `instance_reset` ENABLE KEYS */; UNLOCK TABLES; +-- +-- Table structure for table `instance_scenario_progress` +-- + +DROP TABLE IF EXISTS `instance_scenario_progress`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `instance_scenario_progress` ( + `id` int(10) unsigned NOT NULL, + `criteria` int(10) unsigned NOT NULL, + `counter` bigint(20) unsigned NOT NULL, + `date` int(10) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`id`,`criteria`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `instance_scenario_progress` +-- + +LOCK TABLES `instance_scenario_progress` WRITE; +/*!40000 ALTER TABLE `instance_scenario_progress` DISABLE KEYS */; +/*!40000 ALTER TABLE `instance_scenario_progress` ENABLE KEYS */; +UNLOCK TABLES; + -- -- Table structure for table `item_instance` -- -- cgit v1.2.3