From 34d495d1ba08dd15d46653b77d11991b1f41ff8d Mon Sep 17 00:00:00 2001
From: toyomoyo <toyomoyo>
Date: Fri, 21 Apr 2006 07:47:14 +0000
Subject: [PATCH] fix for bug 5205

---
 backup/db/mysql.php | 10 ++++++++++
 backup/db/mysql.sql |  4 ++--
 backup/version.php  |  2 +-
 3 files changed, 13 insertions(+), 3 deletions(-)

diff --git a/backup/db/mysql.php b/backup/db/mysql.php
index 13864c2b2b..b9eda335d4 100644
--- a/backup/db/mysql.php
+++ b/backup/db/mysql.php
@@ -135,6 +135,16 @@ function backup_upgrade($oldversion=0) {
         }
     }
 
+
+    // code to drop the prefix in tables
+    if ($oldversion < 2006042100) {
+        $result = execute_sql("ALTER TABLE {$CFG->prefix}backup_files DROP INDEX {$CFG->prefix}backup_files_uk");
+        $result = execute_sql("ALTER TABLE {$CFG->prefix}backup_ids DROP INDEX {$CFG->prefix}backup_ids_uk");
+        $result = execute_sql("ALTER TABLE {$CFG->prefix}backup_files ADD UNIQUE INDEX {$CFG->prefix}backup_files_uk(backup_code,file_type(10),path(255))");
+        $result = execute_sql("ALTER TABLE {$CFG->prefix}backup_ids ADD UNIQUE INDEX {$CFG->prefix}backup_ids_uk(backup_code,table_name(30),old_id)");
+    }
+
+
     //Finally, return result
     return $result;
 
diff --git a/backup/db/mysql.sql b/backup/db/mysql.sql
index d098d9ee5f..d0d2bc6833 100644
--- a/backup/db/mysql.sql
+++ b/backup/db/mysql.sql
@@ -10,7 +10,7 @@ CREATE TABLE `prefix_backup_files` (
   `old_id` int(10) unsigned default NULL,
   `new_id` int(10) unsigned default NULL,
   PRIMARY KEY  (`id`),
-  UNIQUE KEY `prefix_backup_files_uk` (`backup_code`,`file_type`,`path`)
+  UNIQUE KEY `backup_files_uk` (`backup_code`,`file_type`,`path`)
 ) TYPE=MyISAM COMMENT='To store and recode ids to user and course files.';
 # --------------------------------------------------------
 
@@ -26,7 +26,7 @@ CREATE TABLE `prefix_backup_ids` (
   `new_id` int(10) unsigned default NULL,
   `info` mediumtext,
   PRIMARY KEY  (`id`),
-  UNIQUE KEY `prefix_backup_ids_uk` (`backup_code` ,`table_name`,`old_id`)
+  UNIQUE KEY `backup_ids_uk` (`backup_code` ,`table_name`,`old_id`)
 ) TYPE=MyISAM COMMENT='To store and convert ids in backup/restore';
 # --------------------------------------------------------
 
diff --git a/backup/version.php b/backup/version.php
index 74125a4bdc..60a479aecb 100644
--- a/backup/version.php
+++ b/backup/version.php
@@ -5,6 +5,6 @@
 // database (backup_version) to determine whether upgrades should
 // be performed (see db/backup_*.php)
 
-$backup_version = 2006032900;   // The current version is a date (YYYYMMDDXX)
+$backup_version = 2006042100;   // The current version is a date (YYYYMMDDXX)
 
 $backup_release = "1.6beta1";  // User-friendly version number
-- 
2.39.5