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