Index: /branches/eam_branches/ipp-pstamp-20260421/ippTools/share/pxadmin_create_pstamp_tables.sql
===================================================================
--- /branches/eam_branches/ipp-pstamp-20260421/ippTools/share/pxadmin_create_pstamp_tables.sql	(revision 42989)
+++ /branches/eam_branches/ipp-pstamp-20260421/ippTools/share/pxadmin_create_pstamp_tables.sql	(revision 42990)
@@ -1,12 +1,23 @@
+-- Processing labels with their priorities
+CREATE TABLE Label (
+    label       VARCHAR(64) DEFAULT '',
+    priority    INT,
+    active      TINYINT,
+    comment     VARCHAR(80),
+    PRIMARY KEY(label),
+    KEY(priority),
+    KEY(active)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
 CREATE TABLE pstampDataStore (
         ds_id BIGINT AUTO_INCREMENT,
         state VARCHAR(64),
         lastFileset VARCHAR(64),
-        timestamp  DATETIME,
+        timestamp TIMESTAMP NOT NULL default CURRENT_TIMESTAMP,
         label VARCHAR(64),
         outProduct VARCHAR(64) UNIQUE,
         uri VARCHAR(255),
         pollInterval INTEGER DEFAULT 60,
-        need_magic TINYINT,
+        need_magic INT,
         PRIMARY KEY(ds_id),
         KEY(ds_id)
@@ -35,9 +46,9 @@
         outProduct VARCHAR(64),
         uri VARCHAR(255),
-        outdir VARCHAR(255),
+        outdir VARCHAR(64),
         username VARCHAR(255),
         proj_id BIGINT,
         registered datetime,
-        timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
+        timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
         fault SMALLINT,
         PRIMARY KEY(req_id),
@@ -51,5 +62,5 @@
 CREATE TABLE pstampJob (
         job_id BIGINT AUTO_INCREMENT,
-        req_id BIGINT,
+        req_id BIGINT DEFAULT 0,
         rownum VARCHAR(64),
         state VARCHAR(64),
@@ -61,5 +72,5 @@
         dep_id BIGINT,
         fault_count INT,
-        parent_id BIGINT DEFAULT NULL,
+        parent_id BIGINT DEFAULT 0,
         is_parent TINYINT DEFAULT 0,
         PRIMARY KEY(job_id, req_id),
@@ -71,5 +82,5 @@
         KEY(parent_id),
         KEY(is_parent),
-        FOREIGN KEY(req_id) REFERENCES pstampRequest(req_id)
+        KEY(fault_count)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
@@ -92,5 +103,6 @@
         KEY(component),
         KEY(imagedb),
-        KEY(fault)
+        KEY(fault),
+        KEY(fault_count)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
@@ -104,5 +116,5 @@
 
 CREATE TABLE pstampUserDomain (
-    domainName      VARCHAR(64),
+    domainName      VARCHAR(64) DEFAULT '',
     accessLevel     INT,
     defaultProduct  VARCHAR(255),
@@ -112,6 +124,6 @@
 
 CREATE TABLE pstampUser (
-    userName        VARCHAR(64),
-    domainName      VARCHAR(64),
+    userName        VARCHAR(64) DEFAULT '',
+    domainName      VARCHAR(64) DEFAULT '',
     accessLevel     INT,
     defaultProduct  VARCHAR(255),
@@ -121,6 +133,6 @@
 
 CREATE TABLE pstampAccessLevel (
-    proj_id         BIGINT,
-    accessLevel     INT,
+    proj_id         BIGINT DEFAULT 0,
+    accessLevel     INT DEFAULT 0,
     mjd_min         FLOAT DEFAULT 0,
     mjd_max         FLOAT DEFAULT 0,