-- Migration from 051 to 052\012\012-- Add QUERY_TYPE column to QUERIES\012CREATE DOMAIN QUERY_TYPE AS VARCHAR(40) CHECK (VALUE IN ('GENERIC', 'EXPERIMENT', 'SAMPLE', 'DATA_SET', 'MATERIAL'));\012ALTER TABLE QUERIES ADD COLUMN QUERY_TYPE QUERY_TYPE;\012UPDATE QUERIES SET QUERY_TYPE = 'GENERIC';\012ALTER TABLE QUERIES ALTER COLUMN QUERY_TYPE SET NOT NULL; \012\012-- add DB_KEY column to QUERIES\012\012ALTER TABLE queries ADD COLUMN db_key code NOT NULL DEFAULT '1';\012