Constraint – Not Null, Unique

/* Make Username Unique */
ALTER TABLE students ADD UNIQUE(username);

/* Drop Index For osama */
ALTER TABLE students DROP INDEX osama;

/* Add test Field Not Null And Unique */
ALTER TABLE students ADD test varchar(255) NOT NULL UNIQUE;