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(30) DEFAULT CHR(0) NOT NULL,
8 first VARCHAR(30) DEFAULT CHR(0) NOT NULL,
9 middle VARCHAR(30) 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(92) 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 imap_id INTEGER DEFAULT 0 NOT NULL,
31 box_id INTEGER DEFAULT 0 NOT NULL,
32 pmodtime DATE DEFAULT SYSDATE NOT NULL,
33 pmodby INTEGER DEFAULT 0 NOT NULL,
34 pmodwith VARCHAR(8) DEFAULT CHR(0) NOT NULL,
35 xname VARCHAR(30) DEFAULT CHR(0) NOT NULL,
36 xdept VARCHAR(50) DEFAULT CHR(0) NOT NULL,
37 xtitle VARCHAR(50) DEFAULT CHR(0) NOT NULL,
38 xaddress VARCHAR(82) DEFAULT CHR(0) NOT NULL,
39 xphone1 VARCHAR(12) DEFAULT CHR(0) NOT NULL,
40 xphone2 VARCHAR(12) DEFAULT CHR(0) NOT NULL,
41 xmodtime DATE DEFAULT SYSDATE NOT NULL,
42 sigdate INTEGER DEFAULT 0 NOT NULL,
43 sigwho INTEGER DEFAULT 0 NOT NULL,
44 signature VARCHAR(68) DEFAULT CHR(0) NOT NULL,
45 secure INTEGER DEFAULT 0 NOT NULL,
46 reservations VARCHAR(10) DEFAULT CHR(0) NOT NULL,
47 flag INTEGER DEFAULT 0 NOT NULL
52 users_id INTEGER DEFAULT 0 NOT NULL,
53 string_id INTEGER DEFAULT 0 NOT NULL
58 name VARCHAR(255) DEFAULT CHR(0) NOT NULL,
59 mach_id INTEGER DEFAULT 0 NOT NULL,
60 vendor VARCHAR(16) DEFAULT CHR(0) NOT NULL,
61 model VARCHAR(24) DEFAULT CHR(0) NOT NULL,
62 os VARCHAR(16) DEFAULT CHR(0) NOT NULL,
63 location VARCHAR(16) DEFAULT CHR(0) NOT NULL,
64 contact VARCHAR(32) DEFAULT CHR(0) NOT NULL,
65 use INTEGER DEFAULT 0 NOT NULL,
66 status INTEGER DEFAULT 0 NOT NULL,
67 statuschange DATE DEFAULT SYSDATE NOT NULL,
68 snet_id INTEGER DEFAULT 0 NOT NULL,
69 address VARCHAR(16) DEFAULT CHR(0) NOT NULL,
70 hwaddr VARCHAR(12) DEFAULT CHR(0) NOT NULL,
71 owner_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
72 owner_id INTEGER DEFAULT 0 NOT NULL,
73 acomment INTEGER DEFAULT 0 NOT NULL,
74 ocomment INTEGER DEFAULT 0 NOT NULL,
75 created DATE DEFAULT SYSDATE NOT NULL,
76 creator INTEGER DEFAULT 0 NOT NULL,
77 inuse DATE DEFAULT SYSDATE NOT NULL,
78 modtime DATE DEFAULT SYSDATE NOT NULL,
79 modby INTEGER DEFAULT 0 NOT NULL,
80 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
83 create table hostalias
85 name VARCHAR(255) DEFAULT CHR(0) NOT NULL,
86 mach_id INTEGER DEFAULT 0 NOT NULL
91 name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
92 snet_id INTEGER DEFAULT 0 NOT NULL,
93 description VARCHAR(48) DEFAULT CHR(0) NOT NULL,
94 saddr INTEGER DEFAULT 0 NOT NULL,
95 mask INTEGER DEFAULT 0 NOT NULL,
96 low INTEGER DEFAULT 0 NOT NULL,
97 high INTEGER DEFAULT 0 NOT NULL,
98 prefix VARCHAR(8) DEFAULT CHR(0) NOT NULL,
99 owner_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
100 owner_id INTEGER DEFAULT 0 NOT NULL,
101 modtime DATE DEFAULT SYSDATE NOT NULL,
102 modby INTEGER DEFAULT 0 NOT NULL,
103 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
106 create table clusters
108 name VARCHAR(32) DEFAULT CHR(0) NOT NULL,
109 clu_id INTEGER DEFAULT 0 NOT NULL,
110 description VARCHAR(32) DEFAULT CHR(0) NOT NULL,
111 location VARCHAR(64) DEFAULT CHR(0) NOT NULL,
112 modtime DATE DEFAULT SYSDATE NOT NULL,
113 modby INTEGER DEFAULT 0 NOT NULL,
114 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
119 mach_id INTEGER DEFAULT 0 NOT NULL,
120 clu_id INTEGER DEFAULT 0 NOT NULL
125 clu_id INTEGER DEFAULT 0 NOT NULL,
126 serv_label VARCHAR(16) DEFAULT CHR(0) NOT NULL,
127 serv_cluster VARCHAR(128) DEFAULT CHR(0) NOT NULL
132 name VARCHAR(32) DEFAULT CHR(0) NOT NULL,
133 list_id INTEGER DEFAULT 0 NOT NULL,
134 active INTEGER DEFAULT 0 NOT NULL,
135 publicflg INTEGER DEFAULT 0 NOT NULL,
136 hidden INTEGER DEFAULT 0 NOT NULL,
137 maillist INTEGER DEFAULT 0 NOT NULL,
138 grouplist INTEGER DEFAULT 0 NOT NULL,
139 gid SMALLINT DEFAULT 0 NOT NULL,
140 description VARCHAR(255) DEFAULT CHR(0) NOT NULL,
141 acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
142 acl_id INTEGER DEFAULT 0 NOT NULL,
143 modtime DATE DEFAULT SYSDATE NOT NULL,
144 modby INTEGER DEFAULT 0 NOT NULL,
145 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
148 create table imembers
150 list_id INTEGER DEFAULT 0 NOT NULL,
151 member_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
152 member_id INTEGER DEFAULT 0 NOT NULL,
153 tag INTEGER DEFAULT 0 NOT NULL,
154 ref_count SMALLINT DEFAULT 0 NOT NULL,
155 direct SMALLINT DEFAULT 0 NOT NULL
160 name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
161 update_int INTEGER DEFAULT 0 NOT NULL,
162 target_file VARCHAR(64) DEFAULT CHR(0) NOT NULL,
163 script VARCHAR(128) DEFAULT CHR(0) NOT NULL,
164 dfgen INTEGER DEFAULT 0 NOT NULL,
165 dfcheck INTEGER DEFAULT 0 NOT NULL,
166 type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
167 enable INTEGER DEFAULT 0 NOT NULL,
168 inprogress INTEGER DEFAULT 0 NOT NULL,
169 harderror INTEGER DEFAULT 0 NOT NULL,
170 errmsg VARCHAR(80) DEFAULT CHR(0) NOT NULL,
171 acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
172 acl_id INTEGER DEFAULT 0 NOT NULL,
173 modtime DATE DEFAULT SYSDATE NOT NULL,
174 modby INTEGER DEFAULT 0 NOT NULL,
175 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
178 create table serverhosts
180 service VARCHAR(16) DEFAULT CHR(0) NOT NULL,
181 mach_id INTEGER DEFAULT 0 NOT NULL,
182 success INTEGER DEFAULT 0 NOT NULL,
183 enable INTEGER DEFAULT 0 NOT NULL,
184 override INTEGER DEFAULT 0 NOT NULL,
185 inprogress INTEGER DEFAULT 0 NOT NULL,
186 hosterror INTEGER DEFAULT 0 NOT NULL,
187 hosterrmsg VARCHAR(80) DEFAULT CHR(0) NOT NULL,
188 ltt INTEGER DEFAULT 0 NOT NULL,
189 lts INTEGER DEFAULT 0 NOT NULL,
190 value1 INTEGER DEFAULT 0 NOT NULL,
191 value2 INTEGER DEFAULT 0 NOT NULL,
192 value3 VARCHAR(32) DEFAULT CHR(0) NOT NULL,
193 modtime DATE DEFAULT SYSDATE NOT NULL,
194 modby INTEGER DEFAULT 0 NOT NULL,
195 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
200 filsys_id INTEGER DEFAULT 0 NOT NULL,
201 phys_id INTEGER DEFAULT 0 NOT NULL,
202 label VARCHAR(32) DEFAULT CHR(0) NOT NULL,
203 fs_order INTEGER DEFAULT 0 NOT NULL,
204 type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
205 mach_id INTEGER DEFAULT 0 NOT NULL,
206 name VARCHAR(80) DEFAULT CHR(0) NOT NULL,
207 mount VARCHAR(32) DEFAULT CHR(0) NOT NULL,
208 rwaccess CHAR(1) DEFAULT CHR(0) NOT NULL,
209 comments VARCHAR(64) DEFAULT CHR(0) NOT NULL,
210 owner INTEGER DEFAULT 0 NOT NULL,
211 owners INTEGER DEFAULT 0 NOT NULL,
212 createflg INTEGER DEFAULT 0 NOT NULL,
213 lockertype VARCHAR(8) DEFAULT CHR(0) NOT NULL,
214 modtime DATE DEFAULT SYSDATE NOT NULL,
215 modby INTEGER DEFAULT 0 NOT NULL,
216 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
221 group_id INTEGER DEFAULT 0 NOT NULL,
222 filsys_id INTEGER DEFAULT 0 NOT NULL,
223 key VARCHAR(8) DEFAULT CHR(0) NOT NULL
228 nfsphys_id INTEGER DEFAULT 0 NOT NULL,
229 mach_id INTEGER DEFAULT 0 NOT NULL,
230 device VARCHAR(32) DEFAULT CHR(0) NOT NULL,
231 dir VARCHAR(64) DEFAULT CHR(0) NOT NULL,
232 status SMALLINT DEFAULT 0 NOT NULL,
233 allocated INTEGER DEFAULT 0 NOT NULL,
234 partsize INTEGER DEFAULT 0 NOT NULL,
235 modtime DATE DEFAULT SYSDATE NOT NULL,
236 modby INTEGER DEFAULT 0 NOT NULL,
237 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
242 filsys_id INTEGER DEFAULT 0 NOT NULL,
243 type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
244 entity_id INTEGER DEFAULT 0 NOT NULL,
245 phys_id INTEGER DEFAULT 0 NOT NULL,
246 quota INTEGER DEFAULT 0 NOT NULL,
247 modtime DATE DEFAULT SYSDATE NOT NULL,
248 modby INTEGER DEFAULT 0 NOT NULL,
249 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
254 class VARCHAR(16) DEFAULT CHR(0) NOT NULL,
255 xmt_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
256 xmt_id INTEGER DEFAULT 0 NOT NULL,
257 sub_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
258 sub_id INTEGER DEFAULT 0 NOT NULL,
259 iws_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
260 iws_id INTEGER DEFAULT 0 NOT NULL,
261 iui_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
262 iui_id INTEGER DEFAULT 0 NOT NULL,
263 modtime DATE DEFAULT SYSDATE NOT NULL,
264 modby INTEGER DEFAULT 0 NOT NULL,
265 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
268 create table hostaccess
270 mach_id INTEGER DEFAULT 0 NOT NULL,
271 acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
272 acl_id INTEGER DEFAULT 0 NOT NULL,
273 modtime DATE DEFAULT SYSDATE NOT NULL,
274 modby INTEGER DEFAULT 0 NOT NULL,
275 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
280 mach_id INTEGER DEFAULT 0 NOT NULL,
281 target VARCHAR(128) DEFAULT CHR(0) NOT NULL,
282 kind VARCHAR(16) DEFAULT CHR(0) NOT NULL,
283 list_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
291 string_id INTEGER DEFAULT 0 NOT NULL,
292 string VARCHAR(128) DEFAULT CHR(0) NOT NULL
295 create table services
297 name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
298 protocol VARCHAR(8) DEFAULT CHR(0) NOT NULL,
299 port SMALLINT DEFAULT 0 NOT NULL,
300 description VARCHAR(64) DEFAULT CHR(0) NOT NULL,
301 modtime DATE DEFAULT SYSDATE NOT NULL,
302 modby INTEGER DEFAULT 0 NOT NULL,
303 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
306 create table printers
308 name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
309 type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
310 hwtype VARCHAR(16) DEFAULT CHR(0) NOT NULL,
311 duplexname VARCHAR(16) DEFAULT CHR(0) NOT NULL,
312 mach_id INTEGER DEFAULT 0 NOT NULL,
313 loghost INTEGER DEFAULT 0 NOT NULL,
314 rm INTEGER DEFAULT 0 NOT NULL,
315 rp VARCHAR(16) DEFAULT CHR(0) NOT NULL,
316 rq INTEGER DEFAULT 0 NOT NULL,
317 ka SMALLINT DEFAULT 0 NOT NULL,
318 pc SMALLINT DEFAULT 0 NOT NULL,
319 mc SMALLINT DEFAULT 0 NOT NULL,
320 ac INTEGER DEFAULT 0 NOT NULL,
321 lpc_acl INTEGER DEFAULT 0 NOT NULL,
322 banner INTEGER DEFAULT 0 NOT NULL,
323 location VARCHAR(64) DEFAULT CHR(0) NOT NULL,
324 contact VARCHAR(64) DEFAULT CHR(0) NOT NULL,
325 modtime DATE DEFAULT SYSDATE NOT NULL,
326 modby INTEGER DEFAULT 0 NOT NULL,
327 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
330 create table printservers
332 mach_id INTEGER DEFAULT 0 NOT NULL,
333 kind VARCHAR(8) DEFAULT CHR(0) NOT NULL,
334 printer_types INTEGER DEFAULT 0 NOT NULL,
335 owner_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
336 owner_id INTEGER DEFAULT 0 NOT NULL,
337 lpc_acl INTEGER DEFAULT 0 NOT NULL,
338 modtime DATE DEFAULT SYSDATE NOT NULL,
339 modby INTEGER DEFAULT 0 NOT NULL,
340 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
345 capability VARCHAR(32) DEFAULT CHR(0) NOT NULL,
346 tag VARCHAR(4) DEFAULT CHR(0) NOT NULL,
347 list_id INTEGER DEFAULT 0 NOT NULL
352 name VARCHAR(32) DEFAULT CHR(0) NOT NULL,
353 type VARCHAR(16) DEFAULT CHR(0) NOT NULL,
354 trans VARCHAR(128) DEFAULT CHR(0) NOT NULL
357 create table numvalues
359 name VARCHAR(32) DEFAULT CHR(0) NOT NULL,
360 value INTEGER DEFAULT 0 NOT NULL
363 create table tblstats
365 table_name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
366 modtime DATE DEFAULT SYSDATE NOT NULL,
367 appends INTEGER DEFAULT 0 NOT NULL,
368 updates INTEGER DEFAULT 0 NOT NULL,
369 deletes INTEGER DEFAULT 0 NOT NULL
372 create table incremental
374 table_name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
375 service VARCHAR(16) DEFAULT CHR(0) NOT NULL