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(255) DEFAULT CHR(0) NOT NULL,
69 billing_contact VARCHAR(255) 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(255) 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 mailman INTEGER DEFAULT 0 NOT NULL,
151 mailman_id INTEGER DEFAULT 0 NOT NULL,
152 description VARCHAR(255) DEFAULT CHR(0) NOT NULL,
153 acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
154 acl_id INTEGER DEFAULT 0 NOT NULL,
155 memacl_type VARCHAR(8) DEFAULT 'NONE' NOT NULL,
156 memacl_id INTEGER DEFAULT 0 NOT NULL,
157 modtime DATE DEFAULT SYSDATE NOT NULL,
158 modby INTEGER DEFAULT 0 NOT NULL,
159 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
162 create table imembers
164 list_id INTEGER DEFAULT 0 NOT NULL,
165 member_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
166 member_id INTEGER DEFAULT 0 NOT NULL,
167 tag INTEGER DEFAULT 0 NOT NULL,
168 ref_count SMALLINT DEFAULT 0 NOT NULL,
169 direct SMALLINT DEFAULT 0 NOT NULL
174 name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
175 update_int INTEGER DEFAULT 0 NOT NULL,
176 target_file VARCHAR(64) DEFAULT CHR(0) NOT NULL,
177 script VARCHAR(128) DEFAULT CHR(0) NOT NULL,
178 dfgen INTEGER DEFAULT 0 NOT NULL,
179 dfcheck INTEGER DEFAULT 0 NOT NULL,
180 type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
181 enable INTEGER DEFAULT 0 NOT NULL,
182 inprogress INTEGER DEFAULT 0 NOT NULL,
183 harderror INTEGER DEFAULT 0 NOT NULL,
184 errmsg VARCHAR(80) DEFAULT CHR(0) NOT NULL,
185 acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
186 acl_id INTEGER DEFAULT 0 NOT NULL,
187 modtime DATE DEFAULT SYSDATE NOT NULL,
188 modby INTEGER DEFAULT 0 NOT NULL,
189 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
192 create table serverhosts
194 service VARCHAR(16) DEFAULT CHR(0) NOT NULL,
195 mach_id INTEGER DEFAULT 0 NOT NULL,
196 success INTEGER DEFAULT 0 NOT NULL,
197 enable INTEGER DEFAULT 0 NOT NULL,
198 override INTEGER DEFAULT 0 NOT NULL,
199 inprogress INTEGER DEFAULT 0 NOT NULL,
200 hosterror INTEGER DEFAULT 0 NOT NULL,
201 hosterrmsg VARCHAR(80) DEFAULT CHR(0) NOT NULL,
202 ltt INTEGER DEFAULT 0 NOT NULL,
203 lts INTEGER DEFAULT 0 NOT NULL,
204 value1 INTEGER DEFAULT 0 NOT NULL,
205 value2 INTEGER DEFAULT 0 NOT NULL,
206 value3 VARCHAR(32) DEFAULT CHR(0) NOT NULL,
207 modtime DATE DEFAULT SYSDATE NOT NULL,
208 modby INTEGER DEFAULT 0 NOT NULL,
209 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
214 filsys_id INTEGER DEFAULT 0 NOT NULL,
215 phys_id INTEGER DEFAULT 0 NOT NULL,
216 label VARCHAR(32) DEFAULT CHR(0) NOT NULL,
217 fs_order INTEGER DEFAULT 0 NOT NULL,
218 type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
219 mach_id INTEGER DEFAULT 0 NOT NULL,
220 name VARCHAR(80) DEFAULT CHR(0) NOT NULL,
221 mount VARCHAR(32) DEFAULT CHR(0) NOT NULL,
222 rwaccess CHAR(1) DEFAULT CHR(0) NOT NULL,
223 comments VARCHAR(64) DEFAULT CHR(0) NOT NULL,
224 owner INTEGER DEFAULT 0 NOT NULL,
225 owners INTEGER DEFAULT 0 NOT NULL,
226 createflg INTEGER DEFAULT 0 NOT NULL,
227 lockertype VARCHAR(8) DEFAULT CHR(0) NOT NULL,
228 modtime DATE DEFAULT SYSDATE NOT NULL,
229 modby INTEGER DEFAULT 0 NOT NULL,
230 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
235 group_id INTEGER DEFAULT 0 NOT NULL,
236 filsys_id INTEGER DEFAULT 0 NOT NULL,
237 key VARCHAR(8) DEFAULT CHR(0) NOT NULL
242 nfsphys_id INTEGER DEFAULT 0 NOT NULL,
243 mach_id INTEGER DEFAULT 0 NOT NULL,
244 device VARCHAR(32) DEFAULT CHR(0) NOT NULL,
245 dir VARCHAR(64) DEFAULT CHR(0) NOT NULL,
246 status SMALLINT DEFAULT 0 NOT NULL,
247 allocated INTEGER DEFAULT 0 NOT NULL,
248 partsize INTEGER DEFAULT 0 NOT NULL,
249 modtime DATE DEFAULT SYSDATE NOT NULL,
250 modby INTEGER DEFAULT 0 NOT NULL,
251 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
256 filsys_id INTEGER DEFAULT 0 NOT NULL,
257 type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
258 entity_id INTEGER DEFAULT 0 NOT NULL,
259 phys_id INTEGER DEFAULT 0 NOT NULL,
260 quota INTEGER DEFAULT 0 NOT NULL,
261 modtime DATE DEFAULT SYSDATE NOT NULL,
262 modby INTEGER DEFAULT 0 NOT NULL,
263 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
268 class VARCHAR(16) DEFAULT CHR(0) NOT NULL,
269 xmt_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
270 xmt_id INTEGER DEFAULT 0 NOT NULL,
271 sub_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
272 sub_id INTEGER DEFAULT 0 NOT NULL,
273 iws_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
274 iws_id INTEGER DEFAULT 0 NOT NULL,
275 iui_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
276 iui_id INTEGER DEFAULT 0 NOT NULL,
277 owner_type VARCHAR(8) DEFAULT 'NONE' NOT NULL,
278 owner_id INTEGER DEFAULT 0 NOT NULL,
279 modtime DATE DEFAULT SYSDATE NOT NULL,
280 modby INTEGER DEFAULT 0 NOT NULL,
281 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
284 create table hostaccess
286 mach_id INTEGER DEFAULT 0 NOT NULL,
287 acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
288 acl_id INTEGER DEFAULT 0 NOT NULL,
289 modtime DATE DEFAULT SYSDATE NOT NULL,
290 modby INTEGER DEFAULT 0 NOT NULL,
291 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
296 mach_id INTEGER DEFAULT 0 NOT NULL,
297 target VARCHAR(128) DEFAULT CHR(0) NOT NULL,
298 kind VARCHAR(16) DEFAULT CHR(0) NOT NULL,
299 list_id INTEGER DEFAULT 0 NOT NULL,
300 modtime DATE DEFAULT SYSDATE NOT NULL,
301 modby INTEGER DEFAULT 0 NOT NULL,
302 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
307 string_id INTEGER DEFAULT 0 NOT NULL,
308 string VARCHAR(128) DEFAULT CHR(0) NOT NULL
311 create table services
313 name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
314 protocol VARCHAR(8) DEFAULT CHR(0) NOT NULL,
315 port SMALLINT DEFAULT 0 NOT NULL,
316 description VARCHAR(64) DEFAULT CHR(0) NOT NULL,
317 modtime DATE DEFAULT SYSDATE NOT NULL,
318 modby INTEGER DEFAULT 0 NOT NULL,
319 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
322 create table printers
324 name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
325 type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
326 hwtype VARCHAR(16) DEFAULT CHR(0) NOT NULL,
327 duplexname VARCHAR(16) DEFAULT CHR(0) NOT NULL,
328 mach_id INTEGER DEFAULT 0 NOT NULL,
329 loghost INTEGER DEFAULT 0 NOT NULL,
330 rm INTEGER DEFAULT 0 NOT NULL,
331 rp VARCHAR(16) DEFAULT CHR(0) NOT NULL,
332 rq INTEGER DEFAULT 0 NOT NULL,
333 ka SMALLINT DEFAULT 0 NOT NULL,
334 pc SMALLINT DEFAULT 0 NOT NULL,
335 mc SMALLINT DEFAULT 0 NOT NULL,
336 ac INTEGER DEFAULT 0 NOT NULL,
337 lpc_acl INTEGER DEFAULT 0 NOT NULL,
338 banner INTEGER DEFAULT 0 NOT NULL,
339 location VARCHAR(64) DEFAULT CHR(0) NOT NULL,
340 contact VARCHAR(64) DEFAULT CHR(0) NOT NULL,
341 modtime DATE DEFAULT SYSDATE NOT NULL,
342 modby INTEGER DEFAULT 0 NOT NULL,
343 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
346 create table printservers
348 mach_id INTEGER DEFAULT 0 NOT NULL,
349 kind VARCHAR(8) DEFAULT CHR(0) NOT NULL,
350 printer_types INTEGER DEFAULT 0 NOT NULL,
351 owner_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
352 owner_id INTEGER DEFAULT 0 NOT NULL,
353 lpc_acl INTEGER DEFAULT 0 NOT NULL,
354 modtime DATE DEFAULT SYSDATE NOT NULL,
355 modby INTEGER DEFAULT 0 NOT NULL,
356 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
361 capability VARCHAR(32) DEFAULT CHR(0) NOT NULL,
362 tag VARCHAR(4) DEFAULT CHR(0) NOT NULL,
363 list_id INTEGER DEFAULT 0 NOT NULL
368 name VARCHAR(32) DEFAULT CHR(0) NOT NULL,
369 type VARCHAR(16) DEFAULT CHR(0) NOT NULL,
370 trans VARCHAR(128) DEFAULT CHR(0) NOT NULL
373 create table numvalues
375 name VARCHAR(32) DEFAULT CHR(0) NOT NULL,
376 value INTEGER DEFAULT 0 NOT NULL
379 create table tblstats
381 table_name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
382 modtime DATE DEFAULT SYSDATE NOT NULL,
383 appends INTEGER DEFAULT 0 NOT NULL,
384 updates INTEGER DEFAULT 0 NOT NULL,
385 deletes INTEGER DEFAULT 0 NOT NULL
388 create table incremental
390 table_name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
391 service VARCHAR(16) DEFAULT CHR(0) NOT NULL
394 create table usersids
396 users_id INTEGER DEFAULT 0 NOT NULL,
397 sid VARCHAR(64) DEFAULT CHR(0) NOT NULL,
398 created DATE DEFAULT SYSDATE NOT NULL
401 create table listsids
403 list_id INTEGER DEFAULT 0 NOT NULL,
404 sid VARCHAR(64) DEFAULT CHR(0) NOT NULL,
405 created DATE DEFAULT SYSDATE NOT NULL
408 create table containers
410 name VARCHAR(64) DEFAULT CHR(0) NOT NULL,
411 cnt_id INTEGER DEFAULT 0 NOT NULL,
412 list_id INTEGER DEFAULT 0 NOT NULL,
413 publicflg INTEGER DEFAULT 0 NOT NULL,
414 description VARCHAR(255) DEFAULT CHR(0) NOT NULL,
415 location VARCHAR(64) DEFAULT CHR(0) NOT NULL,
416 contact VARCHAR(32) DEFAULT CHR(0) NOT NULL,
417 acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
418 acl_id INTEGER DEFAULT 0 NOT NULL,
419 memacl_type VARCHAR(8) DEFAULT 'NONE' NOT NULL,
420 memacl_id INTEGER DEFAULT 0 NOT NULL,
421 modtime DATE DEFAULT SYSDATE NOT NULL,
422 modby INTEGER DEFAULT 0 NOT NULL,
423 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
428 mach_id INTEGER DEFAULT 0 NOT NULL,
429 cnt_id INTEGER DEFAULT 0 NOT NULL
432 create table accountnumbers
434 account_number VARCHAR(10) DEFAULT CHR(0) NOT NULL