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