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