diff options
| author | Dries Buytaert <dries@buytaert.net> | 2005-05-14 20:59:01 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2005-05-14 20:59:01 +0000 |
| commit | 0c4db413097e1435d0d788a7a1d03e0b7d80296c (patch) | |
| tree | 306d228374a0f315cb98220e9830ee978cf4f7cc | |
| parent | ae98abc15b7028b750fc2b40b756b37be89c1034 (diff) | |
| download | brdo-0c4db413097e1435d0d788a7a1d03e0b7d80296c.tar.gz brdo-0c4db413097e1435d0d788a7a1d03e0b7d80296c.tar.bz2 | |
- Patch by Mathias: database updates for path alias improvements.
| -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 -- |