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

[Stuart Bishop]

Final two database patches converting LibraryFileContent.id to bigint.

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

[Stuart Bishop (stub)]

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

Staging and qastaging are still running data migration.

[William Grant (wgrant)]

review: Approve (db)

[Stuart Bishop (stub)]

staging is done. qastaging still running data migration.

[Stuart Bishop (stub)]

qastaging done

=== modified file 'database/sampledata/current-dev.sql'
--- database/sampledata/current-dev.sql	2014-08-04 06:45:45 +0000
+++ database/sampledata/current-dev.sql	2014-08-08 07:05:30 +0000
@@ -659,93 +659,93 @@
 
 ALTER TABLE libraryfilecontent DISABLE TRIGGER ALL;
 
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (1, '2005-04-07 16:46:05.265391', 178859, '378b3498ead213d35a82033a6e9196014a5ef25c', '01234567890123456789012345678900', '0123456789012345678901234567890123456789012345678901234567890123', 1);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (2, '2005-04-07 16:46:05.266763', 9922560, 'a57faa6287aee2c58e115673a119c6083d31d1b9', '01234567890123456789012345678902', '0123456789012345678901234567890123456789012345678901234567890123', 2);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (3, '2005-04-07 16:46:05.26727', 309386, 'b218ca7b52fa813550e3f14cdcf3ba68606e4446', '01234567890123456789012345678903', '0123456789012345678901234567890123456789012345678901234567890123', 3);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (4, '2005-04-07 16:46:05.267803', 162927750, 'cfbd3ee1f510c66d49be465b900a3334e8488184', '01234567890123456789012345678904', '0123456789012345678901234567890123456789012345678901234567890123', 4);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (5, '2005-05-18 08:03:28.021862', 4381, '9b1f78faa39fb09a9fd955d744002c2d8f32d88d', '01234567890123456789012345678905', '0123456789012345678901234567890123456789012345678901234567890123', 5);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (6, '2005-05-18 08:03:28.021862', 7910, 'afdf21d698587a6601e2ffed0f44292b7ad5dd07', '01234567890123456789012345678906', '0123456789012345678901234567890123456789012345678901234567890123', 6);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (7, '2005-05-18 08:03:28.021862', 10826, '502828e7591277535abe9015ffbc6918dbba8ef4', '01234567890123456789012345678907', '0123456789012345678901234567890123456789012345678901234567890123', 7);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (8, '2005-05-18 08:03:28.021862', 10826, '502828e7591277535abe9015ffbc6918dbba8ef4', '01234567890123456789012345678907', '0123456789012345678901234567890123456789012345678901234567890123', 8);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (9, '2005-05-18 08:03:28.021862', 2655, 'ca3b107af84c05eaf98ba073376153986566ec28', '01234567890123456789012345678908', '0123456789012345678901234567890123456789012345678901234567890123', 9);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (10, '2005-05-18 08:03:28.021862', 13110, 'bc7bebca1e3c5c166838b19f0eeb7f171e51805d', '01234567890123456789012345678909', '0123456789012345678901234567890123456789012345678901234567890123', 10);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (11, '2005-05-18 08:03:28.021862', 13499, '78a26efee75a54f113063b78783b2d4612fee409', '0123456789012345678901234567890a', '0123456789012345678901234567890123456789012345678901234567890123', 11);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (12, '2005-05-18 08:03:28.021862', 12695, '8812d04c170ca90bb1423e188ce9706869aa03d7', '0123456789012345678901234567890b', '0123456789012345678901234567890123456789012345678901234567890123', 12);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (13, '2005-05-18 08:03:28.021862', 13133, 'db1b50cbde7142d344bd8ef9b2e1fe3b3116f77c', '0123456789012345678901234567890c', '0123456789012345678901234567890123456789012345678901234567890123', 13);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (14, '2005-05-18 08:03:28.021862', 13641, 'e19cc1446e3004f10475c37b2cd363f75b8ae89a', '0123456789012345678901234567890d', '0123456789012345678901234567890123456789012345678901234567890123', 14);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (15, '2005-05-18 08:03:28.021862', 13269, 'fc8cab1cb1e5fb1efa3c3c475b8f7c8dc5038d50', '0123456789012345678901234567890f', '0123456789012345678901234567890123456789012345678901234567890123', 15);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (16, '2005-05-18 08:03:28.021862', 13983, 'e17ee3031bd29dcd1e5905c0fd17945600a91ccf', '01234567890123456789012345678910', '0123456789012345678901234567890123456789012345678901234567890123', 16);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (17, '2005-05-18 08:03:28.021862', 12652, '07b01d1e6fe9a729f911e72dfe674a5e0abdc4ee', '01234567890123456789012345678911', '0123456789012345678901234567890123456789012345678901234567890123', 17);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (18, '2005-05-18 08:03:28.021862', 13240, '801dc911c2bd67e17eff087516fdc63a2ac322ce', '01234567890123456789012345678912', '0123456789012345678901234567890123456789012345678901234567890123', 18);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (19, '2005-05-18 08:03:28.021862', 4165, 'fca78a2292e4034b8dfbb2de6f69e17ebeecaaa1', '01234567890123456789012345678913', '0123456789012345678901234567890123456789012345678901234567890123', 19);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (20, '2005-05-18 08:03:28.021862', 4093, 'fc67a1770f78c45c396b4724195aeb10683aa2fd', '01234567890123456789012345678914', '0123456789012345678901234567890123456789012345678901234567890123', 20);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (21, '2005-05-18 08:03:28.021862', 3635, '4ab2ca308dafe152789640942488e23a33e4f46c', '01234567890123456789012345678915', '0123456789012345678901234567890123456789012345678901234567890123', 21);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (22, '2005-05-18 08:03:28.021862', 3553, '20815563ee33368d51e3213354f97c05b4685968', '01234567890123456789012345678916', '0123456789012345678901234567890123456789012345678901234567890123', 22);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (23, '2005-05-18 08:03:28.021862', 3778, '965968d3e6668f39ebc64bc11a3f1a5cd07c213b', '01234567890123456789012345678917', '0123456789012345678901234567890123456789012345678901234567890123', 23);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (24, '2005-05-18 08:03:28.021862', 3666, 'cca8fb78e05a34481e07683cea8c3a47f01c609e', '01234567890123456789012345678918', '0123456789012345678901234567890123456789012345678901234567890123', 24);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (25, '2005-05-18 08:03:28.021862', 3793, '28a7accfb491a2b4895b49b810ca7cda0badc787', '01234567890123456789012345678919', '0123456789012345678901234567890123456789012345678901234567890123', 25);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (26, '2005-05-18 08:03:28.021862', 4773, '03efb176f04f3897de7d5e6484864b0559fd6cd6', '0123456789012345678901234567891a', '0123456789012345678901234567890123456789012345678901234567890123', 26);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (27, '2005-05-18 08:03:28.021862', 2961, '4468039e1d2cbdfc78d2e53477e5fe0537bae302', '0123456789012345678901234567891b', '0123456789012345678901234567890123456789012345678901234567890123', 27);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (28, '2005-05-18 08:03:28.021862', 3558, 'd6c2ddacdab7618ce2a555c20a4a730fcdb42600', '0123456789012345678901234567891c', '0123456789012345678901234567890123456789012345678901234567890123', 28);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (29, '2005-05-18 08:03:28.021862', 3561, '9eb09455e6a568605c1bbab4cdf1936eee92222d', '0123456789012345678901234567891d', '0123456789012345678901234567890123456789012345678901234567890123', 29);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (30, '2005-05-18 08:03:28.021862', 3305, 'b45b170da29f9b22650315657505124766c93720', '0123456789012345678901234567891e', '0123456789012345678901234567890123456789012345678901234567890123', 30);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (31, '2005-05-18 08:03:28.021862', 3987, '9668ba9f0a59f9e6e6bc73fc5dc9f116b202bceb', '0123456789012345678901234567891f', '0123456789012345678901234567890123456789012345678901234567890123', 31);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (32, '2005-05-18 08:03:28.021862', 4908, '874a6ef9cd1aaef17653c6c12f4b83ef9487c1c3', '01234567890123456789012345678920', '0123456789012345678901234567890123456789012345678901234567890123', 32);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (33, '2005-05-18 08:03:28.021862', 4908, '874a6ef9cd1aaef17653c6c12f4b83ef9487c1c3', '01234567890123456789012345678920', '0123456789012345678901234567890123456789012345678901234567890123', 33);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (34, '2005-08-10 09:31:29.606407', 2, '71853c6197a6a7f222db0f1978c7cb232b87c5ee', '01234567890123456789012345678921', '0123456789012345678901234567890123456789012345678901234567890123', 34);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (35, '2005-08-01 09:31:29.606407', 2, '71853c6197a6a7f222db0f1978c7cb232b87c5ee', '01234567890123456789012345678921', '0123456789012345678901234567890123456789012345678901234567890123', 35);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (36, '2005-10-30 18:00:27.899028', 3, '0beec7b5ea3f0fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678922', '0123456789012345678901234567890123456789012345678901234567890123', 36);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (37, '2005-10-30 18:00:27.899028', 3, '1e04c7b5ea3f0fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678923', '0123456789012345678901234567890123456789012345678901234567890123', 37);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (38, '2005-10-30 18:00:27.899028', 3, 'ae04c7b5ea3f0bdb095d0dd47f3c5bc275da8a33', '01234567890123456789012345678924', '0123456789012345678901234567890123456789012345678901234567890123', 38);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (39, '2005-10-30 18:00:27.899028', 3, 'a10856bfea3f0bdb09550dd41f3c5bc275da8a33', '01234567890123456789012345678925', '0123456789012345678901234567890123456789012345678901234567890123', 39);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (40, '2005-10-30 18:00:27.899028', 3, '5a04c7b5ea3f0fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678926', '0123456789012345678901234567890123456789012345678901234567890123', 40);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (42, '2005-10-30 18:00:27.899028', 3, 'a45ed906e4f56fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678927', '0123456789012345678901234567890123456789012345678901234567890123', 42);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (43, '2005-10-30 18:00:27.899028', 3, '4e3961baf4f56fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678928', '0123456789012345678901234567890123456789012345678901234567890123', 43);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (44, '2005-10-30 18:00:27.899028', 3, 'b45ed906e4f5afdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678929', '0123456789012345678901234567890123456789012345678901234567890123', 44);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (45, '2006-08-01 09:31:29.606407', 2, '43853c6197a6a7f222db0f1978c7cb232b87c5ee', '0123456789012345678901234567892a', '0123456789012345678901234567890123456789012345678901234567890123', 45);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (46, '2006-05-24 09:31:29.606407', 2, 'ab43246197a6a7f222db0f1978c7cb232b87c5ee', '0123456789012345678901234567892b', '0123456789012345678901234567890123456789012345678901234567890123', 46);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (47, '2006-05-24 09:31:29.606407', 2, 'cabf42e197a6a7f222db0f1978c7cb232b87c5ee', '0123456789012345678901234567892c', '0123456789012345678901234567890123456789012345678901234567890123', 47);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (51, '2006-07-14 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5437', '0123456789012345678901234567890123456789012345678901234567890123', 51);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (52, '2006-05-24 09:31:29.606407', 2, '1622db354faa9fa653804d018f3b9d5291e37d6b', 'e4a7193a8f72fa2755e2162512069093', '0123456789012345678901234567890123456789012345678901234567890123', 52);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (53, '2006-12-01 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5437', '0123456789012345678901234567890123456789012345678901234567890123', 53);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (54, '2006-12-01 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5438', '0123456789012345678901234567890123456789012345678901234567890123', 54);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (55, '2006-12-01 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5439', '0123456789012345678901234567890123456789012345678901234567890123', 55);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (56, '2006-12-01 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5440', '0123456789012345678901234567890123456789012345678901234567890123', 56);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (57, '2006-12-13 21:17:56.241901', 1599, 'acdf6b9b99c39b1585f829ec7d68598a8e10816d', '5c6fa250b612e7e4d17261268a4d8400', '0123456789012345678901234567890123456789012345678901234567890123', 57);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (58, '2006-12-13 21:18:28.796588', 1599, 'acdf6b9b99c39b1585f829ec7d68598a8e10816d', '5c6fa250b612e7e4d17261268a4d8401', '0123456789012345678901234567890123456789012345678901234567890123', 58);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (59, '2006-05-24 09:31:29.606407', 2, 'fabb42e197a6a7f222db0f1978c7cb232b87c5ee', '0123456789012345678901234567892d', '0123456789012345678901234567890123456789012345678901234567890123', 59);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (60, '2007-01-03 17:26:27.288968', 11793, 'df3a6670671781d5e08d7795ca1ada776815d87f', 'e8120781cd606202fd259a4f0d4585bb', '0123456789012345678901234567890123456789012345678901234567890123', 60);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (61, '2007-02-15 14:26:27.288968', 100, 'df3a6670671781d5e08d7795ca1ada776815d87f', 'e8120781cd606202fd259a4f0d4585b1', '0123456789012345678901234567890123456789012345678901234567890123', 61);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (62, '2007-05-14 23:21:11.121446', 123, 'd06b970f258e57547ef1104fba3499eb4ab43ff6', '767e1635f55ff5e833410523decec438', '0123456789012345678901234567890123456789012345678901234567890123', 62);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (63, '2007-05-14 23:21:11.121446', 123, 'd06b970f258e57547ef1104fba3499eb4ab43ff6', '767e1635f55ff5e833410523decec438', '0123456789012345678901234567890123456789012345678901234567890123', 63);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (65, '2007-08-09 21:25:37.832976', 958, 'df4adf483eb24fec455e8411ca3dceb0bee51b44', 'b85b447f88c326c4124f0554e175097f', '0123456789012345678901234567890123456789012345678901234567890123', 65);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (66, '2007-08-09 21:25:37.832976', 179, '3e00fea68e91f6e03de6333b4c8e60c2ce441926', 'f27fb7494c5afbb0fb10b78d16f7da37', '0123456789012345678901234567890123456789012345678901234567890123', 66);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (67, '2007-08-09 21:25:37.832976', 610, '01bedc249af59cb80abb40b4898eced10f5d5e20', '7d6fa416334c6da3b954bf9ebff6e9ae', '0123456789012345678901234567890123456789012345678901234567890123', 67);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (68, '2007-08-09 21:25:37.832976', 567, 'b5aeb55faeb86a1d8c1a93dd58131b387a604c5a', '95f2b067e046d73f4e93eca44c034b97', '0123456789012345678901234567890123456789012345678901234567890123', 68);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (69, '2007-08-09 21:54:18.456616', 749, '0526ef40da99af5c1c97c91f9aca77e7ae564838', '8afa3dbc21b2dcdad7f31ab28c041ad9', '0123456789012345678901234567890123456789012345678901234567890123', 69);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (70, '2007-08-09 21:54:18.456616', 652, '0ce85c0cf331d05f76aa4977c43e87e9ffbd0480', '05a37db4ba50ba5f28650ee74b450c2c', '0123456789012345678901234567890123456789012345678901234567890123', 70);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (71, '2007-09-10 19:14:26.037382', 22897, 'd7ebed9e00fc134ebc79eaf7deebb30a4f5f6859', '0113f983ff8beba46ad64c4ae8899091', '0123456789012345678901234567890123456789012345678901234567890123', 71);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (72, '2007-09-10 19:15:01.67038', 221, '0ddef36534d59da64790eeffa55cc0221a01736d', 'df6ce34951747929ca9c6a4e2cb78f94', '0123456789012345678901234567890123456789012345678901234567890123', 72);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (73, '2007-09-10 19:15:19.947543', 217, 'ea265925f6214628dc46e731ca1e131f1e632127', '9d19d15feffc620c0d16523e0ce00a54', '0123456789012345678901234567890123456789012345678901234567890123', 73);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (74, '2007-09-10 19:16:01.017943', 22899, '234acbb3dc11b2af9bc46b6e33f0e453c3b1289d', '6d2d916ea729bc875ca0bd739f6be476', '0123456789012345678901234567890123456789012345678901234567890123', 74);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (75, '2007-12-18 16:31:34.790641', 4296, 'e8b25389964bc3bd471c20a1508d00852ee7de40', 'e6b759498b7cde49e9d34e7b8c8b4542', '0123456789012345678901234567890123456789012345678901234567890123', 75);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (76, '2007-12-18 16:31:34.790641', 2103, 'c154e1c1c2407d9b80c96b63c48d61a94248bf95', 'd86630cafdf624a3aa32aba0c41078c5', '0123456789012345678901234567890123456789012345678901234567890123', 76);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (77, '2007-12-18 16:31:34.790641', 2787, '2d94c4a6a014895f93b581fb0134efe73ae4e2c8', '315ef57e5f6ad295e98db65607c5c18a', '0123456789012345678901234567890123456789012345678901234567890123', 77);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (78, '2007-12-18 16:31:34.790641', 3534, '2bd22db53f2b9e47df50ed731128ff1fc54a5775', 'e0d510b49f803a0a4c2b2712d0a80522', '0123456789012345678901234567890123456789012345678901234567890123', 78);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (79, '2007-12-18 16:31:34.790641', 3327, 'a57356e4cbf97bbb47df202449a95d909d50614a', '8c5ffb558a0d0f520887f3d4cbd619c5', '0123456789012345678901234567890123456789012345678901234567890123', 79);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (80, '2007-12-18 16:31:34.790641', 189, '9800f54c65017e1bafe2d09a13af6176ba0ab244', 'a94677aabcd34b0901f1f75a35f7dff3', '0123456789012345678901234567890123456789012345678901234567890123', 80);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (81, '2007-12-18 16:31:34.790641', 2926, 'b53bb11bc40c42b0f9ecd981561fe9d6f265b275', '496cf1cbb97c17a67998478402520ab5', '0123456789012345678901234567890123456789012345678901234567890123', 81);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (82, '2008-03-17 15:36:19.035615', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123', 82);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (83, '2008-03-17 15:36:38.022812', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123', 83);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (84, '2008-03-17 15:36:48.877842', 3, '55ca6286e3e4f4fba5d0448333fa99fc5a404a73', '764efa883dda1e11db47671c4a3bbd9e', '0123456789012345678901234567890123456789012345678901234567890123', 84);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (85, '2008-03-17 15:37:10.252357', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123', 85);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (86, '2008-03-17 15:37:22.489973', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123', 86);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (87, '2008-03-17 15:37:36.701686', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123', 87);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (88, '2008-03-17 15:37:48.465157', 3, '55ca6286e3e4f4fba5d0448333fa99fc5a404a73', '764efa883dda1e11db47671c4a3bbd9e', '0123456789012345678901234567890123456789012345678901234567890123', 88);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (89, '2008-03-17 15:38:16.866444', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123', 89);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (90, '2008-05-08 10:10:16.866444', 18, '0c805a60b31058a1018680f99447033dcb9d4caa', '8a8a67b8dbc5f203ae8712092c68c7aa', '0123456789012345678901234567890123456789012345678901234567890123', 90);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (91, '2008-07-07 22:30:01.123456', 10, '0c805a60b31058a1018680f99447033dcb9d4c01', '8a8a67b8dbc5f203ae8712092c68c701', '0123456789012345678901234567890123456789012345678901234567890123', 91);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (92, '2008-09-30 08:19:00.222131', 10, 'f10e2821bbbea527ea02200352313bc059445190', '7815696ecbf1c96e6894b779456d330e', '0123456789012345678901234567890123456789012345678901234567890123', 92);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-04-07 16:46:05.265391', 178859, '378b3498ead213d35a82033a6e9196014a5ef25c', '01234567890123456789012345678900', '0123456789012345678901234567890123456789012345678901234567890123', 1);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-04-07 16:46:05.266763', 9922560, 'a57faa6287aee2c58e115673a119c6083d31d1b9', '01234567890123456789012345678902', '0123456789012345678901234567890123456789012345678901234567890123', 2);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-04-07 16:46:05.26727', 309386, 'b218ca7b52fa813550e3f14cdcf3ba68606e4446', '01234567890123456789012345678903', '0123456789012345678901234567890123456789012345678901234567890123', 3);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-04-07 16:46:05.267803', 162927750, 'cfbd3ee1f510c66d49be465b900a3334e8488184', '01234567890123456789012345678904', '0123456789012345678901234567890123456789012345678901234567890123', 4);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 10826, '502828e7591277535abe9015ffbc6918dbba8ef4', '01234567890123456789012345678907', '0123456789012345678901234567890123456789012345678901234567890123', 7);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 10826, '502828e7591277535abe9015ffbc6918dbba8ef4', '01234567890123456789012345678907', '0123456789012345678901234567890123456789012345678901234567890123', 8);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 12652, '07b01d1e6fe9a729f911e72dfe674a5e0abdc4ee', '01234567890123456789012345678911', '0123456789012345678901234567890123456789012345678901234567890123', 17);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 12695, '8812d04c170ca90bb1423e188ce9706869aa03d7', '0123456789012345678901234567890b', '0123456789012345678901234567890123456789012345678901234567890123', 12);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 13110, 'bc7bebca1e3c5c166838b19f0eeb7f171e51805d', '01234567890123456789012345678909', '0123456789012345678901234567890123456789012345678901234567890123', 10);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 13133, 'db1b50cbde7142d344bd8ef9b2e1fe3b3116f77c', '0123456789012345678901234567890c', '0123456789012345678901234567890123456789012345678901234567890123', 13);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 13240, '801dc911c2bd67e17eff087516fdc63a2ac322ce', '01234567890123456789012345678912', '0123456789012345678901234567890123456789012345678901234567890123', 18);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 13269, 'fc8cab1cb1e5fb1efa3c3c475b8f7c8dc5038d50', '0123456789012345678901234567890f', '0123456789012345678901234567890123456789012345678901234567890123', 15);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 13499, '78a26efee75a54f113063b78783b2d4612fee409', '0123456789012345678901234567890a', '0123456789012345678901234567890123456789012345678901234567890123', 11);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 13641, 'e19cc1446e3004f10475c37b2cd363f75b8ae89a', '0123456789012345678901234567890d', '0123456789012345678901234567890123456789012345678901234567890123', 14);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 13983, 'e17ee3031bd29dcd1e5905c0fd17945600a91ccf', '01234567890123456789012345678910', '0123456789012345678901234567890123456789012345678901234567890123', 16);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 2655, 'ca3b107af84c05eaf98ba073376153986566ec28', '01234567890123456789012345678908', '0123456789012345678901234567890123456789012345678901234567890123', 9);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 2961, '4468039e1d2cbdfc78d2e53477e5fe0537bae302', '0123456789012345678901234567891b', '0123456789012345678901234567890123456789012345678901234567890123', 27);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 3305, 'b45b170da29f9b22650315657505124766c93720', '0123456789012345678901234567891e', '0123456789012345678901234567890123456789012345678901234567890123', 30);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 3553, '20815563ee33368d51e3213354f97c05b4685968', '01234567890123456789012345678916', '0123456789012345678901234567890123456789012345678901234567890123', 22);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 3558, 'd6c2ddacdab7618ce2a555c20a4a730fcdb42600', '0123456789012345678901234567891c', '0123456789012345678901234567890123456789012345678901234567890123', 28);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 3561, '9eb09455e6a568605c1bbab4cdf1936eee92222d', '0123456789012345678901234567891d', '0123456789012345678901234567890123456789012345678901234567890123', 29);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 3635, '4ab2ca308dafe152789640942488e23a33e4f46c', '01234567890123456789012345678915', '0123456789012345678901234567890123456789012345678901234567890123', 21);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 3666, 'cca8fb78e05a34481e07683cea8c3a47f01c609e', '01234567890123456789012345678918', '0123456789012345678901234567890123456789012345678901234567890123', 24);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 3778, '965968d3e6668f39ebc64bc11a3f1a5cd07c213b', '01234567890123456789012345678917', '0123456789012345678901234567890123456789012345678901234567890123', 23);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 3793, '28a7accfb491a2b4895b49b810ca7cda0badc787', '01234567890123456789012345678919', '0123456789012345678901234567890123456789012345678901234567890123', 25);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 3987, '9668ba9f0a59f9e6e6bc73fc5dc9f116b202bceb', '0123456789012345678901234567891f', '0123456789012345678901234567890123456789012345678901234567890123', 31);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 4093, 'fc67a1770f78c45c396b4724195aeb10683aa2fd', '01234567890123456789012345678914', '0123456789012345678901234567890123456789012345678901234567890123', 20);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 4165, 'fca78a2292e4034b8dfbb2de6f69e17ebeecaaa1', '01234567890123456789012345678913', '0123456789012345678901234567890123456789012345678901234567890123', 19);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 4381, '9b1f78faa39fb09a9fd955d744002c2d8f32d88d', '01234567890123456789012345678905', '0123456789012345678901234567890123456789012345678901234567890123', 5);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 4773, '03efb176f04f3897de7d5e6484864b0559fd6cd6', '0123456789012345678901234567891a', '0123456789012345678901234567890123456789012345678901234567890123', 26);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 4908, '874a6ef9cd1aaef17653c6c12f4b83ef9487c1c3', '01234567890123456789012345678920', '0123456789012345678901234567890123456789012345678901234567890123', 32);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 4908, '874a6ef9cd1aaef17653c6c12f4b83ef9487c1c3', '01234567890123456789012345678920', '0123456789012345678901234567890123456789012345678901234567890123', 33);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 7910, 'afdf21d698587a6601e2ffed0f44292b7ad5dd07', '01234567890123456789012345678906', '0123456789012345678901234567890123456789012345678901234567890123', 6);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-08-01 09:31:29.606407', 2, '71853c6197a6a7f222db0f1978c7cb232b87c5ee', '01234567890123456789012345678921', '0123456789012345678901234567890123456789012345678901234567890123', 35);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-08-10 09:31:29.606407', 2, '71853c6197a6a7f222db0f1978c7cb232b87c5ee', '01234567890123456789012345678921', '0123456789012345678901234567890123456789012345678901234567890123', 34);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-10-30 18:00:27.899028', 3, '0beec7b5ea3f0fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678922', '0123456789012345678901234567890123456789012345678901234567890123', 36);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-10-30 18:00:27.899028', 3, '1e04c7b5ea3f0fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678923', '0123456789012345678901234567890123456789012345678901234567890123', 37);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-10-30 18:00:27.899028', 3, '4e3961baf4f56fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678928', '0123456789012345678901234567890123456789012345678901234567890123', 43);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-10-30 18:00:27.899028', 3, '5a04c7b5ea3f0fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678926', '0123456789012345678901234567890123456789012345678901234567890123', 40);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-10-30 18:00:27.899028', 3, 'a10856bfea3f0bdb09550dd41f3c5bc275da8a33', '01234567890123456789012345678925', '0123456789012345678901234567890123456789012345678901234567890123', 39);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-10-30 18:00:27.899028', 3, 'a45ed906e4f56fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678927', '0123456789012345678901234567890123456789012345678901234567890123', 42);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-10-30 18:00:27.899028', 3, 'ae04c7b5ea3f0bdb095d0dd47f3c5bc275da8a33', '01234567890123456789012345678924', '0123456789012345678901234567890123456789012345678901234567890123', 38);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-10-30 18:00:27.899028', 3, 'b45ed906e4f5afdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678929', '0123456789012345678901234567890123456789012345678901234567890123', 44);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2006-05-24 09:31:29.606407', 2, '1622db354faa9fa653804d018f3b9d5291e37d6b', 'e4a7193a8f72fa2755e2162512069093', '0123456789012345678901234567890123456789012345678901234567890123', 52);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2006-05-24 09:31:29.606407', 2, 'ab43246197a6a7f222db0f1978c7cb232b87c5ee', '0123456789012345678901234567892b', '0123456789012345678901234567890123456789012345678901234567890123', 46);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2006-05-24 09:31:29.606407', 2, 'cabf42e197a6a7f222db0f1978c7cb232b87c5ee', '0123456789012345678901234567892c', '0123456789012345678901234567890123456789012345678901234567890123', 47);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2006-05-24 09:31:29.606407', 2, 'fabb42e197a6a7f222db0f1978c7cb232b87c5ee', '0123456789012345678901234567892d', '0123456789012345678901234567890123456789012345678901234567890123', 59);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2006-07-14 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5437', '0123456789012345678901234567890123456789012345678901234567890123', 51);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2006-08-01 09:31:29.606407', 2, '43853c6197a6a7f222db0f1978c7cb232b87c5ee', '0123456789012345678901234567892a', '0123456789012345678901234567890123456789012345678901234567890123', 45);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2006-12-01 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5437', '0123456789012345678901234567890123456789012345678901234567890123', 53);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2006-12-01 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5438', '0123456789012345678901234567890123456789012345678901234567890123', 54);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2006-12-01 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5439', '0123456789012345678901234567890123456789012345678901234567890123', 55);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2006-12-01 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5440', '0123456789012345678901234567890123456789012345678901234567890123', 56);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2006-12-13 21:17:56.241901', 1599, 'acdf6b9b99c39b1585f829ec7d68598a8e10816d', '5c6fa250b612e7e4d17261268a4d8400', '0123456789012345678901234567890123456789012345678901234567890123', 57);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2006-12-13 21:18:28.796588', 1599, 'acdf6b9b99c39b1585f829ec7d68598a8e10816d', '5c6fa250b612e7e4d17261268a4d8401', '0123456789012345678901234567890123456789012345678901234567890123', 58);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-01-03 17:26:27.288968', 11793, 'df3a6670671781d5e08d7795ca1ada776815d87f', 'e8120781cd606202fd259a4f0d4585bb', '0123456789012345678901234567890123456789012345678901234567890123', 60);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-02-15 14:26:27.288968', 100, 'df3a6670671781d5e08d7795ca1ada776815d87f', 'e8120781cd606202fd259a4f0d4585b1', '0123456789012345678901234567890123456789012345678901234567890123', 61);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-05-14 23:21:11.121446', 123, 'd06b970f258e57547ef1104fba3499eb4ab43ff6', '767e1635f55ff5e833410523decec438', '0123456789012345678901234567890123456789012345678901234567890123', 62);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-05-14 23:21:11.121446', 123, 'd06b970f258e57547ef1104fba3499eb4ab43ff6', '767e1635f55ff5e833410523decec438', '0123456789012345678901234567890123456789012345678901234567890123', 63);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-08-09 21:25:37.832976', 179, '3e00fea68e91f6e03de6333b4c8e60c2ce441926', 'f27fb7494c5afbb0fb10b78d16f7da37', '0123456789012345678901234567890123456789012345678901234567890123', 66);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-08-09 21:25:37.832976', 567, 'b5aeb55faeb86a1d8c1a93dd58131b387a604c5a', '95f2b067e046d73f4e93eca44c034b97', '0123456789012345678901234567890123456789012345678901234567890123', 68);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-08-09 21:25:37.832976', 610, '01bedc249af59cb80abb40b4898eced10f5d5e20', '7d6fa416334c6da3b954bf9ebff6e9ae', '0123456789012345678901234567890123456789012345678901234567890123', 67);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-08-09 21:25:37.832976', 958, 'df4adf483eb24fec455e8411ca3dceb0bee51b44', 'b85b447f88c326c4124f0554e175097f', '0123456789012345678901234567890123456789012345678901234567890123', 65);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-08-09 21:54:18.456616', 652, '0ce85c0cf331d05f76aa4977c43e87e9ffbd0480', '05a37db4ba50ba5f28650ee74b450c2c', '0123456789012345678901234567890123456789012345678901234567890123', 70);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-08-09 21:54:18.456616', 749, '0526ef40da99af5c1c97c91f9aca77e7ae564838', '8afa3dbc21b2dcdad7f31ab28c041ad9', '0123456789012345678901234567890123456789012345678901234567890123', 69);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-09-10 19:14:26.037382', 22897, 'd7ebed9e00fc134ebc79eaf7deebb30a4f5f6859', '0113f983ff8beba46ad64c4ae8899091', '0123456789012345678901234567890123456789012345678901234567890123', 71);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-09-10 19:15:01.67038', 221, '0ddef36534d59da64790eeffa55cc0221a01736d', 'df6ce34951747929ca9c6a4e2cb78f94', '0123456789012345678901234567890123456789012345678901234567890123', 72);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-09-10 19:15:19.947543', 217, 'ea265925f6214628dc46e731ca1e131f1e632127', '9d19d15feffc620c0d16523e0ce00a54', '0123456789012345678901234567890123456789012345678901234567890123', 73);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-09-10 19:16:01.017943', 22899, '234acbb3dc11b2af9bc46b6e33f0e453c3b1289d', '6d2d916ea729bc875ca0bd739f6be476', '0123456789012345678901234567890123456789012345678901234567890123', 74);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-12-18 16:31:34.790641', 189, '9800f54c65017e1bafe2d09a13af6176ba0ab244', 'a94677aabcd34b0901f1f75a35f7dff3', '0123456789012345678901234567890123456789012345678901234567890123', 80);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-12-18 16:31:34.790641', 2103, 'c154e1c1c2407d9b80c96b63c48d61a94248bf95', 'd86630cafdf624a3aa32aba0c41078c5', '0123456789012345678901234567890123456789012345678901234567890123', 76);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-12-18 16:31:34.790641', 2787, '2d94c4a6a014895f93b581fb0134efe73ae4e2c8', '315ef57e5f6ad295e98db65607c5c18a', '0123456789012345678901234567890123456789012345678901234567890123', 77);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-12-18 16:31:34.790641', 2926, 'b53bb11bc40c42b0f9ecd981561fe9d6f265b275', '496cf1cbb97c17a67998478402520ab5', '0123456789012345678901234567890123456789012345678901234567890123', 81);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-12-18 16:31:34.790641', 3327, 'a57356e4cbf97bbb47df202449a95d909d50614a', '8c5ffb558a0d0f520887f3d4cbd619c5', '0123456789012345678901234567890123456789012345678901234567890123', 79);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-12-18 16:31:34.790641', 3534, '2bd22db53f2b9e47df50ed731128ff1fc54a5775', 'e0d510b49f803a0a4c2b2712d0a80522', '0123456789012345678901234567890123456789012345678901234567890123', 78);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-12-18 16:31:34.790641', 4296, 'e8b25389964bc3bd471c20a1508d00852ee7de40', 'e6b759498b7cde49e9d34e7b8c8b4542', '0123456789012345678901234567890123456789012345678901234567890123', 75);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2008-03-17 15:36:19.035615', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123', 82);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2008-03-17 15:36:38.022812', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123', 83);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2008-03-17 15:36:48.877842', 3, '55ca6286e3e4f4fba5d0448333fa99fc5a404a73', '764efa883dda1e11db47671c4a3bbd9e', '0123456789012345678901234567890123456789012345678901234567890123', 84);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2008-03-17 15:37:10.252357', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123', 85);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2008-03-17 15:37:22.489973', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123', 86);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2008-03-17 15:37:36.701686', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123', 87);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2008-03-17 15:37:48.465157', 3, '55ca6286e3e4f4fba5d0448333fa99fc5a404a73', '764efa883dda1e11db47671c4a3bbd9e', '0123456789012345678901234567890123456789012345678901234567890123', 88);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2008-03-17 15:38:16.866444', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123', 89);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2008-05-08 10:10:16.866444', 18, '0c805a60b31058a1018680f99447033dcb9d4caa', '8a8a67b8dbc5f203ae8712092c68c7aa', '0123456789012345678901234567890123456789012345678901234567890123', 90);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2008-07-07 22:30:01.123456', 10, '0c805a60b31058a1018680f99447033dcb9d4c01', '8a8a67b8dbc5f203ae8712092c68c701', '0123456789012345678901234567890123456789012345678901234567890123', 91);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2008-09-30 08:19:00.222131', 10, 'f10e2821bbbea527ea02200352313bc059445190', '7815696ecbf1c96e6894b779456d330e', '0123456789012345678901234567890123456789012345678901234567890123', 92);
 
 
 ALTER TABLE libraryfilecontent ENABLE TRIGGER ALL;
