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