Subversion Repositories Sigmater

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
6 Andrea 1 
create table WS_UTENTI
2 
(
3 
  USERNAME                     VARCHAR2(20) not null,
4 
  PASSWORD                     VARCHAR2(100) not null,
5 
  COGNOME                      VARCHAR2(100),
6 
  NOME                         VARCHAR2(100),
7 
  EMAIL                        VARCHAR2(100),
8 
  LOGIN                        VARCHAR2(20) not null,
9 
  USR_SYSTEM                   NUMBER(1),
10 
  USR_ENABLED                  NUMBER(1),
11 
  USR_LEVEL                    NUMBER(2),
12 
  USR_CREATE_DATE              DATE,
13 
  USR_EXPIRATION               NUMBER(1),
14 
  USR_EXPIRATION_DATE          DATE,
15 
  USR_EXPIRED_ALOWED_LOGINS    NUMBER(3),
16 
  USR_EXPIRED_REMAINING_LOGINS NUMBER(3),
17 
  USR_PWD_DURATION             NUMBER(3),
18 
  USR_PWD_MODIFY               NUMBER(1),
19 
  USR_PWD_FORCE_CHANGE         NUMBER(1),
20 
  USR_FLAG_LOGON               NUMBER(1),
21 
  USR_FLAG_MSG                 NUMBER(1),
22 
  USR_LAST_DOMAIN              NUMBER(10),
23 
  USR_LAST_APPL                NUMBER(10),
24 
  USR_LAST_PROFILE             NUMBER(10),
25 
  USR_LAST_CONNECTION          DATE,
26 
  USR_RAGGR_ENTI               NUMBER(4),
27 
  USR_LOGO                     NUMBER(4),
28 
  USR_FLAG_PLAN                NUMBER(1)
29 
)
30 
tablespace &REGMON_TBS_NAME
31 
  pctfree 10
32 
  initrans 1
33 
  maxtrans 255
34 
  storage
35 
  (
36 
    initial 64K
37 
    minextents 1
38 
    maxextents unlimited
39 
  );
40 
alter table WS_UTENTI
41 
  add constraint PK_WS_UTENTI primary key (USERNAME)
42 
  using index
43 
  tablespace &REGMON_TBS_NAME
44 
  pctfree 10
45 
  initrans 2
46 
  maxtrans 255
47 
  storage
48 
  (
49 
    initial 64K
50 
    minextents 1
51 
    maxextents unlimited
52 
  );
53 
alter table WS_UTENTI
54 
  add constraint FK_WS_UTENTI_02 foreign key (USR_LEVEL)
55 
  references WS_TIPO_UTENTE (ID_TIPO_UTENTE);
56 
create unique index PK_WS_UTENTI_LOGIN on WS_UTENTI (LOGIN)
57 
  tablespace &REGMON_TBS_NAME
58 
  pctfree 10
59 
  initrans 2
60 
  maxtrans 255
61 
  storage
62 
  (
63 
    initial 64K
64 
    minextents 1
65 
    maxextents unlimited
66 
  );
67 
grant select on WS_UTENTI to &MONIT_USER_NAME;
68