Changeset 27149 for trunk/dbconfig

Timestamp:

Mar 2, 2010, 6:29:45 PM (16 years ago)

Author:

watersc1

Message:

Code and regtool rewrites to enable the lossy compression of old data that aren't scientifically useful.

Location:

trunk/dbconfig

Files:

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

trunk/dbconfig/changes.txt

@@ -1527 +1527 @@
 ALTER TABLE publishClient ADD COLUMN magicked TINYINT DEFAULT 1 AFTER stage;
 
+ALTER TABLE rawExp ADD COLUMN state VARCHAR(64) AFTER workdir, ADD KEY(state);
+UPDATE rawExp SET state = 'full';
+
+ALTER TABLE rawImfile ADD COLUMN data_state VARCHAR(64) AFTER uri, ADD KEY(data_state);
+UPDATE rawImfile SET data_state = 'full';
+
+-- Not updating schema_version to not break distribution bundles.
+-- UPDATE dbversion set schema_version = '1.1.65', updated= CURRENT_TIMESTAMP();
+
+-- Version 1.1.66
+

trunk/dbconfig/raw.md

@@ -10 +10 @@
     filelevel   STR         64
     workdir     STR         255     # destination for output files
+    state       STR         64      # Key
     reduction   STR         64      # Reduction class
     dvodb       STR         255
@@ -77 +78 @@
     class_id    STR         64      # Primary Key
     uri         STR         255
+    data_state  STR         64      # Key
     exp_type    STR         64
 # This field is used to set the per exp filelevel. Thus the values for all of