/[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.1 by mocchiut, Thu Sep 7 08:34:18 2006 UTC revision 1.2 by mocchiut, Tue Oct 17 15:19:50 2006 UTC
# Line 57  CREATE TABLE `GL_PARAM` ( Line 57  CREATE TABLE `GL_PARAM` (
57    `NAME` varchar(255) NOT NULL default '',    `NAME` varchar(255) NOT NULL default '',
58    `FROM_TIME` int(10) unsigned NOT NULL default '0',    `FROM_TIME` int(10) unsigned NOT NULL default '0',
59    `TO_TIME` int(10) unsigned NOT NULL default '0',    `TO_TIME` int(10) unsigned NOT NULL default '0',
60    `TYPE` smallint(5) unsigned NOT NULL default '',    `TYPE` smallint(5) unsigned NOT NULL default '0',
61    `DESCR` varchar(255) NOT NULL default '',    `DESCR` varchar(255) NOT NULL default '',
62    `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,    `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,
63    PRIMARY KEY  (`ID`),    PRIMARY KEY  (`ID`),
# Line 72  CREATE TABLE `GL_TLE` ( Line 72  CREATE TABLE `GL_TLE` (
72    `TLE1` varchar(255) NOT NULL default '',    `TLE1` varchar(255) NOT NULL default '',
73    `TLE2` varchar(255) NOT NULL default '',    `TLE2` varchar(255) NOT NULL default '',
74    `TLE3` varchar(255) NOT NULL default '',    `TLE3` varchar(255) NOT NULL default '',
75    `FROM_TIME` int(10) unsigned NOT NULL default '0',    `FROM_TIME` datetime NOT NULL default '0000-00-00 00:00:00',
   `TO_TIME` int(10) unsigned NOT NULL default '0',  
76    `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,    `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,
   `NOTE` varchar(255) NOT NULL default '',  
77    PRIMARY KEY  (`ID`)    PRIMARY KEY  (`ID`)
78  ) ENGINE=InnoDB;  ) ENGINE=InnoDB;
79    
Legend:
Removed from v.1.1  
changed lines
  Added in v.1.2
  ViewVC Help
Powered by ViewVC 1.1.23