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

Diff of /YodaProfiler/docs/PAMELAProductionDB.sql

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 1.4 by mocchiut, Tue Oct 24 14:24:21 2006 UTC revision 1.5 by mocchiut, Tue Oct 31 15:35:58 2006 UTC
# Line 133  CREATE TABLE `GL_RUN` ( Line 133  CREATE TABLE `GL_RUN` (
133    KEY `NEVENTS_index` (`NEVENTS`),    KEY `NEVENTS_index` (`NEVENTS`),
134    KEY `BOOTNUMBER_index` (`BOOT_NUMBER`),    KEY `BOOTNUMBER_index` (`BOOT_NUMBER`),
135    KEY `ID_RUN_fk_constraint` (`ID_ROOT_L0`),    KEY `ID_RUN_fk_constraint` (`ID_ROOT_L0`),
136    KEY `ID_RUN_L2_fk_constraint` (`ID_ROOT_L2`),    KEY `ID_RUN_L2_fk_constraint` (`ID_ROOT_L2`)
   CONSTRAINT `ID_RUN_fk_constraint` FOREIGN KEY (`ID_ROOT_L0`) REFERENCES `GL_ROOT` (`ID`) ON DELETE CASCADE  
137  ) ENGINE=InnoDB;  ) ENGINE=InnoDB;
138    
139  CREATE TABLE `GL_RUN_FRAGMENTS` (  CREATE TABLE `GL_RUN_FRAGMENTS` (
# Line 174  CREATE TABLE `GL_RUN_FRAGMENTS` ( Line 173  CREATE TABLE `GL_RUN_FRAGMENTS` (
173    KEY `ID_ROOT_L0_index` (`ID_ROOT_L0`),    KEY `ID_ROOT_L0_index` (`ID_ROOT_L0`),
174    KEY `BOOTNUMBER_index` (`BOOT_NUMBER`),    KEY `BOOTNUMBER_index` (`BOOT_NUMBER`),
175    KEY `TRKCALIB_index` (`TRK_CALIB_USED`),    KEY `TRKCALIB_index` (`TRK_CALIB_USED`),
176    KEY `NID_RUN_fk_constraint` (`ID_ROOT_L0`),    KEY `NID_RUN_fk_constraint` (`ID_ROOT_L0`)
   CONSTRAINT `NID_RUN_fk_constraint` FOREIGN KEY (`ID_ROOT_L0`) REFERENCES `GL_ROOT` (`ID`) ON DELETE CASCADE  
177  ) ENGINE=InnoDB;  ) ENGINE=InnoDB;
178    
179  CREATE TABLE `GL_RUN_TRASH` (  CREATE TABLE `GL_RUN_TRASH` (
180    `ID` int(10) unsigned NOT NULL auto_increment,    `ID_TRASH` int(10) unsigned NOT NULL auto_increment,
181      `ID` int(10) unsigned NOT NULL default '0',
182    `ID_RUN_FRAG` int(10) unsigned NOT NULL default '0',    `ID_RUN_FRAG` int(10) unsigned NOT NULL default '0',
183    `ID_ROOT_L0` int(10) unsigned NOT NULL default '0',    `ID_ROOT_L0` int(10) unsigned NOT NULL default '0',
184    `ID_ROOT_L2` int(10) unsigned NOT NULL default '0',    `ID_ROOT_L2` int(10) unsigned NOT NULL default '0',
# Line 213  CREATE TABLE `GL_RUN_TRASH` ( Line 212  CREATE TABLE `GL_RUN_TRASH` (
212    `FILENAMEL2` varchar(255) NOT NULL default '',    `FILENAMEL2` varchar(255) NOT NULL default '',
213    `BELONGED_TO` varchar(255) NOT NULL default '',    `BELONGED_TO` varchar(255) NOT NULL default '',
214    `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,    `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,
215    PRIMARY KEY  (`ID`),    PRIMARY KEY  (`ID_TRASH`),
216    KEY `TID_RUN_FRAG_index` (`ID_RUN_FRAG`),    KEY `TID_RUN_FRAG_index` (`ID_RUN_FRAG`),
217    KEY `TID_ROOT_L0_index` (`ID_ROOT_L0`),    KEY `TID_ROOT_L0_index` (`ID_ROOT_L0`),
218    KEY `TBOOTNUMBER_index` (`BOOT_NUMBER`),    KEY `TBOOTNUMBER_index` (`BOOT_NUMBER`),
# Line 239  CREATE TABLE `GL_CALO_CALIB` ( Line 238  CREATE TABLE `GL_CALO_CALIB` (
238    KEY `EV_ROOT_index` (`EV_ROOT`),    KEY `EV_ROOT_index` (`EV_ROOT`),
239    KEY `ID_ROOT_index` (`ID_ROOT_L0`),    KEY `ID_ROOT_index` (`ID_ROOT_L0`),
240    KEY `BOOTNUMBER_index` (`BOOT_NUMBER`),    KEY `BOOTNUMBER_index` (`BOOT_NUMBER`),
241    KEY `VALID1_index` (`VALIDATION`),    KEY `VALID1_index` (`VALIDATION`)
   CONSTRAINT `CALO_REG_fk` FOREIGN KEY (`ID_ROOT_L0`) REFERENCES `GL_ROOT` (`ID`) ON DELETE CASCADE  
242  ) ENGINE=InnoDB;  ) ENGINE=InnoDB;
243    
244  CREATE TABLE `GL_TRK_CALIB` (  CREATE TABLE `GL_TRK_CALIB` (
# Line 261  CREATE TABLE `GL_TRK_CALIB` ( Line 259  CREATE TABLE `GL_TRK_CALIB` (
259    KEY `EV_ROOT_CALIBTRK1index` (`EV_ROOT_CALIBTRK1`),    KEY `EV_ROOT_CALIBTRK1index` (`EV_ROOT_CALIBTRK1`),
260    KEY `EV_ROOT_CALIBTRK2index` (`EV_ROOT_CALIBTRK2`),    KEY `EV_ROOT_CALIBTRK2index` (`EV_ROOT_CALIBTRK2`),
261    KEY `BOOTNUMBER_index` (`BOOT_NUMBER`),    KEY `BOOTNUMBER_index` (`BOOT_NUMBER`),
262    KEY `VALID2_index` (`VALIDATION`),    KEY `VALID2_index` (`VALIDATION`)
   CONSTRAINT `TRK_REG_fk` FOREIGN KEY (`ID_ROOT_L0`) REFERENCES `GL_ROOT` (`ID`) ON DELETE CASCADE  
263  ) ENGINE=InnoDB;  ) ENGINE=InnoDB;
264    
265  CREATE TABLE `GL_S4_CALIB` (  CREATE TABLE `GL_S4_CALIB` (
# Line 276  CREATE TABLE `GL_S4_CALIB` ( Line 273  CREATE TABLE `GL_S4_CALIB` (
273    `BOOT_NUMBER` smallint(5) unsigned NOT NULL default '0',    `BOOT_NUMBER` smallint(5) unsigned NOT NULL default '0',
274    PRIMARY KEY  (`ID`),    PRIMARY KEY  (`ID`),
275    KEY `ID_ROOT_index` (`ID_ROOT_L0`),    KEY `ID_ROOT_index` (`ID_ROOT_L0`),
276    KEY `BOOTNUMBER_index` (`BOOT_NUMBER`),    KEY `BOOTNUMBER_index` (`BOOT_NUMBER`)
   CONSTRAINT `S4_REG_fk` FOREIGN KEY (`ID_ROOT_L0`) REFERENCES `GL_ROOT` (`ID`) ON DELETE CASCADE  
277  ) ENGINE=InnoDB;  ) ENGINE=InnoDB;
278    
279    
Legend:
Removed from v.1.4  
changed lines
  Added in v.1.5
  ViewVC Help
Powered by ViewVC 1.1.23