Changeset 41213 for trunk/dbconfig

Timestamp:

Dec 24, 2019, 2:57:20 AM (7 years ago)

Author:

cclin33

Message:

update for addstar tasks

Location:

trunk/dbconfig

Files:

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

trunk/dbconfig/add.md

@@ -17 +17 @@
     minidvodb_group STR     64
     minidvodb_name  STR     64
+    minidvodb_host  STR     64
 END
 

trunk/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;
+

trunk/dbconfig/minidvodb.md

@@ -4 +4 @@
     minidvodb_group STR    64
     minidvodb_path  STR    255
+    minidvodb_host  STR    64
     state           STR    64
+    note            STR    255
     creation_date   UTC    0001-01-01T00:00:00Z
 END