Subversion Repositories Sigmater

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
6 Andrea 1 
create table WS_ATTRIBUTI_FUNZIONE
2 
(
3 
  COD_ATTRIBUTO NUMBER(10) not null,
4 
  NOME          VARCHAR2(255) not null
5 
)
6 
tablespace &REGMON_TBS_NAME
7 
  pctfree 10
8 
  initrans 1
9 
  maxtrans 255
10 
  storage
11 
  (
12 
    initial 64K
13 
    minextents 1
14 
    maxextents unlimited
15 
  );
16 
alter table WS_ATTRIBUTI_FUNZIONE
17 
  add constraint PK_WS_ATTRIBUTI_FUNZIONE primary key (COD_ATTRIBUTO)
18 
  using index
19 
  tablespace &REGMON_TBS_NAME
20 
  pctfree 10
21 
  initrans 2
22 
  maxtrans 255
23 
  storage
24 
  (
25 
    initial 64K
26 
    minextents 1
27 
    maxextents unlimited
28 
  );
29 
create index I_NOMETTRIBUTO on WS_ATTRIBUTI_FUNZIONE (NOME)
30 
  tablespace &REGMON_TBS_NAME
31 
  pctfree 10
32 
  initrans 2
33 
  maxtrans 255
34 
  storage
35 
  (
36 
    initial 64K
37 
    minextents 1
38 
    maxextents unlimited
39 
  );
40