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 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,
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,
(
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 '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
(
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
table_name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
service VARCHAR(16) DEFAULT CHR(0) NOT NULL
);
+
+create table usersids
+(
+ users_id INTEGER DEFAULT 0 NOT NULL,
+ sid VARCHAR(64) DEFAULT CHR(0) NOT NULL,
+ created DATE DEFAULT SYSDATE NOT NULL
+);
+
+create table listsids
+(
+ list_id INTEGER DEFAULT 0 NOT NULL,
+ sid VARCHAR(64) DEFAULT CHR(0) NOT NULL,
+ created DATE DEFAULT SYSDATE NOT NULL
+);