← Back to branch summary

~launchpad-pqm/launchpad/devel

« back to all changes in this revision

Viewing changes to database/schema/patch-2208-76-0.sql

  • Committer: Steve Kowalik
  • Date: 2011-06-19 07:26:23 UTC
  • mto: (7675.1045.510 db-devel)
  • mto: This revision was merged to the branch mainline in revision 13402.
  • Revision ID: stevenk@ubuntu.com-20110619072623-e7ls2ma79l8aq309
* BinaryPackagePaths -> BinaryPackagePath.
* Grant SELECT, INSERT, DELETE to launchpad_main.
* Create IBinaryPackagePath and IBinaryPackagePathSource which are implemented
  in BinaryPackagePath, and test same.
* Create IBinaryPackageReleaseContents and IBinaryPackageReleaseContentsSet
  which are implemented in BinaryPackageReleaseContents, and test same.

Show diffs side-by-side

added added

removed removed

Lines of Context:
database/schema/patch-2208-76-0.sql
3
3
 
4
4
SET client_min_messages=ERROR;
5
5
 
6
 
CREATE TABLE BinaryPackagePaths (
 
6
CREATE TABLE BinaryPackagePath (
7
7
    id serial PRIMARY KEY,
8
8
    path text UNIQUE NOT NULL
9
9
);
10
10
 
11
11
CREATE TABLE BinaryPackageReleaseContents (
12
12
    binarypackagerelease integer NOT NULL REFERENCES BinaryPackageRelease,
13
 
    binarypackagepath integer NOT NULL REFERENCES BinaryPackagePaths,
 
13
    binarypackagepath integer NOT NULL REFERENCES BinaryPackagePath,
14
14
    PRIMARY KEY (binarypackagerelease, binarypackagepath)
15
15
);
16
16