Contents

class CreateEmailbutlerTables < ActiveRecord::Migration[7.0]
  def self.up
    enable_extension 'pgcrypto' unless extensions.include?('pgcrypto')
    enable_extension 'uuid-ossp' unless extensions.include?('uuid-ossp')

    create_table :emailbutler_messages do |t|
      t.uuid :uuid, null: false, default: ''
      t.string :mailer, null: false
      t.string :action, null: false
      t.jsonb :params, null: false, default: {}
      t.string :send_to, array: true
      t.timestamps
    end
    add_index :emailbutler_messages, :uuid, unique: true

    create_table :emailbutler_events do |t|
      t.integer :emailbutler_message_id, null: false, index: true
      t.integer :status, null: false
      t.datetime :timestamp
      t.timestamps
    end
  end

  def self.down
    drop_table :emailbutler_messages
    drop_table :emailbutler_events
  end
end

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
emailbutler-0.2.2	db/migrate/20220908180903_create_emailbutler_tables.rb