[newdak/master] add a missing field
Signed-off-by: Joerg Jaspert <joerg@debian.org>
---
sql/dakv2try2.ini | 479 +++++++++++++++++++++++++++--------------------------
sql/dakv2try2.sql | 5 +-
2 files changed, 243 insertions(+), 241 deletions(-)
diff --git a/sql/dakv2try2.ini b/sql/dakv2try2.ini
index b202ae3..5413e56 100644
--- a/sql/dakv2try2.ini
+++ b/sql/dakv2try2.ini
@@ -19,17 +19,17 @@ Stamp=1
Name="dakv2 try2"
Page="A4"
Orientation=0
-Revision=11/25/2008 18:26:23.977
+Revision=11/27/2008 19:00:15.496
Driver="8.3"
Author="joerg"
Display=0
[RELATION_0]
Name="archive_suite_fkey"
-X1=126
-Y1=107
+X1=147
+Y1=113
X2=149
-Y2=120
+Y2=130
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -43,10 +43,10 @@ OnDelete="RESTRICT"
[RELATION_1]
Name="component_suite_component_fkey"
-X1=131
-Y1=174
+X1=155
+Y1=180
X2=63
-Y2=271
+Y2=277
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -60,10 +60,10 @@ OnDelete="RESTRICT"
[RELATION_10]
Name="suite_source_suite_fkey"
-X1=247
-Y1=106
+X1=267
+Y1=112
X2=286
-Y2=281
+Y2=291
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -77,10 +77,10 @@ OnDelete="RESTRICT"
[RELATION_11]
Name="component_source_fkey"
-X1=131
-Y1=174
+X1=155
+Y1=180
X2=303
-Y2=352
+Y2=362
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -94,10 +94,10 @@ OnDelete="RESTRICT"
[RELATION_12]
Name="section_source_fkey"
-X1=113
-Y1=353
+X1=129
+Y1=359
X2=303
-Y2=366
+Y2=380
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -111,10 +111,10 @@ OnDelete="RESTRICT"
[RELATION_13]
Name="priority_source_fkey"
-X1=219
-Y1=352
+X1=241
+Y1=358
X2=303
-Y2=380
+Y2=398
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -128,10 +128,10 @@ OnDelete="RESTRICT"
[RELATION_14]
Name="changes_source_fkey"
-X1=602
-Y1=238
+X1=630
+Y1=244
X2=303
-Y2=394
+Y2=416
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -145,10 +145,10 @@ OnDelete="RESTRICT"
[RELATION_15]
Name="source_binary_set_fkey"
-X1=443
-Y1=338
+X1=475
+Y1=344
X2=500
-Y2=434
+Y2=444
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -162,10 +162,10 @@ OnDelete="RESTRICT"
[RELATION_16]
Name="source_source_mirrorfile_fkey"
-X1=443
-Y1=338
+X1=475
+Y1=344
X2=97
-Y2=436
+Y2=442
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -179,10 +179,10 @@ OnDelete="RESTRICT"
[RELATION_17]
Name="mirrorfile_source_mirrorfile_fkey"
-X1=398
-Y1=487
+X1=424
+Y1=493
X2=97
-Y2=450
+Y2=460
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -196,10 +196,10 @@ OnDelete="RESTRICT"
[RELATION_18]
Name="binary_set_binary_set_binary_fkey"
-X1=621
-Y1=420
+X1=647
+Y1=426
X2=684
-Y2=272
+Y2=278
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -213,10 +213,10 @@ OnDelete="RESTRICT"
[RELATION_19]
Name="binary_binary_set_binary_fkey"
-X1=856
-Y1=90
+X1=936
+Y1=104
X2=684
-Y2=286
+Y2=296
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -230,10 +230,10 @@ OnDelete="RESTRICT"
[RELATION_2]
Name="suite_suite_component_fkey"
-X1=247
-Y1=106
+X1=267
+Y1=112
X2=63
-Y2=285
+Y2=295
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -247,10 +247,10 @@ OnDelete="RESTRICT"
[RELATION_20]
Name="binary_binary_suite_fkey"
-X1=856
-Y1=90
+X1=936
+Y1=104
X2=333
-Y2=189
+Y2=195
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -264,10 +264,10 @@ OnDelete="RESTRICT"
[RELATION_21]
Name="suite_binary_suite_fkey"
-X1=247
-Y1=106
+X1=267
+Y1=112
X2=333
-Y2=203
+Y2=213
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -281,10 +281,10 @@ OnDelete="RESTRICT"
[RELATION_22]
Name="architecture_binary_fkey"
-X1=641
-Y1=30
-X2=716
-Y2=104
+X1=670
+Y1=36
+X2=764
+Y2=122
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -298,10 +298,10 @@ OnDelete="RESTRICT"
[RELATION_23]
Name="section_binary_fkey"
-X1=113
-Y1=353
-X2=716
-Y2=118
+X1=129
+Y1=359
+X2=764
+Y2=140
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -315,10 +315,10 @@ OnDelete="RESTRICT"
[RELATION_24]
Name="priority_binary_fkey"
-X1=219
-Y1=352
-X2=716
-Y2=132
+X1=241
+Y1=358
+X2=764
+Y2=158
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -332,10 +332,10 @@ OnDelete="RESTRICT"
[RELATION_25]
Name="changes_binary_fkey"
-X1=602
-Y1=238
-X2=716
-Y2=146
+X1=630
+Y1=244
+X2=764
+Y2=176
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -349,10 +349,10 @@ OnDelete="RESTRICT"
[RELATION_26]
Name="binary_binary_mirrorfile_fkey"
-X1=856
-Y1=90
+X1=936
+Y1=104
X2=465
-Y2=495
+Y2=501
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -366,10 +366,10 @@ OnDelete="RESTRICT"
[RELATION_27]
Name="mirrorfile_binary_mirrorfile_fkey"
-X1=398
-Y1=487
+X1=424
+Y1=493
X2=465
-Y2=509
+Y2=519
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -383,10 +383,10 @@ OnDelete="RESTRICT"
[RELATION_28]
Name="description_binary_fkey"
-X1=1036
-Y1=38
-X2=716
-Y2=160
+X1=1154
+Y1=40
+X2=764
+Y2=194
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -400,10 +400,10 @@ OnDelete="RESTRICT"
[RELATION_29]
Name="checksum_mirrorfile_checksum_fkey"
-X1=216
-Y1=544
+X1=235
+Y1=550
X2=247
-Y2=648
+Y2=658
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -417,10 +417,10 @@ OnDelete="RESTRICT"
[RELATION_3]
Name="location_suite_component_fkey"
-X1=385
-Y1=103
+X1=411
+Y1=109
X2=63
-Y2=299
+Y2=313
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -434,10 +434,10 @@ OnDelete="RESTRICT"
[RELATION_30]
Name="mirrorfile_mirrorfile_checksum_fkey"
-X1=398
-Y1=487
+X1=424
+Y1=493
X2=247
-Y2=634
+Y2=640
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -451,10 +451,10 @@ OnDelete="RESTRICT"
[RELATION_31]
Name="mirrorfile_mirrorfile_location_fkey"
-X1=398
-Y1=487
+X1=424
+Y1=493
X2=508
-Y2=559
+Y2=565
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -468,10 +468,10 @@ OnDelete="RESTRICT"
[RELATION_32]
Name="location_mirrorfile_location_fkey"
-X1=385
-Y1=103
+X1=411
+Y1=109
X2=508
-Y2=573
+Y2=583
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -485,10 +485,10 @@ OnDelete="RESTRICT"
[RELATION_33]
Name="queue_mirrorfile_fkey"
-X1=480
-Y1=30
+X1=495
+Y1=36
X2=279
-Y2=501
+Y2=511
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -502,10 +502,10 @@ OnDelete="RESTRICT"
[RELATION_34]
Name="type_mirrorfile_fkey"
-X1=142
-Y1=710
+X1=157
+Y1=716
X2=279
-Y2=515
+Y2=529
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -519,10 +519,10 @@ OnDelete="RESTRICT"
[RELATION_35]
Name="mirrorfile_mirrorfile_path_fkey"
-X1=398
-Y1=487
+X1=424
+Y1=493
X2=244
-Y2=748
+Y2=758
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -536,10 +536,10 @@ OnDelete="RESTRICT"
[RELATION_36]
Name="path_mirrorfile_path_fkey"
-X1=516
-Y1=683
+X1=529
+Y1=689
X2=244
-Y2=762
+Y2=776
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -553,10 +553,10 @@ OnDelete="RESTRICT"
[RELATION_37]
Name="mirrorfile_path_mirrorfile_path_checksum_fkey"
-X1=398
-Y1=734
+X1=434
+Y1=740
X2=0
-Y2=640
+Y2=650
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -570,10 +570,10 @@ OnDelete="RESTRICT"
[RELATION_38]
Name="checksum_mirrorfile_path_checksum_fkey"
-X1=216
-Y1=544
+X1=235
+Y1=550
X2=0
-Y2=626
+Y2=632
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -587,10 +587,10 @@ OnDelete="RESTRICT"
[RELATION_39]
Name="language_translations_fkey"
-X1=1171
-Y1=37
-X2=911
-Y2=130
+X1=1335
+Y1=65
+X2=984
+Y2=188
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -604,10 +604,10 @@ OnDelete="RESTRICT"
[RELATION_4]
Name="visibility_location_fkey"
-X1=364
-Y1=30
+X1=390
+Y1=36
X2=266
-Y2=131
+Y2=145
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -621,10 +621,10 @@ OnDelete="RESTRICT"
[RELATION_40]
Name="description_translations_fkey"
-X1=1036
-Y1=38
-X2=911
-Y2=144
+X1=1154
+Y1=40
+X2=984
+Y2=206
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -638,10 +638,10 @@ OnDelete="RESTRICT"
[RELATION_41]
Name="fingerprint_changes_fkey"
-X1=1018
-Y1=271
+X1=1254
+Y1=288
X2=476
-Y2=252
+Y2=262
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -655,10 +655,10 @@ OnDelete="RESTRICT"
[RELATION_42]
Name="fingerprint_fingerprint_maintainer_fkey"
-X1=1018
-Y1=271
+X1=1254
+Y1=288
X2=905
-Y2=353
+Y2=359
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -672,10 +672,10 @@ OnDelete="RESTRICT"
[RELATION_43]
Name="maintainer_fingerprint_maintainer_fkey"
-X1=818
-Y1=341
+X1=846
+Y1=347
X2=905
-Y2=367
+Y2=377
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -689,10 +689,10 @@ OnDelete="RESTRICT"
[RELATION_44]
Name="fingerprint_fingerprint_keyring_fkey"
-X1=1018
-Y1=271
-X2=1047
-Y2=223
+X1=1254
+Y1=288
+X2=1287
+Y2=252
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -706,10 +706,10 @@ OnDelete="RESTRICT"
[RELATION_45]
Name="keyring_fingerprint_keyring_fkey"
-X1=1188
-Y1=123
-X2=1047
-Y2=237
+X1=1435
+Y1=453
+X2=1287
+Y2=270
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -723,10 +723,10 @@ OnDelete="RESTRICT"
[RELATION_46]
Name="maintainer_uid_fkey"
-X1=818
-Y1=341
+X1=846
+Y1=347
X2=688
-Y2=469
+Y2=483
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -740,15 +740,15 @@ OnDelete="RESTRICT"
[RELATION_47]
Name="package_binary_fkey"
-X1=1002
-Y1=447
-X2=716
-Y2=174
+X1=1064
+Y1=459
+X2=764
+Y2=212
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
ColorMiddlePoint="255,0,0"
-ColorEndPoint="0,-1,0"
+ColorEndPoint="0,255,0"
Table1="package"
Table2="binary"
Relation_0="package_pk,package_pk"
@@ -757,15 +757,15 @@ OnDelete="RESTRICT"
[RELATION_48]
Name="package_source_fkey"
-X1=1002
-Y1=447
+X1=1064
+Y1=459
X2=303
-Y2=408
+Y2=434
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
ColorMiddlePoint="255,0,0"
-ColorEndPoint="0,-1,0"
+ColorEndPoint="0,255,0"
Table1="package"
Table2="source"
Relation_0="package_pk,package_pk"
@@ -774,15 +774,15 @@ OnDelete="RESTRICT"
[RELATION_49]
Name="source_format_source_fkey"
-X1=718
-Y1=646
+X1=750
+Y1=652
X2=303
-Y2=436
+Y2=470
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
ColorMiddlePoint="255,0,0"
-ColorEndPoint="0,-1,0"
+ColorEndPoint="0,255,0"
Table1="source_format"
Table2="source"
Relation_0="source_format_pk,source_format_pk"
@@ -791,10 +791,10 @@ OnDelete="RESTRICT"
[RELATION_5]
Name="queue_queue_location_fkey"
-X1=480
-Y1=30
+X1=495
+Y1=36
X2=411
-Y2=99
+Y2=105
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -808,15 +808,15 @@ OnDelete="RESTRICT"
[RELATION_50]
Name="binary_format_binary_fkey"
-X1=832
-Y1=34
-X2=716
-Y2=216
+X1=869
+Y1=40
+X2=764
+Y2=266
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
ColorMiddlePoint="255,0,0"
-ColorEndPoint="0,-1,0"
+ColorEndPoint="0,255,0"
Table1="binary_format"
Table2="binary"
Relation_0="binary_format_pk,binary_format_pk"
@@ -825,15 +825,15 @@ OnDelete="RESTRICT"
[RELATION_51]
Name="changes_format_changes_fkey"
-X1=707
-Y1=179
+X1=740
+Y1=185
X2=476
-Y2=266
+Y2=280
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
ColorMiddlePoint="255,0,0"
-ColorEndPoint="0,-1,0"
+ColorEndPoint="0,255,0"
Table1="changes_format"
Table2="changes"
Relation_0="changes_format,changes_format"
@@ -842,15 +842,15 @@ OnDelete="RESTRICT"
[RELATION_52]
Name="binary_binary_metadata_fkey"
-X1=856
-Y1=90
-X2=857
-Y2=529
+X1=936
+Y1=104
+X2=1109
+Y2=527
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
ColorMiddlePoint="255,0,0"
-ColorEndPoint="0,-1,0"
+ColorEndPoint="0,255,0"
Table1="binary"
Table2="binary_metadata"
Relation_0="binary_pk,binary_pk"
@@ -859,15 +859,15 @@ OnDelete="RESTRICT"
[RELATION_53]
Name="metadata_binary_metadata_fkey"
-X1=1005
-Y1=639
-X2=857
-Y2=543
+X1=1399
+Y1=742
+X2=1109
+Y2=545
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
ColorMiddlePoint="255,0,0"
-ColorEndPoint="0,-1,0"
+ColorEndPoint="0,255,0"
Table1="metadata"
Table2="binary_metadata"
Relation_0="metadata_pk,metadata_pk"
@@ -876,15 +876,15 @@ OnDelete="RESTRICT"
[RELATION_54]
Name="source_source_metadata_fkey"
-X1=443
-Y1=338
+X1=475
+Y1=344
X2=559
-Y2=747
+Y2=753
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
ColorMiddlePoint="255,0,0"
-ColorEndPoint="0,-1,0"
+ColorEndPoint="0,255,0"
Table1="source"
Table2="source_metadata"
Relation_0="source_pk,source_pk"
@@ -893,15 +893,15 @@ OnDelete="RESTRICT"
[RELATION_55]
Name="metadata_source_metadata_fkey"
-X1=1005
-Y1=639
+X1=1399
+Y1=742
X2=559
-Y2=761
+Y2=771
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
ColorMiddlePoint="255,0,0"
-ColorEndPoint="0,-1,0"
+ColorEndPoint="0,255,0"
Table1="metadata"
Table2="source_metadata"
Relation_0="metadata_pk,metadata_pk"
@@ -910,15 +910,15 @@ OnDelete="RESTRICT"
[RELATION_56]
Name="urgency_changes_fkey"
-X1=830
-Y1=560
+X1=851
+Y1=566
X2=476
-Y2=308
+Y2=334
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
ColorMiddlePoint="255,0,0"
-ColorEndPoint="0,-1,0"
+ColorEndPoint="0,255,0"
Table1="urgency"
Table2="changes"
Relation_0="urgency_pk,urgency_pk"
@@ -927,15 +927,15 @@ OnDelete="RESTRICT"
[RELATION_57]
Name="changedby_changes_fkey"
-X1=818
-Y1=341
+X1=846
+Y1=347
X2=476
-Y2=350
+Y2=388
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
ColorMiddlePoint="255,0,0"
-ColorEndPoint="0,-1,0"
+ColorEndPoint="0,255,0"
Table1="maintainer"
Table2="changes"
Relation_0="maintainer_pk,changedby_pk"
@@ -944,15 +944,15 @@ OnDelete="RESTRICT"
[RELATION_58]
Name="maintainer_changes_fkey"
-X1=818
-Y1=341
+X1=846
+Y1=347
X2=476
-Y2=364
+Y2=406
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
ColorMiddlePoint="255,0,0"
-ColorEndPoint="0,-1,0"
+ColorEndPoint="0,255,0"
Table1="maintainer"
Table2="changes"
Relation_0="maintainer_pk,maintainer_pk"
@@ -961,15 +961,15 @@ OnDelete="RESTRICT"
[RELATION_59]
Name="maintainer_source_uploaders_fkey"
-X1=818
-Y1=341
+X1=846
+Y1=347
X2=400
-Y2=808
+Y2=814
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
ColorMiddlePoint="255,0,0"
-ColorEndPoint="0,-1,0"
+ColorEndPoint="0,255,0"
Table1="maintainer"
Table2="source_uploaders"
Relation_0="maintainer_pk,maintainer_pk"
@@ -978,10 +978,10 @@ OnDelete="RESTRICT"
[RELATION_6]
Name="location_queue_location_fkey"
-X1=385
-Y1=103
+X1=411
+Y1=109
X2=411
-Y2=113
+Y2=123
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -995,15 +995,15 @@ OnDelete="RESTRICT"
[RELATION_60]
Name="source_source_uploaders_fkey"
-X1=443
-Y1=338
+X1=475
+Y1=344
X2=400
-Y2=822
+Y2=832
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
ColorMiddlePoint="255,0,0"
-ColorEndPoint="0,-1,0"
+ColorEndPoint="0,255,0"
Table1="source"
Table2="source_uploaders"
Relation_0="source_pk,source_pk"
@@ -1012,15 +1012,15 @@ OnDelete="RESTRICT"
[RELATION_61]
Name="fingerprint_restricted_uploads_fkey"
-X1=1018
-Y1=271
+X1=1254
+Y1=288
X2=791
-Y2=749
+Y2=755
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
ColorMiddlePoint="255,0,0"
-ColorEndPoint="0,-1,0"
+ColorEndPoint="0,255,0"
Table1="fingerprint"
Table2="restricted_uploads"
Relation_0="fingerprint_pk,fingerprint_pk"
@@ -1029,15 +1029,15 @@ OnDelete="RESTRICT"
[RELATION_62]
Name="package_restricted_uploads_fkey"
-X1=1002
-Y1=447
+X1=1064
+Y1=459
X2=791
-Y2=763
+Y2=773
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
ColorMiddlePoint="255,0,0"
-ColorEndPoint="0,-1,0"
+ColorEndPoint="0,255,0"
Table1="package"
Table2="restricted_uploads"
Relation_0="package_pk,package_pk"
@@ -1046,10 +1046,10 @@ OnDelete="RESTRICT"
[RELATION_7]
Name="queue_suite_queue_fkey"
-X1=480
-Y1=30
+X1=495
+Y1=36
X2=152
-Y2=198
+Y2=204
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -1063,10 +1063,10 @@ OnDelete="RESTRICT"
[RELATION_8]
Name="suite_suite_queue_fkey"
-X1=247
-Y1=106
+X1=267
+Y1=112
X2=152
-Y2=212
+Y2=222
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -1080,10 +1080,10 @@ OnDelete="RESTRICT"
[RELATION_9]
Name="source_source_suite_fkey"
-X1=443
-Y1=338
+X1=475
+Y1=344
X2=286
-Y2=267
+Y2=273
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -1247,8 +1247,8 @@ Field_1="mirrorfile_pk||T||0|true|false|serial||"
[TABLE_17]
Name="binary"
-X=716
-Y=60
+X=764
+Y=68
ColorBack="230,230,230"
ColorText="0,0,0"
ColorBackTitle="230,230,230"
@@ -1344,8 +1344,8 @@ Field_1="mirrorfile_pk||T||0|true|false|serial||"
[TABLE_22]
Name="description"
-X=908
-Y=8
+X=1000
+Y=4
ColorBack="230,230,230"
ColorText="0,0,0"
ColorBackTitle="230,230,230"
@@ -1479,8 +1479,8 @@ Index_0="suite_component_unique||true|component_pk,suite_pk"
[TABLE_30]
Name="language"
-X=1056
-Y=7
+X=1199
+Y=29
ColorBack="230,230,230"
ColorText="0,0,0"
ColorBackTitle="230,230,230"
@@ -1495,8 +1495,8 @@ Field_2="iso_code||T||0|true|false|text||"
[TABLE_31]
Name="translations"
-X=911
-Y=86
+X=984
+Y=134
ColorBack="230,230,230"
ColorText="0,0,0"
ColorBackTitle="230,230,230"
@@ -1508,11 +1508,12 @@ PrimaryKey="translations_pk"
Field_0="translations_pk||T||0|true|true|serial||"
Field_1="language_pk||T||0|true|false|serial||"
Field_2="description_pk||T||0|true|false|serial||"
+Field_3="description||T||0|true|false|text||"
[TABLE_32]
Name="fingerprint"
-X=892
-Y=241
+X=1100
+Y=252
ColorBack="230,230,230"
ColorText="0,0,0"
ColorBackTitle="230,230,230"
@@ -1555,8 +1556,8 @@ Field_1="maintainer_pk||T||0|true|false|serial||"
[TABLE_35]
Name="keyring"
-X=1087
-Y=93
+X=1312
+Y=417
ColorBack="230,230,230"
ColorText="0,0,0"
ColorBackTitle="230,230,230"
@@ -1571,8 +1572,8 @@ Field_2="restricted||T|false|0|true|false|bool||"
[TABLE_36]
Name="fingerprint_keyring"
-X=1047
-Y=193
+X=1287
+Y=216
ColorBack="230,230,230"
ColorText="0,0,0"
ColorBackTitle="230,230,230"
@@ -1601,8 +1602,8 @@ Field_2="maintainer_pk||T||0|true|false|serial||"
[TABLE_38]
Name="package"
-X=892
-Y=417
+X=936
+Y=423
ColorBack="230,230,230"
ColorText="0,0,0"
ColorBackTitle="230,230,230"
@@ -1678,8 +1679,8 @@ Field_1="version||T||0|true|false|text||"
[TABLE_42]
Name="metadata"
-X=889
-Y=609
+X=1260
+Y=706
ColorBack="230,230,230"
ColorText="0,0,0"
ColorBackTitle="230,230,230"
@@ -1693,8 +1694,8 @@ Field_1="metadata||T||0|true|false|text||"
[TABLE_43]
Name="binary_metadata"
-X=857
-Y=499
+X=1109
+Y=491
ColorBack="230,230,230"
ColorText="0,0,0"
ColorBackTitle="230,230,230"
diff --git a/sql/dakv2try2.sql b/sql/dakv2try2.sql
index 9b9bf38..6cada19 100644
--- a/sql/dakv2try2.sql
+++ b/sql/dakv2try2.sql
@@ -2,7 +2,7 @@
-- pgDesigner 1.2.7
--
-- Project : dakv2 try2
--- Date : 11/25/2008 18:27:16.987
+-- Date : 11/27/2008 19:00:24.852
-- Description:
------------------------------
@@ -257,7 +257,8 @@ DROP TABLE IF EXISTS "translations" CASCADE;
CREATE TABLE "translations" (
"translations_pk" serial NOT NULL,
"language_pk" serial NOT NULL,
-"description_pk" serial NOT NULL
+"description_pk" serial NOT NULL,
+"description" text NOT NULL
) WITHOUT OIDS;
ALTER TABLE "translations" ADD CONSTRAINT "translations_pk" PRIMARY KEY("translations_pk");
--
1.5.6.5
Reply to: