search for: if_exist

...staff, Post.joins(comment: user).where(users: {role: ''staff''}).uniq create_view :uncommented_posts, "SELECT * FROM posts LEFT OUTER JOIN comments ON comments.post_id = posts.id WHERE comments.id IS NULL" And a few other smaller things: drop_table :table_name, if_exists: true, cascade: true # :if_exists and :cascade options to drop_table t.datetime :seen_at, default: { expr: ''NOW()'' } # default expressions post.update_attributes(category: ActiveRecord::DB_DEFAULT) # instruct rails to use the Cheers, -rone...