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