DROP TABLE OMALERT.OM_ALERT_TEXT_VARIABLES CASCADE CONSTRAINTS ;
/
CREATE TABLE OMALERT.OM_ALERT_TEXT_VARIABLES (
  VAR_ID             NUMBER (10)   NOT NULL,
  VAR_VALUE          VARCHAR2 (1000)  NOT NULL,
  VAR_NAME           VARCHAR2 (50)  NOT NULL,
  VAR_DISPLAY_TABLE  VARCHAR2 (100),
  VAR_JOIN_TABLE     VARCHAR2 (100),
  CONSTRAINT OM_ALERT_TXT_VAR_PK
  PRIMARY KEY ( VAR_ID ) ) ;
/

ALTER TABLE OMALERT.OM_ALERT_TEXT_VARIABLES ADD  CONSTRAINT OM_ALERT_TXT_VAR_UK
 UNIQUE (VAR_NAME) ;
/



GRANT ALTER ON OMALERT.OM_ALERT_TEXT_VARIABLES TO PUBLIC;
/

GRANT DELETE ON OMALERT.OM_ALERT_TEXT_VARIABLES TO PUBLIC;
/

GRANT INDEX ON OMALERT.OM_ALERT_TEXT_VARIABLES TO PUBLIC;
/

GRANT INSERT ON OMALERT.OM_ALERT_TEXT_VARIABLES TO PUBLIC;
/

GRANT SELECT ON OMALERT.OM_ALERT_TEXT_VARIABLES TO PUBLIC;
/

GRANT UPDATE ON OMALERT.OM_ALERT_TEXT_VARIABLES TO PUBLIC;
/

GRANT REFERENCES ON OMALERT.OM_ALERT_TEXT_VARIABLES TO PUBLIC;
/

CREATE PUBLIC SYNONYM OM_ALERT_TEXT_VARIABLES FOR OMALERT.OM_ALERT_TEXT_VARIABLES;
/
