EcalCondDB/sql/create_beamfile_to_energy.sql

0001 /*
0002  *  Creates beam file to energy correspondence
0003  */
0004
0005 CREATE TABLE beamfile_to_energy_def (
0006   def_id                NUMBER(10),
0007   beam_file             varchar(100),
0008   energy                NUMBER(10),
0009   particle              varchar(20),
0010   special_settings      varchar(100)
0011 );
0012
0013 ALTER TABLE beamfile_to_energy_def ADD CONSTRAINT beamfile_to_energy_def_pk PRIMARY KEY (def_id);
0014 CREATE SEQUENCE beamfile_to_energy_sq INCREMENT BY 1 START WITH 1;
0015
0016
0017
0018 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4A.001', 150.0 , 'p+ pi+', '');
0019 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4A.002', 350.0 , 'p+ pi+', '');
0020 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4A.005', 50.0 , 'p+ pi+', '');
0021 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4A.021', 100.0 , 'electrons', '');
0022 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4A.022', 200.0 , 'electrons', '');
0023 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4A.048', 150.0 , 'muons +', '');
0024 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4A.100', 20.0 , 'electrons', '');
0025 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4C.001', 150.0 , 'P+PI+H', 'FM,focus C8(OMR) collimators closed -> poor man muon beam');
0026 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4C.002', 120.0 , 'electrons', 'FM(@-4.52mr)');
0027 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4C.003', 20.0 , 'electrons', 'FM(@-4.52mr) P=20.000');
0028 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4C.004', 30.0 , 'electrons', 'FM(@-4.52mr) P=29.998');
0029 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4C.005', 50.0 , 'electrons', 'FM(@-4.52mr) P=49.988');
0030 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4C.006', 70.0 , 'electrons', 'FM(@-4.52mr) P=69.955');
0031 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4C.007', 150.0 , 'electrons', 'FM(@-4.52mr) not sure!');
0032 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4C.008', 80.0 , 'electrons', 'FM(@-4.52mr) P=79.766');
0033  INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4C.009', 0.0 , '', '');
0034 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4A.900', 20.0 , 'positrons', '');
0035 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4C.011', 90.0 , 'electrons', 'FM(@-4.52mr),P=89.835');
0036 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4C.012', 120.0 , 'electrons', 'FM(@-4.52mr),P=119.610');
0037 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4C.013', 150.0 , 'electrons', 'FM(@-4.52mr),P=149.053');
0038 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4C.014', 170.0 , 'electrons', 'FM(@-4.52mr),P=168.446');
0039 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4C.016', 200.0 , 'electrons', 'FM(@-4.52mr),P=197.055');
0040 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4C.017', 230.0 , 'electrons', 'FM(@-4.52mr),P=224.923');
0041 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4C.018', 250.0 , 'electrons', 'FM(@-4.52mr),P=242.996');
0042 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4C.020', 150.0 , 'P+PI+H', 'FM,focus C8(OMR), linearity run');
0043 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4C.021', 10.0 , 'electrons', 'FM(@-4.52mr),linearity run P=10.000');
0044 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4C.022', 20.0 , 'electrons', 'FM(@-4.52mr),linearity run P=20.000');
0045 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4C.023', 30.0 , 'electrons', 'FM(@-4.52mr),linearity run P=29.998');
0046 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4C.024', 50.0 , 'electrons', 'FM(@-4.52mr),linearity run P=49.981');
0047 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4C.025', 70.0 , 'electrons', 'FM(@-4.52mr),linearity run P=69.926');
0048 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4C.026', 90.0 , 'electrons', 'FM(@-4.52mr),linearity run P=89.799');
0049 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4C.027', 120.0 , 'electrons', 'FM(@-4.52mr),linearity run P=119.369');
0050 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4C.028', 150.0 , 'electrons', 'FM(@-4.52mr),linearity run P=148.474');
0051 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4C.029', 170.0 , 'electrons', 'FM(@-4.52mr),linearity run P=167.503');
0052 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4C.030', 15.0 , 'electrons', 'FM(@-4.52mr),linearity run P=15.00');
0053
0054 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4C.400', 400.0 , '', 'magnet test');
0055 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4C.401', 400.0 , '', 'magnet polarity test');
0056 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4C.902', 120.0 , 'electrons', 'FM(@-4.52mr),P=119.610');
0057 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4C.903', 20.0 , 'electrons', 'FM(@-4.52mr),P=20.000');
0058 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4C.904', 30.0 , 'electrons', 'FM(@-4.52mr),P=29.998');
0059 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4C.905', 50.0 , 'electrons', 'FM(@-4.52mr),P=49.988');
0060 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4C.906', 70.0 , 'electrons', 'FM(@-4.52mr),P=69.955');
0061 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4C.908', 80.0 , 'electrons', 'FM(@-4.52mr),P=79.923');
0062 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4C.911', 90.0 , 'electrons', 'FM(@-4.52mr),P=89.876');
0063 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4C.912', 120.0 , 'electrons', 'FM(@-4.52mr),P=119.610');
0064 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4C.913', 150.0 , 'electrons', 'FM(@-4.52mr),P=149.053');
0065 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4C.914', 170.0 , 'electrons', 'FM(@-4.52mr),P=168.446');
0066 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4C.916', 200.0 , 'electrons', 'FM(@-4.52mr),P=197.055');
0067 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4C.917', 230.0 , 'electrons', 'FM(@-4.52mr),P=224.923');
0068 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4C.918', 250.0 , 'electrons', 'FM(@-4.52mr),P=242.996');
0069 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4C.A', 450.0 , '', 'P4 TO T24(2.51mr)-NOMINAL KOL');
0070 INSERT INTO beamfile_to_energy_def(DEF_ID, beam_file, energy, particle, special_settings ) values (beamfile_to_energy_SQ.NextVal, 'H4C.RTEST', 200.0 ,'',  'P4 TO T24(2.51mr)-NOMINAL KOL');
0071
0072