ThinkDing  

Go Back   ThinkDing > Member Forums > Pre-Sale Questions
Acceptance Mark
User Name
Password


Reply
 
Thread Tools Search this Thread
  #1  
Old 09-26-2007, 03:25 AM
montero montero is offline
Junior Member
 
Join Date: Sep 2007
Posts: 1
Default does the tdsearch modify the sql database?

Hi I'm thinking of buying this script but I'm wondering whether it will work for me. I want to search a textpattern blog database that I'm setting up, but I'm wondering whether by using tdsearch will corrupt the textpattern blog database? I read on your announcements that the tdstatistics logs are added as a column in a the search database? Do I understand that correctly? ... so it actually modifies the database that it searches?

Thanks.
Reply With Quote
  #2  
Old 10-14-2007, 05:41 PM
Winston Winston is offline
Administrator
 
Join Date: Jul 2005
Posts: 46
Default

Sorry for the delayed response, but to answer the questions, tdSearch adds a FULLTEXT key to the table to be searched, and tdSearchStats uses its own table. Neither of these would corrupt data, but of course you should backup beforehand. The table to be searched should have the following form:
Code:
CREATE TABLE search_data ( title varchar(255) NOT NULL, description text NOT NULL, keywords text NOT NULL, url varchar(255) NOT NULL, size varchar(255) NOT NULL, date varchar(255) NOT NULL ) TYPE=MyISAM;
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump



All times are GMT. The time now is 08:44 PM.


Powered by: vBulletin Version 3.0.7
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright © 2001 - 2005, ThinkDing LLC. All Rights Reserved.