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 last VARCHAR(16) DEFAULT CHR(0) NOT NULL,
8 first VARCHAR(16) DEFAULT CHR(0) NOT NULL,
9 middle VARCHAR(16) DEFAULT CHR(0) NOT NULL,
10 status SMALLINT DEFAULT 0 NOT NULL,
11 clearid VARCHAR(16) DEFAULT CHR(0) NOT NULL,
12 type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
13 comments INTEGER DEFAULT 0 NOT NULL,
14 modtime DATE DEFAULT SYSDATE NOT NULL,
15 modby INTEGER DEFAULT 0 NOT NULL,
16 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL,
17 fullname VARCHAR(32) DEFAULT CHR(0) NOT NULL,
18 nickname VARCHAR(16) DEFAULT CHR(0) NOT NULL,
19 home_addr VARCHAR(82) DEFAULT CHR(0) NOT NULL,
20 home_phone VARCHAR(16) DEFAULT CHR(0) NOT NULL,
21 office_addr VARCHAR(16) DEFAULT CHR(0) NOT NULL,
22 office_phone VARCHAR(12) DEFAULT CHR(0) NOT NULL,
23 department VARCHAR(50) DEFAULT CHR(0) NOT NULL,
24 affiliation VARCHAR(50) DEFAULT CHR(0) NOT NULL,
25 fmodtime DATE DEFAULT SYSDATE NOT NULL,
26 fmodby INTEGER DEFAULT 0 NOT NULL,
27 fmodwith VARCHAR(8) DEFAULT CHR(0) NOT NULL,
28 potype VARCHAR(8) DEFAULT CHR(0) NOT NULL,
29 pop_id INTEGER DEFAULT 0 NOT NULL,
30 box_id INTEGER DEFAULT 0 NOT NULL,
31 pmodtime DATE DEFAULT SYSDATE NOT NULL,
32 pmodby INTEGER DEFAULT 0 NOT NULL,
33 pmodwith VARCHAR(8) DEFAULT CHR(0) NOT NULL,
34 xname VARCHAR(30) DEFAULT CHR(0) NOT NULL,
35 xdept VARCHAR(50) DEFAULT CHR(0) NOT NULL,
36 xtitle VARCHAR(50) DEFAULT CHR(0) NOT NULL,
37 xaddress VARCHAR(82) DEFAULT CHR(0) NOT NULL,
38 xphone1 VARCHAR(12) DEFAULT CHR(0) NOT NULL,
39 xphone2 VARCHAR(12) DEFAULT CHR(0) NOT NULL,
40 xmodtime DATE DEFAULT SYSDATE NOT NULL,
41 sigdate INTEGER DEFAULT 0 NOT NULL,
42 sigwho INTEGER DEFAULT 0 NOT NULL,
43 signature VARCHAR(68) DEFAULT CHR(0) NOT NULL,
44 secure INTEGER DEFAULT 0 NOT NULL,
45 flag INTEGER DEFAULT 0 NOT NULL
50 users_id INTEGER DEFAULT 0 NOT NULL,
51 string_id INTEGER DEFAULT 0 NOT NULL
56 name VARCHAR(255) DEFAULT CHR(0) NOT NULL,
57 mach_id INTEGER DEFAULT 0 NOT NULL,
58 vendor VARCHAR(16) DEFAULT CHR(0) NOT NULL,
59 model VARCHAR(24) DEFAULT CHR(0) NOT NULL,
60 os VARCHAR(16) DEFAULT CHR(0) NOT NULL,
61 location VARCHAR(16) DEFAULT CHR(0) NOT NULL,
62 contact VARCHAR(32) DEFAULT CHR(0) NOT NULL,
63 use INTEGER DEFAULT 0 NOT NULL,
64 status INTEGER DEFAULT 0 NOT NULL,
65 statuschange DATE DEFAULT SYSDATE NOT NULL,
66 snet_id INTEGER DEFAULT 0 NOT NULL,
67 address VARCHAR(16) DEFAULT CHR(0) NOT NULL,
68 hwaddr VARCHAR(12) DEFAULT CHR(0) NOT NULL,
69 owner_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
70 owner_id INTEGER DEFAULT 0 NOT NULL,
71 acomment INTEGER DEFAULT 0 NOT NULL,
72 ocomment INTEGER DEFAULT 0 NOT NULL,
73 created DATE DEFAULT SYSDATE NOT NULL,
74 creator INTEGER DEFAULT 0 NOT NULL,
75 inuse DATE DEFAULT SYSDATE NOT NULL,
76 modtime DATE DEFAULT SYSDATE NOT NULL,
77 modby INTEGER DEFAULT 0 NOT NULL,
78 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
81 create table hostalias
83 name VARCHAR(255) DEFAULT CHR(0) NOT NULL,
84 mach_id INTEGER DEFAULT 0 NOT NULL
89 name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
90 snet_id INTEGER DEFAULT 0 NOT NULL,
91 description VARCHAR(48) DEFAULT CHR(0) NOT NULL,
92 saddr INTEGER DEFAULT 0 NOT NULL,
93 mask INTEGER DEFAULT 0 NOT NULL,
94 low INTEGER DEFAULT 0 NOT NULL,
95 high INTEGER DEFAULT 0 NOT NULL,
96 prefix VARCHAR(8) DEFAULT CHR(0) NOT NULL,
97 owner_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
98 owner_id INTEGER DEFAULT 0 NOT NULL,
99 modtime DATE DEFAULT SYSDATE NOT NULL,
100 modby INTEGER DEFAULT 0 NOT NULL,
101 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
104 create table clusters
106 name VARCHAR(32) DEFAULT CHR(0) NOT NULL,
107 clu_id INTEGER DEFAULT 0 NOT NULL,
108 description VARCHAR(32) DEFAULT CHR(0) NOT NULL,
109 location VARCHAR(64) DEFAULT CHR(0) NOT NULL,
110 modtime DATE DEFAULT SYSDATE NOT NULL,
111 modby INTEGER DEFAULT 0 NOT NULL,
112 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
117 mach_id INTEGER DEFAULT 0 NOT NULL,
118 clu_id INTEGER DEFAULT 0 NOT NULL
123 clu_id INTEGER DEFAULT 0 NOT NULL,
124 serv_label VARCHAR(16) DEFAULT CHR(0) NOT NULL,
125 serv_cluster VARCHAR(32) DEFAULT CHR(0) NOT NULL
130 name VARCHAR(32) DEFAULT CHR(0) NOT NULL,
131 list_id INTEGER DEFAULT 0 NOT NULL,
132 active INTEGER DEFAULT 0 NOT NULL,
133 publicflg INTEGER DEFAULT 0 NOT NULL,
134 hidden INTEGER DEFAULT 0 NOT NULL,
135 maillist INTEGER DEFAULT 0 NOT NULL,
136 grouplist INTEGER DEFAULT 0 NOT NULL,
137 gid SMALLINT DEFAULT 0 NOT NULL,
138 description VARCHAR(255) DEFAULT CHR(0) NOT NULL,
139 acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
140 acl_id INTEGER DEFAULT 0 NOT NULL,
141 modtime DATE DEFAULT SYSDATE NOT NULL,
142 modby INTEGER DEFAULT 0 NOT NULL,
143 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
146 create table imembers
148 list_id INTEGER DEFAULT 0 NOT NULL,
149 member_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
150 member_id INTEGER DEFAULT 0 NOT NULL,
151 tag INTEGER DEFAULT 0 NOT NULL,
152 ref_count SMALLINT DEFAULT 0 NOT NULL,
153 direct SMALLINT DEFAULT 0 NOT NULL
158 name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
159 update_int INTEGER DEFAULT 0 NOT NULL,
160 target_file VARCHAR(64) DEFAULT CHR(0) NOT NULL,
161 script VARCHAR(128) DEFAULT CHR(0) NOT NULL,
162 dfgen INTEGER DEFAULT 0 NOT NULL,
163 dfcheck INTEGER DEFAULT 0 NOT NULL,
164 type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
165 enable INTEGER DEFAULT 0 NOT NULL,
166 inprogress INTEGER DEFAULT 0 NOT NULL,
167 harderror INTEGER DEFAULT 0 NOT NULL,
168 errmsg VARCHAR(80) DEFAULT CHR(0) NOT NULL,
169 acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
170 acl_id INTEGER DEFAULT 0 NOT NULL,
171 modtime DATE DEFAULT SYSDATE NOT NULL,
172 modby INTEGER DEFAULT 0 NOT NULL,
173 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
176 create table serverhosts
178 service VARCHAR(16) DEFAULT CHR(0) NOT NULL,
179 mach_id INTEGER DEFAULT 0 NOT NULL,
180 success INTEGER DEFAULT 0 NOT NULL,
181 enable INTEGER DEFAULT 0 NOT NULL,
182 override INTEGER DEFAULT 0 NOT NULL,
183 inprogress INTEGER DEFAULT 0 NOT NULL,
184 hosterror INTEGER DEFAULT 0 NOT NULL,
185 hosterrmsg VARCHAR(80) DEFAULT CHR(0) NOT NULL,
186 ltt INTEGER DEFAULT 0 NOT NULL,
187 lts INTEGER DEFAULT 0 NOT NULL,
188 value1 INTEGER DEFAULT 0 NOT NULL,
189 value2 INTEGER DEFAULT 0 NOT NULL,
190 value3 VARCHAR(32) DEFAULT CHR(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
198 filsys_id INTEGER DEFAULT 0 NOT NULL,
199 phys_id INTEGER DEFAULT 0 NOT NULL,
200 label VARCHAR(32) DEFAULT CHR(0) NOT NULL,
201 fs_order INTEGER DEFAULT 0 NOT NULL,
202 type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
203 mach_id INTEGER DEFAULT 0 NOT NULL,
204 name VARCHAR(80) DEFAULT CHR(0) NOT NULL,
205 mount VARCHAR(32) DEFAULT CHR(0) NOT NULL,
206 rwaccess CHAR(1) DEFAULT CHR(0) NOT NULL,
207 comments VARCHAR(64) DEFAULT CHR(0) NOT NULL,
208 owner INTEGER DEFAULT 0 NOT NULL,
209 owners INTEGER DEFAULT 0 NOT NULL,
210 createflg INTEGER DEFAULT 0 NOT NULL,
211 lockertype VARCHAR(8) 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 group_id INTEGER DEFAULT 0 NOT NULL,
220 filsys_id INTEGER DEFAULT 0 NOT NULL,
221 key VARCHAR(8) DEFAULT CHR(0) NOT NULL
226 nfsphys_id INTEGER DEFAULT 0 NOT NULL,
227 mach_id INTEGER DEFAULT 0 NOT NULL,
228 device VARCHAR(16) DEFAULT CHR(0) NOT NULL,
229 dir VARCHAR(16) DEFAULT CHR(0) NOT NULL,
230 status SMALLINT DEFAULT 0 NOT NULL,
231 allocated INTEGER DEFAULT 0 NOT NULL,
232 partsize INTEGER DEFAULT 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 filsys_id INTEGER DEFAULT 0 NOT NULL,
241 type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
242 entity_id INTEGER DEFAULT 0 NOT NULL,
243 phys_id INTEGER DEFAULT 0 NOT NULL,
244 quota INTEGER DEFAULT 0 NOT NULL,
245 modtime DATE DEFAULT SYSDATE NOT NULL,
246 modby INTEGER DEFAULT 0 NOT NULL,
247 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
252 class VARCHAR(16) DEFAULT CHR(0) NOT NULL,
253 xmt_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
254 xmt_id INTEGER DEFAULT 0 NOT NULL,
255 sub_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
256 sub_id INTEGER DEFAULT 0 NOT NULL,
257 iws_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
258 iws_id INTEGER DEFAULT 0 NOT NULL,
259 iui_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
260 iui_id INTEGER DEFAULT 0 NOT NULL,
261 modtime DATE DEFAULT SYSDATE NOT NULL,
262 modby INTEGER DEFAULT 0 NOT NULL,
263 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
266 create table hostaccess
268 mach_id INTEGER DEFAULT 0 NOT NULL,
269 acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
270 acl_id INTEGER DEFAULT 0 NOT NULL,
271 modtime DATE DEFAULT SYSDATE NOT NULL,
272 modby INTEGER DEFAULT 0 NOT NULL,
273 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
278 mach_id INTEGER DEFAULT 0 NOT NULL,
279 target VARCHAR(128) DEFAULT CHR(0) NOT NULL,
280 kind VARCHAR(16) DEFAULT CHR(0) NOT NULL,
281 list_id INTEGER DEFAULT 0 NOT NULL,
282 modtime DATE DEFAULT SYSDATE NOT NULL,
283 modby INTEGER DEFAULT 0 NOT NULL,
284 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
289 string_id INTEGER DEFAULT 0 NOT NULL,
290 string VARCHAR(128) DEFAULT CHR(0) NOT NULL
293 create table services
295 name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
296 protocol VARCHAR(8) DEFAULT CHR(0) NOT NULL,
297 port SMALLINT DEFAULT 0 NOT NULL,
298 description VARCHAR(64) DEFAULT CHR(0) NOT NULL,
299 modtime DATE DEFAULT SYSDATE NOT NULL,
300 modby INTEGER DEFAULT 0 NOT NULL,
301 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
304 create table printers
306 name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
307 type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
308 hwtype VARCHAR(16) DEFAULT CHR(0) NOT NULL,
309 duplexname VARCHAR(16) DEFAULT CHR(0) NOT NULL,
310 mach_id INTEGER DEFAULT 0 NOT NULL,
311 loghost INTEGER DEFAULT 0 NOT NULL,
312 rm INTEGER DEFAULT 0 NOT NULL,
313 rp VARCHAR(16) DEFAULT CHR(0) NOT NULL,
314 rq INTEGER DEFAULT 0 NOT NULL,
315 ka SMALLINT DEFAULT 0 NOT NULL,
316 pc SMALLINT DEFAULT 0 NOT NULL,
317 ac INTEGER DEFAULT 0 NOT NULL,
318 lpc_acl INTEGER DEFAULT 0 NOT NULL,
319 banner INTEGER DEFAULT 0 NOT NULL,
320 location VARCHAR(64) DEFAULT CHR(0) NOT NULL,
321 contact 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 printservers
329 mach_id INTEGER DEFAULT 0 NOT NULL,
330 kind VARCHAR(8) DEFAULT CHR(0) NOT NULL,
331 printer_types INTEGER DEFAULT 0 NOT NULL,
332 owner_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
333 owner_id INTEGER DEFAULT 0 NOT NULL,
334 lpc_acl INTEGER DEFAULT 0 NOT NULL,
335 modtime DATE DEFAULT SYSDATE NOT NULL,
336 modby INTEGER DEFAULT 0 NOT NULL,
337 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
342 capability VARCHAR(32) DEFAULT CHR(0) NOT NULL,
343 tag VARCHAR(4) DEFAULT CHR(0) NOT NULL,
344 list_id INTEGER DEFAULT 0 NOT NULL
349 name VARCHAR(32) DEFAULT CHR(0) NOT NULL,
350 type VARCHAR(16) DEFAULT CHR(0) NOT NULL,
351 trans VARCHAR(128) DEFAULT CHR(0) NOT NULL
354 create table numvalues
356 name VARCHAR(32) DEFAULT CHR(0) NOT NULL,
357 value INTEGER DEFAULT 0 NOT NULL
360 create table tblstats
362 table_name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
363 modtime DATE DEFAULT SYSDATE NOT NULL,
364 appends INTEGER DEFAULT 0 NOT NULL,
365 updates INTEGER DEFAULT 0 NOT NULL,
366 deletes INTEGER DEFAULT 0 NOT NULL
369 create table incremental
371 table_name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
372 service VARCHAR(16) DEFAULT CHR(0) NOT NULL