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,
54 sponsor_type VARCHAR(8) DEFAULT 'NONE' NOT NULL,
55 sponsor_id INTEGER DEFAULT 0 NOT NULL
60 users_id INTEGER DEFAULT 0 NOT NULL,
61 string_id INTEGER DEFAULT 0 NOT NULL
66 name VARCHAR(255) DEFAULT CHR(0) NOT NULL,
67 mach_id INTEGER DEFAULT 0 NOT NULL,
68 vendor VARCHAR(16) DEFAULT CHR(0) NOT NULL,
69 model VARCHAR(24) DEFAULT CHR(0) NOT NULL,
70 os VARCHAR(16) DEFAULT CHR(0) NOT NULL,
71 location VARCHAR(16) DEFAULT CHR(0) NOT NULL,
72 contact VARCHAR(255) DEFAULT CHR(0) NOT NULL,
73 billing_contact VARCHAR(255) DEFAULT CHR(0) NOT NULL,
74 account_number VARCHAR(10) DEFAULT CHR(0) NOT NULL,
75 use INTEGER DEFAULT 0 NOT NULL,
76 status INTEGER DEFAULT 0 NOT NULL,
77 statuschange DATE DEFAULT SYSDATE NOT NULL,
78 snet_id INTEGER DEFAULT 0 NOT NULL,
79 address VARCHAR(16) DEFAULT CHR(0) NOT NULL,
80 hwaddr VARCHAR(12) DEFAULT CHR(0) NOT NULL,
81 owner_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
82 owner_id INTEGER DEFAULT 0 NOT NULL,
83 acomment INTEGER DEFAULT 0 NOT NULL,
84 ocomment INTEGER DEFAULT 0 NOT NULL,
85 created DATE DEFAULT SYSDATE NOT NULL,
86 creator INTEGER DEFAULT 0 NOT NULL,
87 inuse DATE DEFAULT SYSDATE NOT NULL,
88 modtime DATE DEFAULT SYSDATE NOT NULL,
89 modby INTEGER DEFAULT 0 NOT NULL,
90 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
93 create table hostalias
95 name VARCHAR(255) DEFAULT CHR(0) NOT NULL,
96 mach_id INTEGER DEFAULT 0 NOT NULL
101 name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
102 snet_id INTEGER DEFAULT 0 NOT NULL,
103 description VARCHAR(48) DEFAULT CHR(0) NOT NULL,
104 status INTEGER DEFAULT 0 NOT NULL,
105 contact VARCHAR(255) DEFAULT CHR(0) NOT NULL,
106 account_number VARCHAR(10) DEFAULT CHR(0) NOT NULL,
107 saddr INTEGER DEFAULT 0 NOT NULL,
108 mask INTEGER DEFAULT 0 NOT NULL,
109 low INTEGER DEFAULT 0 NOT NULL,
110 high INTEGER DEFAULT 0 NOT NULL,
111 prefix VARCHAR(8) DEFAULT CHR(0) NOT NULL,
112 owner_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
113 owner_id INTEGER DEFAULT 0 NOT NULL,
114 modtime DATE DEFAULT SYSDATE NOT NULL,
115 modby INTEGER DEFAULT 0 NOT NULL,
116 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
119 create table clusters
121 name VARCHAR(32) DEFAULT CHR(0) NOT NULL,
122 clu_id INTEGER DEFAULT 0 NOT NULL,
123 description VARCHAR(32) DEFAULT CHR(0) NOT NULL,
124 location VARCHAR(64) DEFAULT CHR(0) NOT NULL,
125 modtime DATE DEFAULT SYSDATE NOT NULL,
126 modby INTEGER DEFAULT 0 NOT NULL,
127 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
132 mach_id INTEGER DEFAULT 0 NOT NULL,
133 clu_id INTEGER DEFAULT 0 NOT NULL
138 clu_id INTEGER DEFAULT 0 NOT NULL,
139 serv_label VARCHAR(16) DEFAULT CHR(0) NOT NULL,
140 serv_cluster VARCHAR(128) DEFAULT CHR(0) NOT NULL
145 name VARCHAR(32) DEFAULT CHR(0) NOT NULL,
146 list_id INTEGER DEFAULT 0 NOT NULL,
147 active INTEGER DEFAULT 0 NOT NULL,
148 publicflg INTEGER DEFAULT 0 NOT NULL,
149 hidden INTEGER DEFAULT 0 NOT NULL,
150 maillist INTEGER DEFAULT 0 NOT NULL,
151 grouplist INTEGER DEFAULT 0 NOT NULL,
152 gid SMALLINT DEFAULT 0 NOT NULL,
153 nfsgroup INTEGER DEFAULT 0 NOT NULL,
154 mailman INTEGER DEFAULT 0 NOT NULL,
155 mailman_id INTEGER DEFAULT 0 NOT NULL,
156 description VARCHAR(255) DEFAULT CHR(0) NOT NULL,
157 acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
158 acl_id INTEGER DEFAULT 0 NOT NULL,
159 memacl_type VARCHAR(8) DEFAULT 'NONE' NOT NULL,
160 memacl_id INTEGER DEFAULT 0 NOT NULL,
161 modtime DATE DEFAULT SYSDATE NOT NULL,
162 modby INTEGER DEFAULT 0 NOT NULL,
163 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
166 create table imembers
168 list_id INTEGER DEFAULT 0 NOT NULL,
169 member_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
170 member_id INTEGER DEFAULT 0 NOT NULL,
171 tag INTEGER DEFAULT 0 NOT NULL,
172 ref_count SMALLINT DEFAULT 0 NOT NULL,
173 direct SMALLINT DEFAULT 0 NOT NULL
178 name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
179 update_int INTEGER DEFAULT 0 NOT NULL,
180 target_file VARCHAR(64) DEFAULT CHR(0) NOT NULL,
181 script VARCHAR(128) DEFAULT CHR(0) NOT NULL,
182 dfgen INTEGER DEFAULT 0 NOT NULL,
183 dfcheck INTEGER DEFAULT 0 NOT NULL,
184 type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
185 enable INTEGER DEFAULT 0 NOT NULL,
186 inprogress INTEGER DEFAULT 0 NOT NULL,
187 harderror INTEGER DEFAULT 0 NOT NULL,
188 errmsg VARCHAR(80) DEFAULT CHR(0) NOT NULL,
189 acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
190 acl_id INTEGER DEFAULT 0 NOT NULL,
191 modtime DATE DEFAULT SYSDATE NOT NULL,
192 modby INTEGER DEFAULT 0 NOT NULL,
193 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
196 create table serverhosts
198 service VARCHAR(16) DEFAULT CHR(0) NOT NULL,
199 mach_id INTEGER DEFAULT 0 NOT NULL,
200 success INTEGER DEFAULT 0 NOT NULL,
201 enable INTEGER DEFAULT 0 NOT NULL,
202 override INTEGER DEFAULT 0 NOT NULL,
203 inprogress INTEGER DEFAULT 0 NOT NULL,
204 hosterror INTEGER DEFAULT 0 NOT NULL,
205 hosterrmsg VARCHAR(80) DEFAULT CHR(0) NOT NULL,
206 ltt INTEGER DEFAULT 0 NOT NULL,
207 lts INTEGER DEFAULT 0 NOT NULL,
208 value1 INTEGER DEFAULT 0 NOT NULL,
209 value2 INTEGER DEFAULT 0 NOT NULL,
210 value3 VARCHAR(32) DEFAULT CHR(0) NOT NULL,
211 modtime DATE DEFAULT SYSDATE NOT NULL,
212 modby INTEGER DEFAULT 0 NOT NULL,
213 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
218 filsys_id INTEGER DEFAULT 0 NOT NULL,
219 phys_id INTEGER DEFAULT 0 NOT NULL,
220 label VARCHAR(32) DEFAULT CHR(0) NOT NULL,
221 fs_order INTEGER DEFAULT 0 NOT NULL,
222 type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
223 mach_id INTEGER DEFAULT 0 NOT NULL,
224 name VARCHAR(80) DEFAULT CHR(0) NOT NULL,
225 mount VARCHAR(32) DEFAULT CHR(0) NOT NULL,
226 rwaccess CHAR(1) DEFAULT CHR(0) NOT NULL,
227 comments VARCHAR(64) DEFAULT CHR(0) NOT NULL,
228 owner INTEGER DEFAULT 0 NOT NULL,
229 owners INTEGER DEFAULT 0 NOT NULL,
230 createflg INTEGER DEFAULT 0 NOT NULL,
231 lockertype VARCHAR(8) DEFAULT CHR(0) NOT NULL,
232 modtime DATE DEFAULT SYSDATE NOT NULL,
233 modby INTEGER DEFAULT 0 NOT NULL,
234 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
239 group_id INTEGER DEFAULT 0 NOT NULL,
240 filsys_id INTEGER DEFAULT 0 NOT NULL,
241 key VARCHAR(8) DEFAULT CHR(0) NOT NULL
246 nfsphys_id INTEGER DEFAULT 0 NOT NULL,
247 mach_id INTEGER DEFAULT 0 NOT NULL,
248 device VARCHAR(32) DEFAULT CHR(0) NOT NULL,
249 dir VARCHAR(64) DEFAULT CHR(0) NOT NULL,
250 status SMALLINT DEFAULT 0 NOT NULL,
251 allocated INTEGER DEFAULT 0 NOT NULL,
252 partsize INTEGER DEFAULT 0 NOT NULL,
253 modtime DATE DEFAULT SYSDATE NOT NULL,
254 modby INTEGER DEFAULT 0 NOT NULL,
255 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
260 filsys_id INTEGER DEFAULT 0 NOT NULL,
261 type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
262 entity_id INTEGER DEFAULT 0 NOT NULL,
263 phys_id INTEGER DEFAULT 0 NOT NULL,
264 quota INTEGER DEFAULT 0 NOT NULL,
265 modtime DATE DEFAULT SYSDATE NOT NULL,
266 modby INTEGER DEFAULT 0 NOT NULL,
267 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
272 class VARCHAR(16) DEFAULT CHR(0) NOT NULL,
273 xmt_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
274 xmt_id INTEGER DEFAULT 0 NOT NULL,
275 sub_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
276 sub_id INTEGER DEFAULT 0 NOT NULL,
277 iws_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
278 iws_id INTEGER DEFAULT 0 NOT NULL,
279 iui_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
280 iui_id INTEGER DEFAULT 0 NOT NULL,
281 owner_type VARCHAR(8) DEFAULT 'NONE' NOT NULL,
282 owner_id INTEGER DEFAULT 0 NOT NULL,
283 modtime DATE DEFAULT SYSDATE NOT NULL,
284 modby INTEGER DEFAULT 0 NOT NULL,
285 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
288 create table hostaccess
290 mach_id INTEGER DEFAULT 0 NOT NULL,
291 acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
292 acl_id INTEGER DEFAULT 0 NOT NULL,
293 modtime DATE DEFAULT SYSDATE NOT NULL,
294 modby INTEGER DEFAULT 0 NOT NULL,
295 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
300 mach_id INTEGER DEFAULT 0 NOT NULL,
301 target VARCHAR(128) DEFAULT CHR(0) NOT NULL,
302 kind VARCHAR(16) DEFAULT CHR(0) NOT NULL,
303 list_id INTEGER DEFAULT 0 NOT NULL,
304 modtime DATE DEFAULT SYSDATE NOT NULL,
305 modby INTEGER DEFAULT 0 NOT NULL,
306 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
311 string_id INTEGER DEFAULT 0 NOT NULL,
312 string VARCHAR(128) DEFAULT CHR(0) NOT NULL
315 create table services
317 name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
318 protocol VARCHAR(8) DEFAULT CHR(0) NOT NULL,
319 port SMALLINT DEFAULT 0 NOT NULL,
320 description VARCHAR(64) DEFAULT CHR(0) NOT NULL,
321 modtime DATE DEFAULT SYSDATE NOT NULL,
322 modby INTEGER DEFAULT 0 NOT NULL,
323 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
326 create table printers
328 name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
329 type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
330 hwtype VARCHAR(16) DEFAULT CHR(0) NOT NULL,
331 duplexname VARCHAR(16) DEFAULT CHR(0) NOT NULL,
332 mach_id INTEGER DEFAULT 0 NOT NULL,
333 loghost INTEGER DEFAULT 0 NOT NULL,
334 rm INTEGER DEFAULT 0 NOT NULL,
335 rp VARCHAR(16) DEFAULT CHR(0) NOT NULL,
336 rq INTEGER DEFAULT 0 NOT NULL,
337 ka SMALLINT DEFAULT 0 NOT NULL,
338 pc SMALLINT DEFAULT 0 NOT NULL,
339 mc SMALLINT DEFAULT 0 NOT NULL,
340 ac INTEGER DEFAULT 0 NOT NULL,
341 lpc_acl INTEGER DEFAULT 0 NOT NULL,
342 banner INTEGER DEFAULT 0 NOT NULL,
343 location VARCHAR(64) DEFAULT CHR(0) NOT NULL,
344 contact VARCHAR(64) DEFAULT CHR(0) NOT NULL,
345 modtime DATE DEFAULT SYSDATE NOT NULL,
346 modby INTEGER DEFAULT 0 NOT NULL,
347 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
350 create table printservers
352 mach_id INTEGER DEFAULT 0 NOT NULL,
353 kind VARCHAR(8) DEFAULT CHR(0) NOT NULL,
354 printer_types INTEGER DEFAULT 0 NOT NULL,
355 owner_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
356 owner_id INTEGER DEFAULT 0 NOT NULL,
357 lpc_acl INTEGER DEFAULT 0 NOT NULL,
358 modtime DATE DEFAULT SYSDATE NOT NULL,
359 modby INTEGER DEFAULT 0 NOT NULL,
360 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
365 capability VARCHAR(32) DEFAULT CHR(0) NOT NULL,
366 tag VARCHAR(4) DEFAULT CHR(0) NOT NULL,
367 list_id INTEGER DEFAULT 0 NOT NULL
372 name VARCHAR(32) DEFAULT CHR(0) NOT NULL,
373 type VARCHAR(16) DEFAULT CHR(0) NOT NULL,
374 trans VARCHAR(128) DEFAULT CHR(0) NOT NULL
377 create table numvalues
379 name VARCHAR(32) DEFAULT CHR(0) NOT NULL,
380 value INTEGER DEFAULT 0 NOT NULL
383 create table tblstats
385 table_name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
386 modtime DATE DEFAULT SYSDATE NOT NULL,
387 appends INTEGER DEFAULT 0 NOT NULL,
388 updates INTEGER DEFAULT 0 NOT NULL,
389 deletes INTEGER DEFAULT 0 NOT NULL
392 create table incremental
394 table_name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
395 service VARCHAR(16) DEFAULT CHR(0) NOT NULL
398 create table containers
400 name VARCHAR(64) DEFAULT CHR(0) NOT NULL,
401 cnt_id INTEGER DEFAULT 0 NOT NULL,
402 list_id INTEGER DEFAULT 0 NOT NULL,
403 publicflg INTEGER DEFAULT 0 NOT NULL,
404 description VARCHAR(255) DEFAULT CHR(0) NOT NULL,
405 location VARCHAR(64) DEFAULT CHR(0) NOT NULL,
406 contact VARCHAR(32) DEFAULT CHR(0) NOT NULL,
407 acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
408 acl_id INTEGER DEFAULT 0 NOT NULL,
409 memacl_type VARCHAR(8) DEFAULT 'NONE' NOT NULL,
410 memacl_id INTEGER DEFAULT 0 NOT NULL,
411 modtime DATE DEFAULT SYSDATE NOT NULL,
412 modby INTEGER DEFAULT 0 NOT NULL,
413 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
418 mach_id INTEGER DEFAULT 0 NOT NULL,
419 cnt_id INTEGER DEFAULT 0 NOT NULL
422 create table accountnumbers
424 account_number VARCHAR(10) DEFAULT CHR(0) NOT NULL
427 create table userhistory
429 login VARCHAR(8) DEFAULT CHR(0) NOT NULL,
430 users_id INTEGER DEFAULT 0 NOT NULL,
431 unix_uid SMALLINT DEFAULT 0 NOT NULL,
432 shell VARCHAR(32) DEFAULT CHR(0) NOT NULL,
433 winconsoleshell VARCHAR(32) DEFAULT 'cmd' NOT NULL,
434 last VARCHAR(30) DEFAULT CHR(0) NOT NULL,
435 first VARCHAR(30) DEFAULT CHR(0) NOT NULL,
436 middle VARCHAR(30) DEFAULT CHR(0) NOT NULL,
437 status SMALLINT DEFAULT 0 NOT NULL,
438 clearid VARCHAR(16) DEFAULT CHR(0) NOT NULL,
439 type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
440 comments INTEGER DEFAULT 0 NOT NULL,
441 modtime DATE DEFAULT SYSDATE NOT NULL,
442 modby INTEGER DEFAULT 0 NOT NULL,
443 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL,
444 fullname VARCHAR(92) DEFAULT CHR(0) NOT NULL,
445 nickname VARCHAR(16) DEFAULT CHR(0) NOT NULL,
446 home_addr VARCHAR(82) DEFAULT CHR(0) NOT NULL,
447 home_phone VARCHAR(24) DEFAULT CHR(0) NOT NULL,
448 office_addr VARCHAR(16) DEFAULT CHR(0) NOT NULL,
449 office_phone VARCHAR(24) DEFAULT CHR(0) NOT NULL,
450 department VARCHAR(50) DEFAULT CHR(0) NOT NULL,
451 affiliation VARCHAR(50) DEFAULT CHR(0) NOT NULL,
452 fmodtime DATE DEFAULT SYSDATE NOT NULL,
453 fmodby INTEGER DEFAULT 0 NOT NULL,
454 fmodwith VARCHAR(8) DEFAULT CHR(0) NOT NULL,
455 potype VARCHAR(8) DEFAULT CHR(0) NOT NULL,
456 pop_id INTEGER DEFAULT 0 NOT NULL,
457 imap_id INTEGER DEFAULT 0 NOT NULL,
458 box_id INTEGER DEFAULT 0 NOT NULL,
459 pmodtime DATE DEFAULT SYSDATE NOT NULL,
460 pmodby INTEGER DEFAULT 0 NOT NULL,
461 pmodwith VARCHAR(8) DEFAULT CHR(0) NOT NULL,
462 xname VARCHAR(30) DEFAULT CHR(0) NOT NULL,
463 xdept VARCHAR(50) DEFAULT CHR(0) NOT NULL,
464 xtitle VARCHAR(50) DEFAULT CHR(0) NOT NULL,
465 xaddress VARCHAR(82) DEFAULT CHR(0) NOT NULL,
466 xphone1 VARCHAR(24) DEFAULT CHR(0) NOT NULL,
467 xphone2 VARCHAR(24) DEFAULT CHR(0) NOT NULL,
468 xmodtime DATE DEFAULT SYSDATE NOT NULL,
469 sigdate INTEGER DEFAULT 0 NOT NULL,
470 sigwho INTEGER DEFAULT 0 NOT NULL,
471 signature VARCHAR(68) DEFAULT CHR(0) NOT NULL,
472 secure INTEGER DEFAULT 0 NOT NULL,
473 pin VARCHAR(10) DEFAULT CHR(0) NOT NULL,
474 reservations VARCHAR(10) DEFAULT CHR(0) NOT NULL,
475 flag INTEGER DEFAULT 0 NOT NULL,
476 created DATE DEFAULT SYSDATE NOT NULL,
477 creator INTEGER DEFAULT 0 NOT NULL,
478 winhomedir VARCHAR(260) DEFAULT '[DFS]' NOT NULL,
479 winprofiledir VARCHAR(260) DEFAULT '[DFS]' NOT NULL,
480 purged DATE DEFAULT SYSDATE NOT NULL