Launchpad itself

Merge lp:~stub/launchpad/librarian-last-accessed-db into lp:launchpad/db-devel

  1. librarian-last-accessed-db
  2. Merge into db-devel
Proposed by Stuart Bishop
Status: Merged
Approved by: Stuart Bishop
Approved revision: not available
Merged at revision: 12264
Proposed branch: lp:~stub/launchpad/librarian-last-accessed-db
Merge into: lp:launchpad/db-devel
Prerequisite: lp:~stub/launchpad/librarian-last-accessed
Diff against target: 391 lines (+179/-175)
4 files modified
database/sampledata/current-dev.sql (+87/-87)
database/sampledata/current.sql (+87/-87)
database/schema/comments.sql (+0/-1)
database/schema/patch-2209-39-1.sql (+5/-0)
To merge this branch: bzr merge lp:~stub/launchpad/librarian-last-accessed-db
Reviewer Review Type Date Requested Status
Stuart Bishop (community) Approve
Review via email: mp+142452@code.launchpad.net

Commit message

Drop LibraryFileAlias.last_accessed column from the database

Description of the change

= Summary =

LibraryFileAlias.last_accessed has never been successfully used, and has been in limbo for several years.

== Proposed fix ==

Drop it. Even if we activated it, it would be incorrect without integration with Squid.

== Pre-implementation notes ==

== LOC Rationale ==

== Implementation details ==

== Tests ==

== Demo and Q/A ==

= Launchpad lint =

Checking for conflicts and issues in changed files.

