[newdak/master] Added pathdir
Signed-off-by: Joerg Jaspert <joerg@debian.org>
---
sql/dakv2try2.ini | 450 ++++++++++++++++++++++++++++------------------------
sql/dakv2try2.sql | 16 ++-
2 files changed, 256 insertions(+), 210 deletions(-)
diff --git a/sql/dakv2try2.ini b/sql/dakv2try2.ini
index 5413e56..6027eff 100644
--- a/sql/dakv2try2.ini
+++ b/sql/dakv2try2.ini
@@ -8,18 +8,18 @@ Domain=0
Procedure=0
Sequence=0
View=0
-Table=48
+Table=49
Trigger=0
Tablespace=0
Text=0
-Relation=63
+Relation=64
Stamp=1
[PROJECT]
Name="dakv2 try2"
Page="A4"
Orientation=0
-Revision=11/27/2008 19:00:15.496
+Revision=11/28/2008 11:44:10.704
Driver="8.3"
Author="joerg"
Display=0
@@ -128,8 +128,8 @@ OnDelete="RESTRICT"
[RELATION_14]
Name="changes_source_fkey"
-X1=630
-Y1=244
+X1=708
+Y1=243
X2=303
Y2=416
ColorLine="192,192,192"
@@ -179,8 +179,8 @@ OnDelete="RESTRICT"
[RELATION_17]
Name="mirrorfile_source_mirrorfile_fkey"
-X1=424
-Y1=493
+X1=373
+Y1=541
X2=97
Y2=460
ColorLine="192,192,192"
@@ -198,8 +198,8 @@ OnDelete="RESTRICT"
Name="binary_set_binary_set_binary_fkey"
X1=647
Y1=426
-X2=684
-Y2=278
+X2=812
+Y2=322
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=936
-Y1=104
-X2=684
-Y2=296
+X1=1082
+Y1=109
+X2=812
+Y2=340
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -247,8 +247,8 @@ OnDelete="RESTRICT"
[RELATION_20]
Name="binary_binary_suite_fkey"
-X1=936
-Y1=104
+X1=1082
+Y1=109
X2=333
Y2=195
ColorLine="192,192,192"
@@ -283,8 +283,8 @@ OnDelete="RESTRICT"
Name="architecture_binary_fkey"
X1=670
Y1=36
-X2=764
-Y2=122
+X2=910
+Y2=127
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -300,8 +300,8 @@ OnDelete="RESTRICT"
Name="section_binary_fkey"
X1=129
Y1=359
-X2=764
-Y2=140
+X2=910
+Y2=145
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -317,8 +317,8 @@ OnDelete="RESTRICT"
Name="priority_binary_fkey"
X1=241
Y1=358
-X2=764
-Y2=158
+X2=910
+Y2=163
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=630
-Y1=244
-X2=764
-Y2=176
+X1=708
+Y1=243
+X2=910
+Y2=181
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -349,8 +349,8 @@ OnDelete="RESTRICT"
[RELATION_26]
Name="binary_binary_mirrorfile_fkey"
-X1=936
-Y1=104
+X1=1082
+Y1=109
X2=465
Y2=501
ColorLine="192,192,192"
@@ -366,8 +366,8 @@ OnDelete="RESTRICT"
[RELATION_27]
Name="mirrorfile_binary_mirrorfile_fkey"
-X1=424
-Y1=493
+X1=373
+Y1=541
X2=465
Y2=519
ColorLine="192,192,192"
@@ -383,10 +383,10 @@ OnDelete="RESTRICT"
[RELATION_28]
Name="description_binary_fkey"
-X1=1154
-Y1=40
-X2=764
-Y2=194
+X1=1337
+Y1=36
+X2=910
+Y2=199
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=235
-Y1=550
-X2=247
-Y2=658
+X1=162
+Y1=565
+X2=426
+Y2=663
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=424
-Y1=493
-X2=247
-Y2=640
+X1=373
+Y1=541
+X2=426
+Y2=645
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=424
-Y1=493
-X2=508
-Y2=565
+X1=373
+Y1=541
+X2=489
+Y2=569
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -470,8 +470,8 @@ OnDelete="RESTRICT"
Name="location_mirrorfile_location_fkey"
X1=411
Y1=109
-X2=508
-Y2=583
+X2=489
+Y2=587
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -487,8 +487,8 @@ OnDelete="RESTRICT"
Name="queue_mirrorfile_fkey"
X1=495
Y1=36
-X2=279
-Y2=511
+X2=228
+Y2=559
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=157
-Y1=716
-X2=279
-Y2=529
+X1=102
+Y1=794
+X2=228
+Y2=577
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=424
-Y1=493
-X2=244
-Y2=758
+X1=373
+Y1=541
+X2=458
+Y2=817
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=529
-Y1=689
-X2=244
-Y2=776
+X1=276
+Y1=870
+X2=458
+Y2=835
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=434
-Y1=740
-X2=0
-Y2=650
+X1=648
+Y1=799
+X2=19
+Y2=727
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=235
-Y1=550
-X2=0
-Y2=632
+X1=162
+Y1=565
+X2=19
+Y2=709
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=1335
-Y1=65
-X2=984
-Y2=188
+X1=1515
+Y1=36
+X2=1158
+Y2=132
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=1154
-Y1=40
-X2=984
-Y2=206
+X1=1337
+Y1=36
+X2=1158
+Y2=150
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=1254
-Y1=288
-X2=476
-Y2=262
+X1=1515
+Y1=130
+X2=554
+Y2=261
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=1254
-Y1=288
-X2=905
-Y2=359
+X1=1515
+Y1=130
+X2=1221
+Y2=388
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=846
-Y1=347
-X2=905
-Y2=377
+X1=1321
+Y1=294
+X2=1221
+Y2=406
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=1254
-Y1=288
-X2=1287
-Y2=252
+X1=1515
+Y1=130
+X2=1298
+Y2=220
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=1435
-Y1=453
-X2=1287
-Y2=270
+X1=1525
+Y1=283
+X2=1298
+Y2=238
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=846
-Y1=347
-X2=688
-Y2=483
+X1=1321
+Y1=294
+X2=1093
+Y2=492
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -740,10 +740,10 @@ OnDelete="RESTRICT"
[RELATION_47]
Name="package_binary_fkey"
-X1=1064
-Y1=459
-X2=764
-Y2=212
+X1=978
+Y1=412
+X2=910
+Y2=217
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -757,8 +757,8 @@ OnDelete="RESTRICT"
[RELATION_48]
Name="package_source_fkey"
-X1=1064
-Y1=459
+X1=978
+Y1=412
X2=303
Y2=434
ColorLine="192,192,192"
@@ -774,8 +774,8 @@ OnDelete="RESTRICT"
[RELATION_49]
Name="source_format_source_fkey"
-X1=750
-Y1=652
+X1=874
+Y1=656
X2=303
Y2=470
ColorLine="192,192,192"
@@ -808,10 +808,10 @@ OnDelete="RESTRICT"
[RELATION_50]
Name="binary_format_binary_fkey"
-X1=869
-Y1=40
-X2=764
-Y2=266
+X1=990
+Y1=39
+X2=910
+Y2=271
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -825,10 +825,10 @@ OnDelete="RESTRICT"
[RELATION_51]
Name="changes_format_changes_fkey"
-X1=740
-Y1=185
-X2=476
-Y2=280
+X1=787
+Y1=157
+X2=554
+Y2=279
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -842,10 +842,10 @@ OnDelete="RESTRICT"
[RELATION_52]
Name="binary_binary_metadata_fkey"
-X1=936
-Y1=104
-X2=1109
-Y2=527
+X1=1082
+Y1=109
+X2=853
+Y2=518
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -861,8 +861,8 @@ OnDelete="RESTRICT"
Name="metadata_binary_metadata_fkey"
X1=1399
Y1=742
-X2=1109
-Y2=545
+X2=853
+Y2=536
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -878,8 +878,8 @@ OnDelete="RESTRICT"
Name="source_source_metadata_fkey"
X1=475
Y1=344
-X2=559
-Y2=753
+X2=881
+Y2=765
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -895,8 +895,8 @@ OnDelete="RESTRICT"
Name="metadata_source_metadata_fkey"
X1=1399
Y1=742
-X2=559
-Y2=771
+X2=881
+Y2=783
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -912,8 +912,8 @@ OnDelete="RESTRICT"
Name="urgency_changes_fkey"
X1=851
Y1=566
-X2=476
-Y2=334
+X2=554
+Y2=333
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -927,10 +927,10 @@ OnDelete="RESTRICT"
[RELATION_57]
Name="changedby_changes_fkey"
-X1=846
-Y1=347
-X2=476
-Y2=388
+X1=1321
+Y1=294
+X2=554
+Y2=387
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -944,10 +944,10 @@ OnDelete="RESTRICT"
[RELATION_58]
Name="maintainer_changes_fkey"
-X1=846
-Y1=347
-X2=476
-Y2=406
+X1=1321
+Y1=294
+X2=554
+Y2=405
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -961,10 +961,10 @@ OnDelete="RESTRICT"
[RELATION_59]
Name="maintainer_source_uploaders_fkey"
-X1=846
-Y1=347
-X2=400
-Y2=814
+X1=1321
+Y1=294
+X2=699
+Y2=813
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -997,8 +997,8 @@ OnDelete="RESTRICT"
Name="source_source_uploaders_fkey"
X1=475
Y1=344
-X2=400
-Y2=832
+X2=699
+Y2=831
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -1012,10 +1012,10 @@ OnDelete="RESTRICT"
[RELATION_61]
Name="fingerprint_restricted_uploads_fkey"
-X1=1254
-Y1=288
-X2=791
-Y2=755
+X1=1515
+Y1=130
+X2=887
+Y2=625
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -1029,10 +1029,10 @@ OnDelete="RESTRICT"
[RELATION_62]
Name="package_restricted_uploads_fkey"
-X1=1064
-Y1=459
-X2=791
-Y2=773
+X1=978
+Y1=412
+X2=887
+Y2=643
ColorLine="192,192,192"
ColorLineSelected="255,0,0"
ColorStartPoint="255,0,0"
@@ -1044,6 +1044,23 @@ Relation_0="package_pk,package_pk"
OnUpdate="RESTRICT"
OnDelete="RESTRICT"
+[RELATION_63]
+Name="pathdir_path_fkey"
+X1=586
+Y1=922
+X2=158
+Y2=906
+ColorLine="192,192,192"
+ColorLineSelected="255,0,0"
+ColorStartPoint="255,0,0"
+ColorMiddlePoint="255,0,0"
+ColorEndPoint="0,255,0"
+Table1="pathdir"
+Table2="path"
+Relation_0="pathdir_pk,pathdir_pk"
+OnUpdate="RESTRICT"
+OnDelete="RESTRICT"
+
[RELATION_7]
Name="queue_suite_queue_fkey"
X1=495
@@ -1176,8 +1193,8 @@ Field_1="priority||T||0|true|false|text||"
[TABLE_13]
Name="changes"
-X=476
-Y=208
+X=554
+Y=207
ColorBack="230,230,230"
ColorText="0,0,0"
ColorBackTitle="230,230,230"
@@ -1215,8 +1232,8 @@ Field_2="binrev||T|0|0|true|false|bigint||"
[TABLE_15]
Name="mirrorfile"
-X=279
-Y=457
+X=228
+Y=505
ColorBack="230,230,230"
ColorText="0,0,0"
ColorBackTitle="230,230,230"
@@ -1247,8 +1264,8 @@ Field_1="mirrorfile_pk||T||0|true|false|serial||"
[TABLE_17]
Name="binary"
-X=764
-Y=68
+X=910
+Y=73
ColorBack="230,230,230"
ColorText="0,0,0"
ColorBackTitle="230,230,230"
@@ -1270,8 +1287,8 @@ Field_9="binary_format_pk||T||0|true|false|serial||"
[TABLE_18]
Name="binary_set_binary"
-X=684
-Y=242
+X=812
+Y=286
ColorBack="230,230,230"
ColorText="0,0,0"
ColorBackTitle="230,230,230"
@@ -1344,8 +1361,8 @@ Field_1="mirrorfile_pk||T||0|true|false|serial||"
[TABLE_22]
Name="description"
-X=1000
-Y=4
+X=1183
+Y=0
ColorBack="230,230,230"
ColorText="0,0,0"
ColorBackTitle="230,230,230"
@@ -1360,8 +1377,8 @@ Field_2="md5||T||0|true|false|text||"
[TABLE_23]
Name="checksum"
-X=93
-Y=514
+X=20
+Y=529
ColorBack="230,230,230"
ColorText="0,0,0"
ColorBackTitle="230,230,230"
@@ -1375,8 +1392,8 @@ Field_1="checksum||T||0|true|false|text||"
[TABLE_24]
Name="mirrorfile_checksum"
-X=247
-Y=604
+X=426
+Y=609
ColorBack="230,230,230"
ColorText="0,0,0"
ColorBackTitle="230,230,230"
@@ -1389,8 +1406,8 @@ Field_1="checksums_pk||T||0|true|false|serial||"
[TABLE_25]
Name="mirrorfile_location"
-X=508
-Y=529
+X=489
+Y=533
ColorBack="230,230,230"
ColorText="0,0,0"
ColorBackTitle="230,230,230"
@@ -1403,8 +1420,8 @@ Field_1="location_pk||T||0|true|false|serial||"
[TABLE_26]
Name="type"
-X=61
-Y=680
+X=6
+Y=758
ColorBack="230,230,230"
ColorText="0,0,0"
ColorBackTitle="230,230,230"
@@ -1418,8 +1435,8 @@ Field_1="type||T||0|true|false|text||"
[TABLE_27]
Name="path"
-X=434
-Y=653
+X=158
+Y=834
ColorBack="230,230,230"
ColorText="0,0,0"
ColorBackTitle="230,230,230"
@@ -1429,12 +1446,13 @@ ColorForeTitleSelected="255,255,255"
Option=False
PrimaryKey="path_pk"
Field_0="path_pk||T||0|true|true|serial||"
-Field_1="path||T||0|true|false|text||"
+Field_1="filename||T||0|true|false|text||"
+Field_2="pathdir_pk||T||0|true|false|serial||"
[TABLE_28]
Name="mirrorfile_path"
-X=244
-Y=704
+X=458
+Y=763
ColorBack="230,230,230"
ColorText="0,0,0"
ColorBackTitle="230,230,230"
@@ -1449,8 +1467,8 @@ Field_2="path_pk||T||0|true|false|serial||"
[TABLE_29]
Name="mirrorfile_path_checksum"
-X=0
-Y=596
+X=19
+Y=673
ColorBack="230,230,230"
ColorText="0,0,0"
ColorBackTitle="230,230,230"
@@ -1479,8 +1497,8 @@ Index_0="suite_component_unique||true|component_pk,suite_pk"
[TABLE_30]
Name="language"
-X=1199
-Y=29
+X=1379
+Y=0
ColorBack="230,230,230"
ColorText="0,0,0"
ColorBackTitle="230,230,230"
@@ -1495,8 +1513,8 @@ Field_2="iso_code||T||0|true|false|text||"
[TABLE_31]
Name="translations"
-X=984
-Y=134
+X=1158
+Y=78
ColorBack="230,230,230"
ColorText="0,0,0"
ColorBackTitle="230,230,230"
@@ -1512,8 +1530,8 @@ Field_3="description||T||0|true|false|text||"
[TABLE_32]
Name="fingerprint"
-X=1100
-Y=252
+X=1361
+Y=94
ColorBack="230,230,230"
ColorText="0,0,0"
ColorBackTitle="230,230,230"
@@ -1527,8 +1545,8 @@ Field_1="fingerprint||T||0|true|false|text||"
[TABLE_33]
Name="maintainer"
-X=695
-Y=311
+X=1170
+Y=258
ColorBack="230,230,230"
ColorText="0,0,0"
ColorBackTitle="230,230,230"
@@ -1542,8 +1560,8 @@ Field_1="maintainer||T||0|true|false|text||"
[TABLE_34]
Name="fingerprint_maintainer"
-X=905
-Y=323
+X=1221
+Y=352
ColorBack="230,230,230"
ColorText="0,0,0"
ColorBackTitle="230,230,230"
@@ -1556,8 +1574,8 @@ Field_1="maintainer_pk||T||0|true|false|serial||"
[TABLE_35]
Name="keyring"
-X=1312
-Y=417
+X=1402
+Y=247
ColorBack="230,230,230"
ColorText="0,0,0"
ColorBackTitle="230,230,230"
@@ -1572,8 +1590,8 @@ Field_2="restricted||T|false|0|true|false|bool||"
[TABLE_36]
Name="fingerprint_keyring"
-X=1287
-Y=216
+X=1298
+Y=184
ColorBack="230,230,230"
ColorText="0,0,0"
ColorBackTitle="230,230,230"
@@ -1586,8 +1604,8 @@ Field_1="keyring_pk||T||0|true|false|serial||"
[TABLE_37]
Name="uid"
-X=688
-Y=411
+X=1093
+Y=420
ColorBack="230,230,230"
ColorText="0,0,0"
ColorBackTitle="230,230,230"
@@ -1602,8 +1620,8 @@ Field_2="maintainer_pk||T||0|true|false|serial||"
[TABLE_38]
Name="package"
-X=936
-Y=423
+X=850
+Y=376
ColorBack="230,230,230"
ColorText="0,0,0"
ColorBackTitle="230,230,230"
@@ -1617,8 +1635,8 @@ Field_1="name||T||0|true|false|text||"
[TABLE_39]
Name="source_format"
-X=568
-Y=616
+X=692
+Y=620
ColorBack="230,230,230"
ColorText="0,0,0"
ColorBackTitle="230,230,230"
@@ -1649,8 +1667,8 @@ Field_3="pool||T|true|0|true|false|bool||"
[TABLE_40]
Name="binary_format"
-X=689
-Y=4
+X=810
+Y=3
ColorBack="230,230,230"
ColorText="0,0,0"
ColorBackTitle="230,230,230"
@@ -1664,8 +1682,8 @@ Field_1="version||T||0|true|false|text||"
[TABLE_41]
Name="changes_format"
-X=545
-Y=149
+X=592
+Y=121
ColorBack="230,230,230"
ColorText="0,0,0"
ColorBackTitle="230,230,230"
@@ -1694,8 +1712,8 @@ Field_1="metadata||T||0|true|false|text||"
[TABLE_43]
Name="binary_metadata"
-X=1109
-Y=491
+X=853
+Y=482
ColorBack="230,230,230"
ColorText="0,0,0"
ColorBackTitle="230,230,230"
@@ -1709,8 +1727,8 @@ Field_2="value||T||0|true|false|text||"
[TABLE_44]
Name="source_metadata"
-X=559
-Y=717
+X=881
+Y=729
ColorBack="230,230,230"
ColorText="0,0,0"
ColorBackTitle="230,230,230"
@@ -1739,8 +1757,8 @@ Field_1="urgency||T||0|true|false|text||"
[TABLE_46]
Name="source_uploaders"
-X=400
-Y=778
+X=699
+Y=777
ColorBack="230,230,230"
ColorText="0,0,0"
ColorBackTitle="230,230,230"
@@ -1753,8 +1771,8 @@ Field_1="source_pk||T||0|true|false|serial||"
[TABLE_47]
Name="restricted_uploads"
-X=791
-Y=719
+X=887
+Y=589
ColorBack="230,230,230"
ColorText="0,0,0"
ColorBackTitle="230,230,230"
@@ -1765,6 +1783,22 @@ Option=False
Field_0="fingerprint_pk||T||0|true|false|serial||"
Field_1="package_pk||T||0|true|false|serial||"
+[TABLE_48]
+Name="pathdir"
+X=467
+Y=886
+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="005000610074006800200070006100720074007300200066006F0072002000660069006C0065007300200069006E00200063006F006E00740065006E00740073"
+Option=False
+PrimaryKey="pathdir_pk"
+Field_0="pathdir_pk||T||0|true|true|serial||"
+Field_1="path||T||0|true|false|text||"
+
[TABLE_5]
Name="visibility"
X=245
diff --git a/sql/dakv2try2.sql b/sql/dakv2try2.sql
index 6cada19..d2c0d57 100644
--- a/sql/dakv2try2.sql
+++ b/sql/dakv2try2.sql
@@ -2,7 +2,7 @@
-- pgDesigner 1.2.7
--
-- Project : dakv2 try2
--- Date : 11/27/2008 19:00:24.852
+-- Date : 11/28/2008 11:42:18.234
-- Description:
------------------------------
@@ -227,7 +227,8 @@ ALTER TABLE "type" ADD CONSTRAINT "type_pk" PRIMARY KEY("type_pk");
DROP TABLE IF EXISTS "path" CASCADE;
CREATE TABLE "path" (
"path_pk" serial NOT NULL,
-"path" text NOT NULL
+"filename" text NOT NULL,
+"pathdir_pl" serial NOT NULL
) WITHOUT OIDS;
ALTER TABLE "path" ADD CONSTRAINT "path_pk" PRIMARY KEY("path_pk");
@@ -372,6 +373,14 @@ CREATE TABLE "restricted_uploads" (
"package_pk" serial NOT NULL
) WITHOUT OIDS;
+DROP TABLE IF EXISTS "pathdir" CASCADE;
+CREATE TABLE "pathdir" (
+"pathdir_pl" serial NOT NULL,
+"path" text NOT NULL
+) WITHOUT OIDS;
+ALTER TABLE "pathdir" ADD CONSTRAINT "pathdir_pk" PRIMARY KEY("pathdir_pl");
+COMMENT ON TABLE "pathdir" IS 'Path parts for files in contents';
+
-- End Table's declaration
-- Start Relation's declaration
@@ -564,5 +573,8 @@ ALTER TABLE "restricted_uploads" ADD CONSTRAINT "fingerprint_restricted_uploads_
ALTER TABLE "restricted_uploads" DROP CONSTRAINT "package_restricted_uploads_fkey" CASCADE;
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;
+
-- End Relation's declaration
--
1.5.6.5
Reply to: