science-ation/db/db.update.234.sql
james cbfd66bb28 add numstudents API to the project object
also add a unique constraint on the user_roles table (user_id,role_id)
2011-03-04 01:05:15 +00:00

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`);