Changeset 29527

Timestamp:

Oct 22, 2010, 4:24:44 PM (16 years ago)

Author:

heather

Message:

minidvodbcopy merge to trunk

Location:

trunk/dbconfig

Files:

• . (modified) (1 prop)
• changes.txt (modified) (1 diff)
• minidvodb.md (modified) (1 diff)

trunk/dbconfig/changes.txt

@@ -1965 +1965 @@
 -- Version 1.1.66
 
+-- minidvodb copy table (for tracking copying of minidvodbs to other machines
+
+
+CREATE TABLE minidvodbCopy (
+    minidvodbcopy_id     BIGINT AUTO_INCREMENT,
+    minidvodb_id     BIGINT,
+    minidvodb_rsync_path VARCHAR(255) NOT NULL,
+    destination_host VARCHAR(255) NOT NULL,
+    fault  SMALLINT NOT NULL,
+    state   VARCHAR(64) NOT NULL,
+    epoch TIMESTAMP,
+    dtime FLOAT,
+    PRIMARY KEY(minidvodbcopy_id),
+    KEY(minidvodb_id),
+    FOREIGN KEY(minidvodb_id) REFERENCES minidvodbRun(minidvodb_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;

trunk/dbconfig/minidvodb.md

@@ -19 +19 @@
     fault           S16    0
 END
+
+minidvodbCopy METADATA
+    minidvodbcopy_id    S64 0
+    minidvodb_id    S64    0
+    minidvodb_rsync_path   STR    255
+    destination_host       STR    255
+    fault           S16    0
+    state           STR    64
+    epoch           UTC    0001-01-01T00:00:00Z
+    dtime           F32    0.0
+END