9 lines
560 B
MySQL
9 lines
560 B
MySQL
|
--------------------------------------------------------
|
||
|
|
-- Constraints for Table TMP_ENVIROMENTS_REQUEST
|
||
|
|
--------------------------------------------------------
|
||
|
|
|
||
|
|
ALTER TABLE "ENVX_OPER"."TMP_ENVIROMENTS_REQUEST" ADD CONSTRAINT "TMP_ENVIROMENTS_REQUEST_PK" PRIMARY KEY ("ID_DEP_REQ_ENV")
|
||
|
|
USING INDEX "ENVX_OPER"."TMP_ENVIROMENTS_REQUEST_PK" ENABLE;
|
||
|
|
ALTER TABLE "ENVX_OPER"."TMP_ENVIROMENTS_REQUEST" ADD CONSTRAINT "TMP_ENVIROMENTS_REQUEST_UK1" UNIQUE ("ID_ENVIROMENT", "ID_REQ_HGROUP")
|
||
|
|
USING INDEX "ENVX_OPER"."TMP_ENVIROMENTS_REQUEST_UK1" ENABLE;
|