database-fill-supplemental.sql 3.75 KB
Newer Older
1
-- 
Timothy Stack's avatar
 
Timothy Stack committed
2
-- database-fill-supplemental.sql - Various things that need to go into new
3 4 5 6 7
-- sites' databases, but don't really fit into database-fill.sql, which is
-- auto-generated. Also, unlike the contents of database-fill.sql, inserting
-- these is not idempotent, since a site may have changed them for some reason.
--

8 9
INSERT IGNORE INTO `node_types` VALUES ('pc','pc',NULL,NULL,0,0,0,0,0,0,0,0,0,0,0,0);
INSERT IGNORE INTO`node_type_attributes` VALUES ('pc','imageable','1','boolean');
10 11
INSERT IGNORE INTO `node_types` VALUES ('pcvm','pcvm',NULL,NULL,1,0,1,1,0,0,0,0,0,0,0,0);
INSERT IGNORE INTO `node_types` VALUES ('pcvwa','pcvwa',NULL,NULL,1,0,0,1,1,0,0,0,0,0,0,0);
12
INSERT IGNORE INTO `node_type_attributes` VALUES ('pcvwa','default_osid','0','integer');
Timothy Stack's avatar
 
Timothy Stack committed
13 14 15 16 17 18

INSERT IGNORE INTO os_boot_cmd VALUES ('FreeBSD','4.10','delay','/kernel.delay');
INSERT IGNORE INTO os_boot_cmd VALUES ('FreeBSD','4.10','vnodehost','/kernel.jail');
INSERT IGNORE INTO os_boot_cmd VALUES ('FreeBSD','4.10','linkdelay','/kernel.linkdelay');
INSERT IGNORE INTO os_boot_cmd VALUES ('FreeBSD','5.4','delay','/boot/kernel.delay/kernel');
INSERT IGNORE INTO os_boot_cmd VALUES ('FreeBSD','5.4','linkdelay','/boot/kernel.linkdelay/kernel');
19 20
INSERT IGNORE INTO os_boot_cmd VALUES ('FreeBSD','6.2','delay','/boot/kernel.poll/kernel HZ=10000');
INSERT IGNORE INTO os_boot_cmd VALUES ('FreeBSD','6.2','linkdelay','/boot/kernel/kernel HZ=1000');
21
INSERT IGNORE INTO os_boot_cmd VALUES ('FreeBSD','7.3','delay','/boot/kernel.poll/kernel HZ=10000');
22
INSERT IGNORE INTO os_boot_cmd VALUES ('FreeBSD','8.2','delay','/boot/kernel/kernel kern.hz=10000');
Timothy Stack's avatar
 
Timothy Stack committed
23
INSERT IGNORE INTO os_boot_cmd VALUES ('Linux','9.0','linkdelay','linkdelay');
Kevin Atkinson's avatar
 
Kevin Atkinson committed
24 25

INSERT IGNORE INTO emulab_indicies (name,idx) VALUES ('cur_log_seq', 1);
26
INSERT IGNORE INTO emulab_indicies (name,idx) VALUES ('frisbee_index', 1);
Leigh B. Stoller's avatar
Leigh B. Stoller committed
27
INSERT IGNORE INTO emulab_indicies (name,idx) VALUES ('next_osid', 10000);
28 29 30
-- The initial certs start at hardwired location cause no DB during install
-- Push this up so that user certs start above it. 
INSERT IGNORE INTO emulab_indicies (name,idx) VALUES ('user_sslcerts', 1000);
31
INSERT IGNORE INTO emulab_locks (name,value) VALUES ('pool_daemon', 0);
32 33 34 35

INSERT IGNORE INTO `interface_capabilities` VALUES ('generic','protocols','ethernet');
INSERT IGNORE INTO `interface_capabilities` VALUES ('generic','ethernet_defspeed','100000');
INSERT IGNORE INTO `interface_types` VALUES ('generic',100000,1,'Generic','Generic',1,'RJ45');
Leigh B Stoller's avatar
Leigh B Stoller committed
36 37 38
INSERT IGNORE INTO `interface_types` VALUES ('generic_1G',1000000,1,'Generic GB','Generic GB',1,'RJ45');
INSERT IGNORE INTO `interface_capabilities` VALUES ('generic_1G','protocols','ethernet');
INSERT IGNORE INTO `interface_capabilities` VALUES ('generic_1G','ethernet_defspeed','1000000');
39

40 41 42 43 44
-- We use these types for the ilo/drac management interfaces.
INSERT INTO `interface_types` VALUES ('ilo2',0,1,'HP','HP iLO 2',1,'RJ45');
INSERT INTO `interface_types` VALUES ('ilo3',0,1,'HP','HP iLO 3',1,'RJ45');
INSERT INTO `interface_types` VALUES ('drac',0,1,'Dell','Dell Drac',1,'RJ45');

45 46 47 48 49 50 51 52 53 54
-- For the external link support.
INSERT INTO `node_types` VALUES ('bbgeni','bbgeni',NULL,NULL,0,0,0,0,0,0,0,0,0,0,0,0);
INSERT INTO `node_types` VALUES ('bbgenivm','bbgenivm',NULL,NULL,1,0,0,1,0,0,0,0,0,0,0,0);
INSERT INTO `node_type_attributes` VALUES ('bbgeni','rebootable','0','boolean');
INSERT INTO `node_type_attributes` VALUES ('bbgeni','imageable','0','boolean');
INSERT INTO `node_type_attributes` VALUES ('bbgenivm','rebootable','0','boolean');
INSERT INTO `node_type_attributes` VALUES ('bbgenivm','imageable','0','boolean');
INSERT INTO `interface_types` VALUES ('bbg',1000000,1,'Unknown','Gigabit Ethernet',1,'RJ45');
INSERT INTO `interface_capabilities` VALUES ('bbg','ethernet_defspeed','1000000');
INSERT INTO `interface_capabilities` VALUES ('bbg','protocols','ethernet');