← Back to branch summary

~azzar1/unity/add-show-desktop-key

916 by mattgiuca
userdb: Added constraints UNIQUE and NOT NULL to subjects.subj_short_name. 
1
 
BEGIN;

2
 
ALTER TABLE subject ADD UNIQUE (subj_short_name);

3
 
ALTER TABLE subject ALTER COLUMN subj_short_name SET NOT NULL;

4
 
COMMIT;