[moira.git] / db / schema.sql

create table users
(
	login		VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL,
	users_id	INTEGER		DEFAULT 0	NOT NULL,
	unix_uid	SMALLINT 	DEFAULT 0	NOT NULL,
	shell		VARCHAR(32)	DEFAULT CHR(0)	NOT NULL,
	winconsoleshell VARCHAR(32)	DEFAULT 'cmd'	NOT NULL,
	last		VARCHAR(30) 	DEFAULT CHR(0)	NOT NULL,
	first		VARCHAR(30) 	DEFAULT CHR(0)	NOT NULL,
	middle		VARCHAR(30) 	DEFAULT CHR(0)	NOT NULL,
	status		SMALLINT 	DEFAULT 0	NOT NULL,
	clearid		VARCHAR(16) 	DEFAULT CHR(0)	NOT NULL,
	type		VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL,
	comments        INTEGER		DEFAULT 0	NOT NULL,
	modtime		DATE    	DEFAULT SYSDATE	NOT NULL,
	modby		INTEGER		DEFAULT 0	NOT NULL,
	modwith		VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL,
	fullname	VARCHAR(92) 	DEFAULT CHR(0)	NOT NULL,
	nickname	VARCHAR(16) 	DEFAULT CHR(0)	NOT NULL,
	home_addr	VARCHAR(82) 	DEFAULT CHR(0)	NOT NULL,
	home_phone	VARCHAR(24) 	DEFAULT CHR(0)	NOT NULL,
	office_addr	VARCHAR(16) 	DEFAULT CHR(0)	NOT NULL,
	office_phone	VARCHAR(24) 	DEFAULT CHR(0)	NOT NULL,
	department	VARCHAR(50) 	DEFAULT CHR(0)	NOT NULL,
	affiliation	VARCHAR(50) 	DEFAULT CHR(0)	NOT NULL,
	fmodtime	DATE    	DEFAULT SYSDATE	NOT NULL,
	fmodby		INTEGER		DEFAULT 0	NOT NULL,
	fmodwith	VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL,
	potype		VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL,
	pop_id		INTEGER		DEFAULT 0	NOT NULL,
	imap_id		INTEGER		DEFAULT 0	NOT NULL,
	box_id		INTEGER		DEFAULT 0	NOT NULL,
	pmodtime	DATE    	DEFAULT SYSDATE	NOT NULL,
	pmodby		INTEGER		DEFAULT 0	NOT NULL,
	pmodwith	VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL,
	xname           VARCHAR(30)	DEFAULT CHR(0)	NOT NULL,
	xdept        	VARCHAR(50)	DEFAULT CHR(0)	NOT NULL,
	xtitle       	VARCHAR(50)	DEFAULT CHR(0)	NOT NULL,
	xaddress     	VARCHAR(82)	DEFAULT CHR(0)	NOT NULL,
	xphone1      	VARCHAR(24)	DEFAULT CHR(0)	NOT NULL,
	xphone2      	VARCHAR(24)	DEFAULT CHR(0)	NOT NULL,
	xmodtime     	DATE         	DEFAULT SYSDATE	NOT NULL,
	sigdate      	INTEGER		DEFAULT 0	NOT NULL,
	sigwho       	INTEGER		DEFAULT 0	NOT NULL,
	signature    	VARCHAR(68)	DEFAULT CHR(0)	NOT NULL,
	secure       	INTEGER		DEFAULT 0	NOT NULL,       
	pin		VARCHAR(10)	DEFAULT CHR(0)	NOT NULL,
	reservations	VARCHAR(10)	DEFAULT CHR(0)	NOT NULL,
	flag         	INTEGER		DEFAULT 0	NOT NULL,
	created		DATE		DEFAULT SYSDATE	NOT NULL,
	creator		INTEGER		DEFAULT 0	NOT NULL,
	winhomedir	VARCHAR(260)	DEFAULT '[AFS]' NOT NULL,
	winprofiledir	VARCHAR(260)	DEFAULT '[AFS]' NOT NULL,
);

create table krbmap
(
	users_id	INTEGER		DEFAULT 0	NOT NULL,
	string_id	INTEGER		DEFAULT 0	NOT NULL
);

