added NOT NULL and AUTOINCREMENT to dbschema
added missing info to projects