[moira.git] / db / schema

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)
);
Commit	Line	Data
49083d45	1	create table users
fba90e28	2	(
49083d45	3	login CHAR(8),
	4	users_id INTEGER,
	5	uid SMALLINT,
	6	shell CHAR(32),
	7	last CHAR(16),
	8	first CHAR(16),
	9	middle CHAR(16),
	10	status SMALLINT,
	11	clearid CHAR(16),
	12	encryptid CHAR(16),
	13	type CHAR(8),
	14	modtime DATE,
	15	modby INTEGER,
	16	modwith CHAR(8),
	17	fullname CHAR(32),
	18	nickname CHAR(16),
	19	home_addr CHAR(82),
	20	home_phone CHAR(16),
	21	office_addr CHAR(16),
	22	office_phone CHAR(12),
	23	deptartment CHAR(20),
	24	affiliation CHAR(50),
	25	fmodtime DATE,
	26	fmodby INTEGER,
	27	fmodwith CHAR(8),
	28	potype CHAR(8),
	29	pop_id INTEGER,
	30	box_id INTEGER,
	31	pmodtime DATE,
	32	pmodby INTEGER,
	33	pmodwith CHAR(8),
	34	misc SMALLINT
	35	);
	36	create table krbmap
fba90e28	37	(
49083d45	38	users_id INTEGER,
	39	string_id INTEGER
	40	);
	41	create table machine
fba90e28	42	(
49083d45	43	name CHAR(32),
	44	mach_id INTEGER,
	45	type CHAR(8),
	46	modtime DATE,
	47	modby INTEGER,
	48	modwith CHAR(8)
	49	);
	50	create table clusters
fba90e28	51	(
49083d45	52	name CHAR(32),
	53	clu_id INTEGER,
	54	description CHAR(32),
	55	location CHAR(64),
	56	modtime DATE,
	57	modby INTEGER,
	58	modwith CHAR(8)
	59	);
	60	create table mcmap
fba90e28	61	(
49083d45	62	mach_id INTEGER,
	63	clu_id INTEGER
	64	);
	65	create table cludata
fba90e28	66	(
49083d45	67	clu_id INTEGER,
	68	label CHAR(16),
	69	data CHAR(32)
	70	);
	71	create table list
fba90e28	72	(
49083d45	73	name CHAR(32),
	74	list_id INTEGER,
	75	active SMALLINT,
	76	publicflg SMALLINT,
	77	hidden SMALLINT,
	78	maillist SMALLINT,
	79	grouplist SMALLINT,
	80	gid SMALLINT,
	81	description CHAR(255),
	82	acl_type CHAR(8),
	83	acl_id INTEGER,
	84	modtime DATE,
	85	modby INTEGER,
	86	modwith CHAR(8)
	87	);
	88	create table imembers
fba90e28	89	(
49083d45	90	list_id INTEGER,
	91	member_type CHAR(8),
	92	member_id INTEGER,
	93	ref_count SMALLINT,
	94	direct SMALLINT
	95	);
	96	create table servers
fba90e28	97	(
49083d45	98	name CHAR(16),
	99	update_int INTEGER,
	100	target_file CHAR(64),
	101	script CHAR(128),
	102	dfgen INTEGER,
	103	dfcheck INTEGER,
	104	type CHAR(8),
	105	enable SMALLINT,
	106	inprogress SMALLINT,
	107	harderror INTEGER,
	108	errmsg CHAR(80),
	109	acl_type CHAR(8),
	110	acl_id INTEGER,
	111	modtime DATE,
	112	modby INTEGER,
	113	modwith CHAR(8)
	114	);
	115	create table serverhosts
fba90e28	116	(
49083d45	117	service CHAR(16),
	118	mach_id INTEGER,
	119	success SMALLINT,
	120	enable SMALLINT,
	121	override SMALLINT,
	122	inprogress SMALLINT,
	123	hosterror INTEGER,
	124	hosterrmsg CHAR(80),
	125	ltt INTEGER,
	126	lts INTEGER,
	127	value1 INTEGER,
	128	value2 INTEGER,
	129	value3 CHAR(32),
	130	modtime DATE,
	131	modby INTEGER,
	132	modwith CHAR(8)
	133	);
	134	create table filesys
