(1.6ms)  CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) 
   (1.2ms)  CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
  ActiveRecord::SchemaMigration Load (0.1ms)  SELECT "schema_migrations".* FROM "schema_migrations"
  ActiveRecord::SchemaMigration Load (0.1ms)  SELECT "schema_migrations".* FROM "schema_migrations"
Migrating to CreateProductCategories (20130926094549)
   (0.0ms)  begin transaction
   (0.5ms)  CREATE TABLE "shoppe_product_categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "permalink" varchar(255), "description" text, "created_at" datetime, "updated_at" datetime) 
  SQL (1.4ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130926094549"]]
   (2.2ms)  commit transaction
Migrating to CreateProducts (20130926094551)
   (0.1ms)  begin transaction
   (0.4ms)  CREATE TABLE "shoppe_products" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "product_category_id" integer, "title" varchar(255), "sku" varchar(255), "permalink" varchar(255), "description" text, "short_description" text, "active" boolean DEFAULT 't', "weight" decimal(8,3) DEFAULT 0.0, "price" decimal(8,2) DEFAULT 0.0, "vat_rate" decimal(8,2) DEFAULT 0.0, "stock" integer DEFAULT 0, "created_at" datetime, "updated_at" datetime) 
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130926094551"]]
   (1.0ms)  commit transaction
Migrating to CreateOrders (20130926094647)
   (0.1ms)  begin transaction
   (0.3ms)  CREATE TABLE "shoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "approved_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime) 
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130926094647"]]
   (0.9ms)  commit transaction
Migrating to CreateOrderItems (20130926094654)
   (0.1ms)  begin transaction
   (0.3ms)  CREATE TABLE "shoppe_order_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "parent_type" varchar(255), "parent_id" integer, "quantity" integer DEFAULT 1, "unit_price" decimal(8,2), "vat_amount" decimal(8,2), "vat_rate" decimal(8,2), "weight" decimal(8,3) DEFAULT 0, "created_at" datetime, "updated_at" datetime) 
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130926094654"]]
   (0.9ms)  commit transaction
Migrating to CreateImages (20130926104450)
   (0.1ms)  begin transaction
   (0.3ms)  CREATE TABLE "shoppe_attachments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "parent_type" varchar(255), "token" varchar(255), "role" varchar(255), "file_name" varchar(255), "file_type" varchar(255), "data" blob(10485760), "created_at" datetime, "updated_at" datetime) 
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130926104450"]]
   (0.8ms)  commit transaction
Migrating to CreateUsers (20130926151718)
   (0.1ms)  begin transaction
   (0.4ms)  CREATE TABLE "shoppe_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "first_name" varchar(255), "last_name" varchar(255), "email_address" varchar(255), "password_digest" varchar(255), "created_at" datetime, "updated_at" datetime) 
  SQL (0.2ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130926151718"]]
   (1.1ms)  commit transaction
Migrating to AddCardTokenToOrders (20130927113134)
   (0.1ms)  begin transaction
   (0.8ms)  ALTER TABLE "shoppe_orders" ADD "stripe_customer_token" varchar(255)
   (0.1ms)  ALTER TABLE "shoppe_orders" ADD "stripe_payment_token" varchar(255)
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130927113134"]]
   (1.0ms)  commit transaction
Migrating to CreateDeliveryServices (20130927130022)
   (0.1ms)  begin transaction
   (0.3ms)  CREATE TABLE "shoppe_delivery_services" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "code" varchar(255), "default" boolean DEFAULT 't', "min_weight" decimal(8,3), "max_weight" decimal(8,3), "price" decimal(8,2) DEFAULT 0, "vat_rate" decimal(8,2), "active" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime) 
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130927130022"]]
   (1.1ms)  commit transaction
Migrating to AddDeliveryServiceToOrder (20130927132143)
   (0.1ms)  begin transaction
   (0.3ms)  ALTER TABLE "shoppe_orders" ADD "delivery_service_id" integer
   (0.1ms)  ALTER TABLE "shoppe_orders" ADD "delivery_price" decimal(8,2) DEFAULT 0.0
   (0.1ms)  ALTER TABLE "shoppe_orders" ADD "delivery_vat_rate" decimal(8,2) DEFAULT 0.0
   (0.1ms)  ALTER TABLE "shoppe_orders" ADD "delivery_vat_amount" decimal(8,2) DEFAULT 0.0
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130927132143"]]
   (0.9ms)  commit transaction
Migrating to AddPaymentDateToOrders (20130927150025)
   (0.1ms)  begin transaction
   (0.3ms)  ALTER TABLE "shoppe_orders" ADD "paid_at" datetime
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130927150025"]]
   (0.8ms)  commit transaction
Migrating to RenameStripePaymentToken (20130928111819)
   (0.1ms)  begin transaction
   (0.5ms)  CREATE TEMPORARY TABLE "ashoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "approved_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "stripe_customer_token" varchar(255), "payment_reference" varchar(255), "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_vat_rate" decimal(8,2) DEFAULT 0.0, "delivery_vat_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime) 
   (0.1ms)  SELECT * FROM "shoppe_orders"
   (0.4ms)  DROP TABLE "shoppe_orders"
   (0.2ms)  CREATE TABLE "shoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "approved_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "stripe_customer_token" varchar(255), "payment_reference" varchar(255), "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_vat_rate" decimal(8,2) DEFAULT 0.0, "delivery_vat_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime) 
   (0.1ms)  SELECT * FROM "ashoppe_orders"
   (0.3ms)  DROP TABLE "ashoppe_orders"
   (0.2ms)  ALTER TABLE "shoppe_orders" ADD "payment_method" varchar(255)
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130928111819"]]
   (1.1ms)  commit transaction
Migrating to AddApporovedUsers (20130928131502)
   (0.1ms)  begin transaction
   (0.5ms)  ALTER TABLE "shoppe_orders" ADD "approved_by" integer
   (0.2ms)  ALTER TABLE "shoppe_orders" ADD "shipped_by" integer
   (0.2ms)  ALTER TABLE "shoppe_orders" ADD "consignment_number" varchar(255)
  SQL (0.2ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130928131502"]]
   (0.8ms)  commit transaction
Migrating to AddCourierDetailsToShippingMethods (20130928134518)
   (0.1ms)  begin transaction
   (0.4ms)  ALTER TABLE "shoppe_delivery_services" ADD "courier" varchar(255)
   (0.2ms)  ALTER TABLE "shoppe_delivery_services" ADD "tracking_url" varchar(255)
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130928134518"]]
   (1.0ms)  commit transaction
Migrating to AddRejectionToOrders (20130928173818)
   (0.1ms)  begin transaction
   (0.5ms)  ALTER TABLE "shoppe_orders" ADD "rejected_at" datetime
   (0.2ms)  ALTER TABLE "shoppe_orders" ADD "rejected_by" integer
  SQL (0.2ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130928173818"]]
   (0.9ms)  commit transaction
Migrating to SortOutOrdersForGateways (20130928180041)
   (0.1ms)  begin transaction
   (0.2ms)  CREATE TEMPORARY TABLE "ashoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "approved_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "stripe_customer_token" varchar(255), "payment_reference" varchar(255), "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_vat_rate" decimal(8,2) DEFAULT 0.0, "delivery_vat_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "payment_method" varchar(255), "approved_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer) 
   (0.1ms)  SELECT * FROM "shoppe_orders"
   (0.2ms)  DROP TABLE "shoppe_orders"
   (0.1ms)  CREATE TABLE "shoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "approved_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "payment_reference" varchar(255), "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_vat_rate" decimal(8,2) DEFAULT 0.0, "delivery_vat_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "payment_method" varchar(255), "approved_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer) 
   (0.1ms)  SELECT * FROM "ashoppe_orders"
   (0.1ms)  DROP TABLE "ashoppe_orders"
   (0.1ms)  CREATE TEMPORARY TABLE "ashoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "approved_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "payment_reference" varchar(255), "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_vat_rate" decimal(8,2) DEFAULT 0.0, "delivery_vat_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "payment_method" varchar(255), "approved_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer) 
   (0.1ms)  SELECT * FROM "shoppe_orders"
   (0.4ms)  DROP TABLE "shoppe_orders"
   (0.2ms)  CREATE TABLE "shoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "approved_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_vat_rate" decimal(8,2) DEFAULT 0.0, "delivery_vat_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "payment_method" varchar(255), "approved_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer) 
   (0.1ms)  SELECT * FROM "ashoppe_orders"
   (0.2ms)  DROP TABLE "ashoppe_orders"
   (0.2ms)  CREATE TEMPORARY TABLE "ashoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "approved_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_vat_rate" decimal(8,2) DEFAULT 0.0, "delivery_vat_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "payment_method" varchar(255), "approved_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer) 
   (0.1ms)  SELECT * FROM "shoppe_orders"
   (0.1ms)  DROP TABLE "shoppe_orders"
   (0.2ms)  CREATE TABLE "shoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "approved_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_vat_rate" decimal(8,2) DEFAULT 0.0, "delivery_vat_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "approved_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer) 
   (0.1ms)  SELECT * FROM "ashoppe_orders"
   (0.1ms)  DROP TABLE "ashoppe_orders"
  SQL (0.2ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130928180041"]]
   (0.9ms)  commit transaction
Migrating to CreateNiftyKeyValueStoreTable (20130928185655)
   (0.1ms)  begin transaction
   (0.3ms)  CREATE TABLE "shoppe_key_value_store" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "parent_type" varchar(255), "group" varchar(255), "name" varchar(255), "value" varchar(255)) 
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130928185655"]]
   (0.8ms)  commit transaction
Migrating to AddPaymentGatewayToOrders (20130928193023)
   (0.1ms)  begin transaction
   (0.4ms)  ALTER TABLE "shoppe_orders" ADD "payment_gateway_module" varchar(255)
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130928193023"]]
   (1.0ms)  commit transaction
Migrating to UpdateDatabaseColumnsForAccepted (20130928201257)
   (0.1ms)  begin transaction
   (0.3ms)  CREATE TEMPORARY TABLE "ashoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_vat_rate" decimal(8,2) DEFAULT 0.0, "delivery_vat_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "approved_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "payment_gateway_module" varchar(255)) 
   (0.2ms)  SELECT * FROM "shoppe_orders"
   (0.3ms)  DROP TABLE "shoppe_orders"
   (0.2ms)  CREATE TABLE "shoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_vat_rate" decimal(8,2) DEFAULT 0.0, "delivery_vat_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "approved_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "payment_gateway_module" varchar(255)) 
   (0.1ms)  SELECT * FROM "ashoppe_orders"
   (0.1ms)  DROP TABLE "ashoppe_orders"
   (0.2ms)  CREATE TEMPORARY TABLE "ashoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_vat_rate" decimal(8,2) DEFAULT 0.0, "delivery_vat_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "accepted_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "payment_gateway_module" varchar(255)) 
   (0.1ms)  SELECT * FROM "shoppe_orders"
   (0.3ms)  DROP TABLE "shoppe_orders"
   (0.3ms)  CREATE TABLE "shoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_vat_rate" decimal(8,2) DEFAULT 0.0, "delivery_vat_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "accepted_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "payment_gateway_module" varchar(255)) 
   (0.2ms)  SELECT * FROM "ashoppe_orders"
   (0.2ms)  DROP TABLE "ashoppe_orders"
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130928201257"]]
   (1.3ms)  commit transaction
Migrating to AddIpAddressToOrders (20130929151744)
   (0.1ms)  begin transaction
   (0.4ms)  ALTER TABLE "shoppe_orders" ADD "ip_address" varchar(255)
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130929151744"]]
   (0.9ms)  commit transaction
Migrating to ChangeOrderItemsToBeNonPolymorphic (20130929203421)
   (0.1ms)  begin transaction
   (0.2ms)  CREATE TEMPORARY TABLE "ashoppe_order_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "parent_type" varchar(255), "product_id" integer, "quantity" integer DEFAULT 1, "unit_price" decimal(8,2), "vat_amount" decimal(8,2), "vat_rate" decimal(8,2), "weight" decimal(8,3) DEFAULT 0.0, "created_at" datetime, "updated_at" datetime) 
   (0.1ms)  SELECT * FROM "shoppe_order_items"
   (0.3ms)  DROP TABLE "shoppe_order_items"
   (0.1ms)  CREATE TABLE "shoppe_order_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "parent_type" varchar(255), "product_id" integer, "quantity" integer DEFAULT 1, "unit_price" decimal(8,2), "vat_amount" decimal(8,2), "vat_rate" decimal(8,2), "weight" decimal(8,3) DEFAULT 0.0, "created_at" datetime, "updated_at" datetime) 
   (0.1ms)  SELECT * FROM "ashoppe_order_items"
   (0.1ms)  DROP TABLE "ashoppe_order_items"
   (0.2ms)  CREATE TEMPORARY TABLE "ashoppe_order_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "parent_type" varchar(255), "product_id" integer, "quantity" integer DEFAULT 1, "unit_price" decimal(8,2), "vat_amount" decimal(8,2), "vat_rate" decimal(8,2), "weight" decimal(8,3) DEFAULT 0.0, "created_at" datetime, "updated_at" datetime) 
   (0.1ms)  SELECT * FROM "shoppe_order_items"
   (0.2ms)  DROP TABLE "shoppe_order_items"
   (0.2ms)  CREATE TABLE "shoppe_order_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "product_id" integer, "quantity" integer DEFAULT 1, "unit_price" decimal(8,2), "vat_amount" decimal(8,2), "vat_rate" decimal(8,2), "weight" decimal(8,3) DEFAULT 0.0, "created_at" datetime, "updated_at" datetime) 
   (0.1ms)  SELECT * FROM "ashoppe_order_items"
   (0.1ms)  DROP TABLE "ashoppe_order_items"
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130929203421"]]
   (0.7ms)  commit transaction
Migrating to AddFeaturedBooleanToProducts (20130930181344)
   (0.1ms)  begin transaction
   (0.3ms)  ALTER TABLE "shoppe_products" ADD "featured" boolean DEFAULT 'f'
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130930181344"]]
   (0.6ms)  commit transaction
