
-- Insert supporting Data
-- Jeremy Simmons

PROMPT Inserting Supporting Data

PROMPT Inserting into table DEVICE_TYPES and TEMPLATE_IDS

insert into device_types (id, description)
values ('HV',	'High Voltage Channel');

insert into device_types (id, description)
values ('RM',	'Rack Monitor');

insert into device_types (id, description)
values ('RMI',	'Rack Monitor Interface');

insert into device_types (id, description)
values ('VBD',	'VME Buffer Driver');                                                             

insert into device_types (id, description)
values ('VRB',	'VME Readout Buffer');

insert into device_types (id, description)
values ('VRBC',	'VME Readout Buffer Controller');

insert into device_types (id, description)
values ('HVSA', 'High Voltage PS channel for muon scintilator type A');

insert into device_types (id, description)
values ('HVSB', 'High Voltage PS channel for muon scintilator type B');

insert into device_types (id, description)
values ('HVSC', 'High Voltage PS channel for muon scintilator type C');

insert into device_types (id, description)
values ('HVDP', 'High Voltage PS channel for muon drift pad');

insert into device_types (id, description)
values ('HVDW', 'High Voltage PS channel for muon drift wire');

insert into device_types (id, description)
values ('HVU', 'High Voltage Utility monitoring');

insert into device_types (id, description)
values ('HVC', 'High Voltage Channel');

insert into device_types (id, description)
values ('HVS', 'High Voltage control settings');

insert into device_types (id, description)
values ('ADC', 'Analog-to-Digital Converter');

insert into device_types (id, description)
values ('ADCC', 'Analog-to-Digital Converter for Calorimeter');

insert into device_types (id, description)
values ('CCCA', 'Crate Controller - ADC');

insert into device_types (id, description)
values ('CMCA', 'Crate Monitor - ADC');

insert into device_types (id, description)
values ('CMCB', 'Crate Monitor - BLS');

insert into device_types (id, description)
values ('CMCC', 'Crate Monitor - Calibration Pulser');

insert into device_types (id, description)
values ('CMCF', 'Crate Monitor - BLS Fanout');

insert into device_types (id, description)
values ('CMCP', 'Crate Monitor - Preamp');

insert into device_types (id, description)
values ('LVCA', 'Low Voltage Power Supply - ADC');

insert into device_types (id, description)
values ('LVCB', 'Low Voltage Power Supply - BLS');

insert into device_types (id, description)
values ('LVCC', 'Low Voltage Power Supply - Calibration Pulser');

insert into device_types (id, description)
values ('LVCF', 'Low Voltage Power Supply - BLS Fanout');

insert into device_types (id, description)
values ('LVCP', 'Low Voltage Power Supply - Preamp');

insert into device_types (id, description)
values ('LV', 'Low Voltage Power Supply');

insert into device_types (id, description)
values ('LVMT', 'Low Voltage PS for Muon LVL-1 Trigger');

insert into device_types (id, description)
values ('LVAFE', 'Low Voltage PS for Analog Front End');

insert into device_types (id, description)
values ('LVDFE', 'Low Voltage PS for Digital Front End');

insert into device_types (id, description)
values ('FO', 'Six port fanout');

--

insert into device_types (id, description)
values ('MIL', 'MIL1553 standard records');

insert into device_types (id, description)
values ('VME', 'VME standard records');

insert into device_types (id, description)
values ('PROC', 'Processor performance statistics');

insert into device_types (id, description)
values ('IOC', 'Standard MIL1553 rack monitor device');

--

insert into device_types (id, description)
values ('MDT', 'Muon MDRC (MDT Readout Crate) Interface board');

insert into device_types (id, description)
values ('SRC', 'Muon SRC Control Board');

insert into device_types (id, description)
values ('PDT', 'Muon PDT Control Board');

insert into device_types (id, description)
values ('MFLO', 'Muon MDT gas flow');