Linting changed files:
  database/schema/patch-2209-39-1.sql
  database/sampledata/current.sql
  database/sampledata/current-dev.sql
  database/schema/comments.sql

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

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== modified file 'database/sampledata/current-dev.sql'
2--- database/sampledata/current-dev.sql 2012-12-14 01:22:35 +0000
3+++ database/sampledata/current-dev.sql 2013-01-09 07:53:26 +0000
4@@ -1499,93 +1499,93 @@
5
6 ALTER TABLE libraryfilealias DISABLE TRIGGER ALL;
7
8-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (1, 1, 'netapplet-1.0.0.tar.gz', 'application/x-gtar', NULL, '2005-11-17 16:15:32.440132', '2005-04-07 16:46:05.265391', false, 0);
9-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (2, 1, 'netapplet_1.0.0.orig.tar.gz', 'application/x-gtar', NULL, '2005-11-17 16:15:32.440132', '2005-04-07 16:46:05.265391', false, 0);
10-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (3, 2, 'firefox_0.9.2.orig.tar.gz', 'application/x-gtar', NULL, '2005-11-17 16:15:32.440132', '2005-04-07 16:46:05.266763', false, 0);
11-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (4, 3, 'evolution-1.0.tar.gz', 'application/x-gtar', NULL, '2005-11-17 16:15:32.440132', '2005-04-07 16:46:05.26727', false, 0);
12-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (5, 5, 'netapplet.pot', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
13-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (6, 6, 'pmount.pot', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
14-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (7, 7, 'evolution-2.2.pot', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
15-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (8, 8, 'evolution-2.2.pot', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
16-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (9, 9, 'pkgconf-mozilla.pot', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
17-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (10, 10, 'hr.po', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
18-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (11, 11, 'ca.po', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
19-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (12, 12, 'nb.po', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
20-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (13, 13, 'cs.po', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
21-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (14, 14, 'es_ES.po', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
22-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (15, 15, 'de.po', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
23-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (16, 16, 'fr.po', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
24-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (17, 17, 'it_IT.po', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
25-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (18, 18, 'es.po', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
26-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (19, 19, 'fr.po', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
27-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (20, 20, 'pt_BR.po', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
28-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (21, 21, 'ja.po', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
29-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (22, 22, 'es.po', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
30-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (23, 23, 'nl.po', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
31-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (24, 24, 'cs.po', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
32-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (25, 25, 'da.po', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
33-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (26, 26, 'fi.po', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
34-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (27, 27, 'gl.po', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
35-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (28, 28, 'lt.po', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
36-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (29, 29, 'it.po', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
37-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (30, 30, 'tr.po', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
38-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (31, 31, 'de.po', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
39-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (32, 32, 'es.po', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
40-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (33, 33, 'es.po', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
41-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (34, 34, 'evolution-2.2-test.pot', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-08-10 09:31:29.606407', false, 0);
42-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (35, 35, 'Ubuntu-High-Pri-2005-08-01.csv', 'text/plain', NULL, '2005-11-17 16:15:32.440132', '2005-08-01 09:31:29.606407', false, 0);
43-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (36, NULL, 'foo.txt', 'text/plain', NULL, '2005-11-17 16:15:32.440132', '2005-10-30 18:00:27.899028', false, 0);
44-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (37, 37, 'pmount_1.9-1_all.deb', 'application/x-debian-package', NULL, '2005-11-17 16:15:32.440132', '2005-10-30 18:00:27.899028', false, 0);
45-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (38, 38, 'alsa-utils_1.0.9a-4.dsc', 'application/dsc', NULL, '2005-11-17 16:15:32.440132', '2005-10-30 18:00:27.899028', false, 0);
46-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (39, 39, 'alsa-utils_1.0.8-1ubuntu1.dsc', 'application/dsc', NULL, '2005-11-17 16:15:32.440132', '2005-10-30 18:00:27.899028', false, 0);
47-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (40, 40, 'mozilla-firefox_0.9_i386.deb', 'application/x-debian-package', NULL, '2005-11-17 16:15:32.440132', '2005-10-30 18:00:27.899028', false, 0);
48-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (42, 42, 'linux-2.6.12_2.6.12.20_i386.deb', 'application/x-debian-package', NULL, '2005-11-17 16:15:32.440132', '2005-10-30 18:00:27.899028', false, 0);
49-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (43, 43, 'alsa-utils_1.0.9a-4ubuntu1.dsc', 'application/x-debian-package', NULL, '2005-11-17 16:15:32.440132', '2005-10-30 18:00:27.899028', false, 0);
50-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (44, 44, 'at-3.14156_all.udeb', 'application/x-debian-package', NULL, '2005-11-17 16:15:32.440132', '2005-10-30 18:00:27.899028', false, 0);
51-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (45, 45, 'Ubuntu-High-Pri-2006-08-01.csv', 'text/plain', NULL, '2005-11-17 16:15:32.440132', '2006-08-01 09:31:29.606407', false, 0);
52-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (46, 46, 'non-existent-mirrorprober-logfile.txt', 'text/plain', NULL, '2006-05-24 16:15:32.440132', '2006-05-24 09:31:29.606407', false, 0);
53-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (47, 47, 'non-existent-mirrorprober-logfile.txt', 'text/plain', NULL, '2006-05-24 16:15:32.440132', '2006-05-24 09:31:29.606407', false, 0);
54-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (51, 51, 'x4cWPgneBxsZOM21ZzpRPxsZXod.msg', 'message/rfc822', NULL, '2006-07-14 16:41:34.028627', '2006-07-14 16:41:34.028627', false, 0);
55-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (52, 52, 'mozilla-firefox_0.9_i386.changes', 'text/plain', NULL, '2006-07-31 15:41:34.028627', '2006-05-24 09:31:29.606407', false, 0);
56-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (53, 53, 'cdrkit-1.0.dsc', 'application/dsc', NULL, '2006-12-01 15:41:34.028627', '2006-12-01 16:41:34.028627', false, 0);
57-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (54, 54, 'foobar-1.0.dsc', 'application/dsc', NULL, '2006-12-01 15:41:34.028627', '2006-12-01 16:41:34.028627', false, 0);
58-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (55, 55, 'cdrkit_1.0_all.deb', 'application/deb', NULL, '2006-12-01 15:41:34.028627', '2006-12-01 16:41:34.028627', false, 0);
59-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (56, 56, 'foobar_1.0_all.deb', 'application/deb', NULL, '2006-12-01 15:41:34.028627', '2006-12-01 16:41:34.028627', false, 0);
60-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (57, 57, 'evolution-2.2-test.pot', 'application/x-po', NULL, '2006-12-13 21:17:56.241901', '2006-12-13 21:17:56.241901', false, 0);
61-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (58, 58, 'pt_BR.po', 'application/x-po', NULL, '2006-12-13 21:18:28.796588', '2006-12-13 21:18:28.796588', false, 0);
62-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (59, 59, 'salgado-mugshot.jpg', 'image/jpeg', NULL, '2006-07-31 15:41:34.028627', '2006-05-24 09:31:29.606407', false, 0);
63-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (60, 60, 'es.po', 'application/x-po', NULL, '2007-01-03 17:26:27.288968', '2007-01-03 17:26:27.288968', false, 0);
64-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (61, 61, 'language-pack-ar_1.0.dsc', 'application/dsc', NULL, '2007-02-15 14:26:27.288968', '2007-02-15 14:26:27.288968', false, 0);
65-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (62, 62, 'iceweasel-1.0.dsc', 'application/dsc', NULL, '2007-05-14 23:21:11.121446', '2007-05-14 23:21:11.121446', false, 0);
66-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (63, 63, 'hwsubmission1.xml', 'text/xml', NULL, '2007-05-14 23:21:11.121446', '2007-05-14 23:21:11.121446', false, 0);
67-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (65, 65, 'commercialpackage_1.0-1_source.changes', 'text/plain', NULL, '2007-08-09 21:25:37.832976', '2007-08-09 21:25:37.832976', false, 0);
68-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (66, 66, 'commercialpackage_1.0.orig.tar.gz', 'application/gzipped-tar', NULL, '2007-08-09 21:25:37.832976', '2007-08-09 21:25:37.832976', false, 0);
69-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (67, 67, 'commercialpackage_1.0-1.diff.gz', 'application/gzipped-patch', NULL, '2007-08-09 21:25:37.832976', '2007-08-09 21:25:37.832976', false, 0);
70-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (68, 68, 'commercialpackage_1.0-1.dsc', 'text/x-debian-source-package', NULL, '2007-08-09 21:25:37.832976', '2007-08-09 21:25:37.832976', false, 0);
71-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (69, 69, 'commercialpackage_1.0-1_i386.changes', 'text/plain', NULL, '2007-08-09 21:54:18.456616', '2007-08-09 21:54:18.456616', false, 0);
72-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (70, 70, 'commercialpackage_1.0-1_i386.deb', 'application/x-debian-package', NULL, '2007-08-09 21:54:18.456616', '2007-08-09 21:54:18.456616', false, 0);
73-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (71, 71, 'ubuntu-hoary-translations.tar.gz', 'application/x-gtar', NULL, '2007-09-10 19:14:26.037382', '2007-09-10 19:14:26.037382', false, 0);
74-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (72, 72, 'ubuntu-hoary-translations-update.tar.gz', 'application/x-gtar', NULL, '2007-09-10 19:15:01.67038', '2007-09-10 19:15:01.67038', false, 0);
75-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (73, 73, 'ubuntu-hoary-translations-update.tar.gz', 'application/x-gtar', NULL, '2007-09-10 19:15:19.947543', '2007-09-10 19:15:19.947543', false, 0);
76-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (74, 74, 'ubuntu-hoary-translations.tar.gz', 'application/x-gtar', NULL, '2007-09-10 19:16:01.017943', '2007-09-10 19:16:01.017943', false, 0);
77-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (75, 75, 'cX0Ey6rIIK5MqHphucFPna1fQMt.msg', 'message/rfc822', NULL, '2007-12-18 16:31:34.790641', '2007-12-18 16:31:34.790641', false, 0);
78-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (76, 76, 'nSpn1l12p7HBplm6e7kaaX6lf86.msg', 'message/rfc822', NULL, '2007-12-18 16:31:34.790641', '2007-12-18 16:31:34.790641', false, 0);
79-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (77, 77, 'evJ9qHEN3ufdtsDUnGPb8a5hs77.msg', 'message/rfc822', NULL, '2007-12-18 16:31:34.790641', '2007-12-18 16:31:34.790641', false, 0);
80-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (78, 78, 'jqUQpLymm7f9DjBAAsQoM10WndS.msg', 'message/rfc822', NULL, '2007-12-18 16:31:34.790641', '2007-12-18 16:31:34.790641', false, 0);
81-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (79, 79, '378cZyfOfUKx6BySEK0HYKz4Tpd.msg', 'message/rfc822', NULL, '2007-12-18 16:31:34.790641', '2007-12-18 16:31:34.790641', false, 0);
82-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (80, 80, 'unnamed', 'application/pgp-signature; name="signature.asc"', NULL, '2007-12-18 16:31:34.790641', '2007-12-18 16:31:34.790641', false, 0);
83-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (81, 81, 'jm81HhLQDRDAsqbl74W7GT3cpel.msg', 'message/rfc822', NULL, '2007-12-18 16:31:34.790641', '2007-12-18 16:31:34.790641', false, 0);
84-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (82, 82, 'alsa-1.0.9a.exe', 'application/x-msdos-program', NULL, '2008-03-17 15:36:19.035615', '2008-03-17 15:36:19.035615', false, 0);
85-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (83, 83, 'alsa-1.0.9a.dmg', 'application/x-apple-diskimage', NULL, '2008-03-17 15:36:38.022812', '2008-03-17 15:36:38.022812', false, 0);
86-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (84, 84, 'README.txt', 'text/plain', NULL, '2008-03-17 15:36:48.877842', '2008-03-17 15:36:48.877842', false, 0);
87-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (85, 85, 'alsa-1.0.8.exe', 'application/x-msdos-program', NULL, '2008-03-17 15:37:10.252357', '2008-03-17 15:37:10.252357', false, 0);
88-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (86, 86, 'alsa-1.0.8.dmg', 'application/x-apple-diskimage', NULL, '2008-03-17 15:37:22.489973', '2008-03-17 15:37:22.489973', false, 0);
89-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (87, 87, 'alsa-1.0.8.tgz', 'application/x-tar', NULL, '2008-03-17 15:37:36.701686', '2008-03-17 15:37:36.701686', false, 0);
90-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (88, 88, 'README.txt', 'text/plain', NULL, '2008-03-17 15:37:48.465157', '2008-03-17 15:37:48.465157', false, 0);
91-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (89, 89, 'alsa-1.0.9a.tgz', 'application/x-tar', NULL, '2008-03-17 15:38:16.866444', '2008-03-17 15:38:16.866444', false, 0);
92-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (90, 90, 'pmount_1.0-1_all.deb', 'application/x-debian-package', NULL, '2008-05-08 10:15:32.440132', '2008-05-08 10:10:27.899028', false, 0);
93-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (91, 91, 'upload_22_log.txt', 'application/text', NULL, '2008-07-07 22:30:01.123456', '2008-07-07 22:30:01.123456', false, 0);
94-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (92, 92, 'sample-submission-2.xml', 'application/x-bzip2', NULL, '2008-09-30 08:19:00.222131', '2008-09-30 08:19:00.222131', false, 0);
95+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (1, 1, 'netapplet-1.0.0.tar.gz', 'application/x-gtar', NULL, '2005-04-07 16:46:05.265391', false, 0);
96+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (2, 1, 'netapplet_1.0.0.orig.tar.gz', 'application/x-gtar', NULL, '2005-04-07 16:46:05.265391', false, 0);
97+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (3, 2, 'firefox_0.9.2.orig.tar.gz', 'application/x-gtar', NULL, '2005-04-07 16:46:05.266763', false, 0);
98+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (4, 3, 'evolution-1.0.tar.gz', 'application/x-gtar', NULL, '2005-04-07 16:46:05.26727', false, 0);
99+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (5, 5, 'netapplet.pot', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
100+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (6, 6, 'pmount.pot', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
101+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (7, 7, 'evolution-2.2.pot', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
102+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (8, 8, 'evolution-2.2.pot', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
103+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (9, 9, 'pkgconf-mozilla.pot', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
104+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (10, 10, 'hr.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
105+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (11, 11, 'ca.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
106+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (12, 12, 'nb.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
107+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (13, 13, 'cs.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
108+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (14, 14, 'es_ES.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
109+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (15, 15, 'de.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
110+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (16, 16, 'fr.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
111+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (17, 17, 'it_IT.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
112+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (18, 18, 'es.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
113+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (19, 19, 'fr.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
114+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (20, 20, 'pt_BR.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
115+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (21, 21, 'ja.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
116+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (22, 22, 'es.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
117+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (23, 23, 'nl.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
118+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (24, 24, 'cs.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
119+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (25, 25, 'da.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
120+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (26, 26, 'fi.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
121+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (27, 27, 'gl.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
122+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (28, 28, 'lt.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
123+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (29, 29, 'it.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
124+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (30, 30, 'tr.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
125+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (31, 31, 'de.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
126+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (32, 32, 'es.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
127+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (33, 33, 'es.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
128+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (34, 34, 'evolution-2.2-test.pot', 'application/x-po', NULL, '2005-08-10 09:31:29.606407', false, 0);
129+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (35, 35, 'Ubuntu-High-Pri-2005-08-01.csv', 'text/plain', NULL, '2005-08-01 09:31:29.606407', false, 0);
130+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (36, NULL, 'foo.txt', 'text/plain', NULL, '2005-10-30 18:00:27.899028', false, 0);
131+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (37, 37, 'pmount_1.9-1_all.deb', 'application/x-debian-package', NULL, '2005-10-30 18:00:27.899028', false, 0);
132+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (38, 38, 'alsa-utils_1.0.9a-4.dsc', 'application/dsc', NULL, '2005-10-30 18:00:27.899028', false, 0);
133+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (39, 39, 'alsa-utils_1.0.8-1ubuntu1.dsc', 'application/dsc', NULL, '2005-10-30 18:00:27.899028', false, 0);
134+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (40, 40, 'mozilla-firefox_0.9_i386.deb', 'application/x-debian-package', NULL, '2005-10-30 18:00:27.899028', false, 0);
135+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (42, 42, 'linux-2.6.12_2.6.12.20_i386.deb', 'application/x-debian-package', NULL, '2005-10-30 18:00:27.899028', false, 0);
136+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (43, 43, 'alsa-utils_1.0.9a-4ubuntu1.dsc', 'application/x-debian-package', NULL, '2005-10-30 18:00:27.899028', false, 0);
137+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (44, 44, 'at-3.14156_all.udeb', 'application/x-debian-package', NULL, '2005-10-30 18:00:27.899028', false, 0);
138+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (45, 45, 'Ubuntu-High-Pri-2006-08-01.csv', 'text/plain', NULL, '2006-08-01 09:31:29.606407', false, 0);
139+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (46, 46, 'non-existent-mirrorprober-logfile.txt', 'text/plain', NULL, '2006-05-24 09:31:29.606407', false, 0);
140+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (47, 47, 'non-existent-mirrorprober-logfile.txt', 'text/plain', NULL, '2006-05-24 09:31:29.606407', false, 0);
141+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (51, 51, 'x4cWPgneBxsZOM21ZzpRPxsZXod.msg', 'message/rfc822', NULL, '2006-07-14 16:41:34.028627', false, 0);
142+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (52, 52, 'mozilla-firefox_0.9_i386.changes', 'text/plain', NULL, '2006-05-24 09:31:29.606407', false, 0);
143+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (53, 53, 'cdrkit-1.0.dsc', 'application/dsc', NULL, '2006-12-01 16:41:34.028627', false, 0);
144+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (54, 54, 'foobar-1.0.dsc', 'application/dsc', NULL, '2006-12-01 16:41:34.028627', false, 0);
145+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (55, 55, 'cdrkit_1.0_all.deb', 'application/deb', NULL, '2006-12-01 16:41:34.028627', false, 0);
146+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (56, 56, 'foobar_1.0_all.deb', 'application/deb', NULL, '2006-12-01 16:41:34.028627', false, 0);
147+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (57, 57, 'evolution-2.2-test.pot', 'application/x-po', NULL, '2006-12-13 21:17:56.241901', false, 0);
148+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (58, 58, 'pt_BR.po', 'application/x-po', NULL, '2006-12-13 21:18:28.796588', false, 0);
149+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (59, 59, 'salgado-mugshot.jpg', 'image/jpeg', NULL, '2006-05-24 09:31:29.606407', false, 0);
150+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (60, 60, 'es.po', 'application/x-po', NULL, '2007-01-03 17:26:27.288968', false, 0);
151+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (61, 61, 'language-pack-ar_1.0.dsc', 'application/dsc', NULL, '2007-02-15 14:26:27.288968', false, 0);
152+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (62, 62, 'iceweasel-1.0.dsc', 'application/dsc', NULL, '2007-05-14 23:21:11.121446', false, 0);
153+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (63, 63, 'hwsubmission1.xml', 'text/xml', NULL, '2007-05-14 23:21:11.121446', false, 0);
154+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (65, 65, 'commercialpackage_1.0-1_source.changes', 'text/plain', NULL, '2007-08-09 21:25:37.832976', false, 0);
155+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (66, 66, 'commercialpackage_1.0.orig.tar.gz', 'application/gzipped-tar', NULL, '2007-08-09 21:25:37.832976', false, 0);
156+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (67, 67, 'commercialpackage_1.0-1.diff.gz', 'application/gzipped-patch', NULL, '2007-08-09 21:25:37.832976', false, 0);
157+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (68, 68, 'commercialpackage_1.0-1.dsc', 'text/x-debian-source-package', NULL, '2007-08-09 21:25:37.832976', false, 0);
158+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (69, 69, 'commercialpackage_1.0-1_i386.changes', 'text/plain', NULL, '2007-08-09 21:54:18.456616', false, 0);
159+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (70, 70, 'commercialpackage_1.0-1_i386.deb', 'application/x-debian-package', NULL, '2007-08-09 21:54:18.456616', false, 0);
160+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (71, 71, 'ubuntu-hoary-translations.tar.gz', 'application/x-gtar', NULL, '2007-09-10 19:14:26.037382', false, 0);
161+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (72, 72, 'ubuntu-hoary-translations-update.tar.gz', 'application/x-gtar', NULL, '2007-09-10 19:15:01.67038', false, 0);
162+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (73, 73, 'ubuntu-hoary-translations-update.tar.gz', 'application/x-gtar', NULL, '2007-09-10 19:15:19.947543', false, 0);
163+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (74, 74, 'ubuntu-hoary-translations.tar.gz', 'application/x-gtar', NULL, '2007-09-10 19:16:01.017943', false, 0);
164+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (75, 75, 'cX0Ey6rIIK5MqHphucFPna1fQMt.msg', 'message/rfc822', NULL, '2007-12-18 16:31:34.790641', false, 0);
165+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (76, 76, 'nSpn1l12p7HBplm6e7kaaX6lf86.msg', 'message/rfc822', NULL, '2007-12-18 16:31:34.790641', false, 0);
166+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (77, 77, 'evJ9qHEN3ufdtsDUnGPb8a5hs77.msg', 'message/rfc822', NULL, '2007-12-18 16:31:34.790641', false, 0);
167+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (78, 78, 'jqUQpLymm7f9DjBAAsQoM10WndS.msg', 'message/rfc822', NULL, '2007-12-18 16:31:34.790641', false, 0);
168+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (79, 79, '378cZyfOfUKx6BySEK0HYKz4Tpd.msg', 'message/rfc822', NULL, '2007-12-18 16:31:34.790641', false, 0);
169+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (80, 80, 'unnamed', 'application/pgp-signature; name="signature.asc"', NULL, '2007-12-18 16:31:34.790641', false, 0);
170+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (81, 81, 'jm81HhLQDRDAsqbl74W7GT3cpel.msg', 'message/rfc822', NULL, '2007-12-18 16:31:34.790641', false, 0);
171+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (82, 82, 'alsa-1.0.9a.exe', 'application/x-msdos-program', NULL, '2008-03-17 15:36:19.035615', false, 0);
172+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (83, 83, 'alsa-1.0.9a.dmg', 'application/x-apple-diskimage', NULL, '2008-03-17 15:36:38.022812', false, 0);
173+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (84, 84, 'README.txt', 'text/plain', NULL, '2008-03-17 15:36:48.877842', false, 0);
174+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (85, 85, 'alsa-1.0.8.exe', 'application/x-msdos-program', NULL, '2008-03-17 15:37:10.252357', false, 0);
175+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (86, 86, 'alsa-1.0.8.dmg', 'application/x-apple-diskimage', NULL, '2008-03-17 15:37:22.489973', false, 0);
176+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (87, 87, 'alsa-1.0.8.tgz', 'application/x-tar', NULL, '2008-03-17 15:37:36.701686', false, 0);
177+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (88, 88, 'README.txt', 'text/plain', NULL, '2008-03-17 15:37:48.465157', false, 0);
178+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (89, 89, 'alsa-1.0.9a.tgz', 'application/x-tar', NULL, '2008-03-17 15:38:16.866444', false, 0);
179+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (90, 90, 'pmount_1.0-1_all.deb', 'application/x-debian-package', NULL, '2008-05-08 10:10:27.899028', false, 0);
180+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (91, 91, 'upload_22_log.txt', 'application/text', NULL, '2008-07-07 22:30:01.123456', false, 0);
181+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (92, 92, 'sample-submission-2.xml', 'application/x-bzip2', NULL, '2008-09-30 08:19:00.222131', false, 0);
182
183
184 ALTER TABLE libraryfilealias ENABLE TRIGGER ALL;
185
186=== modified file 'database/sampledata/current.sql'
187--- database/sampledata/current.sql 2012-12-14 01:22:35 +0000
188+++ database/sampledata/current.sql 2013-01-09 07:53:26 +0000
189@@ -1499,93 +1499,93 @@
190
191 ALTER TABLE libraryfilealias DISABLE TRIGGER ALL;
192
193-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (1, 1, 'netapplet-1.0.0.tar.gz', 'application/x-gtar', NULL, '2005-11-17 16:15:32.440132', '2005-04-07 16:46:05.265391', false, 0);
194-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (2, 1, 'netapplet_1.0.0.orig.tar.gz', 'application/x-gtar', NULL, '2005-11-17 16:15:32.440132', '2005-04-07 16:46:05.265391', false, 0);
195-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (3, 2, 'firefox_0.9.2.orig.tar.gz', 'application/x-gtar', NULL, '2005-11-17 16:15:32.440132', '2005-04-07 16:46:05.266763', false, 0);
196-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (4, 3, 'evolution-1.0.tar.gz', 'application/x-gtar', NULL, '2005-11-17 16:15:32.440132', '2005-04-07 16:46:05.26727', false, 0);
197-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (5, 5, 'netapplet.pot', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
198-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (6, 6, 'pmount.pot', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
199-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (7, 7, 'evolution-2.2.pot', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
200-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (8, 8, 'evolution-2.2.pot', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
201-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (9, 9, 'pkgconf-mozilla.pot', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
202-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (10, 10, 'hr.po', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
203-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (11, 11, 'ca.po', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
204-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (12, 12, 'nb.po', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
205-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (13, 13, 'cs.po', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
206-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (14, 14, 'es_ES.po', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
207-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (15, 15, 'de.po', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
208-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (16, 16, 'fr.po', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
209-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (17, 17, 'it_IT.po', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
210-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (18, 18, 'es.po', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
211-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (19, 19, 'fr.po', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
212-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (20, 20, 'pt_BR.po', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
213-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (21, 21, 'ja.po', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
214-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (22, 22, 'es.po', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
215-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (23, 23, 'nl.po', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
216-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (24, 24, 'cs.po', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
217-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (25, 25, 'da.po', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
218-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (26, 26, 'fi.po', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
219-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (27, 27, 'gl.po', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
220-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (28, 28, 'lt.po', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
221-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (29, 29, 'it.po', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
222-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (30, 30, 'tr.po', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
223-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (31, 31, 'de.po', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
224-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (32, 32, 'es.po', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
225-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (33, 33, 'es.po', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-05-18 08:03:28.021862', false, 0);
226-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (34, 34, 'evolution-2.2-test.pot', 'application/x-po', NULL, '2005-11-17 16:15:32.440132', '2005-08-10 09:31:29.606407', false, 0);
227-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (35, 35, 'Ubuntu-High-Pri-2005-08-01.csv', 'text/plain', NULL, '2005-11-17 16:15:32.440132', '2005-08-01 09:31:29.606407', false, 0);
228-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (36, NULL, 'foo.txt', 'text/plain', NULL, '2005-11-17 16:15:32.440132', '2005-10-30 18:00:27.899028', false, 0);
229-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (37, 37, 'pmount_1.9-1_all.deb', 'application/x-debian-package', NULL, '2005-11-17 16:15:32.440132', '2005-10-30 18:00:27.899028', false, 0);
230-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (38, 38, 'alsa-utils_1.0.9a-4.dsc', 'application/dsc', NULL, '2005-11-17 16:15:32.440132', '2005-10-30 18:00:27.899028', false, 0);
231-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (39, 39, 'alsa-utils_1.0.8-1ubuntu1.dsc', 'application/dsc', NULL, '2005-11-17 16:15:32.440132', '2005-10-30 18:00:27.899028', false, 0);
232-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (40, 40, 'mozilla-firefox_0.9_i386.deb', 'application/x-debian-package', NULL, '2005-11-17 16:15:32.440132', '2005-10-30 18:00:27.899028', false, 0);
233-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (42, 42, 'linux-2.6.12_2.6.12.20_i386.deb', 'application/x-debian-package', NULL, '2005-11-17 16:15:32.440132', '2005-10-30 18:00:27.899028', false, 0);
234-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (43, 43, 'alsa-utils_1.0.9a-4ubuntu1.dsc', 'application/x-debian-package', NULL, '2005-11-17 16:15:32.440132', '2005-10-30 18:00:27.899028', false, 0);
235-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (44, 44, 'at-3.14156_all.udeb', 'application/x-debian-package', NULL, '2005-11-17 16:15:32.440132', '2005-10-30 18:00:27.899028', false, 0);
236-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (45, 45, 'Ubuntu-High-Pri-2006-08-01.csv', 'text/plain', NULL, '2005-11-17 16:15:32.440132', '2006-08-01 09:31:29.606407', false, 0);
237-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (46, 46, 'non-existent-mirrorprober-logfile.txt', 'text/plain', NULL, '2006-05-24 16:15:32.440132', '2006-05-24 09:31:29.606407', false, 0);
238-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (47, 47, 'non-existent-mirrorprober-logfile.txt', 'text/plain', NULL, '2006-05-24 16:15:32.440132', '2006-05-24 09:31:29.606407', false, 0);
239-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (51, 51, 'x4cWPgneBxsZOM21ZzpRPxsZXod.msg', 'message/rfc822', NULL, '2006-07-14 16:41:34.028627', '2006-07-14 16:41:34.028627', false, 0);
240-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (52, 52, 'mozilla-firefox_0.9_i386.changes', 'text/plain', NULL, '2006-07-31 15:41:34.028627', '2006-05-24 09:31:29.606407', false, 0);
241-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (53, 53, 'cdrkit-1.0.dsc', 'application/dsc', NULL, '2006-12-01 15:41:34.028627', '2006-12-01 16:41:34.028627', false, 0);
242-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (54, 54, 'foobar-1.0.dsc', 'application/dsc', NULL, '2006-12-01 15:41:34.028627', '2006-12-01 16:41:34.028627', false, 0);
243-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (55, 55, 'cdrkit_1.0_all.deb', 'application/deb', NULL, '2006-12-01 15:41:34.028627', '2006-12-01 16:41:34.028627', false, 0);
244-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (56, 56, 'foobar_1.0_all.deb', 'application/deb', NULL, '2006-12-01 15:41:34.028627', '2006-12-01 16:41:34.028627', false, 0);
245-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (57, 57, 'evolution-2.2-test.pot', 'application/x-po', NULL, '2006-12-13 21:17:56.241901', '2006-12-13 21:17:56.241901', false, 0);
246-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (58, 58, 'pt_BR.po', 'application/x-po', NULL, '2006-12-13 21:18:28.796588', '2006-12-13 21:18:28.796588', false, 0);
247-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (59, 59, 'salgado-mugshot.jpg', 'image/jpeg', NULL, '2006-07-31 15:41:34.028627', '2006-05-24 09:31:29.606407', false, 0);
248-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (60, 60, 'es.po', 'application/x-po', NULL, '2007-01-03 17:26:27.288968', '2007-01-03 17:26:27.288968', false, 0);
249-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (61, 61, 'language-pack-ar_1.0.dsc', 'application/dsc', NULL, '2007-02-15 14:26:27.288968', '2007-02-15 14:26:27.288968', false, 0);
250-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (62, 62, 'iceweasel-1.0.dsc', 'application/dsc', NULL, '2007-05-14 23:21:11.121446', '2007-05-14 23:21:11.121446', false, 0);
251-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (63, 63, 'hwsubmission1.xml', 'text/xml', NULL, '2007-05-14 23:21:11.121446', '2007-05-14 23:21:11.121446', false, 0);
252-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (65, 65, 'commercialpackage_1.0-1_source.changes', 'text/plain', NULL, '2007-08-09 21:25:37.832976', '2007-08-09 21:25:37.832976', false, 0);
253-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (66, 66, 'commercialpackage_1.0.orig.tar.gz', 'application/gzipped-tar', NULL, '2007-08-09 21:25:37.832976', '2007-08-09 21:25:37.832976', false, 0);
254-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (67, 67, 'commercialpackage_1.0-1.diff.gz', 'application/gzipped-patch', NULL, '2007-08-09 21:25:37.832976', '2007-08-09 21:25:37.832976', false, 0);
255-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (68, 68, 'commercialpackage_1.0-1.dsc', 'text/x-debian-source-package', NULL, '2007-08-09 21:25:37.832976', '2007-08-09 21:25:37.832976', false, 0);
256-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (69, 69, 'commercialpackage_1.0-1_i386.changes', 'text/plain', NULL, '2007-08-09 21:54:18.456616', '2007-08-09 21:54:18.456616', false, 0);
257-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (70, 70, 'commercialpackage_1.0-1_i386.deb', 'application/x-debian-package', NULL, '2007-08-09 21:54:18.456616', '2007-08-09 21:54:18.456616', false, 0);
258-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (71, 71, 'ubuntu-hoary-translations.tar.gz', 'application/x-gtar', NULL, '2007-09-10 19:14:26.037382', '2007-09-10 19:14:26.037382', false, 0);
259-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (72, 72, 'ubuntu-hoary-translations-update.tar.gz', 'application/x-gtar', NULL, '2007-09-10 19:15:01.67038', '2007-09-10 19:15:01.67038', false, 0);
260-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (73, 73, 'ubuntu-hoary-translations-update.tar.gz', 'application/x-gtar', NULL, '2007-09-10 19:15:19.947543', '2007-09-10 19:15:19.947543', false, 0);
261-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (74, 74, 'ubuntu-hoary-translations.tar.gz', 'application/x-gtar', NULL, '2007-09-10 19:16:01.017943', '2007-09-10 19:16:01.017943', false, 0);
262-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (75, 75, 'cX0Ey6rIIK5MqHphucFPna1fQMt.msg', 'message/rfc822', NULL, '2007-12-18 16:31:34.790641', '2007-12-18 16:31:34.790641', false, 0);
263-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (76, 76, 'nSpn1l12p7HBplm6e7kaaX6lf86.msg', 'message/rfc822', NULL, '2007-12-18 16:31:34.790641', '2007-12-18 16:31:34.790641', false, 0);
264-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (77, 77, 'evJ9qHEN3ufdtsDUnGPb8a5hs77.msg', 'message/rfc822', NULL, '2007-12-18 16:31:34.790641', '2007-12-18 16:31:34.790641', false, 0);
265-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (78, 78, 'jqUQpLymm7f9DjBAAsQoM10WndS.msg', 'message/rfc822', NULL, '2007-12-18 16:31:34.790641', '2007-12-18 16:31:34.790641', false, 0);
266-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (79, 79, '378cZyfOfUKx6BySEK0HYKz4Tpd.msg', 'message/rfc822', NULL, '2007-12-18 16:31:34.790641', '2007-12-18 16:31:34.790641', false, 0);
267-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (80, 80, 'unnamed', 'application/pgp-signature; name="signature.asc"', NULL, '2007-12-18 16:31:34.790641', '2007-12-18 16:31:34.790641', false, 0);
268-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (81, 81, 'jm81HhLQDRDAsqbl74W7GT3cpel.msg', 'message/rfc822', NULL, '2007-12-18 16:31:34.790641', '2007-12-18 16:31:34.790641', false, 0);
269-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (82, 82, 'alsa-1.0.9a.exe', 'application/x-msdos-program', NULL, '2008-03-17 15:36:19.035615', '2008-03-17 15:36:19.035615', false, 0);
270-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (83, 83, 'alsa-1.0.9a.dmg', 'application/x-apple-diskimage', NULL, '2008-03-17 15:36:38.022812', '2008-03-17 15:36:38.022812', false, 0);
271-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (84, 84, 'README.txt', 'text/plain', NULL, '2008-03-17 15:36:48.877842', '2008-03-17 15:36:48.877842', false, 0);
272-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (85, 85, 'alsa-1.0.8.exe', 'application/x-msdos-program', NULL, '2008-03-17 15:37:10.252357', '2008-03-17 15:37:10.252357', false, 0);
273-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (86, 86, 'alsa-1.0.8.dmg', 'application/x-apple-diskimage', NULL, '2008-03-17 15:37:22.489973', '2008-03-17 15:37:22.489973', false, 0);
274-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (87, 87, 'alsa-1.0.8.tgz', 'application/x-tar', NULL, '2008-03-17 15:37:36.701686', '2008-03-17 15:37:36.701686', false, 0);
275-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (88, 88, 'README.txt', 'text/plain', NULL, '2008-03-17 15:37:48.465157', '2008-03-17 15:37:48.465157', false, 0);
276-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (89, 89, 'alsa-1.0.9a.tgz', 'application/x-tar', NULL, '2008-03-17 15:38:16.866444', '2008-03-17 15:38:16.866444', false, 0);
277-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (90, 90, 'pmount_1.0-1_all.deb', 'application/x-debian-package', NULL, '2008-05-08 10:15:32.440132', '2008-05-08 10:10:27.899028', false, 0);
278-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (91, 91, 'upload_22_log.txt', 'application/text', NULL, '2008-07-07 22:30:01.123456', '2008-07-07 22:30:01.123456', false, 0);
279-INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, last_accessed, date_created, restricted, hits) VALUES (92, 92, 'sample-submission-2.xml', 'application/x-bzip2', NULL, '2008-09-30 08:19:00.222131', '2008-09-30 08:19:00.222131', false, 0);
280+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (1, 1, 'netapplet-1.0.0.tar.gz', 'application/x-gtar', NULL, '2005-04-07 16:46:05.265391', false, 0);
281+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (2, 1, 'netapplet_1.0.0.orig.tar.gz', 'application/x-gtar', NULL, '2005-04-07 16:46:05.265391', false, 0);
282+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (3, 2, 'firefox_0.9.2.orig.tar.gz', 'application/x-gtar', NULL, '2005-04-07 16:46:05.266763', false, 0);
283+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (4, 3, 'evolution-1.0.tar.gz', 'application/x-gtar', NULL, '2005-04-07 16:46:05.26727', false, 0);
284+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (5, 5, 'netapplet.pot', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
285+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (6, 6, 'pmount.pot', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
286+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (7, 7, 'evolution-2.2.pot', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
287+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (8, 8, 'evolution-2.2.pot', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
288+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (9, 9, 'pkgconf-mozilla.pot', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
289+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (10, 10, 'hr.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
290+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (11, 11, 'ca.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
291+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (12, 12, 'nb.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
292+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (13, 13, 'cs.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
293+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (14, 14, 'es_ES.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
294+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (15, 15, 'de.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
295+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (16, 16, 'fr.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
296+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (17, 17, 'it_IT.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
297+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (18, 18, 'es.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
298+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (19, 19, 'fr.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
299+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (20, 20, 'pt_BR.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
300+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (21, 21, 'ja.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
301+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (22, 22, 'es.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
302+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (23, 23, 'nl.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
303+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (24, 24, 'cs.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
304+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (25, 25, 'da.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
305+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (26, 26, 'fi.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
306+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (27, 27, 'gl.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
307+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (28, 28, 'lt.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
308+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (29, 29, 'it.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
309+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (30, 30, 'tr.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
310+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (31, 31, 'de.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
311+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (32, 32, 'es.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
312+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (33, 33, 'es.po', 'application/x-po', NULL, '2005-05-18 08:03:28.021862', false, 0);
313+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (34, 34, 'evolution-2.2-test.pot', 'application/x-po', NULL, '2005-08-10 09:31:29.606407', false, 0);
314+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (35, 35, 'Ubuntu-High-Pri-2005-08-01.csv', 'text/plain', NULL, '2005-08-01 09:31:29.606407', false, 0);
315+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (36, NULL, 'foo.txt', 'text/plain', NULL, '2005-10-30 18:00:27.899028', false, 0);
316+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (37, 37, 'pmount_1.9-1_all.deb', 'application/x-debian-package', NULL, '2005-10-30 18:00:27.899028', false, 0);
317+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (38, 38, 'alsa-utils_1.0.9a-4.dsc', 'application/dsc', NULL, '2005-10-30 18:00:27.899028', false, 0);
318+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (39, 39, 'alsa-utils_1.0.8-1ubuntu1.dsc', 'application/dsc', NULL, '2005-10-30 18:00:27.899028', false, 0);
319+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (40, 40, 'mozilla-firefox_0.9_i386.deb', 'application/x-debian-package', NULL, '2005-10-30 18:00:27.899028', false, 0);
320+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (42, 42, 'linux-2.6.12_2.6.12.20_i386.deb', 'application/x-debian-package', NULL, '2005-10-30 18:00:27.899028', false, 0);
321+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (43, 43, 'alsa-utils_1.0.9a-4ubuntu1.dsc', 'application/x-debian-package', NULL, '2005-10-30 18:00:27.899028', false, 0);
322+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (44, 44, 'at-3.14156_all.udeb', 'application/x-debian-package', NULL, '2005-10-30 18:00:27.899028', false, 0);
323+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (45, 45, 'Ubuntu-High-Pri-2006-08-01.csv', 'text/plain', NULL, '2006-08-01 09:31:29.606407', false, 0);
324+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (46, 46, 'non-existent-mirrorprober-logfile.txt', 'text/plain', NULL, '2006-05-24 09:31:29.606407', false, 0);
325+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (47, 47, 'non-existent-mirrorprober-logfile.txt', 'text/plain', NULL, '2006-05-24 09:31:29.606407', false, 0);
326+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (51, 51, 'x4cWPgneBxsZOM21ZzpRPxsZXod.msg', 'message/rfc822', NULL, '2006-07-14 16:41:34.028627', false, 0);
327+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (52, 52, 'mozilla-firefox_0.9_i386.changes', 'text/plain', NULL, '2006-05-24 09:31:29.606407', false, 0);
328+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (53, 53, 'cdrkit-1.0.dsc', 'application/dsc', NULL, '2006-12-01 16:41:34.028627', false, 0);
329+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (54, 54, 'foobar-1.0.dsc', 'application/dsc', NULL, '2006-12-01 16:41:34.028627', false, 0);
330+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (55, 55, 'cdrkit_1.0_all.deb', 'application/deb', NULL, '2006-12-01 16:41:34.028627', false, 0);
331+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (56, 56, 'foobar_1.0_all.deb', 'application/deb', NULL, '2006-12-01 16:41:34.028627', false, 0);
332+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (57, 57, 'evolution-2.2-test.pot', 'application/x-po', NULL, '2006-12-13 21:17:56.241901', false, 0);
333+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (58, 58, 'pt_BR.po', 'application/x-po', NULL, '2006-12-13 21:18:28.796588', false, 0);
334+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (59, 59, 'salgado-mugshot.jpg', 'image/jpeg', NULL, '2006-05-24 09:31:29.606407', false, 0);
335+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (60, 60, 'es.po', 'application/x-po', NULL, '2007-01-03 17:26:27.288968', false, 0);
336+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (61, 61, 'language-pack-ar_1.0.dsc', 'application/dsc', NULL, '2007-02-15 14:26:27.288968', false, 0);
337+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (62, 62, 'iceweasel-1.0.dsc', 'application/dsc', NULL, '2007-05-14 23:21:11.121446', false, 0);
338+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (63, 63, 'hwsubmission1.xml', 'text/xml', NULL, '2007-05-14 23:21:11.121446', false, 0);
339+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (65, 65, 'commercialpackage_1.0-1_source.changes', 'text/plain', NULL, '2007-08-09 21:25:37.832976', false, 0);
340+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (66, 66, 'commercialpackage_1.0.orig.tar.gz', 'application/gzipped-tar', NULL, '2007-08-09 21:25:37.832976', false, 0);
341+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (67, 67, 'commercialpackage_1.0-1.diff.gz', 'application/gzipped-patch', NULL, '2007-08-09 21:25:37.832976', false, 0);
342+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (68, 68, 'commercialpackage_1.0-1.dsc', 'text/x-debian-source-package', NULL, '2007-08-09 21:25:37.832976', false, 0);
343+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (69, 69, 'commercialpackage_1.0-1_i386.changes', 'text/plain', NULL, '2007-08-09 21:54:18.456616', false, 0);
344+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (70, 70, 'commercialpackage_1.0-1_i386.deb', 'application/x-debian-package', NULL, '2007-08-09 21:54:18.456616', false, 0);
345+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (71, 71, 'ubuntu-hoary-translations.tar.gz', 'application/x-gtar', NULL, '2007-09-10 19:14:26.037382', false, 0);
346+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (72, 72, 'ubuntu-hoary-translations-update.tar.gz', 'application/x-gtar', NULL, '2007-09-10 19:15:01.67038', false, 0);
347+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (73, 73, 'ubuntu-hoary-translations-update.tar.gz', 'application/x-gtar', NULL, '2007-09-10 19:15:19.947543', false, 0);
348+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (74, 74, 'ubuntu-hoary-translations.tar.gz', 'application/x-gtar', NULL, '2007-09-10 19:16:01.017943', false, 0);
349+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (75, 75, 'cX0Ey6rIIK5MqHphucFPna1fQMt.msg', 'message/rfc822', NULL, '2007-12-18 16:31:34.790641', false, 0);
350+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (76, 76, 'nSpn1l12p7HBplm6e7kaaX6lf86.msg', 'message/rfc822', NULL, '2007-12-18 16:31:34.790641', false, 0);
351+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (77, 77, 'evJ9qHEN3ufdtsDUnGPb8a5hs77.msg', 'message/rfc822', NULL, '2007-12-18 16:31:34.790641', false, 0);
352+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (78, 78, 'jqUQpLymm7f9DjBAAsQoM10WndS.msg', 'message/rfc822', NULL, '2007-12-18 16:31:34.790641', false, 0);
353+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (79, 79, '378cZyfOfUKx6BySEK0HYKz4Tpd.msg', 'message/rfc822', NULL, '2007-12-18 16:31:34.790641', false, 0);
354+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (80, 80, 'unnamed', 'application/pgp-signature; name="signature.asc"', NULL, '2007-12-18 16:31:34.790641', false, 0);
355+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (81, 81, 'jm81HhLQDRDAsqbl74W7GT3cpel.msg', 'message/rfc822', NULL, '2007-12-18 16:31:34.790641', false, 0);
356+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (82, 82, 'alsa-1.0.9a.exe', 'application/x-msdos-program', NULL, '2008-03-17 15:36:19.035615', false, 0);
357+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (83, 83, 'alsa-1.0.9a.dmg', 'application/x-apple-diskimage', NULL, '2008-03-17 15:36:38.022812', false, 0);
358+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (84, 84, 'README.txt', 'text/plain', NULL, '2008-03-17 15:36:48.877842', false, 0);
359+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (85, 85, 'alsa-1.0.8.exe', 'application/x-msdos-program', NULL, '2008-03-17 15:37:10.252357', false, 0);
360+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (86, 86, 'alsa-1.0.8.dmg', 'application/x-apple-diskimage', NULL, '2008-03-17 15:37:22.489973', false, 0);
361+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (87, 87, 'alsa-1.0.8.tgz', 'application/x-tar', NULL, '2008-03-17 15:37:36.701686', false, 0);
362+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (88, 88, 'README.txt', 'text/plain', NULL, '2008-03-17 15:37:48.465157', false, 0);
363+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (89, 89, 'alsa-1.0.9a.tgz', 'application/x-tar', NULL, '2008-03-17 15:38:16.866444', false, 0);
364+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (90, 90, 'pmount_1.0-1_all.deb', 'application/x-debian-package', NULL, '2008-05-08 10:10:27.899028', false, 0);
365+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (91, 91, 'upload_22_log.txt', 'application/text', NULL, '2008-07-07 22:30:01.123456', false, 0);
366+INSERT INTO libraryfilealias (id, content, filename, mimetype, expires, date_created, restricted, hits) VALUES (92, 92, 'sample-submission-2.xml', 'application/x-bzip2', NULL, '2008-09-30 08:19:00.222131', false, 0);
367
368
369 ALTER TABLE libraryfilealias ENABLE TRIGGER ALL;
370
371=== modified file 'database/schema/comments.sql'
372--- database/schema/comments.sql 2012-11-15 01:53:44 +0000
373+++ database/schema/comments.sql 2013-01-09 07:53:26 +0000
374@@ -1681,7 +1681,6 @@
375 COMMENT ON COLUMN LibraryFileAlias.filename IS 'The name of the file. E.g. "foo_1.0-1_i386.deb"';
376 COMMENT ON COLUMN LibraryFileAlias.mimetype IS 'The mime type of the file. E.g. "application/x-debian-package"';
377 COMMENT ON COLUMN LibraryFileAlias.expires IS 'The expiry date of this file. If NULL, this item may be removed as soon as it is no longer referenced. If set, the item will not be removed until this date. Once the date is passed, the file may be removed from disk even if this item is still being referenced (in which case content.deleted will be true)';
378-COMMENT ON COLUMN LibraryFileAlias.last_accessed IS 'Roughly when this file was last retrieved from the Librarian. Initially set to this item''s creation date.';
379 COMMENT ON COLUMN LibraryFileAlias.date_created IS 'The timestamp when this alias was created.';
380 COMMENT ON COLUMN LibraryFileAlias.restricted IS 'Is this file available only from the restricted librarian?';
381 COMMENT ON COLUMN LibraryFileAlias.hits IS 'The number of times this file has been downloaded.';
382
383=== added file 'database/schema/patch-2209-39-1.sql'
384--- database/schema/patch-2209-39-1.sql 1970-01-01 00:00:00 +0000
385+++ database/schema/patch-2209-39-1.sql 2013-01-09 07:53:26 +0000
386@@ -0,0 +1,5 @@
387+SET client_min_messages=ERROR;
388+
389+ALTER TABLE LibraryFileAlias DROP COLUMN last_accessed;
390+
391+INSERT INTO LaunchpadDatabaseRevision VALUES (2209, 39, 1);

Subscribers

People subscribed via source and target branches

to status/vote changes: