launchpad-reviewers team mailing list archive

Thread
Date

[Merge] lp:~wgrant/launchpad/sha256-model into lp:launchpad

To: mp+169345@xxxxxxxxxxxxxxxxxx
From: William Grant <me@xxxxxxxxxxxxxxxxxx>
Date: Fri, 14 Jun 2013 06:19:11 -0000
Reply-to: mp+169345@xxxxxxxxxxxxxxxxxx
Sender: bounces@xxxxxxxxxxxxx

William Grant has proposed merging lp:~wgrant/launchpad/sha256-model into lp:launchpad.

Commit message:
Add SHA-256 support to the librarian.

Requested reviews:
  Launchpad code reviewers (launchpad-reviewers)

For more details, see:
https://code.launchpad.net/~wgrant/launchpad/sha256-model/+merge/169345

SHA256 support for the librarian. The column's already there.
-- 
https://code.launchpad.net/~wgrant/launchpad/sha256-model/+merge/169345
Your team Launchpad code reviewers is requested to review the proposed merge of lp:~wgrant/launchpad/sha256-model into lp:launchpad.

=== modified file 'database/sampledata/current-dev.sql'
--- database/sampledata/current-dev.sql	2013-05-15 05:04:53 +0000
+++ database/sampledata/current-dev.sql	2013-06-14 06:17:30 +0000
@@ -1402,93 +1402,93 @@
 
 ALTER TABLE libraryfilecontent DISABLE TRIGGER ALL;
 
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (1, '2005-04-07 16:46:05.265391', 178859, '378b3498ead213d35a82033a6e9196014a5ef25c', '01234567890123456789012345678900', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (2, '2005-04-07 16:46:05.266763', 9922560, 'a57faa6287aee2c58e115673a119c6083d31d1b9', '01234567890123456789012345678902', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (3, '2005-04-07 16:46:05.26727', 309386, 'b218ca7b52fa813550e3f14cdcf3ba68606e4446', '01234567890123456789012345678903', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (4, '2005-04-07 16:46:05.267803', 162927750, 'cfbd3ee1f510c66d49be465b900a3334e8488184', '01234567890123456789012345678904', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (5, '2005-05-18 08:03:28.021862', 4381, '9b1f78faa39fb09a9fd955d744002c2d8f32d88d', '01234567890123456789012345678905', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (6, '2005-05-18 08:03:28.021862', 7910, 'afdf21d698587a6601e2ffed0f44292b7ad5dd07', '01234567890123456789012345678906', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (7, '2005-05-18 08:03:28.021862', 10826, '502828e7591277535abe9015ffbc6918dbba8ef4', '01234567890123456789012345678907', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (8, '2005-05-18 08:03:28.021862', 10826, '502828e7591277535abe9015ffbc6918dbba8ef4', '01234567890123456789012345678907', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (9, '2005-05-18 08:03:28.021862', 2655, 'ca3b107af84c05eaf98ba073376153986566ec28', '01234567890123456789012345678908', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (10, '2005-05-18 08:03:28.021862', 13110, 'bc7bebca1e3c5c166838b19f0eeb7f171e51805d', '01234567890123456789012345678909', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (11, '2005-05-18 08:03:28.021862', 13499, '78a26efee75a54f113063b78783b2d4612fee409', '0123456789012345678901234567890a', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (12, '2005-05-18 08:03:28.021862', 12695, '8812d04c170ca90bb1423e188ce9706869aa03d7', '0123456789012345678901234567890b', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (13, '2005-05-18 08:03:28.021862', 13133, 'db1b50cbde7142d344bd8ef9b2e1fe3b3116f77c', '0123456789012345678901234567890c', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (14, '2005-05-18 08:03:28.021862', 13641, 'e19cc1446e3004f10475c37b2cd363f75b8ae89a', '0123456789012345678901234567890d', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (15, '2005-05-18 08:03:28.021862', 13269, 'fc8cab1cb1e5fb1efa3c3c475b8f7c8dc5038d50', '0123456789012345678901234567890f', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (16, '2005-05-18 08:03:28.021862', 13983, 'e17ee3031bd29dcd1e5905c0fd17945600a91ccf', '01234567890123456789012345678910', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (17, '2005-05-18 08:03:28.021862', 12652, '07b01d1e6fe9a729f911e72dfe674a5e0abdc4ee', '01234567890123456789012345678911', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (18, '2005-05-18 08:03:28.021862', 13240, '801dc911c2bd67e17eff087516fdc63a2ac322ce', '01234567890123456789012345678912', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (19, '2005-05-18 08:03:28.021862', 4165, 'fca78a2292e4034b8dfbb2de6f69e17ebeecaaa1', '01234567890123456789012345678913', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (20, '2005-05-18 08:03:28.021862', 4093, 'fc67a1770f78c45c396b4724195aeb10683aa2fd', '01234567890123456789012345678914', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (21, '2005-05-18 08:03:28.021862', 3635, '4ab2ca308dafe152789640942488e23a33e4f46c', '01234567890123456789012345678915', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (22, '2005-05-18 08:03:28.021862', 3553, '20815563ee33368d51e3213354f97c05b4685968', '01234567890123456789012345678916', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (23, '2005-05-18 08:03:28.021862', 3778, '965968d3e6668f39ebc64bc11a3f1a5cd07c213b', '01234567890123456789012345678917', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (24, '2005-05-18 08:03:28.021862', 3666, 'cca8fb78e05a34481e07683cea8c3a47f01c609e', '01234567890123456789012345678918', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (25, '2005-05-18 08:03:28.021862', 3793, '28a7accfb491a2b4895b49b810ca7cda0badc787', '01234567890123456789012345678919', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (26, '2005-05-18 08:03:28.021862', 4773, '03efb176f04f3897de7d5e6484864b0559fd6cd6', '0123456789012345678901234567891a', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (27, '2005-05-18 08:03:28.021862', 2961, '4468039e1d2cbdfc78d2e53477e5fe0537bae302', '0123456789012345678901234567891b', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (28, '2005-05-18 08:03:28.021862', 3558, 'd6c2ddacdab7618ce2a555c20a4a730fcdb42600', '0123456789012345678901234567891c', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (29, '2005-05-18 08:03:28.021862', 3561, '9eb09455e6a568605c1bbab4cdf1936eee92222d', '0123456789012345678901234567891d', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (30, '2005-05-18 08:03:28.021862', 3305, 'b45b170da29f9b22650315657505124766c93720', '0123456789012345678901234567891e', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (31, '2005-05-18 08:03:28.021862', 3987, '9668ba9f0a59f9e6e6bc73fc5dc9f116b202bceb', '0123456789012345678901234567891f', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (32, '2005-05-18 08:03:28.021862', 4908, '874a6ef9cd1aaef17653c6c12f4b83ef9487c1c3', '01234567890123456789012345678920', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (33, '2005-05-18 08:03:28.021862', 4908, '874a6ef9cd1aaef17653c6c12f4b83ef9487c1c3', '01234567890123456789012345678920', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (34, '2005-08-10 09:31:29.606407', 2, '71853c6197a6a7f222db0f1978c7cb232b87c5ee', '01234567890123456789012345678921', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (35, '2005-08-01 09:31:29.606407', 2, '71853c6197a6a7f222db0f1978c7cb232b87c5ee', '01234567890123456789012345678921', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (36, '2005-10-30 18:00:27.899028', 3, '0beec7b5ea3f0fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678922', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (37, '2005-10-30 18:00:27.899028', 3, '1e04c7b5ea3f0fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678923', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (38, '2005-10-30 18:00:27.899028', 3, 'ae04c7b5ea3f0bdb095d0dd47f3c5bc275da8a33', '01234567890123456789012345678924', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (39, '2005-10-30 18:00:27.899028', 3, 'a10856bfea3f0bdb09550dd41f3c5bc275da8a33', '01234567890123456789012345678925', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (40, '2005-10-30 18:00:27.899028', 3, '5a04c7b5ea3f0fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678926', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (42, '2005-10-30 18:00:27.899028', 3, 'a45ed906e4f56fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678927', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (43, '2005-10-30 18:00:27.899028', 3, '4e3961baf4f56fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678928', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (44, '2005-10-30 18:00:27.899028', 3, 'b45ed906e4f5afdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678929', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (45, '2006-08-01 09:31:29.606407', 2, '43853c6197a6a7f222db0f1978c7cb232b87c5ee', '0123456789012345678901234567892a', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (46, '2006-05-24 09:31:29.606407', 2, 'ab43246197a6a7f222db0f1978c7cb232b87c5ee', '0123456789012345678901234567892b', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (47, '2006-05-24 09:31:29.606407', 2, 'cabf42e197a6a7f222db0f1978c7cb232b87c5ee', '0123456789012345678901234567892c', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (51, '2006-07-14 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5437', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (52, '2006-05-24 09:31:29.606407', 2, '1622db354faa9fa653804d018f3b9d5291e37d6b', 'e4a7193a8f72fa2755e2162512069093', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (53, '2006-12-01 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5437', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (54, '2006-12-01 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5438', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (55, '2006-12-01 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5439', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (56, '2006-12-01 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5440', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (57, '2006-12-13 21:17:56.241901', 1599, 'acdf6b9b99c39b1585f829ec7d68598a8e10816d', '5c6fa250b612e7e4d17261268a4d8400', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (58, '2006-12-13 21:18:28.796588', 1599, 'acdf6b9b99c39b1585f829ec7d68598a8e10816d', '5c6fa250b612e7e4d17261268a4d8401', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (59, '2006-05-24 09:31:29.606407', 2, 'fabb42e197a6a7f222db0f1978c7cb232b87c5ee', '0123456789012345678901234567892d', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (60, '2007-01-03 17:26:27.288968', 11793, 'df3a6670671781d5e08d7795ca1ada776815d87f', 'e8120781cd606202fd259a4f0d4585bb', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (61, '2007-02-15 14:26:27.288968', 100, 'df3a6670671781d5e08d7795ca1ada776815d87f', 'e8120781cd606202fd259a4f0d4585b1', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (62, '2007-05-14 23:21:11.121446', 123, 'd06b970f258e57547ef1104fba3499eb4ab43ff6', '767e1635f55ff5e833410523decec438', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (63, '2007-05-14 23:21:11.121446', 123, 'd06b970f258e57547ef1104fba3499eb4ab43ff6', '767e1635f55ff5e833410523decec438', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (65, '2007-08-09 21:25:37.832976', 958, 'df4adf483eb24fec455e8411ca3dceb0bee51b44', 'b85b447f88c326c4124f0554e175097f', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (66, '2007-08-09 21:25:37.832976', 179, '3e00fea68e91f6e03de6333b4c8e60c2ce441926', 'f27fb7494c5afbb0fb10b78d16f7da37', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (67, '2007-08-09 21:25:37.832976', 610, '01bedc249af59cb80abb40b4898eced10f5d5e20', '7d6fa416334c6da3b954bf9ebff6e9ae', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (68, '2007-08-09 21:25:37.832976', 567, 'b5aeb55faeb86a1d8c1a93dd58131b387a604c5a', '95f2b067e046d73f4e93eca44c034b97', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (69, '2007-08-09 21:54:18.456616', 749, '0526ef40da99af5c1c97c91f9aca77e7ae564838', '8afa3dbc21b2dcdad7f31ab28c041ad9', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (70, '2007-08-09 21:54:18.456616', 652, '0ce85c0cf331d05f76aa4977c43e87e9ffbd0480', '05a37db4ba50ba5f28650ee74b450c2c', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (71, '2007-09-10 19:14:26.037382', 22897, 'd7ebed9e00fc134ebc79eaf7deebb30a4f5f6859', '0113f983ff8beba46ad64c4ae8899091', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (72, '2007-09-10 19:15:01.67038', 221, '0ddef36534d59da64790eeffa55cc0221a01736d', 'df6ce34951747929ca9c6a4e2cb78f94', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (73, '2007-09-10 19:15:19.947543', 217, 'ea265925f6214628dc46e731ca1e131f1e632127', '9d19d15feffc620c0d16523e0ce00a54', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (74, '2007-09-10 19:16:01.017943', 22899, '234acbb3dc11b2af9bc46b6e33f0e453c3b1289d', '6d2d916ea729bc875ca0bd739f6be476', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (75, '2007-12-18 16:31:34.790641', 4296, 'e8b25389964bc3bd471c20a1508d00852ee7de40', 'e6b759498b7cde49e9d34e7b8c8b4542', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (76, '2007-12-18 16:31:34.790641', 2103, 'c154e1c1c2407d9b80c96b63c48d61a94248bf95', 'd86630cafdf624a3aa32aba0c41078c5', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (77, '2007-12-18 16:31:34.790641', 2787, '2d94c4a6a014895f93b581fb0134efe73ae4e2c8', '315ef57e5f6ad295e98db65607c5c18a', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (78, '2007-12-18 16:31:34.790641', 3534, '2bd22db53f2b9e47df50ed731128ff1fc54a5775', 'e0d510b49f803a0a4c2b2712d0a80522', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (79, '2007-12-18 16:31:34.790641', 3327, 'a57356e4cbf97bbb47df202449a95d909d50614a', '8c5ffb558a0d0f520887f3d4cbd619c5', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (80, '2007-12-18 16:31:34.790641', 189, '9800f54c65017e1bafe2d09a13af6176ba0ab244', 'a94677aabcd34b0901f1f75a35f7dff3', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (81, '2007-12-18 16:31:34.790641', 2926, 'b53bb11bc40c42b0f9ecd981561fe9d6f265b275', '496cf1cbb97c17a67998478402520ab5', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (82, '2008-03-17 15:36:19.035615', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (83, '2008-03-17 15:36:38.022812', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (84, '2008-03-17 15:36:48.877842', 3, '55ca6286e3e4f4fba5d0448333fa99fc5a404a73', '764efa883dda1e11db47671c4a3bbd9e', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (85, '2008-03-17 15:37:10.252357', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (86, '2008-03-17 15:37:22.489973', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (87, '2008-03-17 15:37:36.701686', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (88, '2008-03-17 15:37:48.465157', 3, '55ca6286e3e4f4fba5d0448333fa99fc5a404a73', '764efa883dda1e11db47671c4a3bbd9e', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (89, '2008-03-17 15:38:16.866444', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (90, '2008-05-08 10:10:16.866444', 18, '0c805a60b31058a1018680f99447033dcb9d4caa', '8a8a67b8dbc5f203ae8712092c68c7aa', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (91, '2008-07-07 22:30:01.123456', 10, '0c805a60b31058a1018680f99447033dcb9d4c01', '8a8a67b8dbc5f203ae8712092c68c701', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (92, '2008-09-30 08:19:00.222131', 10, 'f10e2821bbbea527ea02200352313bc059445190', '7815696ecbf1c96e6894b779456d330e', NULL);
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (1, '2005-04-07 16:46:05.265391', 178859, '378b3498ead213d35a82033a6e9196014a5ef25c', '01234567890123456789012345678900', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (2, '2005-04-07 16:46:05.266763', 9922560, 'a57faa6287aee2c58e115673a119c6083d31d1b9', '01234567890123456789012345678902', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (3, '2005-04-07 16:46:05.26727', 309386, 'b218ca7b52fa813550e3f14cdcf3ba68606e4446', '01234567890123456789012345678903', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (4, '2005-04-07 16:46:05.267803', 162927750, 'cfbd3ee1f510c66d49be465b900a3334e8488184', '01234567890123456789012345678904', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (5, '2005-05-18 08:03:28.021862', 4381, '9b1f78faa39fb09a9fd955d744002c2d8f32d88d', '01234567890123456789012345678905', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (6, '2005-05-18 08:03:28.021862', 7910, 'afdf21d698587a6601e2ffed0f44292b7ad5dd07', '01234567890123456789012345678906', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (7, '2005-05-18 08:03:28.021862', 10826, '502828e7591277535abe9015ffbc6918dbba8ef4', '01234567890123456789012345678907', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (8, '2005-05-18 08:03:28.021862', 10826, '502828e7591277535abe9015ffbc6918dbba8ef4', '01234567890123456789012345678907', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (9, '2005-05-18 08:03:28.021862', 2655, 'ca3b107af84c05eaf98ba073376153986566ec28', '01234567890123456789012345678908', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (10, '2005-05-18 08:03:28.021862', 13110, 'bc7bebca1e3c5c166838b19f0eeb7f171e51805d', '01234567890123456789012345678909', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (11, '2005-05-18 08:03:28.021862', 13499, '78a26efee75a54f113063b78783b2d4612fee409', '0123456789012345678901234567890a', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (12, '2005-05-18 08:03:28.021862', 12695, '8812d04c170ca90bb1423e188ce9706869aa03d7', '0123456789012345678901234567890b', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (13, '2005-05-18 08:03:28.021862', 13133, 'db1b50cbde7142d344bd8ef9b2e1fe3b3116f77c', '0123456789012345678901234567890c', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (14, '2005-05-18 08:03:28.021862', 13641, 'e19cc1446e3004f10475c37b2cd363f75b8ae89a', '0123456789012345678901234567890d', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (15, '2005-05-18 08:03:28.021862', 13269, 'fc8cab1cb1e5fb1efa3c3c475b8f7c8dc5038d50', '0123456789012345678901234567890f', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (16, '2005-05-18 08:03:28.021862', 13983, 'e17ee3031bd29dcd1e5905c0fd17945600a91ccf', '01234567890123456789012345678910', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (17, '2005-05-18 08:03:28.021862', 12652, '07b01d1e6fe9a729f911e72dfe674a5e0abdc4ee', '01234567890123456789012345678911', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (18, '2005-05-18 08:03:28.021862', 13240, '801dc911c2bd67e17eff087516fdc63a2ac322ce', '01234567890123456789012345678912', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (19, '2005-05-18 08:03:28.021862', 4165, 'fca78a2292e4034b8dfbb2de6f69e17ebeecaaa1', '01234567890123456789012345678913', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (20, '2005-05-18 08:03:28.021862', 4093, 'fc67a1770f78c45c396b4724195aeb10683aa2fd', '01234567890123456789012345678914', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (21, '2005-05-18 08:03:28.021862', 3635, '4ab2ca308dafe152789640942488e23a33e4f46c', '01234567890123456789012345678915', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (22, '2005-05-18 08:03:28.021862', 3553, '20815563ee33368d51e3213354f97c05b4685968', '01234567890123456789012345678916', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (23, '2005-05-18 08:03:28.021862', 3778, '965968d3e6668f39ebc64bc11a3f1a5cd07c213b', '01234567890123456789012345678917', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (24, '2005-05-18 08:03:28.021862', 3666, 'cca8fb78e05a34481e07683cea8c3a47f01c609e', '01234567890123456789012345678918', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (25, '2005-05-18 08:03:28.021862', 3793, '28a7accfb491a2b4895b49b810ca7cda0badc787', '01234567890123456789012345678919', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (26, '2005-05-18 08:03:28.021862', 4773, '03efb176f04f3897de7d5e6484864b0559fd6cd6', '0123456789012345678901234567891a', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (27, '2005-05-18 08:03:28.021862', 2961, '4468039e1d2cbdfc78d2e53477e5fe0537bae302', '0123456789012345678901234567891b', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (28, '2005-05-18 08:03:28.021862', 3558, 'd6c2ddacdab7618ce2a555c20a4a730fcdb42600', '0123456789012345678901234567891c', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (29, '2005-05-18 08:03:28.021862', 3561, '9eb09455e6a568605c1bbab4cdf1936eee92222d', '0123456789012345678901234567891d', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (30, '2005-05-18 08:03:28.021862', 3305, 'b45b170da29f9b22650315657505124766c93720', '0123456789012345678901234567891e', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (31, '2005-05-18 08:03:28.021862', 3987, '9668ba9f0a59f9e6e6bc73fc5dc9f116b202bceb', '0123456789012345678901234567891f', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (32, '2005-05-18 08:03:28.021862', 4908, '874a6ef9cd1aaef17653c6c12f4b83ef9487c1c3', '01234567890123456789012345678920', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (33, '2005-05-18 08:03:28.021862', 4908, '874a6ef9cd1aaef17653c6c12f4b83ef9487c1c3', '01234567890123456789012345678920', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (34, '2005-08-10 09:31:29.606407', 2, '71853c6197a6a7f222db0f1978c7cb232b87c5ee', '01234567890123456789012345678921', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (35, '2005-08-01 09:31:29.606407', 2, '71853c6197a6a7f222db0f1978c7cb232b87c5ee', '01234567890123456789012345678921', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (36, '2005-10-30 18:00:27.899028', 3, '0beec7b5ea3f0fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678922', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (37, '2005-10-30 18:00:27.899028', 3, '1e04c7b5ea3f0fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678923', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (38, '2005-10-30 18:00:27.899028', 3, 'ae04c7b5ea3f0bdb095d0dd47f3c5bc275da8a33', '01234567890123456789012345678924', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (39, '2005-10-30 18:00:27.899028', 3, 'a10856bfea3f0bdb09550dd41f3c5bc275da8a33', '01234567890123456789012345678925', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (40, '2005-10-30 18:00:27.899028', 3, '5a04c7b5ea3f0fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678926', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (42, '2005-10-30 18:00:27.899028', 3, 'a45ed906e4f56fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678927', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (43, '2005-10-30 18:00:27.899028', 3, '4e3961baf4f56fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678928', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (44, '2005-10-30 18:00:27.899028', 3, 'b45ed906e4f5afdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678929', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (45, '2006-08-01 09:31:29.606407', 2, '43853c6197a6a7f222db0f1978c7cb232b87c5ee', '0123456789012345678901234567892a', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (46, '2006-05-24 09:31:29.606407', 2, 'ab43246197a6a7f222db0f1978c7cb232b87c5ee', '0123456789012345678901234567892b', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (47, '2006-05-24 09:31:29.606407', 2, 'cabf42e197a6a7f222db0f1978c7cb232b87c5ee', '0123456789012345678901234567892c', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (51, '2006-07-14 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5437', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (52, '2006-05-24 09:31:29.606407', 2, '1622db354faa9fa653804d018f3b9d5291e37d6b', 'e4a7193a8f72fa2755e2162512069093', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (53, '2006-12-01 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5437', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (54, '2006-12-01 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5438', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (55, '2006-12-01 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5439', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (56, '2006-12-01 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5440', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (57, '2006-12-13 21:17:56.241901', 1599, 'acdf6b9b99c39b1585f829ec7d68598a8e10816d', '5c6fa250b612e7e4d17261268a4d8400', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (58, '2006-12-13 21:18:28.796588', 1599, 'acdf6b9b99c39b1585f829ec7d68598a8e10816d', '5c6fa250b612e7e4d17261268a4d8401', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (59, '2006-05-24 09:31:29.606407', 2, 'fabb42e197a6a7f222db0f1978c7cb232b87c5ee', '0123456789012345678901234567892d', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (60, '2007-01-03 17:26:27.288968', 11793, 'df3a6670671781d5e08d7795ca1ada776815d87f', 'e8120781cd606202fd259a4f0d4585bb', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (61, '2007-02-15 14:26:27.288968', 100, 'df3a6670671781d5e08d7795ca1ada776815d87f', 'e8120781cd606202fd259a4f0d4585b1', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (62, '2007-05-14 23:21:11.121446', 123, 'd06b970f258e57547ef1104fba3499eb4ab43ff6', '767e1635f55ff5e833410523decec438', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (63, '2007-05-14 23:21:11.121446', 123, 'd06b970f258e57547ef1104fba3499eb4ab43ff6', '767e1635f55ff5e833410523decec438', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (65, '2007-08-09 21:25:37.832976', 958, 'df4adf483eb24fec455e8411ca3dceb0bee51b44', 'b85b447f88c326c4124f0554e175097f', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (66, '2007-08-09 21:25:37.832976', 179, '3e00fea68e91f6e03de6333b4c8e60c2ce441926', 'f27fb7494c5afbb0fb10b78d16f7da37', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (67, '2007-08-09 21:25:37.832976', 610, '01bedc249af59cb80abb40b4898eced10f5d5e20', '7d6fa416334c6da3b954bf9ebff6e9ae', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (68, '2007-08-09 21:25:37.832976', 567, 'b5aeb55faeb86a1d8c1a93dd58131b387a604c5a', '95f2b067e046d73f4e93eca44c034b97', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (69, '2007-08-09 21:54:18.456616', 749, '0526ef40da99af5c1c97c91f9aca77e7ae564838', '8afa3dbc21b2dcdad7f31ab28c041ad9', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (70, '2007-08-09 21:54:18.456616', 652, '0ce85c0cf331d05f76aa4977c43e87e9ffbd0480', '05a37db4ba50ba5f28650ee74b450c2c', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (71, '2007-09-10 19:14:26.037382', 22897, 'd7ebed9e00fc134ebc79eaf7deebb30a4f5f6859', '0113f983ff8beba46ad64c4ae8899091', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (72, '2007-09-10 19:15:01.67038', 221, '0ddef36534d59da64790eeffa55cc0221a01736d', 'df6ce34951747929ca9c6a4e2cb78f94', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (73, '2007-09-10 19:15:19.947543', 217, 'ea265925f6214628dc46e731ca1e131f1e632127', '9d19d15feffc620c0d16523e0ce00a54', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (74, '2007-09-10 19:16:01.017943', 22899, '234acbb3dc11b2af9bc46b6e33f0e453c3b1289d', '6d2d916ea729bc875ca0bd739f6be476', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (75, '2007-12-18 16:31:34.790641', 4296, 'e8b25389964bc3bd471c20a1508d00852ee7de40', 'e6b759498b7cde49e9d34e7b8c8b4542', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (76, '2007-12-18 16:31:34.790641', 2103, 'c154e1c1c2407d9b80c96b63c48d61a94248bf95', 'd86630cafdf624a3aa32aba0c41078c5', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (77, '2007-12-18 16:31:34.790641', 2787, '2d94c4a6a014895f93b581fb0134efe73ae4e2c8', '315ef57e5f6ad295e98db65607c5c18a', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (78, '2007-12-18 16:31:34.790641', 3534, '2bd22db53f2b9e47df50ed731128ff1fc54a5775', 'e0d510b49f803a0a4c2b2712d0a80522', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (79, '2007-12-18 16:31:34.790641', 3327, 'a57356e4cbf97bbb47df202449a95d909d50614a', '8c5ffb558a0d0f520887f3d4cbd619c5', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (80, '2007-12-18 16:31:34.790641', 189, '9800f54c65017e1bafe2d09a13af6176ba0ab244', 'a94677aabcd34b0901f1f75a35f7dff3', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (81, '2007-12-18 16:31:34.790641', 2926, 'b53bb11bc40c42b0f9ecd981561fe9d6f265b275', '496cf1cbb97c17a67998478402520ab5', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (82, '2008-03-17 15:36:19.035615', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (83, '2008-03-17 15:36:38.022812', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (84, '2008-03-17 15:36:48.877842', 3, '55ca6286e3e4f4fba5d0448333fa99fc5a404a73', '764efa883dda1e11db47671c4a3bbd9e', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (85, '2008-03-17 15:37:10.252357', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (86, '2008-03-17 15:37:22.489973', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (87, '2008-03-17 15:37:36.701686', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (88, '2008-03-17 15:37:48.465157', 3, '55ca6286e3e4f4fba5d0448333fa99fc5a404a73', '764efa883dda1e11db47671c4a3bbd9e', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (89, '2008-03-17 15:38:16.866444', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (90, '2008-05-08 10:10:16.866444', 18, '0c805a60b31058a1018680f99447033dcb9d4caa', '8a8a67b8dbc5f203ae8712092c68c7aa', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (91, '2008-07-07 22:30:01.123456', 10, '0c805a60b31058a1018680f99447033dcb9d4c01', '8a8a67b8dbc5f203ae8712092c68c701', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (92, '2008-09-30 08:19:00.222131', 10, 'f10e2821bbbea527ea02200352313bc059445190', '7815696ecbf1c96e6894b779456d330e', '0123456789012345678901234567890123456789012345678901234567890123');
 
 
 ALTER TABLE libraryfilecontent ENABLE TRIGGER ALL;
@@ -2336,20 +2336,20 @@
 
 ALTER TABLE archive DISABLE TRIGGER ALL;
 
-INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols) VALUES (1, 17, NULL, true, NULL, 1, 1, false, NULL, NULL, NULL, NULL, NULL, false, 'primary', true, '2008-05-27 18:15:12.241774', 15, 1, 8, 5, 1, '2008-09-23 17:29:03.442606', NULL, NULL, NULL, 'Primary Archive for Ubuntu Linux', 0, NULL, 0, false, true, false);
-INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols) VALUES (2, 1, NULL, true, NULL, 2, 1, false, NULL, NULL, NULL, NULL, NULL, false, 'primary', true, '2008-05-27 18:15:15.863812', 0, 0, 0, 0, 0, '2008-09-23 17:29:03.445921', NULL, NULL, NULL, 'Primary Archive for Redhat Advanced Server', 0, NULL, 0, false, false, false);
-INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols) VALUES (3, 1, NULL, true, NULL, 3, 1, false, NULL, NULL, NULL, NULL, NULL, false, 'primary', true, '2008-05-27 18:15:15.864941', 0, 0, 0, 0, 0, '2008-09-23 17:29:03.446557', NULL, NULL, NULL, 'Primary Archive for Debian GNU/Linux', 0, NULL, 0, false, false, false);
-INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols) VALUES (4, 1, NULL, true, NULL, 4, 1, false, NULL, NULL, NULL, NULL, NULL, false, 'primary', true, '2008-05-27 18:15:15.865502', 0, 0, 0, 0, 0, '2008-09-23 17:29:03.44689', NULL, NULL, NULL, 'Primary Archive for The Gentoo Linux', 0, NULL, 0, false, false, false);
-INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols) VALUES (5, 1, NULL, true, NULL, 5, 1, false, NULL, NULL, NULL, NULL, NULL, false, 'primary', true, '2008-05-27 18:15:15.866015', 0, 0, 0, 0, 0, '2008-09-23 17:29:03.447202', NULL, NULL, NULL, 'Primary Archive for Kubuntu - Free KDE-based Linux', 0, NULL, 0, false, false, false);
-INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols) VALUES (7, 4, NULL, true, NULL, 7, 1, false, NULL, NULL, NULL, NULL, NULL, false, 'primary', true, '2008-05-27 18:15:15.866529', 0, 0, 0, 0, 0, '2008-09-23 17:29:03.447515', NULL, NULL, NULL, 'Primary Archive for GuadaLinex: Linux for Andalucia', 0, NULL, 0, false, false, false);
-INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols) VALUES (8, 17, NULL, true, NULL, 8, 1, false, NULL, NULL, NULL, NULL, NULL, false, 'primary', true, '2008-05-27 18:15:15.867154', 0, 0, 0, 0, 0, '2008-09-23 17:29:03.447851', NULL, NULL, NULL, 'Primary Archive for Ubuntu Test', 0, NULL, 0, false, false, false);
-INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols) VALUES (9, 28, 'packages to help my friends.', true, 1024, 1, 2, false, 3, 3, NULL, NULL, NULL, true, 'ppa', true, '2008-05-27 18:15:15.867684', 4, 0, 3, 1, 0, '2008-09-23 17:29:03.448178', NULL, NULL, NULL, 'PPA for Celso Providelo', 0, NULL, 0, false, false, false);
-INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols) VALUES (10, 1, 'packages to help the humanity (you know, ubuntu)', true, 1024, 1, 2, false, 1, 1, NULL, NULL, NULL, true, 'ppa', true, '2008-05-27 18:15:15.868202', 0, 0, 0, 0, 0, '2008-09-23 17:29:03.448488', NULL, NULL, NULL, 'PPA for Mark Shuttleworth', 0, NULL, 0, false, false, false);
-INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols) VALUES (11, 52, 'I am not allowed to say, I have no privs.', true, 1024, 1, 2, false, 0, 0, NULL, NULL, NULL, true, 'ppa', true, '2008-05-27 18:15:15.868709', 1, 0, 0, 1, 0, '2008-09-23 17:29:03.448797', NULL, NULL, NULL, 'PPA for No Privileges Person', 0, NULL, 0, false, false, false);
-INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols) VALUES (12, 17, 'Partner archive', true, NULL, 1, 4, false, NULL, NULL, NULL, NULL, NULL, false, 'partner', true, '2008-05-27 18:15:15.869209', 1, 0, 1, 0, 0, '2008-09-23 17:29:03.449157', NULL, NULL, NULL, 'Partner Archive for Ubuntu Linux', 0, NULL, 0, false, false, false);
-INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols) VALUES (13, 17, 'Partner archive', true, NULL, 8, 4, false, NULL, NULL, NULL, NULL, NULL, false, 'partner', true, '2008-05-27 18:15:15.869732', 0, 0, 0, 0, 0, '2008-09-23 17:29:03.449471', NULL, NULL, NULL, 'Partner Archive for Ubuntu Test', 0, NULL, 0, false, false, false);
-INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols) VALUES (14, 17, 'Sample copy archive', true, NULL, 8, 6, false, NULL, NULL, NULL, NULL, NULL, false, 'samplecopyarchive', false, '2008-11-19 18:15:15.869732', 0, 0, 0, 0, 0, '2008-11-18 17:29:03.449471', NULL, NULL, NULL, 'Copy archive samplecopyarchive for Ubuntu Team', 0, NULL, 0, false, false, false);
-INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols) VALUES (16, 16, NULL, true, 2048, 9, 1, false, 0, 0, NULL, NULL, NULL, true, 'primary', true, '2011-03-17 14:28:54.354337', 0, 0, 0, 0, 0, '2011-03-17 14:28:54.354337', NULL, NULL, NULL, 'Primary Archive for Deribuntu', 0, NULL, 0, false, false, false);
+INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols, permit_obsolete_series_uploads) VALUES (1, 17, NULL, true, NULL, 1, 1, false, NULL, NULL, NULL, NULL, NULL, false, 'primary', true, '2008-05-27 18:15:12.241774', 15, 1, 8, 5, 1, '2008-09-23 17:29:03.442606', NULL, NULL, NULL, 'Primary Archive for Ubuntu Linux', 0, NULL, 0, false, true, false, false);
+INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols, permit_obsolete_series_uploads) VALUES (2, 1, NULL, true, NULL, 2, 1, false, NULL, NULL, NULL, NULL, NULL, false, 'primary', true, '2008-05-27 18:15:15.863812', 0, 0, 0, 0, 0, '2008-09-23 17:29:03.445921', NULL, NULL, NULL, 'Primary Archive for Redhat Advanced Server', 0, NULL, 0, false, false, false, false);
+INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols, permit_obsolete_series_uploads) VALUES (3, 1, NULL, true, NULL, 3, 1, false, NULL, NULL, NULL, NULL, NULL, false, 'primary', true, '2008-05-27 18:15:15.864941', 0, 0, 0, 0, 0, '2008-09-23 17:29:03.446557', NULL, NULL, NULL, 'Primary Archive for Debian GNU/Linux', 0, NULL, 0, false, false, false, false);
+INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols, permit_obsolete_series_uploads) VALUES (4, 1, NULL, true, NULL, 4, 1, false, NULL, NULL, NULL, NULL, NULL, false, 'primary', true, '2008-05-27 18:15:15.865502', 0, 0, 0, 0, 0, '2008-09-23 17:29:03.44689', NULL, NULL, NULL, 'Primary Archive for The Gentoo Linux', 0, NULL, 0, false, false, false, false);
+INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols, permit_obsolete_series_uploads) VALUES (5, 1, NULL, true, NULL, 5, 1, false, NULL, NULL, NULL, NULL, NULL, false, 'primary', true, '2008-05-27 18:15:15.866015', 0, 0, 0, 0, 0, '2008-09-23 17:29:03.447202', NULL, NULL, NULL, 'Primary Archive for Kubuntu - Free KDE-based Linux', 0, NULL, 0, false, false, false, false);
+INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols, permit_obsolete_series_uploads) VALUES (7, 4, NULL, true, NULL, 7, 1, false, NULL, NULL, NULL, NULL, NULL, false, 'primary', true, '2008-05-27 18:15:15.866529', 0, 0, 0, 0, 0, '2008-09-23 17:29:03.447515', NULL, NULL, NULL, 'Primary Archive for GuadaLinex: Linux for Andalucia', 0, NULL, 0, false, false, false, false);
+INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols, permit_obsolete_series_uploads) VALUES (8, 17, NULL, true, NULL, 8, 1, false, NULL, NULL, NULL, NULL, NULL, false, 'primary', true, '2008-05-27 18:15:15.867154', 0, 0, 0, 0, 0, '2008-09-23 17:29:03.447851', NULL, NULL, NULL, 'Primary Archive for Ubuntu Test', 0, NULL, 0, false, false, false, false);
+INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols, permit_obsolete_series_uploads) VALUES (9, 28, 'packages to help my friends.', true, 1024, 1, 2, false, 3, 3, NULL, NULL, NULL, true, 'ppa', true, '2008-05-27 18:15:15.867684', 4, 0, 3, 1, 0, '2008-09-23 17:29:03.448178', NULL, NULL, NULL, 'PPA for Celso Providelo', 0, NULL, 0, false, false, false, false);
+INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols, permit_obsolete_series_uploads) VALUES (10, 1, 'packages to help the humanity (you know, ubuntu)', true, 1024, 1, 2, false, 1, 1, NULL, NULL, NULL, true, 'ppa', true, '2008-05-27 18:15:15.868202', 0, 0, 0, 0, 0, '2008-09-23 17:29:03.448488', NULL, NULL, NULL, 'PPA for Mark Shuttleworth', 0, NULL, 0, false, false, false, false);
+INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols, permit_obsolete_series_uploads) VALUES (11, 52, 'I am not allowed to say, I have no privs.', true, 1024, 1, 2, false, 0, 0, NULL, NULL, NULL, true, 'ppa', true, '2008-05-27 18:15:15.868709', 1, 0, 0, 1, 0, '2008-09-23 17:29:03.448797', NULL, NULL, NULL, 'PPA for No Privileges Person', 0, NULL, 0, false, false, false, false);
+INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols, permit_obsolete_series_uploads) VALUES (12, 17, 'Partner archive', true, NULL, 1, 4, false, NULL, NULL, NULL, NULL, NULL, false, 'partner', true, '2008-05-27 18:15:15.869209', 1, 0, 1, 0, 0, '2008-09-23 17:29:03.449157', NULL, NULL, NULL, 'Partner Archive for Ubuntu Linux', 0, NULL, 0, false, false, false, false);
+INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols, permit_obsolete_series_uploads) VALUES (13, 17, 'Partner archive', true, NULL, 8, 4, false, NULL, NULL, NULL, NULL, NULL, false, 'partner', true, '2008-05-27 18:15:15.869732', 0, 0, 0, 0, 0, '2008-09-23 17:29:03.449471', NULL, NULL, NULL, 'Partner Archive for Ubuntu Test', 0, NULL, 0, false, false, false, false);
+INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols, permit_obsolete_series_uploads) VALUES (14, 17, 'Sample copy archive', true, NULL, 8, 6, false, NULL, NULL, NULL, NULL, NULL, false, 'samplecopyarchive', false, '2008-11-19 18:15:15.869732', 0, 0, 0, 0, 0, '2008-11-18 17:29:03.449471', NULL, NULL, NULL, 'Copy archive samplecopyarchive for Ubuntu Team', 0, NULL, 0, false, false, false, false);
+INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols, permit_obsolete_series_uploads) VALUES (16, 16, NULL, true, 2048, 9, 1, false, 0, 0, NULL, NULL, NULL, true, 'primary', true, '2011-03-17 14:28:54.354337', 0, 0, 0, 0, 0, '2011-03-17 14:28:54.354337', NULL, NULL, NULL, 'Primary Archive for Deribuntu', 0, NULL, 0, false, false, false, false);
 
 
 ALTER TABLE archive ENABLE TRIGGER ALL;

=== modified file 'database/sampledata/current.sql'
--- database/sampledata/current.sql	2013-05-15 05:04:53 +0000
+++ database/sampledata/current.sql	2013-06-14 06:17:30 +0000
@@ -1402,93 +1402,93 @@
 
 ALTER TABLE libraryfilecontent DISABLE TRIGGER ALL;
 
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (1, '2005-04-07 16:46:05.265391', 178859, '378b3498ead213d35a82033a6e9196014a5ef25c', '01234567890123456789012345678900', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (2, '2005-04-07 16:46:05.266763', 9922560, 'a57faa6287aee2c58e115673a119c6083d31d1b9', '01234567890123456789012345678902', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (3, '2005-04-07 16:46:05.26727', 309386, 'b218ca7b52fa813550e3f14cdcf3ba68606e4446', '01234567890123456789012345678903', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (4, '2005-04-07 16:46:05.267803', 162927750, 'cfbd3ee1f510c66d49be465b900a3334e8488184', '01234567890123456789012345678904', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (5, '2005-05-18 08:03:28.021862', 4381, '9b1f78faa39fb09a9fd955d744002c2d8f32d88d', '01234567890123456789012345678905', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (6, '2005-05-18 08:03:28.021862', 7910, 'afdf21d698587a6601e2ffed0f44292b7ad5dd07', '01234567890123456789012345678906', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (7, '2005-05-18 08:03:28.021862', 10826, '502828e7591277535abe9015ffbc6918dbba8ef4', '01234567890123456789012345678907', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (8, '2005-05-18 08:03:28.021862', 10826, '502828e7591277535abe9015ffbc6918dbba8ef4', '01234567890123456789012345678907', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (9, '2005-05-18 08:03:28.021862', 2655, 'ca3b107af84c05eaf98ba073376153986566ec28', '01234567890123456789012345678908', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (10, '2005-05-18 08:03:28.021862', 13110, 'bc7bebca1e3c5c166838b19f0eeb7f171e51805d', '01234567890123456789012345678909', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (11, '2005-05-18 08:03:28.021862', 13499, '78a26efee75a54f113063b78783b2d4612fee409', '0123456789012345678901234567890a', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (12, '2005-05-18 08:03:28.021862', 12695, '8812d04c170ca90bb1423e188ce9706869aa03d7', '0123456789012345678901234567890b', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (13, '2005-05-18 08:03:28.021862', 13133, 'db1b50cbde7142d344bd8ef9b2e1fe3b3116f77c', '0123456789012345678901234567890c', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (14, '2005-05-18 08:03:28.021862', 13641, 'e19cc1446e3004f10475c37b2cd363f75b8ae89a', '0123456789012345678901234567890d', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (15, '2005-05-18 08:03:28.021862', 13269, 'fc8cab1cb1e5fb1efa3c3c475b8f7c8dc5038d50', '0123456789012345678901234567890f', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (16, '2005-05-18 08:03:28.021862', 13983, 'e17ee3031bd29dcd1e5905c0fd17945600a91ccf', '01234567890123456789012345678910', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (17, '2005-05-18 08:03:28.021862', 12652, '07b01d1e6fe9a729f911e72dfe674a5e0abdc4ee', '01234567890123456789012345678911', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (18, '2005-05-18 08:03:28.021862', 13240, '801dc911c2bd67e17eff087516fdc63a2ac322ce', '01234567890123456789012345678912', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (19, '2005-05-18 08:03:28.021862', 4165, 'fca78a2292e4034b8dfbb2de6f69e17ebeecaaa1', '01234567890123456789012345678913', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (20, '2005-05-18 08:03:28.021862', 4093, 'fc67a1770f78c45c396b4724195aeb10683aa2fd', '01234567890123456789012345678914', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (21, '2005-05-18 08:03:28.021862', 3635, '4ab2ca308dafe152789640942488e23a33e4f46c', '01234567890123456789012345678915', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (22, '2005-05-18 08:03:28.021862', 3553, '20815563ee33368d51e3213354f97c05b4685968', '01234567890123456789012345678916', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (23, '2005-05-18 08:03:28.021862', 3778, '965968d3e6668f39ebc64bc11a3f1a5cd07c213b', '01234567890123456789012345678917', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (24, '2005-05-18 08:03:28.021862', 3666, 'cca8fb78e05a34481e07683cea8c3a47f01c609e', '01234567890123456789012345678918', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (25, '2005-05-18 08:03:28.021862', 3793, '28a7accfb491a2b4895b49b810ca7cda0badc787', '01234567890123456789012345678919', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (26, '2005-05-18 08:03:28.021862', 4773, '03efb176f04f3897de7d5e6484864b0559fd6cd6', '0123456789012345678901234567891a', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (27, '2005-05-18 08:03:28.021862', 2961, '4468039e1d2cbdfc78d2e53477e5fe0537bae302', '0123456789012345678901234567891b', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (28, '2005-05-18 08:03:28.021862', 3558, 'd6c2ddacdab7618ce2a555c20a4a730fcdb42600', '0123456789012345678901234567891c', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (29, '2005-05-18 08:03:28.021862', 3561, '9eb09455e6a568605c1bbab4cdf1936eee92222d', '0123456789012345678901234567891d', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (30, '2005-05-18 08:03:28.021862', 3305, 'b45b170da29f9b22650315657505124766c93720', '0123456789012345678901234567891e', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (31, '2005-05-18 08:03:28.021862', 3987, '9668ba9f0a59f9e6e6bc73fc5dc9f116b202bceb', '0123456789012345678901234567891f', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (32, '2005-05-18 08:03:28.021862', 4908, '874a6ef9cd1aaef17653c6c12f4b83ef9487c1c3', '01234567890123456789012345678920', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (33, '2005-05-18 08:03:28.021862', 4908, '874a6ef9cd1aaef17653c6c12f4b83ef9487c1c3', '01234567890123456789012345678920', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (34, '2005-08-10 09:31:29.606407', 2, '71853c6197a6a7f222db0f1978c7cb232b87c5ee', '01234567890123456789012345678921', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (35, '2005-08-01 09:31:29.606407', 2, '71853c6197a6a7f222db0f1978c7cb232b87c5ee', '01234567890123456789012345678921', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (36, '2005-10-30 18:00:27.899028', 3, '0beec7b5ea3f0fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678922', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (37, '2005-10-30 18:00:27.899028', 3, '1e04c7b5ea3f0fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678923', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (38, '2005-10-30 18:00:27.899028', 3, 'ae04c7b5ea3f0bdb095d0dd47f3c5bc275da8a33', '01234567890123456789012345678924', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (39, '2005-10-30 18:00:27.899028', 3, 'a10856bfea3f0bdb09550dd41f3c5bc275da8a33', '01234567890123456789012345678925', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (40, '2005-10-30 18:00:27.899028', 3, '5a04c7b5ea3f0fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678926', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (42, '2005-10-30 18:00:27.899028', 3, 'a45ed906e4f56fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678927', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (43, '2005-10-30 18:00:27.899028', 3, '4e3961baf4f56fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678928', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (44, '2005-10-30 18:00:27.899028', 3, 'b45ed906e4f5afdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678929', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (45, '2006-08-01 09:31:29.606407', 2, '43853c6197a6a7f222db0f1978c7cb232b87c5ee', '0123456789012345678901234567892a', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (46, '2006-05-24 09:31:29.606407', 2, 'ab43246197a6a7f222db0f1978c7cb232b87c5ee', '0123456789012345678901234567892b', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (47, '2006-05-24 09:31:29.606407', 2, 'cabf42e197a6a7f222db0f1978c7cb232b87c5ee', '0123456789012345678901234567892c', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (51, '2006-07-14 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5437', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (52, '2006-05-24 09:31:29.606407', 2, '1622db354faa9fa653804d018f3b9d5291e37d6b', 'e4a7193a8f72fa2755e2162512069093', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (53, '2006-12-01 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5437', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (54, '2006-12-01 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5438', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (55, '2006-12-01 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5439', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (56, '2006-12-01 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5440', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (57, '2006-12-13 21:17:56.241901', 1599, 'acdf6b9b99c39b1585f829ec7d68598a8e10816d', '5c6fa250b612e7e4d17261268a4d8400', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (58, '2006-12-13 21:18:28.796588', 1599, 'acdf6b9b99c39b1585f829ec7d68598a8e10816d', '5c6fa250b612e7e4d17261268a4d8401', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (59, '2006-05-24 09:31:29.606407', 2, 'fabb42e197a6a7f222db0f1978c7cb232b87c5ee', '0123456789012345678901234567892d', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (60, '2007-01-03 17:26:27.288968', 11793, 'df3a6670671781d5e08d7795ca1ada776815d87f', 'e8120781cd606202fd259a4f0d4585bb', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (61, '2007-02-15 14:26:27.288968', 100, 'df3a6670671781d5e08d7795ca1ada776815d87f', 'e8120781cd606202fd259a4f0d4585b1', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (62, '2007-05-14 23:21:11.121446', 123, 'd06b970f258e57547ef1104fba3499eb4ab43ff6', '767e1635f55ff5e833410523decec438', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (63, '2007-05-14 23:21:11.121446', 123, 'd06b970f258e57547ef1104fba3499eb4ab43ff6', '767e1635f55ff5e833410523decec438', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (65, '2007-08-09 21:25:37.832976', 958, 'df4adf483eb24fec455e8411ca3dceb0bee51b44', 'b85b447f88c326c4124f0554e175097f', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (66, '2007-08-09 21:25:37.832976', 179, '3e00fea68e91f6e03de6333b4c8e60c2ce441926', 'f27fb7494c5afbb0fb10b78d16f7da37', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (67, '2007-08-09 21:25:37.832976', 610, '01bedc249af59cb80abb40b4898eced10f5d5e20', '7d6fa416334c6da3b954bf9ebff6e9ae', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (68, '2007-08-09 21:25:37.832976', 567, 'b5aeb55faeb86a1d8c1a93dd58131b387a604c5a', '95f2b067e046d73f4e93eca44c034b97', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (69, '2007-08-09 21:54:18.456616', 749, '0526ef40da99af5c1c97c91f9aca77e7ae564838', '8afa3dbc21b2dcdad7f31ab28c041ad9', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (70, '2007-08-09 21:54:18.456616', 652, '0ce85c0cf331d05f76aa4977c43e87e9ffbd0480', '05a37db4ba50ba5f28650ee74b450c2c', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (71, '2007-09-10 19:14:26.037382', 22897, 'd7ebed9e00fc134ebc79eaf7deebb30a4f5f6859', '0113f983ff8beba46ad64c4ae8899091', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (72, '2007-09-10 19:15:01.67038', 221, '0ddef36534d59da64790eeffa55cc0221a01736d', 'df6ce34951747929ca9c6a4e2cb78f94', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (73, '2007-09-10 19:15:19.947543', 217, 'ea265925f6214628dc46e731ca1e131f1e632127', '9d19d15feffc620c0d16523e0ce00a54', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (74, '2007-09-10 19:16:01.017943', 22899, '234acbb3dc11b2af9bc46b6e33f0e453c3b1289d', '6d2d916ea729bc875ca0bd739f6be476', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (75, '2007-12-18 16:31:34.790641', 4296, 'e8b25389964bc3bd471c20a1508d00852ee7de40', 'e6b759498b7cde49e9d34e7b8c8b4542', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (76, '2007-12-18 16:31:34.790641', 2103, 'c154e1c1c2407d9b80c96b63c48d61a94248bf95', 'd86630cafdf624a3aa32aba0c41078c5', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (77, '2007-12-18 16:31:34.790641', 2787, '2d94c4a6a014895f93b581fb0134efe73ae4e2c8', '315ef57e5f6ad295e98db65607c5c18a', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (78, '2007-12-18 16:31:34.790641', 3534, '2bd22db53f2b9e47df50ed731128ff1fc54a5775', 'e0d510b49f803a0a4c2b2712d0a80522', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (79, '2007-12-18 16:31:34.790641', 3327, 'a57356e4cbf97bbb47df202449a95d909d50614a', '8c5ffb558a0d0f520887f3d4cbd619c5', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (80, '2007-12-18 16:31:34.790641', 189, '9800f54c65017e1bafe2d09a13af6176ba0ab244', 'a94677aabcd34b0901f1f75a35f7dff3', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (81, '2007-12-18 16:31:34.790641', 2926, 'b53bb11bc40c42b0f9ecd981561fe9d6f265b275', '496cf1cbb97c17a67998478402520ab5', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (82, '2008-03-17 15:36:19.035615', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (83, '2008-03-17 15:36:38.022812', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (84, '2008-03-17 15:36:48.877842', 3, '55ca6286e3e4f4fba5d0448333fa99fc5a404a73', '764efa883dda1e11db47671c4a3bbd9e', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (85, '2008-03-17 15:37:10.252357', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (86, '2008-03-17 15:37:22.489973', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (87, '2008-03-17 15:37:36.701686', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (88, '2008-03-17 15:37:48.465157', 3, '55ca6286e3e4f4fba5d0448333fa99fc5a404a73', '764efa883dda1e11db47671c4a3bbd9e', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (89, '2008-03-17 15:38:16.866444', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (90, '2008-05-08 10:10:16.866444', 18, '0c805a60b31058a1018680f99447033dcb9d4caa', '8a8a67b8dbc5f203ae8712092c68c7aa', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (91, '2008-07-07 22:30:01.123456', 10, '0c805a60b31058a1018680f99447033dcb9d4c01', '8a8a67b8dbc5f203ae8712092c68c701', NULL);
-INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (92, '2008-09-30 08:19:00.222131', 10, 'f10e2821bbbea527ea02200352313bc059445190', '7815696ecbf1c96e6894b779456d330e', NULL);
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (1, '2005-04-07 16:46:05.265391', 178859, '378b3498ead213d35a82033a6e9196014a5ef25c', '01234567890123456789012345678900', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (2, '2005-04-07 16:46:05.266763', 9922560, 'a57faa6287aee2c58e115673a119c6083d31d1b9', '01234567890123456789012345678902', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (3, '2005-04-07 16:46:05.26727', 309386, 'b218ca7b52fa813550e3f14cdcf3ba68606e4446', '01234567890123456789012345678903', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (4, '2005-04-07 16:46:05.267803', 162927750, 'cfbd3ee1f510c66d49be465b900a3334e8488184', '01234567890123456789012345678904', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (5, '2005-05-18 08:03:28.021862', 4381, '9b1f78faa39fb09a9fd955d744002c2d8f32d88d', '01234567890123456789012345678905', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (6, '2005-05-18 08:03:28.021862', 7910, 'afdf21d698587a6601e2ffed0f44292b7ad5dd07', '01234567890123456789012345678906', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (7, '2005-05-18 08:03:28.021862', 10826, '502828e7591277535abe9015ffbc6918dbba8ef4', '01234567890123456789012345678907', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (8, '2005-05-18 08:03:28.021862', 10826, '502828e7591277535abe9015ffbc6918dbba8ef4', '01234567890123456789012345678907', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (9, '2005-05-18 08:03:28.021862', 2655, 'ca3b107af84c05eaf98ba073376153986566ec28', '01234567890123456789012345678908', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (10, '2005-05-18 08:03:28.021862', 13110, 'bc7bebca1e3c5c166838b19f0eeb7f171e51805d', '01234567890123456789012345678909', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (11, '2005-05-18 08:03:28.021862', 13499, '78a26efee75a54f113063b78783b2d4612fee409', '0123456789012345678901234567890a', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (12, '2005-05-18 08:03:28.021862', 12695, '8812d04c170ca90bb1423e188ce9706869aa03d7', '0123456789012345678901234567890b', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (13, '2005-05-18 08:03:28.021862', 13133, 'db1b50cbde7142d344bd8ef9b2e1fe3b3116f77c', '0123456789012345678901234567890c', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (14, '2005-05-18 08:03:28.021862', 13641, 'e19cc1446e3004f10475c37b2cd363f75b8ae89a', '0123456789012345678901234567890d', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (15, '2005-05-18 08:03:28.021862', 13269, 'fc8cab1cb1e5fb1efa3c3c475b8f7c8dc5038d50', '0123456789012345678901234567890f', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (16, '2005-05-18 08:03:28.021862', 13983, 'e17ee3031bd29dcd1e5905c0fd17945600a91ccf', '01234567890123456789012345678910', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (17, '2005-05-18 08:03:28.021862', 12652, '07b01d1e6fe9a729f911e72dfe674a5e0abdc4ee', '01234567890123456789012345678911', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (18, '2005-05-18 08:03:28.021862', 13240, '801dc911c2bd67e17eff087516fdc63a2ac322ce', '01234567890123456789012345678912', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (19, '2005-05-18 08:03:28.021862', 4165, 'fca78a2292e4034b8dfbb2de6f69e17ebeecaaa1', '01234567890123456789012345678913', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (20, '2005-05-18 08:03:28.021862', 4093, 'fc67a1770f78c45c396b4724195aeb10683aa2fd', '01234567890123456789012345678914', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (21, '2005-05-18 08:03:28.021862', 3635, '4ab2ca308dafe152789640942488e23a33e4f46c', '01234567890123456789012345678915', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (22, '2005-05-18 08:03:28.021862', 3553, '20815563ee33368d51e3213354f97c05b4685968', '01234567890123456789012345678916', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (23, '2005-05-18 08:03:28.021862', 3778, '965968d3e6668f39ebc64bc11a3f1a5cd07c213b', '01234567890123456789012345678917', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (24, '2005-05-18 08:03:28.021862', 3666, 'cca8fb78e05a34481e07683cea8c3a47f01c609e', '01234567890123456789012345678918', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (25, '2005-05-18 08:03:28.021862', 3793, '28a7accfb491a2b4895b49b810ca7cda0badc787', '01234567890123456789012345678919', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (26, '2005-05-18 08:03:28.021862', 4773, '03efb176f04f3897de7d5e6484864b0559fd6cd6', '0123456789012345678901234567891a', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (27, '2005-05-18 08:03:28.021862', 2961, '4468039e1d2cbdfc78d2e53477e5fe0537bae302', '0123456789012345678901234567891b', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (28, '2005-05-18 08:03:28.021862', 3558, 'd6c2ddacdab7618ce2a555c20a4a730fcdb42600', '0123456789012345678901234567891c', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (29, '2005-05-18 08:03:28.021862', 3561, '9eb09455e6a568605c1bbab4cdf1936eee92222d', '0123456789012345678901234567891d', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (30, '2005-05-18 08:03:28.021862', 3305, 'b45b170da29f9b22650315657505124766c93720', '0123456789012345678901234567891e', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (31, '2005-05-18 08:03:28.021862', 3987, '9668ba9f0a59f9e6e6bc73fc5dc9f116b202bceb', '0123456789012345678901234567891f', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (32, '2005-05-18 08:03:28.021862', 4908, '874a6ef9cd1aaef17653c6c12f4b83ef9487c1c3', '01234567890123456789012345678920', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (33, '2005-05-18 08:03:28.021862', 4908, '874a6ef9cd1aaef17653c6c12f4b83ef9487c1c3', '01234567890123456789012345678920', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (34, '2005-08-10 09:31:29.606407', 2, '71853c6197a6a7f222db0f1978c7cb232b87c5ee', '01234567890123456789012345678921', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (35, '2005-08-01 09:31:29.606407', 2, '71853c6197a6a7f222db0f1978c7cb232b87c5ee', '01234567890123456789012345678921', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (36, '2005-10-30 18:00:27.899028', 3, '0beec7b5ea3f0fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678922', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (37, '2005-10-30 18:00:27.899028', 3, '1e04c7b5ea3f0fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678923', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (38, '2005-10-30 18:00:27.899028', 3, 'ae04c7b5ea3f0bdb095d0dd47f3c5bc275da8a33', '01234567890123456789012345678924', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (39, '2005-10-30 18:00:27.899028', 3, 'a10856bfea3f0bdb09550dd41f3c5bc275da8a33', '01234567890123456789012345678925', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (40, '2005-10-30 18:00:27.899028', 3, '5a04c7b5ea3f0fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678926', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (42, '2005-10-30 18:00:27.899028', 3, 'a45ed906e4f56fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678927', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (43, '2005-10-30 18:00:27.899028', 3, '4e3961baf4f56fdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678928', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (44, '2005-10-30 18:00:27.899028', 3, 'b45ed906e4f5afdbc95d0dd47f3c5bc275da8a33', '01234567890123456789012345678929', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (45, '2006-08-01 09:31:29.606407', 2, '43853c6197a6a7f222db0f1978c7cb232b87c5ee', '0123456789012345678901234567892a', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (46, '2006-05-24 09:31:29.606407', 2, 'ab43246197a6a7f222db0f1978c7cb232b87c5ee', '0123456789012345678901234567892b', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (47, '2006-05-24 09:31:29.606407', 2, 'cabf42e197a6a7f222db0f1978c7cb232b87c5ee', '0123456789012345678901234567892c', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (51, '2006-07-14 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5437', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (52, '2006-05-24 09:31:29.606407', 2, '1622db354faa9fa653804d018f3b9d5291e37d6b', 'e4a7193a8f72fa2755e2162512069093', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (53, '2006-12-01 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5437', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (54, '2006-12-01 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5438', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (55, '2006-12-01 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5439', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (56, '2006-12-01 16:41:34.028627', 716, '86d537a0d8b5b346d02752a853cc6ea648a0ebd7', 'eeb4c1e00a2e17a1eb51bd8b92fa5440', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (57, '2006-12-13 21:17:56.241901', 1599, 'acdf6b9b99c39b1585f829ec7d68598a8e10816d', '5c6fa250b612e7e4d17261268a4d8400', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (58, '2006-12-13 21:18:28.796588', 1599, 'acdf6b9b99c39b1585f829ec7d68598a8e10816d', '5c6fa250b612e7e4d17261268a4d8401', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (59, '2006-05-24 09:31:29.606407', 2, 'fabb42e197a6a7f222db0f1978c7cb232b87c5ee', '0123456789012345678901234567892d', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (60, '2007-01-03 17:26:27.288968', 11793, 'df3a6670671781d5e08d7795ca1ada776815d87f', 'e8120781cd606202fd259a4f0d4585bb', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (61, '2007-02-15 14:26:27.288968', 100, 'df3a6670671781d5e08d7795ca1ada776815d87f', 'e8120781cd606202fd259a4f0d4585b1', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (62, '2007-05-14 23:21:11.121446', 123, 'd06b970f258e57547ef1104fba3499eb4ab43ff6', '767e1635f55ff5e833410523decec438', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (63, '2007-05-14 23:21:11.121446', 123, 'd06b970f258e57547ef1104fba3499eb4ab43ff6', '767e1635f55ff5e833410523decec438', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (65, '2007-08-09 21:25:37.832976', 958, 'df4adf483eb24fec455e8411ca3dceb0bee51b44', 'b85b447f88c326c4124f0554e175097f', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (66, '2007-08-09 21:25:37.832976', 179, '3e00fea68e91f6e03de6333b4c8e60c2ce441926', 'f27fb7494c5afbb0fb10b78d16f7da37', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (67, '2007-08-09 21:25:37.832976', 610, '01bedc249af59cb80abb40b4898eced10f5d5e20', '7d6fa416334c6da3b954bf9ebff6e9ae', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (68, '2007-08-09 21:25:37.832976', 567, 'b5aeb55faeb86a1d8c1a93dd58131b387a604c5a', '95f2b067e046d73f4e93eca44c034b97', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (69, '2007-08-09 21:54:18.456616', 749, '0526ef40da99af5c1c97c91f9aca77e7ae564838', '8afa3dbc21b2dcdad7f31ab28c041ad9', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (70, '2007-08-09 21:54:18.456616', 652, '0ce85c0cf331d05f76aa4977c43e87e9ffbd0480', '05a37db4ba50ba5f28650ee74b450c2c', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (71, '2007-09-10 19:14:26.037382', 22897, 'd7ebed9e00fc134ebc79eaf7deebb30a4f5f6859', '0113f983ff8beba46ad64c4ae8899091', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (72, '2007-09-10 19:15:01.67038', 221, '0ddef36534d59da64790eeffa55cc0221a01736d', 'df6ce34951747929ca9c6a4e2cb78f94', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (73, '2007-09-10 19:15:19.947543', 217, 'ea265925f6214628dc46e731ca1e131f1e632127', '9d19d15feffc620c0d16523e0ce00a54', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (74, '2007-09-10 19:16:01.017943', 22899, '234acbb3dc11b2af9bc46b6e33f0e453c3b1289d', '6d2d916ea729bc875ca0bd739f6be476', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (75, '2007-12-18 16:31:34.790641', 4296, 'e8b25389964bc3bd471c20a1508d00852ee7de40', 'e6b759498b7cde49e9d34e7b8c8b4542', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (76, '2007-12-18 16:31:34.790641', 2103, 'c154e1c1c2407d9b80c96b63c48d61a94248bf95', 'd86630cafdf624a3aa32aba0c41078c5', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (77, '2007-12-18 16:31:34.790641', 2787, '2d94c4a6a014895f93b581fb0134efe73ae4e2c8', '315ef57e5f6ad295e98db65607c5c18a', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (78, '2007-12-18 16:31:34.790641', 3534, '2bd22db53f2b9e47df50ed731128ff1fc54a5775', 'e0d510b49f803a0a4c2b2712d0a80522', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (79, '2007-12-18 16:31:34.790641', 3327, 'a57356e4cbf97bbb47df202449a95d909d50614a', '8c5ffb558a0d0f520887f3d4cbd619c5', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (80, '2007-12-18 16:31:34.790641', 189, '9800f54c65017e1bafe2d09a13af6176ba0ab244', 'a94677aabcd34b0901f1f75a35f7dff3', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (81, '2007-12-18 16:31:34.790641', 2926, 'b53bb11bc40c42b0f9ecd981561fe9d6f265b275', '496cf1cbb97c17a67998478402520ab5', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (82, '2008-03-17 15:36:19.035615', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (83, '2008-03-17 15:36:38.022812', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (84, '2008-03-17 15:36:48.877842', 3, '55ca6286e3e4f4fba5d0448333fa99fc5a404a73', '764efa883dda1e11db47671c4a3bbd9e', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (85, '2008-03-17 15:37:10.252357', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (86, '2008-03-17 15:37:22.489973', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (87, '2008-03-17 15:37:36.701686', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (88, '2008-03-17 15:37:48.465157', 3, '55ca6286e3e4f4fba5d0448333fa99fc5a404a73', '764efa883dda1e11db47671c4a3bbd9e', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (89, '2008-03-17 15:38:16.866444', 18, '0c805a60b31058a1018680f99447033dcb9d4cf8', '8a8a67b8dbc5f203ae8712092c68c780', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (90, '2008-05-08 10:10:16.866444', 18, '0c805a60b31058a1018680f99447033dcb9d4caa', '8a8a67b8dbc5f203ae8712092c68c7aa', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (91, '2008-07-07 22:30:01.123456', 10, '0c805a60b31058a1018680f99447033dcb9d4c01', '8a8a67b8dbc5f203ae8712092c68c701', '0123456789012345678901234567890123456789012345678901234567890123');
+INSERT INTO libraryfilecontent (id, datecreated, filesize, sha1, md5, sha256) VALUES (92, '2008-09-30 08:19:00.222131', 10, 'f10e2821bbbea527ea02200352313bc059445190', '7815696ecbf1c96e6894b779456d330e', '0123456789012345678901234567890123456789012345678901234567890123');
 
 
 ALTER TABLE libraryfilecontent ENABLE TRIGGER ALL;
@@ -2332,19 +2332,19 @@
 
 ALTER TABLE archive DISABLE TRIGGER ALL;
 
-INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols) VALUES (1, 17, NULL, true, NULL, 1, 1, false, NULL, NULL, NULL, NULL, NULL, false, 'primary', true, '2008-05-27 18:15:12.241774', 15, 1, 8, 5, 1, '2008-09-23 17:29:03.442606', NULL, NULL, NULL, 'Primary Archive for Ubuntu Linux', 0, NULL, 0, false, true, false);
-INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols) VALUES (2, 1, NULL, true, NULL, 2, 1, false, NULL, NULL, NULL, NULL, NULL, false, 'primary', true, '2008-05-27 18:15:15.863812', 0, 0, 0, 0, 0, '2008-09-23 17:29:03.445921', NULL, NULL, NULL, 'Primary Archive for Redhat Advanced Server', 0, NULL, 0, false, false, false);
-INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols) VALUES (3, 1, NULL, true, NULL, 3, 1, false, NULL, NULL, NULL, NULL, NULL, false, 'primary', true, '2008-05-27 18:15:15.864941', 0, 0, 0, 0, 0, '2008-09-23 17:29:03.446557', NULL, NULL, NULL, 'Primary Archive for Debian GNU/Linux', 0, NULL, 0, false, false, false);
-INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols) VALUES (4, 1, NULL, true, NULL, 4, 1, false, NULL, NULL, NULL, NULL, NULL, false, 'primary', true, '2008-05-27 18:15:15.865502', 0, 0, 0, 0, 0, '2008-09-23 17:29:03.44689', NULL, NULL, NULL, 'Primary Archive for The Gentoo Linux', 0, NULL, 0, false, false, false);
-INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols) VALUES (5, 1, NULL, true, NULL, 5, 1, false, NULL, NULL, NULL, NULL, NULL, false, 'primary', true, '2008-05-27 18:15:15.866015', 0, 0, 0, 0, 0, '2008-09-23 17:29:03.447202', NULL, NULL, NULL, 'Primary Archive for Kubuntu - Free KDE-based Linux', 0, NULL, 0, false, false, false);
-INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols) VALUES (7, 4, NULL, true, NULL, 7, 1, false, NULL, NULL, NULL, NULL, NULL, false, 'primary', true, '2008-05-27 18:15:15.866529', 0, 0, 0, 0, 0, '2008-09-23 17:29:03.447515', NULL, NULL, NULL, 'Primary Archive for GuadaLinex: Linux for Andalucia', 0, NULL, 0, false, false, false);
-INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols) VALUES (8, 17, NULL, true, NULL, 8, 1, false, NULL, NULL, NULL, NULL, NULL, false, 'primary', true, '2008-05-27 18:15:15.867154', 0, 0, 0, 0, 0, '2008-09-23 17:29:03.447851', NULL, NULL, NULL, 'Primary Archive for Ubuntu Test', 0, NULL, 0, false, false, false);
-INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols) VALUES (9, 28, 'packages to help my friends.', true, 1024, 1, 2, false, 3, 3, NULL, NULL, NULL, true, 'ppa', true, '2008-05-27 18:15:15.867684', 4, 0, 3, 1, 0, '2008-09-23 17:29:03.448178', NULL, NULL, NULL, 'PPA for Celso Providelo', 0, NULL, 0, false, false, false);
-INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols) VALUES (10, 1, 'packages to help the humanity (you know, ubuntu)', true, 1024, 1, 2, false, 1, 1, NULL, NULL, NULL, true, 'ppa', true, '2008-05-27 18:15:15.868202', 0, 0, 0, 0, 0, '2008-09-23 17:29:03.448488', NULL, NULL, NULL, 'PPA for Mark Shuttleworth', 0, NULL, 0, false, false, false);
-INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols) VALUES (11, 52, 'I am not allowed to say, I have no privs.', true, 1024, 1, 2, false, 0, 0, NULL, NULL, NULL, true, 'ppa', true, '2008-05-27 18:15:15.868709', 1, 0, 0, 1, 0, '2008-09-23 17:29:03.448797', NULL, NULL, NULL, 'PPA for No Privileges Person', 0, NULL, 0, false, false, false);
-INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols) VALUES (12, 17, 'Partner archive', true, NULL, 1, 4, false, NULL, NULL, NULL, NULL, NULL, false, 'partner', true, '2008-05-27 18:15:15.869209', 1, 0, 1, 0, 0, '2008-09-23 17:29:03.449157', NULL, NULL, NULL, 'Partner Archive for Ubuntu Linux', 0, NULL, 0, false, false, false);
-INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols) VALUES (13, 17, 'Partner archive', true, NULL, 8, 4, false, NULL, NULL, NULL, NULL, NULL, false, 'partner', true, '2008-05-27 18:15:15.869732', 0, 0, 0, 0, 0, '2008-09-23 17:29:03.449471', NULL, NULL, NULL, 'Partner Archive for Ubuntu Test', 0, NULL, 0, false, false, false);
-INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols) VALUES (14, 17, 'Sample copy archive', true, NULL, 8, 6, false, NULL, NULL, NULL, NULL, NULL, false, 'samplecopyarchive', false, '2008-11-19 18:15:15.869732', 0, 0, 0, 0, 0, '2008-11-18 17:29:03.449471', NULL, NULL, NULL, 'Copy archive samplecopyarchive for Ubuntu Team', 0, NULL, 0, false, false, false);
+INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols, permit_obsolete_series_uploads) VALUES (1, 17, NULL, true, NULL, 1, 1, false, NULL, NULL, NULL, NULL, NULL, false, 'primary', true, '2008-05-27 18:15:12.241774', 15, 1, 8, 5, 1, '2008-09-23 17:29:03.442606', NULL, NULL, NULL, 'Primary Archive for Ubuntu Linux', 0, NULL, 0, false, true, false, false);
+INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols, permit_obsolete_series_uploads) VALUES (2, 1, NULL, true, NULL, 2, 1, false, NULL, NULL, NULL, NULL, NULL, false, 'primary', true, '2008-05-27 18:15:15.863812', 0, 0, 0, 0, 0, '2008-09-23 17:29:03.445921', NULL, NULL, NULL, 'Primary Archive for Redhat Advanced Server', 0, NULL, 0, false, false, false, false);
+INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols, permit_obsolete_series_uploads) VALUES (3, 1, NULL, true, NULL, 3, 1, false, NULL, NULL, NULL, NULL, NULL, false, 'primary', true, '2008-05-27 18:15:15.864941', 0, 0, 0, 0, 0, '2008-09-23 17:29:03.446557', NULL, NULL, NULL, 'Primary Archive for Debian GNU/Linux', 0, NULL, 0, false, false, false, false);
+INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols, permit_obsolete_series_uploads) VALUES (4, 1, NULL, true, NULL, 4, 1, false, NULL, NULL, NULL, NULL, NULL, false, 'primary', true, '2008-05-27 18:15:15.865502', 0, 0, 0, 0, 0, '2008-09-23 17:29:03.44689', NULL, NULL, NULL, 'Primary Archive for The Gentoo Linux', 0, NULL, 0, false, false, false, false);
+INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols, permit_obsolete_series_uploads) VALUES (5, 1, NULL, true, NULL, 5, 1, false, NULL, NULL, NULL, NULL, NULL, false, 'primary', true, '2008-05-27 18:15:15.866015', 0, 0, 0, 0, 0, '2008-09-23 17:29:03.447202', NULL, NULL, NULL, 'Primary Archive for Kubuntu - Free KDE-based Linux', 0, NULL, 0, false, false, false, false);
+INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols, permit_obsolete_series_uploads) VALUES (7, 4, NULL, true, NULL, 7, 1, false, NULL, NULL, NULL, NULL, NULL, false, 'primary', true, '2008-05-27 18:15:15.866529', 0, 0, 0, 0, 0, '2008-09-23 17:29:03.447515', NULL, NULL, NULL, 'Primary Archive for GuadaLinex: Linux for Andalucia', 0, NULL, 0, false, false, false, false);
+INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols, permit_obsolete_series_uploads) VALUES (8, 17, NULL, true, NULL, 8, 1, false, NULL, NULL, NULL, NULL, NULL, false, 'primary', true, '2008-05-27 18:15:15.867154', 0, 0, 0, 0, 0, '2008-09-23 17:29:03.447851', NULL, NULL, NULL, 'Primary Archive for Ubuntu Test', 0, NULL, 0, false, false, false, false);
+INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols, permit_obsolete_series_uploads) VALUES (9, 28, 'packages to help my friends.', true, 1024, 1, 2, false, 3, 3, NULL, NULL, NULL, true, 'ppa', true, '2008-05-27 18:15:15.867684', 4, 0, 3, 1, 0, '2008-09-23 17:29:03.448178', NULL, NULL, NULL, 'PPA for Celso Providelo', 0, NULL, 0, false, false, false, false);
+INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols, permit_obsolete_series_uploads) VALUES (10, 1, 'packages to help the humanity (you know, ubuntu)', true, 1024, 1, 2, false, 1, 1, NULL, NULL, NULL, true, 'ppa', true, '2008-05-27 18:15:15.868202', 0, 0, 0, 0, 0, '2008-09-23 17:29:03.448488', NULL, NULL, NULL, 'PPA for Mark Shuttleworth', 0, NULL, 0, false, false, false, false);
+INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols, permit_obsolete_series_uploads) VALUES (11, 52, 'I am not allowed to say, I have no privs.', true, 1024, 1, 2, false, 0, 0, NULL, NULL, NULL, true, 'ppa', true, '2008-05-27 18:15:15.868709', 1, 0, 0, 1, 0, '2008-09-23 17:29:03.448797', NULL, NULL, NULL, 'PPA for No Privileges Person', 0, NULL, 0, false, false, false, false);
+INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols, permit_obsolete_series_uploads) VALUES (12, 17, 'Partner archive', true, NULL, 1, 4, false, NULL, NULL, NULL, NULL, NULL, false, 'partner', true, '2008-05-27 18:15:15.869209', 1, 0, 1, 0, 0, '2008-09-23 17:29:03.449157', NULL, NULL, NULL, 'Partner Archive for Ubuntu Linux', 0, NULL, 0, false, false, false, false);
+INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols, permit_obsolete_series_uploads) VALUES (13, 17, 'Partner archive', true, NULL, 8, 4, false, NULL, NULL, NULL, NULL, NULL, false, 'partner', true, '2008-05-27 18:15:15.869732', 0, 0, 0, 0, 0, '2008-09-23 17:29:03.449471', NULL, NULL, NULL, 'Partner Archive for Ubuntu Test', 0, NULL, 0, false, false, false, false);
+INSERT INTO archive (id, owner, description, enabled, authorized_size, distribution, purpose, private, sources_cached, binaries_cached, package_description_cache, fti, buildd_secret, require_virtualized, name, publish, date_updated, total_count, pending_count, succeeded_count, failed_count, building_count, date_created, signing_key, removed_binary_retention_days, num_old_versions_published, displayname, relative_build_score, external_dependencies, status, suppress_subscription_notifications, build_debug_symbols, publish_debug_symbols, permit_obsolete_series_uploads) VALUES (14, 17, 'Sample copy archive', true, NULL, 8, 6, false, NULL, NULL, NULL, NULL, NULL, false, 'samplecopyarchive', false, '2008-11-19 18:15:15.869732', 0, 0, 0, 0, 0, '2008-11-18 17:29:03.449471', NULL, NULL, NULL, 'Copy archive samplecopyarchive for Ubuntu Team', 0, NULL, 0, false, false, false, false);
 
 
 ALTER TABLE archive ENABLE TRIGGER ALL;

=== modified file 'lib/lp/services/librarian/client.py'
--- lib/lp/services/librarian/client.py	2012-09-28 06:25:44 +0000
+++ lib/lp/services/librarian/client.py	2013-06-14 06:17:30 +0000
@@ -183,8 +183,9 @@
             self._sendLine('', check_for_error_responses=(size > 0))
 
             # Prepare to the upload the file
-            shaDigester = hashlib.sha1()
-            md5Digester = hashlib.md5()
+            md5_digester = hashlib.md5()
+            sha1_digester = hashlib.sha1()
+            sha256_digester = hashlib.sha256()
             bytesWritten = 0
 
             # Read in and upload the file 64kb at a time, by using the two-arg
@@ -193,8 +194,9 @@
             for chunk in iter(lambda: file.read(1024 * 64), ''):
                 self.state.f.write(chunk)
                 bytesWritten += len(chunk)
-                shaDigester.update(chunk)
-                md5Digester.update(chunk)
+                md5_digester.update(chunk)
+                sha1_digester.update(chunk)
+                sha256_digester.update(chunk)
 
             assert bytesWritten == size, (
                 'size is %d, but %d were read from the file'
@@ -209,8 +211,9 @@
             # Add rows to DB
             content = LibraryFileContent(
                 id=contentID, filesize=size,
-                sha1=shaDigester.hexdigest(),
-                md5=md5Digester.hexdigest())
+                sha256=sha256_digester.hexdigest(),
+                sha1=sha1_digester.hexdigest(),
+                md5=md5_digester.hexdigest())
             LibraryFileAlias(
                 id=aliasID, content=content, filename=name.decode('UTF-8'),
                 mimetype=contentType, expires=expires,

=== modified file 'lib/lp/services/librarian/interfaces/__init__.py'
--- lib/lp/services/librarian/interfaces/__init__.py	2013-01-07 05:54:28 +0000
+++ lib/lp/services/librarian/interfaces/__init__.py	2013-06-14 06:17:30 +0000
@@ -147,6 +147,7 @@
     datecreated = Datetime(
         title=_('Date created'), required=True, readonly=True)
     filesize = Int(title=_('File size'), required=True, readonly=True)
+    sha256 = TextLine(title=_('SHA-256 hash'), required=True, readonly=True)
     sha1 = TextLine(title=_('SHA-1 hash'), required=True, readonly=True)
     md5 = TextLine(title=_('MD5 hash'), required=True, readonly=True)
 

=== modified file 'lib/lp/services/librarian/model.py'
--- lib/lp/services/librarian/model.py	2013-01-07 05:54:28 +0000
+++ lib/lp/services/librarian/model.py	2013-06-14 06:17:30 +0000
@@ -79,8 +79,9 @@
 
     datecreated = UtcDateTimeCol(notNull=True, default=UTC_NOW)
     filesize = IntCol(notNull=True)
+    sha256 = StringCol()
     sha1 = StringCol(notNull=True)
-    md5 = StringCol()
+    md5 = StringCol(notNull=True)
 
 
 class LibraryFileAlias(SQLBase):

=== modified file 'lib/lp/services/librarian/tests/test_client.py'
--- lib/lp/services/librarian/tests/test_client.py	2012-11-29 19:56:21 +0000
+++ lib/lp/services/librarian/tests/test_client.py	2013-06-14 06:17:30 +0000
@@ -2,6 +2,7 @@
 # GNU Affero General Public License version 3 (see the file LICENSE).
 
 from cStringIO import StringIO
+import hashlib
 import httplib
 import textwrap
 import unittest
@@ -156,6 +157,22 @@
         # twice.
         self.assertEqual(5, client.check_error_calls)
 
+    def test_addFile_hashes(self):
+        # addFile() sets the MD5, SHA-1 and SHA-256 hashes on the
+        # LibraryFileContent record.
+        data = 'i am some data'
+        md5 = hashlib.md5(data).hexdigest()
+        sha1 = hashlib.sha1(data).hexdigest()
+        sha256 = hashlib.sha256(data).hexdigest()
+
+        client = LibrarianClient()
+        lfa = LibraryFileAlias.get(
+            client.addFile('file', len(data), StringIO(data), 'text/plain'))
+
+        self.assertEqual(md5, lfa.content.md5)
+        self.assertEqual(sha1, lfa.content.sha1)
+        self.assertEqual(sha256, lfa.content.sha256)
+
     def test__getURLForDownload(self):
         # This protected method is used by getFileByAlias. It is supposed to
         # use the internal host and port rather than the external, proxied

=== modified file 'lib/lp/services/librarianserver/db.py'
--- lib/lp/services/librarianserver/db.py	2013-05-01 17:12:51 +0000
+++ lib/lp/services/librarianserver/db.py	2013-06-14 06:17:30 +0000
@@ -84,8 +84,9 @@
 
     # the following methods are used for adding to the library
 
-    def add(self, digest, size, md5Digest):
-        lfc = LibraryFileContent(filesize=size, sha1=digest, md5=md5Digest)
+    def add(self, digest, size, md5_digest, sha256_digest):
+        lfc = LibraryFileContent(
+            filesize=size, sha1=digest, md5=md5_digest, sha256=sha256_digest)
         return lfc.id
 
     def addAlias(self, fileid, filename, mimetype, expires=None):

=== modified file 'lib/lp/services/librarianserver/storage.py'
--- lib/lp/services/librarianserver/storage.py	2012-09-28 06:25:44 +0000
+++ lib/lp/services/librarianserver/storage.py	2013-06-14 06:17:30 +0000
@@ -102,13 +102,15 @@
         tmpfile, tmpfilepath = tempfile.mkstemp(dir=self.storage.incoming)
         self.tmpfile = os.fdopen(tmpfile, 'w')
         self.tmpfilepath = tmpfilepath
-        self.shaDigester = hashlib.sha1()
-        self.md5Digester = hashlib.md5()
+        self.md5_digester = hashlib.md5()
+        self.sha1_digester = hashlib.sha1()
+        self.sha256_digester = hashlib.sha256()
 
     def append(self, data):
         self.tmpfile.write(data)
-        self.shaDigester.update(data)
-        self.md5Digester.update(data)
+        self.md5_digester.update(data)
+        self.sha1_digester.update(data)
+        self.sha256_digester.update(data)
 
     @write_transaction
     def store(self):
@@ -117,7 +119,7 @@
         self.tmpfile.close()
 
         # Verify the digest matches what the client sent us
-        dstDigest = self.shaDigester.hexdigest()
+        dstDigest = self.sha1_digester.hexdigest()
         if self.srcDigest is not None and dstDigest != self.srcDigest:
             # XXX: Andrew Bennetts 2004-09-20: Write test that checks that
             # the file really is removed or renamed, and can't possibly be
@@ -151,7 +153,8 @@
             # it to the client.
             if self.contentID is None:
                 contentID = self.storage.library.add(
-                        dstDigest, self.size, self.md5Digester.hexdigest())
+                        dstDigest, self.size, self.md5_digester.hexdigest(),
+                        self.sha256_digester.hexdigest())
                 aliasID = self.storage.library.addAlias(
                         contentID, self.filename, self.mimetype, self.expires)
                 self.debugLog.append('created contentID: %r, aliasID: %r.'

=== modified file 'lib/lp/services/librarianserver/testing/fake.py'
--- lib/lp/services/librarianserver/testing/fake.py	2011-12-30 02:24:09 +0000
+++ lib/lp/services/librarianserver/testing/fake.py	2013-06-14 06:17:30 +0000
@@ -150,10 +150,12 @@
     def _makeLibraryFileContent(self, content):
         """Create a `LibraryFileContent`."""
         size = len(content)
+        md5 = hashlib.md5(content).hexdigest()
         sha1 = hashlib.sha1(content).hexdigest()
-        md5 = hashlib.md5(content).hexdigest()
+        sha256 = hashlib.sha256(content).hexdigest()
 
-        content_object = LibraryFileContent(filesize=size, sha1=sha1, md5=md5)
+        content_object = LibraryFileContent(
+            filesize=size, md5=md5, sha1=sha1, sha256=sha256)
         return content_object
 
     def create(self, name, size, file, contentType, expires=None,

=== modified file 'lib/lp/services/librarianserver/tests/test_db.py'
--- lib/lp/services/librarianserver/tests/test_db.py	2012-09-28 06:25:44 +0000
+++ lib/lp/services/librarianserver/tests/test_db.py	2013-06-14 06:17:30 +0000
@@ -31,11 +31,11 @@
         self.assertEqual([], library.lookupBySHA1('deadbeef'))
 
         # Add a file, check it is found by lookupBySHA1
-        fileID = library.add('deadbeef', 1234, 'abababab')
+        fileID = library.add('deadbeef', 1234, 'abababab', 'babababa')
         self.assertEqual([fileID], library.lookupBySHA1('deadbeef'))
 
         # Add a new file with the same digest
-        newFileID = library.add('deadbeef', 1234, 'abababab')
+        newFileID = library.add('deadbeef', 1234, 'abababab', 'babababa')
         # Check it gets a new ID anyway
         self.assertNotEqual(fileID, newFileID)
         # Check it is found by lookupBySHA1
@@ -57,7 +57,7 @@
         switch_dbuser('librarian')
         self.store = getUtility(IStoreSelector).get(
                 MAIN_STORE, DEFAULT_FLAVOR)
-        self.content_id = db.Library().add('deadbeef', 1234, 'abababab')
+        self.content_id = db.Library().add('deadbeef', 1234, 'abababab', 'ba')
         self.file_content = self._getTestFileContent()
         transaction.commit()
 

=== modified file 'lib/lp/services/librarianserver/tests/test_gc.py'
--- lib/lp/services/librarianserver/tests/test_gc.py	2012-12-20 07:44:56 +0000
+++ lib/lp/services/librarianserver/tests/test_gc.py	2013-06-14 06:17:30 +0000
@@ -637,8 +637,8 @@
 
         # First a blob that has been unclaimed and expired.
         cur.execute("""
-            INSERT INTO LibraryFileContent (filesize, sha1, md5)
-            VALUES (666, 'whatever', 'whatever')
+            INSERT INTO LibraryFileContent (filesize, sha1, md5, sha256)
+            VALUES (666, 'whatever', 'whatever', 'whatever')
             """)
         cur.execute("""SELECT currval('libraryfilecontent_id_seq')""")
         self.expired_lfc_id = cur.fetchone()[0]
@@ -677,8 +677,8 @@
         # Next a blob that has expired, but claimed and now linked to
         # elsewhere in the database
         cur.execute("""
-            INSERT INTO LibraryFileContent (filesize, sha1, md5)
-            VALUES (666, 'whatever', 'whatever')
+            INSERT INTO LibraryFileContent (filesize, sha1, md5, sha256)
+            VALUES (666, 'whatever', 'whatever', 'whatever')
             """)
         cur.execute("""SELECT currval('libraryfilecontent_id_seq')""")
         self.expired2_lfc_id = cur.fetchone()[0]
@@ -713,8 +713,8 @@
 
         # And a non expired blob
         cur.execute("""
-            INSERT INTO LibraryFileContent (filesize, sha1, md5)
-            VALUES (666, 'whatever', 'whatever')
+            INSERT INTO LibraryFileContent (filesize, sha1, md5, sha256)
+            VALUES (666, 'whatever', 'whatever', 'whatever')
             """)
         cur.execute("""SELECT currval('libraryfilecontent_id_seq')""")
         self.unexpired_lfc_id = cur.fetchone()[0]

=== modified file 'lib/lp/services/librarianserver/tests/test_storage.py'
--- lib/lp/services/librarianserver/tests/test_storage.py	2012-09-28 06:25:44 +0000
+++ lib/lp/services/librarianserver/tests/test_storage.py	2013-06-14 06:17:30 +0000
@@ -1,6 +1,7 @@
 # Copyright 2009 Canonical Ltd.  This software is licensed under the
 # GNU Affero General Public License version 3 (see the file LICENSE).
 
+import hashlib
 import os
 import shutil
 import tempfile
@@ -13,6 +14,7 @@
     IStoreSelector,
     MAIN_STORE,
     )
+from lp.services.librarian.model import LibraryFileContent
 from lp.services.librarianserver import db
 from lp.services.librarianserver.storage import (
     _relFileLocation,
@@ -132,6 +134,21 @@
         self.failUnless(self.storage.hasFile(fileid1))
         self.failUnless(self.storage.hasFile(fileid2))
 
+    def test_hashes(self):
+        # Check that the MD5, SHA1 and SHA256 hashes are correct.
+        data = 'i am some data'
+        md5 = hashlib.md5(data).hexdigest()
+        sha1 = hashlib.sha1(data).hexdigest()
+        sha256 = hashlib.sha256(data).hexdigest()
+
+        newfile = self.storage.startAddFile('file', len(data))
+        newfile.append(data)
+        lfc_id, lfa_id = newfile.store()
+        lfc = LibraryFileContent.get(lfc_id)
+        self.assertEqual(md5, lfc.md5)
+        self.assertEqual(sha1, lfc.sha1)
+        self.assertEqual(sha256, lfc.sha256)
+
 
 class StubLibrary:
     # Used by test_multipleFilesInOnePrefixedDirectory

=== modified file 'lib/lp/services/librarianserver/tests/test_storage_db.py'
--- lib/lp/services/librarianserver/tests/test_storage_db.py	2012-01-20 15:42:44 +0000
+++ lib/lp/services/librarianserver/tests/test_storage_db.py	2013-06-14 06:17:30 +0000
@@ -104,8 +104,8 @@
         self.assertRaises(DuplicateFileIDError, newfile.store)
 
     def test_clientProvidedDuplicateContent(self):
-        # Check the new behaviour specified by LibrarianTransactions spec: allow
-        # duplicate content with distinct IDs.
+        # Check the new behaviour specified by LibrarianTransactions
+        # spec: allow duplicate content with distinct IDs.
 
         content = 'some content'
 
@@ -122,8 +122,10 @@
         fileid2, aliasid2 = newfile2.store()
 
         # Create rows in the database for these files.
-        LibraryFileContent(filesize=0, sha1='foo', md5='xx', id=6661)
-        LibraryFileContent(filesize=0, sha1='foo', md5='xx', id=6662)
+        LibraryFileContent(
+            filesize=0, sha1='foo', md5='xx', sha256='xx', id=6661)
+        LibraryFileContent(
+            filesize=0, sha1='foo', md5='xx', sha256='xx', id=6662)
 
         flush_database_updates()
         # And no errors should have been raised!