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 modtime DATE DEFAULT SYSDATE NOT NULL,
146 modby INTEGER DEFAULT 0 NOT NULL,
147 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
150 create table imembers
152 list_id INTEGER DEFAULT 0 NOT NULL,
153 member_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
154 member_id INTEGER DEFAULT 0 NOT NULL,
155 tag INTEGER DEFAULT 0 NOT NULL,
156 ref_count SMALLINT DEFAULT 0 NOT NULL,
157 direct SMALLINT DEFAULT 0 NOT NULL
162 name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
163 update_int INTEGER DEFAULT 0 NOT NULL,
164 target_file VARCHAR(64) DEFAULT CHR(0) NOT NULL,
165 script VARCHAR(128) DEFAULT CHR(0) NOT NULL,
166 dfgen INTEGER DEFAULT 0 NOT NULL,
167 dfcheck INTEGER DEFAULT 0 NOT NULL,
168 type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
169 enable INTEGER DEFAULT 0 NOT NULL,
170 inprogress INTEGER DEFAULT 0 NOT NULL,
171 harderror INTEGER DEFAULT 0 NOT NULL,
172 errmsg VARCHAR(80) DEFAULT CHR(0) NOT NULL,
173 acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
174 acl_id INTEGER DEFAULT 0 NOT NULL,
175 modtime DATE DEFAULT SYSDATE NOT NULL,
176 modby INTEGER DEFAULT 0 NOT NULL,
177 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
180 create table serverhosts
182 service VARCHAR(16) DEFAULT CHR(0) NOT NULL,
183 mach_id INTEGER DEFAULT 0 NOT NULL,
184 success INTEGER DEFAULT 0 NOT NULL,
185 enable INTEGER DEFAULT 0 NOT NULL,
186 override INTEGER DEFAULT 0 NOT NULL,
187 inprogress INTEGER DEFAULT 0 NOT NULL,
188 hosterror INTEGER DEFAULT 0 NOT NULL,
189 hosterrmsg VARCHAR(80) DEFAULT CHR(0) NOT NULL,
190 ltt INTEGER DEFAULT 0 NOT NULL,
191 lts INTEGER DEFAULT 0 NOT NULL,
192 value1 INTEGER DEFAULT 0 NOT NULL,
193 value2 INTEGER DEFAULT 0 NOT NULL,
194 value3 VARCHAR(32) DEFAULT CHR(0) NOT NULL,
195 modtime DATE DEFAULT SYSDATE NOT NULL,
196 modby INTEGER DEFAULT 0 NOT NULL,
197 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
202 filsys_id INTEGER DEFAULT 0 NOT NULL,
203 phys_id INTEGER DEFAULT 0 NOT NULL,
204 label VARCHAR(32) DEFAULT CHR(0) NOT NULL,
205 fs_order INTEGER DEFAULT 0 NOT NULL,
206 type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
207 mach_id INTEGER DEFAULT 0 NOT NULL,
208 name VARCHAR(80) DEFAULT CHR(0) NOT NULL,
209 mount VARCHAR(32) DEFAULT CHR(0) NOT NULL,
210 rwaccess CHAR(1) DEFAULT CHR(0) NOT NULL,
211 comments VARCHAR(64) DEFAULT CHR(0) NOT NULL,
212 owner INTEGER DEFAULT 0 NOT NULL,
213 owners INTEGER DEFAULT 0 NOT NULL,
214 createflg INTEGER DEFAULT 0 NOT NULL,
215 lockertype VARCHAR(8) DEFAULT CHR(0) NOT NULL,
216 modtime DATE DEFAULT SYSDATE NOT NULL,
217 modby INTEGER DEFAULT 0 NOT NULL,
218 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
223 group_id INTEGER DEFAULT 0 NOT NULL,
224 filsys_id INTEGER DEFAULT 0 NOT NULL,
225 key VARCHAR(8) DEFAULT CHR(0) NOT NULL
230 nfsphys_id INTEGER DEFAULT 0 NOT NULL,
231 mach_id INTEGER DEFAULT 0 NOT NULL,
232 device VARCHAR(32) DEFAULT CHR(0) NOT NULL,
233 dir VARCHAR(64) DEFAULT CHR(0) NOT NULL,
234 status SMALLINT DEFAULT 0 NOT NULL,
235 allocated INTEGER DEFAULT 0 NOT NULL,
236 partsize INTEGER DEFAULT 0 NOT NULL,
237 modtime DATE DEFAULT SYSDATE NOT NULL,
238 modby INTEGER DEFAULT 0 NOT NULL,
239 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
244 filsys_id INTEGER DEFAULT 0 NOT NULL,
245 type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
246 entity_id INTEGER DEFAULT 0 NOT NULL,
247 phys_id INTEGER DEFAULT 0 NOT NULL,
248 quota 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 class VARCHAR(16) DEFAULT CHR(0) NOT NULL,
257 xmt_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
258 xmt_id INTEGER DEFAULT 0 NOT NULL,
259 sub_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
260 sub_id INTEGER DEFAULT 0 NOT NULL,
261 iws_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
262 iws_id INTEGER DEFAULT 0 NOT NULL,
263 iui_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
264 iui_id 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
270 create table hostaccess
272 mach_id INTEGER DEFAULT 0 NOT NULL,
273 acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
274 acl_id INTEGER DEFAULT 0 NOT NULL,
275 modtime DATE DEFAULT SYSDATE NOT NULL,
276 modby INTEGER DEFAULT 0 NOT NULL,
277 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
282 mach_id INTEGER DEFAULT 0 NOT NULL,
283 target VARCHAR(128) DEFAULT CHR(0) NOT NULL,
284 kind VARCHAR(16) DEFAULT CHR(0) NOT NULL,
285 list_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 string_id INTEGER DEFAULT 0 NOT NULL,
294 string VARCHAR(128) DEFAULT CHR(0) NOT NULL
297 create table services
299 name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
300 protocol VARCHAR(8) DEFAULT CHR(0) NOT NULL,
301 port SMALLINT DEFAULT 0 NOT NULL,
302 description VARCHAR(64) DEFAULT CHR(0) NOT NULL,
303 modtime DATE DEFAULT SYSDATE NOT NULL,
304 modby INTEGER DEFAULT 0 NOT NULL,
305 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
308 create table printers
310 name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
311 type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
312 hwtype VARCHAR(16) DEFAULT CHR(0) NOT NULL,
313 duplexname VARCHAR(16) DEFAULT CHR(0) NOT NULL,
314 mach_id INTEGER DEFAULT 0 NOT NULL,
315 loghost INTEGER DEFAULT 0 NOT NULL,
316 rm INTEGER DEFAULT 0 NOT NULL,
317 rp VARCHAR(16) DEFAULT CHR(0) NOT NULL,
318 rq INTEGER DEFAULT 0 NOT NULL,
319 ka SMALLINT DEFAULT 0 NOT NULL,
320 pc SMALLINT DEFAULT 0 NOT NULL,
321 mc SMALLINT DEFAULT 0 NOT NULL,
322 ac INTEGER DEFAULT 0 NOT NULL,
323 lpc_acl INTEGER DEFAULT 0 NOT NULL,
324 banner INTEGER DEFAULT 0 NOT NULL,
325 location VARCHAR(64) DEFAULT CHR(0) NOT NULL,
326 contact VARCHAR(64) DEFAULT CHR(0) NOT NULL,
327 modtime DATE DEFAULT SYSDATE NOT NULL,
328 modby INTEGER DEFAULT 0 NOT NULL,
329 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
332 create table printservers
334 mach_id INTEGER DEFAULT 0 NOT NULL,
335 kind VARCHAR(8) DEFAULT CHR(0) NOT NULL,
336 printer_types INTEGER DEFAULT 0 NOT NULL,
337 owner_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
338 owner_id INTEGER DEFAULT 0 NOT NULL,
339 lpc_acl INTEGER DEFAULT 0 NOT NULL,
340 modtime DATE DEFAULT SYSDATE NOT NULL,
341 modby INTEGER DEFAULT 0 NOT NULL,
342 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
347 capability VARCHAR(32) DEFAULT CHR(0) NOT NULL,
348 tag VARCHAR(4) DEFAULT CHR(0) NOT NULL,
349 list_id INTEGER DEFAULT 0 NOT NULL
354 name VARCHAR(32) DEFAULT CHR(0) NOT NULL,
355 type VARCHAR(16) DEFAULT CHR(0) NOT NULL,
356 trans VARCHAR(128) DEFAULT CHR(0) NOT NULL
359 create table numvalues
361 name VARCHAR(32) DEFAULT CHR(0) NOT NULL,
362 value INTEGER DEFAULT 0 NOT NULL
365 create table tblstats
367 table_name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
368 modtime DATE DEFAULT SYSDATE NOT NULL,
369 appends INTEGER DEFAULT 0 NOT NULL,
370 updates INTEGER DEFAULT 0 NOT NULL,
371 deletes INTEGER DEFAULT 0 NOT NULL
374 create table incremental
376 table_name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
377 service VARCHAR(16) DEFAULT CHR(0) NOT NULL