15 lines
1.1 KiB
SQL
15 lines
1.1 KiB
SQL
--------------------------------------------------------
|
|
-- Constraints for Table DEPLOYMENT_PATTERN_STEP
|
|
--------------------------------------------------------
|
|
|
|
ALTER TABLE "ENVX_OPER"."DEPLOYMENT_PATTERN_STEP" MODIFY ("EXEC_SEQUENCE" NOT NULL ENABLE);
|
|
ALTER TABLE "ENVX_OPER"."DEPLOYMENT_PATTERN_STEP" MODIFY ("STEP_NAME" NOT NULL ENABLE);
|
|
ALTER TABLE "ENVX_OPER"."DEPLOYMENT_PATTERN_STEP" MODIFY ("STEP_DESCRIPTION" NOT NULL ENABLE);
|
|
ALTER TABLE "ENVX_OPER"."DEPLOYMENT_PATTERN_STEP" MODIFY ("ID_STEP_TYPE" NOT NULL ENABLE);
|
|
ALTER TABLE "ENVX_OPER"."DEPLOYMENT_PATTERN_STEP" MODIFY ("ID_PATTERN_STEP" NOT NULL ENABLE);
|
|
ALTER TABLE "ENVX_OPER"."DEPLOYMENT_PATTERN_STEP" MODIFY ("ID_PATTERN" NOT NULL ENABLE);
|
|
ALTER TABLE "ENVX_OPER"."DEPLOYMENT_PATTERN_STEP" MODIFY ("ID_SCOPE" NOT NULL ENABLE);
|
|
ALTER TABLE "ENVX_OPER"."DEPLOYMENT_PATTERN_STEP" MODIFY ("ID_EXEC_CATEGORY" NOT NULL ENABLE);
|
|
ALTER TABLE "ENVX_OPER"."DEPLOYMENT_PATTERN_STEP" ADD CONSTRAINT "PK_DEPLOYMENT_PATTERN_STEP" PRIMARY KEY ("ID_PATTERN_STEP", "ID_PATTERN")
|
|
USING INDEX "ENVX_OPER"."PK_DEPLOYMENT_PATTERN_STEP" ENABLE;
|