Changeset 7262 for trunk/MagicSoft/Mars/datacenter

Timestamp:

08/04/05 20:09:28 (19 years ago)

Author:

Daniela Dorner

Message:

*** empty log message ***

Location:

trunk/MagicSoft/Mars/datacenter/macros

Files:

• fillsinope.C (added)
• setupdb.C (modified) (2 diffs)

trunk/MagicSoft/Mars/datacenter/macros/setupdb.C

@@ -418 +418 @@
 
     list.Add(new TObjString(
-         "CREATE TABLE MyMagic.%s ("
+         "CREATE TABLE MyMagic.ExcludedFDA ("
          "  fExcludedFDAKEY        SMALLINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,"
          "  fExcludedFDAImportance SMALLINT UNSIGNED        NULL,"
@@ -425 +425 @@
          "  fExcludedFDA           VARCHAR(255)             NULL"
          ") MAX_ROWS=65536"));
+
+
+    list.Add(new TObjString(
+         "CREATE TABLE MyMagic.DataCheck ("
+         "  fRunNumber                INT      UNSIGNED PRIMARY KEY,"
+         "  fEvents                   INT      UNSIGNED        NULL,"
+         "  fPositionSignal           TINYINT  UNSIGNED        NULL,"
+         "  fPositionFWHM             TINYINT  UNSIGNED        NULL,"
+         "  fHeightSignal             SMALLINT UNSIGNED        NULL,"
+         "  fHeightFWHM               SMALLINT UNSIGNED        NULL,"
+         "  fHasSignal                ENUM(\"yes\",\"no\")     NULL,"
+         "  fHasPedestal              ENUM(\"yes\",\"no\")     NULL,"
+         "  fPositionAsym             ENUM(\"yes\",\"no\")     NULL,"
+         "  fHeightAsym               ENUM(\"yes\",\"no\")     NULL,"
+         "  fEventsInterlaced         INT      UNSIGNED        NULL,"
+         "  fPositionSignalInterlaced TINYINT  UNSIGNED        NULL,"
+         "  fPositionFWHMInterlaced   TINYINT  UNSIGNED        NULL,"
+         "  fHeightSignalInterlaced   SMALLINT UNSIGNED        NULL,"
+         "  fHeightFWHMInterlaced     SMALLINT UNSIGNED        NULL,"
+         "  fHasSignalInterlaced      ENUM(\"yes\",\"no\")     NULL,"
+         "  fHasPedestalInterlaced    ENUM(\"yes\",\"no\")     NULL,"
+         "  fPositionAsymInterlaced   ENUM(\"yes\",\"no\")     NULL,"
+         "  fHeightAsymInterlaced     ENUM(\"yes\",\"no\")     NULL"
+         ")"));