Subversion Repositories Sigmater

create table WS_ISTANZE_APPL
(
  ISTANZA_APPL_ID NUMBER(10) not null,
  APPLICAZIONE_ID NUMBER(10) not null,
  ISTANZA_APPL    VARCHAR2(255) not null,
  URL_APPL        VARCHAR2(255),
  URL_WS          VARCHAR2(255)
)
tablespace &REGMON_TBS_NAME
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table WS_ISTANZE_APPL
  add constraint PK_WS_ISTANZE_APPL primary key (ISTANZA_APPL_ID)
  using index 
  tablespace &REGMON_TBS_NAME
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table WS_ISTANZE_APPL
  add constraint FK_WS_ISTAN_REFERENCE_WS_APPLI foreign key (APPLICAZIONE_ID)
  references WS_APPLICAZIONI (COD_APPLICAZIONE);