Olá Saulo, vou postar aqui.
Neste caso, estão sem as chaves.
Acredito que seja compatível com qualquer banco.
CREATE TABLE UCLOG (
APPLICATIONID VARCHAR(250) NOT NULL,
IDUSER INTEGER NOT NULL,
MSG VARCHAR(260),
DATA VARCHAR(14) NOT NULL,
NIVEL INTEGER
);
CREATE TABLE UCTABHISTORY (
APPLICATIONID VARCHAR(250),
USERID INTEGER,
EVENTDATE CHAR(10),
EVENTTIME CHAR(8),
FORM VARCHAR(250),
FORMCAPTION VARCHAR(100),
“EVENT” VARCHAR(50),
OBS BLOB SUB_TYPE 1 SEGMENT SIZE 1024,
TNAME VARCHAR(50)
);
CREATE TABLE UCTABMESSAGES (
IDMSG INTEGER,
USRFROM INTEGER,
USRTO INTEGER,
SUBJECT VARCHAR(50),
MSG VARCHAR(255),
DTSEND VARCHAR(12),
DTRECEIVE VARCHAR(12)
);
CREATE TABLE UCTABRIGHTS (
UCIDUSER INTEGER NOT NULL,
UCMODULE VARCHAR(50) NOT NULL,
UCCOMPNAME VARCHAR(50) NOT NULL,
UCKEY VARCHAR(250)
);
CREATE TABLE UCTABRIGHTSEX (
UCIDUSER INTEGER NOT NULL,
UCMODULE VARCHAR(50) NOT NULL,
UCCOMPNAME VARCHAR(50) NOT NULL,
UCFORMNAME VARCHAR(50) NOT NULL,
UCKEY VARCHAR(250)
);
CREATE TABLE UCTABUSERS (
UCIDUSER INTEGER NOT NULL,
UCUSERNAME VARCHAR(30),
UCLOGIN VARCHAR(30),
UCPASSWORD VARCHAR(250),
UCPASSEXPIRED CHAR(10),
UCUSEREXPIRED INTEGER,
UCUSERDAYSSUN INTEGER,
UCEMAIL VARCHAR(150),
UCPRIVILEGED INTEGER,
UCTYPEREC CHAR(1),
UCPROFILE INTEGER,
UCKEY VARCHAR(250),
UCINATIVE INTEGER,
UCIMAGE BLOB SUB_TYPE 0 SEGMENT SIZE 16384
);
CREATE TABLE UCTABUSERSLOGGED (
UCIDLOGON CHAR(38),
UCIDUSER INTEGER,
UCAPPLICATIONID VARCHAR(50),
UCMACHINENAME VARCHAR(50),
UCDATA VARCHAR(14)
);