From 0c4db413097e1435d0d788a7a1d03e0b7d80296c Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Sat, 14 May 2005 20:59:01 +0000
Subject: - Patch by Mathias: database updates for path alias improvements.

---
 database/database.mysql | 3 ++-
 database/database.pgsql | 1 +
 2 files changed, 3 insertions(+), 1 deletion(-)

(limited to 'database')

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
 --
-- 
cgit v1.2.3