Changeset 26378 for trunk/dbconfig/changes.txt

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.

File:

• trunk/dbconfig/changes.txt (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();