Get HTML - parsed_html_c.sql

-- ------------------------------------------------------------------------- -- -- -- -- Title: parsed_html_c.sql -- -- Author: Steve Roach -- -- Date: 25-JUL-2006 -- -- Version: 01.00 -- -- -- -- Description: Create constraints for table PARSED_HTML. -- -- -- -- History: -- -- -- -- Date Ver Author Description -- -- --------- ----- ------ -------------------------------------------------- -- -- 25-JUL-06 01.00 SRR First release -- -- -- -- ------------------------------------------------------------------------- -- ALTER TABLE parsed_html DROP CONSTRAINT parsed_html_pk / ALTER TABLE parsed_html DROP CONSTRAINT parsed_html_f1 / ALTER TABLE parsed_html ADD CONSTRAINT parsed_html_pk PRIMARY KEY ( parse_run_no ,raw_run_no ,component_seq ) USING INDEX parsed_html_pk / ALTER TABLE parsed_html ADD CONSTRAINT parsed_html_f1 FOREIGN KEY ( parse_run_no ,raw_run_no ) REFERENCES html_parse_passes(parse_run_no ,raw_run_no) /