Index: /branches/eam_branches/ipp-20140717/Ohana/src/dvopsps/src/insert_objects_dvopsps_catalog.c
===================================================================
--- /branches/eam_branches/ipp-20140717/Ohana/src/dvopsps/src/insert_objects_dvopsps_catalog.c	(revision 37227)
+++ /branches/eam_branches/ipp-20140717/Ohana/src/dvopsps/src/insert_objects_dvopsps_catalog.c	(revision 37228)
@@ -90,20 +90,22 @@
   // Only send the necessary fields (eg, do not sent parallax and pm)
   PrintIOBuffer (&buffer, "CREATE TABLE %s_cpt ("
-		 "EXT_ID      BIGINT, "
-		 "OBJ_ID      INT,    "      
-		 "CAT_ID      INT,    "      
-		 "DVO_REGION  INT,    "
-		 "RA_STK      DOUBLE, "          
-		 "DEC_STK     DOUBLE, "         
-		 "RA_STK_ERR  FLOAT,  "      
-		 "DEC_STK_ERR FLOAT,  "     
-		 "RA_MEAN     DOUBLE, "          
-		 "DEC_MEAN    DOUBLE, "         
-		 "RA_ERR      FLOAT,  "      
-		 "DEC_ERR     FLOAT,  "     
-		 "CHISQ_POS   FLOAT,  "   
-		 "CHISQ_PM    FLOAT,  "    
-		 "CHISQ_PAR   FLOAT,  "   
-		 "FLAGS       INT     "       
+		 "EXT_ID        BIGINT,   "
+		 "OBJ_ID        INT,      "      
+		 "CAT_ID        INT,      " 
+		 "TESS_ID       TINYINT,  " 
+		 "PROJECTION_ID SMALLINT, " 
+		 "SKYCELL_ID    TINYINT,  " 
+		 "RA_STK        DOUBLE,   "          
+		 "DEC_STK       DOUBLE,   "         
+		 "RA_STK_ERR    FLOAT,    "      
+		 "DEC_STK_ERR   FLOAT,    "     
+		 "RA_MEAN       DOUBLE,   "          
+		 "DEC_MEAN      DOUBLE,   "         
+		 "RA_ERR        FLOAT,    "      
+		 "DEC_ERR       FLOAT,    "     
+		 "CHISQ_POS     FLOAT,    "   
+		 "CHISQ_PM      FLOAT,    "    
+		 "CHISQ_PAR     FLOAT,    "   
+		 "FLAGS         INT       "       
 		 ")\n", basename);
 
@@ -168,5 +170,7 @@
 		 "NUSED_AP       SMALLINT,  "    
 		 "NCODE          SMALLINT,  "           
-		 "FLAGS          INT  "           
+		 "NSTACK_DET     SMALLINT,  "           
+		 "PSF_QF_PERF_MAX FLOAT, "           
+		 "FLAGS          INT "           
 		 ")\n", basename);
 
@@ -192,20 +196,22 @@
 
   PrintIOBuffer (ave_buffer, "INSERT INTO %s_cpt ("
-		 "EXT_ID,      "
-		 "OBJ_ID,      "      
-		 "CAT_ID,      "      
-		 "DVO_REGION,  "
-		 "RA_STK,      "          
-		 "DEC_STK,     "         
-		 "RA_STK_ERR,  "      
-		 "DEC_STK_ERR, "     
-		 "RA_MEAN,     "          
-		 "DEC_MEAN,    "         
-		 "RA_ERR,      "      
-		 "DEC_ERR,     "     
-		 "CHISQ_POS,   "   
-		 "CHISQ_PM,    "    
-		 "CHISQ_PAR,   "   
-		 "FLAGS        "       
+		 "EXT_ID,        "
+		 "OBJ_ID,        "      
+		 "CAT_ID,        "      
+		 "TESS_ID,       "      
+		 "PROJECTION_ID, "      
+		 "SKYCELL_ID,    "      
+		 "RA_STK,        "          
+		 "DEC_STK,       "         
+		 "RA_STK_ERR,    "      
+		 "DEC_STK_ERR,   "     
+		 "RA_MEAN,       "          
+		 "DEC_MEAN,      "         
+		 "RA_ERR,        "      
+		 "DEC_ERR,       "     
+		 "CHISQ_POS,     "   
+		 "CHISQ_PM,      "    
+		 "CHISQ_PAR,     "   
+		 "FLAGS          "       
 		 ") VALUES \n", basename);
 
@@ -233,4 +239,6 @@
 
 		 "NCODE, "           
+		 "NSTACK_DET,  "           
+		 "PSF_QF_PERF_MAX, "           
 		 "FLAGS "           
 		 ") VALUES \n", basename);
@@ -252,6 +260,7 @@
   PrintIOBuffer (ave_buffer, "%u,  ", average->catID);          
 
-  int dvoRegion = 1;
-  PrintIOBuffer (ave_buffer, "%u, ",  dvoRegion);          
+  PrintIOBuffer (ave_buffer, "%hhd, ", average->tessID);          
+  PrintIOBuffer (ave_buffer, "%hd,  ", average->projectionID);          
+  PrintIOBuffer (ave_buffer, "%hhd, ", average->skycellID);          
 
   PRINT_FLOAT(ave_buffer, average->Rstk,     "%.8f, ");  // 0.036 mas precision 
@@ -324,5 +333,8 @@
     PrintIOBuffer (sec_buffer, "%hd,  ", secfilt->NusedAp);        
     PrintIOBuffer (sec_buffer, "%hd,  ", secfilt->Ncode);        
-    PrintIOBuffer (sec_buffer, "%u    ", secfilt->flags);       
+    PrintIOBuffer (sec_buffer, "%hd,  ", secfilt->NstackDet);        
+
+    PRINT_FLOAT(sec_buffer, secfilt->psfQfPerfMax, "%.6f,");       
+    PrintIOBuffer (sec_buffer, "%u ", secfilt->flags);       
 
     PrintIOBuffer (sec_buffer, "),\n");