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