Subversion Repositories Sigmater

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
6 Andrea 1 
create table WS_CROSS_ENTI_UTENTI
2 
(
3 
  USERNAME VARCHAR2(20) not null,
4 
  ID       NUMBER 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_CROSS_ENTI_UTENTI
17 
  add constraint PK_CROSS_ENTI_UTENTI primary key (USERNAME, ID)
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 
alter table WS_CROSS_ENTI_UTENTI
30 
  add constraint FK_CROSS_ENTI_1 foreign key (ID)
31 
  references WS_ENTI (ID);
32 
alter table WS_CROSS_ENTI_UTENTI
33 
  add constraint FK_CROSS_UTENTI_1 foreign key (USERNAME)
34 
  references WS_UTENTI (USERNAME);
35 
create index ENTI on WS_CROSS_ENTI_UTENTI (ID)
36 
  tablespace &REGMON_TBS_NAME
37 
  pctfree 10
38 
  initrans 2
39 
  maxtrans 255
40 
  storage
41 
  (
42 
    initial 64K
43 
    minextents 1
44 
    maxextents unlimited
45 
  );
46 
create index UTENTI on WS_CROSS_ENTI_UTENTI (USERNAME)
47 
  tablespace &REGMON_TBS_NAME
48 
  pctfree 10
49 
  initrans 2
50 
  maxtrans 255
51 
  storage
52 
  (
53 
    initial 64K
54 
    minextents 1
55 
    maxextents unlimited
56 
  );
57