Modified db_schema.sql to correct discrepancies. 

In tables auth_project_viewer and auth_project_collaborator, added unique key on groupID and projectID.