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 pin VARCHAR(10) DEFAULT CHR(0) NOT NULL,
48 reservations VARCHAR(10) DEFAULT CHR(0) NOT NULL,
49 flag INTEGER DEFAULT 0 NOT NULL,
50 created DATE DEFAULT SYSDATE NOT NULL,
51 creator INTEGER DEFAULT 0 NOT NULL
56 users_id INTEGER DEFAULT 0 NOT NULL,
57 string_id INTEGER DEFAULT 0 NOT NULL
62 name VARCHAR(255) DEFAULT CHR(0) NOT NULL,
63 mach_id INTEGER DEFAULT 0 NOT NULL,
64 vendor VARCHAR(16) DEFAULT CHR(0) NOT NULL,
65 model VARCHAR(24) DEFAULT CHR(0) NOT NULL,
66 os VARCHAR(16) DEFAULT CHR(0) NOT NULL,
67 location VARCHAR(16) DEFAULT CHR(0) NOT NULL,
68 contact VARCHAR(32) DEFAULT CHR(0) NOT NULL,
69 billing_contact VARCHAR(32) DEFAULT CHR(0) NOT NULL,
70 account_number VARCHAR(10) DEFAULT CHR(0) NOT NULL,
71 use INTEGER DEFAULT 0 NOT NULL,
72 status INTEGER DEFAULT 0 NOT NULL,
73 statuschange DATE DEFAULT SYSDATE NOT NULL,
74 snet_id INTEGER DEFAULT 0 NOT NULL,
75 address VARCHAR(16) DEFAULT CHR(0) NOT NULL,
76 hwaddr VARCHAR(12) DEFAULT CHR(0) NOT NULL,
77 owner_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
78 owner_id INTEGER DEFAULT 0 NOT NULL,
79 acomment INTEGER DEFAULT 0 NOT NULL,
80 ocomment INTEGER DEFAULT 0 NOT NULL,
81 created DATE DEFAULT SYSDATE NOT NULL,
82 creator INTEGER DEFAULT 0 NOT NULL,
83 inuse DATE DEFAULT SYSDATE NOT NULL,
84 modtime DATE DEFAULT SYSDATE NOT NULL,
85 modby INTEGER DEFAULT 0 NOT NULL,
86 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
89 create table hostalias
91 name VARCHAR(255) DEFAULT CHR(0) NOT NULL,
92 mach_id INTEGER DEFAULT 0 NOT NULL
97 name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
98 snet_id INTEGER DEFAULT 0 NOT NULL,
99 description VARCHAR(48) DEFAULT CHR(0) NOT NULL,
100 status INTEGER DEFAULT 0 NOT NULL,
101 contact VARCHAR(32) DEFAULT CHR(0) NOT NULL,
102 account_number VARCHAR(10) DEFAULT CHR(0) NOT NULL,
103 saddr INTEGER DEFAULT 0 NOT NULL,
104 mask INTEGER DEFAULT 0 NOT NULL,
105 low INTEGER DEFAULT 0 NOT NULL,
106 high INTEGER DEFAULT 0 NOT NULL,
107 prefix VARCHAR(8) DEFAULT CHR(0) NOT NULL,
108 owner_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
109 owner_id INTEGER DEFAULT 0 NOT NULL,
110 modtime DATE DEFAULT SYSDATE NOT NULL,
111 modby INTEGER DEFAULT 0 NOT NULL,
112 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
115 create table clusters
117 name VARCHAR(32) DEFAULT CHR(0) NOT NULL,
118 clu_id INTEGER DEFAULT 0 NOT NULL,
119 description VARCHAR(32) DEFAULT CHR(0) NOT NULL,
120 location VARCHAR(64) DEFAULT CHR(0) NOT NULL,
121 modtime DATE DEFAULT SYSDATE NOT NULL,
122 modby INTEGER DEFAULT 0 NOT NULL,
123 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
128 mach_id INTEGER DEFAULT 0 NOT NULL,
129 clu_id INTEGER DEFAULT 0 NOT NULL
134 clu_id INTEGER DEFAULT 0 NOT NULL,
135 serv_label VARCHAR(16) DEFAULT CHR(0) NOT NULL,
136 serv_cluster VARCHAR(128) DEFAULT CHR(0) NOT NULL
141 name VARCHAR(32) DEFAULT CHR(0) NOT NULL,
142 list_id INTEGER DEFAULT 0 NOT NULL,
143 active INTEGER DEFAULT 0 NOT NULL,
144 publicflg INTEGER DEFAULT 0 NOT NULL,
145 hidden INTEGER DEFAULT 0 NOT NULL,
146 maillist INTEGER DEFAULT 0 NOT NULL,
147 grouplist INTEGER DEFAULT 0 NOT NULL,
148 gid SMALLINT DEFAULT 0 NOT NULL,
149 nfsgroup INTEGER DEFAULT 0 NOT NULL,
150 description VARCHAR(255) DEFAULT CHR(0) NOT NULL,
151 acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
152 acl_id INTEGER DEFAULT 0 NOT NULL,
153 memacl_type VARCHAR(8) DEFAULT 'NONE' NOT NULL,
154 memacl_id INTEGER DEFAULT 0 NOT NULL,
155 modtime DATE DEFAULT SYSDATE NOT NULL,
156 modby INTEGER DEFAULT 0 NOT NULL,
157 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
160 create table imembers
162 list_id INTEGER DEFAULT 0 NOT NULL,
163 member_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
164 member_id INTEGER DEFAULT 0 NOT NULL,
165 tag INTEGER DEFAULT 0 NOT NULL,
166 ref_count SMALLINT DEFAULT 0 NOT NULL,
167 direct SMALLINT DEFAULT 0 NOT NULL
172 name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
173 update_int INTEGER DEFAULT 0 NOT NULL,
174 target_file VARCHAR(64) DEFAULT CHR(0) NOT NULL,
175 script VARCHAR(128) DEFAULT CHR(0) NOT NULL,
176 dfgen INTEGER DEFAULT 0 NOT NULL,
177 dfcheck INTEGER DEFAULT 0 NOT NULL,
178 type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
179 enable INTEGER DEFAULT 0 NOT NULL,
180 inprogress INTEGER DEFAULT 0 NOT NULL,
181 harderror INTEGER DEFAULT 0 NOT NULL,
182 errmsg VARCHAR(80) DEFAULT CHR(0) NOT NULL,
183 acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
184 acl_id INTEGER DEFAULT 0 NOT NULL,
185 modtime DATE DEFAULT SYSDATE NOT NULL,
186 modby INTEGER DEFAULT 0 NOT NULL,
187 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
190 create table serverhosts
192 service VARCHAR(16) DEFAULT CHR(0) NOT NULL,
193 mach_id INTEGER DEFAULT 0 NOT NULL,
194 success INTEGER DEFAULT 0 NOT NULL,
195 enable INTEGER DEFAULT 0 NOT NULL,
196 override INTEGER DEFAULT 0 NOT NULL,
197 inprogress INTEGER DEFAULT 0 NOT NULL,
198 hosterror INTEGER DEFAULT 0 NOT NULL,
199 hosterrmsg VARCHAR(80) DEFAULT CHR(0) NOT NULL,
200 ltt INTEGER DEFAULT 0 NOT NULL,
201 lts INTEGER DEFAULT 0 NOT NULL,
202 value1 INTEGER DEFAULT 0 NOT NULL,
203 value2 INTEGER DEFAULT 0 NOT NULL,
204 value3 VARCHAR(32) DEFAULT CHR(0) NOT NULL,
205 modtime DATE DEFAULT SYSDATE NOT NULL,
206 modby INTEGER DEFAULT 0 NOT NULL,
207 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
212 filsys_id INTEGER DEFAULT 0 NOT NULL,
213 phys_id INTEGER DEFAULT 0 NOT NULL,
214 label VARCHAR(32) DEFAULT CHR(0) NOT NULL,
215 fs_order INTEGER DEFAULT 0 NOT NULL,
216 type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
217 mach_id INTEGER DEFAULT 0 NOT NULL,
218 name VARCHAR(80) DEFAULT CHR(0) NOT NULL,
219 mount VARCHAR(32) DEFAULT CHR(0) NOT NULL,
220 rwaccess CHAR(1) DEFAULT CHR(0) NOT NULL,
221 comments VARCHAR(64) DEFAULT CHR(0) NOT NULL,
222 owner INTEGER DEFAULT 0 NOT NULL,
223 owners INTEGER DEFAULT 0 NOT NULL,
224 createflg INTEGER DEFAULT 0 NOT NULL,
225 lockertype VARCHAR(8) DEFAULT CHR(0) NOT NULL,
226 modtime DATE DEFAULT SYSDATE NOT NULL,
227 modby INTEGER DEFAULT 0 NOT NULL,
228 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
233 group_id INTEGER DEFAULT 0 NOT NULL,
234 filsys_id INTEGER DEFAULT 0 NOT NULL,
235 key VARCHAR(8) DEFAULT CHR(0) NOT NULL
240 nfsphys_id INTEGER DEFAULT 0 NOT NULL,
241 mach_id INTEGER DEFAULT 0 NOT NULL,
242 device VARCHAR(32) DEFAULT CHR(0) NOT NULL,
243 dir VARCHAR(64) DEFAULT CHR(0) NOT NULL,
244 status SMALLINT DEFAULT 0 NOT NULL,
245 allocated INTEGER DEFAULT 0 NOT NULL,
246 partsize INTEGER DEFAULT 0 NOT NULL,
247 modtime DATE DEFAULT SYSDATE NOT NULL,
248 modby INTEGER DEFAULT 0 NOT NULL,
249 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
254 filsys_id INTEGER DEFAULT 0 NOT NULL,
255 type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
256 entity_id INTEGER DEFAULT 0 NOT NULL,
257 phys_id INTEGER DEFAULT 0 NOT NULL,
258 quota INTEGER DEFAULT 0 NOT NULL,
259 modtime DATE DEFAULT SYSDATE NOT NULL,
260 modby INTEGER DEFAULT 0 NOT NULL,
261 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
266 class VARCHAR(16) DEFAULT CHR(0) NOT NULL,
267 xmt_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
268 xmt_id INTEGER DEFAULT 0 NOT NULL,
269 sub_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
270 sub_id INTEGER DEFAULT 0 NOT NULL,
271 iws_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
272 iws_id INTEGER DEFAULT 0 NOT NULL,
273 iui_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
274 iui_id INTEGER DEFAULT 0 NOT NULL,
275 owner_type VARCHAR(8) DEFAULT 'NONE' NOT NULL,
276 owner_id INTEGER DEFAULT 0 NOT NULL,
277 modtime DATE DEFAULT SYSDATE NOT NULL,
278 modby INTEGER DEFAULT 0 NOT NULL,
279 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
282 create table hostaccess
284 mach_id INTEGER DEFAULT 0 NOT NULL,
285 acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
286 acl_id INTEGER DEFAULT 0 NOT NULL,
287 modtime DATE DEFAULT SYSDATE NOT NULL,
288 modby INTEGER DEFAULT 0 NOT NULL,
289 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
294 mach_id INTEGER DEFAULT 0 NOT NULL,
295 target VARCHAR(128) DEFAULT CHR(0) NOT NULL,
296 kind VARCHAR(16) DEFAULT CHR(0) NOT NULL,
297 list_id INTEGER DEFAULT 0 NOT NULL,
298 modtime DATE DEFAULT SYSDATE NOT NULL,
299 modby INTEGER DEFAULT 0 NOT NULL,
300 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
305 string_id INTEGER DEFAULT 0 NOT NULL,
306 string VARCHAR(128) DEFAULT CHR(0) NOT NULL
309 create table services
311 name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
312 protocol VARCHAR(8) DEFAULT CHR(0) NOT NULL,
313 port SMALLINT DEFAULT 0 NOT NULL,
314 description VARCHAR(64) DEFAULT CHR(0) NOT NULL,
315 modtime DATE DEFAULT SYSDATE NOT NULL,
316 modby INTEGER DEFAULT 0 NOT NULL,
317 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
320 create table printers
322 name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
323 type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
324 hwtype VARCHAR(16) DEFAULT CHR(0) NOT NULL,
325 duplexname VARCHAR(16) DEFAULT CHR(0) NOT NULL,
326 mach_id INTEGER DEFAULT 0 NOT NULL,
327 loghost INTEGER DEFAULT 0 NOT NULL,
328 rm INTEGER DEFAULT 0 NOT NULL,
329 rp VARCHAR(16) DEFAULT CHR(0) NOT NULL,
330 rq INTEGER DEFAULT 0 NOT NULL,
331 ka SMALLINT DEFAULT 0 NOT NULL,
332 pc SMALLINT DEFAULT 0 NOT NULL,
333 mc SMALLINT DEFAULT 0 NOT NULL,
334 ac INTEGER DEFAULT 0 NOT NULL,
335 lpc_acl INTEGER DEFAULT 0 NOT NULL,
336 banner INTEGER DEFAULT 0 NOT NULL,
337 location VARCHAR(64) DEFAULT CHR(0) NOT NULL,
338 contact VARCHAR(64) DEFAULT CHR(0) NOT NULL,
339 modtime DATE DEFAULT SYSDATE NOT NULL,
340 modby INTEGER DEFAULT 0 NOT NULL,
341 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
344 create table printservers
346 mach_id INTEGER DEFAULT 0 NOT NULL,
347 kind VARCHAR(8) DEFAULT CHR(0) NOT NULL,
348 printer_types INTEGER DEFAULT 0 NOT NULL,
349 owner_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
350 owner_id INTEGER DEFAULT 0 NOT NULL,
351 lpc_acl INTEGER DEFAULT 0 NOT NULL,
352 modtime DATE DEFAULT SYSDATE NOT NULL,
353 modby INTEGER DEFAULT 0 NOT NULL,
354 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
359 capability VARCHAR(32) DEFAULT CHR(0) NOT NULL,
360 tag VARCHAR(4) DEFAULT CHR(0) NOT NULL,
361 list_id INTEGER DEFAULT 0 NOT NULL
366 name VARCHAR(32) DEFAULT CHR(0) NOT NULL,
367 type VARCHAR(16) DEFAULT CHR(0) NOT NULL,
368 trans VARCHAR(128) DEFAULT CHR(0) NOT NULL
371 create table numvalues
373 name VARCHAR(32) DEFAULT CHR(0) NOT NULL,
374 value INTEGER DEFAULT 0 NOT NULL
377 create table tblstats
379 table_name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
380 modtime DATE DEFAULT SYSDATE NOT NULL,
381 appends INTEGER DEFAULT 0 NOT NULL,
382 updates INTEGER DEFAULT 0 NOT NULL,
383 deletes INTEGER DEFAULT 0 NOT NULL
386 create table incremental
388 table_name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
389 service VARCHAR(16) DEFAULT CHR(0) NOT NULL
392 create table usersids
394 users_id INTEGER DEFAULT 0 NOT NULL,
395 sid VARCHAR(64) DEFAULT CHR(0) NOT NULL,
396 created DATE DEFAULT SYSDATE NOT NULL
399 create table listsids
401 list_id INTEGER DEFAULT 0 NOT NULL,
402 sid VARCHAR(64) DEFAULT CHR(0) NOT NULL,
403 created DATE DEFAULT SYSDATE NOT NULL
406 create table containers
408 name VARCHAR(64) DEFAULT CHR(0) NOT NULL,
409 cnt_id INTEGER DEFAULT 0 NOT NULL,
410 description VARCHAR(255) DEFAULT CHR(0) NOT NULL,
411 location VARCHAR(64) DEFAULT CHR(0) NOT NULL,
412 contact VARCHAR(32) DEFAULT CHR(0) NOT NULL,
413 acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
414 acl_id INTEGER DEFAULT 0 NOT NULL,
415 memacl_type VARCHAR(8) DEFAULT 'NONE' NOT NULL,
416 memacl_id INTEGER DEFAULT 0 NOT NULL,
417 modtime DATE DEFAULT SYSDATE NOT NULL,
418 modby INTEGER DEFAULT 0 NOT NULL,
419 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
424 mach_id INTEGER DEFAULT 0 NOT NULL,
425 cnt_id INTEGER DEFAULT 0 NOT NULL
428 create table accountnumbers
430 account_number VARCHAR(10) DEFAULT CHR(0) NOT NULL