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 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 reservations VARCHAR(10) DEFAULT CHR(0) NOT NULL,
46 flag INTEGER DEFAULT 0 NOT NULL
51 users_id INTEGER DEFAULT 0 NOT NULL,
52 string_id INTEGER DEFAULT 0 NOT NULL
57 name VARCHAR(255) DEFAULT CHR(0) NOT NULL,
58 mach_id INTEGER DEFAULT 0 NOT NULL,
59 vendor VARCHAR(16) DEFAULT CHR(0) NOT NULL,
60 model VARCHAR(24) DEFAULT CHR(0) NOT NULL,
61 os VARCHAR(16) DEFAULT CHR(0) NOT NULL,
62 location VARCHAR(16) DEFAULT CHR(0) NOT NULL,
63 contact VARCHAR(32) DEFAULT CHR(0) NOT NULL,
64 use INTEGER DEFAULT 0 NOT NULL,
65 status INTEGER DEFAULT 0 NOT NULL,
66 statuschange DATE DEFAULT SYSDATE NOT NULL,
67 snet_id INTEGER DEFAULT 0 NOT NULL,
68 address VARCHAR(16) DEFAULT CHR(0) NOT NULL,
69 hwaddr VARCHAR(12) DEFAULT CHR(0) NOT NULL,
70 owner_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
71 owner_id INTEGER DEFAULT 0 NOT NULL,
72 acomment INTEGER DEFAULT 0 NOT NULL,
73 ocomment INTEGER DEFAULT 0 NOT NULL,
74 created DATE DEFAULT SYSDATE NOT NULL,
75 creator INTEGER DEFAULT 0 NOT NULL,
76 inuse DATE DEFAULT SYSDATE NOT NULL,
77 modtime DATE DEFAULT SYSDATE NOT NULL,
78 modby INTEGER DEFAULT 0 NOT NULL,
79 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
82 create table hostalias
84 name VARCHAR(255) DEFAULT CHR(0) NOT NULL,
85 mach_id INTEGER DEFAULT 0 NOT NULL
90 name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
91 snet_id INTEGER DEFAULT 0 NOT NULL,
92 description VARCHAR(48) DEFAULT CHR(0) NOT NULL,
93 saddr INTEGER DEFAULT 0 NOT NULL,
94 mask INTEGER DEFAULT 0 NOT NULL,
95 low INTEGER DEFAULT 0 NOT NULL,
96 high INTEGER DEFAULT 0 NOT NULL,
97 prefix VARCHAR(8) DEFAULT CHR(0) NOT NULL,
98 owner_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
99 owner_id INTEGER DEFAULT 0 NOT NULL,
100 modtime DATE DEFAULT SYSDATE NOT NULL,
101 modby INTEGER DEFAULT 0 NOT NULL,
102 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
105 create table clusters
107 name VARCHAR(32) DEFAULT CHR(0) NOT NULL,
108 clu_id INTEGER DEFAULT 0 NOT NULL,
109 description VARCHAR(32) DEFAULT CHR(0) NOT NULL,
110 location VARCHAR(64) DEFAULT CHR(0) NOT NULL,
111 modtime DATE DEFAULT SYSDATE NOT NULL,
112 modby INTEGER DEFAULT 0 NOT NULL,
113 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
118 mach_id INTEGER DEFAULT 0 NOT NULL,
119 clu_id INTEGER DEFAULT 0 NOT NULL
124 clu_id INTEGER DEFAULT 0 NOT NULL,
125 serv_label VARCHAR(16) DEFAULT CHR(0) NOT NULL,
126 serv_cluster VARCHAR(32) DEFAULT CHR(0) NOT NULL
131 name VARCHAR(32) DEFAULT CHR(0) NOT NULL,
132 list_id INTEGER DEFAULT 0 NOT NULL,
133 active INTEGER DEFAULT 0 NOT NULL,
134 publicflg INTEGER DEFAULT 0 NOT NULL,
135 hidden INTEGER DEFAULT 0 NOT NULL,
136 maillist INTEGER DEFAULT 0 NOT NULL,
137 grouplist INTEGER DEFAULT 0 NOT NULL,
138 gid SMALLINT DEFAULT 0 NOT NULL,
139 description VARCHAR(255) DEFAULT CHR(0) NOT NULL,
140 acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
141 acl_id INTEGER DEFAULT 0 NOT NULL,
142 modtime DATE DEFAULT SYSDATE NOT NULL,
143 modby INTEGER DEFAULT 0 NOT NULL,
144 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
147 create table imembers
149 list_id INTEGER DEFAULT 0 NOT NULL,
150 member_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
151 member_id INTEGER DEFAULT 0 NOT NULL,
152 tag INTEGER DEFAULT 0 NOT NULL,
153 ref_count SMALLINT DEFAULT 0 NOT NULL,
154 direct SMALLINT DEFAULT 0 NOT NULL
159 name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
160 update_int INTEGER DEFAULT 0 NOT NULL,
161 target_file VARCHAR(64) DEFAULT CHR(0) NOT NULL,
162 script VARCHAR(128) DEFAULT CHR(0) NOT NULL,
163 dfgen INTEGER DEFAULT 0 NOT NULL,
164 dfcheck INTEGER DEFAULT 0 NOT NULL,
165 type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
166 enable INTEGER DEFAULT 0 NOT NULL,
167 inprogress INTEGER DEFAULT 0 NOT NULL,
168 harderror INTEGER DEFAULT 0 NOT NULL,
169 errmsg VARCHAR(80) DEFAULT CHR(0) NOT NULL,
170 acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
171 acl_id INTEGER DEFAULT 0 NOT NULL,
172 modtime DATE DEFAULT SYSDATE NOT NULL,
173 modby INTEGER DEFAULT 0 NOT NULL,
174 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
177 create table serverhosts
179 service VARCHAR(16) DEFAULT CHR(0) NOT NULL,
180 mach_id INTEGER DEFAULT 0 NOT NULL,
181 success INTEGER DEFAULT 0 NOT NULL,
182 enable INTEGER DEFAULT 0 NOT NULL,
183 override INTEGER DEFAULT 0 NOT NULL,
184 inprogress INTEGER DEFAULT 0 NOT NULL,
185 hosterror INTEGER DEFAULT 0 NOT NULL,
186 hosterrmsg VARCHAR(80) DEFAULT CHR(0) NOT NULL,
187 ltt INTEGER DEFAULT 0 NOT NULL,
188 lts INTEGER DEFAULT 0 NOT NULL,
189 value1 INTEGER DEFAULT 0 NOT NULL,
190 value2 INTEGER DEFAULT 0 NOT NULL,
191 value3 VARCHAR(32) DEFAULT CHR(0) NOT NULL,
192 modtime DATE DEFAULT SYSDATE NOT NULL,
193 modby INTEGER DEFAULT 0 NOT NULL,
194 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
199 filsys_id INTEGER DEFAULT 0 NOT NULL,
200 phys_id INTEGER DEFAULT 0 NOT NULL,
201 label VARCHAR(32) DEFAULT CHR(0) NOT NULL,
202 fs_order INTEGER DEFAULT 0 NOT NULL,
203 type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
204 mach_id INTEGER DEFAULT 0 NOT NULL,
205 name VARCHAR(80) DEFAULT CHR(0) NOT NULL,
206 mount VARCHAR(32) DEFAULT CHR(0) NOT NULL,
207 rwaccess CHAR(1) DEFAULT CHR(0) NOT NULL,
208 comments VARCHAR(64) DEFAULT CHR(0) NOT NULL,
209 owner INTEGER DEFAULT 0 NOT NULL,
210 owners INTEGER DEFAULT 0 NOT NULL,
211 createflg INTEGER DEFAULT 0 NOT NULL,
212 lockertype VARCHAR(8) DEFAULT CHR(0) NOT NULL,
213 modtime DATE DEFAULT SYSDATE NOT NULL,
214 modby INTEGER DEFAULT 0 NOT NULL,
215 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
220 group_id INTEGER DEFAULT 0 NOT NULL,
221 filsys_id INTEGER DEFAULT 0 NOT NULL,
222 key VARCHAR(8) DEFAULT CHR(0) NOT NULL
227 nfsphys_id INTEGER DEFAULT 0 NOT NULL,
228 mach_id INTEGER DEFAULT 0 NOT NULL,
229 device VARCHAR(16) DEFAULT CHR(0) NOT NULL,
230 dir VARCHAR(16) DEFAULT CHR(0) NOT NULL,
231 status SMALLINT DEFAULT 0 NOT NULL,
232 allocated INTEGER DEFAULT 0 NOT NULL,
233 partsize INTEGER DEFAULT 0 NOT NULL,
234 modtime DATE DEFAULT SYSDATE NOT NULL,
235 modby INTEGER DEFAULT 0 NOT NULL,
236 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
241 filsys_id INTEGER DEFAULT 0 NOT NULL,
242 type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
243 entity_id INTEGER DEFAULT 0 NOT NULL,
244 phys_id INTEGER DEFAULT 0 NOT NULL,
245 quota INTEGER DEFAULT 0 NOT NULL,
246 modtime DATE DEFAULT SYSDATE NOT NULL,
247 modby INTEGER DEFAULT 0 NOT NULL,
248 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
253 class VARCHAR(16) DEFAULT CHR(0) NOT NULL,
254 xmt_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
255 xmt_id INTEGER DEFAULT 0 NOT NULL,
256 sub_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
257 sub_id INTEGER DEFAULT 0 NOT NULL,
258 iws_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
259 iws_id INTEGER DEFAULT 0 NOT NULL,
260 iui_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
261 iui_id INTEGER DEFAULT 0 NOT NULL,
262 modtime DATE DEFAULT SYSDATE NOT NULL,
263 modby INTEGER DEFAULT 0 NOT NULL,
264 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
267 create table hostaccess
269 mach_id INTEGER DEFAULT 0 NOT NULL,
270 acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
271 acl_id INTEGER DEFAULT 0 NOT NULL,
272 modtime DATE DEFAULT SYSDATE NOT NULL,
273 modby INTEGER DEFAULT 0 NOT NULL,
274 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
279 mach_id INTEGER DEFAULT 0 NOT NULL,
280 target VARCHAR(128) DEFAULT CHR(0) NOT NULL,
281 kind VARCHAR(16) DEFAULT CHR(0) NOT NULL,
282 list_id INTEGER DEFAULT 0 NOT NULL,
283 modtime DATE DEFAULT SYSDATE NOT NULL,
284 modby INTEGER DEFAULT 0 NOT NULL,
285 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
290 string_id INTEGER DEFAULT 0 NOT NULL,
291 string VARCHAR(128) DEFAULT CHR(0) NOT NULL
294 create table services
296 name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
297 protocol VARCHAR(8) DEFAULT CHR(0) NOT NULL,
298 port SMALLINT DEFAULT 0 NOT NULL,
299 description VARCHAR(64) DEFAULT CHR(0) NOT NULL,
300 modtime DATE DEFAULT SYSDATE NOT NULL,
301 modby INTEGER DEFAULT 0 NOT NULL,
302 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
305 create table printers
307 name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
308 type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
309 hwtype VARCHAR(16) DEFAULT CHR(0) NOT NULL,
310 duplexname VARCHAR(16) DEFAULT CHR(0) NOT NULL,
311 mach_id INTEGER DEFAULT 0 NOT NULL,
312 loghost INTEGER DEFAULT 0 NOT NULL,
313 rm INTEGER DEFAULT 0 NOT NULL,
314 rp VARCHAR(16) DEFAULT CHR(0) NOT NULL,
315 rq INTEGER DEFAULT 0 NOT NULL,
316 ka SMALLINT DEFAULT 0 NOT NULL,
317 pc SMALLINT DEFAULT 0 NOT NULL,
318 mc SMALLINT DEFAULT 0 NOT NULL,
319 ac INTEGER DEFAULT 0 NOT NULL,
320 lpc_acl INTEGER DEFAULT 0 NOT NULL,
321 banner INTEGER DEFAULT 0 NOT NULL,
322 location VARCHAR(64) DEFAULT CHR(0) NOT NULL,
323 contact VARCHAR(64) DEFAULT CHR(0) NOT NULL,
324 modtime DATE DEFAULT SYSDATE NOT NULL,
325 modby INTEGER DEFAULT 0 NOT NULL,
326 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
329 create table printservers
331 mach_id INTEGER DEFAULT 0 NOT NULL,
332 kind VARCHAR(8) DEFAULT CHR(0) NOT NULL,
333 printer_types INTEGER DEFAULT 0 NOT NULL,
334 owner_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
335 owner_id INTEGER DEFAULT 0 NOT NULL,
336 lpc_acl INTEGER DEFAULT 0 NOT NULL,
337 modtime DATE DEFAULT SYSDATE NOT NULL,
338 modby INTEGER DEFAULT 0 NOT NULL,
339 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
344 capability VARCHAR(32) DEFAULT CHR(0) NOT NULL,
345 tag VARCHAR(4) DEFAULT CHR(0) NOT NULL,
346 list_id INTEGER DEFAULT 0 NOT NULL
351 name VARCHAR(32) DEFAULT CHR(0) NOT NULL,
352 type VARCHAR(16) DEFAULT CHR(0) NOT NULL,
353 trans VARCHAR(128) DEFAULT CHR(0) NOT NULL
356 create table numvalues
358 name VARCHAR(32) DEFAULT CHR(0) NOT NULL,
359 value INTEGER DEFAULT 0 NOT NULL
362 create table tblstats
364 table_name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
365 modtime DATE DEFAULT SYSDATE NOT NULL,
366 appends INTEGER DEFAULT 0 NOT NULL,
367 updates INTEGER DEFAULT 0 NOT NULL,
368 deletes INTEGER DEFAULT 0 NOT NULL
371 create table incremental
373 table_name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
374 service VARCHAR(16) DEFAULT CHR(0) NOT NULL