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

Timestamp:

05/13/05 11:49:02 (20 years ago)

Author:

Daniela Dorner

Message:

*** empty log message ***

Location:

trunk/MagicSoft/Mars/datacenter/macros

Files:

• buildsequenceentries.C (modified) (1 diff)
• setupdb.C (modified) (1 diff)

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

@@ -75 +75 @@
     {
         query = Form("DELETE FROM MyMagic.Calibration WHERE fSequenceFirst=%s", (*row)[0]);
+
+        TSQLResult *res = serv.Query(query);
+        if (!res)
+            return kFALSE;
+        delete res;
+
+        query = Form("DELETE FROM MyMagic.Star WHERE fSequenceFirst=%s", (*row)[0]);
 
         TSQLResult *res = serv.Query(query);

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

@@ -526 +526 @@
 
     list.Add(new TObjString(
+         "CREATE TABLE MyMagic.Star ("
+         "  fSequenceFirst      INT        UNSIGNED   PRIMARY KEY, "
+         "  fMeanNumberIslands  FLOAT(5,1)            NOT NULL,"
+         "  fPSF                FLOAT(5,1)            NOT NULL,"
+         "  fLastUpdate         TIMESTAMP"
+         ")"));
+
+    list.Add(new TObjString(
          "CREATE TABLE MyMagic.SequenceBuildStatus ("
          "  fDate                  DATE                 PRIMARY KEY, "