11 lines
724 B
MySQL
11 lines
724 B
MySQL
|
--------------------------------------------------------
|
||
|
|
-- Constraints for Table DEPLOYMENT_REQ_OBJECT
|
||
|
|
--------------------------------------------------------
|
||
|
|
|
||
|
|
ALTER TABLE "ENVX_OPER"."DEPLOYMENT_REQ_OBJECT" MODIFY ("ID_DEP_REQ_OBJECT" NOT NULL ENABLE);
|
||
|
|
ALTER TABLE "ENVX_OPER"."DEPLOYMENT_REQ_OBJECT" MODIFY ("ID_REQUEST" NOT NULL ENABLE);
|
||
|
|
ALTER TABLE "ENVX_OPER"."DEPLOYMENT_REQ_OBJECT" MODIFY ("ID_PATTERN" NOT NULL ENABLE);
|
||
|
|
ALTER TABLE "ENVX_OPER"."DEPLOYMENT_REQ_OBJECT" MODIFY ("ID_REQ_HGROUP" NOT NULL ENABLE);
|
||
|
|
ALTER TABLE "ENVX_OPER"."DEPLOYMENT_REQ_OBJECT" ADD CONSTRAINT "DEPLOYMENT_REQ_OBJECT_PK" PRIMARY KEY ("ID_DEP_REQ_OBJECT", "ID_REQUEST")
|
||
|
|
USING INDEX "ENVX_OPER"."PK_REQUEST_DETAIL" ENABLE;
|