Changeset 41211 for branches/ccl_branches/ipponly-20191108/dbconfig

Timestamp:

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

Author:

cclin33

Message:

update addstar for multiple hosts

Location:

branches/ccl_branches/ipponly-20191108/dbconfig

Files:

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

branches/ccl_branches/ipponly-20191108/dbconfig/add.md

@@ -1 +1 @@
 # XXX rename these 'addstarRun', etc... (add_id -> addstar_id)
 addRun METADATA
-    add_id          S64     0       # Primary Key AUTO_INCREMENT
-    stage           STR     64      # what the stage is (warp, cam, diff,
-    stage_id          S64     0       # Key INDEX(add_id,cam_id) fkey(cam_id)    ref camRun(cam_id)
-    stage_extra1    S32     0       
-    state           STR     64      # Key
-    workdir         STR     255
-    workdir_state   STR     64
-    reduction       STR     64
-    label           STR     64
-    data_group      STR     64      # Key
-    dvodb           STR     255
-    note            STR     255
+    add_id          S64     0    # Primary Key AUTO_INCREMENT
+    stage           STR    64    # what the stage is (warp, cam, diff,
+    stage_id        S64     0    # Key INDEX(add_id,cam_id) fkey(cam_id)    ref camRun(cam_id)
+    stage_extra1    S32     0     
+    state           STR    64    # Key
+    workdir         STR   255
+    workdir_state   STR    64
+    reduction       STR    64
+    label           STR    64
+    data_group      STR    64    # Key
+    dvodb           STR   255
+    note            STR   255
     image_only      BOOL    f
-    minidvodb       BOOL    f
-    minidvodb_group STR     64
-    minidvodb_name  STR     64
+    minidvodb       BOOL    f
+    minidvodb_group STR    64
+    minidvodb_name  STR    64
+    minidvodb_host  STR    64
 END
 
 addProcessedExp METADATA
-    add_id          S64     0       # Primary Key AUTO_INCREMENT
-    dtime_addstar   F32     0.0
-    path_base       STR     255
-    dvodb_path      STR     255
-    fault           S16     0       # Key NOT NULL
+    add_id          S64     0    # Primary Key AUTO_INCREMENT
+    dtime_addstar   F32   0.0
+    path_base       STR   255
+    dvodb_path      STR   255
+    fault           S16     0    # Key NOT NULL
 END
 
 addMask METADATA
-    label           STR    64       # Primary Key
+    label           STR    64    # Primary Key
 END
 

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

branches/ccl_branches/ipponly-20191108/dbconfig/minidvodb.md

@@ -1 +1 @@
 minidvodbRun METADATA
-    minidvodb_id    S64    0         
-    minidvodb_name  STR    64
-    minidvodb_group STR    64
-    minidvodb_path  STR    255
-    state           STR    64
-    creation_date   UTC    0001-01-01T00:00:00Z
+    minidvodb_id          S64    0        
+    minidvodb_name        STR    64
+    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 
 
 minidvodbProcessed METADATA
-    minidvodb_id    S64    0
-    dtime_resort    F32    0.0
-    dtime_relphot   F32    0.0
-    dtime_script    F32    0.0
-    epoch           UTC    0001-01-01T00:00:00Z
-    fault           S16    0
+    minidvodb_id          S64    0
+    dtime_resort          F32    0.0
+    dtime_relphot         F32    0.0
+    dtime_script          F32    0.0
+    epoch                 UTC    0001-01-01T00:00:00Z
+    fault                 S16    0
 END
 
 minidvodbCopy METADATA
-    minidvodbcopy_id    S64 0
-    minidvodb_id    S64    0
-    minidvodb_rsync_path   STR    255
-    destination_host       STR    255
-    fault           S16    0
-    state           STR    64
-    epoch           UTC    0001-01-01T00:00:00Z
-    dtime           F32    0.0
+    minidvodbcopy_id      S64    0
+    minidvodb_id          S64    0
+    minidvodb_rsync_path  STR    255
+    destination_host      STR    255
+    fault                 S16    0
+    state                 STR    64
+    epoch                 UTC    0001-01-01T00:00:00Z
+    dtime                 F32    0.0
 END