Subversion Repositories Sigmater

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
6 Andrea 1 
create table WS_LOG_EVENTI
2 
(
3 
  LOG_EVENTI_ID    NUMBER(20) not null,
4 
  EVENTO_ID        VARCHAR2(30),
5 
  TIME             VARCHAR2(100),
6 
  OPERATORE        VARCHAR2(50),
7 
  DESCRIZIONE      VARCHAR2(100),
8 
  SUBJECT          VARCHAR2(100),
9 
  DESCRIZIONE_BLOB CLOB,
10 
  COD_PROFILO_U    NUMBER(10)
11 
)
12 
tablespace &REGMON_TBS_NAME
13 
  pctfree 10
14 
  initrans 1
15 
  maxtrans 255
16 
  storage
17 
  (
18 
    initial 64K
19 
    minextents 1
20 
    maxextents unlimited
21 
  );
22 
alter table WS_LOG_EVENTI
23 
  add constraint PK_WS_LOG_EVENTI primary key (LOG_EVENTI_ID)
24 
  using index
25 
  tablespace &REGMON_TBS_NAME
26 
  pctfree 10
27 
  initrans 2
28 
  maxtrans 255
29 
  storage
30 
  (
31 
    initial 64K
32 
    minextents 1
33 
    maxextents unlimited
34 
  );
35 
alter table WS_LOG_EVENTI
36 
  add constraint FK_WS_LOG_E_REF_93_WS_EVENT foreign key (EVENTO_ID)
37 
  references WS_EVENTI (EVENTO_ID);
38 
alter table WS_LOG_EVENTI
39 
  add constraint FK_WS_LOG_E_WS_PROF_UTENTE foreign key (COD_PROFILO_U)
40 
  references WS_PROFILI_UTENTE (COD_PROFILO_U);
41