Subversion Repositories Sigmater

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
6 Andrea 1 
create table WS_FILTRI
2 
(
3 
  COD_FILTRO  NUMBER(10) not null,
4 
  DESCRIZIONE VARCHAR2(100),
5 
  VALORE      VARCHAR2(100),
6 
  FLG_TIPO    CHAR(1)
7 
)
8 
tablespace &REGMON_TBS_NAME
9 
  pctfree 10
10 
  initrans 1
11 
  maxtrans 255
12 
  storage
13 
  (
14 
    initial 64K
15 
    minextents 1
16 
    maxextents unlimited
17 
  );
18 
alter table WS_FILTRI
19 
  add constraint PK_WS_FILTRI primary key (COD_FILTRO)
20 
  using index
21 
  tablespace &REGMON_TBS_NAME
22 
  pctfree 10
23 
  initrans 2
24 
  maxtrans 255
25 
  storage
26 
  (
27 
    initial 64K
28 
    minextents 1
29 
    maxextents unlimited
30 
  );
31