users_id INTEGER DEFAULT 0 NOT NULL,
unix_uid SMALLINT DEFAULT 0 NOT NULL,
shell VARCHAR(32) DEFAULT CHR(0) NOT NULL,
- last VARCHAR(16) DEFAULT CHR(0) NOT NULL,
- first VARCHAR(16) DEFAULT CHR(0) NOT NULL,
- middle VARCHAR(16) 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,
modtime DATE DEFAULT SYSDATE NOT NULL,
modby INTEGER DEFAULT 0 NOT NULL,
modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL,
- fullname VARCHAR(32) 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,
- department VARCHAR(20) 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,
+ 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,
xname VARCHAR(30) DEFAULT CHR(0) NOT NULL,
- xdept VARCHAR(20) 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,
- flag 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,
+ 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
create table machine
(
- name VARCHAR(40) DEFAULT CHR(0) NOT NULL,
+ name VARCHAR(255) DEFAULT CHR(0) NOT NULL,
mach_id INTEGER DEFAULT 0 NOT NULL,
vendor VARCHAR(16) DEFAULT CHR(0) NOT NULL,
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,
snet_id INTEGER DEFAULT 0 NOT NULL,
address VARCHAR(16) DEFAULT CHR(0) NOT NULL,
+ hwaddr VARCHAR(12) DEFAULT CHR(0) NOT NULL,
owner_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
owner_id INTEGER DEFAULT 0 NOT NULL,
acomment INTEGER DEFAULT 0 NOT NULL,
create table hostalias
(
- name VARCHAR(40) DEFAULT CHR(0) NOT NULL,
+ name VARCHAR(255) DEFAULT CHR(0) NOT NULL,
mach_id INTEGER DEFAULT 0 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,
(
clu_id INTEGER DEFAULT 0 NOT NULL,
serv_label VARCHAR(16) DEFAULT CHR(0) NOT NULL,
- serv_cluster VARCHAR(32) DEFAULT CHR(0) NOT NULL
+ serv_cluster VARCHAR(128) DEFAULT CHR(0) NOT NULL
);
create table list
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
list_id INTEGER DEFAULT 0 NOT NULL,
member_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
member_id INTEGER DEFAULT 0 NOT NULL,
+ tag INTEGER DEFAULT 0 NOT NULL,
ref_count SMALLINT DEFAULT 0 NOT NULL,
direct SMALLINT DEFAULT 0 NOT NULL
);
(
nfsphys_id INTEGER DEFAULT 0 NOT NULL,
mach_id INTEGER DEFAULT 0 NOT NULL,
- device VARCHAR(16) DEFAULT CHR(0) NOT NULL,
- dir VARCHAR(16) DEFAULT CHR(0) NOT NULL,
+ device VARCHAR(32) DEFAULT CHR(0) NOT NULL,
+ dir VARCHAR(64) DEFAULT CHR(0) NOT NULL,
status SMALLINT DEFAULT 0 NOT NULL,
allocated INTEGER DEFAULT 0 NOT NULL,
partsize INTEGER DEFAULT 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
modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
);
+create table acl
+(
+ mach_id INTEGER DEFAULT 0 NOT NULL,
+ target VARCHAR(128) DEFAULT CHR(0) NOT NULL,
+ kind VARCHAR(16) DEFAULT CHR(0) NOT NULL,
+ list_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 strings
(
string_id INTEGER DEFAULT 0 NOT NULL,
modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
);
-create table printcap
+create table printers
(
name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
+ type VARCHAR(8) 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,
- dir VARCHAR(32) DEFAULT CHR(0) NOT NULL,
+ loghost INTEGER DEFAULT 0 NOT NULL,
+ rm INTEGER DEFAULT 0 NOT NULL,
rp VARCHAR(16) DEFAULT CHR(0) NOT NULL,
- quotaserver INTEGER DEFAULT 0 NOT NULL,
- auth INTEGER DEFAULT 0 NOT NULL,
- price SMALLINT DEFAULT 0 NOT NULL,
- comments VARCHAR(64) DEFAULT CHR(0) NOT NULL,
+ rq INTEGER DEFAULT 0 NOT NULL,
+ ka SMALLINT DEFAULT 0 NOT NULL,
+ pc SMALLINT DEFAULT 0 NOT NULL,
+ mc SMALLINT DEFAULT 0 NOT NULL,
+ ac INTEGER DEFAULT 0 NOT NULL,
+ lpc_acl INTEGER DEFAULT 0 NOT NULL,
+ banner INTEGER DEFAULT 0 NOT NULL,
+ location VARCHAR(64) DEFAULT CHR(0) NOT NULL,
+ contact VARCHAR(64) DEFAULT CHR(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 palladium
+create table printservers
(
- name VARCHAR(32) DEFAULT CHR(0) NOT NULL,
- identifier INTEGER DEFAULT 0 NOT NULL,
mach_id INTEGER DEFAULT 0 NOT NULL,
+ kind VARCHAR(8) DEFAULT CHR(0) NOT NULL,
+ printer_types INTEGER DEFAULT 0 NOT NULL,
+ owner_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
+ owner_id INTEGER DEFAULT 0 NOT NULL,
+ lpc_acl 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
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
+);