Changeset 9617 for trunk/MagicSoft/Mars/datacenter/db/mcdefs.php

Timestamp:

07/28/10 14:38:30 (15 years ago)

Author:

Daniela Dorner

Message:

*** empty log message ***

File:

• trunk/MagicSoft/Mars/datacenter/db/mcdefs.php (modified) (4 diffs)

trunk/MagicSoft/Mars/datacenter/db/mcdefs.php

@@ -4 +4 @@
     (
      "Corsika" => "60",
-     "Ceres" => "1",
+     "Ceres" => "2",
      "SequenceFile" => "1",
      "Callisto" => "1",
@@ -40 +40 @@
     (
      "Run.File"                 => "Run.File",
+     "fSequenceNumber"          => "Sequ",
      "fNumEvents"               => "#Evts",
      "SUM(fNumEvents)"          => "Evts",
@@ -69 +70 @@
 $rightalign = array
     (
-//     $alias["fRunNumber"]                => "1",
+     $alias["fSequenceNumber"]           => "1",
      $alias["fNumEvents"]                => "1",
      $alias["fZenithDistanceMin"]        => "1",
@@ -157 +158 @@
     $joins = array
         (
-         "fParticleTypeName"           => " LEFT JOIN ParticleType         USING(fParticleTypeKEY) ",
-         "fRunTypeName"                => " LEFT JOIN RunType              USING(fRunTypeKEY) ",
-         "fAtmosphericModelName"       => " LEFT JOIN AtmosphericModel     USING(fAtmosphericModelKEY) ",
-         "Corsika"                     => " LEFT JOIN CorsikaStatus        USING(fRunNumber, fFileNumber) ",
-         "Ceres"                       => " LEFT JOIN CeresStatus          USING(fRunNumber, fFileNumber, fCeresSetupKEY) ",
-         "SequenceFile"                => " LEFT JOIN SequenceFileStatus   USING(fSequenceNumber) ",
-         "Callisto"                    => " LEFT JOIN CallistoStatus       USING(fSequenceNumber, fCeresSetupKEY) ",
-         "Star"                        => " LEFT JOIN StarStatus           USING(fSequenceNumber, fCeresSetupKEY) ",
+         "fParticleTypeKEY"           => " LEFT JOIN ParticleType         USING(fParticleTypeKEY) ",
+         "fRunTypeKEY"                => " LEFT JOIN RunType              USING(fRunTypeKEY) ",
+         "fAtmosphericModelKEY"       => " LEFT JOIN AtmosphericModel     USING(fAtmosphericModelKEY) ",
+         "fParticleTypeName"          => " LEFT JOIN ParticleType         USING(fParticleTypeKEY) ",
+         "fRunTypeName"               => " LEFT JOIN RunType              USING(fRunTypeKEY) ",
+         "fAtmosphericModelName"      => " LEFT JOIN AtmosphericModel     USING(fAtmosphericModelKEY) ",
+         "CorsikaStatus"              => " LEFT JOIN CorsikaStatus        USING(fRunNumber, fFileNumber) ",
+         "CeresStatus"                => " LEFT JOIN CeresStatus          USING(fRunNumber, fFileNumber, fCeresSetupKEY) ",
+         "SequenceFileStatus"         => " LEFT JOIN SequenceFileStatus   USING(fSequenceNumber) ",
+         "CallistoStatus"             => " LEFT JOIN CallistoStatus       USING(fSequenceNumber, fCeresSetupKEY) ",
+         "StarStatus"                 => " LEFT JOIN StarStatus           USING(fSequenceNumber, fCeresSetupKEY) ",
+         "Corsika"                    => " LEFT JOIN CorsikaStatus        USING(fRunNumber, fFileNumber) ",
+         "Ceres"                      => " LEFT JOIN CeresStatus          USING(fRunNumber, fFileNumber, fCeresSetupKEY) ",
+         "SequenceFile"               => " LEFT JOIN SequenceFileStatus   USING(fSequenceNumber) ",
+         "Callisto"                   => " LEFT JOIN CallistoStatus       USING(fSequenceNumber, fCeresSetupKEY) ",
+         "Star"                       => " LEFT JOIN StarStatus           USING(fSequenceNumber, fCeresSetupKEY) ",
         );