disabling zip by default.
removed unnecessary index and some columns.
removed authorization set from abstract role.