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

Contents of /YodaProfiler/docs/PAMELAProductionDB.txt

Parent Directory Parent Directory | Revision Log Revision Log

Revision 1.1.1.1 - (show annotations) (download) (vendor branch)
Wed Aug 30 11:18:14 2006 UTC (18 years, 3 months ago) by mocchiut
Branch: YodaProfiler
CVS Tags: start, v0r00
Changes since 1.1: +0 -0 lines
File MIME type: text/plain 
Imported sources
1 CREATE TABLE `GL_RAW` (
2 `ID` int(10) unsigned NOT NULL auto_increment,
3 `PATH` varchar(255) NOT NULL default '',
4 `NAME` varchar(255) NOT NULL default '',
5 `BOOT_NUMBER` smallint(5) unsigned default NULL,
6 `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,
7 PRIMARY KEY (`ID`),
8 KEY `BOOTNUMBER_index` (`BOOT_NUMBER`),
9 KEY `PATH_index` (`PATH`)
10 ) ENGINE=InnoDB;
11
12 CREATE TABLE `GL_ROOT` (
13 `ID` int(10) unsigned NOT NULL auto_increment,
14 `ID_RAW` int(10) unsigned NOT NULL default '0',
15 `ID_TIMESYNC` int(10) unsigned NOT NULL default '0',
16 `PATH` varchar(255) NOT NULL default '',
17 `NAME` varchar(255) NOT NULL default '',
18 `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,
19 PRIMARY KEY (`ID`),
20 KEY `ID_RAW_index` (`ID_RAW`),
21 KEY `PATH_index` (`PATH`),
22 CONSTRAINT `ROOT_fk` FOREIGN KEY (`ID_RAW`) REFERENCES `GL_RAW` (`ID`) ON DELETE CASCADE
23 ) ENGINE=InnoDB;
24
25 CREATE TABLE `GL_RESURS_OFFSET` (
26 `ID` int(10) unsigned NOT NULL auto_increment,
27 `FROM_ID_RAW` int(10) unsigned NOT NULL default '0',
28 `TO_ID_RAW` int(10) unsigned NOT NULL default '0',
29 `OFFSET_DATE` timestamp default '0000-00-00 00:00:00',
30 `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,
31 PRIMARY KEY (`ID`)
32 ) ENGINE=InnoDB;
33
34 INSERT INTO GL_RESURS_OFFSET VALUES(0,'1','2147483647','2006-06-14 21:00:00',NULL);
35
36 CREATE TABLE `GL_TIMESYNC` (
37 `ID` int(10) unsigned NOT NULL auto_increment,
38 `ID_RAW` int(10) unsigned NOT NULL default '0',
39 `OBT0` int(10) unsigned NOT NULL default '0',
40 `TIMESYNC` int(10) unsigned NOT NULL default '0',
41 `TYPE` smallint(5) unsigned NOT NULL default '0',
42 PRIMARY KEY (`ID`),
43 KEY `ID_RAW_index` (`ID_RAW`),
44 KEY `TYPE_index` (`TYPE`),
45 CONSTRAINT `TIME_RAW_fk` FOREIGN KEY (`ID_RAW`) REFERENCES `GL_RAW` (`ID`) ON DELETE CASCADE
46 ) ENGINE=InnoDB;
47
48 CREATE TABLE `GL_PARAM` (
49 `ID` int(10) unsigned NOT NULL auto_increment,
50 `PATH` varchar(255) NOT NULL default '',
51 `NAME` varchar(255) NOT NULL default '',
52 `FROM_TIME` int(10) unsigned default NULL,
53 `TO_TIME` int(10) unsigned default NULL,
54 `TYPE` smallint(5) unsigned NOT NULL default '',
55 `DESCR` varchar(255) NOT NULL default '',
56 `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,
57 PRIMARY KEY (`ID`),
58 KEY `PATH_index` (`PATH`),
59 KEY `NAME_index` (`NAME`),
60 KEY `TYPE_index` (`TYPE`),
61 KEY `DESCR_index` (`DESCR`)
62 ) ENGINE=InnoDB;
63
64 CREATE TABLE `GL_TLE` (
65 `ID` int(10) NOT NULL auto_increment,
66 `TLE1` varchar(255) NOT NULL default '',
67 `TLE2` varchar(255) NOT NULL default '',
68 `TLE3` varchar(255) NOT NULL default '',
69 `FROM_TIME` int(10) unsigned default NULL,
70 `TO_TIME` int(10) unsigned default NULL,
71 `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,
72 `NOTE` varchar(255) NOT NULL default '',
73 PRIMARY KEY (`ID`)
74 ) ENGINE=InnoDB;
75
76 CREATE TABLE `GL_RUN` (
77 `ID` int(10) unsigned NOT NULL auto_increment,
78 `ID_RUN_FRAG` int(10) unsigned NOT NULL default '0',
79 `ID_ROOT_L0` int(10) unsigned NOT NULL default '0',
80 `ID_ROOT_L2` int(10) unsigned NOT NULL default '0',
81 `RUNHEADER_TIME` int(10) unsigned NOT NULL default '0',
82 `RUNTRAILER_TIME` int(10) unsigned NOT NULL default '0',
83 `RUNHEADER_OBT` int(10) unsigned NOT NULL default '0',
84 `RUNTRAILER_OBT` int(10) unsigned NOT NULL default '0',
85 `RUNHEADER_PKT` int(10) unsigned NOT NULL default '0',
86 `RUNTRAILER_PKT` int(10) unsigned NOT NULL default '0',
87 `BOOT_NUMBER` smallint(5) unsigned NOT NULL default '0',
88 `EV_FROM` int(10) unsigned NOT NULL default '0',
89 `EV_TO` int(10) unsigned NOT NULL default '0',
90 `NEVENTS` int(10) unsigned NOT NULL default '0',
91 `PKT_COUNTER` int(10) unsigned NOT NULL default '0',
92 `PKT_READY_COUNTER` int(10) unsigned NOT NULL default '0',
93 `COMPILATIONTIMESTAMP` int(10) unsigned NOT NULL default '0',
94 `FAV_WRK_SCHEDULE` tinyint(3) unsigned NOT NULL default '0',
95 `EFF_WRK_SCHEDULE` tinyint(3) unsigned NOT NULL default '0',
96 `PRH_VAR_TRG_MODE_A` int(10) unsigned NOT NULL default '0',
97 `PRH_VAR_TRG_MODE_B` int(10) unsigned NOT NULL default '0',
98 `ACQ_BUILD_INFO` int(10) unsigned NOT NULL default '0',
99 `ACQ_VAR_INFO` smallint(5) unsigned NOT NULL default '0',
100 `RM_ACQ_AFTER_CALIB` tinyint(3) NOT NULL default '0',
101 `RM_ACQ_SETTING_MODE` tinyint(3) NOT NULL default '0',
102 `TRK_CALIB_USED` int(10) unsigned NOT NULL default '0',
103 `CAL_DSP_MASK` tinyint(3) unsigned NOT NULL default '0',
104 `LAST_TIMESYNC` int(10) unsigned NOT NULL default '0',
105 `OBT_TIMESYNC` int(10) unsigned NOT NULL default '0',
106 `VALIDATION` tinyint(3) unsigned NOT NULL default '',
107 `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,
108 PRIMARY KEY (`ID`),
109 KEY `ID_RUN_FRAG_index` (`ID_RUN_FRAG`),
110 KEY `ID_ROOT_L0_index` (`ID_ROOT_L0`),
111 KEY `ID_ROOT_L2_index` (`ID_ROOT_L2`),
112 KEY `COMPILATIONTS_index` (`COMPILATIONTIMESTAMP`),
113 KEY `VALID_index` (`VALIDATION`),
114 KEY `TRKCALIB_index` (`TRK_CALIB_USED`),
115 KEY `CALDSPMASK_index` (`CAL_DSP_MASK`),
116 KEY `EFF_WS_index` (`EFF_WRK_SCHEDULE`),
117 KEY `FAV_WS_index` (`FAV_WRK_SCHEDULE`),
118 KEY `RM_ACQ_AFTER_CALIB_index` (`RM_ACQ_AFTER_CALIB`),
119 KEY `RM_ACQ_SETTING_MODE_index` (`RM_ACQ_SETTING_MODE`),
120 KEY `ACQ_VAR_INFO_index` (`ACQ_VAR_INFO`),
121 KEY `TRG_MODE_A_index` (`PRH_VAR_TRG_MODE_A`),
122 KEY `TRG_MODE_B_index` (`PRH_VAR_TRG_MODE_B`),
123 KEY `NEVENTS_index` (`NEVENTS`),
124 KEY `BOOTNUMBER_index` (`BOOT_NUMBER`),
125 KEY `VALID0_index` (`VALIDATION`),
126 KEY `ID_RUN_fk_constraint` (`ID_ROOT_L0`),
127 KEY `ID_RUN_L2_fk_constraint` (`ID_ROOT_L2`),
128 CONSTRAINT `ID_RUN_fk_constraint` FOREIGN KEY (`ID_ROOT_L0`) REFERENCES `GL_ROOT` (`ID`) ON DELETE CASCADE
129 ) ENGINE=InnoDB;
130
131 CREATE TABLE `GL_RUN_FRAGMENTS` (
132 `ID` int(10) unsigned NOT NULL auto_increment,
133 `ID_RUN_FRAG` int(10) unsigned NOT NULL default '0',
134 `ID_ROOT_L0` int(10) unsigned NOT NULL default '0',
135 `ID_ROOT_L2` int(10) unsigned NOT NULL default '0',
136 `RUNHEADER_TIME` int(10) unsigned NOT NULL default '0',
137 `RUNTRAILER_TIME` int(10) unsigned NOT NULL default '0',
138 `RUNHEADER_OBT` int(10) unsigned NOT NULL default '0',
139 `RUNTRAILER_OBT` int(10) unsigned NOT NULL default '0',
140 `RUNHEADER_PKT` int(10) unsigned NOT NULL default '0',
141 `RUNTRAILER_PKT` int(10) unsigned NOT NULL default '0',
142 `BOOT_NUMBER` smallint(5) unsigned NOT NULL default '0',
143 `EV_FROM` int(10) unsigned NOT NULL default '0',
144 `EV_TO` int(10) unsigned NOT NULL default '0',
145 `NEVENTS` int(10) unsigned NOT NULL default '0',
146 `PKT_COUNTER` int(10) unsigned NOT NULL default '0',
147 `PKT_READY_COUNTER` int(10) unsigned NOT NULL default '0',
148 `COMPILATIONTIMESTAMP` int(10) unsigned NOT NULL default '0',
149 `FAV_WRK_SCHEDULE` tinyint(3) unsigned NOT NULL default '0',
150 `EFF_WRK_SCHEDULE` tinyint(3) unsigned NOT NULL default '0',
151 `PRH_VAR_TRG_MODE_A` int(10) unsigned NOT NULL default '0',
152 `PRH_VAR_TRG_MODE_B` int(10) unsigned NOT NULL default '0',
153 `ACQ_BUILD_INFO` int(10) unsigned NOT NULL default '0',
154 `ACQ_VAR_INFO` smallint(5) unsigned NOT NULL default '0',
155 `RM_ACQ_AFTER_CALIB` tinyint(3) NOT NULL default '0',
156 `RM_ACQ_SETTING_MODE` tinyint(3) NOT NULL default '0',
157 `TRK_CALIB_USED` int(10) unsigned NOT NULL default '0',
158 `CAL_DSP_MASK` tinyint(3) unsigned NOT NULL default '0',
159 `LAST_TIMESYNC` int(10) unsigned NOT NULL default '0',
160 `OBT_TIMESYNC` int(10) unsigned NOT NULL default '0',
161 `VALIDATION` tinyint(3) unsigned default NULL,
162 `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,
163 PRIMARY KEY (`ID`),
164 KEY `ID_RUN_FRAG_index` (`ID_RUN_FRAG`),
165 KEY `ID_ROOT_L0_index` (`ID_ROOT_L0`),
166 KEY `BOOTNUMBER_index` (`BOOT_NUMBER`),
167 KEY `TRKCALIB_index` (`TRK_CALIB_USED`),
168 KEY `NID_RUN_fk_constraint` (`ID_ROOT_L0`),
169 CONSTRAINT `NID_RUN_fk_constraint` FOREIGN KEY (`ID_ROOT_L0`) REFERENCES `GL_ROOT` (`ID`) ON DELETE CASCADE
170 ) ENGINE=InnoDB;
171
172 CREATE TABLE `GL_CALO_CALIB` (
173 `ID` int(10) unsigned NOT NULL auto_increment,
174 `ID_ROOT_L0` int(10) unsigned NOT NULL default '0',
175 `EV_ROOT` int(10) unsigned NOT NULL default '0',
176 `FROM_TIME` int(10) unsigned NOT NULL default '0',
177 `TO_TIME` int(10) unsigned NOT NULL default '0',
178 `SECTION` tinyint(3) unsigned NOT NULL default '0',
179 `OBT` int(10) unsigned NOT NULL default '0',
180 `PKT` int(10) unsigned NOT NULL default '0',
181 `BOOT_NUMBER` smallint(5) unsigned default NULL,
182 `VALIDATION` tinyint(3) unsigned default NULL,
183 PRIMARY KEY (`ID`),
184 KEY `SECTION_index` (`SECTION`),
185 KEY `EV_ROOT_index` (`EV_ROOT`),
186 KEY `ID_ROOT_index` (`ID_ROOT_L0`),
187 KEY `BOOTNUMBER_index` (`BOOT_NUMBER`),
188 KEY `VALID1_index` (`VALIDATION`),
189 CONSTRAINT `CALO_REG_fk` FOREIGN KEY (`ID_ROOT_L0`) REFERENCES `GL_ROOT` (`ID`) ON DELETE CASCADE
190 ) ENGINE=InnoDB;
191
192 CREATE TABLE `GL_TRK_CALIB` (
193 `ID` int(10) unsigned NOT NULL auto_increment,
194 `ID_ROOT_L0` int(10) unsigned NOT NULL default '0',
195 `EV_ROOT_CALIBTRK1` int(10) unsigned default NULL,
196 `EV_ROOT_CALIBTRK2` int(10) unsigned default NULL,
197 `FROM_TIME` int(10) unsigned NOT NULL default '0',
198 `TO_TIME` int(10) unsigned NOT NULL default '0',
199 `OBT1` int(10) unsigned NOT NULL default '0',
200 `PKT1` int(10) unsigned NOT NULL default '0',
201 `OBT2` int(10) unsigned NOT NULL default '0',
202 `PKT2` int(10) unsigned NOT NULL default '0',
203 `BOOT_NUMBER` smallint(5) unsigned default NULL,
204 `VALIDATION` tinyint(3) unsigned default NULL,
205 PRIMARY KEY (`ID`),
206 KEY `ID_ROOT_index` (`ID_ROOT_L0`),
207 KEY `EV_ROOT_CALIBTRK1index` (`EV_ROOT_CALIBTRK1`),
208 KEY `EV_ROOT_CALIBTRK2index` (`EV_ROOT_CALIBTRK2`),
209 KEY `BOOTNUMBER_index` (`BOOT_NUMBER`),
210 KEY `VALID2_index` (`VALIDATION`),
211 CONSTRAINT `TRK_REG_fk` FOREIGN KEY (`ID_ROOT_L0`) REFERENCES `GL_ROOT` (`ID`) ON DELETE CASCADE
212 ) ENGINE=InnoDB;
213
214 CREATE TABLE `GL_S4_CALIB` (
215 `ID` int(10) unsigned NOT NULL auto_increment,
216 `ID_ROOT_L0` int(10) unsigned NOT NULL default '0',
217 `EV_ROOT` int(10) unsigned NOT NULL default '0',
218 `FROM_TIME` int(10) unsigned NOT NULL default '0',
219 `TO_TIME` int(10) unsigned NOT NULL default '0',
220 `PARAM_FIT0` float default NULL,
221 `PARAM_FIT1` float NOT NULL default '0',
222 `OBT` int(10) unsigned NOT NULL default '0',
223 `PKT` int(10) unsigned NOT NULL default '0',
224 `BOOT_NUMBER` smallint(5) unsigned default NULL,
225 `VALIDATION` tinyint(3) unsigned default NULL,
226 PRIMARY KEY (`ID`),
227 KEY `ID_ROOT_index` (`ID_ROOT_L0`),
228 KEY `PAR_FIT0_index` (`PARAM_FIT0`),
229 KEY `PAR_FIT1_index` (`PARAM_FIT1`),
230 KEY `BOOTNUMBER_index` (`BOOT_NUMBER`),
231 KEY `VALID3_index` (`VALIDATION`),
232 CONSTRAINT `S4_REG_fk` FOREIGN KEY (`ID_ROOT_L0`) REFERENCES `GL_ROOT` (`ID`) ON DELETE CASCADE
233 ) ENGINE=InnoDB;
234
235
  ViewVC Help
Powered by ViewVC 1.1.23