Index: trunk/MagicSoft/Mars/datacenter/macros/setupdb.C
===================================================================
--- trunk/MagicSoft/Mars/datacenter/macros/setupdb.C	(revision 8404)
+++ trunk/MagicSoft/Mars/datacenter/macros/setupdb.C	(revision 8405)
@@ -686,4 +686,24 @@
         ") 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;