Migrating to RenameVatToTax (20131002154122)
   (0.1ms)  begin transaction
   (0.2ms)  CREATE TEMPORARY TABLE "ashoppe_products" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "product_category_id" integer, "title" varchar(255), "sku" varchar(255), "permalink" varchar(255), "description" text, "short_description" text, "active" boolean DEFAULT 't', "weight" decimal(8,3) DEFAULT 0.0, "price" decimal(8,2) DEFAULT 0.0, "tax_rate" decimal(8,2) DEFAULT 0.0, "stock" integer DEFAULT 0, "created_at" datetime, "updated_at" datetime, "featured" boolean DEFAULT 'f') 
   (0.1ms)  SELECT * FROM "shoppe_products"
   (0.3ms)  DROP TABLE "shoppe_products"
   (0.2ms)  CREATE TABLE "shoppe_products" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "product_category_id" integer, "title" varchar(255), "sku" varchar(255), "permalink" varchar(255), "description" text, "short_description" text, "active" boolean DEFAULT 't', "weight" decimal(8,3) DEFAULT 0.0, "price" decimal(8,2) DEFAULT 0.0, "tax_rate" decimal(8,2) DEFAULT 0.0, "stock" integer DEFAULT 0, "created_at" datetime, "updated_at" datetime, "featured" boolean DEFAULT 'f') 
   (0.1ms)  SELECT * FROM "ashoppe_products"
   (0.1ms)  DROP TABLE "ashoppe_products"
   (0.2ms)  CREATE TEMPORARY TABLE "ashoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_tax_rate" decimal(8,2) DEFAULT 0.0, "delivery_vat_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "accepted_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "payment_gateway_module" varchar(255), "ip_address" varchar(255)) 
   (0.1ms)  SELECT * FROM "shoppe_orders"
   (0.3ms)  DROP TABLE "shoppe_orders"
   (0.1ms)  CREATE TABLE "shoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_tax_rate" decimal(8,2) DEFAULT 0.0, "delivery_vat_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "accepted_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "payment_gateway_module" varchar(255), "ip_address" varchar(255)) 
   (0.1ms)  SELECT * FROM "ashoppe_orders"
   (0.1ms)  DROP TABLE "ashoppe_orders"
   (0.2ms)  CREATE TEMPORARY TABLE "ashoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_tax_rate" decimal(8,2) DEFAULT 0.0, "delivery_tax_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "accepted_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "payment_gateway_module" varchar(255), "ip_address" varchar(255)) 
   (0.1ms)  SELECT * FROM "shoppe_orders"
   (0.1ms)  DROP TABLE "shoppe_orders"
   (0.2ms)  CREATE TABLE "shoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_tax_rate" decimal(8,2) DEFAULT 0.0, "delivery_tax_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "accepted_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "payment_gateway_module" varchar(255), "ip_address" varchar(255)) 
   (0.1ms)  SELECT * FROM "ashoppe_orders"
   (0.1ms)  DROP TABLE "ashoppe_orders"
   (0.1ms)  CREATE TEMPORARY TABLE "ashoppe_order_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "product_id" integer, "quantity" integer DEFAULT 1, "unit_price" decimal(8,2), "tax_amount" decimal(8,2), "vat_rate" decimal(8,2), "weight" decimal(8,3) DEFAULT 0.0, "created_at" datetime, "updated_at" datetime) 
   (0.1ms)  SELECT * FROM "shoppe_order_items"
   (0.2ms)  DROP TABLE "shoppe_order_items"
   (0.1ms)  CREATE TABLE "shoppe_order_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "product_id" integer, "quantity" integer DEFAULT 1, "unit_price" decimal(8,2), "tax_amount" decimal(8,2), "vat_rate" decimal(8,2), "weight" decimal(8,3) DEFAULT 0.0, "created_at" datetime, "updated_at" datetime) 
   (0.1ms)  SELECT * FROM "ashoppe_order_items"
   (0.1ms)  DROP TABLE "ashoppe_order_items"
   (0.1ms)  CREATE TEMPORARY TABLE "ashoppe_order_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "product_id" integer, "quantity" integer DEFAULT 1, "unit_price" decimal(8,2), "tax_amount" decimal(8,2), "tax_rate" decimal(8,2), "weight" decimal(8,3) DEFAULT 0.0, "created_at" datetime, "updated_at" datetime) 
   (0.1ms)  SELECT * FROM "shoppe_order_items"
   (0.1ms)  DROP TABLE "shoppe_order_items"
   (0.1ms)  CREATE TABLE "shoppe_order_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "product_id" integer, "quantity" integer DEFAULT 1, "unit_price" decimal(8,2), "tax_amount" decimal(8,2), "tax_rate" decimal(8,2), "weight" decimal(8,3) DEFAULT 0.0, "created_at" datetime, "updated_at" datetime) 
   (0.1ms)  SELECT * FROM "ashoppe_order_items"
   (0.1ms)  DROP TABLE "ashoppe_order_items"
   (0.2ms)  CREATE TEMPORARY TABLE "ashoppe_delivery_services" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "code" varchar(255), "default" boolean DEFAULT 't', "min_weight" decimal(8,3), "max_weight" decimal(8,3), "price" decimal(8,2) DEFAULT 0.0, "tax_rate" decimal(8,2), "active" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime, "courier" varchar(255), "tracking_url" varchar(255)) 
   (0.1ms)  SELECT * FROM "shoppe_delivery_services"
   (0.1ms)  DROP TABLE "shoppe_delivery_services"
   (0.1ms)  CREATE TABLE "shoppe_delivery_services" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "code" varchar(255), "default" boolean DEFAULT 't', "min_weight" decimal(8,3), "max_weight" decimal(8,3), "price" decimal(8,2) DEFAULT 0.0, "tax_rate" decimal(8,2), "active" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime, "courier" varchar(255), "tracking_url" varchar(255)) 
   (0.1ms)  SELECT * FROM "ashoppe_delivery_services"
   (0.1ms)  DROP TABLE "ashoppe_delivery_services"
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20131002154122"]]
   (1.3ms)  commit transaction
Migrating to CreateDeliveryServicePrices (20131002155246)
   (0.1ms)  begin transaction
   (0.3ms)  CREATE TABLE "shoppe_delivery_service_prices" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "delivery_service_id" integer, "code" varchar(255), "price" decimal(8,2), "tax_rate" decimal(8,2), "min_weight" decimal(8,2), "max_weight" decimal(8,2), "created_at" datetime, "updated_at" datetime) 
   (0.1ms)  CREATE TEMPORARY TABLE "ashoppe_delivery_services" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "code" varchar(255), "default" boolean DEFAULT 't', "min_weight" decimal(8,3), "max_weight" decimal(8,3), "price" decimal(8,2) DEFAULT 0.0, "tax_rate" decimal(8,2), "active" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime, "courier" varchar(255), "tracking_url" varchar(255)) 
   (0.1ms)  SELECT * FROM "shoppe_delivery_services"
   (0.3ms)  DROP TABLE "shoppe_delivery_services"
   (0.1ms)  CREATE TABLE "shoppe_delivery_services" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "code" varchar(255), "default" boolean DEFAULT 't', "min_weight" decimal(8,3), "max_weight" decimal(8,3), "tax_rate" decimal(8,2), "active" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime, "courier" varchar(255), "tracking_url" varchar(255)) 
   (0.1ms)  SELECT * FROM "ashoppe_delivery_services"
   (0.1ms)  DROP TABLE "ashoppe_delivery_services"
   (0.1ms)  CREATE TEMPORARY TABLE "ashoppe_delivery_services" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "code" varchar(255), "default" boolean DEFAULT 't', "min_weight" decimal(8,3), "max_weight" decimal(8,3), "tax_rate" decimal(8,2), "active" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime, "courier" varchar(255), "tracking_url" varchar(255)) 
   (0.1ms)  SELECT * FROM "shoppe_delivery_services"
   (0.1ms)  DROP TABLE "shoppe_delivery_services"
   (0.1ms)  CREATE TABLE "shoppe_delivery_services" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "code" varchar(255), "default" boolean DEFAULT 't', "min_weight" decimal(8,3), "max_weight" decimal(8,3), "active" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime, "courier" varchar(255), "tracking_url" varchar(255)) 
   (0.1ms)  SELECT * FROM "ashoppe_delivery_services"
   (0.1ms)  DROP TABLE "ashoppe_delivery_services"
   (0.1ms)  CREATE TEMPORARY TABLE "ashoppe_delivery_services" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "code" varchar(255), "default" boolean DEFAULT 't', "min_weight" decimal(8,3), "max_weight" decimal(8,3), "active" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime, "courier" varchar(255), "tracking_url" varchar(255)) 
   (0.0ms)  SELECT * FROM "shoppe_delivery_services"
   (0.1ms)  DROP TABLE "shoppe_delivery_services"
   (0.1ms)  CREATE TABLE "shoppe_delivery_services" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "code" varchar(255), "default" boolean DEFAULT 't', "max_weight" decimal(8,3), "active" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime, "courier" varchar(255), "tracking_url" varchar(255)) 
   (0.0ms)  SELECT * FROM "ashoppe_delivery_services"
   (0.1ms)  DROP TABLE "ashoppe_delivery_services"
   (0.1ms)  CREATE TEMPORARY TABLE "ashoppe_delivery_services" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "code" varchar(255), "default" boolean DEFAULT 't', "max_weight" decimal(8,3), "active" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime, "courier" varchar(255), "tracking_url" varchar(255)) 
   (0.0ms)  SELECT * FROM "shoppe_delivery_services"
   (0.1ms)  DROP TABLE "shoppe_delivery_services"
   (0.1ms)  CREATE TABLE "shoppe_delivery_services" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "code" varchar(255), "default" boolean DEFAULT 't', "active" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime, "courier" varchar(255), "tracking_url" varchar(255)) 
   (0.0ms)  SELECT * FROM "ashoppe_delivery_services"
   (0.1ms)  DROP TABLE "ashoppe_delivery_services"
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20131002155246"]]
   (1.0ms)  commit transaction
Migrating to DefaultShouldNotBeTrueForDeliveryServices (20131002162301)
   (0.1ms)  begin transaction
   (0.1ms)  CREATE TEMPORARY TABLE "ashoppe_delivery_services" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "code" varchar(255), "default" boolean DEFAULT 't', "active" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime, "courier" varchar(255), "tracking_url" varchar(255)) 
   (0.1ms)  SELECT * FROM "shoppe_delivery_services"
   (0.2ms)  DROP TABLE "shoppe_delivery_services"
   (0.1ms)  CREATE TABLE "shoppe_delivery_services" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "code" varchar(255), "default" boolean DEFAULT 'f', "active" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime, "courier" varchar(255), "tracking_url" varchar(255)) 
   (0.0ms)  SELECT * FROM "ashoppe_delivery_services"
   (0.1ms)  DROP TABLE "ashoppe_delivery_services"
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20131002162301"]]
   (0.9ms)  commit transaction
Migrating to ChangeDefaultsForDeliveryValuesOnOrders (20131003163827)
   (0.1ms)  begin transaction
   (0.2ms)  CREATE TEMPORARY TABLE "ashoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_tax_rate" decimal(8,2) DEFAULT 0.0, "delivery_tax_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "accepted_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "payment_gateway_module" varchar(255), "ip_address" varchar(255)) 
   (0.1ms)  SELECT * FROM "shoppe_orders"
   (0.4ms)  DROP TABLE "shoppe_orders"
   (0.2ms)  CREATE TABLE "shoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2), "delivery_tax_rate" decimal(8,2) DEFAULT 0.0, "delivery_tax_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "accepted_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "payment_gateway_module" varchar(255), "ip_address" varchar(255)) 
   (0.1ms)  SELECT * FROM "ashoppe_orders"
   (0.1ms)  DROP TABLE "ashoppe_orders"
   (0.2ms)  CREATE TEMPORARY TABLE "ashoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2), "delivery_tax_rate" decimal(8,2) DEFAULT 0.0, "delivery_tax_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "accepted_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "payment_gateway_module" varchar(255), "ip_address" varchar(255)) 
   (0.1ms)  SELECT * FROM "shoppe_orders"
   (0.3ms)  DROP TABLE "shoppe_orders"
   (0.2ms)  CREATE TABLE "shoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2), "delivery_tax_rate" decimal(8,2), "delivery_tax_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "accepted_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "payment_gateway_module" varchar(255), "ip_address" varchar(255)) 
   (0.1ms)  SELECT * FROM "ashoppe_orders"
   (0.2ms)  DROP TABLE "ashoppe_orders"
   (0.2ms)  CREATE TEMPORARY TABLE "ashoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2), "delivery_tax_rate" decimal(8,2), "delivery_tax_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "accepted_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "payment_gateway_module" varchar(255), "ip_address" varchar(255)) 
   (0.1ms)  SELECT * FROM "shoppe_orders"
   (0.1ms)  DROP TABLE "shoppe_orders"
   (0.1ms)  CREATE TABLE "shoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2), "delivery_tax_rate" decimal(8,2), "delivery_tax_amount" decimal(8,2), "paid_at" datetime, "accepted_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "payment_gateway_module" varchar(255), "ip_address" varchar(255)) 
   (0.1ms)  SELECT * FROM "ashoppe_orders"
   (0.1ms)  DROP TABLE "ashoppe_orders"
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20131003163827"]]
   (1.0ms)  commit transaction
Migrating to AddCountryToOrders (20131004185043)
   (0.1ms)  begin transaction
   (0.3ms)  ALTER TABLE "shoppe_orders" ADD "country" varchar(255)
  SQL (0.2ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20131004185043"]]
   (0.9ms)  commit transaction
Migrating to AddBoxFieldsToProducts (20131004193320)
   (0.1ms)  begin transaction
   (0.4ms)  ALTER TABLE "shoppe_products" ADD "in_the_box" text
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20131004193320"]]
   (1.0ms)  commit transaction
Migrating to AddPaymentReferenceFields (20131006144849)
   (0.1ms)  begin transaction
   (0.4ms)  ALTER TABLE "shoppe_orders" ADD "payment_reference" varchar(255)
   (0.2ms)  ALTER TABLE "shoppe_orders" ADD "payment_method" varchar(255)
   (0.2ms)  CREATE TEMPORARY TABLE "ashoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2), "delivery_tax_rate" decimal(8,2), "delivery_tax_amount" decimal(8,2), "paid_at" datetime, "accepted_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "payment_gateway_module" varchar(255), "ip_address" varchar(255), "country" varchar(255), "payment_reference" varchar(255), "payment_method" varchar(255)) 
   (0.1ms)  SELECT * FROM "shoppe_orders"
   (0.4ms)  DROP TABLE "shoppe_orders"
   (0.2ms)  CREATE TABLE "shoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2), "delivery_tax_rate" decimal(8,2), "delivery_tax_amount" decimal(8,2), "paid_at" datetime, "accepted_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "ip_address" varchar(255), "country" varchar(255), "payment_reference" varchar(255), "payment_method" varchar(255)) 
   (0.1ms)  SELECT * FROM "ashoppe_orders"
   (0.1ms)  DROP TABLE "ashoppe_orders"
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20131006144849"]]
   (1.0ms)  commit transaction
  ActiveRecord::SchemaMigration Load (0.1ms)  SELECT "schema_migrations".* FROM "schema_migrations"
   (3.0ms)  CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) 
   (0.8ms)  CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
  ActiveRecord::SchemaMigration Load (0.1ms)  SELECT "schema_migrations".* FROM "schema_migrations"
