Launchpad itself

Merge lp:~stub/launchpad/db into lp:launchpad

  1. db
  2. Merge into devel
Proposed by Stuart Bishop
Status: Merged
Merged at revision: 17157
Proposed branch: lp:~stub/launchpad/db
Merge into: lp:launchpad
Diff against target: 797 lines (+404/-348)
4 files modified
database/sampledata/current-dev.sql (+174/-174)
database/sampledata/current.sql (+174/-174)
database/schema/patch-2209-58-3.sql (+10/-0)
database/schema/patch-2209-58-4.sql (+46/-0)
To merge this branch: bzr merge lp:~stub/launchpad/db
Reviewer Review Type Date Requested Status
William Grant db Approve
Review via email: mp+230047@code.launchpad.net

Commit message

Final two database patches converting LibraryFileContent.id to bigint.

Description of the change

Final two database patches converting LibraryFileContent.id to bigint.

This branch is not to be landed until after data migration has completed, and patch-2209-58-3.sql (the new primary key index) applied manually to production, staging and qastaging

To post a comment you must log in.
Revision history for this message
Stuart Bishop (stub) wrote :

Production has completed data migration and had patch-2209-58-3.sql applied manually.

Staging and qastaging are still running data migration.

Revision history for this message
William Grant (wgrant) :
review: Approve (db)
Revision history for this message
Stuart Bishop (stub) wrote :

staging is done. qastaging still running data migration.

Revision history for this message
Stuart Bishop (stub) wrote :

