aboutsummaryrefslogtreecommitdiff
path: root/sql/base
diff options
context:
space:
mode:
Diffstat (limited to 'sql/base')
-rw-r--r--sql/base/auth_database.sql18
-rw-r--r--sql/base/characters_database.sql9
-rw-r--r--sql/base/dev/world_database.sql198
3 files changed, 181 insertions, 44 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index 56fa5122cd6..832022fbf76 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -1,8 +1,8 @@
--- MySQL dump 10.16 Distrib 10.1.6-MariaDB, for Win64 (AMD64)
+-- MySQL dump 10.13 Distrib 5.7.24, for Linux (x86_64)
--
-- Host: localhost Database: auth
-- ------------------------------------------------------
--- Server version 5.7.14-log
+-- Server version 5.7.24-0ubuntu0.16.04.1
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -296,10 +296,10 @@ CREATE TABLE `rbac_default_permissions` (
LOCK TABLES `rbac_default_permissions` WRITE;
/*!40000 ALTER TABLE `rbac_default_permissions` DISABLE KEYS */;
INSERT INTO `rbac_default_permissions` VALUES
-(1,194,-1),
-(0,195,-1),
+(3,192,-1),
(2,193,-1),
-(3,192,-1);
+(1,194,-1),
+(0,195,-1);
/*!40000 ALTER TABLE `rbac_default_permissions` ENABLE KEYS */;
UNLOCK TABLES;
@@ -1706,7 +1706,8 @@ CREATE TABLE `realmlist` (
LOCK TABLES `realmlist` WRITE;
/*!40000 ALTER TABLE `realmlist` DISABLE KEYS */;
-INSERT INTO `realmlist` VALUES (1,'Trinity','127.0.0.1','127.0.0.1','255.255.255.0',8085,0,2,1,0,0,12340);
+INSERT INTO `realmlist` VALUES
+(1,'Trinity','127.0.0.1','127.0.0.1','255.255.255.0',8085,0,2,1,0,0,12340);
/*!40000 ALTER TABLE `realmlist` ENABLE KEYS */;
UNLOCK TABLES;
@@ -1774,7 +1775,8 @@ INSERT INTO `updates` VALUES
('2018_08_30_00_auth.sql','22F69864361D3E72F800379338310172C0576D1C','ARCHIVED','2018-08-30 00:00:00',0),
('2018_09_06_00_auth.sql','309D21E0DF82ED8921F77EAFDE741F38AC32BB13','ARCHIVED','2018-09-06 00:00:00',0),
('2018_09_17_00_auth.sql','4DB671F0A4FA1A93AF28FB6426AF13DE72C7DA3D','ARCHIVED','2018-09-17 00:00:00',0),
-('2018_12_30_00_auth.sql','680F4F9194FC37592041C2DB5B2B7006B14E836D','RELEASED','2018-12-30 00:00:00',0);
+('2018_12_30_00_auth.sql','680F4F9194FC37592041C2DB5B2B7006B14E836D','ARCHIVED','2018-12-30 00:00:00',0),
+('2019_03_19_00_auth.sql','03BA8CFC60ACD5B874840A3E50F11CD2643730A0','ARCHIVED','2019-03-19 07:17:45',5);
/*!40000 ALTER TABLE `updates` ENABLE KEYS */;
UNLOCK TABLES;
@@ -1840,4 +1842,4 @@ UNLOCK TABLES;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2018-02-18 19:49:37
+-- Dump completed on 2019-03-19 7:18:00
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 863429ba72b..5a33979a6ab 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -1,8 +1,8 @@
--- MySQL dump 10.16 Distrib 10.1.6-MariaDB, for Win64 (AMD64)
+-- MySQL dump 10.13 Distrib 5.7.24, for Linux (x86_64)
--
-- Host: localhost Database: characters
-- ------------------------------------------------------
--- Server version 5.7.14-log
+-- Server version 5.7.24-0ubuntu0.16.04.1
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -2628,7 +2628,8 @@ INSERT INTO `updates` VALUES
('2018_02_19_00_characters.sql','FE5C5F9B88F0791549DDE680942493781E2269E6','ARCHIVED','2018-02-18 19:49:38',0),
('2018_04_24_00_characters.sql','77264AB7BEF421C0A4BB81EEAFD0D8C1CBCA840F','ARCHIVED','2018-04-20 09:38:10',0),
('2018_07_09_00_characters.sql','6F3EA22DD5E4CD9F9C60C4332B147E3DBF2E8A44','ARCHIVED','2018-07-09 18:19:18',0),
-('2018_11_09_00_characters.sql','50429D68E6EBD1149CDA14A9EA642BC06A1FAE3D','ARCHIVED','2018-11-09 20:49:47',0);
+('2018_11_09_00_characters.sql','50429D68E6EBD1149CDA14A9EA642BC06A1FAE3D','ARCHIVED','2018-11-09 20:49:47',0),
+('2019_03_19_00_characters.sql','1FD394E354CB9E854ABDC8CFD02329240AE07C3F','ARCHIVED','2019-03-19 07:17:45',5);
/*!40000 ALTER TABLE `updates` ENABLE KEYS */;
UNLOCK TABLES;
@@ -2794,4 +2795,4 @@ UNLOCK TABLES;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2018-02-18 19:49:38
+-- Dump completed on 2019-03-19 7:18:01
diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql
index bcbcdd086f2..60e905dc79a 100644
--- a/sql/base/dev/world_database.sql
+++ b/sql/base/dev/world_database.sql
@@ -1,8 +1,8 @@
--- MySQL dump 10.16 Distrib 10.1.6-MariaDB, for Win64 (AMD64)
+-- MySQL dump 10.13 Distrib 5.7.24, for Linux (x86_64)
--
-- Host: localhost Database: world
-- ------------------------------------------------------
--- Server version 5.7.14-log
+-- Server version 5.7.24-0ubuntu0.16.04.1
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -89,7 +89,7 @@ CREATE TABLE `achievement_reward` (
`ItemID` mediumint(8) unsigned NOT NULL DEFAULT '0',
`Sender` mediumint(8) unsigned NOT NULL DEFAULT '0',
`Subject` varchar(255) DEFAULT NULL,
- `Text` text,
+ `Body` text,
`MailTemplateID` mediumint(8) unsigned DEFAULT '0',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System';
@@ -106,7 +106,7 @@ CREATE TABLE `achievement_reward_locale` (
`ID` mediumint(8) unsigned NOT NULL DEFAULT '0',
`Locale` varchar(4) NOT NULL,
`Subject` text,
- `Text` text,
+ `Body` text,
PRIMARY KEY (`ID`,`Locale`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -350,6 +350,7 @@ CREATE TABLE `creature_addon` (
`bytes1` int(10) unsigned NOT NULL DEFAULT '0',
`bytes2` int(10) unsigned NOT NULL DEFAULT '0',
`emote` int(10) unsigned NOT NULL DEFAULT '0',
+ `visibilityDistanceType` tinyint(3) unsigned NOT NULL DEFAULT '0',
`auras` text,
PRIMARY KEY (`guid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
@@ -381,6 +382,20 @@ CREATE TABLE `creature_classlevelstats` (
/*!40101 SET character_set_client = @saved_cs_client */;
--
+-- Table structure for table `creature_default_trainer`
+--
+
+DROP TABLE IF EXISTS `creature_default_trainer`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `creature_default_trainer` (
+ `CreatureId` int(11) unsigned NOT NULL,
+ `TrainerId` int(11) unsigned NOT NULL DEFAULT '0',
+ PRIMARY KEY (`CreatureId`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
-- Table structure for table `creature_equip_template`
--
@@ -457,6 +472,25 @@ CREATE TABLE `creature_model_info` (
/*!40101 SET character_set_client = @saved_cs_client */;
--
+-- Table structure for table `creature_movement_override`
+--
+
+DROP TABLE IF EXISTS `creature_movement_override`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `creature_movement_override` (
+ `SpawnId` int(10) unsigned NOT NULL DEFAULT '0',
+ `Ground` tinyint(3) unsigned NOT NULL DEFAULT '1',
+ `Swim` tinyint(3) unsigned NOT NULL DEFAULT '1',
+ `Flight` tinyint(3) unsigned NOT NULL DEFAULT '0',
+ `Rooted` tinyint(3) unsigned NOT NULL DEFAULT '0',
+ `Chase` tinyint(3) unsigned NOT NULL DEFAULT '0',
+ `Random` tinyint(3) unsigned NOT NULL DEFAULT '0',
+ PRIMARY KEY (`SpawnId`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
-- Table structure for table `creature_onkill_reputation`
--
@@ -584,10 +618,6 @@ CREATE TABLE `creature_template` (
`unit_flags2` int(10) unsigned NOT NULL DEFAULT '0',
`dynamicflags` int(10) unsigned NOT NULL DEFAULT '0',
`family` tinyint(4) NOT NULL DEFAULT '0',
- `trainer_type` tinyint(4) NOT NULL DEFAULT '0',
- `trainer_spell` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `trainer_class` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `trainer_race` tinyint(3) unsigned NOT NULL DEFAULT '0',
`type` tinyint(3) unsigned NOT NULL DEFAULT '0',
`type_flags` int(10) unsigned NOT NULL DEFAULT '0',
`lootid` mediumint(8) unsigned NOT NULL DEFAULT '0',
@@ -613,7 +643,6 @@ CREATE TABLE `creature_template` (
`maxgold` mediumint(8) unsigned NOT NULL DEFAULT '0',
`AIName` char(64) NOT NULL DEFAULT '',
`MovementType` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `InhabitType` tinyint(3) unsigned NOT NULL DEFAULT '3',
`HoverHeight` float NOT NULL DEFAULT '1',
`HealthModifier` float NOT NULL DEFAULT '1',
`ManaModifier` float NOT NULL DEFAULT '1',
@@ -647,6 +676,7 @@ CREATE TABLE `creature_template_addon` (
`bytes1` int(10) unsigned NOT NULL DEFAULT '0',
`bytes2` int(10) unsigned NOT NULL DEFAULT '0',
`emote` mediumint(8) unsigned NOT NULL DEFAULT '0',
+ `visibilityDistanceType` tinyint(3) unsigned NOT NULL DEFAULT '0',
`auras` text,
PRIMARY KEY (`entry`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
@@ -670,6 +700,25 @@ CREATE TABLE `creature_template_locale` (
/*!40101 SET character_set_client = @saved_cs_client */;
--
+-- Table structure for table `creature_template_movement`
+--
+
+DROP TABLE IF EXISTS `creature_template_movement`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `creature_template_movement` (
+ `CreatureId` int(10) unsigned NOT NULL DEFAULT '0',
+ `Ground` tinyint(3) unsigned NOT NULL DEFAULT '1',
+ `Swim` tinyint(3) unsigned NOT NULL DEFAULT '1',
+ `Flight` tinyint(3) unsigned NOT NULL DEFAULT '0',
+ `Rooted` tinyint(3) unsigned NOT NULL DEFAULT '0',
+ `Chase` tinyint(3) unsigned NOT NULL DEFAULT '0',
+ `Random` tinyint(3) unsigned NOT NULL DEFAULT '0',
+ PRIMARY KEY (`CreatureId`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
-- Table structure for table `creature_text`
--
@@ -721,7 +770,7 @@ DROP TABLE IF EXISTS `disables`;
CREATE TABLE `disables` (
`sourceType` int(10) unsigned NOT NULL,
`entry` int(10) unsigned NOT NULL,
- `flags` tinyint(3) unsigned NOT NULL DEFAULT '0',
+ `flags` smallint(5) NOT NULL,
`params_0` varchar(255) NOT NULL DEFAULT '',
`params_1` varchar(255) NOT NULL DEFAULT '',
`comment` varchar(255) NOT NULL DEFAULT '',
@@ -1163,6 +1212,21 @@ CREATE TABLE `gameobject_loot_template` (
/*!40101 SET character_set_client = @saved_cs_client */;
--
+-- Table structure for table `gameobject_overrides`
+--
+
+DROP TABLE IF EXISTS `gameobject_overrides`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `gameobject_overrides` (
+ `spawnId` int(10) unsigned NOT NULL DEFAULT '0',
+ `faction` smallint(5) unsigned NOT NULL DEFAULT '0',
+ `flags` int(10) unsigned NOT NULL DEFAULT '0',
+ PRIMARY KEY (`spawnId`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
-- Table structure for table `gameobject_questender`
--
@@ -1925,24 +1989,6 @@ CREATE TABLE `npc_text_locale` (
/*!40101 SET character_set_client = @saved_cs_client */;
--
--- Table structure for table `npc_trainer`
---
-
-DROP TABLE IF EXISTS `npc_trainer`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `npc_trainer` (
- `ID` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `SpellID` mediumint(8) NOT NULL DEFAULT '0',
- `MoneyCost` int(10) unsigned NOT NULL DEFAULT '0',
- `ReqSkillLine` smallint(5) unsigned NOT NULL DEFAULT '0',
- `ReqSkillRank` smallint(5) unsigned NOT NULL DEFAULT '0',
- `ReqLevel` tinyint(3) unsigned NOT NULL DEFAULT '0',
- PRIMARY KEY (`ID`,`SpellID`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
-- Table structure for table `npc_vendor`
--
@@ -2027,6 +2073,8 @@ CREATE TABLE `pet_levelstats` (
`sta` smallint(5) unsigned NOT NULL,
`inte` smallint(5) unsigned NOT NULL,
`spi` smallint(5) unsigned NOT NULL,
+ `min_dmg` smallint(5) unsigned NOT NULL DEFAULT '0',
+ `max_dmg` smallint(5) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`creature_entry`,`level`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 COMMENT='Stores pet levels stats.';
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -2546,6 +2594,22 @@ CREATE TABLE `quest_offer_reward` (
/*!40101 SET character_set_client = @saved_cs_client */;
--
+-- Table structure for table `quest_offer_reward_locale`
+--
+
+DROP TABLE IF EXISTS `quest_offer_reward_locale`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `quest_offer_reward_locale` (
+ `ID` int(10) unsigned NOT NULL DEFAULT '0',
+ `locale` varchar(4) NOT NULL,
+ `RewardText` text,
+ `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+ PRIMARY KEY (`ID`,`locale`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
-- Table structure for table `quest_poi`
--
@@ -2604,6 +2668,22 @@ CREATE TABLE `quest_request_items` (
/*!40101 SET character_set_client = @saved_cs_client */;
--
+-- Table structure for table `quest_request_items_locale`
+--
+
+DROP TABLE IF EXISTS `quest_request_items_locale`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `quest_request_items_locale` (
+ `ID` int(10) unsigned NOT NULL DEFAULT '0',
+ `locale` varchar(4) NOT NULL,
+ `CompletionText` text,
+ `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0',
+ PRIMARY KEY (`ID`,`locale`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
-- Table structure for table `quest_template`
--
@@ -2762,8 +2842,6 @@ CREATE TABLE `quest_template_locale` (
`Title` text,
`Details` text,
`Objectives` text,
- `OfferRewardText` text,
- `RequestItemsText` text,
`EndText` text,
`CompletedText` text,
`ObjectiveText1` text,
@@ -3013,6 +3091,7 @@ CREATE TABLE `smart_scripts` (
`target_param1` int(10) unsigned NOT NULL DEFAULT '0',
`target_param2` int(10) unsigned NOT NULL DEFAULT '0',
`target_param3` int(10) unsigned NOT NULL DEFAULT '0',
+ `target_param4` int(10) unsigned NOT NULL DEFAULT '0',
`target_x` float NOT NULL DEFAULT '0',
`target_y` float NOT NULL DEFAULT '0',
`target_z` float NOT NULL DEFAULT '0',
@@ -3196,6 +3275,7 @@ CREATE TABLE `spell_dbc` (
`EffectSpellClassMaskC1` int(10) unsigned NOT NULL DEFAULT '0',
`EffectSpellClassMaskC2` int(10) unsigned NOT NULL DEFAULT '0',
`EffectSpellClassMaskC3` int(10) unsigned NOT NULL DEFAULT '0',
+ `SpellName` varchar(100) DEFAULT NULL,
`MaxTargetLevel` int(10) unsigned NOT NULL DEFAULT '0',
`SpellFamilyName` int(10) unsigned NOT NULL DEFAULT '0',
`SpellFamilyFlags1` int(10) unsigned NOT NULL DEFAULT '0',
@@ -3209,7 +3289,6 @@ CREATE TABLE `spell_dbc` (
`DmgMultiplier3` float NOT NULL DEFAULT '0',
`AreaGroupId` int(11) NOT NULL DEFAULT '0',
`SchoolMask` int(10) unsigned NOT NULL DEFAULT '0',
- `Comment` text NOT NULL,
PRIMARY KEY (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Custom spell.dbc entries';
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -3475,6 +3554,61 @@ CREATE TABLE `spelldifficulty_dbc` (
/*!40101 SET character_set_client = @saved_cs_client */;
--
+-- Table structure for table `trainer`
+--
+
+DROP TABLE IF EXISTS `trainer`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `trainer` (
+ `Id` int(10) unsigned NOT NULL DEFAULT '0',
+ `Type` tinyint(2) unsigned NOT NULL DEFAULT '2',
+ `Requirement` mediumint(8) unsigned NOT NULL DEFAULT '0',
+ `Greeting` text,
+ `VerifiedBuild` smallint(5) DEFAULT '0',
+ PRIMARY KEY (`Id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `trainer_locale`
+--
+
+DROP TABLE IF EXISTS `trainer_locale`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `trainer_locale` (
+ `Id` int(10) unsigned NOT NULL DEFAULT '0',
+ `locale` varchar(4) NOT NULL,
+ `Greeting_lang` text,
+ `VerifiedBuild` smallint(5) DEFAULT '0',
+ PRIMARY KEY (`Id`,`locale`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `trainer_spell`
+--
+
+DROP TABLE IF EXISTS `trainer_spell`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `trainer_spell` (
+ `TrainerId` int(10) unsigned NOT NULL DEFAULT '0',
+ `SpellId` int(10) unsigned NOT NULL DEFAULT '0',
+ `MoneyCost` int(10) unsigned NOT NULL DEFAULT '0',
+ `ReqSkillLine` int(10) unsigned NOT NULL DEFAULT '0',
+ `ReqSkillRank` int(10) unsigned NOT NULL DEFAULT '0',
+ `ReqAbility1` int(10) unsigned NOT NULL DEFAULT '0',
+ `ReqAbility2` int(10) unsigned NOT NULL DEFAULT '0',
+ `ReqAbility3` int(10) unsigned NOT NULL DEFAULT '0',
+ `ReqLevel` tinyint(3) unsigned NOT NULL DEFAULT '0',
+ `VerifiedBuild` smallint(5) DEFAULT '0',
+ PRIMARY KEY (`TrainerId`,`SpellId`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
-- Table structure for table `transports`
--
@@ -3691,4 +3825,4 @@ CREATE TABLE `waypoints` (
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2018-02-18 19:49:40
+-- Dump completed on 2019-03-19 7:18:01