Changeset 26446 for trunk/dbconfig

Timestamp:

Dec 16, 2009, 3:57:48 PM (17 years ago)

Author:

bills

Message:

Add some stats to magicDSFile.
On the receive side, make it possible to disable a source

Location:

trunk/dbconfig

Files:

• changes.txt (modified) (2 diffs)
• magic.md (modified) (1 diff)
• receive.md (modified) (1 diff)

trunk/dbconfig/changes.txt

@@ -1434 +1434 @@
 UPDATE dbversion set schema_version = '1.1.57',  updated= CURRENT_TIMESTAMP();
 
+ALTER TABLE receiveSource add column state varchar (64) after workdir;
+UPDATE receiveSource SET state = 'enabled';
+
 -- Vesion 1.1.58
 -- UPDATE dbversion set schema_version = '1.1.58',  updated= CURRENT_TIMESTAMP();
@@ -1479 +1482 @@
 
 UPDATE dbversion set schema_version = '1.1.61',  updated= CURRENT_TIMESTAMP();
+
+ALTER TABLE magicDSFile ADD COLUMN streak_frac FLOAT AFTER recovery_path_base;
+ALTER TABLE magicDSFile ADD COLUMN total_time FLOAT AFTER streak_frac;
+
+ALTER TABLE receiveSource ADD COLUMN state VARCHAR(64) AFTER workdir;
+
+UPDATE dbversion set schema_version = '1.1.62',  updated= CURRENT_TIMESTAMP();

trunk/dbconfig/magic.md

@@ -69 +69 @@
     backup_path_base  STR         255
     recovery_path_base STR        255
+    streak_frac F32         0
+    run_time    F32         0
     fault       S16         0
     data_state  STR        64     # Key

trunk/dbconfig/receive.md

@@ -6 +6 @@
         product         STR     64      # Key
         workdir         STR     255
+        state           STR     64
         comment         STR     255     # Key
         fileset_last    STR     128