insert into device_types (id, description)
values ('MTCM', 'Muon Trigger Control Module');

insert into device_types (id, description)
values ('MRCC', 'Muon Readout Crate Control/Monitoring');

--

insert into device_types (id, description)
values ('SEQ', 'SVX Sequencer Board');

insert into device_types (id, description)
values ('SVXIB', 'SVX Interface Board');

insert into device_types (id, description)
values ('IB', 'SMT Interface Board read');

insert into device_types (id, description)
values ('SEQC', 'SVX Sequencer Controller Board');

insert into device_types (id, description)
values ('SVXEA', 'SVX Sequencer Emulator, Card 1, Channel A');

insert into device_types (id, description)
values ('SVXEB', 'SVX Sequencer Emulator, Card 1, Channel B');

insert into device_types (id, description)
values ('SVXEC', 'SVX Sequencer Emulator, Card 2, Channel A');

insert into device_types (id, description)
values ('SVXED', 'SVX Sequencer Emulator, Card 2, Channel B');

insert into device_types (id, description)
values ('SVXEE', 'SVX Sequencer Emulator, Card 3, Channel A');

insert into device_types (id, description)
values ('SVXEF', 'SVX Sequencer Emulator, Card 3, Channel B');

insert into device_types (id, description)
values ('SVXEG', 'SVX Sequencer Emulator, Card 4, Channel A');

insert into device_types (id, description)
values ('SVXEH', 'SVX Sequencer Emulator, Card 4, Channel B');

--

insert into device_types (id, description)
values ('DFE', 'Digital Front End card');

insert into device_types (id, description)
values ('AFE', 'Analog Front End card');

insert into device_types (id, description)
values ('AFEP', 'Analog Front End Power supplies');

insert into device_types (id, description)
values ('REG', 'Hardware Register Simulation');

insert into device_types (id, description)
values ('SES', 'Significant Event System');

--

insert into device_types (id, description)
values ('CSEQ', 'Clock Sequencer Module');

insert into device_types (id, description)
values ('CSFM', 'Clock Selector Fanout Module');

insert into device_types (id, description)
values ('CPCC', 'Phase Coherent Clock');

insert into device_types (id, description)
values ('CCCT', 'Calorimeter Timing and Control Crate Controller');

insert into device_types (id, description)
values ('CCCP', 'Crate Controller Calorimeter Pulser');

--

insert into device_types (id, description)
values ('BLM', 'Beam loss monitors');

insert into device_types (id, description)
values ('SDAQ', 'Secondary Data Acquisition Run Control');

--
insert into device_types (id, description)
values ('SLP', 'ICD LED Pulsers');
--
insert into device_types (id, description)
values ('CENT', 'Muon Centroid Finder');
--
insert into device_types (id, description)
values ('TFC', 'Track Fit Card');

insert into device_types (id, description)
values ('STC', 'Silicon Track Card');

insert into device_types (id, description)
values ('FRC', 'Fiber Road Card');

--
insert into device_types (id, description)
values ('NULL', 'Custom device type');

commit;

PROMPT Inserting into table DETECTORS

insert into detectors (det_type, description)
values ('ICD', 'Inter Cryostat Detector');

insert into detectors (det_type, description)
values ('CAL', 'Calorimeter');

insert into detectors (det_type, description)
values ('CALC', 'Calorimeter Central');

insert into detectors (det_type, description)
values ('CALN', 'Calorimeter North');

insert into detectors (det_type, description)
values ('CALS', 'Calorimeter South');

insert into detectors (det_type, description)
values ('CFT', 'Central Fiber Tracker');

insert into detectors (det_type, description)
values ('CFTT', 'Central Fiber Tracker Trigger');

insert into detectors (det_type, description)
values ('CPS', 'Central Preshower');

insert into detectors (det_type, description)
values ('FPS', 'Forward Preshower');

insert into detectors (det_type, description)
values ('CTL', 'Control System');

insert into detectors (det_type, description)
values ('MUO', 'Muon');

