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