Contents

class AddRuleTables < ActiveRecord::Migration[7.0]
  def change
    create_table :friendly_products_promotion_rules, force: :cascade do |t|
      t.references :product, type: :integer, index: true, null: false, foreign_key: {to_table: :spree_products}
      t.references :promotion_rule, index: true, null: false, foreign_key: {to_table: :friendly_promotion_rules}

      t.timestamps
    end

    create_table :friendly_promotion_rules_taxons, force: :cascade do |t|
      t.references :taxon, type: :integer, index: true, null: false, foreign_key: {to_table: :spree_taxons}
      t.references :promotion_rule, index: true, null: false, foreign_key: {to_table: :friendly_promotion_rules}

      t.timestamps
    end

    create_table :friendly_promotion_rules_users, force: :cascade do |t|
      t.references :user, type: :integer, index: true, null: false, foreign_key: {to_table: Spree.user_class.table_name}
      t.references :promotion_rule, index: true, null: false, foreign_key: {to_table: :friendly_promotion_rules}

      t.timestamps
    end

    create_table :friendly_promotion_rules_stores do |t|
      t.references :store, type: :integer, index: true, null: false, foreign_key: {to_table: :spree_stores}
      t.references :promotion_rule, index: true, null: false

      t.timestamps
    end
  end
end

Version data entries

9 entries across 9 versions & 1 rubygems

Version	Path
solidus_friendly_promotions-1.9.3	db/migrate/20230704083830_add_rule_tables.rb
solidus_friendly_promotions-1.9.2	db/migrate/20230704083830_add_rule_tables.rb
solidus_friendly_promotions-1.9.1	db/migrate/20230704083830_add_rule_tables.rb
solidus_friendly_promotions-1.9.0	db/migrate/20230704083830_add_rule_tables.rb
solidus_friendly_promotions-1.0.0	db/migrate/20230704083830_add_rule_tables.rb
solidus_friendly_promotions-1.0.0.rc.3	db/migrate/20230704083830_add_rule_tables.rb
solidus_friendly_promotions-1.0.0.rc.2	db/migrate/20230704083830_add_rule_tables.rb
solidus_friendly_promotions-1.0.0.rc.1	db/migrate/20230704083830_add_rule_tables.rb
solidus_friendly_promotions-1.0.0.pre	db/migrate/20230704083830_add_rule_tables.rb