Changeset 7037

Timestamp:

05/13/05 22:15:34 (20 years ago)

Author:

Daniela Dorner

Message:

*** empty log message ***

Location:

trunk/MagicSoft/Mars

Files:

• Changelog (modified) (1 diff)
• datacenter/macros/insertdataset.C (added)
• datacenter/macros/setupdb.C (modified) (1 diff)
• datacenter/scripts/insertdatasets (added)

trunk/MagicSoft/Mars/Changelog

@@ -23 +23 @@
  2005/05/13 Daniela Dorner
 
+   * datacenter/macros/insertdataset.C
+     - added (macro, that inserts dataset into db)
+
+   * datacenter/macros/setupdb.C
+     - adapted to new table in db
+
+   * datacenter/scripts/insertdatasets
+     - added (script, that inserts datasets into db)
+
    * datacenter/scripts/sourcefile
      - added (file with commands and variables, that are needed by all
-       scripts
+       scripts)
 
    * datacenter/scripts/buildsequenceentries, checkfilesforsequenceavail

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

@@ -534 +534 @@
 
     list.Add(new TObjString(
+         "CREATE TABLE MyMagic.DataSets ("
+         "  fDataSetNumber      INT           UNSIGNED   PRIMARY KEY, "
+         "  fSourceKEY          SMALLINT      UNSIGNED   NOT NULL,"
+         "  fWobble             ENUM('Y','N')            NULL,"
+         "  fLastUpdate         TIMESTAMP"
+         ")"));
+
+    list.Add(new TObjString(
+         "CREATE TABLE MyMagic.DataSetProcessStatus ("
+         "  fDataSetNumber    INT       UNSIGNED   PRIMARY KEY, "
+         "  fDataSetInserted  DATETIME             NULL,"
+         "  fGanymed          DATETIME             NULL"
+         ")";
+
+    list.Add(new TObjString(
          "CREATE TABLE MyMagic.SequenceBuildStatus ("
          "  fDate                  DATE                 PRIMARY KEY, "