Skip to content

Commit

Permalink
TDB 335.20101 - 2020/10/15
Browse files Browse the repository at this point in the history
  • Loading branch information
TDB Release committed Oct 15, 2020
1 parent 5fee99b commit f4a397a
Show file tree
Hide file tree
Showing 85 changed files with 17 additions and 7 deletions.
2 changes: 1 addition & 1 deletion revision_data.h.in.cmake
Original file line number Diff line number Diff line change
Expand Up @@ -9,7 +9,7 @@
#define _SOURCE_DIRECTORY R"(@CMAKE_SOURCE_DIR@)"
#define _BUILD_DIRECTORY R"(@BUILDDIR@)"
#define _MYSQL_EXECUTABLE R"(@MYSQL_EXECUTABLE@)"
#define _FULL_DATABASE "TDB_full_world_335.20091_2020_09_15.sql"
#define _FULL_DATABASE "TDB_full_world_335.20101_2020_10_15.sql"
#define VER_COMPANYNAME_STR "TrinityCore Developers"
#define VER_LEGALCOPYRIGHT_STR "(c)2008-2019 TrinityCore"
#define VER_FILEVERSION 0,0,0
Expand Down
5 changes: 3 additions & 2 deletions sql/base/auth_database.sql
Original file line number Diff line number Diff line change
Expand Up @@ -1974,7 +1974,8 @@ INSERT INTO `updates` VALUES
('2020_08_22_00_auth.sql','060A87FCC8F836A96D9D55BEDC32CBAD05008B4C','ARCHIVED','2020-08-22 00:00:00',0),
('2020_09_06_00_auth.sql','DC4B5D4C65EB138D5609F137799C3289B9CC2493','ARCHIVED','2020-09-06 00:00:00',0),
('2020_09_15_00_auth.sql','0AA5BCA384A372DC789647F838657766D51D8CC7','ARCHIVED','2020-09-15 19:35:18',0),
('2020_09_17_00_auth.sql','BBC0A8B2BBED38A57A83999909EB066753A893C5','ARCHIVED','2020-09-17 00:00:00',0);
('2020_09_17_00_auth.sql','BBC0A8B2BBED38A57A83999909EB066753A893C5','ARCHIVED','2020-09-17 00:00:00',0),
('2020_10_15_00_auth.sql','8A79DE7DBDF35EBDA5C261BEBF9BC8E5CFF816CE','ARCHIVED','2020-10-15 07:33:13',0);
/*!40000 ALTER TABLE `updates` ENABLE KEYS */;
UNLOCK TABLES;

Expand Down Expand Up @@ -2080,4 +2081,4 @@ SET character_set_client = @saved_cs_client;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2020-09-15 19:35:20
-- Dump completed on 2020-10-15 7:33:15
5 changes: 3 additions & 2 deletions sql/base/characters_database.sql
Original file line number Diff line number Diff line change
Expand Up @@ -2653,7 +2653,8 @@ INSERT INTO `updates` VALUES
('2020_08_22_00_characters.sql','78251072C9281D98BC4EAC523DA0858C9F8425D9','ARCHIVED','2020-08-22 16:27:27',0),
('2020_09_02_00_characters.sql','627F320D58A42F401AB10ABA927F2B37C1981576','ARCHIVED','2020-09-02 17:41:04',0),
('2020_09_15_00_characters.sql','1B650E8C815E29AE261238B010BC9EB35BD49A25','ARCHIVED','2020-09-15 19:35:18',0),
('2020_09_27_00_characters.sql','441A0E8717165067D13B206F6925EEEA774262F3','RELEASED','2020-09-27 00:27:19',0);
('2020_09_27_00_characters.sql','441A0E8717165067D13B206F6925EEEA774262F3','ARCHIVED','2020-09-27 00:27:19',0),
('2020_10_15_00_characters.sql','72F769B6EFFA4C2C5E08235C89EF2629C0FA82EF','ARCHIVED','2020-10-15 07:33:14',0);
/*!40000 ALTER TABLE `updates` ENABLE KEYS */;
UNLOCK TABLES;

Expand Down Expand Up @@ -2824,4 +2825,4 @@ UNLOCK TABLES;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2020-09-15 19:35:20
-- Dump completed on 2020-10-15 7:33:15
5 changes: 3 additions & 2 deletions sql/base/dev/world_database.sql
Original file line number Diff line number Diff line change
Expand Up @@ -279,7 +279,6 @@ DROP TABLE IF EXISTS `command`;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `command` (
`name` varchar(50) NOT NULL DEFAULT '',
`permission` smallint(5) unsigned NOT NULL DEFAULT '0',
`help` longtext,
PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Chat System';
Expand Down Expand Up @@ -3955,6 +3954,8 @@ CREATE TABLE `waypoints` (
`position_x` float NOT NULL DEFAULT '0',
`position_y` float NOT NULL DEFAULT '0',
`position_z` float NOT NULL DEFAULT '0',
`orientation` float NOT NULL DEFAULT '0',
`delay` int(10) unsigned NOT NULL DEFAULT '0',
`point_comment` text,
PRIMARY KEY (`entry`,`pointid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Creature waypoints';
Expand Down Expand Up @@ -4027,4 +4028,4 @@ CREATE TABLE `waypoints` (
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2020-09-15 19:35:21
-- Dump completed on 2020-10-15 7:33:16
2 changes: 2 additions & 0 deletions sql/updates/auth/3.3.5/2020_10_15_00_auth.sql
Original file line number Diff line number Diff line change
@@ -0,0 +1,2 @@
-- TDB 335.20101 auth
UPDATE `updates` SET `state`='ARCHIVED';
2 changes: 2 additions & 0 deletions sql/updates/characters/3.3.5/2020_10_15_00_characters.sql
Original file line number Diff line number Diff line change
@@ -0,0 +1,2 @@
-- TDB 335.20101 characters
UPDATE `updates` SET `state`='ARCHIVED';
3 changes: 3 additions & 0 deletions sql/updates/world/3.3.5/2020_10_15_00_world.sql
Original file line number Diff line number Diff line change
@@ -0,0 +1,3 @@
-- TDB 335.20101 world
UPDATE `version` SET `db_version`='TDB 335.20101', `cache_id`=20101 LIMIT 1;
UPDATE `updates` SET `state`='ARCHIVED';

0 comments on commit f4a397a

Please sign in to comment.