[moira.git] / db / schema.sql

create table users
(
	login		VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL,
	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,
	status		SMALLINT 	DEFAULT 0	NOT NULL,
	clearid		VARCHAR(16) 	DEFAULT CHR(0)	NOT NULL,
	type		VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL,
	comments        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,
	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(24) 	DEFAULT CHR(0)	NOT NULL,
	office_addr	VARCHAR(16) 	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,
	fmodby		INTEGER		DEFAULT 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,
	pmodwith	VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL,
	xname           VARCHAR(30)	DEFAULT CHR(0)	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(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,
	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
);

create table krbmap
(
	users_id	INTEGER		DEFAULT 0	NOT NULL,
	string_id	INTEGER		DEFAULT 0	NOT NULL
);

create table machine
(
	name		VARCHAR(255) 	DEFAULT CHR(0)	NOT NULL,
	mach_id		INTEGER		DEFAULT 0	NOT NULL,
	vendor		VARCHAR(16) 	DEFAULT CHR(0)	NOT NULL,
	model		VARCHAR(24) 	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,
	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,
	snet_id		INTEGER		DEFAULT 0	NOT NULL,
	address		VARCHAR(16)	DEFAULT CHR(0)	NOT NULL,
	hwaddr		VARCHAR(12)	DEFAULT CHR(0)	NOT NULL,
	owner_type	VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL,
	owner_id	INTEGER		DEFAULT 0	NOT NULL,
	acomment	INTEGER		DEFAULT 0	NOT NULL,
	ocomment	INTEGER		DEFAULT 0	NOT NULL,
	created		DATE 		DEFAULT SYSDATE	NOT NULL,
	creator		INTEGER		DEFAULT 0	NOT NULL,
	inuse		DATE		DEFAULT SYSDATE	NOT NULL,
	modtime		DATE    	DEFAULT SYSDATE	NOT NULL,
	modby		INTEGER		DEFAULT 0	NOT NULL,
	modwith		VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL
);

create table hostalias
(
	name		VARCHAR(255) 	DEFAULT CHR(0)	NOT NULL,
	mach_id		INTEGER	 	DEFAULT 0	NOT NULL
);

create table subnet
(
	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,
	high		INTEGER		DEFAULT 0	NOT NULL,
	prefix		VARCHAR(8)	DEFAULT CHR(0)	NOT NULL,
	owner_type	VARCHAR(8) 	DEFAULT CHR(0)	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
);

create table clusters
(
	name		VARCHAR(32) 	DEFAULT CHR(0)	NOT NULL,
	clu_id		INTEGER		DEFAULT 0	NOT NULL,
	description	VARCHAR(32) 	DEFAULT CHR(0)	NOT NULL,
	location	VARCHAR(64) 	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
);

create table mcmap
(
	mach_id		INTEGER		DEFAULT 0	NOT NULL,
	clu_id		INTEGER		DEFAULT 0	NOT NULL
);

create table svc
(
	clu_id		INTEGER		DEFAULT 0	NOT NULL,
	serv_label	VARCHAR(16) 	DEFAULT CHR(0)	NOT NULL,
	serv_cluster	VARCHAR(128) 	DEFAULT CHR(0)	NOT NULL
);

create table list
(
	name		VARCHAR(32) 	DEFAULT CHR(0)	NOT NULL,
	list_id		INTEGER		DEFAULT 0	NOT NULL,
	active		INTEGER 	DEFAULT 0	NOT NULL,
	publicflg	INTEGER 	DEFAULT 0	NOT NULL,
	hidden		INTEGER 	DEFAULT 0	NOT NULL,
	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
);

create table imembers 
(
	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
);

create table servers 
(
	name		VARCHAR(16) 	DEFAULT CHR(0)	NOT NULL,
	update_int	INTEGER		DEFAULT 0	NOT NULL,
	target_file	VARCHAR(64) 	DEFAULT CHR(0)	NOT NULL,
	script		VARCHAR(128) 	DEFAULT CHR(0)	NOT NULL,
	dfgen		INTEGER		DEFAULT 0	NOT NULL,
	dfcheck		INTEGER		DEFAULT 0	NOT NULL,
	type		VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL,
	enable		INTEGER 	DEFAULT 0	NOT NULL,
	inprogress	INTEGER 	DEFAULT 0	NOT NULL,
	harderror	INTEGER		DEFAULT 0	NOT NULL,
	errmsg		VARCHAR(80) 	DEFAULT CHR(0)	NOT NULL,
	acl_type	VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL,
	acl_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 serverhosts 
(
	service		VARCHAR(16) 	DEFAULT CHR(0)	NOT NULL,
	mach_id		INTEGER		DEFAULT 0	NOT NULL,
	success		INTEGER 	DEFAULT 0	NOT NULL,
	enable		INTEGER 	DEFAULT 0	NOT NULL,
	override	INTEGER 	DEFAULT 0	NOT NULL,
	inprogress	INTEGER 	DEFAULT 0	NOT NULL,
	hosterror	INTEGER		DEFAULT 0	NOT NULL,
	hosterrmsg	VARCHAR(80) 	DEFAULT CHR(0)	NOT NULL,
	ltt		INTEGER		DEFAULT 0	NOT NULL,
	lts		INTEGER		DEFAULT 0	NOT NULL,
	value1		INTEGER		DEFAULT 0	NOT NULL,
	value2		INTEGER		DEFAULT 0	NOT NULL,
	value3		VARCHAR(32) 	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
);

create table filesys 
(
	filsys_id	INTEGER		DEFAULT 0	NOT NULL,
	phys_id		INTEGER		DEFAULT 0	NOT NULL,
	label		VARCHAR(32) 	DEFAULT CHR(0)	NOT NULL,
	fs_order	INTEGER		DEFAULT 0	NOT NULL,
	type		VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL,
	mach_id		INTEGER		DEFAULT 0	NOT NULL,
	name		VARCHAR(80) 	DEFAULT CHR(0)	NOT NULL,
	mount		VARCHAR(32) 	DEFAULT CHR(0)	NOT NULL,
	rwaccess	CHAR(1) 	DEFAULT CHR(0)	NOT NULL,
	comments	VARCHAR(64) 	DEFAULT CHR(0)	NOT NULL,
	owner		INTEGER		DEFAULT 0	NOT NULL,
	owners		INTEGER		DEFAULT 0	NOT NULL,
	createflg	INTEGER 	DEFAULT 0	NOT NULL,
	lockertype	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
);

create table fsgroup
(
	group_id	INTEGER		DEFAULT 0	NOT NULL,
	filsys_id	INTEGER		DEFAULT 0	NOT NULL,
	key		VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL
);

create table nfsphys 
(
	nfsphys_id	INTEGER		DEFAULT 0	NOT NULL,
	mach_id		INTEGER		DEFAULT 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,
	modtime		DATE    	DEFAULT SYSDATE	NOT NULL,
	modby		INTEGER		DEFAULT 0	NOT NULL,
	modwith		VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL
);

create table quota 
(
	filsys_id	INTEGER		DEFAULT 0	NOT NULL,
	type		VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL,
	entity_id	INTEGER		DEFAULT 0	NOT NULL,
	phys_id		INTEGER		DEFAULT 0	NOT NULL,
	quota		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 zephyr 
(
	class		VARCHAR(16) 	DEFAULT CHR(0)	NOT NULL,
	xmt_type	VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL,
	xmt_id		INTEGER		DEFAULT 0	NOT NULL,
	sub_type	VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL,
	sub_id		INTEGER		DEFAULT 0	NOT NULL,
	iws_type	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
);

create table hostaccess 
(
	mach_id		INTEGER		DEFAULT 0	NOT NULL,
	acl_type	VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL,
	acl_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 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,
	string		VARCHAR(128)	DEFAULT CHR(0)	NOT NULL
);

create table services 
(
	name		VARCHAR(16) 	DEFAULT CHR(0)	NOT NULL,
	protocol	VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL,
	port		SMALLINT 	DEFAULT 0	NOT NULL,
	description	VARCHAR(64) 	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
);

create table printers
(
	name		VARCHAR(16) 	DEFAULT CHR(0)	NOT NULL,
	type		VARCHAR(8)	DEFAULT CHR(0)	NOT NULL,
	hwtype		VARCHAR(16)	DEFAULT CHR(0)	NOT NULL,
	duplexname	VARCHAR(16) 	DEFAULT CHR(0)	NOT NULL,
	mach_id		INTEGER		DEFAULT 0	NOT NULL,
	loghost		INTEGER		DEFAULT 0	NOT NULL,
	rm		INTEGER		DEFAULT 0	NOT NULL,
	rp		VARCHAR(16) 	DEFAULT CHR(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,
	location	VARCHAR(64)	DEFAULT CHR(0)	NOT NULL,
	contact		VARCHAR(64)	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
);

create table printservers
(
	mach_id		INTEGER		DEFAULT 0	NOT NULL,
	kind		VARCHAR(8)	DEFAULT CHR(0)	NOT NULL,
	printer_types	INTEGER		DEFAULT 0	NOT NULL,
	owner_type	VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL,
	owner_id	INTEGER		DEFAULT 0	NOT NULL,
	lpc_acl		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 capacls 
(
	capability	VARCHAR(32) 	DEFAULT CHR(0)	NOT NULL,
	tag		VARCHAR(4) 	DEFAULT CHR(0)	NOT NULL,
	list_id		INTEGER		DEFAULT 0	NOT NULL
);

create table alias 
(
	name		VARCHAR(32) 	DEFAULT CHR(0)	NOT NULL,
	type		VARCHAR(16) 	DEFAULT CHR(0)	NOT NULL,
	trans		VARCHAR(128) 	DEFAULT CHR(0)	NOT NULL
);

create table numvalues 
(
	name		VARCHAR(32) 	DEFAULT CHR(0)	NOT NULL,
	value		INTEGER		DEFAULT 0	NOT NULL
);

create table tblstats 
(
	table_name	VARCHAR(16)	DEFAULT CHR(0)	NOT NULL,
	modtime		DATE    	DEFAULT SYSDATE	NOT NULL,
	appends		INTEGER		DEFAULT 0	NOT NULL,
	updates		INTEGER		DEFAULT 0	NOT NULL,
	deletes		INTEGER		DEFAULT 0	NOT NULL
);

create table incremental
(
	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
);

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
);
Commit	Line	Data
c6161d79	1	create table users
c6161d79	2	(
c345c1f9	3	login VARCHAR(8) DEFAULT CHR(0) NOT NULL,
c6161d79	4	users_id INTEGER DEFAULT 0 NOT NULL,
c6161d79	5	unix_uid SMALLINT DEFAULT 0 NOT NULL,
c345c1f9	6	shell VARCHAR(32) DEFAULT CHR(0) NOT NULL,
7edef5b7	7	winconsoleshell VARCHAR(32) DEFAULT CHR(0) NOT NULL,
9281a4c3	8	last VARCHAR(30) DEFAULT CHR(0) NOT NULL,
	9	first VARCHAR(30) DEFAULT CHR(0) NOT NULL,
	10	middle VARCHAR(30) DEFAULT CHR(0) NOT NULL,
c6161d79	11	status SMALLINT DEFAULT 0 NOT NULL,
c6161d79	12	clearid VARCHAR(16) DEFAULT CHR(0) NOT NULL,
c345c1f9	13	type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
c6161d79	14	comments INTEGER DEFAULT 0 NOT NULL,
	15	modtime DATE DEFAULT SYSDATE NOT NULL,
	16	modby INTEGER DEFAULT 0 NOT NULL,
c345c1f9	17	modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL,
9281a4c3	18	fullname VARCHAR(92) DEFAULT CHR(0) NOT NULL,
c345c1f9	19	nickname VARCHAR(16) DEFAULT CHR(0) NOT NULL,
c345c1f9	20	home_addr VARCHAR(82) DEFAULT CHR(0) NOT NULL,
68d17ac6	21	home_phone VARCHAR(24) DEFAULT CHR(0) NOT NULL,
c345c1f9	22	office_addr VARCHAR(16) DEFAULT CHR(0) NOT NULL,
68d17ac6	23	office_phone VARCHAR(24) DEFAULT CHR(0) NOT NULL,
01cae672	24	department VARCHAR(50) DEFAULT CHR(0) NOT NULL,
c345c1f9	25	affiliation VARCHAR(50) DEFAULT CHR(0) NOT NULL,
c6161d79	26	fmodtime DATE DEFAULT SYSDATE NOT NULL,
c6161d79	27	fmodby INTEGER DEFAULT 0 NOT NULL,
c345c1f9	28	fmodwith VARCHAR(8) DEFAULT CHR(0) NOT NULL,
c345c1f9	29	potype VARCHAR(8) DEFAULT CHR(0) NOT NULL,
c6161d79	30	pop_id INTEGER DEFAULT 0 NOT NULL,
7509f097	31	imap_id INTEGER DEFAULT 0 NOT NULL,
c6161d79	32	box_id INTEGER DEFAULT 0 NOT NULL,
	33	pmodtime DATE DEFAULT SYSDATE NOT NULL,
	34	pmodby INTEGER DEFAULT 0 NOT NULL,
c345c1f9	35	pmodwith VARCHAR(8) DEFAULT CHR(0) NOT NULL,
c345c1f9	36	xname VARCHAR(30) DEFAULT CHR(0) NOT NULL,
01cae672	37	xdept VARCHAR(50) DEFAULT CHR(0) NOT NULL,
c345c1f9	38	xtitle VARCHAR(50) DEFAULT CHR(0) NOT NULL,
c345c1f9	39	xaddress VARCHAR(82) DEFAULT CHR(0) NOT NULL,
68d17ac6	40	xphone1 VARCHAR(24) DEFAULT CHR(0) NOT NULL,
68d17ac6	41	xphone2 VARCHAR(24) DEFAULT CHR(0) NOT NULL,
c6161d79	42	xmodtime DATE DEFAULT SYSDATE NOT NULL,
	43	sigdate INTEGER DEFAULT 0 NOT NULL,
	44	sigwho INTEGER DEFAULT 0 NOT NULL,
	45	signature VARCHAR(68) DEFAULT CHR(0) NOT NULL,
	46	secure INTEGER DEFAULT 0 NOT NULL,
0aa10fc1	47	reservations VARCHAR(10) DEFAULT CHR(0) NOT NULL,
c6161d79	48	flag INTEGER DEFAULT 0 NOT NULL
	49	);
	50
	51	create table krbmap
	52	(
	53	users_id INTEGER DEFAULT 0 NOT NULL,
	54	string_id INTEGER DEFAULT 0 NOT NULL
	55	);
	56
	57	create table machine
	58	(
01c6a9e2	59	name VARCHAR(255) DEFAULT CHR(0) NOT NULL,
c6161d79	60	mach_id INTEGER DEFAULT 0 NOT NULL,
c345c1f9	61	vendor VARCHAR(16) DEFAULT CHR(0) NOT NULL,
	62	model VARCHAR(24) DEFAULT CHR(0) NOT NULL,
	63	os VARCHAR(16) DEFAULT CHR(0) NOT NULL,
	64	location VARCHAR(16) DEFAULT CHR(0) NOT NULL,
	65	contact VARCHAR(32) DEFAULT CHR(0) NOT NULL,
d007b6ba	66	billing_contact VARCHAR(32) DEFAULT CHR(0) NOT NULL,
8b656b14	67	account_number VARCHAR(10) DEFAULT CHR(0) NOT NULL,
c6161d79	68	use INTEGER DEFAULT 0 NOT NULL,
	69	status INTEGER DEFAULT 0 NOT NULL,
	70	statuschange DATE DEFAULT SYSDATE NOT NULL,
	71	snet_id INTEGER DEFAULT 0 NOT NULL,
c345c1f9	72	address VARCHAR(16) DEFAULT CHR(0) NOT NULL,
0fead213	73	hwaddr VARCHAR(12) DEFAULT CHR(0) NOT NULL,
c345c1f9	74	owner_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
c6161d79	75	owner_id INTEGER DEFAULT 0 NOT NULL,
	76	acomment INTEGER DEFAULT 0 NOT NULL,
	77	ocomment INTEGER DEFAULT 0 NOT NULL,
	78	created DATE DEFAULT SYSDATE NOT NULL,
	79	creator INTEGER DEFAULT 0 NOT NULL,
	80	inuse DATE DEFAULT SYSDATE NOT NULL,
	81	modtime DATE DEFAULT SYSDATE NOT NULL,
	82	modby INTEGER DEFAULT 0 NOT NULL,
c345c1f9	83	modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
c6161d79	84	);
	85
	86	create table hostalias
	87	(
01c6a9e2	88	name VARCHAR(255) DEFAULT CHR(0) NOT NULL,
c6161d79	89	mach_id INTEGER DEFAULT 0 NOT NULL
	90	);
	91
	92	create table subnet
	93	(
c345c1f9	94	name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
c6161d79	95	snet_id INTEGER DEFAULT 0 NOT NULL,
c6161d79	96	description VARCHAR(48) DEFAULT CHR(0) NOT NULL,
0b8bc8b8	97	status INTEGER DEFAULT 0 NOT NULL,
	98	contact VARCHAR(32) DEFAULT CHR(0) NOT NULL,
	99	account_number VARCHAR(10) DEFAULT CHR(0) NOT NULL,
c6161d79	100	saddr INTEGER DEFAULT 0 NOT NULL,
	101	mask INTEGER DEFAULT 0 NOT NULL,
	102	low INTEGER DEFAULT 0 NOT NULL,
	103	high INTEGER DEFAULT 0 NOT NULL,
c345c1f9	104	prefix VARCHAR(8) DEFAULT CHR(0) NOT NULL,
c345c1f9	105	owner_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
c6161d79	106	owner_id INTEGER DEFAULT 0 NOT NULL,
	107	modtime DATE DEFAULT SYSDATE NOT NULL,
	108	modby INTEGER DEFAULT 0 NOT NULL,
c345c1f9	109	modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
c6161d79	110	);
	111
	112	create table clusters
	113	(
	114	name VARCHAR(32) DEFAULT CHR(0) NOT NULL,
	115	clu_id INTEGER DEFAULT 0 NOT NULL,
c345c1f9	116	description VARCHAR(32) DEFAULT CHR(0) NOT NULL,
c345c1f9	117	location VARCHAR(64) DEFAULT CHR(0) NOT NULL,
c6161d79	118	modtime DATE DEFAULT SYSDATE NOT NULL,
c6161d79	119	modby INTEGER DEFAULT 0 NOT NULL,
c345c1f9	120	modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
c6161d79	121	);
	122
	123	create table mcmap
	124	(
	125	mach_id INTEGER DEFAULT 0 NOT NULL,
	126	clu_id INTEGER DEFAULT 0 NOT NULL
	127	);
	128
	129	create table svc
	130	(
	131	clu_id INTEGER DEFAULT 0 NOT NULL,
	132	serv_label VARCHAR(16) DEFAULT CHR(0) NOT NULL,
2a04e22e	133	serv_cluster VARCHAR(128) DEFAULT CHR(0) NOT NULL
c6161d79	134	);
	135
	136	create table list
	137	(
	138	name VARCHAR(32) DEFAULT CHR(0) NOT NULL,
	139	list_id INTEGER DEFAULT 0 NOT NULL,
	140	active INTEGER DEFAULT 0 NOT NULL,
	141	publicflg INTEGER DEFAULT 0 NOT NULL,
	142	hidden INTEGER DEFAULT 0 NOT NULL,
	143	maillist INTEGER DEFAULT 0 NOT NULL,
	144	grouplist INTEGER DEFAULT 0 NOT NULL,
	145	gid SMALLINT DEFAULT 0 NOT NULL,
2a69e049	146	nfsgroup INTEGER DEFAULT 0 NOT NULL,
c345c1f9	147	description VARCHAR(255) DEFAULT CHR(0) NOT NULL,
c345c1f9	148	acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
c6161d79	149	acl_id INTEGER DEFAULT 0 NOT NULL,
faf02688	150	memacl_type VARCHAR(8) DEFAULT 'NONE' NOT NULL,
a7868226	151	memacl_id INTEGER DEFAULT 0 NOT NULL,
c6161d79	152	modtime DATE DEFAULT SYSDATE NOT NULL,
c6161d79	153	modby INTEGER DEFAULT 0 NOT NULL,
c345c1f9	154	modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
c6161d79	155	);
	156
	157	create table imembers
	158	(
	159	list_id INTEGER DEFAULT 0 NOT NULL,
c345c1f9	160	member_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
c6161d79	161	member_id INTEGER DEFAULT 0 NOT NULL,
5debd42e	162	tag INTEGER DEFAULT 0 NOT NULL,
c6161d79	163	ref_count SMALLINT DEFAULT 0 NOT NULL,
	164	direct SMALLINT DEFAULT 0 NOT NULL
	165	);
	166
	167	create table servers
	168	(
	169	name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
	170	update_int INTEGER DEFAULT 0 NOT NULL,
c345c1f9	171	target_file VARCHAR(64) DEFAULT CHR(0) NOT NULL,
c345c1f9	172	script VARCHAR(128) DEFAULT CHR(0) NOT NULL,
c6161d79	173	dfgen INTEGER DEFAULT 0 NOT NULL,
c6161d79	174	dfcheck INTEGER DEFAULT 0 NOT NULL,
c345c1f9	175	type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
c6161d79	176	enable INTEGER DEFAULT 0 NOT NULL,
	177	inprogress INTEGER DEFAULT 0 NOT NULL,
	178	harderror INTEGER DEFAULT 0 NOT NULL,
c345c1f9	179	errmsg VARCHAR(80) DEFAULT CHR(0) NOT NULL,
c345c1f9	180	acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
c6161d79	181	acl_id INTEGER DEFAULT 0 NOT NULL,
	182	modtime DATE DEFAULT SYSDATE NOT NULL,
	183	modby INTEGER DEFAULT 0 NOT NULL,
c345c1f9	184	modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
c6161d79	185	);
	186
	187	create table serverhosts
	188	(
	189	service VARCHAR(16) DEFAULT CHR(0) NOT NULL,
	190	mach_id INTEGER DEFAULT 0 NOT NULL,
	191	success INTEGER DEFAULT 0 NOT NULL,
	192	enable INTEGER DEFAULT 0 NOT NULL,
	193	override INTEGER DEFAULT 0 NOT NULL,
	194	inprogress INTEGER DEFAULT 0 NOT NULL,
	195	hosterror INTEGER DEFAULT 0 NOT NULL,
c345c1f9	196	hosterrmsg VARCHAR(80) DEFAULT CHR(0) NOT NULL,
c6161d79	197	ltt INTEGER DEFAULT 0 NOT NULL,
	198	lts INTEGER DEFAULT 0 NOT NULL,
	199	value1 INTEGER DEFAULT 0 NOT NULL,
	200	value2 INTEGER DEFAULT 0 NOT NULL,
c345c1f9	201	value3 VARCHAR(32) DEFAULT CHR(0) NOT NULL,
c6161d79	202	modtime DATE DEFAULT SYSDATE NOT NULL,
c6161d79	203	modby INTEGER DEFAULT 0 NOT NULL,
c345c1f9	204	modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
c6161d79	205	);
	206
	207	create table filesys
	208	(
	209	filsys_id INTEGER DEFAULT 0 NOT NULL,
	210	phys_id INTEGER DEFAULT 0 NOT NULL,
	211	label VARCHAR(32) DEFAULT CHR(0) NOT NULL,
	212	fs_order INTEGER DEFAULT 0 NOT NULL,
c345c1f9	213	type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
c6161d79	214	mach_id INTEGER DEFAULT 0 NOT NULL,
c6161d79	215	name VARCHAR(80) DEFAULT CHR(0) NOT NULL,
c345c1f9	216	mount VARCHAR(32) DEFAULT CHR(0) NOT NULL,
c6161d79	217	rwaccess CHAR(1) DEFAULT CHR(0) NOT NULL,
c345c1f9	218	comments VARCHAR(64) DEFAULT CHR(0) NOT NULL,
c6161d79	219	owner INTEGER DEFAULT 0 NOT NULL,
	220	owners INTEGER DEFAULT 0 NOT NULL,
	221	createflg INTEGER DEFAULT 0 NOT NULL,
c345c1f9	222	lockertype VARCHAR(8) DEFAULT CHR(0) NOT NULL,
c6161d79	223	modtime DATE DEFAULT SYSDATE NOT NULL,
c6161d79	224	modby INTEGER DEFAULT 0 NOT NULL,
c345c1f9	225	modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
c6161d79	226	);
	227
	228	create table fsgroup
	229	(
	230	group_id INTEGER DEFAULT 0 NOT NULL,
	231	filsys_id INTEGER DEFAULT 0 NOT NULL,
c345c1f9	232	key VARCHAR(8) DEFAULT CHR(0) NOT NULL
c6161d79	233	);
	234
	235	create table nfsphys
	236	(
	237	nfsphys_id INTEGER DEFAULT 0 NOT NULL,
	238	mach_id INTEGER DEFAULT 0 NOT NULL,
7509f097	239	device VARCHAR(32) DEFAULT CHR(0) NOT NULL,
7509f097	240	dir VARCHAR(64) DEFAULT CHR(0) NOT NULL,
c6161d79	241	status SMALLINT DEFAULT 0 NOT NULL,
	242	allocated INTEGER DEFAULT 0 NOT NULL,
	243	partsize INTEGER DEFAULT 0 NOT NULL,
	244	modtime DATE DEFAULT SYSDATE NOT NULL,
	245	modby INTEGER DEFAULT 0 NOT NULL,
c345c1f9	246	modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
c6161d79	247	);
	248
	249	create table quota
	250	(
	251	filsys_id INTEGER DEFAULT 0 NOT NULL,
c345c1f9	252	type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
c6161d79	253	entity_id INTEGER DEFAULT 0 NOT NULL,
	254	phys_id INTEGER DEFAULT 0 NOT NULL,
	255	quota INTEGER DEFAULT 0 NOT NULL,
	256	modtime DATE DEFAULT SYSDATE NOT NULL,
	257	modby INTEGER DEFAULT 0 NOT NULL,
c345c1f9	258	modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
c6161d79	259	);
	260
	261	create table zephyr
	262	(
	263	class VARCHAR(16) DEFAULT CHR(0) NOT NULL,
c345c1f9	264	xmt_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
c6161d79	265	xmt_id INTEGER DEFAULT 0 NOT NULL,
c345c1f9	266	sub_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
c6161d79	267	sub_id INTEGER DEFAULT 0 NOT NULL,
c345c1f9	268	iws_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
c6161d79	269	iws_id INTEGER DEFAULT 0 NOT NULL,
c345c1f9	270	iui_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
c6161d79	271	iui_id INTEGER DEFAULT 0 NOT NULL,
2fb84c10	272	owner_type VARCHAR(8) DEFAULT 'NONE' NOT NULL,
faf02688	273	owner_id INTEGER DEFAULT 0 NOT NULL,
c6161d79	274	modtime DATE DEFAULT SYSDATE NOT NULL,
c6161d79	275	modby INTEGER DEFAULT 0 NOT NULL,
c345c1f9	276	modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
c6161d79	277	);
	278
	279	create table hostaccess
	280	(
	281	mach_id INTEGER DEFAULT 0 NOT NULL,
c345c1f9	282	acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
c6161d79	283	acl_id INTEGER DEFAULT 0 NOT NULL,
	284	modtime DATE DEFAULT SYSDATE NOT NULL,
	285	modby INTEGER DEFAULT 0 NOT NULL,
c345c1f9	286	modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
c6161d79	287	);
c6161d79	288
5debd42e	289	create table acl
	290	(
	291	mach_id INTEGER DEFAULT 0 NOT NULL,
	292	target VARCHAR(128) DEFAULT CHR(0) NOT NULL,
	293	kind VARCHAR(16) DEFAULT CHR(0) NOT NULL,
	294	list_id INTEGER DEFAULT 0 NOT NULL,
	295	modtime DATE DEFAULT SYSDATE NOT NULL,
	296	modby INTEGER DEFAULT 0 NOT NULL,
	297	modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
	298	);
	299
c6161d79	300	create table strings
	301	(
	302	string_id INTEGER DEFAULT 0 NOT NULL,
	303	string VARCHAR(128) DEFAULT CHR(0) NOT NULL
	304	);
	305
	306	create table services
	307	(
	308	name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
c345c1f9	309	protocol VARCHAR(8) DEFAULT CHR(0) NOT NULL,
c6161d79	310	port SMALLINT DEFAULT 0 NOT NULL,
c345c1f9	311	description VARCHAR(64) DEFAULT CHR(0) NOT NULL,
c6161d79	312	modtime DATE DEFAULT SYSDATE NOT NULL,
c6161d79	313	modby INTEGER DEFAULT 0 NOT NULL,
c345c1f9	314	modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
c6161d79	315	);
c6161d79	316
0fead213	317	create table printers
c6161d79	318	(
c6161d79	319	name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
0fead213	320	type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
427fe83f	321	hwtype VARCHAR(16) DEFAULT CHR(0) NOT NULL,
0fead213	322	duplexname VARCHAR(16) DEFAULT CHR(0) NOT NULL,
c6161d79	323	mach_id INTEGER DEFAULT 0 NOT NULL,
0fead213	324	loghost INTEGER DEFAULT 0 NOT NULL,
0fead213	325	rm INTEGER DEFAULT 0 NOT NULL,
c345c1f9	326	rp VARCHAR(16) DEFAULT CHR(0) NOT NULL,
0fead213	327	rq INTEGER DEFAULT 0 NOT NULL,
	328	ka SMALLINT DEFAULT 0 NOT NULL,
	329	pc SMALLINT DEFAULT 0 NOT NULL,
66ba52df	330	mc SMALLINT DEFAULT 0 NOT NULL,
0fead213	331	ac INTEGER DEFAULT 0 NOT NULL,
0fead213	332	lpc_acl INTEGER DEFAULT 0 NOT NULL,
39de8ad2	333	banner INTEGER DEFAULT 0 NOT NULL,
0fead213	334	location VARCHAR(64) DEFAULT CHR(0) NOT NULL,
0fead213	335	contact VARCHAR(64) DEFAULT CHR(0) NOT NULL,
c6161d79	336	modtime DATE DEFAULT SYSDATE NOT NULL,
c6161d79	337	modby INTEGER DEFAULT 0 NOT NULL,
c345c1f9	338	modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
c6161d79	339	);
c6161d79	340
120cd8f9	341	create table printservers
	342	(
	343	mach_id INTEGER DEFAULT 0 NOT NULL,
	344	kind VARCHAR(8) DEFAULT CHR(0) NOT NULL,
	345	printer_types INTEGER DEFAULT 0 NOT NULL,
	346	owner_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
	347	owner_id INTEGER DEFAULT 0 NOT NULL,
	348	lpc_acl INTEGER DEFAULT 0 NOT NULL,
	349	modtime DATE DEFAULT SYSDATE NOT NULL,
	350	modby INTEGER DEFAULT 0 NOT NULL,
	351	modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
	352	);
	353
c6161d79	354	create table capacls
c6161d79	355	(
c345c1f9	356	capability VARCHAR(32) DEFAULT CHR(0) NOT NULL,
c345c1f9	357	tag VARCHAR(4) DEFAULT CHR(0) NOT NULL,
c6161d79	358	list_id INTEGER DEFAULT 0 NOT NULL
	359	);
	360
	361	create table alias
	362	(
	363	name VARCHAR(32) DEFAULT CHR(0) NOT NULL,
	364	type VARCHAR(16) DEFAULT CHR(0) NOT NULL,
	365	trans VARCHAR(128) DEFAULT CHR(0) NOT NULL
	366	);
	367
	368	create table numvalues
	369	(
	370	name VARCHAR(32) DEFAULT CHR(0) NOT NULL,
	371	value INTEGER DEFAULT 0 NOT NULL
	372	);
	373
	374	create table tblstats
	375	(
c345c1f9	376	table_name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
c6161d79	377	modtime DATE DEFAULT SYSDATE NOT NULL,
	378	appends INTEGER DEFAULT 0 NOT NULL,
	379	updates INTEGER DEFAULT 0 NOT NULL,
	380	deletes INTEGER DEFAULT 0 NOT NULL
	381	);
	382
	383	create table incremental
	384	(
c345c1f9	385	table_name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
c345c1f9	386	service VARCHAR(16) DEFAULT CHR(0) NOT NULL
c6161d79	387	);
de3d85c0	388
	389	create table usersids
	390	(
	391	users_id INTEGER DEFAULT 0 NOT NULL,
	392	sid VARCHAR(64) DEFAULT CHR(0) NOT NULL,
	393	created DATE DEFAULT SYSDATE NOT NULL
	394	);
	395
	396	create table listsids
	397	(
	398	list_id INTEGER DEFAULT 0 NOT NULL,
	399	sid VARCHAR(64) DEFAULT CHR(0) NOT NULL,
	400	created DATE DEFAULT SYSDATE NOT NULL
	401	);
327fb8c0	402
	403	create table containers
	404	(
c2cbb1dd	405	name VARCHAR(64) DEFAULT CHR(0) NOT NULL,
327fb8c0	406	cnt_id INTEGER DEFAULT 0 NOT NULL,
	407	description VARCHAR(255) DEFAULT CHR(0) NOT NULL,
	408	location VARCHAR(64) DEFAULT CHR(0) NOT NULL,
	409	contact VARCHAR(32) DEFAULT CHR(0) NOT NULL,
	410	acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
	411	acl_id INTEGER DEFAULT 0 NOT NULL,
	412	memacl_type VARCHAR(8) DEFAULT 'NONE' NOT NULL,
	413	memacl_id INTEGER DEFAULT 0 NOT NULL,
	414	modtime DATE DEFAULT SYSDATE NOT NULL,
	415	modby INTEGER DEFAULT 0 NOT NULL,
	416	modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
	417	);
	418
	419	create table mcntmap
	420	(
	421	mach_id INTEGER DEFAULT 0 NOT NULL,
	422	cnt_id INTEGER DEFAULT 0 NOT NULL
	423	);
8b656b14	424
	425	create table accountnumbers
	426	(
	427	account_number VARCHAR(10) DEFAULT CHR(0) NOT NULL
	428	);