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