-
Notifications
You must be signed in to change notification settings - Fork 13
/
2_Add_NewLocalisationFields.sql
115 lines (101 loc) · 6.6 KB
/
2_Add_NewLocalisationFields.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
ALTER TABLE `locales_achievement_reward`
ADD COLUMN `subject_loc0` VARCHAR(255) NOT NULL AFTER `gender`,
ADD COLUMN `subject_loc9` VARCHAR(255) NOT NULL AFTER `subject_loc8`,
ADD COLUMN `text_loc0` TEXT NOT NULL AFTER `subject_loc9`,
ADD COLUMN `text_loc9` TEXT NOT NULL AFTER `text_loc8`;
ALTER TABLE `locales_command`
ADD COLUMN `help_text_loc0` LONGTEXT AFTER `id`,
ADD COLUMN `help_text_loc9` LONGTEXT AFTER `help_text_loc8`;
ALTER TABLE `locales_creature`
ADD COLUMN `name_loc0` VARCHAR(100) NOT NULL DEFAULT '' AFTER `entry`,
ADD COLUMN `name_loc9` VARCHAR(100) AFTER `name_loc8`,
ADD COLUMN `subname_loc0` VARCHAR(100) AFTER `name_loc9`,
ADD COLUMN `subname_loc9` VARCHAR(100) AFTER `subname_loc8`;
ALTER TABLE `creature_ai_texts`
ADD COLUMN `content_loc0` TEXT AFTER `content_default`,
ADD COLUMN `content_loc9` TEXT AFTER `content_loc8`;
ALTER TABLE `db_script_string`
ADD COLUMN `content_loc0` TEXT AFTER `content_default`,
ADD COLUMN `content_loc9` TEXT AFTER `content_loc8`;
ALTER TABLE `gossip_texts`
ADD COLUMN `content_loc0` TEXT AFTER `content_default`,
ADD COLUMN `content_loc9` TEXT AFTER `content_loc8`;
ALTER TABLE `mangos_string`
ADD COLUMN `content_loc0` TEXT AFTER `content_default`,
ADD COLUMN `content_loc9` TEXT AFTER `content_loc8`;
ALTER TABLE `script_texts`
ADD COLUMN `content_loc0` TEXT AFTER `content_default`,
ADD COLUMN `content_loc9` TEXT AFTER `content_loc8`;
ALTER TABLE `locales_item`
ADD COLUMN `name_loc0` VARCHAR(100) NOT NULL DEFAULT '' AFTER `entry`,
ADD COLUMN `name_loc9` VARCHAR(100) AFTER `name_loc8`,
ADD COLUMN `description_loc0` VARCHAR(255) AFTER `name_loc9`,
ADD COLUMN `description_loc9` VARCHAR(255) AFTER `description_loc8`;
ALTER TABLE `locales_gameobject`
ADD COLUMN `name_loc0` VARCHAR(100) NOT NULL DEFAULT '' AFTER `entry`,
ADD COLUMN `name_loc9` VARCHAR(100) NOT NULL DEFAULT '' AFTER `name_loc8`;
ALTER TABLE `locales_gossip_menu_option`
ADD COLUMN `option_text_loc0` TEXT AFTER `id`,
ADD COLUMN `option_text_loc9` TEXT AFTER `option_text_loc8`,
ADD COLUMN `box_text_loc0` TEXT AFTER `option_text_loc9`,
ADD COLUMN `box_text_loc9` TEXT AFTER `box_text_loc8`;
ALTER TABLE `locales_npc_text`
ADD COLUMN `Text0_0_loc0` LONGTEXT AFTER `entry`,
ADD COLUMN `Text0_0_loc9` LONGTEXT AFTER `Text0_0_loc8`,
ADD COLUMN `Text0_1_loc0` LONGTEXT AFTER `Text0_0_loc9`,
ADD COLUMN `Text0_1_loc9` LONGTEXT AFTER `Text0_1_loc8`,
ADD COLUMN `Text1_0_loc0` LONGTEXT AFTER `Text0_1_loc9`,
ADD COLUMN `Text1_0_loc9` LONGTEXT AFTER `Text1_0_loc8`,
ADD COLUMN `Text1_1_loc0` LONGTEXT AFTER `Text1_0_loc9`,
ADD COLUMN `Text1_1_loc9` LONGTEXT AFTER `Text1_1_loc8`,
ADD COLUMN `Text2_0_loc0` LONGTEXT AFTER `Text1_1_loc9`,
ADD COLUMN `Text2_0_loc9` LONGTEXT AFTER `Text2_0_loc8`,
ADD COLUMN `Text2_1_loc0` LONGTEXT AFTER `Text2_0_loc9`,
ADD COLUMN `Text2_1_loc9` LONGTEXT AFTER `Text2_1_loc8`,
ADD COLUMN `Text3_0_loc0` LONGTEXT AFTER `Text2_1_loc9`,
ADD COLUMN `Text3_0_loc9` LONGTEXT AFTER `Text3_0_loc8`,
ADD COLUMN `Text3_1_loc0` LONGTEXT AFTER `Text3_0_loc9`,
ADD COLUMN `Text3_1_loc9` LONGTEXT AFTER `Text3_1_loc8`,
ADD COLUMN `Text4_0_loc0` LONGTEXT AFTER `Text3_1_loc9`,
ADD COLUMN `Text4_0_loc9` LONGTEXT AFTER `Text4_0_loc8`,
ADD COLUMN `Text4_1_loc0` LONGTEXT AFTER `Text4_0_loc9`,
ADD COLUMN `Text4_1_loc9` LONGTEXT AFTER `Text4_1_loc8`,
ADD COLUMN `Text5_0_loc0` LONGTEXT AFTER `Text4_1_loc9`,
ADD COLUMN `Text5_0_loc9` LONGTEXT AFTER `Text5_0_loc8`,
ADD COLUMN `Text5_1_loc0` LONGTEXT AFTER `Text5_0_loc9`,
ADD COLUMN `Text5_1_loc9` LONGTEXT AFTER `Text5_1_loc8`,
ADD COLUMN `Text6_0_loc0` LONGTEXT AFTER `Text5_1_loc9`,
ADD COLUMN `Text6_0_loc9` LONGTEXT AFTER `Text6_0_loc8`,
ADD COLUMN `Text6_1_loc0` LONGTEXT AFTER `Text6_0_loc9`,
ADD COLUMN `Text6_1_loc9` LONGTEXT AFTER `Text6_1_loc8`,
ADD COLUMN `Text7_0_loc0` LONGTEXT AFTER `Text6_1_loc9`,
ADD COLUMN `Text7_0_loc9` LONGTEXT AFTER `Text7_0_loc8`,
ADD COLUMN `Text7_1_loc0` LONGTEXT AFTER `Text7_0_loc9`,
ADD COLUMN `Text7_1_loc9` LONGTEXT AFTER `Text7_1_loc8`;
ALTER TABLE `locales_page_text`
ADD COLUMN `Text_loc0` LONGTEXT AFTER `entry`,
ADD COLUMN `Text_loc9` LONGTEXT AFTER `Text_loc8`;
ALTER TABLE `locales_points_of_interest`
ADD COLUMN `icon_name_loc0` TEXT AFTER `entry`,
ADD COLUMN `icon_name_loc9` TEXT AFTER `icon_name_loc8`;
ALTER TABLE `locales_quest`
ADD COLUMN `Title_loc0` LONGTEXT AFTER `entry`,
ADD COLUMN `Title_loc9` LONGTEXT AFTER `Title_loc8`,
ADD COLUMN `Details_loc0` LONGTEXT AFTER Title_loc9,
ADD COLUMN `Details_loc9` LONGTEXT AFTER `Details_loc8`,
ADD COLUMN `Objectives_loc0` LONGTEXT AFTER `Details_loc9`,
ADD COLUMN `Objectives_loc9` LONGTEXT AFTER `Objectives_loc8`,
ADD COLUMN `OfferRewardText_loc0` LONGTEXT AFTER `Objectives_loc9`,
ADD COLUMN `OfferRewardText_loc9` LONGTEXT AFTER `OfferRewardText_loc8`,
ADD COLUMN `RequestItemsText_loc0` LONGTEXT AFTER `OfferRewardText_loc9`,
ADD COLUMN `RequestItemsText_loc9` LONGTEXT AFTER `RequestItemsText_loc8`,
ADD COLUMN `EndText_loc0` LONGTEXT AFTER `RequestItemsText_loc9`,
ADD COLUMN `EndText_loc9` LONGTEXT AFTER `EndText_loc8`,
ADD COLUMN `ObjectiveText1_loc0` LONGTEXT AFTER `EndText_loc9`,
ADD COLUMN `ObjectiveText1_loc9` LONGTEXT AFTER `ObjectiveText1_loc8`,
ADD COLUMN `ObjectiveText2_loc0` LONGTEXT AFTER `ObjectiveText1_loc9`,
ADD COLUMN `ObjectiveText2_loc9` LONGTEXT AFTER `ObjectiveText2_loc8`,
ADD COLUMN `ObjectiveText3_loc0` LONGTEXT AFTER `ObjectiveText2_loc9`,
ADD COLUMN `ObjectiveText3_loc9` LONGTEXT AFTER `ObjectiveText3_loc8`,
ADD COLUMN `ObjectiveText4_loc0` LONGTEXT AFTER `ObjectiveText3_loc9`,
ADD COLUMN `ObjectiveText4_loc9` LONGTEXT AFTER `ObjectiveText4_loc8`;