Migrating to CreateProductCategories (20130926094549)
   (0.1ms)  begin transaction
   (0.3ms)  CREATE TABLE "shoppe_product_categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "permalink" varchar(255), "description" text, "created_at" datetime, "updated_at" datetime) 
  SQL (1.5ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130926094549"]]
   (1.0ms)  commit transaction
Migrating to CreateProducts (20130926094551)
   (0.1ms)  begin transaction
   (0.4ms)  CREATE TABLE "shoppe_products" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "product_category_id" integer, "title" varchar(255), "sku" varchar(255), "permalink" varchar(255), "description" text, "short_description" text, "active" boolean DEFAULT 't', "weight" decimal(8,3) DEFAULT 0.0, "price" decimal(8,2) DEFAULT 0.0, "vat_rate" decimal(8,2) DEFAULT 0.0, "stock" integer DEFAULT 0, "created_at" datetime, "updated_at" datetime) 
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130926094551"]]
   (0.9ms)  commit transaction
Migrating to CreateOrders (20130926094647)
   (0.1ms)  begin transaction
   (0.4ms)  CREATE TABLE "shoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "approved_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime) 
  SQL (0.2ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130926094647"]]
   (0.7ms)  commit transaction
Migrating to CreateOrderItems (20130926094654)
   (0.1ms)  begin transaction
   (0.4ms)  CREATE TABLE "shoppe_order_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "parent_type" varchar(255), "parent_id" integer, "quantity" integer DEFAULT 1, "unit_price" decimal(8,2), "vat_amount" decimal(8,2), "vat_rate" decimal(8,2), "weight" decimal(8,3) DEFAULT 0, "created_at" datetime, "updated_at" datetime) 
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130926094654"]]
   (0.8ms)  commit transaction
Migrating to CreateImages (20130926104450)
   (0.1ms)  begin transaction
   (0.3ms)  CREATE TABLE "shoppe_attachments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "parent_type" varchar(255), "token" varchar(255), "role" varchar(255), "file_name" varchar(255), "file_type" varchar(255), "data" blob(10485760), "created_at" datetime, "updated_at" datetime) 
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130926104450"]]
   (0.7ms)  commit transaction
Migrating to CreateUsers (20130926151718)
   (0.1ms)  begin transaction
   (0.3ms)  CREATE TABLE "shoppe_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "first_name" varchar(255), "last_name" varchar(255), "email_address" varchar(255), "password_digest" varchar(255), "created_at" datetime, "updated_at" datetime) 
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130926151718"]]
   (0.6ms)  commit transaction
Migrating to AddCardTokenToOrders (20130927113134)
   (0.1ms)  begin transaction
   (0.3ms)  ALTER TABLE "shoppe_orders" ADD "stripe_customer_token" varchar(255)
   (0.1ms)  ALTER TABLE "shoppe_orders" ADD "stripe_payment_token" varchar(255)
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130927113134"]]
   (0.7ms)  commit transaction
Migrating to CreateDeliveryServices (20130927130022)
   (0.1ms)  begin transaction
   (0.3ms)  CREATE TABLE "shoppe_delivery_services" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "code" varchar(255), "default" boolean DEFAULT 't', "min_weight" decimal(8,3), "max_weight" decimal(8,3), "price" decimal(8,2) DEFAULT 0, "vat_rate" decimal(8,2), "active" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime) 
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130927130022"]]
   (0.6ms)  commit transaction
Migrating to AddDeliveryServiceToOrder (20130927132143)
   (0.1ms)  begin transaction
   (0.4ms)  ALTER TABLE "shoppe_orders" ADD "delivery_service_id" integer
   (0.2ms)  ALTER TABLE "shoppe_orders" ADD "delivery_price" decimal(8,2) DEFAULT 0.0
   (0.2ms)  ALTER TABLE "shoppe_orders" ADD "delivery_vat_rate" decimal(8,2) DEFAULT 0.0
   (0.1ms)  ALTER TABLE "shoppe_orders" ADD "delivery_vat_amount" decimal(8,2) DEFAULT 0.0
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130927132143"]]
   (0.9ms)  commit transaction
Migrating to AddPaymentDateToOrders (20130927150025)
   (0.1ms)  begin transaction
   (0.4ms)  ALTER TABLE "shoppe_orders" ADD "paid_at" datetime
  SQL (0.2ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130927150025"]]
   (0.8ms)  commit transaction
Migrating to RenameStripePaymentToken (20130928111819)
   (0.1ms)  begin transaction
   (0.5ms)  CREATE TEMPORARY TABLE "ashoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "approved_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "stripe_customer_token" varchar(255), "payment_reference" varchar(255), "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_vat_rate" decimal(8,2) DEFAULT 0.0, "delivery_vat_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime) 
   (0.1ms)  SELECT * FROM "shoppe_orders"
   (0.2ms)  DROP TABLE "shoppe_orders"
   (0.1ms)  CREATE TABLE "shoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "approved_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "stripe_customer_token" varchar(255), "payment_reference" varchar(255), "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_vat_rate" decimal(8,2) DEFAULT 0.0, "delivery_vat_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime) 
   (0.1ms)  SELECT * FROM "ashoppe_orders"
   (0.2ms)  DROP TABLE "ashoppe_orders"
   (0.1ms)  ALTER TABLE "shoppe_orders" ADD "payment_method" varchar(255)
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130928111819"]]
   (0.9ms)  commit transaction
Migrating to AddApporovedUsers (20130928131502)
   (0.1ms)  begin transaction
   (0.3ms)  ALTER TABLE "shoppe_orders" ADD "approved_by" integer
   (0.2ms)  ALTER TABLE "shoppe_orders" ADD "shipped_by" integer
   (0.2ms)  ALTER TABLE "shoppe_orders" ADD "consignment_number" varchar(255)
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130928131502"]]
   (0.8ms)  commit transaction
Migrating to AddCourierDetailsToShippingMethods (20130928134518)
   (0.1ms)  begin transaction
   (0.3ms)  ALTER TABLE "shoppe_delivery_services" ADD "courier" varchar(255)
   (0.1ms)  ALTER TABLE "shoppe_delivery_services" ADD "tracking_url" varchar(255)
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130928134518"]]
   (0.8ms)  commit transaction
Migrating to AddRejectionToOrders (20130928173818)
   (0.1ms)  begin transaction
   (0.3ms)  ALTER TABLE "shoppe_orders" ADD "rejected_at" datetime
   (0.2ms)  ALTER TABLE "shoppe_orders" ADD "rejected_by" integer
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130928173818"]]
   (0.7ms)  commit transaction
Migrating to SortOutOrdersForGateways (20130928180041)
   (0.1ms)  begin transaction
   (0.3ms)  CREATE TEMPORARY TABLE "ashoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "approved_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "stripe_customer_token" varchar(255), "payment_reference" varchar(255), "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_vat_rate" decimal(8,2) DEFAULT 0.0, "delivery_vat_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "payment_method" varchar(255), "approved_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer) 
   (0.1ms)  SELECT * FROM "shoppe_orders"
   (0.3ms)  DROP TABLE "shoppe_orders"
   (0.2ms)  CREATE TABLE "shoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "approved_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "payment_reference" varchar(255), "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_vat_rate" decimal(8,2) DEFAULT 0.0, "delivery_vat_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "payment_method" varchar(255), "approved_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer) 
   (0.1ms)  SELECT * FROM "ashoppe_orders"
   (0.1ms)  DROP TABLE "ashoppe_orders"
   (0.3ms)  CREATE TEMPORARY TABLE "ashoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "approved_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "payment_reference" varchar(255), "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_vat_rate" decimal(8,2) DEFAULT 0.0, "delivery_vat_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "payment_method" varchar(255), "approved_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer) 
   (0.1ms)  SELECT * FROM "shoppe_orders"
   (0.3ms)  DROP TABLE "shoppe_orders"
   (0.2ms)  CREATE TABLE "shoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "approved_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_vat_rate" decimal(8,2) DEFAULT 0.0, "delivery_vat_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "payment_method" varchar(255), "approved_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer) 
   (0.1ms)  SELECT * FROM "ashoppe_orders"
   (0.1ms)  DROP TABLE "ashoppe_orders"
   (0.2ms)  CREATE TEMPORARY TABLE "ashoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "approved_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_vat_rate" decimal(8,2) DEFAULT 0.0, "delivery_vat_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "payment_method" varchar(255), "approved_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer) 
   (0.1ms)  SELECT * FROM "shoppe_orders"
   (0.1ms)  DROP TABLE "shoppe_orders"
   (0.2ms)  CREATE TABLE "shoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "approved_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_vat_rate" decimal(8,2) DEFAULT 0.0, "delivery_vat_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "approved_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer) 
   (0.1ms)  SELECT * FROM "ashoppe_orders"
   (0.1ms)  DROP TABLE "ashoppe_orders"
  SQL (0.3ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130928180041"]]
   (1.2ms)  commit transaction
Migrating to CreateNiftyKeyValueStoreTable (20130928185655)
   (0.1ms)  begin transaction
   (0.6ms)  CREATE TABLE "shoppe_key_value_store" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "parent_type" varchar(255), "group" varchar(255), "name" varchar(255), "value" varchar(255)) 
  SQL (0.2ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130928185655"]]
   (0.8ms)  commit transaction
Migrating to AddPaymentGatewayToOrders (20130928193023)
   (0.1ms)  begin transaction
   (0.4ms)  ALTER TABLE "shoppe_orders" ADD "payment_gateway_module" varchar(255)
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130928193023"]]
   (0.9ms)  commit transaction
Migrating to UpdateDatabaseColumnsForAccepted (20130928201257)
   (0.1ms)  begin transaction
   (0.3ms)  CREATE TEMPORARY TABLE "ashoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_vat_rate" decimal(8,2) DEFAULT 0.0, "delivery_vat_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "approved_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "payment_gateway_module" varchar(255)) 
   (0.1ms)  SELECT * FROM "shoppe_orders"
   (0.2ms)  DROP TABLE "shoppe_orders"
   (0.2ms)  CREATE TABLE "shoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_vat_rate" decimal(8,2) DEFAULT 0.0, "delivery_vat_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "approved_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "payment_gateway_module" varchar(255)) 
   (0.1ms)  SELECT * FROM "ashoppe_orders"
   (0.1ms)  DROP TABLE "ashoppe_orders"
   (0.2ms)  CREATE TEMPORARY TABLE "ashoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_vat_rate" decimal(8,2) DEFAULT 0.0, "delivery_vat_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "accepted_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "payment_gateway_module" varchar(255)) 
   (0.1ms)  SELECT * FROM "shoppe_orders"
   (0.3ms)  DROP TABLE "shoppe_orders"
   (0.2ms)  CREATE TABLE "shoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_vat_rate" decimal(8,2) DEFAULT 0.0, "delivery_vat_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "accepted_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "payment_gateway_module" varchar(255)) 
   (0.1ms)  SELECT * FROM "ashoppe_orders"
   (0.2ms)  DROP TABLE "ashoppe_orders"
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130928201257"]]
   (0.8ms)  commit transaction
