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 CHR(0) 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(16) DEFAULT CHR(0) NOT NULL,
22 office_addr VARCHAR(16) DEFAULT CHR(0) NOT NULL,
23 office_phone VARCHAR(12) 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(12) DEFAULT CHR(0) NOT NULL,
41 xphone2 VARCHAR(12) 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
53 users_id INTEGER DEFAULT 0 NOT NULL,
54 string_id INTEGER DEFAULT 0 NOT NULL
59 name VARCHAR(255) DEFAULT CHR(0) NOT NULL,
60 mach_id INTEGER DEFAULT 0 NOT NULL,
61 vendor VARCHAR(16) DEFAULT CHR(0) NOT NULL,
62 model VARCHAR(24) DEFAULT CHR(0) NOT NULL,
63 os VARCHAR(16) DEFAULT CHR(0) NOT NULL,
64 location VARCHAR(16) DEFAULT CHR(0) NOT NULL,
65 contact VARCHAR(32) DEFAULT CHR(0) NOT NULL,
66 use INTEGER DEFAULT 0 NOT NULL,
67 status INTEGER DEFAULT 0 NOT NULL,
68 statuschange DATE DEFAULT SYSDATE NOT NULL,
69 snet_id INTEGER DEFAULT 0 NOT NULL,
70 address VARCHAR(16) DEFAULT CHR(0) NOT NULL,
71 hwaddr VARCHAR(12) DEFAULT CHR(0) NOT NULL,
72 owner_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
73 owner_id INTEGER DEFAULT 0 NOT NULL,
74 acomment INTEGER DEFAULT 0 NOT NULL,
75 ocomment INTEGER DEFAULT 0 NOT NULL,
76 created DATE DEFAULT SYSDATE NOT NULL,
77 creator INTEGER DEFAULT 0 NOT NULL,
78 inuse DATE DEFAULT SYSDATE NOT NULL,
79 modtime DATE DEFAULT SYSDATE NOT NULL,
80 modby INTEGER DEFAULT 0 NOT NULL,
81 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
84 create table hostalias
86 name VARCHAR(255) DEFAULT CHR(0) NOT NULL,
87 mach_id INTEGER DEFAULT 0 NOT NULL
92 name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
93 snet_id INTEGER DEFAULT 0 NOT NULL,
94 description VARCHAR(48) DEFAULT CHR(0) NOT NULL,
95 saddr INTEGER DEFAULT 0 NOT NULL,
96 mask INTEGER DEFAULT 0 NOT NULL,
97 low INTEGER DEFAULT 0 NOT NULL,
98 high INTEGER DEFAULT 0 NOT NULL,
99 prefix VARCHAR(8) DEFAULT CHR(0) NOT NULL,
100 owner_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
101 owner_id INTEGER DEFAULT 0 NOT NULL,
102 modtime DATE DEFAULT SYSDATE NOT NULL,
103 modby INTEGER DEFAULT 0 NOT NULL,
104 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
107 create table clusters
109 name VARCHAR(32) DEFAULT CHR(0) NOT NULL,
110 clu_id INTEGER DEFAULT 0 NOT NULL,
111 description VARCHAR(32) DEFAULT CHR(0) NOT NULL,
112 location VARCHAR(64) DEFAULT CHR(0) NOT NULL,
113 modtime DATE DEFAULT SYSDATE NOT NULL,
114 modby INTEGER DEFAULT 0 NOT NULL,
115 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
120 mach_id INTEGER DEFAULT 0 NOT NULL,
121 clu_id INTEGER DEFAULT 0 NOT NULL
126 clu_id INTEGER DEFAULT 0 NOT NULL,
127 serv_label VARCHAR(16) DEFAULT CHR(0) NOT NULL,
128 serv_cluster VARCHAR(128) DEFAULT CHR(0) NOT NULL
133 name VARCHAR(32) DEFAULT CHR(0) NOT NULL,
134 list_id INTEGER DEFAULT 0 NOT NULL,
135 active INTEGER DEFAULT 0 NOT NULL,
136 publicflg INTEGER DEFAULT 0 NOT NULL,
137 hidden INTEGER DEFAULT 0 NOT NULL,
138 maillist INTEGER DEFAULT 0 NOT NULL,
139 grouplist INTEGER DEFAULT 0 NOT NULL,
140 gid SMALLINT DEFAULT 0 NOT NULL,
141 nfsgroup INTEGER DEFAULT 0 NOT NULL,
142 description VARCHAR(255) DEFAULT CHR(0) NOT NULL,
143 acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
144 acl_id INTEGER DEFAULT 0 NOT NULL,
145 memacl_type VARCHAR(8) DEFAULT 'NONE' NOT NULL,
146 memacl_id INTEGER DEFAULT 0 NOT NULL,
147 modtime DATE DEFAULT SYSDATE NOT NULL,
148 modby INTEGER DEFAULT 0 NOT NULL,
149 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
152 create table imembers
154 list_id INTEGER DEFAULT 0 NOT NULL,
155 member_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
156 member_id INTEGER DEFAULT 0 NOT NULL,
157 tag INTEGER DEFAULT 0 NOT NULL,
158 ref_count SMALLINT DEFAULT 0 NOT NULL,
159 direct SMALLINT DEFAULT 0 NOT NULL
164 name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
165 update_int INTEGER DEFAULT 0 NOT NULL,
166 target_file VARCHAR(64) DEFAULT CHR(0) NOT NULL,
167 script VARCHAR(128) DEFAULT CHR(0) NOT NULL,
168 dfgen INTEGER DEFAULT 0 NOT NULL,
169 dfcheck INTEGER DEFAULT 0 NOT NULL,
170 type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
171 enable INTEGER DEFAULT 0 NOT NULL,
172 inprogress INTEGER DEFAULT 0 NOT NULL,
173 harderror INTEGER DEFAULT 0 NOT NULL,
174 errmsg VARCHAR(80) DEFAULT CHR(0) NOT NULL,
175 acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
176 acl_id INTEGER DEFAULT 0 NOT NULL,
177 modtime DATE DEFAULT SYSDATE NOT NULL,
178 modby INTEGER DEFAULT 0 NOT NULL,
179 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
182 create table serverhosts
184 service VARCHAR(16) DEFAULT CHR(0) NOT NULL,
185 mach_id INTEGER DEFAULT 0 NOT NULL,
186 success INTEGER DEFAULT 0 NOT NULL,
187 enable INTEGER DEFAULT 0 NOT NULL,
188 override INTEGER DEFAULT 0 NOT NULL,
189 inprogress INTEGER DEFAULT 0 NOT NULL,
190 hosterror INTEGER DEFAULT 0 NOT NULL,
191 hosterrmsg VARCHAR(80) DEFAULT CHR(0) NOT NULL,
192 ltt INTEGER DEFAULT 0 NOT NULL,
193 lts INTEGER DEFAULT 0 NOT NULL,
194 value1 INTEGER DEFAULT 0 NOT NULL,
195 value2 INTEGER DEFAULT 0 NOT NULL,
196 value3 VARCHAR(32) DEFAULT CHR(0) NOT NULL,
197 modtime DATE DEFAULT SYSDATE NOT NULL,
198 modby INTEGER DEFAULT 0 NOT NULL,
199 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
204 filsys_id INTEGER DEFAULT 0 NOT NULL,
205 phys_id INTEGER DEFAULT 0 NOT NULL,
206 label VARCHAR(32) DEFAULT CHR(0) NOT NULL,
207 fs_order INTEGER DEFAULT 0 NOT NULL,
208 type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
209 mach_id INTEGER DEFAULT 0 NOT NULL,
210 name VARCHAR(80) DEFAULT CHR(0) NOT NULL,
211 mount VARCHAR(32) DEFAULT CHR(0) NOT NULL,
212 rwaccess CHAR(1) DEFAULT CHR(0) NOT NULL,
213 comments VARCHAR(64) DEFAULT CHR(0) NOT NULL,
214 owner INTEGER DEFAULT 0 NOT NULL,
215 owners INTEGER DEFAULT 0 NOT NULL,
216 createflg INTEGER DEFAULT 0 NOT NULL,
217 lockertype VARCHAR(8) DEFAULT CHR(0) NOT NULL,
218 modtime DATE DEFAULT SYSDATE NOT NULL,
219 modby INTEGER DEFAULT 0 NOT NULL,
220 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
225 group_id INTEGER DEFAULT 0 NOT NULL,
226 filsys_id INTEGER DEFAULT 0 NOT NULL,
227 key VARCHAR(8) DEFAULT CHR(0) NOT NULL
232 nfsphys_id INTEGER DEFAULT 0 NOT NULL,
233 mach_id INTEGER DEFAULT 0 NOT NULL,
234 device VARCHAR(32) DEFAULT CHR(0) NOT NULL,
235 dir VARCHAR(64) DEFAULT CHR(0) NOT NULL,
236 status SMALLINT DEFAULT 0 NOT NULL,
237 allocated INTEGER DEFAULT 0 NOT NULL,
238 partsize INTEGER DEFAULT 0 NOT NULL,
239 modtime DATE DEFAULT SYSDATE NOT NULL,
240 modby INTEGER DEFAULT 0 NOT NULL,
241 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
246 filsys_id INTEGER DEFAULT 0 NOT NULL,
247 type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
248 entity_id INTEGER DEFAULT 0 NOT NULL,
249 phys_id INTEGER DEFAULT 0 NOT NULL,
250 quota 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 class VARCHAR(16) DEFAULT CHR(0) NOT NULL,
259 xmt_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
260 xmt_id INTEGER DEFAULT 0 NOT NULL,
261 sub_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
262 sub_id INTEGER DEFAULT 0 NOT NULL,
263 iws_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
264 iws_id INTEGER DEFAULT 0 NOT NULL,
265 iui_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
266 iui_id INTEGER DEFAULT 0 NOT NULL,
267 owner_type VARCHAR(8) DEFAULT 'NONE' NOT NULL,
268 owner_id INTEGER DEFAULT 0 NOT NULL,
269 modtime DATE DEFAULT SYSDATE NOT NULL,
270 modby INTEGER DEFAULT 0 NOT NULL,
271 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
274 create table hostaccess
276 mach_id INTEGER DEFAULT 0 NOT NULL,
277 acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
278 acl_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
286 mach_id INTEGER DEFAULT 0 NOT NULL,
287 target VARCHAR(128) DEFAULT CHR(0) NOT NULL,
288 kind VARCHAR(16) DEFAULT CHR(0) NOT NULL,
289 list_id INTEGER DEFAULT 0 NOT NULL,
290 modtime DATE DEFAULT SYSDATE NOT NULL,
291 modby INTEGER DEFAULT 0 NOT NULL,
292 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
297 string_id INTEGER DEFAULT 0 NOT NULL,
298 string VARCHAR(128) DEFAULT CHR(0) NOT NULL
301 create table services
303 name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
304 protocol VARCHAR(8) DEFAULT CHR(0) NOT NULL,
305 port SMALLINT DEFAULT 0 NOT NULL,
306 description VARCHAR(64) DEFAULT CHR(0) NOT NULL,
307 modtime DATE DEFAULT SYSDATE NOT NULL,
308 modby INTEGER DEFAULT 0 NOT NULL,
309 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
312 create table printers
314 name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
315 type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
316 hwtype VARCHAR(16) DEFAULT CHR(0) NOT NULL,
317 duplexname VARCHAR(16) DEFAULT CHR(0) NOT NULL,
318 mach_id INTEGER DEFAULT 0 NOT NULL,
319 loghost INTEGER DEFAULT 0 NOT NULL,
320 rm INTEGER DEFAULT 0 NOT NULL,
321 rp VARCHAR(16) DEFAULT CHR(0) NOT NULL,
322 rq INTEGER DEFAULT 0 NOT NULL,
323 ka SMALLINT DEFAULT 0 NOT NULL,
324 pc SMALLINT DEFAULT 0 NOT NULL,
325 mc SMALLINT DEFAULT 0 NOT NULL,
326 ac INTEGER DEFAULT 0 NOT NULL,
327 lpc_acl INTEGER DEFAULT 0 NOT NULL,
328 banner INTEGER DEFAULT 0 NOT NULL,
329 location VARCHAR(64) DEFAULT CHR(0) NOT NULL,
330 contact VARCHAR(64) DEFAULT CHR(0) NOT NULL,
331 modtime DATE DEFAULT SYSDATE NOT NULL,
332 modby INTEGER DEFAULT 0 NOT NULL,
333 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
336 create table printservers
338 mach_id INTEGER DEFAULT 0 NOT NULL,
339 kind VARCHAR(8) DEFAULT CHR(0) NOT NULL,
340 printer_types INTEGER DEFAULT 0 NOT NULL,
341 owner_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
342 owner_id INTEGER DEFAULT 0 NOT NULL,
343 lpc_acl INTEGER DEFAULT 0 NOT NULL,
344 modtime DATE DEFAULT SYSDATE NOT NULL,
345 modby INTEGER DEFAULT 0 NOT NULL,
346 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
351 capability VARCHAR(32) DEFAULT CHR(0) NOT NULL,
352 tag VARCHAR(4) DEFAULT CHR(0) NOT NULL,
353 list_id INTEGER DEFAULT 0 NOT NULL
358 name VARCHAR(32) DEFAULT CHR(0) NOT NULL,
359 type VARCHAR(16) DEFAULT CHR(0) NOT NULL,
360 trans VARCHAR(128) DEFAULT CHR(0) NOT NULL
363 create table numvalues
365 name VARCHAR(32) DEFAULT CHR(0) NOT NULL,
366 value INTEGER DEFAULT 0 NOT NULL
369 create table tblstats
371 table_name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
372 modtime DATE DEFAULT SYSDATE NOT NULL,
373 appends INTEGER DEFAULT 0 NOT NULL,
374 updates INTEGER DEFAULT 0 NOT NULL,
375 deletes INTEGER DEFAULT 0 NOT NULL
378 create table incremental
380 table_name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
381 service VARCHAR(16) DEFAULT CHR(0) NOT NULL