adding support for column length generation in primary keys. adding plugin for SC demographics, updating column drop support