aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/base/auth_database.sql51
-rw-r--r--sql/base/characters_database.sql72
-rw-r--r--sql/base/dev/world_database.sql114
-rw-r--r--sql/old/3.3.5a/auth/19071_2019_08_16/2019_07_15_00_auth.sql (renamed from sql/updates/auth/3.3.5/2019_07_15_00_auth.sql)0
-rw-r--r--sql/old/3.3.5a/auth/19071_2019_08_16/2019_07_16_00_auth.sql (renamed from sql/updates/auth/3.3.5/2019_07_16_00_auth.sql)0
-rw-r--r--sql/old/3.3.5a/auth/19071_2019_08_16/2019_07_17_00_auth.sql (renamed from sql/updates/auth/3.3.5/2019_07_17_00_auth.sql)0
-rw-r--r--sql/old/3.3.5a/auth/19071_2019_08_16/2019_08_10_00_auth.sql (renamed from sql/updates/auth/3.3.5/2019_08_10_00_auth.sql)0
-rw-r--r--sql/old/3.3.5a/auth/19071_2019_08_16/2019_08_10_01_auth.sql (renamed from sql/updates/auth/3.3.5/2019_08_10_01_auth.sql)0
-rw-r--r--sql/old/3.3.5a/characters/19071_2019_08_16/2019_07_15_00_characters.sql (renamed from sql/updates/characters/3.3.5/2019_07_15_00_characters.sql)0
-rw-r--r--sql/old/3.3.5a/characters/19071_2019_08_16/2019_07_15_01_characters.sql (renamed from sql/updates/characters/3.3.5/2019_07_15_01_characters.sql)0
-rw-r--r--sql/old/3.3.5a/characters/19071_2019_08_16/2019_07_16_00_characters.sql (renamed from sql/updates/characters/3.3.5/2019_07_16_00_characters.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_15_00_world.sql (renamed from sql/updates/world/3.3.5/2019_07_15_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_16_00_world.sql (renamed from sql/updates/world/3.3.5/2019_07_16_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_16_01_world.sql (renamed from sql/updates/world/3.3.5/2019_07_16_01_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_16_02_world_335.sql (renamed from sql/updates/world/3.3.5/2019_07_16_02_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_16_03_world_335.sql (renamed from sql/updates/world/3.3.5/2019_07_16_03_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_17_00_world_335.sql (renamed from sql/updates/world/3.3.5/2019_07_17_00_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_17_01_world.sql (renamed from sql/updates/world/3.3.5/2019_07_17_01_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_17_02_world.sql (renamed from sql/updates/world/3.3.5/2019_07_17_02_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_17_03_world.sql (renamed from sql/updates/world/3.3.5/2019_07_17_03_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_17_04_world.sql (renamed from sql/updates/world/3.3.5/2019_07_17_04_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_17_05_world.sql (renamed from sql/updates/world/3.3.5/2019_07_17_05_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_17_06_world.sql (renamed from sql/updates/world/3.3.5/2019_07_17_06_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_17_07_world.sql (renamed from sql/updates/world/3.3.5/2019_07_17_07_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_17_08_world.sql (renamed from sql/updates/world/3.3.5/2019_07_17_08_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_18_00_world.sql (renamed from sql/updates/world/3.3.5/2019_07_18_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_19_00_world.sql (renamed from sql/updates/world/3.3.5/2019_07_19_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_19_01_world.sql (renamed from sql/updates/world/3.3.5/2019_07_19_01_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_19_02_world.sql (renamed from sql/updates/world/3.3.5/2019_07_19_02_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_19_03_world.sql (renamed from sql/updates/world/3.3.5/2019_07_19_03_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_19_04_world.sql (renamed from sql/updates/world/3.3.5/2019_07_19_04_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_20_00_world.sql (renamed from sql/updates/world/3.3.5/2019_07_20_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_20_01_world.sql (renamed from sql/updates/world/3.3.5/2019_07_20_01_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_20_02_world.sql (renamed from sql/updates/world/3.3.5/2019_07_20_02_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_20_03_world.sql (renamed from sql/updates/world/3.3.5/2019_07_20_03_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_20_04_world.sql (renamed from sql/updates/world/3.3.5/2019_07_20_04_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_20_05_world.sql (renamed from sql/updates/world/3.3.5/2019_07_20_05_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_20_06_world.sql (renamed from sql/updates/world/3.3.5/2019_07_20_06_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_20_07_world.sql (renamed from sql/updates/world/3.3.5/2019_07_20_07_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_20_08_world.sql (renamed from sql/updates/world/3.3.5/2019_07_20_08_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_20_09_world.sql (renamed from sql/updates/world/3.3.5/2019_07_20_09_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_21_00_world.sql (renamed from sql/updates/world/3.3.5/2019_07_21_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_21_01_world.sql (renamed from sql/updates/world/3.3.5/2019_07_21_01_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_21_02_world.sql (renamed from sql/updates/world/3.3.5/2019_07_21_02_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_22_00_world.sql (renamed from sql/updates/world/3.3.5/2019_07_22_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_22_01_world.sql (renamed from sql/updates/world/3.3.5/2019_07_22_01_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_22_02_world.sql (renamed from sql/updates/world/3.3.5/2019_07_22_02_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_22_03_world.sql (renamed from sql/updates/world/3.3.5/2019_07_22_03_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_22_04_world.sql (renamed from sql/updates/world/3.3.5/2019_07_22_04_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_22_05_world.sql (renamed from sql/updates/world/3.3.5/2019_07_22_05_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_22_06_world.sql (renamed from sql/updates/world/3.3.5/2019_07_22_06_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_23_00_world.sql (renamed from sql/updates/world/3.3.5/2019_07_23_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_23_01_world.sql (renamed from sql/updates/world/3.3.5/2019_07_23_01_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_23_02_world.sql (renamed from sql/updates/world/3.3.5/2019_07_23_02_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_23_03_world.sql (renamed from sql/updates/world/3.3.5/2019_07_23_03_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_23_04_world.sql (renamed from sql/updates/world/3.3.5/2019_07_23_04_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_23_05_world.sql (renamed from sql/updates/world/3.3.5/2019_07_23_05_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_24_00_world.sql (renamed from sql/updates/world/3.3.5/2019_07_24_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_24_01_world.sql (renamed from sql/updates/world/3.3.5/2019_07_24_01_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_25_00_world_335.sql (renamed from sql/updates/world/3.3.5/2019_07_25_00_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_25_01_world.sql (renamed from sql/updates/world/3.3.5/2019_07_25_01_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_25_02_world.sql (renamed from sql/updates/world/3.3.5/2019_07_25_02_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_25_03_world.sql (renamed from sql/updates/world/3.3.5/2019_07_25_03_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_25_04_world_335.sql (renamed from sql/updates/world/3.3.5/2019_07_25_04_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_25_05_world.sql (renamed from sql/updates/world/3.3.5/2019_07_25_05_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_25_06_world.sql (renamed from sql/updates/world/3.3.5/2019_07_25_06_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_25_07_world.sql (renamed from sql/updates/world/3.3.5/2019_07_25_07_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_25_08_world_335.sql (renamed from sql/updates/world/3.3.5/2019_07_25_08_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_25_09_world_335.sql (renamed from sql/updates/world/3.3.5/2019_07_25_09_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_25_10_world.sql (renamed from sql/updates/world/3.3.5/2019_07_25_10_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_25_11_world.sql (renamed from sql/updates/world/3.3.5/2019_07_25_11_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_26_00_world.sql (renamed from sql/updates/world/3.3.5/2019_07_26_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_26_01_world.sql (renamed from sql/updates/world/3.3.5/2019_07_26_01_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_27_00_world.sql (renamed from sql/updates/world/3.3.5/2019_07_27_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_27_01_world.sql (renamed from sql/updates/world/3.3.5/2019_07_27_01_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_28_00_world.sql (renamed from sql/updates/world/3.3.5/2019_07_28_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_28_01_world_335.sql (renamed from sql/updates/world/3.3.5/2019_07_28_01_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_28_02_world.sql (renamed from sql/updates/world/3.3.5/2019_07_28_02_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_28_03_world.sql (renamed from sql/updates/world/3.3.5/2019_07_28_03_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_28_04_world.sql (renamed from sql/updates/world/3.3.5/2019_07_28_04_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_28_05_world.sql (renamed from sql/updates/world/3.3.5/2019_07_28_05_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_07_30_00_world.sql (renamed from sql/updates/world/3.3.5/2019_07_30_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_08_01_00_world.sql (renamed from sql/updates/world/3.3.5/2019_08_01_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_08_02_00_world.sql (renamed from sql/updates/world/3.3.5/2019_08_02_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_08_02_01_world.sql (renamed from sql/updates/world/3.3.5/2019_08_02_01_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_08_02_02_world.sql (renamed from sql/updates/world/3.3.5/2019_08_02_02_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_08_02_03_world.sql (renamed from sql/updates/world/3.3.5/2019_08_02_03_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_08_02_04_world.sql (renamed from sql/updates/world/3.3.5/2019_08_02_04_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_08_02_05_world.sql (renamed from sql/updates/world/3.3.5/2019_08_02_05_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_08_03_00_world.sql (renamed from sql/updates/world/3.3.5/2019_08_03_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_08_03_01_world.sql (renamed from sql/updates/world/3.3.5/2019_08_03_01_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_08_03_02_world.sql (renamed from sql/updates/world/3.3.5/2019_08_03_02_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_08_03_03_world.sql (renamed from sql/updates/world/3.3.5/2019_08_03_03_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_08_03_04_world_335.sql (renamed from sql/updates/world/3.3.5/2019_08_03_04_world_335.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_08_03_05_world.sql (renamed from sql/updates/world/3.3.5/2019_08_03_05_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_08_03_06_world.sql (renamed from sql/updates/world/3.3.5/2019_08_03_06_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_08_03_07_world.sql (renamed from sql/updates/world/3.3.5/2019_08_03_07_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_08_03_08_world.sql (renamed from sql/updates/world/3.3.5/2019_08_03_08_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_08_03_09_world.sql (renamed from sql/updates/world/3.3.5/2019_08_03_09_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_08_04_00_world.sql (renamed from sql/updates/world/3.3.5/2019_08_04_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_08_04_01_world.sql (renamed from sql/updates/world/3.3.5/2019_08_04_01_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_08_04_02_world.sql (renamed from sql/updates/world/3.3.5/2019_08_04_02_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_08_04_03_world.sql (renamed from sql/updates/world/3.3.5/2019_08_04_03_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_08_04_04_world.sql (renamed from sql/updates/world/3.3.5/2019_08_04_04_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_08_05_00_world.sql (renamed from sql/updates/world/3.3.5/2019_08_05_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_08_05_01_world.sql (renamed from sql/updates/world/3.3.5/2019_08_05_01_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_08_05_02_world.sql (renamed from sql/updates/world/3.3.5/2019_08_05_02_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_08_05_03_world.sql (renamed from sql/updates/world/3.3.5/2019_08_05_03_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_08_05_04_world.sql (renamed from sql/updates/world/3.3.5/2019_08_05_04_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_08_05_05_world.sql (renamed from sql/updates/world/3.3.5/2019_08_05_05_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_08_05_06_world.sql (renamed from sql/updates/world/3.3.5/2019_08_05_06_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_08_06_00_world.sql (renamed from sql/updates/world/3.3.5/2019_08_06_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_08_06_01_world.sql (renamed from sql/updates/world/3.3.5/2019_08_06_01_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_08_06_02_world.sql (renamed from sql/updates/world/3.3.5/2019_08_06_02_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_08_06_03_world.sql (renamed from sql/updates/world/3.3.5/2019_08_06_03_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_08_06_04_world.sql (renamed from sql/updates/world/3.3.5/2019_08_06_04_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_08_06_05_world.sql (renamed from sql/updates/world/3.3.5/2019_08_06_05_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_08_08_00_world.sql (renamed from sql/updates/world/3.3.5/2019_08_08_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_08_08_01_world.sql (renamed from sql/updates/world/3.3.5/2019_08_08_01_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_08_10_00_world.sql (renamed from sql/updates/world/3.3.5/2019_08_10_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_08_10_01_world.sql (renamed from sql/updates/world/3.3.5/2019_08_10_01_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_08_12_00_world.sql (renamed from sql/updates/world/3.3.5/2019_08_12_00_world.sql)0
-rw-r--r--sql/old/3.3.5a/world/19071_2019_08_16/2019_08_15_00_world.sql (renamed from sql/updates/world/3.3.5/2019_08_15_00_world.sql)0
-rw-r--r--sql/updates/auth/3.3.5/2019_08_16_00_auth.sql2
-rw-r--r--sql/updates/characters/3.3.5/2019_08_16_00_characters.sql2
-rw-r--r--sql/updates/world/3.3.5/2019_08_16_00_world.sql3
126 files changed, 125 insertions, 119 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index ffcd11d5257..61c08d40e26 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -16,29 +16,6 @@
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
--- Table structure for table `secret_digest`
---
-
-DROP TABLE IF EXISTS `secret_digest`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `secret_digest` (
- `id` int(10) unsigned not null,
- `digest` varchar(100) not null,
- PRIMARY KEY (`id`)
-) ENGINE=InnoDB;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `secret_digest`
---
-
-LOCK TABLES `secret_digest` WRITE;
-/*!40000 ALTER TABLE `secret_digest` DISABLE KEYS */;
-/*!40000 ALTER TABLE `secret_digest` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
-- Table structure for table `account`
--
@@ -1756,6 +1733,29 @@ INSERT INTO `realmlist` VALUES
UNLOCK TABLES;
--
+-- Table structure for table `secret_digest`
+--
+
+DROP TABLE IF EXISTS `secret_digest`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `secret_digest` (
+ `id` int(10) unsigned NOT NULL,
+ `digest` varchar(100) NOT NULL,
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `secret_digest`
+--
+
+LOCK TABLES `secret_digest` WRITE;
+/*!40000 ALTER TABLE `secret_digest` DISABLE KEYS */;
+/*!40000 ALTER TABLE `secret_digest` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
-- Table structure for table `updates`
--
@@ -1832,7 +1832,8 @@ INSERT INTO `updates` VALUES
('2019_07_16_00_auth.sql','36CB53A9EBD64BFDCF7030083E36E534F1753773','ARCHIVED','2019-07-16 00:00:00',0),
('2019_07_17_00_auth.sql','4F983F039904894ACC483BE885676C5F0A18F06B','ARCHIVED','2019-07-17 00:00:00',0),
('2019_08_10_00_auth.sql','E936802893474BB9B459D01BB5F181F54EDF0653','ARCHIVED','2019-08-10 00:00:00',0),
-('2019_08_10_01_auth.sql','C58357260F0C70DA226A71F7E05DE2C49AAEFD74','ARCHIVED','2019-08-10 00:00:00',0);
+('2019_08_10_01_auth.sql','C58357260F0C70DA226A71F7E05DE2C49AAEFD74','ARCHIVED','2019-08-10 00:00:00',0),
+('2019_08_16_00_auth.sql','99CF9C250EFBBD703DF0A2D1BDEB1E46D1063EE9','ARCHIVED','2019-08-16 06:25:07',0);
/*!40000 ALTER TABLE `updates` ENABLE KEYS */;
UNLOCK TABLES;
@@ -1934,4 +1935,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 2019-07-15 5:57:44
+-- Dump completed on 2019-08-16 6:25:10
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 668c8adb45f..b786a9e588f 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -115,29 +115,29 @@ CREATE TABLE `addons` (
LOCK TABLES `addons` WRITE;
/*!40000 ALTER TABLE `addons` DISABLE KEYS */;
INSERT INTO `addons` VALUES
-('Blizzard_AchievementUI', 1276933997),
-('Blizzard_ArenaUI', 1276933997),
-('Blizzard_AuctionUI', 1276933997),
-('Blizzard_BarbershopUI', 1276933997),
-('Blizzard_BattlefieldMinimap', 1276933997),
-('Blizzard_BindingUI', 1276933997),
-('Blizzard_Calendar', 1276933997),
-('Blizzard_CombatLog', 1276933997),
-('Blizzard_CombatText', 1276933997),
-('Blizzard_DebugTools', 1276933997),
-('Blizzard_GlyphUI', 1276933997),
-('Blizzard_GMChatUI', 1276933997),
-('Blizzard_GMSurveyUI', 1276933997),
-('Blizzard_GuildBankUI', 1276933997),
-('Blizzard_InspectUI', 1276933997),
-('Blizzard_ItemSocketingUI', 1276933997),
-('Blizzard_MacroUI', 1276933997),
-('Blizzard_RaidUI', 1276933997),
-('Blizzard_TalentUI', 1276933997),
-('Blizzard_TimeManager', 1276933997),
-('Blizzard_TokenUI', 1276933997),
-('Blizzard_TradeSkillUI', 1276933997),
-('Blizzard_TrainerUI', 1276933997);
+('Blizzard_AchievementUI',1276933997),
+('Blizzard_ArenaUI',1276933997),
+('Blizzard_AuctionUI',1276933997),
+('Blizzard_BarbershopUI',1276933997),
+('Blizzard_BattlefieldMinimap',1276933997),
+('Blizzard_BindingUI',1276933997),
+('Blizzard_Calendar',1276933997),
+('Blizzard_CombatLog',1276933997),
+('Blizzard_CombatText',1276933997),
+('Blizzard_DebugTools',1276933997),
+('Blizzard_GlyphUI',1276933997),
+('Blizzard_GMChatUI',1276933997),
+('Blizzard_GMSurveyUI',1276933997),
+('Blizzard_GuildBankUI',1276933997),
+('Blizzard_InspectUI',1276933997),
+('Blizzard_ItemSocketingUI',1276933997),
+('Blizzard_MacroUI',1276933997),
+('Blizzard_RaidUI',1276933997),
+('Blizzard_TalentUI',1276933997),
+('Blizzard_TimeManager',1276933997),
+('Blizzard_TokenUI',1276933997),
+('Blizzard_TradeSkillUI',1276933997),
+('Blizzard_TrainerUI',1276933997);
/*!40000 ALTER TABLE `addons` ENABLE KEYS */;
UNLOCK TABLES;
@@ -2610,7 +2610,7 @@ INSERT INTO `updates` VALUES
('2015_10_28_00_characters.sql','622A9CA8FCE690429EBE23BA071A37C7A007BF8B','ARCHIVED','2015-10-19 14:32:22',0),
('2015_10_29_00_characters_335.sql','4555A7F35C107E54C13D74D20F141039ED42943E','ARCHIVED','2015-10-29 17:05:43',0),
('2015_11_03_00_characters.sql','CC045717B8FDD9733351E52A5302560CD08AAD57','ARCHIVED','2015-10-12 15:23:33',0),
-('2015_11_07_00_characters.sql','0ACDD35EC9745231BCFA701B78056DEF94D0CC53','ARCHIVED','2016-04-11 00:42:36',94),
+('2015_11_07_00_characters.sql','0ACDD35EC9745231BCFA701B78056DEF94D0CC53','ARCHIVED','2016-04-11 00:42:36',0),
('2016_02_10_00_characters.sql','F1B4DA202819CABC7319A4470A2D224A34609E97','ARCHIVED','2016-02-10 00:00:00',0),
('2016_03_13_2016_01_05_00_characters.sql','0EAD24977F40DE2476B4567DA2B477867CC0DA1A','ARCHIVED','2016-03-13 20:03:56',0),
('2016_04_11_00_characters.sql','0ACDD35EC9745231BCFA701B78056DEF94D0CC53','ARCHIVED','2016-04-11 03:18:17',0),
@@ -2635,8 +2635,8 @@ INSERT INTO `updates` VALUES
('2019_07_14_00_characters.sql','A141F4F15BDF0320483921429871D4C572BD7E2D','ARCHIVED','2019-07-04 00:00:00',0),
('2019_07_15_00_characters.sql','5BCF35896BB36A306CE79CF1E3F1945FAF9019D9','ARCHIVED','2019-07-15 00:00:00',0),
('2019_07_15_01_characters.sql','5D383B026AB9EDE7114F249D206DE7E432E19468','ARCHIVED','2019-07-15 00:00:00',0),
-('2019_07_16_00_characters.sql','76AE193EFA3129FA1702BF7B6FA7C4127B543BDF','ARCHIVED','2019-07-16 00:00:00',0);
-
+('2019_07_16_00_characters.sql','76AE193EFA3129FA1702BF7B6FA7C4127B543BDF','ARCHIVED','2019-07-16 00:00:00',0),
+('2019_08_16_00_characters.sql','7E21060060513C9504107C4A06B106166CC0768E','ARCHIVED','2019-08-16 06:25:07',0);
/*!40000 ALTER TABLE `updates` ENABLE KEYS */;
UNLOCK TABLES;
@@ -2725,11 +2725,11 @@ INSERT INTO `worldstates` VALUES
(11,0,NULL),
(12,0,NULL),
(13,0,NULL),
-(14,1476626581,NULL),
-(15,1476626581,NULL),
+(14,0,NULL),
+(15,0,NULL),
(16,0,NULL),
(17,0,NULL),
-(18,1476626581,NULL),
+(18,0,NULL),
(19,0,NULL),
(20,0,NULL),
(21,0,NULL),
@@ -2738,14 +2738,14 @@ INSERT INTO `worldstates` VALUES
(24,0,NULL),
(25,0,NULL),
(26,0,NULL),
-(27,1476626581,NULL),
+(27,0,NULL),
(28,0,NULL),
(29,0,NULL),
(30,0,NULL),
(31,0,NULL),
(32,0,NULL),
(33,0,NULL),
-(34,1476626581,NULL),
+(34,0,NULL),
(35,0,NULL),
(36,0,NULL),
(37,0,NULL),
@@ -2771,9 +2771,9 @@ INSERT INTO `worldstates` VALUES
(57,0,NULL),
(58,0,NULL),
(59,0,NULL),
-(60,1476626581,NULL),
+(60,0,NULL),
(61,0,NULL),
-(62,1476626581,NULL),
+(62,0,NULL),
(63,0,NULL),
(64,0,NULL),
(65,0,NULL),
@@ -2781,9 +2781,9 @@ INSERT INTO `worldstates` VALUES
(67,0,NULL),
(68,0,NULL),
(69,0,NULL),
-(3781,9000000,NULL),
+(3781,0,NULL),
(3801,0,NULL),
-(3802,1,NULL),
+(3802,0,NULL),
(20001,0,'NextArenaPointDistributionTime'),
(20002,0,'NextWeeklyQuestResetTime'),
(20003,0,'NextBGRandomDailyResetTime'),
@@ -2803,4 +2803,4 @@ UNLOCK TABLES;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2019-07-15 5:57:44
+-- Dump completed on 2019-08-16 6:25:11
diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql
index 32d12d9dcb5..82243763ca4 100644
--- a/sql/base/dev/world_database.sql
+++ b/sql/base/dev/world_database.sql
@@ -2262,6 +2262,21 @@ CREATE TABLE `player_levelstats` (
/*!40101 SET character_set_client = @saved_cs_client */;
--
+-- Table structure for table `player_totem_model`
+--
+
+DROP TABLE IF EXISTS `player_totem_model`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `player_totem_model` (
+ `TotemSlot` tinyint(3) unsigned NOT NULL,
+ `RaceId` tinyint(3) unsigned NOT NULL,
+ `DisplayId` int(10) unsigned NOT NULL DEFAULT '0',
+ PRIMARY KEY (`TotemSlot`,`RaceId`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
-- Table structure for table `player_xp_for_level`
--
@@ -2415,68 +2430,19 @@ CREATE TABLE `points_of_interest_locale` (
/*!40101 SET character_set_client = @saved_cs_client */;
--
--- Table structure for table `pool_creature`
+-- Table structure for table `pool_members`
--
-DROP TABLE IF EXISTS `pool_creature`;
+DROP TABLE IF EXISTS `pool_members`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `pool_creature` (
- `guid` int(10) unsigned NOT NULL DEFAULT '0',
- `pool_entry` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `chance` float unsigned NOT NULL DEFAULT '0',
- `description` varchar(255) DEFAULT NULL,
- PRIMARY KEY (`guid`),
- KEY `idx_guid` (`guid`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `pool_gameobject`
---
-
-DROP TABLE IF EXISTS `pool_gameobject`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `pool_gameobject` (
- `guid` int(10) unsigned NOT NULL DEFAULT '0',
- `pool_entry` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `chance` float unsigned NOT NULL DEFAULT '0',
- `description` varchar(255) DEFAULT NULL,
- PRIMARY KEY (`guid`),
- KEY `idx_guid` (`guid`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `pool_pool`
---
-
-DROP TABLE IF EXISTS `pool_pool`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `pool_pool` (
- `pool_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `mother_pool` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `chance` float NOT NULL DEFAULT '0',
- `description` varchar(255) DEFAULT NULL,
- PRIMARY KEY (`pool_id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Table structure for table `pool_quest`
---
-
-DROP TABLE IF EXISTS `pool_quest`;
-/*!40101 SET @saved_cs_client = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `pool_quest` (
- `entry` int(10) unsigned NOT NULL DEFAULT '0',
- `pool_entry` mediumint(8) unsigned NOT NULL DEFAULT '0',
+CREATE TABLE `pool_members` (
+ `type` smallint(10) unsigned NOT NULL,
+ `spawnId` int(10) unsigned NOT NULL,
+ `poolSpawnId` int(10) unsigned NOT NULL,
+ `chance` double unsigned NOT NULL,
`description` varchar(255) DEFAULT NULL,
- PRIMARY KEY (`entry`),
- KEY `idx_guid` (`entry`)
+ PRIMARY KEY (`type`,`spawnId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -2669,6 +2635,37 @@ CREATE TABLE `quest_poi_points` (
/*!40101 SET character_set_client = @saved_cs_client */;
--
+-- Table structure for table `quest_pool_members`
+--
+
+DROP TABLE IF EXISTS `quest_pool_members`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `quest_pool_members` (
+ `questId` int(10) unsigned NOT NULL,
+ `poolId` int(10) unsigned NOT NULL,
+ `poolIndex` tinyint(2) unsigned NOT NULL COMMENT 'Multiple quests with the same index will always spawn together!',
+ `description` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`questId`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Table structure for table `quest_pool_template`
+--
+
+DROP TABLE IF EXISTS `quest_pool_template`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `quest_pool_template` (
+ `poolId` mediumint(8) unsigned NOT NULL,
+ `numActive` int(10) unsigned NOT NULL COMMENT 'Number of indices to have active at any time',
+ `description` varchar(255) DEFAULT NULL,
+ PRIMARY KEY (`poolId`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
-- Table structure for table `quest_request_items`
--
@@ -2952,6 +2949,7 @@ CREATE TABLE `script_spline_chain_meta` (
`splineId` tinyint(3) unsigned NOT NULL,
`expectedDuration` int(10) unsigned NOT NULL,
`msUntilNext` int(10) unsigned NOT NULL,
+ `velocity` float unsigned DEFAULT '0',
PRIMARY KEY (`entry`,`chainId`,`splineId`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -3844,4 +3842,4 @@ CREATE TABLE `waypoints` (
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2019-07-15 5:57:44
+-- Dump completed on 2019-08-16 6:25:11
diff --git a/sql/updates/auth/3.3.5/2019_07_15_00_auth.sql b/sql/old/3.3.5a/auth/19071_2019_08_16/2019_07_15_00_auth.sql
index f96eaa66920..f96eaa66920 100644
--- a/sql/updates/auth/3.3.5/2019_07_15_00_auth.sql
+++ b/sql/old/3.3.5a/auth/19071_2019_08_16/2019_07_15_00_auth.sql
diff --git a/sql/updates/auth/3.3.5/2019_07_16_00_auth.sql b/sql/old/3.3.5a/auth/19071_2019_08_16/2019_07_16_00_auth.sql
index bbec0eb65aa..bbec0eb65aa 100644
--- a/sql/updates/auth/3.3.5/2019_07_16_00_auth.sql
+++ b/sql/old/3.3.5a/auth/19071_2019_08_16/2019_07_16_00_auth.sql
diff --git a/sql/updates/auth/3.3.5/2019_07_17_00_auth.sql b/sql/old/3.3.5a/auth/19071_2019_08_16/2019_07_17_00_auth.sql
index afcd8c6e57e..afcd8c6e57e 100644
--- a/sql/updates/auth/3.3.5/2019_07_17_00_auth.sql
+++ b/sql/old/3.3.5a/auth/19071_2019_08_16/2019_07_17_00_auth.sql
diff --git a/sql/updates/auth/3.3.5/2019_08_10_00_auth.sql b/sql/old/3.3.5a/auth/19071_2019_08_16/2019_08_10_00_auth.sql
index 6af00e84c4b..6af00e84c4b 100644
--- a/sql/updates/auth/3.3.5/2019_08_10_00_auth.sql
+++ b/sql/old/3.3.5a/auth/19071_2019_08_16/2019_08_10_00_auth.sql
diff --git a/sql/updates/auth/3.3.5/2019_08_10_01_auth.sql b/sql/old/3.3.5a/auth/19071_2019_08_16/2019_08_10_01_auth.sql
index fd0e0c8ae0c..fd0e0c8ae0c 100644
--- a/sql/updates/auth/3.3.5/2019_08_10_01_auth.sql
+++ b/sql/old/3.3.5a/auth/19071_2019_08_16/2019_08_10_01_auth.sql
diff --git a/sql/updates/characters/3.3.5/2019_07_15_00_characters.sql b/sql/old/3.3.5a/characters/19071_2019_08_16/2019_07_15_00_characters.sql
index 7b15aaa0140..7b15aaa0140 100644
--- a/sql/updates/characters/3.3.5/2019_07_15_00_characters.sql
+++ b/sql/old/3.3.5a/characters/19071_2019_08_16/2019_07_15_00_characters.sql
diff --git a/sql/updates/characters/3.3.5/2019_07_15_01_characters.sql b/sql/old/3.3.5a/characters/19071_2019_08_16/2019_07_15_01_characters.sql
index 5864c766927..5864c766927 100644
--- a/sql/updates/characters/3.3.5/2019_07_15_01_characters.sql
+++ b/sql/old/3.3.5a/characters/19071_2019_08_16/2019_07_15_01_characters.sql
diff --git a/sql/updates/characters/3.3.5/2019_07_16_00_characters.sql b/sql/old/3.3.5a/characters/19071_2019_08_16/2019_07_16_00_characters.sql
index 425972d7e0e..425972d7e0e 100644
--- a/sql/updates/characters/3.3.5/2019_07_16_00_characters.sql
+++ b/sql/old/3.3.5a/characters/19071_2019_08_16/2019_07_16_00_characters.sql
diff --git a/sql/updates/world/3.3.5/2019_07_15_00_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_15_00_world.sql
index 695f04e35ba..695f04e35ba 100644
--- a/sql/updates/world/3.3.5/2019_07_15_00_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_15_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_16_00_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_16_00_world.sql
index e61738a3eaa..e61738a3eaa 100644
--- a/sql/updates/world/3.3.5/2019_07_16_00_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_16_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_16_01_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_16_01_world.sql
index 9bc838f2c6e..9bc838f2c6e 100644
--- a/sql/updates/world/3.3.5/2019_07_16_01_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_16_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_16_02_world_335.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_16_02_world_335.sql
index 904e0d0e017..904e0d0e017 100644
--- a/sql/updates/world/3.3.5/2019_07_16_02_world_335.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_16_02_world_335.sql
diff --git a/sql/updates/world/3.3.5/2019_07_16_03_world_335.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_16_03_world_335.sql
index b0f6c503d6e..b0f6c503d6e 100644
--- a/sql/updates/world/3.3.5/2019_07_16_03_world_335.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_16_03_world_335.sql
diff --git a/sql/updates/world/3.3.5/2019_07_17_00_world_335.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_17_00_world_335.sql
index a4b5c8e2887..a4b5c8e2887 100644
--- a/sql/updates/world/3.3.5/2019_07_17_00_world_335.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_17_00_world_335.sql
diff --git a/sql/updates/world/3.3.5/2019_07_17_01_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_17_01_world.sql
index b3ceb271ec3..b3ceb271ec3 100644
--- a/sql/updates/world/3.3.5/2019_07_17_01_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_17_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_17_02_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_17_02_world.sql
index f572b1d3835..f572b1d3835 100644
--- a/sql/updates/world/3.3.5/2019_07_17_02_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_17_02_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_17_03_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_17_03_world.sql
index c4b1a923945..c4b1a923945 100644
--- a/sql/updates/world/3.3.5/2019_07_17_03_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_17_03_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_17_04_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_17_04_world.sql
index 98d2594c0ad..98d2594c0ad 100644
--- a/sql/updates/world/3.3.5/2019_07_17_04_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_17_04_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_17_05_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_17_05_world.sql
index a1f5bf5e119..a1f5bf5e119 100644
--- a/sql/updates/world/3.3.5/2019_07_17_05_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_17_05_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_17_06_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_17_06_world.sql
index dd145469e3d..dd145469e3d 100644
--- a/sql/updates/world/3.3.5/2019_07_17_06_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_17_06_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_17_07_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_17_07_world.sql
index f6b9ff3d219..f6b9ff3d219 100644
--- a/sql/updates/world/3.3.5/2019_07_17_07_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_17_07_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_17_08_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_17_08_world.sql
index 95177a02e13..95177a02e13 100644
--- a/sql/updates/world/3.3.5/2019_07_17_08_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_17_08_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_18_00_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_18_00_world.sql
index 32a404c070e..32a404c070e 100644
--- a/sql/updates/world/3.3.5/2019_07_18_00_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_18_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_19_00_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_19_00_world.sql
index 9c34d0fefac..9c34d0fefac 100644
--- a/sql/updates/world/3.3.5/2019_07_19_00_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_19_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_19_01_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_19_01_world.sql
index 5926ebafc18..5926ebafc18 100644
--- a/sql/updates/world/3.3.5/2019_07_19_01_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_19_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_19_02_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_19_02_world.sql
index 91b0048d81c..91b0048d81c 100644
--- a/sql/updates/world/3.3.5/2019_07_19_02_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_19_02_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_19_03_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_19_03_world.sql
index 55a9945a16d..55a9945a16d 100644
--- a/sql/updates/world/3.3.5/2019_07_19_03_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_19_03_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_19_04_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_19_04_world.sql
index b606b9bbaf7..b606b9bbaf7 100644
--- a/sql/updates/world/3.3.5/2019_07_19_04_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_19_04_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_20_00_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_20_00_world.sql
index 17c463e9c4d..17c463e9c4d 100644
--- a/sql/updates/world/3.3.5/2019_07_20_00_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_20_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_20_01_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_20_01_world.sql
index 92dd3d8ed79..92dd3d8ed79 100644
--- a/sql/updates/world/3.3.5/2019_07_20_01_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_20_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_20_02_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_20_02_world.sql
index bb49309917f..bb49309917f 100644
--- a/sql/updates/world/3.3.5/2019_07_20_02_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_20_02_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_20_03_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_20_03_world.sql
index 6c0df98229a..6c0df98229a 100644
--- a/sql/updates/world/3.3.5/2019_07_20_03_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_20_03_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_20_04_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_20_04_world.sql
index f8f39a4ca8b..f8f39a4ca8b 100644
--- a/sql/updates/world/3.3.5/2019_07_20_04_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_20_04_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_20_05_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_20_05_world.sql
index d6d7ac2fb8f..d6d7ac2fb8f 100644
--- a/sql/updates/world/3.3.5/2019_07_20_05_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_20_05_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_20_06_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_20_06_world.sql
index 942e2b7a9cc..942e2b7a9cc 100644
--- a/sql/updates/world/3.3.5/2019_07_20_06_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_20_06_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_20_07_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_20_07_world.sql
index 4e508602626..4e508602626 100644
--- a/sql/updates/world/3.3.5/2019_07_20_07_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_20_07_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_20_08_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_20_08_world.sql
index 12d5eb97aa3..12d5eb97aa3 100644
--- a/sql/updates/world/3.3.5/2019_07_20_08_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_20_08_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_20_09_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_20_09_world.sql
index 6c76d16a2f7..6c76d16a2f7 100644
--- a/sql/updates/world/3.3.5/2019_07_20_09_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_20_09_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_21_00_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_21_00_world.sql
index ac660a40a61..ac660a40a61 100644
--- a/sql/updates/world/3.3.5/2019_07_21_00_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_21_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_21_01_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_21_01_world.sql
index 7b6de70c1e1..7b6de70c1e1 100644
--- a/sql/updates/world/3.3.5/2019_07_21_01_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_21_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_21_02_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_21_02_world.sql
index f1ea4065f50..f1ea4065f50 100644
--- a/sql/updates/world/3.3.5/2019_07_21_02_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_21_02_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_22_00_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_22_00_world.sql
index cd66f1f0174..cd66f1f0174 100644
--- a/sql/updates/world/3.3.5/2019_07_22_00_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_22_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_22_01_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_22_01_world.sql
index 9b9d71acfab..9b9d71acfab 100644
--- a/sql/updates/world/3.3.5/2019_07_22_01_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_22_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_22_02_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_22_02_world.sql
index 0d4281062cb..0d4281062cb 100644
--- a/sql/updates/world/3.3.5/2019_07_22_02_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_22_02_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_22_03_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_22_03_world.sql
index 63f3b889251..63f3b889251 100644
--- a/sql/updates/world/3.3.5/2019_07_22_03_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_22_03_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_22_04_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_22_04_world.sql
index a64413edb98..a64413edb98 100644
--- a/sql/updates/world/3.3.5/2019_07_22_04_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_22_04_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_22_05_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_22_05_world.sql
index 08e68686132..08e68686132 100644
--- a/sql/updates/world/3.3.5/2019_07_22_05_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_22_05_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_22_06_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_22_06_world.sql
index 0403377ac52..0403377ac52 100644
--- a/sql/updates/world/3.3.5/2019_07_22_06_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_22_06_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_23_00_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_23_00_world.sql
index 56736846bd2..56736846bd2 100644
--- a/sql/updates/world/3.3.5/2019_07_23_00_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_23_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_23_01_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_23_01_world.sql
index a1f919ea158..a1f919ea158 100644
--- a/sql/updates/world/3.3.5/2019_07_23_01_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_23_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_23_02_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_23_02_world.sql
index 7aa02b13777..7aa02b13777 100644
--- a/sql/updates/world/3.3.5/2019_07_23_02_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_23_02_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_23_03_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_23_03_world.sql
index 44afc530244..44afc530244 100644
--- a/sql/updates/world/3.3.5/2019_07_23_03_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_23_03_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_23_04_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_23_04_world.sql
index f73fd2ea302..f73fd2ea302 100644
--- a/sql/updates/world/3.3.5/2019_07_23_04_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_23_04_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_23_05_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_23_05_world.sql
index 625c4a4b2eb..625c4a4b2eb 100644
--- a/sql/updates/world/3.3.5/2019_07_23_05_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_23_05_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_24_00_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_24_00_world.sql
index 97d47fd919c..97d47fd919c 100644
--- a/sql/updates/world/3.3.5/2019_07_24_00_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_24_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_24_01_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_24_01_world.sql
index a9145fbf3d0..a9145fbf3d0 100644
--- a/sql/updates/world/3.3.5/2019_07_24_01_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_24_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_25_00_world_335.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_25_00_world_335.sql
index 04c1de08b90..04c1de08b90 100644
--- a/sql/updates/world/3.3.5/2019_07_25_00_world_335.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_25_00_world_335.sql
diff --git a/sql/updates/world/3.3.5/2019_07_25_01_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_25_01_world.sql
index 3b248a6e0ca..3b248a6e0ca 100644
--- a/sql/updates/world/3.3.5/2019_07_25_01_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_25_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_25_02_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_25_02_world.sql
index f0fd7fc4b78..f0fd7fc4b78 100644
--- a/sql/updates/world/3.3.5/2019_07_25_02_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_25_02_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_25_03_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_25_03_world.sql
index 3cf6a925566..3cf6a925566 100644
--- a/sql/updates/world/3.3.5/2019_07_25_03_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_25_03_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_25_04_world_335.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_25_04_world_335.sql
index ff739bf1150..ff739bf1150 100644
--- a/sql/updates/world/3.3.5/2019_07_25_04_world_335.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_25_04_world_335.sql
diff --git a/sql/updates/world/3.3.5/2019_07_25_05_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_25_05_world.sql
index 814c08884d6..814c08884d6 100644
--- a/sql/updates/world/3.3.5/2019_07_25_05_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_25_05_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_25_06_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_25_06_world.sql
index f4d2a88dabf..f4d2a88dabf 100644
--- a/sql/updates/world/3.3.5/2019_07_25_06_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_25_06_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_25_07_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_25_07_world.sql
index 6f6b202d96e..6f6b202d96e 100644
--- a/sql/updates/world/3.3.5/2019_07_25_07_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_25_07_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_25_08_world_335.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_25_08_world_335.sql
index 67b5921457f..67b5921457f 100644
--- a/sql/updates/world/3.3.5/2019_07_25_08_world_335.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_25_08_world_335.sql
diff --git a/sql/updates/world/3.3.5/2019_07_25_09_world_335.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_25_09_world_335.sql
index 2562fe98a05..2562fe98a05 100644
--- a/sql/updates/world/3.3.5/2019_07_25_09_world_335.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_25_09_world_335.sql
diff --git a/sql/updates/world/3.3.5/2019_07_25_10_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_25_10_world.sql
index 66a4937b19c..66a4937b19c 100644
--- a/sql/updates/world/3.3.5/2019_07_25_10_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_25_10_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_25_11_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_25_11_world.sql
index d9573ba9dd4..d9573ba9dd4 100644
--- a/sql/updates/world/3.3.5/2019_07_25_11_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_25_11_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_26_00_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_26_00_world.sql
index 9544e3d0430..9544e3d0430 100644
--- a/sql/updates/world/3.3.5/2019_07_26_00_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_26_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_26_01_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_26_01_world.sql
index 7448e0a4cd9..7448e0a4cd9 100644
--- a/sql/updates/world/3.3.5/2019_07_26_01_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_26_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_27_00_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_27_00_world.sql
index b16db23f30b..b16db23f30b 100644
--- a/sql/updates/world/3.3.5/2019_07_27_00_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_27_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_27_01_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_27_01_world.sql
index 17f4d3bb597..17f4d3bb597 100644
--- a/sql/updates/world/3.3.5/2019_07_27_01_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_27_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_28_00_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_28_00_world.sql
index fa71a24fd8f..fa71a24fd8f 100644
--- a/sql/updates/world/3.3.5/2019_07_28_00_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_28_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_28_01_world_335.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_28_01_world_335.sql
index a91e8c3c798..a91e8c3c798 100644
--- a/sql/updates/world/3.3.5/2019_07_28_01_world_335.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_28_01_world_335.sql
diff --git a/sql/updates/world/3.3.5/2019_07_28_02_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_28_02_world.sql
index 14352073dd8..14352073dd8 100644
--- a/sql/updates/world/3.3.5/2019_07_28_02_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_28_02_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_28_03_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_28_03_world.sql
index e65fe43aa28..e65fe43aa28 100644
--- a/sql/updates/world/3.3.5/2019_07_28_03_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_28_03_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_28_04_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_28_04_world.sql
index 86cb0a3d6f7..86cb0a3d6f7 100644
--- a/sql/updates/world/3.3.5/2019_07_28_04_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_28_04_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_28_05_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_28_05_world.sql
index 431b37b1707..431b37b1707 100644
--- a/sql/updates/world/3.3.5/2019_07_28_05_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_28_05_world.sql
diff --git a/sql/updates/world/3.3.5/2019_07_30_00_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_30_00_world.sql
index aa3f44396b8..aa3f44396b8 100644
--- a/sql/updates/world/3.3.5/2019_07_30_00_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_07_30_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_08_01_00_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_01_00_world.sql
index f8e082bbe20..f8e082bbe20 100644
--- a/sql/updates/world/3.3.5/2019_08_01_00_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_01_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_08_02_00_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_02_00_world.sql
index 8dd7a159d85..8dd7a159d85 100644
--- a/sql/updates/world/3.3.5/2019_08_02_00_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_02_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_08_02_01_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_02_01_world.sql
index 3d472cae16d..3d472cae16d 100644
--- a/sql/updates/world/3.3.5/2019_08_02_01_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_02_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_08_02_02_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_02_02_world.sql
index e7ce85498b2..e7ce85498b2 100644
--- a/sql/updates/world/3.3.5/2019_08_02_02_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_02_02_world.sql
diff --git a/sql/updates/world/3.3.5/2019_08_02_03_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_02_03_world.sql
index a4ea5908c8e..a4ea5908c8e 100644
--- a/sql/updates/world/3.3.5/2019_08_02_03_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_02_03_world.sql
diff --git a/sql/updates/world/3.3.5/2019_08_02_04_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_02_04_world.sql
index 5af97dbaf14..5af97dbaf14 100644
--- a/sql/updates/world/3.3.5/2019_08_02_04_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_02_04_world.sql
diff --git a/sql/updates/world/3.3.5/2019_08_02_05_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_02_05_world.sql
index a22cd3cd372..a22cd3cd372 100644
--- a/sql/updates/world/3.3.5/2019_08_02_05_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_02_05_world.sql
diff --git a/sql/updates/world/3.3.5/2019_08_03_00_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_03_00_world.sql
index f71e3fc19da..f71e3fc19da 100644
--- a/sql/updates/world/3.3.5/2019_08_03_00_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_03_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_08_03_01_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_03_01_world.sql
index 48d2d717146..48d2d717146 100644
--- a/sql/updates/world/3.3.5/2019_08_03_01_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_03_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_08_03_02_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_03_02_world.sql
index fb53ba88889..fb53ba88889 100644
--- a/sql/updates/world/3.3.5/2019_08_03_02_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_03_02_world.sql
diff --git a/sql/updates/world/3.3.5/2019_08_03_03_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_03_03_world.sql
index dc0f36e34c4..dc0f36e34c4 100644
--- a/sql/updates/world/3.3.5/2019_08_03_03_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_03_03_world.sql
diff --git a/sql/updates/world/3.3.5/2019_08_03_04_world_335.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_03_04_world_335.sql
index b75474a9090..b75474a9090 100644
--- a/sql/updates/world/3.3.5/2019_08_03_04_world_335.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_03_04_world_335.sql
diff --git a/sql/updates/world/3.3.5/2019_08_03_05_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_03_05_world.sql
index 7848ba0f6fd..7848ba0f6fd 100644
--- a/sql/updates/world/3.3.5/2019_08_03_05_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_03_05_world.sql
diff --git a/sql/updates/world/3.3.5/2019_08_03_06_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_03_06_world.sql
index 2891ed41734..2891ed41734 100644
--- a/sql/updates/world/3.3.5/2019_08_03_06_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_03_06_world.sql
diff --git a/sql/updates/world/3.3.5/2019_08_03_07_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_03_07_world.sql
index ad3fe6aa224..ad3fe6aa224 100644
--- a/sql/updates/world/3.3.5/2019_08_03_07_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_03_07_world.sql
diff --git a/sql/updates/world/3.3.5/2019_08_03_08_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_03_08_world.sql
index 82cef9c96ee..82cef9c96ee 100644
--- a/sql/updates/world/3.3.5/2019_08_03_08_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_03_08_world.sql
diff --git a/sql/updates/world/3.3.5/2019_08_03_09_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_03_09_world.sql
index 478e2bdb383..478e2bdb383 100644
--- a/sql/updates/world/3.3.5/2019_08_03_09_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_03_09_world.sql
diff --git a/sql/updates/world/3.3.5/2019_08_04_00_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_04_00_world.sql
index 2c82d1d2491..2c82d1d2491 100644
--- a/sql/updates/world/3.3.5/2019_08_04_00_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_04_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_08_04_01_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_04_01_world.sql
index b51b60abf38..b51b60abf38 100644
--- a/sql/updates/world/3.3.5/2019_08_04_01_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_04_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_08_04_02_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_04_02_world.sql
index a591f92e8db..a591f92e8db 100644
--- a/sql/updates/world/3.3.5/2019_08_04_02_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_04_02_world.sql
diff --git a/sql/updates/world/3.3.5/2019_08_04_03_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_04_03_world.sql
index 84eca3113ee..84eca3113ee 100644
--- a/sql/updates/world/3.3.5/2019_08_04_03_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_04_03_world.sql
diff --git a/sql/updates/world/3.3.5/2019_08_04_04_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_04_04_world.sql
index c919422cb27..c919422cb27 100644
--- a/sql/updates/world/3.3.5/2019_08_04_04_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_04_04_world.sql
diff --git a/sql/updates/world/3.3.5/2019_08_05_00_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_05_00_world.sql
index fe01936dcaf..fe01936dcaf 100644
--- a/sql/updates/world/3.3.5/2019_08_05_00_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_05_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_08_05_01_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_05_01_world.sql
index aed40d7ddd2..aed40d7ddd2 100644
--- a/sql/updates/world/3.3.5/2019_08_05_01_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_05_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_08_05_02_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_05_02_world.sql
index 2020a521c03..2020a521c03 100644
--- a/sql/updates/world/3.3.5/2019_08_05_02_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_05_02_world.sql
diff --git a/sql/updates/world/3.3.5/2019_08_05_03_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_05_03_world.sql
index cb76bfe7245..cb76bfe7245 100644
--- a/sql/updates/world/3.3.5/2019_08_05_03_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_05_03_world.sql
diff --git a/sql/updates/world/3.3.5/2019_08_05_04_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_05_04_world.sql
index b9ccf69d3ed..b9ccf69d3ed 100644
--- a/sql/updates/world/3.3.5/2019_08_05_04_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_05_04_world.sql
diff --git a/sql/updates/world/3.3.5/2019_08_05_05_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_05_05_world.sql
index e8816141490..e8816141490 100644
--- a/sql/updates/world/3.3.5/2019_08_05_05_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_05_05_world.sql
diff --git a/sql/updates/world/3.3.5/2019_08_05_06_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_05_06_world.sql
index 2a4f5b8bbcc..2a4f5b8bbcc 100644
--- a/sql/updates/world/3.3.5/2019_08_05_06_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_05_06_world.sql
diff --git a/sql/updates/world/3.3.5/2019_08_06_00_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_06_00_world.sql
index 2c2c8dff69c..2c2c8dff69c 100644
--- a/sql/updates/world/3.3.5/2019_08_06_00_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_06_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_08_06_01_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_06_01_world.sql
index 2f42367fc48..2f42367fc48 100644
--- a/sql/updates/world/3.3.5/2019_08_06_01_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_06_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_08_06_02_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_06_02_world.sql
index 21231e5800a..21231e5800a 100644
--- a/sql/updates/world/3.3.5/2019_08_06_02_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_06_02_world.sql
diff --git a/sql/updates/world/3.3.5/2019_08_06_03_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_06_03_world.sql
index 951e4988e11..951e4988e11 100644
--- a/sql/updates/world/3.3.5/2019_08_06_03_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_06_03_world.sql
diff --git a/sql/updates/world/3.3.5/2019_08_06_04_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_06_04_world.sql
index 650d1272b8c..650d1272b8c 100644
--- a/sql/updates/world/3.3.5/2019_08_06_04_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_06_04_world.sql
diff --git a/sql/updates/world/3.3.5/2019_08_06_05_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_06_05_world.sql
index 591d7564c3e..591d7564c3e 100644
--- a/sql/updates/world/3.3.5/2019_08_06_05_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_06_05_world.sql
diff --git a/sql/updates/world/3.3.5/2019_08_08_00_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_08_00_world.sql
index aaaca865404..aaaca865404 100644
--- a/sql/updates/world/3.3.5/2019_08_08_00_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_08_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_08_08_01_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_08_01_world.sql
index 1f4ccd75359..1f4ccd75359 100644
--- a/sql/updates/world/3.3.5/2019_08_08_01_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_08_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_08_10_00_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_10_00_world.sql
index 4708a4965b2..4708a4965b2 100644
--- a/sql/updates/world/3.3.5/2019_08_10_00_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_10_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_08_10_01_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_10_01_world.sql
index 5ce0c1829fd..5ce0c1829fd 100644
--- a/sql/updates/world/3.3.5/2019_08_10_01_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_10_01_world.sql
diff --git a/sql/updates/world/3.3.5/2019_08_12_00_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_12_00_world.sql
index 21c47556c7d..21c47556c7d 100644
--- a/sql/updates/world/3.3.5/2019_08_12_00_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_12_00_world.sql
diff --git a/sql/updates/world/3.3.5/2019_08_15_00_world.sql b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_15_00_world.sql
index a15c00b4e93..a15c00b4e93 100644
--- a/sql/updates/world/3.3.5/2019_08_15_00_world.sql
+++ b/sql/old/3.3.5a/world/19071_2019_08_16/2019_08_15_00_world.sql
diff --git a/sql/updates/auth/3.3.5/2019_08_16_00_auth.sql b/sql/updates/auth/3.3.5/2019_08_16_00_auth.sql
new file mode 100644
index 00000000000..6544c316449
--- /dev/null
+++ b/sql/updates/auth/3.3.5/2019_08_16_00_auth.sql
@@ -0,0 +1,2 @@
+-- TDB 335.19081 auth
+UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/updates/characters/3.3.5/2019_08_16_00_characters.sql b/sql/updates/characters/3.3.5/2019_08_16_00_characters.sql
new file mode 100644
index 00000000000..5d9a26ec653
--- /dev/null
+++ b/sql/updates/characters/3.3.5/2019_08_16_00_characters.sql
@@ -0,0 +1,2 @@
+-- TDB 335.19081 characters
+UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/updates/world/3.3.5/2019_08_16_00_world.sql b/sql/updates/world/3.3.5/2019_08_16_00_world.sql
new file mode 100644
index 00000000000..7cb4c1c9abb
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_08_16_00_world.sql
@@ -0,0 +1,3 @@
+-- TDB 335.19081 world
+UPDATE `version` SET `db_version`='TDB 335.19081', `cache_id`=19081 LIMIT 1;
+UPDATE `updates` SET `state`='ARCHIVED';