-- ABS-35830/ ABS-41854

---SHUTDOWNAPPSERVERCLMSG table---
CREATE TABLE SHUTDOWNAPPSERVERCLMSG
(
  LANGUAGE_ID     NUMBER NOT NULL,
  SHUTDOWNMESSAGE VARCHAR2(200) NOT NULL,
  SYSTEMUSER_ID   NUMBER NOT NULL,
  TIMESTAMP       DATE NOT NULL
)
;

ALTER TABLE SHUTDOWNAPPSERVERCLMSG
  ADD CONSTRAINT XPKSHUTDOWNAPPSERVERCLMSG PRIMARY KEY (LANGUAGE_ID);

ALTER TABLE SHUTDOWNAPPSERVERCLMSG
  ADD CONSTRAINT SHUTDOWNAPPSERVERCLMSG_LANG FOREIGN KEY (LANGUAGE_ID)
  REFERENCES LANGUAGES (LANGUAGE_ID) ON DELETE CASCADE;