Changeset 26378 for trunk/dbconfig

Timestamp:

Dec 9, 2009, 12:14:22 PM (17 years ago)

Author:

watersc1

Message:

dqstatstool: I forgot to commit this last week.

summit copy: added support for use_compress option in the datastore entry in the database. This should allow gpc1 and isp data to be copied using the same code.

dbconfig: database changes to support the above.

Location:

trunk/dbconfig

Files:

• changes.txt (modified) (1 diff)
• dqstats.md (modified) (1 diff)
• summitcopy.md (modified) (1 diff)

trunk/dbconfig/changes.txt

@@ -1466 +1466 @@
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
+-- Version 1.1.60
+
+ALTER TABLE dqstatsRun ADD COLUMN label VARCHAR(64) AFTER registered;
+ALTER TABLE dqstatsRun ADD KEY(label);
+
+ALTER TABLE dqstatsRun ADD COLUMN fault SMALLINT NOT NULL AFTER label;
+ALTER TABLE dqstatsRun ADD KEY(fault);
+
+-- Version 1.1.61
+
+ALTER TABLE pzDataStore ADD COLUMN use_compress SMALLINT NOT NULL AFTER epoch;
+
+UPDATE dbversion set schema_version = '1.1.61',  updated= CURRENT_TIMESTAMP();

trunk/dbconfig/dqstats.md

@@ -3 +3 @@
     state          STR          64
     registered     TAI          NULL
+    label          STR          64    # Key
+    fault          S16          0     # Key NOT NULL
 END
 

trunk/dbconfig/summitcopy.md

@@ -4 +4 @@
     uri         STR         255
     epoch       UTC         0001-01-01T00:00:00Z
+    use_compress S16        0
 END