qastaging done

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== modified file 'database/sampledata/current-dev.sql'
2--- database/sampledata/current-dev.sql 2014-08-04 06:45:45 +0000
3+++ database/sampledata/current-dev.sql 2014-08-08 07:05:30 +0000
4@@ -659,93 +659,93 @@
5
6 ALTER TABLE libraryfilecontent DISABLE TRIGGER ALL;
7
8-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (1, '2005-04-07 16:46:05.265391', 178859, '378b3498ead213d35a82033a6e9196014a5ef25c', '01234567890123456789012345678900', '0123456789012345678901234567890123456789012345678901234567890123', 1);
9-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (2, '2005-04-07 16:46:05.266763', 9922560, 'a57faa6287aee2c58e115673a119c6083d31d1b9', '01234567890123456789012345678902', '0123456789012345678901234567890123456789012345678901234567890123', 2);
10-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (3, '2005-04-07 16:46:05.26727', 309386, 'b218ca7b52fa813550e3f14cdcf3ba68606e4446', '01234567890123456789012345678903', '0123456789012345678901234567890123456789012345678901234567890123', 3);
11-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (4, '2005-04-07 16:46:05.267803', 162927750, 'cfbd3ee1f510c66d49be465b900a3334e8488184', '01234567890123456789012345678904', '0123456789012345678901234567890123456789012345678901234567890123', 4);
12-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (5, '2005-05-18 08:03:28.021862', 4381, '9b1f78faa39fb09a9fd955d744002c2d8f32d88d', '01234567890123456789012345678905', '0123456789012345678901234567890123456789012345678901234567890123', 5);
13-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (6, '2005-05-18 08:03:28.021862', 7910, 'afdf21d698587a6601e2ffed0f44292b7ad5dd07', '01234567890123456789012345678906', '0123456789012345678901234567890123456789012345678901234567890123', 6);
14-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (7, '2005-05-18 08:03:28.021862', 10826, '502828e7591277535abe9015ffbc6918dbba8ef4', '01234567890123456789012345678907', '0123456789012345678901234567890123456789012345678901234567890123', 7);
15-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (8, '2005-05-18 08:03:28.021862', 10826, '502828e7591277535abe9015ffbc6918dbba8ef4', '01234567890123456789012345678907', '0123456789012345678901234567890123456789012345678901234567890123', 8);
16-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (9, '2005-05-18 08:03:28.021862', 2655, 'ca3b107af84c05eaf98ba073376153986566ec28', '01234567890123456789012345678908', '0123456789012345678901234567890123456789012345678901234567890123', 9);
17-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (10, '2005-05-18 08:03:28.021862', 13110, 'bc7bebca1e3c5c166838b19f0eeb7f171e51805d', '01234567890123456789012345678909', '0123456789012345678901234567890123456789012345678901234567890123', 10);
18-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (11, '2005-05-18 08:03:28.021862', 13499, '78a26efee75a54f113063b78783b2d4612fee409', '0123456789012345678901234567890a', '0123456789012345678901234567890123456789012345678901234567890123', 11);
19-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (12, '2005-05-18 08:03:28.021862', 12695, '8812d04c170ca90bb1423e188ce9706869aa03d7', '0123456789012345678901234567890b', '0123456789012345678901234567890123456789012345678901234567890123', 12);
20-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (13, '2005-05-18 08:03:28.021862', 13133, 'db1b50cbde7142d344bd8ef9b2e1fe3b3116f77c', '0123456789012345678901234567890c', '0123456789012345678901234567890123456789012345678901234567890123', 13);
21-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (14, '2005-05-18 08:03:28.021862', 13641, 'e19cc1446e3004f10475c37b2cd363f75b8ae89a', '0123456789012345678901234567890d', '0123456789012345678901234567890123456789012345678901234567890123', 14);
22-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (15, '2005-05-18 08:03:28.021862', 13269, 'fc8cab1cb1e5fb1efa3c3c475b8f7c8dc5038d50', '0123456789012345678901234567890f', '0123456789012345678901234567890123456789012345678901234567890123', 15);
23-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (16, '2005-05-18 08:03:28.021862', 13983, 'e17ee3031bd29dcd1e5905c0fd17945600a91ccf', '01234567890123456789012345678910', '0123456789012345678901234567890123456789012345678901234567890123', 16);
24-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (17, '2005-05-18 08:03:28.021862', 12652, '07b01d1e6fe9a729f911e72dfe674a5e0abdc4ee', '01234567890123456789012345678911', '0123456789012345678901234567890123456789012345678901234567890123', 17);
25-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (18, '2005-05-18 08:03:28.021862', 13240, '801dc911c2bd67e17eff087516fdc63a2ac322ce', '01234567890123456789012345678912', '0123456789012345678901234567890123456789012345678901234567890123', 18);
26-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (19, '2005-05-18 08:03:28.021862', 4165, 'fca78a2292e4034b8dfbb2de6f69e17ebeecaaa1', '01234567890123456789012345678913', '0123456789012345678901234567890123456789012345678901234567890123', 19);
27-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (20, '2005-05-18 08:03:28.021862', 4093, 'fc67a1770f78c45c396b4724195aeb10683aa2fd', '01234567890123456789012345678914', '0123456789012345678901234567890123456789012345678901234567890123', 20);
28-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (21, '2005-05-18 08:03:28.021862', 3635, '4ab2ca308dafe152789640942488e23a33e4f46c', '01234567890123456789012345678915', '0123456789012345678901234567890123456789012345678901234567890123', 21);
29-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (22, '2005-05-18 08:03:28.021862', 3553, '20815563ee33368d51e3213354f97c05b4685968', '01234567890123456789012345678916', '0123456789012345678901234567890123456789012345678901234567890123', 22);
30-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (23, '2005-05-18 08:03:28.021862', 3778, '965968d3e6668f39ebc64bc11a3f1a5cd07c213b', '01234567890123456789012345678917', '0123456789012345678901234567890123456789012345678901234567890123', 23);
31-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (24, '2005-05-18 08:03:28.021862', 3666, 'cca8fb78e05a34481e07683cea8c3a47f01c609e', '01234567890123456789012345678918', '0123456789012345678901234567890123456789012345678901234567890123', 24);
32-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (25, '2005-05-18 08:03:28.021862', 3793, '28a7accfb491a2b4895b49b810ca7cda0badc787', '01234567890123456789012345678919', '0123456789012345678901234567890123456789012345678901234567890123', 25);
33-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (26, '2005-05-18 08:03:28.021862', 4773, '03efb176f04f3897de7d5e6484864b0559fd6cd6', '0123456789012345678901234567891a', '0123456789012345678901234567890123456789012345678901234567890123', 26);
34-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (27, '2005-05-18 08:03:28.021862', 2961, '4468039e1d2cbdfc78d2e53477e5fe0537bae302', '0123456789012345678901234567891b', '0123456789012345678901234567890123456789012345678901234567890123', 27);
35-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (28, '2005-05-18 08:03:28.021862', 3558, 'd6c2ddacdab7618ce2a555c20a4a730fcdb42600', '0123456789012345678901234567891c', '0123456789012345678901234567890123456789012345678901234567890123', 28);
36-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (29, '2005-05-18 08:03:28.021862', 3561, '9eb09455e6a568605c1bbab4cdf1936eee92222d', '0123456789012345678901234567891d', '0123456789012345678901234567890123456789012345678901234567890123', 29);
37-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (30, '2005-05-18 08:03:28.021862', 3305, 'b45b170da29f9b22650315657505124766c93720', '0123456789012345678901234567891e', '0123456789012345678901234567890123456789012345678901234567890123', 30);
38-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (31, '2005-05-18 08:03:28.021862', 3987, '9668ba9f0a59f9e6e6bc73fc5dc9f116b202bceb', '0123456789012345678901234567891f', '0123456789012345678901234567890123456789012345678901234567890123', 31);
39-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (32, '2005-05-18 08:03:28.021862', 4908, '874a6ef9cd1aaef17653c6c12f4b83ef9487c1c3', '01234567890123456789012345678920', '0123456789012345678901234567890123456789012345678901234567890123', 32);
40-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (33, '2005-05-18 08:03:28.021862', 4908, '874a6ef9cd1aaef17653c6c12f4b83ef9487c1c3', '01234567890123456789012345678920', '0123456789012345678901234567890123456789012345678901234567890123', 33);
41-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (34, '2005-08-10 09:31:29.606407', 2, '71853c6197a6a7f222db0f1978c7cb232b87c5ee', '01234567890123456789012345678921', '0123456789012345678901234567890123456789012345678901234567890123', 34);
42-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (35, '2005-08-01 09:31:29.606407', 2, '71853c6197a6a7f222db0f1978c7cb232b87c5ee', '01234567890123456789012345678921', '0123456789012345678901234567890123456789012345678901234567890123', 35);
43-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (36, '2005-10-30 18:00:27.899028', 3, '0beec7b5ea3f0fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678922', '0123456789012345678901234567890123456789012345678901234567890123', 36);
44-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (37, '2005-10-30 18:00:27.899028', 3, '1e04c7b5ea3f0fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678923', '0123456789012345678901234567890123456789012345678901234567890123', 37);
45-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (38, '2005-10-30 18:00:27.899028', 3, 'ae04c7b5ea3f0bdb095d0dd47f3c5bc275da8a33', '01234567890123456789012345678924', '0123456789012345678901234567890123456789012345678901234567890123', 38);
46-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (39, '2005-10-30 18:00:27.899028', 3, 'a10856bfea3f0bdb09550dd41f3c5bc275da8a33', '01234567890123456789012345678925', '0123456789012345678901234567890123456789012345678901234567890123', 39);
47-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (40, '2005-10-30 18:00:27.899028', 3, '5a04c7b5ea3f0fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678926', '0123456789012345678901234567890123456789012345678901234567890123', 40);
48-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (42, '2005-10-30 18:00:27.899028', 3, 'a45ed906e4f56fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678927', '0123456789012345678901234567890123456789012345678901234567890123', 42);
49-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (43, '2005-10-30 18:00:27.899028', 3, '4e3961baf4f56fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678928', '0123456789012345678901234567890123456789012345678901234567890123', 43);
50-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (44, '2005-10-30 18:00:27.899028', 3, 'b45ed906e4f5afdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678929', '0123456789012345678901234567890123456789012345678901234567890123', 44);
51-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (45, '2006-08-01 09:31:29.606407', 2, '43853c6197a6a7f222db0f1978c7cb232b87c5ee', '0123456789012345678901234567892a', '0123456789012345678901234567890123456789012345678901234567890123', 45);
52-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (46, '2006-05-24 09:31:29.606407', 2, 'ab43246197a6a7f222db0f1978c7cb232b87c5ee', '0123456789012345678901234567892b', '0123456789012345678901234567890123456789012345678901234567890123', 46);
53-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (47, '2006-05-24 09:31:29.606407', 2, 'cabf42e197a6a7f222db0f1978c7cb232b87c5ee', '0123456789012345678901234567892c', '0123456789012345678901234567890123456789012345678901234567890123', 47);
54-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (51, '2006-07-14 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5437', '0123456789012345678901234567890123456789012345678901234567890123', 51);
55-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (52, '2006-05-24 09:31:29.606407', 2, '1622db354faa9fa653804d018f3b9d5291e37d6b', 'e4a7193a8f72fa2755e2162512069093', '0123456789012345678901234567890123456789012345678901234567890123', 52);
56-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (53, '2006-12-01 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5437', '0123456789012345678901234567890123456789012345678901234567890123', 53);
57-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (54, '2006-12-01 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5438', '0123456789012345678901234567890123456789012345678901234567890123', 54);
58-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (55, '2006-12-01 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5439', '0123456789012345678901234567890123456789012345678901234567890123', 55);
59-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (56, '2006-12-01 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5440', '0123456789012345678901234567890123456789012345678901234567890123', 56);
60-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (57, '2006-12-13 21:17:56.241901', 1599, 'acdf6b9b99c39b1585f829ec7d68598a8e10816d', '5c6fa250b612e7e4d17261268a4d8400', '0123456789012345678901234567890123456789012345678901234567890123', 57);
61-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (58, '2006-12-13 21:18:28.796588', 1599, 'acdf6b9b99c39b1585f829ec7d68598a8e10816d', '5c6fa250b612e7e4d17261268a4d8401', '0123456789012345678901234567890123456789012345678901234567890123', 58);
62-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (59, '2006-05-24 09:31:29.606407', 2, 'fabb42e197a6a7f222db0f1978c7cb232b87c5ee', '0123456789012345678901234567892d', '0123456789012345678901234567890123456789012345678901234567890123', 59);
63-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (60, '2007-01-03 17:26:27.288968', 11793, 'df3a6670671781d5e08d7795ca1ada776815d87f', 'e8120781cd606202fd259a4f0d4585bb', '0123456789012345678901234567890123456789012345678901234567890123', 60);
64-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (61, '2007-02-15 14:26:27.288968', 100, 'df3a6670671781d5e08d7795ca1ada776815d87f', 'e8120781cd606202fd259a4f0d4585b1', '0123456789012345678901234567890123456789012345678901234567890123', 61);
65-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (62, '2007-05-14 23:21:11.121446', 123, 'd06b970f258e57547ef1104fba3499eb4ab43ff6', '767e1635f55ff5e833410523decec438', '0123456789012345678901234567890123456789012345678901234567890123', 62);
66-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (63, '2007-05-14 23:21:11.121446', 123, 'd06b970f258e57547ef1104fba3499eb4ab43ff6', '767e1635f55ff5e833410523decec438', '0123456789012345678901234567890123456789012345678901234567890123', 63);
67-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (65, '2007-08-09 21:25:37.832976', 958, 'df4adf483eb24fec455e8411ca3dceb0bee51b44', 'b85b447f88c326c4124f0554e175097f', '0123456789012345678901234567890123456789012345678901234567890123', 65);
68-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (66, '2007-08-09 21:25:37.832976', 179, '3e00fea68e91f6e03de6333b4c8e60c2ce441926', 'f27fb7494c5afbb0fb10b78d16f7da37', '0123456789012345678901234567890123456789012345678901234567890123', 66);
69-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (67, '2007-08-09 21:25:37.832976', 610, '01bedc249af59cb80abb40b4898eced10f5d5e20', '7d6fa416334c6da3b954bf9ebff6e9ae', '0123456789012345678901234567890123456789012345678901234567890123', 67);
70-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (68, '2007-08-09 21:25:37.832976', 567, 'b5aeb55faeb86a1d8c1a93dd58131b387a604c5a', '95f2b067e046d73f4e93eca44c034b97', '0123456789012345678901234567890123456789012345678901234567890123', 68);
71-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (69, '2007-08-09 21:54:18.456616', 749, '0526ef40da99af5c1c97c91f9aca77e7ae564838', '8afa3dbc21b2dcdad7f31ab28c041ad9', '0123456789012345678901234567890123456789012345678901234567890123', 69);
72-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (70, '2007-08-09 21:54:18.456616', 652, '0ce85c0cf331d05f76aa4977c43e87e9ffbd0480', '05a37db4ba50ba5f28650ee74b450c2c', '0123456789012345678901234567890123456789012345678901234567890123', 70);
73-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (71, '2007-09-10 19:14:26.037382', 22897, 'd7ebed9e00fc134ebc79eaf7deebb30a4f5f6859', '0113f983ff8beba46ad64c4ae8899091', '0123456789012345678901234567890123456789012345678901234567890123', 71);
74-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (72, '2007-09-10 19:15:01.67038', 221, '0ddef36534d59da64790eeffa55cc0221a01736d', 'df6ce34951747929ca9c6a4e2cb78f94', '0123456789012345678901234567890123456789012345678901234567890123', 72);
75-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (73, '2007-09-10 19:15:19.947543', 217, 'ea265925f6214628dc46e731ca1e131f1e632127', '9d19d15feffc620c0d16523e0ce00a54', '0123456789012345678901234567890123456789012345678901234567890123', 73);
76-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (74, '2007-09-10 19:16:01.017943', 22899, '234acbb3dc11b2af9bc46b6e33f0e453c3b1289d', '6d2d916ea729bc875ca0bd739f6be476', '0123456789012345678901234567890123456789012345678901234567890123', 74);
77-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (75, '2007-12-18 16:31:34.790641', 4296, 'e8b25389964bc3bd471c20a1508d00852ee7de40', 'e6b759498b7cde49e9d34e7b8c8b4542', '0123456789012345678901234567890123456789012345678901234567890123', 75);
78-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (76, '2007-12-18 16:31:34.790641', 2103, 'c154e1c1c2407d9b80c96b63c48d61a94248bf95', 'd86630cafdf624a3aa32aba0c41078c5', '0123456789012345678901234567890123456789012345678901234567890123', 76);
79-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (77, '2007-12-18 16:31:34.790641', 2787, '2d94c4a6a014895f93b581fb0134efe73ae4e2c8', '315ef57e5f6ad295e98db65607c5c18a', '0123456789012345678901234567890123456789012345678901234567890123', 77);
80-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (78, '2007-12-18 16:31:34.790641', 3534, '2bd22db53f2b9e47df50ed731128ff1fc54a5775', 'e0d510b49f803a0a4c2b2712d0a80522', '0123456789012345678901234567890123456789012345678901234567890123', 78);
81-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (79, '2007-12-18 16:31:34.790641', 3327, 'a57356e4cbf97bbb47df202449a95d909d50614a', '8c5ffb558a0d0f520887f3d4cbd619c5', '0123456789012345678901234567890123456789012345678901234567890123', 79);
82-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (80, '2007-12-18 16:31:34.790641', 189, '9800f54c65017e1bafe2d09a13af6176ba0ab244', 'a94677aabcd34b0901f1f75a35f7dff3', '0123456789012345678901234567890123456789012345678901234567890123', 80);
83-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (81, '2007-12-18 16:31:34.790641', 2926, 'b53bb11bc40c42b0f9ecd981561fe9d6f265b275', '496cf1cbb97c17a67998478402520ab5', '0123456789012345678901234567890123456789012345678901234567890123', 81);
84-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (82, '2008-03-17 15:36:19.035615', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123', 82);
85-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (83, '2008-03-17 15:36:38.022812', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123', 83);
86-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (84, '2008-03-17 15:36:48.877842', 3, '55ca6286e3e4f4fba5d0448333fa99fc5a404a73', '764efa883dda1e11db47671c4a3bbd9e', '0123456789012345678901234567890123456789012345678901234567890123', 84);
87-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (85, '2008-03-17 15:37:10.252357', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123', 85);
88-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (86, '2008-03-17 15:37:22.489973', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123', 86);
89-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (87, '2008-03-17 15:37:36.701686', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123', 87);
90-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (88, '2008-03-17 15:37:48.465157', 3, '55ca6286e3e4f4fba5d0448333fa99fc5a404a73', '764efa883dda1e11db47671c4a3bbd9e', '0123456789012345678901234567890123456789012345678901234567890123', 88);
91-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (89, '2008-03-17 15:38:16.866444', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123', 89);
92-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (90, '2008-05-08 10:10:16.866444', 18, '0c805a60b31058a1018680f99447033dcb9d4caa', '8a8a67b8dbc5f203ae8712092c68c7aa', '0123456789012345678901234567890123456789012345678901234567890123', 90);
93-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (91, '2008-07-07 22:30:01.123456', 10, '0c805a60b31058a1018680f99447033dcb9d4c01', '8a8a67b8dbc5f203ae8712092c68c701', '0123456789012345678901234567890123456789012345678901234567890123', 91);
94-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (92, '2008-09-30 08:19:00.222131', 10, 'f10e2821bbbea527ea02200352313bc059445190', '7815696ecbf1c96e6894b779456d330e', '0123456789012345678901234567890123456789012345678901234567890123', 92);
95+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-04-07 16:46:05.265391', 178859, '378b3498ead213d35a82033a6e9196014a5ef25c', '01234567890123456789012345678900', '0123456789012345678901234567890123456789012345678901234567890123', 1);
96+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-04-07 16:46:05.266763', 9922560, 'a57faa6287aee2c58e115673a119c6083d31d1b9', '01234567890123456789012345678902', '0123456789012345678901234567890123456789012345678901234567890123', 2);
97+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-04-07 16:46:05.26727', 309386, 'b218ca7b52fa813550e3f14cdcf3ba68606e4446', '01234567890123456789012345678903', '0123456789012345678901234567890123456789012345678901234567890123', 3);
98+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-04-07 16:46:05.267803', 162927750, 'cfbd3ee1f510c66d49be465b900a3334e8488184', '01234567890123456789012345678904', '0123456789012345678901234567890123456789012345678901234567890123', 4);
99+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 10826, '502828e7591277535abe9015ffbc6918dbba8ef4', '01234567890123456789012345678907', '0123456789012345678901234567890123456789012345678901234567890123', 7);
100+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 10826, '502828e7591277535abe9015ffbc6918dbba8ef4', '01234567890123456789012345678907', '0123456789012345678901234567890123456789012345678901234567890123', 8);
101+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 12652, '07b01d1e6fe9a729f911e72dfe674a5e0abdc4ee', '01234567890123456789012345678911', '0123456789012345678901234567890123456789012345678901234567890123', 17);
102+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 12695, '8812d04c170ca90bb1423e188ce9706869aa03d7', '0123456789012345678901234567890b', '0123456789012345678901234567890123456789012345678901234567890123', 12);
103+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 13110, 'bc7bebca1e3c5c166838b19f0eeb7f171e51805d', '01234567890123456789012345678909', '0123456789012345678901234567890123456789012345678901234567890123', 10);
104+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 13133, 'db1b50cbde7142d344bd8ef9b2e1fe3b3116f77c', '0123456789012345678901234567890c', '0123456789012345678901234567890123456789012345678901234567890123', 13);
105+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 13240, '801dc911c2bd67e17eff087516fdc63a2ac322ce', '01234567890123456789012345678912', '0123456789012345678901234567890123456789012345678901234567890123', 18);
106+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 13269, 'fc8cab1cb1e5fb1efa3c3c475b8f7c8dc5038d50', '0123456789012345678901234567890f', '0123456789012345678901234567890123456789012345678901234567890123', 15);
107+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 13499, '78a26efee75a54f113063b78783b2d4612fee409', '0123456789012345678901234567890a', '0123456789012345678901234567890123456789012345678901234567890123', 11);
108+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 13641, 'e19cc1446e3004f10475c37b2cd363f75b8ae89a', '0123456789012345678901234567890d', '0123456789012345678901234567890123456789012345678901234567890123', 14);
109+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 13983, 'e17ee3031bd29dcd1e5905c0fd17945600a91ccf', '01234567890123456789012345678910', '0123456789012345678901234567890123456789012345678901234567890123', 16);
110+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 2655, 'ca3b107af84c05eaf98ba073376153986566ec28', '01234567890123456789012345678908', '0123456789012345678901234567890123456789012345678901234567890123', 9);
111+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 2961, '4468039e1d2cbdfc78d2e53477e5fe0537bae302', '0123456789012345678901234567891b', '0123456789012345678901234567890123456789012345678901234567890123', 27);
112+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 3305, 'b45b170da29f9b22650315657505124766c93720', '0123456789012345678901234567891e', '0123456789012345678901234567890123456789012345678901234567890123', 30);
113+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 3553, '20815563ee33368d51e3213354f97c05b4685968', '01234567890123456789012345678916', '0123456789012345678901234567890123456789012345678901234567890123', 22);
114+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 3558, 'd6c2ddacdab7618ce2a555c20a4a730fcdb42600', '0123456789012345678901234567891c', '0123456789012345678901234567890123456789012345678901234567890123', 28);
115+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 3561, '9eb09455e6a568605c1bbab4cdf1936eee92222d', '0123456789012345678901234567891d', '0123456789012345678901234567890123456789012345678901234567890123', 29);
116+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 3635, '4ab2ca308dafe152789640942488e23a33e4f46c', '01234567890123456789012345678915', '0123456789012345678901234567890123456789012345678901234567890123', 21);
117+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 3666, 'cca8fb78e05a34481e07683cea8c3a47f01c609e', '01234567890123456789012345678918', '0123456789012345678901234567890123456789012345678901234567890123', 24);
118+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 3778, '965968d3e6668f39ebc64bc11a3f1a5cd07c213b', '01234567890123456789012345678917', '0123456789012345678901234567890123456789012345678901234567890123', 23);
119+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 3793, '28a7accfb491a2b4895b49b810ca7cda0badc787', '01234567890123456789012345678919', '0123456789012345678901234567890123456789012345678901234567890123', 25);
120+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 3987, '9668ba9f0a59f9e6e6bc73fc5dc9f116b202bceb', '0123456789012345678901234567891f', '0123456789012345678901234567890123456789012345678901234567890123', 31);
121+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 4093, 'fc67a1770f78c45c396b4724195aeb10683aa2fd', '01234567890123456789012345678914', '0123456789012345678901234567890123456789012345678901234567890123', 20);
122+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 4165, 'fca78a2292e4034b8dfbb2de6f69e17ebeecaaa1', '01234567890123456789012345678913', '0123456789012345678901234567890123456789012345678901234567890123', 19);
123+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 4381, '9b1f78faa39fb09a9fd955d744002c2d8f32d88d', '01234567890123456789012345678905', '0123456789012345678901234567890123456789012345678901234567890123', 5);
124+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 4773, '03efb176f04f3897de7d5e6484864b0559fd6cd6', '0123456789012345678901234567891a', '0123456789012345678901234567890123456789012345678901234567890123', 26);
125+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 4908, '874a6ef9cd1aaef17653c6c12f4b83ef9487c1c3', '01234567890123456789012345678920', '0123456789012345678901234567890123456789012345678901234567890123', 32);
126+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 4908, '874a6ef9cd1aaef17653c6c12f4b83ef9487c1c3', '01234567890123456789012345678920', '0123456789012345678901234567890123456789012345678901234567890123', 33);
127+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 7910, 'afdf21d698587a6601e2ffed0f44292b7ad5dd07', '01234567890123456789012345678906', '0123456789012345678901234567890123456789012345678901234567890123', 6);
128+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-08-01 09:31:29.606407', 2, '71853c6197a6a7f222db0f1978c7cb232b87c5ee', '01234567890123456789012345678921', '0123456789012345678901234567890123456789012345678901234567890123', 35);
129+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-08-10 09:31:29.606407', 2, '71853c6197a6a7f222db0f1978c7cb232b87c5ee', '01234567890123456789012345678921', '0123456789012345678901234567890123456789012345678901234567890123', 34);
130+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-10-30 18:00:27.899028', 3, '0beec7b5ea3f0fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678922', '0123456789012345678901234567890123456789012345678901234567890123', 36);
131+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-10-30 18:00:27.899028', 3, '1e04c7b5ea3f0fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678923', '0123456789012345678901234567890123456789012345678901234567890123', 37);
132+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-10-30 18:00:27.899028', 3, '4e3961baf4f56fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678928', '0123456789012345678901234567890123456789012345678901234567890123', 43);
133+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-10-30 18:00:27.899028', 3, '5a04c7b5ea3f0fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678926', '0123456789012345678901234567890123456789012345678901234567890123', 40);
134+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-10-30 18:00:27.899028', 3, 'a10856bfea3f0bdb09550dd41f3c5bc275da8a33', '01234567890123456789012345678925', '0123456789012345678901234567890123456789012345678901234567890123', 39);
135+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-10-30 18:00:27.899028', 3, 'a45ed906e4f56fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678927', '0123456789012345678901234567890123456789012345678901234567890123', 42);
136+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-10-30 18:00:27.899028', 3, 'ae04c7b5ea3f0bdb095d0dd47f3c5bc275da8a33', '01234567890123456789012345678924', '0123456789012345678901234567890123456789012345678901234567890123', 38);
137+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-10-30 18:00:27.899028', 3, 'b45ed906e4f5afdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678929', '0123456789012345678901234567890123456789012345678901234567890123', 44);
138+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2006-05-24 09:31:29.606407', 2, '1622db354faa9fa653804d018f3b9d5291e37d6b', 'e4a7193a8f72fa2755e2162512069093', '0123456789012345678901234567890123456789012345678901234567890123', 52);
139+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2006-05-24 09:31:29.606407', 2, 'ab43246197a6a7f222db0f1978c7cb232b87c5ee', '0123456789012345678901234567892b', '0123456789012345678901234567890123456789012345678901234567890123', 46);
140+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2006-05-24 09:31:29.606407', 2, 'cabf42e197a6a7f222db0f1978c7cb232b87c5ee', '0123456789012345678901234567892c', '0123456789012345678901234567890123456789012345678901234567890123', 47);
141+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2006-05-24 09:31:29.606407', 2, 'fabb42e197a6a7f222db0f1978c7cb232b87c5ee', '0123456789012345678901234567892d', '0123456789012345678901234567890123456789012345678901234567890123', 59);
142+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2006-07-14 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5437', '0123456789012345678901234567890123456789012345678901234567890123', 51);
143+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2006-08-01 09:31:29.606407', 2, '43853c6197a6a7f222db0f1978c7cb232b87c5ee', '0123456789012345678901234567892a', '0123456789012345678901234567890123456789012345678901234567890123', 45);
144+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2006-12-01 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5437', '0123456789012345678901234567890123456789012345678901234567890123', 53);
145+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2006-12-01 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5438', '0123456789012345678901234567890123456789012345678901234567890123', 54);
146+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2006-12-01 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5439', '0123456789012345678901234567890123456789012345678901234567890123', 55);
147+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2006-12-01 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5440', '0123456789012345678901234567890123456789012345678901234567890123', 56);
148+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2006-12-13 21:17:56.241901', 1599, 'acdf6b9b99c39b1585f829ec7d68598a8e10816d', '5c6fa250b612e7e4d17261268a4d8400', '0123456789012345678901234567890123456789012345678901234567890123', 57);
149+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2006-12-13 21:18:28.796588', 1599, 'acdf6b9b99c39b1585f829ec7d68598a8e10816d', '5c6fa250b612e7e4d17261268a4d8401', '0123456789012345678901234567890123456789012345678901234567890123', 58);
150+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-01-03 17:26:27.288968', 11793, 'df3a6670671781d5e08d7795ca1ada776815d87f', 'e8120781cd606202fd259a4f0d4585bb', '0123456789012345678901234567890123456789012345678901234567890123', 60);
151+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-02-15 14:26:27.288968', 100, 'df3a6670671781d5e08d7795ca1ada776815d87f', 'e8120781cd606202fd259a4f0d4585b1', '0123456789012345678901234567890123456789012345678901234567890123', 61);
152+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-05-14 23:21:11.121446', 123, 'd06b970f258e57547ef1104fba3499eb4ab43ff6', '767e1635f55ff5e833410523decec438', '0123456789012345678901234567890123456789012345678901234567890123', 62);
153+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-05-14 23:21:11.121446', 123, 'd06b970f258e57547ef1104fba3499eb4ab43ff6', '767e1635f55ff5e833410523decec438', '0123456789012345678901234567890123456789012345678901234567890123', 63);
154+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-08-09 21:25:37.832976', 179, '3e00fea68e91f6e03de6333b4c8e60c2ce441926', 'f27fb7494c5afbb0fb10b78d16f7da37', '0123456789012345678901234567890123456789012345678901234567890123', 66);
155+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-08-09 21:25:37.832976', 567, 'b5aeb55faeb86a1d8c1a93dd58131b387a604c5a', '95f2b067e046d73f4e93eca44c034b97', '0123456789012345678901234567890123456789012345678901234567890123', 68);
156+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-08-09 21:25:37.832976', 610, '01bedc249af59cb80abb40b4898eced10f5d5e20', '7d6fa416334c6da3b954bf9ebff6e9ae', '0123456789012345678901234567890123456789012345678901234567890123', 67);
157+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-08-09 21:25:37.832976', 958, 'df4adf483eb24fec455e8411ca3dceb0bee51b44', 'b85b447f88c326c4124f0554e175097f', '0123456789012345678901234567890123456789012345678901234567890123', 65);
158+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-08-09 21:54:18.456616', 652, '0ce85c0cf331d05f76aa4977c43e87e9ffbd0480', '05a37db4ba50ba5f28650ee74b450c2c', '0123456789012345678901234567890123456789012345678901234567890123', 70);
159+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-08-09 21:54:18.456616', 749, '0526ef40da99af5c1c97c91f9aca77e7ae564838', '8afa3dbc21b2dcdad7f31ab28c041ad9', '0123456789012345678901234567890123456789012345678901234567890123', 69);
160+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-09-10 19:14:26.037382', 22897, 'd7ebed9e00fc134ebc79eaf7deebb30a4f5f6859', '0113f983ff8beba46ad64c4ae8899091', '0123456789012345678901234567890123456789012345678901234567890123', 71);
161+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-09-10 19:15:01.67038', 221, '0ddef36534d59da64790eeffa55cc0221a01736d', 'df6ce34951747929ca9c6a4e2cb78f94', '0123456789012345678901234567890123456789012345678901234567890123', 72);
162+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-09-10 19:15:19.947543', 217, 'ea265925f6214628dc46e731ca1e131f1e632127', '9d19d15feffc620c0d16523e0ce00a54', '0123456789012345678901234567890123456789012345678901234567890123', 73);
163+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-09-10 19:16:01.017943', 22899, '234acbb3dc11b2af9bc46b6e33f0e453c3b1289d', '6d2d916ea729bc875ca0bd739f6be476', '0123456789012345678901234567890123456789012345678901234567890123', 74);
164+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-12-18 16:31:34.790641', 189, '9800f54c65017e1bafe2d09a13af6176ba0ab244', 'a94677aabcd34b0901f1f75a35f7dff3', '0123456789012345678901234567890123456789012345678901234567890123', 80);
165+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-12-18 16:31:34.790641', 2103, 'c154e1c1c2407d9b80c96b63c48d61a94248bf95', 'd86630cafdf624a3aa32aba0c41078c5', '0123456789012345678901234567890123456789012345678901234567890123', 76);
166+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-12-18 16:31:34.790641', 2787, '2d94c4a6a014895f93b581fb0134efe73ae4e2c8', '315ef57e5f6ad295e98db65607c5c18a', '0123456789012345678901234567890123456789012345678901234567890123', 77);
167+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-12-18 16:31:34.790641', 2926, 'b53bb11bc40c42b0f9ecd981561fe9d6f265b275', '496cf1cbb97c17a67998478402520ab5', '0123456789012345678901234567890123456789012345678901234567890123', 81);
168+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-12-18 16:31:34.790641', 3327, 'a57356e4cbf97bbb47df202449a95d909d50614a', '8c5ffb558a0d0f520887f3d4cbd619c5', '0123456789012345678901234567890123456789012345678901234567890123', 79);
169+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-12-18 16:31:34.790641', 3534, '2bd22db53f2b9e47df50ed731128ff1fc54a5775', 'e0d510b49f803a0a4c2b2712d0a80522', '0123456789012345678901234567890123456789012345678901234567890123', 78);
170+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-12-18 16:31:34.790641', 4296, 'e8b25389964bc3bd471c20a1508d00852ee7de40', 'e6b759498b7cde49e9d34e7b8c8b4542', '0123456789012345678901234567890123456789012345678901234567890123', 75);
171+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2008-03-17 15:36:19.035615', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123', 82);
172+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2008-03-17 15:36:38.022812', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123', 83);
173+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2008-03-17 15:36:48.877842', 3, '55ca6286e3e4f4fba5d0448333fa99fc5a404a73', '764efa883dda1e11db47671c4a3bbd9e', '0123456789012345678901234567890123456789012345678901234567890123', 84);
174+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2008-03-17 15:37:10.252357', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123', 85);
175+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2008-03-17 15:37:22.489973', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123', 86);
176+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2008-03-17 15:37:36.701686', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123', 87);
177+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2008-03-17 15:37:48.465157', 3, '55ca6286e3e4f4fba5d0448333fa99fc5a404a73', '764efa883dda1e11db47671c4a3bbd9e', '0123456789012345678901234567890123456789012345678901234567890123', 88);
178+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2008-03-17 15:38:16.866444', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123', 89);
179+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2008-05-08 10:10:16.866444', 18, '0c805a60b31058a1018680f99447033dcb9d4caa', '8a8a67b8dbc5f203ae8712092c68c7aa', '0123456789012345678901234567890123456789012345678901234567890123', 90);
180+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2008-07-07 22:30:01.123456', 10, '0c805a60b31058a1018680f99447033dcb9d4c01', '8a8a67b8dbc5f203ae8712092c68c701', '0123456789012345678901234567890123456789012345678901234567890123', 91);
181+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2008-09-30 08:19:00.222131', 10, 'f10e2821bbbea527ea02200352313bc059445190', '7815696ecbf1c96e6894b779456d330e', '0123456789012345678901234567890123456789012345678901234567890123', 92);
182
183
184 ALTER TABLE libraryfilecontent ENABLE TRIGGER ALL;
185@@ -753,93 +753,93 @@
186
187 ALTER TABLE libraryfilealias DISABLE TRIGGER ALL;
188
189-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (1, 1, 'netapplet-1.0.0.tar.gz', 'application/x-gtar', NULL, '2005-04-07 16:46:05.265391', false, 0, 1);
190-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (2, 1, 'netapplet_1.0.0.orig.tar.gz', 'application/x-gtar', NULL, '2005-04-07 16:46:05.265391', false, 0, 1);
191-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (3, 2, 'firefox_0.9.2.orig.tar.gz', 'application/x-gtar', NULL, '2005-04-07 16:46:05.266763', false, 0, 2);
192-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (4, 3, 'evolution-1.0.tar.gz', 'application/x-gtar', NULL, '2005-04-07 16:46:05.26727', false, 0, 3);
193-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (5, 5, 'netapplet.pot', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 5);
194-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (6, 6, 'pmount.pot', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 6);
195-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (7, 7, 'evolution-2.2.pot', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 7);
196-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (8, 8, 'evolution-2.2.pot', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 8);
197-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (9, 9, 'pkgconf-mozilla.pot', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 9);
198-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (10, 10, 'hr.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 10);
199-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (11, 11, 'ca.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 11);
200-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (12, 12, 'nb.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 12);
201-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (13, 13, 'cs.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 13);
202-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (14, 14, 'es_ES.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 14);
203-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (15, 15, 'de.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 15);
204-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (16, 16, 'fr.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 16);
205-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (17, 17, 'it_IT.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 17);
206-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (18, 18, 'es.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 18);
207-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (19, 19, 'fr.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 19);
208-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (20, 20, 'pt_BR.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 20);
209-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (21, 21, 'ja.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 21);
210-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (22, 22, 'es.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 22);
211-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (23, 23, 'nl.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 23);
212-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (24, 24, 'cs.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 24);
213-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (25, 25, 'da.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 25);
214-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (26, 26, 'fi.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 26);
215-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (27, 27, 'gl.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 27);
216-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (28, 28, 'lt.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 28);
217-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (29, 29, 'it.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 29);
218-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (30, 30, 'tr.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 30);
219-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (31, 31, 'de.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 31);
220-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (32, 32, 'es.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 32);
221-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (33, 33, 'es.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 33);
222-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (34, 34, 'evolution-2.2-test.pot', 'application/x-po', NULL, '2005-08-10 09:31:29.606407', false, 0, 34);
223-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (35, 35, 'Ubuntu-High-Pri-2005-08-01.csv', 'text/plain', NULL, '2005-08-01 09:31:29.606407', false, 0, 35);
224-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (36, NULL, 'foo.txt', 'text/plain', NULL, '2005-10-30 18:00:27.899028', false, 0, NULL);
225-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (37, 37, 'pmount_1.9-1_all.deb', 'application/x-debian-package', NULL, '2005-10-30 18:00:27.899028', false, 0, 37);
226-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (38, 38, 'alsa-utils_1.0.9a-4.dsc', 'application/dsc', NULL, '2005-10-30 18:00:27.899028', false, 0, 38);
227-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (39, 39, 'alsa-utils_1.0.8-1ubuntu1.dsc', 'application/dsc', NULL, '2005-10-30 18:00:27.899028', false, 0, 39);
228-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (40, 40, 'mozilla-firefox_0.9_i386.deb', 'application/x-debian-package', NULL, '2005-10-30 18:00:27.899028', false, 0, 40);
229-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (42, 42, 'linux-2.6.12_2.6.12.20_i386.deb', 'application/x-debian-package', NULL, '2005-10-30 18:00:27.899028', false, 0, 42);
230-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (43, 43, 'alsa-utils_1.0.9a-4ubuntu1.dsc', 'application/x-debian-package', NULL, '2005-10-30 18:00:27.899028', false, 0, 43);
231-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (44, 44, 'at-3.14156_all.udeb', 'application/x-debian-package', NULL, '2005-10-30 18:00:27.899028', false, 0, 44);
232-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (45, 45, 'Ubuntu-High-Pri-2006-08-01.csv', 'text/plain', NULL, '2006-08-01 09:31:29.606407', false, 0, 45);
233-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (46, 46, 'non-existent-mirrorprober-logfile.txt', 'text/plain', NULL, '2006-05-24 09:31:29.606407', false, 0, 46);
234-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (47, 47, 'non-existent-mirrorprober-logfile.txt', 'text/plain', NULL, '2006-05-24 09:31:29.606407', false, 0, 47);
235-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (51, 51, 'x4cWPgneBxsZOM21ZzpRPxsZXod.msg', 'message/rfc822', NULL, '2006-07-14 16:41:34.028627', false, 0, 51);
236-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (52, 52, 'mozilla-firefox_0.9_i386.changes', 'text/plain', NULL, '2006-05-24 09:31:29.606407', false, 0, 52);
237-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (53, 53, 'cdrkit-1.0.dsc', 'application/dsc', NULL, '2006-12-01 16:41:34.028627', false, 0, 53);
238-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (54, 54, 'foobar-1.0.dsc', 'application/dsc', NULL, '2006-12-01 16:41:34.028627', false, 0, 54);
239-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (55, 55, 'cdrkit_1.0_all.deb', 'application/deb', NULL, '2006-12-01 16:41:34.028627', false, 0, 55);
240-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (56, 56, 'foobar_1.0_all.deb', 'application/deb', NULL, '2006-12-01 16:41:34.028627', false, 0, 56);
241-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (57, 57, 'evolution-2.2-test.pot', 'application/x-po', NULL, '2006-12-13 21:17:56.241901', false, 0, 57);
242-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (58, 58, 'pt_BR.po', 'application/x-po', NULL, '2006-12-13 21:18:28.796588', false, 0, 58);
243-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (59, 59, 'salgado-mugshot.jpg', 'image/jpeg', NULL, '2006-05-24 09:31:29.606407', false, 0, 59);
244-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (60, 60, 'es.po', 'application/x-po', NULL, '2007-01-03 17:26:27.288968', false, 0, 60);
245-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (61, 61, 'language-pack-ar_1.0.dsc', 'application/dsc', NULL, '2007-02-15 14:26:27.288968', false, 0, 61);
246-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (62, 62, 'iceweasel-1.0.dsc', 'application/dsc', NULL, '2007-05-14 23:21:11.121446', false, 0, 62);
247-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (63, 63, 'hwsubmission1.xml', 'text/xml', NULL, '2007-05-14 23:21:11.121446', false, 0, 63);
248-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (65, 65, 'commercialpackage_1.0-1_source.changes', 'text/plain', NULL, '2007-08-09 21:25:37.832976', false, 0, 65);
249-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (66, 66, 'commercialpackage_1.0.orig.tar.gz', 'application/gzipped-tar', NULL, '2007-08-09 21:25:37.832976', false, 0, 66);
250-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (67, 67, 'commercialpackage_1.0-1.diff.gz', 'application/gzipped-patch', NULL, '2007-08-09 21:25:37.832976', false, 0, 67);
251-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (68, 68, 'commercialpackage_1.0-1.dsc', 'text/x-debian-source-package', NULL, '2007-08-09 21:25:37.832976', false, 0, 68);
252-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (69, 69, 'commercialpackage_1.0-1_i386.changes', 'text/plain', NULL, '2007-08-09 21:54:18.456616', false, 0, 69);
253-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (70, 70, 'commercialpackage_1.0-1_i386.deb', 'application/x-debian-package', NULL, '2007-08-09 21:54:18.456616', false, 0, 70);
254-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (71, 71, 'ubuntu-hoary-translations.tar.gz', 'application/x-gtar', NULL, '2007-09-10 19:14:26.037382', false, 0, 71);
255-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (72, 72, 'ubuntu-hoary-translations-update.tar.gz', 'application/x-gtar', NULL, '2007-09-10 19:15:01.67038', false, 0, 72);
256-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (73, 73, 'ubuntu-hoary-translations-update.tar.gz', 'application/x-gtar', NULL, '2007-09-10 19:15:19.947543', false, 0, 73);
257-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (74, 74, 'ubuntu-hoary-translations.tar.gz', 'application/x-gtar', NULL, '2007-09-10 19:16:01.017943', false, 0, 74);
258-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (75, 75, 'cX0Ey6rIIK5MqHphucFPna1fQMt.msg', 'message/rfc822', NULL, '2007-12-18 16:31:34.790641', false, 0, 75);
259-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (76, 76, 'nSpn1l12p7HBplm6e7kaaX6lf86.msg', 'message/rfc822', NULL, '2007-12-18 16:31:34.790641', false, 0, 76);
260-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (77, 77, 'evJ9qHEN3ufdtsDUnGPb8a5hs77.msg', 'message/rfc822', NULL, '2007-12-18 16:31:34.790641', false, 0, 77);
261-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (78, 78, 'jqUQpLymm7f9DjBAAsQoM10WndS.msg', 'message/rfc822', NULL, '2007-12-18 16:31:34.790641', false, 0, 78);
262-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (79, 79, '378cZyfOfUKx6BySEK0HYKz4Tpd.msg', 'message/rfc822', NULL, '2007-12-18 16:31:34.790641', false, 0, 79);
263-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (80, 80, 'unnamed', 'application/pgp-signature; name="signature.asc"', NULL, '2007-12-18 16:31:34.790641', false, 0, 80);
264-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (81, 81, 'jm81HhLQDRDAsqbl74W7GT3cpel.msg', 'message/rfc822', NULL, '2007-12-18 16:31:34.790641', false, 0, 81);
265-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (82, 82, 'alsa-1.0.9a.exe', 'application/x-msdos-program', NULL, '2008-03-17 15:36:19.035615', false, 0, 82);
266-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (83, 83, 'alsa-1.0.9a.dmg', 'application/x-apple-diskimage', NULL, '2008-03-17 15:36:38.022812', false, 0, 83);
267-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (84, 84, 'README.txt', 'text/plain', NULL, '2008-03-17 15:36:48.877842', false, 0, 84);
268-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (85, 85, 'alsa-1.0.8.exe', 'application/x-msdos-program', NULL, '2008-03-17 15:37:10.252357', false, 0, 85);
269-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (86, 86, 'alsa-1.0.8.dmg', 'application/x-apple-diskimage', NULL, '2008-03-17 15:37:22.489973', false, 0, 86);
270-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (87, 87, 'alsa-1.0.8.tgz', 'application/x-tar', NULL, '2008-03-17 15:37:36.701686', false, 0, 87);
271-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (88, 88, 'README.txt', 'text/plain', NULL, '2008-03-17 15:37:48.465157', false, 0, 88);
272-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (89, 89, 'alsa-1.0.9a.tgz', 'application/x-tar', NULL, '2008-03-17 15:38:16.866444', false, 0, 89);
273-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (90, 90, 'pmount_1.0-1_all.deb', 'application/x-debian-package', NULL, '2008-05-08 10:10:27.899028', false, 0, 90);
274-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (91, 91, 'upload_22_log.txt', 'application/text', NULL, '2008-07-07 22:30:01.123456', false, 0, 91);
275-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (92, 92, 'sample-submission-2.xml', 'application/x-bzip2', NULL, '2008-09-30 08:19:00.222131', false, 0, 92);
276+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (1, 'netapplet-1.0.0.tar.gz', 'application/x-gtar', NULL, '2005-04-07 16:46:05.265391', false, 0, 1);
277+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (2, 'netapplet_1.0.0.orig.tar.gz', 'application/x-gtar', NULL, '2005-04-07 16:46:05.265391', false, 0, 1);
278+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (3, 'firefox_0.9.2.orig.tar.gz', 'application/x-gtar', NULL, '2005-04-07 16:46:05.266763', false, 0, 2);
279+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (4, 'evolution-1.0.tar.gz', 'application/x-gtar', NULL, '2005-04-07 16:46:05.26727', false, 0, 3);
280+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (5, 'netapplet.pot', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 5);
281+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (6, 'pmount.pot', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 6);
282+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (7, 'evolution-2.2.pot', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 7);
283+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (8, 'evolution-2.2.pot', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 8);
284+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (9, 'pkgconf-mozilla.pot', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 9);
285+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (10, 'hr.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 10);
286+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (11, 'ca.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 11);
287+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (12, 'nb.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 12);
288+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (13, 'cs.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 13);
289+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (14, 'es_ES.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 14);
290+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (15, 'de.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 15);
291+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (16, 'fr.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 16);
292+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (17, 'it_IT.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 17);
293+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (18, 'es.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 18);
294+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (19, 'fr.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 19);
295+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (20, 'pt_BR.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 20);
296+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (21, 'ja.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 21);
297+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (22, 'es.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 22);
298+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (23, 'nl.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 23);
299+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (24, 'cs.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 24);
300+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (25, 'da.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 25);
301+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (26, 'fi.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 26);
302+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (27, 'gl.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 27);
303+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (28, 'lt.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 28);
304+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (29, 'it.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 29);
305+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (30, 'tr.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 30);
306+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (31, 'de.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 31);
307+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (32, 'es.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 32);
308+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (33, 'es.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 33);
309+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (34, 'evolution-2.2-test.pot', 'application/x-po', NULL, '2005-08-10 09:31:29.606407', false, 0, 34);
310+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (35, 'Ubuntu-High-Pri-2005-08-01.csv', 'text/plain', NULL, '2005-08-01 09:31:29.606407', false, 0, 35);
311+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (36, 'foo.txt', 'text/plain', NULL, '2005-10-30 18:00:27.899028', false, 0, NULL);
312+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (37, 'pmount_1.9-1_all.deb', 'application/x-debian-package', NULL, '2005-10-30 18:00:27.899028', false, 0, 37);
313+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (38, 'alsa-utils_1.0.9a-4.dsc', 'application/dsc', NULL, '2005-10-30 18:00:27.899028', false, 0, 38);
314+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (39, 'alsa-utils_1.0.8-1ubuntu1.dsc', 'application/dsc', NULL, '2005-10-30 18:00:27.899028', false, 0, 39);
315+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (40, 'mozilla-firefox_0.9_i386.deb', 'application/x-debian-package', NULL, '2005-10-30 18:00:27.899028', false, 0, 40);
316+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (42, 'linux-2.6.12_2.6.12.20_i386.deb', 'application/x-debian-package', NULL, '2005-10-30 18:00:27.899028', false, 0, 42);
317+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (43, 'alsa-utils_1.0.9a-4ubuntu1.dsc', 'application/x-debian-package', NULL, '2005-10-30 18:00:27.899028', false, 0, 43);
318+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (44, 'at-3.14156_all.udeb', 'application/x-debian-package', NULL, '2005-10-30 18:00:27.899028', false, 0, 44);
319+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (45, 'Ubuntu-High-Pri-2006-08-01.csv', 'text/plain', NULL, '2006-08-01 09:31:29.606407', false, 0, 45);
320+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (46, 'non-existent-mirrorprober-logfile.txt', 'text/plain', NULL, '2006-05-24 09:31:29.606407', false, 0, 46);
321+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (47, 'non-existent-mirrorprober-logfile.txt', 'text/plain', NULL, '2006-05-24 09:31:29.606407', false, 0, 47);
322+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (51, 'x4cWPgneBxsZOM21ZzpRPxsZXod.msg', 'message/rfc822', NULL, '2006-07-14 16:41:34.028627', false, 0, 51);
323+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (52, 'mozilla-firefox_0.9_i386.changes', 'text/plain', NULL, '2006-05-24 09:31:29.606407', false, 0, 52);
324+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (53, 'cdrkit-1.0.dsc', 'application/dsc', NULL, '2006-12-01 16:41:34.028627', false, 0, 53);
325+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (54, 'foobar-1.0.dsc', 'application/dsc', NULL, '2006-12-01 16:41:34.028627', false, 0, 54);
326+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (55, 'cdrkit_1.0_all.deb', 'application/deb', NULL, '2006-12-01 16:41:34.028627', false, 0, 55);
327+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (56, 'foobar_1.0_all.deb', 'application/deb', NULL, '2006-12-01 16:41:34.028627', false, 0, 56);
328+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (57, 'evolution-2.2-test.pot', 'application/x-po', NULL, '2006-12-13 21:17:56.241901', false, 0, 57);
329+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (58, 'pt_BR.po', 'application/x-po', NULL, '2006-12-13 21:18:28.796588', false, 0, 58);
330+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (59, 'salgado-mugshot.jpg', 'image/jpeg', NULL, '2006-05-24 09:31:29.606407', false, 0, 59);
331+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (60, 'es.po', 'application/x-po', NULL, '2007-01-03 17:26:27.288968', false, 0, 60);
332+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (61, 'language-pack-ar_1.0.dsc', 'application/dsc', NULL, '2007-02-15 14:26:27.288968', false, 0, 61);
333+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (62, 'iceweasel-1.0.dsc', 'application/dsc', NULL, '2007-05-14 23:21:11.121446', false, 0, 62);
334+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (63, 'hwsubmission1.xml', 'text/xml', NULL, '2007-05-14 23:21:11.121446', false, 0, 63);
335+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (65, 'commercialpackage_1.0-1_source.changes', 'text/plain', NULL, '2007-08-09 21:25:37.832976', false, 0, 65);
336+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (66, 'commercialpackage_1.0.orig.tar.gz', 'application/gzipped-tar', NULL, '2007-08-09 21:25:37.832976', false, 0, 66);
337+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (67, 'commercialpackage_1.0-1.diff.gz', 'application/gzipped-patch', NULL, '2007-08-09 21:25:37.832976', false, 0, 67);
338+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (68, 'commercialpackage_1.0-1.dsc', 'text/x-debian-source-package', NULL, '2007-08-09 21:25:37.832976', false, 0, 68);
339+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (69, 'commercialpackage_1.0-1_i386.changes', 'text/plain', NULL, '2007-08-09 21:54:18.456616', false, 0, 69);
340+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (70, 'commercialpackage_1.0-1_i386.deb', 'application/x-debian-package', NULL, '2007-08-09 21:54:18.456616', false, 0, 70);
341+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (71, 'ubuntu-hoary-translations.tar.gz', 'application/x-gtar', NULL, '2007-09-10 19:14:26.037382', false, 0, 71);
342+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (72, 'ubuntu-hoary-translations-update.tar.gz', 'application/x-gtar', NULL, '2007-09-10 19:15:01.67038', false, 0, 72);
343+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (73, 'ubuntu-hoary-translations-update.tar.gz', 'application/x-gtar', NULL, '2007-09-10 19:15:19.947543', false, 0, 73);
344+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (74, 'ubuntu-hoary-translations.tar.gz', 'application/x-gtar', NULL, '2007-09-10 19:16:01.017943', false, 0, 74);
345+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (75, 'cX0Ey6rIIK5MqHphucFPna1fQMt.msg', 'message/rfc822', NULL, '2007-12-18 16:31:34.790641', false, 0, 75);
346+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (76, 'nSpn1l12p7HBplm6e7kaaX6lf86.msg', 'message/rfc822', NULL, '2007-12-18 16:31:34.790641', false, 0, 76);
347+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (77, 'evJ9qHEN3ufdtsDUnGPb8a5hs77.msg', 'message/rfc822', NULL, '2007-12-18 16:31:34.790641', false, 0, 77);
348+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (78, 'jqUQpLymm7f9DjBAAsQoM10WndS.msg', 'message/rfc822', NULL, '2007-12-18 16:31:34.790641', false, 0, 78);
349+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (79, '378cZyfOfUKx6BySEK0HYKz4Tpd.msg', 'message/rfc822', NULL, '2007-12-18 16:31:34.790641', false, 0, 79);
350+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (80, 'unnamed', 'application/pgp-signature; name="signature.asc"', NULL, '2007-12-18 16:31:34.790641', false, 0, 80);
351+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (81, 'jm81HhLQDRDAsqbl74W7GT3cpel.msg', 'message/rfc822', NULL, '2007-12-18 16:31:34.790641', false, 0, 81);
352+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (82, 'alsa-1.0.9a.exe', 'application/x-msdos-program', NULL, '2008-03-17 15:36:19.035615', false, 0, 82);
353+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (83, 'alsa-1.0.9a.dmg', 'application/x-apple-diskimage', NULL, '2008-03-17 15:36:38.022812', false, 0, 83);
354+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (84, 'README.txt', 'text/plain', NULL, '2008-03-17 15:36:48.877842', false, 0, 84);
355+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (85, 'alsa-1.0.8.exe', 'application/x-msdos-program', NULL, '2008-03-17 15:37:10.252357', false, 0, 85);
356+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (86, 'alsa-1.0.8.dmg', 'application/x-apple-diskimage', NULL, '2008-03-17 15:37:22.489973', false, 0, 86);
357+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (87, 'alsa-1.0.8.tgz', 'application/x-tar', NULL, '2008-03-17 15:37:36.701686', false, 0, 87);
358+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (88, 'README.txt', 'text/plain', NULL, '2008-03-17 15:37:48.465157', false, 0, 88);
359+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (89, 'alsa-1.0.9a.tgz', 'application/x-tar', NULL, '2008-03-17 15:38:16.866444', false, 0, 89);
360+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (90, 'pmount_1.0-1_all.deb', 'application/x-debian-package', NULL, '2008-05-08 10:10:27.899028', false, 0, 90);
361+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (91, 'upload_22_log.txt', 'application/text', NULL, '2008-07-07 22:30:01.123456', false, 0, 91);
362+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (92, 'sample-submission-2.xml', 'application/x-bzip2', NULL, '2008-09-30 08:19:00.222131', false, 0, 92);
363
364
365 ALTER TABLE libraryfilealias ENABLE TRIGGER ALL;
366
367=== modified file 'database/sampledata/current.sql'
368--- database/sampledata/current.sql 2014-08-04 06:45:45 +0000
369+++ database/sampledata/current.sql 2014-08-08 07:05:30 +0000
370@@ -659,93 +659,93 @@
371
372 ALTER TABLE libraryfilecontent DISABLE TRIGGER ALL;
373
374-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (1, '2005-04-07 16:46:05.265391', 178859, '378b3498ead213d35a82033a6e9196014a5ef25c', '01234567890123456789012345678900', '0123456789012345678901234567890123456789012345678901234567890123', 1);
375-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (2, '2005-04-07 16:46:05.266763', 9922560, 'a57faa6287aee2c58e115673a119c6083d31d1b9', '01234567890123456789012345678902', '0123456789012345678901234567890123456789012345678901234567890123', 2);
376-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (3, '2005-04-07 16:46:05.26727', 309386, 'b218ca7b52fa813550e3f14cdcf3ba68606e4446', '01234567890123456789012345678903', '0123456789012345678901234567890123456789012345678901234567890123', 3);
377-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (4, '2005-04-07 16:46:05.267803', 162927750, 'cfbd3ee1f510c66d49be465b900a3334e8488184', '01234567890123456789012345678904', '0123456789012345678901234567890123456789012345678901234567890123', 4);
378-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (5, '2005-05-18 08:03:28.021862', 4381, '9b1f78faa39fb09a9fd955d744002c2d8f32d88d', '01234567890123456789012345678905', '0123456789012345678901234567890123456789012345678901234567890123', 5);
379-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (6, '2005-05-18 08:03:28.021862', 7910, 'afdf21d698587a6601e2ffed0f44292b7ad5dd07', '01234567890123456789012345678906', '0123456789012345678901234567890123456789012345678901234567890123', 6);
380-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (7, '2005-05-18 08:03:28.021862', 10826, '502828e7591277535abe9015ffbc6918dbba8ef4', '01234567890123456789012345678907', '0123456789012345678901234567890123456789012345678901234567890123', 7);
381-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (8, '2005-05-18 08:03:28.021862', 10826, '502828e7591277535abe9015ffbc6918dbba8ef4', '01234567890123456789012345678907', '0123456789012345678901234567890123456789012345678901234567890123', 8);
382-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (9, '2005-05-18 08:03:28.021862', 2655, 'ca3b107af84c05eaf98ba073376153986566ec28', '01234567890123456789012345678908', '0123456789012345678901234567890123456789012345678901234567890123', 9);
383-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (10, '2005-05-18 08:03:28.021862', 13110, 'bc7bebca1e3c5c166838b19f0eeb7f171e51805d', '01234567890123456789012345678909', '0123456789012345678901234567890123456789012345678901234567890123', 10);
384-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (11, '2005-05-18 08:03:28.021862', 13499, '78a26efee75a54f113063b78783b2d4612fee409', '0123456789012345678901234567890a', '0123456789012345678901234567890123456789012345678901234567890123', 11);
385-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (12, '2005-05-18 08:03:28.021862', 12695, '8812d04c170ca90bb1423e188ce9706869aa03d7', '0123456789012345678901234567890b', '0123456789012345678901234567890123456789012345678901234567890123', 12);
386-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (13, '2005-05-18 08:03:28.021862', 13133, 'db1b50cbde7142d344bd8ef9b2e1fe3b3116f77c', '0123456789012345678901234567890c', '0123456789012345678901234567890123456789012345678901234567890123', 13);
387-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (14, '2005-05-18 08:03:28.021862', 13641, 'e19cc1446e3004f10475c37b2cd363f75b8ae89a', '0123456789012345678901234567890d', '0123456789012345678901234567890123456789012345678901234567890123', 14);
388-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (15, '2005-05-18 08:03:28.021862', 13269, 'fc8cab1cb1e5fb1efa3c3c475b8f7c8dc5038d50', '0123456789012345678901234567890f', '0123456789012345678901234567890123456789012345678901234567890123', 15);
389-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (16, '2005-05-18 08:03:28.021862', 13983, 'e17ee3031bd29dcd1e5905c0fd17945600a91ccf', '01234567890123456789012345678910', '0123456789012345678901234567890123456789012345678901234567890123', 16);
390-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (17, '2005-05-18 08:03:28.021862', 12652, '07b01d1e6fe9a729f911e72dfe674a5e0abdc4ee', '01234567890123456789012345678911', '0123456789012345678901234567890123456789012345678901234567890123', 17);
391-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (18, '2005-05-18 08:03:28.021862', 13240, '801dc911c2bd67e17eff087516fdc63a2ac322ce', '01234567890123456789012345678912', '0123456789012345678901234567890123456789012345678901234567890123', 18);
392-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (19, '2005-05-18 08:03:28.021862', 4165, 'fca78a2292e4034b8dfbb2de6f69e17ebeecaaa1', '01234567890123456789012345678913', '0123456789012345678901234567890123456789012345678901234567890123', 19);
393-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (20, '2005-05-18 08:03:28.021862', 4093, 'fc67a1770f78c45c396b4724195aeb10683aa2fd', '01234567890123456789012345678914', '0123456789012345678901234567890123456789012345678901234567890123', 20);
394-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (21, '2005-05-18 08:03:28.021862', 3635, '4ab2ca308dafe152789640942488e23a33e4f46c', '01234567890123456789012345678915', '0123456789012345678901234567890123456789012345678901234567890123', 21);
395-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (22, '2005-05-18 08:03:28.021862', 3553, '20815563ee33368d51e3213354f97c05b4685968', '01234567890123456789012345678916', '0123456789012345678901234567890123456789012345678901234567890123', 22);
396-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (23, '2005-05-18 08:03:28.021862', 3778, '965968d3e6668f39ebc64bc11a3f1a5cd07c213b', '01234567890123456789012345678917', '0123456789012345678901234567890123456789012345678901234567890123', 23);
397-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (24, '2005-05-18 08:03:28.021862', 3666, 'cca8fb78e05a34481e07683cea8c3a47f01c609e', '01234567890123456789012345678918', '0123456789012345678901234567890123456789012345678901234567890123', 24);
398-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (25, '2005-05-18 08:03:28.021862', 3793, '28a7accfb491a2b4895b49b810ca7cda0badc787', '01234567890123456789012345678919', '0123456789012345678901234567890123456789012345678901234567890123', 25);
399-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (26, '2005-05-18 08:03:28.021862', 4773, '03efb176f04f3897de7d5e6484864b0559fd6cd6', '0123456789012345678901234567891a', '0123456789012345678901234567890123456789012345678901234567890123', 26);
400-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (27, '2005-05-18 08:03:28.021862', 2961, '4468039e1d2cbdfc78d2e53477e5fe0537bae302', '0123456789012345678901234567891b', '0123456789012345678901234567890123456789012345678901234567890123', 27);
401-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (28, '2005-05-18 08:03:28.021862', 3558, 'd6c2ddacdab7618ce2a555c20a4a730fcdb42600', '0123456789012345678901234567891c', '0123456789012345678901234567890123456789012345678901234567890123', 28);
402-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (29, '2005-05-18 08:03:28.021862', 3561, '9eb09455e6a568605c1bbab4cdf1936eee92222d', '0123456789012345678901234567891d', '0123456789012345678901234567890123456789012345678901234567890123', 29);
403-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (30, '2005-05-18 08:03:28.021862', 3305, 'b45b170da29f9b22650315657505124766c93720', '0123456789012345678901234567891e', '0123456789012345678901234567890123456789012345678901234567890123', 30);
404-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (31, '2005-05-18 08:03:28.021862', 3987, '9668ba9f0a59f9e6e6bc73fc5dc9f116b202bceb', '0123456789012345678901234567891f', '0123456789012345678901234567890123456789012345678901234567890123', 31);
405-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (32, '2005-05-18 08:03:28.021862', 4908, '874a6ef9cd1aaef17653c6c12f4b83ef9487c1c3', '01234567890123456789012345678920', '0123456789012345678901234567890123456789012345678901234567890123', 32);
406-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (33, '2005-05-18 08:03:28.021862', 4908, '874a6ef9cd1aaef17653c6c12f4b83ef9487c1c3', '01234567890123456789012345678920', '0123456789012345678901234567890123456789012345678901234567890123', 33);
407-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (34, '2005-08-10 09:31:29.606407', 2, '71853c6197a6a7f222db0f1978c7cb232b87c5ee', '01234567890123456789012345678921', '0123456789012345678901234567890123456789012345678901234567890123', 34);
408-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (35, '2005-08-01 09:31:29.606407', 2, '71853c6197a6a7f222db0f1978c7cb232b87c5ee', '01234567890123456789012345678921', '0123456789012345678901234567890123456789012345678901234567890123', 35);
409-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (36, '2005-10-30 18:00:27.899028', 3, '0beec7b5ea3f0fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678922', '0123456789012345678901234567890123456789012345678901234567890123', 36);
410-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (37, '2005-10-30 18:00:27.899028', 3, '1e04c7b5ea3f0fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678923', '0123456789012345678901234567890123456789012345678901234567890123', 37);
411-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (38, '2005-10-30 18:00:27.899028', 3, 'ae04c7b5ea3f0bdb095d0dd47f3c5bc275da8a33', '01234567890123456789012345678924', '0123456789012345678901234567890123456789012345678901234567890123', 38);
412-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (39, '2005-10-30 18:00:27.899028', 3, 'a10856bfea3f0bdb09550dd41f3c5bc275da8a33', '01234567890123456789012345678925', '0123456789012345678901234567890123456789012345678901234567890123', 39);
413-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (40, '2005-10-30 18:00:27.899028', 3, '5a04c7b5ea3f0fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678926', '0123456789012345678901234567890123456789012345678901234567890123', 40);
414-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (42, '2005-10-30 18:00:27.899028', 3, 'a45ed906e4f56fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678927', '0123456789012345678901234567890123456789012345678901234567890123', 42);
415-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (43, '2005-10-30 18:00:27.899028', 3, '4e3961baf4f56fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678928', '0123456789012345678901234567890123456789012345678901234567890123', 43);
416-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (44, '2005-10-30 18:00:27.899028', 3, 'b45ed906e4f5afdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678929', '0123456789012345678901234567890123456789012345678901234567890123', 44);
417-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (45, '2006-08-01 09:31:29.606407', 2, '43853c6197a6a7f222db0f1978c7cb232b87c5ee', '0123456789012345678901234567892a', '0123456789012345678901234567890123456789012345678901234567890123', 45);
418-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (46, '2006-05-24 09:31:29.606407', 2, 'ab43246197a6a7f222db0f1978c7cb232b87c5ee', '0123456789012345678901234567892b', '0123456789012345678901234567890123456789012345678901234567890123', 46);
419-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (47, '2006-05-24 09:31:29.606407', 2, 'cabf42e197a6a7f222db0f1978c7cb232b87c5ee', '0123456789012345678901234567892c', '0123456789012345678901234567890123456789012345678901234567890123', 47);
420-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (51, '2006-07-14 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5437', '0123456789012345678901234567890123456789012345678901234567890123', 51);
421-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (52, '2006-05-24 09:31:29.606407', 2, '1622db354faa9fa653804d018f3b9d5291e37d6b', 'e4a7193a8f72fa2755e2162512069093', '0123456789012345678901234567890123456789012345678901234567890123', 52);
422-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (53, '2006-12-01 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5437', '0123456789012345678901234567890123456789012345678901234567890123', 53);
423-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (54, '2006-12-01 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5438', '0123456789012345678901234567890123456789012345678901234567890123', 54);
424-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (55, '2006-12-01 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5439', '0123456789012345678901234567890123456789012345678901234567890123', 55);
425-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (56, '2006-12-01 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5440', '0123456789012345678901234567890123456789012345678901234567890123', 56);
426-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (57, '2006-12-13 21:17:56.241901', 1599, 'acdf6b9b99c39b1585f829ec7d68598a8e10816d', '5c6fa250b612e7e4d17261268a4d8400', '0123456789012345678901234567890123456789012345678901234567890123', 57);
427-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (58, '2006-12-13 21:18:28.796588', 1599, 'acdf6b9b99c39b1585f829ec7d68598a8e10816d', '5c6fa250b612e7e4d17261268a4d8401', '0123456789012345678901234567890123456789012345678901234567890123', 58);
428-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (59, '2006-05-24 09:31:29.606407', 2, 'fabb42e197a6a7f222db0f1978c7cb232b87c5ee', '0123456789012345678901234567892d', '0123456789012345678901234567890123456789012345678901234567890123', 59);
429-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (60, '2007-01-03 17:26:27.288968', 11793, 'df3a6670671781d5e08d7795ca1ada776815d87f', 'e8120781cd606202fd259a4f0d4585bb', '0123456789012345678901234567890123456789012345678901234567890123', 60);
430-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (61, '2007-02-15 14:26:27.288968', 100, 'df3a6670671781d5e08d7795ca1ada776815d87f', 'e8120781cd606202fd259a4f0d4585b1', '0123456789012345678901234567890123456789012345678901234567890123', 61);
431-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (62, '2007-05-14 23:21:11.121446', 123, 'd06b970f258e57547ef1104fba3499eb4ab43ff6', '767e1635f55ff5e833410523decec438', '0123456789012345678901234567890123456789012345678901234567890123', 62);
432-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (63, '2007-05-14 23:21:11.121446', 123, 'd06b970f258e57547ef1104fba3499eb4ab43ff6', '767e1635f55ff5e833410523decec438', '0123456789012345678901234567890123456789012345678901234567890123', 63);
433-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (65, '2007-08-09 21:25:37.832976', 958, 'df4adf483eb24fec455e8411ca3dceb0bee51b44', 'b85b447f88c326c4124f0554e175097f', '0123456789012345678901234567890123456789012345678901234567890123', 65);
434-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (66, '2007-08-09 21:25:37.832976', 179, '3e00fea68e91f6e03de6333b4c8e60c2ce441926', 'f27fb7494c5afbb0fb10b78d16f7da37', '0123456789012345678901234567890123456789012345678901234567890123', 66);
435-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (67, '2007-08-09 21:25:37.832976', 610, '01bedc249af59cb80abb40b4898eced10f5d5e20', '7d6fa416334c6da3b954bf9ebff6e9ae', '0123456789012345678901234567890123456789012345678901234567890123', 67);
436-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (68, '2007-08-09 21:25:37.832976', 567, 'b5aeb55faeb86a1d8c1a93dd58131b387a604c5a', '95f2b067e046d73f4e93eca44c034b97', '0123456789012345678901234567890123456789012345678901234567890123', 68);
437-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (69, '2007-08-09 21:54:18.456616', 749, '0526ef40da99af5c1c97c91f9aca77e7ae564838', '8afa3dbc21b2dcdad7f31ab28c041ad9', '0123456789012345678901234567890123456789012345678901234567890123', 69);
438-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (70, '2007-08-09 21:54:18.456616', 652, '0ce85c0cf331d05f76aa4977c43e87e9ffbd0480', '05a37db4ba50ba5f28650ee74b450c2c', '0123456789012345678901234567890123456789012345678901234567890123', 70);
439-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (71, '2007-09-10 19:14:26.037382', 22897, 'd7ebed9e00fc134ebc79eaf7deebb30a4f5f6859', '0113f983ff8beba46ad64c4ae8899091', '0123456789012345678901234567890123456789012345678901234567890123', 71);
440-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (72, '2007-09-10 19:15:01.67038', 221, '0ddef36534d59da64790eeffa55cc0221a01736d', 'df6ce34951747929ca9c6a4e2cb78f94', '0123456789012345678901234567890123456789012345678901234567890123', 72);
441-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (73, '2007-09-10 19:15:19.947543', 217, 'ea265925f6214628dc46e731ca1e131f1e632127', '9d19d15feffc620c0d16523e0ce00a54', '0123456789012345678901234567890123456789012345678901234567890123', 73);
442-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (74, '2007-09-10 19:16:01.017943', 22899, '234acbb3dc11b2af9bc46b6e33f0e453c3b1289d', '6d2d916ea729bc875ca0bd739f6be476', '0123456789012345678901234567890123456789012345678901234567890123', 74);
443-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (75, '2007-12-18 16:31:34.790641', 4296, 'e8b25389964bc3bd471c20a1508d00852ee7de40', 'e6b759498b7cde49e9d34e7b8c8b4542', '0123456789012345678901234567890123456789012345678901234567890123', 75);
444-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (76, '2007-12-18 16:31:34.790641', 2103, 'c154e1c1c2407d9b80c96b63c48d61a94248bf95', 'd86630cafdf624a3aa32aba0c41078c5', '0123456789012345678901234567890123456789012345678901234567890123', 76);
445-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (77, '2007-12-18 16:31:34.790641', 2787, '2d94c4a6a014895f93b581fb0134efe73ae4e2c8', '315ef57e5f6ad295e98db65607c5c18a', '0123456789012345678901234567890123456789012345678901234567890123', 77);
446-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (78, '2007-12-18 16:31:34.790641', 3534, '2bd22db53f2b9e47df50ed731128ff1fc54a5775', 'e0d510b49f803a0a4c2b2712d0a80522', '0123456789012345678901234567890123456789012345678901234567890123', 78);
447-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (79, '2007-12-18 16:31:34.790641', 3327, 'a57356e4cbf97bbb47df202449a95d909d50614a', '8c5ffb558a0d0f520887f3d4cbd619c5', '0123456789012345678901234567890123456789012345678901234567890123', 79);
448-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (80, '2007-12-18 16:31:34.790641', 189, '9800f54c65017e1bafe2d09a13af6176ba0ab244', 'a94677aabcd34b0901f1f75a35f7dff3', '0123456789012345678901234567890123456789012345678901234567890123', 80);
449-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (81, '2007-12-18 16:31:34.790641', 2926, 'b53bb11bc40c42b0f9ecd981561fe9d6f265b275', '496cf1cbb97c17a67998478402520ab5', '0123456789012345678901234567890123456789012345678901234567890123', 81);
450-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (82, '2008-03-17 15:36:19.035615', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123', 82);
451-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (83, '2008-03-17 15:36:38.022812', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123', 83);
452-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (84, '2008-03-17 15:36:48.877842', 3, '55ca6286e3e4f4fba5d0448333fa99fc5a404a73', '764efa883dda1e11db47671c4a3bbd9e', '0123456789012345678901234567890123456789012345678901234567890123', 84);
453-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (85, '2008-03-17 15:37:10.252357', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123', 85);
454-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (86, '2008-03-17 15:37:22.489973', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123', 86);
455-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (87, '2008-03-17 15:37:36.701686', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123', 87);
456-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (88, '2008-03-17 15:37:48.465157', 3, '55ca6286e3e4f4fba5d0448333fa99fc5a404a73', '764efa883dda1e11db47671c4a3bbd9e', '0123456789012345678901234567890123456789012345678901234567890123', 88);
457-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (89, '2008-03-17 15:38:16.866444', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123', 89);
458-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (90, '2008-05-08 10:10:16.866444', 18, '0c805a60b31058a1018680f99447033dcb9d4caa', '8a8a67b8dbc5f203ae8712092c68c7aa', '0123456789012345678901234567890123456789012345678901234567890123', 90);
459-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (91, '2008-07-07 22:30:01.123456', 10, '0c805a60b31058a1018680f99447033dcb9d4c01', '8a8a67b8dbc5f203ae8712092c68c701', '0123456789012345678901234567890123456789012345678901234567890123', 91);
460-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (92, '2008-09-30 08:19:00.222131', 10, 'f10e2821bbbea527ea02200352313bc059445190', '7815696ecbf1c96e6894b779456d330e', '0123456789012345678901234567890123456789012345678901234567890123', 92);
461+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-04-07 16:46:05.265391', 178859, '378b3498ead213d35a82033a6e9196014a5ef25c', '01234567890123456789012345678900', '0123456789012345678901234567890123456789012345678901234567890123', 1);
462+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-04-07 16:46:05.266763', 9922560, 'a57faa6287aee2c58e115673a119c6083d31d1b9', '01234567890123456789012345678902', '0123456789012345678901234567890123456789012345678901234567890123', 2);
463+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-04-07 16:46:05.26727', 309386, 'b218ca7b52fa813550e3f14cdcf3ba68606e4446', '01234567890123456789012345678903', '0123456789012345678901234567890123456789012345678901234567890123', 3);
464+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-04-07 16:46:05.267803', 162927750, 'cfbd3ee1f510c66d49be465b900a3334e8488184', '01234567890123456789012345678904', '0123456789012345678901234567890123456789012345678901234567890123', 4);
465+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 10826, '502828e7591277535abe9015ffbc6918dbba8ef4', '01234567890123456789012345678907', '0123456789012345678901234567890123456789012345678901234567890123', 7);
466+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 10826, '502828e7591277535abe9015ffbc6918dbba8ef4', '01234567890123456789012345678907', '0123456789012345678901234567890123456789012345678901234567890123', 8);
467+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 12652, '07b01d1e6fe9a729f911e72dfe674a5e0abdc4ee', '01234567890123456789012345678911', '0123456789012345678901234567890123456789012345678901234567890123', 17);
468+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 12695, '8812d04c170ca90bb1423e188ce9706869aa03d7', '0123456789012345678901234567890b', '0123456789012345678901234567890123456789012345678901234567890123', 12);
469+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 13110, 'bc7bebca1e3c5c166838b19f0eeb7f171e51805d', '01234567890123456789012345678909', '0123456789012345678901234567890123456789012345678901234567890123', 10);
470+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 13133, 'db1b50cbde7142d344bd8ef9b2e1fe3b3116f77c', '0123456789012345678901234567890c', '0123456789012345678901234567890123456789012345678901234567890123', 13);
471+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 13240, '801dc911c2bd67e17eff087516fdc63a2ac322ce', '01234567890123456789012345678912', '0123456789012345678901234567890123456789012345678901234567890123', 18);
472+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 13269, 'fc8cab1cb1e5fb1efa3c3c475b8f7c8dc5038d50', '0123456789012345678901234567890f', '0123456789012345678901234567890123456789012345678901234567890123', 15);
473+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 13499, '78a26efee75a54f113063b78783b2d4612fee409', '0123456789012345678901234567890a', '0123456789012345678901234567890123456789012345678901234567890123', 11);
474+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 13641, 'e19cc1446e3004f10475c37b2cd363f75b8ae89a', '0123456789012345678901234567890d', '0123456789012345678901234567890123456789012345678901234567890123', 14);
475+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 13983, 'e17ee3031bd29dcd1e5905c0fd17945600a91ccf', '01234567890123456789012345678910', '0123456789012345678901234567890123456789012345678901234567890123', 16);
476+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 2655, 'ca3b107af84c05eaf98ba073376153986566ec28', '01234567890123456789012345678908', '0123456789012345678901234567890123456789012345678901234567890123', 9);
477+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 2961, '4468039e1d2cbdfc78d2e53477e5fe0537bae302', '0123456789012345678901234567891b', '0123456789012345678901234567890123456789012345678901234567890123', 27);
478+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 3305, 'b45b170da29f9b22650315657505124766c93720', '0123456789012345678901234567891e', '0123456789012345678901234567890123456789012345678901234567890123', 30);
479+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 3553, '20815563ee33368d51e3213354f97c05b4685968', '01234567890123456789012345678916', '0123456789012345678901234567890123456789012345678901234567890123', 22);
480+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 3558, 'd6c2ddacdab7618ce2a555c20a4a730fcdb42600', '0123456789012345678901234567891c', '0123456789012345678901234567890123456789012345678901234567890123', 28);
481+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 3561, '9eb09455e6a568605c1bbab4cdf1936eee92222d', '0123456789012345678901234567891d', '0123456789012345678901234567890123456789012345678901234567890123', 29);
482+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 3635, '4ab2ca308dafe152789640942488e23a33e4f46c', '01234567890123456789012345678915', '0123456789012345678901234567890123456789012345678901234567890123', 21);
483+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 3666, 'cca8fb78e05a34481e07683cea8c3a47f01c609e', '01234567890123456789012345678918', '0123456789012345678901234567890123456789012345678901234567890123', 24);
484+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 3778, '965968d3e6668f39ebc64bc11a3f1a5cd07c213b', '01234567890123456789012345678917', '0123456789012345678901234567890123456789012345678901234567890123', 23);
485+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 3793, '28a7accfb491a2b4895b49b810ca7cda0badc787', '01234567890123456789012345678919', '0123456789012345678901234567890123456789012345678901234567890123', 25);
486+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 3987, '9668ba9f0a59f9e6e6bc73fc5dc9f116b202bceb', '0123456789012345678901234567891f', '0123456789012345678901234567890123456789012345678901234567890123', 31);
487+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 4093, 'fc67a1770f78c45c396b4724195aeb10683aa2fd', '01234567890123456789012345678914', '0123456789012345678901234567890123456789012345678901234567890123', 20);
488+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 4165, 'fca78a2292e4034b8dfbb2de6f69e17ebeecaaa1', '01234567890123456789012345678913', '0123456789012345678901234567890123456789012345678901234567890123', 19);
489+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 4381, '9b1f78faa39fb09a9fd955d744002c2d8f32d88d', '01234567890123456789012345678905', '0123456789012345678901234567890123456789012345678901234567890123', 5);
490+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 4773, '03efb176f04f3897de7d5e6484864b0559fd6cd6', '0123456789012345678901234567891a', '0123456789012345678901234567890123456789012345678901234567890123', 26);
491+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 4908, '874a6ef9cd1aaef17653c6c12f4b83ef9487c1c3', '01234567890123456789012345678920', '0123456789012345678901234567890123456789012345678901234567890123', 32);
492+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 4908, '874a6ef9cd1aaef17653c6c12f4b83ef9487c1c3', '01234567890123456789012345678920', '0123456789012345678901234567890123456789012345678901234567890123', 33);
493+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 7910, 'afdf21d698587a6601e2ffed0f44292b7ad5dd07', '01234567890123456789012345678906', '0123456789012345678901234567890123456789012345678901234567890123', 6);
494+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-08-01 09:31:29.606407', 2, '71853c6197a6a7f222db0f1978c7cb232b87c5ee', '01234567890123456789012345678921', '0123456789012345678901234567890123456789012345678901234567890123', 35);
495+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-08-10 09:31:29.606407', 2, '71853c6197a6a7f222db0f1978c7cb232b87c5ee', '01234567890123456789012345678921', '0123456789012345678901234567890123456789012345678901234567890123', 34);
496+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-10-30 18:00:27.899028', 3, '0beec7b5ea3f0fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678922', '0123456789012345678901234567890123456789012345678901234567890123', 36);
497+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-10-30 18:00:27.899028', 3, '1e04c7b5ea3f0fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678923', '0123456789012345678901234567890123456789012345678901234567890123', 37);
498+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-10-30 18:00:27.899028', 3, '4e3961baf4f56fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678928', '0123456789012345678901234567890123456789012345678901234567890123', 43);
499+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-10-30 18:00:27.899028', 3, '5a04c7b5ea3f0fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678926', '0123456789012345678901234567890123456789012345678901234567890123', 40);
500+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-10-30 18:00:27.899028', 3, 'a10856bfea3f0bdb09550dd41f3c5bc275da8a33', '01234567890123456789012345678925', '0123456789012345678901234567890123456789012345678901234567890123', 39);
501+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-10-30 18:00:27.899028', 3, 'a45ed906e4f56fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678927', '0123456789012345678901234567890123456789012345678901234567890123', 42);
502+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-10-30 18:00:27.899028', 3, 'ae04c7b5ea3f0bdb095d0dd47f3c5bc275da8a33', '01234567890123456789012345678924', '0123456789012345678901234567890123456789012345678901234567890123', 38);
503+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-10-30 18:00:27.899028', 3, 'b45ed906e4f5afdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678929', '0123456789012345678901234567890123456789012345678901234567890123', 44);
504+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2006-05-24 09:31:29.606407', 2, '1622db354faa9fa653804d018f3b9d5291e37d6b', 'e4a7193a8f72fa2755e2162512069093', '0123456789012345678901234567890123456789012345678901234567890123', 52);
505+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2006-05-24 09:31:29.606407', 2, 'ab43246197a6a7f222db0f1978c7cb232b87c5ee', '0123456789012345678901234567892b', '0123456789012345678901234567890123456789012345678901234567890123', 46);
506+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2006-05-24 09:31:29.606407', 2, 'cabf42e197a6a7f222db0f1978c7cb232b87c5ee', '0123456789012345678901234567892c', '0123456789012345678901234567890123456789012345678901234567890123', 47);
507+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2006-05-24 09:31:29.606407', 2, 'fabb42e197a6a7f222db0f1978c7cb232b87c5ee', '0123456789012345678901234567892d', '0123456789012345678901234567890123456789012345678901234567890123', 59);
508+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2006-07-14 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5437', '0123456789012345678901234567890123456789012345678901234567890123', 51);
509+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2006-08-01 09:31:29.606407', 2, '43853c6197a6a7f222db0f1978c7cb232b87c5ee', '0123456789012345678901234567892a', '0123456789012345678901234567890123456789012345678901234567890123', 45);
510+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2006-12-01 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5437', '0123456789012345678901234567890123456789012345678901234567890123', 53);
511+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2006-12-01 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5438', '0123456789012345678901234567890123456789012345678901234567890123', 54);
512+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2006-12-01 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5439', '0123456789012345678901234567890123456789012345678901234567890123', 55);
513+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2006-12-01 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5440', '0123456789012345678901234567890123456789012345678901234567890123', 56);
514+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2006-12-13 21:17:56.241901', 1599, 'acdf6b9b99c39b1585f829ec7d68598a8e10816d', '5c6fa250b612e7e4d17261268a4d8400', '0123456789012345678901234567890123456789012345678901234567890123', 57);
515+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2006-12-13 21:18:28.796588', 1599, 'acdf6b9b99c39b1585f829ec7d68598a8e10816d', '5c6fa250b612e7e4d17261268a4d8401', '0123456789012345678901234567890123456789012345678901234567890123', 58);
516+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-01-03 17:26:27.288968', 11793, 'df3a6670671781d5e08d7795ca1ada776815d87f', 'e8120781cd606202fd259a4f0d4585bb', '0123456789012345678901234567890123456789012345678901234567890123', 60);
517+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-02-15 14:26:27.288968', 100, 'df3a6670671781d5e08d7795ca1ada776815d87f', 'e8120781cd606202fd259a4f0d4585b1', '0123456789012345678901234567890123456789012345678901234567890123', 61);
518+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-05-14 23:21:11.121446', 123, 'd06b970f258e57547ef1104fba3499eb4ab43ff6', '767e1635f55ff5e833410523decec438', '0123456789012345678901234567890123456789012345678901234567890123', 62);
519+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-05-14 23:21:11.121446', 123, 'd06b970f258e57547ef1104fba3499eb4ab43ff6', '767e1635f55ff5e833410523decec438', '0123456789012345678901234567890123456789012345678901234567890123', 63);
520+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-08-09 21:25:37.832976', 179, '3e00fea68e91f6e03de6333b4c8e60c2ce441926', 'f27fb7494c5afbb0fb10b78d16f7da37', '0123456789012345678901234567890123456789012345678901234567890123', 66);
521+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-08-09 21:25:37.832976', 567, 'b5aeb55faeb86a1d8c1a93dd58131b387a604c5a', '95f2b067e046d73f4e93eca44c034b97', '0123456789012345678901234567890123456789012345678901234567890123', 68);
522+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-08-09 21:25:37.832976', 610, '01bedc249af59cb80abb40b4898eced10f5d5e20', '7d6fa416334c6da3b954bf9ebff6e9ae', '0123456789012345678901234567890123456789012345678901234567890123', 67);
523+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-08-09 21:25:37.832976', 958, 'df4adf483eb24fec455e8411ca3dceb0bee51b44', 'b85b447f88c326c4124f0554e175097f', '0123456789012345678901234567890123456789012345678901234567890123', 65);
524+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-08-09 21:54:18.456616', 652, '0ce85c0cf331d05f76aa4977c43e87e9ffbd0480', '05a37db4ba50ba5f28650ee74b450c2c', '0123456789012345678901234567890123456789012345678901234567890123', 70);
525+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-08-09 21:54:18.456616', 749, '0526ef40da99af5c1c97c91f9aca77e7ae564838', '8afa3dbc21b2dcdad7f31ab28c041ad9', '0123456789012345678901234567890123456789012345678901234567890123', 69);
526+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-09-10 19:14:26.037382', 22897, 'd7ebed9e00fc134ebc79eaf7deebb30a4f5f6859', '0113f983ff8beba46ad64c4ae8899091', '0123456789012345678901234567890123456789012345678901234567890123', 71);
527+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-09-10 19:15:01.67038', 221, '0ddef36534d59da64790eeffa55cc0221a01736d', 'df6ce34951747929ca9c6a4e2cb78f94', '0123456789012345678901234567890123456789012345678901234567890123', 72);
528+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-09-10 19:15:19.947543', 217, 'ea265925f6214628dc46e731ca1e131f1e632127', '9d19d15feffc620c0d16523e0ce00a54', '0123456789012345678901234567890123456789012345678901234567890123', 73);
529+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-09-10 19:16:01.017943', 22899, '234acbb3dc11b2af9bc46b6e33f0e453c3b1289d', '6d2d916ea729bc875ca0bd739f6be476', '0123456789012345678901234567890123456789012345678901234567890123', 74);
530+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-12-18 16:31:34.790641', 189, '9800f54c65017e1bafe2d09a13af6176ba0ab244', 'a94677aabcd34b0901f1f75a35f7dff3', '0123456789012345678901234567890123456789012345678901234567890123', 80);
531+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-12-18 16:31:34.790641', 2103, 'c154e1c1c2407d9b80c96b63c48d61a94248bf95', 'd86630cafdf624a3aa32aba0c41078c5', '0123456789012345678901234567890123456789012345678901234567890123', 76);
532+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-12-18 16:31:34.790641', 2787, '2d94c4a6a014895f93b581fb0134efe73ae4e2c8', '315ef57e5f6ad295e98db65607c5c18a', '0123456789012345678901234567890123456789012345678901234567890123', 77);
533+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-12-18 16:31:34.790641', 2926, 'b53bb11bc40c42b0f9ecd981561fe9d6f265b275', '496cf1cbb97c17a67998478402520ab5', '0123456789012345678901234567890123456789012345678901234567890123', 81);
534+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-12-18 16:31:34.790641', 3327, 'a57356e4cbf97bbb47df202449a95d909d50614a', '8c5ffb558a0d0f520887f3d4cbd619c5', '0123456789012345678901234567890123456789012345678901234567890123', 79);
535+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-12-18 16:31:34.790641', 3534, '2bd22db53f2b9e47df50ed731128ff1fc54a5775', 'e0d510b49f803a0a4c2b2712d0a80522', '0123456789012345678901234567890123456789012345678901234567890123', 78);
536+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-12-18 16:31:34.790641', 4296, 'e8b25389964bc3bd471c20a1508d00852ee7de40', 'e6b759498b7cde49e9d34e7b8c8b4542', '0123456789012345678901234567890123456789012345678901234567890123', 75);
537+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2008-03-17 15:36:19.035615', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123', 82);
538+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2008-03-17 15:36:38.022812', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123', 83);
539+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2008-03-17 15:36:48.877842', 3, '55ca6286e3e4f4fba5d0448333fa99fc5a404a73', '764efa883dda1e11db47671c4a3bbd9e', '0123456789012345678901234567890123456789012345678901234567890123', 84);
540+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2008-03-17 15:37:10.252357', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123', 85);
541+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2008-03-17 15:37:22.489973', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123', 86);
542+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2008-03-17 15:37:36.701686', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123', 87);
543+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2008-03-17 15:37:48.465157', 3, '55ca6286e3e4f4fba5d0448333fa99fc5a404a73', '764efa883dda1e11db47671c4a3bbd9e', '0123456789012345678901234567890123456789012345678901234567890123', 88);
544+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2008-03-17 15:38:16.866444', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123', 89);
545+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2008-05-08 10:10:16.866444', 18, '0c805a60b31058a1018680f99447033dcb9d4caa', '8a8a67b8dbc5f203ae8712092c68c7aa', '0123456789012345678901234567890123456789012345678901234567890123', 90);
546+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2008-07-07 22:30:01.123456', 10, '0c805a60b31058a1018680f99447033dcb9d4c01', '8a8a67b8dbc5f203ae8712092c68c701', '0123456789012345678901234567890123456789012345678901234567890123', 91);
547+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2008-09-30 08:19:00.222131', 10, 'f10e2821bbbea527ea02200352313bc059445190', '7815696ecbf1c96e6894b779456d330e', '0123456789012345678901234567890123456789012345678901234567890123', 92);
548
549
550 ALTER TABLE libraryfilecontent ENABLE TRIGGER ALL;
551@@ -753,93 +753,93 @@
552
553 ALTER TABLE libraryfilealias DISABLE TRIGGER ALL;
554
555-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (1, 1, 'netapplet-1.0.0.tar.gz', 'application/x-gtar', NULL, '2005-04-07 16:46:05.265391', false, 0, 1);
556-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (2, 1, 'netapplet_1.0.0.orig.tar.gz', 'application/x-gtar', NULL, '2005-04-07 16:46:05.265391', false, 0, 1);
557-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (3, 2, 'firefox_0.9.2.orig.tar.gz', 'application/x-gtar', NULL, '2005-04-07 16:46:05.266763', false, 0, 2);
558-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (4, 3, 'evolution-1.0.tar.gz', 'application/x-gtar', NULL, '2005-04-07 16:46:05.26727', false, 0, 3);
559-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (5, 5, 'netapplet.pot', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 5);
560-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (6, 6, 'pmount.pot', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 6);
561-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (7, 7, 'evolution-2.2.pot', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 7);
562-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (8, 8, 'evolution-2.2.pot', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 8);
563-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (9, 9, 'pkgconf-mozilla.pot', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 9);
564-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (10, 10, 'hr.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 10);
565-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (11, 11, 'ca.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 11);
566-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (12, 12, 'nb.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 12);
567-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (13, 13, 'cs.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 13);
568-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (14, 14, 'es_ES.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 14);
569-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (15, 15, 'de.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 15);
570-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (16, 16, 'fr.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 16);
571-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (17, 17, 'it_IT.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 17);
572-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (18, 18, 'es.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 18);
573-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (19, 19, 'fr.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 19);
574-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (20, 20, 'pt_BR.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 20);
575-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (21, 21, 'ja.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 21);
576-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (22, 22, 'es.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 22);
577-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (23, 23, 'nl.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 23);
578-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (24, 24, 'cs.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 24);
579-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (25, 25, 'da.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 25);
580-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (26, 26, 'fi.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 26);
581-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (27, 27, 'gl.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 27);
582-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (28, 28, 'lt.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 28);
583-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (29, 29, 'it.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 29);
584-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (30, 30, 'tr.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 30);
585-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (31, 31, 'de.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 31);
586-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (32, 32, 'es.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 32);
587-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (33, 33, 'es.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 33);
588-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (34, 34, 'evolution-2.2-test.pot', 'application/x-po', NULL, '2005-08-10 09:31:29.606407', false, 0, 34);
589-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (35, 35, 'Ubuntu-High-Pri-2005-08-01.csv', 'text/plain', NULL, '2005-08-01 09:31:29.606407', false, 0, 35);
590-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (36, NULL, 'foo.txt', 'text/plain', NULL, '2005-10-30 18:00:27.899028', false, 0, NULL);
591-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (37, 37, 'pmount_1.9-1_all.deb', 'application/x-debian-package', NULL, '2005-10-30 18:00:27.899028', false, 0, 37);
592-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (38, 38, 'alsa-utils_1.0.9a-4.dsc', 'application/dsc', NULL, '2005-10-30 18:00:27.899028', false, 0, 38);
593-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (39, 39, 'alsa-utils_1.0.8-1ubuntu1.dsc', 'application/dsc', NULL, '2005-10-30 18:00:27.899028', false, 0, 39);
594-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (40, 40, 'mozilla-firefox_0.9_i386.deb', 'application/x-debian-package', NULL, '2005-10-30 18:00:27.899028', false, 0, 40);
595-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (42, 42, 'linux-2.6.12_2.6.12.20_i386.deb', 'application/x-debian-package', NULL, '2005-10-30 18:00:27.899028', false, 0, 42);
596-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (43, 43, 'alsa-utils_1.0.9a-4ubuntu1.dsc', 'application/x-debian-package', NULL, '2005-10-30 18:00:27.899028', false, 0, 43);
597-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (44, 44, 'at-3.14156_all.udeb', 'application/x-debian-package', NULL, '2005-10-30 18:00:27.899028', false, 0, 44);
598-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (45, 45, 'Ubuntu-High-Pri-2006-08-01.csv', 'text/plain', NULL, '2006-08-01 09:31:29.606407', false, 0, 45);
599-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (46, 46, 'non-existent-mirrorprober-logfile.txt', 'text/plain', NULL, '2006-05-24 09:31:29.606407', false, 0, 46);
600-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (47, 47, 'non-existent-mirrorprober-logfile.txt', 'text/plain', NULL, '2006-05-24 09:31:29.606407', false, 0, 47);
601-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (51, 51, 'x4cWPgneBxsZOM21ZzpRPxsZXod.msg', 'message/rfc822', NULL, '2006-07-14 16:41:34.028627', false, 0, 51);
602-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (52, 52, 'mozilla-firefox_0.9_i386.changes', 'text/plain', NULL, '2006-05-24 09:31:29.606407', false, 0, 52);
603-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (53, 53, 'cdrkit-1.0.dsc', 'application/dsc', NULL, '2006-12-01 16:41:34.028627', false, 0, 53);
604-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (54, 54, 'foobar-1.0.dsc', 'application/dsc', NULL, '2006-12-01 16:41:34.028627', false, 0, 54);
605-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (55, 55, 'cdrkit_1.0_all.deb', 'application/deb', NULL, '2006-12-01 16:41:34.028627', false, 0, 55);
606-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (56, 56, 'foobar_1.0_all.deb', 'application/deb', NULL, '2006-12-01 16:41:34.028627', false, 0, 56);
607-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (57, 57, 'evolution-2.2-test.pot', 'application/x-po', NULL, '2006-12-13 21:17:56.241901', false, 0, 57);
608-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (58, 58, 'pt_BR.po', 'application/x-po', NULL, '2006-12-13 21:18:28.796588', false, 0, 58);
609-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (59, 59, 'salgado-mugshot.jpg', 'image/jpeg', NULL, '2006-05-24 09:31:29.606407', false, 0, 59);
610-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (60, 60, 'es.po', 'application/x-po', NULL, '2007-01-03 17:26:27.288968', false, 0, 60);
611-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (61, 61, 'language-pack-ar_1.0.dsc', 'application/dsc', NULL, '2007-02-15 14:26:27.288968', false, 0, 61);
612-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (62, 62, 'iceweasel-1.0.dsc', 'application/dsc', NULL, '2007-05-14 23:21:11.121446', false, 0, 62);
613-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (63, 63, 'hwsubmission1.xml', 'text/xml', NULL, '2007-05-14 23:21:11.121446', false, 0, 63);
614-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (65, 65, 'commercialpackage_1.0-1_source.changes', 'text/plain', NULL, '2007-08-09 21:25:37.832976', false, 0, 65);
615-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (66, 66, 'commercialpackage_1.0.orig.tar.gz', 'application/gzipped-tar', NULL, '2007-08-09 21:25:37.832976', false, 0, 66);
616-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (67, 67, 'commercialpackage_1.0-1.diff.gz', 'application/gzipped-patch', NULL, '2007-08-09 21:25:37.832976', false, 0, 67);
617-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (68, 68, 'commercialpackage_1.0-1.dsc', 'text/x-debian-source-package', NULL, '2007-08-09 21:25:37.832976', false, 0, 68);
618-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (69, 69, 'commercialpackage_1.0-1_i386.changes', 'text/plain', NULL, '2007-08-09 21:54:18.456616', false, 0, 69);
619-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (70, 70, 'commercialpackage_1.0-1_i386.deb', 'application/x-debian-package', NULL, '2007-08-09 21:54:18.456616', false, 0, 70);
620-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (71, 71, 'ubuntu-hoary-translations.tar.gz', 'application/x-gtar', NULL, '2007-09-10 19:14:26.037382', false, 0, 71);
621-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (72, 72, 'ubuntu-hoary-translations-update.tar.gz', 'application/x-gtar', NULL, '2007-09-10 19:15:01.67038', false, 0, 72);
622-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (73, 73, 'ubuntu-hoary-translations-update.tar.gz', 'application/x-gtar', NULL, '2007-09-10 19:15:19.947543', false, 0, 73);
623-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (74, 74, 'ubuntu-hoary-translations.tar.gz', 'application/x-gtar', NULL, '2007-09-10 19:16:01.017943', false, 0, 74);
624-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (75, 75, 'cX0Ey6rIIK5MqHphucFPna1fQMt.msg', 'message/rfc822', NULL, '2007-12-18 16:31:34.790641', false, 0, 75);
625-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (76, 76, 'nSpn1l12p7HBplm6e7kaaX6lf86.msg', 'message/rfc822', NULL, '2007-12-18 16:31:34.790641', false, 0, 76);
626-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (77, 77, 'evJ9qHEN3ufdtsDUnGPb8a5hs77.msg', 'message/rfc822', NULL, '2007-12-18 16:31:34.790641', false, 0, 77);
627-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (78, 78, 'jqUQpLymm7f9DjBAAsQoM10WndS.msg', 'message/rfc822', NULL, '2007-12-18 16:31:34.790641', false, 0, 78);
628-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (79, 79, '378cZyfOfUKx6BySEK0HYKz4Tpd.msg', 'message/rfc822', NULL, '2007-12-18 16:31:34.790641', false, 0, 79);
629-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (80, 80, 'unnamed', 'application/pgp-signature; name="signature.asc"', NULL, '2007-12-18 16:31:34.790641', false, 0, 80);
630-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (81, 81, 'jm81HhLQDRDAsqbl74W7GT3cpel.msg', 'message/rfc822', NULL, '2007-12-18 16:31:34.790641', false, 0, 81);
631-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (82, 82, 'alsa-1.0.9a.exe', 'application/x-msdos-program', NULL, '2008-03-17 15:36:19.035615', false, 0, 82);
632-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (83, 83, 'alsa-1.0.9a.dmg', 'application/x-apple-diskimage', NULL, '2008-03-17 15:36:38.022812', false, 0, 83);
633-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (84, 84, 'README.txt', 'text/plain', NULL, '2008-03-17 15:36:48.877842', false, 0, 84);
634-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (85, 85, 'alsa-1.0.8.exe', 'application/x-msdos-program', NULL, '2008-03-17 15:37:10.252357', false, 0, 85);
635-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (86, 86, 'alsa-1.0.8.dmg', 'application/x-apple-diskimage', NULL, '2008-03-17 15:37:22.489973', false, 0, 86);
636-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (87, 87, 'alsa-1.0.8.tgz', 'application/x-tar', NULL, '2008-03-17 15:37:36.701686', false, 0, 87);
637-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (88, 88, 'README.txt', 'text/plain', NULL, '2008-03-17 15:37:48.465157', false, 0, 88);
638-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (89, 89, 'alsa-1.0.9a.tgz', 'application/x-tar', NULL, '2008-03-17 15:38:16.866444', false, 0, 89);
639-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (90, 90, 'pmount_1.0-1_all.deb', 'application/x-debian-package', NULL, '2008-05-08 10:10:27.899028', false, 0, 90);
640-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (91, 91, 'upload_22_log.txt', 'application/text', NULL, '2008-07-07 22:30:01.123456', false, 0, 91);
641-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits, _content) VALUES (92, 92, 'sample-submission-2.xml', 'application/x-bzip2', NULL, '2008-09-30 08:19:00.222131', false, 0, 92);
642+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (1, 'netapplet-1.0.0.tar.gz', 'application/x-gtar', NULL, '2005-04-07 16:46:05.265391', false, 0, 1);
643+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (2, 'netapplet_1.0.0.orig.tar.gz', 'application/x-gtar', NULL, '2005-04-07 16:46:05.265391', false, 0, 1);
644+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (3, 'firefox_0.9.2.orig.tar.gz', 'application/x-gtar', NULL, '2005-04-07 16:46:05.266763', false, 0, 2);
645+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (4, 'evolution-1.0.tar.gz', 'application/x-gtar', NULL, '2005-04-07 16:46:05.26727', false, 0, 3);
646+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (5, 'netapplet.pot', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 5);
647+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (6, 'pmount.pot', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 6);
648+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (7, 'evolution-2.2.pot', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 7);
649+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (8, 'evolution-2.2.pot', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 8);
650+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (9, 'pkgconf-mozilla.pot', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 9);
651+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (10, 'hr.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 10);
652+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (11, 'ca.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 11);
653+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (12, 'nb.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 12);
654+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (13, 'cs.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 13);
655+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (14, 'es_ES.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 14);
656+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (15, 'de.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 15);
657+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (16, 'fr.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 16);
658+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (17, 'it_IT.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 17);
659+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (18, 'es.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 18);
660+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (19, 'fr.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 19);
661+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (20, 'pt_BR.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 20);
662+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (21, 'ja.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 21);
663+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (22, 'es.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 22);
664+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (23, 'nl.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 23);
665+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (24, 'cs.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 24);
666+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (25, 'da.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 25);
667+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (26, 'fi.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 26);
668+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (27, 'gl.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 27);
669+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (28, 'lt.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 28);
670+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (29, 'it.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 29);
671+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (30, 'tr.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 30);
672+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (31, 'de.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 31);
673+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (32, 'es.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 32);
674+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (33, 'es.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0, 33);
675+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (34, 'evolution-2.2-test.pot', 'application/x-po', NULL, '2005-08-10 09:31:29.606407', false, 0, 34);
676+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (35, 'Ubuntu-High-Pri-2005-08-01.csv', 'text/plain', NULL, '2005-08-01 09:31:29.606407', false, 0, 35);
677+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (36, 'foo.txt', 'text/plain', NULL, '2005-10-30 18:00:27.899028', false, 0, NULL);
678+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (37, 'pmount_1.9-1_all.deb', 'application/x-debian-package', NULL, '2005-10-30 18:00:27.899028', false, 0, 37);
679+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (38, 'alsa-utils_1.0.9a-4.dsc', 'application/dsc', NULL, '2005-10-30 18:00:27.899028', false, 0, 38);
680+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (39, 'alsa-utils_1.0.8-1ubuntu1.dsc', 'application/dsc', NULL, '2005-10-30 18:00:27.899028', false, 0, 39);
681+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (40, 'mozilla-firefox_0.9_i386.deb', 'application/x-debian-package', NULL, '2005-10-30 18:00:27.899028', false, 0, 40);
682+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (42, 'linux-2.6.12_2.6.12.20_i386.deb', 'application/x-debian-package', NULL, '2005-10-30 18:00:27.899028', false, 0, 42);
683+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (43, 'alsa-utils_1.0.9a-4ubuntu1.dsc', 'application/x-debian-package', NULL, '2005-10-30 18:00:27.899028', false, 0, 43);
684+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (44, 'at-3.14156_all.udeb', 'application/x-debian-package', NULL, '2005-10-30 18:00:27.899028', false, 0, 44);
685+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (45, 'Ubuntu-High-Pri-2006-08-01.csv', 'text/plain', NULL, '2006-08-01 09:31:29.606407', false, 0, 45);
686+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (46, 'non-existent-mirrorprober-logfile.txt', 'text/plain', NULL, '2006-05-24 09:31:29.606407', false, 0, 46);
687+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (47, 'non-existent-mirrorprober-logfile.txt', 'text/plain', NULL, '2006-05-24 09:31:29.606407', false, 0, 47);
688+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (51, 'x4cWPgneBxsZOM21ZzpRPxsZXod.msg', 'message/rfc822', NULL, '2006-07-14 16:41:34.028627', false, 0, 51);
689+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (52, 'mozilla-firefox_0.9_i386.changes', 'text/plain', NULL, '2006-05-24 09:31:29.606407', false, 0, 52);
690+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (53, 'cdrkit-1.0.dsc', 'application/dsc', NULL, '2006-12-01 16:41:34.028627', false, 0, 53);
691+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (54, 'foobar-1.0.dsc', 'application/dsc', NULL, '2006-12-01 16:41:34.028627', false, 0, 54);
692+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (55, 'cdrkit_1.0_all.deb', 'application/deb', NULL, '2006-12-01 16:41:34.028627', false, 0, 55);
693+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (56, 'foobar_1.0_all.deb', 'application/deb', NULL, '2006-12-01 16:41:34.028627', false, 0, 56);
694+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (57, 'evolution-2.2-test.pot', 'application/x-po', NULL, '2006-12-13 21:17:56.241901', false, 0, 57);
695+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (58, 'pt_BR.po', 'application/x-po', NULL, '2006-12-13 21:18:28.796588', false, 0, 58);
696+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (59, 'salgado-mugshot.jpg', 'image/jpeg', NULL, '2006-05-24 09:31:29.606407', false, 0, 59);
697+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (60, 'es.po', 'application/x-po', NULL, '2007-01-03 17:26:27.288968', false, 0, 60);
698+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (61, 'language-pack-ar_1.0.dsc', 'application/dsc', NULL, '2007-02-15 14:26:27.288968', false, 0, 61);
699+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (62, 'iceweasel-1.0.dsc', 'application/dsc', NULL, '2007-05-14 23:21:11.121446', false, 0, 62);
700+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (63, 'hwsubmission1.xml', 'text/xml', NULL, '2007-05-14 23:21:11.121446', false, 0, 63);
701+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (65, 'commercialpackage_1.0-1_source.changes', 'text/plain', NULL, '2007-08-09 21:25:37.832976', false, 0, 65);
702+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (66, 'commercialpackage_1.0.orig.tar.gz', 'application/gzipped-tar', NULL, '2007-08-09 21:25:37.832976', false, 0, 66);
703+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (67, 'commercialpackage_1.0-1.diff.gz', 'application/gzipped-patch', NULL, '2007-08-09 21:25:37.832976', false, 0, 67);
704+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (68, 'commercialpackage_1.0-1.dsc', 'text/x-debian-source-package', NULL, '2007-08-09 21:25:37.832976', false, 0, 68);
705+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (69, 'commercialpackage_1.0-1_i386.changes', 'text/plain', NULL, '2007-08-09 21:54:18.456616', false, 0, 69);
706+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (70, 'commercialpackage_1.0-1_i386.deb', 'application/x-debian-package', NULL, '2007-08-09 21:54:18.456616', false, 0, 70);
707+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (71, 'ubuntu-hoary-translations.tar.gz', 'application/x-gtar', NULL, '2007-09-10 19:14:26.037382', false, 0, 71);
708+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (72, 'ubuntu-hoary-translations-update.tar.gz', 'application/x-gtar', NULL, '2007-09-10 19:15:01.67038', false, 0, 72);
709+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (73, 'ubuntu-hoary-translations-update.tar.gz', 'application/x-gtar', NULL, '2007-09-10 19:15:19.947543', false, 0, 73);
710+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (74, 'ubuntu-hoary-translations.tar.gz', 'application/x-gtar', NULL, '2007-09-10 19:16:01.017943', false, 0, 74);
711+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (75, 'cX0Ey6rIIK5MqHphucFPna1fQMt.msg', 'message/rfc822', NULL, '2007-12-18 16:31:34.790641', false, 0, 75);
712+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (76, 'nSpn1l12p7HBplm6e7kaaX6lf86.msg', 'message/rfc822', NULL, '2007-12-18 16:31:34.790641', false, 0, 76);
713+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (77, 'evJ9qHEN3ufdtsDUnGPb8a5hs77.msg', 'message/rfc822', NULL, '2007-12-18 16:31:34.790641', false, 0, 77);
714+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (78, 'jqUQpLymm7f9DjBAAsQoM10WndS.msg', 'message/rfc822', NULL, '2007-12-18 16:31:34.790641', false, 0, 78);
715+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (79, '378cZyfOfUKx6BySEK0HYKz4Tpd.msg', 'message/rfc822', NULL, '2007-12-18 16:31:34.790641', false, 0, 79);
716+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (80, 'unnamed', 'application/pgp-signature; name="signature.asc"', NULL, '2007-12-18 16:31:34.790641', false, 0, 80);
717+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (81, 'jm81HhLQDRDAsqbl74W7GT3cpel.msg', 'message/rfc822', NULL, '2007-12-18 16:31:34.790641', false, 0, 81);
718+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (82, 'alsa-1.0.9a.exe', 'application/x-msdos-program', NULL, '2008-03-17 15:36:19.035615', false, 0, 82);
719+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (83, 'alsa-1.0.9a.dmg', 'application/x-apple-diskimage', NULL, '2008-03-17 15:36:38.022812', false, 0, 83);
720+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (84, 'README.txt', 'text/plain', NULL, '2008-03-17 15:36:48.877842', false, 0, 84);
721+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (85, 'alsa-1.0.8.exe', 'application/x-msdos-program', NULL, '2008-03-17 15:37:10.252357', false, 0, 85);
722+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (86, 'alsa-1.0.8.dmg', 'application/x-apple-diskimage', NULL, '2008-03-17 15:37:22.489973', false, 0, 86);
723+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (87, 'alsa-1.0.8.tgz', 'application/x-tar', NULL, '2008-03-17 15:37:36.701686', false, 0, 87);
724+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (88, 'README.txt', 'text/plain', NULL, '2008-03-17 15:37:48.465157', false, 0, 88);
725+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (89, 'alsa-1.0.9a.tgz', 'application/x-tar', NULL, '2008-03-17 15:38:16.866444', false, 0, 89);
726+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (90, 'pmount_1.0-1_all.deb', 'application/x-debian-package', NULL, '2008-05-08 10:10:27.899028', false, 0, 90);
727+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (91, 'upload_22_log.txt', 'application/text', NULL, '2008-07-07 22:30:01.123456', false, 0, 91);
728+INSERT INTO libraryfilealias (id, filename, mimetype, expires, date_created, restricted, hits, content) VALUES (92, 'sample-submission-2.xml', 'application/x-bzip2', NULL, '2008-09-30 08:19:00.222131', false, 0, 92);
729
730
731 ALTER TABLE libraryfilealias ENABLE TRIGGER ALL;
732
733=== added file 'database/schema/patch-2209-58-3.sql'
734--- database/schema/patch-2209-58-3.sql 1970-01-01 00:00:00 +0000
735+++ database/schema/patch-2209-58-3.sql 2014-08-08 07:05:30 +0000
736@@ -0,0 +1,10 @@
737+-- Copyright 2014 Canonical Ltd. This software is licensed under the
738+-- GNU Affero General Public License version 3 (see the file LICENSE).
739+
740+SET client_min_messages=ERROR;
741+
742+-- STEP 6, LIVE.
743+-- LibraryFileAlias indexes, to be done concurrently.
744+CREATE INDEX libraryfilealias__content__idx ON LibraryFileAlias(_content);
745+
746+INSERT INTO LaunchpadDatabaseRevision VALUES (2209, 58, 3);
747
748=== added file 'database/schema/patch-2209-58-4.sql'
749--- database/schema/patch-2209-58-4.sql 1970-01-01 00:00:00 +0000
750+++ database/schema/patch-2209-58-4.sql 2014-08-08 07:05:30 +0000
751@@ -0,0 +1,46 @@
752+-- Copyright 2014 Canonical Ltd. This software is licensed under the
753+-- GNU Affero General Public License version 3 (see the file LICENSE).
754+
755+SET client_min_messages=ERROR;
756+
757+-- STEP 7
758+-- Constraints, swap into place, and the rest.
759+
760+-- Explicitly grab the lock since we will be bypassing DDL and going
761+-- straight to the catalog.
762+LOCK LibraryFileContent, LibraryFileAlias;
763+
764+-- Set LFC._id and LFC.sha256 to NOT NULL, the sneaky unsupported way.
765+UPDATE pg_attribute SET attnotnull=TRUE
766+FROM pg_class, pg_namespace
767+WHERE
768+ pg_class.oid = pg_attribute.attrelid
769+ AND pg_namespace.oid = pg_class.relnamespace
770+ AND pg_attribute.attname in ('_id', 'sha256')
771+ AND pg_namespace.nspname = 'public'
772+ AND pg_class.relname = 'libraryfilecontent';
773+
774+-- Kill the triggers.
775+DROP TRIGGER lfa_sync_content_t ON LibraryFileAlias;
776+DROP TRIGGER lfc_sync_id_t ON LibraryFileContent;
777+DROP FUNCTION lfa_sync_content_t();
778+DROP FUNCTION lfc_sync_id_t();
779+
780+-- Fix the SEQUENCE owner, so it doesn't get removed when the old id column
781+-- is dropped.
782+ALTER SEQUENCE libraryfilecontent_id_seq OWNED BY LibraryFileContent._id;
783+
784+-- Swap in the wide columns.
785+ALTER TABLE LibraryFileAlias DROP COLUMN content;
786+ALTER TABLE LibraryFileAlias RENAME _content TO content;
787+ALTER TABLE LibraryFileContent DROP COLUMN id;
788+ALTER TABLE LibraryFileContent RENAME _id TO id;
789+
790+-- Fixup the LFC primary key.
791+ALTER INDEX libraryfilecontent_id_key RENAME TO libraryfilecontent_pkey;
792+ALTER TABLE LibraryFileContent
793+ ALTER COLUMN id SET DEFAULT nextval('libraryfilecontent_id_seq'),
794+ ADD CONSTRAINT libraryfilecontent_pkey
795+ PRIMARY KEY USING INDEX libraryfilecontent_pkey; -- Maybe slow.
796+
797+INSERT INTO LaunchpadDatabaseRevision VALUES (2209, 58, 4);