Subversion Repositories Sigmater

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
6 Andrea 1 
create table WS_CROSS_ATTRIBUTI_FUNZ
2 
(
3 
  COD_FUNZIONE  NUMBER(10) not null,
4 
  COD_ATTRIBUTO NUMBER(10) not null,
5 
  VALORE        VARCHAR2(255)
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_CROSS_ATTRIBUTI_FUNZ
18 
  add constraint PK_WS_CROSS_ATTRIBUTI_FUNZ primary key (COD_ATTRIBUTO, COD_FUNZIONE)
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_CROSS_ATTRIBUTI_FUNZ
31 
  add constraint FK_FUNZ_ATTR2ATTR foreign key (COD_ATTRIBUTO)
32 
  references WS_ATTRIBUTI_FUNZIONE (COD_ATTRIBUTO);
33 
alter table WS_CROSS_ATTRIBUTI_FUNZ
34 
  add constraint FK_FUNZ_ATTR2FUNZ foreign key (COD_FUNZIONE)
35 
  references WS_FUNZIONI (COD_FUNZIONE);
36 
create index I_FUNZATTR_ATTRIBUTI on WS_CROSS_ATTRIBUTI_FUNZ (COD_ATTRIBUTO)
37 
  tablespace &REGMON_TBS_NAME
38 
  pctfree 10
39 
  initrans 2
40 
  maxtrans 255
41 
  storage
42 
  (
43 
    initial 64K
44 
    minextents 1
45 
    maxextents unlimited
46 
  );
47 
create index I_FUNZATTR_FUNZIONI on WS_CROSS_ATTRIBUTI_FUNZ (COD_FUNZIONE)
48 
  tablespace &REGMON_TBS_NAME
49 
  pctfree 10
50 
  initrans 2
51 
  maxtrans 255
52 
  storage
53 
  (
54 
    initial 64K
55 
    minextents 1
56 
    maxextents unlimited
57 
  );
58