Class: CreateMerchantSidekickShoppingCartTables

Inherits:
ActiveRecord::Migration
  • Object
show all
Defined in:
lib/merchant_sidekick/migrations/shopping_cart.rb

Class Method Summary collapse

Class Method Details

.down ⇒ Object 



25
26
27
 
# File 'lib/merchant_sidekick/migrations/shopping_cart.rb', line 25

def self.down
  drop_table :cart_line_items
end

.up ⇒ Object 



2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
 
# File 'lib/merchant_sidekick/migrations/shopping_cart.rb', line 2

def self.up
  create_table :cart_line_items do |t|
    t.string   "item_number"
    t.string   "name"
    t.string   "description"
    t.integer  "quantity",                  :default => 1,       :null => false
    t.string   "unit",                      :default => "piece", :null => false
    t.integer  "pieces",                    :default => 0,       :null => false
    t.integer  "cents",                     :default => 0,       :null => false
    t.string   "currency",     :limit => 3, :default => "USD",   :null => false
    t.boolean  "taxable",                   :default => false,   :null => false
    t.integer  "product_id",                                     :null => false
    t.string   "product_type",                                   :null => false
    t.timestamps
  end
  add_index :cart_line_items, "item_number"
  add_index :cart_line_items, "name"
  add_index :cart_line_items, "unit"
  add_index :cart_line_items, "pieces"
  add_index :cart_line_items, ["product_id", "product_type"]
  add_index :cart_line_items, "quantity"
end