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