/
DropPrimaryKeys.sql
367 lines (366 loc) · 28 KB
/
DropPrimaryKeys.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
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
-- Automatically generated, do not edit.
\unset ON_ERROR_STOP
ALTER TABLE alternative_medium DROP CONSTRAINT IF EXISTS alternative_medium_pkey;
ALTER TABLE alternative_medium_track DROP CONSTRAINT IF EXISTS alternative_medium_track_pkey;
ALTER TABLE alternative_release DROP CONSTRAINT IF EXISTS alternative_release_pkey;
ALTER TABLE alternative_release_type DROP CONSTRAINT IF EXISTS alternative_release_type_pkey;
ALTER TABLE alternative_track DROP CONSTRAINT IF EXISTS alternative_track_pkey;
ALTER TABLE annotation DROP CONSTRAINT IF EXISTS annotation_pkey;
ALTER TABLE application DROP CONSTRAINT IF EXISTS application_pkey;
ALTER TABLE area DROP CONSTRAINT IF EXISTS area_pkey;
ALTER TABLE area_alias DROP CONSTRAINT IF EXISTS area_alias_pkey;
ALTER TABLE area_alias_type DROP CONSTRAINT IF EXISTS area_alias_type_pkey;
ALTER TABLE area_annotation DROP CONSTRAINT IF EXISTS area_annotation_pkey;
ALTER TABLE area_attribute DROP CONSTRAINT IF EXISTS area_attribute_pkey;
ALTER TABLE area_attribute_type DROP CONSTRAINT IF EXISTS area_attribute_type_pkey;
ALTER TABLE area_attribute_type_allowed_value DROP CONSTRAINT IF EXISTS area_attribute_type_allowed_value_pkey;
ALTER TABLE area_containment DROP CONSTRAINT IF EXISTS area_containment_pkey;
ALTER TABLE area_gid_redirect DROP CONSTRAINT IF EXISTS area_gid_redirect_pkey;
ALTER TABLE area_tag DROP CONSTRAINT IF EXISTS area_tag_pkey;
ALTER TABLE area_tag_raw DROP CONSTRAINT IF EXISTS area_tag_raw_pkey;
ALTER TABLE area_type DROP CONSTRAINT IF EXISTS area_type_pkey;
ALTER TABLE artist DROP CONSTRAINT IF EXISTS artist_pkey;
ALTER TABLE artist_alias DROP CONSTRAINT IF EXISTS artist_alias_pkey;
ALTER TABLE artist_alias_type DROP CONSTRAINT IF EXISTS artist_alias_type_pkey;
ALTER TABLE artist_annotation DROP CONSTRAINT IF EXISTS artist_annotation_pkey;
ALTER TABLE artist_attribute DROP CONSTRAINT IF EXISTS artist_attribute_pkey;
ALTER TABLE artist_attribute_type DROP CONSTRAINT IF EXISTS artist_attribute_type_pkey;
ALTER TABLE artist_attribute_type_allowed_value DROP CONSTRAINT IF EXISTS artist_attribute_type_allowed_value_pkey;
ALTER TABLE artist_credit DROP CONSTRAINT IF EXISTS artist_credit_pkey;
ALTER TABLE artist_credit_gid_redirect DROP CONSTRAINT IF EXISTS artist_credit_gid_redirect_pkey;
ALTER TABLE artist_credit_name DROP CONSTRAINT IF EXISTS artist_credit_name_pkey;
ALTER TABLE artist_gid_redirect DROP CONSTRAINT IF EXISTS artist_gid_redirect_pkey;
ALTER TABLE artist_ipi DROP CONSTRAINT IF EXISTS artist_ipi_pkey;
ALTER TABLE artist_isni DROP CONSTRAINT IF EXISTS artist_isni_pkey;
ALTER TABLE artist_meta DROP CONSTRAINT IF EXISTS artist_meta_pkey;
ALTER TABLE artist_rating_raw DROP CONSTRAINT IF EXISTS artist_rating_raw_pkey;
ALTER TABLE artist_tag DROP CONSTRAINT IF EXISTS artist_tag_pkey;
ALTER TABLE artist_tag_raw DROP CONSTRAINT IF EXISTS artist_tag_raw_pkey;
ALTER TABLE artist_type DROP CONSTRAINT IF EXISTS artist_type_pkey;
ALTER TABLE autoeditor_election DROP CONSTRAINT IF EXISTS autoeditor_election_pkey;
ALTER TABLE autoeditor_election_vote DROP CONSTRAINT IF EXISTS autoeditor_election_vote_pkey;
ALTER TABLE cdtoc DROP CONSTRAINT IF EXISTS cdtoc_pkey;
ALTER TABLE cdtoc_raw DROP CONSTRAINT IF EXISTS cdtoc_raw_pkey;
ALTER TABLE country_area DROP CONSTRAINT IF EXISTS country_area_pkey;
ALTER TABLE deleted_entity DROP CONSTRAINT IF EXISTS deleted_entity_pkey;
ALTER TABLE edit DROP CONSTRAINT IF EXISTS edit_pkey;
ALTER TABLE edit_area DROP CONSTRAINT IF EXISTS edit_area_pkey;
ALTER TABLE edit_artist DROP CONSTRAINT IF EXISTS edit_artist_pkey;
ALTER TABLE edit_data DROP CONSTRAINT IF EXISTS edit_data_pkey;
ALTER TABLE edit_event DROP CONSTRAINT IF EXISTS edit_event_pkey;
ALTER TABLE edit_genre DROP CONSTRAINT IF EXISTS edit_genre_pkey;
ALTER TABLE edit_instrument DROP CONSTRAINT IF EXISTS edit_instrument_pkey;
ALTER TABLE edit_label DROP CONSTRAINT IF EXISTS edit_label_pkey;
ALTER TABLE edit_mood DROP CONSTRAINT IF EXISTS edit_mood_pkey;
ALTER TABLE edit_note DROP CONSTRAINT IF EXISTS edit_note_pkey;
ALTER TABLE edit_note_change DROP CONSTRAINT IF EXISTS edit_note_change_pkey;
ALTER TABLE edit_note_recipient DROP CONSTRAINT IF EXISTS edit_note_recipient_pkey;
ALTER TABLE edit_place DROP CONSTRAINT IF EXISTS edit_place_pkey;
ALTER TABLE edit_recording DROP CONSTRAINT IF EXISTS edit_recording_pkey;
ALTER TABLE edit_release DROP CONSTRAINT IF EXISTS edit_release_pkey;
ALTER TABLE edit_release_group DROP CONSTRAINT IF EXISTS edit_release_group_pkey;
ALTER TABLE edit_series DROP CONSTRAINT IF EXISTS edit_series_pkey;
ALTER TABLE edit_url DROP CONSTRAINT IF EXISTS edit_url_pkey;
ALTER TABLE edit_work DROP CONSTRAINT IF EXISTS edit_work_pkey;
ALTER TABLE editor DROP CONSTRAINT IF EXISTS editor_pkey;
ALTER TABLE editor_collection DROP CONSTRAINT IF EXISTS editor_collection_pkey;
ALTER TABLE editor_collection_area DROP CONSTRAINT IF EXISTS editor_collection_area_pkey;
ALTER TABLE editor_collection_artist DROP CONSTRAINT IF EXISTS editor_collection_artist_pkey;
ALTER TABLE editor_collection_collaborator DROP CONSTRAINT IF EXISTS editor_collection_collaborator_pkey;
ALTER TABLE editor_collection_deleted_entity DROP CONSTRAINT IF EXISTS editor_collection_deleted_entity_pkey;
ALTER TABLE editor_collection_event DROP CONSTRAINT IF EXISTS editor_collection_event_pkey;
ALTER TABLE editor_collection_gid_redirect DROP CONSTRAINT IF EXISTS editor_collection_gid_redirect_pkey;
ALTER TABLE editor_collection_instrument DROP CONSTRAINT IF EXISTS editor_collection_instrument_pkey;
ALTER TABLE editor_collection_label DROP CONSTRAINT IF EXISTS editor_collection_label_pkey;
ALTER TABLE editor_collection_place DROP CONSTRAINT IF EXISTS editor_collection_place_pkey;
ALTER TABLE editor_collection_recording DROP CONSTRAINT IF EXISTS editor_collection_recording_pkey;
ALTER TABLE editor_collection_release DROP CONSTRAINT IF EXISTS editor_collection_release_pkey;
ALTER TABLE editor_collection_release_group DROP CONSTRAINT IF EXISTS editor_collection_release_group_pkey;
ALTER TABLE editor_collection_series DROP CONSTRAINT IF EXISTS editor_collection_series_pkey;
ALTER TABLE editor_collection_type DROP CONSTRAINT IF EXISTS editor_collection_type_pkey;
ALTER TABLE editor_collection_work DROP CONSTRAINT IF EXISTS editor_collection_work_pkey;
ALTER TABLE editor_language DROP CONSTRAINT IF EXISTS editor_language_pkey;
ALTER TABLE editor_oauth_token DROP CONSTRAINT IF EXISTS editor_oauth_token_pkey;
ALTER TABLE editor_preference DROP CONSTRAINT IF EXISTS editor_preference_pkey;
ALTER TABLE editor_subscribe_artist DROP CONSTRAINT IF EXISTS editor_subscribe_artist_pkey;
ALTER TABLE editor_subscribe_artist_deleted DROP CONSTRAINT IF EXISTS editor_subscribe_artist_deleted_pkey;
ALTER TABLE editor_subscribe_collection DROP CONSTRAINT IF EXISTS editor_subscribe_collection_pkey;
ALTER TABLE editor_subscribe_editor DROP CONSTRAINT IF EXISTS editor_subscribe_editor_pkey;
ALTER TABLE editor_subscribe_label DROP CONSTRAINT IF EXISTS editor_subscribe_label_pkey;
ALTER TABLE editor_subscribe_label_deleted DROP CONSTRAINT IF EXISTS editor_subscribe_label_deleted_pkey;
ALTER TABLE editor_subscribe_series DROP CONSTRAINT IF EXISTS editor_subscribe_series_pkey;
ALTER TABLE editor_subscribe_series_deleted DROP CONSTRAINT IF EXISTS editor_subscribe_series_deleted_pkey;
ALTER TABLE event DROP CONSTRAINT IF EXISTS event_pkey;
ALTER TABLE event_alias DROP CONSTRAINT IF EXISTS event_alias_pkey;
ALTER TABLE event_alias_type DROP CONSTRAINT IF EXISTS event_alias_type_pkey;
ALTER TABLE event_annotation DROP CONSTRAINT IF EXISTS event_annotation_pkey;
ALTER TABLE event_attribute DROP CONSTRAINT IF EXISTS event_attribute_pkey;
ALTER TABLE event_attribute_type DROP CONSTRAINT IF EXISTS event_attribute_type_pkey;
ALTER TABLE event_attribute_type_allowed_value DROP CONSTRAINT IF EXISTS event_attribute_type_allowed_value_pkey;
ALTER TABLE event_gid_redirect DROP CONSTRAINT IF EXISTS event_gid_redirect_pkey;
ALTER TABLE event_meta DROP CONSTRAINT IF EXISTS event_meta_pkey;
ALTER TABLE event_rating_raw DROP CONSTRAINT IF EXISTS event_rating_raw_pkey;
ALTER TABLE event_tag DROP CONSTRAINT IF EXISTS event_tag_pkey;
ALTER TABLE event_tag_raw DROP CONSTRAINT IF EXISTS event_tag_raw_pkey;
ALTER TABLE event_type DROP CONSTRAINT IF EXISTS event_type_pkey;
ALTER TABLE gender DROP CONSTRAINT IF EXISTS gender_pkey;
ALTER TABLE genre DROP CONSTRAINT IF EXISTS genre_pkey;
ALTER TABLE genre_alias DROP CONSTRAINT IF EXISTS genre_alias_pkey;
ALTER TABLE genre_alias_type DROP CONSTRAINT IF EXISTS genre_alias_type_pkey;
ALTER TABLE genre_annotation DROP CONSTRAINT IF EXISTS genre_annotation_pkey;
ALTER TABLE instrument DROP CONSTRAINT IF EXISTS instrument_pkey;
ALTER TABLE instrument_alias DROP CONSTRAINT IF EXISTS instrument_alias_pkey;
ALTER TABLE instrument_alias_type DROP CONSTRAINT IF EXISTS instrument_alias_type_pkey;
ALTER TABLE instrument_annotation DROP CONSTRAINT IF EXISTS instrument_annotation_pkey;
ALTER TABLE instrument_attribute DROP CONSTRAINT IF EXISTS instrument_attribute_pkey;
ALTER TABLE instrument_attribute_type DROP CONSTRAINT IF EXISTS instrument_attribute_type_pkey;
ALTER TABLE instrument_attribute_type_allowed_value DROP CONSTRAINT IF EXISTS instrument_attribute_type_allowed_value_pkey;
ALTER TABLE instrument_gid_redirect DROP CONSTRAINT IF EXISTS instrument_gid_redirect_pkey;
ALTER TABLE instrument_tag DROP CONSTRAINT IF EXISTS instrument_tag_pkey;
ALTER TABLE instrument_tag_raw DROP CONSTRAINT IF EXISTS instrument_tag_raw_pkey;
ALTER TABLE instrument_type DROP CONSTRAINT IF EXISTS instrument_type_pkey;
ALTER TABLE iso_3166_1 DROP CONSTRAINT IF EXISTS iso_3166_1_pkey;
ALTER TABLE iso_3166_2 DROP CONSTRAINT IF EXISTS iso_3166_2_pkey;
ALTER TABLE iso_3166_3 DROP CONSTRAINT IF EXISTS iso_3166_3_pkey;
ALTER TABLE isrc DROP CONSTRAINT IF EXISTS isrc_pkey;
ALTER TABLE iswc DROP CONSTRAINT IF EXISTS iswc_pkey;
ALTER TABLE l_area_area DROP CONSTRAINT IF EXISTS l_area_area_pkey;
ALTER TABLE l_area_artist DROP CONSTRAINT IF EXISTS l_area_artist_pkey;
ALTER TABLE l_area_event DROP CONSTRAINT IF EXISTS l_area_event_pkey;
ALTER TABLE l_area_genre DROP CONSTRAINT IF EXISTS l_area_genre_pkey;
ALTER TABLE l_area_instrument DROP CONSTRAINT IF EXISTS l_area_instrument_pkey;
ALTER TABLE l_area_label DROP CONSTRAINT IF EXISTS l_area_label_pkey;
ALTER TABLE l_area_mood DROP CONSTRAINT IF EXISTS l_area_mood_pkey;
ALTER TABLE l_area_place DROP CONSTRAINT IF EXISTS l_area_place_pkey;
ALTER TABLE l_area_recording DROP CONSTRAINT IF EXISTS l_area_recording_pkey;
ALTER TABLE l_area_release DROP CONSTRAINT IF EXISTS l_area_release_pkey;
ALTER TABLE l_area_release_group DROP CONSTRAINT IF EXISTS l_area_release_group_pkey;
ALTER TABLE l_area_series DROP CONSTRAINT IF EXISTS l_area_series_pkey;
ALTER TABLE l_area_url DROP CONSTRAINT IF EXISTS l_area_url_pkey;
ALTER TABLE l_area_work DROP CONSTRAINT IF EXISTS l_area_work_pkey;
ALTER TABLE l_artist_artist DROP CONSTRAINT IF EXISTS l_artist_artist_pkey;
ALTER TABLE l_artist_event DROP CONSTRAINT IF EXISTS l_artist_event_pkey;
ALTER TABLE l_artist_genre DROP CONSTRAINT IF EXISTS l_artist_genre_pkey;
ALTER TABLE l_artist_instrument DROP CONSTRAINT IF EXISTS l_artist_instrument_pkey;
ALTER TABLE l_artist_label DROP CONSTRAINT IF EXISTS l_artist_label_pkey;
ALTER TABLE l_artist_mood DROP CONSTRAINT IF EXISTS l_artist_mood_pkey;
ALTER TABLE l_artist_place DROP CONSTRAINT IF EXISTS l_artist_place_pkey;
ALTER TABLE l_artist_recording DROP CONSTRAINT IF EXISTS l_artist_recording_pkey;
ALTER TABLE l_artist_release DROP CONSTRAINT IF EXISTS l_artist_release_pkey;
ALTER TABLE l_artist_release_group DROP CONSTRAINT IF EXISTS l_artist_release_group_pkey;
ALTER TABLE l_artist_series DROP CONSTRAINT IF EXISTS l_artist_series_pkey;
ALTER TABLE l_artist_url DROP CONSTRAINT IF EXISTS l_artist_url_pkey;
ALTER TABLE l_artist_work DROP CONSTRAINT IF EXISTS l_artist_work_pkey;
ALTER TABLE l_event_event DROP CONSTRAINT IF EXISTS l_event_event_pkey;
ALTER TABLE l_event_genre DROP CONSTRAINT IF EXISTS l_event_genre_pkey;
ALTER TABLE l_event_instrument DROP CONSTRAINT IF EXISTS l_event_instrument_pkey;
ALTER TABLE l_event_label DROP CONSTRAINT IF EXISTS l_event_label_pkey;
ALTER TABLE l_event_mood DROP CONSTRAINT IF EXISTS l_event_mood_pkey;
ALTER TABLE l_event_place DROP CONSTRAINT IF EXISTS l_event_place_pkey;
ALTER TABLE l_event_recording DROP CONSTRAINT IF EXISTS l_event_recording_pkey;
ALTER TABLE l_event_release DROP CONSTRAINT IF EXISTS l_event_release_pkey;
ALTER TABLE l_event_release_group DROP CONSTRAINT IF EXISTS l_event_release_group_pkey;
ALTER TABLE l_event_series DROP CONSTRAINT IF EXISTS l_event_series_pkey;
ALTER TABLE l_event_url DROP CONSTRAINT IF EXISTS l_event_url_pkey;
ALTER TABLE l_event_work DROP CONSTRAINT IF EXISTS l_event_work_pkey;
ALTER TABLE l_genre_genre DROP CONSTRAINT IF EXISTS l_genre_genre_pkey;
ALTER TABLE l_genre_instrument DROP CONSTRAINT IF EXISTS l_genre_instrument_pkey;
ALTER TABLE l_genre_label DROP CONSTRAINT IF EXISTS l_genre_label_pkey;
ALTER TABLE l_genre_mood DROP CONSTRAINT IF EXISTS l_genre_mood_pkey;
ALTER TABLE l_genre_place DROP CONSTRAINT IF EXISTS l_genre_place_pkey;
ALTER TABLE l_genre_recording DROP CONSTRAINT IF EXISTS l_genre_recording_pkey;
ALTER TABLE l_genre_release DROP CONSTRAINT IF EXISTS l_genre_release_pkey;
ALTER TABLE l_genre_release_group DROP CONSTRAINT IF EXISTS l_genre_release_group_pkey;
ALTER TABLE l_genre_series DROP CONSTRAINT IF EXISTS l_genre_series_pkey;
ALTER TABLE l_genre_url DROP CONSTRAINT IF EXISTS l_genre_url_pkey;
ALTER TABLE l_genre_work DROP CONSTRAINT IF EXISTS l_genre_work_pkey;
ALTER TABLE l_instrument_instrument DROP CONSTRAINT IF EXISTS l_instrument_instrument_pkey;
ALTER TABLE l_instrument_label DROP CONSTRAINT IF EXISTS l_instrument_label_pkey;
ALTER TABLE l_instrument_mood DROP CONSTRAINT IF EXISTS l_instrument_mood_pkey;
ALTER TABLE l_instrument_place DROP CONSTRAINT IF EXISTS l_instrument_place_pkey;
ALTER TABLE l_instrument_recording DROP CONSTRAINT IF EXISTS l_instrument_recording_pkey;
ALTER TABLE l_instrument_release DROP CONSTRAINT IF EXISTS l_instrument_release_pkey;
ALTER TABLE l_instrument_release_group DROP CONSTRAINT IF EXISTS l_instrument_release_group_pkey;
ALTER TABLE l_instrument_series DROP CONSTRAINT IF EXISTS l_instrument_series_pkey;
ALTER TABLE l_instrument_url DROP CONSTRAINT IF EXISTS l_instrument_url_pkey;
ALTER TABLE l_instrument_work DROP CONSTRAINT IF EXISTS l_instrument_work_pkey;
ALTER TABLE l_label_label DROP CONSTRAINT IF EXISTS l_label_label_pkey;
ALTER TABLE l_label_mood DROP CONSTRAINT IF EXISTS l_label_mood_pkey;
ALTER TABLE l_label_place DROP CONSTRAINT IF EXISTS l_label_place_pkey;
ALTER TABLE l_label_recording DROP CONSTRAINT IF EXISTS l_label_recording_pkey;
ALTER TABLE l_label_release DROP CONSTRAINT IF EXISTS l_label_release_pkey;
ALTER TABLE l_label_release_group DROP CONSTRAINT IF EXISTS l_label_release_group_pkey;
ALTER TABLE l_label_series DROP CONSTRAINT IF EXISTS l_label_series_pkey;
ALTER TABLE l_label_url DROP CONSTRAINT IF EXISTS l_label_url_pkey;
ALTER TABLE l_label_work DROP CONSTRAINT IF EXISTS l_label_work_pkey;
ALTER TABLE l_mood_mood DROP CONSTRAINT IF EXISTS l_mood_mood_pkey;
ALTER TABLE l_mood_place DROP CONSTRAINT IF EXISTS l_mood_place_pkey;
ALTER TABLE l_mood_recording DROP CONSTRAINT IF EXISTS l_mood_recording_pkey;
ALTER TABLE l_mood_release DROP CONSTRAINT IF EXISTS l_mood_release_pkey;
ALTER TABLE l_mood_release_group DROP CONSTRAINT IF EXISTS l_mood_release_group_pkey;
ALTER TABLE l_mood_series DROP CONSTRAINT IF EXISTS l_mood_series_pkey;
ALTER TABLE l_mood_url DROP CONSTRAINT IF EXISTS l_mood_url_pkey;
ALTER TABLE l_mood_work DROP CONSTRAINT IF EXISTS l_mood_work_pkey;
ALTER TABLE l_place_place DROP CONSTRAINT IF EXISTS l_place_place_pkey;
ALTER TABLE l_place_recording DROP CONSTRAINT IF EXISTS l_place_recording_pkey;
ALTER TABLE l_place_release DROP CONSTRAINT IF EXISTS l_place_release_pkey;
ALTER TABLE l_place_release_group DROP CONSTRAINT IF EXISTS l_place_release_group_pkey;
ALTER TABLE l_place_series DROP CONSTRAINT IF EXISTS l_place_series_pkey;
ALTER TABLE l_place_url DROP CONSTRAINT IF EXISTS l_place_url_pkey;
ALTER TABLE l_place_work DROP CONSTRAINT IF EXISTS l_place_work_pkey;
ALTER TABLE l_recording_recording DROP CONSTRAINT IF EXISTS l_recording_recording_pkey;
ALTER TABLE l_recording_release DROP CONSTRAINT IF EXISTS l_recording_release_pkey;
ALTER TABLE l_recording_release_group DROP CONSTRAINT IF EXISTS l_recording_release_group_pkey;
ALTER TABLE l_recording_series DROP CONSTRAINT IF EXISTS l_recording_series_pkey;
ALTER TABLE l_recording_url DROP CONSTRAINT IF EXISTS l_recording_url_pkey;
ALTER TABLE l_recording_work DROP CONSTRAINT IF EXISTS l_recording_work_pkey;
ALTER TABLE l_release_group_release_group DROP CONSTRAINT IF EXISTS l_release_group_release_group_pkey;
ALTER TABLE l_release_group_series DROP CONSTRAINT IF EXISTS l_release_group_series_pkey;
ALTER TABLE l_release_group_url DROP CONSTRAINT IF EXISTS l_release_group_url_pkey;
ALTER TABLE l_release_group_work DROP CONSTRAINT IF EXISTS l_release_group_work_pkey;
ALTER TABLE l_release_release DROP CONSTRAINT IF EXISTS l_release_release_pkey;
ALTER TABLE l_release_release_group DROP CONSTRAINT IF EXISTS l_release_release_group_pkey;
ALTER TABLE l_release_series DROP CONSTRAINT IF EXISTS l_release_series_pkey;
ALTER TABLE l_release_url DROP CONSTRAINT IF EXISTS l_release_url_pkey;
ALTER TABLE l_release_work DROP CONSTRAINT IF EXISTS l_release_work_pkey;
ALTER TABLE l_series_series DROP CONSTRAINT IF EXISTS l_series_series_pkey;
ALTER TABLE l_series_url DROP CONSTRAINT IF EXISTS l_series_url_pkey;
ALTER TABLE l_series_work DROP CONSTRAINT IF EXISTS l_series_work_pkey;
ALTER TABLE l_url_url DROP CONSTRAINT IF EXISTS l_url_url_pkey;
ALTER TABLE l_url_work DROP CONSTRAINT IF EXISTS l_url_work_pkey;
ALTER TABLE l_work_work DROP CONSTRAINT IF EXISTS l_work_work_pkey;
ALTER TABLE label DROP CONSTRAINT IF EXISTS label_pkey;
ALTER TABLE label_alias DROP CONSTRAINT IF EXISTS label_alias_pkey;
ALTER TABLE label_alias_type DROP CONSTRAINT IF EXISTS label_alias_type_pkey;
ALTER TABLE label_annotation DROP CONSTRAINT IF EXISTS label_annotation_pkey;
ALTER TABLE label_attribute DROP CONSTRAINT IF EXISTS label_attribute_pkey;
ALTER TABLE label_attribute_type DROP CONSTRAINT IF EXISTS label_attribute_type_pkey;
ALTER TABLE label_attribute_type_allowed_value DROP CONSTRAINT IF EXISTS label_attribute_type_allowed_value_pkey;
ALTER TABLE label_gid_redirect DROP CONSTRAINT IF EXISTS label_gid_redirect_pkey;
ALTER TABLE label_ipi DROP CONSTRAINT IF EXISTS label_ipi_pkey;
ALTER TABLE label_isni DROP CONSTRAINT IF EXISTS label_isni_pkey;
ALTER TABLE label_meta DROP CONSTRAINT IF EXISTS label_meta_pkey;
ALTER TABLE label_rating_raw DROP CONSTRAINT IF EXISTS label_rating_raw_pkey;
ALTER TABLE label_tag DROP CONSTRAINT IF EXISTS label_tag_pkey;
ALTER TABLE label_tag_raw DROP CONSTRAINT IF EXISTS label_tag_raw_pkey;
ALTER TABLE label_type DROP CONSTRAINT IF EXISTS label_type_pkey;
ALTER TABLE language DROP CONSTRAINT IF EXISTS language_pkey;
ALTER TABLE link DROP CONSTRAINT IF EXISTS link_pkey;
ALTER TABLE link_attribute DROP CONSTRAINT IF EXISTS link_attribute_pkey;
ALTER TABLE link_attribute_credit DROP CONSTRAINT IF EXISTS link_attribute_credit_pkey;
ALTER TABLE link_attribute_text_value DROP CONSTRAINT IF EXISTS link_attribute_text_value_pkey;
ALTER TABLE link_attribute_type DROP CONSTRAINT IF EXISTS link_attribute_type_pkey;
ALTER TABLE link_creditable_attribute_type DROP CONSTRAINT IF EXISTS link_creditable_attribute_type_pkey;
ALTER TABLE link_text_attribute_type DROP CONSTRAINT IF EXISTS link_text_attribute_type_pkey;
ALTER TABLE link_type DROP CONSTRAINT IF EXISTS link_type_pkey;
ALTER TABLE link_type_attribute_type DROP CONSTRAINT IF EXISTS link_type_attribute_type_pkey;
ALTER TABLE medium DROP CONSTRAINT IF EXISTS medium_pkey;
ALTER TABLE medium_attribute DROP CONSTRAINT IF EXISTS medium_attribute_pkey;
ALTER TABLE medium_attribute_type DROP CONSTRAINT IF EXISTS medium_attribute_type_pkey;
ALTER TABLE medium_attribute_type_allowed_format DROP CONSTRAINT IF EXISTS medium_attribute_type_allowed_format_pkey;
ALTER TABLE medium_attribute_type_allowed_value DROP CONSTRAINT IF EXISTS medium_attribute_type_allowed_value_pkey;
ALTER TABLE medium_attribute_type_allowed_value_allowed_format DROP CONSTRAINT IF EXISTS medium_attribute_type_allowed_value_allowed_format_pkey;
ALTER TABLE medium_cdtoc DROP CONSTRAINT IF EXISTS medium_cdtoc_pkey;
ALTER TABLE medium_format DROP CONSTRAINT IF EXISTS medium_format_pkey;
ALTER TABLE medium_index DROP CONSTRAINT IF EXISTS medium_index_pkey;
ALTER TABLE mood DROP CONSTRAINT IF EXISTS mood_pkey;
ALTER TABLE mood_alias DROP CONSTRAINT IF EXISTS mood_alias_pkey;
ALTER TABLE mood_alias_type DROP CONSTRAINT IF EXISTS mood_alias_type_pkey;
ALTER TABLE mood_annotation DROP CONSTRAINT IF EXISTS mood_annotation_pkey;
ALTER TABLE orderable_link_type DROP CONSTRAINT IF EXISTS orderable_link_type_pkey;
ALTER TABLE place DROP CONSTRAINT IF EXISTS place_pkey;
ALTER TABLE place_alias DROP CONSTRAINT IF EXISTS place_alias_pkey;
ALTER TABLE place_alias_type DROP CONSTRAINT IF EXISTS place_alias_type_pkey;
ALTER TABLE place_annotation DROP CONSTRAINT IF EXISTS place_annotation_pkey;
ALTER TABLE place_attribute DROP CONSTRAINT IF EXISTS place_attribute_pkey;
ALTER TABLE place_attribute_type DROP CONSTRAINT IF EXISTS place_attribute_type_pkey;
ALTER TABLE place_attribute_type_allowed_value DROP CONSTRAINT IF EXISTS place_attribute_type_allowed_value_pkey;
ALTER TABLE place_gid_redirect DROP CONSTRAINT IF EXISTS place_gid_redirect_pkey;
ALTER TABLE place_meta DROP CONSTRAINT IF EXISTS place_meta_pkey;
ALTER TABLE place_rating_raw DROP CONSTRAINT IF EXISTS place_rating_raw_pkey;
ALTER TABLE place_tag DROP CONSTRAINT IF EXISTS place_tag_pkey;
ALTER TABLE place_tag_raw DROP CONSTRAINT IF EXISTS place_tag_raw_pkey;
ALTER TABLE place_type DROP CONSTRAINT IF EXISTS place_type_pkey;
ALTER TABLE recording DROP CONSTRAINT IF EXISTS recording_pkey;
ALTER TABLE recording_alias DROP CONSTRAINT IF EXISTS recording_alias_pkey;
ALTER TABLE recording_alias_type DROP CONSTRAINT IF EXISTS recording_alias_type_pkey;
ALTER TABLE recording_annotation DROP CONSTRAINT IF EXISTS recording_annotation_pkey;
ALTER TABLE recording_attribute DROP CONSTRAINT IF EXISTS recording_attribute_pkey;
ALTER TABLE recording_attribute_type DROP CONSTRAINT IF EXISTS recording_attribute_type_pkey;
ALTER TABLE recording_attribute_type_allowed_value DROP CONSTRAINT IF EXISTS recording_attribute_type_allowed_value_pkey;
ALTER TABLE recording_first_release_date DROP CONSTRAINT IF EXISTS recording_first_release_date_pkey;
ALTER TABLE recording_gid_redirect DROP CONSTRAINT IF EXISTS recording_gid_redirect_pkey;
ALTER TABLE recording_meta DROP CONSTRAINT IF EXISTS recording_meta_pkey;
ALTER TABLE recording_rating_raw DROP CONSTRAINT IF EXISTS recording_rating_raw_pkey;
ALTER TABLE recording_tag DROP CONSTRAINT IF EXISTS recording_tag_pkey;
ALTER TABLE recording_tag_raw DROP CONSTRAINT IF EXISTS recording_tag_raw_pkey;
ALTER TABLE release DROP CONSTRAINT IF EXISTS release_pkey;
ALTER TABLE release_alias DROP CONSTRAINT IF EXISTS release_alias_pkey;
ALTER TABLE release_alias_type DROP CONSTRAINT IF EXISTS release_alias_type_pkey;
ALTER TABLE release_annotation DROP CONSTRAINT IF EXISTS release_annotation_pkey;
ALTER TABLE release_attribute DROP CONSTRAINT IF EXISTS release_attribute_pkey;
ALTER TABLE release_attribute_type DROP CONSTRAINT IF EXISTS release_attribute_type_pkey;
ALTER TABLE release_attribute_type_allowed_value DROP CONSTRAINT IF EXISTS release_attribute_type_allowed_value_pkey;
ALTER TABLE release_country DROP CONSTRAINT IF EXISTS release_country_pkey;
ALTER TABLE release_first_release_date DROP CONSTRAINT IF EXISTS release_first_release_date_pkey;
ALTER TABLE release_gid_redirect DROP CONSTRAINT IF EXISTS release_gid_redirect_pkey;
ALTER TABLE release_group DROP CONSTRAINT IF EXISTS release_group_pkey;
ALTER TABLE release_group_alias DROP CONSTRAINT IF EXISTS release_group_alias_pkey;
ALTER TABLE release_group_alias_type DROP CONSTRAINT IF EXISTS release_group_alias_type_pkey;
ALTER TABLE release_group_annotation DROP CONSTRAINT IF EXISTS release_group_annotation_pkey;
ALTER TABLE release_group_attribute DROP CONSTRAINT IF EXISTS release_group_attribute_pkey;
ALTER TABLE release_group_attribute_type DROP CONSTRAINT IF EXISTS release_group_attribute_type_pkey;
ALTER TABLE release_group_attribute_type_allowed_value DROP CONSTRAINT IF EXISTS release_group_attribute_type_allowed_value_pkey;
ALTER TABLE release_group_gid_redirect DROP CONSTRAINT IF EXISTS release_group_gid_redirect_pkey;
ALTER TABLE release_group_meta DROP CONSTRAINT IF EXISTS release_group_meta_pkey;
ALTER TABLE release_group_primary_type DROP CONSTRAINT IF EXISTS release_group_primary_type_pkey;
ALTER TABLE release_group_rating_raw DROP CONSTRAINT IF EXISTS release_group_rating_raw_pkey;
ALTER TABLE release_group_secondary_type DROP CONSTRAINT IF EXISTS release_group_secondary_type_pkey;
ALTER TABLE release_group_secondary_type_join DROP CONSTRAINT IF EXISTS release_group_secondary_type_join_pkey;
ALTER TABLE release_group_tag DROP CONSTRAINT IF EXISTS release_group_tag_pkey;
ALTER TABLE release_group_tag_raw DROP CONSTRAINT IF EXISTS release_group_tag_raw_pkey;
ALTER TABLE release_label DROP CONSTRAINT IF EXISTS release_label_pkey;
ALTER TABLE release_meta DROP CONSTRAINT IF EXISTS release_meta_pkey;
ALTER TABLE release_packaging DROP CONSTRAINT IF EXISTS release_packaging_pkey;
ALTER TABLE release_raw DROP CONSTRAINT IF EXISTS release_raw_pkey;
ALTER TABLE release_status DROP CONSTRAINT IF EXISTS release_status_pkey;
ALTER TABLE release_tag DROP CONSTRAINT IF EXISTS release_tag_pkey;
ALTER TABLE release_tag_raw DROP CONSTRAINT IF EXISTS release_tag_raw_pkey;
ALTER TABLE release_unknown_country DROP CONSTRAINT IF EXISTS release_unknown_country_pkey;
ALTER TABLE replication_control DROP CONSTRAINT IF EXISTS replication_control_pkey;
ALTER TABLE script DROP CONSTRAINT IF EXISTS script_pkey;
ALTER TABLE series DROP CONSTRAINT IF EXISTS series_pkey;
ALTER TABLE series_alias DROP CONSTRAINT IF EXISTS series_alias_pkey;
ALTER TABLE series_alias_type DROP CONSTRAINT IF EXISTS series_alias_type_pkey;
ALTER TABLE series_annotation DROP CONSTRAINT IF EXISTS series_annotation_pkey;
ALTER TABLE series_attribute DROP CONSTRAINT IF EXISTS series_attribute_pkey;
ALTER TABLE series_attribute_type DROP CONSTRAINT IF EXISTS series_attribute_type_pkey;
ALTER TABLE series_attribute_type_allowed_value DROP CONSTRAINT IF EXISTS series_attribute_type_allowed_value_pkey;
ALTER TABLE series_gid_redirect DROP CONSTRAINT IF EXISTS series_gid_redirect_pkey;
ALTER TABLE series_ordering_type DROP CONSTRAINT IF EXISTS series_ordering_type_pkey;
ALTER TABLE series_tag DROP CONSTRAINT IF EXISTS series_tag_pkey;
ALTER TABLE series_tag_raw DROP CONSTRAINT IF EXISTS series_tag_raw_pkey;
ALTER TABLE series_type DROP CONSTRAINT IF EXISTS series_type_pkey;
ALTER TABLE tag DROP CONSTRAINT IF EXISTS tag_pkey;
ALTER TABLE tag_relation DROP CONSTRAINT IF EXISTS tag_relation_pkey;
ALTER TABLE track DROP CONSTRAINT IF EXISTS track_pkey;
ALTER TABLE track_gid_redirect DROP CONSTRAINT IF EXISTS track_gid_redirect_pkey;
ALTER TABLE track_raw DROP CONSTRAINT IF EXISTS track_raw_pkey;
ALTER TABLE unreferenced_row_log DROP CONSTRAINT IF EXISTS unreferenced_row_log_pkey;
ALTER TABLE url DROP CONSTRAINT IF EXISTS url_pkey;
ALTER TABLE url_gid_redirect DROP CONSTRAINT IF EXISTS url_gid_redirect_pkey;
ALTER TABLE vote DROP CONSTRAINT IF EXISTS vote_pkey;
ALTER TABLE work DROP CONSTRAINT IF EXISTS work_pkey;
ALTER TABLE work_alias DROP CONSTRAINT IF EXISTS work_alias_pkey;
ALTER TABLE work_alias_type DROP CONSTRAINT IF EXISTS work_alias_type_pkey;
ALTER TABLE work_annotation DROP CONSTRAINT IF EXISTS work_annotation_pkey;
ALTER TABLE work_attribute DROP CONSTRAINT IF EXISTS work_attribute_pkey;
ALTER TABLE work_attribute_type DROP CONSTRAINT IF EXISTS work_attribute_type_pkey;
ALTER TABLE work_attribute_type_allowed_value DROP CONSTRAINT IF EXISTS work_attribute_type_allowed_value_pkey;
ALTER TABLE work_gid_redirect DROP CONSTRAINT IF EXISTS work_gid_redirect_pkey;
ALTER TABLE work_language DROP CONSTRAINT IF EXISTS work_language_pkey;
ALTER TABLE work_meta DROP CONSTRAINT IF EXISTS work_meta_pkey;
ALTER TABLE work_rating_raw DROP CONSTRAINT IF EXISTS work_rating_raw_pkey;
ALTER TABLE work_tag DROP CONSTRAINT IF EXISTS work_tag_pkey;
ALTER TABLE work_tag_raw DROP CONSTRAINT IF EXISTS work_tag_raw_pkey;
ALTER TABLE work_type DROP CONSTRAINT IF EXISTS work_type_pkey;