IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changeset 39022


Ignore:
Timestamp:
Nov 2, 2015, 8:34:56 AM (11 years ago)
Author:
eugene
Message:

INDEX is invalid as a mysql column name, change to SERSIC_INDEX; use DROP TABLE IF EXISTS

Location:
trunk/Ohana/src/dvopsps/src
Files:
3 edited

Legend:

Unmodified
Added
Removed

  • trunk/Ohana/src/dvopsps/src/insert_FGshape_dvopsps_catalog.c

    r38674 r39022  
    9090
    9191  // *** Average / cpt ***
    92   PrintIOBuffer (&buffer, "DROP TABLE %s_cpt\n", basename);
     92  PrintIOBuffer (&buffer, "DROP TABLE IF EXISTS %s_cpt\n", basename);
    9393  status = mysql_query(mysql, buffer.buffer);
    9494  if (status) {
    … …  
    117117
    118118  // *** Galphot / cpq ***
    119   PrintIOBuffer (&buffer, "DROP TABLE %s_cpq\n", basename);
     119  PrintIOBuffer (&buffer, "DROP TABLE IF EXISTS %s_cpq\n", basename);
    120120  status = mysql_query(mysql, buffer.buffer);
    121121  if (status) {
    … …  
    141141                 "THETA              FLOAT, "
    142142                 "THETA_ERR          FLOAT, "
    143                  "INDEX              FLOAT, "
    144                  "CHISQ              FLOAT  "
     143                 "SERSIC_INDEX       FLOAT, "
     144                 "CHISQ              FLOAT,  "
    145145
    146146                 "NPIX               INT "
    … …  
    193193                 "THETA, "
    194194                 "THETA_ERR, "
    195                  "INDEX, "
     195                 "SERSIC_INDEX, "
    196196                 "CHISQ"
    197197                 ") VALUES \n", basename);

  • trunk/Ohana/src/dvopsps/src/insert_FWobjects_dvopsps_catalog.c

    r38153 r39022  
    104104  // MYSQL_RES *result;
    105105
    106   PrintIOBuffer (&buffer, "DROP TABLE %s_cpt\n", basename);
     106  PrintIOBuffer (&buffer, "DROP TABLE IF EXISTS %s_cpt\n", basename);
    107107  status = mysql_query(mysql, buffer.buffer);
    108108  if (status) {
    … …  
    130130  bzero (buffer.buffer, buffer.Nalloc);
    131131
    132   PrintIOBuffer (&buffer, "DROP TABLE %s_cps\n", basename);
     132  PrintIOBuffer (&buffer, "DROP TABLE IF EXISTS %s_cps\n", basename);
    133133  status = mysql_query(mysql, buffer.buffer);
    134134  if (status) {
    … …  
    170170  bzero (buffer.buffer, buffer.Nalloc);
    171171
    172   PrintIOBuffer (&buffer, "DROP TABLE %s_cpy\n", basename);
     172  PrintIOBuffer (&buffer, "DROP TABLE IF EXISTS %s_cpy\n", basename);
    173173  status = mysql_query(mysql, buffer.buffer);
    174174  if (status) {

  • trunk/Ohana/src/dvopsps/src/insert_diffobj_dvopsps_catalog.c

    r38153 r39022  
    7979  // MYSQL_RES *result;
    8080
    81   PrintIOBuffer (&buffer, "DROP TABLE %s_cpt\n", basename);
     81  PrintIOBuffer (&buffer, "DROP TABLE IF EXISTS %s_cpt\n", basename);
    8282  status = mysql_query(mysql, buffer.buffer);
    8383  if (status) {
    … …  
    110110  bzero (buffer.buffer, buffer.Nalloc);
    111111
    112   PrintIOBuffer (&buffer, "DROP TABLE %s_cps\n", basename);
     112  PrintIOBuffer (&buffer, "DROP TABLE IF EXISTS %s_cps\n", basename);
    113113  status = mysql_query(mysql, buffer.buffer);
    114114  if (status) {
Note: See TracChangeset for help on using the changeset viewer.