Migrating to AddIpAddressToOrders (20130929151744)
   (0.1ms)  begin transaction
   (0.5ms)  ALTER TABLE "shoppe_orders" ADD "ip_address" varchar(255)
  SQL (0.2ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130929151744"]]
   (0.7ms)  commit transaction
Migrating to ChangeOrderItemsToBeNonPolymorphic (20130929203421)
   (0.1ms)  begin transaction
   (0.2ms)  CREATE TEMPORARY TABLE "ashoppe_order_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "parent_type" varchar(255), "product_id" integer, "quantity" integer DEFAULT 1, "unit_price" decimal(8,2), "vat_amount" decimal(8,2), "vat_rate" decimal(8,2), "weight" decimal(8,3) DEFAULT 0.0, "created_at" datetime, "updated_at" datetime) 
   (0.1ms)  SELECT * FROM "shoppe_order_items"
   (0.2ms)  DROP TABLE "shoppe_order_items"
   (0.1ms)  CREATE TABLE "shoppe_order_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "parent_type" varchar(255), "product_id" integer, "quantity" integer DEFAULT 1, "unit_price" decimal(8,2), "vat_amount" decimal(8,2), "vat_rate" decimal(8,2), "weight" decimal(8,3) DEFAULT 0.0, "created_at" datetime, "updated_at" datetime) 
   (0.1ms)  SELECT * FROM "ashoppe_order_items"
   (0.1ms)  DROP TABLE "ashoppe_order_items"
   (0.1ms)  CREATE TEMPORARY TABLE "ashoppe_order_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "parent_type" varchar(255), "product_id" integer, "quantity" integer DEFAULT 1, "unit_price" decimal(8,2), "vat_amount" decimal(8,2), "vat_rate" decimal(8,2), "weight" decimal(8,3) DEFAULT 0.0, "created_at" datetime, "updated_at" datetime) 
   (0.1ms)  SELECT * FROM "shoppe_order_items"
   (0.2ms)  DROP TABLE "shoppe_order_items"
   (0.1ms)  CREATE TABLE "shoppe_order_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "product_id" integer, "quantity" integer DEFAULT 1, "unit_price" decimal(8,2), "vat_amount" decimal(8,2), "vat_rate" decimal(8,2), "weight" decimal(8,3) DEFAULT 0.0, "created_at" datetime, "updated_at" datetime) 
   (0.1ms)  SELECT * FROM "ashoppe_order_items"
   (0.1ms)  DROP TABLE "ashoppe_order_items"
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130929203421"]]
   (1.0ms)  commit transaction
Migrating to AddFeaturedBooleanToProducts (20130930181344)
   (0.1ms)  begin transaction
   (0.4ms)  ALTER TABLE "shoppe_products" ADD "featured" boolean DEFAULT 'f'
  SQL (0.2ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130930181344"]]
   (0.9ms)  commit transaction
Migrating to RenameVatToTax (20131002154122)
   (0.1ms)  begin transaction
   (0.4ms)  CREATE TEMPORARY TABLE "ashoppe_products" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "product_category_id" integer, "title" varchar(255), "sku" varchar(255), "permalink" varchar(255), "description" text, "short_description" text, "active" boolean DEFAULT 't', "weight" decimal(8,3) DEFAULT 0.0, "price" decimal(8,2) DEFAULT 0.0, "tax_rate" decimal(8,2) DEFAULT 0.0, "stock" integer DEFAULT 0, "created_at" datetime, "updated_at" datetime, "featured" boolean DEFAULT 'f') 
   (0.1ms)  SELECT * FROM "shoppe_products"
   (0.3ms)  DROP TABLE "shoppe_products"
   (0.2ms)  CREATE TABLE "shoppe_products" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "product_category_id" integer, "title" varchar(255), "sku" varchar(255), "permalink" varchar(255), "description" text, "short_description" text, "active" boolean DEFAULT 't', "weight" decimal(8,3) DEFAULT 0.0, "price" decimal(8,2) DEFAULT 0.0, "tax_rate" decimal(8,2) DEFAULT 0.0, "stock" integer DEFAULT 0, "created_at" datetime, "updated_at" datetime, "featured" boolean DEFAULT 'f') 
   (0.1ms)  SELECT * FROM "ashoppe_products"
   (0.1ms)  DROP TABLE "ashoppe_products"
   (0.2ms)  CREATE TEMPORARY TABLE "ashoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_tax_rate" decimal(8,2) DEFAULT 0.0, "delivery_vat_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "accepted_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "payment_gateway_module" varchar(255), "ip_address" varchar(255)) 
   (0.1ms)  SELECT * FROM "shoppe_orders"
   (0.3ms)  DROP TABLE "shoppe_orders"
   (0.2ms)  CREATE TABLE "shoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_tax_rate" decimal(8,2) DEFAULT 0.0, "delivery_vat_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "accepted_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "payment_gateway_module" varchar(255), "ip_address" varchar(255)) 
   (0.1ms)  SELECT * FROM "ashoppe_orders"
   (0.1ms)  DROP TABLE "ashoppe_orders"
   (0.2ms)  CREATE TEMPORARY TABLE "ashoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_tax_rate" decimal(8,2) DEFAULT 0.0, "delivery_tax_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "accepted_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "payment_gateway_module" varchar(255), "ip_address" varchar(255)) 
   (0.1ms)  SELECT * FROM "shoppe_orders"
   (0.1ms)  DROP TABLE "shoppe_orders"
   (0.2ms)  CREATE TABLE "shoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_tax_rate" decimal(8,2) DEFAULT 0.0, "delivery_tax_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "accepted_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "payment_gateway_module" varchar(255), "ip_address" varchar(255)) 
   (0.1ms)  SELECT * FROM "ashoppe_orders"
   (0.1ms)  DROP TABLE "ashoppe_orders"
   (0.1ms)  CREATE TEMPORARY TABLE "ashoppe_order_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "product_id" integer, "quantity" integer DEFAULT 1, "unit_price" decimal(8,2), "tax_amount" decimal(8,2), "vat_rate" decimal(8,2), "weight" decimal(8,3) DEFAULT 0.0, "created_at" datetime, "updated_at" datetime) 
   (0.1ms)  SELECT * FROM "shoppe_order_items"
   (0.1ms)  DROP TABLE "shoppe_order_items"
   (0.1ms)  CREATE TABLE "shoppe_order_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "product_id" integer, "quantity" integer DEFAULT 1, "unit_price" decimal(8,2), "tax_amount" decimal(8,2), "vat_rate" decimal(8,2), "weight" decimal(8,3) DEFAULT 0.0, "created_at" datetime, "updated_at" datetime) 
   (0.1ms)  SELECT * FROM "ashoppe_order_items"
   (0.1ms)  DROP TABLE "ashoppe_order_items"
   (0.1ms)  CREATE TEMPORARY TABLE "ashoppe_order_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "product_id" integer, "quantity" integer DEFAULT 1, "unit_price" decimal(8,2), "tax_amount" decimal(8,2), "tax_rate" decimal(8,2), "weight" decimal(8,3) DEFAULT 0.0, "created_at" datetime, "updated_at" datetime) 
   (0.1ms)  SELECT * FROM "shoppe_order_items"
   (0.1ms)  DROP TABLE "shoppe_order_items"
   (0.1ms)  CREATE TABLE "shoppe_order_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "product_id" integer, "quantity" integer DEFAULT 1, "unit_price" decimal(8,2), "tax_amount" decimal(8,2), "tax_rate" decimal(8,2), "weight" decimal(8,3) DEFAULT 0.0, "created_at" datetime, "updated_at" datetime) 
   (0.1ms)  SELECT * FROM "ashoppe_order_items"
   (0.1ms)  DROP TABLE "ashoppe_order_items"
   (0.1ms)  CREATE TEMPORARY TABLE "ashoppe_delivery_services" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "code" varchar(255), "default" boolean DEFAULT 't', "min_weight" decimal(8,3), "max_weight" decimal(8,3), "price" decimal(8,2) DEFAULT 0.0, "tax_rate" decimal(8,2), "active" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime, "courier" varchar(255), "tracking_url" varchar(255)) 
   (0.1ms)  SELECT * FROM "shoppe_delivery_services"
   (0.1ms)  DROP TABLE "shoppe_delivery_services"
   (0.1ms)  CREATE TABLE "shoppe_delivery_services" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "code" varchar(255), "default" boolean DEFAULT 't', "min_weight" decimal(8,3), "max_weight" decimal(8,3), "price" decimal(8,2) DEFAULT 0.0, "tax_rate" decimal(8,2), "active" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime, "courier" varchar(255), "tracking_url" varchar(255)) 
   (0.1ms)  SELECT * FROM "ashoppe_delivery_services"
   (0.1ms)  DROP TABLE "ashoppe_delivery_services"
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20131002154122"]]
   (1.4ms)  commit transaction
Migrating to CreateDeliveryServicePrices (20131002155246)
   (0.1ms)  begin transaction
   (0.3ms)  CREATE TABLE "shoppe_delivery_service_prices" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "delivery_service_id" integer, "code" varchar(255), "price" decimal(8,2), "tax_rate" decimal(8,2), "min_weight" decimal(8,2), "max_weight" decimal(8,2), "created_at" datetime, "updated_at" datetime) 
   (0.1ms)  CREATE TEMPORARY TABLE "ashoppe_delivery_services" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "code" varchar(255), "default" boolean DEFAULT 't', "min_weight" decimal(8,3), "max_weight" decimal(8,3), "price" decimal(8,2) DEFAULT 0.0, "tax_rate" decimal(8,2), "active" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime, "courier" varchar(255), "tracking_url" varchar(255)) 
   (0.1ms)  SELECT * FROM "shoppe_delivery_services"
   (0.3ms)  DROP TABLE "shoppe_delivery_services"
   (0.1ms)  CREATE TABLE "shoppe_delivery_services" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "code" varchar(255), "default" boolean DEFAULT 't', "min_weight" decimal(8,3), "max_weight" decimal(8,3), "tax_rate" decimal(8,2), "active" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime, "courier" varchar(255), "tracking_url" varchar(255)) 
   (0.1ms)  SELECT * FROM "ashoppe_delivery_services"
   (0.1ms)  DROP TABLE "ashoppe_delivery_services"
   (0.1ms)  CREATE TEMPORARY TABLE "ashoppe_delivery_services" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "code" varchar(255), "default" boolean DEFAULT 't', "min_weight" decimal(8,3), "max_weight" decimal(8,3), "tax_rate" decimal(8,2), "active" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime, "courier" varchar(255), "tracking_url" varchar(255)) 
   (0.0ms)  SELECT * FROM "shoppe_delivery_services"
   (0.1ms)  DROP TABLE "shoppe_delivery_services"
   (0.1ms)  CREATE TABLE "shoppe_delivery_services" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "code" varchar(255), "default" boolean DEFAULT 't', "min_weight" decimal(8,3), "max_weight" decimal(8,3), "active" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime, "courier" varchar(255), "tracking_url" varchar(255)) 
   (0.1ms)  SELECT * FROM "ashoppe_delivery_services"
   (0.1ms)  DROP TABLE "ashoppe_delivery_services"
   (0.2ms)  CREATE TEMPORARY TABLE "ashoppe_delivery_services" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "code" varchar(255), "default" boolean DEFAULT 't', "min_weight" decimal(8,3), "max_weight" decimal(8,3), "active" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime, "courier" varchar(255), "tracking_url" varchar(255)) 
   (0.1ms)  SELECT * FROM "shoppe_delivery_services"
   (0.2ms)  DROP TABLE "shoppe_delivery_services"
   (0.2ms)  CREATE TABLE "shoppe_delivery_services" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "code" varchar(255), "default" boolean DEFAULT 't', "max_weight" decimal(8,3), "active" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime, "courier" varchar(255), "tracking_url" varchar(255)) 
   (0.1ms)  SELECT * FROM "ashoppe_delivery_services"
   (0.1ms)  DROP TABLE "ashoppe_delivery_services"
   (0.1ms)  CREATE TEMPORARY TABLE "ashoppe_delivery_services" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "code" varchar(255), "default" boolean DEFAULT 't', "max_weight" decimal(8,3), "active" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime, "courier" varchar(255), "tracking_url" varchar(255)) 
   (0.1ms)  SELECT * FROM "shoppe_delivery_services"
   (0.1ms)  DROP TABLE "shoppe_delivery_services"
   (0.1ms)  CREATE TABLE "shoppe_delivery_services" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "code" varchar(255), "default" boolean DEFAULT 't', "active" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime, "courier" varchar(255), "tracking_url" varchar(255)) 
   (0.0ms)  SELECT * FROM "ashoppe_delivery_services"
   (0.1ms)  DROP TABLE "ashoppe_delivery_services"
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20131002155246"]]
   (1.2ms)  commit transaction
Migrating to DefaultShouldNotBeTrueForDeliveryServices (20131002162301)
   (0.1ms)  begin transaction
   (0.2ms)  CREATE TEMPORARY TABLE "ashoppe_delivery_services" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "code" varchar(255), "default" boolean DEFAULT 't', "active" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime, "courier" varchar(255), "tracking_url" varchar(255)) 
   (0.1ms)  SELECT * FROM "shoppe_delivery_services"
   (0.3ms)  DROP TABLE "shoppe_delivery_services"
   (0.1ms)  CREATE TABLE "shoppe_delivery_services" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "code" varchar(255), "default" boolean DEFAULT 'f', "active" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime, "courier" varchar(255), "tracking_url" varchar(255)) 
   (0.1ms)  SELECT * FROM "ashoppe_delivery_services"
   (0.1ms)  DROP TABLE "ashoppe_delivery_services"
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20131002162301"]]
   (0.8ms)  commit transaction
