Created
December 30, 2011 15:47
-
-
Save dnordstrom/1540360 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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