forked from science-ation/science-ation
6 lines
216 B
SQL
6 lines
216 B
SQL
-- Change the (unique) index in the users table from (username,year)
|
|
-- to (accounts_id,conferences_id)
|
|
ALTER TABLE `users` DROP INDEX `username`;
|
|
ALTER TABLE `users` ADD UNIQUE (`accounts_id` , `conferences_id`);
|
|
|