[newdak/master] Transitions and tags
Signed-off-by: Joerg Jaspert <joerg@debian.org>
---
sql/dakv2try2.ini | 401 ++++++++++++++++++++++++++++++++++++++++++++---------
sql/dakv2try2.sql | 113 +++++++++++++---
2 files changed, 429 insertions(+), 85 deletions(-)
diff --git a/sql/dakv2try2.ini b/sql/dakv2try2.ini
index 6027eff..b916bee 100644
--- a/sql/dakv2try2.ini
+++ b/sql/dakv2try2.ini
@@ -8,18 +8,18 @@ Domain=0
Procedure=0
Sequence=0
View=0
-Table=49
+Table=54
Trigger=0
Tablespace=0
Text=0
-Relation=64
+Relation=75
Stamp=1
[PROJECT]
Name="dakv2 try2"
Page="A4"
Orientation=0
-Revision=11/28/2008 11:44:10.704
+Revision=11/28/2008 19:38:49.645
Driver="8.3"
Author="joerg"
Display=0
@@ -79,8 +79,8 @@ OnDelete="RESTRICT"
Name="component_source_fkey"
X1=155
Y1=180
-X2=303
-Y2=362
+X2=265
+Y2=370
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -93,11 +93,11 @@ OnUpdate="RESTRICT"
OnDelete="RESTRICT"
[RELATION_12]
-Name="section_source_fkey"
+Name="section_source_maintainer_fkey"
X1=129
Y1=359
-X2=303
-Y2=380
+X2=265
+Y2=388
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -105,16 +105,16 @@ ColorMiddlePoint="255,0,0"
ColorEndPoint="0,255,0"
Table1="section"
Table2="source"
-Relation_0="section_pk,section_pk"
+Relation_0="section_pk,section_maintainer_pk"
OnUpdate="RESTRICT"
OnDelete="RESTRICT"
[RELATION_13]
-Name="priority_source_fkey"
+Name="priority_source_maintainer_fkey"
X1=241
Y1=358
-X2=303
-Y2=398
+X2=265
+Y2=406
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -122,7 +122,7 @@ ColorMiddlePoint="255,0,0"
ColorEndPoint="0,255,0"
Table1="priority"
Table2="source"
-Relation_0="priority_pk,priority_pk"
+Relation_0="priority_pk,priority_maintainer_pk"
OnUpdate="RESTRICT"
OnDelete="RESTRICT"
@@ -130,8 +130,8 @@ OnDelete="RESTRICT"
Name="changes_source_fkey"
X1=708
Y1=243
-X2=303
-Y2=416
+X2=265
+Y2=424
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -145,8 +145,8 @@ OnDelete="RESTRICT"
[RELATION_15]
Name="source_binary_set_fkey"
-X1=475
-Y1=344
+X1=491
+Y1=352
X2=500
Y2=444
ColorLine="192,192,192"
@@ -162,9 +162,9 @@ OnDelete="RESTRICT"
[RELATION_16]
Name="source_source_mirrorfile_fkey"
-X1=475
-Y1=344
-X2=97
+X1=491
+Y1=352
+X2=30
Y2=442
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
@@ -181,7 +181,7 @@ OnDelete="RESTRICT"
Name="mirrorfile_source_mirrorfile_fkey"
X1=373
Y1=541
-X2=97
+X2=30
Y2=460
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
@@ -213,7 +213,7 @@ OnDelete="RESTRICT"
[RELATION_19]
Name="binary_binary_set_binary_fkey"
-X1=1082
+X1=1136
Y1=109
X2=812
Y2=340
@@ -247,7 +247,7 @@ OnDelete="RESTRICT"
[RELATION_20]
Name="binary_binary_suite_fkey"
-X1=1082
+X1=1136
Y1=109
X2=333
Y2=195
@@ -297,7 +297,7 @@ OnUpdate="RESTRICT"
OnDelete="RESTRICT"
[RELATION_23]
-Name="section_binary_fkey"
+Name="section_binary_maintainer_fkey"
X1=129
Y1=359
X2=910
@@ -309,12 +309,12 @@ ColorMiddlePoint="255,0,0"
ColorEndPoint="0,255,0"
Table1="section"
Table2="binary"
-Relation_0="section_pk,section_pk"
+Relation_0="section_pk,section_maintainer_pk"
OnUpdate="RESTRICT"
OnDelete="RESTRICT"
[RELATION_24]
-Name="priority_binary_fkey"
+Name="priority_binary_maintainer_fkey"
X1=241
Y1=358
X2=910
@@ -326,7 +326,7 @@ ColorMiddlePoint="255,0,0"
ColorEndPoint="0,255,0"
Table1="priority"
Table2="binary"
-Relation_0="priority_pk,priority_pk"
+Relation_0="priority_pk,priority_maintainer_pk"
OnUpdate="RESTRICT"
OnDelete="RESTRICT"
@@ -349,10 +349,10 @@ OnDelete="RESTRICT"
[RELATION_26]
Name="binary_binary_mirrorfile_fkey"
-X1=1082
+X1=1136
Y1=109
-X2=465
-Y2=501
+X2=497
+Y2=505
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -368,8 +368,8 @@ OnDelete="RESTRICT"
Name="mirrorfile_binary_mirrorfile_fkey"
X1=373
Y1=541
-X2=465
-Y2=519
+X2=497
+Y2=523
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -759,8 +759,8 @@ OnDelete="RESTRICT"
Name="package_source_fkey"
X1=978
Y1=412
-X2=303
-Y2=434
+X2=265
+Y2=442
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -776,8 +776,8 @@ OnDelete="RESTRICT"
Name="source_format_source_fkey"
X1=874
Y1=656
-X2=303
-Y2=470
+X2=265
+Y2=478
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -808,8 +808,8 @@ OnDelete="RESTRICT"
[RELATION_50]
Name="binary_format_binary_fkey"
-X1=990
-Y1=39
+X1=1065
+Y1=36
X2=910
Y2=271
ColorLine="192,192,192"
@@ -825,8 +825,8 @@ OnDelete="RESTRICT"
[RELATION_51]
Name="changes_format_changes_fkey"
-X1=787
-Y1=157
+X1=792
+Y1=177
X2=554
Y2=279
ColorLine="192,192,192"
@@ -842,7 +842,7 @@ OnDelete="RESTRICT"
[RELATION_52]
Name="binary_binary_metadata_fkey"
-X1=1082
+X1=1136
Y1=109
X2=853
Y2=518
@@ -859,8 +859,8 @@ OnDelete="RESTRICT"
[RELATION_53]
Name="metadata_binary_metadata_fkey"
-X1=1399
-Y1=742
+X1=1058
+Y1=694
X2=853
Y2=536
ColorLine="192,192,192"
@@ -876,8 +876,8 @@ OnDelete="RESTRICT"
[RELATION_54]
Name="source_source_metadata_fkey"
-X1=475
-Y1=344
+X1=491
+Y1=352
X2=881
Y2=765
ColorLine="192,192,192"
@@ -893,8 +893,8 @@ OnDelete="RESTRICT"
[RELATION_55]
Name="metadata_source_metadata_fkey"
-X1=1399
-Y1=742
+X1=1058
+Y1=694
X2=881
Y2=783
ColorLine="192,192,192"
@@ -995,8 +995,8 @@ OnDelete="RESTRICT"
[RELATION_60]
Name="source_source_uploaders_fkey"
-X1=475
-Y1=344
+X1=491
+Y1=352
X2=699
Y2=831
ColorLine="192,192,192"
@@ -1061,6 +1061,108 @@ Relation_0="pathdir_pk,pathdir_pk"
OnUpdate="RESTRICT"
OnDelete="RESTRICT"
+[RELATION_64]
+Name="priority_source_fkey"
+X1=241
+Y1=358
+X2=265
+Y2=496
+ColorLine="192,192,192"
+ColorLineSelected="255,0,0"
+ColorStartPoint="255,0,0"
+ColorMiddlePoint="255,0,0"
+ColorEndPoint="0,-1,0"
+Table1="priority"
+Table2="source"
+Relation_0="priority_pk,priority_pk"
+OnUpdate="RESTRICT"
+OnDelete="RESTRICT"
+
+[RELATION_65]
+Name="binary_source_fkey"
+X1=129
+Y1=359
+X2=265
+Y2=514
+ColorLine="192,192,192"
+ColorLineSelected="255,0,0"
+ColorStartPoint="255,0,0"
+ColorMiddlePoint="255,0,0"
+ColorEndPoint="0,-1,0"
+Table1="section"
+Table2="source"
+Relation_0="section_pk,section_pk"
+OnUpdate="RESTRICT"
+OnDelete="RESTRICT"
+
+[RELATION_66]
+Name="priority_binary_fkey"
+X1=241
+Y1=358
+X2=910
+Y2=289
+ColorLine="192,192,192"
+ColorLineSelected="255,0,0"
+ColorStartPoint="255,0,0"
+ColorMiddlePoint="255,0,0"
+ColorEndPoint="0,-1,0"
+Table1="priority"
+Table2="binary"
+Relation_0="priority_pk,priority_pk"
+OnUpdate="RESTRICT"
+OnDelete="RESTRICT"
+
+[RELATION_67]
+Name="section_binary_fkey"
+X1=129
+Y1=359
+X2=910
+Y2=307
+ColorLine="192,192,192"
+ColorLineSelected="255,0,0"
+ColorStartPoint="255,0,0"
+ColorMiddlePoint="255,0,0"
+ColorEndPoint="0,-1,0"
+Table1="section"
+Table2="binary"
+Relation_0="section_pk,section_pk"
+OnUpdate="RESTRICT"
+OnDelete="RESTRICT"
+
+[RELATION_68]
+Name="tag_tag_binary_fkey"
+X1=714
+Y1=106
+X2=708
+Y2=37
+ColorLine="192,192,192"
+ColorLineSelected="255,0,0"
+ColorStartPoint="255,0,0"
+ColorMiddlePoint="255,0,0"
+ColorEndPoint="0,-1,0"
+Table1="tag"
+Table2="tag_binary"
+Relation_0="tag_pk,tag_pk"
+OnUpdate="RESTRICT"
+OnDelete="RESTRICT"
+
+[RELATION_69]
+Name="binary_tag_binary_fkey"
+X1=1136
+Y1=109
+X2=708
+Y2=55
+ColorLine="192,192,192"
+ColorLineSelected="255,0,0"
+ColorStartPoint="255,0,0"
+ColorMiddlePoint="255,0,0"
+ColorEndPoint="0,-1,0"
+Table1="binary"
+Table2="tag_binary"
+Relation_0="binary_pk,binary_pk"
+OnUpdate="RESTRICT"
+OnDelete="RESTRICT"
+
[RELATION_7]
Name="queue_suite_queue_fkey"
X1=495
@@ -1078,6 +1180,91 @@ Relation_0="queue_pk,queue_pk"
OnUpdate="RESTRICT"
OnDelete="RESTRICT"
+[RELATION_70]
+Name="package_transitions_fkey"
+X1=978
+Y1=412
+X2=1213
+Y2=610
+ColorLine="192,192,192"
+ColorLineSelected="255,0,0"
+ColorStartPoint="255,0,0"
+ColorMiddlePoint="255,0,0"
+ColorEndPoint="0,-1,0"
+Table1="package"
+Table2="transitions"
+Relation_0="package_pk,package_pk"
+OnUpdate="RESTRICT"
+OnDelete="RESTRICT"
+
+[RELATION_71]
+Name="fingerprint_upload_restriction_fkey"
+X1=1515
+Y1=130
+X2=1101
+Y2=779
+ColorLine="192,192,192"
+ColorLineSelected="255,0,0"
+ColorStartPoint="255,0,0"
+ColorMiddlePoint="255,0,0"
+ColorEndPoint="0,-1,0"
+Table1="fingerprint"
+Table2="upload_restriction"
+Relation_0="fingerprint_pk,fingerprint_pk"
+OnUpdate="RESTRICT"
+OnDelete="RESTRICT"
+
+[RELATION_72]
+Name="suite_upload_restriction_fkey"
+X1=267
+Y1=112
+X2=1101
+Y2=797
+ColorLine="192,192,192"
+ColorLineSelected="255,0,0"
+ColorStartPoint="255,0,0"
+ColorMiddlePoint="255,0,0"
+ColorEndPoint="0,-1,0"
+Table1="suite"
+Table2="upload_restriction"
+Relation_0="suite_pk,suite_pk"
+OnUpdate="RESTRICT"
+OnDelete="RESTRICT"
+
+[RELATION_73]
+Name="upload_restriction_transitions_upload_restrictions_fkey"
+X1=1318
+Y1=761
+X2=1138
+Y2=669
+ColorLine="192,192,192"
+ColorLineSelected="255,0,0"
+ColorStartPoint="255,0,0"
+ColorMiddlePoint="255,0,0"
+ColorEndPoint="0,-1,0"
+Table1="upload_restriction"
+Table2="transitions_upload_restrictions"
+Relation_0="upload_restriction_pk,upload_restriction_pk"
+OnUpdate="RESTRICT"
+OnDelete="RESTRICT"
+
+[RELATION_74]
+Name="transitions_transitions_upload_restrictions_fkey"
+X1=1367
+Y1=538
+X2=1138
+Y2=687
+ColorLine="192,192,192"
+ColorLineSelected="255,0,0"
+ColorStartPoint="255,0,0"
+ColorMiddlePoint="255,0,0"
+ColorEndPoint="0,-1,0"
+Table1="transitions"
+Table2="transitions_upload_restrictions"
+Relation_0="transitions_pk,transitions_pk"
+OnUpdate="RESTRICT"
+OnDelete="RESTRICT"
+
[RELATION_8]
Name="suite_suite_queue_fkey"
X1=267
@@ -1097,8 +1284,8 @@ OnDelete="RESTRICT"
[RELATION_9]
Name="source_source_suite_fkey"
-X1=475
-Y1=344
+X1=491
+Y1=352
X2=286
Y2=273
ColorLine="192,192,192"
@@ -1250,7 +1437,7 @@ Field_4="upload||T||0|true|false|timestamp with time zone||"
[TABLE_16]
Name="source_mirrorfile"
-X=97
+X=30
Y=406
ColorBack="230,230,230"
ColorText="0,0,0"
@@ -1276,14 +1463,16 @@ Option=False
PrimaryKey="binary_pk"
Field_0="binary_pk||T||0|true|true|serial||"
Field_1="architecture_pk||T||0|false|false|serial||"
-Field_2="section_pk||T||0|true|false|serial||"
-Field_3="priority_pk||T||0|true|false|serial||"
+Field_2="section_maintainer_pk||T||0|true|false|serial||"
+Field_3="priority_maintainer_pk||T||0|true|false|serial||"
Field_4="changes_pk||T||0|true|false|serial||"
Field_5="description_pk||T||0|true|false|serial||"
Field_6="package_pk||T||0|true|false|serial||"
Field_7="version||T||0|true|false|text||"
Field_8="installed_size||T||0|true|false|bigint||"
Field_9="binary_format_pk||T||0|true|false|serial||"
+Field_10="priority_pk||T||0|true|false|serial||"
+Field_11="section_pk||T||0|true|false|serial||"
[TABLE_18]
Name="binary_set_binary"
@@ -1347,8 +1536,8 @@ Field_1="arch||T||0|true|false|text||"
[TABLE_21]
Name="binary_mirrorfile"
-X=465
-Y=465
+X=497
+Y=469
ColorBack="230,230,230"
ColorText="0,0,0"
ColorBackTitle="230,230,230"
@@ -1667,8 +1856,8 @@ Field_3="pool||T|true|0|true|false|bool||"
[TABLE_40]
Name="binary_format"
-X=810
-Y=3
+X=885
+Y=0
ColorBack="230,230,230"
ColorText="0,0,0"
ColorBackTitle="230,230,230"
@@ -1682,8 +1871,8 @@ Field_1="version||T||0|true|false|text||"
[TABLE_41]
Name="changes_format"
-X=592
-Y=121
+X=597
+Y=141
ColorBack="230,230,230"
ColorText="0,0,0"
ColorBackTitle="230,230,230"
@@ -1697,8 +1886,8 @@ Field_1="version||T||0|true|false|text||"
[TABLE_42]
Name="metadata"
-X=1260
-Y=706
+X=919
+Y=658
ColorBack="230,230,230"
ColorText="0,0,0"
ColorBackTitle="230,230,230"
@@ -1799,6 +1988,22 @@ PrimaryKey="pathdir_pk"
Field_0="pathdir_pk||T||0|true|true|serial||"
Field_1="path||T||0|true|false|text||"
+[TABLE_49]
+Name="tag"
+X=630
+Y=70
+ColorBack="230,230,230"
+ColorText="0,0,0"
+ColorBackTitle="230,230,230"
+ColorBackTitleSelected="76,89,166"
+ColorForeTitle="0,0,0"
+ColorForeTitleSelected="255,255,255"
+Comment="0064006500620074006100670073"
+Option=False
+PrimaryKey="tag_pk"
+Field_0="tag_pk||T||0|true|true|serial||"
+Field_1="tag||T||0|true|false|text||"
+
[TABLE_5]
Name="visibility"
X=245
@@ -1815,6 +2020,68 @@ Field_0="visibility_pk||T||0|true|true|serial||"
Field_1="visibility||T||0|true|false|text||"
Field_2="level||T||0|true|false|bigint||"
+[TABLE_50]
+Name="tag_binary"
+X=708
+Y=1
+ColorBack="230,230,230"
+ColorText="0,0,0"
+ColorBackTitle="230,230,230"
+ColorBackTitleSelected="76,89,166"
+ColorForeTitle="0,0,0"
+ColorForeTitleSelected="255,255,255"
+Option=False
+Field_0="tag_pk||T||0|true|false|serial||"
+Field_1="binary_pk||T||0|true|false|serial||"
+
+[TABLE_51]
+Name="transitions"
+X=1213
+Y=502
+ColorBack="230,230,230"
+ColorText="0,0,0"
+ColorBackTitle="230,230,230"
+ColorBackTitleSelected="76,89,166"
+ColorForeTitle="0,0,0"
+ColorForeTitleSelected="255,255,255"
+Option=False
+PrimaryKey="transitions_pk"
+Field_0="transitions_pk||T||0|true|true|serial||"
+Field_1="description||T||0|true|false|text||"
+Field_2="bastard||T||0|true|false|text||"
+Field_3="version||T||0|true|false|text||"
+Field_4="package_pk||T||0|true|false|serial||"
+
+[TABLE_52]
+Name="upload_restriction"
+X=1101
+Y=725
+ColorBack="230,230,230"
+ColorText="0,0,0"
+ColorBackTitle="230,230,230"
+ColorBackTitleSelected="76,89,166"
+ColorForeTitle="0,0,0"
+ColorForeTitleSelected="255,255,255"
+Option=False
+PrimaryKey="upload_restriction_pk"
+Field_0="upload_restriction_pk||T||0|true|true|serial||"
+Field_1="fingerprint_pk||T||0|false|false|serial||"
+Field_2="suite_pk||T||0|false|false|serial||"
+
+[TABLE_53]
+Name="transitions_upload_restrictions"
+X=1138
+Y=633
+ColorBack="230,230,230"
+ColorText="0,0,0"
+ColorBackTitle="230,230,230"
+ColorBackTitleSelected="76,89,166"
+ColorForeTitle="0,0,0"
+ColorForeTitleSelected="255,255,255"
+Option=False
+Field_0="upload_restriction_pk||T||0|true|false|serial||"
+Field_1="transitions_pk||T||0|true|false|serial||"
+
[TABLE_6]
Name="queue"
X=384
@@ -1863,8 +2130,8 @@ Index_0="suite_queue_unique||true|queue_pk,suite_pk"
[TABLE_9]
Name="source"
-X=303
-Y=308
+X=265
+Y=316
ColorBack="230,230,230"
ColorText="0,0,0"
ColorBackTitle="230,230,230"
@@ -1875,12 +2142,14 @@ Option=False
PrimaryKey="source_pk"
Field_0="source_pk||T||0|true|true|serial||"
Field_1="component_pk||T||0|true|false|serial||"
-Field_2="section_pk||T||0|true|false|serial||"
-Field_3="priority_pk||T||0|true|false|serial||"
+Field_2="section_maintainer_pk||T||0|true|false|serial||"
+Field_3="priority_maintainer_pk||T||0|true|false|serial||"
Field_4="changes_pk||T||0|true|false|serial||"
Field_5="package_pk||T||0|true|false|serial||"
Field_6="version||T||0|true|false|text||"
Field_7="source_format_pk||T||0|true|false|serial||"
+Field_8="priority_pk||T||0|true|false|serial||"
+Field_9="section_pk||T||0|true|false|serial||"
[pgDesigner]
Version="1.1.1"
diff --git a/sql/dakv2try2.sql b/sql/dakv2try2.sql
index d2c0d57..6b23dc0 100644
--- a/sql/dakv2try2.sql
+++ b/sql/dakv2try2.sql
@@ -2,7 +2,7 @@
-- pgDesigner 1.2.7
--
-- Project : dakv2 try2
--- Date : 11/28/2008 11:42:18.234
+-- Date : 11/28/2008 19:39:50.131
-- Description:
------------------------------
@@ -81,12 +81,14 @@ DROP TABLE IF EXISTS "source" CASCADE;
CREATE TABLE "source" (
"source_pk" serial NOT NULL,
"component_pk" serial NOT NULL,
-"section_pk" serial NOT NULL,
-"priority_pk" serial NOT NULL,
+"section_maintainer_pk" serial NOT NULL,
+"priority_maintainer_pk" serial NOT NULL,
"changes_pk" serial NOT NULL,
"package_pk" serial NOT NULL,
"version" text NOT NULL,
-"source_format_pk" serial NOT NULL
+"source_format_pk" serial NOT NULL,
+"priority_pk" serial NOT NULL,
+"section_pk" serial NOT NULL
) WITHOUT OIDS;
ALTER TABLE "source" ADD CONSTRAINT "source_pk" PRIMARY KEY("source_pk");
@@ -153,14 +155,16 @@ DROP TABLE IF EXISTS "binary" CASCADE;
CREATE TABLE "binary" (
"binary_pk" serial NOT NULL,
"architecture_pk" serial,
-"section_pk" serial NOT NULL,
-"priority_pk" serial NOT NULL,
+"section_maintainer_pk" serial NOT NULL,
+"priority_maintainer_pk" serial NOT NULL,
"changes_pk" serial NOT NULL,
"description_pk" serial NOT NULL,
"package_pk" serial NOT NULL,
"version" text NOT NULL,
"installed_size" bigint NOT NULL,
-"binary_format_pk" serial NOT NULL
+"binary_format_pk" serial NOT NULL,
+"priority_pk" serial NOT NULL,
+"section_pk" serial NOT NULL
) WITHOUT OIDS;
ALTER TABLE "binary" ADD CONSTRAINT "binary_pk" PRIMARY KEY("binary_pk");
@@ -228,7 +232,7 @@ DROP TABLE IF EXISTS "path" CASCADE;
CREATE TABLE "path" (
"path_pk" serial NOT NULL,
"filename" text NOT NULL,
-"pathdir_pl" serial NOT NULL
+"pathdir_pk" serial NOT NULL
) WITHOUT OIDS;
ALTER TABLE "path" ADD CONSTRAINT "path_pk" PRIMARY KEY("path_pk");
@@ -375,12 +379,50 @@ CREATE TABLE "restricted_uploads" (
DROP TABLE IF EXISTS "pathdir" CASCADE;
CREATE TABLE "pathdir" (
-"pathdir_pl" serial NOT NULL,
+"pathdir_pk" serial NOT NULL,
"path" text NOT NULL
) WITHOUT OIDS;
-ALTER TABLE "pathdir" ADD CONSTRAINT "pathdir_pk" PRIMARY KEY("pathdir_pl");
+ALTER TABLE "pathdir" ADD CONSTRAINT "pathdir_pk" PRIMARY KEY("pathdir_pk");
COMMENT ON TABLE "pathdir" IS 'Path parts for files in contents';
+DROP TABLE IF EXISTS "tag" CASCADE;
+CREATE TABLE "tag" (
+"tag_pk" serial NOT NULL,
+"tag" text NOT NULL
+) WITHOUT OIDS;
+ALTER TABLE "tag" ADD CONSTRAINT "tag_pk" PRIMARY KEY("tag_pk");
+COMMENT ON TABLE "tag" IS 'debtags';
+
+DROP TABLE IF EXISTS "tag_binary" CASCADE;
+CREATE TABLE "tag_binary" (
+"tag_pk" serial NOT NULL,
+"binary_pk" serial NOT NULL
+) WITHOUT OIDS;
+
+DROP TABLE IF EXISTS "transitions" CASCADE;
+CREATE TABLE "transitions" (
+"transitions_pk" serial NOT NULL,
+"description" text NOT NULL,
+"bastard" text NOT NULL,
+"version" text NOT NULL,
+"package_pk" serial NOT NULL
+) WITHOUT OIDS;
+ALTER TABLE "transitions" ADD CONSTRAINT "transitions_pk" PRIMARY KEY("transitions_pk");
+
+DROP TABLE IF EXISTS "upload_restriction" CASCADE;
+CREATE TABLE "upload_restriction" (
+"upload_restriction_pk" serial NOT NULL,
+"fingerprint_pk" serial,
+"suite_pk" serial
+) WITHOUT OIDS;
+ALTER TABLE "upload_restriction" ADD CONSTRAINT "upload_restriction_pk" PRIMARY KEY("upload_restriction_pk");
+
+DROP TABLE IF EXISTS "transitions_upload_restrictions" CASCADE;
+CREATE TABLE "transitions_upload_restrictions" (
+"upload_restriction_pk" serial NOT NULL,
+"transitions_pk" serial NOT NULL
+) WITHOUT OIDS;
+
-- End Table's declaration
-- Start Relation's declaration
@@ -420,11 +462,11 @@ ALTER TABLE "source_suite" ADD CONSTRAINT "suite_source_suite_fkey" FOREIGN KEY
ALTER TABLE "source" DROP CONSTRAINT "component_source_fkey" CASCADE;
ALTER TABLE "source" ADD CONSTRAINT "component_source_fkey" FOREIGN KEY ("component_pk") REFERENCES "component"("component_pk") ON UPDATE RESTRICT ON DELETE RESTRICT;
-ALTER TABLE "source" DROP CONSTRAINT "section_source_fkey" CASCADE;
-ALTER TABLE "source" ADD CONSTRAINT "section_source_fkey" FOREIGN KEY ("section_pk") REFERENCES "section"("section_pk") ON UPDATE RESTRICT ON DELETE RESTRICT;
+ALTER TABLE "source" DROP CONSTRAINT "section_source_maintainer_fkey" CASCADE;
+ALTER TABLE "source" ADD CONSTRAINT "section_source_maintainer_fkey" FOREIGN KEY ("section_maintainer_pk") REFERENCES "section"("section_pk") ON UPDATE RESTRICT ON DELETE RESTRICT;
-ALTER TABLE "source" DROP CONSTRAINT "priority_source_fkey" CASCADE;
-ALTER TABLE "source" ADD CONSTRAINT "priority_source_fkey" FOREIGN KEY ("priority_pk") REFERENCES "priority"("priority_pk") ON UPDATE RESTRICT ON DELETE RESTRICT;
+ALTER TABLE "source" DROP CONSTRAINT "priority_source_maintainer_fkey" CASCADE;
+ALTER TABLE "source" ADD CONSTRAINT "priority_source_maintainer_fkey" FOREIGN KEY ("priority_maintainer_pk") REFERENCES "priority"("priority_pk") ON UPDATE RESTRICT ON DELETE RESTRICT;
ALTER TABLE "source" DROP CONSTRAINT "changes_source_fkey" CASCADE;
ALTER TABLE "source" ADD CONSTRAINT "changes_source_fkey" FOREIGN KEY ("changes_pk") REFERENCES "changes"("changes_pk") ON UPDATE RESTRICT ON DELETE RESTRICT;
@@ -453,11 +495,11 @@ ALTER TABLE "binary_suite" ADD CONSTRAINT "suite_binary_suite_fkey" FOREIGN KEY
ALTER TABLE "binary" DROP CONSTRAINT "architecture_binary_fkey" CASCADE;
ALTER TABLE "binary" ADD CONSTRAINT "architecture_binary_fkey" FOREIGN KEY ("architecture_pk") REFERENCES "architecture"("architecture_pk") ON UPDATE RESTRICT ON DELETE RESTRICT;
-ALTER TABLE "binary" DROP CONSTRAINT "section_binary_fkey" CASCADE;
-ALTER TABLE "binary" ADD CONSTRAINT "section_binary_fkey" FOREIGN KEY ("section_pk") REFERENCES "section"("section_pk") ON UPDATE RESTRICT ON DELETE RESTRICT;
+ALTER TABLE "binary" DROP CONSTRAINT "section_binary_maintainer_fkey" CASCADE;
+ALTER TABLE "binary" ADD CONSTRAINT "section_binary_maintainer_fkey" FOREIGN KEY ("section_maintainer_pk") REFERENCES "section"("section_pk") ON UPDATE RESTRICT ON DELETE RESTRICT;
-ALTER TABLE "binary" DROP CONSTRAINT "priority_binary_fkey" CASCADE;
-ALTER TABLE "binary" ADD CONSTRAINT "priority_binary_fkey" FOREIGN KEY ("priority_pk") REFERENCES "priority"("priority_pk") ON UPDATE RESTRICT ON DELETE RESTRICT;
+ALTER TABLE "binary" DROP CONSTRAINT "priority_binary_maintainer_fkey" CASCADE;
+ALTER TABLE "binary" ADD CONSTRAINT "priority_binary_maintainer_fkey" FOREIGN KEY ("priority_maintainer_pk") REFERENCES "priority"("priority_pk") ON UPDATE RESTRICT ON DELETE RESTRICT;
ALTER TABLE "binary" DROP CONSTRAINT "changes_binary_fkey" CASCADE;
ALTER TABLE "binary" ADD CONSTRAINT "changes_binary_fkey" FOREIGN KEY ("changes_pk") REFERENCES "changes"("changes_pk") ON UPDATE RESTRICT ON DELETE RESTRICT;
@@ -574,7 +616,40 @@ ALTER TABLE "restricted_uploads" DROP CONSTRAINT "package_restricted_uploads_fke
ALTER TABLE "restricted_uploads" ADD CONSTRAINT "package_restricted_uploads_fkey" FOREIGN KEY ("package_pk") REFERENCES "package"("package_pk") ON UPDATE RESTRICT ON DELETE RESTRICT;
ALTER TABLE "path" DROP CONSTRAINT "pathdir_path_fkey" CASCADE;
-ALTER TABLE "path" ADD CONSTRAINT "pathdir_path_fkey" FOREIGN KEY ("pathdir_pl") REFERENCES "pathdir"("pathdir_pl") ON UPDATE RESTRICT ON DELETE RESTRICT;
+ALTER TABLE "path" ADD CONSTRAINT "pathdir_path_fkey" FOREIGN KEY ("pathdir_pk") REFERENCES "pathdir"("pathdir_pk") ON UPDATE RESTRICT ON DELETE RESTRICT;
+
+ALTER TABLE "source" DROP CONSTRAINT "priority_source_fkey" CASCADE;
+ALTER TABLE "source" ADD CONSTRAINT "priority_source_fkey" FOREIGN KEY ("priority_pk") REFERENCES "priority"("priority_pk") ON UPDATE RESTRICT ON DELETE RESTRICT;
+
+ALTER TABLE "source" DROP CONSTRAINT "binary_source_fkey" CASCADE;
+ALTER TABLE "source" ADD CONSTRAINT "binary_source_fkey" FOREIGN KEY ("section_pk") REFERENCES "section"("section_pk") ON UPDATE RESTRICT ON DELETE RESTRICT;
+
+ALTER TABLE "binary" DROP CONSTRAINT "priority_binary_fkey" CASCADE;
+ALTER TABLE "binary" ADD CONSTRAINT "priority_binary_fkey" FOREIGN KEY ("priority_pk") REFERENCES "priority"("priority_pk") ON UPDATE RESTRICT ON DELETE RESTRICT;
+
+ALTER TABLE "binary" DROP CONSTRAINT "section_binary_fkey" CASCADE;
+ALTER TABLE "binary" ADD CONSTRAINT "section_binary_fkey" FOREIGN KEY ("section_pk") REFERENCES "section"("section_pk") ON UPDATE RESTRICT ON DELETE RESTRICT;
+
+ALTER TABLE "tag_binary" DROP CONSTRAINT "tag_tag_binary_fkey" CASCADE;
+ALTER TABLE "tag_binary" ADD CONSTRAINT "tag_tag_binary_fkey" FOREIGN KEY ("tag_pk") REFERENCES "tag"("tag_pk") ON UPDATE RESTRICT ON DELETE RESTRICT;
+
+ALTER TABLE "tag_binary" DROP CONSTRAINT "binary_tag_binary_fkey" CASCADE;
+ALTER TABLE "tag_binary" ADD CONSTRAINT "binary_tag_binary_fkey" FOREIGN KEY ("binary_pk") REFERENCES "binary"("binary_pk") ON UPDATE RESTRICT ON DELETE RESTRICT;
+
+ALTER TABLE "transitions" DROP CONSTRAINT "package_transitions_fkey" CASCADE;
+ALTER TABLE "transitions" ADD CONSTRAINT "package_transitions_fkey" FOREIGN KEY ("package_pk") REFERENCES "package"("package_pk") ON UPDATE RESTRICT ON DELETE RESTRICT;
+
+ALTER TABLE "upload_restriction" DROP CONSTRAINT "fingerprint_upload_restriction_fkey" CASCADE;
+ALTER TABLE "upload_restriction" ADD CONSTRAINT "fingerprint_upload_restriction_fkey" FOREIGN KEY ("fingerprint_pk") REFERENCES "fingerprint"("fingerprint_pk") ON UPDATE RESTRICT ON DELETE RESTRICT;
+
+ALTER TABLE "upload_restriction" DROP CONSTRAINT "suite_upload_restriction_fkey" CASCADE;
+ALTER TABLE "upload_restriction" ADD CONSTRAINT "suite_upload_restriction_fkey" FOREIGN KEY ("suite_pk") REFERENCES "suite"("suite_pk") ON UPDATE RESTRICT ON DELETE RESTRICT;
+
+ALTER TABLE "transitions_upload_restrictions" DROP CONSTRAINT "upload_restriction_transitions_upload_restrictions_fkey" CASCADE;
+ALTER TABLE "transitions_upload_restrictions" ADD CONSTRAINT "upload_restriction_transitions_upload_restrictions_fkey" FOREIGN KEY ("upload_restriction_pk") REFERENCES "upload_restriction"("upload_restriction_pk") ON UPDATE RESTRICT ON DELETE RESTRICT;
+
+ALTER TABLE "transitions_upload_restrictions" DROP CONSTRAINT "transitions_transitions_upload_restrictions_fkey" CASCADE;
+ALTER TABLE "transitions_upload_restrictions" ADD CONSTRAINT "transitions_transitions_upload_restrictions_fkey" FOREIGN KEY ("transitions_pk") REFERENCES "transitions"("transitions_pk") ON UPDATE RESTRICT ON DELETE RESTRICT;
-- End Relation's declaration
--
1.5.6.5
Reply to: