CREATE TABLE "NOTIFICATION_LOG" | |
( | |
"NL_ID" BIGINT NOT NULL, | |
"EVENT_ID" BIGINT NOT NULL, | |
"EVENT_TIME" INTEGER NOT NULL, | |
"EVENT_TYPE" VARCHAR(32) NOT NULL, | |
"DB_NAME" VARCHAR(128), | |
"TBL_NAME" VARCHAR(128), | |
"MESSAGE" text, | |
PRIMARY KEY ("NL_ID") | |
); | |
CREATE TABLE "NOTIFICATION_SEQUENCE" | |
( | |
"NNI_ID" BIGINT NOT NULL, | |
"NEXT_EVENT_ID" BIGINT NOT NULL, | |
PRIMARY KEY ("NNI_ID") | |
); |