Subversion Repositories Sigmater

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
6 Andrea 1 
create table WS_APPLICAZIONI
2 
(
3 
  COD_APPLICAZIONE NUMBER(10) not null,
4 
  NOME             VARCHAR2(255) not null,
5 
  DESCRIZIONE      VARCHAR2(255) not null,
6 
  FLAG             VARCHAR2(1),
7 
  FLAG_RISERVATO   VARCHAR2(1),
8 
  URL              VARCHAR2(255)
9 
)
10 
tablespace &REGMON_TBS_NAME
11 
  pctfree 10
12 
  initrans 1
13 
  maxtrans 255
14 
  storage
15 
  (
16 
    initial 64K
17 
    minextents 1
18 
    maxextents unlimited
19 
  );
20 
alter table WS_APPLICAZIONI
21 
  add constraint PK_WS_APPLICAZIONI primary key (COD_APPLICAZIONE)
22 
  using index
23 
  tablespace &REGMON_TBS_NAME
24 
  pctfree 10
25 
  initrans 2
26 
  maxtrans 255
27 
  storage
28 
  (
29 
    initial 64K
30 
    minextents 1
31 
    maxextents unlimited
32 
  );
33 
grant select on WS_APPLICAZIONI to &MONIT_USER_NAME;
34 
grant select on WS_APPLICAZIONI to PUBLIC;
35