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