create table machine
(
	name		VARCHAR(255) 	DEFAULT CHR(0)	NOT NULL,
	mach_id		INTEGER		DEFAULT 0	NOT NULL,
	vendor		VARCHAR(16) 	DEFAULT CHR(0)	NOT NULL,
	model		VARCHAR(24) 	DEFAULT CHR(0)	NOT NULL,
	os		VARCHAR(16) 	DEFAULT CHR(0)	NOT NULL,
	location	VARCHAR(16) 	DEFAULT CHR(0)	NOT NULL,
	contact		VARCHAR(255) 	DEFAULT CHR(0)	NOT NULL,
	billing_contact	VARCHAR(255)	DEFAULT CHR(0)	NOT NULL,
	account_number	VARCHAR(10)	DEFAULT CHR(0)	NOT NULL,	
	use		INTEGER		DEFAULT 0	NOT NULL,
	status		INTEGER		DEFAULT 0	NOT NULL,
	statuschange	DATE    	DEFAULT SYSDATE	NOT NULL,
	snet_id		INTEGER		DEFAULT 0	NOT NULL,
	address		VARCHAR(16)	DEFAULT CHR(0)	NOT NULL,
	hwaddr		VARCHAR(12)	DEFAULT CHR(0)	NOT NULL,
	owner_type	VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL,
	owner_id	INTEGER		DEFAULT 0	NOT NULL,
	acomment	INTEGER		DEFAULT 0	NOT NULL,
	ocomment	INTEGER		DEFAULT 0	NOT NULL,
	created		DATE 		DEFAULT SYSDATE	NOT NULL,
	creator		INTEGER		DEFAULT 0	NOT NULL,
	inuse		DATE		DEFAULT SYSDATE	NOT NULL,
	modtime		DATE    	DEFAULT SYSDATE	NOT NULL,
	modby		INTEGER		DEFAULT 0	NOT NULL,
	modwith		VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL
);

create table hostalias
(
	name		VARCHAR(255) 	DEFAULT CHR(0)	NOT NULL,
	mach_id		INTEGER	 	DEFAULT 0	NOT NULL
);

create table subnet
(
	name		VARCHAR(16) 	DEFAULT CHR(0)	NOT NULL,
	snet_id		INTEGER		DEFAULT 0	NOT NULL,
	description	VARCHAR(48) 	DEFAULT CHR(0)	NOT NULL,
	status		INTEGER		DEFAULT 0	NOT NULL,
	contact		VARCHAR(255)	DEFAULT CHR(0)	NOT NULL,
	account_number	VARCHAR(10)	DEFAULT CHR(0)	NOT NULL,
	saddr		INTEGER		DEFAULT 0	NOT NULL,
	mask		INTEGER		DEFAULT 0	NOT NULL,
	low		INTEGER		DEFAULT 0	NOT NULL,
	high		INTEGER		DEFAULT 0	NOT NULL,
	prefix		VARCHAR(8)	DEFAULT CHR(0)	NOT NULL,
	owner_type	VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL,
	owner_id	INTEGER		DEFAULT 0	NOT NULL,
	modtime		DATE 		DEFAULT SYSDATE	NOT NULL,
	modby		INTEGER		DEFAULT 0	NOT NULL,
	modwith		VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL
);

create table clusters
(
	name		VARCHAR(32) 	DEFAULT CHR(0)	NOT NULL,
	clu_id		INTEGER		DEFAULT 0	NOT NULL,
	description	VARCHAR(32) 	DEFAULT CHR(0)	NOT NULL,
	location	VARCHAR(64) 	DEFAULT CHR(0)	NOT NULL,
	modtime	 	DATE    	DEFAULT SYSDATE	NOT NULL,
	modby		INTEGER		DEFAULT 0	NOT NULL,
	modwith		VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL
);

create table mcmap
(
	mach_id		INTEGER		DEFAULT 0	NOT NULL,
	clu_id		INTEGER		DEFAULT 0	NOT NULL
);

create table svc
(
	clu_id		INTEGER		DEFAULT 0	NOT NULL,
	serv_label	VARCHAR(16) 	DEFAULT CHR(0)	NOT NULL,
	serv_cluster	VARCHAR(128) 	DEFAULT CHR(0)	NOT NULL
);

create table list
(
	name		VARCHAR(32) 	DEFAULT CHR(0)	NOT NULL,
	list_id		INTEGER		DEFAULT 0	NOT NULL,
	active		INTEGER 	DEFAULT 0	NOT NULL,
	publicflg	INTEGER 	DEFAULT 0	NOT NULL,
	hidden		INTEGER 	DEFAULT 0	NOT NULL,
	maillist	INTEGER 	DEFAULT 0	NOT NULL,
	grouplist	INTEGER 	DEFAULT 0	NOT NULL,
	gid		SMALLINT 	DEFAULT 0	NOT NULL,
	nfsgroup	INTEGER		DEFAULT 0	NOT NULL,	
	mailman		INTEGER		DEFAULT 0	NOT NULL,
	mailman_id	INTEGER		DEFAULT 0	NOT NULL,
	description	VARCHAR(255) 	DEFAULT CHR(0)	NOT NULL,
	acl_type	VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL,
	acl_id		INTEGER		DEFAULT 0	NOT NULL,
	memacl_type	VARCHAR(8)	DEFAULT 'NONE'	NOT NULL,
	memacl_id	INTEGER		DEFAULT 0	NOT NULL,
	modtime		DATE    	DEFAULT SYSDATE	NOT NULL,
	modby		INTEGER		DEFAULT 0	NOT NULL,
	modwith		VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL
);

