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,
52 winhomedir VARCHAR(260) DEFAULT '[DFS]' NOT NULL,
53 winprofiledir VARCHAR(260) DEFAULT '[DFS]' NOT NULL
58 users_id INTEGER DEFAULT 0 NOT NULL,
59 string_id INTEGER DEFAULT 0 NOT NULL
64 name VARCHAR(255) DEFAULT CHR(0) NOT NULL,
65 mach_id INTEGER DEFAULT 0 NOT NULL,
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,
70 contact VARCHAR(255) DEFAULT CHR(0) NOT NULL,
71 billing_contact VARCHAR(255) DEFAULT CHR(0) NOT NULL,
72 account_number VARCHAR(10) DEFAULT CHR(0) NOT NULL,
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,
77 address VARCHAR(16) DEFAULT CHR(0) NOT NULL,
78 hwaddr VARCHAR(12) DEFAULT CHR(0) NOT NULL,
79 owner_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
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,
88 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
91 create table hostalias
93 name VARCHAR(255) DEFAULT CHR(0) NOT NULL,
94 mach_id INTEGER DEFAULT 0 NOT NULL
99 name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
100 snet_id INTEGER DEFAULT 0 NOT NULL,
101 description VARCHAR(48) DEFAULT CHR(0) NOT NULL,
102 status INTEGER DEFAULT 0 NOT NULL,
103 contact VARCHAR(255) DEFAULT CHR(0) NOT NULL,
104 account_number VARCHAR(10) DEFAULT CHR(0) NOT NULL,
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,
109 prefix VARCHAR(8) DEFAULT CHR(0) NOT NULL,
110 owner_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
111 owner_id INTEGER DEFAULT 0 NOT NULL,
112 modtime DATE DEFAULT SYSDATE NOT NULL,
113 modby INTEGER DEFAULT 0 NOT NULL,
114 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
117 create table clusters
119 name VARCHAR(32) DEFAULT CHR(0) NOT NULL,
120 clu_id INTEGER DEFAULT 0 NOT NULL,
121 description VARCHAR(32) DEFAULT CHR(0) NOT NULL,
122 location VARCHAR(64) DEFAULT CHR(0) NOT NULL,
123 modtime DATE DEFAULT SYSDATE NOT NULL,
124 modby INTEGER DEFAULT 0 NOT NULL,
125 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
130 mach_id INTEGER DEFAULT 0 NOT NULL,
131 clu_id INTEGER DEFAULT 0 NOT NULL
136 clu_id INTEGER DEFAULT 0 NOT NULL,
137 serv_label VARCHAR(16) DEFAULT CHR(0) NOT NULL,
138 serv_cluster VARCHAR(128) DEFAULT CHR(0) NOT NULL
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,
151 nfsgroup INTEGER DEFAULT 0 NOT NULL,
152 mailman INTEGER DEFAULT 0 NOT NULL,
153 mailman_id INTEGER DEFAULT 0 NOT NULL,
154 description VARCHAR(255) DEFAULT CHR(0) NOT NULL,
155 acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
156 acl_id INTEGER DEFAULT 0 NOT NULL,
157 memacl_type VARCHAR(8) DEFAULT 'NONE' NOT NULL,
158 memacl_id INTEGER DEFAULT 0 NOT NULL,
159 modtime DATE DEFAULT SYSDATE NOT NULL,
160 modby INTEGER DEFAULT 0 NOT NULL,
161 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
164 create table imembers
166 list_id INTEGER DEFAULT 0 NOT NULL,
167 member_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
168 member_id INTEGER DEFAULT 0 NOT NULL,
169 tag INTEGER DEFAULT 0 NOT NULL,
170 ref_count SMALLINT DEFAULT 0 NOT NULL,
171 direct SMALLINT DEFAULT 0 NOT NULL
176 name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
177 update_int INTEGER DEFAULT 0 NOT NULL,
178 target_file VARCHAR(64) DEFAULT CHR(0) NOT NULL,
179 script VARCHAR(128) DEFAULT CHR(0) NOT NULL,
180 dfgen INTEGER DEFAULT 0 NOT NULL,
181 dfcheck INTEGER DEFAULT 0 NOT NULL,
182 type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
183 enable INTEGER DEFAULT 0 NOT NULL,
184 inprogress INTEGER DEFAULT 0 NOT NULL,
185 harderror INTEGER DEFAULT 0 NOT NULL,
186 errmsg VARCHAR(80) DEFAULT CHR(0) NOT NULL,
187 acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
188 acl_id INTEGER DEFAULT 0 NOT NULL,
189 modtime DATE DEFAULT SYSDATE NOT NULL,
190 modby INTEGER DEFAULT 0 NOT NULL,
191 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
194 create table serverhosts
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,
203 hosterrmsg VARCHAR(80) DEFAULT CHR(0) NOT NULL,
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,
208 value3 VARCHAR(32) DEFAULT CHR(0) NOT NULL,
209 modtime DATE DEFAULT SYSDATE NOT NULL,
210 modby INTEGER DEFAULT 0 NOT NULL,
211 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
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,
220 type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
221 mach_id INTEGER DEFAULT 0 NOT NULL,
222 name VARCHAR(80) DEFAULT CHR(0) NOT NULL,
223 mount VARCHAR(32) DEFAULT CHR(0) NOT NULL,
224 rwaccess CHAR(1) DEFAULT CHR(0) NOT NULL,
225 comments VARCHAR(64) DEFAULT CHR(0) NOT NULL,
226 owner INTEGER DEFAULT 0 NOT NULL,
227 owners INTEGER DEFAULT 0 NOT NULL,
228 createflg INTEGER DEFAULT 0 NOT NULL,
229 lockertype VARCHAR(8) DEFAULT CHR(0) NOT NULL,
230 modtime DATE DEFAULT SYSDATE NOT NULL,
231 modby INTEGER DEFAULT 0 NOT NULL,
232 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
237 group_id INTEGER DEFAULT 0 NOT NULL,
238 filsys_id INTEGER DEFAULT 0 NOT NULL,
239 key VARCHAR(8) DEFAULT CHR(0) NOT NULL
244 nfsphys_id INTEGER DEFAULT 0 NOT NULL,
245 mach_id INTEGER DEFAULT 0 NOT NULL,
246 device VARCHAR(32) DEFAULT CHR(0) NOT NULL,
247 dir VARCHAR(64) DEFAULT CHR(0) NOT NULL,
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,
253 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
258 filsys_id INTEGER DEFAULT 0 NOT NULL,
259 type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
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,
265 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
270 class VARCHAR(16) DEFAULT CHR(0) NOT NULL,
271 xmt_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
272 xmt_id INTEGER DEFAULT 0 NOT NULL,
273 sub_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
274 sub_id INTEGER DEFAULT 0 NOT NULL,
275 iws_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
276 iws_id INTEGER DEFAULT 0 NOT NULL,
277 iui_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
278 iui_id INTEGER DEFAULT 0 NOT NULL,
279 owner_type VARCHAR(8) DEFAULT 'NONE' NOT NULL,
280 owner_id INTEGER DEFAULT 0 NOT NULL,
281 modtime DATE DEFAULT SYSDATE NOT NULL,
282 modby INTEGER DEFAULT 0 NOT NULL,
283 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
286 create table hostaccess
288 mach_id INTEGER DEFAULT 0 NOT NULL,
289 acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
290 acl_id INTEGER DEFAULT 0 NOT NULL,
291 modtime DATE DEFAULT SYSDATE NOT NULL,
292 modby INTEGER DEFAULT 0 NOT NULL,
293 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
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
309 string_id INTEGER DEFAULT 0 NOT NULL,
310 string VARCHAR(128) DEFAULT CHR(0) NOT NULL
313 create table services
315 name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
316 protocol VARCHAR(8) DEFAULT CHR(0) NOT NULL,
317 port SMALLINT DEFAULT 0 NOT NULL,
318 description VARCHAR(64) DEFAULT CHR(0) NOT NULL,
319 modtime DATE DEFAULT SYSDATE NOT NULL,
320 modby INTEGER DEFAULT 0 NOT NULL,
321 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
324 create table printers
326 name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
327 type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
328 hwtype VARCHAR(16) DEFAULT CHR(0) NOT NULL,
329 duplexname VARCHAR(16) DEFAULT CHR(0) NOT NULL,
330 mach_id INTEGER DEFAULT 0 NOT NULL,
331 loghost INTEGER DEFAULT 0 NOT NULL,
332 rm INTEGER DEFAULT 0 NOT NULL,
333 rp VARCHAR(16) DEFAULT CHR(0) NOT NULL,
334 rq INTEGER DEFAULT 0 NOT NULL,
335 ka SMALLINT DEFAULT 0 NOT NULL,
336 pc SMALLINT DEFAULT 0 NOT NULL,
337 mc SMALLINT DEFAULT 0 NOT NULL,
338 ac INTEGER DEFAULT 0 NOT NULL,
339 lpc_acl INTEGER DEFAULT 0 NOT NULL,
340 banner INTEGER DEFAULT 0 NOT NULL,
341 location VARCHAR(64) DEFAULT CHR(0) NOT NULL,
342 contact VARCHAR(64) DEFAULT CHR(0) NOT NULL,
343 modtime DATE DEFAULT SYSDATE NOT NULL,
344 modby INTEGER DEFAULT 0 NOT NULL,
345 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
348 create table printservers
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
363 capability VARCHAR(32) DEFAULT CHR(0) NOT NULL,
364 tag VARCHAR(4) DEFAULT CHR(0) NOT NULL,
365 list_id INTEGER DEFAULT 0 NOT NULL
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
375 create table numvalues
377 name VARCHAR(32) DEFAULT CHR(0) NOT NULL,
378 value INTEGER DEFAULT 0 NOT NULL
381 create table tblstats
383 table_name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
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
390 create table incremental
392 table_name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
393 service VARCHAR(16) DEFAULT CHR(0) NOT NULL
396 create table usersids
398 users_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 listsids
405 list_id INTEGER DEFAULT 0 NOT NULL,
406 sid VARCHAR(64) DEFAULT CHR(0) NOT NULL,
407 created DATE DEFAULT SYSDATE NOT NULL
410 create table containers
412 name VARCHAR(64) DEFAULT CHR(0) NOT NULL,
413 cnt_id INTEGER DEFAULT 0 NOT NULL,
414 list_id INTEGER DEFAULT 0 NOT NULL,
415 publicflg INTEGER DEFAULT 0 NOT NULL,
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
430 mach_id INTEGER DEFAULT 0 NOT NULL,
431 cnt_id INTEGER DEFAULT 0 NOT NULL
434 create table accountnumbers
436 account_number VARCHAR(10) DEFAULT CHR(0) NOT NULL