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 CHAR(16) NOT NULL WITH DEFAULT,
8 first CHAR(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,
46 searchlast VARCHAR(16) NOT NULL WITH DEFAULT,
47 searchfirst VARCHAR(16) NOT NULL WITH DEFAULT
51 users_id INTEGER NOT NULL WITH DEFAULT,
52 string_id INTEGER NOT NULL WITH DEFAULT
56 name VARCHAR(32) NOT NULL WITH DEFAULT,
57 mach_id INTEGER NOT NULL WITH DEFAULT,
58 type CHAR(8) NOT NULL WITH DEFAULT,
59 modtime DATE NOT NULL WITH DEFAULT,
60 modby INTEGER NOT NULL WITH DEFAULT,
61 modwith CHAR(8) NOT NULL WITH DEFAULT
65 name CHAR(32) NOT NULL WITH DEFAULT,
66 searchname VARCHAR(32) NOT NULL WITH DEFAULT,
67 clu_id INTEGER NOT NULL WITH DEFAULT,
68 description CHAR(32) NOT NULL WITH DEFAULT,
69 location CHAR(64) NOT NULL WITH DEFAULT,
70 modtime DATE NOT NULL WITH DEFAULT,
71 modby INTEGER NOT NULL WITH DEFAULT,
72 modwith CHAR(8) NOT NULL WITH DEFAULT
76 mach_id INTEGER NOT NULL WITH DEFAULT,
77 clu_id INTEGER NOT NULL WITH DEFAULT
81 clu_id INTEGER NOT NULL WITH DEFAULT,
82 serv_label VARCHAR(16) NOT NULL WITH DEFAULT,
83 serv_cluster CHAR(32) NOT NULL WITH DEFAULT
87 name CHAR(32) NOT NULL WITH DEFAULT,
88 searchname VARCHAR(32) NOT NULL WITH DEFAULT,
89 list_id INTEGER NOT NULL WITH DEFAULT,
90 active INTEGER1 NOT NULL WITH DEFAULT,
91 publicflg INTEGER1 NOT NULL WITH DEFAULT,
92 hidden INTEGER1 NOT NULL WITH DEFAULT,
93 maillist INTEGER1 NOT NULL WITH DEFAULT,
94 grouplist INTEGER1 NOT NULL WITH DEFAULT,
95 gid SMALLINT NOT NULL WITH DEFAULT,
96 description CHAR(255) NOT NULL WITH DEFAULT,
97 acl_type CHAR(8) NOT NULL WITH DEFAULT,
98 acl_id INTEGER NOT NULL WITH DEFAULT,
99 modtime DATE NOT NULL WITH DEFAULT,
100 modby INTEGER NOT NULL WITH DEFAULT,
101 modwith CHAR(8) NOT NULL WITH DEFAULT
103 create table imembers
105 list_id INTEGER NOT NULL WITH DEFAULT,
106 member_type CHAR(8) NOT NULL WITH DEFAULT,
107 member_id INTEGER NOT NULL WITH DEFAULT,
108 ref_count SMALLINT NOT NULL WITH DEFAULT,
109 direct SMALLINT NOT NULL WITH DEFAULT
113 name CHAR(16) NOT NULL WITH DEFAULT,
114 searchname VARCHAR(16) NOT NULL WITH DEFAULT,
115 update_int INTEGER NOT NULL WITH DEFAULT,
116 target_file CHAR(64) NOT NULL WITH DEFAULT,
117 script CHAR(128) NOT NULL WITH DEFAULT,
118 dfgen INTEGER NOT NULL WITH DEFAULT,
119 dfcheck INTEGER NOT NULL WITH DEFAULT,
120 type CHAR(8) NOT NULL WITH DEFAULT,
121 enable INTEGER1 NOT NULL WITH DEFAULT,
122 inprogress INTEGER1 NOT NULL WITH DEFAULT,
123 harderror INTEGER NOT NULL WITH DEFAULT,
124 errmsg CHAR(80) NOT NULL WITH DEFAULT,
125 acl_type CHAR(8) NOT NULL WITH DEFAULT,
126 acl_id INTEGER NOT NULL WITH DEFAULT,
127 modtime DATE NOT NULL WITH DEFAULT,
128 modby INTEGER NOT NULL WITH DEFAULT,
129 modwith CHAR(8) NOT NULL WITH DEFAULT
131 create table serverhosts
133 service CHAR(16) NOT NULL WITH DEFAULT,
134 searchservice VARCHAR(16) NOT NULL WITH DEFAULT,
135 mach_id INTEGER NOT NULL WITH DEFAULT,
136 success INTEGER1 NOT NULL WITH DEFAULT,
137 enable INTEGER1 NOT NULL WITH DEFAULT,
138 override INTEGER1 NOT NULL WITH DEFAULT,
139 inprogress INTEGER1 NOT NULL WITH DEFAULT,
140 hosterror INTEGER NOT NULL WITH DEFAULT,
141 hosterrmsg CHAR(80) NOT NULL WITH DEFAULT,
142 ltt INTEGER NOT NULL WITH DEFAULT,
143 lts INTEGER NOT NULL WITH DEFAULT,
144 value1 INTEGER NOT NULL WITH DEFAULT,
145 value2 INTEGER NOT NULL WITH DEFAULT,
146 value3 CHAR(32) NOT NULL WITH DEFAULT,
147 modtime DATE NOT NULL WITH DEFAULT,
148 modby INTEGER NOT NULL WITH DEFAULT,
149 modwith CHAR(8) NOT NULL WITH DEFAULT
153 filsys_id INTEGER NOT NULL WITH DEFAULT,
154 phys_id INTEGER NOT NULL WITH DEFAULT,
155 label CHAR(32) NOT NULL WITH DEFAULT,
156 searchlabel VARCHAR(32) NOT NULL WITH DEFAULT,
157 fs_order INTEGER2 NOT NULL WITH DEFAULT,
158 type CHAR(8) NOT NULL WITH DEFAULT,
159 mach_id INTEGER NOT NULL WITH DEFAULT,
160 name VARCHAR(80) NOT NULL WITH DEFAULT,
161 mount CHAR(32) NOT NULL WITH DEFAULT,
162 access CHAR(1) NOT NULL WITH DEFAULT,
163 comments CHAR(64) NOT NULL WITH DEFAULT,
164 owner INTEGER NOT NULL WITH DEFAULT,
165 owners INTEGER NOT NULL WITH DEFAULT,
166 createflg INTEGER1 NOT NULL WITH DEFAULT,
167 lockertype CHAR(8) NOT NULL WITH DEFAULT,
168 modtime DATE NOT NULL WITH DEFAULT,
169 modby INTEGER NOT NULL WITH DEFAULT,
170 modwith CHAR(8) NOT NULL WITH DEFAULT
174 group_id INTEGER NOT NULL WITH DEFAULT,
175 filsys_id INTEGER NOT NULL WITH DEFAULT,
176 key CHAR(8) NOT NULL WITH DEFAULT
180 nfsphys_id INTEGER NOT NULL WITH DEFAULT,
181 mach_id INTEGER NOT NULL WITH DEFAULT,
182 device CHAR(16) NOT NULL WITH DEFAULT,
183 dir VARCHAR(16) NOT NULL WITH DEFAULT,
184 status SMALLINT NOT NULL WITH DEFAULT,
185 allocated INTEGER NOT NULL WITH DEFAULT,
186 partsize INTEGER NOT NULL WITH DEFAULT,
187 modtime DATE NOT NULL WITH DEFAULT,
188 modby INTEGER NOT NULL WITH DEFAULT,
189 modwith CHAR(8) NOT NULL WITH DEFAULT
193 filsys_id INTEGER NOT NULL WITH DEFAULT,
194 type CHAR(8) NOT NULL WITH DEFAULT,
195 entity_id INTEGER NOT NULL WITH DEFAULT,
196 phys_id INTEGER NOT NULL WITH DEFAULT,
197 quota INTEGER 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 class VARCHAR(16) NOT NULL WITH DEFAULT,
205 xmt_type CHAR(8) NOT NULL WITH DEFAULT,
206 xmt_id INTEGER NOT NULL WITH DEFAULT,
207 sub_type CHAR(8) NOT NULL WITH DEFAULT,
208 sub_id INTEGER NOT NULL WITH DEFAULT,
209 iws_type CHAR(8) NOT NULL WITH DEFAULT,
210 iws_id INTEGER NOT NULL WITH DEFAULT,
211 iui_type CHAR(8) NOT NULL WITH DEFAULT,
212 iui_id INTEGER NOT NULL WITH DEFAULT,
213 modtime DATE NOT NULL WITH DEFAULT,
214 modby INTEGER NOT NULL WITH DEFAULT,
215 modwith CHAR(8) NOT NULL WITH DEFAULT
217 create table hostaccess
219 mach_id INTEGER NOT NULL WITH DEFAULT,
220 acl_type CHAR(8) NOT NULL WITH DEFAULT,
221 acl_id INTEGER NOT NULL WITH DEFAULT,
222 modtime DATE NOT NULL WITH DEFAULT,
223 modby INTEGER NOT NULL WITH DEFAULT,
224 modwith CHAR(8) NOT NULL WITH DEFAULT
228 string_id INTEGER NOT NULL WITH DEFAULT,
229 string VARCHAR(128) NOT NULL WITH DEFAULT
231 create table services
233 name CHAR(16) NOT NULL WITH DEFAULT,
234 searchname VARCHAR(16) NOT NULL WITH DEFAULT,
235 protocol CHAR(8) NOT NULL WITH DEFAULT,
236 port SMALLINT NOT NULL WITH DEFAULT,
237 description CHAR(64) NOT NULL WITH DEFAULT,
238 modtime DATE NOT NULL WITH DEFAULT,
239 modby INTEGER NOT NULL WITH DEFAULT,
240 modwith CHAR(8) NOT NULL WITH DEFAULT
242 create table printcap
244 name CHAR(16) NOT NULL WITH DEFAULT,
245 searchname VARCHAR(16) NOT NULL WITH DEFAULT,
246 mach_id INTEGER NOT NULL WITH DEFAULT,
247 dir CHAR(32) NOT NULL WITH DEFAULT,
248 rp CHAR(16) NOT NULL WITH DEFAULT,
249 quotaserver INTEGER NOT NULL WITH DEFAULT,
250 auth INTEGER1 NOT NULL WITH DEFAULT,
251 price SMALLINT NOT NULL WITH DEFAULT,
252 comments CHAR(64) 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
257 create table palladium
259 name VARCHAR(32) NOT NULL WITH DEFAULT,
260 ident INTEGER NOT NULL WITH DEFAULT,
261 mach_id INTEGER NOT NULL WITH DEFAULT,
262 modtime DATE NOT NULL WITH DEFAULT,
263 modby INTEGER NOT NULL WITH DEFAULT,
264 modwith CHAR(8) NOT NULL WITH DEFAULT
268 capability CHAR(32) NOT NULL WITH DEFAULT,
269 tag CHAR(4) NOT NULL WITH DEFAULT,
270 list_id INTEGER NOT NULL WITH DEFAULT
274 name VARCHAR(32) NOT NULL WITH DEFAULT,
275 type VARCHAR(16) NOT NULL WITH DEFAULT,
276 trans VARCHAR(128) NOT NULL WITH DEFAULT
278 create table numvalues
280 name VARCHAR(32) NOT NULL WITH DEFAULT,
281 value INTEGER NOT NULL WITH DEFAULT
283 create table tblstats
285 table_name CHAR(12) NOT NULL WITH DEFAULT,
286 modtime DATE NOT NULL WITH DEFAULT,
287 appends INTEGER NOT NULL WITH DEFAULT,
288 updates INTEGER NOT NULL WITH DEFAULT,
289 deletes INTEGER NOT NULL WITH DEFAULT
291 create table incremental
293 tablename CHAR(16) NOT NULL WITH DEFAULT,
294 service CHAR(16) NOT NULL WITH DEFAULT