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,
+ 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,
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,
+ 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,
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,
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,
+ 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,
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(32) 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,
sid VARCHAR(64) DEFAULT CHR(0) NOT NULL,
created DATE DEFAULT SYSDATE NOT NULL
);
+
+create table containers
+(
+ name VARCHAR(64) DEFAULT CHR(0) NOT NULL,
+ cnt_id 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
+);