create table imembers 
(
	list_id		INTEGER		DEFAULT 0	NOT NULL,
	member_type	VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL,
	member_id	INTEGER		DEFAULT 0	NOT NULL,
	tag		INTEGER		DEFAULT 0	NOT NULL,
	ref_count	SMALLINT 	DEFAULT 0	NOT NULL,
	direct		SMALLINT 	DEFAULT 0	NOT NULL
);

create table servers 
(
	name		VARCHAR(16) 	DEFAULT CHR(0)	NOT NULL,
	update_int	INTEGER		DEFAULT 0	NOT NULL,
	target_file	VARCHAR(64) 	DEFAULT CHR(0)	NOT NULL,
	script		VARCHAR(128) 	DEFAULT CHR(0)	NOT NULL,
	dfgen		INTEGER		DEFAULT 0	NOT NULL,
	dfcheck		INTEGER		DEFAULT 0	NOT NULL,
	type		VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL,
	enable		INTEGER 	DEFAULT 0	NOT NULL,
	inprogress	INTEGER 	DEFAULT 0	NOT NULL,
	harderror	INTEGER		DEFAULT 0	NOT NULL,
	errmsg		VARCHAR(80) 	DEFAULT CHR(0)	NOT NULL,
	acl_type	VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL,
	acl_id		INTEGER		DEFAULT 0	NOT NULL,
	modtime		DATE    	DEFAULT SYSDATE	NOT NULL,
	modby		INTEGER		DEFAULT 0	NOT NULL,
	modwith		VARCHAR(8) 	DEFAULT CHR(0) 	NOT NULL
);

create table serverhosts 
(
	service		VARCHAR(16) 	DEFAULT CHR(0)	NOT NULL,
	mach_id		INTEGER		DEFAULT 0	NOT NULL,
	success		INTEGER 	DEFAULT 0	NOT NULL,
	enable		INTEGER 	DEFAULT 0	NOT NULL,
	override	INTEGER 	DEFAULT 0	NOT NULL,
	inprogress	INTEGER 	DEFAULT 0	NOT NULL,
	hosterror	INTEGER		DEFAULT 0	NOT NULL,
	hosterrmsg	VARCHAR(80) 	DEFAULT CHR(0)	NOT NULL,
	ltt		INTEGER		DEFAULT 0	NOT NULL,
	lts		INTEGER		DEFAULT 0	NOT NULL,
	value1		INTEGER		DEFAULT 0	NOT NULL,
	value2		INTEGER		DEFAULT 0	NOT NULL,
	value3		VARCHAR(32) 	DEFAULT CHR(0)	NOT NULL,
	modtime		DATE    	DEFAULT SYSDATE	NOT NULL,
	modby		INTEGER		DEFAULT 0	NOT NULL,
	modwith		VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL
);

create table filesys 
(
	filsys_id	INTEGER		DEFAULT 0	NOT NULL,
	phys_id		INTEGER		DEFAULT 0	NOT NULL,
	label		VARCHAR(32) 	DEFAULT CHR(0)	NOT NULL,
	fs_order	INTEGER		DEFAULT 0	NOT NULL,
	type		VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL,
	mach_id		INTEGER		DEFAULT 0	NOT NULL,
	name		VARCHAR(80) 	DEFAULT CHR(0)	NOT NULL,
	mount		VARCHAR(32) 	DEFAULT CHR(0)	NOT NULL,
	rwaccess	CHAR(1) 	DEFAULT CHR(0)	NOT NULL,
	comments	VARCHAR(64) 	DEFAULT CHR(0)	NOT NULL,
	owner		INTEGER		DEFAULT 0	NOT NULL,
	owners		INTEGER		DEFAULT 0	NOT NULL,
	createflg	INTEGER 	DEFAULT 0	NOT NULL,
	lockertype	VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL,
	modtime		DATE    	DEFAULT SYSDATE	NOT NULL,
	modby		INTEGER		DEFAULT 0	NOT NULL,
	modwith		VARCHAR(8) 	DEFAULT CHR(0) 	NOT NULL
);

