]>
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, |
c6161d79 | 7 | last VARCHAR(16) DEFAULT CHR(0) NOT NULL, |
8 | first VARCHAR(16) DEFAULT CHR(0) NOT NULL, | |
c345c1f9 | 9 | middle VARCHAR(16) 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, |
17 | fullname VARCHAR(32) DEFAULT CHR(0) NOT NULL, | |
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, | |
23 | department VARCHAR(20) DEFAULT CHR(0) NOT NULL, | |
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, |
30 | box_id INTEGER DEFAULT 0 NOT NULL, | |
31 | pmodtime DATE DEFAULT SYSDATE NOT NULL, | |
32 | pmodby INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 33 | pmodwith VARCHAR(8) DEFAULT CHR(0) NOT NULL, |
34 | xname VARCHAR(30) DEFAULT CHR(0) NOT NULL, | |
35 | xdept VARCHAR(20) DEFAULT CHR(0) NOT NULL, | |
36 | xtitle VARCHAR(50) DEFAULT CHR(0) NOT NULL, | |
37 | xaddress VARCHAR(82) DEFAULT CHR(0) NOT NULL, | |
38 | xphone1 VARCHAR(12) DEFAULT CHR(0) NOT NULL, | |
39 | xphone2 VARCHAR(12) DEFAULT CHR(0) NOT NULL, | |
c6161d79 | 40 | xmodtime DATE DEFAULT SYSDATE NOT NULL, |
41 | sigdate INTEGER DEFAULT 0 NOT NULL, | |
42 | sigwho INTEGER DEFAULT 0 NOT NULL, | |
43 | signature VARCHAR(68) DEFAULT CHR(0) NOT NULL, | |
44 | secure INTEGER DEFAULT 0 NOT NULL, | |
45 | flag INTEGER DEFAULT 0 NOT NULL | |
46 | ); | |
47 | ||
48 | create table krbmap | |
49 | ( | |
50 | users_id INTEGER DEFAULT 0 NOT NULL, | |
51 | string_id INTEGER DEFAULT 0 NOT NULL | |
52 | ); | |
53 | ||
54 | create table machine | |
55 | ( | |
01c6a9e2 | 56 | name VARCHAR(255) DEFAULT CHR(0) NOT NULL, |
c6161d79 | 57 | mach_id INTEGER DEFAULT 0 NOT NULL, |
c345c1f9 | 58 | vendor VARCHAR(16) DEFAULT CHR(0) NOT NULL, |
59 | model VARCHAR(24) DEFAULT CHR(0) NOT NULL, | |
60 | os VARCHAR(16) DEFAULT CHR(0) NOT NULL, | |
61 | location VARCHAR(16) DEFAULT CHR(0) NOT NULL, | |
62 | contact VARCHAR(32) DEFAULT CHR(0) NOT NULL, | |
c6161d79 | 63 | use INTEGER DEFAULT 0 NOT NULL, |
64 | status INTEGER DEFAULT 0 NOT NULL, | |
65 | statuschange DATE DEFAULT SYSDATE NOT NULL, | |
66 | snet_id INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 67 | address VARCHAR(16) DEFAULT CHR(0) NOT NULL, |
68 | owner_type VARCHAR(8) DEFAULT CHR(0) NOT NULL, | |
c6161d79 | 69 | owner_id INTEGER DEFAULT 0 NOT NULL, |
70 | acomment INTEGER DEFAULT 0 NOT NULL, | |
71 | ocomment INTEGER DEFAULT 0 NOT NULL, | |
72 | created DATE DEFAULT SYSDATE NOT NULL, | |
73 | creator INTEGER DEFAULT 0 NOT NULL, | |
74 | inuse DATE DEFAULT SYSDATE NOT NULL, | |
75 | modtime DATE DEFAULT SYSDATE NOT NULL, | |
76 | modby INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 77 | modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL |
c6161d79 | 78 | ); |
79 | ||
80 | create table hostalias | |
81 | ( | |
01c6a9e2 | 82 | name VARCHAR(255) DEFAULT CHR(0) NOT NULL, |
c6161d79 | 83 | mach_id INTEGER DEFAULT 0 NOT NULL |
84 | ); | |
85 | ||
86 | create table subnet | |
87 | ( | |
c345c1f9 | 88 | name VARCHAR(16) DEFAULT CHR(0) NOT NULL, |
c6161d79 | 89 | snet_id INTEGER DEFAULT 0 NOT NULL, |
90 | description VARCHAR(48) DEFAULT CHR(0) NOT NULL, | |
91 | saddr INTEGER DEFAULT 0 NOT NULL, | |
92 | mask INTEGER DEFAULT 0 NOT NULL, | |
93 | low INTEGER DEFAULT 0 NOT NULL, | |
94 | high INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 95 | prefix VARCHAR(8) DEFAULT CHR(0) NOT NULL, |
96 | owner_type VARCHAR(8) DEFAULT CHR(0) NOT NULL, | |
c6161d79 | 97 | owner_id INTEGER DEFAULT 0 NOT NULL, |
98 | modtime DATE DEFAULT SYSDATE NOT NULL, | |
99 | modby INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 100 | modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL |
c6161d79 | 101 | ); |
102 | ||
103 | create table clusters | |
104 | ( | |
105 | name VARCHAR(32) DEFAULT CHR(0) NOT NULL, | |
106 | clu_id INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 107 | description VARCHAR(32) DEFAULT CHR(0) NOT NULL, |
108 | location VARCHAR(64) DEFAULT CHR(0) NOT NULL, | |
c6161d79 | 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 mcmap | |
115 | ( | |
116 | mach_id INTEGER DEFAULT 0 NOT NULL, | |
117 | clu_id INTEGER DEFAULT 0 NOT NULL | |
118 | ); | |
119 | ||
120 | create table svc | |
121 | ( | |
122 | clu_id INTEGER DEFAULT 0 NOT NULL, | |
123 | serv_label VARCHAR(16) DEFAULT CHR(0) NOT NULL, | |
c345c1f9 | 124 | serv_cluster VARCHAR(32) DEFAULT CHR(0) NOT NULL |
c6161d79 | 125 | ); |
126 | ||
127 | create table list | |
128 | ( | |
129 | name VARCHAR(32) DEFAULT CHR(0) NOT NULL, | |
130 | list_id INTEGER DEFAULT 0 NOT NULL, | |
131 | active INTEGER DEFAULT 0 NOT NULL, | |
132 | publicflg INTEGER DEFAULT 0 NOT NULL, | |
133 | hidden INTEGER DEFAULT 0 NOT NULL, | |
134 | maillist INTEGER DEFAULT 0 NOT NULL, | |
135 | grouplist INTEGER DEFAULT 0 NOT NULL, | |
136 | gid SMALLINT DEFAULT 0 NOT NULL, | |
c345c1f9 | 137 | description VARCHAR(255) DEFAULT CHR(0) NOT NULL, |
138 | acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL, | |
c6161d79 | 139 | acl_id INTEGER DEFAULT 0 NOT NULL, |
140 | modtime DATE DEFAULT SYSDATE NOT NULL, | |
141 | modby INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 142 | modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL |
c6161d79 | 143 | ); |
144 | ||
145 | create table imembers | |
146 | ( | |
147 | list_id INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 148 | member_type VARCHAR(8) DEFAULT CHR(0) NOT NULL, |
c6161d79 | 149 | member_id INTEGER DEFAULT 0 NOT NULL, |
150 | ref_count SMALLINT DEFAULT 0 NOT NULL, | |
151 | direct SMALLINT DEFAULT 0 NOT NULL | |
152 | ); | |
153 | ||
154 | create table servers | |
155 | ( | |
156 | name VARCHAR(16) DEFAULT CHR(0) NOT NULL, | |
157 | update_int INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 158 | target_file VARCHAR(64) DEFAULT CHR(0) NOT NULL, |
159 | script VARCHAR(128) DEFAULT CHR(0) NOT NULL, | |
c6161d79 | 160 | dfgen INTEGER DEFAULT 0 NOT NULL, |
161 | dfcheck INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 162 | type VARCHAR(8) DEFAULT CHR(0) NOT NULL, |
c6161d79 | 163 | enable INTEGER DEFAULT 0 NOT NULL, |
164 | inprogress INTEGER DEFAULT 0 NOT NULL, | |
165 | harderror INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 166 | errmsg VARCHAR(80) DEFAULT CHR(0) NOT NULL, |
167 | acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL, | |
c6161d79 | 168 | acl_id INTEGER DEFAULT 0 NOT NULL, |
169 | modtime DATE DEFAULT SYSDATE NOT NULL, | |
170 | modby INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 171 | modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL |
c6161d79 | 172 | ); |
173 | ||
174 | create table serverhosts | |
175 | ( | |
176 | service VARCHAR(16) DEFAULT CHR(0) NOT NULL, | |
177 | mach_id INTEGER DEFAULT 0 NOT NULL, | |
178 | success INTEGER DEFAULT 0 NOT NULL, | |
179 | enable INTEGER DEFAULT 0 NOT NULL, | |
180 | override INTEGER DEFAULT 0 NOT NULL, | |
181 | inprogress INTEGER DEFAULT 0 NOT NULL, | |
182 | hosterror INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 183 | hosterrmsg VARCHAR(80) DEFAULT CHR(0) NOT NULL, |
c6161d79 | 184 | ltt INTEGER DEFAULT 0 NOT NULL, |
185 | lts INTEGER DEFAULT 0 NOT NULL, | |
186 | value1 INTEGER DEFAULT 0 NOT NULL, | |
187 | value2 INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 188 | value3 VARCHAR(32) DEFAULT CHR(0) NOT NULL, |
c6161d79 | 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 filesys | |
195 | ( | |
196 | filsys_id INTEGER DEFAULT 0 NOT NULL, | |
197 | phys_id INTEGER DEFAULT 0 NOT NULL, | |
198 | label VARCHAR(32) DEFAULT CHR(0) NOT NULL, | |
199 | fs_order INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 200 | type VARCHAR(8) DEFAULT CHR(0) NOT NULL, |
c6161d79 | 201 | mach_id INTEGER DEFAULT 0 NOT NULL, |
202 | name VARCHAR(80) DEFAULT CHR(0) NOT NULL, | |
c345c1f9 | 203 | mount VARCHAR(32) DEFAULT CHR(0) NOT NULL, |
c6161d79 | 204 | rwaccess CHAR(1) DEFAULT CHR(0) NOT NULL, |
c345c1f9 | 205 | comments VARCHAR(64) DEFAULT CHR(0) NOT NULL, |
c6161d79 | 206 | owner INTEGER DEFAULT 0 NOT NULL, |
207 | owners INTEGER DEFAULT 0 NOT NULL, | |
208 | createflg INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 209 | lockertype VARCHAR(8) DEFAULT CHR(0) NOT NULL, |
c6161d79 | 210 | modtime DATE DEFAULT SYSDATE NOT NULL, |
211 | modby INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 212 | modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL |
c6161d79 | 213 | ); |
214 | ||
215 | create table fsgroup | |
216 | ( | |
217 | group_id INTEGER DEFAULT 0 NOT NULL, | |
218 | filsys_id INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 219 | key VARCHAR(8) DEFAULT CHR(0) NOT NULL |
c6161d79 | 220 | ); |
221 | ||
222 | create table nfsphys | |
223 | ( | |
224 | nfsphys_id INTEGER DEFAULT 0 NOT NULL, | |
225 | mach_id INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 226 | device VARCHAR(16) DEFAULT CHR(0) NOT NULL, |
c6161d79 | 227 | dir VARCHAR(16) DEFAULT CHR(0) NOT NULL, |
228 | status SMALLINT DEFAULT 0 NOT NULL, | |
229 | allocated INTEGER DEFAULT 0 NOT NULL, | |
230 | partsize INTEGER DEFAULT 0 NOT NULL, | |
231 | modtime DATE DEFAULT SYSDATE NOT NULL, | |
232 | modby INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 233 | modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL |
c6161d79 | 234 | ); |
235 | ||
236 | create table quota | |
237 | ( | |
238 | filsys_id INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 239 | type VARCHAR(8) DEFAULT CHR(0) NOT NULL, |
c6161d79 | 240 | entity_id INTEGER DEFAULT 0 NOT NULL, |
241 | phys_id INTEGER DEFAULT 0 NOT NULL, | |
242 | quota INTEGER DEFAULT 0 NOT NULL, | |
243 | modtime DATE DEFAULT SYSDATE NOT NULL, | |
244 | modby INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 245 | modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL |
c6161d79 | 246 | ); |
247 | ||
248 | create table zephyr | |
249 | ( | |
250 | class VARCHAR(16) DEFAULT CHR(0) NOT NULL, | |
c345c1f9 | 251 | xmt_type VARCHAR(8) DEFAULT CHR(0) NOT NULL, |
c6161d79 | 252 | xmt_id INTEGER DEFAULT 0 NOT NULL, |
c345c1f9 | 253 | sub_type VARCHAR(8) DEFAULT CHR(0) NOT NULL, |
c6161d79 | 254 | sub_id INTEGER DEFAULT 0 NOT NULL, |
c345c1f9 | 255 | iws_type VARCHAR(8) DEFAULT CHR(0) NOT NULL, |
c6161d79 | 256 | iws_id INTEGER DEFAULT 0 NOT NULL, |
c345c1f9 | 257 | iui_type VARCHAR(8) DEFAULT CHR(0) NOT NULL, |
c6161d79 | 258 | iui_id INTEGER DEFAULT 0 NOT NULL, |
259 | modtime DATE DEFAULT SYSDATE NOT NULL, | |
260 | modby INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 261 | modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL |
c6161d79 | 262 | ); |
263 | ||
264 | create table hostaccess | |
265 | ( | |
266 | mach_id INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 267 | acl_type VARCHAR(8) DEFAULT CHR(0) NOT NULL, |
c6161d79 | 268 | acl_id INTEGER DEFAULT 0 NOT NULL, |
269 | modtime DATE DEFAULT SYSDATE NOT NULL, | |
270 | modby INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 271 | modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL |
c6161d79 | 272 | ); |
273 | ||
274 | create table strings | |
275 | ( | |
276 | string_id INTEGER DEFAULT 0 NOT NULL, | |
277 | string VARCHAR(128) DEFAULT CHR(0) NOT NULL | |
278 | ); | |
279 | ||
280 | create table services | |
281 | ( | |
282 | name VARCHAR(16) DEFAULT CHR(0) NOT NULL, | |
c345c1f9 | 283 | protocol VARCHAR(8) DEFAULT CHR(0) NOT NULL, |
c6161d79 | 284 | port SMALLINT DEFAULT 0 NOT NULL, |
c345c1f9 | 285 | description VARCHAR(64) DEFAULT CHR(0) NOT NULL, |
c6161d79 | 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 | ||
291 | create table printcap | |
292 | ( | |
293 | name VARCHAR(16) DEFAULT CHR(0) NOT NULL, | |
294 | mach_id INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 295 | dir VARCHAR(32) DEFAULT CHR(0) NOT NULL, |
296 | rp VARCHAR(16) DEFAULT CHR(0) NOT NULL, | |
c6161d79 | 297 | quotaserver INTEGER DEFAULT 0 NOT NULL, |
298 | auth INTEGER DEFAULT 0 NOT NULL, | |
299 | price SMALLINT DEFAULT 0 NOT NULL, | |
c345c1f9 | 300 | comments 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 | ||
306 | create table palladium | |
307 | ( | |
308 | name VARCHAR(32) DEFAULT CHR(0) NOT NULL, | |
309 | identifier INTEGER DEFAULT 0 NOT NULL, | |
310 | mach_id INTEGER DEFAULT 0 NOT NULL, | |
311 | modtime DATE DEFAULT SYSDATE NOT NULL, | |
312 | modby INTEGER DEFAULT 0 NOT NULL, | |
c345c1f9 | 313 | modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL |
c6161d79 | 314 | ); |
315 | ||
316 | create table capacls | |
317 | ( | |
c345c1f9 | 318 | capability VARCHAR(32) DEFAULT CHR(0) NOT NULL, |
319 | tag VARCHAR(4) DEFAULT CHR(0) NOT NULL, | |
c6161d79 | 320 | list_id INTEGER DEFAULT 0 NOT NULL |
321 | ); | |
322 | ||
323 | create table alias | |
324 | ( | |
325 | name VARCHAR(32) DEFAULT CHR(0) NOT NULL, | |
326 | type VARCHAR(16) DEFAULT CHR(0) NOT NULL, | |
327 | trans VARCHAR(128) DEFAULT CHR(0) NOT NULL | |
328 | ); | |
329 | ||
330 | create table numvalues | |
331 | ( | |
332 | name VARCHAR(32) DEFAULT CHR(0) NOT NULL, | |
333 | value INTEGER DEFAULT 0 NOT NULL | |
334 | ); | |
335 | ||
336 | create table tblstats | |
337 | ( | |
c345c1f9 | 338 | table_name VARCHAR(16) DEFAULT CHR(0) NOT NULL, |
c6161d79 | 339 | modtime DATE DEFAULT SYSDATE NOT NULL, |
340 | appends INTEGER DEFAULT 0 NOT NULL, | |
341 | updates INTEGER DEFAULT 0 NOT NULL, | |
342 | deletes INTEGER DEFAULT 0 NOT NULL | |
343 | ); | |
344 | ||
345 | create table incremental | |
346 | ( | |
c345c1f9 | 347 | table_name VARCHAR(16) DEFAULT CHR(0) NOT NULL, |
348 | service VARCHAR(16) DEFAULT CHR(0) NOT NULL | |
c6161d79 | 349 | ); |