insert into detectors (det_type, description)
values ('MUOC', 'Muon Central');

insert into detectors (det_type, description)
values ('MUON', 'Muon North');

insert into detectors (det_type, description)
values ('MUOS', 'Muon South');

insert into detectors (det_type, description)
values ('MUOF', 'Muon Forward');

insert into detectors (det_type, description)
values ('SMT', 'Silicon Microstrip Tracker');

insert into detectors (det_type, description)
values ('SMTS', 'Silicon Microstrip Tracker South');

insert into detectors (det_type, description)
values ('SMTN', 'Silicon Microstrip Tracker North');

insert into detectors (det_type, description)
values ('TRG', 'Trigger');

insert into detectors (det_type, description)
values ('FPD', 'Forward Proton Detector');

insert into detectors (det_type, description)
values ('LUM', 'Luminosity');

insert into detectors (det_type, description)
values ('MCH', 'Moving Counting House tests');

insert into detectors (det_type, description)
values ('L1CTT', 'L1 Central Tracking Trigger');

insert into detectors (det_type, description)
values ('STT', 'Silicon Track Trigger');

insert into detectors (det_type, description)
values ('NULL', 'Custom detector type');

commit;

PROMPT Inserting into table LOCATORS

insert into locators (id, house, rack_name)
values ('AAANULL','NULL','NULL');

insert into locators (id, house, rack_name)
values ('MCH-1', 'MCH-1', 'NULL');

insert into locators (id, house, rack_name)
values ('MCH-2', 'MCH-2', 'NULL');

insert into locators (id, house, rack_name)
values ('MCH-3', 'MCH-3', 'NULL');

commit;

PROMPT Inserting into table LOCATORS and NODES

insert into locators (house, rack_name, crate_name)
values ('MCH-2', '212','A');
--insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
--values ('d0olcft00', 'MCH-2/212/A', 'MVME2304', 't-d0-mch2', '17', 'CFT VRB readout');

insert into locators (house, rack_name, crate_name)
values ('MCH-2', '212','B');
--insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
--values ('d0olcft01', 'MCH-2/212/B', 'MVME2304', 't-d0-mch2', '18', 'CFT VRB readout');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olcft04', 'MCH-2/212/B', 'MVME2304', 't-d0-mch2', '17', 'VRB readout');

insert into locators (house, rack_name, crate_name)
values ('MCH-2', '213','A');
--insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
--values ('d0olcft02', 'MCH-2/213/A', 'MVME2304', 't-d0-mch2', '19', 'CFT VRB readout');

insert into locators (house, rack_name, crate_name)
values ('MCH-2', '213','B');
--insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
--values ('d0olcft03', 'MCH-2/213/B', 'MVME2304', 't-d0-mch2', '20', 'CFT VRB readout');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olcft07', 'MCH-2/213/B', 'MVME2304', 't-d0-mch2', '20', 'VRB readout');

insert into locators (house, rack_name, crate_name)
values ('MCH-2', '212','C');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olcft05', 'MCH-2/212/C', 'MVME2304', 't-d0-mch2', '18', 'VRB readout');

insert into locators (house, rack_name, crate_name)
values ('MCH-2', '213','C');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olcft06', 'MCH-2/213/C', 'MVME2304', 't-d0-mch2', '19', 'VRB readout');

insert into locators (house, rack_name, crate_name)
values ('FCH-3', 'Test','A');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olctl00', 'FCH-3/Test/A', 'MVME162-262', 't-d0-fch3', '1', '68 K test processor');

insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olctl02', 'MCH-1',  'MVME162-262', '', '', 'FPD control node');

insert into locators (house, rack_name, crate_name)
values ('MCH-3', '309','B2');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olctl03', 'MCH-3/309/B2', 'MVME162-262', 't-d0-mch3', '2', 'ICD/Calorimeter Test');

