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(32) NOT NULL WITH DEFAULT,
55 mach_id INTEGER NOT NULL WITH DEFAULT,
56 type CHAR(8) NOT NULL WITH DEFAULT,
57 modtime DATE NOT NULL WITH DEFAULT,
58 modby INTEGER NOT NULL WITH DEFAULT,
59 modwith CHAR(8) NOT NULL WITH DEFAULT
63 name VARCHAR(32) NOT NULL WITH DEFAULT,
64 clu_id INTEGER NOT NULL WITH DEFAULT,
65 description CHAR(32) NOT NULL WITH DEFAULT,
66 location CHAR(64) NOT NULL WITH DEFAULT,
67 modtime DATE NOT NULL WITH DEFAULT,
68 modby INTEGER NOT NULL WITH DEFAULT,
69 modwith CHAR(8) NOT NULL WITH DEFAULT
73 mach_id INTEGER NOT NULL WITH DEFAULT,
74 clu_id INTEGER NOT NULL WITH DEFAULT
78 clu_id INTEGER NOT NULL WITH DEFAULT,
79 serv_label VARCHAR(16) NOT NULL WITH DEFAULT,
80 serv_cluster CHAR(32) NOT NULL WITH DEFAULT
84 name VARCHAR(32) NOT NULL WITH DEFAULT,
85 list_id INTEGER NOT NULL WITH DEFAULT,
86 active INTEGER1 NOT NULL WITH DEFAULT,
87 publicflg INTEGER1 NOT NULL WITH DEFAULT,
88 hidden INTEGER1 NOT NULL WITH DEFAULT,
89 maillist INTEGER1 NOT NULL WITH DEFAULT,
90 grouplist INTEGER1 NOT NULL WITH DEFAULT,
91 gid SMALLINT NOT NULL WITH DEFAULT,
92 description CHAR(255) NOT NULL WITH DEFAULT,
93 acl_type CHAR(8) NOT NULL WITH DEFAULT,
94 acl_id INTEGER NOT NULL WITH DEFAULT,
95 modtime DATE NOT NULL WITH DEFAULT,
96 modby INTEGER NOT NULL WITH DEFAULT,
97 modwith CHAR(8) NOT NULL WITH DEFAULT
101 list_id INTEGER NOT NULL WITH DEFAULT,
102 member_type CHAR(8) NOT NULL WITH DEFAULT,
103 member_id INTEGER NOT NULL WITH DEFAULT,
104 ref_count SMALLINT NOT NULL WITH DEFAULT,
105 direct SMALLINT NOT NULL WITH DEFAULT
109 name VARCHAR(16) NOT NULL WITH DEFAULT,
110 update_int INTEGER NOT NULL WITH DEFAULT,
111 target_file CHAR(64) NOT NULL WITH DEFAULT,
112 script CHAR(128) NOT NULL WITH DEFAULT,
113 dfgen INTEGER NOT NULL WITH DEFAULT,
114 dfcheck INTEGER NOT NULL WITH DEFAULT,
115 type CHAR(8) NOT NULL WITH DEFAULT,
116 enable INTEGER1 NOT NULL WITH DEFAULT,
117 inprogress INTEGER1 NOT NULL WITH DEFAULT,
118 harderror INTEGER NOT NULL WITH DEFAULT,
119 errmsg CHAR(80) NOT NULL WITH DEFAULT,
120 acl_type CHAR(8) NOT NULL WITH DEFAULT,
121 acl_id INTEGER NOT NULL WITH DEFAULT,
122 modtime DATE NOT NULL WITH DEFAULT,
123 modby INTEGER NOT NULL WITH DEFAULT,
124 modwith CHAR(8) NOT NULL WITH DEFAULT
126 create table serverhosts
128 service VARCHAR(16) NOT NULL WITH DEFAULT,
129 mach_id INTEGER NOT NULL WITH DEFAULT,
130 success INTEGER1 NOT NULL WITH DEFAULT,
131 enable INTEGER1 NOT NULL WITH DEFAULT,
132 override INTEGER1 NOT NULL WITH DEFAULT,
133 inprogress INTEGER1 NOT NULL WITH DEFAULT,
134 hosterror INTEGER NOT NULL WITH DEFAULT,
135 hosterrmsg CHAR(80) NOT NULL WITH DEFAULT,
136 ltt INTEGER NOT NULL WITH DEFAULT,
137 lts INTEGER NOT NULL WITH DEFAULT,
138 value1 INTEGER NOT NULL WITH DEFAULT,
139 value2 INTEGER NOT NULL WITH DEFAULT,
140 value3 CHAR(32) NOT NULL WITH DEFAULT,
141 modtime DATE NOT NULL WITH DEFAULT,
142 modby INTEGER NOT NULL WITH DEFAULT,
143 modwith CHAR(8) NOT NULL WITH DEFAULT
147 filsys_id INTEGER NOT NULL WITH DEFAULT,
148 phys_id INTEGER NOT NULL WITH DEFAULT,
149 label VARCHAR(32) NOT NULL WITH DEFAULT,
150 fs_order INTEGER2 NOT NULL WITH DEFAULT,
151 type CHAR(8) NOT NULL WITH DEFAULT,
152 mach_id INTEGER NOT NULL WITH DEFAULT,
153 name VARCHAR(80) NOT NULL WITH DEFAULT,
154 mount CHAR(32) NOT NULL WITH DEFAULT,
155 access CHAR(1) NOT NULL WITH DEFAULT,
156 comments CHAR(64) NOT NULL WITH DEFAULT,
157 owner INTEGER NOT NULL WITH DEFAULT,
158 owners INTEGER NOT NULL WITH DEFAULT,
159 createflg INTEGER1 NOT NULL WITH DEFAULT,
160 lockertype CHAR(8) NOT NULL WITH DEFAULT,
161 modtime DATE NOT NULL WITH DEFAULT,
162 modby INTEGER NOT NULL WITH DEFAULT,
163 modwith CHAR(8) NOT NULL WITH DEFAULT
167 group_id INTEGER NOT NULL WITH DEFAULT,
168 filsys_id INTEGER NOT NULL WITH DEFAULT,
169 key CHAR(8) NOT NULL WITH DEFAULT
173 nfsphys_id INTEGER NOT NULL WITH DEFAULT,
174 mach_id INTEGER NOT NULL WITH DEFAULT,
175 device CHAR(16) NOT NULL WITH DEFAULT,
176 dir VARCHAR(16) NOT NULL WITH DEFAULT,
177 status SMALLINT NOT NULL WITH DEFAULT,
178 allocated INTEGER NOT NULL WITH DEFAULT,
179 partsize INTEGER NOT NULL WITH DEFAULT,
180 modtime DATE NOT NULL WITH DEFAULT,
181 modby INTEGER NOT NULL WITH DEFAULT,
182 modwith CHAR(8) NOT NULL WITH DEFAULT
186 filsys_id INTEGER NOT NULL WITH DEFAULT,
187 type CHAR(8) NOT NULL WITH DEFAULT,
188 entity_id INTEGER NOT NULL WITH DEFAULT,
189 phys_id INTEGER NOT NULL WITH DEFAULT,
190 quota INTEGER NOT NULL WITH DEFAULT,
191 modtime DATE NOT NULL WITH DEFAULT,
192 modby INTEGER NOT NULL WITH DEFAULT,
193 modwith CHAR(8) NOT NULL WITH DEFAULT
197 class VARCHAR(16) NOT NULL WITH DEFAULT,
198 xmt_type CHAR(8) NOT NULL WITH DEFAULT,
199 xmt_id INTEGER NOT NULL WITH DEFAULT,
200 sub_type CHAR(8) NOT NULL WITH DEFAULT,
201 sub_id INTEGER NOT NULL WITH DEFAULT,
202 iws_type CHAR(8) NOT NULL WITH DEFAULT,
203 iws_id INTEGER NOT NULL WITH DEFAULT,
204 iui_type CHAR(8) NOT NULL WITH DEFAULT,
205 iui_id INTEGER NOT NULL WITH DEFAULT,
206 modtime DATE NOT NULL WITH DEFAULT,
207 modby INTEGER NOT NULL WITH DEFAULT,
208 modwith CHAR(8) NOT NULL WITH DEFAULT
210 create table hostaccess
212 mach_id INTEGER NOT NULL WITH DEFAULT,
213 acl_type CHAR(8) NOT NULL WITH DEFAULT,
214 acl_id INTEGER NOT NULL WITH DEFAULT,
215 modtime DATE NOT NULL WITH DEFAULT,
216 modby INTEGER NOT NULL WITH DEFAULT,
217 modwith CHAR(8) NOT NULL WITH DEFAULT
221 string_id INTEGER NOT NULL WITH DEFAULT,
222 string VARCHAR(128) NOT NULL WITH DEFAULT
224 create table services
226 name VARCHAR(16) NOT NULL WITH DEFAULT,
227 protocol CHAR(8) NOT NULL WITH DEFAULT,
228 port SMALLINT NOT NULL WITH DEFAULT,
229 description CHAR(64) NOT NULL WITH DEFAULT,
230 modtime DATE NOT NULL WITH DEFAULT,
231 modby INTEGER NOT NULL WITH DEFAULT,
232 modwith CHAR(8) NOT NULL WITH DEFAULT
234 create table printcap
236 name VARCHAR(16) NOT NULL WITH DEFAULT,
237 mach_id INTEGER NOT NULL WITH DEFAULT,
238 dir CHAR(32) NOT NULL WITH DEFAULT,
239 rp CHAR(16) NOT NULL WITH DEFAULT,
240 quotaserver INTEGER NOT NULL WITH DEFAULT,
241 auth INTEGER1 NOT NULL WITH DEFAULT,
242 price SMALLINT NOT NULL WITH DEFAULT,
243 comments CHAR(64) NOT NULL WITH DEFAULT,
244 modtime DATE NOT NULL WITH DEFAULT,
245 modby INTEGER NOT NULL WITH DEFAULT,
246 modwith CHAR(8) NOT NULL WITH DEFAULT
248 create table palladium
250 name VARCHAR(32) NOT NULL WITH DEFAULT,
251 ident INTEGER NOT NULL WITH DEFAULT,
252 mach_id INTEGER NOT NULL WITH DEFAULT,
253 modtime DATE NOT NULL WITH DEFAULT,
254 modby INTEGER NOT NULL WITH DEFAULT,
255 modwith CHAR(8) NOT NULL WITH DEFAULT
259 capability CHAR(32) NOT NULL WITH DEFAULT,
260 tag CHAR(4) NOT NULL WITH DEFAULT,
261 list_id INTEGER NOT NULL WITH DEFAULT
265 name VARCHAR(32) NOT NULL WITH DEFAULT,
266 type VARCHAR(16) NOT NULL WITH DEFAULT,
267 trans VARCHAR(128) NOT NULL WITH DEFAULT
269 create table numvalues
271 name VARCHAR(32) NOT NULL WITH DEFAULT,
272 value INTEGER NOT NULL WITH DEFAULT
274 create table tblstats
276 table_name CHAR(12) NOT NULL WITH DEFAULT,
277 modtime DATE NOT NULL WITH DEFAULT,
278 appends INTEGER NOT NULL WITH DEFAULT,
279 updates INTEGER NOT NULL WITH DEFAULT,
280 deletes INTEGER NOT NULL WITH DEFAULT
282 create table incremental
284 tablename CHAR(16) NOT NULL WITH DEFAULT,
285 service CHAR(16) NOT NULL WITH DEFAULT