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 ref_count SMALLINT DEFAULT 0 NOT NULL,
152 direct SMALLINT DEFAULT 0 NOT NULL
157 name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
158 update_int INTEGER DEFAULT 0 NOT NULL,
159 target_file VARCHAR(64) DEFAULT CHR(0) NOT NULL,
160 script VARCHAR(128) DEFAULT CHR(0) NOT NULL,
161 dfgen INTEGER DEFAULT 0 NOT NULL,
162 dfcheck INTEGER DEFAULT 0 NOT NULL,
163 type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
164 enable INTEGER DEFAULT 0 NOT NULL,
165 inprogress INTEGER DEFAULT 0 NOT NULL,
166 harderror INTEGER DEFAULT 0 NOT NULL,
167 errmsg VARCHAR(80) DEFAULT CHR(0) NOT NULL,
168 acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
169 acl_id INTEGER DEFAULT 0 NOT NULL,
170 modtime DATE DEFAULT SYSDATE NOT NULL,
171 modby INTEGER DEFAULT 0 NOT NULL,
172 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
175 create table serverhosts
177 service VARCHAR(16) DEFAULT CHR(0) NOT NULL,
178 mach_id INTEGER DEFAULT 0 NOT NULL,
179 success INTEGER DEFAULT 0 NOT NULL,
180 enable INTEGER DEFAULT 0 NOT NULL,
181 override INTEGER DEFAULT 0 NOT NULL,
182 inprogress INTEGER DEFAULT 0 NOT NULL,
183 hosterror INTEGER DEFAULT 0 NOT NULL,
184 hosterrmsg VARCHAR(80) DEFAULT CHR(0) NOT NULL,
185 ltt INTEGER DEFAULT 0 NOT NULL,
186 lts INTEGER DEFAULT 0 NOT NULL,
187 value1 INTEGER DEFAULT 0 NOT NULL,
188 value2 INTEGER DEFAULT 0 NOT NULL,
189 value3 VARCHAR(32) DEFAULT CHR(0) NOT NULL,
190 modtime DATE DEFAULT SYSDATE NOT NULL,
191 modby INTEGER DEFAULT 0 NOT NULL,
192 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
197 filsys_id INTEGER DEFAULT 0 NOT NULL,
198 phys_id INTEGER DEFAULT 0 NOT NULL,
199 label VARCHAR(32) DEFAULT CHR(0) NOT NULL,
200 fs_order INTEGER DEFAULT 0 NOT NULL,
201 type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
202 mach_id INTEGER DEFAULT 0 NOT NULL,
203 name VARCHAR(80) DEFAULT CHR(0) NOT NULL,
204 mount VARCHAR(32) DEFAULT CHR(0) NOT NULL,
205 rwaccess CHAR(1) DEFAULT CHR(0) NOT NULL,
206 comments VARCHAR(64) DEFAULT CHR(0) NOT NULL,
207 owner INTEGER DEFAULT 0 NOT NULL,
208 owners INTEGER DEFAULT 0 NOT NULL,
209 createflg INTEGER DEFAULT 0 NOT NULL,
210 lockertype VARCHAR(8) DEFAULT CHR(0) NOT NULL,
211 modtime DATE DEFAULT SYSDATE NOT NULL,
212 modby INTEGER DEFAULT 0 NOT NULL,
213 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
218 group_id INTEGER DEFAULT 0 NOT NULL,
219 filsys_id INTEGER DEFAULT 0 NOT NULL,
220 key VARCHAR(8) DEFAULT CHR(0) NOT NULL
225 nfsphys_id INTEGER DEFAULT 0 NOT NULL,
226 mach_id INTEGER DEFAULT 0 NOT NULL,
227 device VARCHAR(16) DEFAULT CHR(0) NOT NULL,
228 dir VARCHAR(16) DEFAULT CHR(0) NOT NULL,
229 status SMALLINT DEFAULT 0 NOT NULL,
230 allocated INTEGER DEFAULT 0 NOT NULL,
231 partsize INTEGER DEFAULT 0 NOT NULL,
232 modtime DATE DEFAULT SYSDATE NOT NULL,
233 modby INTEGER DEFAULT 0 NOT NULL,
234 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
239 filsys_id INTEGER DEFAULT 0 NOT NULL,
240 type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
241 entity_id INTEGER DEFAULT 0 NOT NULL,
242 phys_id INTEGER DEFAULT 0 NOT NULL,
243 quota INTEGER DEFAULT 0 NOT NULL,
244 modtime DATE DEFAULT SYSDATE NOT NULL,
245 modby INTEGER DEFAULT 0 NOT NULL,
246 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
251 class VARCHAR(16) DEFAULT CHR(0) NOT NULL,
252 xmt_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
253 xmt_id INTEGER DEFAULT 0 NOT NULL,
254 sub_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
255 sub_id INTEGER DEFAULT 0 NOT NULL,
256 iws_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
257 iws_id INTEGER DEFAULT 0 NOT NULL,
258 iui_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
259 iui_id INTEGER DEFAULT 0 NOT NULL,
260 modtime DATE DEFAULT SYSDATE NOT NULL,
261 modby INTEGER DEFAULT 0 NOT NULL,
262 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
265 create table hostaccess
267 mach_id INTEGER DEFAULT 0 NOT NULL,
268 acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
269 acl_id INTEGER DEFAULT 0 NOT NULL,
270 modtime DATE DEFAULT SYSDATE NOT NULL,
271 modby INTEGER DEFAULT 0 NOT NULL,
272 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
277 string_id INTEGER DEFAULT 0 NOT NULL,
278 string VARCHAR(128) DEFAULT CHR(0) NOT NULL
281 create table services
283 name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
284 protocol VARCHAR(8) DEFAULT CHR(0) NOT NULL,
285 port SMALLINT DEFAULT 0 NOT NULL,
286 description VARCHAR(64) DEFAULT CHR(0) NOT NULL,
287 modtime DATE DEFAULT SYSDATE NOT NULL,
288 modby INTEGER DEFAULT 0 NOT NULL,
289 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
292 create table printers
294 name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
295 type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
296 hwtype VARCHAR(8) DEFAULT CHR(0) NOT NULL,
297 duplexname VARCHAR(16) DEFAULT CHR(0) NOT NULL,
298 mach_id INTEGER DEFAULT 0 NOT NULL,
299 loghost INTEGER DEFAULT 0 NOT NULL,
300 rm INTEGER DEFAULT 0 NOT NULL,
301 rp VARCHAR(16) DEFAULT CHR(0) NOT NULL,
302 rq INTEGER DEFAULT 0 NOT NULL,
303 ka SMALLINT DEFAULT 0 NOT NULL,
304 pc SMALLINT DEFAULT 0 NOT NULL,
305 ac INTEGER DEFAULT 0 NOT NULL,
306 lpc_acl INTEGER DEFAULT 0 NOT NULL,
307 banner INTEGER DEFAULT 0 NOT NULL,
308 location VARCHAR(64) DEFAULT CHR(0) NOT NULL,
309 contact VARCHAR(64) DEFAULT CHR(0) NOT NULL,
310 modtime DATE DEFAULT SYSDATE NOT NULL,
311 modby INTEGER DEFAULT 0 NOT NULL,
312 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
315 create table printservers
317 mach_id INTEGER DEFAULT 0 NOT NULL,
318 kind VARCHAR(8) DEFAULT CHR(0) NOT NULL,
319 printer_types INTEGER DEFAULT 0 NOT NULL,
320 owner_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
321 owner_id INTEGER DEFAULT 0 NOT NULL,
322 lpc_acl INTEGER DEFAULT 0 NOT NULL,
323 modtime DATE DEFAULT SYSDATE NOT NULL,
324 modby INTEGER DEFAULT 0 NOT NULL,
325 modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
330 capability VARCHAR(32) DEFAULT CHR(0) NOT NULL,
331 tag VARCHAR(4) DEFAULT CHR(0) NOT NULL,
332 list_id INTEGER DEFAULT 0 NOT NULL
337 name VARCHAR(32) DEFAULT CHR(0) NOT NULL,
338 type VARCHAR(16) DEFAULT CHR(0) NOT NULL,
339 trans VARCHAR(128) DEFAULT CHR(0) NOT NULL
342 create table numvalues
344 name VARCHAR(32) DEFAULT CHR(0) NOT NULL,
345 value INTEGER DEFAULT 0 NOT NULL
348 create table tblstats
350 table_name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
351 modtime DATE DEFAULT SYSDATE NOT NULL,
352 appends INTEGER DEFAULT 0 NOT NULL,
353 updates INTEGER DEFAULT 0 NOT NULL,
354 deletes INTEGER DEFAULT 0 NOT NULL
357 create table incremental
359 table_name VARCHAR(16) DEFAULT CHR(0) NOT NULL,
360 service VARCHAR(16) DEFAULT CHR(0) NOT NULL