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,
os VARCHAR(16) DEFAULT CHR(0) NOT NULL,
location VARCHAR(16) DEFAULT CHR(0) NOT NULL,
contact VARCHAR(32) DEFAULT CHR(0) NOT NULL,
+ billing_contact VARCHAR(32) DEFAULT CHR(0) NOT NULL,
use INTEGER DEFAULT 0 NOT NULL,
status INTEGER DEFAULT 0 NOT NULL,
statuschange DATE DEFAULT SYSDATE 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
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
+);