db/schema.rb in spree-0.10.2 vs db/schema.rb in spree-0.11.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 => 20100317120946) do
+ActiveRecord::Schema.define(:version => 20100605152042) do
create_table "addresses", :force => true do |t|
t.string "firstname"
t.string "lastname"
t.string "address1"
@@ -25,14 +25,17 @@
t.datetime "updated_at"
t.string "state_name"
t.string "alternative_phone"
end
+ add_index "addresses", ["firstname"], :name => "index_addresses_on_firstname"
+ add_index "addresses", ["lastname"], :name => "index_addresses_on_lastname"
+
create_table "adjustments", :force => true do |t|
t.integer "order_id"
t.string "type"
- t.decimal "amount", :precision => 8, :scale => 2
+ t.decimal "amount"
t.string "description"
t.integer "position"
t.datetime "created_at"
t.datetime "updated_at"
t.integer "adjustment_source_id"
@@ -77,10 +80,13 @@
t.string "state"
t.integer "ship_address_id"
t.integer "shipping_method_id"
end
+ add_index "checkouts", ["bill_address_id"], :name => "index_checkouts_on_bill_address_id"
+ add_index "checkouts", ["order_id"], :name => "index_checkouts_on_order_id"
+
create_table "configurations", :force => true do |t|
t.string "name"
t.datetime "created_at"
t.datetime "updated_at"
t.string "type", :limit => 50
@@ -124,18 +130,38 @@
t.integer "address_id"
t.string "gateway_customer_profile_id"
t.string "gateway_payment_profile_id"
end
+ create_table "gateway_configurations", :force => true do |t|
+ t.integer "gateway_id"
+ t.datetime "created_at"
+ t.datetime "updated_at"
+ end
+
+ create_table "gateway_option_values", :force => true do |t|
+ t.integer "gateway_configuration_id"
+ t.integer "gateway_option_id"
+ t.text "value"
+ t.datetime "created_at"
+ t.datetime "updated_at"
+ end
+
+ create_table "gateway_options", :force => true do |t|
+ t.string "name"
+ t.text "description"
+ t.integer "gateway_id"
+ t.boolean "textarea", :default => false
+ t.datetime "created_at"
+ t.datetime "updated_at"
+ end
+
create_table "gateways", :force => true do |t|
- t.string "type"
+ t.string "clazz"
t.string "name"
t.text "description"
- t.boolean "active", :default => true
- t.string "environment", :default => "development"
- t.string "server", :default => "test"
- t.boolean "test_mode", :default => true
+ t.boolean "active"
t.datetime "created_at"
t.datetime "updated_at"
end
create_table "inventory_units", :force => true do |t|
@@ -232,36 +258,35 @@
t.boolean "active", :default => true
t.string "environment", :default => "development"
t.datetime "created_at"
t.datetime "updated_at"
t.datetime "deleted_at"
+ t.string "display"
end
create_table "payments", :force => true do |t|
t.integer "payable_id"
t.datetime "created_at"
t.datetime "updated_at"
- t.decimal "amount", :precision => 8, :scale => 2, :default => 0.0, :null => false
+ t.decimal "amount", :default => 0.0, :null => false
t.string "payable_type"
t.integer "source_id"
t.string "source_type"
t.integer "payment_method_id"
end
create_table "preferences", :force => true do |t|
t.string "attribute", :limit => 100, :null => false
- t.integer "owner_id", :null => false
+ t.integer "owner_id", :limit => 30, :null => false
t.string "owner_type", :limit => 50, :null => false
t.integer "group_id"
t.string "group_type", :limit => 50
- t.text "value"
+ t.text "value", :limit => 255
t.datetime "created_at"
t.datetime "updated_at"
end
- add_index "preferences", ["owner_id", "owner_type", "attribute", "group_id", "group_type"], :name => "index_preferences_on_owner_and_attribute_and_preference", :unique => true
-
create_table "product_groups", :force => true do |t|
t.string "name"
t.string "permalink"
t.string "order"
end
@@ -385,10 +410,12 @@
t.datetime "shipped_at"
t.integer "address_id"
t.string "state"
end
+ add_index "shipments", ["number"], :name => "index_shipments_on_number"
+
create_table "shipping_categories", :force => true do |t|
t.string "name"
t.datetime "created_at"
t.datetime "updated_at"
end
@@ -424,10 +451,11 @@
create_table "tax_categories", :force => true do |t|
t.string "name"
t.string "description"
t.datetime "created_at"
t.datetime "updated_at"
+ t.boolean "is_default", :default => false
end
create_table "tax_rates", :force => true do |t|
t.integer "zone_id"
t.decimal "amount", :precision => 8, :scale => 4
@@ -441,19 +469,24 @@
t.datetime "created_at"
t.datetime "updated_at"
end
create_table "taxons", :force => true do |t|
- t.integer "taxonomy_id", :null => false
+ t.integer "taxonomy_id", :null => false
t.integer "parent_id"
- t.integer "position", :default => 0
- t.string "name", :null => false
+ t.integer "position", :default => 0
+ t.string "name", :null => false
t.datetime "created_at"
t.datetime "updated_at"
t.string "permalink"
t.integer "lft"
t.integer "rgt"
+ t.string "icon_file_name"
+ t.string "icon_content_type"
+ t.integer "icon_file_size"
+ t.datetime "icon_updated_at"
+ t.text "description"
end
add_index "taxons", ["parent_id"], :name => "index_taxons_on_parent_id"
add_index "taxons", ["permalink"], :name => "index_taxons_on_permalink"
add_index "taxons", ["taxonomy_id"], :name => "index_taxons_on_taxonomy_id"
@@ -465,11 +498,11 @@
t.datetime "created_at"
t.datetime "updated_at"
end
create_table "transactions", :force => true do |t|
- t.decimal "amount", :precision => 8, :scale => 2, :default => 0.0, :null => false
+ t.decimal "amount", :default => 0.0, :null => false
t.integer "txn_type"
t.string "response_code"
t.text "avs_response"
t.text "cvv_response"
t.datetime "created_at"
@@ -479,33 +512,33 @@
t.string "type"
end
create_table "users", :force => true do |t|
t.string "email"
- t.string "crypted_password"
- t.string "salt"
+ t.string "crypted_password", :limit => 128
+ t.string "salt", :limit => 128
t.string "remember_token"
t.string "remember_token_expires_at"
t.datetime "created_at"
t.datetime "updated_at"
t.string "persistence_token"
t.string "single_access_token"
t.string "perishable_token"
- t.integer "login_count", :default => 0, :null => false
- t.integer "failed_login_count", :default => 0, :null => false
+ t.integer "login_count", :default => 0, :null => false
+ t.integer "failed_login_count", :default => 0, :null => false
t.datetime "last_request_at"
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"
t.string "openid_identifier"
- t.string "api_key", :limit => 40
end
add_index "users", ["openid_identifier"], :name => "index_users_on_openid_identifier"
+ add_index "users", ["persistence_token"], :name => "index_users_on_persistence_token"
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