Changeset 41211 for branches/ccl_branches/ipponly-20191108/dbconfig/changes.txt

Timestamp:

Dec 22, 2019, 4:11:49 PM (7 years ago)

Author:

cclin33

Message:

update addstar for multiple hosts

File:

• branches/ccl_branches/ipponly-20191108/dbconfig/changes.txt (modified) (1 diff)

branches/ccl_branches/ipponly-20191108/dbconfig/changes.txt

@@ -2553 +2553 @@
 --
 
+ALTER TABLE minidvodbProcessed DROP COLUMN hostname;
+ALTER TABLE minidvodbRun ADD COLUMN hostname varchar(64) AFTER state;
+ALTER TABLE minidvodbRun DROP COLUMN hostname;
+ALTER TABLE minidvodbRun ADD COLUMN minidvodb_host varchar(64) NOT NULL AFTER minidvodb_path;
+ALTER TABLE addRun Change hostname minidvodb_host varchar(64);
+ALTER TABLE minidvodbRun ADD COLUMN note varchar(255) AFTER state;
+