vmangos/sql/migrations
2019-05-03 07:58:42 +03:00
..
20190216195152_world.sql Fix typo in migration. 2019-02-18 23:02:05 +02:00
20190220180943_world.sql Fix crash when Red Drakonid dies. 2019-02-20 20:11:57 +02:00
20190220213249_world.sql Improve Kirtonos the Herald script. 2019-02-20 23:36:07 +02:00
20190302155127_world.sql Implement negative resistances. 2019-03-02 18:45:12 +02:00
20190304084505_world.sql Add some missing item sources. 2019-03-04 10:47:35 +02:00
20190304091651_world.sql Add new extra flag to mark unobtainable items. 2019-03-04 11:36:06 +02:00
20190306081346_world.sql Fix damage of The End of Dreams. 2019-03-06 10:14:19 +02:00
20190306174313_world.sql Determine guard text based on faction. 2019-03-07 14:19:19 +02:00
20190307084626_world.sql Mark items used in mail system as discovered. 2019-03-07 10:47:49 +02:00
20190307122817_world.sql Misc creature spawn fixes. 2019-03-07 14:29:11 +02:00
20190308120124_world.sql Misc db fixes. 2019-03-08 14:01:56 +02:00
20190317152536_world.sql Misc database fixes. 2019-03-17 17:27:02 +02:00
20190319163539_world.sql Correct minimum level for some dungeon portals. 2019-03-19 18:39:50 +02:00
20190328170946_world.sql Progression fixes for 1.8 and 1.9. 2019-03-28 20:01:03 +02:00
20190401192133_world.sql Add missing item display id changes. 2019-04-01 22:23:40 +03:00
20190401193926_world.sql Add Food Crate and Water Barrel pools. 2019-04-01 22:40:38 +03:00
20190406121747_world.sql Fix some judgement issues before 1.9. 2019-04-06 15:21:06 +03:00
20190406141140_world.sql Fix ghost auras before 1.9. 2019-04-06 17:12:23 +03:00
20190422165936_world.sql Define some item flags. 2019-04-22 21:25:31 +03:00
20190422190410_world.sql Update creature spell lists in 1.2s intervals. 2019-04-22 22:57:22 +03:00
20190423150228_world.sql Update page text table. 2019-04-23 18:05:13 +03:00
20190425203723_world.sql Various spawn corrections. 2019-04-25 23:39:21 +03:00
20190426070954_world.sql Show waypoint id as level on waypoint npc. 2019-04-26 10:11:18 +03:00
20190426101930_world.sql Implement personal experience rates. 2019-04-26 13:39:01 +03:00
20190426190601_world.sql Fix Improved Fire Ward and Frost Warding talents. 2019-04-26 22:12:07 +03:00
20190429082223_world.sql Move Anachronos script to database. 2019-05-05 13:51:58 +03:00
20190430151640_world.sql A few AQ40 changes. 2019-04-30 18:19:04 +03:00
20190430153202_world.sql Add Defias Tower Patroller event. 2019-04-30 18:35:15 +03:00
20190430154254_world.sql Add Kargath Expeditionary Force event. 2019-04-30 18:43:49 +03:00
20190430155450_world.sql Fix Sheen of Zanza not applying. 2019-04-30 19:21:10 +03:00
20190430202017_world.sql Implement some GM spells. 2019-05-03 00:03:19 +03:00
20190502192619_world.sql Implement some GM spells. 2019-05-03 00:03:19 +03:00
20190503045304_world.sql Custom item script example. 2019-05-03 07:58:42 +03:00
merge.bat Change batch script for merging migrations to create a separate sql file for each database (#818) 2017-05-22 11:36:12 +01:00
merge.sh Add sql merge script for linux (#820) 2017-05-22 15:51:14 +01:00
README Initial Commit / Core Files 2017-03-10 00:38:11 +03:00

# SQL Migration File Format

SQL Migration is an ordinary SQL file.

File name must have the following format:

    YYYYmmddHHMMSS_database.sql

'YYYYmmddHHMMSS' should be the current date in UTC.
'database' must be one of 'characters', 'world' or 'logon'.

For example:

    20140320193109_world.sql

First line in the file must be the following:

    INSERT INTO `migrations` VALUES ('YYYYmmddHHMMSS');

The date must be the same as in the file name.