Changeset 29440 for branches/haf_branches/ipp.rsync.20101015/dbconfig

Timestamp:

Oct 15, 2010, 6:39:07 PM (16 years ago)

Author:

heather

Message:

minidvodbtool -update and -defineby work

Location:

branches/haf_branches/ipp.rsync.20101015/dbconfig

Files:

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

branches/haf_branches/ipp.rsync.20101015/dbconfig/changes.txt

@@ -1945 +1945 @@
 ALTER TABLE diffSummary DROP PRIMARY KEY, ADD PRIMARY KEY (diff_id, projection_cell);
 ALTER TABLE stackSummary DROP PRIMARY KEY, ADD PRIMARY KEY (sass_id, projection_cell);
+
+
+-- 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;

branches/haf_branches/ipp.rsync.20101015/dbconfig/minidvodb.md

@@ -21 +21 @@
 
 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