[aur-dev] [PATCH] Remove fulltext index from "Packages".

[Lukas Fleischer]

Drop unused fulltext indexes from "Packages" table (all search routines
use "LIKE" patterns) which prevent the use of InnoDB.

Signed-off-by: Lukas Fleischer <archlinux at cryptocrack.de>
---
As far as I can see, this is the only thing that prevents us from using
InnoDB as the storage engine for all tables. Correct me if I missed
something.

 UPGRADING                     |   10 +++++++++-
 support/schema/aur-schema.sql |    1 -
 2 files changed, 9 insertions(+), 2 deletions(-)

diff --git a/UPGRADING b/UPGRADING
index 661a6c3..c649985 100644
--- a/UPGRADING
+++ b/UPGRADING
@@ -29,7 +29,15 @@ ALTER TABLE TU_VoteInfo
 	MODIFY User VARCHAR(32) collate latin1_general_ci NOT NULL;
 ----
 
-2. You will need to update all packages which are stored in the incoming dir as
+2. Drop all fulltext indexes from the "Packages" table:
+
+Please do this with care. `ALTER TABLE Packages DROP INDEX Name;` will work in
+most cases but might remove the wrong index if your indexes have been created
+in a non-standard order (e.g. during some update process). You'd better run
+`SHOW INDEX FROM Packages;` before to ensure that your setup doesn't use a
+different naming.
+
+3. You will need to update all packages which are stored in the incoming dir as
 in 1.8.0, source tarballs are no longer extracted automatically and PKGBUILDs
 are from now on located in the same subdirectories as the tarballs themselves.
 The following script will do the conversion automatically when being run inside
diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql
index cddf00e..d37e1b2 100644
--- a/support/schema/aur-schema.sql
+++ b/support/schema/aur-schema.sql
@@ -106,7 +106,6 @@ CREATE TABLE Packages (
 	ModifiedTS BIGINT UNSIGNED NOT NULL,
 	SubmitterUID INTEGER UNSIGNED NOT NULL DEFAULT 0,     -- who submitted it?
 	MaintainerUID INTEGER UNSIGNED NOT NULL DEFAULT 0,    -- User
-	FULLTEXT (Name,Description),
 	PRIMARY KEY (ID),
 	UNIQUE (Name),
 	INDEX (CategoryID),
-- 
1.7.4