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

Annotation of /yodaUtility/YodaProfiler/PAMELAProductionDB.txt

Parent Directory Parent Directory | Revision Log Revision Log

Revision 1.2 - (hide annotations) (download)
Sat Jun 10 18:07:03 2006 UTC (19 years, 4 months ago) by kusanagi
Branch: MAIN
CVS Tags: yodaUtility2_0/00, yodaUtility2_1/00
Changes since 1.1: +9 -5 lines
File MIME type: text/plain 
Updating for Orbital and Geomagnetic parameters in Registry class.
1 kusanagi 1.1 CREATE TABLE `GL_RAW` (
2     `ID` bigint(20) unsigned NOT NULL auto_increment,
3 kusanagi 1.2 `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,
4 kusanagi 1.1 `PATH` varchar(255) NOT NULL default '',
5     `NAME` varchar(255) NOT NULL default '',
6     `BOOT_NUMBER` bigint(20) default NULL,
7 kusanagi 1.2 `OFFSET_DATE` timestamp default '',
8 kusanagi 1.1 PRIMARY KEY (`ID`)
9     ) TYPE=InnoDB;
10    
11    
12     CREATE TABLE `GL_ROOT` (
13     `ID` bigint(20) unsigned NOT NULL auto_increment,
14 kusanagi 1.2 `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,
15 kusanagi 1.1 `ID_RAW` bigint(20) unsigned NOT NULL default '0',
16     `PATH` varchar(255) NOT NULL default '',
17     `NAME` varchar(255) NOT NULL default '',
18     PRIMARY KEY (`ID`),
19     KEY `ID_RAW_index` (`ID_RAW`),
20     CONSTRAINT `ROOT_fk` FOREIGN KEY (`ID_RAW`) REFERENCES `GL_RAW` (`ID`) ON DELETE CASCADE
21     ) TYPE=InnoDB;
22    
23    
24     CREATE TABLE `GL_RUN` (
25     `ID` bigint(20) unsigned NOT NULL auto_increment,
26     `ID_REG_RUN` bigint(20) unsigned NOT NULL default '0',
27     `ID_REG_RUN_L2` bigint(20) unsigned default '0',
28     `RUNHEADER_TIME` bigint(31) unsigned NOT NULL default '0',
29     `RUNTRAILER_TIME` bigint(20) unsigned NOT NULL default '0',
30     `EV_REG_PHYS_FROM` int(10) unsigned NOT NULL default '0',
31     `EV_REG_PHYS_TO` int(10) unsigned NOT NULL default '0',
32     `EV_REG_RUNHEADER` int(10) unsigned NOT NULL default '0',
33     `EV_REG_RUNTRAILER` int(10) unsigned NOT NULL default '0',
34     `TRK_CALIB_USED` tinyint(3) unsigned NOT NULL default '0',
35     `EFF_WRK_SCHEDULE` int(10) unsigned NOT NULL default '0',
36     `PRH_VAR_TRG_MODE_A` bigint(32) unsigned NOT NULL default '0',
37     `PRH_VAR_TRG_MODE_B` bigint(32) unsigned NOT NULL default '0',
38     `ACQ_BUILD_INFO` bigint(32) unsigned NOT NULL default '0',
39     `ACQ_VAR_INFO` int(10) unsigned NOT NULL default '0',
40     `VALIDATION` varchar(255) NOT NULL default '',
41     PRIMARY KEY (`ID`),
42     KEY `ID_RUN_fk_constraint` (`ID_REG_RUN`),
43     KEY `ID_RUN_L2_fk_constraint` (`ID_REG_RUN_L2`),
44     CONSTRAINT `ID_RUN_fk_constraint` FOREIGN KEY (`ID_REG_RUN`) REFERENCES `GL_ROOT` (`ID`) ON DELETE CASCADE
45     ) TYPE=InnoDB;
46    
47    
48     CREATE TABLE `GL_TIMESYNC` (
49     `ID` bigint(20) unsigned NOT NULL auto_increment,
50     `ID_RAW` bigint(20) unsigned NOT NULL default '0',
51     `TYPE` smallint(5) unsigned NOT NULL default '0',
52     `DELTA_OBT_TMSYNC` double NOT NULL default '0',
53     `RMS_DELTA` double NOT NULL default '0',
54     PRIMARY KEY (`ID`),
55     KEY `ID_RAW_index` (`ID_RAW`),
56     CONSTRAINT `TIME_RAW_fk` FOREIGN KEY (`ID_RAW`) REFERENCES `GL_RAW` (`ID`) ON DELETE CASCADE
57     ) TYPE=InnoDB;
58    
59    
60     CREATE TABLE `GL_CALO_CALIB` (
61     `ID` bigint(20) unsigned NOT NULL auto_increment,
62     `ID_REG_CALIBCALPED` bigint(20) unsigned NOT NULL default '0',
63     `EV_REG_CALIBCALPED` int(10) unsigned NOT NULL default '0',
64     `FROM_TIME` bigint(20) unsigned NOT NULL default '0',
65     `TO_TIME` bigint(20) unsigned NOT NULL default '0',
66     `SECTION` smallint(5) unsigned NOT NULL default '0',
67     PRIMARY KEY (`ID`),
68     KEY `FROM_TIME_index` (`FROM_TIME`),
69     KEY `REG_CAL_index` (`ID_REG_CALIBCALPED`),
70     CONSTRAINT `CALO_REG_fk` FOREIGN KEY (`ID_REG_CALIBCALPED`) REFERENCES `GL_ROOT` (`ID`) ON DELETE CASCADE
71     ) TYPE=InnoDB;
72    
73    
74     CREATE TABLE `GL_S4_CALIB` (
75     `ID` bigint(20) unsigned NOT NULL auto_increment,
76     `ID_REG_CALIBS4` bigint(20) unsigned NOT NULL default '0',
77     `EV_REG_CALIBS4` int(10) unsigned NOT NULL default '0',
78     `FROM_TIME` bigint(20) unsigned NOT NULL default '0',
79     `TO_TIME` bigint(20) unsigned NOT NULL default '0',
80     `PARAM_FIT0` float default NULL,
81     `PARAM_FIT1` float NOT NULL default '0',
82     PRIMARY KEY (`ID`),
83     KEY `ID_REG_index` (`ID_REG_CALIBS4`),
84     CONSTRAINT `S4_REG_fk` FOREIGN KEY (`ID_REG_CALIBS4`) REFERENCES `GL_ROOT` (`ID`) ON DELETE CASCADE
85     ) TYPE=InnoDB;
86    
87    
88     CREATE TABLE `GL_TRK_CALIB` (
89     `ID` bigint(20) unsigned NOT NULL auto_increment,
90     `ID_REG_CALIBTRK` bigint(20) unsigned NOT NULL default '0',
91     `EV_REG_CALIBTRK1` int(10) unsigned NOT NULL default '0',
92     `EV_REG_CALIBTRK2` int(10) unsigned NOT NULL default '0',
93     `FROM_TIME` bigint(20) unsigned NOT NULL default '0',
94     `TO_TIME` bigint(20) unsigned NOT NULL default '0',
95     PRIMARY KEY (`ID`),
96     KEY `ID_REG_index` (`ID_REG_CALIBTRK`),
97     CONSTRAINT `TRK_REG_fk` FOREIGN KEY (`ID_REG_CALIBTRK`) REFERENCES `GL_ROOT` (`ID`) ON DELETE CASCADE
98     ) TYPE=InnoDB;
99    
100    
101     CREATE TABLE `GL_PARAM` (
102     `ID` int(11) NOT NULL auto_increment,
103 kusanagi 1.2 `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,
104 kusanagi 1.1 `PATH` varchar(255) NOT NULL default '',
105     `NAME` varchar(255) NOT NULL default '',
106     `DESCR` varchar(255) NOT NULL default '',
107     `FROM_TIME` bigint(20) default NULL,
108     `TO_TIME` bigint(20) default NULL,
109     PRIMARY KEY (`ID`)
110     ) TYPE=InnoDB;
111    
112 kusanagi 1.2
113 kusanagi 1.1 CREATE TABLE `GL_TLE` (
114     `ID` int(11) NOT NULL auto_increment,
115 kusanagi 1.2 `INSERT_TIME` timestamp NOT NULL default CURRENT_TIMESTAMP,
116 kusanagi 1.1 `TLE1` varchar(255) NOT NULL default '',
117     `TLE2` varchar(255) NOT NULL default '',
118     `TLE3` varchar(255) NOT NULL default '',
119 kusanagi 1.2 `FROM_TIME` bigint(20) default NULL,
120     `TO_TIME` bigint(20) default NULL,
121 kusanagi 1.1 `NOTE` varchar(255) NOT NULL default '',
122     PRIMARY KEY (`ID`)
123 kusanagi 1.2 ) TYPE=InnoDB;
  ViewVC Help
Powered by ViewVC 1.1.23