Subversion Repositories Sigmater

create table WS_LOG_EVENTI
(
  LOG_EVENTI_ID    NUMBER(20) not null,
  EVENTO_ID        VARCHAR2(30),
  TIME             VARCHAR2(100),
  OPERATORE        VARCHAR2(50),
  DESCRIZIONE      VARCHAR2(100),
  SUBJECT          VARCHAR2(100),
  DESCRIZIONE_BLOB CLOB,
  COD_PROFILO_U    NUMBER(10)
)
tablespace &REGMON_TBS_NAME
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table WS_LOG_EVENTI
  add constraint PK_WS_LOG_EVENTI primary key (LOG_EVENTI_ID)
  using index 
  tablespace &REGMON_TBS_NAME
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table WS_LOG_EVENTI
  add constraint FK_WS_LOG_E_REF_93_WS_EVENT foreign key (EVENTO_ID)
  references WS_EVENTI (EVENTO_ID);
alter table WS_LOG_EVENTI
  add constraint FK_WS_LOG_E_WS_PROF_UTENTE foreign key (COD_PROFILO_U)
  references WS_PROFILI_UTENTE (COD_PROFILO_U);