tbdb.sql 1.96 KB
Newer Older
1 2 3 4 5 6 7
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');

Leigh B Stoller's avatar
Leigh B Stoller committed
8 9 10 11 12 13 14
REPLACE INTO `interface_types`
  VALUES ('igb',1000000,1,'Intel','Gigabit Ethernet',1,'RJ45');
REPLACE INTO `interface_capabilities`
  VALUES ('igb','protocols','ethernet');
REPLACE INTO `interface_capabilities`
  VALUES ('igb','ethernet_defspeed','1000000');

15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
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';
Leigh B Stoller's avatar
Leigh B Stoller committed
33 34 35 36 37
replace into node_types set
      class='switch', isswitch=1, type='hp5406';
replace into node_type_attributes set
      type='hp5406',attrkey='forwarding_protocols',
      attrvalue='ethernet',attrtype='string';
38
replace into nodes set
39
      node_id='procurve2',phys_nodeid='procurve2',type='hp5406',role='testswitch';
40 41 42 43 44 45
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);

Leigh B Stoller's avatar
Leigh B Stoller committed
46 47 48 49 50
replace into node_types set
      class='switch', isswitch=1, type='external-switch';
replace into node_type_attributes set
      type='external-switch',attrkey='forwarding_protocols',
      attrvalue='ethernet',attrtype='string';