]>
Commit | Line | Data |
---|---|---|
c6161d79 | 1 | create table users |
2 | ( | |
c345c1f9 | 3 | login VARCHAR(8) DEFAULT CHR(0) NOT NULL, |
c6161d79 | 4 | users_id INTEGER DEFAULT 0 NOT NULL, |
5 | unix_uid SMALLINT DEFAULT 0 NOT NULL, | |
c345c1f9 | 6 | shell VARCHAR(32) DEFAULT CHR(0) NOT NULL, |
c7333834 | 7 | winconsoleshell VARCHAR(32) DEFAULT 'cmd' NOT NULL, |
9281a4c3 | 8 | last VARCHAR(30) DEFAULT CHR(0) NOT NULL, |
9 | first VARCHAR(30) DEFAULT CHR(0) NOT NULL, | |
10 | middle VARCHAR(30) DEFAULT CHR(0) NOT NULL, | |
c6161d79 | 11 | status SMALLINT DEFAULT 0 NOT NULL, |
12 | clearid VARCHAR(16) DEFAULT CHR(0) NOT NULL, | |
c345c1f9 | 13 | type VARCHAR(8) DEFAULT CHR(0) NOT NULL, |
c6161d79 | 14 | comments INTEGER DEFAULT 0 NOT NULL, |
15 | modtime DATE DEFAULT SYSDATE NOT NULL, | |
16 | modby INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 17 | modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL, |
9281a4c3 | 18 | fullname VARCHAR(92) DEFAULT CHR(0) NOT NULL, |
c345c1f9 | 19 | nickname VARCHAR(16) DEFAULT CHR(0) NOT NULL, |
20 | home_addr VARCHAR(82) DEFAULT CHR(0) NOT NULL, | |
68d17ac6 | 21 | home_phone VARCHAR(24) DEFAULT CHR(0) NOT NULL, |
c345c1f9 | 22 | office_addr VARCHAR(16) DEFAULT CHR(0) NOT NULL, |
68d17ac6 | 23 | office_phone VARCHAR(24) DEFAULT CHR(0) NOT NULL, |
01cae672 | 24 | department VARCHAR(50) DEFAULT CHR(0) NOT NULL, |
c345c1f9 | 25 | affiliation VARCHAR(50) DEFAULT CHR(0) NOT NULL, |
c6161d79 | 26 | fmodtime DATE DEFAULT SYSDATE NOT NULL, |
27 | fmodby INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 28 | fmodwith VARCHAR(8) DEFAULT CHR(0) NOT NULL, |
29 | potype VARCHAR(8) DEFAULT CHR(0) NOT NULL, | |
c6161d79 | 30 | pop_id INTEGER DEFAULT 0 NOT NULL, |
7509f097 | 31 | imap_id INTEGER DEFAULT 0 NOT NULL, |
c6161d79 | 32 | box_id INTEGER DEFAULT 0 NOT NULL, |
33 | pmodtime DATE DEFAULT SYSDATE NOT NULL, | |
34 | pmodby INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 35 | pmodwith VARCHAR(8) DEFAULT CHR(0) NOT NULL, |
36 | xname VARCHAR(30) DEFAULT CHR(0) NOT NULL, | |
01cae672 | 37 | xdept VARCHAR(50) DEFAULT CHR(0) NOT NULL, |
c345c1f9 | 38 | xtitle VARCHAR(50) DEFAULT CHR(0) NOT NULL, |
39 | xaddress VARCHAR(82) DEFAULT CHR(0) NOT NULL, | |
68d17ac6 | 40 | xphone1 VARCHAR(24) DEFAULT CHR(0) NOT NULL, |
41 | xphone2 VARCHAR(24) DEFAULT CHR(0) NOT NULL, | |
c6161d79 | 42 | xmodtime DATE DEFAULT SYSDATE NOT NULL, |
43 | sigdate INTEGER DEFAULT 0 NOT NULL, | |
44 | sigwho INTEGER DEFAULT 0 NOT NULL, | |
45 | signature VARCHAR(68) DEFAULT CHR(0) NOT NULL, | |
46 | secure INTEGER DEFAULT 0 NOT NULL, | |
0aa10fc1 | 47 | reservations VARCHAR(10) DEFAULT CHR(0) NOT NULL, |
1792dbea | 48 | flag INTEGER DEFAULT 0 NOT NULL, |
49 | created DATE DEFAULT SYSDATE NOT NULL, | |
50 | creator INTEGER DEFAULT 0 NOT NULL | |
c6161d79 | 51 | ); |
52 | ||
53 | create table krbmap | |
54 | ( | |
55 | users_id INTEGER DEFAULT 0 NOT NULL, | |
56 | string_id INTEGER DEFAULT 0 NOT NULL | |
57 | ); | |
58 | ||
59 | create table machine | |
60 | ( | |
01c6a9e2 | 61 | name VARCHAR(255) DEFAULT CHR(0) NOT NULL, |
c6161d79 | 62 | mach_id INTEGER DEFAULT 0 NOT NULL, |
c345c1f9 | 63 | vendor VARCHAR(16) DEFAULT CHR(0) NOT NULL, |
64 | model VARCHAR(24) DEFAULT CHR(0) NOT NULL, | |
65 | os VARCHAR(16) DEFAULT CHR(0) NOT NULL, | |
66 | location VARCHAR(16) DEFAULT CHR(0) NOT NULL, | |
67 | contact VARCHAR(32) DEFAULT CHR(0) NOT NULL, | |
d007b6ba | 68 | billing_contact VARCHAR(32) DEFAULT CHR(0) NOT NULL, |
4f6b1a05 | 69 | account_number VARCHAR(10) DEFAULT CHR(0) NOT NULL, |
c6161d79 | 70 | use INTEGER DEFAULT 0 NOT NULL, |
71 | status INTEGER DEFAULT 0 NOT NULL, | |
72 | statuschange DATE DEFAULT SYSDATE NOT NULL, | |
73 | snet_id INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 74 | address VARCHAR(16) DEFAULT CHR(0) NOT NULL, |
0fead213 | 75 | hwaddr VARCHAR(12) DEFAULT CHR(0) NOT NULL, |
c345c1f9 | 76 | owner_type VARCHAR(8) DEFAULT CHR(0) NOT NULL, |
c6161d79 | 77 | owner_id INTEGER DEFAULT 0 NOT NULL, |
78 | acomment INTEGER DEFAULT 0 NOT NULL, | |
79 | ocomment INTEGER DEFAULT 0 NOT NULL, | |
80 | created DATE DEFAULT SYSDATE NOT NULL, | |
81 | creator INTEGER DEFAULT 0 NOT NULL, | |
82 | inuse DATE DEFAULT SYSDATE NOT NULL, | |
83 | modtime DATE DEFAULT SYSDATE NOT NULL, | |
84 | modby INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 85 | modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL |
c6161d79 | 86 | ); |
87 | ||
88 | create table hostalias | |
89 | ( | |
01c6a9e2 | 90 | name VARCHAR(255) DEFAULT CHR(0) NOT NULL, |
c6161d79 | 91 | mach_id INTEGER DEFAULT 0 NOT NULL |
92 | ); | |
93 | ||
94 | create table subnet | |
95 | ( | |
c345c1f9 | 96 | name VARCHAR(16) DEFAULT CHR(0) NOT NULL, |
c6161d79 | 97 | snet_id INTEGER DEFAULT 0 NOT NULL, |
98 | description VARCHAR(48) DEFAULT CHR(0) NOT NULL, | |
4f6b1a05 | 99 | status INTEGER DEFAULT 0 NOT NULL, |
100 | contact VARCHAR(32) DEFAULT CHR(0) NOT NULL, | |
101 | account_number VARCHAR(10) DEFAULT CHR(0) NOT NULL, | |
c6161d79 | 102 | saddr INTEGER DEFAULT 0 NOT NULL, |
103 | mask INTEGER DEFAULT 0 NOT NULL, | |
104 | low INTEGER DEFAULT 0 NOT NULL, | |
105 | high INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 106 | prefix VARCHAR(8) DEFAULT CHR(0) NOT NULL, |
107 | owner_type VARCHAR(8) DEFAULT CHR(0) NOT NULL, | |
c6161d79 | 108 | owner_id INTEGER DEFAULT 0 NOT NULL, |
109 | modtime DATE DEFAULT SYSDATE NOT NULL, | |
110 | modby INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 111 | modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL |
c6161d79 | 112 | ); |
113 | ||
114 | create table clusters | |
115 | ( | |
116 | name VARCHAR(32) DEFAULT CHR(0) NOT NULL, | |
117 | clu_id INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 118 | description VARCHAR(32) DEFAULT CHR(0) NOT NULL, |
119 | location VARCHAR(64) DEFAULT CHR(0) NOT NULL, | |
c6161d79 | 120 | modtime DATE DEFAULT SYSDATE NOT NULL, |
121 | modby INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 122 | modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL |
c6161d79 | 123 | ); |
124 | ||
125 | create table mcmap | |
126 | ( | |
127 | mach_id INTEGER DEFAULT 0 NOT NULL, | |
128 | clu_id INTEGER DEFAULT 0 NOT NULL | |
129 | ); | |
130 | ||
131 | create table svc | |
132 | ( | |
133 | clu_id INTEGER DEFAULT 0 NOT NULL, | |
134 | serv_label VARCHAR(16) DEFAULT CHR(0) NOT NULL, | |
2a04e22e | 135 | serv_cluster VARCHAR(128) DEFAULT CHR(0) NOT NULL |
c6161d79 | 136 | ); |
137 | ||
138 | create table list | |
139 | ( | |
140 | name VARCHAR(32) DEFAULT CHR(0) NOT NULL, | |
141 | list_id INTEGER DEFAULT 0 NOT NULL, | |
142 | active INTEGER DEFAULT 0 NOT NULL, | |
143 | publicflg INTEGER DEFAULT 0 NOT NULL, | |
144 | hidden INTEGER DEFAULT 0 NOT NULL, | |
145 | maillist INTEGER DEFAULT 0 NOT NULL, | |
146 | grouplist INTEGER DEFAULT 0 NOT NULL, | |
147 | gid SMALLINT DEFAULT 0 NOT NULL, | |
2a69e049 | 148 | nfsgroup INTEGER DEFAULT 0 NOT NULL, |
c345c1f9 | 149 | description VARCHAR(255) DEFAULT CHR(0) NOT NULL, |
150 | acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL, | |
c6161d79 | 151 | acl_id INTEGER DEFAULT 0 NOT NULL, |
faf02688 | 152 | memacl_type VARCHAR(8) DEFAULT 'NONE' NOT NULL, |
a7868226 | 153 | memacl_id INTEGER DEFAULT 0 NOT NULL, |
c6161d79 | 154 | modtime DATE DEFAULT SYSDATE NOT NULL, |
155 | modby INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 156 | modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL |
c6161d79 | 157 | ); |
158 | ||
159 | create table imembers | |
160 | ( | |
161 | list_id INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 162 | member_type VARCHAR(8) DEFAULT CHR(0) NOT NULL, |
c6161d79 | 163 | member_id INTEGER DEFAULT 0 NOT NULL, |
5debd42e | 164 | tag INTEGER DEFAULT 0 NOT NULL, |
c6161d79 | 165 | ref_count SMALLINT DEFAULT 0 NOT NULL, |
166 | direct SMALLINT DEFAULT 0 NOT NULL | |
167 | ); | |
168 | ||
169 | create table servers | |
170 | ( | |
171 | name VARCHAR(16) DEFAULT CHR(0) NOT NULL, | |
172 | update_int INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 173 | target_file VARCHAR(64) DEFAULT CHR(0) NOT NULL, |
174 | script VARCHAR(128) DEFAULT CHR(0) NOT NULL, | |
c6161d79 | 175 | dfgen INTEGER DEFAULT 0 NOT NULL, |
176 | dfcheck INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 177 | type VARCHAR(8) DEFAULT CHR(0) NOT NULL, |
c6161d79 | 178 | enable INTEGER DEFAULT 0 NOT NULL, |
179 | inprogress INTEGER DEFAULT 0 NOT NULL, | |
180 | harderror INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 181 | errmsg VARCHAR(80) DEFAULT CHR(0) NOT NULL, |
182 | acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL, | |
c6161d79 | 183 | acl_id INTEGER DEFAULT 0 NOT NULL, |
184 | modtime DATE DEFAULT SYSDATE NOT NULL, | |
185 | modby INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 186 | modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL |
c6161d79 | 187 | ); |
188 | ||
189 | create table serverhosts | |
190 | ( | |
191 | service VARCHAR(16) DEFAULT CHR(0) NOT NULL, | |
192 | mach_id INTEGER DEFAULT 0 NOT NULL, | |
193 | success INTEGER DEFAULT 0 NOT NULL, | |
194 | enable INTEGER DEFAULT 0 NOT NULL, | |
195 | override INTEGER DEFAULT 0 NOT NULL, | |
196 | inprogress INTEGER DEFAULT 0 NOT NULL, | |
197 | hosterror INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 198 | hosterrmsg VARCHAR(80) DEFAULT CHR(0) NOT NULL, |
c6161d79 | 199 | ltt INTEGER DEFAULT 0 NOT NULL, |
200 | lts INTEGER DEFAULT 0 NOT NULL, | |
201 | value1 INTEGER DEFAULT 0 NOT NULL, | |
202 | value2 INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 203 | value3 VARCHAR(32) DEFAULT CHR(0) NOT NULL, |
c6161d79 | 204 | modtime DATE DEFAULT SYSDATE NOT NULL, |
205 | modby INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 206 | modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL |
c6161d79 | 207 | ); |
208 | ||
209 | create table filesys | |
210 | ( | |
211 | filsys_id INTEGER DEFAULT 0 NOT NULL, | |
212 | phys_id INTEGER DEFAULT 0 NOT NULL, | |
213 | label VARCHAR(32) DEFAULT CHR(0) NOT NULL, | |
214 | fs_order INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 215 | type VARCHAR(8) DEFAULT CHR(0) NOT NULL, |
c6161d79 | 216 | mach_id INTEGER DEFAULT 0 NOT NULL, |
217 | name VARCHAR(80) DEFAULT CHR(0) NOT NULL, | |
c345c1f9 | 218 | mount VARCHAR(32) DEFAULT CHR(0) NOT NULL, |
c6161d79 | 219 | rwaccess CHAR(1) DEFAULT CHR(0) NOT NULL, |
c345c1f9 | 220 | comments VARCHAR(64) DEFAULT CHR(0) NOT NULL, |
c6161d79 | 221 | owner INTEGER DEFAULT 0 NOT NULL, |
222 | owners INTEGER DEFAULT 0 NOT NULL, | |
223 | createflg INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 224 | lockertype VARCHAR(8) DEFAULT CHR(0) NOT NULL, |
c6161d79 | 225 | modtime DATE DEFAULT SYSDATE NOT NULL, |
226 | modby INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 227 | modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL |
c6161d79 | 228 | ); |
229 | ||
230 | create table fsgroup | |
231 | ( | |
232 | group_id INTEGER DEFAULT 0 NOT NULL, | |
233 | filsys_id INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 234 | key VARCHAR(8) DEFAULT CHR(0) NOT NULL |
c6161d79 | 235 | ); |
236 | ||
237 | create table nfsphys | |
238 | ( | |
239 | nfsphys_id INTEGER DEFAULT 0 NOT NULL, | |
240 | mach_id INTEGER DEFAULT 0 NOT NULL, | |
7509f097 | 241 | device VARCHAR(32) DEFAULT CHR(0) NOT NULL, |
242 | dir VARCHAR(64) DEFAULT CHR(0) NOT NULL, | |
c6161d79 | 243 | status SMALLINT DEFAULT 0 NOT NULL, |
244 | allocated INTEGER DEFAULT 0 NOT NULL, | |
245 | partsize INTEGER DEFAULT 0 NOT NULL, | |
246 | modtime DATE DEFAULT SYSDATE NOT NULL, | |
247 | modby INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 248 | modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL |
c6161d79 | 249 | ); |
250 | ||
251 | create table quota | |
252 | ( | |
253 | filsys_id INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 254 | type VARCHAR(8) DEFAULT CHR(0) NOT NULL, |
c6161d79 | 255 | entity_id INTEGER DEFAULT 0 NOT NULL, |
256 | phys_id INTEGER DEFAULT 0 NOT NULL, | |
257 | quota INTEGER DEFAULT 0 NOT NULL, | |
258 | modtime DATE DEFAULT SYSDATE NOT NULL, | |
259 | modby INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 260 | modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL |
c6161d79 | 261 | ); |
262 | ||
263 | create table zephyr | |
264 | ( | |
265 | class VARCHAR(16) DEFAULT CHR(0) NOT NULL, | |
c345c1f9 | 266 | xmt_type VARCHAR(8) DEFAULT CHR(0) NOT NULL, |
c6161d79 | 267 | xmt_id INTEGER DEFAULT 0 NOT NULL, |
c345c1f9 | 268 | sub_type VARCHAR(8) DEFAULT CHR(0) NOT NULL, |
c6161d79 | 269 | sub_id INTEGER DEFAULT 0 NOT NULL, |
c345c1f9 | 270 | iws_type VARCHAR(8) DEFAULT CHR(0) NOT NULL, |
c6161d79 | 271 | iws_id INTEGER DEFAULT 0 NOT NULL, |
c345c1f9 | 272 | iui_type VARCHAR(8) DEFAULT CHR(0) NOT NULL, |
c6161d79 | 273 | iui_id INTEGER DEFAULT 0 NOT NULL, |
2fb84c10 | 274 | owner_type VARCHAR(8) DEFAULT 'NONE' NOT NULL, |
faf02688 | 275 | owner_id INTEGER DEFAULT 0 NOT NULL, |
c6161d79 | 276 | modtime DATE DEFAULT SYSDATE NOT NULL, |
277 | modby INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 278 | modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL |
c6161d79 | 279 | ); |
280 | ||
281 | create table hostaccess | |
282 | ( | |
283 | mach_id INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 284 | acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL, |
c6161d79 | 285 | acl_id INTEGER DEFAULT 0 NOT NULL, |
286 | modtime DATE DEFAULT SYSDATE NOT NULL, | |
287 | modby INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 288 | modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL |
c6161d79 | 289 | ); |
290 | ||
5debd42e | 291 | create table acl |
292 | ( | |
293 | mach_id INTEGER DEFAULT 0 NOT NULL, | |
294 | target VARCHAR(128) DEFAULT CHR(0) NOT NULL, | |
295 | kind VARCHAR(16) DEFAULT CHR(0) NOT NULL, | |
296 | list_id INTEGER DEFAULT 0 NOT NULL, | |
297 | modtime DATE DEFAULT SYSDATE NOT NULL, | |
298 | modby INTEGER DEFAULT 0 NOT NULL, | |
299 | modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL | |
300 | ); | |
301 | ||
c6161d79 | 302 | create table strings |
303 | ( | |
304 | string_id INTEGER DEFAULT 0 NOT NULL, | |
305 | string VARCHAR(128) DEFAULT CHR(0) NOT NULL | |
306 | ); | |
307 | ||
308 | create table services | |
309 | ( | |
310 | name VARCHAR(16) DEFAULT CHR(0) NOT NULL, | |
c345c1f9 | 311 | protocol VARCHAR(8) DEFAULT CHR(0) NOT NULL, |
c6161d79 | 312 | port SMALLINT DEFAULT 0 NOT NULL, |
c345c1f9 | 313 | description VARCHAR(64) DEFAULT CHR(0) NOT NULL, |
c6161d79 | 314 | modtime DATE DEFAULT SYSDATE NOT NULL, |
315 | modby INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 316 | modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL |
c6161d79 | 317 | ); |
318 | ||
0fead213 | 319 | create table printers |
c6161d79 | 320 | ( |
321 | name VARCHAR(16) DEFAULT CHR(0) NOT NULL, | |
0fead213 | 322 | type VARCHAR(8) DEFAULT CHR(0) NOT NULL, |
427fe83f | 323 | hwtype VARCHAR(16) DEFAULT CHR(0) NOT NULL, |
0fead213 | 324 | duplexname VARCHAR(16) DEFAULT CHR(0) NOT NULL, |
c6161d79 | 325 | mach_id INTEGER DEFAULT 0 NOT NULL, |
0fead213 | 326 | loghost INTEGER DEFAULT 0 NOT NULL, |
327 | rm INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 328 | rp VARCHAR(16) DEFAULT CHR(0) NOT NULL, |
0fead213 | 329 | rq INTEGER DEFAULT 0 NOT NULL, |
330 | ka SMALLINT DEFAULT 0 NOT NULL, | |
331 | pc SMALLINT DEFAULT 0 NOT NULL, | |
66ba52df | 332 | mc SMALLINT DEFAULT 0 NOT NULL, |
0fead213 | 333 | ac INTEGER DEFAULT 0 NOT NULL, |
334 | lpc_acl INTEGER DEFAULT 0 NOT NULL, | |
39de8ad2 | 335 | banner INTEGER DEFAULT 0 NOT NULL, |
0fead213 | 336 | location VARCHAR(64) DEFAULT CHR(0) NOT NULL, |
337 | contact VARCHAR(64) DEFAULT CHR(0) NOT NULL, | |
c6161d79 | 338 | modtime DATE DEFAULT SYSDATE NOT NULL, |
339 | modby INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 340 | modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL |
c6161d79 | 341 | ); |
342 | ||
120cd8f9 | 343 | create table printservers |
344 | ( | |
345 | mach_id INTEGER DEFAULT 0 NOT NULL, | |
346 | kind VARCHAR(8) DEFAULT CHR(0) NOT NULL, | |
347 | printer_types INTEGER DEFAULT 0 NOT NULL, | |
348 | owner_type VARCHAR(8) DEFAULT CHR(0) NOT NULL, | |
349 | owner_id INTEGER DEFAULT 0 NOT NULL, | |
350 | lpc_acl INTEGER DEFAULT 0 NOT NULL, | |
351 | modtime DATE DEFAULT SYSDATE NOT NULL, | |
352 | modby INTEGER DEFAULT 0 NOT NULL, | |
353 | modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL | |
354 | ); | |
355 | ||
c6161d79 | 356 | create table capacls |
357 | ( | |
c345c1f9 | 358 | capability VARCHAR(32) DEFAULT CHR(0) NOT NULL, |
359 | tag VARCHAR(4) DEFAULT CHR(0) NOT NULL, | |
c6161d79 | 360 | list_id INTEGER DEFAULT 0 NOT NULL |
361 | ); | |
362 | ||
363 | create table alias | |
364 | ( | |
365 | name VARCHAR(32) DEFAULT CHR(0) NOT NULL, | |
366 | type VARCHAR(16) DEFAULT CHR(0) NOT NULL, | |
367 | trans VARCHAR(128) DEFAULT CHR(0) NOT NULL | |
368 | ); | |
369 | ||
370 | create table numvalues | |
371 | ( | |
372 | name VARCHAR(32) DEFAULT CHR(0) NOT NULL, | |
373 | value INTEGER DEFAULT 0 NOT NULL | |
374 | ); | |
375 | ||
376 | create table tblstats | |
377 | ( | |
c345c1f9 | 378 | table_name VARCHAR(16) DEFAULT CHR(0) NOT NULL, |
c6161d79 | 379 | modtime DATE DEFAULT SYSDATE NOT NULL, |
380 | appends INTEGER DEFAULT 0 NOT NULL, | |
381 | updates INTEGER DEFAULT 0 NOT NULL, | |
382 | deletes INTEGER DEFAULT 0 NOT NULL | |
383 | ); | |
384 | ||
385 | create table incremental | |
386 | ( | |
c345c1f9 | 387 | table_name VARCHAR(16) DEFAULT CHR(0) NOT NULL, |
388 | service VARCHAR(16) DEFAULT CHR(0) NOT NULL | |
c6161d79 | 389 | ); |
de3d85c0 | 390 | |
391 | create table usersids | |
392 | ( | |
393 | users_id INTEGER DEFAULT 0 NOT NULL, | |
394 | sid VARCHAR(64) DEFAULT CHR(0) NOT NULL, | |
395 | created DATE DEFAULT SYSDATE NOT NULL | |
396 | ); | |
397 | ||
398 | create table listsids | |
399 | ( | |
400 | list_id INTEGER DEFAULT 0 NOT NULL, | |
401 | sid VARCHAR(64) DEFAULT CHR(0) NOT NULL, | |
402 | created DATE DEFAULT SYSDATE NOT NULL | |
403 | ); | |
327fb8c0 | 404 | |
405 | create table containers | |
406 | ( | |
c2cbb1dd | 407 | name VARCHAR(64) DEFAULT CHR(0) NOT NULL, |
327fb8c0 | 408 | cnt_id INTEGER DEFAULT 0 NOT NULL, |
409 | description VARCHAR(255) DEFAULT CHR(0) NOT NULL, | |
410 | location VARCHAR(64) DEFAULT CHR(0) NOT NULL, | |
411 | contact VARCHAR(32) DEFAULT CHR(0) NOT NULL, | |
412 | acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL, | |
413 | acl_id INTEGER DEFAULT 0 NOT NULL, | |
414 | memacl_type VARCHAR(8) DEFAULT 'NONE' NOT NULL, | |
415 | memacl_id INTEGER DEFAULT 0 NOT NULL, | |
416 | modtime DATE DEFAULT SYSDATE NOT NULL, | |
417 | modby INTEGER DEFAULT 0 NOT NULL, | |
418 | modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL | |
419 | ); | |
420 | ||
421 | create table mcntmap | |
422 | ( | |
423 | mach_id INTEGER DEFAULT 0 NOT NULL, | |
424 | cnt_id INTEGER DEFAULT 0 NOT NULL | |
425 | ); | |
4f6b1a05 | 426 | |
427 | create table accountnumbers | |
428 | ( | |
429 | account_number VARCHAR(10) DEFAULT CHR(0) NOT NULL | |
430 | ); |