]>
Commit | Line | Data |
---|---|---|
49083d45 | 1 | create table users |
fba90e28 | 2 | ( |
07a40e5f | 3 | login VARCHAR(8) NOT NULL WITH DEFAULT, |
4 | users_id INTEGER NOT NULL WITH DEFAULT, | |
5 | uid SMALLINT NOT NULL WITH DEFAULT, | |
6 | shell CHAR(32) NOT NULL WITH DEFAULT, | |
7 | last VARCHAR(16) NOT NULL WITH DEFAULT, | |
8 | first VARCHAR(16) NOT NULL WITH DEFAULT, | |
9 | middle CHAR(16) NOT NULL WITH DEFAULT, | |
10 | status SMALLINT NOT NULL WITH DEFAULT, | |
11 | clearid VARCHAR(16) NOT NULL WITH DEFAULT, | |
12 | type CHAR(8) NOT NULL WITH DEFAULT, | |
13 | comment INTEGER NOT NULL WITH DEFAULT, | |
14 | modtime DATE NOT NULL WITH DEFAULT, | |
15 | modby INTEGER NOT NULL WITH DEFAULT, | |
16 | modwith CHAR(8) NOT NULL WITH DEFAULT, | |
17 | fullname CHAR(32) NOT NULL WITH DEFAULT, | |
18 | nickname CHAR(16) NOT NULL WITH DEFAULT, | |
19 | home_addr CHAR(82) NOT NULL WITH DEFAULT, | |
20 | home_phone CHAR(16) NOT NULL WITH DEFAULT, | |
21 | office_addr CHAR(16) NOT NULL WITH DEFAULT, | |
22 | office_phone CHAR(12) NOT NULL WITH DEFAULT, | |
23 | department CHAR(20) NOT NULL WITH DEFAULT, | |
24 | affiliation CHAR(50) NOT NULL WITH DEFAULT, | |
25 | fmodtime DATE NOT NULL WITH DEFAULT, | |
26 | fmodby INTEGER NOT NULL WITH DEFAULT, | |
27 | fmodwith CHAR(8) NOT NULL WITH DEFAULT, | |
28 | potype CHAR(8) NOT NULL WITH DEFAULT, | |
29 | pop_id INTEGER NOT NULL WITH DEFAULT, | |
30 | box_id INTEGER NOT NULL WITH DEFAULT, | |
31 | pmodtime DATE NOT NULL WITH DEFAULT, | |
32 | pmodby INTEGER NOT NULL WITH DEFAULT, | |
33 | pmodwith CHAR(8) NOT NULL WITH DEFAULT, | |
34 | xname CHAR(30) NOT NULL WITH DEFAULT, | |
35 | xdept CHAR(20) NOT NULL WITH DEFAULT, | |
36 | xtitle CHAR(50) NOT NULL WITH DEFAULT, | |
37 | xaddress CHAR(82) NOT NULL WITH DEFAULT, | |
38 | xphone1 CHAR(12) NOT NULL WITH DEFAULT, | |
39 | xphone2 CHAR(12) NOT NULL WITH DEFAULT, | |
40 | xmodtime DATE NOT NULL WITH DEFAULT, | |
41 | sigdate INTEGER NOT NULL WITH DEFAULT, | |
42 | sigwho INTEGER NOT NULL WITH DEFAULT, | |
43 | signature VARCHAR(68) NOT NULL WITH DEFAULT, | |
44 | secure INTEGER NOT NULL WITH DEFAULT, | |
45 | flag INTEGER1 NOT NULL WITH DEFAULT | |
49083d45 | 46 | ); |
47 | create table krbmap | |
fba90e28 | 48 | ( |
07a40e5f | 49 | users_id INTEGER NOT NULL WITH DEFAULT, |
50 | string_id INTEGER NOT NULL WITH DEFAULT | |
49083d45 | 51 | ); |
52 | create table machine | |
fba90e28 | 53 | ( |
07a40e5f | 54 | name VARCHAR(32) NOT NULL WITH DEFAULT, |
55 | mach_id INTEGER NOT NULL WITH DEFAULT, | |
aae0481e | 56 | vendor CHAR(16) NOT NULL WITH DEFAULT, |
57 | model CHAR(24) NOT NULL WITH DEFAULT, | |
58 | os CHAR(16) NOT NULL WITH DEFAULT, | |
59 | location CHAR(16) NOT NULL WITH DEFAULT, | |
60 | contact CHAR(32) NOT NULL WITH DEFAULT, | |
61 | use INTEGER NOT NULL WITH DEFAULT, | |
62 | status INTEGER1 NOT NULL WITH DEFAULT, | |
63 | statuschange DATE NOT NULL WITH DEFAULT, | |
64 | snet_id INTEGER NOT NULL WITH DEFAULT, | |
65 | address CHAR(16) NOT NULL WITH DEFAULT, | |
66 | owner_type CHAR(8) NOT NULL WITH DEFAULT, | |
67 | owner_id INTEGER NOT NULL WITH DEFAULT, | |
68 | acomment INTEGER NOT NULL WITH DEFAULT, | |
69 | ocomment INTEGER NOT NULL WITH DEFAULT, | |
70 | created DATE NOT NULL WITH DEFAULT, | |
71 | creator INTEGER NOT NULL WITH DEFAULT, | |
72 | inuse DATE NOT NULL WITH DEFAULT, | |
07a40e5f | 73 | modtime DATE NOT NULL WITH DEFAULT, |
74 | modby INTEGER NOT NULL WITH DEFAULT, | |
75 | modwith CHAR(8) NOT NULL WITH DEFAULT | |
49083d45 | 76 | ); |
aae0481e | 77 | create table hostalias |
78 | ( | |
79 | name VARCHAR(32) NOT NULL WITH DEFAULT, | |
80 | mach_id INTEGER NOT NULL WITH DEFAULT | |
81 | ); | |
82 | create table subnet | |
83 | ( | |
84 | name CHAR(8) NOT NULL WITH DEFAULT, | |
85 | snet_id INTEGER NOT NULL WITH DEFAULT, | |
86 | description VARCHAR(32) NOT NULL WITH DEFAULT, | |
87 | address INTEGER NOT NULL WITH DEFAULT, | |
88 | mask INTEGER NOT NULL WITH DEFAULT, | |
89 | low INTEGER NOT NULL WITH DEFAULT, | |
90 | high INTEGER NOT NULL WITH DEFAULT, | |
91 | owner_type CHAR(8) NOT NULL WITH DEFAULT, | |
92 | owner_id INTEGER NOT NULL WITH DEFAULT, | |
93 | modtime DATE NOT NULL WITH DEFAULT, | |
94 | modby INTEGER NOT NULL WITH DEFAULT, | |
95 | modwith CHAR(8) NOT NULL WITH DEFAULT | |
96 | ); | |
07a40e5f | 97 | create table cluster |
fba90e28 | 98 | ( |
07a40e5f | 99 | name VARCHAR(32) NOT NULL WITH DEFAULT, |
100 | clu_id INTEGER NOT NULL WITH DEFAULT, | |
101 | description CHAR(32) NOT NULL WITH DEFAULT, | |
102 | location CHAR(64) NOT NULL WITH DEFAULT, | |
103 | modtime DATE NOT NULL WITH DEFAULT, | |
104 | modby INTEGER NOT NULL WITH DEFAULT, | |
105 | modwith CHAR(8) NOT NULL WITH DEFAULT | |
49083d45 | 106 | ); |
107 | create table mcmap | |
fba90e28 | 108 | ( |
07a40e5f | 109 | mach_id INTEGER NOT NULL WITH DEFAULT, |
110 | clu_id INTEGER NOT NULL WITH DEFAULT | |
49083d45 | 111 | ); |
07a40e5f | 112 | create table svc |
fba90e28 | 113 | ( |
07a40e5f | 114 | clu_id INTEGER NOT NULL WITH DEFAULT, |
115 | serv_label VARCHAR(16) NOT NULL WITH DEFAULT, | |
116 | serv_cluster CHAR(32) NOT NULL WITH DEFAULT | |
49083d45 | 117 | ); |
118 | create table list | |
fba90e28 | 119 | ( |
07a40e5f | 120 | name VARCHAR(32) NOT NULL WITH DEFAULT, |
121 | list_id INTEGER NOT NULL WITH DEFAULT, | |
122 | active INTEGER1 NOT NULL WITH DEFAULT, | |
123 | publicflg INTEGER1 NOT NULL WITH DEFAULT, | |
124 | hidden INTEGER1 NOT NULL WITH DEFAULT, | |
125 | maillist INTEGER1 NOT NULL WITH DEFAULT, | |
126 | grouplist INTEGER1 NOT NULL WITH DEFAULT, | |
127 | gid SMALLINT NOT NULL WITH DEFAULT, | |
128 | description CHAR(255) NOT NULL WITH DEFAULT, | |
129 | acl_type CHAR(8) NOT NULL WITH DEFAULT, | |
130 | acl_id INTEGER NOT NULL WITH DEFAULT, | |
131 | modtime DATE NOT NULL WITH DEFAULT, | |
132 | modby INTEGER NOT NULL WITH DEFAULT, | |
133 | modwith CHAR(8) NOT NULL WITH DEFAULT | |
49083d45 | 134 | ); |
135 | create table imembers | |
fba90e28 | 136 | ( |
07a40e5f | 137 | list_id INTEGER NOT NULL WITH DEFAULT, |
138 | member_type CHAR(8) NOT NULL WITH DEFAULT, | |
139 | member_id INTEGER NOT NULL WITH DEFAULT, | |
140 | ref_count SMALLINT NOT NULL WITH DEFAULT, | |
141 | direct SMALLINT NOT NULL WITH DEFAULT | |
49083d45 | 142 | ); |
143 | create table servers | |
fba90e28 | 144 | ( |
07a40e5f | 145 | name VARCHAR(16) NOT NULL WITH DEFAULT, |
146 | update_int INTEGER NOT NULL WITH DEFAULT, | |
147 | target_file CHAR(64) NOT NULL WITH DEFAULT, | |
148 | script CHAR(128) NOT NULL WITH DEFAULT, | |
149 | dfgen INTEGER NOT NULL WITH DEFAULT, | |
150 | dfcheck INTEGER NOT NULL WITH DEFAULT, | |
151 | type CHAR(8) NOT NULL WITH DEFAULT, | |
152 | enable INTEGER1 NOT NULL WITH DEFAULT, | |
153 | inprogress INTEGER1 NOT NULL WITH DEFAULT, | |
154 | harderror INTEGER NOT NULL WITH DEFAULT, | |
155 | errmsg CHAR(80) NOT NULL WITH DEFAULT, | |
156 | acl_type CHAR(8) NOT NULL WITH DEFAULT, | |
157 | acl_id INTEGER NOT NULL WITH DEFAULT, | |
158 | modtime DATE NOT NULL WITH DEFAULT, | |
159 | modby INTEGER NOT NULL WITH DEFAULT, | |
160 | modwith CHAR(8) NOT NULL WITH DEFAULT | |
49083d45 | 161 | ); |
162 | create table serverhosts | |
fba90e28 | 163 | ( |
07a40e5f | 164 | service VARCHAR(16) NOT NULL WITH DEFAULT, |
165 | mach_id INTEGER NOT NULL WITH DEFAULT, | |
166 | success INTEGER1 NOT NULL WITH DEFAULT, | |
167 | enable INTEGER1 NOT NULL WITH DEFAULT, | |
168 | override INTEGER1 NOT NULL WITH DEFAULT, | |
169 | inprogress INTEGER1 NOT NULL WITH DEFAULT, | |
170 | hosterror INTEGER NOT NULL WITH DEFAULT, | |
171 | hosterrmsg CHAR(80) NOT NULL WITH DEFAULT, | |
172 | ltt INTEGER NOT NULL WITH DEFAULT, | |
173 | lts INTEGER NOT NULL WITH DEFAULT, | |
174 | value1 INTEGER NOT NULL WITH DEFAULT, | |
175 | value2 INTEGER NOT NULL WITH DEFAULT, | |
176 | value3 CHAR(32) NOT NULL WITH DEFAULT, | |
177 | modtime DATE NOT NULL WITH DEFAULT, | |
178 | modby INTEGER NOT NULL WITH DEFAULT, | |
179 | modwith CHAR(8) NOT NULL WITH DEFAULT | |
49083d45 | 180 | ); |
181 | create table filesys | |
fba90e28 | 182 | ( |
07a40e5f | 183 | filsys_id INTEGER NOT NULL WITH DEFAULT, |
184 | phys_id INTEGER NOT NULL WITH DEFAULT, | |
185 | label VARCHAR(32) NOT NULL WITH DEFAULT, | |
186 | fs_order INTEGER2 NOT NULL WITH DEFAULT, | |
187 | type CHAR(8) NOT NULL WITH DEFAULT, | |
188 | mach_id INTEGER NOT NULL WITH DEFAULT, | |
189 | name VARCHAR(80) NOT NULL WITH DEFAULT, | |
190 | mount CHAR(32) NOT NULL WITH DEFAULT, | |
191 | access CHAR(1) NOT NULL WITH DEFAULT, | |
192 | comments CHAR(64) NOT NULL WITH DEFAULT, | |
193 | owner INTEGER NOT NULL WITH DEFAULT, | |
194 | owners INTEGER NOT NULL WITH DEFAULT, | |
195 | createflg INTEGER1 NOT NULL WITH DEFAULT, | |
196 | lockertype CHAR(8) NOT NULL WITH DEFAULT, | |
197 | modtime DATE NOT NULL WITH DEFAULT, | |
198 | modby INTEGER NOT NULL WITH DEFAULT, | |
199 | modwith CHAR(8) NOT NULL WITH DEFAULT | |
49083d45 | 200 | ); |
201 | create table fsgroup | |
fba90e28 | 202 | ( |
07a40e5f | 203 | group_id INTEGER NOT NULL WITH DEFAULT, |
204 | filsys_id INTEGER NOT NULL WITH DEFAULT, | |
205 | key CHAR(8) NOT NULL WITH DEFAULT | |
49083d45 | 206 | ); |
207 | create table nfsphys | |
fba90e28 | 208 | ( |
07a40e5f | 209 | nfsphys_id INTEGER NOT NULL WITH DEFAULT, |
210 | mach_id INTEGER NOT NULL WITH DEFAULT, | |
211 | device CHAR(16) NOT NULL WITH DEFAULT, | |
212 | dir VARCHAR(16) NOT NULL WITH DEFAULT, | |
213 | status SMALLINT NOT NULL WITH DEFAULT, | |
214 | allocated INTEGER NOT NULL WITH DEFAULT, | |
215 | partsize INTEGER NOT NULL WITH DEFAULT, | |
216 | modtime DATE NOT NULL WITH DEFAULT, | |
217 | modby INTEGER NOT NULL WITH DEFAULT, | |
218 | modwith CHAR(8) NOT NULL WITH DEFAULT | |
49083d45 | 219 | ); |
220 | create table quota | |
fba90e28 | 221 | ( |
07a40e5f | 222 | filsys_id INTEGER NOT NULL WITH DEFAULT, |
223 | type CHAR(8) NOT NULL WITH DEFAULT, | |
224 | entity_id INTEGER NOT NULL WITH DEFAULT, | |
225 | phys_id INTEGER NOT NULL WITH DEFAULT, | |
226 | quota INTEGER NOT NULL WITH DEFAULT, | |
227 | modtime DATE NOT NULL WITH DEFAULT, | |
228 | modby INTEGER NOT NULL WITH DEFAULT, | |
229 | modwith CHAR(8) NOT NULL WITH DEFAULT | |
49083d45 | 230 | ); |
231 | create table zephyr | |
fba90e28 | 232 | ( |
07a40e5f | 233 | class VARCHAR(16) NOT NULL WITH DEFAULT, |
234 | xmt_type CHAR(8) NOT NULL WITH DEFAULT, | |
235 | xmt_id INTEGER NOT NULL WITH DEFAULT, | |
236 | sub_type CHAR(8) NOT NULL WITH DEFAULT, | |
237 | sub_id INTEGER NOT NULL WITH DEFAULT, | |
238 | iws_type CHAR(8) NOT NULL WITH DEFAULT, | |
239 | iws_id INTEGER NOT NULL WITH DEFAULT, | |
240 | iui_type CHAR(8) NOT NULL WITH DEFAULT, | |
241 | iui_id INTEGER NOT NULL WITH DEFAULT, | |
242 | modtime DATE NOT NULL WITH DEFAULT, | |
243 | modby INTEGER NOT NULL WITH DEFAULT, | |
244 | modwith CHAR(8) NOT NULL WITH DEFAULT | |
49083d45 | 245 | ); |
246 | create table hostaccess | |
fba90e28 | 247 | ( |
07a40e5f | 248 | mach_id INTEGER NOT NULL WITH DEFAULT, |
249 | acl_type CHAR(8) NOT NULL WITH DEFAULT, | |
250 | acl_id INTEGER NOT NULL WITH DEFAULT, | |
251 | modtime DATE NOT NULL WITH DEFAULT, | |
252 | modby INTEGER NOT NULL WITH DEFAULT, | |
253 | modwith CHAR(8) NOT NULL WITH DEFAULT | |
49083d45 | 254 | ); |
255 | create table strings | |
fba90e28 | 256 | ( |
07a40e5f | 257 | string_id INTEGER NOT NULL WITH DEFAULT, |
258 | string VARCHAR(128) NOT NULL WITH DEFAULT | |
49083d45 | 259 | ); |
260 | create table services | |
fba90e28 | 261 | ( |
07a40e5f | 262 | name VARCHAR(16) NOT NULL WITH DEFAULT, |
263 | protocol CHAR(8) NOT NULL WITH DEFAULT, | |
264 | port SMALLINT NOT NULL WITH DEFAULT, | |
265 | description CHAR(64) NOT NULL WITH DEFAULT, | |
266 | modtime DATE NOT NULL WITH DEFAULT, | |
267 | modby INTEGER NOT NULL WITH DEFAULT, | |
268 | modwith CHAR(8) NOT NULL WITH DEFAULT | |
49083d45 | 269 | ); |
270 | create table printcap | |
fba90e28 | 271 | ( |
07a40e5f | 272 | name VARCHAR(16) NOT NULL WITH DEFAULT, |
273 | mach_id INTEGER NOT NULL WITH DEFAULT, | |
274 | dir CHAR(32) NOT NULL WITH DEFAULT, | |
275 | rp CHAR(16) NOT NULL WITH DEFAULT, | |
276 | quotaserver INTEGER NOT NULL WITH DEFAULT, | |
277 | auth INTEGER1 NOT NULL WITH DEFAULT, | |
278 | price SMALLINT NOT NULL WITH DEFAULT, | |
279 | comments CHAR(64) NOT NULL WITH DEFAULT, | |
280 | modtime DATE NOT NULL WITH DEFAULT, | |
281 | modby INTEGER NOT NULL WITH DEFAULT, | |
282 | modwith CHAR(8) NOT NULL WITH DEFAULT | |
49083d45 | 283 | ); |
284 | create table palladium | |
fba90e28 | 285 | ( |
07a40e5f | 286 | name VARCHAR(32) NOT NULL WITH DEFAULT, |
287 | ident INTEGER NOT NULL WITH DEFAULT, | |
288 | mach_id INTEGER NOT NULL WITH DEFAULT, | |
289 | modtime DATE NOT NULL WITH DEFAULT, | |
290 | modby INTEGER NOT NULL WITH DEFAULT, | |
291 | modwith CHAR(8) NOT NULL WITH DEFAULT | |
49083d45 | 292 | ); |
293 | create table capacls | |
fba90e28 | 294 | ( |
07a40e5f | 295 | capability CHAR(32) NOT NULL WITH DEFAULT, |
296 | tag CHAR(4) NOT NULL WITH DEFAULT, | |
297 | list_id INTEGER NOT NULL WITH DEFAULT | |
49083d45 | 298 | ); |
299 | create table alias | |
fba90e28 | 300 | ( |
07a40e5f | 301 | name VARCHAR(32) NOT NULL WITH DEFAULT, |
302 | type VARCHAR(16) NOT NULL WITH DEFAULT, | |
303 | trans VARCHAR(128) NOT NULL WITH DEFAULT | |
49083d45 | 304 | ); |
305 | create table numvalues | |
fba90e28 | 306 | ( |
07a40e5f | 307 | name VARCHAR(32) NOT NULL WITH DEFAULT, |
308 | value INTEGER NOT NULL WITH DEFAULT | |
49083d45 | 309 | ); |
310 | create table tblstats | |
fba90e28 | 311 | ( |
07a40e5f | 312 | table_name CHAR(12) NOT NULL WITH DEFAULT, |
313 | modtime DATE NOT NULL WITH DEFAULT, | |
314 | appends INTEGER NOT NULL WITH DEFAULT, | |
315 | updates INTEGER NOT NULL WITH DEFAULT, | |
316 | deletes INTEGER NOT NULL WITH DEFAULT | |
49083d45 | 317 | ); |
318 | create table incremental | |
fba90e28 | 319 | ( |
07a40e5f | 320 | tablename CHAR(16) NOT NULL WITH DEFAULT, |
321 | service CHAR(16) NOT NULL WITH DEFAULT | |
49083d45 | 322 | ); |