Changeset 23893

Timestamp:

Apr 16, 2009, 5:44:28 PM (17 years ago)

Author:

Paul Price

Message:

Add UNIQUE constraint to ensure we're not downloading the same file/fileset over and over.

Location:

trunk

Files:

• dbconfig/changes.txt (modified) (3 diffs)
• ippTools/share/pxadmin_create_tables.sql (modified) (3 diffs)

trunk/dbconfig/changes.txt

@@ -1039 +1039 @@
     source VARCHAR(128) NOT NULL, -- source URI
     product VARCHAR(64) NOT NULL, -- product of interest
-    workdir VARCHAR(255),       -- where to extract (optional)
+    workdir VARCHAR(255) NOT NULL, -- where to extract
     comment VARCHAR(255),       -- for human memory
     fileset_last VARCHAR(128),  -- last fileset seen
@@ -1055 +1055 @@
     PRIMARY KEY(fileset_id),
     KEY(source_id),
+    CONSTRAINT UNIQUE(source_id, fileset),
     FOREIGN KEY(source_id) REFERENCES receiveSource(source_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
@@ -1065 +1066 @@
     PRIMARY KEY(file_id),
     KEY(fileset_id),
+    CONSTRAINT UNIQUE(fileset_id, file),
     FOREIGN KEY(fileset_id) REFERENCES receiveFileset(fileset_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -1308 +1308 @@
     source VARCHAR(128) NOT NULL, -- source URI
     product VARCHAR(64) NOT NULL, -- product of interest
-    workdir VARCHAR(255),       -- where to extract (optional)
+    workdir VARCHAR(255) NOT NULL, -- where to extract
     comment VARCHAR(255),       -- for human memory
     fileset_last VARCHAR(128),  -- last fileset seen
@@ -1324 +1324 @@
     PRIMARY KEY(fileset_id),
     KEY(source_id),
+    CONSTRAINT UNIQUE(source_id, fileset),
     FOREIGN KEY(source_id) REFERENCES receiveSource(source_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
@@ -1334 +1335 @@
     PRIMARY KEY(file_id),
     KEY(fileset_id),
+    CONSTRAINT UNIQUE(fileset_id, file),
     FOREIGN KEY(fileset_id) REFERENCES receiveFileset(fileset_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;