[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		CHAR(32) 	DEFAULT CHR(0)	NOT NULL,
	last		VARCHAR(16) 	DEFAULT CHR(0)	NOT NULL,
	first		VARCHAR(16) 	DEFAULT CHR(0)	NOT NULL,
	middle		CHAR(16) 	DEFAULT CHR(0)	NOT NULL,
	status		SMALLINT 	DEFAULT 0	NOT NULL,
	clearid		VARCHAR(16) 	DEFAULT CHR(0)	NOT NULL,
	type		CHAR(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		CHAR(8) 	DEFAULT CHR(0)	NOT NULL,
	fullname	CHAR(32) 	DEFAULT CHR(0)	NOT NULL,
	nickname	CHAR(16) 	DEFAULT CHR(0)	NOT NULL,
	home_addr	CHAR(82) 	DEFAULT CHR(0)	NOT NULL,
	home_phone	CHAR(16) 	DEFAULT CHR(0)	NOT NULL,
	office_addr	CHAR(16) 	DEFAULT CHR(0)	NOT NULL,
	office_phone	CHAR(12) 	DEFAULT CHR(0)	NOT NULL,
	department	CHAR(20) 	DEFAULT CHR(0)	NOT NULL,
	affiliation	CHAR(50) 	DEFAULT CHR(0)	NOT NULL,
	fmodtime	DATE    	DEFAULT SYSDATE	NOT NULL,
	fmodby		INTEGER		DEFAULT 0	NOT NULL,
	fmodwith	CHAR(8) 	DEFAULT CHR(0)	NOT NULL,
	potype		CHAR(8) 	DEFAULT CHR(0)	NOT NULL,
	pop_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	CHAR(8) 	DEFAULT CHR(0)	NOT NULL,
	xname           CHAR(30)        DEFAULT CHR(0)	NOT NULL,
	xdept        	CHAR(20)        DEFAULT CHR(0)	NOT NULL,
	xtitle       	CHAR(50)	DEFAULT CHR(0)	NOT NULL,
	xaddress     	CHAR(82)	DEFAULT CHR(0)	NOT NULL,
	xphone1      	CHAR(12)	DEFAULT CHR(0)	NOT NULL,
	xphone2      	CHAR(12)	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,       
	flag         	INTEGER		DEFAULT 0	NOT NULL
);

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

create table machine
(
	name		VARCHAR(40) 	DEFAULT CHR(0)	NOT NULL,
	mach_id		INTEGER		DEFAULT 0	NOT NULL,
	vendor		CHAR(16) 	DEFAULT CHR(0)	NOT NULL,
	model		CHAR(24) 	DEFAULT CHR(0)	NOT NULL,
	os		CHAR(16) 	DEFAULT CHR(0)	NOT NULL,
	location	CHAR(16) 	DEFAULT CHR(0)	NOT NULL,
	contact		CHAR(32) 	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		CHAR(16)	DEFAULT CHR(0)	NOT NULL,
	owner_type	CHAR(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		CHAR(8) 	DEFAULT CHR(0)	NOT NULL
);

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

create table subnet
(
	name		CHAR(16) 	DEFAULT CHR(0)	NOT NULL,
	snet_id		INTEGER		DEFAULT 0	NOT NULL,
	description	VARCHAR(48) 	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		CHAR(8)		DEFAULT CHR(0)	NOT NULL,
	owner_type	CHAR(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		CHAR(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	CHAR(32) 	DEFAULT CHR(0)	NOT NULL,
	location	CHAR(64) 	DEFAULT CHR(0)	NOT NULL,
	modtime	 	DATE    	DEFAULT SYSDATE	NOT NULL,
	modby		INTEGER		DEFAULT 0	NOT NULL,
	modwith		CHAR(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	CHAR(32) 	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,
	description	CHAR(255) 	DEFAULT CHR(0)	NOT NULL,
	acl_type	CHAR(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		CHAR(8) 	DEFAULT CHR(0)	NOT NULL
);

create table imembers 
(
	list_id		INTEGER		DEFAULT 0	NOT NULL,
	member_type	CHAR(8) 	DEFAULT CHR(0)	NOT NULL,
	member_id	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	CHAR(64) 	DEFAULT CHR(0)	NOT NULL,
	script		CHAR(128) 	DEFAULT CHR(0)	NOT NULL,
	dfgen		INTEGER		DEFAULT 0	NOT NULL,
	dfcheck		INTEGER		DEFAULT 0	NOT NULL,
	type		CHAR(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		CHAR(80) 	DEFAULT CHR(0)	NOT NULL,
	acl_type	CHAR(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		CHAR(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	CHAR(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		CHAR(32) 	DEFAULT CHR(0)	NOT NULL,
	modtime		DATE    	DEFAULT SYSDATE	NOT NULL,
	modby		INTEGER		DEFAULT 0	NOT NULL,
	modwith		CHAR(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		CHAR(8) 	DEFAULT CHR(0)	NOT NULL,
	mach_id		INTEGER		DEFAULT 0	NOT NULL,
	name		VARCHAR(80) 	DEFAULT CHR(0)	NOT NULL,
	mount		CHAR(32) 	DEFAULT CHR(0)	NOT NULL,
	rwaccess	CHAR(1) 	DEFAULT CHR(0)	NOT NULL,
	comments	CHAR(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	CHAR(8) 	DEFAULT CHR(0)	NOT NULL,
	modtime		DATE    	DEFAULT SYSDATE	NOT NULL,
	modby		INTEGER		DEFAULT 0	NOT NULL,
	modwith		CHAR(8) 	DEFAULT CHR(0) 	NOT NULL
);

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

create table nfsphys 
(
	nfsphys_id	INTEGER		DEFAULT 0	NOT NULL,
	mach_id		INTEGER		DEFAULT 0	NOT NULL,
	device		CHAR(16) 	DEFAULT CHR(0)	NOT NULL,
	dir		VARCHAR(16) 	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		CHAR(8) 	DEFAULT CHR(0)	NOT NULL
);

create table quota 
(
	filsys_id	INTEGER		DEFAULT 0	NOT NULL,
	type		CHAR(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		CHAR(8) 	DEFAULT CHR(0) 	NOT NULL
);

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

create table hostaccess 
(
	mach_id		INTEGER		DEFAULT 0	NOT NULL,
	acl_type	CHAR(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		CHAR(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	CHAR(8) 	DEFAULT CHR(0)	NOT NULL,
	port		SMALLINT 	DEFAULT 0	NOT NULL,
	description	CHAR(64) 	DEFAULT CHR(0)	NOT NULL,
	modtime		DATE    	DEFAULT SYSDATE	NOT NULL,
	modby		INTEGER		DEFAULT 0	NOT NULL,
	modwith		CHAR(8) 	DEFAULT CHR(0) 	NOT NULL
);

create table printcap 
(
	name		VARCHAR(16) 	DEFAULT CHR(0)	NOT NULL,
	mach_id		INTEGER		DEFAULT 0	NOT NULL,
	dir		CHAR(32) 	DEFAULT CHR(0)	NOT NULL,
	rp		CHAR(16) 	DEFAULT CHR(0)	NOT NULL,
	quotaserver	INTEGER		DEFAULT 0	NOT NULL,
	auth		INTEGER 	DEFAULT 0	NOT NULL,
	price		SMALLINT 	DEFAULT 0	NOT NULL,
	comments	CHAR(64) 	DEFAULT CHR(0)	NOT NULL,
	modtime		DATE    	DEFAULT SYSDATE	NOT NULL,
	modby		INTEGER		DEFAULT 0	NOT NULL,
	modwith		CHAR(8) 	DEFAULT CHR(0)	NOT NULL
);

create table palladium
(
	name		VARCHAR(32) 	DEFAULT CHR(0)	NOT NULL,
	identifier	INTEGER		DEFAULT 0	NOT NULL,
	mach_id		INTEGER		DEFAULT 0	NOT NULL,
	modtime		DATE    	DEFAULT SYSDATE	NOT NULL,
	modby		INTEGER		DEFAULT 0	NOT NULL,
	modwith		CHAR(8) 	DEFAULT CHR(0)	NOT NULL
);

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