Files
oper/DB/CONSTRAINTS/DEPLOYMENT_PATTERN_ENV.sql

11 lines
722 B
MySQL
Raw Permalink Normal View History

2023-06-08 11:55:59 -03:00
--------------------------------------------------------
-- Constraints for Table DEPLOYMENT_PATTERN_ENV
--------------------------------------------------------
ALTER TABLE "ENVX_OPER"."DEPLOYMENT_PATTERN_ENV" MODIFY ("ID_PATTERN" NOT NULL ENABLE);
ALTER TABLE "ENVX_OPER"."DEPLOYMENT_PATTERN_ENV" MODIFY ("ID_ENVIROMENT" NOT NULL ENABLE);
ALTER TABLE "ENVX_OPER"."DEPLOYMENT_PATTERN_ENV" MODIFY ("ID_DEP_PAT_ENV" NOT NULL ENABLE);
ALTER TABLE "ENVX_OPER"."DEPLOYMENT_PATTERN_ENV" MODIFY ("ID_REPOSITORY" NOT NULL ENABLE);
ALTER TABLE "ENVX_OPER"."DEPLOYMENT_PATTERN_ENV" ADD CONSTRAINT "DEPLOYMENT_PATTERN_ENV_PK" PRIMARY KEY ("ID_DEP_PAT_ENV")
USING INDEX "ENVX_OPER"."DEPLOYMENT_PATTERN_ENV_PK" ENABLE;