Control Repository - mapping_histories_c.sql

-- ------------------------------------------------------------------------- -- -- -- -- Title: mapping_histories_c.sql -- -- Author: Steve Roach -- -- Date: 23-AUG-2006 -- -- Version: 01.00 -- -- -- -- Description: Create constraints for table MAPPING_HISTORIES. -- -- -- -- History: -- -- -- -- Date Ver Author Description -- -- --------- ----- ------ -------------------------------------------------- -- -- 23-AUG-06 01.00 SRR First release -- -- -- -- ------------------------------------------------------------------------- -- ALTER TABLE mapping_histories DROP CONSTRAINT mapping_histories_pk / ALTER TABLE mapping_histories DROP CONSTRAINT mapping_histories_f1 / ALTER TABLE mapping_histories ADD CONSTRAINT mapping_histories_pk PRIMARY KEY ( run_no ) USING INDEX mapping_histories_pk / ALTER TABLE mapping_histories ADD CONSTRAINT mapping_histories_f1 FOREIGN KEY ( mapping_library ) REFERENCES mapping_libraries(mapping_name) /