/[PAMELA software]/YodaProfiler/docs/PAMELAProductionDB.sql
ViewVC logotype

Contents of /YodaProfiler/docs/PAMELAProductionDB.sql

Parent Directory Parent Directory | Revision Log Revision Log

Revision 1.11 - (show annotations) (download)
Mon Apr 16 12:35:52 2007 UTC (17 years, 10 months ago) by mocchiut
Branch: MAIN
Changes since 1.10: +5 -0 lines 
Updated Resurs time zero
1 DROP DATABASE IF EXISTS dbname;
2
3 CREATE DATABASE dbname;
4
5 USE dbname;
6
7 SET time_zone='+0:00';
8
9 CREATE TABLE `_RUNID_GEN` (
10 `ID` int(10) unsigned NOT NULL auto_increment,
11 PRIMARY KEY (`ID`)
12 ) ENGINE=InnoDB;
13
14 CREATE TABLE `GL_RAW` (
15 `ID` int(10) unsigned NOT NULL auto_increment,
16 `PATH` varchar(255) NOT NULL default '',
17 `NAME` varchar(255) NOT NULL default '',
18 `BOOT_NUMBER` smallint(5) unsigned default NULL,
19 `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,
20 PRIMARY KEY (`ID`),
21 KEY `BOOTNUMBER_index` (`BOOT_NUMBER`),
22 KEY `PATH_index` (`PATH`)
23 ) ENGINE=InnoDB;
24
25 INSERT INTO GL_RAW VALUES(0,'path to','level2 files',NULL,NULL);
26
27 CREATE TABLE `GL_ROOT` (
28 `ID` int(10) unsigned NOT NULL auto_increment,
29 `ID_RAW` int(10) unsigned NOT NULL default '0',
30 `ID_TIMESYNC` int(10) unsigned NOT NULL default '0',
31 `PATH` varchar(255) NOT NULL default '',
32 `NAME` varchar(255) NOT NULL default '',
33 `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,
34 PRIMARY KEY (`ID`),
35 KEY `ID_RAW_index` (`ID_RAW`),
36 KEY `PATH_index` (`PATH`),
37 CONSTRAINT `ROOT_fk` FOREIGN KEY (`ID_RAW`) REFERENCES `GL_RAW` (`ID`) ON DELETE CASCADE
38 ) ENGINE=InnoDB;
39
40 CREATE TABLE `GL_RESURS_OFFSET` (
41 `ID` int(10) unsigned NOT NULL auto_increment,
42 `FROM_ORBIT` int(10) unsigned NOT NULL default '0',
43 `SPECIAL_FILE` varchar(255) NOT NULL default '',
44 `OFFSET_DATE` timestamp default '0000-00-00 00:00:00',
45 `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,
46 PRIMARY KEY (`ID`)
47 ) ENGINE=InnoDB;
48
49 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','','2006-06-14 21:00:00',NULL);
50 INSERT INTO GL_RESURS_OFFSET VALUES(0,'1619','','2006-09-28 21:00:00',NULL);
51 INSERT INTO GL_RESURS_OFFSET VALUES(0,'2797','','2006-12-12 21:00:00',NULL);
52 INSERT INTO GL_RESURS_OFFSET VALUES(0,'3221','','2007-01-08 21:00:00',NULL);
53 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04584_002_001_cln1.pam','2007-01-08 21:00:00',NULL);
54 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04584_003_001_cln1.pam','2007-01-08 21:00:00',NULL);
55 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04586_002_001_cln1.pam','2007-01-08 21:00:00',NULL);
56 INSERT INTO GL_RESURS_OFFSET VALUES(0,'0','04586_003_001_cln1.pam','2007-01-08 21:00:00',NULL);
57 INSERT INTO GL_RESURS_OFFSET VALUES(0,'4576','','2007-04-08 21:00:00',NULL);
58
59 CREATE TABLE `GL_TIMESYNC` (
60 `ID` int(10) unsigned NOT NULL auto_increment,
61 `ID_RAW` int(10) unsigned NOT NULL default '0',
62 `OBT0` int(10) unsigned NOT NULL default '0',
63 `TIMESYNC` int(10) unsigned NOT NULL default '0',
64 `TYPE` smallint(5) unsigned NOT NULL default '0',
65 PRIMARY KEY (`ID`),
66 KEY `ID_RAW_index` (`ID_RAW`),
67 KEY `TYPE_index` (`TYPE`),
68 CONSTRAINT `TIME_RAW_fk` FOREIGN KEY (`ID_RAW`) REFERENCES `GL_RAW` (`ID`) ON DELETE CASCADE
69 ) ENGINE=InnoDB;
70
71 CREATE TABLE `GL_PARAM` (
72 `ID` int(10) unsigned NOT NULL auto_increment,
73 `PATH` varchar(255) NOT NULL default '',
74 `NAME` varchar(255) NOT NULL default '',
75 `FROM_TIME` int(10) unsigned NOT NULL default '0',
76 `TO_TIME` int(10) unsigned NOT NULL default '0',
77 `TYPE` smallint(5) unsigned NOT NULL default '0',
78 `DESCR` varchar(255) NOT NULL default '',
79 `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,
80 PRIMARY KEY (`ID`),
81 KEY `PATH_index` (`PATH`),
82 KEY `NAME_index` (`NAME`),
83 KEY `TYPE_index` (`TYPE`),
84 KEY `DESCR_index` (`DESCR`)
85 ) ENGINE=InnoDB;
86
87 CREATE TABLE `GL_TLE` (
88 `ID` int(10) NOT NULL auto_increment,
89 `TLE1` varchar(255) NOT NULL default '',
90 `TLE2` varchar(255) NOT NULL default '',
91 `TLE3` varchar(255) NOT NULL default '',
92 `FROM_TIME` datetime NOT NULL default '0000-00-00 00:00:00',
93 `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,
94 PRIMARY KEY (`ID`)
95 ) ENGINE=InnoDB;
96
97 CREATE TABLE `GL_RUN` (
98 `ID` int(10) unsigned NOT NULL auto_increment,
99 `ID_RUN_FRAG` int(10) unsigned NOT NULL default '0',
100 `ID_ROOT_L0` int(10) unsigned NOT NULL default '0',
101 `ID_ROOT_L2` int(10) unsigned NOT NULL default '0',
102 `RUNHEADER_TIME` int(10) unsigned NOT NULL default '0',
103 `RUNTRAILER_TIME` int(10) unsigned NOT NULL default '0',
104 `RUNHEADER_OBT` int(10) unsigned NOT NULL default '0',
105 `RUNTRAILER_OBT` int(10) unsigned NOT NULL default '0',
106 `RUNHEADER_PKT` int(10) unsigned NOT NULL default '0',
107 `RUNTRAILER_PKT` int(10) unsigned NOT NULL default '0',
108 `BOOT_NUMBER` smallint(5) unsigned NOT NULL default '0',
109 `EV_FROM` int(10) unsigned NOT NULL default '0',
110 `EV_TO` int(10) unsigned NOT NULL default '0',
111 `NEVENTS` int(10) unsigned NOT NULL default '0',
112 `PKT_COUNTER` int(10) unsigned NOT NULL default '0',
113 `PKT_READY_COUNTER` int(10) unsigned NOT NULL default '0',
114 `COMPILATIONTIMESTAMP` int(10) unsigned NOT NULL default '0',
115 `FAV_WRK_SCHEDULE` tinyint(3) unsigned NOT NULL default '0',
116 `EFF_WRK_SCHEDULE` tinyint(3) unsigned NOT NULL default '0',
117 `PRH_VAR_TRG_MODE_A` int(10) unsigned NOT NULL default '0',
118 `PRH_VAR_TRG_MODE_B` int(10) unsigned NOT NULL default '0',
119 `ACQ_BUILD_INFO` int(10) unsigned NOT NULL default '0',
120 `ACQ_VAR_INFO` smallint(5) unsigned NOT NULL default '0',
121 `RM_ACQ_AFTER_CALIB` tinyint(3) NOT NULL default '0',
122 `RM_ACQ_SETTING_MODE` tinyint(3) NOT NULL default '0',
123 `TRK_CALIB_USED` int(10) unsigned NOT NULL default '0',
124 `CAL_DSP_MASK` tinyint(3) unsigned NOT NULL default '0',
125 `LAST_TIMESYNC` int(10) unsigned NOT NULL default '0',
126 `OBT_TIMESYNC` int(10) unsigned NOT NULL default '0',
127 `VALIDATION` tinyint(3) unsigned NOT NULL default '0',
128 `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,
129 PRIMARY KEY (`ID`),
130 KEY `ID_RUN_FRAG_index` (`ID_RUN_FRAG`),
131 KEY `ID_ROOT_L0_index` (`ID_ROOT_L0`),
132 KEY `ID_ROOT_L2_index` (`ID_ROOT_L2`),
133 KEY `COMPILATIONTS_index` (`COMPILATIONTIMESTAMP`),
134 KEY `VALID_index` (`VALIDATION`),
135 KEY `TRKCALIB_index` (`TRK_CALIB_USED`),
136 KEY `CALDSPMASK_index` (`CAL_DSP_MASK`),
137 KEY `EFF_WS_index` (`EFF_WRK_SCHEDULE`),
138 KEY `FAV_WS_index` (`FAV_WRK_SCHEDULE`),
139 KEY `RM_ACQ_AFTER_CALIB_index` (`RM_ACQ_AFTER_CALIB`),
140 KEY `RM_ACQ_SETTING_MODE_index` (`RM_ACQ_SETTING_MODE`),
141 KEY `ACQ_VAR_INFO_index` (`ACQ_VAR_INFO`),
142 KEY `TRG_MODE_A_index` (`PRH_VAR_TRG_MODE_A`),
143 KEY `TRG_MODE_B_index` (`PRH_VAR_TRG_MODE_B`),
144 KEY `NEVENTS_index` (`NEVENTS`),
145 KEY `BOOTNUMBER_index` (`BOOT_NUMBER`),
146 KEY `ID_RUN_fk_constraint` (`ID_ROOT_L0`),
147 KEY `ID_RUN_L2_fk_constraint` (`ID_ROOT_L2`)
148 ) ENGINE=InnoDB;
149
150 CREATE TABLE `GL_RUN_FRAGMENTS` (
151 `ID` int(10) unsigned NOT NULL auto_increment,
152 `ID_RUN_FRAG` int(10) unsigned NOT NULL default '0',
153 `ID_ROOT_L0` int(10) unsigned NOT NULL default '0',
154 `ID_ROOT_L2` int(10) unsigned NOT NULL default '0',
155 `RUNHEADER_TIME` int(10) unsigned NOT NULL default '0',
156 `RUNTRAILER_TIME` int(10) unsigned NOT NULL default '0',
157 `RUNHEADER_OBT` int(10) unsigned NOT NULL default '0',
158 `RUNTRAILER_OBT` int(10) unsigned NOT NULL default '0',
159 `RUNHEADER_PKT` int(10) unsigned NOT NULL default '0',
160 `RUNTRAILER_PKT` int(10) unsigned NOT NULL default '0',
161 `BOOT_NUMBER` smallint(5) unsigned NOT NULL default '0',
162 `EV_FROM` int(10) unsigned NOT NULL default '0',
163 `EV_TO` int(10) unsigned NOT NULL default '0',
164 `NEVENTS` int(10) unsigned NOT NULL default '0',
165 `PKT_COUNTER` int(10) unsigned NOT NULL default '0',
166 `PKT_READY_COUNTER` int(10) unsigned NOT NULL default '0',
167 `COMPILATIONTIMESTAMP` int(10) unsigned NOT NULL default '0',
168 `FAV_WRK_SCHEDULE` tinyint(3) unsigned NOT NULL default '0',
169 `EFF_WRK_SCHEDULE` tinyint(3) unsigned NOT NULL default '0',
170 `PRH_VAR_TRG_MODE_A` int(10) unsigned NOT NULL default '0',
171 `PRH_VAR_TRG_MODE_B` int(10) unsigned NOT NULL default '0',
172 `ACQ_BUILD_INFO` int(10) unsigned NOT NULL default '0',
173 `ACQ_VAR_INFO` smallint(5) unsigned NOT NULL default '0',
174 `RM_ACQ_AFTER_CALIB` tinyint(3) NOT NULL default '0',
175 `RM_ACQ_SETTING_MODE` tinyint(3) NOT NULL default '0',
176 `TRK_CALIB_USED` int(10) unsigned NOT NULL default '0',
177 `CAL_DSP_MASK` tinyint(3) unsigned NOT NULL default '0',
178 `LAST_TIMESYNC` int(10) unsigned NOT NULL default '0',
179 `OBT_TIMESYNC` int(10) unsigned NOT NULL default '0',
180 `VALIDATION` tinyint(3) unsigned NOT NULL default '0',
181 `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,
182 PRIMARY KEY (`ID`),
183 KEY `ID_RUN_FRAG_index` (`ID_RUN_FRAG`),
184 KEY `ID_ROOT_L0_index` (`ID_ROOT_L0`),
185 KEY `BOOTNUMBER_index` (`BOOT_NUMBER`),
186 KEY `TRKCALIB_index` (`TRK_CALIB_USED`),
187 KEY `NID_RUN_fk_constraint` (`ID_ROOT_L0`)
188 ) ENGINE=InnoDB;
189
190 CREATE TABLE `GL_RUN_TRASH` (
191 `ID_TRASH` int(10) unsigned NOT NULL auto_increment,
192 `ID` int(10) unsigned NOT NULL default '0',
193 `ID_RUN_FRAG` int(10) unsigned NOT NULL default '0',
194 `ID_ROOT_L0` int(10) unsigned NOT NULL default '0',
195 `ID_ROOT_L2` int(10) unsigned NOT NULL default '0',
196 `RUNHEADER_TIME` int(10) unsigned NOT NULL default '0',
197 `RUNTRAILER_TIME` int(10) unsigned NOT NULL default '0',
198 `RUNHEADER_OBT` int(10) unsigned NOT NULL default '0',
199 `RUNTRAILER_OBT` int(10) unsigned NOT NULL default '0',
200 `RUNHEADER_PKT` int(10) unsigned NOT NULL default '0',
201 `RUNTRAILER_PKT` int(10) unsigned NOT NULL default '0',
202 `BOOT_NUMBER` smallint(5) unsigned NOT NULL default '0',
203 `EV_FROM` int(10) unsigned NOT NULL default '0',
204 `EV_TO` int(10) unsigned NOT NULL default '0',
205 `NEVENTS` int(10) unsigned NOT NULL default '0',
206 `PKT_COUNTER` int(10) unsigned NOT NULL default '0',
207 `PKT_READY_COUNTER` int(10) unsigned NOT NULL default '0',
208 `COMPILATIONTIMESTAMP` int(10) unsigned NOT NULL default '0',
209 `FAV_WRK_SCHEDULE` tinyint(3) unsigned NOT NULL default '0',
210 `EFF_WRK_SCHEDULE` tinyint(3) unsigned NOT NULL default '0',
211 `PRH_VAR_TRG_MODE_A` int(10) unsigned NOT NULL default '0',
212 `PRH_VAR_TRG_MODE_B` int(10) unsigned NOT NULL default '0',
213 `ACQ_BUILD_INFO` int(10) unsigned NOT NULL default '0',
214 `ACQ_VAR_INFO` smallint(5) unsigned NOT NULL default '0',
215 `RM_ACQ_AFTER_CALIB` tinyint(3) NOT NULL default '0',
216 `RM_ACQ_SETTING_MODE` tinyint(3) NOT NULL default '0',
217 `TRK_CALIB_USED` int(10) unsigned NOT NULL default '0',
218 `CAL_DSP_MASK` tinyint(3) unsigned NOT NULL default '0',
219 `LAST_TIMESYNC` int(10) unsigned NOT NULL default '0',
220 `OBT_TIMESYNC` int(10) unsigned NOT NULL default '0',
221 `VALIDATION` tinyint(3) unsigned NOT NULL default '0',
222 `FILENAMEL0` varchar(255) NOT NULL default '',
223 `FILENAMEL2` varchar(255) NOT NULL default '',
224 `BELONGED_TO` varchar(255) NOT NULL default '',
225 `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,
226 PRIMARY KEY (`ID_TRASH`),
227 KEY `TID_RUN_FRAG_index` (`ID_RUN_FRAG`),
228 KEY `TID_ROOT_L0_index` (`ID_ROOT_L0`),
229 KEY `TBOOTNUMBER_index` (`BOOT_NUMBER`),
230 KEY `TTRKCALIB_index` (`TRK_CALIB_USED`),
231 KEY `TFNAME0_index` (`FILENAMEL0`),
232 KEY `TFNAME2_index` (`FILENAMEL2`),
233 KEY `TBELONG_index` (`BELONGED_TO`)
234 ) ENGINE=InnoDB;
235
236 CREATE TABLE `GL_CALO_CALIB` (
237 `ID` int(10) unsigned NOT NULL auto_increment,
238 `ID_ROOT_L0` int(10) unsigned NOT NULL default '0',
239 `EV_ROOT` int(10) unsigned NOT NULL default '0',
240 `FROM_TIME` int(10) unsigned NOT NULL default '0',
241 `TO_TIME` int(10) unsigned NOT NULL default '0',
242 `SECTION` tinyint(3) unsigned NOT NULL default '0',
243 `OBT` int(10) unsigned NOT NULL default '0',
244 `PKT` int(10) unsigned NOT NULL default '0',
245 `BOOT_NUMBER` smallint(5) unsigned NOT NULL default '0',
246 `VALIDATION` tinyint(3) unsigned NOT NULL default '0',
247 PRIMARY KEY (`ID`),
248 KEY `SECTION_index` (`SECTION`),
249 KEY `EV_ROOT_index` (`EV_ROOT`),
250 KEY `ID_ROOT_index` (`ID_ROOT_L0`),
251 KEY `BOOTNUMBER_index` (`BOOT_NUMBER`),
252 KEY `VALID1_index` (`VALIDATION`)
253 ) ENGINE=InnoDB;
254
255 CREATE TABLE `GL_TRK_CALIB` (
256 `ID` int(10) unsigned NOT NULL auto_increment,
257 `ID_ROOT_L0` int(10) unsigned NOT NULL default '0',
258 `EV_ROOT_CALIBTRK1` int(10) unsigned default NULL,
259 `EV_ROOT_CALIBTRK2` int(10) unsigned default NULL,
260 `FROM_TIME` int(10) unsigned NOT NULL default '0',
261 `TO_TIME` int(10) unsigned NOT NULL default '0',
262 `OBT1` int(10) unsigned NOT NULL default '0',
263 `PKT1` int(10) unsigned NOT NULL default '0',
264 `OBT2` int(10) unsigned NOT NULL default '0',
265 `PKT2` int(10) unsigned NOT NULL default '0',
266 `BOOT_NUMBER` smallint(5) unsigned NOT NULL default '0',
267 `VALIDATION` tinyint(3) unsigned NOT NULL default '0',
268 PRIMARY KEY (`ID`),
269 KEY `ID_ROOT_index` (`ID_ROOT_L0`),
270 KEY `EV_ROOT_CALIBTRK1index` (`EV_ROOT_CALIBTRK1`),
271 KEY `EV_ROOT_CALIBTRK2index` (`EV_ROOT_CALIBTRK2`),
272 KEY `BOOTNUMBER_index` (`BOOT_NUMBER`),
273 KEY `VALID2_index` (`VALIDATION`)
274 ) ENGINE=InnoDB;
275
276 CREATE TABLE `GL_S4_CALIB` (
277 `ID` int(10) unsigned NOT NULL auto_increment,
278 `ID_ROOT_L0` int(10) unsigned NOT NULL default '0',
279 `EV_ROOT` int(10) unsigned NOT NULL default '0',
280 `FROM_TIME` int(10) unsigned NOT NULL default '0',
281 `TO_TIME` int(10) unsigned NOT NULL default '0',
282 `OBT` int(10) unsigned NOT NULL default '0',
283 `PKT` int(10) unsigned NOT NULL default '0',
284 `BOOT_NUMBER` smallint(5) unsigned NOT NULL default '0',
285 PRIMARY KEY (`ID`),
286 KEY `ID_ROOT_index` (`ID_ROOT_L0`),
287 KEY `BOOTNUMBER_index` (`BOOT_NUMBER`)
288 ) ENGINE=InnoDB;
289
290
  ViewVC Help
Powered by ViewVC 1.1.23