- Patch by Matt: made it possible to alias an URL multiple times.

3 files changed, 14 insertions, 4 deletions

diff --git a/database/database.mysql b/database/database.mysql
index 3b3f86643..003fb35d2 100644
--- a/database/database.mysql
+++ b/database/database.mysql
@@ -394,8 +394,7 @@ 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 src (src)
+  UNIQUE KEY dst (dst)
 ) TYPE=MyISAM;
 
 --
diff --git a/database/database.pgsql b/database/database.pgsql
index 4ec05d474..1ce84a83a 100644
--- a/database/database.pgsql
+++ b/database/database.pgsql
@@ -407,7 +407,6 @@ CREATE TABLE url_alias (
   src varchar(128) NOT NULL default '',
   PRIMARY KEY  (pid)
 );
-CREATE INDEX url_alias_src_idx ON url_alias(src);
 CREATE INDEX url_alias_dst_idx ON url_alias(dst);
 --
 -- Table structure for permission
diff --git a/database/updates.inc b/database/updates.inc
index f63568b69..5bd6279a9 100644
--- a/database/updates.inc
+++ b/database/updates.inc
@@ -63,7 +63,8 @@ $sql_updates = array(
   "2004-06-18" => "update_89",
   "2004-06-27" => "update_90",
   "2004-06-30" => "update_91",
-  "2004-07-07" => "update_92"
+  "2004-07-07" => "update_92",
+  "2004-07-10" => "update_93",
 );
 
 function update_32() {
@@ -1149,6 +1150,17 @@ function update_92() {
   return $ret;
 }
 
+function update_93() {
+  $ret = array();
+  if ($GLOBALS['db_type'] == 'pgsql') {
+    $ret[] = update_sql('DROP INDEX url_alias_src_idx');
+  }
+  else {
+    $ret[] = update_sql('ALTER TABLE {url_alias} DROP INDEX src');
+  }
+  return $ret;
+}
+
 function update_sql($sql) {
   $edit = $_POST["edit"];
   $result = db_query($sql);