fix id as primary_key and add some indexes
add drop option to cli