fba90e28	135	(
49083d45	136	filsys_id INTEGER,
	137	phys_id INTEGER,
	138	label CHAR(32),
	139	type CHAR(8),
	140	mach_id INTEGER,
	141	name CHAR(80),
	142	mount CHAR(32),
	143	access CHAR(1),
	144	comments CHAR(64),
	145	owner INTEGER,
	146	owners INTEGER,
	147	createflg SMALLINT,
	148	lockertype CHAR(8),
	149	modtime DATE,
	150	modby INTEGER,
	151	modwith CHAR(8)
	152	);
	153	create table fsgroup
fba90e28	154	(
49083d45	155	group_id INTEGER,
	156	filsys_id INTEGER,
	157	key CHAR(8)
	158	);
	159	create table nfsphys
fba90e28	160	(
49083d45	161	nfsphys_id INTEGER,
	162	mach_id INTEGER,
	163	device CHAR(16),
	164	dir CHAR(16),
	165	status SMALLINT,
	166	allocated INTEGER,
	167	partsize INTEGER,
	168	modtime DATE,
	169	modby INTEGER,
	170	modwith CHAR(8)
	171	);
	172	create table quota
fba90e28	173	(
49083d45	174	filsys_id INTEGER,
	175	type CHAR(8),
	176	entity_id INTEGER,
	177	phys_id INTEGER,
	178	quota INTEGER,
	179	modtime DATE,
	180	modby INTEGER,
	181	modwith CHAR(8)
	182	);
	183	create table zephyr
fba90e28	184	(
49083d45	185	class CHAR(16),
	186	xmt_type CHAR(8),
	187	xmt_id INTEGER,
	188	sub_type CHAR(8),
	189	sub_id INTEGER,
	190	iws_type CHAR(8),
	191	iws_id INTEGER,
	192	iui_type CHAR(8),
	193	iui_id INTEGER,
	194	modtime DATE,
	195	modby INTEGER,
	196	modwith CHAR(8)
	197	);
	198	create table hostaccess
fba90e28	199	(
49083d45	200	mach_id INTEGER,
	201	acl_type CHAR(8),
	202	acl_id INTEGER,
	203	modtime DATE,
	204	modby INTEGER,
	205	modwith CHAR(8)
	206	);
	207	create table strings
fba90e28	208	(
49083d45	209	string_id INTEGER,
	210	string CHAR(128)
	211	);
	212	create table services
fba90e28	213	(
49083d45	214	name CHAR(16),
	215	protocol CHAR(8),
	216	port SMALLINT,
	217	description CHAR(64),
	218	modtime DATE,
	219	modby INTEGER,
	220	modwith CHAR(8)
	221	);
	222	create table printcap
fba90e28	223	(
49083d45	224	name CHAR(16),
	225	mach_id INTEGER,
	226	dir CHAR(32),
	227	rp CHAR(16),
	228	quotaserver INTEGER,
	229	auth SMALLINT,
	230	price SMALLINT,
	231	comments CHAR(64),
	232	modtime DATE,
	233	modby INTEGER,
	234	modwith CHAR(8)
	235	);
	236	create table palladium
fba90e28	237	(
49083d45	238	name CHAR(32),
	239	ident INTEGER,
	240	mach_id INTEGER,
	241	modtime DATE,
	242	modby INTEGER,
	243	modwith CHAR(8)
	244	);
	245	create table capacls
fba90e28	246	(
49083d45	247	capability CHAR(32),
	248	tag CHAR(4),
	249	list_id INTEGER
	250	);
	251	create table alias
fba90e28	252	(
49083d45	253	name CHAR(32),
	254	type CHAR(16),
	255	trans CHAR(128)
	256	);
	257	create table numvalues
fba90e28	258	(
49083d45	259	name CHAR(32),
	260	value INTEGER
	261	);
	262	create table tblstats
fba90e28	263	(
49083d45	264	table_name CHAR(12),
	265	modtime DATE,
	266	retrieves INTEGER,
	267	appends INTEGER,
	268	updates INTEGER,
	269	deletes INTEGER
	270	);
	271	create table incremental
fba90e28	272	(
49083d45	273	tablename CHAR(16),
	274	service CHAR(16)
	275	);