Index: trunk/ippTools/share/pxadmin_create_tables.sql
===================================================================
--- trunk/ippTools/share/pxadmin_create_tables.sql	(revision 23885)
+++ trunk/ippTools/share/pxadmin_create_tables.sql	(revision 23893)
@@ -1308,5 +1308,5 @@
     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,4 +1324,5 @@
     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,4 +1335,5 @@
     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;