Subversion Repositories Sigmater

create table WS_RUOLI
(
  COD_PROFILO_U       NUMBER(10) not null,
  USERNAME            VARCHAR2(20) not null,
  FLG_NOTIFICA_EVENTI NUMBER(1)
)
tablespace &REGMON_TBS_NAME
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table WS_RUOLI
  add constraint PK_WS_RUOLI primary key (COD_PROFILO_U, USERNAME)
  using index 
  tablespace &REGMON_TBS_NAME
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table WS_RUOLI
  add constraint FK_WS_RUOLI_REF_13_WS_PROFI foreign key (COD_PROFILO_U)
  references WS_PROFILI_UTENTE (COD_PROFILO_U);
alter table WS_RUOLI
  add constraint FK_WS_RUOLI_REF_9_WS_UTENT foreign key (USERNAME)
  references WS_UTENTI (USERNAME);