[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		CHAR(16) 	NOT NULL WITH DEFAULT,
	first		CHAR(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,
	searchlast	VARCHAR(16) 	NOT NULL WITH DEFAULT,
	searchfirst	VARCHAR(16) 	NOT NULL WITH DEFAULT
);
create table krbmap
(
	users_id	INTEGER 	NOT NULL WITH DEFAULT,
	string_id	INTEGER 	NOT NULL WITH DEFAULT
);
create table machine
(
	name		VARCHAR(32) 	NOT NULL WITH DEFAULT,
	mach_id		INTEGER 	NOT NULL WITH DEFAULT,
	type		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 cluster
(
	name		CHAR(32) 	NOT NULL WITH DEFAULT,
	searchname	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
);
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
);
create table list
(
	name		CHAR(32) 	NOT NULL WITH DEFAULT,
	searchname	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
);
create table servers 
(
	name		CHAR(16)	NOT NULL WITH DEFAULT,
	searchname	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		CHAR(16)	NOT NULL WITH DEFAULT,
	searchservice	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		CHAR(32)	NOT NULL WITH DEFAULT,
	searchlabel	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
);
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		CHAR(16)	NOT NULL WITH DEFAULT,
	searchname	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		CHAR(16)	NOT NULL WITH DEFAULT,
	searchname	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
);
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	(
65eed998	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 CHAR(16) NOT NULL WITH DEFAULT,
	8	first CHAR(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,
	46	searchlast VARCHAR(16) NOT NULL WITH DEFAULT,
	47	searchfirst VARCHAR(16) NOT NULL WITH DEFAULT
49083d45	48	);
49083d45	49	create table krbmap
fba90e28	50	(
65eed998	51	users_id INTEGER NOT NULL WITH DEFAULT,
65eed998	52	string_id INTEGER NOT NULL WITH DEFAULT
49083d45	53	);
49083d45	54	create table machine
fba90e28	55	(
65eed998	56	name VARCHAR(32) NOT NULL WITH DEFAULT,
	57	mach_id INTEGER NOT NULL WITH DEFAULT,
	58	type CHAR(8) NOT NULL WITH DEFAULT,
	59	modtime DATE NOT NULL WITH DEFAULT,
	60	modby INTEGER NOT NULL WITH DEFAULT,
	61	modwith CHAR(8) NOT NULL WITH DEFAULT
49083d45	62	);
65eed998	63	create table cluster
fba90e28	64	(
65eed998	65	name CHAR(32) NOT NULL WITH DEFAULT,
	66	searchname VARCHAR(32) NOT NULL WITH DEFAULT,
	67	clu_id INTEGER NOT NULL WITH DEFAULT,
	68	description CHAR(32) NOT NULL WITH DEFAULT,
	69	location CHAR(64) NOT NULL WITH DEFAULT,
	70	modtime DATE NOT NULL WITH DEFAULT,
	71	modby INTEGER NOT NULL WITH DEFAULT,
	72	modwith CHAR(8) NOT NULL WITH DEFAULT
49083d45	73	);
49083d45	74	create table mcmap
fba90e28	75	(
65eed998	76	mach_id INTEGER NOT NULL WITH DEFAULT,
65eed998	77	clu_id INTEGER NOT NULL WITH DEFAULT
49083d45	78	);
65eed998	79	create table svc
fba90e28	80	(
65eed998	81	clu_id INTEGER NOT NULL WITH DEFAULT,
	82	serv_label VARCHAR(16) NOT NULL WITH DEFAULT,
	83	serv_cluster CHAR(32) NOT NULL WITH DEFAULT
49083d45	84	);
49083d45	85	create table list
fba90e28	86	(
65eed998	87	name CHAR(32) NOT NULL WITH DEFAULT,
	88	searchname VARCHAR(32) NOT NULL WITH DEFAULT,
	89	list_id INTEGER NOT NULL WITH DEFAULT,
	90	active INTEGER1 NOT NULL WITH DEFAULT,
	91	publicflg INTEGER1 NOT NULL WITH DEFAULT,
	92	hidden INTEGER1 NOT NULL WITH DEFAULT,
	93	maillist INTEGER1 NOT NULL WITH DEFAULT,
	94	grouplist INTEGER1 NOT NULL WITH DEFAULT,
	95	gid SMALLINT NOT NULL WITH DEFAULT,
	96	description CHAR(255) NOT NULL WITH DEFAULT,
	97	acl_type CHAR(8) NOT NULL WITH DEFAULT,
	98	acl_id INTEGER NOT NULL WITH DEFAULT,
	99	modtime DATE NOT NULL WITH DEFAULT,
	100	modby INTEGER NOT NULL WITH DEFAULT,
	101	modwith CHAR(8) NOT NULL WITH DEFAULT
49083d45	102	);
49083d45	103	create table imembers
fba90e28	104	(
65eed998	105	list_id INTEGER NOT NULL WITH DEFAULT,
	106	member_type CHAR(8) NOT NULL WITH DEFAULT,
	107	member_id INTEGER NOT NULL WITH DEFAULT,
	108	ref_count SMALLINT NOT NULL WITH DEFAULT,
	109	direct SMALLINT NOT NULL WITH DEFAULT
49083d45	110	);
49083d45	111	create table servers
fba90e28	112	(
65eed998	113	name CHAR(16) NOT NULL WITH DEFAULT,
	114	searchname VARCHAR(16) NOT NULL WITH DEFAULT,
	115	update_int INTEGER NOT NULL WITH DEFAULT,
	116	target_file CHAR(64) NOT NULL WITH DEFAULT,
	117	script CHAR(128) NOT NULL WITH DEFAULT,
	118	dfgen INTEGER NOT NULL WITH DEFAULT,
	119	dfcheck INTEGER NOT NULL WITH DEFAULT,
	120	type CHAR(8) NOT NULL WITH DEFAULT,
	121	enable INTEGER1 NOT NULL WITH DEFAULT,
	122	inprogress INTEGER1 NOT NULL WITH DEFAULT,
	123	harderror INTEGER NOT NULL WITH DEFAULT,
	124	errmsg CHAR(80) NOT NULL WITH DEFAULT,
	125	acl_type CHAR(8) NOT NULL WITH DEFAULT,
	126	acl_id INTEGER NOT NULL WITH DEFAULT,
	127	modtime DATE NOT NULL WITH DEFAULT,
	128	modby INTEGER NOT NULL WITH DEFAULT,
	129	modwith CHAR(8) NOT NULL WITH DEFAULT
49083d45	130	);
49083d45	131	create table serverhosts
fba90e28	132	(
65eed998	133	service CHAR(16) NOT NULL WITH DEFAULT,
	134	searchservice VARCHAR(16) NOT NULL WITH DEFAULT,
	135	mach_id INTEGER NOT NULL WITH DEFAULT,
	136	success INTEGER1 NOT NULL WITH DEFAULT,
	137	enable INTEGER1 NOT NULL WITH DEFAULT,
	138	override INTEGER1 NOT NULL WITH DEFAULT,
	139	inprogress INTEGER1 NOT NULL WITH DEFAULT,
	140	hosterror INTEGER NOT NULL WITH DEFAULT,
	141	hosterrmsg CHAR(80) NOT NULL WITH DEFAULT,
	142	ltt INTEGER NOT NULL WITH DEFAULT,
	143	lts INTEGER NOT NULL WITH DEFAULT,
	144	value1 INTEGER NOT NULL WITH DEFAULT,
	145	value2 INTEGER NOT NULL WITH DEFAULT,
	146	value3 CHAR(32) NOT NULL WITH DEFAULT,
	147	modtime DATE NOT NULL WITH DEFAULT,
	148	modby INTEGER NOT NULL WITH DEFAULT,
	149	modwith CHAR(8) NOT NULL WITH DEFAULT
49083d45	150	);
49083d45	151	create table filesys
fba90e28	152	(
65eed998	153	filsys_id INTEGER NOT NULL WITH DEFAULT,
	154	phys_id INTEGER NOT NULL WITH DEFAULT,
	155	label CHAR(32) NOT NULL WITH DEFAULT,
	156	searchlabel VARCHAR(32) NOT NULL WITH DEFAULT,
	157	fs_order INTEGER2 NOT NULL WITH DEFAULT,
	158	type CHAR(8) NOT NULL WITH DEFAULT,
	159	mach_id INTEGER NOT NULL WITH DEFAULT,
	160	name VARCHAR(80) NOT NULL WITH DEFAULT,
	161	mount CHAR(32) NOT NULL WITH DEFAULT,
	162	access CHAR(1) NOT NULL WITH DEFAULT,
	163	comments CHAR(64) NOT NULL WITH DEFAULT,
	164	owner INTEGER NOT NULL WITH DEFAULT,
	165	owners INTEGER NOT NULL WITH DEFAULT,
	166	createflg INTEGER1 NOT NULL WITH DEFAULT,
	167	lockertype CHAR(8) NOT NULL WITH DEFAULT,
	168	modtime DATE NOT NULL WITH DEFAULT,
	169	modby INTEGER NOT NULL WITH DEFAULT,
	170	modwith CHAR(8) NOT NULL WITH DEFAULT
49083d45	171	);
49083d45	172	create table fsgroup
fba90e28	173	(
65eed998	174	group_id INTEGER NOT NULL WITH DEFAULT,
	175	filsys_id INTEGER NOT NULL WITH DEFAULT,
	176	key CHAR(8) NOT NULL WITH DEFAULT
49083d45	177	);
49083d45	178	create table nfsphys
fba90e28	179	(
65eed998	180	nfsphys_id INTEGER NOT NULL WITH DEFAULT,
	181	mach_id INTEGER NOT NULL WITH DEFAULT,
	182	device CHAR(16) NOT NULL WITH DEFAULT,
	183	dir VARCHAR(16) NOT NULL WITH DEFAULT,
	184	status SMALLINT NOT NULL WITH DEFAULT,
	185	allocated INTEGER NOT NULL WITH DEFAULT,
	186	partsize INTEGER NOT NULL WITH DEFAULT,
	187	modtime DATE NOT NULL WITH DEFAULT,
	188	modby INTEGER NOT NULL WITH DEFAULT,
	189	modwith CHAR(8) NOT NULL WITH DEFAULT
49083d45	190	);
49083d45	191	create table quota
fba90e28	192	(
65eed998	193	filsys_id INTEGER NOT NULL WITH DEFAULT,
	194	type CHAR(8) NOT NULL WITH DEFAULT,
	195	entity_id INTEGER NOT NULL WITH DEFAULT,
	196	phys_id INTEGER NOT NULL WITH DEFAULT,
	197	quota INTEGER 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 zephyr
fba90e28	203	(
65eed998	204	class VARCHAR(16) NOT NULL WITH DEFAULT,
	205	xmt_type CHAR(8) NOT NULL WITH DEFAULT,
	206	xmt_id INTEGER NOT NULL WITH DEFAULT,
	207	sub_type CHAR(8) NOT NULL WITH DEFAULT,
	208	sub_id INTEGER NOT NULL WITH DEFAULT,
	209	iws_type CHAR(8) NOT NULL WITH DEFAULT,
	210	iws_id INTEGER NOT NULL WITH DEFAULT,
	211	iui_type CHAR(8) NOT NULL WITH DEFAULT,
	212	iui_id INTEGER NOT NULL WITH DEFAULT,
	213	modtime DATE NOT NULL WITH DEFAULT,
	214	modby INTEGER NOT NULL WITH DEFAULT,
	215	modwith CHAR(8) NOT NULL WITH DEFAULT
49083d45	216	);
49083d45	217	create table hostaccess
fba90e28	218	(
65eed998	219	mach_id INTEGER NOT NULL WITH DEFAULT,
	220	acl_type CHAR(8) NOT NULL WITH DEFAULT,
	221	acl_id INTEGER NOT NULL WITH DEFAULT,
	222	modtime DATE NOT NULL WITH DEFAULT,
	223	modby INTEGER NOT NULL WITH DEFAULT,
	224	modwith CHAR(8) NOT NULL WITH DEFAULT
49083d45	225	);
49083d45	226	create table strings
fba90e28	227	(
65eed998	228	string_id INTEGER NOT NULL WITH DEFAULT,
65eed998	229	string VARCHAR(128) NOT NULL WITH DEFAULT
49083d45	230	);
49083d45	231	create table services
fba90e28	232	(
65eed998	233	name CHAR(16) NOT NULL WITH DEFAULT,
	234	searchname VARCHAR(16) NOT NULL WITH DEFAULT,
	235	protocol CHAR(8) NOT NULL WITH DEFAULT,
	236	port SMALLINT NOT NULL WITH DEFAULT,
	237	description CHAR(64) NOT NULL WITH DEFAULT,
	238	modtime DATE NOT NULL WITH DEFAULT,
	239	modby INTEGER NOT NULL WITH DEFAULT,
	240	modwith CHAR(8) NOT NULL WITH DEFAULT
49083d45	241	);
49083d45	242	create table printcap
fba90e28	243	(
65eed998	244	name CHAR(16) NOT NULL WITH DEFAULT,
	245	searchname VARCHAR(16) NOT NULL WITH DEFAULT,
	246	mach_id INTEGER NOT NULL WITH DEFAULT,
	247	dir CHAR(32) NOT NULL WITH DEFAULT,
	248	rp CHAR(16) NOT NULL WITH DEFAULT,
	249	quotaserver INTEGER NOT NULL WITH DEFAULT,
	250	auth INTEGER1 NOT NULL WITH DEFAULT,
	251	price SMALLINT NOT NULL WITH DEFAULT,
	252	comments CHAR(64) NOT NULL WITH DEFAULT,
	253	modtime DATE NOT NULL WITH DEFAULT,
	254	modby INTEGER NOT NULL WITH DEFAULT,
	255	modwith CHAR(8) NOT NULL WITH DEFAULT
49083d45	256	);
49083d45	257	create table palladium
fba90e28	258	(
65eed998	259	name VARCHAR(32) NOT NULL WITH DEFAULT,
	260	ident INTEGER NOT NULL WITH DEFAULT,
	261	mach_id INTEGER NOT NULL WITH DEFAULT,
	262	modtime DATE NOT NULL WITH DEFAULT,
	263	modby INTEGER NOT NULL WITH DEFAULT,
	264	modwith CHAR(8) NOT NULL WITH DEFAULT
49083d45	265	);
49083d45	266	create table capacls
fba90e28	267	(
65eed998	268	capability CHAR(32) NOT NULL WITH DEFAULT,
	269	tag CHAR(4) NOT NULL WITH DEFAULT,
	270	list_id INTEGER NOT NULL WITH DEFAULT
49083d45	271	);
49083d45	272	create table alias
fba90e28	273	(
65eed998	274	name VARCHAR(32) NOT NULL WITH DEFAULT,
	275	type VARCHAR(16) NOT NULL WITH DEFAULT,
	276	trans VARCHAR(128) NOT NULL WITH DEFAULT
49083d45	277	);
49083d45	278	create table numvalues
fba90e28	279	(
65eed998	280	name VARCHAR(32) NOT NULL WITH DEFAULT,
65eed998	281	value INTEGER NOT NULL WITH DEFAULT
49083d45	282	);
49083d45	283	create table tblstats
fba90e28	284	(
65eed998	285	table_name CHAR(12) NOT NULL WITH DEFAULT,
	286	modtime DATE NOT NULL WITH DEFAULT,
	287	appends INTEGER NOT NULL WITH DEFAULT,
	288	updates INTEGER NOT NULL WITH DEFAULT,
	289	deletes INTEGER NOT NULL WITH DEFAULT
49083d45	290	);
49083d45	291	create table incremental
fba90e28	292	(
65eed998	293	tablename CHAR(16) NOT NULL WITH DEFAULT,
65eed998	294	service CHAR(16) NOT NULL WITH DEFAULT
49083d45	295	);