CREATE TABLE chat (
logcount INTEGER UNIQUE
PRIMARY KEY AUTOINCREMENT
NOT NULL,
topic STRING,
servertime DATETIME,
message STRING,
senttime DATETIME,
deliveredtime DATETIME,
viewedtime DATETIME,
fromuser STRING,
messageno STRING,
messagedts REAL UNIQUE,
reference STRING,
image STRING,
fromusername STRING,
thumbnailfilename STRING
);