[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,
	winhomedir	VARCHAR(260)	DEFAULT '[DFS]' NOT NULL,
	winprofiledir	VARCHAR(260)	DEFAULT '[DFS]' NOT NULL,
	sponsor_type	VARCHAR(8) 	DEFAULT 'NONE'	NOT NULL,
	sponsor_id	INTEGER		DEFAULT 0	NOT NULL,
	expiration	VARCHAR(24)	DEFAULT CHR(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(255) 	DEFAULT CHR(0)	NOT NULL,
	billing_contact	VARCHAR(255)	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(255)	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,	
	mailman		INTEGER		DEFAULT 0	NOT NULL,
	mailman_id	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 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
);

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