andersk Git - moira.git/blame_incremental

... / ...

Commit	Line	Data
	1	create table users
	2	(
	3	login VARCHAR(8) DEFAULT CHR(0) NOT NULL,
	4	users_id INTEGER DEFAULT 0 NOT NULL,
	5	unix_uid SMALLINT DEFAULT 0 NOT NULL,
	6	shell VARCHAR(32) DEFAULT CHR(0) NOT NULL,
	7	winconsoleshell VARCHAR(32) DEFAULT CHR(0) NOT NULL,
	8	last VARCHAR(30) DEFAULT CHR(0) NOT NULL,
	9	first VARCHAR(30) DEFAULT CHR(0) NOT NULL,
	10	middle VARCHAR(30) DEFAULT CHR(0) NOT NULL,
	11	status SMALLINT DEFAULT 0 NOT NULL,
	12	clearid VARCHAR(16) DEFAULT CHR(0) NOT NULL,
	13	type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
	14	comments INTEGER DEFAULT 0 NOT NULL,
	15	modtime DATE DEFAULT SYSDATE NOT NULL,
	16	modby INTEGER DEFAULT 0 NOT NULL,
	17	modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL,
	18	fullname VARCHAR(92) DEFAULT CHR(0) NOT NULL,
	19	nickname VARCHAR(16) DEFAULT CHR(0) NOT NULL,
	20	home_addr VARCHAR(82) DEFAULT CHR(0) NOT NULL,
	21	home_phone VARCHAR(24) DEFAULT CHR(0) NOT NULL,
	22	office_addr VARCHAR(16) DEFAULT CHR(0) NOT NULL,
	23	office_phone VARCHAR(24) DEFAULT CHR(0) NOT NULL,
	24	department VARCHAR(50) DEFAULT CHR(0) NOT NULL,
	25	affiliation VARCHAR(50) DEFAULT CHR(0) NOT NULL,
	26	fmodtime DATE DEFAULT SYSDATE NOT NULL,
	27	fmodby INTEGER DEFAULT 0 NOT NULL,
	28	fmodwith VARCHAR(8) DEFAULT CHR(0) NOT NULL,
	29	potype VARCHAR(8) DEFAULT CHR(0) NOT NULL,
	30	pop_id INTEGER DEFAULT 0 NOT NULL,
	31	imap_id INTEGER DEFAULT 0 NOT NULL,
	32	box_id INTEGER DEFAULT 0 NOT NULL,
	33	pmodtime DATE DEFAULT SYSDATE NOT NULL,
	34	pmodby INTEGER DEFAULT 0 NOT NULL,
	35	pmodwith VARCHAR(8) DEFAULT CHR(0) NOT NULL,
	36	xname VARCHAR(30) DEFAULT CHR(0) NOT NULL,
	37	xdept VARCHAR(50) DEFAULT CHR(0) NOT NULL,
	38	xtitle VARCHAR(50) DEFAULT CHR(0) NOT NULL,
	39	xaddress VARCHAR(82) DEFAULT CHR(0) NOT NULL,
	40	xphone1 VARCHAR(24) DEFAULT CHR(0) NOT NULL,
	41	xphone2 VARCHAR(24) DEFAULT CHR(0) NOT NULL,
	42	xmodtime DATE DEFAULT SYSDATE NOT NULL,
	43	sigdate INTEGER DEFAULT 0 NOT NULL,
	44	sigwho INTEGER DEFAULT 0 NOT NULL,
	45	signature VARCHAR(68) DEFAULT CHR(0) NOT NULL,
	46	secure INTEGER DEFAULT 0 NOT NULL,
	47	reservations VARCHAR(10) DEFAULT CHR(0) NOT NULL,
	48	flag INTEGER DEFAULT 0 NOT NULL
	49	);
	50
	51	create table krbmap
	52	(
	53	users_id INTEGER DEFAULT 0 NOT NULL,
	54	string_id INTEGER DEFAULT 0 NOT NULL
	55	);
	56
	57	create table machine
	58	(
	59	name VARCHAR(255) DEFAULT CHR(0) NOT NULL,
	60	mach_id INTEGER DEFAULT 0 NOT NULL,
	61	vendor VARCHAR(16) DEFAULT CHR(0) NOT NULL,
	62	model VARCHAR(24) DEFAULT CHR(0) NOT NULL,
	63	os VARCHAR(16) DEFAULT CHR(0) NOT NULL,
	64	location VARCHAR(16) DEFAULT CHR(0) NOT NULL,
	65	contact VARCHAR(32) DEFAULT CHR(0) NOT NULL,
	66	billing_contact VARCHAR(32) DEFAULT CHR(0) NOT NULL,
	67	use INTEGER DEFAULT 0 NOT NULL,
	68	status INTEGER DEFAULT 0 NOT NULL,
	69	statuschange DATE DEFAULT SYSDATE NOT NULL,
	70	snet_id INTEGER DEFAULT 0 NOT NULL,
	71	address VARCHAR(16) DEFAULT CHR(0) NOT NULL,
	72	hwaddr VARCHAR(12) DEFAULT CHR(0) NOT NULL,
	73	owner_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
	74	owner_id INTEGER DEFAULT 0 NOT NULL,
	75	acomment INTEGER DEFAULT 0 NOT NULL,
	76	ocomment INTEGER DEFAULT 0 NOT NULL,
	77	created DATE DEFAULT SYSDATE NOT NULL,
	78	creator INTEGER DEFAULT 0 NOT NULL,
	79	inuse DATE DEFAULT SYSDATE NOT NULL,
	80	modtime DATE DEFAULT SYSDATE NOT NULL,
	81	modby INTEGER DEFAULT 0 NOT NULL,
	82	modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
	83	);
	84
	85	create table hostalias
	86	(
	87	name VARCHAR(255) DEFAULT CHR(0) NOT NULL,
	88	mach_id INTEGER DEFAULT 0 NOT NULL
	89	);
	90
	91	create table subnet
	92	(
	93	name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
	94	snet_id INTEGER DEFAULT 0 NOT NULL,
	95	description VARCHAR(48) DEFAULT CHR(0) NOT NULL,
	96	saddr INTEGER DEFAULT 0 NOT NULL,
	97	mask INTEGER DEFAULT 0 NOT NULL,
	98	low INTEGER DEFAULT 0 NOT NULL,
	99	high INTEGER DEFAULT 0 NOT NULL,
	100	prefix VARCHAR(8) DEFAULT CHR(0) NOT NULL,
	101	owner_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
	102	owner_id INTEGER DEFAULT 0 NOT NULL,
	103	modtime DATE DEFAULT SYSDATE NOT NULL,
	104	modby INTEGER DEFAULT 0 NOT NULL,
	105	modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
	106	);
	107
	108	create table clusters
	109	(
	110	name VARCHAR(32) DEFAULT CHR(0) NOT NULL,
	111	clu_id INTEGER DEFAULT 0 NOT NULL,
	112	description VARCHAR(32) DEFAULT CHR(0) NOT NULL,
	113	location VARCHAR(64) DEFAULT CHR(0) NOT NULL,
	114	modtime DATE DEFAULT SYSDATE NOT NULL,
	115	modby INTEGER DEFAULT 0 NOT NULL,
	116	modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
	117	);
	118
	119	create table mcmap
	120	(
	121	mach_id INTEGER DEFAULT 0 NOT NULL,
	122	clu_id INTEGER DEFAULT 0 NOT NULL
	123	);
	124
	125	create table svc
	126	(
	127	clu_id INTEGER DEFAULT 0 NOT NULL,
	128	serv_label VARCHAR(16) DEFAULT CHR(0) NOT NULL,
	129	serv_cluster VARCHAR(128) DEFAULT CHR(0) NOT NULL
	130	);
	131
	132	create table list
	133	(
	134	name VARCHAR(32) DEFAULT CHR(0) NOT NULL,
	135	list_id INTEGER DEFAULT 0 NOT NULL,
	136	active INTEGER DEFAULT 0 NOT NULL,
	137	publicflg INTEGER DEFAULT 0 NOT NULL,
	138	hidden INTEGER DEFAULT 0 NOT NULL,
	139	maillist INTEGER DEFAULT 0 NOT NULL,
	140	grouplist INTEGER DEFAULT 0 NOT NULL,
	141	gid SMALLINT DEFAULT 0 NOT NULL,
	142	nfsgroup INTEGER DEFAULT 0 NOT NULL,
	143	description VARCHAR(255) DEFAULT CHR(0) NOT NULL,
	144	acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
	145	acl_id INTEGER DEFAULT 0 NOT NULL,
	146	memacl_type VARCHAR(8) DEFAULT 'NONE' NOT NULL,
	147	memacl_id INTEGER DEFAULT 0 NOT NULL,
	148	modtime DATE DEFAULT SYSDATE NOT NULL,
	149	modby INTEGER DEFAULT 0 NOT NULL,
	150	modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
	151	);
	152
	153	create table imembers
	154	(
	155	list_id INTEGER DEFAULT 0 NOT NULL,
	156	member_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
	157	member_id INTEGER DEFAULT 0 NOT NULL,
	158	tag INTEGER DEFAULT 0 NOT NULL,
	159	ref_count SMALLINT DEFAULT 0 NOT NULL,
	160	direct SMALLINT DEFAULT 0 NOT NULL
	161	);
	162
	163	create table servers
	164	(
	165	name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
	166	update_int INTEGER DEFAULT 0 NOT NULL,
	167	target_file VARCHAR(64) DEFAULT CHR(0) NOT NULL,
	168	script VARCHAR(128) DEFAULT CHR(0) NOT NULL,
	169	dfgen INTEGER DEFAULT 0 NOT NULL,
	170	dfcheck INTEGER DEFAULT 0 NOT NULL,
	171	type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
	172	enable INTEGER DEFAULT 0 NOT NULL,
	173	inprogress INTEGER DEFAULT 0 NOT NULL,
	174	harderror INTEGER DEFAULT 0 NOT NULL,
	175	errmsg VARCHAR(80) DEFAULT CHR(0) NOT NULL,
	176	acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
	177	acl_id INTEGER DEFAULT 0 NOT NULL,
	178	modtime DATE DEFAULT SYSDATE NOT NULL,
	179	modby INTEGER DEFAULT 0 NOT NULL,
	180	modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
	181	);
	182
	183	create table serverhosts
	184	(
	185	service VARCHAR(16) DEFAULT CHR(0) NOT NULL,
	186	mach_id INTEGER DEFAULT 0 NOT NULL,
	187	success INTEGER DEFAULT 0 NOT NULL,
	188	enable INTEGER DEFAULT 0 NOT NULL,
	189	override INTEGER DEFAULT 0 NOT NULL,
	190	inprogress INTEGER DEFAULT 0 NOT NULL,
	191	hosterror INTEGER DEFAULT 0 NOT NULL,
	192	hosterrmsg VARCHAR(80) DEFAULT CHR(0) NOT NULL,
	193	ltt INTEGER DEFAULT 0 NOT NULL,
	194	lts INTEGER DEFAULT 0 NOT NULL,
	195	value1 INTEGER DEFAULT 0 NOT NULL,
	196	value2 INTEGER DEFAULT 0 NOT NULL,
	197	value3 VARCHAR(32) DEFAULT CHR(0) NOT NULL,
	198	modtime DATE DEFAULT SYSDATE NOT NULL,
	199	modby INTEGER DEFAULT 0 NOT NULL,
	200	modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
	201	);
	202
	203	create table filesys
	204	(
	205	filsys_id INTEGER DEFAULT 0 NOT NULL,
	206	phys_id INTEGER DEFAULT 0 NOT NULL,
	207	label VARCHAR(32) DEFAULT CHR(0) NOT NULL,
	208	fs_order INTEGER DEFAULT 0 NOT NULL,
	209	type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
	210	mach_id INTEGER DEFAULT 0 NOT NULL,
	211	name VARCHAR(80) DEFAULT CHR(0) NOT NULL,
	212	mount VARCHAR(32) DEFAULT CHR(0) NOT NULL,
	213	rwaccess CHAR(1) DEFAULT CHR(0) NOT NULL,
	214	comments VARCHAR(64) DEFAULT CHR(0) NOT NULL,
	215	owner INTEGER DEFAULT 0 NOT NULL,
	216	owners INTEGER DEFAULT 0 NOT NULL,
	217	createflg INTEGER DEFAULT 0 NOT NULL,
	218	lockertype VARCHAR(8) DEFAULT CHR(0) NOT NULL,
	219	modtime DATE DEFAULT SYSDATE NOT NULL,
	220	modby INTEGER DEFAULT 0 NOT NULL,
	221	modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
	222	);
	223
	224	create table fsgroup
	225	(
	226	group_id INTEGER DEFAULT 0 NOT NULL,
	227	filsys_id INTEGER DEFAULT 0 NOT NULL,
	228	key VARCHAR(8) DEFAULT CHR(0) NOT NULL
	229	);
	230
	231	create table nfsphys
	232	(
	233	nfsphys_id INTEGER DEFAULT 0 NOT NULL,
	234	mach_id INTEGER DEFAULT 0 NOT NULL,
	235	device VARCHAR(32) DEFAULT CHR(0) NOT NULL,
	236	dir VARCHAR(64) DEFAULT CHR(0) NOT NULL,
	237	status SMALLINT DEFAULT 0 NOT NULL,
	238	allocated INTEGER DEFAULT 0 NOT NULL,
	239	partsize INTEGER DEFAULT 0 NOT NULL,
	240	modtime DATE DEFAULT SYSDATE NOT NULL,
	241	modby INTEGER DEFAULT 0 NOT NULL,
	242	modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
	243	);
	244
	245	create table quota
	246	(
	247	filsys_id INTEGER DEFAULT 0 NOT NULL,
	248	type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
	249	entity_id INTEGER DEFAULT 0 NOT NULL,
	250	phys_id INTEGER DEFAULT 0 NOT NULL,
	251	quota INTEGER DEFAULT 0 NOT NULL,
	252	modtime DATE DEFAULT SYSDATE NOT NULL,
	253	modby INTEGER DEFAULT 0 NOT NULL,
	254	modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
	255	);
	256
	257	create table zephyr
	258	(
	259	class VARCHAR(16) DEFAULT CHR(0) NOT NULL,
	260	xmt_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
	261	xmt_id INTEGER DEFAULT 0 NOT NULL,
	262	sub_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
	263	sub_id INTEGER DEFAULT 0 NOT NULL,
	264	iws_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
	265	iws_id INTEGER DEFAULT 0 NOT NULL,
	266	iui_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
	267	iui_id INTEGER DEFAULT 0 NOT NULL,
	268	owner_type VARCHAR(8) DEFAULT 'NONE' NOT NULL,
	269	owner_id INTEGER DEFAULT 0 NOT NULL,
	270	modtime DATE DEFAULT SYSDATE NOT NULL,
	271	modby INTEGER DEFAULT 0 NOT NULL,
	272	modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
	273	);
	274
	275	create table hostaccess
	276	(
	277	mach_id INTEGER DEFAULT 0 NOT NULL,
	278	acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
	279	acl_id INTEGER DEFAULT 0 NOT NULL,
	280	modtime DATE DEFAULT SYSDATE NOT NULL,
	281	modby INTEGER DEFAULT 0 NOT NULL,
	282	modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
	283	);
	284
	285	create table acl
	286	(
	287	mach_id INTEGER DEFAULT 0 NOT NULL,
	288	target VARCHAR(128) DEFAULT CHR(0) NOT NULL,
	289	kind VARCHAR(16) DEFAULT CHR(0) NOT NULL,
	290	list_id INTEGER DEFAULT 0 NOT NULL,
	291	modtime DATE DEFAULT SYSDATE NOT NULL,
	292	modby INTEGER DEFAULT 0 NOT NULL,
	293	modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
	294	);
	295
	296	create table strings
	297	(
	298	string_id INTEGER DEFAULT 0 NOT NULL,
	299	string VARCHAR(128) DEFAULT CHR(0) NOT NULL
	300	);
	301
	302	create table services
	303	(
	304	name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
	305	protocol VARCHAR(8) DEFAULT CHR(0) NOT NULL,
	306	port SMALLINT DEFAULT 0 NOT NULL,
	307	description VARCHAR(64) DEFAULT CHR(0) NOT NULL,
	308	modtime DATE DEFAULT SYSDATE NOT NULL,
	309	modby INTEGER DEFAULT 0 NOT NULL,
	310	modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
	311	);
	312
	313	create table printers
	314	(
	315	name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
	316	type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
	317	hwtype VARCHAR(16) DEFAULT CHR(0) NOT NULL,
	318	duplexname VARCHAR(16) DEFAULT CHR(0) NOT NULL,
	319	mach_id INTEGER DEFAULT 0 NOT NULL,
	320	loghost INTEGER DEFAULT 0 NOT NULL,
	321	rm INTEGER DEFAULT 0 NOT NULL,
	322	rp VARCHAR(16) DEFAULT CHR(0) NOT NULL,
	323	rq INTEGER DEFAULT 0 NOT NULL,
	324	ka SMALLINT DEFAULT 0 NOT NULL,
	325	pc SMALLINT DEFAULT 0 NOT NULL,
	326	mc SMALLINT DEFAULT 0 NOT NULL,
	327	ac INTEGER DEFAULT 0 NOT NULL,
	328	lpc_acl INTEGER DEFAULT 0 NOT NULL,
	329	banner INTEGER DEFAULT 0 NOT NULL,
	330	location VARCHAR(64) DEFAULT CHR(0) NOT NULL,
	331	contact VARCHAR(64) DEFAULT CHR(0) NOT NULL,
	332	modtime DATE DEFAULT SYSDATE NOT NULL,
	333	modby INTEGER DEFAULT 0 NOT NULL,
	334	modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
	335	);
	336
	337	create table printservers
	338	(
	339	mach_id INTEGER DEFAULT 0 NOT NULL,
	340	kind VARCHAR(8) DEFAULT CHR(0) NOT NULL,
	341	printer_types INTEGER DEFAULT 0 NOT NULL,
	342	owner_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
	343	owner_id INTEGER DEFAULT 0 NOT NULL,
	344	lpc_acl INTEGER DEFAULT 0 NOT NULL,
	345	modtime DATE DEFAULT SYSDATE NOT NULL,
	346	modby INTEGER DEFAULT 0 NOT NULL,
	347	modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
	348	);
	349
	350	create table capacls
	351	(
	352	capability VARCHAR(32) DEFAULT CHR(0) NOT NULL,
	353	tag VARCHAR(4) DEFAULT CHR(0) NOT NULL,
	354	list_id INTEGER DEFAULT 0 NOT NULL
	355	);
	356
	357	create table alias
	358	(
	359	name VARCHAR(32) DEFAULT CHR(0) NOT NULL,
	360	type VARCHAR(16) DEFAULT CHR(0) NOT NULL,
	361	trans VARCHAR(128) DEFAULT CHR(0) NOT NULL
	362	);
	363
	364	create table numvalues
	365	(
	366	name VARCHAR(32) DEFAULT CHR(0) NOT NULL,
	367	value INTEGER DEFAULT 0 NOT NULL
	368	);
	369
	370	create table tblstats
	371	(
	372	table_name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
	373	modtime DATE DEFAULT SYSDATE NOT NULL,
	374	appends INTEGER DEFAULT 0 NOT NULL,
	375	updates INTEGER DEFAULT 0 NOT NULL,
	376	deletes INTEGER DEFAULT 0 NOT NULL
	377	);
	378
	379	create table incremental
	380	(
	381	table_name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
	382	service VARCHAR(16) DEFAULT CHR(0) NOT NULL
	383	);
	384
	385	create table usersids
	386	(
	387	users_id INTEGER DEFAULT 0 NOT NULL,
	388	sid VARCHAR(64) DEFAULT CHR(0) NOT NULL,
	389	created DATE DEFAULT SYSDATE NOT NULL
	390	);
	391
	392	create table listsids
	393	(
	394	list_id INTEGER DEFAULT 0 NOT NULL,
	395	sid VARCHAR(64) DEFAULT CHR(0) NOT NULL,
	396	created DATE DEFAULT SYSDATE NOT NULL
	397	);
	398
	399	create table containers
	400	(
	401	name VARCHAR(255) DEFAULT CHR(0) NOT NULL,
	402	cnt_id INTEGER DEFAULT 0 NOT NULL,
	403	description VARCHAR(255) DEFAULT CHR(0) NOT NULL,
	404	location VARCHAR(64) DEFAULT CHR(0) NOT NULL,
	405	contact VARCHAR(32) DEFAULT CHR(0) NOT NULL,
	406	acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
	407	acl_id INTEGER DEFAULT 0 NOT NULL,
	408	memacl_type VARCHAR(8) DEFAULT 'NONE' NOT NULL,
	409	memacl_id INTEGER DEFAULT 0 NOT NULL,
	410	modtime DATE DEFAULT SYSDATE NOT NULL,
	411	modby INTEGER DEFAULT 0 NOT NULL,
	412	modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
	413	);
	414
	415	create table mcntmap
	416	(
	417	mach_id INTEGER DEFAULT 0 NOT NULL,
	418	cnt_id INTEGER DEFAULT 0 NOT NULL
	419	);