Subversion Repositories Sigmater

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
6 Andrea 1 
create table WS_LOG_LOGIN
2 
(
3 
  USERNAME    VARCHAR2(100) not null,
4 
  DESCRIZIONE VARCHAR2(200),
5 
  LAST_LOGIN  DATE,
6 
  CLIENT_ID   VARCHAR2(100)
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_LOG_LOGIN
19 
  add constraint WS_LOG_LOGIN_ID primary key (USERNAME);
20 
create unique index WS_LOGIN_LOG_PK on WS_LOG_LOGIN (USERNAME)
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