Contents

class CreateAssets < ActiveRecord::Migration
  def self.up
    create_table :assets do |t|
      t.integer  "parent_id"
		  t.string   "content_type"
		  t.string   "filename", :limit=>80
		  t.string   "thumbnail", :limit=>20
		  t.integer  "size"
		  t.integer  "width"
		  t.integer  "height"
		  t.string   "type", :limit=>40
		  t.integer  "user_id"
		  t.integer  "assetable_id"
		  t.string   "assetable_type", :limit=>40
		  
      t.timestamps
    end
    
    add_index "assets", ["assetable_id", "assetable_type", "type"], :name => "ndx_type_assetable"
		add_index "assets", ["assetable_id", "assetable_type"], :name => "fk_assets"
		add_index "assets", ["parent_id", "type"], :name => "ndx_type_name"
		add_index "assets", ["thumbnail", "parent_id"], :name => "assets_thumbnail_parent_id"
		add_index "assets", ["user_id", "assetable_type", "assetable_id"], :name => "assets_user_type_assetable_id"
		add_index :assets, :user_id, :name=>"fk_user"
  end

  def self.down
    drop_table :assets
  end
end

Version data entries

24 entries across 24 versions & 5 rubygems

Version	Path
ckeditor-3.5.3	examples/migrations/attachment_fu/create_assets.rb
ckeditor-3.5.2	examples/migrations/attachment_fu/create_assets.rb
ckeditor-3.5.1	examples/migrations/attachment_fu/create_assets.rb
dust-ckeditor-3.5.0	examples/migrations/attachment_fu/create_assets.rb
hifi-ckeditor-3.5.2	examples/migrations/attachment_fu/create_assets.rb
hifi-ckeditor-3.5.1	examples/migrations/attachment_fu/create_assets.rb
artemk-ckeditor-3.5.5	examples/migrations/attachment_fu/create_assets.rb
ckeditor-jess-3.4.3	examples/migrations/attachment_fu/create_assets.rb
ckeditor-3.5.0	examples/migrations/attachment_fu/create_assets.rb
artemk-ckeditor-3.5.4	examples/migrations/attachment_fu/create_assets.rb
artemk-ckeditor-3.4.4	examples/migrations/attachment_fu/create_assets.rb
artemk-ckeditor-3.4.3	examples/migrations/attachment_fu/create_assets.rb
ckeditor-3.4.3.pre	examples/migrations/attachment_fu/create_assets.rb
ckeditor-3.4.3	examples/migrations/attachment_fu/create_assets.rb
ckeditor-3.4.2.pre	examples/migrations/attachment_fu/create_assets.rb
ckeditor-3.4.2	examples/migrations/attachment_fu/create_assets.rb
ckeditor-3.4.1.pre	examples/migrations/attachment_fu/create_assets.rb
ckeditor-3.4.1	examples/migrations/attachment_fu/create_assets.rb
ckeditor-3.4.0	examples/migrations/attachment_fu/create_assets.rb
ckeditor-3.4.0.pre	examples/migrations/attachment_fu/create_assets.rb