SQL (0.3ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) select sqlite_version(*) SQL (118.9ms) CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)  SQL (0.1ms) PRAGMA index_list("schema_migrations") SQL (79.7ms) CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version") SQL (0.1ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.2ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) SELECT "schema_migrations"."version" FROM "schema_migrations" Migrating to SpreeZeroNineZero (20090823005402) SQL (0.1ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.3ms) CREATE TABLE "addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "firstname" varchar(255), "lastname" varchar(255), "address1" varchar(255), "address2" varchar(255), "city" varchar(255), "state_id" integer, "zipcode" varchar(255), "country_id" integer, "phone" varchar(255), "created_at" datetime, "updated_at" datetime, "state_name" varchar(255), "alternative_phone" varchar(255)) SQL (0.1ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.2ms) CREATE TABLE "adjustments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "type" varchar(255), "amount" decimal(8,2) DEFAULT 0.0 NOT NULL, "description" varchar(255), "position" integer, "created_at" datetime, "updated_at" datetime, "adjustment_source_id" integer, "adjustment_source_type" varchar(255), "secondary_type" varchar(255)) SQL (0.1ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) CREATE TABLE "assets" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "viewable_id" integer, "viewable_type" varchar(50), "attachment_content_type" varchar(255), "attachment_file_name" varchar(255), "attachment_size" integer, "position" integer, "type" varchar(75), "attachment_updated_at" datetime, "attachment_width" integer, "attachment_height" integer) SQL (0.1ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) CREATE TABLE "calculators" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(255), "calculable_id" integer NOT NULL, "calculable_type" varchar(255) NOT NULL, "created_at" datetime, "updated_at" datetime) SQL (0.1ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) CREATE TABLE "checkouts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "email" varchar(255), "ip_address" varchar(255), "special_instructions" text, "bill_address_id" integer, "completed_at" datetime, "created_at" datetime, "updated_at" datetime) SQL (0.1ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) CREATE TABLE "configurations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime, "updated_at" datetime, "type" varchar(50)) SQL (0.0ms) PRAGMA index_list("configurations") SQL (0.1ms) CREATE INDEX "index_configurations_on_name_and_type" ON "configurations" ("name", "type") SQL (0.1ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) CREATE TABLE "countries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "iso_name" varchar(255), "iso" varchar(255), "name" varchar(255), "iso3" varchar(255), "numcode" integer) SQL (0.2ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) CREATE TABLE "coupons" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "code" varchar(255), "description" varchar(255), "usage_limit" integer, "combine" boolean, "expires_at" datetime, "created_at" datetime, "updated_at" datetime, "starts_at" datetime) SQL (0.1ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) CREATE TABLE "creditcard_txns" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "creditcard_payment_id" integer, "amount" decimal(8,2) DEFAULT 0.0 NOT NULL, "txn_type" integer, "response_code" varchar(255), "avs_response" text, "cvv_response" text, "created_at" datetime, "updated_at" datetime) SQL (0.1ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.2ms) CREATE TABLE "creditcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" text, "month" varchar(255), "year" varchar(255), "verification_value" text, "cc_type" varchar(255), "display_number" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "created_at" datetime, "updated_at" datetime, "start_month" varchar(255), "start_year" varchar(255), "issue_number" varchar(255), "address_id" integer, "checkout_id" integer) SQL (0.1ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) CREATE TABLE "gateway_configurations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "gateway_id" integer, "created_at" datetime, "updated_at" datetime) SQL (0.1ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) CREATE TABLE "gateway_option_values" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "gateway_configuration_id" integer, "gateway_option_id" integer, "value" text, "created_at" datetime, "updated_at" datetime) SQL (0.1ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) CREATE TABLE "gateway_options" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "description" text, "gateway_id" integer, "textarea" boolean DEFAULT 'f', "created_at" datetime, "updated_at" datetime) SQL (0.1ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) CREATE TABLE "gateways" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "clazz" varchar(255), "name" varchar(255), "description" text, "active" boolean, "created_at" datetime, "updated_at" datetime) SQL (0.1ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) CREATE TABLE "inventory_units" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "variant_id" integer, "order_id" integer, "state" varchar(255), "lock_version" integer DEFAULT 0, "created_at" datetime, "updated_at" datetime) SQL (0.1ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) CREATE TABLE "line_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "variant_id" integer, "quantity" integer NOT NULL, "price" decimal(8,2) NOT NULL, "created_at" datetime, "updated_at" datetime) SQL (0.0ms) PRAGMA index_list("line_items") SQL (0.1ms) CREATE INDEX "index_line_items_on_order_id" ON "line_items" ("order_id") SQL (0.0ms) PRAGMA index_list("line_items") SQL (0.0ms) PRAGMA index_info('index_line_items_on_order_id') SQL (0.1ms) CREATE INDEX "index_line_items_on_variant_id" ON "line_items" ("variant_id") SQL (0.2ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.2ms) CREATE TABLE "option_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(100), "presentation" varchar(100), "created_at" datetime, "updated_at" datetime)  SQL (0.5ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.3ms) CREATE TABLE "option_types_prototypes" ("prototype_id" integer, "option_type_id" integer)  SQL (0.2ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms) CREATE TABLE "option_values" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "option_type_id" integer, "name" varchar(255), "position" integer, "presentation" varchar(255), "created_at" datetime, "updated_at" datetime)  SQL (0.2ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms) CREATE TABLE "option_values_variants" ("variant_id" integer, "option_value_id" integer)  SQL (0.0ms) PRAGMA index_list("option_values_variants") SQL (0.1ms) CREATE INDEX "index_option_values_variants_on_variant_id" ON "option_values_variants" ("variant_id") SQL (0.2ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.2ms) CREATE TABLE "orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "number" varchar(15), "item_total" decimal(8,2) DEFAULT 0.0 NOT NULL, "total" decimal(8,2) DEFAULT 0.0 NOT NULL, "created_at" datetime, "updated_at" datetime, "state" varchar(255), "token" varchar(255), "adjustment_total" decimal(8,2) DEFAULT 0.0 NOT NULL, "credit_total" decimal(8,2) DEFAULT 0.0 NOT NULL)  SQL (0.0ms) PRAGMA index_list("orders") SQL (0.1ms) CREATE INDEX "index_orders_on_number" ON "orders" ("number") SQL (0.2ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms) CREATE TABLE "payments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "created_at" datetime, "updated_at" datetime, "amount" decimal(8,2) DEFAULT 0.0 NOT NULL, "creditcard_id" integer, "type" varchar(255))  SQL (0.2ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms) CREATE TABLE "preferences" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "attribute" varchar(100) NOT NULL, "owner_id" integer(30) NOT NULL, "owner_type" varchar(50) NOT NULL, "group_id" integer, "group_type" varchar(50), "value" varchar(255), "created_at" datetime, "updated_at" datetime)  SQL (0.0ms) PRAGMA index_list("preferences") SQL (0.2ms) CREATE UNIQUE INDEX "index_preferences_on_owner_and_attribute_and_preference" ON "preferences" ("owner_id", "owner_type", "attribute", "group_id", "group_type") SQL (0.2ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms) CREATE TABLE "product_option_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "product_id" integer, "option_type_id" integer, "position" integer, "created_at" datetime, "updated_at" datetime)  SQL (0.2ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms) CREATE TABLE "product_properties" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "product_id" integer, "property_id" integer, "value" varchar(255), "created_at" datetime, "updated_at" datetime)  SQL (0.3ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.2ms) CREATE TABLE "products" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) DEFAULT '' NOT NULL, "description" text, "created_at" datetime, "updated_at" datetime, "permalink" varchar(255), "available_on" datetime, "tax_category_id" integer, "shipping_category_id" integer, "deleted_at" datetime, "meta_description" varchar(255), "meta_keywords" varchar(255))  SQL (0.0ms) PRAGMA index_list("products") SQL (0.1ms) CREATE INDEX "index_products_on_available_on" ON "products" ("available_on") SQL (0.0ms) PRAGMA index_list("products") SQL (0.0ms) PRAGMA index_info('index_products_on_available_on') SQL (0.1ms) CREATE INDEX "index_products_on_deleted_at" ON "products" ("deleted_at") SQL (0.0ms) PRAGMA index_list("products") SQL (0.0ms) PRAGMA index_info('index_products_on_deleted_at') SQL (0.0ms) PRAGMA index_info('index_products_on_available_on') SQL (0.1ms) CREATE INDEX "index_products_on_name" ON "products" ("name") SQL (0.1ms) PRAGMA index_list("products") SQL (0.0ms) PRAGMA index_info('index_products_on_name') SQL (0.0ms) PRAGMA index_info('index_products_on_deleted_at') SQL (0.0ms) PRAGMA index_info('index_products_on_available_on') SQL (0.1ms) CREATE INDEX "index_products_on_permalink" ON "products" ("permalink") SQL (0.2ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms) CREATE TABLE "products_taxons" ("product_id" integer, "taxon_id" integer)  SQL (0.0ms) PRAGMA index_list("products_taxons") SQL (0.1ms) CREATE INDEX "index_products_taxons_on_product_id" ON "products_taxons" ("product_id") SQL (0.0ms) PRAGMA index_list("products_taxons") SQL (0.0ms) PRAGMA index_info('index_products_taxons_on_product_id') SQL (0.1ms) CREATE INDEX "index_products_taxons_on_taxon_id" ON "products_taxons" ("taxon_id") SQL (0.2ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) CREATE TABLE "properties" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "presentation" varchar(255) NOT NULL, "created_at" datetime, "updated_at" datetime) SQL (0.2ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) CREATE TABLE "properties_prototypes" ("prototype_id" integer, "property_id" integer) SQL (0.2ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) CREATE TABLE "prototypes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime, "updated_at" datetime) SQL (0.2ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) CREATE TABLE "roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255)) SQL (0.2ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) CREATE TABLE "roles_users" ("role_id" integer, "user_id" integer) SQL (0.0ms) PRAGMA index_list("roles_users") SQL (0.1ms) CREATE INDEX "index_roles_users_on_role_id" ON "roles_users" ("role_id") SQL (0.0ms) PRAGMA index_list("roles_users") SQL (0.0ms) PRAGMA index_info('index_roles_users_on_role_id') SQL (0.1ms) CREATE INDEX "index_roles_users_on_user_id" ON "roles_users" ("user_id") SQL (0.2ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms) CREATE TABLE "shipments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "shipping_method_id" integer, "tracking" varchar(255), "created_at" datetime, "updated_at" datetime, "number" varchar(255), "cost" decimal(8,2), "shipped_at" datetime, "address_id" integer)  SQL (0.3ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.2ms) CREATE TABLE "shipping_categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime, "updated_at" datetime)  SQL (0.3ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms) CREATE TABLE "shipping_methods" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "zone_id" integer, "name" varchar(255), "created_at" datetime, "updated_at" datetime)  SQL (0.3ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms) CREATE TABLE "state_events" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "user_id" integer, "name" varchar(255), "created_at" datetime, "updated_at" datetime, "previous_state" varchar(255))  SQL (0.3ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms) CREATE TABLE "states" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "abbr" varchar(255), "country_id" integer)  SQL (0.3ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms) CREATE TABLE "tax_categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "description" varchar(255), "created_at" datetime, "updated_at" datetime)  SQL (0.3ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms) CREATE TABLE "tax_rates" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "zone_id" integer, "amount" decimal(8,4), "created_at" datetime, "updated_at" datetime, "tax_category_id" integer)  SQL (0.3ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms) CREATE TABLE "taxonomies" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) NOT NULL, "created_at" datetime, "updated_at" datetime)  SQL (0.3ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms) CREATE TABLE "taxons" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "taxonomy_id" integer NOT NULL, "parent_id" integer, "position" integer DEFAULT 0, "name" varchar(255) NOT NULL, "created_at" datetime, "updated_at" datetime, "permalink" varchar(255))  SQL (0.3ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.2ms) CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255), "crypted_password" varchar(128) DEFAULT '' NOT NULL, "salt" varchar(128) DEFAULT '' NOT NULL, "remember_token" varchar(255), "remember_token_expires_at" varchar(255), "created_at" datetime, "updated_at" datetime, "persistence_token" varchar(255), "single_access_token" varchar(255), "perishable_token" varchar(255), "login_count" integer DEFAULT 0 NOT NULL, "failed_login_count" integer DEFAULT 0 NOT NULL, "last_request_at" datetime, "current_login_at" datetime, "last_login_at" datetime, "current_login_ip" varchar(255), "last_login_ip" varchar(255), "login" varchar(255), "ship_address_id" integer, "bill_address_id" integer)  SQL (0.3ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.2ms) CREATE TABLE "variants" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "product_id" integer, "sku" varchar(255) DEFAULT '' NOT NULL, "price" decimal(8,2) NOT NULL, "weight" decimal(8,2), "height" decimal(8,2), "width" decimal(8,2), "depth" decimal(8,2), "deleted_at" datetime, "is_master" boolean DEFAULT 'f')  SQL (0.0ms) PRAGMA index_list("variants") SQL (0.2ms) CREATE INDEX "index_variants_on_product_id" ON "variants" ("product_id") SQL (0.3ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms) CREATE TABLE "zone_members" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "zone_id" integer, "zoneable_id" integer, "zoneable_type" varchar(255), "created_at" datetime, "updated_at" datetime)  SQL (0.3ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms) CREATE TABLE "zones" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "description" varchar(255), "created_at" datetime, "updated_at" datetime)  SQL (0.3ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20090823005402') Migrating to CreateIndexesForInventoryUnits (20090904192342) SQL (0.1ms) PRAGMA index_list("inventory_units") SQL (0.4ms) CREATE INDEX "index_inventory_units_on_variant_id" ON "inventory_units" ("variant_id") SQL (0.1ms) PRAGMA index_list("inventory_units") SQL (0.1ms) PRAGMA index_info('index_inventory_units_on_variant_id') SQL (0.3ms) CREATE INDEX "index_inventory_units_on_order_id" ON "inventory_units" ("order_id") SQL (0.6ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20090904192342') Migrating to AddCountOnHandToVariantsAndProducts (20090923100315) SQL (0.6ms) ALTER TABLE "variants" ADD "count_on_hand" integer DEFAULT 0 NOT NULL SQL (0.4ms) ALTER TABLE "products" ADD "count_on_hand" integer DEFAULT 0 NOT NULL Variant Load (0.2ms) SELECT "variants".* FROM "variants" Product Load (0.2ms) SELECT "products".* FROM "products" SQL (0.5ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20090923100315') Migrating to ChangeTaxonsToNestedSet (20091007134354) SQL (0.6ms) ALTER TABLE "taxons" ADD "lft" integer SQL (0.4ms) ALTER TABLE "taxons" ADD "rgt" integer SQL (0.6ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.5ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' Property Load (0.2ms) SELECT "properties".* FROM "properties" WHERE "properties"."name" = 'brand' LIMIT 1 SQL (0.4ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' Taxon Load (0.2ms) SELECT "taxons".* FROM "taxons" WHERE (parent_id IS NULL) ORDER BY position ASC SQL (0.6ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20091007134354') Migrating to MoveToConfigurableGateways (20091008091614) SQL (0.3ms) DROP TABLE "gateways" SQL (0.2ms) DROP TABLE "gateway_options" SQL (0.1ms) DROP TABLE "gateway_option_values" SQL (0.2ms) DROP TABLE "gateway_configurations" SQL (0.4ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.2ms) CREATE TABLE "gateways" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(255), "name" varchar(255), "description" text, "active" boolean DEFAULT 't', "environment" varchar(255) DEFAULT 'development', "server" varchar(255) DEFAULT 'test', "test_mode" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime)  SQL (0.4ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20091008091614') Migrating to ProductGroupsAndScopes (20091012120519) SQL (0.5ms) CREATE TABLE "product_groups" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "permalink" varchar(255), "order" varchar(255)) SQL (0.3ms) CREATE TABLE "product_scopes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "product_group_id" integer, "name" varchar(255), "arguments" text)  SQL (0.0ms) PRAGMA index_list("product_groups") SQL (0.1ms) CREATE INDEX "index_product_groups_on_name" ON "product_groups" ("name") SQL (0.1ms) PRAGMA index_list("product_groups") SQL (0.0ms) PRAGMA index_info('index_product_groups_on_name') SQL (0.1ms) CREATE INDEX "index_product_groups_on_permalink" ON "product_groups" ("permalink") SQL (0.0ms) PRAGMA index_list("product_scopes") SQL (0.1ms) CREATE INDEX "index_product_scopes_on_name" ON "product_scopes" ("name") SQL (0.0ms) PRAGMA index_list("product_scopes") SQL (0.1ms) PRAGMA index_info('index_product_scopes_on_name') SQL (0.2ms) CREATE INDEX "index_product_scopes_on_product_group_id" ON "product_scopes" ("product_group_id") SQL (0.3ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20091012120519') Migrating to AddOpenIdAuthenticationTables (20091015110842) SQL (0.8ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.3ms) CREATE TABLE "open_id_authentication_associations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "issued" integer, "lifetime" integer, "handle" varchar(255), "assoc_type" varchar(255), "server_url" blob, "secret" blob)  SQL (0.7ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.3ms) CREATE TABLE "open_id_authentication_nonces" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "timestamp" integer NOT NULL, "server_url" varchar(255), "salt" varchar(255) NOT NULL)  SQL (0.7ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20091015110842') Migrating to AddOpenidFieldToUsers (20091015153048) SQL (0.6ms) ALTER TABLE "users" ADD "openid_identifier" varchar(255) SQL (0.1ms) PRAGMA index_list("users") SQL (0.3ms) CREATE INDEX "index_users_on_openid_identifier" ON "users" ("openid_identifier") SQL (0.4ms) CREATE TEMPORARY TABLE "altered_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255), "crypted_password" varchar(128) DEFAULT '' NOT NULL, "salt" varchar(128) DEFAULT '' NOT NULL, "remember_token" varchar(255), "remember_token_expires_at" varchar(255), "created_at" datetime, "updated_at" datetime, "persistence_token" varchar(255), "single_access_token" varchar(255), "perishable_token" varchar(255), "login_count" integer DEFAULT 0 NOT NULL, "failed_login_count" integer DEFAULT 0 NOT NULL, "last_request_at" datetime, "current_login_at" datetime, "last_login_at" datetime, "current_login_ip" varchar(255), "last_login_ip" varchar(255), "login" varchar(255), "ship_address_id" integer, "bill_address_id" integer, "openid_identifier" varchar(255))  SQL (0.1ms) PRAGMA index_list("users") SQL (0.0ms) PRAGMA index_info('index_users_on_openid_identifier') SQL (0.9ms) PRAGMA index_list("altered_users") SQL (0.2ms) CREATE INDEX "temp_index_altered_users_on_openid_identifier" ON "altered_users" ("openid_identifier") SQL (0.3ms) DROP TABLE "users" SQL (0.3ms) CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255), "crypted_password" varchar(128) DEFAULT '' NOT NULL, "salt" varchar(128) DEFAULT '' NOT NULL, "remember_token" varchar(255), "remember_token_expires_at" varchar(255), "created_at" datetime, "updated_at" datetime, "persistence_token" varchar(255), "single_access_token" varchar(255), "perishable_token" varchar(255), "login_count" integer DEFAULT 0 NOT NULL, "failed_login_count" integer DEFAULT 0 NOT NULL, "last_request_at" datetime, "current_login_at" datetime, "last_login_at" datetime, "current_login_ip" varchar(255), "last_login_ip" varchar(255), "login" varchar(255), "ship_address_id" integer, "bill_address_id" integer, "openid_identifier" varchar(255))  SQL (0.1ms) PRAGMA index_list("altered_users") SQL (0.1ms) PRAGMA index_info('temp_index_altered_users_on_openid_identifier') SQL (0.0ms) PRAGMA index_list("users") SQL (0.2ms) CREATE INDEX "index_users_on_openid_identifier" ON "users" ("openid_identifier") SQL (0.2ms) DROP TABLE "altered_users" SQL (0.2ms) CREATE TEMPORARY TABLE "altered_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255), "crypted_password" varchar(128) DEFAULT '' NOT NULL, "salt" varchar(128) DEFAULT '' NOT NULL, "remember_token" varchar(255), "remember_token_expires_at" varchar(255), "created_at" datetime, "updated_at" datetime, "persistence_token" varchar(255), "single_access_token" varchar(255), "perishable_token" varchar(255), "login_count" integer DEFAULT 0 NOT NULL, "failed_login_count" integer DEFAULT 0 NOT NULL, "last_request_at" datetime, "current_login_at" datetime, "last_login_at" datetime, "current_login_ip" varchar(255), "last_login_ip" varchar(255), "login" varchar(255), "ship_address_id" integer, "bill_address_id" integer, "openid_identifier" varchar(255))  SQL (0.1ms) PRAGMA index_list("users") SQL (0.0ms) PRAGMA index_info('index_users_on_openid_identifier') SQL (0.0ms) PRAGMA index_list("altered_users") SQL (0.1ms) CREATE INDEX "temp_index_altered_users_on_openid_identifier" ON "altered_users" ("openid_identifier") SQL (0.2ms) DROP TABLE "users" SQL (0.3ms) CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255), "crypted_password" varchar(128), "salt" varchar(128) DEFAULT '' NOT NULL, "remember_token" varchar(255), "remember_token_expires_at" varchar(255), "created_at" datetime, "updated_at" datetime, "persistence_token" varchar(255), "single_access_token" varchar(255), "perishable_token" varchar(255), "login_count" integer DEFAULT 0 NOT NULL, "failed_login_count" integer DEFAULT 0 NOT NULL, "last_request_at" datetime, "current_login_at" datetime, "last_login_at" datetime, "current_login_ip" varchar(255), "last_login_ip" varchar(255), "login" varchar(255), "ship_address_id" integer, "bill_address_id" integer, "openid_identifier" varchar(255))  SQL (0.1ms) PRAGMA index_list("altered_users") SQL (0.0ms) PRAGMA index_info('temp_index_altered_users_on_openid_identifier') SQL (0.1ms) PRAGMA index_list("users") SQL (0.2ms) CREATE INDEX "index_users_on_openid_identifier" ON "users" ("openid_identifier") SQL (0.1ms) DROP TABLE "altered_users" SQL (0.4ms) CREATE TEMPORARY TABLE "altered_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255), "crypted_password" varchar(128), "salt" varchar(128) DEFAULT '' NOT NULL, "remember_token" varchar(255), "remember_token_expires_at" varchar(255), "created_at" datetime, "updated_at" datetime, "persistence_token" varchar(255), "single_access_token" varchar(255), "perishable_token" varchar(255), "login_count" integer DEFAULT 0 NOT NULL, "failed_login_count" integer DEFAULT 0 NOT NULL, "last_request_at" datetime, "current_login_at" datetime, "last_login_at" datetime, "current_login_ip" varchar(255), "last_login_ip" varchar(255), "login" varchar(255), "ship_address_id" integer, "bill_address_id" integer, "openid_identifier" varchar(255))  SQL (0.1ms) PRAGMA index_list("users") SQL (0.1ms) PRAGMA index_info('index_users_on_openid_identifier') SQL (0.1ms) PRAGMA index_list("altered_users") SQL (0.2ms) CREATE INDEX "temp_index_altered_users_on_openid_identifier" ON "altered_users" ("openid_identifier") SQL (0.2ms) DROP TABLE "users" SQL (0.3ms) CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255), "crypted_password" varchar(128), "salt" varchar(128), "remember_token" varchar(255), "remember_token_expires_at" varchar(255), "created_at" datetime, "updated_at" datetime, "persistence_token" varchar(255), "single_access_token" varchar(255), "perishable_token" varchar(255), "login_count" integer DEFAULT 0 NOT NULL, "failed_login_count" integer DEFAULT 0 NOT NULL, "last_request_at" datetime, "current_login_at" datetime, "last_login_at" datetime, "current_login_ip" varchar(255), "last_login_ip" varchar(255), "login" varchar(255), "ship_address_id" integer, "bill_address_id" integer, "openid_identifier" varchar(255))  SQL (0.1ms) PRAGMA index_list("altered_users") SQL (0.0ms) PRAGMA index_info('temp_index_altered_users_on_openid_identifier') SQL (0.1ms) PRAGMA index_list("users") SQL (0.2ms) CREATE INDEX "index_users_on_openid_identifier" ON "users" ("openid_identifier") SQL (0.1ms) DROP TABLE "altered_users" SQL (0.3ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20091015153048') Migrating to ChangePreferenceValueType (20091016174634) SQL (0.1ms) PRAGMA index_list("preferences") SQL (0.1ms) PRAGMA index_info('index_preferences_on_owner_and_attribute_and_preference') SQL (0.4ms) DROP INDEX "index_preferences_on_owner_and_attribute_and_preference" SQL (0.2ms) CREATE TEMPORARY TABLE "altered_preferences" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "attribute" varchar(100) NOT NULL, "owner_id" integer(30) NOT NULL, "owner_type" varchar(50) NOT NULL, "group_id" integer, "group_type" varchar(50), "value" varchar(255), "created_at" datetime, "updated_at" datetime) SQL (0.0ms) PRAGMA index_list("preferences") SQL (0.2ms) DROP TABLE "preferences" SQL (0.2ms) CREATE TABLE "preferences" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "attribute" varchar(100) NOT NULL, "owner_id" integer(30) NOT NULL, "owner_type" varchar(50) NOT NULL, "group_id" integer, "group_type" varchar(50), "value" text(255), "created_at" datetime, "updated_at" datetime)  SQL (0.0ms) PRAGMA index_list("altered_preferences") SQL (0.1ms) DROP TABLE "altered_preferences" SQL (0.3ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20091016174634') Migrating to CreateBillingIntegrations (20091017175558) SQL (0.5ms) CREATE TABLE "billing_integrations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(255), "name" varchar(255), "description" text, "active" boolean DEFAULT 't', "environment" varchar(255) DEFAULT 'development', "created_at" datetime, "updated_at" datetime) SQL (0.7ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20091017175558') Migrating to ChargeRefactoring (20091021133257) SQL (0.6ms) ALTER TABLE "orders" ADD "completed_at" datetime ChargeRefactoring::Order Load (0.2ms) SELECT "orders".* FROM "orders" SQL (1.2ms) CREATE TEMPORARY TABLE "altered_checkouts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "email" varchar(255), "ip_address" varchar(255), "special_instructions" text, "bill_address_id" integer, "completed_at" datetime, "created_at" datetime, "updated_at" datetime)  SQL (0.0ms) PRAGMA index_list("checkouts") SQL (0.2ms) DROP TABLE "checkouts" SQL (0.2ms) CREATE TABLE "checkouts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "email" varchar(255), "ip_address" varchar(255), "special_instructions" text, "bill_address_id" integer, "created_at" datetime, "updated_at" datetime) SQL (0.0ms) PRAGMA index_list("altered_checkouts") SQL (0.1ms) DROP TABLE "altered_checkouts" SQL (0.2ms) CREATE TEMPORARY TABLE "altered_adjustments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "type" varchar(255), "amount" decimal DEFAULT 0.0 NOT NULL, "description" varchar(255), "position" integer, "created_at" datetime, "updated_at" datetime, "adjustment_source_id" integer, "adjustment_source_type" varchar(255), "secondary_type" varchar(255))  SQL (0.0ms) PRAGMA index_list("adjustments") SQL (0.1ms) DROP TABLE "adjustments" SQL (0.2ms) CREATE TABLE "adjustments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "type" varchar(255), "amount" decimal, "description" varchar(255), "position" integer, "created_at" datetime, "updated_at" datetime, "adjustment_source_id" integer, "adjustment_source_type" varchar(255), "secondary_type" varchar(255)) SQL (0.0ms) PRAGMA index_list("altered_adjustments") SQL (0.1ms) DROP TABLE "altered_adjustments" SQL (0.4ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  AREL (0.1ms) UPDATE "adjustments" SET type = secondary_type AREL (0.0ms) UPDATE "adjustments" SET type = 'CouponCredit' WHERE (type = 'Credit') SQL (0.2ms) CREATE TEMPORARY TABLE "altered_adjustments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "type" varchar(255), "amount" decimal, "description" varchar(255), "position" integer, "created_at" datetime, "updated_at" datetime, "adjustment_source_id" integer, "adjustment_source_type" varchar(255), "secondary_type" varchar(255)) SQL (0.0ms) PRAGMA index_list("adjustments") SQL (0.2ms) DROP TABLE "adjustments" SQL (0.3ms) CREATE TABLE "adjustments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "type" varchar(255), "amount" decimal, "description" varchar(255), "position" integer, "created_at" datetime, "updated_at" datetime, "adjustment_source_id" integer, "adjustment_source_type" varchar(255))  SQL (0.0ms) PRAGMA index_list("altered_adjustments") SQL (0.1ms) DROP TABLE "altered_adjustments" SQL (0.5ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20091021133257') Migrating to AddSomeIndexes (20091104151730) SQL (0.1ms) PRAGMA index_list("taxons") SQL (0.4ms) CREATE INDEX "index_taxons_on_permalink" ON "taxons" ("permalink") SQL (0.1ms) PRAGMA index_list("taxons") SQL (0.1ms) PRAGMA index_info('index_taxons_on_permalink') SQL (0.2ms) CREATE INDEX "index_taxons_on_parent_id" ON "taxons" ("parent_id") SQL (0.1ms) PRAGMA index_list("taxons") SQL (0.1ms) PRAGMA index_info('index_taxons_on_parent_id') SQL (0.1ms) PRAGMA index_info('index_taxons_on_permalink') SQL (0.4ms) CREATE INDEX "index_taxons_on_taxonomy_id" ON "taxons" ("taxonomy_id") SQL (0.1ms) PRAGMA index_list("assets") SQL (0.3ms) CREATE INDEX "index_assets_on_viewable_id" ON "assets" ("viewable_id") SQL (0.1ms) PRAGMA index_list("assets") SQL (0.1ms) PRAGMA index_info('index_assets_on_viewable_id') SQL (0.2ms) CREATE INDEX "index_assets_on_viewable_type_and_type" ON "assets" ("viewable_type", "type") SQL (0.0ms) PRAGMA index_list("product_properties") SQL (0.3ms) CREATE INDEX "index_product_properties_on_product_id" ON "product_properties" ("product_id") SQL (0.1ms) PRAGMA index_list("option_values_variants") SQL (0.1ms) PRAGMA index_info('index_option_values_variants_on_variant_id') SQL (0.2ms) CREATE INDEX "index_option_values_variants_on_variant_id_and_option_value_id" ON "option_values_variants" ("variant_id", "option_value_id") SQL (0.6ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20091104151730') Migrating to CheckoutStateMachine (20091126190904) SQL (0.6ms) ALTER TABLE "checkouts" ADD "state" varchar(255) SQL (1.2ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20091126190904') Migrating to StateForShipments (20091209153045) SQL (0.5ms) ALTER TABLE "shipments" ADD "state" varchar(255) SQL (0.7ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ('20091209153045') Migrating to MakeStateEventsPolymorphic (20091209202200) SQL (0.2ms) CREATE TEMPORARY TABLE "altered_state_events" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "stateful_id" integer, "user_id" integer, "name" varchar(255), "created_at" datetime, "updated_at" datetime, "previous_state" varchar(255))  SQL (0.0ms) PRAGMA index_list("state_events") SQL (0.2ms) DROP TABLE "state_events" SQL (0.2ms) CREATE TABLE "state_events" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "stateful_id" integer, "user_id" integer, "name" varchar(255), "created_at" datetime, "updated_at" datetime, "previous_state" varchar(255)) SQL (0.0ms) PRAGMA index_list("altered_state_events") SQL (0.2ms) DROP TABLE "altered_state_events" SQL (0.2ms) ALTER TABLE "state_events" ADD "stateful_type" varchar(255) AREL (0.1ms) UPDATE "state_events" SET "stateful_type" = 'Order' SQL (0.4ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20091209202200') Migrating to ShipAddressIdForCheckouts (20091211203813) SQL (0.7ms) ALTER TABLE "checkouts" ADD "ship_address_id" integer SQL (1.3ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ('20091211203813') Migrating to ShippingMethodIdForCheckouts (20091212161118) SQL (0.9ms) ALTER TABLE "checkouts" ADD "shipping_method_id" integer SQL (1.3ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20091212161118') Migrating to CreditcardLastFourDigits (20091213222815) SQL (0.2ms) CREATE TEMPORARY TABLE "altered_creditcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" text, "month" varchar(255), "year" varchar(255), "verification_value" text, "cc_type" varchar(255), "last_digits" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "created_at" datetime, "updated_at" datetime, "start_month" varchar(255), "start_year" varchar(255), "issue_number" varchar(255), "address_id" integer, "checkout_id" integer)  SQL (0.0ms) PRAGMA index_list("creditcards") SQL (0.2ms) DROP TABLE "creditcards" SQL (0.3ms) CREATE TABLE "creditcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" text, "month" varchar(255), "year" varchar(255), "verification_value" text, "cc_type" varchar(255), "last_digits" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "created_at" datetime, "updated_at" datetime, "start_month" varchar(255), "start_year" varchar(255), "issue_number" varchar(255), "address_id" integer, "checkout_id" integer) SQL (0.0ms) PRAGMA index_list("altered_creditcards") SQL (0.4ms) DROP TABLE "altered_creditcards" CreditcardLastFourDigits::Creditcard Load (0.2ms) SELECT "creditcards".* FROM "creditcards" SQL (0.4ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20091213222815') Migrating to PopulateLegacyShipmentState (20091214183826) PopulateLegacyShipmentState::Shipment Load (0.2ms) SELECT "shipments".* FROM "shipments" SQL (0.7ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ('20091214183826') Migrating to AddCostPrice (20100105090147) SQL (0.4ms) ALTER TABLE "variants" ADD "cost_price" decimal(8,2) DEFAULT NULL SQL (0.5ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ('20100105090147') Migrating to ShipmentIdForInventoryUnits (20100105132138) SQL (0.6ms) ALTER TABLE "inventory_units" ADD "shipment_id" integer SQL (0.1ms) PRAGMA index_list("inventory_units") SQL (0.1ms) PRAGMA index_info('index_inventory_units_on_order_id') SQL (0.1ms) PRAGMA index_info('index_inventory_units_on_variant_id') SQL (0.3ms) CREATE INDEX "index_inventory_units_on_shipment_id" ON "inventory_units" ("shipment_id") Shipment Load (0.1ms) SELECT "shipments".* FROM "shipments" SQL (1.1ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20100105132138') Migrating to CimFieldsForCreditcards (20100111205525) SQL (0.7ms) ALTER TABLE "creditcards" ADD "gateway_customer_profile_id" varchar(255) SQL (0.4ms) ALTER TABLE "creditcards" ADD "gateway_payment_profile_id" varchar(255) SQL (0.4ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20100111205525') Migrating to CreateReturnAuthorizations (20100112151511) SQL (0.4ms) CREATE TABLE "return_authorizations" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" varchar(255), "amount" decimal(8,2) DEFAULT 0.0 NOT NULL, "order_id" integer, "reason" text, "state" varchar(255), "created_at" datetime, "updated_at" datetime) SQL (0.7ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20100112151511') Migrating to AddReturnAuthorizationToInventoryUnits (20100113090919) SQL (0.5ms) ALTER TABLE "inventory_units" ADD "return_authorization_id" integer SQL (0.6ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20100113090919') Migrating to CreateTrackers (20100113203104) SQL (0.6ms) CREATE TABLE "trackers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "environment" varchar(255), "analytics_id" varchar(255), "active" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime) SQL (0.7ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20100113203104') Migrating to CreditcardIdForCreditcardTxns (20100121160010) SQL (0.7ms) ALTER TABLE "creditcard_txns" ADD "creditcard_id" integer SQL (0.7ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ('20100121160010') Migrating to OriginalCreditcardTxnIdForCreditcardTxns (20100121183934) SQL (0.5ms) ALTER TABLE "creditcard_txns" ADD "original_creditcard_txn_id" integer SQL (0.4ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20100121183934') Migrating to AddTestModeToBillingIntegration (20100125145351) SQL (0.6ms) ALTER TABLE "billing_integrations" ADD "test_mode" boolean DEFAULT 't' SQL (0.4ms) ALTER TABLE "billing_integrations" ADD "server" varchar(255) DEFAULT 'test' SQL (1.3ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ('20100125145351') Migrating to CreateProductsProductGroups (20100126103714) SQL (1.2ms) CREATE TABLE "product_groups_products" ("product_id" integer, "product_group_id" integer)  SQL (1.4ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ('20100126103714') Migrating to CreatePaymentMethods (20100209025806) SQL (0.5ms) CREATE TABLE "payment_methods" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(255), "name" varchar(255), "description" text, "active" boolean DEFAULT 't', "environment" varchar(255) DEFAULT 'development', "created_at" datetime, "updated_at" datetime) SQL (0.8ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20100209025806') Migrating to PolymorphicPayments (20100209144531) SQL (0.3ms) CREATE TEMPORARY TABLE "altered_payments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "created_at" datetime, "updated_at" datetime, "amount" decimal DEFAULT 0.0 NOT NULL, "creditcard_id" integer, "type" varchar(255))  SQL (0.0ms) PRAGMA index_list("payments") SQL (0.2ms) DROP TABLE "payments" SQL (0.3ms) CREATE TABLE "payments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "created_at" datetime, "updated_at" datetime, "amount" decimal DEFAULT 0.0 NOT NULL, "creditcard_id" integer) SQL (0.1ms) PRAGMA index_list("altered_payments") SQL (0.1ms) DROP TABLE "altered_payments" SQL (0.2ms) CREATE TEMPORARY TABLE "altered_payments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "created_at" datetime, "updated_at" datetime, "amount" decimal DEFAULT 0.0 NOT NULL, "creditcard_id" integer)  SQL (0.1ms) PRAGMA index_list("payments") SQL (0.6ms) DROP TABLE "payments" SQL (0.2ms) CREATE TABLE "payments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "created_at" datetime, "updated_at" datetime, "amount" decimal DEFAULT 0.0 NOT NULL) SQL (0.0ms) PRAGMA index_list("altered_payments") SQL (0.1ms) DROP TABLE "altered_payments" SQL (0.2ms) CREATE TEMPORARY TABLE "altered_payments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "payable_id" integer, "created_at" datetime, "updated_at" datetime, "amount" decimal DEFAULT 0.0 NOT NULL)  SQL (0.0ms) PRAGMA index_list("payments") SQL (0.1ms) DROP TABLE "payments" SQL (0.2ms) CREATE TABLE "payments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "payable_id" integer, "created_at" datetime, "updated_at" datetime, "amount" decimal DEFAULT 0.0 NOT NULL) SQL (0.0ms) PRAGMA index_list("altered_payments") SQL (0.1ms) DROP TABLE "altered_payments" SQL (0.2ms) ALTER TABLE "payments" ADD "payable_type" varchar(255) SQL (0.2ms) ALTER TABLE "payments" ADD "payment_method" varchar(255) SQL (0.2ms) ALTER TABLE "payments" ADD "source_id" integer SQL (0.2ms) ALTER TABLE "payments" ADD "source_type" varchar(255) SQL (0.0ms) UPDATE payments SET payable_type = 'Order' Creditcard Load (0.2ms) SELECT "creditcards".* FROM "creditcards" SQL (0.2ms) CREATE TEMPORARY TABLE "altered_creditcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" text, "month" varchar(255), "year" varchar(255), "verification_value" text, "cc_type" varchar(255), "last_digits" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "created_at" datetime, "updated_at" datetime, "start_month" varchar(255), "start_year" varchar(255), "issue_number" varchar(255), "address_id" integer, "checkout_id" integer, "gateway_customer_profile_id" varchar(255), "gateway_payment_profile_id" varchar(255))  SQL (0.0ms) PRAGMA index_list("creditcards") SQL (0.2ms) DROP TABLE "creditcards" SQL (0.2ms) CREATE TABLE "creditcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" text, "month" varchar(255), "year" varchar(255), "verification_value" text, "cc_type" varchar(255), "last_digits" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "created_at" datetime, "updated_at" datetime, "start_month" varchar(255), "start_year" varchar(255), "issue_number" varchar(255), "address_id" integer, "gateway_customer_profile_id" varchar(255), "gateway_payment_profile_id" varchar(255)) SQL (0.0ms) PRAGMA index_list("altered_creditcards") SQL (0.1ms) DROP TABLE "altered_creditcards" SQL (0.4ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20100209144531') Migrating to ChangePaymentsPaymentMethodToBelongsTo (20100213103131) SQL (0.3ms) CREATE TEMPORARY TABLE "altered_payments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "payable_id" integer, "created_at" datetime, "updated_at" datetime, "amount" decimal DEFAULT 0.0 NOT NULL, "payable_type" varchar(255), "payment_method" varchar(255), "source_id" integer, "source_type" varchar(255))  SQL (0.1ms) PRAGMA index_list("payments") SQL (0.2ms) DROP TABLE "payments" SQL (0.3ms) CREATE TABLE "payments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "payable_id" integer, "created_at" datetime, "updated_at" datetime, "amount" decimal DEFAULT 0.0 NOT NULL, "payable_type" varchar(255), "source_id" integer, "source_type" varchar(255)) SQL (0.0ms) PRAGMA index_list("altered_payments") SQL (0.1ms) DROP TABLE "altered_payments" SQL (0.2ms) ALTER TABLE "payments" ADD "payment_method_id" integer SQL (0.4ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20100213103131') Migrating to AssignCreditcardTxnsToPayment (20100214212536) SQL (0.3ms) ALTER TABLE "creditcard_txns" ADD "payment_id" integer SQL (0.1ms) SELECT * FROM creditcard_txns SQL (0.2ms) CREATE TEMPORARY TABLE "altered_creditcard_txns" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "creditcard_payment_id" integer, "amount" decimal DEFAULT 0.0 NOT NULL, "txn_type" integer, "response_code" varchar(255), "avs_response" text, "cvv_response" text, "created_at" datetime, "updated_at" datetime, "creditcard_id" integer, "original_creditcard_txn_id" integer, "payment_id" integer) SQL (0.0ms) PRAGMA index_list("creditcard_txns") SQL (0.2ms) DROP TABLE "creditcard_txns" SQL (0.3ms) CREATE TABLE "creditcard_txns" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "amount" decimal DEFAULT 0.0 NOT NULL, "txn_type" integer, "response_code" varchar(255), "avs_response" text, "cvv_response" text, "created_at" datetime, "updated_at" datetime, "creditcard_id" integer, "original_creditcard_txn_id" integer, "payment_id" integer)  SQL (0.0ms) PRAGMA index_list("altered_creditcard_txns") SQL (0.1ms) DROP TABLE "altered_creditcard_txns" SQL (0.6ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20100214212536') Migrating to StiForTransactions (20100223170312) SQL (0.6ms) ALTER TABLE "creditcard_txns" RENAME TO "transactions" SQL (0.4ms) ALTER TABLE "transactions" ADD "type" varchar(255) SQL (0.2ms) CREATE TEMPORARY TABLE "altered_transactions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "amount" decimal DEFAULT 0.0 NOT NULL, "txn_type" integer, "response_code" varchar(255), "avs_response" text, "cvv_response" text, "created_at" datetime, "updated_at" datetime, "creditcard_id" integer, "original_creditcard_txn_id" integer, "payment_id" integer, "type" varchar(255)) SQL (0.0ms) PRAGMA index_list("transactions") SQL (0.2ms) DROP TABLE "transactions" SQL (0.2ms) CREATE TABLE "transactions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "amount" decimal DEFAULT 0.0 NOT NULL, "txn_type" integer, "response_code" varchar(255), "avs_response" text, "cvv_response" text, "created_at" datetime, "updated_at" datetime, "original_creditcard_txn_id" integer, "payment_id" integer, "type" varchar(255))  SQL (0.0ms) PRAGMA index_list("altered_transactions") SQL (0.1ms) DROP TABLE "altered_transactions" SQL (0.4ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20100223170312') Migrating to DropBillingIntegrations (20100223183812) SQL (0.5ms) DROP TABLE "billing_integrations" SQL (0.7ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ('20100223183812') Migrating to DeletedAtForPaymentMethods (20100224153127) SQL (0.7ms) ALTER TABLE "payment_methods" ADD "deleted_at" datetime DEFAULT NULL SQL (0.9ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20100224153127') Migrating to AddAdjustmentsIndex (20100301163454) SQL (0.1ms) PRAGMA index_list("adjustments") SQL (0.4ms) CREATE INDEX "index_adjustments_on_order_id" ON "adjustments" ("order_id") SQL (0.7ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20100301163454') Migrating to FixByPopularity (20100306153445) AREL (0.2ms) UPDATE "product_scopes" SET name='descend_by_popularity' WHERE (name='by_popularity') SQL (0.9ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ('20100306153445') Migrating to AddAltTextToImages (20100317120946) SQL (0.6ms) ALTER TABLE "assets" ADD "alt" text SQL (0.8ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.6ms) INSERT INTO "schema_migrations" ("version") VALUES ('20100317120946') Migrating to AddDisplayToPaymentMethods (20100427121301) SQL (0.6ms) ALTER TABLE "payment_methods" ADD "display" varchar(255) DEFAULT NULL SQL (0.8ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20100427121301') Migrating to AddAddressesCheckoutsIndexes (20100504142133) SQL (0.1ms) PRAGMA index_list("addresses") SQL (0.6ms) CREATE INDEX "index_addresses_on_firstname" ON "addresses" ("firstname") SQL (0.1ms) PRAGMA index_list("addresses") SQL (0.1ms) PRAGMA index_info('index_addresses_on_firstname') SQL (0.3ms) CREATE INDEX "index_addresses_on_lastname" ON "addresses" ("lastname") SQL (0.1ms) PRAGMA index_list("checkouts") SQL (0.4ms) CREATE INDEX "index_checkouts_on_order_id" ON "checkouts" ("order_id") SQL (0.2ms) PRAGMA index_list("checkouts") SQL (0.1ms) PRAGMA index_info('index_checkouts_on_order_id') SQL (0.5ms) CREATE INDEX "index_checkouts_on_bill_address_id" ON "checkouts" ("bill_address_id") SQL (1.3ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20100504142133') Migrating to AddIconToTaxons (20100506180619) SQL (0.5ms) ALTER TABLE "taxons" ADD "icon_file_name" varchar(255) SQL (0.3ms) ALTER TABLE "taxons" ADD "icon_content_type" varchar(255) SQL (0.4ms) ALTER TABLE "taxons" ADD "icon_file_size" integer SQL (0.3ms) ALTER TABLE "taxons" ADD "icon_updated_at" datetime SQL (0.6ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20100506180619') Migrating to AddDescriptionToTaxons (20100506185838) SQL (0.7ms) ALTER TABLE "taxons" ADD "description" text SQL (0.8ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20100506185838') Migrating to IndexForShipmentsNumber (20100528155333) SQL (0.1ms) PRAGMA index_list("shipments") SQL (0.4ms) CREATE INDEX "index_shipments_on_number" ON "shipments" ("number") SQL (1.1ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20100528155333') Migrating to AddIndexOnUsersPersistenceToken (20100528185820) SQL (0.1ms) PRAGMA index_list("users") SQL (0.1ms) PRAGMA index_info('index_users_on_openid_identifier') SQL (0.4ms) CREATE INDEX "index_users_on_persistence_token" ON "users" ("persistence_token") SQL (0.7ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20100528185820') Migrating to AddDefaultToTaxCategories (20100605152042) SQL (0.5ms) ALTER TABLE "tax_categories" ADD "is_default" boolean DEFAULT 'f' SQL (0.8ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20100605152042') Migrating to AddDisplayToShippingMethods (20100624110730) SQL (0.6ms) ALTER TABLE "shipping_methods" ADD "display_on" varchar(255) DEFAULT NULL SQL (1.1ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20100624110730') Migrating to RenamePaymentMethodDisplay (20100624123336) SQL (0.2ms) CREATE TEMPORARY TABLE "altered_payment_methods" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(255), "name" varchar(255), "description" text, "active" boolean DEFAULT 't', "environment" varchar(255) DEFAULT 'development', "created_at" datetime, "updated_at" datetime, "deleted_at" datetime, "display_on" varchar(255))  SQL (0.0ms) PRAGMA index_list("payment_methods") SQL (0.2ms) DROP TABLE "payment_methods" SQL (0.2ms) CREATE TABLE "payment_methods" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(255), "name" varchar(255), "description" text, "active" boolean DEFAULT 't', "environment" varchar(255) DEFAULT 'development', "created_at" datetime, "updated_at" datetime, "deleted_at" datetime, "display_on" varchar(255)) SQL (0.0ms) PRAGMA index_list("altered_payment_methods") SQL (0.1ms) DROP TABLE "altered_payment_methods" SQL (0.4ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20100624123336') Migrating to RenamePreferencesField (20100624175547) SQL (1.2ms) CREATE TEMPORARY TABLE "altered_preferences" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(100) NOT NULL, "owner_id" integer(30) NOT NULL, "owner_type" varchar(50) NOT NULL, "group_id" integer, "group_type" varchar(50), "value" text(255), "created_at" datetime, "updated_at" datetime)  SQL (0.0ms) PRAGMA index_list("preferences") SQL (0.2ms) DROP TABLE "preferences" SQL (0.3ms) CREATE TABLE "preferences" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(100) NOT NULL, "owner_id" integer(30) NOT NULL, "owner_type" varchar(50) NOT NULL, "group_id" integer, "group_type" varchar(50), "value" text(255), "created_at" datetime, "updated_at" datetime) SQL (0.0ms) PRAGMA index_list("altered_preferences") SQL (0.1ms) DROP TABLE "altered_preferences" SQL (0.4ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20100624175547') Migrating to AddGuestFlag (20100811163637) SQL (0.8ms) ALTER TABLE "users" ADD "guest" boolean SQL (0.8ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20100811163637') Migrating to DropOrderToken (20100811205836) SQL (0.2ms) CREATE TEMPORARY TABLE "altered_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "number" varchar(15), "item_total" decimal DEFAULT 0.0 NOT NULL, "total" decimal DEFAULT 0.0 NOT NULL, "created_at" datetime, "updated_at" datetime, "state" varchar(255), "token" varchar(255), "adjustment_total" decimal DEFAULT 0.0 NOT NULL, "credit_total" decimal DEFAULT 0.0 NOT NULL, "completed_at" datetime) SQL (0.0ms) PRAGMA index_list("orders") SQL (0.0ms) PRAGMA index_info('index_orders_on_number') SQL (0.0ms) PRAGMA index_list("altered_orders") SQL (0.1ms) CREATE INDEX "temp_index_altered_orders_on_number" ON "altered_orders" ("number") SQL (0.2ms) DROP TABLE "orders" SQL (0.3ms) CREATE TABLE "orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "number" varchar(15), "item_total" decimal DEFAULT 0.0 NOT NULL, "total" decimal DEFAULT 0.0 NOT NULL, "created_at" datetime, "updated_at" datetime, "state" varchar(255), "adjustment_total" decimal DEFAULT 0.0 NOT NULL, "credit_total" decimal DEFAULT 0.0 NOT NULL, "completed_at" datetime) SQL (0.0ms) PRAGMA index_list("altered_orders") SQL (0.0ms) PRAGMA index_info('temp_index_altered_orders_on_number') SQL (0.0ms) PRAGMA index_list("orders") SQL (0.1ms) CREATE INDEX "index_orders_on_number" ON "orders" ("number") SQL (0.1ms) DROP TABLE "altered_orders" SQL (0.4ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20100811205836') Migrating to PaymentsStateAndAssignedToOrderOnly (20100812162326) SQL (0.2ms) CREATE TEMPORARY TABLE "altered_payments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "created_at" datetime, "updated_at" datetime, "amount" decimal DEFAULT 0.0 NOT NULL, "payable_type" varchar(255), "source_id" integer, "source_type" varchar(255), "payment_method_id" integer) SQL (0.0ms) PRAGMA index_list("payments") SQL (0.2ms) DROP TABLE "payments" SQL (0.3ms) CREATE TABLE "payments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "created_at" datetime, "updated_at" datetime, "amount" decimal DEFAULT 0.0 NOT NULL, "payable_type" varchar(255), "source_id" integer, "source_type" varchar(255), "payment_method_id" integer)  SQL (0.0ms) PRAGMA index_list("altered_payments") SQL (0.1ms) DROP TABLE "altered_payments" SQL (0.2ms) CREATE TEMPORARY TABLE "altered_payments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "created_at" datetime, "updated_at" datetime, "amount" decimal DEFAULT 0.0 NOT NULL, "payable_type" varchar(255), "source_id" integer, "source_type" varchar(255), "payment_method_id" integer) SQL (0.0ms) PRAGMA index_list("payments") SQL (0.2ms) DROP TABLE "payments" SQL (0.3ms) CREATE TABLE "payments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "created_at" datetime, "updated_at" datetime, "amount" decimal DEFAULT 0.0 NOT NULL, "source_id" integer, "source_type" varchar(255), "payment_method_id" integer)  SQL (0.0ms) PRAGMA index_list("altered_payments") SQL (0.1ms) DROP TABLE "altered_payments" SQL (0.2ms) ALTER TABLE "payments" ADD "state" varchar(255) SQL (0.4ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20100812162326') Migrating to CreateAddressKeysForOrder (20100813023502) SQL (0.6ms) ALTER TABLE "orders" ADD "bill_address_id" integer SQL (0.5ms) ALTER TABLE "orders" ADD "ship_address_id" integer SQL (0.7ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20100813023502') Migrating to PaymentTotalForOrders (20100813185745) SQL (0.7ms) ALTER TABLE "orders" ADD "payment_total" decimal(8,2) DEFAULT 0.0 SQL (1.0ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20100813185745') Migrating to ShippingMethodIdForOrders (20100816212146) SQL (1.0ms) ALTER TABLE "orders" ADD "shipping_method_id" integer SQL (1.4ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20100816212146') Migrating to AddShipmentAndPaymentState (20100817152723) SQL (0.7ms) ALTER TABLE "orders" ADD "shipment_state" varchar(255) SQL (0.4ms) ALTER TABLE "orders" ADD "payment_state" varchar(255) SQL (0.7ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20100817152723') Migrating to RefactorAdjustments (20100819170125) SQL (0.6ms) ALTER TABLE "adjustments" ADD "mandatory" boolean SQL (0.4ms) ALTER TABLE "adjustments" ADD "frozen" boolean SQL (0.2ms) CREATE TEMPORARY TABLE "altered_adjustments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "type" varchar(255), "amount" decimal, "description" varchar(255), "position" integer, "created_at" datetime, "updated_at" datetime, "source_id" integer, "adjustment_source_type" varchar(255), "mandatory" boolean, "frozen" boolean)  SQL (0.1ms) PRAGMA index_list("adjustments") SQL (0.0ms) PRAGMA index_info('index_adjustments_on_order_id') SQL (0.1ms) PRAGMA index_list("altered_adjustments") SQL (0.2ms) CREATE INDEX "temp_index_altered_adjustments_on_order_id" ON "altered_adjustments" ("order_id") SQL (0.3ms) DROP TABLE "adjustments" SQL (0.3ms) CREATE TABLE "adjustments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "type" varchar(255), "amount" decimal, "description" varchar(255), "position" integer, "created_at" datetime, "updated_at" datetime, "source_id" integer, "adjustment_source_type" varchar(255), "mandatory" boolean, "frozen" boolean)  SQL (0.1ms) PRAGMA index_list("altered_adjustments") SQL (0.0ms) PRAGMA index_info('temp_index_altered_adjustments_on_order_id') SQL (0.0ms) PRAGMA index_list("adjustments") SQL (0.2ms) CREATE INDEX "index_adjustments_on_order_id" ON "adjustments" ("order_id") SQL (0.1ms) DROP TABLE "altered_adjustments" SQL (0.2ms) CREATE TEMPORARY TABLE "altered_adjustments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "type" varchar(255), "amount" decimal, "description" varchar(255), "position" integer, "created_at" datetime, "updated_at" datetime, "source_id" integer, "source_type" varchar(255), "mandatory" boolean, "frozen" boolean)  SQL (0.0ms) PRAGMA index_list("adjustments") SQL (0.0ms) PRAGMA index_info('index_adjustments_on_order_id') SQL (0.0ms) PRAGMA index_list("altered_adjustments") SQL (0.2ms) CREATE INDEX "temp_index_altered_adjustments_on_order_id" ON "altered_adjustments" ("order_id") SQL (0.2ms) DROP TABLE "adjustments" SQL (0.2ms) CREATE TABLE "adjustments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "type" varchar(255), "amount" decimal, "description" varchar(255), "position" integer, "created_at" datetime, "updated_at" datetime, "source_id" integer, "source_type" varchar(255), "mandatory" boolean, "frozen" boolean)  SQL (0.0ms) PRAGMA index_list("altered_adjustments") SQL (0.0ms) PRAGMA index_info('temp_index_altered_adjustments_on_order_id') SQL (0.8ms) PRAGMA index_list("adjustments") SQL (0.2ms) CREATE INDEX "index_adjustments_on_order_id" ON "adjustments" ("order_id") SQL (0.1ms) DROP TABLE "altered_adjustments" SQL (0.2ms) ALTER TABLE "adjustments" ADD "originator_id" integer SQL (0.2ms) ALTER TABLE "adjustments" ADD "originator_type" varchar(255) SQL (0.2ms) CREATE TEMPORARY TABLE "altered_adjustments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "type" varchar(255), "amount" decimal, "description" varchar(255), "position" integer, "created_at" datetime, "updated_at" datetime, "source_id" integer, "source_type" varchar(255), "mandatory" boolean, "frozen" boolean, "originator_id" integer, "originator_type" varchar(255))  SQL (0.0ms) PRAGMA index_list("adjustments") SQL (0.0ms) PRAGMA index_info('index_adjustments_on_order_id') SQL (0.0ms) PRAGMA index_list("altered_adjustments") SQL (0.1ms) CREATE INDEX "temp_index_altered_adjustments_on_order_id" ON "altered_adjustments" ("order_id") SQL (0.2ms) DROP TABLE "adjustments" SQL (0.3ms) CREATE TABLE "adjustments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "amount" decimal, "description" varchar(255), "position" integer, "created_at" datetime, "updated_at" datetime, "source_id" integer, "source_type" varchar(255), "mandatory" boolean, "frozen" boolean, "originator_id" integer, "originator_type" varchar(255))  SQL (0.1ms) PRAGMA index_list("altered_adjustments") SQL (0.0ms) PRAGMA index_info('temp_index_altered_adjustments_on_order_id') SQL (0.1ms) PRAGMA index_list("adjustments") SQL (0.2ms) CREATE INDEX "index_adjustments_on_order_id" ON "adjustments" ("order_id") SQL (0.1ms) DROP TABLE "altered_adjustments" SQL (0.2ms) CREATE TEMPORARY TABLE "altered_adjustments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "amount" decimal, "label" varchar(255), "position" integer, "created_at" datetime, "updated_at" datetime, "source_id" integer, "source_type" varchar(255), "mandatory" boolean, "frozen" boolean, "originator_id" integer, "originator_type" varchar(255))  SQL (0.0ms) PRAGMA index_list("adjustments") SQL (0.0ms) PRAGMA index_info('index_adjustments_on_order_id') SQL (0.1ms) PRAGMA index_list("altered_adjustments") SQL (0.1ms) CREATE INDEX "temp_index_altered_adjustments_on_order_id" ON "altered_adjustments" ("order_id") SQL (0.2ms) DROP TABLE "adjustments" SQL (0.2ms) CREATE TABLE "adjustments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "amount" decimal, "label" varchar(255), "position" integer, "created_at" datetime, "updated_at" datetime, "source_id" integer, "source_type" varchar(255), "mandatory" boolean, "frozen" boolean, "originator_id" integer, "originator_type" varchar(255))  SQL (0.0ms) PRAGMA index_list("altered_adjustments") SQL (0.0ms) PRAGMA index_info('temp_index_altered_adjustments_on_order_id') SQL (0.0ms) PRAGMA index_list("adjustments") SQL (0.1ms) CREATE INDEX "index_adjustments_on_order_id" ON "adjustments" ("order_id") SQL (0.1ms) DROP TABLE "altered_adjustments" SQL (0.2ms) CREATE TEMPORARY TABLE "altered_adjustments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "amount" decimal, "label" varchar(255), "position" integer, "created_at" datetime, "updated_at" datetime, "source_id" integer, "source_type" varchar(255), "mandatory" boolean, "frozen" boolean, "originator_id" integer, "originator_type" varchar(255))  SQL (0.0ms) PRAGMA index_list("adjustments") SQL (0.0ms) PRAGMA index_info('index_adjustments_on_order_id') SQL (0.0ms) PRAGMA index_list("altered_adjustments") SQL (0.1ms) CREATE INDEX "temp_index_altered_adjustments_on_order_id" ON "altered_adjustments" ("order_id") SQL (0.2ms) DROP TABLE "adjustments" SQL (0.2ms) CREATE TABLE "adjustments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "amount" decimal, "label" varchar(255), "created_at" datetime, "updated_at" datetime, "source_id" integer, "source_type" varchar(255), "mandatory" boolean, "frozen" boolean, "originator_id" integer, "originator_type" varchar(255))  SQL (0.0ms) PRAGMA index_list("altered_adjustments") SQL (0.0ms) PRAGMA index_info('temp_index_altered_adjustments_on_order_id') SQL (0.1ms) PRAGMA index_list("adjustments") SQL (0.2ms) CREATE INDEX "index_adjustments_on_order_id" ON "adjustments" ("order_id") SQL (0.1ms) DROP TABLE "altered_adjustments" SQL (0.4ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20100819170125') Migrating to ResponseCodeAndAvsResponseForPayments (20100820135707) SQL (0.6ms) ALTER TABLE "payments" ADD "response_code" varchar(255) SQL (0.5ms) ALTER TABLE "payments" ADD "avs_response" varchar(255) SQL (0.7ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20100820135707') Migrating to ChangeGuestFlagToAnonymous (20100901171814) SQL (0.3ms) CREATE TEMPORARY TABLE "altered_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255), "crypted_password" varchar(128), "salt" varchar(128), "remember_token" varchar(255), "remember_token_expires_at" varchar(255), "created_at" datetime, "updated_at" datetime, "persistence_token" varchar(255), "single_access_token" varchar(255), "perishable_token" varchar(255), "login_count" integer DEFAULT 0 NOT NULL, "failed_login_count" integer DEFAULT 0 NOT NULL, "last_request_at" datetime, "current_login_at" datetime, "last_login_at" datetime, "current_login_ip" varchar(255), "last_login_ip" varchar(255), "login" varchar(255), "ship_address_id" integer, "bill_address_id" integer, "openid_identifier" varchar(255), "anonymous" boolean)  SQL (0.1ms) PRAGMA index_list("users") SQL (0.0ms) PRAGMA index_info('index_users_on_persistence_token') SQL (0.0ms) PRAGMA index_info('index_users_on_openid_identifier') SQL (0.0ms) PRAGMA index_list("altered_users") SQL (0.1ms) CREATE INDEX "temp_index_altered_users_on_persistence_token" ON "altered_users" ("persistence_token") SQL (0.1ms) PRAGMA index_list("altered_users") SQL (0.0ms) PRAGMA index_info('temp_index_altered_users_on_persistence_token') SQL (0.1ms) CREATE INDEX "temp_index_altered_users_on_openid_identifier" ON "altered_users" ("openid_identifier") SQL (0.3ms) DROP TABLE "users" SQL (0.3ms) CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255), "crypted_password" varchar(128), "salt" varchar(128), "remember_token" varchar(255), "remember_token_expires_at" varchar(255), "created_at" datetime, "updated_at" datetime, "persistence_token" varchar(255), "single_access_token" varchar(255), "perishable_token" varchar(255), "login_count" integer DEFAULT 0 NOT NULL, "failed_login_count" integer DEFAULT 0 NOT NULL, "last_request_at" datetime, "current_login_at" datetime, "last_login_at" datetime, "current_login_ip" varchar(255), "last_login_ip" varchar(255), "login" varchar(255), "ship_address_id" integer, "bill_address_id" integer, "openid_identifier" varchar(255), "anonymous" boolean)  SQL (0.1ms) PRAGMA index_list("altered_users") SQL (0.0ms) PRAGMA index_info('temp_index_altered_users_on_openid_identifier') SQL (0.0ms) PRAGMA index_info('temp_index_altered_users_on_persistence_token') SQL (1.0ms) PRAGMA index_list("users") SQL (0.2ms) CREATE INDEX "index_users_on_openid_identifier" ON "users" ("openid_identifier") SQL (0.1ms) PRAGMA index_list("users") SQL (0.0ms) PRAGMA index_info('index_users_on_openid_identifier') SQL (0.2ms) CREATE INDEX "index_users_on_persistence_token" ON "users" ("persistence_token") SQL (0.2ms) DROP TABLE "altered_users" SQL (0.4ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20100901171814') Migrating to EmailForOrders (20100903203949) SQL (0.6ms) ALTER TABLE "orders" ADD "email" varchar(255) SQL (0.7ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ('20100903203949') Migrating to CreateMailMethods (20100923162011) SQL (0.5ms) CREATE TABLE "mail_methods" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "environment" varchar(255), "active" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime) SQL (0.9ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ('20100923162011') Migrating to RenameFrozenToLocked (20100929151905) SQL (0.3ms) CREATE TEMPORARY TABLE "altered_adjustments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "amount" decimal, "label" varchar(255), "created_at" datetime, "updated_at" datetime, "source_id" integer, "source_type" varchar(255), "mandatory" boolean, "locked" boolean, "originator_id" integer, "originator_type" varchar(255))  SQL (0.1ms) PRAGMA index_list("adjustments") SQL (0.0ms) PRAGMA index_info('index_adjustments_on_order_id') SQL (0.0ms) PRAGMA index_list("altered_adjustments") SQL (0.2ms) CREATE INDEX "temp_index_altered_adjustments_on_order_id" ON "altered_adjustments" ("order_id") SQL (0.2ms) DROP TABLE "adjustments" SQL (0.2ms) CREATE TABLE "adjustments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "amount" decimal, "label" varchar(255), "created_at" datetime, "updated_at" datetime, "source_id" integer, "source_type" varchar(255), "mandatory" boolean, "locked" boolean, "originator_id" integer, "originator_type" varchar(255))  SQL (0.0ms) PRAGMA index_list("altered_adjustments") SQL (0.0ms) PRAGMA index_info('temp_index_altered_adjustments_on_order_id') SQL (0.0ms) PRAGMA index_list("adjustments") SQL (0.1ms) CREATE INDEX "index_adjustments_on_order_id" ON "adjustments" ("order_id") SQL (0.1ms) DROP TABLE "altered_adjustments" SQL (0.4ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20100929151905') Migrating to MoveSpecialInstructionsToOrders (20101008190536) SQL (0.6ms) ALTER TABLE "orders" ADD "special_instructions" text SQL (0.2ms) update orders set special_instructions = (select special_instructions from checkouts where order_id = orders.id) SQL (0.7ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20101008190536') Migrating to CreateLogEntries (20101026184700) SQL (0.5ms) CREATE TABLE "log_entries" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "source_id" integer, "source_type" varchar(255), "details" text, "created_at" datetime, "updated_at" datetime)  SQL (0.7ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20101026184700') Migrating to MigrateTransactionsToPaymentState (20101026184714) Transaction Load (0.3ms) select * from transactions group by payment_id having count(payment_id) = 1 and txn_type = 1 Transaction Load (0.2ms) select * from transactions where txn_type=4 Transaction Load (0.1ms) select * from transactions where txn_type = 2 Transaction Load (0.1ms) select * from transactions where txn_type = 3 Transaction Load (0.2ms) select * from transactions where txn_type = 5 SQL (0.8ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.3ms) INSERT INTO "schema_migrations" ("version") VALUES ('20101026184714') Migrating to DeleteInProgressOrders (20101026184746) SQL (1.0ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  AREL (0.1ms) DELETE FROM "orders" WHERE "orders"."state" = 'in_progress' SQL (0.1ms) delete from adjustments where order_id not in (select id from orders) SQL (0.1ms) delete from checkouts where order_id not in (select id from orders) SQL (0.1ms) delete from shipments where order_id not in (select id from orders) SQL (0.1ms) delete from payments where order_id not in (select id from orders) SQL (0.1ms) delete from line_items where order_id not in (select id from orders) SQL (0.1ms) delete from inventory_units where order_id not in (select id from orders) SQL (0.8ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ('20101026184746') Migrating to MigrateCheckoutToOrders (20101026184808) Order Load (0.3ms) SELECT "orders".* FROM "orders" WHERE ("orders"."id" >= 0) ORDER BY "orders"."id" ASC LIMIT 1000 SQL (0.7ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ('20101026184808') Migrating to MigrateAdjustments (20101026184833) SQL (0.2ms) update adjustments set amount = 0.0 where amount is null SQL (0.1ms) update adjustments set mandatory = 'true', locked = 'true' SQL (0.8ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ('20101026184833') Migrating to RemoveShippedState (20101026184855) Order Load (0.4ms) SELECT "orders".* FROM "orders" WHERE "orders"."state" = 'shipped' SQL (1.0ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ('20101026184855') Migrating to PreventNilPaymentTotal (20101026184916) SQL (0.2ms) update orders set payment_total = 0.0 where payment_total is null SQL (0.7ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ('20101026184916') Migrating to PreventNilEmail (20101026184932) SQL (0.2ms) update orders set email = 'guest@example.com' where email is null SQL (0.1ms) update orders set email = 'guest@example.com' where email = '' SQL (1.0ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ('20101026184932') Migrating to GenerateAnonymousUsers (20101026184959) Order Load (0.3ms) SELECT "orders".* FROM "orders" WHERE "orders"."user_id" IS NULL SQL (1.0ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20101026184959') Migrating to UpdateOrderState (20101026185022) Order Load (0.4ms) SELECT "orders".* FROM "orders" SQL (0.8ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ('20101026185022') Migrating to CleanupLegacyTables (20101026192225) SQL (0.5ms) DROP TABLE "checkouts" SQL (0.3ms) DROP TABLE "transactions" SQL (0.4ms) DROP TABLE "open_id_authentication_associations" SQL (0.2ms) DROP TABLE "open_id_authentication_nonces" SQL (0.8ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20101026192225') Migrating to RemoveNumberAndCvvFromCredicard (20101028151745) SQL (0.3ms) CREATE TEMPORARY TABLE "altered_creditcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "number" text, "month" varchar(255), "year" varchar(255), "verification_value" text, "cc_type" varchar(255), "last_digits" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "created_at" datetime, "updated_at" datetime, "start_month" varchar(255), "start_year" varchar(255), "issue_number" varchar(255), "address_id" integer, "gateway_customer_profile_id" varchar(255), "gateway_payment_profile_id" varchar(255)) SQL (0.0ms) PRAGMA index_list("creditcards") SQL (0.3ms) DROP TABLE "creditcards" SQL (0.3ms) CREATE TABLE "creditcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "month" varchar(255), "year" varchar(255), "verification_value" text, "cc_type" varchar(255), "last_digits" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "created_at" datetime, "updated_at" datetime, "start_month" varchar(255), "start_year" varchar(255), "issue_number" varchar(255), "address_id" integer, "gateway_customer_profile_id" varchar(255), "gateway_payment_profile_id" varchar(255))  SQL (0.0ms) PRAGMA index_list("altered_creditcards") SQL (0.1ms) DROP TABLE "altered_creditcards" SQL (0.3ms) CREATE TEMPORARY TABLE "altered_creditcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "month" varchar(255), "year" varchar(255), "verification_value" text, "cc_type" varchar(255), "last_digits" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "created_at" datetime, "updated_at" datetime, "start_month" varchar(255), "start_year" varchar(255), "issue_number" varchar(255), "address_id" integer, "gateway_customer_profile_id" varchar(255), "gateway_payment_profile_id" varchar(255)) SQL (0.0ms) PRAGMA index_list("creditcards") SQL (0.2ms) DROP TABLE "creditcards" SQL (0.3ms) CREATE TABLE "creditcards" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "month" varchar(255), "year" varchar(255), "cc_type" varchar(255), "last_digits" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "created_at" datetime, "updated_at" datetime, "start_month" varchar(255), "start_year" varchar(255), "issue_number" varchar(255), "address_id" integer, "gateway_customer_profile_id" varchar(255), "gateway_payment_profile_id" varchar(255))  SQL (0.0ms) PRAGMA index_list("altered_creditcards") SQL (0.1ms) DROP TABLE "altered_creditcards" SQL (0.4ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20101028151745') Migrating to DropAnonymousFieldForUser (20101103212716) SQL (0.3ms) CREATE TEMPORARY TABLE "altered_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255), "crypted_password" varchar(128), "salt" varchar(128), "remember_token" varchar(255), "remember_token_expires_at" varchar(255), "created_at" datetime, "updated_at" datetime, "persistence_token" varchar(255), "single_access_token" varchar(255), "perishable_token" varchar(255), "login_count" integer DEFAULT 0 NOT NULL, "failed_login_count" integer DEFAULT 0 NOT NULL, "last_request_at" datetime, "current_login_at" datetime, "last_login_at" datetime, "current_login_ip" varchar(255), "last_login_ip" varchar(255), "login" varchar(255), "ship_address_id" integer, "bill_address_id" integer, "openid_identifier" varchar(255), "anonymous" boolean) SQL (0.1ms) PRAGMA index_list("users") SQL (0.0ms) PRAGMA index_info('index_users_on_persistence_token') SQL (0.0ms) PRAGMA index_info('index_users_on_openid_identifier') SQL (0.0ms) PRAGMA index_list("altered_users") SQL (0.1ms) CREATE INDEX "temp_index_altered_users_on_persistence_token" ON "altered_users" ("persistence_token") SQL (0.9ms) PRAGMA index_list("altered_users") SQL (0.0ms) PRAGMA index_info('temp_index_altered_users_on_persistence_token') SQL (0.1ms) CREATE INDEX "temp_index_altered_users_on_openid_identifier" ON "altered_users" ("openid_identifier") SQL (0.4ms) DROP TABLE "users" SQL (0.3ms) CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255), "crypted_password" varchar(128), "salt" varchar(128), "remember_token" varchar(255), "remember_token_expires_at" varchar(255), "created_at" datetime, "updated_at" datetime, "persistence_token" varchar(255), "single_access_token" varchar(255), "perishable_token" varchar(255), "login_count" integer DEFAULT 0 NOT NULL, "failed_login_count" integer DEFAULT 0 NOT NULL, "last_request_at" datetime, "current_login_at" datetime, "last_login_at" datetime, "current_login_ip" varchar(255), "last_login_ip" varchar(255), "login" varchar(255), "ship_address_id" integer, "bill_address_id" integer, "openid_identifier" varchar(255)) SQL (0.1ms) PRAGMA index_list("altered_users") SQL (0.0ms) PRAGMA index_info('temp_index_altered_users_on_openid_identifier') SQL (0.0ms) PRAGMA index_info('temp_index_altered_users_on_persistence_token') SQL (0.8ms) PRAGMA index_list("users") SQL (0.2ms) CREATE INDEX "index_users_on_openid_identifier" ON "users" ("openid_identifier") SQL (0.1ms) PRAGMA index_list("users") SQL (0.0ms) PRAGMA index_info('index_users_on_openid_identifier') SQL (0.2ms) CREATE INDEX "index_users_on_persistence_token" ON "users" ("persistence_token") SQL (0.2ms) DROP TABLE "altered_users" SQL (0.4ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20101103212716') Migrating to RenamedRmaCancelledState (20101111133551) SQL (0.5ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' ReturnAuthorization Load (0.1ms) SELECT "return_authorizations".* FROM "return_authorizations" WHERE "return_authorizations"."state" = 'cancelled' SQL (0.7ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20101111133551') Migrating to FixProblematicIndexNames (20101117031806) SQL (0.1ms) PRAGMA index_list("preferences") SQL (0.1ms) PRAGMA index_list("preferences") SQL (0.5ms) CREATE UNIQUE INDEX "ix_prefs_on_owner_attr_pref" ON "preferences" ("owner_id", "owner_type", "name", "group_id", "group_type") SQL (0.7ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20101117031806') Migrating to AddPositionToVariants (20101223215658) SQL (0.6ms) ALTER TABLE "variants" ADD "position" integer SQL (0.7ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20101223215658') Migrating to AddNextStateToStateEvents (20110110130847) SQL (0.4ms) ALTER TABLE "state_events" ADD "next_state" varchar(255) SQL (0.4ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20110110130847') Migrating to AddPositionToOptionTypes (20110111122537) SQL (0.6ms) ALTER TABLE "option_types" ADD "position" integer DEFAULT 0 NOT NULL SQL (0.9ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms) INSERT INTO "schema_migrations" ("version") VALUES ('20110111122537') Migrating to RemoveTrailingSlashesInTaxonPermalinks (20110314192118) SQL (0.8ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' Taxon Load (0.3ms) SELECT "taxons".* FROM "taxons" WHERE ("taxons"."id" >= 0) ORDER BY "taxons"."id" ASC LIMIT 1000 SQL (0.7ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.2ms) INSERT INTO "schema_migrations" ("version") VALUES ('20110314192118') SQL (1.1ms) select sqlite_version(*) SQL (0.4ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.4ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.5ms) SELECT "schema_migrations"."version" FROM "schema_migrations" SQL (0.4ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.1ms) PRAGMA index_list("addresses") SQL (0.0ms) PRAGMA index_info('index_addresses_on_lastname') SQL (0.0ms) PRAGMA index_info('index_addresses_on_firstname') SQL (0.3ms) PRAGMA index_list("adjustments") SQL (0.0ms) PRAGMA index_info('index_adjustments_on_order_id') SQL (0.1ms) PRAGMA index_list("assets") SQL (0.0ms) PRAGMA index_info('index_assets_on_viewable_type_and_type') SQL (0.0ms) PRAGMA index_info('index_assets_on_viewable_id') SQL (0.0ms) PRAGMA index_list("calculators") SQL (0.0ms) PRAGMA index_list("configurations") SQL (0.0ms) PRAGMA index_info('index_configurations_on_name_and_type') SQL (0.0ms) PRAGMA index_list("countries") SQL (0.0ms) PRAGMA index_list("coupons") SQL (0.0ms) PRAGMA index_list("creditcards") SQL (0.0ms) PRAGMA index_list("gateways") SQL (0.1ms) PRAGMA index_list("inventory_units") SQL (0.0ms) PRAGMA index_info('index_inventory_units_on_shipment_id') SQL (0.0ms) PRAGMA index_info('index_inventory_units_on_order_id') SQL (0.0ms) PRAGMA index_info('index_inventory_units_on_variant_id') SQL (0.1ms) PRAGMA index_list("line_items") SQL (0.0ms) PRAGMA index_info('index_line_items_on_variant_id') SQL (0.0ms) PRAGMA index_info('index_line_items_on_order_id') SQL (0.0ms) PRAGMA index_list("log_entries") SQL (0.0ms) PRAGMA index_list("mail_methods") SQL (0.0ms) PRAGMA index_list("option_types") SQL (0.0ms) PRAGMA index_list("option_types_prototypes") SQL (0.0ms) PRAGMA index_list("option_values") SQL (0.1ms) PRAGMA index_list("option_values_variants") SQL (0.0ms) PRAGMA index_info('index_option_values_variants_on_variant_id_and_option_value_id') SQL (0.0ms) PRAGMA index_info('index_option_values_variants_on_variant_id') SQL (0.1ms) PRAGMA index_list("orders") SQL (0.0ms) PRAGMA index_info('index_orders_on_number') SQL (0.0ms) PRAGMA index_list("payment_methods") SQL (0.0ms) PRAGMA index_list("payments") SQL (0.0ms) PRAGMA index_list("preferences") SQL (0.1ms) PRAGMA index_info('ix_prefs_on_owner_attr_pref') SQL (0.1ms) PRAGMA index_list("product_groups") SQL (0.0ms) PRAGMA index_info('index_product_groups_on_permalink') SQL (0.0ms) PRAGMA index_info('index_product_groups_on_name') SQL (0.0ms) PRAGMA index_list("product_groups_products") SQL (0.0ms) PRAGMA index_list("product_option_types") SQL (0.0ms) PRAGMA index_list("product_properties") SQL (0.0ms) PRAGMA index_info('index_product_properties_on_product_id') SQL (0.1ms) PRAGMA index_list("product_scopes") SQL (0.0ms) PRAGMA index_info('index_product_scopes_on_product_group_id') SQL (0.0ms) PRAGMA index_info('index_product_scopes_on_name') SQL (0.1ms) PRAGMA index_list("products") SQL (0.0ms) PRAGMA index_info('index_products_on_permalink') SQL (0.0ms) PRAGMA index_info('index_products_on_name') SQL (0.0ms) PRAGMA index_info('index_products_on_deleted_at') SQL (0.0ms) PRAGMA index_info('index_products_on_available_on') SQL (0.0ms) PRAGMA index_list("products_taxons") SQL (0.0ms) PRAGMA index_info('index_products_taxons_on_taxon_id') SQL (0.0ms) PRAGMA index_info('index_products_taxons_on_product_id') SQL (0.0ms) PRAGMA index_list("properties") SQL (0.0ms) PRAGMA index_list("properties_prototypes") SQL (0.0ms) PRAGMA index_list("prototypes") SQL (0.0ms) PRAGMA index_list("return_authorizations") SQL (0.0ms) PRAGMA index_list("roles") SQL (0.1ms) PRAGMA index_list("roles_users") SQL (0.0ms) PRAGMA index_info('index_roles_users_on_user_id') SQL (0.0ms) PRAGMA index_info('index_roles_users_on_role_id') SQL (0.1ms) PRAGMA index_list("shipments") SQL (0.0ms) PRAGMA index_info('index_shipments_on_number') SQL (0.0ms) PRAGMA index_list("shipping_categories") SQL (0.0ms) PRAGMA index_list("shipping_methods") SQL (0.0ms) PRAGMA index_list("state_events") SQL (0.0ms) PRAGMA index_list("states") SQL (0.0ms) PRAGMA index_list("tax_categories") SQL (0.0ms) PRAGMA index_list("tax_rates") SQL (0.0ms) PRAGMA index_list("taxonomies") SQL (0.1ms) PRAGMA index_list("taxons") SQL (0.0ms) PRAGMA index_info('index_taxons_on_taxonomy_id') SQL (0.0ms) PRAGMA index_info('index_taxons_on_parent_id') SQL (0.0ms) PRAGMA index_info('index_taxons_on_permalink') SQL (0.0ms) PRAGMA index_list("trackers") SQL (0.1ms) PRAGMA index_list("users") SQL (0.0ms) PRAGMA index_info('index_users_on_persistence_token') SQL (0.0ms) PRAGMA index_info('index_users_on_openid_identifier') SQL (0.0ms) PRAGMA index_list("variants") SQL (0.0ms) PRAGMA index_info('index_variants_on_product_id') SQL (0.0ms) PRAGMA index_list("zone_members") SQL (0.0ms) PRAGMA index_list("zones") SQL (0.4ms) SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence' SQL (0.4ms)  SELECT name FROM sqlite_master WHERE type = 'table' AND NOT name = 'sqlite_sequence'  SQL (0.5ms) SELECT "schema_migrations"."version" FROM "schema_migrations"