Skip to content

Instantly share code, notes, and snippets.

@dnordstrom
Created December 30, 2011 15:47
Show Gist options
  • Save dnordstrom/1540360 to your computer and use it in GitHub Desktop.
Save dnordstrom/1540360 to your computer and use it in GitHub Desktop.
# encoding: UTF-8
# This file is auto-generated from the current state of the database. Instead
# of editing this file, please use the migrations feature of Active Record to
# incrementally modify your database, and then regenerate this schema definition.
#
# Note that this schema.rb definition is the authoritative source for your
# database schema. If you need to create the application database on another
# system, you should be using db:schema:load, not running 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 => 20111230021238) do
create_table "skrill_accounts", :force => true do |t|
t.string "email"
t.datetime "created_at"
t.datetime "updated_at"
end
create_table "spree_activators", :force => true do |t|
t.string "description"
t.datetime "expires_at"
t.datetime "created_at"
t.datetime "updated_at"
t.datetime "starts_at"
t.string "name"
t.string "event_name"
t.string "type"
end
create_table "spree_addresses", :force => true do |t|
t.string "firstname"
t.string "lastname"
t.string "address1"
t.string "address2"
t.string "city"
t.string "zipcode"
t.string "phone"
t.string "state_name"
t.string "alternative_phone"
t.integer "state_id"
t.integer "country_id"
t.datetime "created_at"
t.datetime "updated_at"
t.string "company"
end
add_index "spree_addresses", ["firstname"], :name => "index_addresses_on_firstname"
add_index "spree_addresses", ["lastname"], :name => "index_addresses_on_lastname"
create_table "spree_adjustments", :force => true do |t|
t.integer "source_id"
t.decimal "amount", :precision => 8, :scale => 2
t.string "label"
t.string "source_type"
t.integer "adjustable_id"
t.datetime "created_at"
t.datetime "updated_at"
t.boolean "mandatory"
t.boolean "locked"
t.integer "originator_id"
t.string "originator_type"
t.boolean "eligible", :default => true
t.string "adjustable_type"
end
add_index "spree_adjustments", ["adjustable_id"], :name => "index_adjustments_on_order_id"
create_table "spree_assets", :force => true do |t|
t.integer "viewable_id"
t.integer "attachment_width"
t.integer "attachment_height"
t.integer "attachment_size"
t.integer "position"
t.string "viewable_type", :limit => 50
t.string "attachment_content_type"
t.string "attachment_file_name"
t.string "type", :limit => 75
t.datetime "attachment_updated_at"
t.text "alt"
end
add_index "spree_assets", ["viewable_id"], :name => "index_assets_on_viewable_id"
add_index "spree_assets", ["viewable_type", "type"], :name => "index_assets_on_viewable_type_and_type"
create_table "spree_calculators", :force => true do |t|
t.string "type"
t.integer "calculable_id", :null => false
t.string "calculable_type", :null => false
t.datetime "created_at"
t.datetime "updated_at"
end
create_table "spree_configurations", :force => true do |t|
t.string "name"
t.string "type", :limit => 50
t.datetime "created_at"
t.datetime "updated_at"
end
add_index "spree_configurations", ["name", "type"], :name => "index_configurations_on_name_and_type"
create_table "spree_countries", :force => true do |t|
t.string "iso_name"
t.string "iso"
t.string "iso3"
t.string "name"
t.integer "numcode"
end
create_table "spree_creditcards", :force => true do |t|
t.string "month"
t.string "year"
t.string "cc_type"
t.string "last_digits"
t.string "first_name"
t.string "last_name"
t.string "start_month"
t.string "start_year"
t.string "issue_number"
t.integer "address_id"
t.datetime "created_at"
t.datetime "updated_at"
t.string "gateway_customer_profile_id"
t.string "gateway_payment_profile_id"
end
create_table "spree_gateways", :force => true do |t|
t.string "type"
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.datetime "created_at"
t.datetime "updated_at"
end
create_table "spree_inventory_units", :force => true do |t|
t.integer "lock_version", :default => 0
t.string "state"
t.integer "variant_id"
t.integer "order_id"
t.datetime "created_at"
t.datetime "updated_at"
t.integer "shipment_id"
t.integer "return_authorization_id"
end
add_index "spree_inventory_units", ["order_id"], :name => "index_inventory_units_on_order_id"
add_index "spree_inventory_units", ["shipment_id"], :name => "index_inventory_units_on_shipment_id"
add_index "spree_inventory_units", ["variant_id"], :name => "index_inventory_units_on_variant_id"
create_table "spree_line_items", :force => true do |t|
t.integer "order_id"
t.integer "variant_id"
t.integer "quantity", :null => false
t.decimal "price", :precision => 8, :scale => 2, :null => false
t.datetime "created_at"
t.datetime "updated_at"
end
add_index "spree_line_items", ["order_id"], :name => "index_line_items_on_order_id"
add_index "spree_line_items", ["variant_id"], :name => "index_line_items_on_variant_id"
create_table "spree_log_entries", :force => true do |t|
t.integer "source_id"
t.string "source_type"
t.text "details"
t.datetime "created_at"
t.datetime "updated_at"
end
create_table "spree_mail_methods", :force => true do |t|
t.string "environment"
t.boolean "active", :default => true
t.datetime "created_at"
t.datetime "updated_at"
end
create_table "spree_option_types", :force => true do |t|
t.string "name", :limit => 100
t.string "presentation", :limit => 100
t.datetime "created_at"
t.datetime "updated_at"
t.integer "position", :default => 0, :null => false
end
create_table "spree_option_types_prototypes", :id => false, :force => true do |t|
t.integer "prototype_id"
t.integer "option_type_id"
end
create_table "spree_option_values", :force => true do |t|
t.integer "position"
t.string "name"
t.string "presentation"
t.integer "option_type_id"
t.datetime "created_at"
t.datetime "updated_at"
end
create_table "spree_option_values_variants", :id => false, :force => true do |t|
t.integer "variant_id"
t.integer "option_value_id"
end
add_index "spree_option_values_variants", ["variant_id", "option_value_id"], :name => "index_option_values_variants_on_variant_id_and_option_value_id"
add_index "spree_option_values_variants", ["variant_id"], :name => "index_option_values_variants_on_variant_id"
create_table "spree_orders", :force => true do |t|
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.string "state"
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
t.integer "user_id"
t.datetime "created_at"
t.datetime "updated_at"
t.datetime "completed_at"
t.integer "bill_address_id"
t.integer "ship_address_id"
t.decimal "payment_total", :precision => 8, :scale => 2, :default => 0.0
t.integer "shipping_method_id"
t.string "shipment_state"
t.string "payment_state"
t.string "email"
t.text "special_instructions"
end
add_index "spree_orders", ["number"], :name => "index_orders_on_number"
create_table "spree_payment_methods", :force => true do |t|
t.string "type"
t.string "name"
t.text "description"
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_on"
end
create_table "spree_payments", :force => true do |t|
t.decimal "amount", :precision => 8, :scale => 2, :default => 0.0, :null => false
t.integer "order_id"
t.datetime "created_at"
t.datetime "updated_at"
t.integer "source_id"
t.string "source_type"
t.integer "payment_method_id"
t.string "state"
t.string "response_code"
t.string "avs_response"
end
create_table "spree_preferences", :force => true do |t|
t.text "value"
t.datetime "created_at"
t.datetime "updated_at"
t.string "key"
t.string "value_type"
end
add_index "spree_preferences", ["key"], :name => "index_spree_preferences_on_key", :unique => true
create_table "spree_product_groups", :force => true do |t|
t.string "name"
t.string "permalink"
t.string "order"
end
add_index "spree_product_groups", ["name"], :name => "index_product_groups_on_name"
add_index "spree_product_groups", ["permalink"], :name => "index_product_groups_on_permalink"
create_table "spree_product_groups_products", :id => false, :force => true do |t|
t.integer "product_id"
t.integer "product_group_id"
end
create_table "spree_product_option_types", :force => true do |t|
t.integer "position"
t.integer "product_id"
t.integer "option_type_id"
t.datetime "created_at"
t.datetime "updated_at"
end
create_table "spree_product_properties", :force => true do |t|
t.string "value"
t.integer "product_id"
t.integer "property_id"
t.datetime "created_at"
t.datetime "updated_at"
end
add_index "spree_product_properties", ["product_id"], :name => "index_product_properties_on_product_id"
create_table "spree_product_scopes", :force => true do |t|
t.string "name"
t.text "arguments"
t.integer "product_group_id"
end
add_index "spree_product_scopes", ["name"], :name => "index_product_scopes_on_name"
add_index "spree_product_scopes", ["product_group_id"], :name => "index_product_scopes_on_product_group_id"
create_table "spree_products", :force => true do |t|
t.string "name", :default => "", :null => false
t.text "description"
t.datetime "available_on"
t.datetime "deleted_at"
t.string "permalink"
t.string "meta_description"
t.string "meta_keywords"
t.integer "tax_category_id"
t.integer "shipping_category_id"
t.datetime "created_at"
t.datetime "updated_at"
t.integer "count_on_hand", :default => 0, :null => false
end
add_index "spree_products", ["available_on"], :name => "index_products_on_available_on"
add_index "spree_products", ["deleted_at"], :name => "index_products_on_deleted_at"
add_index "spree_products", ["name"], :name => "index_products_on_name"
add_index "spree_products", ["permalink"], :name => "index_products_on_permalink"
create_table "spree_products_promotion_rules", :id => false, :force => true do |t|
t.integer "product_id"
t.integer "promotion_rule_id"
end
add_index "spree_products_promotion_rules", ["product_id"], :name => "index_products_promotion_rules_on_product_id"
add_index "spree_products_promotion_rules", ["promotion_rule_id"], :name => "index_products_promotion_rules_on_promotion_rule_id"
create_table "spree_products_taxons", :id => false, :force => true do |t|
t.integer "product_id"
t.integer "taxon_id"
end
add_index "spree_products_taxons", ["product_id"], :name => "index_products_taxons_on_product_id"
add_index "spree_products_taxons", ["taxon_id"], :name => "index_products_taxons_on_taxon_id"
create_table "spree_promotion_action_line_items", :force => true do |t|
t.integer "promotion_action_id"
t.integer "variant_id"
t.integer "quantity", :default => 1
end
create_table "spree_promotion_actions", :force => true do |t|
t.integer "activator_id"
t.integer "position"
t.string "type"
end
create_table "spree_promotion_rules", :force => true do |t|
t.integer "activator_id"
t.integer "user_id"
t.integer "product_group_id"
t.string "type"
t.datetime "created_at"
t.datetime "updated_at"
end
add_index "spree_promotion_rules", ["product_group_id"], :name => "index_promotion_rules_on_product_group_id"
add_index "spree_promotion_rules", ["user_id"], :name => "index_promotion_rules_on_user_id"
create_table "spree_promotion_rules_users", :id => false, :force => true do |t|
t.integer "user_id"
t.integer "promotion_rule_id"
end
add_index "spree_promotion_rules_users", ["promotion_rule_id"], :name => "index_promotion_rules_users_on_promotion_rule_id"
add_index "spree_promotion_rules_users", ["user_id"], :name => "index_promotion_rules_users_on_user_id"
create_table "spree_properties", :force => true do |t|
t.string "name"
t.string "presentation", :null => false
t.datetime "created_at"
t.datetime "updated_at"
end
create_table "spree_properties_prototypes", :id => false, :force => true do |t|
t.integer "prototype_id"
t.integer "property_id"
end
create_table "spree_prototypes", :force => true do |t|
t.string "name"
t.datetime "created_at"
t.datetime "updated_at"
end
create_table "spree_return_authorizations", :force => true do |t|
t.string "number"
t.string "state"
t.decimal "amount", :precision => 8, :scale => 2, :default => 0.0, :null => false
t.integer "order_id"
t.text "reason"
t.datetime "created_at"
t.datetime "updated_at"
end
create_table "spree_roles", :force => true do |t|
t.string "name"
end
create_table "spree_roles_users", :id => false, :force => true do |t|
t.integer "role_id"
t.integer "user_id"
end
add_index "spree_roles_users", ["role_id"], :name => "index_roles_users_on_role_id"
add_index "spree_roles_users", ["user_id"], :name => "index_roles_users_on_user_id"
create_table "spree_shipments", :force => true do |t|
t.string "tracking"
t.string "number"
t.decimal "cost", :precision => 8, :scale => 2
t.datetime "shipped_at"
t.integer "order_id"
t.integer "shipping_method_id"
t.integer "address_id"
t.datetime "created_at"
t.datetime "updated_at"
t.string "state"
end
add_index "spree_shipments", ["number"], :name => "index_shipments_on_number"
create_table "spree_shipping_categories", :force => true do |t|
t.string "name"
t.datetime "created_at"
t.datetime "updated_at"
end
create_table "spree_shipping_methods", :force => true do |t|
t.string "name"
t.integer "zone_id"
t.datetime "created_at"
t.datetime "updated_at"
t.string "display_on"
end
create_table "spree_state_events", :force => true do |t|
t.string "name"
t.string "previous_state"
t.integer "stateful_id"
t.integer "user_id"
t.datetime "created_at"
t.datetime "updated_at"
t.string "stateful_type"
t.string "next_state"
end
create_table "spree_states", :force => true do |t|
t.string "name"
t.string "abbr"
t.integer "country_id"
end
create_table "spree_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 "spree_tax_rates", :force => true do |t|
t.decimal "amount", :precision => 8, :scale => 4
t.integer "zone_id"
t.integer "tax_category_id"
t.datetime "created_at"
t.datetime "updated_at"
t.boolean "included_in_price", :default => false
end
create_table "spree_taxonomies", :force => true do |t|
t.string "name", :null => false
t.datetime "created_at"
t.datetime "updated_at"
end
create_table "spree_taxons", :force => true do |t|
t.integer "parent_id"
t.integer "position", :default => 0
t.string "name", :null => false
t.string "permalink"
t.integer "taxonomy_id"
t.datetime "created_at"
t.datetime "updated_at"
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 "spree_taxons", ["parent_id"], :name => "index_taxons_on_parent_id"
add_index "spree_taxons", ["permalink"], :name => "index_taxons_on_permalink"
add_index "spree_taxons", ["taxonomy_id"], :name => "index_taxons_on_taxonomy_id"
create_table "spree_tokenized_permissions", :force => true do |t|
t.integer "permissable_id"
t.string "permissable_type"
t.string "token"
t.datetime "created_at"
t.datetime "updated_at"
end
add_index "spree_tokenized_permissions", ["permissable_id", "permissable_type"], :name => "index_tokenized_name_and_type"
create_table "spree_trackers", :force => true do |t|
t.string "environment"
t.string "analytics_id"
t.boolean "active", :default => true
t.datetime "created_at"
t.datetime "updated_at"
end
create_table "spree_users", :force => true do |t|
t.string "encrypted_password"
t.string "password_salt"
t.string "email"
t.string "remember_token"
t.string "persistence_token"
t.string "reset_password_token"
t.string "perishable_token"
t.integer "sign_in_count", :default => 0, :null => false
t.integer "failed_attempts", :default => 0, :null => false
t.datetime "last_request_at"
t.datetime "current_sign_in_at"
t.datetime "last_sign_in_at"
t.string "current_sign_in_ip"
t.string "last_sign_in_ip"
t.string "login"
t.integer "ship_address_id"
t.integer "bill_address_id"
t.datetime "created_at"
t.datetime "updated_at"
t.string "authentication_token"
t.string "unlock_token"
t.datetime "locked_at"
t.datetime "remember_created_at"
t.string "api_key", :limit => 40
end
add_index "spree_users", ["persistence_token"], :name => "index_users_on_persistence_token"
create_table "spree_variants", :force => true do |t|
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
t.integer "product_id"
t.integer "count_on_hand", :default => 0, :null => false
t.decimal "cost_price", :precision => 8, :scale => 2
t.integer "position"
end
add_index "spree_variants", ["product_id"], :name => "index_variants_on_product_id"
create_table "spree_zone_members", :force => true do |t|
t.integer "zoneable_id"
t.string "zoneable_type"
t.integer "zone_id"
t.datetime "created_at"
t.datetime "updated_at"
end
create_table "spree_zones", :force => true do |t|
t.string "name"
t.string "description"
t.datetime "created_at"
t.datetime "updated_at"
t.boolean "default_tax", :default => false
end
end
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment