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_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,
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
+);