Changeset 23842 for trunk/ippTools/share/pxadmin_create_tables.sql

Timestamp:

Apr 13, 2009, 4:32:41 PM (17 years ago)

Author:

bills

Message:

modes to disttool for creating rcDSFileset objects
tweaks to the rcDSFileset and rcDSProduct tables

File:

• trunk/ippTools/share/pxadmin_create_tables.sql (modified) (2 diffs)

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -1250 +1250 @@
     dbname      VARCHAR(64),
     dbhost      VARCHAR(64),
-    prod_root   VARCHAR(255),
     PRIMARY KEY(prod_id)
 )  ENGINE=innodb DEFAULT CHARSET=latin1;
@@ -1281 +1280 @@
     dist_id     BIGINT,
     prod_id     BIGINT,
-    name        VARCHAR(64),
+    name        VARCHAR(255),
     state       VARCHAR(64),
     registered  TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
-    PRIMARY KEY(fs_id),
+    fault       SMALLINT DEFAULT 0,
+    PRIMARY KEY(dist_id, prod_id),
+    KEY(fs_id),
     FOREIGN KEY(dist_id) REFERENCES distRun(dist_id),
     FOREIGN KEY(prod_id) REFERENCES rcDSProduct(prod_id)
+--    KEY(dist_id, prod_id)
 )  ENGINE=innodb DEFAULT CHARSET=latin1;