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