@@ -753,93 +753,93 @@
 
 ALTER TABLE libraryfilealias DISABLE TRIGGER ALL;
 
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
 
 
 ALTER TABLE libraryfilealias ENABLE TRIGGER ALL;
 
=== modified file 'database/sampledata/current.sql'
--- database/sampledata/current.sql	2014-08-04 06:45:45 +0000
+++ database/sampledata/current.sql	2014-08-08 07:05:30 +0000
@@ -659,93 +659,93 @@
 
 ALTER TABLE libraryfilecontent DISABLE TRIGGER ALL;
 
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (1, '2005-04-07 16:46:05.265391', 178859, '378b3498ead213d35a82033a6e9196014a5ef25c', '01234567890123456789012345678900', '0123456789012345678901234567890123456789012345678901234567890123', 1);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (2, '2005-04-07 16:46:05.266763', 9922560, 'a57faa6287aee2c58e115673a119c6083d31d1b9', '01234567890123456789012345678902', '0123456789012345678901234567890123456789012345678901234567890123', 2);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (3, '2005-04-07 16:46:05.26727', 309386, 'b218ca7b52fa813550e3f14cdcf3ba68606e4446', '01234567890123456789012345678903', '0123456789012345678901234567890123456789012345678901234567890123', 3);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (4, '2005-04-07 16:46:05.267803', 162927750, 'cfbd3ee1f510c66d49be465b900a3334e8488184', '01234567890123456789012345678904', '0123456789012345678901234567890123456789012345678901234567890123', 4);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (5, '2005-05-18 08:03:28.021862', 4381, '9b1f78faa39fb09a9fd955d744002c2d8f32d88d', '01234567890123456789012345678905', '0123456789012345678901234567890123456789012345678901234567890123', 5);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (6, '2005-05-18 08:03:28.021862', 7910, 'afdf21d698587a6601e2ffed0f44292b7ad5dd07', '01234567890123456789012345678906', '0123456789012345678901234567890123456789012345678901234567890123', 6);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (7, '2005-05-18 08:03:28.021862', 10826, '502828e7591277535abe9015ffbc6918dbba8ef4', '01234567890123456789012345678907', '0123456789012345678901234567890123456789012345678901234567890123', 7);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (8, '2005-05-18 08:03:28.021862', 10826, '502828e7591277535abe9015ffbc6918dbba8ef4', '01234567890123456789012345678907', '0123456789012345678901234567890123456789012345678901234567890123', 8);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (9, '2005-05-18 08:03:28.021862', 2655, 'ca3b107af84c05eaf98ba073376153986566ec28', '01234567890123456789012345678908', '0123456789012345678901234567890123456789012345678901234567890123', 9);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (10, '2005-05-18 08:03:28.021862', 13110, 'bc7bebca1e3c5c166838b19f0eeb7f171e51805d', '01234567890123456789012345678909', '0123456789012345678901234567890123456789012345678901234567890123', 10);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (11, '2005-05-18 08:03:28.021862', 13499, '78a26efee75a54f113063b78783b2d4612fee409', '0123456789012345678901234567890a', '0123456789012345678901234567890123456789012345678901234567890123', 11);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (12, '2005-05-18 08:03:28.021862', 12695, '8812d04c170ca90bb1423e188ce9706869aa03d7', '0123456789012345678901234567890b', '0123456789012345678901234567890123456789012345678901234567890123', 12);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (13, '2005-05-18 08:03:28.021862', 13133, 'db1b50cbde7142d344bd8ef9b2e1fe3b3116f77c', '0123456789012345678901234567890c', '0123456789012345678901234567890123456789012345678901234567890123', 13);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (14, '2005-05-18 08:03:28.021862', 13641, 'e19cc1446e3004f10475c37b2cd363f75b8ae89a', '0123456789012345678901234567890d', '0123456789012345678901234567890123456789012345678901234567890123', 14);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (15, '2005-05-18 08:03:28.021862', 13269, 'fc8cab1cb1e5fb1efa3c3c475b8f7c8dc5038d50', '0123456789012345678901234567890f', '0123456789012345678901234567890123456789012345678901234567890123', 15);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (16, '2005-05-18 08:03:28.021862', 13983, 'e17ee3031bd29dcd1e5905c0fd17945600a91ccf', '01234567890123456789012345678910', '0123456789012345678901234567890123456789012345678901234567890123', 16);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (17, '2005-05-18 08:03:28.021862', 12652, '07b01d1e6fe9a729f911e72dfe674a5e0abdc4ee', '01234567890123456789012345678911', '0123456789012345678901234567890123456789012345678901234567890123', 17);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (18, '2005-05-18 08:03:28.021862', 13240, '801dc911c2bd67e17eff087516fdc63a2ac322ce', '01234567890123456789012345678912', '0123456789012345678901234567890123456789012345678901234567890123', 18);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (19, '2005-05-18 08:03:28.021862', 4165, 'fca78a2292e4034b8dfbb2de6f69e17ebeecaaa1', '01234567890123456789012345678913', '0123456789012345678901234567890123456789012345678901234567890123', 19);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (20, '2005-05-18 08:03:28.021862', 4093, 'fc67a1770f78c45c396b4724195aeb10683aa2fd', '01234567890123456789012345678914', '0123456789012345678901234567890123456789012345678901234567890123', 20);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (21, '2005-05-18 08:03:28.021862', 3635, '4ab2ca308dafe152789640942488e23a33e4f46c', '01234567890123456789012345678915', '0123456789012345678901234567890123456789012345678901234567890123', 21);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (22, '2005-05-18 08:03:28.021862', 3553, '20815563ee33368d51e3213354f97c05b4685968', '01234567890123456789012345678916', '0123456789012345678901234567890123456789012345678901234567890123', 22);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (23, '2005-05-18 08:03:28.021862', 3778, '965968d3e6668f39ebc64bc11a3f1a5cd07c213b', '01234567890123456789012345678917', '0123456789012345678901234567890123456789012345678901234567890123', 23);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (24, '2005-05-18 08:03:28.021862', 3666, 'cca8fb78e05a34481e07683cea8c3a47f01c609e', '01234567890123456789012345678918', '0123456789012345678901234567890123456789012345678901234567890123', 24);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (25, '2005-05-18 08:03:28.021862', 3793, '28a7accfb491a2b4895b49b810ca7cda0badc787', '01234567890123456789012345678919', '0123456789012345678901234567890123456789012345678901234567890123', 25);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (26, '2005-05-18 08:03:28.021862', 4773, '03efb176f04f3897de7d5e6484864b0559fd6cd6', '0123456789012345678901234567891a', '0123456789012345678901234567890123456789012345678901234567890123', 26);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (27, '2005-05-18 08:03:28.021862', 2961, '4468039e1d2cbdfc78d2e53477e5fe0537bae302', '0123456789012345678901234567891b', '0123456789012345678901234567890123456789012345678901234567890123', 27);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (28, '2005-05-18 08:03:28.021862', 3558, 'd6c2ddacdab7618ce2a555c20a4a730fcdb42600', '0123456789012345678901234567891c', '0123456789012345678901234567890123456789012345678901234567890123', 28);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (29, '2005-05-18 08:03:28.021862', 3561, '9eb09455e6a568605c1bbab4cdf1936eee92222d', '0123456789012345678901234567891d', '0123456789012345678901234567890123456789012345678901234567890123', 29);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (30, '2005-05-18 08:03:28.021862', 3305, 'b45b170da29f9b22650315657505124766c93720', '0123456789012345678901234567891e', '0123456789012345678901234567890123456789012345678901234567890123', 30);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (31, '2005-05-18 08:03:28.021862', 3987, '9668ba9f0a59f9e6e6bc73fc5dc9f116b202bceb', '0123456789012345678901234567891f', '0123456789012345678901234567890123456789012345678901234567890123', 31);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (32, '2005-05-18 08:03:28.021862', 4908, '874a6ef9cd1aaef17653c6c12f4b83ef9487c1c3', '01234567890123456789012345678920', '0123456789012345678901234567890123456789012345678901234567890123', 32);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (33, '2005-05-18 08:03:28.021862', 4908, '874a6ef9cd1aaef17653c6c12f4b83ef9487c1c3', '01234567890123456789012345678920', '0123456789012345678901234567890123456789012345678901234567890123', 33);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (34, '2005-08-10 09:31:29.606407', 2, '71853c6197a6a7f222db0f1978c7cb232b87c5ee', '01234567890123456789012345678921', '0123456789012345678901234567890123456789012345678901234567890123', 34);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (35, '2005-08-01 09:31:29.606407', 2, '71853c6197a6a7f222db0f1978c7cb232b87c5ee', '01234567890123456789012345678921', '0123456789012345678901234567890123456789012345678901234567890123', 35);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (36, '2005-10-30 18:00:27.899028', 3, '0beec7b5ea3f0fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678922', '0123456789012345678901234567890123456789012345678901234567890123', 36);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (37, '2005-10-30 18:00:27.899028', 3, '1e04c7b5ea3f0fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678923', '0123456789012345678901234567890123456789012345678901234567890123', 37);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (38, '2005-10-30 18:00:27.899028', 3, 'ae04c7b5ea3f0bdb095d0dd47f3c5bc275da8a33', '01234567890123456789012345678924', '0123456789012345678901234567890123456789012345678901234567890123', 38);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (39, '2005-10-30 18:00:27.899028', 3, 'a10856bfea3f0bdb09550dd41f3c5bc275da8a33', '01234567890123456789012345678925', '0123456789012345678901234567890123456789012345678901234567890123', 39);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (40, '2005-10-30 18:00:27.899028', 3, '5a04c7b5ea3f0fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678926', '0123456789012345678901234567890123456789012345678901234567890123', 40);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (42, '2005-10-30 18:00:27.899028', 3, 'a45ed906e4f56fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678927', '0123456789012345678901234567890123456789012345678901234567890123', 42);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (43, '2005-10-30 18:00:27.899028', 3, '4e3961baf4f56fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678928', '0123456789012345678901234567890123456789012345678901234567890123', 43);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (44, '2005-10-30 18:00:27.899028', 3, 'b45ed906e4f5afdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678929', '0123456789012345678901234567890123456789012345678901234567890123', 44);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (45, '2006-08-01 09:31:29.606407', 2, '43853c6197a6a7f222db0f1978c7cb232b87c5ee', '0123456789012345678901234567892a', '0123456789012345678901234567890123456789012345678901234567890123', 45);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (46, '2006-05-24 09:31:29.606407', 2, 'ab43246197a6a7f222db0f1978c7cb232b87c5ee', '0123456789012345678901234567892b', '0123456789012345678901234567890123456789012345678901234567890123', 46);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (47, '2006-05-24 09:31:29.606407', 2, 'cabf42e197a6a7f222db0f1978c7cb232b87c5ee', '0123456789012345678901234567892c', '0123456789012345678901234567890123456789012345678901234567890123', 47);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (51, '2006-07-14 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5437', '0123456789012345678901234567890123456789012345678901234567890123', 51);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (52, '2006-05-24 09:31:29.606407', 2, '1622db354faa9fa653804d018f3b9d5291e37d6b', 'e4a7193a8f72fa2755e2162512069093', '0123456789012345678901234567890123456789012345678901234567890123', 52);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (53, '2006-12-01 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5437', '0123456789012345678901234567890123456789012345678901234567890123', 53);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (54, '2006-12-01 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5438', '0123456789012345678901234567890123456789012345678901234567890123', 54);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (55, '2006-12-01 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5439', '0123456789012345678901234567890123456789012345678901234567890123', 55);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (56, '2006-12-01 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5440', '0123456789012345678901234567890123456789012345678901234567890123', 56);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (57, '2006-12-13 21:17:56.241901', 1599, 'acdf6b9b99c39b1585f829ec7d68598a8e10816d', '5c6fa250b612e7e4d17261268a4d8400', '0123456789012345678901234567890123456789012345678901234567890123', 57);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (58, '2006-12-13 21:18:28.796588', 1599, 'acdf6b9b99c39b1585f829ec7d68598a8e10816d', '5c6fa250b612e7e4d17261268a4d8401', '0123456789012345678901234567890123456789012345678901234567890123', 58);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (59, '2006-05-24 09:31:29.606407', 2, 'fabb42e197a6a7f222db0f1978c7cb232b87c5ee', '0123456789012345678901234567892d', '0123456789012345678901234567890123456789012345678901234567890123', 59);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (60, '2007-01-03 17:26:27.288968', 11793, 'df3a6670671781d5e08d7795ca1ada776815d87f', 'e8120781cd606202fd259a4f0d4585bb', '0123456789012345678901234567890123456789012345678901234567890123', 60);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (61, '2007-02-15 14:26:27.288968', 100, 'df3a6670671781d5e08d7795ca1ada776815d87f', 'e8120781cd606202fd259a4f0d4585b1', '0123456789012345678901234567890123456789012345678901234567890123', 61);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (62, '2007-05-14 23:21:11.121446', 123, 'd06b970f258e57547ef1104fba3499eb4ab43ff6', '767e1635f55ff5e833410523decec438', '0123456789012345678901234567890123456789012345678901234567890123', 62);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (63, '2007-05-14 23:21:11.121446', 123, 'd06b970f258e57547ef1104fba3499eb4ab43ff6', '767e1635f55ff5e833410523decec438', '0123456789012345678901234567890123456789012345678901234567890123', 63);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (65, '2007-08-09 21:25:37.832976', 958, 'df4adf483eb24fec455e8411ca3dceb0bee51b44', 'b85b447f88c326c4124f0554e175097f', '0123456789012345678901234567890123456789012345678901234567890123', 65);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (66, '2007-08-09 21:25:37.832976', 179, '3e00fea68e91f6e03de6333b4c8e60c2ce441926', 'f27fb7494c5afbb0fb10b78d16f7da37', '0123456789012345678901234567890123456789012345678901234567890123', 66);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (67, '2007-08-09 21:25:37.832976', 610, '01bedc249af59cb80abb40b4898eced10f5d5e20', '7d6fa416334c6da3b954bf9ebff6e9ae', '0123456789012345678901234567890123456789012345678901234567890123', 67);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (68, '2007-08-09 21:25:37.832976', 567, 'b5aeb55faeb86a1d8c1a93dd58131b387a604c5a', '95f2b067e046d73f4e93eca44c034b97', '0123456789012345678901234567890123456789012345678901234567890123', 68);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (69, '2007-08-09 21:54:18.456616', 749, '0526ef40da99af5c1c97c91f9aca77e7ae564838', '8afa3dbc21b2dcdad7f31ab28c041ad9', '0123456789012345678901234567890123456789012345678901234567890123', 69);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (70, '2007-08-09 21:54:18.456616', 652, '0ce85c0cf331d05f76aa4977c43e87e9ffbd0480', '05a37db4ba50ba5f28650ee74b450c2c', '0123456789012345678901234567890123456789012345678901234567890123', 70);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (71, '2007-09-10 19:14:26.037382', 22897, 'd7ebed9e00fc134ebc79eaf7deebb30a4f5f6859', '0113f983ff8beba46ad64c4ae8899091', '0123456789012345678901234567890123456789012345678901234567890123', 71);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (72, '2007-09-10 19:15:01.67038', 221, '0ddef36534d59da64790eeffa55cc0221a01736d', 'df6ce34951747929ca9c6a4e2cb78f94', '0123456789012345678901234567890123456789012345678901234567890123', 72);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (73, '2007-09-10 19:15:19.947543', 217, 'ea265925f6214628dc46e731ca1e131f1e632127', '9d19d15feffc620c0d16523e0ce00a54', '0123456789012345678901234567890123456789012345678901234567890123', 73);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (74, '2007-09-10 19:16:01.017943', 22899, '234acbb3dc11b2af9bc46b6e33f0e453c3b1289d', '6d2d916ea729bc875ca0bd739f6be476', '0123456789012345678901234567890123456789012345678901234567890123', 74);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (75, '2007-12-18 16:31:34.790641', 4296, 'e8b25389964bc3bd471c20a1508d00852ee7de40', 'e6b759498b7cde49e9d34e7b8c8b4542', '0123456789012345678901234567890123456789012345678901234567890123', 75);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (76, '2007-12-18 16:31:34.790641', 2103, 'c154e1c1c2407d9b80c96b63c48d61a94248bf95', 'd86630cafdf624a3aa32aba0c41078c5', '0123456789012345678901234567890123456789012345678901234567890123', 76);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (77, '2007-12-18 16:31:34.790641', 2787, '2d94c4a6a014895f93b581fb0134efe73ae4e2c8', '315ef57e5f6ad295e98db65607c5c18a', '0123456789012345678901234567890123456789012345678901234567890123', 77);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (78, '2007-12-18 16:31:34.790641', 3534, '2bd22db53f2b9e47df50ed731128ff1fc54a5775', 'e0d510b49f803a0a4c2b2712d0a80522', '0123456789012345678901234567890123456789012345678901234567890123', 78);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (79, '2007-12-18 16:31:34.790641', 3327, 'a57356e4cbf97bbb47df202449a95d909d50614a', '8c5ffb558a0d0f520887f3d4cbd619c5', '0123456789012345678901234567890123456789012345678901234567890123', 79);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (80, '2007-12-18 16:31:34.790641', 189, '9800f54c65017e1bafe2d09a13af6176ba0ab244', 'a94677aabcd34b0901f1f75a35f7dff3', '0123456789012345678901234567890123456789012345678901234567890123', 80);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (81, '2007-12-18 16:31:34.790641', 2926, 'b53bb11bc40c42b0f9ecd981561fe9d6f265b275', '496cf1cbb97c17a67998478402520ab5', '0123456789012345678901234567890123456789012345678901234567890123', 81);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (82, '2008-03-17 15:36:19.035615', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123', 82);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (83, '2008-03-17 15:36:38.022812', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123', 83);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (84, '2008-03-17 15:36:48.877842', 3, '55ca6286e3e4f4fba5d0448333fa99fc5a404a73', '764efa883dda1e11db47671c4a3bbd9e', '0123456789012345678901234567890123456789012345678901234567890123', 84);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (85, '2008-03-17 15:37:10.252357', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123', 85);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (86, '2008-03-17 15:37:22.489973', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123', 86);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (87, '2008-03-17 15:37:36.701686', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123', 87);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (88, '2008-03-17 15:37:48.465157', 3, '55ca6286e3e4f4fba5d0448333fa99fc5a404a73', '764efa883dda1e11db47671c4a3bbd9e', '0123456789012345678901234567890123456789012345678901234567890123', 88);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (89, '2008-03-17 15:38:16.866444', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123', 89);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (90, '2008-05-08 10:10:16.866444', 18, '0c805a60b31058a1018680f99447033dcb9d4caa', '8a8a67b8dbc5f203ae8712092c68c7aa', '0123456789012345678901234567890123456789012345678901234567890123', 90);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (91, '2008-07-07 22:30:01.123456', 10, '0c805a60b31058a1018680f99447033dcb9d4c01', '8a8a67b8dbc5f203ae8712092c68c701', '0123456789012345678901234567890123456789012345678901234567890123', 91);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256, _id) VALUES (92, '2008-09-30 08:19:00.222131', 10, 'f10e2821bbbea527ea02200352313bc059445190', '7815696ecbf1c96e6894b779456d330e', '0123456789012345678901234567890123456789012345678901234567890123', 92);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-04-07 16:46:05.265391', 178859, '378b3498ead213d35a82033a6e9196014a5ef25c', '01234567890123456789012345678900', '0123456789012345678901234567890123456789012345678901234567890123', 1);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-04-07 16:46:05.266763', 9922560, 'a57faa6287aee2c58e115673a119c6083d31d1b9', '01234567890123456789012345678902', '0123456789012345678901234567890123456789012345678901234567890123', 2);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-04-07 16:46:05.26727', 309386, 'b218ca7b52fa813550e3f14cdcf3ba68606e4446', '01234567890123456789012345678903', '0123456789012345678901234567890123456789012345678901234567890123', 3);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-04-07 16:46:05.267803', 162927750, 'cfbd3ee1f510c66d49be465b900a3334e8488184', '01234567890123456789012345678904', '0123456789012345678901234567890123456789012345678901234567890123', 4);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 10826, '502828e7591277535abe9015ffbc6918dbba8ef4', '01234567890123456789012345678907', '0123456789012345678901234567890123456789012345678901234567890123', 7);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 10826, '502828e7591277535abe9015ffbc6918dbba8ef4', '01234567890123456789012345678907', '0123456789012345678901234567890123456789012345678901234567890123', 8);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 12652, '07b01d1e6fe9a729f911e72dfe674a5e0abdc4ee', '01234567890123456789012345678911', '0123456789012345678901234567890123456789012345678901234567890123', 17);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 12695, '8812d04c170ca90bb1423e188ce9706869aa03d7', '0123456789012345678901234567890b', '0123456789012345678901234567890123456789012345678901234567890123', 12);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 13110, 'bc7bebca1e3c5c166838b19f0eeb7f171e51805d', '01234567890123456789012345678909', '0123456789012345678901234567890123456789012345678901234567890123', 10);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 13133, 'db1b50cbde7142d344bd8ef9b2e1fe3b3116f77c', '0123456789012345678901234567890c', '0123456789012345678901234567890123456789012345678901234567890123', 13);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 13240, '801dc911c2bd67e17eff087516fdc63a2ac322ce', '01234567890123456789012345678912', '0123456789012345678901234567890123456789012345678901234567890123', 18);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 13269, 'fc8cab1cb1e5fb1efa3c3c475b8f7c8dc5038d50', '0123456789012345678901234567890f', '0123456789012345678901234567890123456789012345678901234567890123', 15);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 13499, '78a26efee75a54f113063b78783b2d4612fee409', '0123456789012345678901234567890a', '0123456789012345678901234567890123456789012345678901234567890123', 11);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 13641, 'e19cc1446e3004f10475c37b2cd363f75b8ae89a', '0123456789012345678901234567890d', '0123456789012345678901234567890123456789012345678901234567890123', 14);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 13983, 'e17ee3031bd29dcd1e5905c0fd17945600a91ccf', '01234567890123456789012345678910', '0123456789012345678901234567890123456789012345678901234567890123', 16);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 2655, 'ca3b107af84c05eaf98ba073376153986566ec28', '01234567890123456789012345678908', '0123456789012345678901234567890123456789012345678901234567890123', 9);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 2961, '4468039e1d2cbdfc78d2e53477e5fe0537bae302', '0123456789012345678901234567891b', '0123456789012345678901234567890123456789012345678901234567890123', 27);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 3305, 'b45b170da29f9b22650315657505124766c93720', '0123456789012345678901234567891e', '0123456789012345678901234567890123456789012345678901234567890123', 30);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 3553, '20815563ee33368d51e3213354f97c05b4685968', '01234567890123456789012345678916', '0123456789012345678901234567890123456789012345678901234567890123', 22);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 3558, 'd6c2ddacdab7618ce2a555c20a4a730fcdb42600', '0123456789012345678901234567891c', '0123456789012345678901234567890123456789012345678901234567890123', 28);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 3561, '9eb09455e6a568605c1bbab4cdf1936eee92222d', '0123456789012345678901234567891d', '0123456789012345678901234567890123456789012345678901234567890123', 29);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 3635, '4ab2ca308dafe152789640942488e23a33e4f46c', '01234567890123456789012345678915', '0123456789012345678901234567890123456789012345678901234567890123', 21);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 3666, 'cca8fb78e05a34481e07683cea8c3a47f01c609e', '01234567890123456789012345678918', '0123456789012345678901234567890123456789012345678901234567890123', 24);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 3778, '965968d3e6668f39ebc64bc11a3f1a5cd07c213b', '01234567890123456789012345678917', '0123456789012345678901234567890123456789012345678901234567890123', 23);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 3793, '28a7accfb491a2b4895b49b810ca7cda0badc787', '01234567890123456789012345678919', '0123456789012345678901234567890123456789012345678901234567890123', 25);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 3987, '9668ba9f0a59f9e6e6bc73fc5dc9f116b202bceb', '0123456789012345678901234567891f', '0123456789012345678901234567890123456789012345678901234567890123', 31);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 4093, 'fc67a1770f78c45c396b4724195aeb10683aa2fd', '01234567890123456789012345678914', '0123456789012345678901234567890123456789012345678901234567890123', 20);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 4165, 'fca78a2292e4034b8dfbb2de6f69e17ebeecaaa1', '01234567890123456789012345678913', '0123456789012345678901234567890123456789012345678901234567890123', 19);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 4381, '9b1f78faa39fb09a9fd955d744002c2d8f32d88d', '01234567890123456789012345678905', '0123456789012345678901234567890123456789012345678901234567890123', 5);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 4773, '03efb176f04f3897de7d5e6484864b0559fd6cd6', '0123456789012345678901234567891a', '0123456789012345678901234567890123456789012345678901234567890123', 26);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 4908, '874a6ef9cd1aaef17653c6c12f4b83ef9487c1c3', '01234567890123456789012345678920', '0123456789012345678901234567890123456789012345678901234567890123', 32);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 4908, '874a6ef9cd1aaef17653c6c12f4b83ef9487c1c3', '01234567890123456789012345678920', '0123456789012345678901234567890123456789012345678901234567890123', 33);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-05-18 08:03:28.021862', 7910, 'afdf21d698587a6601e2ffed0f44292b7ad5dd07', '01234567890123456789012345678906', '0123456789012345678901234567890123456789012345678901234567890123', 6);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-08-01 09:31:29.606407', 2, '71853c6197a6a7f222db0f1978c7cb232b87c5ee', '01234567890123456789012345678921', '0123456789012345678901234567890123456789012345678901234567890123', 35);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-08-10 09:31:29.606407', 2, '71853c6197a6a7f222db0f1978c7cb232b87c5ee', '01234567890123456789012345678921', '0123456789012345678901234567890123456789012345678901234567890123', 34);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-10-30 18:00:27.899028', 3, '0beec7b5ea3f0fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678922', '0123456789012345678901234567890123456789012345678901234567890123', 36);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-10-30 18:00:27.899028', 3, '1e04c7b5ea3f0fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678923', '0123456789012345678901234567890123456789012345678901234567890123', 37);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-10-30 18:00:27.899028', 3, '4e3961baf4f56fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678928', '0123456789012345678901234567890123456789012345678901234567890123', 43);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-10-30 18:00:27.899028', 3, '5a04c7b5ea3f0fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678926', '0123456789012345678901234567890123456789012345678901234567890123', 40);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-10-30 18:00:27.899028', 3, 'a10856bfea3f0bdb09550dd41f3c5bc275da8a33', '01234567890123456789012345678925', '0123456789012345678901234567890123456789012345678901234567890123', 39);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-10-30 18:00:27.899028', 3, 'a45ed906e4f56fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678927', '0123456789012345678901234567890123456789012345678901234567890123', 42);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-10-30 18:00:27.899028', 3, 'ae04c7b5ea3f0bdb095d0dd47f3c5bc275da8a33', '01234567890123456789012345678924', '0123456789012345678901234567890123456789012345678901234567890123', 38);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2005-10-30 18:00:27.899028', 3, 'b45ed906e4f5afdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678929', '0123456789012345678901234567890123456789012345678901234567890123', 44);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2006-05-24 09:31:29.606407', 2, '1622db354faa9fa653804d018f3b9d5291e37d6b', 'e4a7193a8f72fa2755e2162512069093', '0123456789012345678901234567890123456789012345678901234567890123', 52);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2006-05-24 09:31:29.606407', 2, 'ab43246197a6a7f222db0f1978c7cb232b87c5ee', '0123456789012345678901234567892b', '0123456789012345678901234567890123456789012345678901234567890123', 46);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2006-05-24 09:31:29.606407', 2, 'cabf42e197a6a7f222db0f1978c7cb232b87c5ee', '0123456789012345678901234567892c', '0123456789012345678901234567890123456789012345678901234567890123', 47);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2006-05-24 09:31:29.606407', 2, 'fabb42e197a6a7f222db0f1978c7cb232b87c5ee', '0123456789012345678901234567892d', '0123456789012345678901234567890123456789012345678901234567890123', 59);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2006-07-14 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5437', '0123456789012345678901234567890123456789012345678901234567890123', 51);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2006-08-01 09:31:29.606407', 2, '43853c6197a6a7f222db0f1978c7cb232b87c5ee', '0123456789012345678901234567892a', '0123456789012345678901234567890123456789012345678901234567890123', 45);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2006-12-01 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5437', '0123456789012345678901234567890123456789012345678901234567890123', 53);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2006-12-01 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5438', '0123456789012345678901234567890123456789012345678901234567890123', 54);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2006-12-01 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5439', '0123456789012345678901234567890123456789012345678901234567890123', 55);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2006-12-01 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5440', '0123456789012345678901234567890123456789012345678901234567890123', 56);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2006-12-13 21:17:56.241901', 1599, 'acdf6b9b99c39b1585f829ec7d68598a8e10816d', '5c6fa250b612e7e4d17261268a4d8400', '0123456789012345678901234567890123456789012345678901234567890123', 57);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2006-12-13 21:18:28.796588', 1599, 'acdf6b9b99c39b1585f829ec7d68598a8e10816d', '5c6fa250b612e7e4d17261268a4d8401', '0123456789012345678901234567890123456789012345678901234567890123', 58);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-01-03 17:26:27.288968', 11793, 'df3a6670671781d5e08d7795ca1ada776815d87f', 'e8120781cd606202fd259a4f0d4585bb', '0123456789012345678901234567890123456789012345678901234567890123', 60);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-02-15 14:26:27.288968', 100, 'df3a6670671781d5e08d7795ca1ada776815d87f', 'e8120781cd606202fd259a4f0d4585b1', '0123456789012345678901234567890123456789012345678901234567890123', 61);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-05-14 23:21:11.121446', 123, 'd06b970f258e57547ef1104fba3499eb4ab43ff6', '767e1635f55ff5e833410523decec438', '0123456789012345678901234567890123456789012345678901234567890123', 62);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-05-14 23:21:11.121446', 123, 'd06b970f258e57547ef1104fba3499eb4ab43ff6', '767e1635f55ff5e833410523decec438', '0123456789012345678901234567890123456789012345678901234567890123', 63);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-08-09 21:25:37.832976', 179, '3e00fea68e91f6e03de6333b4c8e60c2ce441926', 'f27fb7494c5afbb0fb10b78d16f7da37', '0123456789012345678901234567890123456789012345678901234567890123', 66);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-08-09 21:25:37.832976', 567, 'b5aeb55faeb86a1d8c1a93dd58131b387a604c5a', '95f2b067e046d73f4e93eca44c034b97', '0123456789012345678901234567890123456789012345678901234567890123', 68);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-08-09 21:25:37.832976', 610, '01bedc249af59cb80abb40b4898eced10f5d5e20', '7d6fa416334c6da3b954bf9ebff6e9ae', '0123456789012345678901234567890123456789012345678901234567890123', 67);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-08-09 21:25:37.832976', 958, 'df4adf483eb24fec455e8411ca3dceb0bee51b44', 'b85b447f88c326c4124f0554e175097f', '0123456789012345678901234567890123456789012345678901234567890123', 65);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-08-09 21:54:18.456616', 652, '0ce85c0cf331d05f76aa4977c43e87e9ffbd0480', '05a37db4ba50ba5f28650ee74b450c2c', '0123456789012345678901234567890123456789012345678901234567890123', 70);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-08-09 21:54:18.456616', 749, '0526ef40da99af5c1c97c91f9aca77e7ae564838', '8afa3dbc21b2dcdad7f31ab28c041ad9', '0123456789012345678901234567890123456789012345678901234567890123', 69);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-09-10 19:14:26.037382', 22897, 'd7ebed9e00fc134ebc79eaf7deebb30a4f5f6859', '0113f983ff8beba46ad64c4ae8899091', '0123456789012345678901234567890123456789012345678901234567890123', 71);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-09-10 19:15:01.67038', 221, '0ddef36534d59da64790eeffa55cc0221a01736d', 'df6ce34951747929ca9c6a4e2cb78f94', '0123456789012345678901234567890123456789012345678901234567890123', 72);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-09-10 19:15:19.947543', 217, 'ea265925f6214628dc46e731ca1e131f1e632127', '9d19d15feffc620c0d16523e0ce00a54', '0123456789012345678901234567890123456789012345678901234567890123', 73);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-09-10 19:16:01.017943', 22899, '234acbb3dc11b2af9bc46b6e33f0e453c3b1289d', '6d2d916ea729bc875ca0bd739f6be476', '0123456789012345678901234567890123456789012345678901234567890123', 74);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-12-18 16:31:34.790641', 189, '9800f54c65017e1bafe2d09a13af6176ba0ab244', 'a94677aabcd34b0901f1f75a35f7dff3', '0123456789012345678901234567890123456789012345678901234567890123', 80);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-12-18 16:31:34.790641', 2103, 'c154e1c1c2407d9b80c96b63c48d61a94248bf95', 'd86630cafdf624a3aa32aba0c41078c5', '0123456789012345678901234567890123456789012345678901234567890123', 76);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-12-18 16:31:34.790641', 2787, '2d94c4a6a014895f93b581fb0134efe73ae4e2c8', '315ef57e5f6ad295e98db65607c5c18a', '0123456789012345678901234567890123456789012345678901234567890123', 77);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-12-18 16:31:34.790641', 2926, 'b53bb11bc40c42b0f9ecd981561fe9d6f265b275', '496cf1cbb97c17a67998478402520ab5', '0123456789012345678901234567890123456789012345678901234567890123', 81);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-12-18 16:31:34.790641', 3327, 'a57356e4cbf97bbb47df202449a95d909d50614a', '8c5ffb558a0d0f520887f3d4cbd619c5', '0123456789012345678901234567890123456789012345678901234567890123', 79);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-12-18 16:31:34.790641', 3534, '2bd22db53f2b9e47df50ed731128ff1fc54a5775', 'e0d510b49f803a0a4c2b2712d0a80522', '0123456789012345678901234567890123456789012345678901234567890123', 78);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2007-12-18 16:31:34.790641', 4296, 'e8b25389964bc3bd471c20a1508d00852ee7de40', 'e6b759498b7cde49e9d34e7b8c8b4542', '0123456789012345678901234567890123456789012345678901234567890123', 75);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2008-03-17 15:36:19.035615', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123', 82);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2008-03-17 15:36:38.022812', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123', 83);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2008-03-17 15:36:48.877842', 3, '55ca6286e3e4f4fba5d0448333fa99fc5a404a73', '764efa883dda1e11db47671c4a3bbd9e', '0123456789012345678901234567890123456789012345678901234567890123', 84);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2008-03-17 15:37:10.252357', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123', 85);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2008-03-17 15:37:22.489973', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123', 86);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2008-03-17 15:37:36.701686', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123', 87);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2008-03-17 15:37:48.465157', 3, '55ca6286e3e4f4fba5d0448333fa99fc5a404a73', '764efa883dda1e11db47671c4a3bbd9e', '0123456789012345678901234567890123456789012345678901234567890123', 88);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2008-03-17 15:38:16.866444', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123', 89);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2008-05-08 10:10:16.866444', 18, '0c805a60b31058a1018680f99447033dcb9d4caa', '8a8a67b8dbc5f203ae8712092c68c7aa', '0123456789012345678901234567890123456789012345678901234567890123', 90);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2008-07-07 22:30:01.123456', 10, '0c805a60b31058a1018680f99447033dcb9d4c01', '8a8a67b8dbc5f203ae8712092c68c701', '0123456789012345678901234567890123456789012345678901234567890123', 91);
+INSERT INTO libraryfilecontent (datecreated, filesize, sha1, md5, sha256, id) VALUES ('2008-09-30 08:19:00.222131', 10, 'f10e2821bbbea527ea02200352313bc059445190', '7815696ecbf1c96e6894b779456d330e', '0123456789012345678901234567890123456789012345678901234567890123', 92);
 
 
 ALTER TABLE libraryfilecontent ENABLE TRIGGER ALL;
