]>
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, | |
56 | type CHAR(8) NOT NULL WITH DEFAULT, | |
57 | modtime DATE NOT NULL WITH DEFAULT, | |
58 | modby INTEGER NOT NULL WITH DEFAULT, | |
59 | modwith CHAR(8) NOT NULL WITH DEFAULT | |
49083d45 | 60 | ); |
07a40e5f | 61 | create table cluster |
fba90e28 | 62 | ( |
07a40e5f | 63 | name VARCHAR(32) NOT NULL WITH DEFAULT, |
64 | clu_id INTEGER NOT NULL WITH DEFAULT, | |
65 | description CHAR(32) NOT NULL WITH DEFAULT, | |
66 | location CHAR(64) NOT NULL WITH DEFAULT, | |
67 | modtime DATE NOT NULL WITH DEFAULT, | |
68 | modby INTEGER NOT NULL WITH DEFAULT, | |
69 | modwith CHAR(8) NOT NULL WITH DEFAULT | |
49083d45 | 70 | ); |
71 | create table mcmap | |
fba90e28 | 72 | ( |
07a40e5f | 73 | mach_id INTEGER NOT NULL WITH DEFAULT, |
74 | clu_id INTEGER NOT NULL WITH DEFAULT | |
49083d45 | 75 | ); |
07a40e5f | 76 | create table svc |
fba90e28 | 77 | ( |
07a40e5f | 78 | clu_id INTEGER NOT NULL WITH DEFAULT, |
79 | serv_label VARCHAR(16) NOT NULL WITH DEFAULT, | |
80 | serv_cluster CHAR(32) NOT NULL WITH DEFAULT | |
49083d45 | 81 | ); |
82 | create table list | |
fba90e28 | 83 | ( |
07a40e5f | 84 | name VARCHAR(32) NOT NULL WITH DEFAULT, |
85 | list_id INTEGER NOT NULL WITH DEFAULT, | |
86 | active INTEGER1 NOT NULL WITH DEFAULT, | |
87 | publicflg INTEGER1 NOT NULL WITH DEFAULT, | |
88 | hidden INTEGER1 NOT NULL WITH DEFAULT, | |
89 | maillist INTEGER1 NOT NULL WITH DEFAULT, | |
90 | grouplist INTEGER1 NOT NULL WITH DEFAULT, | |
91 | gid SMALLINT NOT NULL WITH DEFAULT, | |
92 | description CHAR(255) NOT NULL WITH DEFAULT, | |
93 | acl_type CHAR(8) NOT NULL WITH DEFAULT, | |
94 | acl_id INTEGER NOT NULL WITH DEFAULT, | |
95 | modtime DATE NOT NULL WITH DEFAULT, | |
96 | modby INTEGER NOT NULL WITH DEFAULT, | |
97 | modwith CHAR(8) NOT NULL WITH DEFAULT | |
49083d45 | 98 | ); |
99 | create table imembers | |
fba90e28 | 100 | ( |
07a40e5f | 101 | list_id INTEGER NOT NULL WITH DEFAULT, |
102 | member_type CHAR(8) NOT NULL WITH DEFAULT, | |
103 | member_id INTEGER NOT NULL WITH DEFAULT, | |
104 | ref_count SMALLINT NOT NULL WITH DEFAULT, | |
105 | direct SMALLINT NOT NULL WITH DEFAULT | |
49083d45 | 106 | ); |
107 | create table servers | |
fba90e28 | 108 | ( |
07a40e5f | 109 | name VARCHAR(16) NOT NULL WITH DEFAULT, |
110 | update_int INTEGER NOT NULL WITH DEFAULT, | |
111 | target_file CHAR(64) NOT NULL WITH DEFAULT, | |
112 | script CHAR(128) NOT NULL WITH DEFAULT, | |
113 | dfgen INTEGER NOT NULL WITH DEFAULT, | |
114 | dfcheck INTEGER NOT NULL WITH DEFAULT, | |
115 | type CHAR(8) NOT NULL WITH DEFAULT, | |
116 | enable INTEGER1 NOT NULL WITH DEFAULT, | |
117 | inprogress INTEGER1 NOT NULL WITH DEFAULT, | |
118 | harderror INTEGER NOT NULL WITH DEFAULT, | |
119 | errmsg CHAR(80) NOT NULL WITH DEFAULT, | |
120 | acl_type CHAR(8) NOT NULL WITH DEFAULT, | |
121 | acl_id INTEGER NOT NULL WITH DEFAULT, | |
122 | modtime DATE NOT NULL WITH DEFAULT, | |
123 | modby INTEGER NOT NULL WITH DEFAULT, | |
124 | modwith CHAR(8) NOT NULL WITH DEFAULT | |
49083d45 | 125 | ); |
126 | create table serverhosts | |
fba90e28 | 127 | ( |
07a40e5f | 128 | service VARCHAR(16) NOT NULL WITH DEFAULT, |
129 | mach_id INTEGER NOT NULL WITH DEFAULT, | |
130 | success INTEGER1 NOT NULL WITH DEFAULT, | |
131 | enable INTEGER1 NOT NULL WITH DEFAULT, | |
132 | override INTEGER1 NOT NULL WITH DEFAULT, | |
133 | inprogress INTEGER1 NOT NULL WITH DEFAULT, | |
134 | hosterror INTEGER NOT NULL WITH DEFAULT, | |
135 | hosterrmsg CHAR(80) NOT NULL WITH DEFAULT, | |
136 | ltt INTEGER NOT NULL WITH DEFAULT, | |
137 | lts INTEGER NOT NULL WITH DEFAULT, | |
138 | value1 INTEGER NOT NULL WITH DEFAULT, | |
139 | value2 INTEGER NOT NULL WITH DEFAULT, | |
140 | value3 CHAR(32) NOT NULL WITH DEFAULT, | |
141 | modtime DATE NOT NULL WITH DEFAULT, | |
142 | modby INTEGER NOT NULL WITH DEFAULT, | |
143 | modwith CHAR(8) NOT NULL WITH DEFAULT | |
49083d45 | 144 | ); |
145 | create table filesys | |
fba90e28 | 146 | ( |
07a40e5f | 147 | filsys_id INTEGER NOT NULL WITH DEFAULT, |
148 | phys_id INTEGER NOT NULL WITH DEFAULT, | |
149 | label VARCHAR(32) NOT NULL WITH DEFAULT, | |
150 | fs_order INTEGER2 NOT NULL WITH DEFAULT, | |
151 | type CHAR(8) NOT NULL WITH DEFAULT, | |
152 | mach_id INTEGER NOT NULL WITH DEFAULT, | |
153 | name VARCHAR(80) NOT NULL WITH DEFAULT, | |
154 | mount CHAR(32) NOT NULL WITH DEFAULT, | |
155 | access CHAR(1) NOT NULL WITH DEFAULT, | |
156 | comments CHAR(64) NOT NULL WITH DEFAULT, | |
157 | owner INTEGER NOT NULL WITH DEFAULT, | |
158 | owners INTEGER NOT NULL WITH DEFAULT, | |
159 | createflg INTEGER1 NOT NULL WITH DEFAULT, | |
160 | lockertype CHAR(8) NOT NULL WITH DEFAULT, | |
161 | modtime DATE NOT NULL WITH DEFAULT, | |
162 | modby INTEGER NOT NULL WITH DEFAULT, | |
163 | modwith CHAR(8) NOT NULL WITH DEFAULT | |
49083d45 | 164 | ); |
165 | create table fsgroup | |
fba90e28 | 166 | ( |
07a40e5f | 167 | group_id INTEGER NOT NULL WITH DEFAULT, |
168 | filsys_id INTEGER NOT NULL WITH DEFAULT, | |
169 | key CHAR(8) NOT NULL WITH DEFAULT | |
49083d45 | 170 | ); |
171 | create table nfsphys | |
fba90e28 | 172 | ( |
07a40e5f | 173 | nfsphys_id INTEGER NOT NULL WITH DEFAULT, |
174 | mach_id INTEGER NOT NULL WITH DEFAULT, | |
175 | device CHAR(16) NOT NULL WITH DEFAULT, | |
176 | dir VARCHAR(16) NOT NULL WITH DEFAULT, | |
177 | status SMALLINT NOT NULL WITH DEFAULT, | |
178 | allocated INTEGER NOT NULL WITH DEFAULT, | |
179 | partsize INTEGER NOT NULL WITH DEFAULT, | |
180 | modtime DATE NOT NULL WITH DEFAULT, | |
181 | modby INTEGER NOT NULL WITH DEFAULT, | |
182 | modwith CHAR(8) NOT NULL WITH DEFAULT | |
49083d45 | 183 | ); |
184 | create table quota | |
fba90e28 | 185 | ( |
07a40e5f | 186 | filsys_id INTEGER NOT NULL WITH DEFAULT, |
187 | type CHAR(8) NOT NULL WITH DEFAULT, | |
188 | entity_id INTEGER NOT NULL WITH DEFAULT, | |
189 | phys_id INTEGER NOT NULL WITH DEFAULT, | |
190 | quota INTEGER NOT NULL WITH DEFAULT, | |
191 | modtime DATE NOT NULL WITH DEFAULT, | |
192 | modby INTEGER NOT NULL WITH DEFAULT, | |
193 | modwith CHAR(8) NOT NULL WITH DEFAULT | |
49083d45 | 194 | ); |
195 | create table zephyr | |
fba90e28 | 196 | ( |
07a40e5f | 197 | class VARCHAR(16) NOT NULL WITH DEFAULT, |
198 | xmt_type CHAR(8) NOT NULL WITH DEFAULT, | |
199 | xmt_id INTEGER NOT NULL WITH DEFAULT, | |
200 | sub_type CHAR(8) NOT NULL WITH DEFAULT, | |
201 | sub_id INTEGER NOT NULL WITH DEFAULT, | |
202 | iws_type CHAR(8) NOT NULL WITH DEFAULT, | |
203 | iws_id INTEGER NOT NULL WITH DEFAULT, | |
204 | iui_type CHAR(8) NOT NULL WITH DEFAULT, | |
205 | iui_id INTEGER NOT NULL WITH DEFAULT, | |
206 | modtime DATE NOT NULL WITH DEFAULT, | |
207 | modby INTEGER NOT NULL WITH DEFAULT, | |
208 | modwith CHAR(8) NOT NULL WITH DEFAULT | |
49083d45 | 209 | ); |
210 | create table hostaccess | |
fba90e28 | 211 | ( |
07a40e5f | 212 | mach_id INTEGER NOT NULL WITH DEFAULT, |
213 | acl_type CHAR(8) NOT NULL WITH DEFAULT, | |
214 | acl_id INTEGER NOT NULL WITH DEFAULT, | |
215 | modtime DATE NOT NULL WITH DEFAULT, | |
216 | modby INTEGER NOT NULL WITH DEFAULT, | |
217 | modwith CHAR(8) NOT NULL WITH DEFAULT | |
49083d45 | 218 | ); |
219 | create table strings | |
fba90e28 | 220 | ( |
07a40e5f | 221 | string_id INTEGER NOT NULL WITH DEFAULT, |
222 | string VARCHAR(128) NOT NULL WITH DEFAULT | |
49083d45 | 223 | ); |
224 | create table services | |
fba90e28 | 225 | ( |
07a40e5f | 226 | name VARCHAR(16) NOT NULL WITH DEFAULT, |
227 | protocol CHAR(8) NOT NULL WITH DEFAULT, | |
228 | port SMALLINT NOT NULL WITH DEFAULT, | |
229 | description CHAR(64) NOT NULL WITH DEFAULT, | |
230 | modtime DATE NOT NULL WITH DEFAULT, | |
231 | modby INTEGER NOT NULL WITH DEFAULT, | |
232 | modwith CHAR(8) NOT NULL WITH DEFAULT | |
49083d45 | 233 | ); |
234 | create table printcap | |
fba90e28 | 235 | ( |
07a40e5f | 236 | name VARCHAR(16) NOT NULL WITH DEFAULT, |
237 | mach_id INTEGER NOT NULL WITH DEFAULT, | |
238 | dir CHAR(32) NOT NULL WITH DEFAULT, | |
239 | rp CHAR(16) NOT NULL WITH DEFAULT, | |
240 | quotaserver INTEGER NOT NULL WITH DEFAULT, | |
241 | auth INTEGER1 NOT NULL WITH DEFAULT, | |
242 | price SMALLINT NOT NULL WITH DEFAULT, | |
243 | comments CHAR(64) NOT NULL WITH DEFAULT, | |
244 | modtime DATE NOT NULL WITH DEFAULT, | |
245 | modby INTEGER NOT NULL WITH DEFAULT, | |
246 | modwith CHAR(8) NOT NULL WITH DEFAULT | |
49083d45 | 247 | ); |
248 | create table palladium | |
fba90e28 | 249 | ( |
07a40e5f | 250 | name VARCHAR(32) NOT NULL WITH DEFAULT, |
251 | ident INTEGER NOT NULL WITH DEFAULT, | |
252 | mach_id INTEGER NOT NULL WITH DEFAULT, | |
253 | modtime DATE NOT NULL WITH DEFAULT, | |
254 | modby INTEGER NOT NULL WITH DEFAULT, | |
255 | modwith CHAR(8) NOT NULL WITH DEFAULT | |
49083d45 | 256 | ); |
257 | create table capacls | |
fba90e28 | 258 | ( |
07a40e5f | 259 | capability CHAR(32) NOT NULL WITH DEFAULT, |
260 | tag CHAR(4) NOT NULL WITH DEFAULT, | |
261 | list_id INTEGER NOT NULL WITH DEFAULT | |
49083d45 | 262 | ); |
263 | create table alias | |
fba90e28 | 264 | ( |
07a40e5f | 265 | name VARCHAR(32) NOT NULL WITH DEFAULT, |
266 | type VARCHAR(16) NOT NULL WITH DEFAULT, | |
267 | trans VARCHAR(128) NOT NULL WITH DEFAULT | |
49083d45 | 268 | ); |
269 | create table numvalues | |
fba90e28 | 270 | ( |
07a40e5f | 271 | name VARCHAR(32) NOT NULL WITH DEFAULT, |
272 | value INTEGER NOT NULL WITH DEFAULT | |
49083d45 | 273 | ); |
274 | create table tblstats | |
fba90e28 | 275 | ( |
07a40e5f | 276 | table_name CHAR(12) NOT NULL WITH DEFAULT, |
277 | modtime DATE NOT NULL WITH DEFAULT, | |
278 | appends INTEGER NOT NULL WITH DEFAULT, | |
279 | updates INTEGER NOT NULL WITH DEFAULT, | |
280 | deletes INTEGER NOT NULL WITH DEFAULT | |
49083d45 | 281 | ); |
282 | create table incremental | |
fba90e28 | 283 | ( |
07a40e5f | 284 | tablename CHAR(16) NOT NULL WITH DEFAULT, |
285 | service CHAR(16) NOT NULL WITH DEFAULT | |
49083d45 | 286 | ); |