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

Diff of /yodaUtility/YodaProfiler/PAMELAProductionDB.txt

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

revision 1.1 by kusanagi, Tue Jun 6 07:39:45 2006 UTC revision 1.2 by kusanagi, Sat Jun 10 18:07:03 2006 UTC
# Line 1  Line 1 
1  CREATE TABLE `GL_RAW` (  CREATE TABLE `GL_RAW` (
2    `ID` bigint(20) unsigned NOT NULL auto_increment,    `ID` bigint(20) unsigned NOT NULL auto_increment,
3      `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,
4    `PATH` varchar(255) NOT NULL default '',    `PATH` varchar(255) NOT NULL default '',
5    `NAME` varchar(255) NOT NULL default '',    `NAME` varchar(255) NOT NULL default '',
6    `BOOT_NUMBER` bigint(20) default NULL,    `BOOT_NUMBER` bigint(20) default NULL,
7      `OFFSET_DATE` timestamp default '',
8    PRIMARY KEY  (`ID`)    PRIMARY KEY  (`ID`)
9  ) TYPE=InnoDB;  ) TYPE=InnoDB;
10    
11    
   
12  CREATE TABLE `GL_ROOT` (  CREATE TABLE `GL_ROOT` (
13    `ID` bigint(20) unsigned NOT NULL auto_increment,    `ID` bigint(20) unsigned NOT NULL auto_increment,
14      `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,
15    `ID_RAW` bigint(20) unsigned NOT NULL default '0',    `ID_RAW` bigint(20) unsigned NOT NULL default '0',
16    `PATH` varchar(255) NOT NULL default '',    `PATH` varchar(255) NOT NULL default '',
17    `NAME` varchar(255) NOT NULL default '',    `NAME` varchar(255) NOT NULL default '',
# Line 98  CREATE TABLE `GL_TRK_CALIB` ( Line 100  CREATE TABLE `GL_TRK_CALIB` (
100    
101  CREATE TABLE `GL_PARAM` (  CREATE TABLE `GL_PARAM` (
102    `ID` int(11) NOT NULL auto_increment,    `ID` int(11) NOT NULL auto_increment,
103      `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,
104    `PATH` varchar(255) NOT NULL default '',    `PATH` varchar(255) NOT NULL default '',
105    `NAME` varchar(255) NOT NULL default '',    `NAME` varchar(255) NOT NULL default '',
106    `DESCR` varchar(255) NOT NULL default '',    `DESCR` varchar(255) NOT NULL default '',
# Line 106  CREATE TABLE `GL_PARAM` ( Line 109  CREATE TABLE `GL_PARAM` (
109    PRIMARY KEY  (`ID`)    PRIMARY KEY  (`ID`)
110  ) TYPE=InnoDB;  ) TYPE=InnoDB;
111    
112    
113  CREATE TABLE `GL_TLE` (  CREATE TABLE `GL_TLE` (
114    `ID` int(11) NOT NULL auto_increment,    `ID` int(11) NOT NULL auto_increment,
115      `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,
116    `TLE1` varchar(255) NOT NULL default '',    `TLE1` varchar(255) NOT NULL default '',
117    `TLE2` varchar(255) NOT NULL default '',    `TLE2` varchar(255) NOT NULL default '',
118    `TLE3` varchar(255) NOT NULL default '',    `TLE3` varchar(255) NOT NULL default '',
119    `INSERT_TIME` timestamp NOT NULL,    `FROM_TIME` bigint(20) default NULL,
120    `VALID_FROM_TIME` bigint(20) default NULL,    `TO_TIME` bigint(20) default NULL,
   `VALID_FROM_TO` bigint(20) default NULL,  
121    `NOTE` varchar(255) NOT NULL default '',    `NOTE` varchar(255) NOT NULL default '',
122    PRIMARY KEY  (`ID`)    PRIMARY KEY  (`ID`)
123  ) TYPE=InnoDB;  ) TYPE=InnoDB;
Legend:
Removed from v.1.1  
changed lines
  Added in v.1.2
  ViewVC Help
Powered by ViewVC 1.1.23