added out columns to ptickets
add migration
improved front-end