12 lines
392 B
MySQL
12 lines
392 B
MySQL
|
-- Migration: Remove UNIQUE constraint from words.name
|
||
|
|
-- This script removes the unique constraint on the name column in the words table
|
||
|
|
|
||
|
|
-- Drop the unique constraint on words.name if it exists
|
||
|
|
ALTER TABLE words
|
||
|
|
DROP CONSTRAINT IF EXISTS words_name_key;
|
||
|
|
|
||
|
|
-- Also try to drop constraint if it was created with different name
|
||
|
|
ALTER TABLE words
|
||
|
|
DROP CONSTRAINT IF EXISTS words_name_unique;
|
||
|
|
|