11 lines
720 B
MySQL
11 lines
720 B
MySQL
|
--------------------------------------------------------
|
||
|
|
-- Constraints for Table REPOSITORY_ACTION
|
||
|
|
--------------------------------------------------------
|
||
|
|
|
||
|
|
ALTER TABLE "ENVX_OPER"."REPOSITORY_ACTION" ADD CONSTRAINT "REPOSITORY_ACTION_UK1" UNIQUE ("ID_REPOSITORY", "ACTION_NAME", "ACTION_RESULT")
|
||
|
|
USING INDEX "ENVX_OPER"."REPOSITORY_ACTION_UK1" ENABLE;
|
||
|
|
ALTER TABLE "ENVX_OPER"."REPOSITORY_ACTION" ADD CONSTRAINT "REPOSITORY_ACTION_PK" PRIMARY KEY ("ID_REPOSITORY_ACTION")
|
||
|
|
USING INDEX "ENVX_OPER"."REPOSITORY_ACTION_PK" ENABLE;
|
||
|
|
ALTER TABLE "ENVX_OPER"."REPOSITORY_ACTION" MODIFY ("ACTION_NAME" NOT NULL ENABLE);
|
||
|
|
ALTER TABLE "ENVX_OPER"."REPOSITORY_ACTION" MODIFY ("ID_REPOSITORY_ACTION" NOT NULL ENABLE);
|