insert into locators (house, rack_name, crate_name)
values ('MCH-1', '100','D');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olctl06', 'MCH-1/100/D', 'MVME162-262', 't-d0-mch1', '15', 'Trigger Master clock ');

insert into locators (house, rack_name, crate_name)
values ('FCH-3', 'Test','B2');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olctl07', 'FCH-3/Test/B2', 'MVME2301', 't-d0-fch3', '2', 'Controls PPC test processor');

insert into locators (house, rack_name, crate_name)
values ('MCH-2', '220', 'B');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olctl08', 'MCH-2/220/B', 'MVME2301', 't-d0-mch2', '9', 'SMT HV - south');

insert into locators (house, rack_name, crate_name)
values ('MCH-3', '300','F1');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olctl09', 'MCH-3/300/F1', 'MVME2301', 't-d0-mch3', '4', 'Calorimeter MVME2301 PPC in rack M300,crate F,partition 1');

insert into locators (house, rack_name, crate_name)
values ('MCH-2', '215','E');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olctl10', 'MCH-2/215/E', 'MVME2301', 't-d0-mch2', '1', 'Muon HV - central B layer');

insert into locators (house, rack_name, crate_name)
values ('MCH-3', '300','F2');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olctl11', 'MCH-3/300/F2', 'MVME2301', 't-d0-mch3', '5', 'Calorimeter MVME2301 PPC in rack M300,crate C,partition 2');

insert into locators (house, rack_name, crate_name)
values ('MCH-2', '215','D');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olctl13', 'MCH-2/215/D', 'MVME2301', 't-d0-mch2', '5', 'Muon HV - central C layer');

insert into locators (house, rack_name, crate_name)
values ('MCH-2', '215','B');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olctl14', 'MCH-2/215/B', 'MVME2301', 't-d0-mch2', '2', 'Muon HV - central pads');

insert into locators (house, rack_name, crate_name)
values ('MCH-2', '215','C');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olctl15', 'MCH-2/215/C', 'MVME2301', 't-d0-mch2', '3', 'Muon HV - central wires');

insert into locators (house, rack_name, crate_name)
values ('MCH-3', '300','A2');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olctl40', 'MCH-3/300/A2', 'MVME2301', 't-d0-mch3', '42', 'CFT Platform');

insert into locators (house, rack_name, crate_name)
values ('MCH-3', '300','D1');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olctl16', 'MCH-3/300/D1', 'MVME2301', 't-d0-mch3', '41', 'Controls MCH rack environment monitoring');

insert into locators (house, rack_name, crate_name)
values ('MCH-3', '305','E1');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olctl18', 'MCH-3/305/E1', 'MVME2301', 't-d0-mch3', '8', 'Central muon platform');

insert into locators (house, rack_name, crate_name)
values ('MCH-3', '305','D1');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olctl19', 'MCH-3/305/D1', 'MVME2301', 't-d0-mch3', '7', 'Central muon platform');

insert into locators (house, rack_name, crate_name)
values ('MCH-2', '217','C');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olctl20', 'MCH-2/217/C', 'MVME2301', 't-d0-mch2', '', 'Forward muon HV');

insert into locators (house, rack_name, crate_name)
values ('MCH-2', '218','B');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olctl21', 'MCH-2/218/B', 'MVME2301', 't-d0-mch2', '', 'Forward muon HV');

insert into locators (house, rack_name, crate_name)
values ('MCH-2', '217','B');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olctl22', 'MCH-2/217/B', 'MVME2301', 't-d0-mch2', '4', 'Muon HV - central A layer');

insert into locators (house, rack_name, crate_name)
values ('MCH-2', '221','B');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olctl23', 'MCH-2/221/B', 'MVME2301', 't-d0-mch2', '3', 'SMT HV - north');

insert into locators (house, rack_name, crate_name)
values ('MCH-2', '220','E');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olctl25', 'MCH-2/220/E', 'MVME2301', 't-d0-mch2', '13', 'SMT HV - south');