@@ -753,93 +753,93 @@
 
 ALTER TABLE libraryfilealias DISABLE TRIGGER ALL;
 
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
-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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
+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);
 
 
 ALTER TABLE libraryfilealias ENABLE TRIGGER ALL;
 
=== added file 'database/schema/patch-2209-58-3.sql'
--- database/schema/patch-2209-58-3.sql	1970-01-01 00:00:00 +0000
+++ database/schema/patch-2209-58-3.sql	2014-08-08 07:05:30 +0000
@@ -0,0 +1,10 @@
+-- Copyright 2014 Canonical Ltd.  This software is licensed under the
+-- GNU Affero General Public License version 3 (see the file LICENSE).
+
+SET client_min_messages=ERROR;
+
+-- STEP 6, LIVE.
+-- LibraryFileAlias indexes, to be done concurrently.
+CREATE INDEX libraryfilealias__content__idx ON LibraryFileAlias(_content);
+
+INSERT INTO LaunchpadDatabaseRevision VALUES (2209, 58, 3);
 
=== added file 'database/schema/patch-2209-58-4.sql'
--- database/schema/patch-2209-58-4.sql	1970-01-01 00:00:00 +0000
+++ database/schema/patch-2209-58-4.sql	2014-08-08 07:05:30 +0000
@@ -0,0 +1,46 @@
+-- Copyright 2014 Canonical Ltd.  This software is licensed under the
+-- GNU Affero General Public License version 3 (see the file LICENSE).
+
+SET client_min_messages=ERROR;
+
+-- STEP 7
+-- Constraints, swap into place, and the rest.
+
+-- Explicitly grab the lock since we will be bypassing DDL and going
+-- straight to the catalog.
+LOCK LibraryFileContent, LibraryFileAlias;
+
+-- Set LFC._id and LFC.sha256 to NOT NULL, the sneaky unsupported way.
+UPDATE pg_attribute SET attnotnull=TRUE
+FROM pg_class, pg_namespace
+WHERE
+    pg_class.oid = pg_attribute.attrelid
+    AND pg_namespace.oid = pg_class.relnamespace
+    AND pg_attribute.attname in ('_id', 'sha256')
+    AND pg_namespace.nspname = 'public'
+    AND pg_class.relname = 'libraryfilecontent';
+
+-- Kill the triggers.
+DROP TRIGGER lfa_sync_content_t ON LibraryFileAlias;
+DROP TRIGGER lfc_sync_id_t ON LibraryFileContent;
+DROP FUNCTION lfa_sync_content_t();
+DROP FUNCTION lfc_sync_id_t();
+
+-- Fix the SEQUENCE owner, so it doesn't get removed when the old id column
+-- is dropped.
+ALTER SEQUENCE libraryfilecontent_id_seq OWNED BY LibraryFileContent._id;
+
+-- Swap in the wide columns.
+ALTER TABLE LibraryFileAlias DROP COLUMN content;
+ALTER TABLE LibraryFileAlias RENAME _content TO content;
+ALTER TABLE LibraryFileContent DROP COLUMN id;
+ALTER TABLE LibraryFileContent RENAME _id TO id;
+
+-- Fixup the LFC primary key.
+ALTER INDEX libraryfilecontent_id_key RENAME TO libraryfilecontent_pkey;
+ALTER TABLE LibraryFileContent
+    ALTER COLUMN id SET DEFAULT nextval('libraryfilecontent_id_seq'),
+    ADD CONSTRAINT libraryfilecontent_pkey
+        PRIMARY KEY USING INDEX libraryfilecontent_pkey; -- Maybe slow.
+
+INSERT INTO LaunchpadDatabaseRevision VALUES (2209, 58, 4);