Changeset 35213 for trunk/dbconfig/release.md

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.

File:

• trunk/dbconfig/release.md (modified) (3 diffs)

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