diff options
| -rw-r--r-- | database/database.mysql | 3 | ||||
| -rw-r--r-- | database/database.pgsql | 1 |
2 files changed, 3 insertions, 1 deletions
diff --git a/database/database.mysql b/database/database.mysql index 17d182cdb..eca633468 100644 --- a/database/database.mysql +++ b/database/database.mysql @@ -485,7 +485,8 @@ CREATE TABLE url_alias ( src varchar(128) NOT NULL default '', dst varchar(128) NOT NULL default '', PRIMARY KEY (pid), - UNIQUE KEY dst (dst) + UNIQUE KEY dst (dst), + KEY src (src) ) TYPE=MyISAM; -- diff --git a/database/database.pgsql b/database/database.pgsql index d1dc213a5..718036ad6 100644 --- a/database/database.pgsql +++ b/database/database.pgsql @@ -500,6 +500,7 @@ CREATE TABLE url_alias ( PRIMARY KEY (pid) ); CREATE INDEX url_alias_dst_idx ON url_alias(dst); +CREATE INDEX url_alias_src ON url_alias(src) -- -- Table structure for permission -- |