Contents

class CreateEffectiveAssets < ActiveRecord::Migration[4.2]
  def self.up
    create_table <%= @assets_table_name %> do |t|
      t.string  :title
      t.text    :extra

      t.integer :user_id

      t.string  :content_type
      t.text    :upload_file
      t.string  :data
      t.boolean :processed, :default => false
      t.string  :aws_acl, :default => 'public-read'

      t.integer :data_size
      t.integer :height
      t.integer :width
      t.text    :versions_info

      t.timestamps
    end

    add_index <%= @assets_table_name %>, :content_type
    add_index <%= @assets_table_name %>, :user_id

    create_table <%= @attachments_table_name %> do |t|
      t.integer :asset_id
      t.string  :attachable_type
      t.integer :attachable_id
      t.integer :position
      t.string  :box
    end

    create_table <%= @iframe_uploads_table_name %> do |t|
      t.timestamps
    end

    add_index <%= @attachments_table_name %>, :asset_id
    add_index <%= @attachments_table_name %>, [:attachable_type, :attachable_id]
    add_index <%= @attachments_table_name %>, :attachable_id
  end

  def self.down
    drop_table <%= @assets_table_name %>
    drop_table <%= @attachments_table_name %>
  end
end

Version data entries

9 entries across 9 versions & 1 rubygems

Version	Path
effective_assets-1.12.2	db/migrate/01_create_effective_assets.rb.erb
effective_assets-1.12.1	db/migrate/01_create_effective_assets.rb.erb
effective_assets-1.12.0	db/migrate/01_create_effective_assets.rb.erb
effective_assets-1.11.5	db/migrate/01_create_effective_assets.rb.erb
effective_assets-1.11.4	db/migrate/01_create_effective_assets.rb.erb
effective_assets-1.11.3	db/migrate/01_create_effective_assets.rb.erb
effective_assets-1.11.2	db/migrate/01_create_effective_assets.rb.erb
effective_assets-1.11.1	db/migrate/01_create_effective_assets.rb.erb
effective_assets-1.11.0	db/migrate/01_create_effective_assets.rb.erb