--- yodaUtility/YodaProfiler/PAMELAProductionDB.txt	2006/06/06 07:39:45	1.1
+++ yodaUtility/YodaProfiler/PAMELAProductionDB.txt	2006/06/10 18:07:03	1.2
@@ -1,15 +1,17 @@
 CREATE TABLE `GL_RAW` (
   `ID` bigint(20) unsigned NOT NULL auto_increment,
+  `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,
   `PATH` varchar(255) NOT NULL default '',
   `NAME` varchar(255) NOT NULL default '',
   `BOOT_NUMBER` bigint(20) default NULL,
+  `OFFSET_DATE` timestamp default '',
   PRIMARY KEY  (`ID`)
 ) TYPE=InnoDB;
 
 
-
 CREATE TABLE `GL_ROOT` (
   `ID` bigint(20) unsigned NOT NULL auto_increment,
+  `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,
   `ID_RAW` bigint(20) unsigned NOT NULL default '0',
   `PATH` varchar(255) NOT NULL default '',
   `NAME` varchar(255) NOT NULL default '',
@@ -98,6 +100,7 @@
 
 CREATE TABLE `GL_PARAM` (
   `ID` int(11) NOT NULL auto_increment,
+  `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,
   `PATH` varchar(255) NOT NULL default '',
   `NAME` varchar(255) NOT NULL default '',
   `DESCR` varchar(255) NOT NULL default '',
@@ -106,14 +109,15 @@
   PRIMARY KEY  (`ID`)
 ) TYPE=InnoDB;
 
+
 CREATE TABLE `GL_TLE` (
   `ID` int(11) NOT NULL auto_increment,
+  `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,
   `TLE1` varchar(255) NOT NULL default '',
   `TLE2` varchar(255) NOT NULL default '',
   `TLE3` varchar(255) NOT NULL default '',
-  `INSERT_TIME` timestamp NOT NULL,
-  `VALID_FROM_TIME` bigint(20) default NULL,
-  `VALID_FROM_TO` bigint(20) default NULL,
+  `FROM_TIME` bigint(20) default NULL,
+  `TO_TIME` bigint(20) default NULL,
   `NOTE` varchar(255) NOT NULL default '',
   PRIMARY KEY  (`ID`)
 ) TYPE=InnoDB;