insert into locators (house, rack_name, crate_name)
values ('MCH-1', '116','B');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olctl26', 'MCH-1/116/B', 'MVME2301', 't-d0-mch1', '6', 'Calorimeter ICD HV');

insert into locators (house, rack_name, crate_name)
values ('MCH-1', '116','C');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olctl27', 'MCH-1/116/C', 'MVME2301', 't-d0-mch1', '7', 'Calorimeter ICD HV');

insert into locators (house, rack_name, crate_name)
values ('MCH-2', '217','D');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olctl28', 'MCH-2/217/D', 'MVME2301', 't-d0-mch2', '', 'Forward muon HV');

insert into locators (house, rack_name, crate_name)
values ('MCH-2', '217','E');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olctl29', 'MCH-2/217/E', 'MVME2301', 't-d0-mch2', '', 'Forward muon HV');

insert into locators (house, rack_name, crate_name)
values ('MCH-2', '218','C');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olctl30', 'MCH-2/218/C', 'MVME2301', 't-d0-mch2', '', 'Forward muon HV');

--insert into locators (house, rack_name, crate_name)
--values ('MCH-2', '218','D');
--insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
--values ('d0olctl31', 'MCH-2/218/D', 'MVME2301', 't-d0-mch2', '14', 'Forward muon HV');

insert into locators (house, rack_name, crate_name)
values ('MCH-2', '218','E');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olctl32', 'MCH-2/218/E', 'MVME2301', 't-d0-mch2', '29', 'Forward muon HV');

insert into locators (house, rack_name, crate_name)
values ('MCH-1', '116','D');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olctl33', 'MCH-1/116/D', 'MVME2301', 't-d0-mch1', '8', 'Calorimeter ICD HV');

insert into locators (house, rack_name, crate_name)
values ('MCH-3', '305','B2');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olctl34', 'MCH-3/305/B2', 'MVME2301', 't-d0-mch3', '3', 'Central muon platform');

insert into locators (house, rack_name)
values ('FCH-1', 'M09');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olctl35', 'FCH-1/M09', 'MVME2301', 't-d0-fch1', '3', 'EPICS/ACNET gateway');

insert into locators (house, rack_name,crate_name)
values ('MCH-2', '222', 'C');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olctl36', 'MCH-2/222/C', 'MVME2301', '', '', 'SMT HV - south');

insert into locators (house, rack_name,crate_name )
values ('MCH-3', '300', 'B2');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olctl57', 'MCH-3/300/B2', 'MVME2304', 't-d0-mch3', '1', 'SMT South platform');

insert into locators (house, rack_name,crate_name )
values ('MCH-3', '305', 'B1');
insert into locators (house, rack_name,crate_name )
values ('MCH-2', '300', 'C2');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olctl39', 'MCH-2/300/C2', 'MVME2301', 't-d0-mch3', '6', 'SMT North Platform');

insert into locators (house, rack_name, crate_name)
values ('MCH-3', '300','B1');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olctl57', 'MCH-3/300/B1', 'MVME2304', 't-d0-mch3', '34', 'SMT North Platform');

insert into locators (house, rack_name, crate_name)
values ('FCH-3', 'Test','B3');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olctl41', 'FCH-3/Test/B3', 'MVME2301', '', '', 'CTL SDAQ test processor');

insert into locators (house, rack_name, crate_name)
values ('MCH-1', '118','B');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olctl42', 'MCH-1/118/B', 'MVME2301', 't-d0-mch1', '2', 'Calorimeter HV - North');

insert into locators (house, rack_name, crate_name)
values ('MCH-1', '118','C');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olctl43', 'MCH-1/118/C', 'MVME2301', 't-d0-mch1', '3', 'Calorimeter HV - South');

insert into locators (house, rack_name, crate_name)
values ('MCH-1', '118','D');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olctl44', 'MCH-1/118/D', 'MVME2301', 't-d0-mch1', '4', 'Calorimeter HV - Central');

