Files

11 lines
312 B
SQL

CREATE TABLE "LOG_TYPE" (
"LOG_TYPE_ID" VARCHAR2(10) NOT NULL,
"LOG_TYPE_DESC" VARCHAR2(255) NOT NULL );
CREATE TABLE LOGGER (
LOGTIME DATE DEFAULT SYSDATE NOT NULL,
LOG_TYPE_ID VARCHAR2 (10) NOT NULL,
MSG_ID NUMBER (10) NOT NULL,
MSG_TEXT VARCHAR2 (255) NOT NULL);