science-ation/db/db.update.224.sql

3 lines
201 B
MySQL
Raw Permalink Normal View History

ALTER TABLE `pagetext` DROP INDEX `textname` , ADD UNIQUE `textname` ( `textname` , `conferences_id` , `lang` );
UPDATE roles SET `type` = 'participant', `name` = 'Participant' WHERE type = 'student';