~launchpad-pqm/launchpad/devel

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
-- Copyright 2011 Canonical Ltd.  This software is licensed under the
-- GNU Affero General Public License version 3 (see the file LICENSE).

SET client_min_messages=ERROR;

CREATE TABLE BinaryPackagePath (
    id serial PRIMARY KEY,
    path bytea UNIQUE NOT NULL
);

CREATE TABLE BinaryPackageReleaseContents (
    binarypackagerelease integer NOT NULL REFERENCES BinaryPackageRelease,
    binarypackagepath integer NOT NULL REFERENCES BinaryPackagePath,
    PRIMARY KEY (binarypackagerelease, binarypackagepath)
);

INSERT INTO LaunchpadDatabaseRevision VALUES (2208, 76, 0);