Files
oper/DB/CONSTRAINTS/DEPLOYMENT_PATTERN_ENV.sql
2023-06-08 11:55:59 -03:00

11 lines
722 B
SQL

--------------------------------------------------------
-- 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;