10 lines
594 B
MySQL
10 lines
594 B
MySQL
|
--------------------------------------------------------
|
||
|
|
-- Constraints for Table SYSTEM_MESSAGE
|
||
|
|
--------------------------------------------------------
|
||
|
|
|
||
|
|
ALTER TABLE "ENVX_OPER"."SYSTEM_MESSAGE" MODIFY ("ID_MESSAGE" NOT NULL ENABLE);
|
||
|
|
ALTER TABLE "ENVX_OPER"."SYSTEM_MESSAGE" MODIFY ("ID_MESSAGE_CLASS" NOT NULL ENABLE);
|
||
|
|
ALTER TABLE "ENVX_OPER"."SYSTEM_MESSAGE" MODIFY ("MESSAGE_CATEGORY" NOT NULL ENABLE);
|
||
|
|
ALTER TABLE "ENVX_OPER"."SYSTEM_MESSAGE" ADD CONSTRAINT "SYSTEM_MESSAGE_PK" PRIMARY KEY ("ID_MESSAGE", "ID_MESSAGE_CLASS")
|
||
|
|
USING INDEX "ENVX_OPER"."SYSTEM_MESSAGE_PK" ENABLE;
|