aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--phpBB/phpbb/db/tools.php4
1 files changed, 2 insertions, 2 deletions
diff --git a/phpBB/phpbb/db/tools.php b/phpBB/phpbb/db/tools.php
index 38655018e1..05bba0ba84 100644
--- a/phpBB/phpbb/db/tools.php
+++ b/phpBB/phpbb/db/tools.php
@@ -2649,11 +2649,11 @@ class tools
break;
case 'oracle':
- $sql = "SELECT ixc.column_name AS phpbb_index_name
+ $sql = "SELECT ix.index_name AS phpbb_index_name
FROM all_ind_columns ixc, all_indexes ix
WHERE ix.index_name = ixc.index_name
AND ixc.table_name = UPPER('{$table_name}')
- AND ixc.index_name = UPPER('{$column_name}')
+ AND ixc.column_name = UPPER('{$column_name}')
AND ix.uniqueness = " . ($unique) ? "'UNIQUE'" : "'NONUNIQUE'";
break;
}