Get HTML - html_page_access_c.sql

-- ------------------------------------------------------------------------- -- -- -- -- Title: html_page_access_c.sql -- -- Author: Steve Roach -- -- Date: 25-JUL-2006 -- -- Version: 01.00 -- -- -- -- Description: Create constraints for table HTML_PAGE_ACCESS. -- -- -- -- History: -- -- -- -- Date Ver Author Description -- -- --------- ----- ------ -------------------------------------------------- -- -- 25-JUL-06 01.00 SRR First release -- -- -- -- ------------------------------------------------------------------------- -- ALTER TABLE html_page_access DROP CONSTRAINT html_page_access_pk / ALTER TABLE html_page_access DROP CONSTRAINT html_page_access_f1 / ALTER TABLE html_page_access DROP CONSTRAINT html_page_access_f2 / ALTER TABLE html_page_access ADD CONSTRAINT html_page_access_pk PRIMARY KEY ( run_no ) USING INDEX html_page_access_pk / ALTER TABLE html_page_access ADD CONSTRAINT html_page_accesss_f1 FOREIGN KEY ( html_page_name ) REFERENCES html_pages(name) / ALTER TABLE html_page_access ADD CONSTRAINT html_page_accesss_f2 FOREIGN KEY ( run_no ) REFERENCES mapping_histories(run_no) /