Changeset 35213 for trunk/dbconfig

Timestamp:

Feb 28, 2013, 3:29:26 PM (13 years ago)

Author:

bills

Message:

Add tables relGroup and lapGroup
Add group_id to relExp
Rename releaseName release_name because I kept typing it wrong.

Location:

trunk/dbconfig

Files:

• lap.md (modified) (1 diff)
• release.md (modified) (3 diffs)

trunk/dbconfig/lap.md

@@ -30 +30 @@
     data_state     STR         64   # Key
 END
+
+lapGroup METADATA
+    seq_id          S64 0
+    projection_cell STR 64
+    state           STR 64
+    fault           S16 0
+end

trunk/dbconfig/release.md

@@ -8 +8 @@
     rel_id      S32     0   # Primary Key AUTO_INCREMENT
     surveyID    S32     0   # fkey(surveyID) ref survey(surveyID)
-    releaseName STR     64
+    release_name STR     64
     release_state STR   16
     dataRelease S32     0
@@ -20 +20 @@
     chip_id     S64     0
     cam_id      S64     0
+    group_id    S32     0
     state       STR     16
     flags       U32     0
@@ -49 +50 @@
     time_stamp  TAI     NULL
 END
+
+relGroup METADATA
+    group_id    S32     0   # Primary Key AUTO_INCREMENT
+    rel_id      S32     0
+    group_type  STR     16
+    lap_id      S64     0
+    group_name  STR     16
+    state       STR     16
+    label       STR     64
+    exp_list_path STR   255
+    fault       S16     0
+    registered  TAI     NULL
+END