summaryrefslogtreecommitdiffstats
path: root/support/schema/aur-schema.sql
diff options
context:
space:
mode:
authorLukas Fleischer <archlinux@cryptocrack.de>2011-02-09 09:57:25 +0100
committerLukas Fleischer <archlinux@cryptocrack.de>2011-02-10 08:17:53 +0100
commit881bfcced4b1b0906d7ef57af55f4e7201ad2474 (patch)
treee267d271303ba32730683b414de5659d180b0323 /support/schema/aur-schema.sql
parent0e0e80aeea9396647041061d1104d0001bd1cc5a (diff)
downloadaur-881bfcced4b1b0906d7ef57af55f4e7201ad2474.tar.gz
aur-881bfcced4b1b0906d7ef57af55f4e7201ad2474.tar.xz
Remove unused fulltext index from "Packages" table.
Drop fulltext indexes, which prevent the use of InnoDB, from "Packages" table. All search routines use "LIKE" patterns, so fulltext search has actually never been used. Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
Diffstat (limited to 'support/schema/aur-schema.sql')
-rw-r--r--support/schema/aur-schema.sql1
1 files changed, 0 insertions, 1 deletions
diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql
index cddf00e9..d37e1b26 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),