diff options
author | ache <ache@FreeBSD.org> | 2001-01-31 05:40:53 +0800 |
---|---|---|
committer | ache <ache@FreeBSD.org> | 2001-01-31 05:40:53 +0800 |
commit | 9d8e5e0a2da5acf772040a3f5c037c2f315b638c (patch) | |
tree | 183fdf0b87fc3b384d92184221dcd0e9a943126b /www/mnogosearch | |
parent | 82c6c897b0a4c31e7fa8f515f8736d6da6ef5bbf (diff) | |
download | freebsd-ports-graphics-9d8e5e0a2da5acf772040a3f5c037c2f315b638c.tar.gz freebsd-ports-graphics-9d8e5e0a2da5acf772040a3f5c037c2f315b638c.tar.zst freebsd-ports-graphics-9d8e5e0a2da5acf772040a3f5c037c2f315b638c.zip |
Add missing msql DB initialization files
Fix msql syntax error
Diffstat (limited to 'www/mnogosearch')
-rw-r--r-- | www/mnogosearch/Makefile | 5 | ||||
-rw-r--r-- | www/mnogosearch/files/msql_ispell.txt | 21 | ||||
-rw-r--r-- | www/mnogosearch/files/msql_track.txt | 7 | ||||
-rw-r--r-- | www/mnogosearch/files/patch-ad | 92 |
4 files changed, 125 insertions, 0 deletions
diff --git a/www/mnogosearch/Makefile b/www/mnogosearch/Makefile index 508071d81d1..43b350e3772 100644 --- a/www/mnogosearch/Makefile +++ b/www/mnogosearch/Makefile @@ -53,6 +53,11 @@ pre-fetch: @${ECHO} .endif +# Add missing msql DB initialization files +post-patch: + ${CP} ${FILESDIR}/msql_ispell.txt ${WRKSRC}/create/msql/ispell.txt + ${CP} ${FILESDIR}/msql_track.txt ${WRKSRC}/create/msql/track.txt + pre-install: @${MKDIR} ${PREFIX}/share/mnogosearch diff --git a/www/mnogosearch/files/msql_ispell.txt b/www/mnogosearch/files/msql_ispell.txt new file mode 100644 index 00000000000..12936c8bf25 --- /dev/null +++ b/www/mnogosearch/files/msql_ispell.txt @@ -0,0 +1,21 @@ +DROP TABLE affix\g +DROP TABLE spell\g + +CREATE TABLE affix ( + flag char(1) NOT NULL, + type char(1) NOT NULL, + lang char(3) NOT NULL, + mask char(32) NOT NULL, + find char(32) NOT NULL, + repl char(32) NOT NULL +) \g + +CREATE TABLE spell ( + word char(64) NOT NULL, + flag text(32) NOT NULL, + lang char(3) NOT NULL +) \g + + +CREATE INDEX affix_flag ON affix (flag)\g +CREATE INDEX spell_word ON spell (word)\g diff --git a/www/mnogosearch/files/msql_track.txt b/www/mnogosearch/files/msql_track.txt new file mode 100644 index 00000000000..8c3425a86ea --- /dev/null +++ b/www/mnogosearch/files/msql_track.txt @@ -0,0 +1,7 @@ +DROP TABLE qtrack\g + +CREATE TABLE qtrack ( + qwords text(63) NOT NULL, + qtime int NOT NULL, + found int NOT NULL +) \g diff --git a/www/mnogosearch/files/patch-ad b/www/mnogosearch/files/patch-ad new file mode 100644 index 00000000000..5de268297cd --- /dev/null +++ b/www/mnogosearch/files/patch-ad @@ -0,0 +1,92 @@ +--- src/sql.c.bak Wed Jan 24 13:35:58 2001 ++++ src/sql.c Tue Jan 30 22:11:34 2001 +@@ -2205,8 +2205,13 @@ + } + int UdmMarkForReindex(UDM_AGENT *Indexer){ + char qbuf[UDMSTRSIZ]; ++#ifdef HAVE_MSQL ++ sprintf(qbuf,"UPDATE url SET next_index_time=%d WHERE rec_id<>0 %s%s%s%s%s",(int)now(), ++ Indexer->Conf->tagstr,Indexer->Conf->urlstr,Indexer->Conf->statusstr,Indexer->Conf->langstr,Indexer->Conf->catstr); ++#else + sprintf(qbuf,"UPDATE url SET next_index_time=%d WHERE 1=1 %s%s%s%s%s",(int)now(), + Indexer->Conf->tagstr,Indexer->Conf->urlstr,Indexer->Conf->statusstr,Indexer->Conf->langstr,Indexer->Conf->catstr); ++#endif + sql_query(Indexer,qbuf); + if(UdmDBErrorCode(Indexer->db))return(IND_ERROR); + return(IND_OK); +@@ -3136,6 +3141,18 @@ + char qbuf[UDMSTRSIZ]; + + if(query->Conf->tagstr[0] || query->Conf->statusstr[0] || query->Conf->urlstr[0] || query->Conf->langstr[0] || query->Conf->timestr[0] || query->Conf->catstr[0]){ ++#ifdef HAVE_MSQL ++ sprintf(qbuf,"\ ++SELECT rec_id \ ++FROM url \ ++WHERE rec_id<>0 %s%s%s%s%s%s", ++ query->Conf->tagstr, ++ query->Conf->statusstr, ++ query->Conf->urlstr, ++ query->Conf->langstr, ++ query->Conf->timestr, ++ query->Conf->catstr); ++#else + sprintf(qbuf,"\ + SELECT rec_id \ + FROM url \ +@@ -3146,7 +3163,7 @@ + query->Conf->langstr, + query->Conf->timestr, + query->Conf->catstr); +- ++#endif + ((DB*)(query->db))->res=sql_query(query,qbuf); + if(UdmDBErrorCode(query->db))return(NULL); + num=SQL_NUM_ROWS(((DB*)(query->db))->res); +@@ -3595,13 +3612,21 @@ + } + SQL_FREE(((DB*)(Indexer->db))->res); + #elif (HAVE_IBASE||HAVE_MSQL || HAVE_IODBC || HAVE_UNIXODBC || HAVE_SOLID || HAVE_VIRT || HAVE_EASYSOFT) ++#ifdef HAVE_MSQL ++ sprintf(qbuf,"SELECT status,next_index_time FROM url WHERE rec_id<>0 %s%s%s%s%s", ++ Indexer->Conf->tagstr, ++ Indexer->Conf->urlstr, ++ Indexer->Conf->statusstr, ++ Indexer->Conf->langstr, ++ Indexer->Conf->catstr); ++#else + sprintf(qbuf,"SELECT status,next_index_time FROM url WHERE 1=1 %s%s%s%s%s", + Indexer->Conf->tagstr, + Indexer->Conf->urlstr, + Indexer->Conf->statusstr, + Indexer->Conf->langstr, + Indexer->Conf->catstr); +- ++#endif + ((DB*)(Indexer->db))->res=sql_query(Indexer,qbuf); + if(UdmDBErrorCode(Indexer->db))return(IND_ERROR); + if(SQL_NUM_ROWS(((DB*)(Indexer->db))->res)){ +@@ -3698,6 +3723,15 @@ + #ifdef HAVE_SQL_LIMIT + sprintf(limit," LIMIT %d",URL_DELETE_CACHE); + #endif ++#ifdef HAVE_MSQL ++ sprintf(qbuf,"SELECT rec_id FROM url WHERE rec_id<>0 %s%s%s%s%s%s", ++ Indexer->Conf->tagstr, ++ Indexer->Conf->urlstr, ++ Indexer->Conf->statusstr, ++ Indexer->Conf->langstr, ++ Indexer->Conf->catstr, ++ limit); ++#else + sprintf(qbuf,"SELECT rec_id FROM url WHERE 1=1 %s%s%s%s%s%s", + Indexer->Conf->tagstr, + Indexer->Conf->urlstr, +@@ -3705,7 +3739,7 @@ + Indexer->Conf->langstr, + Indexer->Conf->catstr, + limit); +- ++#endif + ((DB*)(Indexer->db))->res=sql_query(Indexer,qbuf); + if(UdmDBErrorCode(Indexer->db))return(IND_ERROR); + if(SQL_NUM_ROWS(((DB*)(Indexer->db))->res)){ |