(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"