forked from science-ation/science-ation
cbfd66bb28
also add a unique constraint on the user_roles table (user_id,role_id)
3 lines
161 B
SQL
3 lines
161 B
SQL
ALTER TABLE `registrations` ADD `numstudents` TINYINT( 4 ) NULL DEFAULT NULL AFTER `nummentors`;
|
|
ALTER TABLE `user_roles` ADD UNIQUE ( `users_id` , `roles_id`);
|