test/dummy/db/schema.rb in shoppe-0.0.7 vs test/dummy/db/schema.rb in shoppe-0.0.8
- old
+ new
@@ -9,21 +9,22 @@
# from scratch. The latter is a flawed and unsustainable approach (the more migrations
# you'll amass, the slower it'll run and the greater likelihood for issues).
#
# It's strongly recommended that you check this file into your version control system.
-ActiveRecord::Schema.define(version: 20131006144849) do
+ActiveRecord::Schema.define(version: 20131013131658) do
create_table "shoppe_delivery_service_prices", force: true do |t|
t.integer "delivery_service_id"
t.string "code"
t.decimal "price", precision: 8, scale: 2
t.decimal "tax_rate", precision: 8, scale: 2
t.decimal "min_weight", precision: 8, scale: 2
t.decimal "max_weight", precision: 8, scale: 2
t.datetime "created_at"
t.datetime "updated_at"
+ t.decimal "cost_price", precision: 8, scale: 2
end
create_table "shoppe_delivery_services", force: true do |t|
t.string "name"
t.string "code"
@@ -36,17 +37,18 @@
end
create_table "shoppe_order_items", force: true do |t|
t.integer "order_id"
t.integer "product_id"
- t.integer "quantity", default: 1
- t.decimal "unit_price", precision: 8, scale: 2
- t.decimal "tax_amount", precision: 8, scale: 2
- t.decimal "tax_rate", precision: 8, scale: 2
- t.decimal "weight", precision: 8, scale: 3, default: 0.0
+ t.integer "quantity", default: 1
+ t.decimal "unit_price", precision: 8, scale: 2
+ t.decimal "tax_amount", precision: 8, scale: 2
+ t.decimal "tax_rate", precision: 8, scale: 2
+ t.decimal "weight", precision: 8, scale: 3, default: 0.0
t.datetime "created_at"
t.datetime "updated_at"
+ t.decimal "unit_cost_price", precision: 8, scale: 2
end
create_table "shoppe_orders", force: true do |t|
t.string "token"
t.string "first_name"
@@ -77,12 +79,24 @@
t.integer "rejected_by"
t.string "ip_address"
t.string "country"
t.string "payment_reference"
t.string "payment_method"
+ t.decimal "delivery_cost_price", precision: 8, scale: 2
end
+ create_table "shoppe_product_attributes", force: true do |t|
+ t.integer "product_id"
+ t.string "key"
+ t.string "value"
+ t.integer "position", default: 1
+ t.boolean "searchable", default: true
+ t.datetime "created_at"
+ t.datetime "updated_at"
+ t.boolean "public", default: true
+ end
+
create_table "shoppe_product_categories", force: true do |t|
t.string "name"
t.string "permalink"
t.text "description"
t.datetime "created_at"
@@ -103,9 +117,11 @@
t.integer "stock", default: 0
t.datetime "created_at"
t.datetime "updated_at"
t.boolean "featured", default: false
t.text "in_the_box"
+ t.decimal "cost_price", precision: 8, scale: 2
+ t.boolean "stock_control", default: true
end
create_table "shoppe_users", force: true do |t|
t.string "first_name"
t.string "last_name"