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