Ok, well I've already got a database running that provides live stats information for the chessbrain project. The problem is I'm running on DSL and anything to help speed up the query processes would be great, because my output is only 13kb/s. Typicaly it's fine, but when the person viewing the stats wants a list of all individuals in the project it has to query 4 tables and about 1000 rows in each table. So I figured it's about time to enable full-text indexing to help the process go a little quicker.
I believe I could set up full-text indexing when creating db tables, but the problem is I already have the tables made and want to enable it without having to redo the whole database and have the stats down.
Right now I would just like to do it on the table that stores the users name/country code/team, etc. The table looks like this:
uID (int, Null) <----unique identifier for all tables.
name (varchar(50), Null)
team (text, Null)
country (text, Null)
tID (int, Null)
When I try to setup the full-text indexing on the table I get this:
The selected table has no
unique single column index on a column that does not allow NULLS.
I tryed changine uID to not allow Nulls but it still gives the same error. Do I have to redo the whole table to get this going?
