Subversion Repositories Sigmater

create table WS_CROSS_ENTI_UTENTI
(
  USERNAME VARCHAR2(20) not null,
  ID       NUMBER not null
)
tablespace &REGMON_TBS_NAME
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table WS_CROSS_ENTI_UTENTI
  add constraint PK_CROSS_ENTI_UTENTI primary key (USERNAME, ID)
  using index 
  tablespace &REGMON_TBS_NAME
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table WS_CROSS_ENTI_UTENTI
  add constraint FK_CROSS_ENTI_1 foreign key (ID)
  references WS_ENTI (ID);
alter table WS_CROSS_ENTI_UTENTI
  add constraint FK_CROSS_UTENTI_1 foreign key (USERNAME)
  references WS_UTENTI (USERNAME);
create index ENTI on WS_CROSS_ENTI_UTENTI (ID)
  tablespace &REGMON_TBS_NAME
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
create index UTENTI on WS_CROSS_ENTI_UTENTI (USERNAME)
  tablespace &REGMON_TBS_NAME
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );