Subversion Repositories Sigmater

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
6 Andrea 1
create table WS_RUOLI
2
(
3
  COD_PROFILO_U       NUMBER(10) not null,
4
  USERNAME            VARCHAR2(20) not null,
5
  FLG_NOTIFICA_EVENTI NUMBER(1)
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_RUOLI
18
  add constraint PK_WS_RUOLI primary key (COD_PROFILO_U, USERNAME)
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_RUOLI
31
  add constraint FK_WS_RUOLI_REF_13_WS_PROFI foreign key (COD_PROFILO_U)
32
  references WS_PROFILI_UTENTE (COD_PROFILO_U);
33
alter table WS_RUOLI
34
  add constraint FK_WS_RUOLI_REF_9_WS_UTENT foreign key (USERNAME)
35
  references WS_UTENTI (USERNAME);
36