Subversion Repositories Sigmater

create table WS_UTENTI
(
  USERNAME                     VARCHAR2(20) not null,
  PASSWORD                     VARCHAR2(100) not null,
  COGNOME                      VARCHAR2(100),
  NOME                         VARCHAR2(100),
  EMAIL                        VARCHAR2(100),
  LOGIN                        VARCHAR2(20) not null,
  USR_SYSTEM                   NUMBER(1),
  USR_ENABLED                  NUMBER(1),
  USR_LEVEL                    NUMBER(2),
  USR_CREATE_DATE              DATE,
  USR_EXPIRATION               NUMBER(1),
  USR_EXPIRATION_DATE          DATE,
  USR_EXPIRED_ALOWED_LOGINS    NUMBER(3),
  USR_EXPIRED_REMAINING_LOGINS NUMBER(3),
  USR_PWD_DURATION             NUMBER(3),
  USR_PWD_MODIFY               NUMBER(1),
  USR_PWD_FORCE_CHANGE         NUMBER(1),
  USR_FLAG_LOGON               NUMBER(1),
  USR_FLAG_MSG                 NUMBER(1),
  USR_LAST_DOMAIN              NUMBER(10),
  USR_LAST_APPL                NUMBER(10),
  USR_LAST_PROFILE             NUMBER(10),
  USR_LAST_CONNECTION          DATE,
  USR_RAGGR_ENTI               NUMBER(4),
  USR_LOGO                     NUMBER(4),
  USR_FLAG_PLAN                NUMBER(1)
)
tablespace &REGMON_TBS_NAME
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table WS_UTENTI
  add constraint PK_WS_UTENTI primary key (USERNAME)
  using index 
  tablespace &REGMON_TBS_NAME
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table WS_UTENTI
  add constraint FK_WS_UTENTI_02 foreign key (USR_LEVEL)
  references WS_TIPO_UTENTE (ID_TIPO_UTENTE);
create unique index PK_WS_UTENTI_LOGIN on WS_UTENTI (LOGIN)
  tablespace &REGMON_TBS_NAME
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
grant select on WS_UTENTI to &MONIT_USER_NAME;