Subversion Repositories Sigmater

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
6 Andrea 1 
create table WS_ABILITAZIONI
2 
(
3 
  COD_PROFILO_U    NUMBER(10) not null,
4 
  COD_PROFILO_FUNZ NUMBER(10) not null,
5 
  COD_FILTRO       NUMBER(10)
6 
)
7 
tablespace &REGMON_TBS_NAME
8 
  pctfree 10
9 
  initrans 1
10 
  maxtrans 255
11 
  storage
12 
  (
13 
    initial 64K
14 
    minextents 1
15 
    maxextents unlimited
16 
  );
17 
alter table WS_ABILITAZIONI
18 
  add constraint PK_WS_ABILITAZIONI primary key (COD_PROFILO_U, COD_PROFILO_FUNZ)
19 
  using index
20 
  tablespace &REGMON_TBS_NAME
21 
  pctfree 10
22 
  initrans 2
23 
  maxtrans 255
24 
  storage
25 
  (
26 
    initial 64K
27 
    minextents 1
28 
    maxextents unlimited
29 
  );
30 
alter table WS_ABILITAZIONI
31 
  add constraint FK_WS_ABILI_REF_63_WS_PROFI foreign key (COD_PROFILO_U)
32 
  references WS_PROFILI_UTENTE (COD_PROFILO_U);
33 
alter table WS_ABILITAZIONI
34 
  add constraint FK_WS_ABILI_REF_67_WS_PROFI foreign key (COD_PROFILO_FUNZ)
35 
  references WS_PROFILI_FUNZIONE (COD_PROFILO_FUNZ) on delete cascade;
36 
alter table WS_ABILITAZIONI
37 
  add constraint FK_WS_ABILI_REF_71_WS_FILTR foreign key (COD_FILTRO)
38 
  references WS_FILTRI (COD_FILTRO);
39