Migrating to ChangeDefaultsForDeliveryValuesOnOrders (20131003163827)
   (0.1ms)  begin transaction
   (0.3ms)  CREATE TEMPORARY TABLE "ashoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_tax_rate" decimal(8,2) DEFAULT 0.0, "delivery_tax_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "accepted_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "payment_gateway_module" varchar(255), "ip_address" varchar(255)) 
   (0.2ms)  SELECT * FROM "shoppe_orders"
   (0.3ms)  DROP TABLE "shoppe_orders"
   (0.2ms)  CREATE TABLE "shoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2), "delivery_tax_rate" decimal(8,2) DEFAULT 0.0, "delivery_tax_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "accepted_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "payment_gateway_module" varchar(255), "ip_address" varchar(255)) 
   (0.1ms)  SELECT * FROM "ashoppe_orders"
   (0.1ms)  DROP TABLE "ashoppe_orders"
   (0.2ms)  CREATE TEMPORARY TABLE "ashoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2), "delivery_tax_rate" decimal(8,2) DEFAULT 0.0, "delivery_tax_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "accepted_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "payment_gateway_module" varchar(255), "ip_address" varchar(255)) 
   (0.1ms)  SELECT * FROM "shoppe_orders"
   (0.3ms)  DROP TABLE "shoppe_orders"
   (0.2ms)  CREATE TABLE "shoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2), "delivery_tax_rate" decimal(8,2), "delivery_tax_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "accepted_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "payment_gateway_module" varchar(255), "ip_address" varchar(255)) 
   (0.1ms)  SELECT * FROM "ashoppe_orders"
   (0.1ms)  DROP TABLE "ashoppe_orders"
   (0.2ms)  CREATE TEMPORARY TABLE "ashoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2), "delivery_tax_rate" decimal(8,2), "delivery_tax_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "accepted_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "payment_gateway_module" varchar(255), "ip_address" varchar(255)) 
   (0.1ms)  SELECT * FROM "shoppe_orders"
   (0.1ms)  DROP TABLE "shoppe_orders"
   (0.2ms)  CREATE TABLE "shoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2), "delivery_tax_rate" decimal(8,2), "delivery_tax_amount" decimal(8,2), "paid_at" datetime, "accepted_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "payment_gateway_module" varchar(255), "ip_address" varchar(255)) 
   (0.1ms)  SELECT * FROM "ashoppe_orders"
   (0.2ms)  DROP TABLE "ashoppe_orders"
  SQL (0.2ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20131003163827"]]
   (1.0ms)  commit transaction
Migrating to AddCountryToOrders (20131004185043)
   (0.1ms)  begin transaction
   (0.5ms)  ALTER TABLE "shoppe_orders" ADD "country" varchar(255)
  SQL (0.2ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20131004185043"]]
   (0.9ms)  commit transaction
Migrating to AddBoxFieldsToProducts (20131004193320)
   (0.1ms)  begin transaction
   (0.5ms)  ALTER TABLE "shoppe_products" ADD "in_the_box" text
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20131004193320"]]
   (0.8ms)  commit transaction
Migrating to AddPaymentReferenceFields (20131006144849)
   (0.1ms)  begin transaction
   (0.3ms)  ALTER TABLE "shoppe_orders" ADD "payment_reference" varchar(255)
   (0.2ms)  ALTER TABLE "shoppe_orders" ADD "payment_method" varchar(255)
   (0.2ms)  CREATE TEMPORARY TABLE "ashoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2), "delivery_tax_rate" decimal(8,2), "delivery_tax_amount" decimal(8,2), "paid_at" datetime, "accepted_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "payment_gateway_module" varchar(255), "ip_address" varchar(255), "country" varchar(255), "payment_reference" varchar(255), "payment_method" varchar(255)) 
   (0.1ms)  SELECT * FROM "shoppe_orders"
   (0.3ms)  DROP TABLE "shoppe_orders"
   (0.2ms)  CREATE TABLE "shoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2), "delivery_tax_rate" decimal(8,2), "delivery_tax_amount" decimal(8,2), "paid_at" datetime, "accepted_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "ip_address" varchar(255), "country" varchar(255), "payment_reference" varchar(255), "payment_method" varchar(255)) 
   (0.1ms)  SELECT * FROM "ashoppe_orders"
   (0.2ms)  DROP TABLE "ashoppe_orders"
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20131006144849"]]
   (0.8ms)  commit transaction
  ActiveRecord::SchemaMigration Load (0.2ms)  SELECT "schema_migrations".* FROM "schema_migrations"
   (2.6ms)  CREATE TABLE "shoppe_attachments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "parent_type" varchar(255), "token" varchar(255), "role" varchar(255), "file_name" varchar(255), "file_type" varchar(255), "data" blob(10485760), "created_at" datetime, "updated_at" datetime) 
   (1.1ms)  CREATE TABLE "shoppe_delivery_service_prices" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "delivery_service_id" integer, "code" varchar(255), "price" decimal(8,2), "tax_rate" decimal(8,2), "min_weight" decimal(8,2), "max_weight" decimal(8,2), "created_at" datetime, "updated_at" datetime) 
   (1.4ms)  CREATE TABLE "shoppe_delivery_services" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "code" varchar(255), "default" boolean DEFAULT 'f', "active" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime, "courier" varchar(255), "tracking_url" varchar(255)) 
   (1.1ms)  CREATE TABLE "shoppe_key_value_store" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "parent_type" varchar(255), "group" varchar(255), "name" varchar(255), "value" varchar(255)) 
   (1.0ms)  CREATE TABLE "shoppe_order_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "product_id" integer, "quantity" integer DEFAULT 1, "unit_price" decimal(8,2), "tax_amount" decimal(8,2), "tax_rate" decimal(8,2), "weight" decimal(8,3) DEFAULT 0.0, "created_at" datetime, "updated_at" datetime) 
   (1.1ms)  CREATE TABLE "shoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2), "delivery_tax_rate" decimal(8,2), "delivery_tax_amount" decimal(8,2), "paid_at" datetime, "accepted_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "ip_address" varchar(255), "country" varchar(255), "payment_reference" varchar(255), "payment_method" varchar(255)) 
   (0.7ms)  CREATE TABLE "shoppe_product_categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "permalink" varchar(255), "description" text, "created_at" datetime, "updated_at" datetime) 
   (1.1ms)  CREATE TABLE "shoppe_products" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "product_category_id" integer, "title" varchar(255), "sku" varchar(255), "permalink" varchar(255), "description" text, "short_description" text, "active" boolean DEFAULT 't', "weight" decimal(8,3) DEFAULT 0.0, "price" decimal(8,2) DEFAULT 0.0, "tax_rate" decimal(8,2) DEFAULT 0.0, "stock" integer DEFAULT 0, "created_at" datetime, "updated_at" datetime, "featured" boolean DEFAULT 'f', "in_the_box" text) 
   (0.8ms)  CREATE TABLE "shoppe_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "first_name" varchar(255), "last_name" varchar(255), "email_address" varchar(255), "password_digest" varchar(255), "created_at" datetime, "updated_at" datetime) 
   (1.0ms)  CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) 
   (0.9ms)  CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
   (0.1ms)  SELECT version FROM "schema_migrations"
   (0.8ms)  INSERT INTO "schema_migrations" (version) VALUES ('20131006144849')
   (0.7ms)  INSERT INTO "schema_migrations" (version) VALUES ('20130926094549')
   (0.7ms)  INSERT INTO "schema_migrations" (version) VALUES ('20130926094551')
   (0.8ms)  INSERT INTO "schema_migrations" (version) VALUES ('20130926094647')
   (0.7ms)  INSERT INTO "schema_migrations" (version) VALUES ('20130926094654')
   (0.7ms)  INSERT INTO "schema_migrations" (version) VALUES ('20130926104450')
   (0.7ms)  INSERT INTO "schema_migrations" (version) VALUES ('20130926151718')
   (0.8ms)  INSERT INTO "schema_migrations" (version) VALUES ('20130927113134')
   (0.8ms)  INSERT INTO "schema_migrations" (version) VALUES ('20130927130022')
   (0.7ms)  INSERT INTO "schema_migrations" (version) VALUES ('20130927132143')
   (0.8ms)  INSERT INTO "schema_migrations" (version) VALUES ('20130927150025')
   (0.7ms)  INSERT INTO "schema_migrations" (version) VALUES ('20130928111819')
   (0.7ms)  INSERT INTO "schema_migrations" (version) VALUES ('20130928131502')
   (0.7ms)  INSERT INTO "schema_migrations" (version) VALUES ('20130928134518')
   (0.8ms)  INSERT INTO "schema_migrations" (version) VALUES ('20130928173818')
   (0.7ms)  INSERT INTO "schema_migrations" (version) VALUES ('20130928180041')
   (0.6ms)  INSERT INTO "schema_migrations" (version) VALUES ('20130928185655')
   (0.7ms)  INSERT INTO "schema_migrations" (version) VALUES ('20130928193023')
   (0.7ms)  INSERT INTO "schema_migrations" (version) VALUES ('20130928201257')
   (0.8ms)  INSERT INTO "schema_migrations" (version) VALUES ('20130929151744')
   (0.7ms)  INSERT INTO "schema_migrations" (version) VALUES ('20130929203421')
   (0.7ms)  INSERT INTO "schema_migrations" (version) VALUES ('20130930181344')
   (0.7ms)  INSERT INTO "schema_migrations" (version) VALUES ('20131002154122')
   (0.8ms)  INSERT INTO "schema_migrations" (version) VALUES ('20131002155246')
   (0.8ms)  INSERT INTO "schema_migrations" (version) VALUES ('20131002162301')
   (0.7ms)  INSERT INTO "schema_migrations" (version) VALUES ('20131003163827')
   (0.7ms)  INSERT INTO "schema_migrations" (version) VALUES ('20131004185043')
   (0.7ms)  INSERT INTO "schema_migrations" (version) VALUES ('20131004193320')
  ActiveRecord::SchemaMigration Load (0.1ms)  SELECT "schema_migrations".* FROM "schema_migrations"
Migrating to CreateNiftyAttachmentsTable (20131007130530)
   (0.1ms)  begin transaction
   (0.5ms)  CREATE TABLE "nifty_attachments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "parent_id" integer, "parent_type" varchar(255), "token" varchar(255), "digest" varchar(255), "role" varchar(255), "file_name" varchar(255), "file_type" varchar(255), "data" blob(10485760), "created_at" datetime, "updated_at" datetime) 
  SQL (1.4ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20131007130530"]]
   (2.5ms)  commit transaction
  ActiveRecord::SchemaMigration Load (0.1ms)  SELECT "schema_migrations".* FROM "schema_migrations"
   (3.1ms)  CREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL) 
   (0.9ms)  CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")
  ActiveRecord::SchemaMigration Load (0.1ms)  SELECT "schema_migrations".* FROM "schema_migrations"
Migrating to CreateProductCategories (20130926094549)
   (0.0ms)  begin transaction
   (0.3ms)  CREATE TABLE "shoppe_product_categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "permalink" varchar(255), "description" text, "created_at" datetime, "updated_at" datetime) 
  SQL (1.2ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130926094549"]]
   (0.8ms)  commit transaction
Migrating to CreateProducts (20130926094551)
   (0.1ms)  begin transaction
   (0.4ms)  CREATE TABLE "shoppe_products" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "product_category_id" integer, "title" varchar(255), "sku" varchar(255), "permalink" varchar(255), "description" text, "short_description" text, "active" boolean DEFAULT 't', "weight" decimal(8,3) DEFAULT 0.0, "price" decimal(8,2) DEFAULT 0.0, "vat_rate" decimal(8,2) DEFAULT 0.0, "stock" integer DEFAULT 0, "created_at" datetime, "updated_at" datetime) 
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130926094551"]]
   (0.8ms)  commit transaction
Migrating to CreateOrders (20130926094647)
   (0.0ms)  begin transaction
   (0.3ms)  CREATE TABLE "shoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "approved_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime) 
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130926094647"]]
   (0.9ms)  commit transaction
Migrating to CreateOrderItems (20130926094654)
   (0.1ms)  begin transaction
   (0.3ms)  CREATE TABLE "shoppe_order_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "parent_type" varchar(255), "parent_id" integer, "quantity" integer DEFAULT 1, "unit_price" decimal(8,2), "vat_amount" decimal(8,2), "vat_rate" decimal(8,2), "weight" decimal(8,3) DEFAULT 0, "created_at" datetime, "updated_at" datetime) 
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130926094654"]]
   (0.8ms)  commit transaction
Migrating to CreateUsers (20130926151718)
   (0.1ms)  begin transaction
   (0.3ms)  CREATE TABLE "shoppe_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "first_name" varchar(255), "last_name" varchar(255), "email_address" varchar(255), "password_digest" varchar(255), "created_at" datetime, "updated_at" datetime) 
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130926151718"]]
   (0.9ms)  commit transaction
Migrating to AddCardTokenToOrders (20130927113134)
   (0.1ms)  begin transaction
   (0.3ms)  ALTER TABLE "shoppe_orders" ADD "stripe_customer_token" varchar(255)
   (0.2ms)  ALTER TABLE "shoppe_orders" ADD "stripe_payment_token" varchar(255)
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130927113134"]]
   (0.8ms)  commit transaction
Migrating to CreateDeliveryServices (20130927130022)
   (0.1ms)  begin transaction
   (0.3ms)  CREATE TABLE "shoppe_delivery_services" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "code" varchar(255), "default" boolean DEFAULT 't', "min_weight" decimal(8,3), "max_weight" decimal(8,3), "price" decimal(8,2) DEFAULT 0, "vat_rate" decimal(8,2), "active" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime) 
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130927130022"]]
   (0.8ms)  commit transaction
Migrating to AddDeliveryServiceToOrder (20130927132143)
   (0.1ms)  begin transaction
   (0.3ms)  ALTER TABLE "shoppe_orders" ADD "delivery_service_id" integer
   (0.1ms)  ALTER TABLE "shoppe_orders" ADD "delivery_price" decimal(8,2) DEFAULT 0.0
   (0.2ms)  ALTER TABLE "shoppe_orders" ADD "delivery_vat_rate" decimal(8,2) DEFAULT 0.0
   (0.1ms)  ALTER TABLE "shoppe_orders" ADD "delivery_vat_amount" decimal(8,2) DEFAULT 0.0
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130927132143"]]
   (0.8ms)  commit transaction
Migrating to AddPaymentDateToOrders (20130927150025)
   (0.1ms)  begin transaction
   (0.4ms)  ALTER TABLE "shoppe_orders" ADD "paid_at" datetime
  SQL (0.2ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130927150025"]]
   (0.7ms)  commit transaction
Migrating to RenameStripePaymentToken (20130928111819)
   (0.1ms)  begin transaction
   (0.6ms)  CREATE TEMPORARY TABLE "ashoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "approved_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "stripe_customer_token" varchar(255), "payment_reference" varchar(255), "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_vat_rate" decimal(8,2) DEFAULT 0.0, "delivery_vat_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime) 
   (0.1ms)  SELECT * FROM "shoppe_orders"
   (0.2ms)  DROP TABLE "shoppe_orders"
   (0.1ms)  CREATE TABLE "shoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "approved_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "stripe_customer_token" varchar(255), "payment_reference" varchar(255), "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_vat_rate" decimal(8,2) DEFAULT 0.0, "delivery_vat_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime) 
   (0.1ms)  SELECT * FROM "ashoppe_orders"
   (0.3ms)  DROP TABLE "ashoppe_orders"
   (0.1ms)  ALTER TABLE "shoppe_orders" ADD "payment_method" varchar(255)
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130928111819"]]
   (1.0ms)  commit transaction
Migrating to AddApporovedUsers (20130928131502)
   (0.1ms)  begin transaction
   (0.3ms)  ALTER TABLE "shoppe_orders" ADD "approved_by" integer
   (0.2ms)  ALTER TABLE "shoppe_orders" ADD "shipped_by" integer
   (0.2ms)  ALTER TABLE "shoppe_orders" ADD "consignment_number" varchar(255)
  SQL (0.2ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130928131502"]]
   (0.8ms)  commit transaction
Migrating to AddCourierDetailsToShippingMethods (20130928134518)
   (0.1ms)  begin transaction
   (0.4ms)  ALTER TABLE "shoppe_delivery_services" ADD "courier" varchar(255)
   (0.1ms)  ALTER TABLE "shoppe_delivery_services" ADD "tracking_url" varchar(255)
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130928134518"]]
   (0.8ms)  commit transaction
Migrating to AddRejectionToOrders (20130928173818)
   (0.1ms)  begin transaction
   (0.4ms)  ALTER TABLE "shoppe_orders" ADD "rejected_at" datetime
   (0.2ms)  ALTER TABLE "shoppe_orders" ADD "rejected_by" integer
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130928173818"]]
   (0.8ms)  commit transaction
Migrating to SortOutOrdersForGateways (20130928180041)
   (0.1ms)  begin transaction
   (0.2ms)  CREATE TEMPORARY TABLE "ashoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "approved_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "stripe_customer_token" varchar(255), "payment_reference" varchar(255), "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_vat_rate" decimal(8,2) DEFAULT 0.0, "delivery_vat_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "payment_method" varchar(255), "approved_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer) 
   (0.1ms)  SELECT * FROM "shoppe_orders"
   (0.3ms)  DROP TABLE "shoppe_orders"
   (0.2ms)  CREATE TABLE "shoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "approved_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "payment_reference" varchar(255), "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_vat_rate" decimal(8,2) DEFAULT 0.0, "delivery_vat_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "payment_method" varchar(255), "approved_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer) 
   (0.1ms)  SELECT * FROM "ashoppe_orders"
   (0.1ms)  DROP TABLE "ashoppe_orders"
   (0.2ms)  CREATE TEMPORARY TABLE "ashoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "approved_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "payment_reference" varchar(255), "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_vat_rate" decimal(8,2) DEFAULT 0.0, "delivery_vat_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "payment_method" varchar(255), "approved_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer) 
   (0.1ms)  SELECT * FROM "shoppe_orders"
   (0.3ms)  DROP TABLE "shoppe_orders"
   (0.2ms)  CREATE TABLE "shoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "approved_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_vat_rate" decimal(8,2) DEFAULT 0.0, "delivery_vat_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "payment_method" varchar(255), "approved_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer) 
   (0.1ms)  SELECT * FROM "ashoppe_orders"
   (0.1ms)  DROP TABLE "ashoppe_orders"
   (0.2ms)  CREATE TEMPORARY TABLE "ashoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "approved_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_vat_rate" decimal(8,2) DEFAULT 0.0, "delivery_vat_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "payment_method" varchar(255), "approved_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer) 
   (0.1ms)  SELECT * FROM "shoppe_orders"
   (0.2ms)  DROP TABLE "shoppe_orders"
   (0.2ms)  CREATE TABLE "shoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "approved_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_vat_rate" decimal(8,2) DEFAULT 0.0, "delivery_vat_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "approved_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer) 
   (0.1ms)  SELECT * FROM "ashoppe_orders"
   (0.1ms)  DROP TABLE "ashoppe_orders"
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130928180041"]]
   (0.9ms)  commit transaction
