Sybase Adaptive Server Anywhere

CREATE TABLE ozekismsin (
  id numeric(1,0) identity,
  sender varchar(30) not null,
  receiver varchar(30) null,
  msg varchar(160) not null,
  senttime varchar(100) null,
  receivedtime varchar(100) null,
  operator varchar(100) null
)


CREATE TABLE ozekismsout (
  id numeric(1,0) identity,
  sender varchar(30),
  receiver varchar(30),
  msg varchar(160),
  senttime varchar(100),
  receivedtime varchar(100),
  reference varchar(100),
  status varchar(20),
  operator varchar(100)
);