Changeset 17877 for trunk/dbconfig

Timestamp:

Jun 2, 2008, 11:24:18 AM (18 years ago)

Author:

jhoblitt

Message:

first use of fake* tables
VERSION 1.1.38

Location:

trunk/dbconfig

Files:

• changes.txt (modified) (1 diff)
• config.md (modified) (1 diff)
• fake.md (modified) (3 diffs)

trunk/dbconfig/changes.txt

@@ -171 +171 @@
 ALTER TABLE rawImfile ADD COLUMN epoch TIMESTAMP DEFAULT CURRENT_TIMESTAMP AFTER fault;
 
+-- 1.1.38
 
+-- first use of fake* tables
+-- just drop/recreate any fake* tables prior to this point

trunk/dbconfig/config.md

@@ -2 +2 @@
     pkg_name        STR     ippdb
     pkg_namespace   STR     ippdb
-    pkg_version     STR     1.1.37
+    pkg_version     STR     1.1.38
 END

trunk/dbconfig/fake.md

@@ -1 +1 @@
 fakeRun METADATA
     fake_id     S64         0       # Primary Key AUTO_INCREMENT
-    exp_id      S64         64      # Key INDEX(fake_id, exp_id) fkey (exp_id) ref rawExp(exp_id)
+    cam_id      S64         0       # Key INDEX(fake_id, cam_id) fkey (cam_id) ref camRun(cam_id)
     state       STR         64      # Key
     workdir     STR         255 
-    workdir_state STR       64      # Key
     label       STR         64      # Key
     reduction   STR         64      # Reduction class
@@ -11 +10 @@
     tess_id     STR         64
     end_stage   STR         64      # Key
+    epoch       UTC         0001-01-01T00:00:00Z
 END
 
 fakeProcessedImfile METADATA
-    fake_id         S64     0       # Primary Key fkey (fake_id, exp_id) ref fakeRun(fake_id, exp_id)
+    fake_id         S64     0       # Primary Key fkey (fake_id) ref fakeRun(fake_id)
     exp_id          S64     64      # Primary Key fkey (exp_id, class_id) ref rawImfile(exp_id, class_id)
     class_id        STR     64      # Primary Key
@@ -22 +22 @@
     path_base       STR     255
     fault           S16     0       # Key NOT NULL
+    epoch           UTC         0001-01-01T00:00:00Z
 END