diff options
| author | Lukas Fleischer <archlinux@cryptocrack.de> | 2011-02-09 09:57:25 +0100 |
|---|---|---|
| committer | Lukas Fleischer <archlinux@cryptocrack.de> | 2011-02-10 08:17:53 +0100 |
| commit | 881bfcced4b1b0906d7ef57af55f4e7201ad2474 (patch) | |
| tree | e267d271303ba32730683b414de5659d180b0323 /support | |
| parent | 0e0e80aeea9396647041061d1104d0001bd1cc5a (diff) | |
| download | aurweb-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')
| -rw-r--r-- | support/schema/aur-schema.sql | 1 |
1 files changed, 0 insertions, 1 deletions
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), |