Subversion Repositories Sigmater

create table WS_LOG_LOGIN
(
  USERNAME    VARCHAR2(100) not null,
  DESCRIZIONE VARCHAR2(200),
  LAST_LOGIN  DATE,
  CLIENT_ID   VARCHAR2(100)
)
tablespace &REGMON_TBS_NAME
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table WS_LOG_LOGIN
  add constraint WS_LOG_LOGIN_ID primary key (USERNAME);
create unique index WS_LOGIN_LOG_PK on WS_LOG_LOGIN (USERNAME)
  tablespace &REGMON_TBS_NAME
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );