andersk Git - moira.git/blame_incremental

... / ...

Commit	Line	Data
	1	create table users
	2	(
	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
	46	);
	47	create table krbmap
	48	(
	49	users_id INTEGER NOT NULL WITH DEFAULT,
	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
	55	);
	56	create table machine
	57	(
	58	name VARCHAR(40) NOT NULL WITH DEFAULT,
	59	mach_id INTEGER NOT NULL WITH DEFAULT,
	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,
	77	modtime DATE NOT NULL WITH DEFAULT,
	78	modby INTEGER NOT NULL WITH DEFAULT,
	79	modwith CHAR(8) NOT NULL WITH DEFAULT
	80	);
	81	create table hostalias
	82	(
	83	name VARCHAR(40) NOT NULL WITH DEFAULT,
	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
	89	);
	90	create table subnet
	91	(
	92	name CHAR(16) NOT NULL WITH DEFAULT,
	93	snet_id INTEGER NOT NULL WITH DEFAULT,
	94	description VARCHAR(48) NOT NULL WITH DEFAULT,
	95	saddr INTEGER NOT NULL WITH DEFAULT,
	96	mask INTEGER NOT NULL WITH DEFAULT,
	97	low INTEGER NOT NULL WITH DEFAULT,
	98	high INTEGER NOT NULL WITH DEFAULT,
	99	prefix CHAR(8) NOT NULL WITH DEFAULT,
	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	);
	106	create table cluster
	107	(
	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
	115	);
	116	create table mcmap
	117	(
	118	mach_id INTEGER NOT NULL WITH DEFAULT,
	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
	124	);
	125	create table svc
	126	(
	127	clu_id INTEGER NOT NULL WITH DEFAULT,
	128	serv_label VARCHAR(16) NOT NULL WITH DEFAULT,
	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
	134	);
	135	create table list
	136	(
	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
	151	);
	152	create table imembers
	153	(
	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,
	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
	163	);
	164	create table servers
	165	(
	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
	182	);
	183	create table serverhosts
	184	(
	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
	201	);
	202	create table filesys
	203	(
	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
	221	);
	222	create table fsgroup
	223	(
	224	group_id INTEGER NOT NULL WITH DEFAULT,
	225	filsys_id INTEGER NOT NULL WITH DEFAULT,
	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
	231	);
	232	create table nfsphys
	233	(
	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
	244	);
	245	create table quota
	246	(
	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
	255	);
	256	create table zephyr
	257	(
	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
	270	);
	271	create table hostaccess
	272	(
	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
	279	);
	280	create table strings
	281	(
	282	string_id INTEGER NOT NULL WITH DEFAULT,
	283	string VARCHAR(128) NOT NULL WITH DEFAULT
	284	);
	285	create table services
	286	(
	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
	294	);
	295	create table printcap
	296	(
	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
	308	);
	309	create table palladium
	310	(
	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
	317	);
	318	create table capacls
	319	(
	320	capability CHAR(32) NOT NULL WITH DEFAULT,
	321	tag CHAR(4) NOT NULL WITH DEFAULT,
	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
	327	);
	328	create table alias
	329	(
	330	name VARCHAR(32) NOT NULL WITH DEFAULT,
	331	type VARCHAR(16) NOT NULL WITH DEFAULT,
	332	trans VARCHAR(128) NOT NULL WITH DEFAULT
	333	);
	334	create table numvalues
	335	(
	336	name VARCHAR(32) NOT NULL WITH DEFAULT,
	337	value INTEGER NOT NULL WITH DEFAULT
	338	);
	339	create table tblstats
	340	(
	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
	346	);
	347	create table incremental
	348	(
	349	tablename CHAR(16) NOT NULL WITH DEFAULT,
	350	service CHAR(16) NOT NULL WITH DEFAULT
	351	);