/
DropTriggers.sql
337 lines (336 loc) · 17.6 KB
/
DropTriggers.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
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
-- Automatically generated, do not edit.
\unset ON_ERROR_STOP
DROP TRIGGER b_upd_area ON area;
DROP TRIGGER b_upd_area_alias ON area_alias;
DROP TRIGGER b_upd_area_tag ON area_tag;
DROP TRIGGER unique_primary_for_locale ON area_alias;
DROP TRIGGER search_hint ON area_alias;
DROP TRIGGER end_date_implies_ended ON area_alias;
DROP TRIGGER end_date_implies_ended ON area;
DROP TRIGGER a_ins_artist ON artist;
DROP TRIGGER b_upd_artist ON artist;
DROP TRIGGER b_upd_artist_credit_name ON artist_credit_name;
DROP TRIGGER b_del_artist_special ON artist;
DROP TRIGGER end_area_implies_ended ON artist;
DROP TRIGGER end_date_implies_ended ON artist;
DROP TRIGGER end_date_implies_ended ON artist_alias;
DROP TRIGGER b_upd_artist_alias ON artist_alias;
DROP TRIGGER replace_old_sub_on_add ON editor_subscribe_collection;
DROP TRIGGER del_collection_sub_on_delete ON editor_collection;
DROP TRIGGER del_collection_sub_on_private ON editor_collection;
DROP TRIGGER unique_primary_for_locale ON artist_alias;
DROP TRIGGER search_hint ON artist_alias;
DROP TRIGGER b_upd_artist_tag ON artist_tag;
DROP TRIGGER b_upd_editor ON editor;
DROP TRIGGER a_ins_editor ON editor;
DROP TRIGGER check_editor_name ON editor;
DROP TRIGGER a_ins_event ON event;
DROP TRIGGER b_upd_event ON event;
DROP TRIGGER end_date_implies_ended ON event;
DROP TRIGGER b_upd_event_alias ON event_alias;
DROP TRIGGER end_date_implies_ended ON event_alias;
DROP TRIGGER unique_primary_for_locale ON event_alias;
DROP TRIGGER search_hint ON event_alias;
DROP TRIGGER b_upd_event_tag ON event_tag;
DROP TRIGGER b_upd_genre ON genre;
DROP TRIGGER b_upd_genre_alias ON genre_alias;
DROP TRIGGER unique_primary_for_locale ON genre_alias;
DROP TRIGGER b_upd_instrument ON instrument;
DROP TRIGGER end_date_implies_ended ON instrument_alias;
DROP TRIGGER b_upd_instrument_alias ON instrument_alias;
DROP TRIGGER b_upd_instrument_tag ON instrument_tag;
DROP TRIGGER unique_primary_for_locale ON instrument_alias;
DROP TRIGGER search_hint ON instrument_alias;
DROP TRIGGER b_upd_l_area_area ON l_area_area;
DROP TRIGGER b_upd_l_area_artist ON l_area_artist;
DROP TRIGGER b_upd_l_area_event ON l_area_event;
DROP TRIGGER b_upd_l_area_instrument ON l_area_instrument;
DROP TRIGGER b_upd_l_area_label ON l_area_label;
DROP TRIGGER b_upd_l_area_place ON l_area_place;
DROP TRIGGER b_upd_l_area_recording ON l_area_recording;
DROP TRIGGER b_upd_l_area_release ON l_area_release;
DROP TRIGGER b_upd_l_area_release_group ON l_area_release_group;
DROP TRIGGER b_upd_l_area_url ON l_area_url;
DROP TRIGGER b_upd_l_area_work ON l_area_work;
DROP TRIGGER b_upd_l_artist_artist ON l_artist_artist;
DROP TRIGGER b_upd_l_artist_event ON l_artist_event;
DROP TRIGGER b_upd_l_artist_instrument ON l_artist_instrument;
DROP TRIGGER b_upd_l_artist_label ON l_artist_label;
DROP TRIGGER b_upd_l_artist_place ON l_artist_place;
DROP TRIGGER b_upd_l_artist_recording ON l_artist_recording;
DROP TRIGGER b_upd_l_artist_release ON l_artist_release;
DROP TRIGGER b_upd_l_artist_release_group ON l_artist_release_group;
DROP TRIGGER b_upd_l_artist_url ON l_artist_url;
DROP TRIGGER b_upd_l_artist_work ON l_artist_work;
DROP TRIGGER b_upd_l_event_event ON l_event_event;
DROP TRIGGER b_upd_l_event_instrument ON l_event_instrument;
DROP TRIGGER b_upd_l_event_label ON l_event_label;
DROP TRIGGER b_upd_l_event_place ON l_event_place;
DROP TRIGGER b_upd_l_event_recording ON l_event_recording;
DROP TRIGGER b_upd_l_event_release ON l_event_release;
DROP TRIGGER b_upd_l_event_release_group ON l_event_release_group;
DROP TRIGGER b_upd_l_event_url ON l_event_url;
DROP TRIGGER b_upd_l_event_work ON l_event_work;
DROP TRIGGER b_upd_l_instrument_instrument ON l_instrument_instrument;
DROP TRIGGER b_upd_l_instrument_label ON l_instrument_label;
DROP TRIGGER b_upd_l_instrument_place ON l_instrument_place;
DROP TRIGGER b_upd_l_instrument_recording ON l_instrument_recording;
DROP TRIGGER b_upd_l_instrument_release ON l_instrument_release;
DROP TRIGGER b_upd_l_instrument_release_group ON l_instrument_release_group;
DROP TRIGGER b_upd_l_instrument_url ON l_instrument_url;
DROP TRIGGER b_upd_l_instrument_work ON l_instrument_work;
DROP TRIGGER b_upd_l_label_label ON l_label_label;
DROP TRIGGER b_upd_l_label_place ON l_label_place;
DROP TRIGGER b_upd_l_label_recording ON l_label_recording;
DROP TRIGGER b_upd_l_label_release ON l_label_release;
DROP TRIGGER b_upd_l_label_release_group ON l_label_release_group;
DROP TRIGGER b_upd_l_label_url ON l_label_url;
DROP TRIGGER b_upd_l_label_work ON l_label_work;
DROP TRIGGER b_upd_l_place_place ON l_place_place;
DROP TRIGGER b_upd_l_place_recording ON l_place_recording;
DROP TRIGGER b_upd_l_place_release ON l_place_release;
DROP TRIGGER b_upd_l_place_release_group ON l_place_release_group;
DROP TRIGGER b_upd_l_place_url ON l_place_url;
DROP TRIGGER b_upd_l_place_work ON l_place_work;
DROP TRIGGER b_upd_l_recording_recording ON l_recording_recording;
DROP TRIGGER b_upd_l_recording_release ON l_recording_release;
DROP TRIGGER b_upd_l_recording_release_group ON l_recording_release_group;
DROP TRIGGER b_upd_l_recording_url ON l_recording_url;
DROP TRIGGER b_upd_l_recording_work ON l_recording_work;
DROP TRIGGER b_upd_l_release_release ON l_release_release;
DROP TRIGGER b_upd_l_release_release_group ON l_release_release_group;
DROP TRIGGER b_upd_l_release_url ON l_release_url;
DROP TRIGGER b_upd_l_release_work ON l_release_work;
DROP TRIGGER b_upd_l_release_group_release_group ON l_release_group_release_group;
DROP TRIGGER b_upd_l_release_group_url ON l_release_group_url;
DROP TRIGGER b_upd_l_release_group_work ON l_release_group_work;
DROP TRIGGER b_upd_l_url_url ON l_url_url;
DROP TRIGGER b_upd_l_url_work ON l_url_work;
DROP TRIGGER b_upd_l_work_work ON l_work_work;
DROP TRIGGER a_ins_label ON label;
DROP TRIGGER b_del_label_special ON label;
DROP TRIGGER b_upd_label ON label;
DROP TRIGGER end_date_implies_ended ON label;
DROP TRIGGER end_date_implies_ended ON label_alias;
DROP TRIGGER b_upd_label_alias ON label_alias;
DROP TRIGGER unique_primary_for_locale ON label_alias;
DROP TRIGGER search_hint ON label_alias;
DROP TRIGGER b_upd_label_tag ON label_tag;
DROP TRIGGER end_date_implies_ended ON link;
DROP TRIGGER deny_deprecated ON link;
DROP TRIGGER check_has_dates ON link;
DROP TRIGGER b_upd_link_attribute ON link_attribute;
DROP TRIGGER b_upd_link_attribute_type ON link_attribute_type;
DROP TRIGGER b_upd_link_type ON link_type;
DROP TRIGGER b_upd_link_type_attribute_type ON link_type_attribute_type;
DROP TRIGGER b_upd_medium ON medium;
DROP TRIGGER b_upd_medium_cdtoc ON medium_cdtoc;
DROP TRIGGER a_ins_place ON place;
DROP TRIGGER b_upd_place ON place;
DROP TRIGGER end_date_implies_ended ON place;
DROP TRIGGER end_date_implies_ended ON place_alias;
DROP TRIGGER b_upd_place_alias ON place_alias;
DROP TRIGGER unique_primary_for_locale ON place_alias;
DROP TRIGGER search_hint ON place_alias;
DROP TRIGGER b_upd_place_tag ON place_tag;
DROP TRIGGER a_ins_recording ON recording;
DROP TRIGGER b_upd_recording ON recording;
DROP TRIGGER a_upd_recording ON recording;
DROP TRIGGER a_del_recording ON recording;
DROP TRIGGER end_date_implies_ended ON recording_alias;
DROP TRIGGER b_upd_recording_alias ON recording_alias;
DROP TRIGGER unique_primary_for_locale ON recording_alias;
DROP TRIGGER search_hint ON recording_alias;
DROP TRIGGER b_upd_recording_tag ON recording_tag;
DROP TRIGGER a_ins_release ON release;
DROP TRIGGER a_upd_release ON release;
DROP TRIGGER a_del_release ON release;
DROP TRIGGER b_upd_release ON release;
DROP TRIGGER end_date_implies_ended ON release_alias;
DROP TRIGGER b_upd_release_alias ON release_alias;
DROP TRIGGER unique_primary_for_locale ON release_alias;
DROP TRIGGER search_hint ON release_alias;
DROP TRIGGER a_ins_release_event ON release_country;
DROP TRIGGER a_upd_release_event ON release_country;
DROP TRIGGER a_del_release_event ON release_country;
DROP TRIGGER a_ins_release_event ON release_unknown_country;
DROP TRIGGER a_upd_release_event ON release_unknown_country;
DROP TRIGGER a_del_release_event ON release_unknown_country;
DROP TRIGGER b_upd_release_label ON release_label;
DROP TRIGGER a_ins_release_label ON release_label;
DROP TRIGGER a_upd_release_label ON release_label;
DROP TRIGGER a_del_release_label ON release_label;
DROP TRIGGER a_ins_release_group ON release_group;
DROP TRIGGER a_upd_release_group ON release_group;
DROP TRIGGER a_del_release_group ON release_group;
DROP TRIGGER b_upd_release_group ON release_group;
DROP TRIGGER a_ins_release_group_secondary_type_join ON release_group_secondary_type_join;
DROP TRIGGER a_del_release_group_secondary_type_join ON release_group_secondary_type_join;
DROP TRIGGER b_upd_release_group_secondary_type_join ON release_group_secondary_type_join;
DROP TRIGGER end_date_implies_ended ON release_group_alias;
DROP TRIGGER b_upd_release_group_alias ON release_group_alias;
DROP TRIGGER unique_primary_for_locale ON release_group_alias;
DROP TRIGGER search_hint ON release_group_alias;
DROP TRIGGER b_upd_release_group_tag ON release_group_tag;
DROP TRIGGER b_upd_series ON series;
DROP TRIGGER b_upd_series_alias ON series_alias;
DROP TRIGGER b_upd_series_tag ON series_tag;
DROP TRIGGER end_date_implies_ended ON series_alias;
DROP TRIGGER unique_primary_for_locale ON series_alias;
DROP TRIGGER search_hint ON series_alias;
DROP TRIGGER b_upd_tag_relation ON tag_relation;
DROP TRIGGER a_ins_track ON track;
DROP TRIGGER a_upd_track ON track;
DROP TRIGGER a_del_track ON track;
DROP TRIGGER b_upd_track ON track;
DROP TRIGGER remove_orphaned_tracks ON track;
DROP TRIGGER b_upd_url ON url;
DROP TRIGGER a_ins_work ON work;
DROP TRIGGER b_upd_work ON work;
DROP TRIGGER b_upd_work_alias ON work_alias;
DROP TRIGGER end_date_implies_ended ON work_alias;
DROP TRIGGER unique_primary_for_locale ON work_alias;
DROP TRIGGER search_hint ON work_alias;
DROP TRIGGER b_upd_work_tag ON work_tag;
DROP TRIGGER inserting_edits_requires_confirmed_email_address ON edit;
DROP TRIGGER a_upd_edit ON edit;
DROP TRIGGER a_ins_edit_artist ON edit_artist;
DROP TRIGGER a_ins_edit_artist ON edit_label;
DROP TRIGGER a_ins_instrument ON instrument;
DROP TRIGGER a_upd_instrument ON instrument;
DROP TRIGGER a_del_instrument ON instrument;
DROP TRIGGER a_ins_edit_note ON edit_note;
DROP TRIGGER a_ins_alternative_release ON alternative_release;
DROP TRIGGER a_ins_alternative_track ON alternative_track;
DROP TRIGGER a_upd_alternative_release ON alternative_release;
DROP TRIGGER a_upd_alternative_track ON alternative_track;
DROP TRIGGER a_del_alternative_release ON alternative_release;
DROP TRIGGER a_del_alternative_track ON alternative_track;
DROP TRIGGER a_ins_alternative_medium_track ON alternative_medium_track;
DROP TRIGGER a_upd_alternative_medium_track ON alternative_medium_track;
DROP TRIGGER a_del_alternative_medium_track ON alternative_medium_track;
DROP TRIGGER ensure_area_attribute_type_allows_text ON area_attribute;
DROP TRIGGER ensure_artist_attribute_type_allows_text ON artist_attribute;
DROP TRIGGER ensure_event_attribute_type_allows_text ON event_attribute;
DROP TRIGGER ensure_instrument_attribute_type_allows_text ON instrument_attribute;
DROP TRIGGER ensure_label_attribute_type_allows_text ON label_attribute;
DROP TRIGGER ensure_medium_attribute_type_allows_text ON medium_attribute;
DROP TRIGGER ensure_place_attribute_type_allows_text ON place_attribute;
DROP TRIGGER ensure_recording_attribute_type_allows_text ON recording_attribute;
DROP TRIGGER ensure_release_attribute_type_allows_text ON release_attribute;
DROP TRIGGER ensure_release_group_attribute_type_allows_text ON release_group_attribute;
DROP TRIGGER ensure_series_attribute_type_allows_text ON series_attribute;
DROP TRIGGER ensure_work_attribute_type_allows_text ON work_attribute;
DROP TRIGGER remove_unused_links ON l_area_area;
DROP TRIGGER remove_unused_links ON l_area_artist;
DROP TRIGGER remove_unused_links ON l_area_event;
DROP TRIGGER remove_unused_links ON l_area_instrument;
DROP TRIGGER remove_unused_links ON l_area_label;
DROP TRIGGER remove_unused_links ON l_area_place;
DROP TRIGGER remove_unused_links ON l_area_recording;
DROP TRIGGER remove_unused_links ON l_area_release;
DROP TRIGGER remove_unused_links ON l_area_release_group;
DROP TRIGGER remove_unused_links ON l_area_url;
DROP TRIGGER remove_unused_links ON l_area_work;
DROP TRIGGER remove_unused_links ON l_artist_artist;
DROP TRIGGER remove_unused_links ON l_artist_event;
DROP TRIGGER remove_unused_links ON l_artist_instrument;
DROP TRIGGER remove_unused_links ON l_artist_label;
DROP TRIGGER remove_unused_links ON l_artist_place;
DROP TRIGGER remove_unused_links ON l_artist_recording;
DROP TRIGGER remove_unused_links ON l_artist_release;
DROP TRIGGER remove_unused_links ON l_artist_release_group;
DROP TRIGGER remove_unused_links ON l_artist_url;
DROP TRIGGER remove_unused_links ON l_artist_work;
DROP TRIGGER remove_unused_links ON l_event_event;
DROP TRIGGER remove_unused_links ON l_event_instrument;
DROP TRIGGER remove_unused_links ON l_event_label;
DROP TRIGGER remove_unused_links ON l_event_place;
DROP TRIGGER remove_unused_links ON l_event_recording;
DROP TRIGGER remove_unused_links ON l_event_release;
DROP TRIGGER remove_unused_links ON l_event_release_group;
DROP TRIGGER remove_unused_links ON l_event_url;
DROP TRIGGER remove_unused_links ON l_event_work;
DROP TRIGGER remove_unused_links ON l_instrument_instrument;
DROP TRIGGER remove_unused_links ON l_instrument_label;
DROP TRIGGER remove_unused_links ON l_instrument_place;
DROP TRIGGER remove_unused_links ON l_instrument_recording;
DROP TRIGGER remove_unused_links ON l_instrument_release;
DROP TRIGGER remove_unused_links ON l_instrument_release_group;
DROP TRIGGER remove_unused_links ON l_instrument_url;
DROP TRIGGER remove_unused_links ON l_instrument_work;
DROP TRIGGER remove_unused_links ON l_label_label;
DROP TRIGGER remove_unused_links ON l_label_place;
DROP TRIGGER remove_unused_links ON l_label_recording;
DROP TRIGGER remove_unused_links ON l_label_release;
DROP TRIGGER remove_unused_links ON l_label_release_group;
DROP TRIGGER remove_unused_links ON l_label_url;
DROP TRIGGER remove_unused_links ON l_label_work;
DROP TRIGGER remove_unused_links ON l_place_place;
DROP TRIGGER remove_unused_links ON l_place_recording;
DROP TRIGGER remove_unused_links ON l_place_release;
DROP TRIGGER remove_unused_links ON l_place_release_group;
DROP TRIGGER remove_unused_links ON l_place_url;
DROP TRIGGER remove_unused_links ON l_place_work;
DROP TRIGGER remove_unused_links ON l_recording_recording;
DROP TRIGGER remove_unused_links ON l_recording_release;
DROP TRIGGER remove_unused_links ON l_recording_release_group;
DROP TRIGGER remove_unused_links ON l_recording_url;
DROP TRIGGER remove_unused_links ON l_recording_work;
DROP TRIGGER remove_unused_links ON l_release_release;
DROP TRIGGER remove_unused_links ON l_release_release_group;
DROP TRIGGER remove_unused_links ON l_release_url;
DROP TRIGGER remove_unused_links ON l_release_work;
DROP TRIGGER remove_unused_links ON l_release_group_release_group;
DROP TRIGGER remove_unused_links ON l_release_group_url;
DROP TRIGGER remove_unused_links ON l_release_group_work;
DROP TRIGGER remove_unused_links ON l_url_url;
DROP TRIGGER remove_unused_links ON l_url_work;
DROP TRIGGER remove_unused_links ON l_work_work;
DROP TRIGGER url_gc_a_upd_url ON url;
DROP TRIGGER url_gc_a_upd_l_area_url ON l_area_url;
DROP TRIGGER url_gc_a_del_l_area_url ON l_area_url;
DROP TRIGGER url_gc_a_upd_l_artist_url ON l_artist_url;
DROP TRIGGER url_gc_a_del_l_artist_url ON l_artist_url;
DROP TRIGGER url_gc_a_upd_l_event_url ON l_event_url;
DROP TRIGGER url_gc_a_del_l_event_url ON l_event_url;
DROP TRIGGER url_gc_a_upd_l_instrument_url ON l_instrument_url;
DROP TRIGGER url_gc_a_del_l_instrument_url ON l_instrument_url;
DROP TRIGGER url_gc_a_upd_l_label_url ON l_label_url;
DROP TRIGGER url_gc_a_del_l_label_url ON l_label_url;
DROP TRIGGER url_gc_a_upd_l_place_url ON l_place_url;
DROP TRIGGER url_gc_a_del_l_place_url ON l_place_url;
DROP TRIGGER url_gc_a_upd_l_recording_url ON l_recording_url;
DROP TRIGGER url_gc_a_del_l_recording_url ON l_recording_url;
DROP TRIGGER url_gc_a_upd_l_release_url ON l_release_url;
DROP TRIGGER url_gc_a_del_l_release_url ON l_release_url;
DROP TRIGGER url_gc_a_upd_l_release_group_url ON l_release_group_url;
DROP TRIGGER url_gc_a_del_l_release_group_url ON l_release_group_url;
DROP TRIGGER url_gc_a_upd_l_series_url ON l_series_url;
DROP TRIGGER url_gc_a_del_l_series_url ON l_series_url;
DROP TRIGGER url_gc_a_upd_l_url_url ON l_url_url;
DROP TRIGGER url_gc_a_del_l_url_url ON l_url_url;
DROP TRIGGER url_gc_a_upd_l_url_work ON l_url_work;
DROP TRIGGER url_gc_a_del_l_url_work ON l_url_work;
DROP TRIGGER delete_unused_tag ON tag;
DROP TRIGGER delete_unused_tag ON area_tag;
DROP TRIGGER delete_unused_tag ON artist_tag;
DROP TRIGGER delete_unused_tag ON event_tag;
DROP TRIGGER delete_unused_tag ON instrument_tag;
DROP TRIGGER delete_unused_tag ON label_tag;
DROP TRIGGER delete_unused_tag ON place_tag;
DROP TRIGGER delete_unused_tag ON recording_tag;
DROP TRIGGER delete_unused_tag ON release_group_tag;
DROP TRIGGER delete_unused_tag ON release_tag;
DROP TRIGGER delete_unused_tag ON series_tag;
DROP TRIGGER delete_unused_tag ON work_tag;
DROP TRIGGER apply_artist_release_group_pending_updates ON release;
DROP TRIGGER apply_artist_release_pending_updates ON release;
DROP TRIGGER apply_artist_release_pending_updates ON release_country;
DROP TRIGGER apply_artist_release_pending_updates ON release_first_release_date;
DROP TRIGGER apply_artist_release_group_pending_updates ON release_group;
DROP TRIGGER apply_artist_release_group_pending_updates ON release_group_meta;
DROP TRIGGER apply_artist_release_group_pending_updates ON release_group_secondary_type_join;
DROP TRIGGER apply_artist_release_pending_updates ON release_label;
DROP TRIGGER apply_artist_release_group_pending_updates ON track;
DROP TRIGGER apply_artist_release_pending_updates ON track;