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