launchpad-reviewers team mailing list archive

Thread
Date

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

To: mp+230047@xxxxxxxxxxxxxxxxxx
From: Stuart Bishop <stuart.bishop@xxxxxxxxxxxxx>
Date: Fri, 08 Aug 2014 07:04:22 -0000
In-reply-to: <20140808065428.12537.71830.launchpad@ackee.canonical.com>
Reply-to: mp+230047@xxxxxxxxxxxxxxxxxx
Sender: bounces@xxxxxxxxxxxxx

Stuart Bishop has proposed merging lp:~stub/launchpad/db into lp:launchpad.

Commit message:
Final two database patches converting LibraryFileContent.id to bigint.

Requested reviews:
  Launchpad code reviewers (launchpad-reviewers)
Related bugs:
  Bug #1345850 in Launchpad itself: "LibraryFileContent.id needs to be 64-bit"
  https://bugs.launchpad.net/launchpad/+bug/1345850

For more details, see:
https://code.launchpad.net/~stub/launchpad/db/+merge/230047

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
-- 
https://code.launchpad.net/~stub/launchpad/db/+merge/230047
Your team Launchpad code reviewers is requested to review the proposed merge of lp:~stub/launchpad/db into lp:launchpad.

=== 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:03:23 +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:03:23 +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:03:23 +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:03:23 +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);

References

[Merge] lp:~stub/launchpad/db into lp:launchpad
From: Stuart Bishop, 2014-08-08