pop_id INTEGER DEFAULT 0 NOT NULL,
imap_id INTEGER DEFAULT 0 NOT NULL,
box_id INTEGER DEFAULT 0 NOT NULL,
+ exchange_id INTEGER DEFAULT 0 NOT NULL,
pmodtime DATE DEFAULT SYSDATE NOT NULL,
pmodby INTEGER DEFAULT 0 NOT NULL,
pmodwith VARCHAR(8) DEFAULT CHR(0) NOT NULL,
created DATE DEFAULT SYSDATE NOT NULL,
creator INTEGER DEFAULT 0 NOT NULL,
winhomedir VARCHAR(260) DEFAULT '[DFS]' NOT NULL,
- winprofiledir VARCHAR(260) DEFAULT '[DFS]' NOT NULL
+ winprofiledir VARCHAR(260) DEFAULT '[DFS]' NOT NULL,
+ sponsor_type VARCHAR(8) DEFAULT 'NONE' NOT NULL,
+ sponsor_id INTEGER DEFAULT 0 NOT NULL,
+ expiration VARCHAR(24) DEFAULT CHR(0) NOT NULL
);
create table krbmap
(
name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
- hwtype VARCHAR(16) DEFAULT CHR(0) NOT NULL,
+ hwtype VARCHAR(64) DEFAULT CHR(0) NOT NULL,
duplexname VARCHAR(16) DEFAULT CHR(0) NOT NULL,
mach_id INTEGER DEFAULT 0 NOT NULL,
loghost INTEGER DEFAULT 0 NOT NULL,
(
account_number VARCHAR(10) DEFAULT CHR(0) NOT NULL
);
+
+create table userhistory
+(
+ login VARCHAR(8) DEFAULT CHR(0) NOT NULL,
+ users_id INTEGER DEFAULT 0 NOT NULL,
+ unix_uid SMALLINT DEFAULT 0 NOT NULL,
+ shell VARCHAR(32) DEFAULT CHR(0) NOT NULL,
+ winconsoleshell VARCHAR(32) DEFAULT 'cmd' NOT NULL,
+ last VARCHAR(30) DEFAULT CHR(0) NOT NULL,
+ first VARCHAR(30) DEFAULT CHR(0) NOT NULL,
+ middle VARCHAR(30) DEFAULT CHR(0) NOT NULL,
+ status SMALLINT DEFAULT 0 NOT NULL,
+ clearid VARCHAR(16) DEFAULT CHR(0) NOT NULL,
+ type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
+ comments INTEGER DEFAULT 0 NOT NULL,
+ modtime DATE DEFAULT SYSDATE NOT NULL,
+ modby INTEGER DEFAULT 0 NOT NULL,
+ modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL,
+ fullname VARCHAR(92) DEFAULT CHR(0) NOT NULL,
+ nickname VARCHAR(16) DEFAULT CHR(0) NOT NULL,
+ home_addr VARCHAR(82) DEFAULT CHR(0) NOT NULL,
+ home_phone VARCHAR(24) DEFAULT CHR(0) NOT NULL,
+ office_addr VARCHAR(16) DEFAULT CHR(0) NOT NULL,
+ office_phone VARCHAR(24) DEFAULT CHR(0) NOT NULL,
+ department VARCHAR(50) DEFAULT CHR(0) NOT NULL,
+ affiliation VARCHAR(50) DEFAULT CHR(0) NOT NULL,
+ fmodtime DATE DEFAULT SYSDATE NOT NULL,
+ fmodby INTEGER DEFAULT 0 NOT NULL,
+ fmodwith VARCHAR(8) DEFAULT CHR(0) NOT NULL,
+ potype VARCHAR(8) DEFAULT CHR(0) NOT NULL,
+ pop_id INTEGER DEFAULT 0 NOT NULL,
+ imap_id INTEGER DEFAULT 0 NOT NULL,
+ box_id INTEGER DEFAULT 0 NOT NULL,
+ pmodtime DATE DEFAULT SYSDATE NOT NULL,
+ pmodby INTEGER DEFAULT 0 NOT NULL,
+ pmodwith VARCHAR(8) DEFAULT CHR(0) NOT NULL,
+ xname VARCHAR(30) DEFAULT CHR(0) NOT NULL,
+ xdept VARCHAR(50) DEFAULT CHR(0) NOT NULL,
+ xtitle VARCHAR(50) DEFAULT CHR(0) NOT NULL,
+ xaddress VARCHAR(82) DEFAULT CHR(0) NOT NULL,
+ xphone1 VARCHAR(24) DEFAULT CHR(0) NOT NULL,
+ xphone2 VARCHAR(24) DEFAULT CHR(0) NOT NULL,
+ xmodtime DATE DEFAULT SYSDATE NOT NULL,
+ sigdate INTEGER DEFAULT 0 NOT NULL,
+ sigwho INTEGER DEFAULT 0 NOT NULL,
+ signature VARCHAR(68) DEFAULT CHR(0) NOT NULL,
+ secure INTEGER DEFAULT 0 NOT NULL,
+ pin VARCHAR(10) DEFAULT CHR(0) NOT NULL,
+ reservations VARCHAR(10) DEFAULT CHR(0) NOT NULL,
+ flag INTEGER DEFAULT 0 NOT NULL,
+ created DATE DEFAULT SYSDATE NOT NULL,
+ creator INTEGER DEFAULT 0 NOT NULL,
+ winhomedir VARCHAR(260) DEFAULT '[DFS]' NOT NULL,
+ winprofiledir VARCHAR(260) DEFAULT '[DFS]' NOT NULL,
+ purged DATE DEFAULT SYSDATE NOT NULL
+);