summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorGo MAEDA <maeda@farend.jp>2024-12-14 03:29:00 +0000
committerGo MAEDA <maeda@farend.jp>2024-12-14 03:29:00 +0000
commit331b955f47412e3b449d6ca6c5b86ffc7b708f28 (patch)
treec8b12c9942bb8ece6e685f3c75798cbd7037088d
parenta7fad287546c2644e42fd1fc274e1f0a0e48ef33 (diff)
downloadredmine-331b955f47412e3b449d6ca6c5b86ffc7b708f28.tar.gz
redmine-331b955f47412e3b449d6ca6c5b86ffc7b708f28.zip
Fix: Missing uniqueness constraint for projects.identifier in the database (#41975).
Patch by Hiroyuki Kano (user:hiropk). git-svn-id: https://svn.redmine.org/redmine/trunk@23407 e93f8b46-1217-0410-a6f0-8f06a7374b81
-rw-r--r--db/migrate/20241213003659_add_unique_index_to_projects_identifier.rb5
1 files changed, 5 insertions, 0 deletions
diff --git a/db/migrate/20241213003659_add_unique_index_to_projects_identifier.rb b/db/migrate/20241213003659_add_unique_index_to_projects_identifier.rb
new file mode 100644
index 000000000..dbfe9c56f
--- /dev/null
+++ b/db/migrate/20241213003659_add_unique_index_to_projects_identifier.rb
@@ -0,0 +1,5 @@
+class AddUniqueIndexToProjectsIdentifier < ActiveRecord::Migration[7.2]
+ def change
+ add_index :projects, :identifier, :unique => true
+ end
+end