Contents

ActiveRecord::Schema.define do
  execute('CREATE extension IF NOT EXISTS "hstore";')
  execute('CREATE extension IF NOT EXISTS "pgcrypto";')
  execute('CREATE extension IF NOT EXISTS "uuid-ossp";')

  create_table :vendors, id: :uuid, force: :cascade do |t|
    t.string :name, null: true
    t.text :preferences

    if t.respond_to?(:json)
      t.json :data
    else
      t.text :data
    end

    if t.respond_to?(:hstore)
      t.hstore :config
    else
      t.text :config
    end

    if t.respond_to?(:jsonb)
      t.jsonb :settings
      t.jsonb :json_data, null: false, default: {}
    else
      t.text :settings
      t.text :json_data
    end

    t.datetime :created_at
    t.datetime :updated_at
  end

  create_table :alarms, force: true do |t|
    t.column :device_id, :integer, null: false
    t.column :alarm_type, :integer, null: false
    t.column :status, :integer, null: false
    t.column :metadata, :text
    t.datetime :created_at
    t.datetime :updated_at
  end

  add_index :alarms, [:device_id, :alarm_type], unique: true, where: 'status <> 0'
end

Version data entries

6 entries across 6 versions & 1 rubygems

Version	Path
activerecord-import-0.19.1	test/schema/postgresql_schema.rb
activerecord-import-0.19.0	test/schema/postgresql_schema.rb
activerecord-import-0.18.3	test/schema/postgresql_schema.rb
activerecord-import-0.18.2	test/schema/postgresql_schema.rb
activerecord-import-0.18.1	test/schema/postgresql_schema.rb
activerecord-import-0.18.0	test/schema/postgresql_schema.rb