create table OFCHATLOGS
(
MESSAGEID NUMBER not null,
SESSIONJID VARCHAR2(50),
SENDER VARCHAR2(50),
RECEIVER VARCHAR2(50),
CREATEDATE VARCHAR2(30),
CONTENT VARCHAR2(200),
DETAIL VARCHAR2(300),
STATE NUMBER(2)
)