Changeset 29495 for trunk/dbconfig

Timestamp:

Oct 20, 2010, 11:53:36 AM (16 years ago)

Author:

bills

Message:

Add path_base to magicMask. Convert destreaking to get streaks file from there.
Also deleted magicInputSkyfile.diff_id from pxadmin_create_tables.sql. The column has been
gone for ages in gpc1 and the rest of the code but new databases were getting it set

Location:

trunk/dbconfig

Files:

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

trunk/dbconfig/changes.txt

@@ -1946 +1946 @@
 ALTER TABLE stackSummary DROP PRIMARY KEY, ADD PRIMARY KEY (sass_id, projection_cell);
 
+ALTER TABLE stackSumSkyfile ADD COLUMN mjd_obs double AFTER good_frac;
+
 -- changes to support cleanup of the background preserved images
 ALTER TABLE chipBackgroundImfile ADD COLUMN data_state VARCHAR(64) AFTER path_base;
@@ -1952 +1954 @@
 ALTER TABLE warpBackgroundSkyfile  ADD KEY(data_state);
 
-ALTER TABLE stackSumSkyfile ADD COLUMN mjd_obs double AFTER good_frac;
+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;

trunk/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