39 |
|
|
40 |
CREATE TABLE `GL_RESURS_OFFSET` ( |
CREATE TABLE `GL_RESURS_OFFSET` ( |
41 |
`ID` int(10) unsigned NOT NULL auto_increment, |
`ID` int(10) unsigned NOT NULL auto_increment, |
42 |
`FROM_ORBIT` int(10) unsigned NOT NULL default '0', |
`FROM_ORBIT` int(10) unsigned NOT NULL default '0' COMMENT 'if dwlimit = dworbit the file takes the OLD resurs 0 -- SELECT YEAR(OFFSET_DATE),MONTH(OFFSET_DATE),DAY(OFFSET_DATE),HOUR(OFFSET_DATE),MINUTE(OFFSET_DATE),SECOND(OFFSET_DATE),ID FROM GL_RESURS_OFFSET WHERE FROM_ORBIT< " << dworbit << " AND SPECIAL_FILE="" order by FROM_ORBIT desc limit 1;', |
43 |
`SPECIAL_FILE` varchar(255) NOT NULL default '', |
`SPECIAL_FILE` varchar(255) NOT NULL default '', |
44 |
`OFFSET_DATE` timestamp default '0000-00-00 00:00:00', |
`OFFSET_DATE` timestamp default '0000-00-00 00:00:00', |
45 |
`INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP, |
`INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP, |
79 |
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15442_504_001_cln1.pam','2008-12-15 21:00:00',NULL); |
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15442_504_001_cln1.pam','2008-12-15 21:00:00',NULL); |
80 |
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15445_002_001_cln1.pam','2008-12-15 21:00:00',NULL); |
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15445_002_001_cln1.pam','2008-12-15 21:00:00',NULL); |
81 |
INSERT INTO GL_RESURS_OFFSET VALUES(0,'15430','','2009-03-16 21:00:00',NULL); |
INSERT INTO GL_RESURS_OFFSET VALUES(0,'15430','','2009-03-16 21:00:00',NULL); |
82 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','16760_002_001_cln1.pam','2009-03-16 21:00:00',NULL); |
83 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'16740','','2009-06-10 21:00:00',NULL); |
84 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18156_072_001_cln1.pam','2009-06-10 21:00:00',NULL); |
85 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18157_072_001_cln1.pam','2009-06-10 21:00:00',NULL); |
86 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18157_073_001_cln1.pam','2009-06-10 21:00:00',NULL); |
87 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_122_001_cln1.pam','2009-06-10 21:00:00',NULL); |
88 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_123_001_cln1.pam','2009-06-10 21:00:00',NULL); |
89 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_132_001_cln1.pam','2009-06-10 21:00:00',NULL); |
90 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_133_001_cln1.pam','2009-06-10 21:00:00',NULL); |
91 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_152_001_cln1.pam','2009-06-10 21:00:00',NULL); |
92 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_153_001_cln1.pam','2009-06-10 21:00:00',NULL); |
93 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'18150','','2009-09-09 21:00:00',NULL); |
94 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','19526_072_001_cln1.pam','2009-09-09 21:00:00',NULL); |
95 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','19539_073_001_cln1.pam','2009-09-09 21:00:00',NULL); |
96 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'19525','','2009-12-08 21:00:00',NULL); |
97 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','20829_072_001_cln1.pam','2009-12-08 21:00:00',NULL); |
98 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','20829_073_001_cln1.pam','2009-12-08 21:00:00',NULL); |
99 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','20829_074_001_cln1.pam','2009-12-08 21:00:00',NULL); |
100 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','20829_075_001_cln1.pam','2009-12-08 21:00:00',NULL); |
101 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','20829_075_002_cln1.pam','2009-12-08 21:00:00',NULL); |
102 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'20820','','2010-03-03 21:00:00',NULL); |
103 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'22400','','2010-05-30 21:00:00',NULL); |
104 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'23600','','2010-08-28 21:00:00',NULL); |
105 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'24760','','2010-11-15 21:00:00',NULL); |
106 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26089_002_001_cln1.pam','2010-11-15 21:00:00',NULL); |
107 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26089_003_001_cln1.pam','2010-11-15 21:00:00',NULL); |
108 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26089_074_001_cln1.pam','2010-11-15 21:00:00',NULL); |
109 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26089_075_001_cln1.pam','2010-11-15 21:00:00',NULL); |
110 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_026_001_cln1.pam','2010-11-15 21:00:00',NULL); |
111 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26100_002_001_cln1.pam','2010-11-15 21:00:00',NULL); |
112 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26104_074_001_cln1.pam','2010-11-15 21:00:00',NULL); |
113 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'26080','','2011-02-13 21:00:00',NULL); |
114 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'27410','','2011-05-12 21:00:00',NULL); |
115 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','27409_071_001_cln1.pam','2011-02-13 21:00:00',NULL); |
116 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','27436_004_001_cln1.pam','2011-02-13 21:00:00',NULL); |
117 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','27436_005_001_cln1.pam','2011-02-13 21:00:00',NULL); |
118 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','27436_006_001_cln1.pam','2011-02-13 21:00:00',NULL); |
119 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'28990','','2011-08-24 21:00:00',NULL); |
120 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30328_001_001_cln1.pam','2011-11-22 21:00:00',NULL); |
121 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_001_001_cln1.pam','2011-11-22 21:00:00',NULL); |
122 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_002_001_cln1.pam','2011-11-22 21:00:00',NULL); |
123 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_003_001_cln1.pam','2011-11-22 21:00:00',NULL); |
124 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_004_001_cln1.pam','2011-11-22 21:00:00',NULL); |
125 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_005_001_cln1.pam','2011-11-22 21:00:00',NULL); |
126 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'30330','','2011-11-22 21:00:00',NULL); |
127 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','31654_001_001_cln1.pam','2012-02-19 21:00:00',NULL); |
128 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'31660','','2012-02-19 21:00:00',NULL); |
129 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'32950','','2012-05-15 21:00:00',NULL); |
130 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'34330','','2012-08-13 21:00:00',NULL); |
131 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'35600','','2012-11-07 21:00:00',NULL); |
132 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','35612_008_001_cln1.pam','2012-08-13 21:00:00',NULL); |
133 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','35612_007_001_cln1.pam','2012-08-13 21:00:00',NULL); |
134 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','35612_006_001_cln1.pam','2012-08-13 21:00:00',NULL); |
135 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','35612_005_001_cln1.pam','2012-08-13 21:00:00',NULL); |
136 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'36920','','2013-02-05 21:00:00',NULL); |
137 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','36935_005_001_cln1.pam','2012-11-07 21:00:00',NULL); |
138 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','36935_006_001_cln1.pam','2012-11-07 21:00:00',NULL); |
139 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','36935_077_001_cln1.pam','2012-11-07 21:00:00',NULL); |
140 |
|
|
141 |
|
|
142 |
|
|
143 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04584_002_001','2007-01-08 21:00:00',NULL); |
144 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04584_002_002','2007-01-08 21:00:00',NULL); |
145 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04584_003_002','2007-01-08 21:00:00',NULL); |
146 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04584_003_001','2007-01-08 21:00:00',NULL); |
147 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04586_002_001','2007-01-08 21:00:00',NULL); |
148 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04586_002_002','2007-01-08 21:00:00',NULL); |
149 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04586_003_001','2007-01-08 21:00:00',NULL); |
150 |
|
|
151 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','08591_002_001','2007-10-08 21:00:00',NULL); |
152 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','08591_003_002','2007-10-08 21:00:00',NULL); |
153 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','08591_003_001','2007-10-08 21:00:00',NULL); |
154 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','08592_004_002','2007-10-08 21:00:00',NULL); |
155 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','08592_004_003','2007-10-08 21:00:00',NULL); |
156 |
|
|
157 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_001_002','2008-03-20 21:00:00',NULL); |
158 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_001_003','2008-03-20 21:00:00',NULL); |
159 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_002_001','2008-03-20 21:00:00',NULL); |
160 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_002_002','2008-03-20 21:00:00',NULL); |
161 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_003_001','2008-03-20 21:00:00',NULL); |
162 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_003_002','2008-03-20 21:00:00',NULL); |
163 |
|
|
164 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','14033_201_001','2008-12-15 21:00:00',NULL); |
165 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','14034_001_001','2008-12-15 21:00:00',NULL); |
166 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','14044_001_001','2008-12-15 21:00:00',NULL); |
167 |
|
|
168 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15441_002_001','2008-12-15 21:00:00',NULL); |
169 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15441_002_002','2008-12-15 21:00:00',NULL); |
170 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15441_003_001','2008-12-15 21:00:00',NULL); |
171 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15442_002_001','2008-12-15 21:00:00',NULL); |
172 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15442_003_001','2008-12-15 21:00:00',NULL); |
173 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15442_003_002','2008-12-15 21:00:00',NULL); |
174 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15442_504_001','2008-12-15 21:00:00',NULL); |
175 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15442_504_002','2008-12-15 21:00:00',NULL); |
176 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','15445_002_001','2008-12-15 21:00:00',NULL); |
177 |
|
|
178 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','16760_002_001','2009-03-16 21:00:00',NULL); |
179 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','16760_002_002','2009-03-16 21:00:00',NULL); |
180 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','16760_002_003','2009-03-16 21:00:00',NULL); |
181 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','16760_002_004','2009-03-16 21:00:00',NULL); |
182 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','16760_002_005','2009-03-16 21:00:00',NULL); |
183 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','16760_002_006','2009-03-16 21:00:00',NULL); |
184 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','16760_002_007','2009-03-16 21:00:00',NULL); |
185 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','16760_002_008','2009-03-16 21:00:00',NULL); |
186 |
|
|
187 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18156_072_001','2009-06-10 21:00:00',NULL); |
188 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18156_072_002','2009-06-10 21:00:00',NULL); |
189 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18157_072_001','2009-06-10 21:00:00',NULL); |
190 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18157_072_002','2009-06-10 21:00:00',NULL); |
191 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18157_073_001','2009-06-10 21:00:00',NULL); |
192 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18157_073_002','2009-06-10 21:00:00',NULL); |
193 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_032_001','2009-06-10 21:00:00',NULL); |
194 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_032_002','2009-06-10 21:00:00',NULL); |
195 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_033_001','2009-06-10 21:00:00',NULL); |
196 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','18160_033_002','2009-06-10 21:00:00',NULL); |
197 |
|
|
198 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','19526_072_001','2009-09-09 21:00:00',NULL); |
199 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','19526_072_002','2009-09-09 21:00:00',NULL); |
200 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','19539_073_001','2009-09-09 21:00:00',NULL); |
201 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','19539_073_002','2009-09-09 21:00:00',NULL); |
202 |
|
|
203 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','20829_072_001','2009-12-08 21:00:00',NULL); |
204 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','20829_072_002','2009-12-08 21:00:00',NULL); |
205 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','20829_073_001','2009-12-08 21:00:00',NULL); |
206 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','20829_073_002','2009-12-08 21:00:00',NULL); |
207 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','20829_074_002','2009-12-08 21:00:00',NULL); |
208 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','20829_075_001','2009-12-08 21:00:00',NULL); |
209 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_001','2010-11-15 21:00:00',NULL); |
210 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_002','2010-11-15 21:00:00',NULL); |
211 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_003','2010-11-15 21:00:00',NULL); |
212 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_004','2010-11-15 21:00:00',NULL); |
213 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_005','2010-11-15 21:00:00',NULL); |
214 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_006','2010-11-15 21:00:00',NULL); |
215 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_007','2010-11-15 21:00:00',NULL); |
216 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_008','2010-11-15 21:00:00',NULL); |
217 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_009','2010-11-15 21:00:00',NULL); |
218 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_010','2010-11-15 21:00:00',NULL); |
219 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_011','2010-11-15 21:00:00',NULL); |
220 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_012','2010-11-15 21:00:00',NULL); |
221 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_025_013','2010-11-15 21:00:00',NULL); |
222 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_026_001','2010-11-15 21:00:00',NULL); |
223 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_026_002','2010-11-15 21:00:00',NULL); |
224 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_026_003','2010-11-15 21:00:00',NULL); |
225 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_026_004','2010-11-15 21:00:00',NULL); |
226 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_026_005','2010-11-15 21:00:00',NULL); |
227 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_026_006','2010-11-15 21:00:00',NULL); |
228 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26099_026_007','2010-11-15 21:00:00',NULL); |
229 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26100_002_001','2010-11-15 21:00:00',NULL); |
230 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26100_002_002','2010-11-15 21:00:00',NULL); |
231 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26104_074_001','2010-11-15 21:00:00',NULL); |
232 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26104_074_002','2010-11-15 21:00:00',NULL); |
233 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26089_075_002','2010-11-15 21:00:00',NULL); |
234 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26089_075_001','2010-11-15 21:00:00',NULL); |
235 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26089_074_002','2010-11-15 21:00:00',NULL); |
236 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26089_074_001','2010-11-15 21:00:00',NULL); |
237 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26089_003_001','2010-11-15 21:00:00',NULL); |
238 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','26089_002_002','2010-11-15 21:00:00',NULL); |
239 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','27436_006_001','2011-02-13 21:00:00',NULL); |
240 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','27436_005_002','2011-02-13 21:00:00',NULL); |
241 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','27436_004_001','2011-02-13 21:00:00',NULL); |
242 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','27409_071_001','2011-05-12 21:00:00',NULL); |
243 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30328_001_001','2011-11-22 21:00:00',NULL); |
244 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30328_001_002','2011-11-22 21:00:00',NULL); |
245 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_001_001','2011-11-22 21:00:00',NULL); |
246 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_001_002','2011-11-22 21:00:00',NULL); |
247 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_002_001','2011-11-22 21:00:00',NULL); |
248 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_002_002','2011-11-22 21:00:00',NULL); |
249 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_003_001','2011-11-22 21:00:00',NULL); |
250 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_003_002','2011-11-22 21:00:00',NULL); |
251 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_004_001','2011-11-22 21:00:00',NULL); |
252 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_004_002','2011-11-22 21:00:00',NULL); |
253 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','30329_005_001','2011-11-22 21:00:00',NULL); |
254 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','31654_001_001','2012-02-19 21:00:00',NULL); |
255 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','35612_008_001','2012-08-13 21:00:00',NULL); |
256 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','35612_008_002','2012-08-13 21:00:00',NULL); |
257 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','35612_007_001','2012-08-13 21:00:00',NULL); |
258 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','35612_007_002','2012-08-13 21:00:00',NULL); |
259 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','35612_006_001','2012-08-13 21:00:00',NULL); |
260 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','35612_006_002','2012-08-13 21:00:00',NULL); |
261 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','35612_005_001','2012-08-13 21:00:00',NULL); |
262 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','35612_005_002','2012-08-13 21:00:00',NULL); |
263 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','36935_005_001','2012-11-07 21:00:00',NULL); |
264 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','36935_005_002','2012-11-07 21:00:00',NULL); |
265 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','36935_006_001','2012-11-07 21:00:00',NULL); |
266 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','36935_006_002','2012-11-07 21:00:00',NULL); |
267 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','36935_077_001','2012-11-07 21:00:00',NULL); |
268 |
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','36935_077_002','2012-11-07 21:00:00',NULL); |
269 |
|
|
270 |
|
|
271 |
CREATE TABLE `GL_TIMESYNC` ( |
CREATE TABLE `GL_TIMESYNC` ( |
594 |
insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","FCaloADC2MIP.dat",1,1,101,"Calorimeter ADC to MIP from ground data",NULL); |
insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","FCaloADC2MIP.dat",1,1,101,"Calorimeter ADC to MIP from ground data",NULL); |
595 |
insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","FCaloADC2MIPfc.dat",2,4294967295,101,"Calorimeter ADC to MIP from flight, relativistic particles",NULL); |
insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","FCaloADC2MIPfc.dat",2,4294967295,101,"Calorimeter ADC to MIP from flight, relativistic particles",NULL); |
596 |
insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","calo_adc2mip_special0.dat",1,1172976488,110,"Calorimeter ADC to MIP from flight, special cases",NULL); |
insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","calo_adc2mip_special0.dat",1,1172976488,110,"Calorimeter ADC to MIP from flight, special cases",NULL); |
597 |
insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","calo_adc2mip_special1.dat",1172976488,4294967295,110,"Calorimeter ADC to MIP from flight, special cases",NULL); |
insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","calo_adc2mip_special1.dat",1172976488,1190000000,110,"Calorimeter ADC to MIP from flight, special cases",NULL); |
598 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","calo_adc2mip_special2.dat",1190000000,4294967295,110,"Calorimeter ADC to MIP from flight, special cases",NULL); |
599 |
insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","FCaloAlign.dat",1,1,102,"Calorimeter alignement",NULL); |
insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","FCaloAlign.dat",1,1,102,"Calorimeter alignement",NULL); |
600 |
insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","FCaloAlign-flight.dat",1,1,102,"Calorimeter alignement with flight data",NULL); |
insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","FCaloAlign-flight.dat",1,1,102,"Calorimeter alignement with flight data",NULL); |
601 |
insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","FCaloAlign-flightEMS.dat",1,1,102,"Calorimeter alignement with flight data EM showers",NULL); |
insert into GL_PARAM values(0,"$PAM_CALIB/cal-param/","FCaloAlign-flightEMS.dat",1,1,102,"Calorimeter alignement with flight data EM showers",NULL); |
616 |
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_2.rz",1153660001,1154375000,201," 07-23 - 07-31 HV_D problems B B july Parameters_jul24-31.txt",NULL); |
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_2.rz",1153660001,1154375000,201," 07-23 - 07-31 HV_D problems B B july Parameters_jul24-31.txt",NULL); |
617 |
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_3.rz",1154375001,1155850000,201," 07-31 - 08-17 - C C standard",NULL); |
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_3.rz",1154375001,1155850000,201," 07-31 - 08-17 - C C standard",NULL); |
618 |
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_4.rz",1155850001,1156280000,201," 08-17 - 08-22 HV_H&HV_N problems D D august Parameters_aug18-22.txt",NULL); |
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_4.rz",1155850001,1156280000,201," 08-17 - 08-22 HV_H&HV_N problems D D august Parameters_aug18-22.txt",NULL); |
619 |
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_5.rz",1156280001,1165400000,201," 08-22 - 12-06 E E standard",NULL); |
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_5.rz",1156280001,1158700000,201," 08-22 - 09-18 S115B failure E E standard",NULL); |
620 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_5B.rz",1158700001,1165400000,201," 09-18 - 12-06 5B 5B standard",NULL); |
621 |
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_6.rz",1165400001,1168490000,201," 12-06 - 01-11 December Tracker off/on F F standard",NULL); |
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_6.rz",1165400001,1168490000,201," 12-06 - 01-11 December Tracker off/on F F standard",NULL); |
622 |
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_7.rz",1168490001,1168940000,201," 01-11 - 01-16 HV_D problems G G january calper02.txt",NULL); |
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_7.rz",1168490001,1168940000,201," 01-11 - 01-16 HV_D problems G G january calper02.txt",NULL); |
623 |
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_8.rz",1168940001,1169580000,201," 01-16 - 01-23 HV_F & HV_M problems G G january calper03.txt",NULL); |
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_8.rz",1168940001,1169580000,201," 01-16 - 01-23 HV_F & HV_M problems G G january calper03.txt",NULL); |
651 |
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_36.rz",1229470001,1229730000,201," 12-17 - 12-19 HV_E problems (?) 36 36 calper_36",NULL); |
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_36.rz",1229470001,1229730000,201," 12-17 - 12-19 HV_E problems (?) 36 36 calper_36",NULL); |
652 |
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_37.rz",1229730001,1230318000,201," 12-19 - 12-26 good 37 37 calper_37",NULL); |
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_37.rz",1229730001,1230318000,201," 12-19 - 12-26 good 37 37 calper_37",NULL); |
653 |
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_38.rz",1230318001,1230410000,201," 12-26 - 12-27 HV_H problems 38 38 calper_38",NULL); |
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_38.rz",1230318001,1230410000,201," 12-26 - 12-27 HV_H problems 38 38 calper_38",NULL); |
654 |
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_39.rz",1230410001,4294967295,201," > 12-27 good 39 39 calper_39",NULL); |
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_39.rz",1230410001,1230768000,201," 12-27 - 12-31 good 39 39 calper_39",NULL); |
655 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_41.rz",1230768001,1232496000,201," 09-01-01 09-01-20 good",NULL); |
656 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_42.rz",1232496001,1235347200,201," 09-01-21 09-02-22 good",NULL); |
657 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_43.rz",1235347201,1238544000,201," 09-02-23 09-03-31 good",NULL); |
658 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_44.rz",1238544001,1241136000,201," 09-04-01 09-04-30 good",NULL); |
659 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_45.rz",1241136001,1243814400,201," 09-05-01 09-05-31 good",NULL); |
660 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_46.rz",1243814401,1246406400,201," 09-06-01 09-06-30 good",NULL); |
661 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_47.rz",1246406401,1249084800,201," 09-07-01 09-07-31 good",NULL); |
662 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_48.rz",1249084801,1251763200,201," 09-08-01 09-08-31 good",NULL); |
663 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_49.rz",1251763201,1254355200,201," 09-09-01 09-09-30 good",NULL); |
664 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_50.rz",1254355201,1257033600,201," 09-10-01 09-10-31 good",NULL); |
665 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_51.rz",1257033601,1259625600,201," 09-11-01 09-11-30 good",NULL); |
666 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_52.rz",1259625601,1262304000,201," 09-12-01 09-12-31 good",NULL); |
667 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","tofcalib_53.rz",1262304001,4294967295,201," >10-01-01 good",NULL); |
668 |
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","ToFCalibParam.txt",1,4294967295,202," GP ToF parameters ",NULL); |
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","ToFCalibParam.txt",1,4294967295,202," GP ToF parameters ",NULL); |
669 |
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","adcmonitor.100k.cut.dat",1,4294967295,203," ToF dE/dx II order correction parameters ",NULL); |
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","adcmonitor.100k.cut.dat",1,1,203," ToF dE/dx II order correction parameters ",NULL); |
670 |
insert into GL_PARAM values(0,"$PAM_CALIB/orb-param/","igrf05.dat",0,0,301,"igrf 2005",NULL); |
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","dedxmonitor.C.5d.8th.all.dat",1,1,203," ToF dE/dx II order correction parameters ",NULL); |
671 |
insert into GL_PARAM values(0,"$PAM_CALIB/orb-param/","igrf05s.dat",0,0,302,"igrf 2010",NULL); |
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","dedxmonitor.He.8th.all.dat",1,1,203," ToF dE/dx II order correction parameters based on He",NULL); |
672 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","dedxmonitor.He.9th.all.dat",1,1,203," ToF dE/dx II order correction parameters based on He 9th data reduction",NULL); |
673 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","calibfile_tofdedx_x10thred.txt",1,4294967295,203," ToF dE/dx II order correction parameters - Rita",NULL); |
674 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_1.dat",1,1150848001,204," ToF attenuation parameter file period 1 ",NULL); |
675 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_2.dat",1150848000,1154995201,204," ToF attenuation parameter file period 2 ",NULL); |
676 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_3.dat",1154995200,1158019201,204," ToF attenuation parameter file period 3 ",NULL); |
677 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_4.dat",1158019200,1161216001,204," ToF attenuation parameter file period 4 ",NULL); |
678 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_5.dat",1161216000,1164499201,204," ToF attenuation parameter file period 5 ",NULL); |
679 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_6.dat",1164499200,1167955201,204," ToF attenuation parameter file period 6 ",NULL); |
680 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_7.dat",1167955200,1171670401,204," ToF attenuation parameter file period 7 ",NULL); |
681 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_8.dat",1171670400,1175472001,204," ToF attenuation parameter file period 8 ",NULL); |
682 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_9.dat",1175472000,1179446401,204," ToF attenuation parameter file period 9 ",NULL); |
683 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_10.dat",1179446400,1184284801,204," ToF attenuation parameter file period 10 ",NULL); |
684 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_11.dat",1184284800,1188691201,204," ToF attenuation parameter file period 11 ",NULL); |
685 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_12.dat",1188691200,1193356801,204," ToF attenuation parameter file period 12 ",NULL); |
686 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_13.dat",1193356800,1198195201,204," ToF attenuation parameter file period 13 ",NULL); |
687 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_14.dat",1198195200,1203292801,204," ToF attenuation parameter file period 14 ",NULL); |
688 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_15.dat",1203292800,1208822401,204," ToF attenuation parameter file period 15 ",NULL); |
689 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_16.dat",1208822400,1214524801,204," ToF attenuation parameter file period 16 ",NULL); |
690 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_17.dat",1214524800,1220659201,204," ToF attenuation parameter file period 17 ",NULL); |
691 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_18.dat",1220659200,1228953601,204," ToF attenuation parameter file period 18 ",NULL); |
692 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_19.dat",1228953600,1237593601,204," ToF attenuation parameter file period 19 ",NULL); |
693 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_20.dat",1237593600,1244592001,204," ToF attenuation parameter file period 20 ",NULL); |
694 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_21.dat",1244592000,1252108801,204," ToF attenuation parameter file period 21 ",NULL); |
695 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","atten_period_22.dat",1252108800,4294967295,204," ToF attenuation parameter file period 22 ",NULL); |
696 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","attenuation.txt",1,1,204," ToF attenuation parameter file ",NULL); |
697 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","desaturation_position.txt",1,4294967295,205," ToF desaturation on position parameter file ",NULL); |
698 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","BetheBloch.txt",1,4294967295,206," ToF BetheBloch parameter file ",NULL); |
699 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","BetheBloch_betagt1.txt",1,4294967295,207," ToF Bethe-Bloch parameter file for beta gt1 ",NULL); |
700 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/tof-param/","desaturation_beta.txt",1,4294967295,208," ToF desaturation on beta parameter file ",NULL); |
701 |
|
insert into GL_PARAM values(0,"","",1182100001,1183030000,210," A connector ",NULL); |
702 |
|
insert into GL_PARAM values(0,"","",1174665001,1175000000,211," B connector ",NULL); |
703 |
|
insert into GL_PARAM values(0,"","",1206100001,1206375600,212," C connector ",NULL); |
704 |
|
insert into GL_PARAM values(0,"","",1153660001,1154375000,213," D connector ",NULL); |
705 |
|
insert into GL_PARAM values(0,"","",1168490001,1168940000,213," D connector ",NULL); |
706 |
|
insert into GL_PARAM values(0,"","",1185090001,1185212000,213," D connector ",NULL); |
707 |
|
insert into GL_PARAM values(0,"","",1191100001,1191940000,213," D connector ",NULL); |
708 |
|
insert into GL_PARAM values(0,"","",1176800001,1178330000,214," E connector ",NULL); |
709 |
|
insert into GL_PARAM values(0,"","",1217989201,1218547800,214," E connector ",NULL); |
710 |
|
insert into GL_PARAM values(0,"","",1225789201,1226566800,214," E connector ",NULL); |
711 |
|
insert into GL_PARAM values(0,"","",1229400901,1229700000,214," E connector ",NULL); |
712 |
|
insert into GL_PARAM values(0,"","",1230318001,1230415200,214," E connector ",NULL); |
713 |
|
insert into GL_PARAM values(0,"","",1168940001,1169580000,215," F connector ",NULL); |
714 |
|
insert into GL_PARAM values(0,"","",1155850001,1156280000,217," H connector ",NULL); |
715 |
|
insert into GL_PARAM values(0,"","",1176120001,1176800000,217," H connector ",NULL); |
716 |
|
insert into GL_PARAM values(0,"","",1178330001,1181322000,217," H connector ",NULL); |
717 |
|
insert into GL_PARAM values(0,"","",1184000001,1184570000,217," H connector ",NULL); |
718 |
|
insert into GL_PARAM values(0,"","",1196230001,1196280000,217," H connector ",NULL); |
719 |
|
insert into GL_PARAM values(0,"","",1168940001,1169580000,220," M connector ",NULL); |
720 |
|
insert into GL_PARAM values(0,"","",1155850001,1156280000,221," N connector ",NULL); |
721 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/orb-param/","igrf00.dat",1,1104537600,301,"igrf 2000",NULL); |
722 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/orb-param/","igrf05.dat",1104537601,1264400000,301,"igrf 2005",NULL); |
723 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/orb-param/","igrf10.dat",1264400001,4294967295,301,"igrf 2010",NULL); |
724 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/orb-param/","igrf00.dat",1,946684800,302,"igrf 2000 for interpolations",NULL); |
725 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/orb-param/","igrf05.dat",946684801,1104537600,302,"igrf 2005 for interpolations",NULL); |
726 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/orb-param/","igrf10.dat",1104537601,1264400000,302,"igrf 2010 for interpolations",NULL); |
727 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/orb-param/","igrf10s.dat",1264400001,4294967295,302,"igrf 2015 estimated",NULL); |
728 |
|
insert into GL_PARAM values(0,"$PAM_CALIB/orb-param/","SortQuat.txt",0,0,303,"Quaternion from Resurs",NULL); |
729 |
|
|
730 |
CREATE TABLE `GL_TLE` ( |
CREATE TABLE `GL_TLE` ( |
731 |
`ID` int(10) NOT NULL auto_increment, |
`ID` int(10) NOT NULL auto_increment, |
984 |
`INPUT_NAME` varchar(255) default './nnnnmmm.pam' COMMENT 'It is the filename of the input file', |
`INPUT_NAME` varchar(255) default './nnnnmmm.pam' COMMENT 'It is the filename of the input file', |
985 |
`TIME_IS_ESTIMATED` tinyint(1) unsigned NOT NULL default '0' COMMENT 'No timesync was found for this entry, we use a timesync from the same download', |
`TIME_IS_ESTIMATED` tinyint(1) unsigned NOT NULL default '0' COMMENT 'No timesync was found for this entry, we use a timesync from the same download', |
986 |
`INSERT_TIME` timestamp default CURRENT_TIMESTAMP, |
`INSERT_TIME` timestamp default CURRENT_TIMESTAMP, |
987 |
|
`INSERTED_BY` varchar(4) NOT NULL default 'NONE' COMMENT 'The owner of the file', |
988 |
|
`ON_DISK` varchar(3) NOT NULL default 'YES' COMMENT 'The file is on disk (no deleted)', |
989 |
PRIMARY KEY (`ID_N`) |
PRIMARY KEY (`ID_N`) |
990 |
) |
) |
991 |
; |
; |
1012 |
`INPUT_NAME` varchar(255) default './nnnnmmm.pam' COMMENT 'It is the filename of the input file', |
`INPUT_NAME` varchar(255) default './nnnnmmm.pam' COMMENT 'It is the filename of the input file', |
1013 |
`TIME_IS_ESTIMATED` tinyint(1) unsigned NOT NULL default '0' COMMENT 'No timesync was found for this entry, we use a timesync from the same download', |
`TIME_IS_ESTIMATED` tinyint(1) unsigned NOT NULL default '0' COMMENT 'No timesync was found for this entry, we use a timesync from the same download', |
1014 |
`INSERT_TIME` timestamp default CURRENT_TIMESTAMP, |
`INSERT_TIME` timestamp default CURRENT_TIMESTAMP, |
1015 |
|
`INSERTED_BY` varchar(4) NOT NULL default 'NONE' COMMENT 'The owner of the file', |
1016 |
|
`ON_DISK` varchar(3) NOT NULL default 'YES' COMMENT 'The file is on disk (no deleted)', |
1017 |
PRIMARY KEY (`ID_N`) |
PRIMARY KEY (`ID_N`) |
1018 |
) |
) |
1019 |
; |
; |
1020 |
|
|
|
|
|
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04584_002_001','2007-01-08 21:00:00',NULL); |
|
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04584_002_002','2007-01-08 21:00:00',NULL); |
|
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04584_003_002','2007-01-08 21:00:00',NULL); |
|
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04584_003_001','2007-01-08 21:00:00',NULL); |
|
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04586_002_001','2007-01-08 21:00:00',NULL); |
|
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04586_002_002','2007-01-08 21:00:00',NULL); |
|
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04586_003_001','2007-01-08 21:00:00',NULL); |
|
|
|
|
|
|
|
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','08591_002_001','2007-10-08 21:00:00',NULL); |
|
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','08591_003_002','2007-10-08 21:00:00',NULL); |
|
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','08591_003_001','2007-10-08 21:00:00',NULL); |
|
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','08592_004_001','2007-10-08 21:00:00',NULL); |
|
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','08592_004_002','2007-10-08 21:00:00',NULL); |
|
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','08592_004_005','2007-10-08 21:00:00',NULL); |
|
|
|
|
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11309_001_002','2008-03-20 21:00:00',NULL); |
|
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_001_002','2008-03-20 21:00:00',NULL); |
|
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_001_003','2008-03-20 21:00:00',NULL); |
|
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_002_001','2008-03-20 21:00:00',NULL); |
|
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_002_002','2008-03-20 21:00:00',NULL); |
|
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_003_001','2008-03-20 21:00:00',NULL); |
|
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','11310_003_002','2008-03-20 21:00:00',NULL); |
|
|
|
|
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','12874_002_001','2008-06-19 21:00:00',NULL); |
|
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','12875_003_001','2008-06-19 21:00:00',NULL); |
|
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','12875_202_003','2008-06-19 21:00:00',NULL); |
|
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','12875_202_004','2008-06-19 21:00:00',NULL); |
|
|
|
|
|
|
|
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','14034_001_001','2008-12-15 21:00:00',NULL); |
|
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','14033_201_001','2008-12-15 21:00:00',NULL); |
|
|
|
|
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','14044_001_001','2008-12-15 21:00:00',NULL); |
|
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','14044_001_002','2008-12-15 21:00:00',NULL); |
|
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','14045_001_003','2008-09-18 21:00:00',NULL); |
|
|
INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','14045_001_004','2008-09-18 21:00:00',NULL); |
|
|
|
|
|
|
|
|
|
|
1021 |
drop table if exists dbname.ROOT_TABLE_MERGING ; |
drop table if exists dbname.ROOT_TABLE_MERGING ; |
1022 |
CREATE TABLE `dbname`.`ROOT_TABLE_MERGING` ( |
CREATE TABLE `dbname`.`ROOT_TABLE_MERGING` ( |
1023 |
`ID_N` int unsigned NOT NULL auto_increment COMMENT 'It is the internal table ID', |
`ID_N` int unsigned NOT NULL auto_increment COMMENT 'It is the internal table ID', |