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 CHR(0) 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 modtime DATE DEFAULT SYSDATE NOT NULL,
268 modby INTEGER DEFAULT 0 NOT NULL,
269 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
272 create table hostaccess
274 mach_id INTEGER DEFAULT 0 NOT NULL,
275 acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
276 acl_id INTEGER DEFAULT 0 NOT NULL,
277 modtime DATE DEFAULT SYSDATE NOT NULL,
278 modby INTEGER DEFAULT 0 NOT NULL,
279 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
284 mach_id INTEGER DEFAULT 0 NOT NULL,
285 target VARCHAR(128) DEFAULT CHR(0) NOT NULL,
286 kind VARCHAR(16) DEFAULT CHR(0) NOT NULL,
287 list_id INTEGER DEFAULT 0 NOT NULL,
288 modtime DATE DEFAULT SYSDATE NOT NULL,
289 modby INTEGER DEFAULT 0 NOT NULL,
290 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
295 string_id INTEGER DEFAULT 0 NOT NULL,
296 string VARCHAR(128) DEFAULT CHR(0) NOT NULL
299 create table services
301 name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
302 protocol VARCHAR(8) DEFAULT CHR(0) NOT NULL,
303 port SMALLINT DEFAULT 0 NOT NULL,
304 description VARCHAR(64) DEFAULT CHR(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
310 create table printers
312 name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
313 type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
314 hwtype VARCHAR(16) DEFAULT CHR(0) NOT NULL,
315 duplexname VARCHAR(16) DEFAULT CHR(0) NOT NULL,
316 mach_id INTEGER DEFAULT 0 NOT NULL,
317 loghost INTEGER DEFAULT 0 NOT NULL,
318 rm INTEGER DEFAULT 0 NOT NULL,
319 rp VARCHAR(16) DEFAULT CHR(0) NOT NULL,
320 rq INTEGER DEFAULT 0 NOT NULL,
321 ka SMALLINT DEFAULT 0 NOT NULL,
322 pc SMALLINT DEFAULT 0 NOT NULL,
323 mc SMALLINT DEFAULT 0 NOT NULL,
324 ac INTEGER DEFAULT 0 NOT NULL,
325 lpc_acl INTEGER DEFAULT 0 NOT NULL,
326 banner INTEGER DEFAULT 0 NOT NULL,
327 location VARCHAR(64) DEFAULT CHR(0) NOT NULL,
328 contact VARCHAR(64) DEFAULT CHR(0) NOT NULL,
329 modtime DATE DEFAULT SYSDATE NOT NULL,
330 modby INTEGER DEFAULT 0 NOT NULL,
331 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
334 create table printservers
336 mach_id INTEGER DEFAULT 0 NOT NULL,
337 kind VARCHAR(8) DEFAULT CHR(0) NOT NULL,
338 printer_types INTEGER DEFAULT 0 NOT NULL,
339 owner_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
340 owner_id INTEGER DEFAULT 0 NOT NULL,
341 lpc_acl INTEGER DEFAULT 0 NOT NULL,
342 modtime DATE DEFAULT SYSDATE NOT NULL,
343 modby INTEGER DEFAULT 0 NOT NULL,
344 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
349 capability VARCHAR(32) DEFAULT CHR(0) NOT NULL,
350 tag VARCHAR(4) DEFAULT CHR(0) NOT NULL,
351 list_id INTEGER DEFAULT 0 NOT NULL
356 name VARCHAR(32) DEFAULT CHR(0) NOT NULL,
357 type VARCHAR(16) DEFAULT CHR(0) NOT NULL,
358 trans VARCHAR(128) DEFAULT CHR(0) NOT NULL
361 create table numvalues
363 name VARCHAR(32) DEFAULT CHR(0) NOT NULL,
364 value INTEGER DEFAULT 0 NOT NULL
367 create table tblstats
369 table_name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
370 modtime DATE DEFAULT SYSDATE NOT NULL,
371 appends INTEGER DEFAULT 0 NOT NULL,
372 updates INTEGER DEFAULT 0 NOT NULL,
373 deletes INTEGER DEFAULT 0 NOT NULL
376 create table incremental
378 table_name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
379 service VARCHAR(16) DEFAULT CHR(0) NOT NULL