475       struct sqlite3_index_constraint *pCons = &pIdxInfo->aConstraint[i];  in expertBestIndex()  local
476       if( pCons->usable   in expertBestIndex()
477        && pCons->iColumn>=0   in expertBestIndex()
478        && p->pTab->aCol[pCons->iColumn].iPk==0  in expertBestIndex()
479        && (pCons->op & opmask)   in expertBestIndex()
485           pNew->iCol = pCons->iColumn;  in expertBestIndex()
486           if( pCons->op==SQLITE_INDEX_CONSTRAINT_EQ ){  in expertBestIndex()
847   IdxConstraint *pCons  in idxAppendColDefn()  argument
850   IdxColumn *p = &pTab->aCol[pCons->iCol];  in idxAppendColDefn()
859   if( sqlite3_stricmp(p->zColl, pCons->zColl) ){  in idxAppendColDefn()
860     if( idxIdentifierRequiresQuotes(pCons->zColl) ){  in idxAppendColDefn()
861       zRet = idxAppendText(pRc, zRet, " COLLATE %Q", pCons->zColl);  in idxAppendColDefn()
863       zRet = idxAppendText(pRc, zRet, " COLLATE %s", pCons->zColl);  in idxAppendColDefn()
867   if( pCons->bDesc ){  in idxAppendColDefn()
974     IdxConstraint *pCons;  in idxCreateFromCons()  local
978     for(pCons=pEq; pCons; pCons=pCons->pLink){  in idxCreateFromCons()
979       zCols = idxAppendColDefn(&rc, zCols, pTab, pCons);  in idxCreateFromCons()
981     for(pCons=pTail; pCons; pCons=pCons->pLink){  in idxCreateFromCons()
982       zCols = idxAppendColDefn(&rc, zCols, pTab, pCons);  in idxCreateFromCons()