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 CHR(0) 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,
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,
sigwho INTEGER DEFAULT 0 NOT NULL,
signature VARCHAR(68) DEFAULT CHR(0) NOT NULL,
secure INTEGER DEFAULT 0 NOT NULL,
+ reservations VARCHAR(10) DEFAULT CHR(0) NOT NULL,
flag 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,
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 CHR(0) 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,
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,
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,