db/schema.rb in spree-0.8.5 vs db/schema.rb in spree-0.9.0
- old
+ new
@@ -7,11 +7,11 @@
# all the migrations 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 to check this file into your version control system.
-ActiveRecord::Schema.define(:version => 20090427000000) do
+ActiveRecord::Schema.define(:version => 20090908141056) do
create_table "addresses", :force => true do |t|
t.string "firstname"
t.string "lastname"
t.string "address1"
@@ -22,23 +22,58 @@
t.integer "country_id"
t.string "phone"
t.datetime "created_at"
t.datetime "updated_at"
t.string "state_name"
+ t.string "alternative_phone"
end
+ create_table "adjustments", :force => true do |t|
+ t.integer "order_id"
+ t.string "type"
+ t.decimal "amount", :precision => 8, :scale => 2, :default => 0.0, :null => false
+ t.string "description"
+ t.integer "position"
+ t.datetime "created_at"
+ t.datetime "updated_at"
+ t.integer "adjustment_source_id"
+ t.string "adjustment_source_type"
+ t.string "secondary_type"
+ end
+
create_table "assets", :force => true do |t|
t.integer "viewable_id"
t.string "viewable_type"
t.string "attachment_content_type"
t.string "attachment_file_name"
t.integer "attachment_size"
t.integer "position"
t.string "type"
t.datetime "attachment_updated_at"
+ t.integer "attachment_width"
+ t.integer "attachment_height"
end
+ create_table "calculators", :force => true do |t|
+ t.string "type"
+ t.integer "calculable_id", :null => false
+ t.string "calculable_type", :default => "", :null => false
+ t.datetime "created_at"
+ t.datetime "updated_at"
+ end
+
+ create_table "checkouts", :force => true do |t|
+ t.integer "order_id"
+ t.string "email"
+ t.string "ip_address"
+ t.text "special_instructions"
+ t.integer "bill_address_id"
+ t.datetime "completed_at"
+ t.datetime "created_at"
+ t.datetime "updated_at"
+ end
+
create_table "configurations", :force => true do |t|
t.string "name"
t.datetime "created_at"
t.datetime "updated_at"
t.string "type"
@@ -52,38 +87,50 @@
t.string "name"
t.string "iso3"
t.integer "numcode"
end
+ create_table "coupons", :force => true do |t|
+ t.string "code"
+ t.string "description"
+ t.integer "usage_limit"
+ t.boolean "combine"
+ t.datetime "expires_at"
+ t.datetime "created_at"
+ t.datetime "updated_at"
+ t.datetime "starts_at"
+ end
+
create_table "creditcard_txns", :force => true do |t|
t.integer "creditcard_payment_id"
t.decimal "amount", :precision => 8, :scale => 2, :default => 0.0, :null => false
- t.string "txn_type"
+ t.integer "txn_type"
t.string "response_code"
t.text "avs_response"
t.text "cvv_response"
t.datetime "created_at"
t.datetime "updated_at"
end
create_table "creditcards", :force => true do |t|
- t.integer "order_id"
t.text "number"
t.string "month"
t.string "year"
t.text "verification_value"
t.string "cc_type"
t.string "display_number"
t.string "first_name"
t.string "last_name"
t.datetime "created_at"
t.datetime "updated_at"
+ t.string "start_month"
+ t.string "start_year"
+ t.string "issue_number"
t.integer "address_id"
+ t.integer "checkout_id"
end
- add_index "creditcards", ["order_id"], :name => "index_creditcards_on_order_id"
-
create_table "gateway_configurations", :force => true do |t|
t.integer "gateway_id"
t.datetime "created_at"
t.datetime "updated_at"
end
@@ -163,28 +210,21 @@
add_index "option_values_variants", ["variant_id"], :name => "index_option_values_variants_on_variant_id"
create_table "orders", :force => true do |t|
t.integer "user_id"
- t.string "number", :limit => 15
- t.decimal "ship_amount", :precision => 8, :scale => 2, :default => 0.0, :null => false
- t.decimal "tax_amount", :precision => 8, :scale => 2, :default => 0.0, :null => false
- t.decimal "item_total", :precision => 8, :scale => 2, :default => 0.0, :null => false
- t.decimal "total", :precision => 8, :scale => 2, :default => 0.0, :null => false
- t.string "ip_address"
- t.text "special_instructions"
+ t.string "number", :limit => 15
+ t.decimal "item_total", :precision => 8, :scale => 2, :default => 0.0, :null => false
+ t.decimal "total", :precision => 8, :scale => 2, :default => 0.0, :null => false
t.datetime "created_at"
t.datetime "updated_at"
t.string "state"
- t.boolean "checkout_complete"
t.string "token"
- t.string "email"
- t.integer "bill_address_id"
- t.integer "ship_address_id"
+ t.decimal "adjustment_total", :precision => 8, :scale => 2, :default => 0.0, :null => false
+ t.decimal "credit_total", :precision => 8, :scale => 2, :default => 0.0, :null => false
end
- add_index "orders", ["checkout_complete"], :name => "index_orders_on_checkout_complete"
add_index "orders", ["number"], :name => "index_orders_on_number"
create_table "payments", :force => true do |t|
t.integer "order_id"
t.datetime "created_at"
@@ -222,13 +262,12 @@
t.datetime "created_at"
t.datetime "updated_at"
end
create_table "products", :force => true do |t|
- t.string "name", :default => "", :null => false
+ t.string "name", :default => "", :null => false
t.text "description"
- t.decimal "master_price", :precision => 8, :scale => 2
t.datetime "created_at"
t.datetime "updated_at"
t.string "permalink"
t.datetime "available_on"
t.integer "tax_category_id"
@@ -267,10 +306,15 @@
t.string "name"
t.datetime "created_at"
t.datetime "updated_at"
end
+ create_table "queued_mails", :force => true do |t|
+ t.text "object"
+ t.string "mailer"
+ end
+
create_table "roles", :force => true do |t|
t.string "name"
end
create_table "roles_users", :id => false, :force => true do |t|
@@ -299,16 +343,20 @@
t.datetime "updated_at"
end
create_table "shipping_methods", :force => true do |t|
t.integer "zone_id"
- t.string "shipping_calculator"
t.string "name"
t.datetime "created_at"
t.datetime "updated_at"
end
+ create_table "shipping_rates", :force => true do |t|
+ t.integer "shipping_category_id"
+ t.integer "shipping_method_id"
+ end
+
create_table "state_events", :force => true do |t|
t.integer "order_id"
t.integer "user_id"
t.string "name"
t.datetime "created_at"
@@ -332,11 +380,10 @@
create_table "tax_rates", :force => true do |t|
t.integer "zone_id"
t.decimal "amount", :precision => 8, :scale => 4
t.datetime "created_at"
t.datetime "updated_at"
- t.integer "tax_type"
t.integer "tax_category_id"
end
create_table "taxonomies", :force => true do |t|
t.string "name", :default => "", :null => false
@@ -371,20 +418,23 @@
t.datetime "current_login_at"
t.datetime "last_login_at"
t.string "current_login_ip"
t.string "last_login_ip"
t.string "login"
+ t.integer "ship_address_id"
+ t.integer "bill_address_id"
end
create_table "variants", :force => true do |t|
t.integer "product_id"
- t.string "sku", :default => "", :null => false
- t.decimal "price", :precision => 8, :scale => 2, :null => false
+ t.string "sku", :default => "", :null => false
+ t.decimal "price", :precision => 8, :scale => 2, :null => false
t.decimal "weight", :precision => 8, :scale => 2
t.decimal "height", :precision => 8, :scale => 2
t.decimal "width", :precision => 8, :scale => 2
t.decimal "depth", :precision => 8, :scale => 2
t.datetime "deleted_at"
+ t.boolean "is_master", :default => false
end
add_index "variants", ["product_id"], :name => "index_variants_on_product_id"
create_table "zone_members", :force => true do |t|