3 login VARCHAR(8) NOT NULL WITH DEFAULT,
4 users_id INTEGER NOT NULL WITH DEFAULT,
5 uid SMALLINT NOT NULL WITH DEFAULT,
6 shell CHAR(32) NOT NULL WITH DEFAULT,
7 last VARCHAR(16) NOT NULL WITH DEFAULT,
8 first VARCHAR(16) NOT NULL WITH DEFAULT,
9 middle CHAR(16) NOT NULL WITH DEFAULT,
10 status SMALLINT NOT NULL WITH DEFAULT,
11 clearid VARCHAR(16) NOT NULL WITH DEFAULT,
12 type CHAR(8) NOT NULL WITH DEFAULT,
13 comment INTEGER NOT NULL WITH DEFAULT,
14 modtime DATE NOT NULL WITH DEFAULT,
15 modby INTEGER NOT NULL WITH DEFAULT,
16 modwith CHAR(8) NOT NULL WITH DEFAULT,
17 fullname CHAR(32) NOT NULL WITH DEFAULT,
18 nickname CHAR(16) NOT NULL WITH DEFAULT,
19 home_addr CHAR(82) NOT NULL WITH DEFAULT,
20 home_phone CHAR(16) NOT NULL WITH DEFAULT,
21 office_addr CHAR(16) NOT NULL WITH DEFAULT,
22 office_phone CHAR(12) NOT NULL WITH DEFAULT,
23 department CHAR(20) NOT NULL WITH DEFAULT,
24 affiliation CHAR(50) NOT NULL WITH DEFAULT,
25 fmodtime DATE NOT NULL WITH DEFAULT,
26 fmodby INTEGER NOT NULL WITH DEFAULT,
27 fmodwith CHAR(8) NOT NULL WITH DEFAULT,
28 potype CHAR(8) NOT NULL WITH DEFAULT,
29 pop_id INTEGER NOT NULL WITH DEFAULT,
30 box_id INTEGER NOT NULL WITH DEFAULT,
31 pmodtime DATE NOT NULL WITH DEFAULT,
32 pmodby INTEGER NOT NULL WITH DEFAULT,
33 pmodwith CHAR(8) NOT NULL WITH DEFAULT,
34 xname CHAR(30) NOT NULL WITH DEFAULT,
35 xdept CHAR(20) NOT NULL WITH DEFAULT,
36 xtitle CHAR(50) NOT NULL WITH DEFAULT,
37 xaddress CHAR(82) NOT NULL WITH DEFAULT,
38 xphone1 CHAR(12) NOT NULL WITH DEFAULT,
39 xphone2 CHAR(12) NOT NULL WITH DEFAULT,
40 xmodtime DATE NOT NULL WITH DEFAULT,
41 sigdate INTEGER NOT NULL WITH DEFAULT,
42 sigwho INTEGER NOT NULL WITH DEFAULT,
43 signature VARCHAR(68) NOT NULL WITH DEFAULT,
44 secure INTEGER NOT NULL WITH DEFAULT,
45 flag INTEGER1 NOT NULL WITH DEFAULT
49 users_id INTEGER NOT NULL WITH DEFAULT,
50 string_id INTEGER NOT NULL WITH DEFAULT
54 name VARCHAR(40) NOT NULL WITH DEFAULT,
55 mach_id INTEGER NOT NULL WITH DEFAULT,
56 vendor CHAR(16) NOT NULL WITH DEFAULT,
57 model CHAR(24) NOT NULL WITH DEFAULT,
58 os CHAR(16) NOT NULL WITH DEFAULT,
59 location CHAR(16) NOT NULL WITH DEFAULT,
60 contact CHAR(32) NOT NULL WITH DEFAULT,
61 use INTEGER NOT NULL WITH DEFAULT,
62 status INTEGER1 NOT NULL WITH DEFAULT,
63 statuschange DATE NOT NULL WITH DEFAULT,
64 snet_id INTEGER NOT NULL WITH DEFAULT,
65 address CHAR(16) NOT NULL WITH DEFAULT,
66 owner_type CHAR(8) NOT NULL WITH DEFAULT,
67 owner_id INTEGER NOT NULL WITH DEFAULT,
68 acomment INTEGER NOT NULL WITH DEFAULT,
69 ocomment INTEGER NOT NULL WITH DEFAULT,
70 created DATE NOT NULL WITH DEFAULT,
71 creator INTEGER NOT NULL WITH DEFAULT,
72 inuse DATE NOT NULL WITH DEFAULT,
73 modtime DATE NOT NULL WITH DEFAULT,
74 modby INTEGER NOT NULL WITH DEFAULT,
75 modwith CHAR(8) NOT NULL WITH DEFAULT
77 create table hostalias
79 name VARCHAR(40) NOT NULL WITH DEFAULT,
80 mach_id INTEGER NOT NULL WITH DEFAULT
84 name CHAR(8) NOT NULL WITH DEFAULT,
85 snet_id INTEGER NOT NULL WITH DEFAULT,
86 description VARCHAR(32) NOT NULL WITH DEFAULT,
87 saddr INTEGER NOT NULL WITH DEFAULT,
88 mask INTEGER NOT NULL WITH DEFAULT,
89 low INTEGER NOT NULL WITH DEFAULT,
90 high INTEGER NOT NULL WITH DEFAULT,
91 prefix CHAR(8) NOT NULL WITH DEFAULT,
92 owner_type CHAR(8) NOT NULL WITH DEFAULT,
93 owner_id INTEGER NOT NULL WITH DEFAULT,
94 modtime DATE NOT NULL WITH DEFAULT,
95 modby INTEGER NOT NULL WITH DEFAULT,
96 modwith CHAR(8) NOT NULL WITH DEFAULT
100 name VARCHAR(32) NOT NULL WITH DEFAULT,
101 clu_id INTEGER NOT NULL WITH DEFAULT,
102 description CHAR(32) NOT NULL WITH DEFAULT,
103 location CHAR(64) NOT NULL WITH DEFAULT,
104 modtime DATE NOT NULL WITH DEFAULT,
105 modby INTEGER NOT NULL WITH DEFAULT,
106 modwith CHAR(8) NOT NULL WITH DEFAULT
110 mach_id INTEGER NOT NULL WITH DEFAULT,
111 clu_id INTEGER NOT NULL WITH DEFAULT
115 clu_id INTEGER NOT NULL WITH DEFAULT,
116 serv_label VARCHAR(16) NOT NULL WITH DEFAULT,
117 serv_cluster CHAR(32) NOT NULL WITH DEFAULT
121 name VARCHAR(32) NOT NULL WITH DEFAULT,
122 list_id INTEGER NOT NULL WITH DEFAULT,
123 active INTEGER1 NOT NULL WITH DEFAULT,
124 publicflg INTEGER1 NOT NULL WITH DEFAULT,
125 hidden INTEGER1 NOT NULL WITH DEFAULT,
126 maillist INTEGER1 NOT NULL WITH DEFAULT,
127 grouplist INTEGER1 NOT NULL WITH DEFAULT,
128 gid SMALLINT NOT NULL WITH DEFAULT,
129 description CHAR(255) NOT NULL WITH DEFAULT,
130 acl_type CHAR(8) NOT NULL WITH DEFAULT,
131 acl_id INTEGER NOT NULL WITH DEFAULT,
132 modtime DATE NOT NULL WITH DEFAULT,
133 modby INTEGER NOT NULL WITH DEFAULT,
134 modwith CHAR(8) NOT NULL WITH DEFAULT
136 create table imembers
138 list_id INTEGER NOT NULL WITH DEFAULT,
139 member_type CHAR(8) NOT NULL WITH DEFAULT,
140 member_id INTEGER NOT NULL WITH DEFAULT,
141 ref_count SMALLINT NOT NULL WITH DEFAULT,
142 direct SMALLINT NOT NULL WITH DEFAULT
146 name VARCHAR(16) NOT NULL WITH DEFAULT,
147 update_int INTEGER NOT NULL WITH DEFAULT,
148 target_file CHAR(64) NOT NULL WITH DEFAULT,
149 script CHAR(128) NOT NULL WITH DEFAULT,
150 dfgen INTEGER NOT NULL WITH DEFAULT,
151 dfcheck INTEGER NOT NULL WITH DEFAULT,
152 type CHAR(8) NOT NULL WITH DEFAULT,
153 enable INTEGER1 NOT NULL WITH DEFAULT,
154 inprogress INTEGER1 NOT NULL WITH DEFAULT,
155 harderror INTEGER NOT NULL WITH DEFAULT,
156 errmsg CHAR(80) NOT NULL WITH DEFAULT,
157 acl_type CHAR(8) NOT NULL WITH DEFAULT,
158 acl_id INTEGER NOT NULL WITH DEFAULT,
159 modtime DATE NOT NULL WITH DEFAULT,
160 modby INTEGER NOT NULL WITH DEFAULT,
161 modwith CHAR(8) NOT NULL WITH DEFAULT
163 create table serverhosts
165 service VARCHAR(16) NOT NULL WITH DEFAULT,
166 mach_id INTEGER NOT NULL WITH DEFAULT,
167 success INTEGER1 NOT NULL WITH DEFAULT,
168 enable INTEGER1 NOT NULL WITH DEFAULT,
169 override INTEGER1 NOT NULL WITH DEFAULT,
170 inprogress INTEGER1 NOT NULL WITH DEFAULT,
171 hosterror INTEGER NOT NULL WITH DEFAULT,
172 hosterrmsg CHAR(80) NOT NULL WITH DEFAULT,
173 ltt INTEGER NOT NULL WITH DEFAULT,
174 lts INTEGER NOT NULL WITH DEFAULT,
175 value1 INTEGER NOT NULL WITH DEFAULT,
176 value2 INTEGER NOT NULL WITH DEFAULT,
177 value3 CHAR(32) NOT NULL WITH DEFAULT,
178 modtime DATE NOT NULL WITH DEFAULT,
179 modby INTEGER NOT NULL WITH DEFAULT,
180 modwith CHAR(8) NOT NULL WITH DEFAULT
184 filsys_id INTEGER NOT NULL WITH DEFAULT,
185 phys_id INTEGER NOT NULL WITH DEFAULT,
186 label VARCHAR(32) NOT NULL WITH DEFAULT,
187 fs_order INTEGER2 NOT NULL WITH DEFAULT,
188 type CHAR(8) NOT NULL WITH DEFAULT,
189 mach_id INTEGER NOT NULL WITH DEFAULT,
190 name VARCHAR(80) NOT NULL WITH DEFAULT,
191 mount CHAR(32) NOT NULL WITH DEFAULT,
192 access CHAR(1) NOT NULL WITH DEFAULT,
193 comments CHAR(64) NOT NULL WITH DEFAULT,
194 owner INTEGER NOT NULL WITH DEFAULT,
195 owners INTEGER NOT NULL WITH DEFAULT,
196 createflg INTEGER1 NOT NULL WITH DEFAULT,
197 lockertype CHAR(8) NOT NULL WITH DEFAULT,
198 modtime DATE NOT NULL WITH DEFAULT,
199 modby INTEGER NOT NULL WITH DEFAULT,
200 modwith CHAR(8) NOT NULL WITH DEFAULT
204 group_id INTEGER NOT NULL WITH DEFAULT,
205 filsys_id INTEGER NOT NULL WITH DEFAULT,
206 key CHAR(8) NOT NULL WITH DEFAULT
210 nfsphys_id INTEGER NOT NULL WITH DEFAULT,
211 mach_id INTEGER NOT NULL WITH DEFAULT,
212 device CHAR(16) NOT NULL WITH DEFAULT,
213 dir VARCHAR(16) NOT NULL WITH DEFAULT,
214 status SMALLINT NOT NULL WITH DEFAULT,
215 allocated INTEGER NOT NULL WITH DEFAULT,
216 partsize INTEGER NOT NULL WITH DEFAULT,
217 modtime DATE NOT NULL WITH DEFAULT,
218 modby INTEGER NOT NULL WITH DEFAULT,
219 modwith CHAR(8) NOT NULL WITH DEFAULT
223 filsys_id INTEGER NOT NULL WITH DEFAULT,
224 type CHAR(8) NOT NULL WITH DEFAULT,
225 entity_id INTEGER NOT NULL WITH DEFAULT,
226 phys_id INTEGER NOT NULL WITH DEFAULT,
227 quota INTEGER NOT NULL WITH DEFAULT,
228 modtime DATE NOT NULL WITH DEFAULT,
229 modby INTEGER NOT NULL WITH DEFAULT,
230 modwith CHAR(8) NOT NULL WITH DEFAULT
234 class VARCHAR(16) NOT NULL WITH DEFAULT,
235 xmt_type CHAR(8) NOT NULL WITH DEFAULT,
236 xmt_id INTEGER NOT NULL WITH DEFAULT,
237 sub_type CHAR(8) NOT NULL WITH DEFAULT,
238 sub_id INTEGER NOT NULL WITH DEFAULT,
239 iws_type CHAR(8) NOT NULL WITH DEFAULT,
240 iws_id INTEGER NOT NULL WITH DEFAULT,
241 iui_type CHAR(8) NOT NULL WITH DEFAULT,
242 iui_id INTEGER NOT NULL WITH DEFAULT,
243 modtime DATE NOT NULL WITH DEFAULT,
244 modby INTEGER NOT NULL WITH DEFAULT,
245 modwith CHAR(8) NOT NULL WITH DEFAULT
247 create table hostaccess
249 mach_id INTEGER NOT NULL WITH DEFAULT,
250 acl_type CHAR(8) NOT NULL WITH DEFAULT,
251 acl_id INTEGER NOT NULL WITH DEFAULT,
252 modtime DATE NOT NULL WITH DEFAULT,
253 modby INTEGER NOT NULL WITH DEFAULT,
254 modwith CHAR(8) NOT NULL WITH DEFAULT
258 string_id INTEGER NOT NULL WITH DEFAULT,
259 string VARCHAR(128) NOT NULL WITH DEFAULT
261 create table services
263 name VARCHAR(16) NOT NULL WITH DEFAULT,
264 protocol CHAR(8) NOT NULL WITH DEFAULT,
265 port SMALLINT NOT NULL WITH DEFAULT,
266 description CHAR(64) NOT NULL WITH DEFAULT,
267 modtime DATE NOT NULL WITH DEFAULT,
268 modby INTEGER NOT NULL WITH DEFAULT,
269 modwith CHAR(8) NOT NULL WITH DEFAULT
271 create table printcap
273 name VARCHAR(16) NOT NULL WITH DEFAULT,
274 mach_id INTEGER NOT NULL WITH DEFAULT,
275 dir CHAR(32) NOT NULL WITH DEFAULT,
276 rp CHAR(16) NOT NULL WITH DEFAULT,
277 quotaserver INTEGER NOT NULL WITH DEFAULT,
278 auth INTEGER1 NOT NULL WITH DEFAULT,
279 price SMALLINT NOT NULL WITH DEFAULT,
280 comments CHAR(64) NOT NULL WITH DEFAULT,
281 modtime DATE NOT NULL WITH DEFAULT,
282 modby INTEGER NOT NULL WITH DEFAULT,
283 modwith CHAR(8) NOT NULL WITH DEFAULT
285 create table palladium
287 name VARCHAR(32) NOT NULL WITH DEFAULT,
288 ident INTEGER NOT NULL WITH DEFAULT,
289 mach_id INTEGER NOT NULL WITH DEFAULT,
290 modtime DATE NOT NULL WITH DEFAULT,
291 modby INTEGER NOT NULL WITH DEFAULT,
292 modwith CHAR(8) NOT NULL WITH DEFAULT
296 capability CHAR(32) NOT NULL WITH DEFAULT,
297 tag CHAR(4) NOT NULL WITH DEFAULT,
298 list_id INTEGER NOT NULL WITH DEFAULT
302 name VARCHAR(32) NOT NULL WITH DEFAULT,
303 type VARCHAR(16) NOT NULL WITH DEFAULT,
304 trans VARCHAR(128) NOT NULL WITH DEFAULT
306 create table numvalues
308 name VARCHAR(32) NOT NULL WITH DEFAULT,
309 value INTEGER NOT NULL WITH DEFAULT
311 create table tblstats
313 table_name CHAR(12) NOT NULL WITH DEFAULT,
314 modtime DATE NOT NULL WITH DEFAULT,
315 appends INTEGER NOT NULL WITH DEFAULT,
316 updates INTEGER NOT NULL WITH DEFAULT,
317 deletes INTEGER NOT NULL WITH DEFAULT
319 create table incremental
321 tablename CHAR(16) NOT NULL WITH DEFAULT,
322 service CHAR(16) NOT NULL WITH DEFAULT