]>
Commit | Line | Data |
---|---|---|
c6161d79 | 1 | create table users |
2 | ( | |
3 | login VARCHAR(8) DEFAULT CHR(0) NOT NULL, | |
4 | users_id INTEGER DEFAULT 0 NOT NULL, | |
5 | unix_uid SMALLINT DEFAULT 0 NOT NULL, | |
6 | shell CHAR(32) DEFAULT CHR(0) NOT NULL, | |
7 | last VARCHAR(16) DEFAULT CHR(0) NOT NULL, | |
8 | first VARCHAR(16) DEFAULT CHR(0) NOT NULL, | |
9 | middle CHAR(16) DEFAULT CHR(0) NOT NULL, | |
10 | status SMALLINT DEFAULT 0 NOT NULL, | |
11 | clearid VARCHAR(16) DEFAULT CHR(0) NOT NULL, | |
12 | type CHAR(8) DEFAULT CHR(0) NOT NULL, | |
13 | comments INTEGER DEFAULT 0 NOT NULL, | |
14 | modtime DATE DEFAULT SYSDATE NOT NULL, | |
15 | modby INTEGER DEFAULT 0 NOT NULL, | |
16 | modwith CHAR(8) DEFAULT CHR(0) NOT NULL, | |
17 | fullname CHAR(32) DEFAULT CHR(0) NOT NULL, | |
18 | nickname CHAR(16) DEFAULT CHR(0) NOT NULL, | |
19 | home_addr CHAR(82) DEFAULT CHR(0) NOT NULL, | |
20 | home_phone CHAR(16) DEFAULT CHR(0) NOT NULL, | |
21 | office_addr CHAR(16) DEFAULT CHR(0) NOT NULL, | |
22 | office_phone CHAR(12) DEFAULT CHR(0) NOT NULL, | |
23 | department CHAR(20) DEFAULT CHR(0) NOT NULL, | |
24 | affiliation CHAR(50) DEFAULT CHR(0) NOT NULL, | |
25 | fmodtime DATE DEFAULT SYSDATE NOT NULL, | |
26 | fmodby INTEGER DEFAULT 0 NOT NULL, | |
27 | fmodwith CHAR(8) DEFAULT CHR(0) NOT NULL, | |
28 | potype CHAR(8) DEFAULT CHR(0) NOT NULL, | |
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, | |
33 | pmodwith CHAR(8) DEFAULT CHR(0) NOT NULL, | |
34 | xname CHAR(30) DEFAULT CHR(0) NOT NULL, | |
35 | xdept CHAR(20) DEFAULT CHR(0) NOT NULL, | |
36 | xtitle CHAR(50) DEFAULT CHR(0) NOT NULL, | |
37 | xaddress CHAR(82) DEFAULT CHR(0) NOT NULL, | |
38 | xphone1 CHAR(12) DEFAULT CHR(0) NOT NULL, | |
39 | xphone2 CHAR(12) DEFAULT CHR(0) NOT NULL, | |
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 | ( | |
56 | name VARCHAR(40) DEFAULT CHR(0) NOT NULL, | |
57 | mach_id INTEGER DEFAULT 0 NOT NULL, | |
58 | vendor CHAR(16) DEFAULT CHR(0) NOT NULL, | |
59 | model CHAR(24) DEFAULT CHR(0) NOT NULL, | |
60 | os CHAR(16) DEFAULT CHR(0) NOT NULL, | |
61 | location CHAR(16) DEFAULT CHR(0) NOT NULL, | |
62 | contact CHAR(32) DEFAULT CHR(0) NOT NULL, | |
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, | |
67 | address CHAR(16) DEFAULT CHR(0) NOT NULL, | |
68 | owner_type CHAR(8) DEFAULT CHR(0) NOT NULL, | |
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, | |
77 | modwith CHAR(8) DEFAULT CHR(0) NOT NULL | |
78 | ); | |
79 | ||
80 | create table hostalias | |
81 | ( | |
82 | name VARCHAR(40) DEFAULT CHR(0) NOT NULL, | |
83 | mach_id INTEGER DEFAULT 0 NOT NULL | |
84 | ); | |
85 | ||
86 | create table subnet | |
87 | ( | |
88 | name CHAR(16) DEFAULT CHR(0) NOT NULL, | |
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, | |
95 | prefix CHAR(8) DEFAULT CHR(0) NOT NULL, | |
96 | owner_type CHAR(8) DEFAULT CHR(0) NOT NULL, | |
97 | owner_id INTEGER DEFAULT 0 NOT NULL, | |
98 | modtime DATE DEFAULT SYSDATE NOT NULL, | |
99 | modby INTEGER DEFAULT 0 NOT NULL, | |
100 | modwith CHAR(8) DEFAULT CHR(0) NOT NULL | |
101 | ); | |
102 | ||
103 | create table clusters | |
104 | ( | |
105 | name VARCHAR(32) DEFAULT CHR(0) NOT NULL, | |
106 | clu_id INTEGER DEFAULT 0 NOT NULL, | |
107 | description CHAR(32) DEFAULT CHR(0) NOT NULL, | |
108 | location CHAR(64) DEFAULT CHR(0) NOT NULL, | |
109 | modtime DATE DEFAULT SYSDATE NOT NULL, | |
110 | modby INTEGER DEFAULT 0 NOT NULL, | |
111 | modwith CHAR(8) DEFAULT CHR(0) NOT NULL | |
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, | |
124 | serv_cluster CHAR(32) DEFAULT CHR(0) NOT NULL | |
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, | |
137 | description CHAR(255) DEFAULT CHR(0) NOT NULL, | |
138 | acl_type CHAR(8) DEFAULT CHR(0) NOT NULL, | |
139 | acl_id INTEGER DEFAULT 0 NOT NULL, | |
140 | modtime DATE DEFAULT SYSDATE NOT NULL, | |
141 | modby INTEGER DEFAULT 0 NOT NULL, | |
142 | modwith CHAR(8) DEFAULT CHR(0) NOT NULL | |
143 | ); | |
144 | ||
145 | create table imembers | |
146 | ( | |
147 | list_id INTEGER DEFAULT 0 NOT NULL, | |
148 | member_type CHAR(8) DEFAULT CHR(0) NOT NULL, | |
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, | |
158 | target_file CHAR(64) DEFAULT CHR(0) NOT NULL, | |
159 | script CHAR(128) DEFAULT CHR(0) NOT NULL, | |
160 | dfgen INTEGER DEFAULT 0 NOT NULL, | |
161 | dfcheck INTEGER DEFAULT 0 NOT NULL, | |
162 | type CHAR(8) DEFAULT CHR(0) NOT NULL, | |
163 | enable INTEGER DEFAULT 0 NOT NULL, | |
164 | inprogress INTEGER DEFAULT 0 NOT NULL, | |
165 | harderror INTEGER DEFAULT 0 NOT NULL, | |
166 | errmsg CHAR(80) DEFAULT CHR(0) NOT NULL, | |
167 | acl_type CHAR(8) DEFAULT CHR(0) NOT NULL, | |
168 | acl_id INTEGER DEFAULT 0 NOT NULL, | |
169 | modtime DATE DEFAULT SYSDATE NOT NULL, | |
170 | modby INTEGER DEFAULT 0 NOT NULL, | |
171 | modwith CHAR(8) DEFAULT CHR(0) NOT NULL | |
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, | |
183 | hosterrmsg CHAR(80) DEFAULT CHR(0) NOT NULL, | |
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, | |
188 | value3 CHAR(32) DEFAULT CHR(0) NOT NULL, | |
189 | modtime DATE DEFAULT SYSDATE NOT NULL, | |
190 | modby INTEGER DEFAULT 0 NOT NULL, | |
191 | modwith CHAR(8) DEFAULT CHR(0) NOT NULL | |
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, | |
200 | type CHAR(8) DEFAULT CHR(0) NOT NULL, | |
201 | mach_id INTEGER DEFAULT 0 NOT NULL, | |
202 | name VARCHAR(80) DEFAULT CHR(0) NOT NULL, | |
203 | mount CHAR(32) DEFAULT CHR(0) NOT NULL, | |
204 | rwaccess CHAR(1) DEFAULT CHR(0) NOT NULL, | |
205 | comments CHAR(64) DEFAULT CHR(0) NOT NULL, | |
206 | owner INTEGER DEFAULT 0 NOT NULL, | |
207 | owners INTEGER DEFAULT 0 NOT NULL, | |
208 | createflg INTEGER DEFAULT 0 NOT NULL, | |
209 | lockertype CHAR(8) DEFAULT CHR(0) NOT NULL, | |
210 | modtime DATE DEFAULT SYSDATE NOT NULL, | |
211 | modby INTEGER DEFAULT 0 NOT NULL, | |
212 | modwith CHAR(8) DEFAULT CHR(0) NOT NULL | |
213 | ); | |
214 | ||
215 | create table fsgroup | |
216 | ( | |
217 | group_id INTEGER DEFAULT 0 NOT NULL, | |
218 | filsys_id INTEGER DEFAULT 0 NOT NULL, | |
219 | key CHAR(8) DEFAULT CHR(0) NOT NULL | |
220 | ); | |
221 | ||
222 | create table nfsphys | |
223 | ( | |
224 | nfsphys_id INTEGER DEFAULT 0 NOT NULL, | |
225 | mach_id INTEGER DEFAULT 0 NOT NULL, | |
226 | device CHAR(16) DEFAULT CHR(0) NOT NULL, | |
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, | |
233 | modwith CHAR(8) DEFAULT CHR(0) NOT NULL | |
234 | ); | |
235 | ||
236 | create table quota | |
237 | ( | |
238 | filsys_id INTEGER DEFAULT 0 NOT NULL, | |
239 | type CHAR(8) DEFAULT CHR(0) NOT NULL, | |
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, | |
245 | modwith CHAR(8) DEFAULT CHR(0) NOT NULL | |
246 | ); | |
247 | ||
248 | create table zephyr | |
249 | ( | |
250 | class VARCHAR(16) DEFAULT CHR(0) NOT NULL, | |
251 | xmt_type CHAR(8) DEFAULT CHR(0) NOT NULL, | |
252 | xmt_id INTEGER DEFAULT 0 NOT NULL, | |
253 | sub_type CHAR(8) DEFAULT CHR(0) NOT NULL, | |
254 | sub_id INTEGER DEFAULT 0 NOT NULL, | |
255 | iws_type CHAR(8) DEFAULT CHR(0) NOT NULL, | |
256 | iws_id INTEGER DEFAULT 0 NOT NULL, | |
257 | iui_type CHAR(8) DEFAULT CHR(0) NOT NULL, | |
258 | iui_id INTEGER DEFAULT 0 NOT NULL, | |
259 | modtime DATE DEFAULT SYSDATE NOT NULL, | |
260 | modby INTEGER DEFAULT 0 NOT NULL, | |
261 | modwith CHAR(8) DEFAULT CHR(0) NOT NULL | |
262 | ); | |
263 | ||
264 | create table hostaccess | |
265 | ( | |
266 | mach_id INTEGER DEFAULT 0 NOT NULL, | |
267 | acl_type CHAR(8) DEFAULT CHR(0) NOT NULL, | |
268 | acl_id INTEGER DEFAULT 0 NOT NULL, | |
269 | modtime DATE DEFAULT SYSDATE NOT NULL, | |
270 | modby INTEGER DEFAULT 0 NOT NULL, | |
271 | modwith CHAR(8) DEFAULT CHR(0) NOT NULL | |
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, | |
283 | protocol CHAR(8) DEFAULT CHR(0) NOT NULL, | |
284 | port SMALLINT DEFAULT 0 NOT NULL, | |
285 | description CHAR(64) DEFAULT CHR(0) NOT NULL, | |
286 | modtime DATE DEFAULT SYSDATE NOT NULL, | |
287 | modby INTEGER DEFAULT 0 NOT NULL, | |
288 | modwith CHAR(8) DEFAULT CHR(0) NOT NULL | |
289 | ); | |
290 | ||
291 | create table printcap | |
292 | ( | |
293 | name VARCHAR(16) DEFAULT CHR(0) NOT NULL, | |
294 | mach_id INTEGER DEFAULT 0 NOT NULL, | |
295 | dir CHAR(32) DEFAULT CHR(0) NOT NULL, | |
296 | rp CHAR(16) DEFAULT CHR(0) NOT NULL, | |
297 | quotaserver INTEGER DEFAULT 0 NOT NULL, | |
298 | auth INTEGER DEFAULT 0 NOT NULL, | |
299 | price SMALLINT DEFAULT 0 NOT NULL, | |
300 | comments CHAR(64) DEFAULT CHR(0) NOT NULL, | |
301 | modtime DATE DEFAULT SYSDATE NOT NULL, | |
302 | modby INTEGER DEFAULT 0 NOT NULL, | |
303 | modwith CHAR(8) DEFAULT CHR(0) NOT NULL | |
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, | |
313 | modwith CHAR(8) DEFAULT CHR(0) NOT NULL | |
314 | ); | |
315 | ||
316 | create table capacls | |
317 | ( | |
318 | capability CHAR(32) DEFAULT CHR(0) NOT NULL, | |
319 | tag CHAR(4) DEFAULT CHR(0) NOT NULL, | |
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 | ( | |
338 | table_name CHAR(16) DEFAULT CHR(0) NOT NULL, | |
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 | ( | |
347 | table_name CHAR(16) DEFAULT CHR(0) NOT NULL, | |
348 | service CHAR(16) DEFAULT CHR(0) NOT NULL | |
349 | ); |