1 LOCK TABLES `
Attribute`
WRITE;
2 INSERT INTO `
Attribute`
(`attr_id`
, `attr_type`
, `attr_name`
) VALUES (1,'string','OEM S/N 1');
3 INSERT INTO `
Attribute`
(`attr_id`
, `attr_type`
, `attr_name`
) VALUES (2,'dict','HW type');
4 INSERT INTO `
Attribute`
(`attr_id`
, `attr_type`
, `attr_name`
) VALUES (3,'string','FQDN');
5 INSERT INTO `
Attribute`
(`attr_id`
, `attr_type`
, `attr_name`
) VALUES (4,'dict','SW type');
6 INSERT INTO `
Attribute`
(`attr_id`
, `attr_type`
, `attr_name`
) VALUES (5,'string','SW version');
7 INSERT INTO `
Attribute`
(`attr_id`
, `attr_type`
, `attr_name`
) VALUES (6,'uint','number of ports');
8 INSERT INTO `
Attribute`
(`attr_id`
, `attr_type`
, `attr_name`
) VALUES (7,'float','max. current, Ampers');
9 INSERT INTO `
Attribute`
(`attr_id`
, `attr_type`
, `attr_name`
) VALUES (8,'float','power load, percents');
10 INSERT INTO `
Attribute`
(`attr_id`
, `attr_type`
, `attr_name`
) VALUES (14,'string','contact person');
11 INSERT INTO `
Attribute`
(`attr_id`
, `attr_type`
, `attr_name`
) VALUES (13,'float','max power, Watts');
12 INSERT INTO `
Attribute`
(`attr_id`
, `attr_type`
, `attr_name`
) VALUES (16,'uint','flash memory, MB');
13 INSERT INTO `
Attribute`
(`attr_id`
, `attr_type`
, `attr_name`
) VALUES (17,'uint','DRAM, MB');
14 INSERT INTO `
Attribute`
(`attr_id`
, `attr_type`
, `attr_name`
) VALUES (18,'uint','CPU, MHz');
15 INSERT INTO `
Attribute`
(`attr_id`
, `attr_type`
, `attr_name`
) VALUES (20,'string','OEM S/N 2');
16 INSERT INTO `
Attribute`
(`attr_id`
, `attr_type`
, `attr_name`
) VALUES (21,'string','support contract expiration');
17 INSERT INTO `
Attribute`
(`attr_id`
, `attr_type`
, `attr_name`
) VALUES (22,'string','HW warranty expiration');
18 INSERT INTO `
Attribute`
(`attr_id`
, `attr_type`
, `attr_name`
) VALUES (24,'string','SW warranty expiration');
21 LOCK TABLES `AttributeMap`
WRITE;
22 INSERT INTO `AttributeMap`
(`objtype_id`
, `attr_id`
, `chapter_no`
) VALUES (4,1,0);
23 INSERT INTO `AttributeMap`
(`objtype_id`
, `attr_id`
, `chapter_no`
) VALUES (4,2,11);
24 INSERT INTO `AttributeMap`
(`objtype_id`
, `attr_id`
, `chapter_no`
) VALUES (4,3,0);
25 INSERT INTO `AttributeMap`
(`objtype_id`
, `attr_id`
, `chapter_no`
) VALUES (5,1,0);
26 INSERT INTO `AttributeMap`
(`objtype_id`
, `attr_id`
, `chapter_no`
) VALUES (12,1,0);
27 INSERT INTO `AttributeMap`
(`objtype_id`
, `attr_id`
, `chapter_no`
) VALUES (8,4,14);
28 INSERT INTO `AttributeMap`
(`objtype_id`
, `attr_id`
, `chapter_no`
) VALUES (8,5,0);
29 INSERT INTO `AttributeMap`
(`objtype_id`
, `attr_id`
, `chapter_no`
) VALUES (8,2,12);
30 INSERT INTO `AttributeMap`
(`objtype_id`
, `attr_id`
, `chapter_no`
) VALUES (4,4,13);
31 INSERT INTO `AttributeMap`
(`objtype_id`
, `attr_id`
, `chapter_no`
) VALUES (8,3,11);
32 INSERT INTO `AttributeMap`
(`objtype_id`
, `attr_id`
, `chapter_no`
) VALUES (7,3,11);
33 INSERT INTO `AttributeMap`
(`objtype_id`
, `attr_id`
, `chapter_no`
) VALUES (8,1,11);
34 INSERT INTO `AttributeMap`
(`objtype_id`
, `attr_id`
, `chapter_no`
) VALUES (8,14,18);
35 INSERT INTO `AttributeMap`
(`objtype_id`
, `attr_id`
, `chapter_no`
) VALUES (7,14,18);
36 INSERT INTO `AttributeMap`
(`objtype_id`
, `attr_id`
, `chapter_no`
) VALUES (4,21,18);
37 INSERT INTO `AttributeMap`
(`objtype_id`
, `attr_id`
, `chapter_no`
) VALUES (4,22,18);
38 INSERT INTO `AttributeMap`
(`objtype_id`
, `attr_id`
, `chapter_no`
) VALUES (4,14,15);
39 INSERT INTO `AttributeMap`
(`objtype_id`
, `attr_id`
, `chapter_no`
) VALUES (7,2,17);
40 INSERT INTO `AttributeMap`
(`objtype_id`
, `attr_id`
, `chapter_no`
) VALUES (7,4,16);
41 INSERT INTO `AttributeMap`
(`objtype_id`
, `attr_id`
, `chapter_no`
) VALUES (7,1,15);
42 INSERT INTO `AttributeMap`
(`objtype_id`
, `attr_id`
, `chapter_no`
) VALUES (7,5,15);
43 INSERT INTO `AttributeMap`
(`objtype_id`
, `attr_id`
, `chapter_no`
) VALUES (12,3,15);
44 INSERT INTO `AttributeMap`
(`objtype_id`
, `attr_id`
, `chapter_no`
) VALUES (9,6,15);
45 INSERT INTO `AttributeMap`
(`objtype_id`
, `attr_id`
, `chapter_no`
) VALUES (7,16,15);
46 INSERT INTO `AttributeMap`
(`objtype_id`
, `attr_id`
, `chapter_no`
) VALUES (7,17,15);
47 INSERT INTO `AttributeMap`
(`objtype_id`
, `attr_id`
, `chapter_no`
) VALUES (7,18,15);
48 INSERT INTO `AttributeMap`
(`objtype_id`
, `attr_id`
, `chapter_no`
) VALUES (8,16,15);
49 INSERT INTO `AttributeMap`
(`objtype_id`
, `attr_id`
, `chapter_no`
) VALUES (8,17,15);
50 INSERT INTO `AttributeMap`
(`objtype_id`
, `attr_id`
, `chapter_no`
) VALUES (8,18,15);
51 INSERT INTO `AttributeMap`
(`objtype_id`
, `attr_id`
, `chapter_no`
) VALUES (5,2,18);
52 INSERT INTO `AttributeMap`
(`objtype_id`
, `attr_id`
, `chapter_no`
) VALUES (6,2,19);
53 INSERT INTO `AttributeMap`
(`objtype_id`
, `attr_id`
, `chapter_no`
) VALUES (12,7,18);
54 INSERT INTO `AttributeMap`
(`objtype_id`
, `attr_id`
, `chapter_no`
) VALUES (12,13,18);
55 INSERT INTO `AttributeMap`
(`objtype_id`
, `attr_id`
, `chapter_no`
) VALUES (4,24,18);
56 INSERT INTO `AttributeMap`
(`objtype_id`
, `attr_id`
, `chapter_no`
) VALUES (12,8,18);
57 INSERT INTO `AttributeMap`
(`objtype_id`
, `attr_id`
, `chapter_no`
) VALUES (8,20,18);
58 INSERT INTO `AttributeMap`
(`objtype_id`
, `attr_id`
, `chapter_no`
) VALUES (12,20,18);
59 INSERT INTO `AttributeMap`
(`objtype_id`
, `attr_id`
, `chapter_no`
) VALUES (8,21,18);
60 INSERT INTO `AttributeMap`
(`objtype_id`
, `attr_id`
, `chapter_no`
) VALUES (8,22,18);
61 INSERT INTO `AttributeMap`
(`objtype_id`
, `attr_id`
, `chapter_no`
) VALUES (8,24,18);
62 INSERT INTO `AttributeMap`
(`objtype_id`
, `attr_id`
, `chapter_no`
) VALUES (7,24,18);
63 INSERT INTO `AttributeMap`
(`objtype_id`
, `attr_id`
, `chapter_no`
) VALUES (7,22,18);
64 INSERT INTO `AttributeMap`
(`objtype_id`
, `attr_id`
, `chapter_no`
) VALUES (7,21,18);
65 INSERT INTO `AttributeMap`
(`objtype_id`
, `attr_id`
, `chapter_no`
) VALUES (6,1,18);
66 INSERT INTO `AttributeMap`
(`objtype_id`
, `attr_id`
, `chapter_no`
) VALUES (6,20,18);
69 LOCK TABLES `Chapter`
WRITE;
70 INSERT INTO `Chapter`
(`chapter_no`
, `sticky`
, `chapter_name`
) VALUES (11,'no','server models');
71 INSERT INTO `Chapter`
(`chapter_no`
, `sticky`
, `chapter_name`
) VALUES (12,'no','switch models');
72 INSERT INTO `Chapter`
(`chapter_no`
, `sticky`
, `chapter_name`
) VALUES (13,'no','server OS type');
73 INSERT INTO `Chapter`
(`chapter_no`
, `sticky`
, `chapter_name`
) VALUES (14,'no','switch OS type');
74 INSERT INTO `Chapter`
(`chapter_no`
, `sticky`
, `chapter_name`
) VALUES (1,'yes','RackObjectType');
75 INSERT INTO `Chapter`
(`chapter_no`
, `sticky`
, `chapter_name`
) VALUES (2,'yes','PortType');
76 INSERT INTO `Chapter`
(`chapter_no`
, `sticky`
, `chapter_name`
) VALUES (3,'yes','RackRow');
77 INSERT INTO `Chapter`
(`chapter_no`
, `sticky`
, `chapter_name`
) VALUES (16,'no','router OS type');
78 INSERT INTO `Chapter`
(`chapter_no`
, `sticky`
, `chapter_name`
) VALUES (17,'no','router models');
79 INSERT INTO `Chapter`
(`chapter_no`
, `sticky`
, `chapter_name`
) VALUES (18,'no','disk array models');
80 INSERT INTO `Chapter`
(`chapter_no`
, `sticky`
, `chapter_name`
) VALUES (19,'no','tape library models');
81 INSERT INTO `Chapter`
(`chapter_no`
, `sticky`
, `chapter_name`
) VALUES (20,'yes','Protocols');
84 LOCK TABLES `PortCompat`
WRITE;
85 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (4,4);
86 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (5,5);
87 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (6,6);
88 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (7,7);
89 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (8,8);
90 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (9,9);
91 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (10,10);
92 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (11,11);
93 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (12,12);
94 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (13,13);
95 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (14,14);
96 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (15,15);
97 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (5,6);
98 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (6,5);
99 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (5,11);
100 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (11,5);
101 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (6,11);
102 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (11,6);
103 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (16,16);
104 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (7,8);
105 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (8,7);
106 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (9,10);
107 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (10,9);
108 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (12,13);
109 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (13,12);
110 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (14,15);
111 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (15,14);
112 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (17,17);
113 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (3,3);
114 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (4,4);
115 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (5,5);
116 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (6,6);
117 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (7,7);
118 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (8,8);
119 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (9,9);
120 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (10,10);
121 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (11,11);
122 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (12,12);
123 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (13,13);
124 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (14,14);
125 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (15,15);
126 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (5,6);
127 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (6,5);
128 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (5,11);
129 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (11,5);
130 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (6,11);
131 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (11,6);
132 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (16,16);
133 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (7,8);
134 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (8,7);
135 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (9,10);
136 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (10,9);
137 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (12,13);
138 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (13,12);
139 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (14,15);
140 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (15,14);
141 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (17,17);
142 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (3,3);
143 INSERT INTO `PortCompat`
(`type1`
, `type2`
) VALUES (19,19);
146 LOCK TABLES `
Dictionary`
WRITE;
147 INSERT INTO `
Dictionary`
(`chapter_no`
, `dict_key`
, `dict_value`
) VALUES (1,1,'BlackBox');
148 INSERT INTO `
Dictionary`
(`chapter_no`
, `dict_key`
, `dict_value`
) VALUES (1,2,'PDU');
149 INSERT INTO `
Dictionary`
(`chapter_no`
, `dict_key`
, `dict_value`
) VALUES (1,3,'Shelf');
150 INSERT INTO `
Dictionary`
(`chapter_no`
, `dict_key`
, `dict_value`
) VALUES (1,4,'Server');
151 INSERT INTO `
Dictionary`
(`chapter_no`
, `dict_key`
, `dict_value`
) VALUES (1,5,'DiskArray');
152 INSERT INTO `
Dictionary`
(`chapter_no`
, `dict_key`
, `dict_value`
) VALUES (1,6,'TapeLibrary');
153 INSERT INTO `
Dictionary`
(`chapter_no`
, `dict_key`
, `dict_value`
) VALUES (1,7,'Router');
154 INSERT INTO `
Dictionary`
(`chapter_no`
, `dict_key`
, `dict_value`
) VALUES (1,8,'Switch');
155 INSERT INTO `
Dictionary`
(`chapter_no`
, `dict_key`
, `dict_value`
) VALUES (1,9,'PatchPanel');
156 INSERT INTO `
Dictionary`
(`chapter_no`
, `dict_key`
, `dict_value`
) VALUES (1,10,'CableOrganizer');
157 INSERT INTO `
Dictionary`
(`chapter_no`
, `dict_key`
, `dict_value`
) VALUES (1,11,'Placeholder');
158 INSERT INTO `
Dictionary`
(`chapter_no`
, `dict_key`
, `dict_value`
) VALUES (1,12,'UPS');
159 INSERT INTO `
Dictionary`
(`chapter_no`
, `dict_key`
, `dict_value`
) VALUES (1,14,'Modem');
160 INSERT INTO `
Dictionary`
(`chapter_no`
, `dict_key`
, `dict_value`
) VALUES (1,15,'MediaConverter');
161 INSERT INTO `
Dictionary`
(`chapter_no`
, `dict_key`
, `dict_value`
) VALUES (1,16,'console');
162 INSERT INTO `
Dictionary`
(`chapter_no`
, `dict_key`
, `dict_value`
) VALUES (2,17,'LC/10GBase-SR');
163 INSERT INTO `
Dictionary`
(`chapter_no`
, `dict_key`
, `dict_value`
) VALUES (2,3,'power plug');
164 INSERT INTO `
Dictionary`
(`chapter_no`
, `dict_key`
, `dict_value`
) VALUES (2,4,'BNC/10Base2');
165 INSERT INTO `
Dictionary`
(`chapter_no`
, `dict_key`
, `dict_value`
) VALUES (2,5,'RJ-45/10Base-T');
166 INSERT INTO `
Dictionary`
(`chapter_no`
, `dict_key`
, `dict_value`
) VALUES (2,6,'RJ-45/100Base-TX');
167 INSERT INTO `
Dictionary`
(`chapter_no`
, `dict_key`
, `dict_value`
) VALUES (2,7,'SC/100Base-FX');
168 INSERT INTO `
Dictionary`
(`chapter_no`
, `dict_key`
, `dict_value`
) VALUES (2,8,'LC/100Base-FX');
169 INSERT INTO `
Dictionary`
(`chapter_no`
, `dict_key`
, `dict_value`
) VALUES (2,9,'SC/100Base-SX');
170 INSERT INTO `
Dictionary`
(`chapter_no`
, `dict_key`
, `dict_value`
) VALUES (2,10,'LC/100Base-SX');
171 INSERT INTO `
Dictionary`
(`chapter_no`
, `dict_key`
, `dict_value`
) VALUES (2,11,'RJ-45/1000Base-T');
172 INSERT INTO `
Dictionary`
(`chapter_no`
, `dict_key`
, `dict_value`
) VALUES (2,12,'SC/1000Base-SX');
173 INSERT INTO `
Dictionary`
(`chapter_no`
, `dict_key`
, `dict_value`
) VALUES (2,13,'LC/1000Base-SX');
174 INSERT INTO `
Dictionary`
(`chapter_no`
, `dict_key`
, `dict_value`
) VALUES (2,14,'SC/1000Base-LX');
175 INSERT INTO `
Dictionary`
(`chapter_no`
, `dict_key`
, `dict_value`
) VALUES (2,15,'LC/1000Base-LX');
176 INSERT INTO `
Dictionary`
(`chapter_no`
, `dict_key`
, `dict_value`
) VALUES (2,16,'async serial');
177 INSERT INTO `
Dictionary`
(`chapter_no`
, `dict_key`
, `dict_value`
) VALUES (2,19,'sync serial');
178 INSERT INTO `
Dictionary`
(`chapter_no`
, `dict_key`
, `dict_value`
) VALUES (2,18,'veth (Xen bridge)');
179 INSERT INTO `
Dictionary`
(`chapter_no`
, `dict_key`
, `dict_value`
) VALUES (20,1,'TCP');
180 INSERT INTO `
Dictionary`
(`chapter_no`
, `dict_key`
, `dict_value`
) VALUES (20,2,'UDP');
projects / racktables / blob