added some comments
fixed some contraints
created indexes on tables and views