create table users
(
        login		CHAR(8),
	users_id	INTEGER,
	uid		SMALLINT,
	shell		CHAR(32),
	last		CHAR(16),
	first		CHAR(16),
	middle		CHAR(16),
	status		SMALLINT,
	clearid		CHAR(16),
	encryptid	CHAR(16),
	type		CHAR(8),
	modtime		DATE,
	modby		INTEGER,
	modwith		CHAR(8),
	fullname	CHAR(32),
	nickname	CHAR(16),
	home_addr	CHAR(82),
	home_phone	CHAR(16),
	office_addr	CHAR(16),
	office_phone	CHAR(12),
	deptartment	CHAR(20),
	affiliation	CHAR(50),
	fmodtime	DATE,
	fmodby		INTEGER,
	fmodwith	CHAR(8),
	potype		CHAR(8),
	pop_id		INTEGER,
	box_id		INTEGER,
	pmodtime	DATE,
	pmodby		INTEGER,
	pmodwith	CHAR(8),
	misc		SMALLINT
);
create table krbmap
(
	users_id	INTEGER,
	string_id	INTEGER
);
create table machine
(
	name		CHAR(32),
	mach_id		INTEGER,
	type		CHAR(8),
	modtime		DATE,
	modby		INTEGER,
	modwith		CHAR(8)
);
create table clusters
(
	name		CHAR(32),
	clu_id		INTEGER,
	description	CHAR(32),
	location	CHAR(64),
	modtime	 	DATE,
	modby		INTEGER,
	modwith		CHAR(8)
);
create table mcmap
(
	mach_id		INTEGER,
	clu_id		INTEGER
);
create table cludata
(
	clu_id		INTEGER,
	label		CHAR(16),
	data		CHAR(32)
);
create table list
(
	name		CHAR(32),
	list_id		INTEGER,
	active		SMALLINT,
	publicflg	SMALLINT,
	hidden		SMALLINT,
	maillist	SMALLINT,
	grouplist	SMALLINT,
	gid		SMALLINT,
	description	CHAR(255),
	acl_type	CHAR(8),
	acl_id		INTEGER,
	modtime		DATE,
	modby		INTEGER,
	modwith		CHAR(8)
);
create table imembers 
(
	list_id		INTEGER,
	member_type	CHAR(8),
	member_id	INTEGER,
	ref_count	SMALLINT,
	direct		SMALLINT
);
create table servers 
(
	name		CHAR(16),
	update_int	INTEGER,
	target_file	CHAR(64),
	script		CHAR(128),
	dfgen		INTEGER,
	dfcheck		INTEGER,
	type		CHAR(8),
	enable		SMALLINT,
	inprogress	SMALLINT,
	harderror	INTEGER,
	errmsg		CHAR(80),
	acl_type	CHAR(8),
	acl_id		INTEGER,
	modtime		DATE,
	modby		INTEGER,
	modwith		CHAR(8)
);
create table serverhosts 
(
	service		CHAR(16),
	mach_id		INTEGER,
	success		SMALLINT,
	enable		SMALLINT,
	override	SMALLINT,
	inprogress	SMALLINT,
	hosterror	INTEGER,
	hosterrmsg	CHAR(80),
	ltt		INTEGER,
	lts		INTEGER,
	value1		INTEGER,
	value2		INTEGER,
	value3		CHAR(32),
	modtime		DATE,
	modby		INTEGER,
	modwith		CHAR(8)
);
create table filesys 
(
	filsys_id	INTEGER,
	phys_id		INTEGER,
	label		CHAR(32),
	type		CHAR(8),
	mach_id		INTEGER,
	name		CHAR(80),
	mount		CHAR(32),
	access		CHAR(1),
	comments	CHAR(64),
	owner		INTEGER,
	owners		INTEGER,
	createflg	SMALLINT,
	lockertype	CHAR(8),
	modtime		DATE,
	modby		INTEGER,
	modwith		CHAR(8)
);
create table fsgroup
(
	group_id	INTEGER,
	filsys_id	INTEGER,
	key		CHAR(8)
);
create table nfsphys 
(
	nfsphys_id	INTEGER,
	mach_id		INTEGER,
	device		CHAR(16),
	dir		CHAR(16),
	status		SMALLINT,
	allocated	INTEGER,
	partsize	INTEGER,
	modtime		DATE,
	modby		INTEGER,
	modwith		CHAR(8)
);
create table quota 
(
	filsys_id	INTEGER,
	type		CHAR(8),
	entity_id	INTEGER,
	phys_id		INTEGER,
	quota		INTEGER,
	modtime		DATE,
	modby		INTEGER,
	modwith		CHAR(8)
);
create table zephyr 
(
	class		CHAR(16),
	xmt_type	CHAR(8),
	xmt_id		INTEGER,
	sub_type	CHAR(8),
	sub_id		INTEGER,
	iws_type	CHAR(8),
	iws_id		INTEGER,
	iui_type	CHAR(8),
	iui_id		INTEGER,
	modtime 	DATE,
	modby		INTEGER,
	modwith		CHAR(8)
);
create table hostaccess 
(
	mach_id		INTEGER,
	acl_type	CHAR(8),
	acl_id		INTEGER,
	modtime		DATE,
	modby		INTEGER,
	modwith		CHAR(8)
);
create table strings 
(
	string_id	INTEGER,
	string		CHAR(128)
);
create table services 
(
	name		CHAR(16),
	protocol	CHAR(8),
	port		SMALLINT,
	description	CHAR(64),
	modtime		DATE,
	modby		INTEGER,
	modwith		CHAR(8)
);
create table printcap 
(
	name		CHAR(16),
	mach_id		INTEGER,
	dir		CHAR(32),
	rp		CHAR(16),
	quotaserver	INTEGER,
	auth		SMALLINT,
	price		SMALLINT,
	comments	CHAR(64),
	modtime		DATE,
	modby		INTEGER,
	modwith		CHAR(8)
);
create table palladium
(
	name		CHAR(32),
	ident		INTEGER,
	mach_id		INTEGER,
	modtime		DATE,
	modby		INTEGER,
	modwith		CHAR(8)
);
create table capacls 
(
	capability	CHAR(32),
	tag		CHAR(4),
	list_id		INTEGER
);
create table alias 
(
	name		CHAR(32),
	type		CHAR(16),
	trans		CHAR(128)
);
create table numvalues 
(
	name		CHAR(32),
	value		INTEGER
);
create table tblstats 
(
	table_name	CHAR(12),
	modtime		DATE,
	retrieves	INTEGER,
	appends		INTEGER,
	updates		INTEGER,
	deletes		INTEGER
);
create table incremental
(
	tablename	CHAR(16),
	service		CHAR(16)
);