Handling/SWinfastructure/pSQL/altertable.sh
ALTER TABLE shots
ADD COLUMN x_ScionixCeBr_a INTEGER;
COMMENT on COLUMN shots.x_ScionixCeBr_a IS 'x position of the probe ScionixCeBr_a [cm]';
ALTER TABLE shots
ADD COLUMN y_ScionixCeBr_a INTEGER;
COMMENT on COLUMN shots.y_ScionixCeBr_a IS 'y position of the probe ScionixCeBr_a [cm]';
ALTER TABLE shots
ADD COLUMN z_ScionixCeBr_a INTEGER;
COMMENT on COLUMN shots.z_ScionixCeBr_a IS 'z position of the probe ScionixCeBr_a [cm]';
ALTER TABLE shots
ADD COLUMN theta_ScionixCeBr_a INTEGER;
COMMENT on COLUMN shots.theta_ScionixCeBr_a IS 'theta direction of the probe ScionixCeBr_a [grad]';
ALTER TABLE shots
ADD COLUMN phi_ScionixCeBr_a INTEGER;
COMMENT on COLUMN shots.phi_ScionixCeBr_a IS 'phi direction of the probe ScionixCeBr_a [grad]';
ALTER TABLE shots
ADD COLUMN Voltage_ScionixCeBr_a INTEGER;
COMMENT on COLUMN shots.Voltage_ScionixCeBr_a IS 'Voltage on the probe ScionixCeBr_a [V|mA]';
ALTER TABLE shots
ADD COLUMN Current_ScionixCeBr_a INTEGER;
COMMENT on COLUMN shots.Current_ScionixCeBr_a IS 'Current on the probe ScionixCeBr_a [V|mA]';
ALTER TABLE shots
ADD COLUMN x_ScionixCeBr_b INTEGER;
COMMENT on COLUMN shots.x_ScionixCeBr_b IS 'x position of the probe ScionixCeBr_b [cm]';
ALTER TABLE shots
ADD COLUMN y_ScionixCeBr_b INTEGER;
COMMENT on COLUMN shots.y_ScionixCeBr_b IS 'y position of the probe ScionixCeBr_b [cm]';
ALTER TABLE shots
ADD COLUMN z_ScionixCeBr_b INTEGER;
COMMENT on COLUMN shots.z_ScionixCeBr_b IS 'z position of the probe ScionixCeBr_b [cm]';
ALTER TABLE shots
ADD COLUMN theta_ScionixCeBr_b INTEGER;
COMMENT on COLUMN shots.theta_ScionixCeBr_b IS 'theta direction of the probe ScionixCeBr_b [grad]';
ALTER TABLE shots
ADD COLUMN phi_ScionixCeBr_b INTEGER;
COMMENT on COLUMN shots.phi_ScionixCeBr_b IS 'phi direction of the probe ScionixCeBr_b [grad]';
ALTER TABLE shots
ADD COLUMN Voltage_ScionixCeBr_b INTEGER;
COMMENT on COLUMN shots.Voltage_ScionixCeBr_b IS 'Voltage on the probe ScionixCeBr_b [V|mA]';
ALTER TABLE shots
ADD COLUMN Current_ScionixCeBr_b INTEGER;
COMMENT on COLUMN shots.Current_ScionixCeBr_b IS 'Current on the probe ScionixCeBr_b [V|mA]';
ALTER TABLE shots
ADD COLUMN x_ScionixYAP_a INTEGER;
COMMENT on COLUMN shots.x_ScionixYAP_a IS 'x position of the probe ScionixYAP_a [cm]';
ALTER TABLE shots
ADD COLUMN y_ScionixYAP_a INTEGER;
COMMENT on COLUMN shots.y_ScionixYAP_a IS 'y position of the probe ScionixYAP_a [cm]';
ALTER TABLE shots
ADD COLUMN z_ScionixYAP_a INTEGER;
COMMENT on COLUMN shots.z_ScionixYAP_a IS 'z position of the probe ScionixYAP_a [cm]';
ALTER TABLE shots
ADD COLUMN theta_ScionixYAP_a INTEGER;
COMMENT on COLUMN shots.theta_ScionixYAP_a IS 'theta direction of the probe ScionixYAP_a [grad]';
ALTER TABLE shots
ADD COLUMN phi_ScionixYAP_a INTEGER;
COMMENT on COLUMN shots.phi_ScionixYAP_a IS 'phi direction of the probe ScionixYAP_a [grad]';
ALTER TABLE shots
ADD COLUMN Voltage_ScionixYAP_a INTEGER;
COMMENT on COLUMN shots.Voltage_ScionixYAP_a IS 'Voltage on the probe ScionixYAP_a [V|mA]';
ALTER TABLE shots
ADD COLUMN Current_ScionixYAP_a INTEGER;
COMMENT on COLUMN shots.Current_ScionixYAP_a IS 'Current on the probe ScionixYAP_a [V|mA]';
ALTER TABLE shots
ADD COLUMN x_ScionixYAP_b INTEGER;
COMMENT on COLUMN shots.x_ScionixYAP_b IS 'x position of the probe ScionixYAP_b [cm]';
ALTER TABLE shots
ADD COLUMN y_ScionixYAP_b INTEGER;
COMMENT on COLUMN shots.y_ScionixYAP_b IS 'y position of the probe ScionixYAP_b [cm]';
ALTER TABLE shots
ADD COLUMN z_ScionixYAP_b INTEGER;
COMMENT on COLUMN shots.z_ScionixYAP_b IS 'z position of the probe ScionixYAP_b [cm]';
ALTER TABLE shots
ADD COLUMN theta_ScionixYAP_b INTEGER;
COMMENT on COLUMN shots.theta_ScionixYAP_b IS 'theta direction of the probe ScionixYAP_b [grad]';
ALTER TABLE shots
ADD COLUMN phi_ScionixYAP_b INTEGER;
COMMENT on COLUMN shots.phi_ScionixYAP_b IS 'phi direction of the probe ScionixYAP_b [grad]';
ALTER TABLE shots
ADD COLUMN Voltage_ScionixYAP_b INTEGER;
COMMENT on COLUMN shots.Voltage_ScionixYAP_b IS 'Voltage on the probe ScionixYAP_b [V|mA]';
ALTER TABLE shots
ADD COLUMN Current_ScionixYAP_b INTEGER;
COMMENT on COLUMN shots.Current_ScionixYAP_b IS 'Current on the probe ScionixYAP_b [V|mA]';
ALTER TABLE shots
ADD COLUMN x_CryturYAP_a INTEGER;
COMMENT on COLUMN shots.x_CryturYAP_a IS 'x position of the probe CryturYAP_a [cm]';
ALTER TABLE shots
ADD COLUMN y_CryturYAP_a INTEGER;
COMMENT on COLUMN shots.y_CryturYAP_a IS 'y position of the probe CryturYAP_a [cm]';
ALTER TABLE shots
ADD COLUMN z_CryturYAP_a INTEGER;
COMMENT on COLUMN shots.z_CryturYAP_a IS 'z position of the probe CryturYAP_a [cm]';
ALTER TABLE shots
ADD COLUMN theta_CryturYAP_a INTEGER;
COMMENT on COLUMN shots.theta_CryturYAP_a IS 'theta direction of the probe CryturYAP_a [grad]';
ALTER TABLE shots
ADD COLUMN phi_CryturYAP_a INTEGER;
COMMENT on COLUMN shots.phi_CryturYAP_a IS 'phi direction of the probe CryturYAP_a [grad]';
ALTER TABLE shots
ADD COLUMN Voltage_CryturYAP_a INTEGER;
COMMENT on COLUMN shots.Voltage_CryturYAP_a IS 'Voltage on the probe CryturYAP_a [V|mA]';
ALTER TABLE shots
ADD COLUMN Current_CryturYAP_a INTEGER;
COMMENT on COLUMN shots.Current_CryturYAP_a IS 'Current on the probe CryturYAP_a [V|mA]';
ALTER TABLE shots
ADD COLUMN x_EnvinetNaItl_a INTEGER;
COMMENT on COLUMN shots.x_EnvinetNaItl_a IS 'x position of the probe EnvinetNaItl_a [cm]';
ALTER TABLE shots
ADD COLUMN y_EnvinetNaItl_a INTEGER;
COMMENT on COLUMN shots.y_EnvinetNaItl_a IS 'y position of the probe EnvinetNaItl_a [cm]';
ALTER TABLE shots
ADD COLUMN z_EnvinetNaItl_a INTEGER;
COMMENT on COLUMN shots.z_EnvinetNaItl_a IS 'z position of the probe EnvinetNaItl_a [cm]';
ALTER TABLE shots
ADD COLUMN theta_EnvinetNaItl_a INTEGER;
COMMENT on COLUMN shots.theta_EnvinetNaItl_a IS 'theta direction of the probe EnvinetNaItl_a [grad]';
ALTER TABLE shots
ADD COLUMN phi_EnvinetNaItl_a INTEGER;
COMMENT on COLUMN shots.phi_EnvinetNaItl_a IS 'phi direction of the probe EnvinetNaItl_a [grad]';
ALTER TABLE shots
ADD COLUMN Voltage_EnvinetNaItl_a INTEGER;
COMMENT on COLUMN shots.Voltage_EnvinetNaItl_a IS 'Voltage on the probe EnvinetNaItl_a [V|mA]';
ALTER TABLE shots
ADD COLUMN Current_EnvinetNaItl_a INTEGER;
COMMENT on COLUMN shots.Current_EnvinetNaItl_a IS 'Current on the probe EnvinetNaItl_a [V|mA]';
ALTER TABLE shots
ADD COLUMN x_NuviaNaItl_a INTEGER;
COMMENT on COLUMN shots.x_NuviaNaItl_a IS 'x position of the probe NuviaNaItl_a [cm]';
ALTER TABLE shots
ADD COLUMN y_NuviaNaItl_a INTEGER;
COMMENT on COLUMN shots.y_NuviaNaItl_a IS 'y position of the probe NuviaNaItl_a [cm]';
ALTER TABLE shots
ADD COLUMN z_NuviaNaItl_a INTEGER;
COMMENT on COLUMN shots.z_NuviaNaItl_a IS 'z position of the probe NuviaNaItl_a [cm]';
ALTER TABLE shots
ADD COLUMN theta_NuviaNaItl_a INTEGER;
COMMENT on COLUMN shots.theta_NuviaNaItl_a IS 'theta direction of the probe NuviaNaItl_a [grad]';
ALTER TABLE shots
ADD COLUMN phi_NuviaNaItl_a INTEGER;
COMMENT on COLUMN shots.phi_NuviaNaItl_a IS 'phi direction of the probe NuviaNaItl_a [grad]';
ALTER TABLE shots
ADD COLUMN Voltage_NuviaNaItl_a INTEGER;
COMMENT on COLUMN shots.Voltage_NuviaNaItl_a IS 'Voltage on the probe NuviaNaItl_a [V|mA]';
ALTER TABLE shots
ADD COLUMN Current_NuviaNaItl_a INTEGER;
COMMENT on COLUMN shots.Current_NuviaNaItl_a IS 'Current on the probe NuviaNaItl_a [V|mA]';
ALTER TABLE shots
ADD COLUMN x_NuviaZnSAg_a INTEGER;
COMMENT on COLUMN shots.x_NuviaZnSAg_a IS 'x position of the probe NuviaZnSAg_a [cm]';
ALTER TABLE shots
ADD COLUMN y_NuviaZnSAg_a INTEGER;
COMMENT on COLUMN shots.y_NuviaZnSAg_a IS 'y position of the probe NuviaZnSAg_a [cm]';
ALTER TABLE shots
ADD COLUMN z_NuviaZnSAg_a INTEGER;
COMMENT on COLUMN shots.z_NuviaZnSAg_a IS 'z position of the probe NuviaZnSAg_a [cm]';
ALTER TABLE shots
ADD COLUMN theta_NuviaZnSAg_a INTEGER;
COMMENT on COLUMN shots.theta_NuviaZnSAg_a IS 'theta direction of the probe NuviaZnSAg_a [grad]';
ALTER TABLE shots
ADD COLUMN phi_NuviaZnSAg_a INTEGER;
COMMENT on COLUMN shots.phi_NuviaZnSAg_a IS 'phi direction of the probe NuviaZnSAg_a [grad]';
ALTER TABLE shots
ADD COLUMN Voltage_NuviaZnSAg_a INTEGER;
COMMENT on COLUMN shots.Voltage_NuviaZnSAg_a IS 'Voltage on the probe NuviaZnSAg_a [V|mA]';
ALTER TABLE shots
ADD COLUMN Current_NuviaZnSAg_a INTEGER;
COMMENT on COLUMN shots.Current_NuviaZnSAg_a IS 'Current on the probe NuviaZnSAg_a [V|mA]';
ALTER TABLE shots
ADD COLUMN x_CapadLYSO_a INTEGER;
COMMENT on COLUMN shots.x_CapadLYSO_a IS 'x position of the probe CapadLYSO_a [cm]';
ALTER TABLE shots
ADD COLUMN y_CapadLYSO_a INTEGER;
COMMENT on COLUMN shots.y_CapadLYSO_a IS 'y position of the probe CapadLYSO_a [cm]';
ALTER TABLE shots
ADD COLUMN z_CapadLYSO_a INTEGER;
COMMENT on COLUMN shots.z_CapadLYSO_a IS 'z position of the probe CapadLYSO_a [cm]';
ALTER TABLE shots
ADD COLUMN theta_CapadLYSO_a INTEGER;
COMMENT on COLUMN shots.theta_CapadLYSO_a IS 'theta direction of the probe CapadLYSO_a [grad]';
ALTER TABLE shots
ADD COLUMN phi_CapadLYSO_a INTEGER;
COMMENT on COLUMN shots.phi_CapadLYSO_a IS 'phi direction of the probe CapadLYSO_a [grad]';
ALTER TABLE shots
ADD COLUMN Voltage_CapadLYSO_a INTEGER;
COMMENT on COLUMN shots.Voltage_CapadLYSO_a IS 'Voltage on the probe CapadLYSO_a [V|mA]';
ALTER TABLE shots
ADD COLUMN Current_CapadLYSO_a INTEGER;
COMMENT on COLUMN shots.Current_CapadLYSO_a IS 'Current on the probe CapadLYSO_a [V|mA]';