Contents

class CreateEffectiveClassifieds < ActiveRecord::Migration[6.0]
  def change
    create_table :classifieds do |t|
      t.integer :classified_wizard_id
      t.string :classified_wizard_type

      t.integer :owner_id
      t.string :owner_type

      t.string :title
      t.string :category

      t.string :organization
      t.string :location

      t.string :website
      t.string :contact_name
      t.string :email
      t.string :phone

      t.datetime :start_on
      t.datetime :end_on

      t.string :slug

      t.string :status
      t.text :status_steps

      t.integer :roles_mask
      t.boolean :authenticate_user, default: false

      t.boolean :archived, default: false

      # Acts as purchasable
      t.integer :purchased_order_id
      t.integer :price
      t.boolean :tax_exempt, default: false
      t.string :qb_item_name

      t.timestamps
    end

    add_index :classifieds, [:owner_id, :owner_type]
    add_index :classifieds, :slug

    create_table :classified_wizards do |t|
      t.string :token

      t.integer :owner_id
      t.string :owner_type

      # Acts as Statused
      t.string :status
      t.text :status_steps

      # Acts as Wizard
      t.text :wizard_steps

      # Dates
      t.datetime :submitted_at

      # Pricing
      t.string :price_category

      t.datetime :updated_at
      t.datetime :created_at
    end

    add_index :classified_wizards, [:owner_id, :owner_type]
    add_index :classified_wizards, :token
  end
end

Version data entries

7 entries across 7 versions & 1 rubygems

Version	Path
effective_classifieds-0.6.7	db/migrate/101_create_effective_classifieds.rb
effective_classifieds-0.6.6	db/migrate/101_create_effective_classifieds.rb
effective_classifieds-0.6.5	db/migrate/101_create_effective_classifieds.rb
effective_classifieds-0.6.4	db/migrate/101_create_effective_classifieds.rb
effective_classifieds-0.6.3	db/migrate/101_create_effective_classifieds.rb
effective_classifieds-0.6.2	db/migrate/101_create_effective_classifieds.rb
effective_classifieds-0.6.1	db/migrate/101_create_effective_classifieds.rb