Changeset 29515 for branches/eam_branches/ipp-20100823/dbconfig

Timestamp:

Oct 21, 2010, 2:45:13 PM (16 years ago)

Author:

eugene

Message:

merge changes from trunk

Location:

branches/eam_branches/ipp-20100823/dbconfig

Files:

• background.md (modified) (2 diffs)
• changes.txt (modified) (1 diff)
• config.md (modified) (1 diff)
• magic.md (modified) (1 diff)
• pstamp.md (modified) (2 diffs)
• stack.md (modified) (1 diff)

branches/eam_branches/ipp-20100823/dbconfig/background.md

@@ -21 +21 @@
     class_id            STR     64
     path_base           STR     255
+    data_state          STR     64
     magicked            S64     0
     dtime_script        F32     0.0
@@ -57 +58 @@
     skycell_id          STR     64
     path_base           STR     255
+    data_state          STR     64
     magicked            S64     0
     dtime_script        F32     0.0

branches/eam_branches/ipp-20100823/dbconfig/changes.txt

@@ -1945 +1945 @@
 ALTER TABLE diffSummary DROP PRIMARY KEY, ADD PRIMARY KEY (diff_id, projection_cell);
 ALTER TABLE stackSummary DROP PRIMARY KEY, ADD PRIMARY KEY (sass_id, projection_cell);
+
+ALTER TABLE stackSumSkyfile ADD COLUMN mjd_obs double AFTER good_frac;
+
+-- Version 1.1.65
+-- changes to support cleanup of the background preserved images
+ALTER TABLE chipBackgroundImfile ADD COLUMN data_state VARCHAR(64) AFTER path_base;
+ALTER TABLE chipBackgroundImfile ADD KEY(data_state);
+ALTER TABLE warpBackgroundSkyfile ADD COLUMN data_state VARCHAR(64) AFTER path_base;
+ALTER TABLE warpBackgroundSkyfile  ADD KEY(data_state);
+
+ALTER TABLE magicMask ADD COLUMN path_base VARCHAR(255) AFTER uri;
+
+-- diff_id was removed from magicInputSkyfile ages ago, but
+-- pxadmin_create_tables.sql still had it this command didn't work due to
+-- a mysql error.
+-- ALTER TABLE magicInputSkyfile DROP COLUMN diff_id;
+UPDATE dbversion set schema_version = '1.1.65',  updated= CURRENT_TIMESTAMP();
+
+-- Version 1.1.66
+

branches/eam_branches/ipp-20100823/dbconfig/config.md

@@ -2 +2 @@
     pkg_name        STR     ippdb
     pkg_namespace   STR     ippdb
-    pkg_version     STR     1.1.63
+    pkg_version     STR     1.1.65
 END

branches/eam_branches/ipp-20100823/dbconfig/magic.md

@@ -42 +42 @@
     magic_id    S64         0       # Primary Key fkey(magic_id) ref magicRun(magic_id)
     uri         STR         255
+    path_base   STR         255
     streaks     S32         0
     fault       S16         0       # Key

branches/eam_branches/ipp-20100823/dbconfig/pstamp.md

@@ -46 +46 @@
     options     S64         64
     dep_id      S64         0
+    fault_count S32         0
 END
 
@@ -59 +60 @@
     outdir      STR         255
     fault       S16         0
+    fault_count S32         0
 END
 

branches/eam_branches/ipp-20100823/dbconfig/stack.md

@@ -49 +49 @@
     hostname           STR    64
     good_frac          F32    0.0     # Key
+    mjd_obs            F64    0.0
     fault              S16    0       # Key
     software_ver    STR         16