[WP3] Type evolution announcement - Changes related to quality control

[D.R. Boxhoorn]

Dear Astro-Wise database maintainer,

There have been some small type evolution changes related to quality control.
The affected classes are SubWinStat, RegriddedBaseFrame (and subclasses),
ReducedScienceFrame, MasterFlatFrameParameters and IlluminationCorrection.

The corresponding type evolution instructions appear below.
The sources have been committed to CVS.

Good luck!

                                                   Danny

1) -----------------------------------------------------------------------------

ALTER TYPE "SubWinStat$" ADD ATTRIBUTE "mask" REF "PixelMap$" CASCADE INCLUDING TABLE DATA;

2) -----------------------------------------------------------------------------

ALTER TYPE "RegriddedBaseFrame$" ADD ATTRIBUTE "psf_radius" DOUBLE PRECISION CASCADE INCLUDING TABLE DATA;
UPDATE "RegriddedBaseFrame" SET "psf_radius"=0.0;
UPDATE "RegriddedFrame" SET "psf_radius"=0.0;
UPDATE "CoaddedRegriddedFrame" SET "psf_radius"=0.0;
COMMIT;

3) -----------------------------------------------------------------------------

ALTER TYPE "ReducedScienceFrame$" ADD ATTRIBUTE "psf_radius" DOUBLE PRECISION CASCADE INCLUDING TABLE DATA;
UPDATE "ReducedScienceFrame" SET "psf_radius"=0.0;
COMMIT;

4) -----------------------------------------------------------------------------

ALTER TYPE "MasterFlatFrameParameters$" ADD ATTRIBUTE "COMBINE_TYPE" SMALLINT CASCADE INCLUDING TABLE DATA;
UPDATE "MasterFlatFrameParameters" SET "COMBINE_TYPE"=1;
COMMIT;

5) -----------------------------------------------------------------------------

CREATE OR REPLACE TYPE "luminationCorrection$fitcoeffs" AS TABLE OF DOUBLE PRECISION;
/
GRANT EXECUTE ON "luminationCorrection$fitcoeffs" TO AWUSER;

ALTER TYPE "IlluminationCorrection$" ADD ATTRIBUTE ("fitcoeffs" "luminationCorrection$fitcoeffs", "min_x" DOUBLE PRECISION, "max_x" DOUBLE PRECISION, "min_y" DOUBLE PRECISION, "max_y" DOUBLE PRECISION) CASCADE INCLUDING TABLE DATA;

UPDATE "IlluminationCorrection" SET "fitcoeffs"="luminationCorrection$fitcoeffs"(), "min_x"=0.0, "max_x"=0.0, "min_y"=0.0, "max_y"=0.0;
COMMIT;

F) -----------------------------------------------------------------------------

RECOMPILE VIEWS
RECOMPILE TRIGGERS