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

Timestamp:

04/12/07 22:00:49 (18 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

@@ -686 +686 @@
         ") MAX_ROWS=256"));
 
+    list.Add(new TObjString(
+        "CREATE TABLE `OpticalData` ("
+        "  `fOpticalDataKEY`     int(11)              NOT NULL auto_increment,"
+        "  `fTimestamp`          datetime             NOT NULL default '0000-00-00 00:00:00',"
+        "  `fExposure`           smallint(5) unsigned NOT NULL default '0',"
+        "  `fFitsFileKEY`        smallint(5) unsigned NOT NULL default '0',"
+        "  `fObjectKEY`          smallint(5) unsigned NOT NULL default '0',"
+        "  `fSkyLevel`           float(6,1)                    default NULL,"
+        "  `fFWHM`               float(4,2)                    default NULL,"
+        "  `fApertureRadius`     float(3,1)                    default NULL,"
+        "  `fInstrumentalMag`    float(7,4)                    default NULL,"
+        "  `fInstrumentalMagErr` float(6,4)                    default NULL,"
+        "  `fStatusKEY`          smallint(5) unsigned NOT NULL default '0',"
+        "  `fZenithDistance`     float(4,1)                    default NULL,"
+        "  `fBandKEY`            smallint(5) unsigned NOT NULL default '0',"
+        "  `fFilterKEY`          smallint(5) unsigned NOT NULL default '0',"
+        "  `fTelescopeKEY`       smallint(5) unsigned NOT NULL default '0',"
+        "  `fCCDKEY`             smallint(5) unsigned NOT NULL default '0',"
+        "  PRIMARY KEY  (`fOpticalDataKEY`)"));
+
     TSQLResult *res;