Changeset 23565

Timestamp:

Mar 26, 2009, 2:03:19 PM (17 years ago)

Author:

bills

Message:

one of the changes for 1.1.50 was incorrect

File:

• trunk/dbconfig/changes.txt (modified) (2 diffs)

trunk/dbconfig/changes.txt

@@ -851 +851 @@
 CREATE TABLE distRun (
     dist_id     BIGINT AUTO_INCREMENT,
+    target_id   BIGINT,
     stage       VARCHAR(64),
     stage_id    BIGINT,
@@ -857 +858 @@
     clean       TINYINT,
     state       VARCHAR(64),
+    time_stamp  TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
     fault       SMALLINT,
     PRIMARY KEY(dist_id),
     KEY(state),
-    KEY(label)
+    KEY(label),
+    FOREIGN KEY(target_id) REFERENCES distTarget(target_id)
 )  ENGINE=innodb DEFAULT CHARSET=latin1;