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,
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(16) 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(12) 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,
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,
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(12) DEFAULT CHR(0) NOT NULL,
- xphone2 VARCHAR(12) 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
+ 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,
+ 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
model VARCHAR(24) DEFAULT CHR(0) NOT NULL,
os VARCHAR(16) DEFAULT CHR(0) NOT NULL,
location VARCHAR(16) DEFAULT CHR(0) NOT NULL,
- contact VARCHAR(32) DEFAULT CHR(0) NOT NULL,
+ contact VARCHAR(255) DEFAULT CHR(0) NOT NULL,
+ billing_contact VARCHAR(255) DEFAULT CHR(0) NOT NULL,
+ account_number VARCHAR(10) DEFAULT CHR(0) NOT NULL,
use INTEGER DEFAULT 0 NOT NULL,
status INTEGER DEFAULT 0 NOT NULL,
statuschange DATE DEFAULT SYSDATE NOT NULL,
name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
snet_id INTEGER DEFAULT 0 NOT NULL,
description VARCHAR(48) DEFAULT CHR(0) NOT NULL,
+ status INTEGER DEFAULT 0 NOT NULL,
+ contact VARCHAR(255) DEFAULT CHR(0) NOT NULL,
+ account_number VARCHAR(10) DEFAULT CHR(0) NOT NULL,
saddr INTEGER DEFAULT 0 NOT NULL,
mask INTEGER DEFAULT 0 NOT NULL,
low INTEGER DEFAULT 0 NOT NULL,
maillist INTEGER DEFAULT 0 NOT NULL,
grouplist INTEGER DEFAULT 0 NOT NULL,
gid SMALLINT DEFAULT 0 NOT NULL,
+ nfsgroup INTEGER DEFAULT 0 NOT NULL,
+ mailman INTEGER DEFAULT 0 NOT NULL,
+ mailman_id INTEGER DEFAULT 0 NOT NULL,
description VARCHAR(255) DEFAULT CHR(0) NOT NULL,
acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
acl_id INTEGER DEFAULT 0 NOT NULL,
+ memacl_type VARCHAR(8) DEFAULT 'NONE' NOT NULL,
+ memacl_id 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
iws_id INTEGER DEFAULT 0 NOT NULL,
iui_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
iui_id INTEGER DEFAULT 0 NOT NULL,
+ owner_type VARCHAR(8) DEFAULT 'NONE' NOT NULL,
+ owner_id 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
(
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,
table_name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
service VARCHAR(16) DEFAULT CHR(0) NOT NULL
);
+
+create table containers
+(
+ name VARCHAR(64) DEFAULT CHR(0) NOT NULL,
+ cnt_id INTEGER DEFAULT 0 NOT NULL,
+ list_id INTEGER DEFAULT 0 NOT NULL,
+ publicflg INTEGER DEFAULT 0 NOT NULL,
+ description VARCHAR(255) DEFAULT CHR(0) NOT NULL,
+ location VARCHAR(64) DEFAULT CHR(0) NOT NULL,
+ contact VARCHAR(32) DEFAULT CHR(0) NOT NULL,
+ acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
+ acl_id INTEGER DEFAULT 0 NOT NULL,
+ memacl_type VARCHAR(8) DEFAULT 'NONE' NOT NULL,
+ memacl_id 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
+);
+
+create table mcntmap
+(
+ mach_id INTEGER DEFAULT 0 NOT NULL,
+ cnt_id INTEGER DEFAULT 0 NOT NULL
+);
+
+create table accountnumbers
+(
+ 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
+);