Get HTML - raw_html_c.sql

-- ------------------------------------------------------------------------- -- -- -- -- Title: raw_html_c.sql -- -- Author: Steve Roach -- -- Date: 25-JUL-2006 -- -- Version: 01.00 -- -- -- -- Description: Create constraints for table RAW_HTML. -- -- -- -- History: -- -- -- -- Date Ver Author Description -- -- --------- ----- ------ -------------------------------------------------- -- -- 25-JUL-06 01.00 SRR First release -- -- -- -- ------------------------------------------------------------------------- -- ALTER TABLE raw_html DROP CONSTRAINT raw_html_pk / ALTER TABLE raw_html DROP CONSTRAINT raw_html_f1 / ALTER TABLE raw_html ADD CONSTRAINT raw_html_pk PRIMARY KEY ( run_no ,piece_seq ) USING INDEX raw_html_pk / ALTER TABLE raw_html ADD CONSTRAINT raw_html_f1 FOREIGN KEY ( run_no ) REFERENCES html_page_access(run_no) /