create table fsgroup
(
	group_id	INTEGER		DEFAULT 0	NOT NULL,
	filsys_id	INTEGER		DEFAULT 0	NOT NULL,
	key		VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL
);

create table nfsphys 
(
	nfsphys_id	INTEGER		DEFAULT 0	NOT NULL,
	mach_id		INTEGER		DEFAULT 0	NOT NULL,
	device		VARCHAR(32) 	DEFAULT CHR(0)	NOT NULL,
	dir		VARCHAR(64) 	DEFAULT CHR(0)	NOT NULL,
	status		SMALLINT 	DEFAULT 0	NOT NULL,
	allocated	INTEGER		DEFAULT 0	NOT NULL,
	partsize	INTEGER		DEFAULT 0	NOT NULL,
	modtime		DATE    	DEFAULT SYSDATE	NOT NULL,
	modby		INTEGER		DEFAULT 0	NOT NULL,
	modwith		VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL
);

create table quota 
(
	filsys_id	INTEGER		DEFAULT 0	NOT NULL,
	type		VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL,
	entity_id	INTEGER		DEFAULT 0	NOT NULL,
	phys_id		INTEGER		DEFAULT 0	NOT NULL,
	quota		INTEGER		DEFAULT 0	NOT NULL,
	modtime		DATE    	DEFAULT SYSDATE	NOT NULL,
	modby		INTEGER		DEFAULT 0	NOT NULL,
	modwith		VARCHAR(8) 	DEFAULT CHR(0) 	NOT NULL
);

create table zephyr 
(
	class		VARCHAR(16) 	DEFAULT CHR(0)	NOT NULL,
	xmt_type	VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL,
	xmt_id		INTEGER		DEFAULT 0	NOT NULL,
	sub_type	VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL,
	sub_id		INTEGER		DEFAULT 0	NOT NULL,
	iws_type	VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL,
	iws_id		INTEGER		DEFAULT 0	NOT NULL,
	iui_type	VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL,
	iui_id		INTEGER		DEFAULT 0	NOT NULL,
	owner_type	VARCHAR(8)	DEFAULT 'NONE'	NOT NULL,
	owner_id	INTEGER		DEFAULT 0	NOT NULL,
	modtime 	DATE    	DEFAULT SYSDATE	NOT NULL,
	modby		INTEGER		DEFAULT 0	NOT NULL,
	modwith		VARCHAR(8) 	DEFAULT CHR(0) 	NOT NULL
);

create table hostaccess 
(
	mach_id		INTEGER		DEFAULT 0	NOT NULL,
	acl_type	VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL,
	acl_id		INTEGER		DEFAULT 0	NOT NULL,
	modtime		DATE    	DEFAULT SYSDATE	NOT NULL,
	modby		INTEGER		DEFAULT 0	NOT NULL,
	modwith		VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL
);

create table acl
(
	mach_id		INTEGER		DEFAULT 0	NOT NULL,
	target		VARCHAR(128)	DEFAULT CHR(0)	NOT NULL,
	kind		VARCHAR(16)	DEFAULT CHR(0)	NOT NULL,
	list_id		INTEGER		DEFAULT 0	NOT NULL,
	modtime		DATE    	DEFAULT SYSDATE	NOT NULL,
	modby		INTEGER		DEFAULT 0	NOT NULL,
	modwith		VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL
);

create table strings 
(
	string_id	INTEGER		DEFAULT 0	NOT NULL,
	string		VARCHAR(128)	DEFAULT CHR(0)	NOT NULL
);

create table services 
(
	name		VARCHAR(16) 	DEFAULT CHR(0)	NOT NULL,
	protocol	VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL,
	port		SMALLINT 	DEFAULT 0	NOT NULL,
	description	VARCHAR(64) 	DEFAULT CHR(0)	NOT NULL,
	modtime		DATE    	DEFAULT SYSDATE	NOT NULL,
	modby		INTEGER		DEFAULT 0	NOT NULL,
	modwith		VARCHAR(8) 	DEFAULT CHR(0) 	NOT NULL
);