Migrating to AddPaymentGatewayToOrders (20130928193023)
   (0.1ms)  begin transaction
   (0.5ms)  ALTER TABLE "shoppe_orders" ADD "payment_gateway_module" varchar(255)
  SQL (0.2ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130928193023"]]
   (0.8ms)  commit transaction
Migrating to UpdateDatabaseColumnsForAccepted (20130928201257)
   (0.1ms)  begin transaction
   (0.2ms)  CREATE TEMPORARY TABLE "ashoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_vat_rate" decimal(8,2) DEFAULT 0.0, "delivery_vat_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "approved_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "payment_gateway_module" varchar(255)) 
   (0.1ms)  SELECT * FROM "shoppe_orders"
   (0.3ms)  DROP TABLE "shoppe_orders"
   (0.2ms)  CREATE TABLE "shoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_vat_rate" decimal(8,2) DEFAULT 0.0, "delivery_vat_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "approved_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "payment_gateway_module" varchar(255)) 
   (0.1ms)  SELECT * FROM "ashoppe_orders"
   (0.1ms)  DROP TABLE "ashoppe_orders"
   (0.2ms)  CREATE TEMPORARY TABLE "ashoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_vat_rate" decimal(8,2) DEFAULT 0.0, "delivery_vat_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "accepted_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "payment_gateway_module" varchar(255)) 
   (0.1ms)  SELECT * FROM "shoppe_orders"
   (0.3ms)  DROP TABLE "shoppe_orders"
   (0.2ms)  CREATE TABLE "shoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_vat_rate" decimal(8,2) DEFAULT 0.0, "delivery_vat_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "accepted_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "payment_gateway_module" varchar(255)) 
   (0.1ms)  SELECT * FROM "ashoppe_orders"
   (0.1ms)  DROP TABLE "ashoppe_orders"
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130928201257"]]
   (1.0ms)  commit transaction
Migrating to AddIpAddressToOrders (20130929151744)
   (0.1ms)  begin transaction
   (0.4ms)  ALTER TABLE "shoppe_orders" ADD "ip_address" varchar(255)
  SQL (0.2ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130929151744"]]
   (0.8ms)  commit transaction
Migrating to ChangeOrderItemsToBeNonPolymorphic (20130929203421)
   (0.1ms)  begin transaction
   (0.2ms)  CREATE TEMPORARY TABLE "ashoppe_order_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "parent_type" varchar(255), "product_id" integer, "quantity" integer DEFAULT 1, "unit_price" decimal(8,2), "vat_amount" decimal(8,2), "vat_rate" decimal(8,2), "weight" decimal(8,3) DEFAULT 0.0, "created_at" datetime, "updated_at" datetime) 
   (0.1ms)  SELECT * FROM "shoppe_order_items"
   (0.3ms)  DROP TABLE "shoppe_order_items"
   (0.1ms)  CREATE TABLE "shoppe_order_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "parent_type" varchar(255), "product_id" integer, "quantity" integer DEFAULT 1, "unit_price" decimal(8,2), "vat_amount" decimal(8,2), "vat_rate" decimal(8,2), "weight" decimal(8,3) DEFAULT 0.0, "created_at" datetime, "updated_at" datetime) 
   (0.0ms)  SELECT * FROM "ashoppe_order_items"
   (0.1ms)  DROP TABLE "ashoppe_order_items"
   (0.1ms)  CREATE TEMPORARY TABLE "ashoppe_order_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "parent_type" varchar(255), "product_id" integer, "quantity" integer DEFAULT 1, "unit_price" decimal(8,2), "vat_amount" decimal(8,2), "vat_rate" decimal(8,2), "weight" decimal(8,3) DEFAULT 0.0, "created_at" datetime, "updated_at" datetime) 
   (0.1ms)  SELECT * FROM "shoppe_order_items"
   (0.3ms)  DROP TABLE "shoppe_order_items"
   (0.2ms)  CREATE TABLE "shoppe_order_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "product_id" integer, "quantity" integer DEFAULT 1, "unit_price" decimal(8,2), "vat_amount" decimal(8,2), "vat_rate" decimal(8,2), "weight" decimal(8,3) DEFAULT 0.0, "created_at" datetime, "updated_at" datetime) 
   (0.1ms)  SELECT * FROM "ashoppe_order_items"
   (0.1ms)  DROP TABLE "ashoppe_order_items"
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130929203421"]]
   (1.0ms)  commit transaction
Migrating to AddFeaturedBooleanToProducts (20130930181344)
   (0.1ms)  begin transaction
   (0.3ms)  ALTER TABLE "shoppe_products" ADD "featured" boolean DEFAULT 'f'
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20130930181344"]]
   (0.9ms)  commit transaction
Migrating to RenameVatToTax (20131002154122)
   (0.1ms)  begin transaction
   (0.2ms)  CREATE TEMPORARY TABLE "ashoppe_products" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "product_category_id" integer, "title" varchar(255), "sku" varchar(255), "permalink" varchar(255), "description" text, "short_description" text, "active" boolean DEFAULT 't', "weight" decimal(8,3) DEFAULT 0.0, "price" decimal(8,2) DEFAULT 0.0, "tax_rate" decimal(8,2) DEFAULT 0.0, "stock" integer DEFAULT 0, "created_at" datetime, "updated_at" datetime, "featured" boolean DEFAULT 'f') 
   (0.1ms)  SELECT * FROM "shoppe_products"
   (0.3ms)  DROP TABLE "shoppe_products"
   (0.1ms)  CREATE TABLE "shoppe_products" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "product_category_id" integer, "title" varchar(255), "sku" varchar(255), "permalink" varchar(255), "description" text, "short_description" text, "active" boolean DEFAULT 't', "weight" decimal(8,3) DEFAULT 0.0, "price" decimal(8,2) DEFAULT 0.0, "tax_rate" decimal(8,2) DEFAULT 0.0, "stock" integer DEFAULT 0, "created_at" datetime, "updated_at" datetime, "featured" boolean DEFAULT 'f') 
   (0.1ms)  SELECT * FROM "ashoppe_products"
   (0.1ms)  DROP TABLE "ashoppe_products"
   (0.2ms)  CREATE TEMPORARY TABLE "ashoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_tax_rate" decimal(8,2) DEFAULT 0.0, "delivery_vat_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "accepted_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "payment_gateway_module" varchar(255), "ip_address" varchar(255)) 
   (0.1ms)  SELECT * FROM "shoppe_orders"
   (0.3ms)  DROP TABLE "shoppe_orders"
   (0.1ms)  CREATE TABLE "shoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_tax_rate" decimal(8,2) DEFAULT 0.0, "delivery_vat_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "accepted_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "payment_gateway_module" varchar(255), "ip_address" varchar(255)) 
   (0.1ms)  SELECT * FROM "ashoppe_orders"
   (0.3ms)  DROP TABLE "ashoppe_orders"
   (0.2ms)  CREATE TEMPORARY TABLE "ashoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_tax_rate" decimal(8,2) DEFAULT 0.0, "delivery_tax_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "accepted_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "payment_gateway_module" varchar(255), "ip_address" varchar(255)) 
   (0.1ms)  SELECT * FROM "shoppe_orders"
   (0.2ms)  DROP TABLE "shoppe_orders"
   (0.2ms)  CREATE TABLE "shoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_tax_rate" decimal(8,2) DEFAULT 0.0, "delivery_tax_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "accepted_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "payment_gateway_module" varchar(255), "ip_address" varchar(255)) 
   (0.1ms)  SELECT * FROM "ashoppe_orders"
   (0.2ms)  DROP TABLE "ashoppe_orders"
   (0.2ms)  CREATE TEMPORARY TABLE "ashoppe_order_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "product_id" integer, "quantity" integer DEFAULT 1, "unit_price" decimal(8,2), "tax_amount" decimal(8,2), "vat_rate" decimal(8,2), "weight" decimal(8,3) DEFAULT 0.0, "created_at" datetime, "updated_at" datetime) 
   (0.1ms)  SELECT * FROM "shoppe_order_items"
   (0.2ms)  DROP TABLE "shoppe_order_items"
   (0.1ms)  CREATE TABLE "shoppe_order_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "product_id" integer, "quantity" integer DEFAULT 1, "unit_price" decimal(8,2), "tax_amount" decimal(8,2), "vat_rate" decimal(8,2), "weight" decimal(8,3) DEFAULT 0.0, "created_at" datetime, "updated_at" datetime) 
   (0.1ms)  SELECT * FROM "ashoppe_order_items"
   (0.1ms)  DROP TABLE "ashoppe_order_items"
   (0.1ms)  CREATE TEMPORARY TABLE "ashoppe_order_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "product_id" integer, "quantity" integer DEFAULT 1, "unit_price" decimal(8,2), "tax_amount" decimal(8,2), "tax_rate" decimal(8,2), "weight" decimal(8,3) DEFAULT 0.0, "created_at" datetime, "updated_at" datetime) 
   (0.0ms)  SELECT * FROM "shoppe_order_items"
   (0.1ms)  DROP TABLE "shoppe_order_items"
   (0.1ms)  CREATE TABLE "shoppe_order_items" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "order_id" integer, "product_id" integer, "quantity" integer DEFAULT 1, "unit_price" decimal(8,2), "tax_amount" decimal(8,2), "tax_rate" decimal(8,2), "weight" decimal(8,3) DEFAULT 0.0, "created_at" datetime, "updated_at" datetime) 
   (0.0ms)  SELECT * FROM "ashoppe_order_items"
   (0.1ms)  DROP TABLE "ashoppe_order_items"
   (0.1ms)  CREATE TEMPORARY TABLE "ashoppe_delivery_services" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "code" varchar(255), "default" boolean DEFAULT 't', "min_weight" decimal(8,3), "max_weight" decimal(8,3), "price" decimal(8,2) DEFAULT 0.0, "tax_rate" decimal(8,2), "active" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime, "courier" varchar(255), "tracking_url" varchar(255)) 
   (0.1ms)  SELECT * FROM "shoppe_delivery_services"
   (0.1ms)  DROP TABLE "shoppe_delivery_services"
   (0.2ms)  CREATE TABLE "shoppe_delivery_services" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "code" varchar(255), "default" boolean DEFAULT 't', "min_weight" decimal(8,3), "max_weight" decimal(8,3), "price" decimal(8,2) DEFAULT 0.0, "tax_rate" decimal(8,2), "active" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime, "courier" varchar(255), "tracking_url" varchar(255)) 
   (0.1ms)  SELECT * FROM "ashoppe_delivery_services"
   (0.1ms)  DROP TABLE "ashoppe_delivery_services"
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20131002154122"]]
   (1.0ms)  commit transaction
Migrating to CreateDeliveryServicePrices (20131002155246)
   (0.1ms)  begin transaction
   (0.4ms)  CREATE TABLE "shoppe_delivery_service_prices" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "delivery_service_id" integer, "code" varchar(255), "price" decimal(8,2), "tax_rate" decimal(8,2), "min_weight" decimal(8,2), "max_weight" decimal(8,2), "created_at" datetime, "updated_at" datetime) 
   (0.1ms)  CREATE TEMPORARY TABLE "ashoppe_delivery_services" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "code" varchar(255), "default" boolean DEFAULT 't', "min_weight" decimal(8,3), "max_weight" decimal(8,3), "price" decimal(8,2) DEFAULT 0.0, "tax_rate" decimal(8,2), "active" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime, "courier" varchar(255), "tracking_url" varchar(255)) 
   (0.1ms)  SELECT * FROM "shoppe_delivery_services"
   (0.2ms)  DROP TABLE "shoppe_delivery_services"
   (0.1ms)  CREATE TABLE "shoppe_delivery_services" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "code" varchar(255), "default" boolean DEFAULT 't', "min_weight" decimal(8,3), "max_weight" decimal(8,3), "tax_rate" decimal(8,2), "active" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime, "courier" varchar(255), "tracking_url" varchar(255)) 
   (0.1ms)  SELECT * FROM "ashoppe_delivery_services"
   (0.1ms)  DROP TABLE "ashoppe_delivery_services"
   (0.1ms)  CREATE TEMPORARY TABLE "ashoppe_delivery_services" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "code" varchar(255), "default" boolean DEFAULT 't', "min_weight" decimal(8,3), "max_weight" decimal(8,3), "tax_rate" decimal(8,2), "active" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime, "courier" varchar(255), "tracking_url" varchar(255)) 
   (0.1ms)  SELECT * FROM "shoppe_delivery_services"
   (0.1ms)  DROP TABLE "shoppe_delivery_services"
   (0.1ms)  CREATE TABLE "shoppe_delivery_services" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "code" varchar(255), "default" boolean DEFAULT 't', "min_weight" decimal(8,3), "max_weight" decimal(8,3), "active" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime, "courier" varchar(255), "tracking_url" varchar(255)) 
   (0.0ms)  SELECT * FROM "ashoppe_delivery_services"
   (0.1ms)  DROP TABLE "ashoppe_delivery_services"
   (0.2ms)  CREATE TEMPORARY TABLE "ashoppe_delivery_services" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "code" varchar(255), "default" boolean DEFAULT 't', "min_weight" decimal(8,3), "max_weight" decimal(8,3), "active" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime, "courier" varchar(255), "tracking_url" varchar(255)) 
   (0.0ms)  SELECT * FROM "shoppe_delivery_services"
   (0.1ms)  DROP TABLE "shoppe_delivery_services"
   (0.1ms)  CREATE TABLE "shoppe_delivery_services" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "code" varchar(255), "default" boolean DEFAULT 't', "max_weight" decimal(8,3), "active" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime, "courier" varchar(255), "tracking_url" varchar(255)) 
   (0.1ms)  SELECT * FROM "ashoppe_delivery_services"
   (0.1ms)  DROP TABLE "ashoppe_delivery_services"
   (0.1ms)  CREATE TEMPORARY TABLE "ashoppe_delivery_services" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "code" varchar(255), "default" boolean DEFAULT 't', "max_weight" decimal(8,3), "active" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime, "courier" varchar(255), "tracking_url" varchar(255)) 
   (0.0ms)  SELECT * FROM "shoppe_delivery_services"
   (0.1ms)  DROP TABLE "shoppe_delivery_services"
   (0.1ms)  CREATE TABLE "shoppe_delivery_services" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "code" varchar(255), "default" boolean DEFAULT 't', "active" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime, "courier" varchar(255), "tracking_url" varchar(255)) 
   (0.0ms)  SELECT * FROM "ashoppe_delivery_services"
   (0.1ms)  DROP TABLE "ashoppe_delivery_services"
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20131002155246"]]
   (1.1ms)  commit transaction
Migrating to DefaultShouldNotBeTrueForDeliveryServices (20131002162301)
   (0.1ms)  begin transaction
   (0.2ms)  CREATE TEMPORARY TABLE "ashoppe_delivery_services" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "code" varchar(255), "default" boolean DEFAULT 't', "active" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime, "courier" varchar(255), "tracking_url" varchar(255)) 
   (0.1ms)  SELECT * FROM "shoppe_delivery_services"
   (0.2ms)  DROP TABLE "shoppe_delivery_services"
   (0.1ms)  CREATE TABLE "shoppe_delivery_services" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "code" varchar(255), "default" boolean DEFAULT 'f', "active" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime, "courier" varchar(255), "tracking_url" varchar(255)) 
   (0.1ms)  SELECT * FROM "ashoppe_delivery_services"
   (0.1ms)  DROP TABLE "ashoppe_delivery_services"
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20131002162301"]]
   (0.7ms)  commit transaction
