Changeset 7334 for trunk/MagicSoft/Mars/datacenter/macros

Timestamp:

08/28/05 04:51:25 (19 years ago)

Author:

Daniela Dorner

Message:

*** empty log message ***

File:

• trunk/MagicSoft/Mars/datacenter/macros/setupdb.C (modified) (1 diff)

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

@@ -573 +573 @@
 
     list.Add(new TObjString(
+         "CREATE TABLE MyMagic.Ganymed ("
+         "  fDataSetNumber      INT        UNSIGNED   PRIMARY KEY, "
+         "  fExcessEvents       INT        UNSIGNED   NOT NULL,"
+         "  fBackgroundEvents   INT        UNSIGNED   NOT NULL,"
+         "  fSignalEvents       INT        UNSIGNED   NOT NULL,"
+         "  fEffOnTime          INT        UNSIGNED   NOT NULL,"
+         "  fSignificance       FLOAT(5,1)            NOT NULL,"
+         "  fScaleFactor        FLOAT(5,2)            NOT NULL,"
+         "  fLastUpdate         TIMESTAMP"
+         ")"));
+
+    list.Add(new TObjString(
          "CREATE TABLE MyMagic.DataSetProcessStatus ("
          "  fDataSetNumber    INT       UNSIGNED   PRIMARY KEY, "
          "  fDataSetInserted  DATETIME             NULL,"
          "  fStarFilesAvail   DATETIME             NULL,"
-         "  fGanymed          DATETIME             NULL"
+         "  fGanymed          DATETIME             NULL,"
+         "  fFillGanymed      DATETIME             NULL"
          ")";