PecanProject / bety

Web-interface to the Biofuel Ecophysiological Traits and Yields Database (used by PEcAn and TERRA REF)
https://www.betydb.org
BSD 3-Clause "New" or "Revised" License
16 stars 38 forks source link

add migration to drop valid_ensemble_runtype constraitn #334

Open dlebauer opened 9 years ago

dlebauer commented 9 years ago

This constraint should be removed:

ALTER TABLE ensembles ALTER COLUMN runtype SET NOT NULL,
                      ADD CONSTRAINT valid_ensemble_runtype CHECK (runtype IN ('ensemble', 'sensitivity analysis', 'MCMC', 'pda.emulator'));

To drop the table:

ALTER TABLE ensembles DROP CONSTRAINT valid_ensemble_runtype;
serbinsh commented 9 years ago

Command worked OK for me.