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