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 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
53 users_id INTEGER DEFAULT 0 NOT NULL,
54 string_id INTEGER DEFAULT 0 NOT NULL
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 account_number VARCHAR(10) DEFAULT CHR(0) NOT NULL,
68 use INTEGER DEFAULT 0 NOT NULL,
69 status INTEGER DEFAULT 0 NOT NULL,
70 statuschange DATE DEFAULT SYSDATE NOT NULL,
71 snet_id INTEGER DEFAULT 0 NOT NULL,
72 address VARCHAR(16) DEFAULT CHR(0) NOT NULL,
73 hwaddr VARCHAR(12) DEFAULT CHR(0) NOT NULL,
74 owner_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
75 owner_id INTEGER DEFAULT 0 NOT NULL,
76 acomment INTEGER DEFAULT 0 NOT NULL,
77 ocomment INTEGER DEFAULT 0 NOT NULL,
78 created DATE DEFAULT SYSDATE NOT NULL,
79 creator INTEGER DEFAULT 0 NOT NULL,
80 inuse DATE DEFAULT SYSDATE NOT NULL,
81 modtime DATE DEFAULT SYSDATE NOT NULL,
82 modby INTEGER DEFAULT 0 NOT NULL,
83 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
86 create table hostalias
88 name VARCHAR(255) DEFAULT CHR(0) NOT NULL,
89 mach_id INTEGER DEFAULT 0 NOT NULL
94 name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
95 snet_id INTEGER DEFAULT 0 NOT NULL,
96 description VARCHAR(48) DEFAULT CHR(0) NOT NULL,
97 status INTEGER DEFAULT 0 NOT NULL,
98 contact VARCHAR(32) DEFAULT CHR(0) NOT NULL,
99 account_number VARCHAR(10) DEFAULT CHR(0) NOT NULL,
100 saddr INTEGER DEFAULT 0 NOT NULL,
101 mask INTEGER DEFAULT 0 NOT NULL,
102 low INTEGER DEFAULT 0 NOT NULL,
103 high INTEGER DEFAULT 0 NOT NULL,
104 prefix VARCHAR(8) DEFAULT CHR(0) NOT NULL,
105 owner_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
106 owner_id INTEGER DEFAULT 0 NOT NULL,
107 modtime DATE DEFAULT SYSDATE NOT NULL,
108 modby INTEGER DEFAULT 0 NOT NULL,
109 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
112 create table clusters
114 name VARCHAR(32) DEFAULT CHR(0) NOT NULL,
115 clu_id INTEGER DEFAULT 0 NOT NULL,
116 description VARCHAR(32) DEFAULT CHR(0) NOT NULL,
117 location VARCHAR(64) DEFAULT CHR(0) NOT NULL,
118 modtime DATE DEFAULT SYSDATE NOT NULL,
119 modby INTEGER DEFAULT 0 NOT NULL,
120 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
125 mach_id INTEGER DEFAULT 0 NOT NULL,
126 clu_id INTEGER DEFAULT 0 NOT NULL
131 clu_id INTEGER DEFAULT 0 NOT NULL,
132 serv_label VARCHAR(16) DEFAULT CHR(0) NOT NULL,
133 serv_cluster VARCHAR(128) DEFAULT CHR(0) NOT NULL
138 name VARCHAR(32) DEFAULT CHR(0) NOT NULL,
139 list_id INTEGER DEFAULT 0 NOT NULL,
140 active INTEGER DEFAULT 0 NOT NULL,
141 publicflg INTEGER DEFAULT 0 NOT NULL,
142 hidden INTEGER DEFAULT 0 NOT NULL,
143 maillist INTEGER DEFAULT 0 NOT NULL,
144 grouplist INTEGER DEFAULT 0 NOT NULL,
145 gid SMALLINT DEFAULT 0 NOT NULL,
146 nfsgroup INTEGER DEFAULT 0 NOT NULL,
147 description VARCHAR(255) DEFAULT CHR(0) NOT NULL,
148 acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
149 acl_id INTEGER DEFAULT 0 NOT NULL,
150 memacl_type VARCHAR(8) DEFAULT 'NONE' NOT NULL,
151 memacl_id INTEGER DEFAULT 0 NOT NULL,
152 modtime DATE DEFAULT SYSDATE NOT NULL,
153 modby INTEGER DEFAULT 0 NOT NULL,
154 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
157 create table imembers
159 list_id INTEGER DEFAULT 0 NOT NULL,
160 member_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
161 member_id INTEGER DEFAULT 0 NOT NULL,
162 tag INTEGER DEFAULT 0 NOT NULL,
163 ref_count SMALLINT DEFAULT 0 NOT NULL,
164 direct SMALLINT DEFAULT 0 NOT NULL
169 name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
170 update_int INTEGER DEFAULT 0 NOT NULL,
171 target_file VARCHAR(64) DEFAULT CHR(0) NOT NULL,
172 script VARCHAR(128) DEFAULT CHR(0) NOT NULL,
173 dfgen INTEGER DEFAULT 0 NOT NULL,
174 dfcheck INTEGER DEFAULT 0 NOT NULL,
175 type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
176 enable INTEGER DEFAULT 0 NOT NULL,
177 inprogress INTEGER DEFAULT 0 NOT NULL,
178 harderror INTEGER DEFAULT 0 NOT NULL,
179 errmsg VARCHAR(80) DEFAULT CHR(0) NOT NULL,
180 acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
181 acl_id INTEGER DEFAULT 0 NOT NULL,
182 modtime DATE DEFAULT SYSDATE NOT NULL,
183 modby INTEGER DEFAULT 0 NOT NULL,
184 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
187 create table serverhosts
189 service VARCHAR(16) DEFAULT CHR(0) NOT NULL,
190 mach_id INTEGER DEFAULT 0 NOT NULL,
191 success INTEGER DEFAULT 0 NOT NULL,
192 enable INTEGER DEFAULT 0 NOT NULL,
193 override INTEGER DEFAULT 0 NOT NULL,
194 inprogress INTEGER DEFAULT 0 NOT NULL,
195 hosterror INTEGER DEFAULT 0 NOT NULL,
196 hosterrmsg VARCHAR(80) DEFAULT CHR(0) NOT NULL,
197 ltt INTEGER DEFAULT 0 NOT NULL,
198 lts INTEGER DEFAULT 0 NOT NULL,
199 value1 INTEGER DEFAULT 0 NOT NULL,
200 value2 INTEGER DEFAULT 0 NOT NULL,
201 value3 VARCHAR(32) DEFAULT CHR(0) NOT NULL,
202 modtime DATE DEFAULT SYSDATE NOT NULL,
203 modby INTEGER DEFAULT 0 NOT NULL,
204 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
209 filsys_id INTEGER DEFAULT 0 NOT NULL,
210 phys_id INTEGER DEFAULT 0 NOT NULL,
211 label VARCHAR(32) DEFAULT CHR(0) NOT NULL,
212 fs_order INTEGER DEFAULT 0 NOT NULL,
213 type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
214 mach_id INTEGER DEFAULT 0 NOT NULL,
215 name VARCHAR(80) DEFAULT CHR(0) NOT NULL,
216 mount VARCHAR(32) DEFAULT CHR(0) NOT NULL,
217 rwaccess CHAR(1) DEFAULT CHR(0) NOT NULL,
218 comments VARCHAR(64) DEFAULT CHR(0) NOT NULL,
219 owner INTEGER DEFAULT 0 NOT NULL,
220 owners INTEGER DEFAULT 0 NOT NULL,
221 createflg INTEGER DEFAULT 0 NOT NULL,
222 lockertype VARCHAR(8) DEFAULT CHR(0) NOT NULL,
223 modtime DATE DEFAULT SYSDATE NOT NULL,
224 modby INTEGER DEFAULT 0 NOT NULL,
225 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
230 group_id INTEGER DEFAULT 0 NOT NULL,
231 filsys_id INTEGER DEFAULT 0 NOT NULL,
232 key VARCHAR(8) DEFAULT CHR(0) NOT NULL
237 nfsphys_id INTEGER DEFAULT 0 NOT NULL,
238 mach_id INTEGER DEFAULT 0 NOT NULL,
239 device VARCHAR(32) DEFAULT CHR(0) NOT NULL,
240 dir VARCHAR(64) DEFAULT CHR(0) NOT NULL,
241 status SMALLINT DEFAULT 0 NOT NULL,
242 allocated INTEGER DEFAULT 0 NOT NULL,
243 partsize INTEGER DEFAULT 0 NOT NULL,
244 modtime DATE DEFAULT SYSDATE NOT NULL,
245 modby INTEGER DEFAULT 0 NOT NULL,
246 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
251 filsys_id INTEGER DEFAULT 0 NOT NULL,
252 type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
253 entity_id INTEGER DEFAULT 0 NOT NULL,
254 phys_id INTEGER DEFAULT 0 NOT NULL,
255 quota INTEGER DEFAULT 0 NOT NULL,
256 modtime DATE DEFAULT SYSDATE NOT NULL,
257 modby INTEGER DEFAULT 0 NOT NULL,
258 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
263 class VARCHAR(16) DEFAULT CHR(0) NOT NULL,
264 xmt_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
265 xmt_id INTEGER DEFAULT 0 NOT NULL,
266 sub_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
267 sub_id INTEGER DEFAULT 0 NOT NULL,
268 iws_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
269 iws_id INTEGER DEFAULT 0 NOT NULL,
270 iui_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
271 iui_id INTEGER DEFAULT 0 NOT NULL,
272 owner_type VARCHAR(8) DEFAULT 'NONE' NOT NULL,
273 owner_id INTEGER DEFAULT 0 NOT NULL,
274 modtime DATE DEFAULT SYSDATE NOT NULL,
275 modby INTEGER DEFAULT 0 NOT NULL,
276 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
279 create table hostaccess
281 mach_id INTEGER DEFAULT 0 NOT NULL,
282 acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
283 acl_id INTEGER DEFAULT 0 NOT NULL,
284 modtime DATE DEFAULT SYSDATE NOT NULL,
285 modby INTEGER DEFAULT 0 NOT NULL,
286 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
291 mach_id INTEGER DEFAULT 0 NOT NULL,
292 target VARCHAR(128) DEFAULT CHR(0) NOT NULL,
293 kind VARCHAR(16) DEFAULT CHR(0) NOT NULL,
294 list_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
302 string_id INTEGER DEFAULT 0 NOT NULL,
303 string VARCHAR(128) DEFAULT CHR(0) NOT NULL
306 create table services
308 name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
309 protocol VARCHAR(8) DEFAULT CHR(0) NOT NULL,
310 port SMALLINT DEFAULT 0 NOT NULL,
311 description VARCHAR(64) DEFAULT CHR(0) NOT NULL,
312 modtime DATE DEFAULT SYSDATE NOT NULL,
313 modby INTEGER DEFAULT 0 NOT NULL,
314 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
317 create table printers
319 name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
320 type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
321 hwtype VARCHAR(16) DEFAULT CHR(0) NOT NULL,
322 duplexname VARCHAR(16) DEFAULT CHR(0) NOT NULL,
323 mach_id INTEGER DEFAULT 0 NOT NULL,
324 loghost INTEGER DEFAULT 0 NOT NULL,
325 rm INTEGER DEFAULT 0 NOT NULL,
326 rp VARCHAR(16) DEFAULT CHR(0) NOT NULL,
327 rq INTEGER DEFAULT 0 NOT NULL,
328 ka SMALLINT DEFAULT 0 NOT NULL,
329 pc SMALLINT DEFAULT 0 NOT NULL,
330 mc SMALLINT DEFAULT 0 NOT NULL,
331 ac INTEGER DEFAULT 0 NOT NULL,
332 lpc_acl INTEGER DEFAULT 0 NOT NULL,
333 banner INTEGER DEFAULT 0 NOT NULL,
334 location VARCHAR(64) DEFAULT CHR(0) NOT NULL,
335 contact VARCHAR(64) DEFAULT CHR(0) NOT NULL,
336 modtime DATE DEFAULT SYSDATE NOT NULL,
337 modby INTEGER DEFAULT 0 NOT NULL,
338 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
341 create table printservers
343 mach_id INTEGER DEFAULT 0 NOT NULL,
344 kind VARCHAR(8) DEFAULT CHR(0) NOT NULL,
345 printer_types INTEGER DEFAULT 0 NOT NULL,
346 owner_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
347 owner_id INTEGER DEFAULT 0 NOT NULL,
348 lpc_acl INTEGER DEFAULT 0 NOT NULL,
349 modtime DATE DEFAULT SYSDATE NOT NULL,
350 modby INTEGER DEFAULT 0 NOT NULL,
351 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
356 capability VARCHAR(32) DEFAULT CHR(0) NOT NULL,
357 tag VARCHAR(4) DEFAULT CHR(0) NOT NULL,
358 list_id INTEGER DEFAULT 0 NOT NULL
363 name VARCHAR(32) DEFAULT CHR(0) NOT NULL,
364 type VARCHAR(16) DEFAULT CHR(0) NOT NULL,
365 trans VARCHAR(128) DEFAULT CHR(0) NOT NULL
368 create table numvalues
370 name VARCHAR(32) DEFAULT CHR(0) NOT NULL,
371 value INTEGER DEFAULT 0 NOT NULL
374 create table tblstats
376 table_name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
377 modtime DATE DEFAULT SYSDATE NOT NULL,
378 appends INTEGER DEFAULT 0 NOT NULL,
379 updates INTEGER DEFAULT 0 NOT NULL,
380 deletes INTEGER DEFAULT 0 NOT NULL
383 create table incremental
385 table_name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
386 service VARCHAR(16) DEFAULT CHR(0) NOT NULL
389 create table usersids
391 users_id INTEGER DEFAULT 0 NOT NULL,
392 sid VARCHAR(64) DEFAULT CHR(0) NOT NULL,
393 created DATE DEFAULT SYSDATE NOT NULL
396 create table listsids
398 list_id INTEGER DEFAULT 0 NOT NULL,
399 sid VARCHAR(64) DEFAULT CHR(0) NOT NULL,
400 created DATE DEFAULT SYSDATE NOT NULL
403 create table containers
405 name VARCHAR(64) DEFAULT CHR(0) NOT NULL,
406 cnt_id INTEGER DEFAULT 0 NOT NULL,
407 description VARCHAR(255) DEFAULT CHR(0) NOT NULL,
408 location VARCHAR(64) DEFAULT CHR(0) NOT NULL,
409 contact VARCHAR(32) DEFAULT CHR(0) NOT NULL,
410 acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
411 acl_id INTEGER DEFAULT 0 NOT NULL,
412 memacl_type VARCHAR(8) DEFAULT 'NONE' NOT NULL,
413 memacl_id INTEGER DEFAULT 0 NOT NULL,
414 modtime DATE DEFAULT SYSDATE NOT NULL,
415 modby INTEGER DEFAULT 0 NOT NULL,
416 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
421 mach_id INTEGER DEFAULT 0 NOT NULL,
422 cnt_id INTEGER DEFAULT 0 NOT NULL
425 create table accountnumbers
427 account_number VARCHAR(10) DEFAULT CHR(0) NOT NULL