r1537 + rearrnage RS poll management pages
[racktables] / install / init-structure.sql
1 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
2 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
3 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
4 /*!40101 SET NAMES utf8 */;
5 /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
6 /*!40103 SET TIME_ZONE='+00:00' */;
7 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
8 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
9 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
10 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
11
12 --
13 -- Table structure for table `Atom`
14 --
15
16 DROP TABLE IF EXISTS `Atom`;
17 CREATE TABLE `Atom` (
18 `molecule_id` int(10) unsigned default NULL,
19 `rack_id` int(10) unsigned default NULL,
20 `unit_no` int(10) unsigned default NULL,
21 `atom` enum('front','interior','rear') default NULL
22 ) ENGINE=MyISAM;
23
24 --
25 -- Table structure for table `Attribute`
26 --
27
28 DROP TABLE IF EXISTS `Attribute`;
29 CREATE TABLE `Attribute` (
30 `attr_id` int(10) unsigned NOT NULL auto_increment,
31 `attr_type` enum('string','uint','float','dict') default NULL,
32 `attr_name` char(64) default NULL,
33 PRIMARY KEY (`attr_id`),
34 UNIQUE KEY `attr_name` (`attr_name`)
35 ) ENGINE=MyISAM AUTO_INCREMENT=10000;
36
37 --
38 -- Table structure for table `AttributeMap`
39 --
40
41 DROP TABLE IF EXISTS `AttributeMap`;
42 CREATE TABLE `AttributeMap` (
43 `objtype_id` int(10) unsigned NOT NULL default '1',
44 `attr_id` int(10) unsigned NOT NULL default '1',
45 `chapter_no` int(10) unsigned NOT NULL,
46 UNIQUE KEY `objtype_id` (`objtype_id`,`attr_id`)
47 ) ENGINE=MyISAM;
48
49 --
50 -- Table structure for table `AttributeValue`
51 --
52
53 DROP TABLE IF EXISTS `AttributeValue`;
54 CREATE TABLE `AttributeValue` (
55 `object_id` int(10) unsigned default NULL,
56 `attr_id` int(10) unsigned default NULL,
57 `string_value` char(128) default NULL,
58 `uint_value` int(10) unsigned default NULL,
59 `float_value` float default NULL,
60 UNIQUE KEY `object_id` (`object_id`,`attr_id`)
61 ) ENGINE=MyISAM;
62
63 --
64 -- Table structure for table `Chapter`
65 --
66
67 DROP TABLE IF EXISTS `Chapter`;
68 CREATE TABLE `Chapter` (
69 `chapter_no` int(10) unsigned NOT NULL auto_increment,
70 `sticky` enum('yes','no') default 'no',
71 `chapter_name` char(128) NOT NULL,
72 PRIMARY KEY (`chapter_no`),
73 UNIQUE KEY `chapter_name` (`chapter_name`)
74 ) ENGINE=MyISAM AUTO_INCREMENT=10000;
75
76 --
77 -- Table structure for table `Dictionary`
78 --
79
80 DROP TABLE IF EXISTS `Dictionary`;
81 CREATE TABLE `Dictionary` (
82 `chapter_no` int(10) unsigned NOT NULL,
83 `dict_key` int(10) unsigned NOT NULL auto_increment,
84 `dict_value` char(128) default NULL,
85 PRIMARY KEY (`dict_key`),
86 UNIQUE KEY `chap_to_key` (`chapter_no`,`dict_key`),
87 UNIQUE KEY `chap_to_val` (`chapter_no`,`dict_value`)
88 ) ENGINE=MyISAM AUTO_INCREMENT=50000;
89
90 --
91 -- Table structure for table `IPAddress`
92 --
93
94 DROP TABLE IF EXISTS `IPAddress`;
95 CREATE TABLE `IPAddress` (
96 `ip` int(10) unsigned NOT NULL,
97 `name` char(255) NOT NULL,
98 `reserved` enum('yes','no') default NULL,
99 PRIMARY KEY (`ip`)
100 ) ENGINE=MyISAM;
101
102 --
103 -- Table structure for table `IPBonds`
104 --
105
106 DROP TABLE IF EXISTS `IPBonds`;
107 CREATE TABLE `IPBonds` (
108 `object_id` int(10) unsigned NOT NULL,
109 `ip` int(10) unsigned NOT NULL,
110 `name` char(255) NOT NULL,
111 `type` enum('regular','shared','virtual') default NULL,
112 PRIMARY KEY (`object_id`,`ip`)
113 ) ENGINE=MyISAM;
114
115 --
116 -- Table structure for table `IPLoadBalancer`
117 --
118
119 DROP TABLE IF EXISTS `IPLoadBalancer`;
120 CREATE TABLE `IPLoadBalancer` (
121 `object_id` int(10) unsigned default NULL,
122 `rspool_id` int(10) unsigned default NULL,
123 `vsconfig` text,
124 `rsconfig` text,
125 UNIQUE KEY `object_id` (`object_id`,`rspool_id`)
126 ) ENGINE=MyISAM;
127
128 --
129 -- Table structure for table `IPRSPool`
130 --
131
132 DROP TABLE IF EXISTS `IPRSPool`;
133 CREATE TABLE `IPRSPool` (
134 `id` int(10) unsigned NOT NULL auto_increment,
135 `vs_id` int(10) unsigned default NULL,
136 `name` char(255) default NULL,
137 `vsconfig` text,
138 `rsconfig` text,
139 PRIMARY KEY (`id`)
140 ) ENGINE=MyISAM;
141
142 --
143 -- Table structure for table `IPRanges`
144 --
145
146 DROP TABLE IF EXISTS `IPRanges`;
147 CREATE TABLE `IPRanges` (
148 `id` int(10) unsigned NOT NULL auto_increment,
149 `ip` int(10) unsigned NOT NULL,
150 `mask` int(10) unsigned NOT NULL,
151 `name` char(255) default NULL,
152 PRIMARY KEY (`id`)
153 ) ENGINE=MyISAM;
154
155 --
156 -- Table structure for table `IPRealServer`
157 --
158
159 DROP TABLE IF EXISTS `IPRealServer`;
160 CREATE TABLE `IPRealServer` (
161 `id` int(10) unsigned NOT NULL auto_increment,
162 `rsip` int(10) unsigned default NULL,
163 `rsport` smallint(5) unsigned default NULL,
164 `rspool_id` int(10) unsigned default NULL,
165 `rsconfig` text,
166 PRIMARY KEY (`id`),
167 UNIQUE KEY `endpoint` (`rsip`,`rsport`)
168 ) ENGINE=MyISAM;
169
170 --
171 -- Table structure for table `IPVirtualService`
172 --
173
174 DROP TABLE IF EXISTS `IPVirtualService`;
175 CREATE TABLE `IPVirtualService` (
176 `id` int(10) unsigned NOT NULL auto_increment,
177 `vip` int(10) unsigned default NULL,
178 `vport` smallint(5) unsigned default NULL,
179 `proto` enum('TCP','UDP') NOT NULL default 'TCP',
180 `name` char(255) default NULL,
181 `vsconfig` text,
182 `rsconfig` text,
183 PRIMARY KEY (`id`),
184 UNIQUE KEY `endpoint` (`vip`,`vport`,`proto`)
185 ) ENGINE=MyISAM;
186
187 --
188 -- Table structure for table `Link`
189 --
190
191 DROP TABLE IF EXISTS `Link`;
192 CREATE TABLE `Link` (
193 `porta` int(10) unsigned NOT NULL,
194 `portb` int(10) unsigned NOT NULL,
195 PRIMARY KEY (`porta`,`portb`),
196 UNIQUE KEY `porta` (`porta`),
197 UNIQUE KEY `portb` (`portb`)
198 ) ENGINE=MyISAM;
199
200 --
201 -- Table structure for table `Molecule`
202 --
203
204 DROP TABLE IF EXISTS `Molecule`;
205 CREATE TABLE `Molecule` (
206 `id` int(10) unsigned NOT NULL auto_increment,
207 PRIMARY KEY (`id`)
208 ) ENGINE=MyISAM;
209
210 --
211 -- Table structure for table `MountOperation`
212 --
213
214 DROP TABLE IF EXISTS `MountOperation`;
215 CREATE TABLE `MountOperation` (
216 `id` int(10) unsigned NOT NULL auto_increment,
217 `object_id` int(10) unsigned NOT NULL,
218 `ctime` timestamp NOT NULL,
219 `user_name` char(64) default NULL,
220 `old_molecule_id` int(10) unsigned default NULL,
221 `new_molecule_id` int(10) unsigned default NULL,
222 `comment` text,
223 PRIMARY KEY (`id`)
224 ) ENGINE=MyISAM;
225
226 --
227 -- Table structure for table `Port`
228 --
229
230 DROP TABLE IF EXISTS `Port`;
231 CREATE TABLE `Port` (
232 `id` int(10) unsigned NOT NULL auto_increment,
233 `object_id` int(10) unsigned NOT NULL,
234 `name` char(255) NOT NULL,
235 `type` int(10) unsigned NOT NULL,
236 `l2address` char(64) default NULL,
237 `reservation_comment` char(255) default NULL,
238 `label` char(255) default NULL,
239 PRIMARY KEY (`id`),
240 UNIQUE KEY `object_id` (`object_id`,`name`),
241 UNIQUE KEY `l2address` (`l2address`),
242 KEY `type` (`type`)
243 ) ENGINE=MyISAM;
244
245 --
246 -- Table structure for table `PortCompat`
247 --
248
249 DROP TABLE IF EXISTS `PortCompat`;
250 CREATE TABLE `PortCompat` (
251 `type1` int(10) unsigned NOT NULL,
252 `type2` int(10) unsigned NOT NULL,
253 KEY `type1` (`type1`),
254 KEY `type2` (`type2`)
255 ) ENGINE=MyISAM;
256
257 --
258 -- Table structure for table `PortForwarding`
259 --
260
261 DROP TABLE IF EXISTS `PortForwarding`;
262 CREATE TABLE `PortForwarding` (
263 `object_id` int(10) unsigned NOT NULL,
264 `proto` int(11) NOT NULL,
265 `localip` int(10) unsigned NOT NULL,
266 `localport` smallint(5) unsigned NOT NULL,
267 `remoteip` int(10) unsigned NOT NULL,
268 `remoteport` smallint(5) unsigned NOT NULL,
269 `description` char(255) default NULL,
270 PRIMARY KEY (`object_id`,`proto`,`localip`,`localport`,`remoteip`,`remoteport`),
271 KEY `localip` (`localip`),
272 KEY `remoteip` (`remoteip`),
273 KEY `object_id` (`object_id`)
274 ) ENGINE=MyISAM;
275
276 --
277 -- Table structure for table `Rack`
278 --
279
280 DROP TABLE IF EXISTS `Rack`;
281 CREATE TABLE `Rack` (
282 `id` int(10) unsigned NOT NULL auto_increment,
283 `name` char(255) default NULL,
284 `deleted` enum('yes','no') NOT NULL default 'no',
285 `row_id` int(10) unsigned NOT NULL default '1',
286 `height` tinyint(3) unsigned NOT NULL default '42',
287 `comment` text,
288 `thumb_data` blob,
289 PRIMARY KEY (`id`)
290 ) ENGINE=MyISAM;
291
292 --
293 -- Table structure for table `RackHistory`
294 --
295
296 DROP TABLE IF EXISTS `RackHistory`;
297 CREATE TABLE `RackHistory` (
298 `id` int(10) unsigned default NULL,
299 `name` char(255) default NULL,
300 `deleted` enum('yes','no') default NULL,
301 `row_id` int(10) unsigned default NULL,
302 `height` int(10) unsigned default NULL,
303 `comment` text,
304 `ctime` timestamp NOT NULL,
305 `user_name` char(64) default NULL
306 ) ENGINE=MyISAM;
307
308 --
309 -- Table structure for table `RackObject`
310 --
311
312 DROP TABLE IF EXISTS `RackObject`;
313 CREATE TABLE `RackObject` (
314 `id` int(10) unsigned NOT NULL auto_increment,
315 `name` char(255) default NULL,
316 `label` char(255) default NULL,
317 `barcode` char(16) default NULL,
318 `deleted` enum('yes','no') NOT NULL default 'no',
319 `objtype_id` int(10) unsigned NOT NULL default '1',
320 `asset_no` char(64) default NULL,
321 `has_problems` enum('yes','no') NOT NULL default 'no',
322 `comment` text,
323 PRIMARY KEY (`id`),
324 UNIQUE KEY `RackObject_asset_no` (`asset_no`),
325 UNIQUE KEY `name` (`name`),
326 UNIQUE KEY `barcode` (`barcode`)
327 ) ENGINE=MyISAM;
328
329 --
330 -- Table structure for table `RackObjectHistory`
331 --
332
333 DROP TABLE IF EXISTS `RackObjectHistory`;
334 CREATE TABLE `RackObjectHistory` (
335 `id` int(10) unsigned default NULL,
336 `name` char(255) default NULL,
337 `label` char(255) default NULL,
338 `barcode` char(16) default NULL,
339 `deleted` enum('yes','no') default NULL,
340 `objtype_id` int(10) unsigned default NULL,
341 `asset_no` char(64) default NULL,
342 `has_problems` enum('yes','no') NOT NULL default 'no',
343 `comment` text,
344 `ctime` timestamp NOT NULL,
345 `user_name` char(64) default NULL
346 ) ENGINE=MyISAM;
347
348 --
349 -- Table structure for table `RackSpace`
350 --
351
352 DROP TABLE IF EXISTS `RackSpace`;
353 CREATE TABLE `RackSpace` (
354 `rack_id` int(10) unsigned NOT NULL default '0',
355 `unit_no` int(10) unsigned NOT NULL default '0',
356 `atom` enum('front','interior','rear') NOT NULL default 'interior',
357 `state` enum('A','U','T','W') NOT NULL default 'A',
358 `object_id` int(10) unsigned default NULL,
359 `problem_id` int(10) unsigned default NULL,
360 PRIMARY KEY (`rack_id`,`unit_no`,`atom`)
361 ) ENGINE=MyISAM;
362
363 --
364 -- Table structure for table `UserAccount`
365 --
366
367 DROP TABLE IF EXISTS `UserAccount`;
368 CREATE TABLE `UserAccount` (
369 `user_id` int(10) unsigned NOT NULL auto_increment,
370 `user_name` char(64) NOT NULL,
371 `user_enabled` enum('yes','no') NOT NULL default 'no',
372 `user_password_hash` char(128) default NULL,
373 `user_realname` char(64) default NULL,
374 PRIMARY KEY (`user_id`),
375 UNIQUE KEY `user_name` (`user_name`)
376 ) ENGINE=MyISAM AUTO_INCREMENT=10000;
377
378 --
379 -- Table structure for table `UserPermission`
380 --
381
382 DROP TABLE IF EXISTS `UserPermission`;
383 CREATE TABLE `UserPermission` (
384 `user_id` int(10) unsigned NOT NULL default '0',
385 `page` char(64) NOT NULL default '%',
386 `tab` char(64) NOT NULL default '%',
387 `access` enum('yes','no') NOT NULL default 'no',
388 UNIQUE KEY `user_id` (`user_id`,`page`,`tab`)
389 ) ENGINE=MyISAM;
390
391 --
392 -- Table structure for table `Config`
393 --
394
395 DROP TABLE IF EXISTS `Config`;
396 CREATE TABLE `Config` (
397 `varname` char(32) NOT NULL,
398 `varvalue` char(64) NOT NULL,
399 `vartype` enum('string','uint') NOT NULL default 'string',
400 `emptyok` enum('yes','no') NOT NULL default 'no',
401 `is_hidden` enum('yes','no') NOT NULL default 'yes',
402 `description` text,
403 PRIMARY KEY (`varname`)
404 ) ENGINE=MyISAM;
405
406 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
407
408 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
409 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
410 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
411 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
412 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
413 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
414 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;