PDA

View Full Version : does the tdsearch modify the sql database?


montero
09-26-2007, 03:25 AM
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.

Winston
10-14-2007, 05:41 PM
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:

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;