Get HTML - html_tags_c.sql

-- ------------------------------------------------------------------------- -- -- -- -- Title: html_tags_c.sql -- -- Author: Steve Roach -- -- Date: 25-JUL-2006 -- -- Version: 01.00 -- -- -- -- Description: Create constraints for table HTML_TAGS. -- -- -- -- History: -- -- -- -- Date Ver Author Description -- -- --------- ----- ------ -------------------------------------------------- -- -- 25-JUL-06 01.00 SRR First release -- -- -- -- ------------------------------------------------------------------------- -- ALTER TABLE html_tags DROP CONSTRAINT html_tags_pk / ALTER TABLE html_tags DROP CONSTRAINT html_tags_c1 / ALTER TABLE html_tags DROP CONSTRAINT html_tags_c2 / ALTER TABLE html_tags ADD CONSTRAINT html_tags_pk PRIMARY KEY ( name ) USING INDEX html_tags_pk / ALTER TABLE html_tags ADD CONSTRAINT html_tags_c1 CHECK ( treatment IN ('KEEP', 'DISCARD') ) / ALTER TABLE html_tags ADD CONSTRAINT html_tags_c2 CHECK ( paired IN ('Y', 'N') ) /