Revision 671dfae9b29960fba966f379a8f49e47ea1f529b

Handling/SWinfastructure/pSQL/altertable.sh

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
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]';