/
InsertTestData.sql
295 lines (233 loc) · 21.2 KB
/
InsertTestData.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
SET client_min_messages TO 'WARNING';
INSERT INTO area (id, gid, name, type) VALUES
(221, '8a754a16-0027-3a29-b6d7-2b40ea0481ed', 'United Kingdom', 1),
(222, '489ce91b-6658-3307-9877-795b68554c98', 'United States', 1);
INSERT INTO country_area (area) VALUES (221), (222);
INSERT INTO iso_3166_1 (area, code) VALUES (221, 'GB'), (222, 'US');
-- MusicBrainz System Entities
INSERT INTO artist (id, gid, name, sort_name, type) VALUES
(1, '89ad4ac3-39f7-470e-963a-56509c546377', 'Various Artists', 'Various Artists', 3),
(2, 'c06aa285-520e-40c0-b776-83d2c9e8a6d1', 'Deleted Artist', 'Deleted Artist', 3);
INSERT INTO artist (area, begin_area, begin_date_day, begin_date_month, begin_date_year, comment, edits_pending, end_area, end_date_day, end_date_month, end_date_year, ended, gender, gid, id, last_updated, name, sort_name, type) VALUES
(222, NULL, NULL, NULL, 1983, '', 0, NULL, NULL, NULL, NULL, '0', 1, 'fa263cb3-205f-4a7f-91e1-94e3df52abe8', 196418, '2011-08-18 11:37:18.247651-05', 'Jimmy Edgar', 'Edgar, Jimmy', 1),
(221, NULL, NULL, NULL, NULL, 'UK electronic artist', 0, NULL, NULL, NULL, NULL, '0', 1, 'e4787c4e-0b1a-48bd-b9a0-b0427391d293', 514734, '2014-06-06 12:43:54.273108-05', 'patten', 'patten', 1);
-- Test Artist
INSERT INTO artist
(id, gid, name, sort_name, type, gender, area,
begin_area, end_area,
begin_date_year, begin_date_month, begin_date_day,
end_date_year, end_date_month, end_date_day, comment)
VALUES
(3, '745c079d-374e-4436-9448-da92dedef3ce', 'Test Artist', 'Artist, Test', 1, 1, 221, 221, 221,
2008, 01, 02, 2009, 03, 04, 'Yet Another Test Artist');
UPDATE artist_meta SET rating=70, rating_count=4 WHERE id=3;
INSERT INTO artist (id, gid, name, sort_name) VALUES
(4, '945c079d-374e-4436-9448-da92dedef3cf', 'Queen', 'Queen'),
(5, '5441c29d-3602-4898-b1a1-b77fa23b8e50', 'David Bowie', 'David Bowie');
INSERT INTO artist_credit (id, name, artist_count, gid) VALUES (1, 'Queen & David Bowie', 2, '949a7fd5-fe73-3e8f-922e-01ff4ca958f7');
INSERT INTO artist_credit_name (artist_credit, position, artist, name, join_phrase) VALUES (1, 0, 4, 'Queen', ' & ');
INSERT INTO artist_credit_name (artist_credit, position, artist, name, join_phrase) VALUES (1, 1, 5, 'David Bowie', '');
-- Test artist name triggers
INSERT INTO artist (id, gid, name, sort_name) VALUES (100, '24c94140-456b-11de-8a39-0800200c9a66', 'Shared Name', 'Shared Name');
INSERT INTO artist (id, gid, name, sort_name) VALUES (101, '374d65d0-456b-11de-8a39-0800200c9a66', 'Name', 'Sort Name');
INSERT INTO artist_credit (id, name, artist_count, gid) VALUES (100, 'Shared Name', 1, '71fde822-f07c-38d8-a969-9973fe775fbb');
INSERT INTO artist_credit_name (artist_credit, position, artist, name, join_phrase) VALUES (100, 0, 100, 'Credit Name', '');
INSERT INTO artist (id, gid, name, sort_name) VALUES (6, 'a45c079d-374e-4436-9448-da92dedef3cf', 'ABBA', 'ABBA');
INSERT INTO artist_credit (id, name, artist_count, gid) VALUES (2, 'ABBA', 1, 'c44109ce-57d7-3691-84c8-37926e3d41d2');
INSERT INTO artist_credit_name (artist_credit, position, artist, name) VALUES (2, 0, 6, 'ABBA');
INSERT INTO recording (id, gid, name, artist_credit, length) VALUES
(1, '123c079d-374e-4436-9448-da92dedef3ce', 'Dancing Queen', 2, 123456);
INSERT INTO release_group (id, gid, name, artist_credit, type) VALUES
(1, '234c079d-374e-4436-9448-da92dedef3ce', 'Arrival', 2, 1);
-- Test multiple release groups on a page
INSERT INTO artist_credit (id, name, artist_count, gid) VALUES (4, 'Test Artist', 1, '261f02c2-75a6-313f-9dd8-1716f73f3ce8');
INSERT INTO artist_credit_name (artist_credit, position, artist, name) VALUES (4, 0, 3, 'Test Artist');
INSERT INTO release_group (id, gid, name, artist_credit, type) VALUES
(3, 'ecc33260-454c-11de-8a39-0800200c9a66', 'Test RG 1', 4, 1);
INSERT INTO release_group (id, gid, name, artist_credit, type) VALUES
(4, '7348f3a0-454e-11de-8a39-0800200c9a66', 'Test RG 2', 4, 1);
INSERT INTO release_group_alias (id, name, sort_name, release_group, type, edits_pending)
VALUES (1, 'Test RG 1 Alias 1', 'Test RG 1 Alias Sort Name 1', 3, 1, 0),
(2, 'Test RG 1 Alias 2', 'Test RG 1 Alias Sort Name 2', 3, 2, 0);
INSERT INTO work (id, gid, name, type) VALUES
(1, '745c079d-374e-4436-9448-da92dedef3ce', 'Dancing Queen', 1);
INSERT INTO iswc (work, iswc) VALUES (1, 'T-000.000.001-0');
-- Special Labels
INSERT INTO label (id, gid, name, type) VALUES
(1, 'f43e252d-9ebf-4e8e-bba8-36d080756cc1', 'Deleted Label', 4);
INSERT INTO label (id, gid, name, type, area, label_code,
begin_date_year, begin_date_month, begin_date_day,
end_date_year, end_date_month, end_date_day, comment)
VALUES (2, '46f0f4cd-8aab-4b33-b698-f459faf64190', 'Warp Records', 4, 221, 2070,
1989, 02, 03, 2008, 05, 19, 'Sheffield based electronica label');
-- recording contract relationships for Warp Records
INSERT INTO link (attribute_count, begin_date_day, begin_date_month, begin_date_year, created, end_date_day, end_date_month, end_date_year, ended, id, link_type) VALUES
(0, NULL, NULL, NULL, '2014-01-12 18:00:27.843631-06', NULL, NULL, 2008, '1', 146318, 121),
(0, 5, 11, 2013, '2013-12-08 14:19:44.210478-06', NULL, NULL, NULL, '0', 141690, 121);
INSERT INTO l_artist_label (edits_pending, entity0, entity0_credit, entity1, entity1_credit, id, last_updated, link, link_order) VALUES
(0, 196418, '', 2, '', 458, '2014-01-12 18:00:27.843631-06', 146318, 0),
(0, 514734, '', 2, '', 6340, '2013-12-15 15:00:13.130313-06', 141690, 0);
INSERT INTO label_alias (id, name, sort_name, label, edits_pending, type)
VALUES (1, 'Test Label Alias', 'Test Label Alias', 2, 2, 1);
INSERT INTO label (id, gid, name) VALUES
(3, '4b4ccf60-658e-11de-8a39-0800200c9a66', 'Another Label');
INSERT INTO label (id, gid, name) VALUES
(4, 'f34c079d-374e-4436-9448-da92dedef3ce', 'Empty Label');
INSERT INTO release (id, gid, name, artist_credit, release_group, status, packaging, barcode) VALUES (1, 'f34c079d-374e-4436-9448-da92dedef3ce', 'Arrival', 2, 1, 1, 1, '731453398122');
INSERT INTO release_country (release, country, date_year, date_month, date_day) VALUES (1, 221, 2009, 5, 8);
INSERT INTO release_label (id, release, label, catalog_number)
VALUES (1, 1, 2, 'ABC-123');
INSERT INTO release_label (id, release, label, catalog_number)
VALUES (2, 1, 2, 'ABC-123-X');
INSERT INTO url (id, gid, url)
VALUES (1, '9201840b-d810-4e0f-bb75-c791205f5b24', 'http://musicbrainz.org/');
INSERT INTO medium (id, release, position, format, name) VALUES (1, 1, 1, 1, 'The First Disc');
INSERT INTO medium (id, release, position, format, name) VALUES (2, 1, 2, 1, 'The Second Disc');
INSERT INTO track (id, gid, recording, medium, position, number, name, artist_credit, length)
VALUES (1, '3fd2523e-1ced-4f83-8b93-c7ecf6960b32', 1, 1, 1, 1, 1, 2, 123456);
INSERT INTO track (id, gid, recording, medium, position, number, name, artist_credit, length)
VALUES (2, '680b2ca7-1c54-4c1b-a034-486f0d22eb87', 1, 1, 2, 2, 'Track 2', 2, 123456);
INSERT INTO track (id, gid, recording, medium, position, number, name, artist_credit)
VALUES (3, '06ebb97d-bdf8-42c8-96c2-cd0f3eb39de6', 1, 2, 1, 1, 'Track 3', 2);
-- A full editor
INSERT INTO editor (id, name, password, privs, email, website, bio, email_confirm_date, member_since, last_login_date, ha1) VALUES (1, 'new_editor', '{CLEARTEXT}password', 0, 'test@editor.org', 'http://musicbrainz.org', 'biography', '2005-10-20', '1989-07-23', now(), 'e1dd8fee8ee728b0ddc8027d3a3db478');
INSERT INTO editor_preference (editor, name, value) VALUES (1, 'public_ratings', '0');
INSERT INTO artist_alias (id, name, sort_name, artist, edits_pending)
VALUES (1, 'Test Alias', 'Test Alias', 4, 2);
INSERT INTO artist_alias (id, name, sort_name, artist)
VALUES (2, 'Test Alias', 'Test Alias', 5);
INSERT INTO artist (id, gid, name, sort_name, begin_date_year, begin_date_month, begin_date_day, type)
VALUES (7, '4b585938-f271-45e2-b19a-91c634b5e396', 'Kate Bush', 'Bush, Kate', 1958, 7, 30, 1);
INSERT INTO artist_credit (id, name, artist_count, gid) VALUES (3, 'Kate Bush', 1, '52dcd9bf-4163-3800-803e-f8e52e2fb283');
INSERT INTO artist_credit_name (artist_credit, position, artist, name) VALUES (3, 0, 7, 'Kate Bush');
INSERT INTO release_group (id, gid, name, artist_credit, type) VALUES
(2, '7c3218d7-75e0-4e8c-971f-f097b6c308c5', 'Aerial', 3, 1);
INSERT INTO release (id, gid, name, artist_credit, release_group, status, barcode) VALUES (2, 'f205627f-b70a-409d-adbe-66289b614e80', 'Aerial', 3, 2, 1, '0094634396028');
INSERT INTO release_country (release, country, date_year, date_month, date_day) VALUES (2, 221, 2005, 11, 7);
INSERT INTO release_alias (id, name, sort_name, release, type, edits_pending)
VALUES (1, 'Ærial', 'Ærial', 2, 1, 0);
INSERT INTO release (id, gid, name, artist_credit, release_group, status, barcode) VALUES (3, '9b3d9383-3d2a-417f-bfbb-56f7c15f075b', 'Aerial', 3, 2, 1, '0827969777220');
INSERT INTO release_country (release, country, date_year, date_month, date_day) VALUES (3, 222, 2005, 11, 8);
INSERT INTO release_label (id, release, label, catalog_number)
VALUES (3, 2, 2, '343 960 2');
INSERT INTO release_label (id, release, label, catalog_number)
VALUES (4, 3, 2, '82796 97772 2');
INSERT INTO medium (id, release, position, format, name) VALUES (3, 2, 1, 1, 'A Sea of Honey');
INSERT INTO medium (id, release, position, format, name) VALUES (4, 2, 2, 1, 'A Sky of Honey');
INSERT INTO medium (id, release, position, format, name) VALUES (5, 3, 1, 1, 'A Sea of Honey');
INSERT INTO medium (id, release, position, format, name) VALUES (6, 3, 2, 1, 'A Sky of Honey');
INSERT INTO recording (id, gid, name, artist_credit, length) VALUES
(2, '54b9d183-7dab-42ba-94a3-7388a66604b8', 'King of the Mountain', 3, 293720);
INSERT INTO recording (id, gid, name, artist_credit, length) VALUES
(3, '659f405b-b4ee-4033-868a-0daa27784b89', 'π', 3, 369680);
INSERT INTO recording (id, gid, name, artist_credit, length) VALUES
(4, 'ae674299-2824-4500-9516-653ac1bc6f80', 'Bertie', 3, 258839);
INSERT INTO recording (id, gid, name, artist_credit, length) VALUES
(5, 'b1d58a57-a0f3-4db8-aa94-868cdc7bc3bb', 'Mrs. Bartolozzi', 3, 358960);
INSERT INTO recording (id, gid, name, artist_credit, length) VALUES
(6, '44f52946-0c98-47ba-ba60-964774db56f0', 'How to Be Invisible', 3, 332613);
INSERT INTO recording (id, gid, name, artist_credit, length) VALUES
(7, '07614140-8bb8-4db9-9dcc-0917c3a8471b', 'Joanni', 3, 296160);
INSERT INTO recording (id, gid, name, artist_credit, length) VALUES
(8, '1eb4f672-5ee3-454f-9a67-db85a4478fea', 'A Coral Room', 3, 372386);
INSERT INTO recording (id, gid, name, artist_credit, length) VALUES
(9, '91028302-a466-4557-a19b-a26584564daa', 'Prelude', 3, 86186);
INSERT INTO recording (id, gid, name, artist_credit, length) VALUES
(10, '9560a5ac-d980-41fe-be7f-a6cb4a0cd91b', 'Prologue', 3, 342306);
INSERT INTO recording (id, gid, name, artist_credit, length) VALUES
(11, '2ed42694-7b28-433e-9cf0-1e14a25babfe', 'An Architect''s Dream', 3, 290053);
INSERT INTO recording (id, gid, name, artist_credit, length) VALUES
(12, '3bf4cbea-f963-4d75-bac5-351a29c60575', 'The Painter''s Link', 3, 95933);
INSERT INTO recording (id, gid, name, artist_credit, length) VALUES
(13, '33137503-0ebf-4b6b-a7ce-cc71df5865df', 'Sunset', 3, 358573);
INSERT INTO recording (id, gid, name, artist_credit, length) VALUES
(14, '2c89d9f6-fd0e-4e79-a654-828fbcf4656d', 'Aerial Tal', 3, 61333);
INSERT INTO recording (id, gid, name, artist_credit, length) VALUES
(15, '61b13b9d-e839-4ea9-8453-208eaafb75bf', 'Somewhere in Between', 3, 300626);
INSERT INTO recording (id, gid, name, artist_credit, length) VALUES
(16, 'd328d709-609c-4b88-90be-95815f041524', 'Nocturn', 3, 514679);
INSERT INTO recording (id, gid, name, artist_credit, length) VALUES
(17, '1539ac10-5081-4469-b8f2-c5896132724e', 'Aerial', 3, 472880);
INSERT INTO recording_alias (id, name, sort_name, recording, type, edits_pending)
VALUES (1, 'King of the Mt.', 'King of the Mt.', 2, 1, 0);
INSERT INTO track (id, gid, medium, position, number, recording, name, artist_credit, length) VALUES (4, '39164965-d4bd-49e6-925d-72026ad03dce', 3, 1, 1, 2, 'King of the Mountain', 3, 293720);
INSERT INTO track (id, gid, medium, position, number, recording, name, artist_credit, length) VALUES (5, '82edb036-4097-484d-ac8a-cf4971451ca0', 3, 2, 2, 3, 'π', 3, 369680);
INSERT INTO track (id, gid, medium, position, number, recording, name, artist_credit, length) VALUES (6, '37e395f0-a23e-45a2-9e67-60de472767e7', 3, 3, 3, 4, 'Bertie', 3, 258839);
INSERT INTO track (id, gid, medium, position, number, recording, name, artist_credit, length) VALUES (7, 'ea7b8e52-2b25-4d2d-aab0-2f1c51be92ef', 3, 4, 4, 5, 'Mrs. Bartolozzi', 3, 358960);
INSERT INTO track (id, gid, medium, position, number, recording, name, artist_credit, length) VALUES (8, 'bb365eeb-dbdf-438c-a249-718c7b0bea52', 3, 5, 5, 6, 'How to Be Invisible', 3, 332613);
INSERT INTO track (id, gid, medium, position, number, recording, name, artist_credit, length) VALUES (9, '37c6df32-d67e-4f9a-b1ff-14ba032dbf26', 3, 6, 6, 7, 'Joanni', 3, 296160);
INSERT INTO track (id, gid, medium, position, number, recording, name, artist_credit, length) VALUES (10, 'a187f0e9-6642-40cb-8571-2f56695641dd', 3, 7, 7, 8, 'A Coral Room', 3, 372386);
INSERT INTO track (id, gid, medium, position, number, recording, name, artist_credit, length) VALUES (11, '88032ed3-9921-46e1-982c-41909cc724af', 4, 1, 1, 9, 'Prelude', 3, 86186);
INSERT INTO track (id, gid, medium, position, number, recording, name, artist_credit, length) VALUES (12, 'ac9da1bf-ff74-4e64-9b4f-76704feb1ce6', 4, 2, 2, 10, 'Prologue', 3, 342306);
INSERT INTO track (id, gid, medium, position, number, recording, name, artist_credit, length) VALUES (13, 'dc71aad9-82fd-421f-8e4a-12656eb4ff4e', 4, 3, 3, 11, 'An Architect''s Dream', 3, 290053);
INSERT INTO track (id, gid, medium, position, number, recording, name, artist_credit, length) VALUES (14, 'd5916ff1-fd23-42a0-a908-425860fef00f', 4, 4, 4, 12, 'The Painter''s Link', 3, 95933);
INSERT INTO track (id, gid, medium, position, number, recording, name, artist_credit, length) VALUES (15, '816a6e79-2c9a-4e15-a358-994044c43355', 4, 5, 5, 13, 'Sunset', 3, 358573);
INSERT INTO track (id, gid, medium, position, number, recording, name, artist_credit, length) VALUES (16, '7deb0f39-d1db-4168-ae8b-d30bd39b954e', 4, 6, 6, 14, 'Aerial Tal', 3, 61333);
INSERT INTO track (id, gid, medium, position, number, recording, name, artist_credit, length) VALUES (17, '07e62d01-af88-4621-8b67-29ec910d31ac', 4, 7, 7, 15, 'Somewhere in Between', 3, 300626);
INSERT INTO track (id, gid, medium, position, number, recording, name, artist_credit, length) VALUES (18, '1cc78aa6-1cad-426e-a5e8-31d64e523399', 4, 8, 8, 16, 'Nocturn', 3, 514679);
INSERT INTO track (id, gid, medium, position, number, recording, name, artist_credit, length) VALUES (19, '2d6bc3f9-620a-40d3-b36d-fd63d8be48c5', 4, 9, 9, 17, 'Aerial', 4, 472880);
INSERT INTO track (id, gid, medium, position, number, recording, name, artist_credit, length) VALUES (20, '26f68708-a04d-4606-9d00-77fbf38238fb', 5, 1, 1, 2, 'King of the Mountain', 3, 293720);
INSERT INTO track (id, gid, medium, position, number, recording, name, artist_credit, length) VALUES (21, '68866291-3937-45d9-bbc9-fd00551a1cfc', 5, 2, 2, 3, 'π', 3, 369680);
INSERT INTO track (id, gid, medium, position, number, recording, name, artist_credit, length) VALUES (22, '6b1a422b-4872-4202-ac77-0c11d0ceec6b', 5, 3, 3, 4, 'Bertie', 3, 258839);
INSERT INTO track (id, gid, medium, position, number, recording, name, artist_credit, length) VALUES (23, 'b74bc478-dfd3-4b31-b8a9-b9d736f266f1', 5, 4, 4, 5, 'Mrs. Bartolozzi', 3, 358960);
INSERT INTO track (id, gid, medium, position, number, recording, name, artist_credit, length) VALUES (24, 'd77512b3-5d85-4282-a7ef-65021c2e061d', 5, 5, 5, 6, 'How to Be Invisible', 3, 332613);
INSERT INTO track (id, gid, medium, position, number, recording, name, artist_credit, length) VALUES (25, '93f35f65-eb26-4f96-b2af-e0291ace234a', 5, 6, 6, 7, 'Joanni', 3, 296160);
INSERT INTO track (id, gid, medium, position, number, recording, name, artist_credit, length) VALUES (26, 'fa2faefb-0bc3-4991-8125-5ee8b848fda5', 5, 7, 7, 8, 'A Coral Room', 3, 372386);
INSERT INTO track (id, gid, medium, position, number, recording, name, artist_credit, length) VALUES (27, '67b5cff6-4fd4-46a4-a354-f7e912cb8f7f', 6, 1, 1, 9, 'Prelude', 3, 86186);
INSERT INTO track (id, gid, medium, position, number, recording, name, artist_credit, length) VALUES (28, '56ad6df9-fdd8-46e8-befb-8c842bcabf66', 6, 2, 2, 10, 'Prologue', 3, 342306);
INSERT INTO track (id, gid, medium, position, number, recording, name, artist_credit, length) VALUES (29, '6121d50d-cf00-4e0c-b045-f02d3684c862', 6, 3, 3, 11, 'An Architect''s Dream', 3, 290053);
INSERT INTO track (id, gid, medium, position, number, recording, name, artist_credit, length) VALUES (30, '4938b277-297e-4224-84ac-d555f69cb7cc', 6, 4, 4, 12, 'The Painter''s Link', 3, 95933);
INSERT INTO track (id, gid, medium, position, number, recording, name, artist_credit, length) VALUES (31, '1c8aec4f-dc70-4aef-90df-748a16f6d2f5', 6, 5, 5, 13, 'Sunset', 3, 358573);
INSERT INTO track (id, gid, medium, position, number, recording, name, artist_credit, length) VALUES (32, '66f51b3e-c401-4d23-8630-7df66cb3904a', 6, 6, 6, 14, 'Aerial Tal', 3, 61333);
INSERT INTO track (id, gid, medium, position, number, recording, name, artist_credit, length) VALUES (33, 'd6e5d737-6fdc-4a29-9d95-b2de5bd3e834', 6, 7, 7, 15, 'Somewhere in Between', 3, 300626);
INSERT INTO track (id, gid, medium, position, number, recording, name, artist_credit, length) VALUES (34, 'db770a93-c0ad-4806-af76-f6fc835a057d', 6, 8, 8, 16, 'Nocturn', 3, 514679);
INSERT INTO track (id, gid, medium, position, number, recording, name, artist_credit, length) VALUES (35, '65464409-1c68-4e90-8664-65ec8a21843a', 6, 9, 9, 17, 'Aerial', 4, 472880);
INSERT INTO isrc (isrc, recording) VALUES ('DEE250800231', 1);
INSERT INTO isrc (isrc, recording) VALUES ('DEE250800230', 2);
INSERT INTO link (id, link_type, attribute_count) VALUES (1, 148, 1);
INSERT INTO link (id, link_type, attribute_count) VALUES (2, 148, 2);
INSERT INTO link (id, link_type, attribute_count, begin_date_year) VALUES (3, 183, 0, 2006);
INSERT INTO link_attribute (link, attribute_type) VALUES (1, 229);
INSERT INTO link_attribute (link, attribute_type) VALUES (2, 1);
INSERT INTO link_attribute (link, attribute_type) VALUES (2, 302);
INSERT INTO artist (id, gid, name, sort_name)
VALUES
(8, 'e2a083a9-9942-4d6e-b4d2-8397320b95f7', 'Test Alias', 'Kate Bush');
INSERT INTO artist (id, gid, name, sort_name, comment) VALUES
(9, '2fed031c-0e89-406e-b9f0-3d192637907a', 'Test Alias', 'Kate Bush', 'Second');
INSERT INTO l_artist_recording (id, link, entity0, entity1) VALUES (1, 1, 8, 2);
INSERT INTO l_artist_recording (id, link, entity0, entity1, edits_pending) VALUES (2, 1, 9, 2, 1);
INSERT INTO l_artist_recording (id, link, entity0, entity1) VALUES (3, 2, 8, 3);
INSERT INTO l_artist_url (id, link, entity0, entity1) VALUES (1, 3, 8, 1);
INSERT INTO annotation (id, editor, text) VALUES (1, 1, 'Test annotation 1' || chr(10) || chr(10) || 'More annotation');
INSERT INTO annotation (id, editor, text) VALUES (2, 1, 'Test annotation 2.');
INSERT INTO annotation (id, editor, text) VALUES (3, 1, 'Test annotation 3.');
INSERT INTO annotation (id, editor, text) VALUES (4, 1, 'Test annotation 4.');
INSERT INTO annotation (id, editor, text) VALUES (5, 1, 'Test annotation 5.');
INSERT INTO annotation (id, editor, text) VALUES (6, 1, 'Test annotation 6.');
INSERT INTO annotation (id, editor, text) VALUES (7, 1, 'Test annotation 7.');
INSERT INTO artist_annotation (artist, annotation) VALUES (3, 1);
INSERT INTO artist_annotation (artist, annotation) VALUES (4, 7);
INSERT INTO label_annotation (label, annotation) VALUES (2, 2);
INSERT INTO recording_annotation (recording, annotation) VALUES (1, 3);
INSERT INTO release_annotation (release, annotation) VALUES (1, 4);
INSERT INTO release_group_annotation (release_group, annotation) VALUES (1, 5);
INSERT INTO work_annotation (work, annotation) VALUES (1, 6);
INSERT INTO artist_gid_redirect VALUES ('a4ef1d08-962e-4dd6-ae14-e42a6a97fc11', 4);
INSERT INTO label_gid_redirect VALUES ('efdf3fe9-c293-4acd-b4b2-8d2a7d4f9592', 2);
INSERT INTO recording_gid_redirect VALUES ('0986e67c-6b7a-40b7-b4ba-c9d7583d6426', 1);
INSERT INTO release_gid_redirect VALUES ('71dc55d8-0fc6-41c1-94e0-85ff2404997d', 1);
INSERT INTO release_group_gid_redirect VALUES ('77637e8c-be66-46ea-87b3-73addc722fc9', 1);
INSERT INTO work_gid_redirect VALUES ('28e73402-5666-4d74-80ab-c3734dc699ea', 1);
INSERT INTO tag (id, name) VALUES (1, 'musical'), (2, 'not-used'), (3, 'hip-hop/rap');
INSERT INTO artist_tag (tag, artist, count) VALUES (1, 3, 2), (3, 3, 2);
INSERT INTO label_tag (tag, label, count) VALUES (1, 2, 2);
INSERT INTO recording_tag (tag, recording, count) VALUES (1, 1, 2);
INSERT INTO release_group_tag (tag, release_group, count) VALUES (1, 1, 2);
INSERT INTO work_tag (tag, work, count) VALUES (1, 1, 2);
INSERT INTO cdtoc (id, discid, freedb_id, track_count, leadout_offset, track_offset) VALUES
(2, 'tLGBAiCflG8ZI6lFcOt87vXjEcI-', '5908ea07', 7, 171327,
ARRAY[150,22179,49905,69318,96240,121186,143398]);
INSERT INTO medium_cdtoc (id, medium, cdtoc) VALUES
(1, 3, 2);
SET client_min_messages TO 'NOTICE';