DROP TABLE BLC_USER_INFO_T;
CREATE TABLE BLC_USER_INFO_T
(CDUSER VARCHAR(128) NOT NULL PRIMARY KEY,
CDLOGINPASSWORD RAW(20),
CDPERSONALNO VARCHAR(128),
NMLASTNAMEJ VARCHAR(62),
NMFIRSTNAMEJ VARCHAR(62),
NMLASTNAMEK VARCHAR(62),
NMFIRSTNAMEK VARCHAR(62),
NMLASTNAMEE VARCHAR(62),
NMFIRSTNAMEE VARCHAR(62),
CDBELONGTO VARCHAR(128) NOT NULL,
CDJOBTITLE VARCHAR(128) NOT NULL,
NMMAILADDRESS VARCHAR(128),
NMTELOUTSIDE VARCHAR(128),
NMTELEXTENSION VARCHAR(128),
NUADMINAUTHORITY SMALLINT DEFAULT 0 NOT NULL,
NUALTERNATEAUTHORITY SMALLINT DEFAULT 0 NOT NULL,
CFLOGINSTATUS SMALLINT DEFAULT 0 NOT NULL,
CFSHARESTATUS SMALLINT DEFAULT 0 NOT NULL
);
CREATE INDEX BLC_USER_INFO_NMLASTNAMEJ ON BLC_USER_INFO_T (NMLASTNAMEJ);
CREATE INDEX BLC_USER_INFO_NMFIRSTNAMEJ ON BLC_USER_INFO_T (NMFIRSTNAMEJ);
CREATE INDEX BLC_USER_INFO_CDBELONGTO ON BLC_USER_INFO_T (CDBELONGTO); |