| CREATE TABLE NOTIFICATION_LOG | |
| ( | |
| NL_ID NUMBER NOT NULL, | |
| EVENT_ID NUMBER NOT NULL, | |
| EVENT_TIME NUMBER(10) NOT NULL, | |
| EVENT_TYPE VARCHAR2(32) NOT NULL, | |
| DB_NAME VARCHAR2(128), | |
| TBL_NAME VARCHAR2(128), | |
| MESSAGE CLOB NULL | |
| ); | |
| ALTER TABLE NOTIFICATION_LOG ADD CONSTRAINT NOTIFICATION_LOG_PK PRIMARY KEY (NL_ID); | |
| CREATE TABLE NOTIFICATION_SEQUENCE | |
| ( | |
| NNI_ID NUMBER NOT NULL, | |
| NEXT_EVENT_ID NUMBER NOT NULL | |
| ); |