|
7675.1203.1
by Steve Kowalik
Create BPRC. |
1 |
-- Copyright 2011 Canonical Ltd. This software is licensed under the
|
2 |
-- GNU Affero General Public License version 3 (see the file LICENSE).
|
|
3 |
||
4 |
SET client_min_messages=ERROR; |
|
5 |
||
|
7675.1203.4
by Steve Kowalik
* BinaryPackagePaths -> BinaryPackagePath. |
6 |
CREATE TABLE BinaryPackagePath ( |
|
7675.1203.2
by Steve Kowalik
Add comments, split into BPP and BPRC. |
7 |
id serial PRIMARY KEY, |
|
7675.1203.11
by Steve Kowalik
Switch from text to bytea, allowing us to store non-UTF8 data. |
8 |
path bytea UNIQUE NOT NULL |
|
7675.1203.2
by Steve Kowalik
Add comments, split into BPP and BPRC. |
9 |
);
|
10 |
||
|
7675.1203.1
by Steve Kowalik
Create BPRC. |
11 |
CREATE TABLE BinaryPackageReleaseContents ( |
|
7675.1203.3
by Steve Kowalik
Switch to patch 76, rename BRPC.path to binarypackagepath and sprinkle in NOT NULL. |
12 |
binarypackagerelease integer NOT NULL REFERENCES BinaryPackageRelease, |
|
7675.1203.4
by Steve Kowalik
* BinaryPackagePaths -> BinaryPackagePath. |
13 |
binarypackagepath integer NOT NULL REFERENCES BinaryPackagePath, |
|
7675.1203.3
by Steve Kowalik
Switch to patch 76, rename BRPC.path to binarypackagepath and sprinkle in NOT NULL. |
14 |
PRIMARY KEY (binarypackagerelease, binarypackagepath) |
|
7675.1203.1
by Steve Kowalik
Create BPRC. |
15 |
);
|
16 |
||
|
7675.1203.3
by Steve Kowalik
Switch to patch 76, rename BRPC.path to binarypackagepath and sprinkle in NOT NULL. |
17 |
INSERT INTO LaunchpadDatabaseRevision VALUES (2208, 76, 0); |