Contents

class CreateEffectiveAssets < ActiveRecord::Migration
  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.string  :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

    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

25 entries across 25 versions & 1 rubygems

Version	Path
effective_assets-1.4.4	db/migrate/01_create_effective_assets.rb.erb
effective_assets-1.4.3	db/migrate/01_create_effective_assets.rb.erb
effective_assets-1.4.2	db/migrate/01_create_effective_assets.rb.erb
effective_assets-1.4.1	db/migrate/01_create_effective_assets.rb.erb
effective_assets-1.4.0	db/migrate/01_create_effective_assets.rb.erb