Changeset 28003 for branches/pap/ippTools/share/pxadmin_create_tables.sql

Timestamp:

May 18, 2010, 12:49:05 PM (16 years ago)

Author:

eugene

Message:

merging changes from trunk into branches/pap

Location:

branches/pap

Files:

• . (modified) (1 prop)
• ippTools/share/pxadmin_create_tables.sql (modified) (7 diffs)

branches/pap/ippTools/share/pxadmin_create_tables.sql

@@ -1175 +1175 @@
         KEY(label),
         KEY(fault),
+        KEY(stage),
+        KEY(stage_id),
         FOREIGN KEY(magic_id) REFERENCES magicRun(magic_id),
         FOREIGN KEY(inv_magic_id) REFERENCES magicRun(magic_id)
@@ -1301 +1303 @@
         outProduct VARCHAR(64),
         uri VARCHAR(255),
+        outdir     VARCHAR(255),
         fault SMALLINT,
         PRIMARY KEY(req_id),
@@ -1327 +1330 @@
         stage      VARCHAR(64),
         stage_id   BIGINT,
+        component  VARCHAR(64),
         imagedb    VARCHAR(64),
         rlabel     VARCHAR(64),
-        no_magic   TINYINT,
-        PRIMARY KEY(dep_id)
+        outdir     VARCHAR(255),
+        need_magic TINYINT,
+        PRIMARY KEY(dep_id),
+        KEY(state),
+        KEY(stage),
+        KEY(stage_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
@@ -1342 +1350 @@
     comment     VARCHAR(255),
     PRIMARY KEY(target_id),
+    KEY(stage),
+    KEY(dist_group),
+    KEY(filter),
+    KEY(state),
     CONSTRAINT UNIQUE (dist_group, filter, stage, clean)
 )  ENGINE=innodb DEFAULT CHARSET=latin1;
@@ -1365 +1377 @@
     KEY(state),
     KEY(label),
+    KEY(stage),
+    KEY(stage_id),
+    KEY(magic_ds_id),
+    KEY(fault),
+    KEY(data_group),
     FOREIGN KEY(target_id) REFERENCES distTarget(target_id)
 )  ENGINE=innodb DEFAULT CHARSET=latin1;
@@ -1549 +1566 @@
       note VARCHAR(255),             -- note
       registered TIMESTAMP DEFAULT CURRENT_TIMESTAMP, -- time run was registered
-      PRIMARY KEY(dqstats_id),
+      PRIMARY KEY(ss_id),
       KEY(state),
       KEY(label),
@@ -1581 +1598 @@
       KEY(fault),
       KEY(quality),
-      FOREIGN KEY(ss_id) REFERENCES staticskyRun(ss_id),
+      FOREIGN KEY(ss_id) REFERENCES staticskyRun(ss_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+CREATE TABLE Label (
+    label       VARCHAR(64),
+    priority    INT,
+    active      TINYINT,
+    comment     VARCHAR(80),
+    PRIMARY KEY(label),
+    KEY(priority),
+    KEY(active)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;