Contents

class CreatePromotionRules < ActiveRecord::Migration
  def up
    create_table :promotion_rules do |t|
      t.references :promotion, :user, :product_group
      t.string :type

      t.timestamps
    end
    add_index :promotion_rules, :product_group_id
    add_index :promotion_rules, :user_id

    create_table :products_promotion_rules do |t|
      t.integer :product_id, :promotion_rule_id
    end
    remove_column :products_promotion_rules, :id
    add_index :products_promotion_rules, :product_id
    add_index :products_promotion_rules, :promotion_rule_id
  end

  def down
    drop_table :promotion_rules
    drop_table :products_promotion_rules
  end
end

Version data entries

28 entries across 28 versions & 1 rubygems

Version	Path
spree_promo-1.2.5	db/migrate/20100426100726_create_promotion_rules.rb
spree_promo-1.1.6	db/migrate/20100426100726_create_promotion_rules.rb
spree_promo-1.1.5	db/migrate/20100426100726_create_promotion_rules.rb
spree_promo-1.2.4	db/migrate/20100426100726_create_promotion_rules.rb
spree_promo-1.0.7	db/migrate/20100426100726_create_promotion_rules.rb
spree_promo-1.2.3	db/migrate/20100426100726_create_promotion_rules.rb
spree_promo-1.2.2	db/migrate/20100426100726_create_promotion_rules.rb
spree_promo-1.1.4	db/migrate/20100426100726_create_promotion_rules.rb
spree_promo-1.2.0	db/migrate/20100426100726_create_promotion_rules.rb
spree_promo-1.2.0.rc2	db/migrate/20100426100726_create_promotion_rules.rb
spree_promo-1.2.0.rc1	db/migrate/20100426100726_create_promotion_rules.rb
spree_promo-1.1.3	db/migrate/20100426100726_create_promotion_rules.rb
spree_promo-1.0.6	db/migrate/20100426100726_create_promotion_rules.rb
spree_promo-1.1.2	db/migrate/20100426100726_create_promotion_rules.rb
spree_promo-1.1.2.rc1	db/migrate/20100426100726_create_promotion_rules.rb
spree_promo-1.1.1	db/migrate/20100426100726_create_promotion_rules.rb
spree_promo-1.1.0	db/migrate/20100426100726_create_promotion_rules.rb
spree_promo-1.0.4	db/migrate/20100426100726_create_promotion_rules.rb
spree_promo-1.1.0.rc2	db/migrate/20100426100726_create_promotion_rules.rb
spree_promo-1.1.0.rc1	db/migrate/20100426100726_create_promotion_rules.rb