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

Diff of /chewbacca/YodaProfiler/docs/PAMELAProductionDB.sql

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

revision 1.1 by mocchiut, Tue Sep 23 07:20:29 2008 UTC revision 1.2 by mocchiut, Thu Sep 25 09:03:16 2008 UTC
# Line 278  CREATE TABLE `GL_RUN` ( Line 278  CREATE TABLE `GL_RUN` (
278    `CAL_DSP_MASK` tinyint(3) unsigned NOT NULL default '0',    `CAL_DSP_MASK` tinyint(3) unsigned NOT NULL default '0',
279    `LAST_TIMESYNC` int(10) unsigned NOT NULL default '0',    `LAST_TIMESYNC` int(10) unsigned NOT NULL default '0',
280    `OBT_TIMESYNC` int(10) unsigned NOT NULL default '0',    `OBT_TIMESYNC` int(10) unsigned NOT NULL default '0',
281      `PHYSENDRUN_MASK_S3S2S12` int(10) unsigned NOT NULL default '0',
282      `PHYSENDRUN_MASK_S11CRC` int(10) unsigned NOT NULL default '0',
283    `VALIDATION` tinyint(3) unsigned NOT NULL default '0',    `VALIDATION` tinyint(3) unsigned NOT NULL default '0',
284    `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,    `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,
285    PRIMARY KEY  (`ID`),    PRIMARY KEY  (`ID`),
# Line 331  CREATE TABLE `GL_RUN_FRAGMENTS` ( Line 333  CREATE TABLE `GL_RUN_FRAGMENTS` (
333    `CAL_DSP_MASK` tinyint(3) unsigned NOT NULL default '0',    `CAL_DSP_MASK` tinyint(3) unsigned NOT NULL default '0',
334    `LAST_TIMESYNC` int(10) unsigned NOT NULL default '0',    `LAST_TIMESYNC` int(10) unsigned NOT NULL default '0',
335    `OBT_TIMESYNC` int(10) unsigned NOT NULL default '0',    `OBT_TIMESYNC` int(10) unsigned NOT NULL default '0',
336      `PHYSENDRUN_MASK_S3S2S12` int(10) unsigned NOT NULL default '0',
337      `PHYSENDRUN_MASK_S11CRC` int(10) unsigned NOT NULL default '0',
338    `VALIDATION` tinyint(3) unsigned NOT NULL default '0',    `VALIDATION` tinyint(3) unsigned NOT NULL default '0',
339    `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,    `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,
340    PRIMARY KEY  (`ID`),    PRIMARY KEY  (`ID`),
# Line 372  CREATE TABLE `GL_RUN_TRASH` ( Line 376  CREATE TABLE `GL_RUN_TRASH` (
376    `CAL_DSP_MASK` tinyint(3) unsigned NOT NULL default '0',    `CAL_DSP_MASK` tinyint(3) unsigned NOT NULL default '0',
377    `LAST_TIMESYNC` int(10) unsigned NOT NULL default '0',    `LAST_TIMESYNC` int(10) unsigned NOT NULL default '0',
378    `OBT_TIMESYNC` int(10) unsigned NOT NULL default '0',    `OBT_TIMESYNC` int(10) unsigned NOT NULL default '0',
379      `PHYSENDRUN_MASK_S3S2S12` int(10) unsigned NOT NULL default '0',
380      `PHYSENDRUN_MASK_S11CRC` int(10) unsigned NOT NULL default '0',
381    `VALIDATION` tinyint(3) unsigned NOT NULL default '0',    `VALIDATION` tinyint(3) unsigned NOT NULL default '0',
382    `FILENAMEL0` varchar(255) NOT NULL default '',    `FILENAMEL0` varchar(255) NOT NULL default '',
383    `FILENAMEL2` varchar(255) NOT NULL default '',    `FILENAMEL2` varchar(255) NOT NULL default '',

Legend:
Removed from v.1.1  
changed lines
  Added in v.1.2

  ViewVC Help
Powered by ViewVC 1.1.23