Changeset 35896 for trunk/dbconfig

Timestamp:

Aug 6, 2013, 11:05:55 AM (13 years ago)

Author:

bills

Message:

Add columns ippRelease.dvodb and ippRelease.ubercal_file and relExp.ubercal_dist

Location:

trunk/dbconfig

Files:

• changes.txt (modified) (1 diff)
• config.md (modified) (1 diff)
• release.md (modified) (2 diffs)

trunk/dbconfig/changes.txt

@@ -2422 +2422 @@
 
 UPDATE dbversion set schema_version = '1.1.76', updated= CURRENT_TIMESTAMP();
+
+--
+
+ALTER TABLE ippRelease ADD COLUMN dvodb VARCHAR(255) DEFAULT NULL AFTER priority;
+ALTER TABLE ippRelease ADD COLUMN ubercal_file VARCHAR(255) DEFAULT NULL AFTER dvodb;
+ALTER TABLE relExp ADD COLUMN ubercal_dist INT DEFAULT 0 AFTER zpt_stdev;
+
+UPDATE dbversion set schema_version = '1.1.77', updated= CURRENT_TIMESTAMP();
+

trunk/dbconfig/config.md

@@ -2 +2 @@
     pkg_name        STR     ippdb
     pkg_namespace   STR     ippdb
-    pkg_version     STR     1.1.76
+    pkg_version     STR     1.1.77
 END

trunk/dbconfig/release.md

@@ -8 +8 @@
     rel_id      S32     0   # Primary Key AUTO_INCREMENT
     surveyID    S32     0   # fkey(surveyID) ref survey(surveyID)
-    release_name STR     64
+    release_name STR    64
     release_state STR   16
     dataRelease S32     0
     priority    S32     0
+    dvodb       STR     255
+    ubercal_file STR    255
 END
 
@@ -25 +27 @@
     zpt_obs     F32     0
     zpt_stdev   F32     0
+    ubercal_dist S32    0
     path_base   STR     255
     fault       S16     0