Changeset 1282 for trunk/mainfunc.h

Timestamp:

03/19/10 08:04:03 (2 years ago)

Author:

Gary

Message:

unxsVZ tGlossary functionality work in progress.

Files:

• trunk/mainfunc.h (modified) (3 diffs)

trunk/mainfunc.h

@@ -921 +921 @@
         unsigned uJobContainerIndex=0;
         unsigned uTemplateLabelIndex=0;
+        unsigned uGlossaryLabelIndex=0;
 
         printf("UpdateSchema(): Start\n");
@@ -1002 +1003 @@
         mysql_free_result(res);
 
+        sprintf(gcQuery,"SHOW INDEX IN tGlossary");
+        mysql_query(&gMysql,gcQuery);
+        if(mysql_errno(&gMysql))
+                printf("%s\n",mysql_error(&gMysql));
+        mysql_query(&gMysql,gcQuery);
+        res=mysql_store_result(&gMysql);
+        while((field=mysql_fetch_row(res)))
+        {
+                if(!strcmp(field[2],"cLabel")) uGlossaryLabelIndex=1;
+        }
+        mysql_free_result(res);
+
         if(uIncorrectVeth)
         {
@@ -1172 +1185 @@
                 else
                         printf("Added INDEX cLabel tTemplate\n");
+        }
+
+        if(!uGlossaryLabelIndex)
+        {
+                sprintf(gcQuery,"ALTER TABLE tGlossary ADD INDEX (cLabel)");
+                mysql_query(&gMysql,gcQuery);
+                if(mysql_errno(&gMysql))
+                        printf("%s\n",mysql_error(&gMysql));
+                else
+                        printf("Added INDEX cLabel tGlossary\n");
         }