[moira.git] / db / schema

create table users
(
        login		VARCHAR(8) 	NOT NULL WITH DEFAULT,
	users_id	INTEGER 	NOT NULL WITH DEFAULT,
	uid		SMALLINT 	NOT NULL WITH DEFAULT,
	shell		CHAR(32) 	NOT NULL WITH DEFAULT,
	last		VARCHAR(16) 	NOT NULL WITH DEFAULT,
	first		VARCHAR(16) 	NOT NULL WITH DEFAULT,
	middle		CHAR(16) 	NOT NULL WITH DEFAULT,
	status		SMALLINT 	NOT NULL WITH DEFAULT,
	clearid		VARCHAR(16) 	NOT NULL WITH DEFAULT,
	type		CHAR(8) 	NOT NULL WITH DEFAULT,
	comment         INTEGER  	NOT NULL WITH DEFAULT,
	modtime		DATE    	NOT NULL WITH DEFAULT,
	modby		INTEGER 	NOT NULL WITH DEFAULT,
	modwith		CHAR(8) 	NOT NULL WITH DEFAULT,
	fullname	CHAR(32) 	NOT NULL WITH DEFAULT,
	nickname	CHAR(16) 	NOT NULL WITH DEFAULT,
	home_addr	CHAR(82) 	NOT NULL WITH DEFAULT,
	home_phone	CHAR(16) 	NOT NULL WITH DEFAULT,
	office_addr	CHAR(16) 	NOT NULL WITH DEFAULT,
	office_phone	CHAR(12) 	NOT NULL WITH DEFAULT,
	department	CHAR(20) 	NOT NULL WITH DEFAULT,
	affiliation	CHAR(50) 	NOT NULL WITH DEFAULT,
	fmodtime	DATE    	NOT NULL WITH DEFAULT,
	fmodby		INTEGER 	NOT NULL WITH DEFAULT,
	fmodwith	CHAR(8) 	NOT NULL WITH DEFAULT,
	potype		CHAR(8) 	NOT NULL WITH DEFAULT,
	pop_id		INTEGER 	NOT NULL WITH DEFAULT,
	box_id		INTEGER 	NOT NULL WITH DEFAULT,
	pmodtime	DATE    	NOT NULL WITH DEFAULT,
	pmodby		INTEGER 	NOT NULL WITH DEFAULT,
	pmodwith	CHAR(8) 	NOT NULL WITH DEFAULT,
	xname           CHAR(30)        NOT NULL WITH DEFAULT,
	xdept        	CHAR(20)        NOT NULL WITH DEFAULT,
	xtitle       	CHAR(50)	NOT NULL WITH DEFAULT,
	xaddress     	CHAR(82)	NOT NULL WITH DEFAULT,
	xphone1      	CHAR(12)	NOT NULL WITH DEFAULT,
	xphone2      	CHAR(12)	NOT NULL WITH DEFAULT,
	xmodtime     	DATE         	NOT NULL WITH DEFAULT,
	sigdate      	INTEGER		NOT NULL WITH DEFAULT,
	sigwho       	INTEGER		NOT NULL WITH DEFAULT,
	signature    	VARCHAR(68)	NOT NULL WITH DEFAULT,
	secure       	INTEGER		NOT NULL WITH DEFAULT,       
	flag         	INTEGER1	NOT NULL WITH DEFAULT
);
create table krbmap
(
	users_id	INTEGER 	NOT NULL WITH DEFAULT,
	string_id	INTEGER 	NOT NULL WITH DEFAULT,
	modtime		DATE    	NOT NULL WITH DEFAULT,
	modby		INTEGER 	NOT NULL WITH DEFAULT,
	modwith		CHAR(8) 	NOT NULL WITH DEFAULT

);
create table machine
(
	name		VARCHAR(40) 	NOT NULL WITH DEFAULT,
	mach_id		INTEGER 	NOT NULL WITH DEFAULT,
	vendor		CHAR(16) 	NOT NULL WITH DEFAULT,
	model		CHAR(24) 	NOT NULL WITH DEFAULT,
	os		CHAR(16) 	NOT NULL WITH DEFAULT,
	location	CHAR(16) 	NOT NULL WITH DEFAULT,
	contact		CHAR(32) 	NOT NULL WITH DEFAULT,
	use		INTEGER		NOT NULL WITH DEFAULT,
	status		INTEGER1	NOT NULL WITH DEFAULT,
	statuschange	DATE    	NOT NULL WITH DEFAULT,
	snet_id		INTEGER 	NOT NULL WITH DEFAULT,
	address		CHAR(16)	NOT NULL WITH DEFAULT,
	owner_type	CHAR(8) 	NOT NULL WITH DEFAULT,
	owner_id	INTEGER 	NOT NULL WITH DEFAULT,
	acomment	INTEGER 	NOT NULL WITH DEFAULT,
	ocomment	INTEGER 	NOT NULL WITH DEFAULT,
	created		DATE 		NOT NULL WITH DEFAULT,
	creator		INTEGER 	NOT NULL WITH DEFAULT,
	inuse		DATE		NOT NULL WITH DEFAULT,
	modtime		DATE    	NOT NULL WITH DEFAULT,
	modby		INTEGER 	NOT NULL WITH DEFAULT,
	modwith		CHAR(8) 	NOT NULL WITH DEFAULT
);
create table hostalias
(
	name		VARCHAR(40) 	NOT NULL WITH DEFAULT,
	mach_id		INTEGER	 	NOT NULL WITH DEFAULT,
	modtime		DATE    	NOT NULL WITH DEFAULT,
	modby		INTEGER 	NOT NULL WITH DEFAULT,
	modwith		CHAR(8) 	NOT NULL WITH DEFAULT

);
create table subnet
(
	name		CHAR(16) 	NOT NULL WITH DEFAULT,
	snet_id		INTEGER		NOT NULL WITH DEFAULT,
	description	VARCHAR(48) 	NOT NULL WITH DEFAULT,
	saddr		INTEGER		NOT NULL WITH DEFAULT,
	mask		INTEGER 	NOT NULL WITH DEFAULT,
	low		INTEGER 	NOT NULL WITH DEFAULT,
	high		INTEGER 	NOT NULL WITH DEFAULT,
	prefix		CHAR(8)		NOT NULL WITH DEFAULT,
	owner_type	CHAR(8) 	NOT NULL WITH DEFAULT,
	owner_id	INTEGER 	NOT NULL WITH DEFAULT,
	modtime		DATE 		NOT NULL WITH DEFAULT,
	modby		INTEGER 	NOT NULL WITH DEFAULT,
	modwith		CHAR(8) 	NOT NULL WITH DEFAULT
);
create table cluster
(
	name		VARCHAR(32) 	NOT NULL WITH DEFAULT,
	clu_id		INTEGER 	NOT NULL WITH DEFAULT,
	description	CHAR(32) 	NOT NULL WITH DEFAULT,
	location	CHAR(64) 	NOT NULL WITH DEFAULT,
	modtime	 	DATE    	NOT NULL WITH DEFAULT,
	modby		INTEGER 	NOT NULL WITH DEFAULT,
	modwith		CHAR(8) 	NOT NULL WITH DEFAULT
);
create table mcmap
(
	mach_id		INTEGER 	NOT NULL WITH DEFAULT,
	clu_id		INTEGER 	NOT NULL WITH DEFAULT,
	modtime		DATE    	NOT NULL WITH DEFAULT,
	modby		INTEGER 	NOT NULL WITH DEFAULT,
	modwith		CHAR(8) 	NOT NULL WITH DEFAULT

);
create table svc
(
	clu_id		INTEGER 	NOT NULL WITH DEFAULT,
	serv_label	VARCHAR(16) 	NOT NULL WITH DEFAULT,
	serv_cluster	CHAR(32) 	NOT NULL WITH DEFAULT,
	modtime		DATE    	NOT NULL WITH DEFAULT,
	modby		INTEGER 	NOT NULL WITH DEFAULT,
	modwith		CHAR(8) 	NOT NULL WITH DEFAULT

);
create table list
(
	name		VARCHAR(32) 	NOT NULL WITH DEFAULT,
	list_id		INTEGER 	NOT NULL WITH DEFAULT,
	active		INTEGER1 	NOT NULL WITH DEFAULT,
	publicflg	INTEGER1 	NOT NULL WITH DEFAULT,
	hidden		INTEGER1 	NOT NULL WITH DEFAULT,
	maillist	INTEGER1 	NOT NULL WITH DEFAULT,
	grouplist	INTEGER1 	NOT NULL WITH DEFAULT,
	gid		SMALLINT 	NOT NULL WITH DEFAULT,
	description	CHAR(255) 	NOT NULL WITH DEFAULT,
	acl_type	CHAR(8) 	NOT NULL WITH DEFAULT,
	acl_id		INTEGER 	NOT NULL WITH DEFAULT,
	modtime		DATE    	NOT NULL WITH DEFAULT,
	modby		INTEGER 	NOT NULL WITH DEFAULT,
	modwith		CHAR(8) 	NOT NULL WITH DEFAULT
);
create table imembers 
(
	list_id		INTEGER 	NOT NULL WITH DEFAULT,
	member_type	CHAR(8) 	NOT NULL WITH DEFAULT,
	member_id	INTEGER 	NOT NULL WITH DEFAULT,
	ref_count	SMALLINT 	NOT NULL WITH DEFAULT,
	direct		SMALLINT 	NOT NULL WITH DEFAULT,
	modtime		DATE    	NOT NULL WITH DEFAULT,
	modby		INTEGER 	NOT NULL WITH DEFAULT,
	modwith		CHAR(8) 	NOT NULL WITH DEFAULT

);
create table servers 
(
	name		VARCHAR(16) 	NOT NULL WITH DEFAULT,
	update_int	INTEGER 	NOT NULL WITH DEFAULT,
	target_file	CHAR(64) 	NOT NULL WITH DEFAULT,
	script		CHAR(128) 	NOT NULL WITH DEFAULT,
	dfgen		INTEGER 	NOT NULL WITH DEFAULT,
	dfcheck		INTEGER 	NOT NULL WITH DEFAULT,
	type		CHAR(8) 	NOT NULL WITH DEFAULT,
	enable		INTEGER1 	NOT NULL WITH DEFAULT,
	inprogress	INTEGER1 	NOT NULL WITH DEFAULT,
	harderror	INTEGER 	NOT NULL WITH DEFAULT,
	errmsg		CHAR(80) 	NOT NULL WITH DEFAULT,
	acl_type	CHAR(8) 	NOT NULL WITH DEFAULT,
	acl_id		INTEGER 	NOT NULL WITH DEFAULT,
	modtime		DATE    	NOT NULL WITH DEFAULT,
	modby		INTEGER 	NOT NULL WITH DEFAULT,
	modwith		CHAR(8) 	NOT NULL WITH DEFAULT 
);
create table serverhosts 
(
	service		VARCHAR(16) 	NOT NULL WITH DEFAULT,
	mach_id		INTEGER 	NOT NULL WITH DEFAULT,
	success		INTEGER1 	NOT NULL WITH DEFAULT,
	enable		INTEGER1 	NOT NULL WITH DEFAULT,
	override	INTEGER1 	NOT NULL WITH DEFAULT,
	inprogress	INTEGER1 	NOT NULL WITH DEFAULT,
	hosterror	INTEGER 	NOT NULL WITH DEFAULT,
	hosterrmsg	CHAR(80) 	NOT NULL WITH DEFAULT,
	ltt		INTEGER 	NOT NULL WITH DEFAULT,
	lts		INTEGER 	NOT NULL WITH DEFAULT,
	value1		INTEGER 	NOT NULL WITH DEFAULT,
	value2		INTEGER 	NOT NULL WITH DEFAULT,
	value3		CHAR(32) 	NOT NULL WITH DEFAULT,
	modtime		DATE    	NOT NULL WITH DEFAULT,
	modby		INTEGER 	NOT NULL WITH DEFAULT,
	modwith		CHAR(8) 	NOT NULL WITH DEFAULT
);
create table filesys 
(
	filsys_id	INTEGER 	NOT NULL WITH DEFAULT,
	phys_id		INTEGER 	NOT NULL WITH DEFAULT,
	label		VARCHAR(32) 	NOT NULL WITH DEFAULT,
	fs_order	INTEGER2	NOT NULL WITH DEFAULT,
	type		CHAR(8) 	NOT NULL WITH DEFAULT,
	mach_id		INTEGER 	NOT NULL WITH DEFAULT,
	name		VARCHAR(80) 	NOT NULL WITH DEFAULT,
	mount		CHAR(32) 	NOT NULL WITH DEFAULT,
	access		CHAR(1) 	NOT NULL WITH DEFAULT,
	comments	CHAR(64) 	NOT NULL WITH DEFAULT,
	owner		INTEGER 	NOT NULL WITH DEFAULT,
	owners		INTEGER 	NOT NULL WITH DEFAULT,
	createflg	INTEGER1 	NOT NULL WITH DEFAULT,
	lockertype	CHAR(8) 	NOT NULL WITH DEFAULT,
	modtime		DATE    	NOT NULL WITH DEFAULT,
	modby		INTEGER 	NOT NULL WITH DEFAULT,
	modwith		CHAR(8) 	NOT NULL WITH DEFAULT 
);
create table fsgroup
(
	group_id	INTEGER 	NOT NULL WITH DEFAULT,
	filsys_id	INTEGER 	NOT NULL WITH DEFAULT,
	key		CHAR(8) 	NOT NULL WITH DEFAULT,
	modtime		DATE    	NOT NULL WITH DEFAULT,
	modby		INTEGER 	NOT NULL WITH DEFAULT,
	modwith		CHAR(8) 	NOT NULL WITH DEFAULT

);
create table nfsphys 
(
	nfsphys_id	INTEGER 	NOT NULL WITH DEFAULT,
	mach_id		INTEGER 	NOT NULL WITH DEFAULT,
	device		CHAR(16) 	NOT NULL WITH DEFAULT,
	dir		VARCHAR(16) 	NOT NULL WITH DEFAULT,
	status		SMALLINT 	NOT NULL WITH DEFAULT,
	allocated	INTEGER 	NOT NULL WITH DEFAULT,
	partsize	INTEGER 	NOT NULL WITH DEFAULT,
	modtime		DATE    	NOT NULL WITH DEFAULT,
	modby		INTEGER 	NOT NULL WITH DEFAULT,
	modwith		CHAR(8) 	NOT NULL WITH DEFAULT
);
create table quota 
(
	filsys_id	INTEGER 	NOT NULL WITH DEFAULT,
	type		CHAR(8) 	NOT NULL WITH DEFAULT,
	entity_id	INTEGER 	NOT NULL WITH DEFAULT,
	phys_id		INTEGER 	NOT NULL WITH DEFAULT,
	quota		INTEGER 	NOT NULL WITH DEFAULT,
	modtime		DATE    	NOT NULL WITH DEFAULT,
	modby		INTEGER 	NOT NULL WITH DEFAULT,
	modwith		CHAR(8) 	NOT NULL WITH DEFAULT 
);
create table zephyr 
(
	class		VARCHAR(16) 	NOT NULL WITH DEFAULT,
	xmt_type	CHAR(8) 	NOT NULL WITH DEFAULT,
	xmt_id		INTEGER 	NOT NULL WITH DEFAULT,
	sub_type	CHAR(8) 	NOT NULL WITH DEFAULT,
	sub_id		INTEGER 	NOT NULL WITH DEFAULT,
	iws_type	CHAR(8) 	NOT NULL WITH DEFAULT,
	iws_id		INTEGER 	NOT NULL WITH DEFAULT,
	iui_type	CHAR(8) 	NOT NULL WITH DEFAULT,
	iui_id		INTEGER 	NOT NULL WITH DEFAULT,
	modtime 	DATE    	NOT NULL WITH DEFAULT,
	modby		INTEGER 	NOT NULL WITH DEFAULT,
	modwith		CHAR(8) 	NOT NULL WITH DEFAULT 
);
create table hostaccess 
(
	mach_id		INTEGER 	NOT NULL WITH DEFAULT,
	acl_type	CHAR(8) 	NOT NULL WITH DEFAULT,
	acl_id		INTEGER 	NOT NULL WITH DEFAULT,
	modtime		DATE    	NOT NULL WITH DEFAULT,
	modby		INTEGER 	NOT NULL WITH DEFAULT,
	modwith		CHAR(8) 	NOT NULL WITH DEFAULT
);
create table strings 
(
	string_id	INTEGER 	NOT NULL WITH DEFAULT,
	string		VARCHAR(128)	NOT NULL WITH DEFAULT
);
create table services 
(
	name		VARCHAR(16) 	NOT NULL WITH DEFAULT,
	protocol	CHAR(8) 	NOT NULL WITH DEFAULT,
	port		SMALLINT 	NOT NULL WITH DEFAULT,
	description	CHAR(64) 	NOT NULL WITH DEFAULT,
	modtime		DATE    	NOT NULL WITH DEFAULT,
	modby		INTEGER 	NOT NULL WITH DEFAULT,
	modwith		CHAR(8) 	NOT NULL WITH DEFAULT 
);
create table printcap 
(
	name		VARCHAR(16) 	NOT NULL WITH DEFAULT,
	mach_id		INTEGER 	NOT NULL WITH DEFAULT,
	dir		CHAR(32) 	NOT NULL WITH DEFAULT,
	rp		CHAR(16) 	NOT NULL WITH DEFAULT,
	quotaserver	INTEGER 	NOT NULL WITH DEFAULT,
	auth		INTEGER1 	NOT NULL WITH DEFAULT,
	price		SMALLINT 	NOT NULL WITH DEFAULT,
	comments	CHAR(64) 	NOT NULL WITH DEFAULT,
	modtime		DATE    	NOT NULL WITH DEFAULT,
	modby		INTEGER 	NOT NULL WITH DEFAULT,
	modwith		CHAR(8) 	NOT NULL WITH DEFAULT
);
create table palladium
(
	name		VARCHAR(32) 	NOT NULL WITH DEFAULT,
	ident		INTEGER 	NOT NULL WITH DEFAULT,
	mach_id		INTEGER 	NOT NULL WITH DEFAULT,
	modtime		DATE    	NOT NULL WITH DEFAULT,
	modby		INTEGER 	NOT NULL WITH DEFAULT,
	modwith		CHAR(8) 	NOT NULL WITH DEFAULT
);
create table capacls 
(
	capability	CHAR(32) 	NOT NULL WITH DEFAULT,
	tag		CHAR(4) 	NOT NULL WITH DEFAULT,
	list_id		INTEGER 	NOT NULL WITH DEFAULT,
	modtime		DATE    	NOT NULL WITH DEFAULT,
	modby		INTEGER 	NOT NULL WITH DEFAULT,
	modwith		CHAR(8) 	NOT NULL WITH DEFAULT

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