insert into locators (house, rack_name, crate_name)
values ('MCH-1', '118','E');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olctl45', 'MCH-1/118/E', 'MVME2301', 't-d0-mch1', '5', 'Calorimeter HV - Argon Monitoring/FPD');

insert into locators (house, rack_name, crate_name)
values ('MCH-2', '218','D');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olctl46', 'MCH-2/218/D', 'MVME2301', 't-d0-mch2', '14', 'Forward muon HV');

insert into locators (house, rack_name, crate_name)
values ('MCH-1', '116','E');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olctl47', 'MCH-1/116/E', 'MVME2301', 't-d0-mch1', '9', 'Luminosity HV/Accel');

insert into locators (house, rack_name, crate_name)
values ('MCH-2', '220','C');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olctl48', 'MCH-2/220/C', 'MVME2301', 't-d0-mch2', '22', 'SMT HV - South');

insert into locators (house, rack_name, crate_name)
values ('MCH-2', '220','D');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olctl49', 'MCH-2/220/D', 'MVME2301', 't-d0-mch2', '23', 'SMT HV - South');

insert into locators (house, rack_name, crate_name)
values ('MCH-3', '300','C1');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olctl50', 'MCH-3/300/C1', 'MVME2301', 't-d0-mch3', '36', 'SMT HV - South');

insert into locators (house, rack_name, crate_name)
values ('MCH-2', '221','C');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olctl51', 'MCH-2/221/C', 'MVME2301', 't-d0-mch2', '1', 'SMT HV - north');

insert into locators (house, rack_name, crate_name)
values ('MCH-2', '221','D');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olctl52', 'MCH-2/221/D', 'MVME2301', 't-d0-mch2', '4', 'SMT HV - north');

insert into locators (house, rack_name, crate_name)
values ('MCH-2', '221','E');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olctl53', 'MCH-2/221/E', 'MVME2301', 't-d0-mch2', '11', 'SMT HV - north');

--

insert into locators (house, rack_name, crate_name)
values ('MCH-2', '207', 'B');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olsmt00', 'MCH-2/207/B', 'MVME2304', 't-d0-mch2', '4', '');

insert into locators (house, rack_name, crate_name)
values ('MCH-2', '208', 'B');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olsmt01', 'MCH-2/208/B', 'MVME2304', 't-d0-mch2', '11', '');

insert into locators (house, rack_name, crate_name)
values ('MCH-2', '210','B');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olsmt02', 'MCH-2/210/B', 'MVME2304', 't-d0-mch2', '10', '');

insert into locators (house, rack_name, crate_name)
values ('MCH-2', '210', 'C');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olsmt03', 'MCH-2/210/C', 'MVME2304', 't-d0-mch2', '3', 'VRB readout sector 2 - south');

insert into locators (house, rack_name, crate_name)
values ('MCH-2', '211', 'C');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olsmt04', 'MCH-2/211/C', 'MVME2304', 't-d0-mch2', '2', 'VRB readout sector 1 - south');

insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olsmt05', 'MCH-2', 'MVME2304', 't-d0-mch2', '', 'VRB readout sector ? - south');

insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olsmt06', 'MCH-2', 'MVME2304', 't-d0-mch2', '', 'VRB readout sector ? - south');

insert into locators (house, rack_name, crate_name)
values ('MCH-2', '206', 'C');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olsmt07', 'MCH-2/206/C', 'MVME2304', 't-d0-mch2', '7', 'VRB readout sector ? - south');

insert into locators (house, rack_name, crate_name)
values ('MCH-2', '205', 'C');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olsmt08', 'MCH-2/205/C', 'MVME2304', 't-d0-mch2', '8', 'VRB readout sector ? - south');

insert into locators (house, rack_name, crate_name)
values ('MCH-3', '303', 'B');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olsmt12', 'MCH-3/303/B', 'MVME761-001', 't-d0-mch3', '33', 'Radiation monitoring');

