--- YodaProfiler/docs/PAMELAProductionDB.txt	2006/08/30 11:18:14	1.1.1.1
+++ YodaProfiler/docs/PAMELAProductionDB.txt	2006/09/07 08:34:19	1.3
@@ -31,7 +31,7 @@
   PRIMARY KEY  (`ID`)
 ) ENGINE=InnoDB;
 
-INSERT INTO GL_RESURS_OFFSET VALUES(0,'1','2147483647','2006-06-14 21:00:00',NULL);
+INSERT INTO GL_RESURS_OFFSET VALUES(0,'1','4294967295','2006-06-14 21:00:00',NULL);
 
 CREATE TABLE `GL_TIMESYNC` (
   `ID` int(10) unsigned NOT NULL auto_increment,
@@ -49,8 +49,8 @@
   `ID` int(10) unsigned NOT NULL auto_increment,
   `PATH` varchar(255) NOT NULL default '',
   `NAME` varchar(255) NOT NULL default '',
-  `FROM_TIME` int(10) unsigned default NULL,
-  `TO_TIME` int(10) unsigned default NULL,
+  `FROM_TIME` int(10) unsigned NOT NULL default '0',
+  `TO_TIME` int(10) unsigned NOT NULL default '0',
   `TYPE` smallint(5) unsigned NOT NULL default '',
   `DESCR` varchar(255) NOT NULL default '',
   `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,
@@ -66,8 +66,8 @@
   `TLE1` varchar(255) NOT NULL default '',
   `TLE2` varchar(255) NOT NULL default '',
   `TLE3` varchar(255) NOT NULL default '',
-  `FROM_TIME` int(10) unsigned default NULL,
-  `TO_TIME` int(10) unsigned default NULL,
+  `FROM_TIME` int(10) unsigned NOT NULL default '0',
+  `TO_TIME` int(10) unsigned NOT NULL default '0',
   `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,
   `NOTE` varchar(255) NOT NULL default '',
   PRIMARY KEY  (`ID`)
@@ -103,7 +103,7 @@
   `CAL_DSP_MASK` tinyint(3) unsigned NOT NULL default '0',
   `LAST_TIMESYNC` int(10) unsigned NOT NULL default '0',
   `OBT_TIMESYNC` int(10) unsigned NOT NULL default '0',
-  `VALIDATION` tinyint(3) unsigned NOT NULL default '',
+  `VALIDATION` tinyint(3) unsigned NOT NULL default '0',
   `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,
   PRIMARY KEY  (`ID`),
   KEY `ID_RUN_FRAG_index` (`ID_RUN_FRAG`),
@@ -122,7 +122,6 @@
   KEY `TRG_MODE_B_index` (`PRH_VAR_TRG_MODE_B`),
   KEY `NEVENTS_index` (`NEVENTS`),
   KEY `BOOTNUMBER_index` (`BOOT_NUMBER`),
-  KEY `VALID0_index` (`VALIDATION`),
   KEY `ID_RUN_fk_constraint` (`ID_ROOT_L0`),
   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
@@ -158,7 +157,7 @@
   `CAL_DSP_MASK` tinyint(3) unsigned NOT NULL default '0',
   `LAST_TIMESYNC` int(10) unsigned NOT NULL default '0',
   `OBT_TIMESYNC` int(10) unsigned NOT NULL default '0',
-  `VALIDATION` tinyint(3) unsigned default NULL,
+  `VALIDATION` tinyint(3) unsigned NOT NULL default '0',
   `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,
   PRIMARY KEY  (`ID`),
   KEY `ID_RUN_FRAG_index` (`ID_RUN_FRAG`),
@@ -178,8 +177,8 @@
   `SECTION` tinyint(3) unsigned NOT NULL default '0',
   `OBT` int(10) unsigned NOT NULL default '0',
   `PKT` int(10) unsigned NOT NULL default '0',
-  `BOOT_NUMBER` smallint(5) unsigned default NULL,
-  `VALIDATION` tinyint(3) unsigned default NULL,
+  `BOOT_NUMBER` smallint(5) unsigned NOT NULL default '0',
+  `VALIDATION` tinyint(3) unsigned NOT NULL default '0',
   PRIMARY KEY  (`ID`),
   KEY `SECTION_index` (`SECTION`),
   KEY `EV_ROOT_index` (`EV_ROOT`),
@@ -200,8 +199,8 @@
   `PKT1` int(10) unsigned NOT NULL default '0',
   `OBT2` int(10) unsigned NOT NULL default '0',
   `PKT2` int(10) unsigned NOT NULL default '0',
-  `BOOT_NUMBER` smallint(5) unsigned default NULL,
-  `VALIDATION` tinyint(3) unsigned default NULL,
+  `BOOT_NUMBER` smallint(5) unsigned NOT NULL default '0',
+  `VALIDATION` tinyint(3) unsigned NOT NULL default '0',
   PRIMARY KEY  (`ID`),
   KEY `ID_ROOT_index` (`ID_ROOT_L0`),
   KEY `EV_ROOT_CALIBTRK1index` (`EV_ROOT_CALIBTRK1`),
@@ -217,18 +216,12 @@
   `EV_ROOT` int(10) unsigned NOT NULL default '0',
   `FROM_TIME` int(10) unsigned NOT NULL default '0',
   `TO_TIME` int(10) unsigned NOT NULL default '0',
-  `PARAM_FIT0` float default NULL,
-  `PARAM_FIT1` float NOT NULL default '0',
   `OBT` int(10) unsigned NOT NULL default '0',
   `PKT` int(10) unsigned NOT NULL default '0',  
-  `BOOT_NUMBER` smallint(5) unsigned default NULL,
-  `VALIDATION` tinyint(3) unsigned default NULL,
+  `BOOT_NUMBER` smallint(5) unsigned NOT NULL default '0',
   PRIMARY KEY  (`ID`),
   KEY `ID_ROOT_index` (`ID_ROOT_L0`),
-  KEY `PAR_FIT0_index` (`PARAM_FIT0`),
-  KEY `PAR_FIT1_index` (`PARAM_FIT1`),
   KEY `BOOTNUMBER_index` (`BOOT_NUMBER`),
-  KEY `VALID3_index` (`VALIDATION`),
   CONSTRAINT `S4_REG_fk` FOREIGN KEY (`ID_ROOT_L0`) REFERENCES `GL_ROOT` (`ID`) ON DELETE CASCADE
 ) ENGINE=InnoDB;