class PostViewContent < ActiveRecord::Migration[7.1]
  def change
    drop_table :posts

    create_table :posts do |t|
      t.uuid :public_id, null: false
      t.references :created_by_user, foreign_key: {to_table: :users}
      t.bigint :role_visibility
      t.integer :status
      t.string :view_path, null: false
      t.datetime :posted_at
      t.timestamps null: false

      t.index :public_id, unique: true
    end
  end
end