create table printers
(
	name		VARCHAR(16) 	DEFAULT CHR(0)	NOT NULL,
	type		VARCHAR(8)	DEFAULT CHR(0)	NOT NULL,
	hwtype		VARCHAR(16)	DEFAULT CHR(0)	NOT NULL,
	duplexname	VARCHAR(16) 	DEFAULT CHR(0)	NOT NULL,
	mach_id		INTEGER		DEFAULT 0	NOT NULL,
	loghost		INTEGER		DEFAULT 0	NOT NULL,
	rm		INTEGER		DEFAULT 0	NOT NULL,
	rp		VARCHAR(16) 	DEFAULT CHR(0)	NOT NULL,
	rq		INTEGER		DEFAULT 0	NOT NULL,
	ka		SMALLINT 	DEFAULT 0	NOT NULL,
	pc		SMALLINT 	DEFAULT 0	NOT NULL,
	mc		SMALLINT	DEFAULT 0	NOT NULL,
	ac		INTEGER		DEFAULT 0	NOT NULL,
	lpc_acl		INTEGER		DEFAULT 0	NOT NULL,
	banner		INTEGER		DEFAULT 0	NOT NULL,
	location	VARCHAR(64)	DEFAULT CHR(0)	NOT NULL,
	contact		VARCHAR(64)	DEFAULT CHR(0)	NOT NULL,
	modtime		DATE    	DEFAULT SYSDATE	NOT NULL,
	modby		INTEGER		DEFAULT 0	NOT NULL,
	modwith		VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL
);

create table printservers
(
	mach_id		INTEGER		DEFAULT 0	NOT NULL,
	kind		VARCHAR(8)	DEFAULT CHR(0)	NOT NULL,
	printer_types	INTEGER		DEFAULT 0	NOT NULL,
	owner_type	VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL,
	owner_id	INTEGER		DEFAULT 0	NOT NULL,
	lpc_acl		INTEGER		DEFAULT 0	NOT NULL,
	modtime		DATE    	DEFAULT SYSDATE	NOT NULL,
	modby		INTEGER		DEFAULT 0	NOT NULL,
	modwith		VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL
);

create table capacls 
(
	capability	VARCHAR(32) 	DEFAULT CHR(0)	NOT NULL,
	tag		VARCHAR(4) 	DEFAULT CHR(0)	NOT NULL,
	list_id		INTEGER		DEFAULT 0	NOT NULL
);

create table alias 
(
	name		VARCHAR(32) 	DEFAULT CHR(0)	NOT NULL,
	type		VARCHAR(16) 	DEFAULT CHR(0)	NOT NULL,
	trans		VARCHAR(128) 	DEFAULT CHR(0)	NOT NULL
);

create table numvalues 
(
	name		VARCHAR(32) 	DEFAULT CHR(0)	NOT NULL,
	value		INTEGER		DEFAULT 0	NOT NULL
);

create table tblstats 
(
	table_name	VARCHAR(16)	DEFAULT CHR(0)	NOT NULL,
	modtime		DATE    	DEFAULT SYSDATE	NOT NULL,
	appends		INTEGER		DEFAULT 0	NOT NULL,
	updates		INTEGER		DEFAULT 0	NOT NULL,
	deletes		INTEGER		DEFAULT 0	NOT NULL
);

create table incremental
(
	table_name	VARCHAR(16)	DEFAULT CHR(0)	NOT NULL,
	service		VARCHAR(16) 	DEFAULT CHR(0)	NOT NULL
);

create table usersids
(
	users_id	INTEGER		DEFAULT 0	NOT NULL,
	sid		VARCHAR(64)	DEFAULT CHR(0)	NOT NULL,
	created		DATE		DEFAULT SYSDATE	NOT NULL
);

create table listsids
(
	list_id		INTEGER		DEFAULT 0	NOT NULL,
	sid		VARCHAR(64)	DEFAULT CHR(0)	NOT NULL,
	created		DATE		DEFAULT SYSDATE	NOT NULL
);

create table containers
(
	name		VARCHAR(64) 	DEFAULT CHR(0)	NOT NULL,
	cnt_id		INTEGER		DEFAULT 0	NOT NULL,
	list_id		INTEGER		DEFAULT 0	NOT NULL,
	publicflg	INTEGER		DEFAULT 0	NOT NULL,
	description	VARCHAR(255) 	DEFAULT CHR(0)	NOT NULL,
	location	VARCHAR(64) 	DEFAULT CHR(0)	NOT NULL,
	contact		VARCHAR(32) 	DEFAULT CHR(0)	NOT NULL,
	acl_type	VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL,
	acl_id		INTEGER		DEFAULT 0	NOT NULL,
	memacl_type	VARCHAR(8)	DEFAULT 'NONE'	NOT NULL,
	memacl_id	INTEGER		DEFAULT 0	NOT NULL,
	modtime		DATE    	DEFAULT SYSDATE	NOT NULL,
	modby		INTEGER		DEFAULT 0	NOT NULL,
	modwith		VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL
);

create table mcntmap
(
	mach_id		INTEGER		DEFAULT 0	NOT NULL,
	cnt_id		INTEGER		DEFAULT 0	NOT NULL
);

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