genirack-tbdb.sql 1.27 KB
Newer Older
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
REPLACE INTO `interface_types`
  VALUES ('bce',1000000,1,'Broadcom','Gigabit Ethernet',1,'RJ45');
REPLACE INTO `interface_capabilities`
  VALUES ('bce','protocols','ethernet');
REPLACE INTO `interface_capabilities`
  VALUES ('bce','ethernet_defspeed','1000000');

REPLACE INTO `interface_types`
  VALUES ('ilo2',0,1,'HP','HP iLO 2',1,'RJ45');

replace into node_types set
      class='switch', isswitch=1, type='hp2610';
replace into node_type_attributes set
      type='hp2610',attrkey='forwarding_protocols',
      attrvalue='ethernet',attrtype='string';
replace into nodes set
      node_id='procurve1',phys_nodeid='procurve1',type='hp2610',role='ctrlswitch';
REPLACE INTO `switch_stack_types`
  VALUES ('Control','generic',0,0,NULL,128,256,'procurve1');

replace into node_types set
      class='switch', isswitch=1, type='hp6600';
replace into node_type_attributes set
      type='hp6600',attrkey='forwarding_protocols',
      attrvalue='ethernet',attrtype='string';
replace into nodes set
      node_id='procurve2',phys_nodeid='procurve2',type='hp6600',role='testswitch';
REPLACE INTO `switch_stack_types`
  VALUES ('Experiment','generic',0,0,NULL,257,999,'procurve2');

replace into switch_stacks (node_id,stack_id,is_primary)
      values ('procurve2','Experiment',1),("procurve1",'Control',1);