CREATE TABLE uixloginnames
    (loginname                      VARCHAR2(16 CHAR) ,
    numloginname                   NUMBER(16,0),
    userloginid                    NUMBER(10,0),
    statusid                       NUMBER(5,0) DEFAULT 1,
    verifcumerrors                 NUMBER(10,0) DEFAULT 0 NOT NULL,
    password                       VARCHAR2(16 CHAR),
    defaultpsw                     VARCHAR2(16 CHAR),
    pswlastchange                  DATE DEFAULT SYSDATE,
    pswvalidity                    NUMBER(5,0) DEFAULT 365,
    pswhistory                     VARCHAR2(255 CHAR),
    pswhint                        VARCHAR2(255 CHAR),
    inputcharsetid                 NUMBER(5,0) DEFAULT 1 ,
    printcount                     NUMBER(5,0) DEFAULT 0,
    printreq                       NUMBER(1,0) DEFAULT 0,
    lastprintdate                  DATE,
    verifseqerrors                 NUMBER(10,0) DEFAULT 0,
    tmppsw                         VARCHAR2(16 BYTE),
    tmppswchange                   DATE,
    seqerrblockdate                DATE,
    dmtimestamp                    VARCHAR2(50 BYTE),
    tmppswexpiration               DATE,
    seqtmploginerrors              NUMBER(10,0))
  PCTFREE     15
  PCTUSED     80
  INITRANS    1
  MAXTRANS    255
  TABLESPACE  uixclient
  STORAGE   (
    INITIAL     16384
    NEXT        1572864
    PCTINCREASE 0
    MINEXTENTS  1
    MAXEXTENTS  2147483645
  )
  NOCACHE
  MONITORING
  NOPARALLEL
  LOGGING
/