insert into locators (house, rack_name, crate_name)
values ('MCH-2', '206', 'B');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olsmt13', 'MCH-2/206/B', 'MVME2304', 't-d0-mch2', '21', 'VRB');

insert into locators (house, rack_name, crate_name)
values ('MCH-2', '211', 'B');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olsmt14', 'MCH-2/211/B', 'MVME2304', 't-d0-mch2', '31', 'VRB');

--

insert into locators (house, rack_name, crate_name)
values ('MCH-3', '322','A');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olmuo21', 'MCH-3/322/A', 'MVME162-222', '', '', 'L1 Manager');

insert into locators (house, rack_name, crate_name)
values ('MCH-3', '322','B');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olmuo30', 'MCH-3/322/B', 'MVME162-222', '', '', 'L1 South');

insert into locators (house, rack_name, crate_name)
values ('MCH-3', '321','A');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olmuo08', 'MCH-3/321/A', 'MVME162-222', '', '', 'L1 Central');

insert into locators (house, rack_name, crate_name)
values ('MCH-3', '321','B');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olmuo18', 'MCH-3/321/B', 'MVME162-222', '', '', 'L1 North');

insert into locators (house, rack_name, crate_name)
values ('MCH-3', '321','C');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olmuo03', 'MCH-3/321/C', 'MVME162-222', '', '', 'CFT/PS Manager');

insert into locators (house, rack_name, crate_name)
values ('MCH-3', '319','B');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olmuo01', 'MCH-3/319/B', 'MVME162-222', '', '', 'East Scintillators');

insert into locators (house, rack_name, crate_name)
values ('MCH-3', '319','C');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olmuo06', 'MCH-3/319/C', 'MVME162-222', '', '', 'West Scintillators');

insert into locators (house, rack_name, crate_name)
values ('MCH-3', '318','A');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olmuo12', 'MCH-3/318/A', 'MVME162-222', '', '', 'East Top PDTs');

insert into locators (house, rack_name, crate_name)
values ('MCH-3', '318','B');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olmuo26', 'MCH-3/318/B', 'MVME162-222', '', '', 'East Side PDTs');

insert into locators (house, rack_name, crate_name)
values ('MCH-3', '318','C');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olmuo23', 'MCH-3/318/C', 'MVME162-222', '', '', 'East Bottom PDTs');

insert into locators (house, rack_name, crate_name)
values ('MCH-3', '317','A');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olmuo11', 'MCH-3/317/A', 'MVME162-222', '', '', 'West Top PDTs');

insert into locators (house, rack_name, crate_name)
values ('MCH-3', '317','B');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olmuo25', 'MCH-3/317/B', 'MVME162-222', '', '', 'West Side PDTs');

insert into locators (house, rack_name, crate_name)
values ('MCH-3', '317','C');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olmuo27', 'MCH-3/317/C', 'MVME162-222', '', '', 'West Bottom PDTs');

insert into locators (house, rack_name, crate_name)
values ('MCH-3', '316','A');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olmuo22', 'MCH-3/316/A', 'MVME162-222', '', '', 'South Pixels');

insert into locators (house, rack_name, crate_name)
values ('MCH-3', '316','B');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olmuo17', 'MCH-3/316/B', 'MVME162-222', '', '', 'North Pixels');

insert into locators (house, rack_name, crate_name)
values ('MCH-3', '314','A');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olmuo24', 'MCH-3/314/A', 'MVME162-222', '', '', 'South MDTs');

insert into locators (house, rack_name, crate_name)
values ('MCH-3', '314','B');
insert into nodes (id, locator_id, node_type, terminal_server, terminal_port, description)
values ('d0olmuo19', 'MCH-3/314/B', 'MVME162-222', '', '', 'North MDTs');

commit;

--
PROMPT Inserting into table ALARMS

insert into alarms (id)
values ('NULL');

commit;