Migrating to ChangeDefaultsForDeliveryValuesOnOrders (20131003163827)
   (0.1ms)  begin transaction
   (0.2ms)  CREATE TEMPORARY TABLE "ashoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2) DEFAULT 0.0, "delivery_tax_rate" decimal(8,2) DEFAULT 0.0, "delivery_tax_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "accepted_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "payment_gateway_module" varchar(255), "ip_address" varchar(255)) 
   (0.1ms)  SELECT * FROM "shoppe_orders"
   (0.3ms)  DROP TABLE "shoppe_orders"
   (0.2ms)  CREATE TABLE "shoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2), "delivery_tax_rate" decimal(8,2) DEFAULT 0.0, "delivery_tax_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "accepted_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "payment_gateway_module" varchar(255), "ip_address" varchar(255)) 
   (0.1ms)  SELECT * FROM "ashoppe_orders"
   (0.1ms)  DROP TABLE "ashoppe_orders"
   (0.2ms)  CREATE TEMPORARY TABLE "ashoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2), "delivery_tax_rate" decimal(8,2) DEFAULT 0.0, "delivery_tax_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "accepted_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "payment_gateway_module" varchar(255), "ip_address" varchar(255)) 
   (0.1ms)  SELECT * FROM "shoppe_orders"
   (0.3ms)  DROP TABLE "shoppe_orders"
   (0.1ms)  CREATE TABLE "shoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2), "delivery_tax_rate" decimal(8,2), "delivery_tax_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "accepted_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "payment_gateway_module" varchar(255), "ip_address" varchar(255)) 
   (0.1ms)  SELECT * FROM "ashoppe_orders"
   (0.1ms)  DROP TABLE "ashoppe_orders"
   (0.2ms)  CREATE TEMPORARY TABLE "ashoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2), "delivery_tax_rate" decimal(8,2), "delivery_tax_amount" decimal(8,2) DEFAULT 0.0, "paid_at" datetime, "accepted_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "payment_gateway_module" varchar(255), "ip_address" varchar(255)) 
   (0.1ms)  SELECT * FROM "shoppe_orders"
   (0.1ms)  DROP TABLE "shoppe_orders"
   (0.2ms)  CREATE TABLE "shoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2), "delivery_tax_rate" decimal(8,2), "delivery_tax_amount" decimal(8,2), "paid_at" datetime, "accepted_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "payment_gateway_module" varchar(255), "ip_address" varchar(255)) 
   (0.1ms)  SELECT * FROM "ashoppe_orders"
   (0.1ms)  DROP TABLE "ashoppe_orders"
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20131003163827"]]
   (1.0ms)  commit transaction
Migrating to AddCountryToOrders (20131004185043)
   (0.1ms)  begin transaction
   (0.4ms)  ALTER TABLE "shoppe_orders" ADD "country" varchar(255)
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20131004185043"]]
   (0.9ms)  commit transaction
Migrating to AddBoxFieldsToProducts (20131004193320)
   (0.0ms)  begin transaction
   (0.3ms)  ALTER TABLE "shoppe_products" ADD "in_the_box" text
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20131004193320"]]
   (0.8ms)  commit transaction
Migrating to AddPaymentReferenceFields (20131006144849)
   (0.1ms)  begin transaction
   (0.4ms)  ALTER TABLE "shoppe_orders" ADD "payment_reference" varchar(255)
   (0.2ms)  ALTER TABLE "shoppe_orders" ADD "payment_method" varchar(255)
   (0.2ms)  CREATE TEMPORARY TABLE "ashoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2), "delivery_tax_rate" decimal(8,2), "delivery_tax_amount" decimal(8,2), "paid_at" datetime, "accepted_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "payment_gateway_module" varchar(255), "ip_address" varchar(255), "country" varchar(255), "payment_reference" varchar(255), "payment_method" varchar(255)) 
   (0.1ms)  SELECT * FROM "shoppe_orders"
   (0.3ms)  DROP TABLE "shoppe_orders"
   (0.2ms)  CREATE TABLE "shoppe_orders" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "token" varchar(255), "first_name" varchar(255), "last_name" varchar(255), "company" varchar(255), "address1" varchar(255), "address2" varchar(255), "address3" varchar(255), "address4" varchar(255), "postcode" varchar(255), "email_address" varchar(255), "phone_number" varchar(255), "status" varchar(255), "received_at" datetime, "accepted_at" datetime, "shipped_at" datetime, "created_at" datetime, "updated_at" datetime, "delivery_service_id" integer, "delivery_price" decimal(8,2), "delivery_tax_rate" decimal(8,2), "delivery_tax_amount" decimal(8,2), "paid_at" datetime, "accepted_by" integer, "shipped_by" integer, "consignment_number" varchar(255), "rejected_at" datetime, "rejected_by" integer, "ip_address" varchar(255), "country" varchar(255), "payment_reference" varchar(255), "payment_method" varchar(255)) 
   (0.1ms)  SELECT * FROM "ashoppe_orders"
   (0.1ms)  DROP TABLE "ashoppe_orders"
  SQL (0.2ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20131006144849"]]
   (0.7ms)  commit transaction
  ActiveRecord::SchemaMigration Load (0.2ms)  SELECT "schema_migrations".* FROM "schema_migrations"
  ActiveRecord::SchemaMigration Load (0.1ms)  SELECT "schema_migrations".* FROM "schema_migrations"
Migrating to CreateShoppeProductAttributes (20131012123829)
   (0.1ms)  begin transaction
   (0.4ms)  CREATE TABLE "shoppe_product_attributes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "product_id" integer, "key" varchar(255), "value" varchar(255), "position" integer DEFAULT 1, "searchable" boolean DEFAULT 't', "created_at" datetime, "updated_at" datetime) 
  SQL (1.4ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20131012123829"]]
   (2.4ms)  commit transaction
Migrating to AddPublicBooleanToProductAttributes (20131012163301)
   (0.1ms)  begin transaction
   (0.7ms)  ALTER TABLE "shoppe_product_attributes" ADD "public" boolean DEFAULT 't'
  SQL (0.1ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20131012163301"]]
   (0.8ms)  commit transaction
  ActiveRecord::SchemaMigration Load (0.1ms)  SELECT "schema_migrations".* FROM "schema_migrations"
  ActiveRecord::SchemaMigration Load (0.1ms)  SELECT "schema_migrations".* FROM "schema_migrations"
Migrating to AddCostPricesToVariousObjects (20131013123937)
   (0.1ms)  begin transaction
   (0.4ms)  ALTER TABLE "shoppe_products" ADD "cost_price" decimal(8,2)
   (0.2ms)  ALTER TABLE "shoppe_delivery_service_prices" ADD "cost_price" decimal(8,2)
   (0.1ms)  ALTER TABLE "shoppe_order_items" ADD "unit_cost_price" decimal(8,2)
   (0.2ms)  ALTER TABLE "shoppe_orders" ADD "delivery_cost_price" decimal(8,2)
  SQL (1.4ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20131013123937"]]
   (1.1ms)  commit transaction
  ActiveRecord::SchemaMigration Load (0.1ms)  SELECT "schema_migrations".* FROM "schema_migrations"
  ActiveRecord::SchemaMigration Load (0.1ms)  SELECT "schema_migrations".* FROM "schema_migrations"
Migrating to AddStockControlBooleanToProducts (20131013131658)
   (0.0ms)  begin transaction
   (0.4ms)  ALTER TABLE "shoppe_products" ADD "stock_control" boolean DEFAULT 't'
  SQL (1.3ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20131013131658"]]
   (2.7ms)  commit transaction
  ActiveRecord::SchemaMigration Load (0.1ms)  SELECT "schema_migrations".* FROM "schema_migrations"
  ActiveRecord::SchemaMigration Load (0.4ms)  SELECT "schema_migrations".* FROM "schema_migrations"
Migrating to CreateShoppeStockLevelAdjustments (20131017144430)
   (0.1ms)  begin transaction
   (0.5ms)  CREATE TABLE "shoppe_stock_level_adjustments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "product_id" integer, "description" varchar(255), "adjustment" integer DEFAULT 0, "parent_type" varchar(255), "parent_id" integer, "created_at" datetime, "updated_at" datetime) 
  SQL (1.6ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20131017144430"]]
   (0.9ms)  commit transaction
  ActiveRecord::SchemaMigration Load (0.2ms)  SELECT "schema_migrations".* FROM "schema_migrations"
  ActiveRecord::SchemaMigration Load (0.1ms)  SELECT "schema_migrations".* FROM "schema_migrations"
  ActiveRecord::SchemaMigration Load (0.1ms)  SELECT "schema_migrations".* FROM "schema_migrations"
Migrating to CreateShoppeStockLevelAdjustments (20131017144430)
   (0.1ms)  begin transaction
   (0.5ms)  DROP TABLE "shoppe_stock_level_adjustments"
  SQL (2.0ms)  DELETE FROM "schema_migrations" WHERE "schema_migrations"."version" = '20131017144430'
   (0.7ms)  commit transaction
  ActiveRecord::SchemaMigration Load (0.1ms)  SELECT "schema_migrations".* FROM "schema_migrations"
  ActiveRecord::SchemaMigration Load (0.1ms)  SELECT "schema_migrations".* FROM "schema_migrations"
Migrating to CreateShoppeStockLevelAdjustments (20131017144430)
   (0.1ms)  begin transaction
   (0.5ms)  CREATE TABLE "shoppe_stock_level_adjustments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "product_id" integer, "description" varchar(255), "adjustment" integer DEFAULT 0, "parent_type" varchar(255), "parent_id" integer, "created_at" datetime, "updated_at" datetime) 
   (1.6ms)  rollback transaction
  ActiveRecord::SchemaMigration Load (0.1ms)  SELECT "schema_migrations".* FROM "schema_migrations"
Migrating to CreateShoppeStockLevelAdjustments (20131017144430)
   (0.1ms)  begin transaction
   (0.5ms)  CREATE TEMPORARY TABLE "ashoppe_products" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "product_category_id" integer, "title" varchar(255), "sku" varchar(255), "permalink" varchar(255), "description" text, "short_description" text, "active" boolean DEFAULT 't', "weight" decimal(8,3) DEFAULT 0.0, "price" decimal(8,2) DEFAULT 0.0, "tax_rate" decimal(8,2) DEFAULT 0.0, "stock" integer DEFAULT 0, "created_at" datetime, "updated_at" datetime, "featured" boolean DEFAULT 'f', "in_the_box" text, "cost_price" decimal(8,2), "stock_control" boolean DEFAULT 't') 
   (0.1ms)  SELECT * FROM "shoppe_products"
   (0.2ms)  DROP TABLE "shoppe_products"
   (0.2ms)  CREATE TABLE "shoppe_products" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "product_category_id" integer, "title" varchar(255), "sku" varchar(255), "permalink" varchar(255), "description" text, "short_description" text, "active" boolean DEFAULT 't', "weight" decimal(8,3) DEFAULT 0.0, "price" decimal(8,2) DEFAULT 0.0, "tax_rate" decimal(8,2) DEFAULT 0.0, "created_at" datetime, "updated_at" datetime, "featured" boolean DEFAULT 'f', "in_the_box" text, "cost_price" decimal(8,2), "stock_control" boolean DEFAULT 't') 
   (0.1ms)  SELECT * FROM "ashoppe_products"
   (0.2ms)  DROP TABLE "ashoppe_products"
  SQL (22.4ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20131017144430"]]
   (2.5ms)  commit transaction
  ActiveRecord::SchemaMigration Load (0.1ms)  SELECT "schema_migrations".* FROM "schema_migrations"
  ActiveRecord::SchemaMigration Load (0.1ms)  SELECT "schema_migrations".* FROM "schema_migrations"
  ActiveRecord::SchemaMigration Load (0.1ms)  SELECT "schema_migrations".* FROM "schema_migrations"
Migrating to CreateShoppeStockLevelAdjustments (20131017144430)
   (0.1ms)  begin transaction
   (0.2ms)  DROP TABLE "shoppe_stock_level_adjustments"
SQLite3::SQLException: no such table: shoppe_stock_level_adjustments: DROP TABLE "shoppe_stock_level_adjustments"
   (0.0ms)  rollback transaction
  ActiveRecord::SchemaMigration Load (0.1ms)  SELECT "schema_migrations".* FROM "schema_migrations"
  ActiveRecord::SchemaMigration Load (0.1ms)  SELECT "schema_migrations".* FROM "schema_migrations"
Migrating to CreateShoppeStockLevelAdjustments (20131017144430)
   (0.1ms)  begin transaction
   (0.2ms)  DROP TABLE "shoppe_stock_level_adjustments"
SQLite3::SQLException: no such table: shoppe_stock_level_adjustments: DROP TABLE "shoppe_stock_level_adjustments"
   (0.0ms)  rollback transaction
  ActiveRecord::SchemaMigration Load (0.1ms)  SELECT "schema_migrations".* FROM "schema_migrations"
  ActiveRecord::SchemaMigration Load (0.1ms)  SELECT "schema_migrations".* FROM "schema_migrations"
Migrating to CreateShoppeStockLevelAdjustments (20131017144430)
   (0.0ms)  begin transaction
   (0.5ms)  ALTER TABLE "shoppe_products" ADD "stock" integer DEFAULT 0
  SQL (1.3ms)  DELETE FROM "schema_migrations" WHERE "schema_migrations"."version" = '20131017144430'
   (2.5ms)  commit transaction
  ActiveRecord::SchemaMigration Load (0.2ms)  SELECT "schema_migrations".* FROM "schema_migrations"
  ActiveRecord::SchemaMigration Load (0.1ms)  SELECT "schema_migrations".* FROM "schema_migrations"
Migrating to CreateShoppeStockLevelAdjustments (20131017144430)
   (0.1ms)  begin transaction
   (0.5ms)  CREATE TABLE "shoppe_stock_level_adjustments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "product_id" integer, "description" varchar(255), "adjustment" integer DEFAULT 0, "parent_type" varchar(255), "parent_id" integer, "created_at" datetime, "updated_at" datetime) 
   (0.4ms)  CREATE TEMPORARY TABLE "ashoppe_products" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "product_category_id" integer, "title" varchar(255), "sku" varchar(255), "permalink" varchar(255), "description" text, "short_description" text, "active" boolean DEFAULT 't', "weight" decimal(8,3) DEFAULT 0.0, "price" decimal(8,2) DEFAULT 0.0, "tax_rate" decimal(8,2) DEFAULT 0.0, "created_at" datetime, "updated_at" datetime, "featured" boolean DEFAULT 'f', "in_the_box" text, "cost_price" decimal(8,2), "stock_control" boolean DEFAULT 't', "stock" integer DEFAULT 0) 
   (0.1ms)  SELECT * FROM "shoppe_products"
   (0.3ms)  DROP TABLE "shoppe_products"
   (0.1ms)  CREATE TABLE "shoppe_products" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "product_category_id" integer, "title" varchar(255), "sku" varchar(255), "permalink" varchar(255), "description" text, "short_description" text, "active" boolean DEFAULT 't', "weight" decimal(8,3) DEFAULT 0.0, "price" decimal(8,2) DEFAULT 0.0, "tax_rate" decimal(8,2) DEFAULT 0.0, "created_at" datetime, "updated_at" datetime, "featured" boolean DEFAULT 'f', "in_the_box" text, "cost_price" decimal(8,2), "stock_control" boolean DEFAULT 't') 
   (0.1ms)  SELECT * FROM "ashoppe_products"
   (0.2ms)  DROP TABLE "ashoppe_products"
  SQL (1.5ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20131017144430"]]
   (2.9ms)  commit transaction
  ActiveRecord::SchemaMigration Load (0.1ms)  SELECT "schema_migrations".* FROM "schema_migrations"
  ActiveRecord::SchemaMigration Load (0.1ms)  SELECT "schema_migrations".* FROM "schema_migrations"
  ActiveRecord::SchemaMigration Load (0.1ms)  SELECT "schema_migrations".* FROM "schema_migrations"
Migrating to CreateShoppeStockLevelAdjustments (20131017144430)
   (0.1ms)  begin transaction
   (0.3ms)  DROP TABLE "shoppe_stock_level_adjustments"
   (0.2ms)  ALTER TABLE "shoppe_products" ADD "stock" integer DEFAULT 0
  SQL (1.3ms)  DELETE FROM "schema_migrations" WHERE "schema_migrations"."version" = '20131017144430'
   (2.2ms)  commit transaction
  ActiveRecord::SchemaMigration Load (0.1ms)  SELECT "schema_migrations".* FROM "schema_migrations"
  ActiveRecord::SchemaMigration Load (0.1ms)  SELECT "schema_migrations".* FROM "schema_migrations"
Migrating to CreateShoppeStockLevelAdjustments (20131017144430)
   (0.1ms)  begin transaction
   (0.7ms)  CREATE TABLE "shoppe_stock_level_adjustments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "product_id" integer, "description" varchar(255), "adjustment" integer DEFAULT 0, "parent_type" varchar(255), "parent_id" integer, "created_at" datetime, "updated_at" datetime) 
   (0.4ms)  CREATE TEMPORARY TABLE "ashoppe_products" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "product_category_id" integer, "title" varchar(255), "sku" varchar(255), "permalink" varchar(255), "description" text, "short_description" text, "active" boolean DEFAULT 't', "weight" decimal(8,3) DEFAULT 0.0, "price" decimal(8,2) DEFAULT 0.0, "tax_rate" decimal(8,2) DEFAULT 0.0, "created_at" datetime, "updated_at" datetime, "featured" boolean DEFAULT 'f', "in_the_box" text, "cost_price" decimal(8,2), "stock_control" boolean DEFAULT 't', "stock" integer DEFAULT 0) 
   (0.1ms)  SELECT * FROM "shoppe_products"
   (0.3ms)  DROP TABLE "shoppe_products"
   (0.1ms)  CREATE TABLE "shoppe_products" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "product_category_id" integer, "title" varchar(255), "sku" varchar(255), "permalink" varchar(255), "description" text, "short_description" text, "active" boolean DEFAULT 't', "weight" decimal(8,3) DEFAULT 0.0, "price" decimal(8,2) DEFAULT 0.0, "tax_rate" decimal(8,2) DEFAULT 0.0, "created_at" datetime, "updated_at" datetime, "featured" boolean DEFAULT 'f', "in_the_box" text, "cost_price" decimal(8,2), "stock_control" boolean DEFAULT 't') 
   (0.1ms)  SELECT * FROM "ashoppe_products"
   (0.2ms)  DROP TABLE "ashoppe_products"
  SQL (2.3ms)  INSERT INTO "schema_migrations" ("version") VALUES (?)  [["version", "20131017144430"]]
   (2.8ms)  commit transaction
  ActiveRecord::SchemaMigration Load (0.2ms)  SELECT "schema_migrations".* FROM "schema_migrations"
   (13.8ms)  CREATE TABLE `shoppe_delivery_service_prices` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `delivery_service_id` int(11), `code` varchar(255), `price` decimal(8,2), `tax_rate` decimal(8,2), `min_weight` decimal(8,2), `max_weight` decimal(8,2), `created_at` datetime, `updated_at` datetime, `cost_price` decimal(8,2)) ENGINE=InnoDB
   (16.5ms)  CREATE TABLE `shoppe_delivery_services` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `name` varchar(255), `code` varchar(255), `default` tinyint(1) DEFAULT 0, `active` tinyint(1) DEFAULT 1, `created_at` datetime, `updated_at` datetime, `courier` varchar(255), `tracking_url` varchar(255)) ENGINE=InnoDB
   (21.9ms)  CREATE TABLE `shoppe_order_items` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `order_id` int(11), `product_id` int(11), `quantity` int(11) DEFAULT 1, `unit_price` decimal(8,2), `tax_amount` decimal(8,2), `tax_rate` decimal(8,2), `weight` decimal(8,3) DEFAULT 0.0, `created_at` datetime, `updated_at` datetime, `unit_cost_price` decimal(8,2)) ENGINE=InnoDB
   (12.0ms)  CREATE TABLE `shoppe_orders` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `token` varchar(255), `first_name` varchar(255), `last_name` varchar(255), `company` varchar(255), `address1` varchar(255), `address2` varchar(255), `address3` varchar(255), `address4` varchar(255), `postcode` varchar(255), `email_address` varchar(255), `phone_number` varchar(255), `status` varchar(255), `received_at` datetime, `accepted_at` datetime, `shipped_at` datetime, `created_at` datetime, `updated_at` datetime, `delivery_service_id` int(11), `delivery_price` decimal(8,2), `delivery_tax_rate` decimal(8,2), `delivery_tax_amount` decimal(8,2), `paid_at` datetime, `accepted_by` int(11), `shipped_by` int(11), `consignment_number` varchar(255), `rejected_at` datetime, `rejected_by` int(11), `ip_address` varchar(255), `country` varchar(255), `payment_reference` varchar(255), `payment_method` varchar(255), `delivery_cost_price` decimal(8,2)) ENGINE=InnoDB
   (10.7ms)  CREATE TABLE `shoppe_product_attributes` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `product_id` int(11), `key` varchar(255), `value` varchar(255), `position` int(11) DEFAULT 1, `searchable` tinyint(1) DEFAULT 1, `created_at` datetime, `updated_at` datetime, `public` tinyint(1) DEFAULT 1) ENGINE=InnoDB
   (12.4ms)  CREATE TABLE `shoppe_product_categories` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `name` varchar(255), `permalink` varchar(255), `description` text, `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB
   (14.5ms)  CREATE TABLE `shoppe_products` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `product_category_id` int(11), `title` varchar(255), `sku` varchar(255), `permalink` varchar(255), `description` text, `short_description` text, `active` tinyint(1) DEFAULT 1, `weight` decimal(8,3) DEFAULT 0.0, `price` decimal(8,2) DEFAULT 0.0, `tax_rate` decimal(8,2) DEFAULT 0.0, `created_at` datetime, `updated_at` datetime, `featured` tinyint(1) DEFAULT 0, `in_the_box` text, `cost_price` decimal(8,2), `stock_control` tinyint(1) DEFAULT 1) ENGINE=InnoDB
   (12.1ms)  CREATE TABLE `shoppe_stock_level_adjustments` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `product_id` int(11), `description` varchar(255), `adjustment` int(11) DEFAULT 0, `parent_type` varchar(255), `parent_id` int(11), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB
   (11.5ms)  CREATE TABLE `shoppe_users` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `first_name` varchar(255), `last_name` varchar(255), `email_address` varchar(255), `password_digest` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB
   (13.7ms)  CREATE TABLE `schema_migrations` (`version` varchar(255) NOT NULL) ENGINE=InnoDB
   (25.9ms)  CREATE UNIQUE INDEX `unique_schema_migrations` ON `schema_migrations` (`version`) 
   (0.2ms)  SELECT version FROM `schema_migrations`
   (0.4ms)  INSERT INTO `schema_migrations` (version) VALUES ('20131017144430')
   (0.3ms)  INSERT INTO `schema_migrations` (version) VALUES ('20130926094549')
   (0.3ms)  INSERT INTO `schema_migrations` (version) VALUES ('20131012123829')
   (0.2ms)  INSERT INTO `schema_migrations` (version) VALUES ('20131012163301')
   (0.2ms)  INSERT INTO `schema_migrations` (version) VALUES ('20131013123937')
   (0.3ms)  INSERT INTO `schema_migrations` (version) VALUES ('20131013131658')
  ActiveRecord::SchemaMigration Load (0.2ms)  SELECT `schema_migrations`.* FROM `schema_migrations`
Migrating to CreateNiftyAttachmentsTable (20131017165217)
   (17.0ms)  CREATE TABLE `nifty_attachments` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `parent_id` int(11), `parent_type` varchar(255), `token` varchar(255), `digest` varchar(255), `role` varchar(255), `file_name` varchar(255), `file_type` varchar(255), `data` blob(10485760), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB
   (0.1ms)  BEGIN
  SQL (1.4ms)  INSERT INTO `schema_migrations` (`version`) VALUES ('20131017165217')
   (0.3ms)  COMMIT
Migrating to CreateNiftyKeyValueStoreTable (20131017165222)
   (10.2ms)  CREATE TABLE `nifty_key_value_store` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `parent_id` int(11), `parent_type` varchar(255), `group` varchar(255), `name` varchar(255), `value` varchar(255)) ENGINE=InnoDB
   (0.1ms)  BEGIN
  SQL (0.2ms)  INSERT INTO `schema_migrations` (`version`) VALUES ('20131017165222')
   (0.3ms)  COMMIT
  ActiveRecord::SchemaMigration Load (0.2ms)  SELECT `schema_migrations`.* FROM `schema_migrations`
  ActiveRecord::SchemaMigration Load (0.2ms)  SELECT `schema_migrations`.* FROM `schema_migrations`
  ActiveRecord::SchemaMigration Load (0.1ms)  SELECT `schema_migrations`.* FROM `schema_migrations`
  ActiveRecord::SchemaMigration Load (0.2ms)  SELECT `schema_migrations`.* FROM `schema_migrations`
Migrating to CreateShoppeCountries (20131017180920)
   (18.7ms)  CREATE TABLE `shoppe_countries` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `name` varchar(255), `code2` varchar(255), `code3` varchar(255), `continent` varchar(255), `tld` varchar(255), `currency` varchar(255), `eu_member` tinyint(1) DEFAULT 0) ENGINE=InnoDB
   (0.1ms)  BEGIN
  SQL (1.7ms)  INSERT INTO `schema_migrations` (`version`) VALUES ('20131017180920')
   (0.3ms)  COMMIT
  ActiveRecord::SchemaMigration Load (0.2ms)  SELECT `schema_migrations`.* FROM `schema_migrations`
  ActiveRecord::SchemaMigration Load (0.3ms)  SELECT `schema_migrations`.* FROM `schema_migrations`
  ActiveRecord::SchemaMigration Load (0.1ms)  SELECT `schema_migrations`.* FROM `schema_migrations`
Migrating to CreateShoppeCountries (20131017180920)
   (0.8ms)  DROP TABLE `shoppe_countries`
  SQL (1.6ms)  DELETE FROM `schema_migrations` WHERE `schema_migrations`.`version` = '20131017180920'
  ActiveRecord::SchemaMigration Load (0.2ms)  SELECT `schema_migrations`.* FROM `schema_migrations`
  ActiveRecord::SchemaMigration Load (0.7ms)  SELECT `schema_migrations`.* FROM `schema_migrations`
Migrating to CreateShoppeCountries (20131017180920)
   (16.5ms)  CREATE TABLE `shoppe_countries` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `name` varchar(255), `code2` varchar(255), `code3` varchar(255), `continent` varchar(255), `tld` varchar(255), `currency` varchar(255), `eu_member` tinyint(1) DEFAULT 0) ENGINE=InnoDB
   (24.1ms)  ALTER TABLE `shoppe_orders` ADD `country_id` int(11) AFTER `postcode`
   (20.5ms)  ALTER TABLE `shoppe_orders` DROP `country`
   (0.1ms)  BEGIN
  SQL (1.9ms)  INSERT INTO `schema_migrations` (`version`) VALUES ('20131017180920')
   (0.3ms)  COMMIT
Migrating to CreateShoppeTaxRates (20131017183211)
   (8.9ms)  CREATE TABLE `shoppe_tax_rates` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `name` varchar(255), `rate` decimal(8,2), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB
   (24.2ms)  ALTER TABLE `shoppe_products` ADD `tax_rate_id` int(11) AFTER `tax_rate`
   (17.3ms)  ALTER TABLE `shoppe_products` DROP `tax_rate`
   (14.6ms)  ALTER TABLE `shoppe_delivery_service_prices` ADD `tax_rate_id` int(11) AFTER `tax_rate`
   (16.9ms)  ALTER TABLE `shoppe_delivery_service_prices` DROP `tax_rate`
   (0.1ms)  BEGIN
  SQL (0.2ms)  INSERT INTO `schema_migrations` (`version`) VALUES ('20131017183211')
   (0.3ms)  COMMIT
Migrating to AddCountriesToTaxRatesAndDeliveryPrices (20131020204719)
   (19.4ms)  ALTER TABLE `shoppe_delivery_service_prices` ADD `country_ids` text
   (19.5ms)  ALTER TABLE `shoppe_tax_rates` ADD `country_ids` text
   (0.1ms)  BEGIN
  SQL (0.2ms)  INSERT INTO `schema_migrations` (`version`) VALUES ('20131020204719')
   (0.3ms)  COMMIT
  ActiveRecord::SchemaMigration Load (0.2ms)  SELECT `schema_migrations`.* FROM `schema_migrations`
  ActiveRecord::SchemaMigration Load (1.0ms)  SELECT `schema_migrations`.* FROM `schema_migrations`
Migrating to AddNotesToOrders (20131021135208)
   (25.9ms)  ALTER TABLE `shoppe_orders` ADD `notes` text
   (0.1ms)  BEGIN
  SQL (1.7ms)  INSERT INTO `schema_migrations` (`version`) VALUES ('20131021135208')
   (0.4ms)  COMMIT
  ActiveRecord::SchemaMigration Load (0.1ms)  SELECT `schema_migrations`.* FROM `schema_migrations`