ActiveRecord::SchemaMigration Load (16.7ms) SELECT `schema_migrations`.* FROM `schema_migrations` ActiveRecord::SchemaMigration Load (0.5ms) SELECT `schema_migrations`.* FROM `schema_migrations`  (26.0ms) CREATE TABLE `schema_migrations` (`version` varchar(255) NOT NULL) ENGINE=InnoDB  (30.0ms) CREATE UNIQUE INDEX `unique_schema_migrations` ON `schema_migrations` (`version`) ActiveRecord::SchemaMigration Load (0.1ms) SELECT `schema_migrations`.* FROM `schema_migrations` Migrating to GemgentoZeroNineZero (20131114161934)  (22.1ms) CREATE TABLE `gemgento_addresses` (`id` int(11) auto_increment PRIMARY KEY, `user_address_id` int(11), `user_id` int(11), `increment_id` varchar(255), `city` varchar(255), `company` varchar(255), `country_id` int(11), `fax` varchar(255), `fname` varchar(255), `mname` varchar(255), `lname` varchar(255), `postcode` varchar(255), `prefix` varchar(255), `suffix` varchar(255), `region_name` varchar(255), `region_id` int(11), `street` varchar(255), `telephone` varchar(255), `address_type` varchar(255), `sync_needed` tinyint(1) DEFAULT 1 NOT NULL, `created_at` datetime, `updated_at` datetime, `order_address_id` int(11), `order_id` int(11), `is_default` tinyint(1) DEFAULT 0) ENGINE=InnoDB DEFAULT CHARSET=utf8  (13.6ms) CREATE TABLE `gemgento_asset_types` (`id` int(11) auto_increment PRIMARY KEY, `product_attribute_set_id` int(11), `code` varchar(255), `scope` varchar(255), `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8  (13.7ms) CREATE TABLE `gemgento_assets` (`id` int(11) auto_increment PRIMARY KEY, `product_id` int(11), `url` varchar(255), `position` int(11), `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL, `file` varchar(255), `label` varchar(255), `sync_needed` tinyint(1) DEFAULT 1 NOT NULL, `attachment_file_name` varchar(255), `attachment_content_type` varchar(255), `attachment_file_size` int(11), `attachment_updated_at` datetime) ENGINE=InnoDB DEFAULT CHARSET=utf8  (14.5ms) CREATE TABLE `gemgento_assets_asset_types` (`asset_id` int(11) DEFAULT 0 NOT NULL, `asset_type_id` int(11) DEFAULT 0 NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8  (13.5ms) CREATE TABLE `gemgento_attribute_set_attributes` (`attribute_set_id` int(11) DEFAULT 0 NOT NULL, `attribute_id` int(11) DEFAULT 0 NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8  (14.0ms) CREATE TABLE `gemgento_categories` (`id` int(11) auto_increment PRIMARY KEY, `magento_id` int(11), `name` varchar(255), `url_key` varchar(255), `parent_id` int(11), `position` int(11), `is_active` tinyint(1), `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL, `all_children` text, `children_count` int(11), `sync_needed` tinyint(1) DEFAULT 1 NOT NULL, `include_in_menu` tinyint(1) DEFAULT 1 NOT NULL, `image_file_name` varchar(255), `image_content_type` varchar(255), `image_file_size` int(11), `image_updated_at` datetime) ENGINE=InnoDB DEFAULT CHARSET=utf8  (12.6ms) CREATE UNIQUE INDEX `index_gemgento_categories_on_magento_id` USING btree ON `gemgento_categories` (`magento_id`)  (16.0ms) CREATE TABLE `gemgento_categories_products` (`product_id` int(11) DEFAULT 0 NOT NULL, `category_id` int(11) DEFAULT 0 NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8  (13.8ms) CREATE TABLE `gemgento_configurable_attributes` (`product_id` int(11) DEFAULT 0 NOT NULL, `product_attribute_id` int(11) DEFAULT 0 NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8  (12.8ms) CREATE TABLE `gemgento_configurable_simple_relations` (`configurable_product_id` int(11) DEFAULT 0 NOT NULL, `simple_product_id` int(11) DEFAULT 0 NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8  (15.7ms) CREATE TABLE `gemgento_countries` (`id` int(11) auto_increment PRIMARY KEY, `magento_id` varchar(255) NOT NULL, `iso2_code` varchar(255), `iso3_code` varchar(255), `name` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB DEFAULT CHARSET=utf8  (14.7ms) CREATE TABLE `gemgento_gift_messages` (`id` int(11) auto_increment PRIMARY KEY, `magento_id` int(11), `to` varchar(255), `from` varchar(255), `message` text) ENGINE=InnoDB DEFAULT CHARSET=utf8  (14.8ms) CREATE TABLE `gemgento_inventories` (`id` int(11) auto_increment PRIMARY KEY, `product_id` int(11) NOT NULL, `quantity` int(11) DEFAULT 0 NOT NULL, `is_in_stock` tinyint(1) DEFAULT 0 NOT NULL, `sync_needed` tinyint(1) DEFAULT 1 NOT NULL, `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB DEFAULT CHARSET=utf8  (13.8ms) CREATE TABLE `gemgento_magento_responses` (`id` int(11) auto_increment PRIMARY KEY, `request` text, `body` mediumtext, `created_at` datetime, `updated_at` datetime, `success` tinyint(1) DEFAULT 1 NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8  (13.0ms) CREATE TABLE `gemgento_order_addresses` (`id` int(11) auto_increment PRIMARY KEY, `order_id` int(11) NOT NULL, `increment_id` int(11), `is_active` tinyint(1) DEFAULT 1 NOT NULL, `address_type` varchar(255), `fname` varchar(255), `lname` varchar(255), `company_name` varchar(255), `street` varchar(255), `city` varchar(255), `region_name` varchar(255), `region_id` int(11), `postcode` varchar(255), `country_id` int(11), `telephone` varchar(255), `fax` varchar(255), `address_id` int(11), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB DEFAULT CHARSET=utf8  (12.2ms) CREATE TABLE `gemgento_order_items` (`id` int(11) auto_increment PRIMARY KEY, `magento_id` int(11), `order_id` int(11), `quote_item_id` int(11), `product_id` int(11), `product_type` varchar(255), `product_options` text, `weight` decimal(12,4), `is_virtual` tinyint(1), `sku` varchar(255), `name` varchar(255), `applied_rule_ids` varchar(255), `free_shipping` tinyint(1), `is_qty_decimal` tinyint(1), `no_discount` tinyint(1), `qty_canceled` decimal(12,4), `qty_invoiced` decimal(12,4), `qty_ordered` decimal(12,4), `qty_refunded` decimal(12,4), `qty_shipped` decimal(12,4), `cost` decimal(12,4), `price` decimal(12,4), `base_price` decimal(12,4), `original_price` decimal(12,4), `base_original_price` decimal(12,4), `tax_percent` decimal(12,4), `tax_amount` decimal(12,4), `base_tax_amount` decimal(12,4), `tax_invoiced` decimal(12,4), `base_tax_invoiced` decimal(12,4), `discount_percent` decimal(12,4), `discount_amount` decimal(12,4), `base_discount_amount` decimal(12,4), `discount_invoiced` decimal(12,4), `base_discount_invoiced` decimal(12,4), `amount_refunded` decimal(12,4), `base_amount_refunded` decimal(12,4), `row_total` decimal(12,4), `base_row_total` decimal(12,4), `row_invoiced` decimal(12,4), `base_row_invoiced` decimal(12,4), `row_weight` decimal(12,4), `gift_message_id` varchar(255), `gift_message` varchar(255), `gift_message_available` varchar(255), `base_tax_before_discount` decimal(12,4), `tax_before_discount` decimal(12,4), `weee_tax_applied` decimal(12,4), `weee_tax_applied_amount` decimal(12,4), `weee_tax_applied_row_amount` decimal(12,4), `base_weee_tax_applied_amount` decimal(12,4), `base_weee_tax_applied_row_amount` decimal(12,4), `weee_tax_disposition` decimal(12,4), `weee_tax_row_disposition` decimal(12,4), `base_weee_tax_disposition` decimal(12,4), `base_weee_tax_row_disposition` decimal(12,4), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB DEFAULT CHARSET=utf8  (14.4ms) CREATE TABLE `gemgento_order_payments` (`id` int(11) auto_increment PRIMARY KEY, `magento_id` int(11), `order_id` int(11) NOT NULL, `increment_id` int(11), `is_active` tinyint(1) DEFAULT 1, `amount_ordered` decimal(12,4), `shipping_amount` decimal(12,4), `base_amount_ordered` decimal(12,4), `base_shipping_amount` decimal(12,4), `method` varchar(255), `po_number` varchar(255), `cc_type` varchar(255), `cc_number_enc` varchar(255), `cc_last4` varchar(255), `cc_owner` varchar(255), `cc_exp_month` varchar(255), `cc_exp_year` varchar(255), `cc_ss_start_month` varchar(255), `cc_ss_start_year` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB DEFAULT CHARSET=utf8  (12.5ms) CREATE TABLE `gemgento_order_statuses` (`id` int(11) auto_increment PRIMARY KEY, `order_id` int(11) NOT NULL, `increment_id` int(11), `is_active` tinyint(1) DEFAULT 1, `is_customer_notified` int(11) DEFAULT 1, `status` varchar(255), `comment` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB DEFAULT CHARSET=utf8  (13.4ms) CREATE TABLE `gemgento_orders` (`id` int(11) auto_increment PRIMARY KEY, `order_id` int(11), `store_id` int(11) NOT NULL, `is_active` tinyint(1), `user_id` int(11), `tax_amount` decimal(12,4), `shipping_amount` decimal(12,4), `discount_amount` decimal(12,4), `subtotal` decimal(12,4), `grand_total` decimal(12,4), `total_paid` decimal(12,4), `total_refunded` decimal(12,4), `total_qty_ordered` decimal(12,4), `total_canceled` decimal(12,4), `total_invoiced` decimal(12,4), `total_online_refunded` decimal(12,4), `total_offline_refunded` decimal(12,4), `base_tax_amount` decimal(12,4), `base_shipping_amount` decimal(12,4), `base_discount_amount` decimal(12,4), `base_subtotal` decimal(12,4), `base_grand_total` decimal(12,4), `base_total_paid` decimal(12,4), `base_total_refunded` decimal(12,4), `base_total_qty_ordered` decimal(12,4), `base_total_canceled` decimal(12,4), `base_total_invoiced` decimal(12,4), `base_total_online_refunded` decimal(12,4), `base_total_offline_refunded` decimal(12,4), `billing_address_id` int(11), `billing_fname` varchar(255), `billing_lname` varchar(255), `shipping_address_id` int(11), `shipping_fname` varchar(255), `shipping_lname` varchar(255), `billing_name` varchar(255), `shipping_name` varchar(255), `store_to_base_rate` varchar(255), `store_to_order_rate` varchar(255), `base_to_global_rate` varchar(255), `base_to_order_rate` varchar(255), `weight` decimal(12,4), `store_name` varchar(255), `remote_ip` varchar(255), `status` varchar(255), `state` varchar(255), `applied_rule_ids` varchar(255), `global_currency_code` varchar(255), `base_currency_code` varchar(255), `store_currency_code` varchar(255), `order_currency_code` varchar(255), `shipping_method` varchar(255), `shipping_description` varchar(255), `customer_email` varchar(255), `customer_firstname` varchar(255), `customer_lastname` varchar(255), `magento_quote_id` varchar(255), `is_virtual` tinyint(1), `user_group_id` int(11), `customer_note_notify` varchar(255), `customer_is_guest` tinyint(1), `email_sent` tinyint(1), `increment_id` varchar(255), `gift_message_id` varchar(255), `gift_message` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB DEFAULT CHARSET=utf8  (14.3ms) CREATE TABLE `gemgento_product_attribute_options` (`id` int(11) auto_increment PRIMARY KEY, `product_attribute_id` int(11), `label` varchar(255), `value` varchar(255), `sync_needed` tinyint(1) DEFAULT 1 NOT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL, `order` int(11)) ENGINE=InnoDB DEFAULT CHARSET=utf8  (16.1ms) CREATE TABLE `gemgento_product_attribute_sets` (`id` int(11) auto_increment PRIMARY KEY, `magento_id` int(11), `name` varchar(255), `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL, `sync_needed` tinyint(1) DEFAULT 1 NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8  (14.3ms) CREATE TABLE `gemgento_product_attribute_values` (`id` int(11) auto_increment PRIMARY KEY, `product_id` int(11), `product_attribute_id` int(11), `value` text, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8  (12.8ms) CREATE TABLE `gemgento_product_attributes` (`id` int(11) auto_increment PRIMARY KEY, `magento_id` int(11), `code` varchar(255), `frontend_input` varchar(255), `scope` varchar(255), `is_unique` tinyint(1), `is_required` tinyint(1), `is_configurable` tinyint(1), `is_searchable` tinyint(1), `is_visible_in_advanced_search` tinyint(1), `is_comparable` tinyint(1), `is_used_for_promo_rules` tinyint(1), `is_visible_on_front` tinyint(1), `used_in_product_listing` tinyint(1), `sync_needed` tinyint(1) DEFAULT 1 NOT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL, `default_value` text) ENGINE=InnoDB DEFAULT CHARSET=utf8  (11.6ms) CREATE TABLE `gemgento_product_categories` (`id` int(11) auto_increment PRIMARY KEY, `category_id` int(11), `product_id` int(11), `position` int(11) DEFAULT 0 NOT NULL, `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB DEFAULT CHARSET=utf8  (14.3ms) CREATE TABLE `gemgento_product_imports` (`id` int(11) auto_increment PRIMARY KEY, `import_errors` text, `created_at` datetime, `updated_at` datetime, `spreadsheet_file_name` varchar(255), `spreadsheet_content_type` varchar(255), `spreadsheet_file_size` int(11), `spreadsheet_updated_at` datetime, `include_images` tinyint(1), `image_path` varchar(255), `image_labels` text, `store_id` int(11), `root_category_id` int(11), `product_attribute_set_id` int(11), `count_created` int(11), `count_updated` int(11), `simple_product_visibility` int(11), `configurable_product_visibility` int(11), `image_file_extensions` text) ENGINE=InnoDB DEFAULT CHARSET=utf8  (11.3ms) CREATE TABLE `gemgento_product_imports_configurable_attributes` (`product_import_id` int(11) DEFAULT 0 NOT NULL, `product_attribute_id` int(11) DEFAULT 0 NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8  (14.6ms) CREATE TABLE `gemgento_products` (`id` int(11) auto_increment PRIMARY KEY, `magento_id` int(11), `magento_type` varchar(255), `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL, `sku` varchar(255), `product_attribute_set_id` varchar(255), `store_id` varchar(255), `sync_needed` tinyint(1) DEFAULT 1 NOT NULL, `status` tinyint(1) DEFAULT 1, `visibility` int(11) DEFAULT 4, `deleted_at` datetime) ENGINE=InnoDB DEFAULT CHARSET=utf8  (13.6ms) CREATE TABLE `gemgento_regions` (`id` int(11) auto_increment PRIMARY KEY, `magento_id` int(11) NOT NULL, `code` varchar(255), `name` varchar(255), `country_id` int(11), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB DEFAULT CHARSET=utf8  (11.7ms) CREATE TABLE `gemgento_relation_types` (`id` int(11) auto_increment PRIMARY KEY, `name` varchar(255), `description` text, `applies_to` varchar(255), `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8  (12.0ms) CREATE TABLE `gemgento_relations` (`id` int(11) auto_increment PRIMARY KEY, `relation_type_id` int(11), `relatable_id` int(11), `relatable_type` varchar(255), `related_to_id` int(11), `related_to_type` varchar(255), `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8  (16.8ms) CREATE TABLE `gemgento_sessions` (`id` int(11) auto_increment PRIMARY KEY, `session_id` varchar(255), `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8  (11.9ms) CREATE TABLE `gemgento_stores` (`id` int(11) auto_increment PRIMARY KEY, `magento_id` int(11) NOT NULL, `code` varchar(255), `group_id` int(11), `name` varchar(255), `sort_order` int(11), `is_active` tinyint(1) DEFAULT 1 NOT NULL, `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB DEFAULT CHARSET=utf8  (14.6ms) CREATE UNIQUE INDEX `index_gemgento_stores_on_magento_id` USING btree ON `gemgento_stores` (`magento_id`)  (16.0ms) CREATE TABLE `gemgento_syncs` (`id` int(11) auto_increment PRIMARY KEY, `subject` varchar(255), `created_at` datetime, `updated_at` datetime, `is_complete` tinyint(1) DEFAULT 0) ENGINE=InnoDB DEFAULT CHARSET=utf8  (12.7ms) CREATE TABLE `gemgento_user_groups` (`id` int(11) auto_increment PRIMARY KEY, `magento_id` int(11), `code` varchar(255), `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8  (12.2ms) CREATE TABLE `gemgento_users` (`id` int(11) auto_increment PRIMARY KEY, `magento_id` int(11), `store_id` int(11), `created_in` varchar(255), `email` varchar(255) DEFAULT '' NOT NULL, `fname` varchar(255), `lname` varchar(255), `mname` varchar(255), `user_group_id` int(11), `prefix` varchar(255), `suffix` varchar(255), `dob` date, `taxvat` varchar(255), `confirmation` tinyint(1), `magento_password` varchar(255), `sync_needed` tinyint(1) DEFAULT 1 NOT NULL, `created_at` datetime, `updated_at` datetime, `increment_id` int(11), `encrypted_password` varchar(255) DEFAULT '' NOT NULL, `reset_password_token` varchar(255), `reset_password_sent_at` datetime, `remember_created_at` datetime, `sign_in_count` int(11) DEFAULT 0, `current_sign_in_at` datetime, `last_sign_in_at` datetime, `current_sign_in_ip` varchar(255), `last_sign_in_ip` varchar(255), `unencrypted_password` varchar(255), `type` varchar(255)) ENGINE=InnoDB DEFAULT CHARSET=utf8  (12.0ms) CREATE UNIQUE INDEX `index_gemgento_users_on_email` USING btree ON `gemgento_users` (`email`)  (15.1ms) CREATE UNIQUE INDEX `index_gemgento_users_on_magento_id` USING btree ON `gemgento_users` (`magento_id`)   (12.1ms) CREATE UNIQUE INDEX `index_gemgento_users_on_reset_password_token` USING btree ON `gemgento_users` (`reset_password_token`)  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20131114161934')  (5.7ms) COMMIT Migrating to AddStoreIdToProductAttributeOptions (20131122133642)  (29.1ms) ALTER TABLE `gemgento_product_attribute_options` ADD `store_id` int(11)  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20131122133642')  (0.2ms) COMMIT Migrating to RenameAttributeSetJoinTableColumns (20131122145637)  (20.9ms) ALTER TABLE `gemgento_attribute_set_attributes` CHANGE `attribute_set_id` `product_attribute_set_id` int(11) DEFAULT 0 NOT NULL  (10.9ms) ALTER TABLE `gemgento_attribute_set_attributes` CHANGE `attribute_id` `product_attribute_id` int(11) DEFAULT 0 NOT NULL  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20131122145637')  (0.3ms) COMMIT Migrating to AddWebsiteIdToGemgentoStores (20131122183022)  (28.8ms) ALTER TABLE `gemgento_stores` ADD `website_id` int(11)  (0.1ms) BEGIN SQL (0.1ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20131122183022')  (0.2ms) COMMIT Migrating to CreateGemgentoStoresProducts (20131213161143)  (27.9ms) CREATE TABLE `gemgento_stores_products` (`id` int(11) auto_increment PRIMARY KEY, `product_id` int(11), `store_id` int(11)) ENGINE=InnoDB DEFAULT CHARSET=utf8  (15.9ms) ALTER TABLE `gemgento_products` DROP `store_id`  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20131213161143')  (0.3ms) COMMIT Migrating to AddStoresToProductAttributeValues (20131213163410)  (30.5ms) ALTER TABLE `gemgento_product_attribute_values` ADD `store_id` int(11)  (0.2ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20131213163410')  (0.3ms) COMMIT Migrating to CreateGemgentoCategoriesStores (20131213172603)  (28.2ms) CREATE TABLE `gemgento_categories_stores` (`id` int(11) auto_increment PRIMARY KEY, `category_id` int(11), `store_id` int(11)) ENGINE=InnoDB DEFAULT CHARSET=utf8  (15.3ms) ALTER TABLE `gemgento_product_categories` ADD `store_id` int(11)  (1.3ms) DROP TABLE `gemgento_categories_products`  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20131213172603')  (0.2ms) COMMIT Migrating to CreateGemgentoStoresUsers (20131220141725)  (26.8ms) CREATE TABLE `gemgento_stores_users` (`id` int(11) auto_increment PRIMARY KEY, `store_id` int(11), `user_id` int(11)) ENGINE=InnoDB DEFAULT CHARSET=utf8  (14.7ms) ALTER TABLE `gemgento_users` DROP `store_id`  (0.1ms) BEGIN SQL (0.1ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20131220141725')  (0.2ms) COMMIT Migrating to CreateGemgentoAssetFiles (20131220160544)  (30.1ms) ALTER TABLE `gemgento_assets` ADD `store_id` int(11)  (13.3ms) ALTER TABLE `gemgento_assets` ADD `asset_file_id` int(11)  (11.9ms) CREATE TABLE `gemgento_asset_files` (`id` int(11) auto_increment PRIMARY KEY, `file_file_name` varchar(255), `file_content_type` varchar(255), `file_file_size` int(11), `file_updated_at` datetime) ENGINE=InnoDB DEFAULT CHARSET=utf8  (13.6ms) ALTER TABLE `gemgento_assets` DROP `attachment_file_name`  (13.5ms) ALTER TABLE `gemgento_assets` DROP `attachment_content_type`  (15.4ms) ALTER TABLE `gemgento_assets` DROP `attachment_file_size`  (13.8ms) ALTER TABLE `gemgento_assets` DROP `attachment_updated_at`  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20131220160544')  (0.2ms) COMMIT Migrating to AddImageTypesToGemgentoProductImport (20131223181709)  (28.9ms) ALTER TABLE `gemgento_product_imports` ADD `image_types` text  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20131223181709')  (0.2ms) COMMIT Migrating to AddStoreIdToGemgentoInventories (20140116154244)  (29.2ms) ALTER TABLE `gemgento_inventories` ADD `store_id` int(11)  (0.1ms) BEGIN SQL (0.1ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20140116154244')  (0.2ms) COMMIT Migrating to AddUseDefaultWebsiteValuesToGemgentoInventories (20140120124655)  (28.2ms) ALTER TABLE `gemgento_inventories` ADD `use_default_website_stock` tinyint(1) DEFAULT 1  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20140120124655')  (0.2ms) COMMIT Migrating to CreateGemgentoApiJobs (20140120144719)  (27.5ms) CREATE TABLE `gemgento_api_jobs` (`id` int(11) auto_increment PRIMARY KEY, `source_id` int(11), `kind` varchar(255), `state` varchar(255), `source_type` varchar(255), `url` varchar(255), `request` text, `response` text, `locked` tinyint(1), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB DEFAULT CHARSET=utf8  (0.2ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20140120144719')  (0.3ms) COMMIT Migrating to DropGemgentoOrderAddresses (20140121164640)  (22.5ms) DROP TABLE `gemgento_order_addresses`  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20140121164640')  (4.7ms) COMMIT Migrating to RecreateGemgentoApiJobs (20140121174243)  (22.6ms) DROP TABLE `gemgento_api_jobs`  (11.5ms) CREATE TABLE `gemgento_api_jobs` (`id` int(11) auto_increment PRIMARY KEY, `source_id` int(11), `kind` varchar(255), `state` varchar(255), `source_type` varchar(255), `request_url` varchar(255), `request` text, `response` text, `locked` tinyint(1), `request_body` text, `request_status` varchar(255), `response_status` varchar(255), `type` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB DEFAULT CHARSET=utf8  (0.1ms) BEGIN SQL (0.1ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20140121174243')  (0.1ms) COMMIT Migrating to AddCurrencyCodeToGemgentoStores (20140127215049)  (29.8ms) ALTER TABLE `gemgento_stores` ADD `currency_code` varchar(255) DEFAULT 'usd'  (0.1ms) BEGIN SQL (0.1ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20140127215049')  (0.2ms) COMMIT Migrating to CreateGemgentoSubscriber (20140129220352)  (25.6ms) CREATE TABLE `gemgento_subscribers` (`id` int(11) auto_increment PRIMARY KEY, `fname` varchar(255), `lname` varchar(255), `email` varchar(255), `country_id` int(11), `city` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB DEFAULT CHARSET=utf8  (0.2ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20140129220352')  (0.2ms) COMMIT Migrating to RenameNames (20140130180722)  (26.8ms) ALTER TABLE `gemgento_addresses` CHANGE `fname` `first_name` varchar(255) DEFAULT NULL  (10.2ms) ALTER TABLE `gemgento_addresses` CHANGE `lname` `last_name` varchar(255) DEFAULT NULL  (10.5ms) ALTER TABLE `gemgento_addresses` CHANGE `mname` `middle_name` varchar(255) DEFAULT NULL  (12.4ms) ALTER TABLE `gemgento_orders` CHANGE `billing_fname` `billing_first_name` varchar(255) DEFAULT NULL  (10.9ms) ALTER TABLE `gemgento_orders` CHANGE `billing_lname` `billing_last_name` varchar(255) DEFAULT NULL  (16.2ms) ALTER TABLE `gemgento_orders` CHANGE `shipping_fname` `shipping_first_name` varchar(255) DEFAULT NULL  (11.8ms) ALTER TABLE `gemgento_orders` CHANGE `shipping_lname` `shipping_last_name` varchar(255) DEFAULT NULL  (13.5ms) ALTER TABLE `gemgento_users` CHANGE `fname` `first_name` varchar(255) DEFAULT NULL  (12.9ms) ALTER TABLE `gemgento_users` CHANGE `lname` `last_name` varchar(255) DEFAULT NULL  (13.5ms) ALTER TABLE `gemgento_users` CHANGE `mname` `middle_name` varchar(255) DEFAULT NULL  (10.2ms) ALTER TABLE `gemgento_subscribers` CHANGE `fname` `first_name` varchar(255) DEFAULT NULL  (13.0ms) ALTER TABLE `gemgento_subscribers` CHANGE `lname` `last_name` varchar(255) DEFAULT NULL  (0.1ms) BEGIN SQL (0.5ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20140130180722')  (0.3ms) COMMIT Migrating to AddGenderToGemgentoUsers (20140201185453)  (32.3ms) ALTER TABLE `gemgento_users` ADD `gender` varchar(255)  (0.1ms) BEGIN SQL (0.1ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20140201185453')  (0.2ms) COMMIT Migrating to AddSyncNeededToGemgentoProductCategories (20140203201046)  (27.7ms) ALTER TABLE `gemgento_product_categories` ADD `sync_needed` tinyint(1) DEFAULT 0  (0.1ms) BEGIN SQL (0.1ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20140203201046')  (0.2ms) COMMIT Migrating to AddGemgentoIndexes (20140207154554)  (25.1ms) CREATE INDEX `index_gemgento_assets_on_product_id` ON `gemgento_assets` (`product_id`)   (11.9ms) CREATE INDEX `index_gemgento_assets_on_store_id` ON `gemgento_assets` (`store_id`)  (15.8ms) CREATE UNIQUE INDEX `attribute_set_attributes_index` ON `gemgento_attribute_set_attributes` (`product_attribute_set_id`, `product_attribute_id`)   (13.0ms) CREATE INDEX `attribute_set_product_attributes_index` ON `gemgento_attribute_set_attributes` (`product_attribute_id`)  (12.5ms) CREATE UNIQUE INDEX `categories_index` ON `gemgento_categories_stores` (`category_id`, `store_id`)   (11.2ms) CREATE INDEX `category_store_index` ON `gemgento_categories_stores` (`store_id`)  (13.1ms) CREATE UNIQUE INDEX `configurable_attributes_index` ON `gemgento_configurable_attributes` (`product_id`, `product_attribute_id`)   (11.3ms) CREATE INDEX `configurable_attribute_product_attribute_index` ON `gemgento_configurable_attributes` (`product_attribute_id`)  (12.2ms) CREATE UNIQUE INDEX `inventories_index` ON `gemgento_inventories` (`product_id`, `store_id`)   (14.1ms) CREATE INDEX `inventory_store_index` ON `gemgento_inventories` (`store_id`)  (13.6ms) CREATE INDEX `order_items_index` ON `gemgento_order_items` (`order_id`)   (14.5ms) CREATE INDEX `order_payments_index` ON `gemgento_order_payments` (`order_id`)  (13.5ms) CREATE INDEX `order_statuses_index` ON `gemgento_order_statuses` (`order_id`)   (13.1ms) CREATE INDEX `attribute_options_index` ON `gemgento_product_attribute_options` (`product_attribute_id`, `store_id`)  (12.0ms) CREATE INDEX `product_attribute_option_store_index` ON `gemgento_product_attribute_options` (`store_id`)   (11.1ms) CREATE INDEX `product_attribute_values_index` ON `gemgento_product_attribute_values` (`product_id`)  (14.7ms) CREATE INDEX `product_attribute_values_product_attribute_index` ON `gemgento_product_attribute_values` (`product_attribute_id`)   (16.1ms) CREATE UNIQUE INDEX `configurable_simple_index` ON `gemgento_configurable_simple_relations` (`configurable_product_id`, `simple_product_id`)  (11.8ms) CREATE INDEX `product_categories_category_index` ON `gemgento_product_categories` (`category_id`)   (14.2ms) CREATE INDEX `product_categories_product_index` ON `gemgento_product_categories` (`product_id`)  (12.6ms) CREATE UNIQUE INDEX `stores_products_index` ON `gemgento_stores_products` (`product_id`, `store_id`)   (12.4ms) CREATE INDEX `store_product_store_index` ON `gemgento_stores_products` (`store_id`)  (0.1ms) BEGIN SQL (0.1ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20140207154554')  (0.2ms) COMMIT Migrating to CreateGemgentoShipment (20140208233651)  (29.1ms) CREATE TABLE `gemgento_shipments` (`id` int(11) auto_increment PRIMARY KEY, `magento_id` int(11), `order_id` int(11), `increment_id` varchar(255), `store_id` int(11), `shipping_address_id` int(11), `total_qty` float, `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB DEFAULT CHARSET=utf8  (13.6ms) CREATE INDEX `shipments_order_index` ON `gemgento_shipments` (`order_id`)   (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20140208233651')  (0.2ms) COMMIT Migrating to CreateGemegentoShipmentItem (20140209000330)  (27.6ms) CREATE TABLE `gemegento_shipment_items` (`id` int(11) auto_increment PRIMARY KEY, `shipment_id` int(11), `sku` varchar(255), `name` varchar(255), `order_item_id` int(11), `product_id` int(11), `weight` float, `price` float, `qty` float, `magento_id` int(11)) ENGINE=InnoDB DEFAULT CHARSET=utf8  (11.5ms) CREATE INDEX `shipment_items_shipment_id` ON `gemegento_shipment_items` (`shipment_id`)  (0.1ms) BEGIN SQL (0.1ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20140209000330')  (0.2ms) COMMIT Migrating to CreateGemgentoShipmentTrack (20140209001048)  (28.3ms) CREATE TABLE `gemgento_shipment_tracks` (`id` int(11) auto_increment PRIMARY KEY, `shipment_id` int(11), `carrier_code` varchar(255), `title` varchar(255), `number` varchar(255), `order_id` int(11), `magento_id` int(11)) ENGINE=InnoDB DEFAULT CHARSET=utf8  (13.9ms) CREATE INDEX `shipment_tracks_shipment_index` ON `gemgento_shipment_tracks` (`shipment_id`)   (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20140209001048')  (0.2ms) COMMIT Migrating to CreateGemgentoShipmentComment (20140209003043)  (27.2ms) CREATE TABLE `gemgento_shipment_comments` (`id` int(11) auto_increment PRIMARY KEY, `shipment_id` int(11), `comment` text, `is_customer_notified` tinyint(1), `magento_id` int(11), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB DEFAULT CHARSET=utf8  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20140209003043')  (0.3ms) COMMIT Migrating to ChangeGemgentoApiJobTextFieldsToLongText (20140209233713)  (29.6ms) ALTER TABLE `gemgento_api_jobs` CHANGE `response` `response` longtext DEFAULT NULL  (16.6ms) ALTER TABLE `gemgento_api_jobs` CHANGE `request` `request` longtext DEFAULT NULL  (19.3ms) ALTER TABLE `gemgento_api_jobs` CHANGE `request_body` `request_body` longtext DEFAULT NULL  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20140209233713')  (0.2ms) COMMIT Migrating to AddPlacedAtToGemgentoOrders (20140227172710)  (30.0ms) ALTER TABLE `gemgento_orders` ADD `placed_at` datetime  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20140227172710')  (0.3ms) COMMIT Migrating to AddDeletedAtToGemgentoCategory (20140310142243)  (28.1ms) ALTER TABLE `gemgento_categories` ADD `deleted_at` datetime  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20140310142243')  (0.3ms) COMMIT Migrating to AddDeletedAtToGemgentoUsers (20140310144408)  (31.0ms) ALTER TABLE `gemgento_users` ADD `deleted_at` datetime  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20140310144408')  (0.2ms) COMMIT Migrating to RemoveEmailIndexFromGemgentoUsers (20140310150145)  (26.2ms) DROP INDEX `index_gemgento_users_on_email` ON `gemgento_users`  (11.9ms) CREATE UNIQUE INDEX `users_email_deleted_index` ON `gemgento_users` (`email`, `deleted_at`)  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20140310150145')  (0.2ms) COMMIT Migrating to AddDeletedAtToGemgentoProductAttribute (20140310162000)  (31.4ms) ALTER TABLE `gemgento_product_attributes` ADD `deleted_at` datetime  (0.1ms) BEGIN SQL (0.1ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20140310162000')  (0.3ms) COMMIT Migrating to AddDeletedAtToGemgentoProductAttributeSet (20140310162017)  (31.5ms) ALTER TABLE `gemgento_product_attribute_sets` ADD `deleted_at` datetime  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20140310162017')  (0.3ms) COMMIT Migrating to CreateGemgentoSavedCreditCard (20140312131230)  (26.4ms) CREATE TABLE `gemgento_saved_credit_cards` (`id` int(11) auto_increment PRIMARY KEY, `magento_id` int(11), `user_id` int(11), `token` varchar(255), `cc_number` varchar(255), `exp_month` int(11), `exp_year` int(11), `cc_type` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB DEFAULT CHARSET=utf8  (0.1ms) BEGIN SQL (0.1ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20140312131230')  (0.2ms) COMMIT Migrating to AddDefaultsToGemgentoAddresses (20140422140433)  (25.4ms) ALTER TABLE `gemgento_addresses` CHANGE `is_default` `is_default_billing` tinyint(1) DEFAULT '0'  (15.9ms) ALTER TABLE `gemgento_addresses` ADD `is_default_shipping` tinyint(1) DEFAULT 0  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20140422140433')  (0.3ms) COMMIT Migrating to CreateGemgentoImageImports (20140429191504)  (27.2ms) CREATE TABLE `gemgento_image_imports` (`id` int(11) auto_increment PRIMARY KEY, `import_errors` text, `spreadsheet_file_name` varchar(255), `spreadsheet_content_type` varchar(255), `spreadsheet_file_size` int(11), `spreadsheet_updated_at` datetime, `destroy_existing` tinyint(1) DEFAULT 0, `store_id` int(11), `count_created` int(11), `count_updated` int(11), `image_path` varchar(255), `image_labels` text, `image_file_extensions` text, `image_types` text, `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB DEFAULT CHARSET=utf8  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20140429191504')  (0.2ms) COMMIT Migrating to AddIsActiveToGemgentoImageImport (20140430190229)  (28.8ms) ALTER TABLE `gemgento_image_imports` ADD `is_active` tinyint(1) DEFAULT 0  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20140430190229')  (0.3ms) COMMIT Migrating to AddMetaToAttachedImages (20140508125933)  (29.3ms) ALTER TABLE `gemgento_asset_files` ADD `file_meta` text  (18.5ms) ALTER TABLE `gemgento_categories` ADD `image_meta` text  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20140508125933')  (0.2ms) COMMIT Migrating to CreateAdminUsers (20140513194044)  (27.1ms) CREATE TABLE `admin_users` (`id` int(11) auto_increment PRIMARY KEY, `email` varchar(255) DEFAULT '' NOT NULL, `encrypted_password` varchar(255) DEFAULT '' NOT NULL, `reset_password_token` varchar(255), `reset_password_sent_at` datetime, `remember_created_at` datetime, `sign_in_count` int(11) DEFAULT 0 NOT NULL, `current_sign_in_at` datetime, `last_sign_in_at` datetime, `current_sign_in_ip` varchar(255), `last_sign_in_ip` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB DEFAULT CHARSET=utf8  (12.3ms) CREATE UNIQUE INDEX `index_admin_users_on_email` ON `admin_users` (`email`)   (11.9ms) CREATE UNIQUE INDEX `index_admin_users_on_reset_password_token` ON `admin_users` (`reset_password_token`)  (0.2ms) BEGIN AdminUser Exists (0.3ms) SELECT 1 AS one FROM `admin_users` WHERE `admin_users`.`email` = BINARY 'admin@example.com' LIMIT 1 SQL (0.2ms) INSERT INTO `admin_users` (`email`, `encrypted_password`, `created_at`, `updated_at`) VALUES ('admin@example.com', '$2a$04$sJNhRgEcdsufNJfhXx9ea.qftJfuhFPJPs2B2/gyYfi3WWUrAjFh.', '2016-01-22 17:18:49', '2016-01-22 17:18:49')  (5.7ms) COMMIT  (0.2ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20140513194044')  (5.5ms) COMMIT Migrating to CreateActiveAdminComments (20140513194047)  (28.5ms) CREATE TABLE `active_admin_comments` (`id` int(11) auto_increment PRIMARY KEY, `namespace` varchar(255), `body` text, `resource_id` varchar(255) NOT NULL, `resource_type` varchar(255) NOT NULL, `author_id` int(11), `author_type` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB DEFAULT CHARSET=utf8  (12.7ms) CREATE INDEX `index_active_admin_comments_on_namespace` ON `active_admin_comments` (`namespace`)   (13.7ms) CREATE INDEX `index_active_admin_comments_on_author_type_and_author_id` ON `active_admin_comments` (`author_type`, `author_id`)  (11.8ms) CREATE INDEX `index_active_admin_comments_on_resource_type_and_resource_id` ON `active_admin_comments` (`resource_type`, `resource_id`)   (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20140513194047')  (0.2ms) COMMIT Migrating to AddBackordersToGemgentoInventories (20140605141601)  (31.0ms) ALTER TABLE `gemgento_inventories` ADD `backorders` int(11) DEFAULT 0 NOT NULL  (14.9ms) ALTER TABLE `gemgento_inventories` ADD `use_config_backorders` tinyint(1) DEFAULT 1 NOT NULL  (16.1ms) ALTER TABLE `gemgento_inventories` ADD `min_qty` int(11) DEFAULT 0 NOT NULL  (18.8ms) ALTER TABLE `gemgento_inventories` ADD `use_config_min_qty` tinyint(1) DEFAULT 1 NOT NULL  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20140605141601')  (0.2ms) COMMIT Migrating to AddQuantityToGemegentoShipmentItems (20140625141601)  (31.9ms) ALTER TABLE `gemegento_shipment_items` ADD `quantity` decimal DEFAULT 0 NOT NULL  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20140625141601')  (0.3ms) COMMIT Migrating to RenameGemegentoShipmentItems (20140625141630)  (16.8ms) RENAME TABLE `gemegento_shipment_items` TO `gemgento_shipment_items`  (0.1ms) BEGIN SQL (0.1ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20140625141630')  (6.0ms) COMMIT Migrating to CreateGemgentoAdapterShopifyAdapter (20140707180118)  (28.1ms) CREATE TABLE `gemgento_shopify_adapters` (`id` int(11) auto_increment PRIMARY KEY, `gemgento_model_id` int(11), `gemgento_model_type` varchar(255), `shopify_model_type` varchar(255), `shopify_model_id` int(11), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB  (13.7ms) CREATE INDEX `gemgento_model_index` ON `gemgento_shopify_adapters` (`gemgento_model_id`, `gemgento_model_type`)   (14.3ms) CREATE INDEX `shopify_model_index` ON `gemgento_shopify_adapters` (`shopify_model_id`, `shopify_model_type`)  (0.1ms) BEGIN SQL (0.1ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20140707180118')  (0.2ms) COMMIT Migrating to CreateGemgentoTags (20140710200747)  (28.9ms) CREATE TABLE `gemgento_tags` (`id` int(11) auto_increment PRIMARY KEY, `magento_id` int(11), `name` varchar(255), `status` varchar(255) DEFAULT '0', `sync_needed` tinyint(1) DEFAULT 0) ENGINE=InnoDB  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20140710200747')  (0.3ms) COMMIT Migrating to CreateGemgentoProductsTags (20140710200830)  (25.9ms) CREATE TABLE `gemgento_products_tags` (`product_id` int(11), `tag_id` int(11)) ENGINE=InnoDB  (12.8ms) CREATE INDEX `index_gemgento_products_tags_on_product_id_and_tag_id` ON `gemgento_products_tags` (`product_id`, `tag_id`)   (13.1ms) CREATE INDEX `index_gemgento_products_tags_on_tag_id` ON `gemgento_products_tags` (`tag_id`)  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20140710200830')  (0.2ms) COMMIT Migrating to CreateGemgentoStoreTags (20140711135514)  (28.3ms) CREATE TABLE `gemgento_store_tags` (`id` int(11) auto_increment PRIMARY KEY, `store_id` int(11), `tag_id` int(11), `base_popularity` int(11) DEFAULT 0, INDEX `index_gemgento_store_tags_on_store_id` (`store_id`) , INDEX `index_gemgento_store_tags_on_tag_id` (`tag_id`) ) ENGINE=InnoDB  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20140711135514')  (0.2ms) COMMIT Migrating to CreateGemgentoPriceRules (20140724152337)  (25.4ms) CREATE TABLE `gemgento_price_rules` (`id` int(11) auto_increment PRIMARY KEY, `magento_id` int(11), `name` varchar(255), `description` text, `from_date` datetime, `to_date` datetime, `is_active` tinyint(1) DEFAULT 0 NOT NULL, `stop_rules_processing` tinyint(1) DEFAULT 1 NOT NULL, `sort_order` int(11), `simple_action` varchar(255), `discount_amount` decimal, `sub_is_enable` tinyint(1) DEFAULT 0 NOT NULL, `sub_simple_action` varchar(255), `sub_discount_amount` decimal, `conditions` text) ENGINE=InnoDB  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20140724152337')  (0.2ms) COMMIT Migrating to CreateGemgentoPriceRulesStores (20140724203223)  (27.3ms) CREATE TABLE `gemgento_price_rules_stores` (`price_rule_id` int(11), `store_id` int(11)) ENGINE=InnoDB  (14.5ms) CREATE INDEX `index_gemgento_price_rules_stores_on_price_rule_id_and_store_id` ON `gemgento_price_rules_stores` (`price_rule_id`, `store_id`)   (15.0ms) CREATE INDEX `index_gemgento_price_rules_stores_on_store_id` ON `gemgento_price_rules_stores` (`store_id`)  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20140724203223')  (0.2ms) COMMIT Migrating to CreateGemgentoPriceRulesUserGroups (20140724203510)  (28.9ms) CREATE TABLE `gemgento_price_rules_user_groups` (`id` int(11) auto_increment PRIMARY KEY, `price_rule_id` int(11), `user_group_id` int(11)) ENGINE=InnoDB  (13.7ms) CREATE INDEX `price_rule_user_group_index` ON `gemgento_price_rules_user_groups` (`price_rule_id`, `user_group_id`)   (18.7ms) CREATE INDEX `user_group_index` ON `gemgento_price_rules_user_groups` (`user_group_id`)  (0.1ms) BEGIN SQL (0.1ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20140724203510')  (3.6ms) COMMIT Migrating to AddManageStockToGemgentoInventories (20140725141407)  (29.4ms) ALTER TABLE `gemgento_inventories` ADD `manage_stock` tinyint(1) DEFAULT 1  (0.2ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20140725141407')  (0.2ms) COMMIT Migrating to CreateGemgentoRecurringProfiles (20140730192804)  (25.5ms) CREATE TABLE `gemgento_recurring_profiles` (`id` int(11) auto_increment PRIMARY KEY, `magento_id` int(11), `state` varchar(255), `user_id` int(11), `store_id` int(11), `method_code` varchar(255), `reference_id` int(11), `subscriber_name` varchar(255), `start_datetime` datetime, `internal_reference_id` varchar(255), `schedule_description` varchar(255), `period_unit` varchar(255), `period_frequency` int(11), `billing_amount` decimal, `currency_code` varchar(255), `shipping_amount` decimal, `tax_amount` decimal, `order_info` text, `order_item_info` text, `billing_address_info` text, `shipping_address_info` text, `profile_vendor_info` text, `additional_info` text, INDEX `index_gemgento_recurring_profiles_on_user_id` (`user_id`) , INDEX `index_gemgento_recurring_profiles_on_store_id` (`store_id`) ) ENGINE=InnoDB  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20140730192804')  (0.2ms) COMMIT Migrating to CreateGemgentoOrdersRecurringProfiles (20140730192852)  (26.1ms) CREATE TABLE `gemgento_orders_recurring_profiles` (`order_id` int(11), `recurring_profile_id` int(11)) ENGINE=InnoDB  (11.8ms) CREATE INDEX `order_recurring_profile_index` ON `gemgento_orders_recurring_profiles` (`order_id`, `recurring_profile_id`)   (14.0ms) CREATE INDEX `recurring_profile_index` ON `gemgento_orders_recurring_profiles` (`recurring_profile_id`)  (0.1ms) BEGIN SQL (0.1ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20140730192852')  (0.3ms) COMMIT Migrating to AddCacheExpiresAtToGemgentoProducts (20140804161106)  (28.4ms) ALTER TABLE `gemgento_products` ADD `cache_expires_at` datetime  (0.1ms) BEGIN SQL (0.1ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20140804161106')  (0.2ms) COMMIT Migrating to AddOptionsToGemgentoOrderItems (20140815143812)  (30.0ms) ALTER TABLE `gemgento_order_items` ADD `options` text  (0.1ms) BEGIN SQL (0.1ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20140815143812')  (0.2ms) COMMIT Migrating to CreateAdminStore (20140828184800)  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `gemgento_stores` (`magento_id`, `code`, `group_id`, `website_id`, `name`, `sort_order`, `created_at`, `updated_at`) VALUES (0, 'admin', 0, 0, 'Admin', 0, '2016-01-22 17:18:49', '2016-01-22 17:18:49')  (5.4ms) COMMIT  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20140828184800')  (5.4ms) COMMIT Migrating to CreateGemgentoInventoryImports (20140829172323)  (27.5ms) CREATE TABLE `gemgento_inventory_imports` (`id` int(11) auto_increment PRIMARY KEY, `spreadsheet_file_name` varchar(255), `spreadsheet_content_type` varchar(255), `spreadsheet_file_size` int(11), `spreadsheet_updated_at` datetime, `import_errors` text, `is_active` tinyint(1) DEFAULT 1) ENGINE=InnoDB  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20140829172323')  (0.2ms) COMMIT Migrating to CreateGemgentoStockNotifications (20140905155652)  (28.7ms) CREATE TABLE `gemgento_stock_notifications` (`id` int(11) auto_increment PRIMARY KEY, `product_id` int(11), `product_name` varchar(255), `product_url` varchar(255), `name` varchar(255), `email` varchar(255), `phone` varchar(255), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20140905155652')  (0.2ms) COMMIT Migrating to AddCartItemErrorsToGemgentoOrders (20140910121424)  (32.2ms) ALTER TABLE `gemgento_orders` ADD `cart_item_errors` text  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20140910121424')  (0.2ms) COMMIT Migrating to UpdateGemgentoRecurringProfileDecimals (20140926153739)  (28.2ms) ALTER TABLE `gemgento_recurring_profiles` CHANGE `billing_amount` `billing_amount` decimal(8,2) DEFAULT NULL  (15.6ms) ALTER TABLE `gemgento_recurring_profiles` CHANGE `shipping_amount` `shipping_amount` decimal(8,2) DEFAULT NULL  (15.1ms) ALTER TABLE `gemgento_recurring_profiles` CHANGE `tax_amount` `tax_amount` decimal(8,2) DEFAULT NULL  (0.1ms) BEGIN SQL (0.1ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20140926153739')  (0.2ms) COMMIT Migrating to RemoveOrderAddressIdFromGemgentoAddresses (20141027191313)  (29.2ms) ALTER TABLE `gemgento_addresses` DROP `order_address_id`  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20141027191313')  (0.3ms) COMMIT Migrating to RenameGemgentoOrderItemsToGemgentoLineItems (20141028144819)  (17.8ms) RENAME TABLE `gemgento_order_items` TO `gemgento_line_items`  (0.1ms) BEGIN SQL (6.3ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20141028144819')  (0.3ms) COMMIT Migrating to ConvertGemgentoLineItemToPolymorphicItemizable (20141028150806)  (24.1ms) ALTER TABLE `gemgento_line_items` CHANGE `order_id` `itemizable_id` int(11) DEFAULT NULL  (16.0ms) ALTER TABLE `gemgento_line_items` ADD `itemizable_type` varchar(255) DEFAULT 'Gemgento::Order' AFTER `magento_id`  (12.6ms) CREATE INDEX `index_gemgento_line_items_on_itemizable_type_and_itemizable_id` ON `gemgento_line_items` (`itemizable_type`, `itemizable_id`)  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20141028150806')  (0.2ms) COMMIT Migrating to RenameGemgentoOrderPaymentToGemgentoPayment (20141028153303)  (17.6ms) RENAME TABLE `gemgento_order_payments` TO `gemgento_payments`  (0.1ms) BEGIN SQL (0.1ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20141028153303')  (5.5ms) COMMIT Migrating to ConvertGemgentoPaymentToPayablePolymorphic (20141028154735)  (21.3ms) ALTER TABLE `gemgento_payments` CHANGE `order_id` `payable_id` int(11) NOT NULL  (15.3ms) ALTER TABLE `gemgento_payments` ADD `payable_type` varchar(255) DEFAULT 'Gemgento::Order' AFTER `magento_id`  (15.5ms) CREATE INDEX `index_gemgento_payments_on_payable_type_and_payable_id` ON `gemgento_payments` (`payable_type`, `payable_id`)  (0.1ms) BEGIN SQL (0.1ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20141028154735')  (0.2ms) COMMIT Migrating to CreateGemgentoQuote (20141028160826)  (26.0ms) CREATE TABLE `gemgento_quotes` (`id` int(11) auto_increment PRIMARY KEY, `magento_id` int(11), `store_id` int(11), `user_id` int(11), `user_group_id` int(11), `order_id` int(11), `converted_at` datetime, `created_at` datetime, `updated_at` datetime, `is_active` tinyint(1) DEFAULT 1, `is_virtual` tinyint(1) DEFAULT 0, `is_multi_shipping` tinyint(1) DEFAULT 0, `original_order_id` varchar(255), `store_to_base_rate` decimal(12,4) DEFAULT 1, `store_to_quote_rate` decimal(12,4) DEFAULT 1, `base_currency_code` varchar(255), `store_currency_code` varchar(255), `quote_currency_code` varchar(255), `grand_total` decimal(12,4), `base_grand_total` decimal(12,4), `checkout_method` varchar(255), `customer_email` varchar(255), `customer_prefix` varchar(255), `customer_first_name` varchar(255), `customer_middle_name` varchar(255), `customer_last_name` varchar(255), `customer_suffix` varchar(255), `customer_note` text, `customer_note_notify` tinyint(1) DEFAULT 0, `customer_is_guest` tinyint(1) DEFAULT 0, `applied_rule_ids` varchar(255), `reserved_order_id` varchar(255), `password_hash` varchar(255), `coupon_code` varchar(255), `global_currency_code` varchar(255), `base_to_global_rate` decimal(12,4) DEFAULT 1, `base_to_order_rate` decimal(12,4) DEFAULT 1, `customer_taxvat` varchar(255), `customer_gender` varchar(255), `subtotal` decimal(12,4), `base_subtotal` decimal(12,4), `base_subtotal_with_discount` decimal(12,4), `shipping_method` varchar(255), `ext_shipping_info` text, `shipping_amount` decimal(12,4), `gift_message_id` int(11), `customer_balance_amount_used` decimal(12,4), `base_customer_balance_amount_used` decimal(12,4), `use_customer_balance` tinyint(1) DEFAULT 0, `gift_cards_amount` decimal(12,4), `base_gift_cards_amount` decimal(12,4), `use_reward_points` tinyint(1) DEFAULT 0, `reward_points_balance` decimal(12,4), `reward_currency_amount` decimal(12,4), `base_reward_currency_amount` decimal(12,4)) ENGINE=InnoDB  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20141028160826')  (0.2ms) COMMIT Migrating to AddQuoteReferenceToGemgentoOrder (20141028203630)  (31.6ms) ALTER TABLE `gemgento_orders` ADD `quote_id` int(11)  (13.5ms) CREATE INDEX `index_gemgento_orders_on_quote_id` ON `gemgento_orders` (`quote_id`)   (0.1ms) BEGIN SQL (0.1ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20141028203630')  (0.2ms) COMMIT Migrating to RemoveCartsFromGemgentoOrders (20141028203943) Gemgento::Order Load (0.3ms) SELECT `gemgento_orders`.* FROM `gemgento_orders` WHERE `gemgento_orders`.`state` = 'cart'  (0.2ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20141028203943')  (5.8ms) COMMIT Migrating to RemoveQuoteAttributesFromGemgentoOrders (20141028204310)  (30.1ms) ALTER TABLE `gemgento_orders` DROP `magento_quote_id`  (15.8ms) ALTER TABLE `gemgento_orders` DROP `is_active`  (15.4ms) ALTER TABLE `gemgento_orders` DROP `cart_item_errors`  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20141028204310')  (0.3ms) COMMIT Migrating to AddGiftMessageToGemgentoQuote (20141028215239)  (30.2ms) ALTER TABLE `gemgento_quotes` ADD `gift_message` text AFTER `gift_message_id`  (0.1ms) BEGIN SQL (0.1ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20141028215239')  (0.3ms) COMMIT Migrating to AddAddressableToGemgentoAddresses (20141029151716)  (30.6ms) ALTER TABLE `gemgento_addresses` ADD `addressable_id` int(11) AFTER `id`  (14.8ms) ALTER TABLE `gemgento_addresses` ADD `addressable_type` varchar(255) AFTER `id`  (11.6ms) CREATE INDEX `index_gemgento_addresses_on_addressable_type_and_addressable_id` ON `gemgento_addresses` (`addressable_type`, `addressable_id`)   (0.1ms) BEGIN SQL (0.1ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20141029151716')  (0.2ms) COMMIT Migrating to RenameGemgentoAddressIsDefaults (20141029152921)  (24.2ms) ALTER TABLE `gemgento_addresses` CHANGE `is_default_shipping` `is_shipping` tinyint(1) DEFAULT '0'  (11.5ms) ALTER TABLE `gemgento_addresses` CHANGE `is_default_billing` `is_billing` tinyint(1) DEFAULT '0'  (0.1ms) BEGIN SQL (0.1ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20141029152921')  (0.3ms) COMMIT Migrating to ConvertGemgentoAddressesToPolymorphicAssociations (20141029160052) Scoped order and limit are ignored, it's forced to be batch order and batch size Gemgento::Address Load (0.2ms) SELECT `gemgento_addresses`.* FROM `gemgento_addresses` ORDER BY `gemgento_addresses`.`id` ASC LIMIT 1000  (0.1ms) BEGIN SQL (0.1ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20141029160052')  (6.0ms) COMMIT Migrating to RemoveGemgentoAddressesAddressType (20141029172426)  (29.5ms) ALTER TABLE `gemgento_addresses` DROP `address_type`  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20141029172426')  (0.2ms) COMMIT Migrating to RemoveGemgentoAddressesOrderId (20141029172700)  (29.0ms) ALTER TABLE `gemgento_addresses` DROP `order_id`  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20141029172700')  (0.2ms) COMMIT Migrating to RenameGemgentoAddressesUserAddressIdToMagentoId (20141029172836)  (22.0ms) ALTER TABLE `gemgento_addresses` CHANGE `user_address_id` `magento_id` int(11) DEFAULT NULL  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20141029172836')  (0.3ms) COMMIT Migrating to RenameGemgentoOrdersIdToMagentoId (20141030150545)  (22.0ms) ALTER TABLE `gemgento_orders` CHANGE `order_id` `magento_id` int(11) DEFAULT NULL  (0.1ms) BEGIN SQL (0.1ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20141030150545')  (0.2ms) COMMIT Migrating to RemoveOrderIdFromGemgentoQuotes (20141030204444)  (29.2ms) ALTER TABLE `gemgento_quotes` DROP `order_id`  (0.1ms) BEGIN SQL (0.1ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20141030204444')  (0.3ms) COMMIT Migrating to RemoveUserIdFromGemgentoAddresses (20141030205035)  (30.0ms) ALTER TABLE `gemgento_addresses` DROP `user_id`  (0.1ms) BEGIN SQL (0.1ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20141030205035')  (0.2ms) COMMIT Migrating to RenameGemgentoShipmentItemOrderItemToLineItem (20141119155605)  (22.5ms) ALTER TABLE `gemgento_shipment_items` CHANGE `order_item_id` `line_item_id` int(11) DEFAULT NULL  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20141119155605')  (0.2ms) COMMIT Migrating to AddIsInUseToGemgentoSavedCreditCards (20141121162052)  (29.9ms) ALTER TABLE `gemgento_saved_credit_cards` ADD `is_in_use` tinyint(1) DEFAULT 0  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20141121162052')  (0.2ms) COMMIT Migrating to AddCouponCodesAndGiftvoucherCodesToGemgentoQuote (20141204151855)  (30.0ms) ALTER TABLE `gemgento_quotes` ADD `coupon_codes` text  (15.9ms) ALTER TABLE `gemgento_quotes` ADD `gift_card_codes` text  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20141204151855')  (0.2ms) COMMIT Migrating to CreateGemgentoWishlistItems (20150128151227)  (28.0ms) CREATE TABLE `gemgento_wishlist_items` (`id` int(11) auto_increment PRIMARY KEY, `product_id` int(11), `user_id` int(11), `created_at` datetime, `updated_at` datetime) ENGINE=InnoDB  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20150128151227')  (0.2ms) COMMIT Migrating to CreateGemgentoBundleOption (20150223161345)  (26.1ms) CREATE TABLE `gemgento_bundle_options` (`id` int(11) auto_increment PRIMARY KEY, `product_id` int(11), `magento_id` int(11), `name` varchar(255), `input_type` int(11), `is_required` tinyint(1) DEFAULT 1, `position` int(11), `created_at` datetime, `updated_at` datetime, INDEX `index_gemgento_bundle_options_on_product_id` (`product_id`) ) ENGINE=InnoDB  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20150223161345')  (0.2ms) COMMIT Migrating to CreateGemgentoBundleItem (20150223161532)  (24.6ms) CREATE TABLE `gemgento_bundle_items` (`id` int(11) auto_increment PRIMARY KEY, `bundle_option_id` int(11), `product_id` int(11), `magento_id` int(11), `price_type` int(11), `price_value` float, `default_quantity` float, `is_user_defined_quantity` tinyint(1) DEFAULT 1, `position` int(11), `is_default` tinyint(1), `created_at` datetime, `updated_at` datetime, INDEX `index_gemgento_bundle_items_on_bundle_option_id` (`bundle_option_id`) , INDEX `index_gemgento_bundle_items_on_product_id` (`product_id`) ) ENGINE=InnoDB  (0.1ms) BEGIN SQL (0.1ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20150223161532')  (0.2ms) COMMIT Migrating to CreateGemgentoLineItemOptions (20150302154059)  (26.6ms) CREATE TABLE `gemgento_line_item_options` (`id` int(11) auto_increment PRIMARY KEY, `line_item_id` int(11), `bundle_item_id` int(11), `quantity` float, INDEX `index_gemgento_line_item_options_on_line_item_id` (`line_item_id`) , INDEX `index_gemgento_line_item_options_on_bundle_item_id` (`bundle_item_id`) ) ENGINE=InnoDB  (0.1ms) BEGIN SQL (0.1ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20150302154059')  (0.2ms) COMMIT Migrating to CreateGemgentoPriceTier (20150616203244)  (26.9ms) CREATE TABLE `gemgento_price_tiers` (`id` int(11) auto_increment PRIMARY KEY, `product_id` int(11), `store_id` int(11), `user_group_id` int(11), `quantity` float, `price` float, INDEX `index_gemgento_price_tiers_on_product_id` (`product_id`) , INDEX `index_gemgento_price_tiers_on_store_id` (`store_id`) , INDEX `index_gemgento_price_tiers_on_user_group_id` (`user_group_id`) ) ENGINE=InnoDB  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20150616203244')  (0.2ms) COMMIT Migrating to ConvertFloatToDecimalOnGemgentoPriceTiers (20150623204331)  (31.6ms) ALTER TABLE `gemgento_price_tiers` CHANGE `price` `price` decimal(5,2) DEFAULT NULL  (15.6ms) ALTER TABLE `gemgento_price_tiers` CHANGE `quantity` `quantity` decimal(5,2) DEFAULT NULL  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20150623204331')  (0.2ms) COMMIT Migrating to AddSetDefaultInventoryValuesToGemgentoProductImports (20150915174007)  (30.1ms) ALTER TABLE `gemgento_product_imports` ADD `set_default_inventory_values` tinyint(1) DEFAULT 0  (0.1ms) BEGIN SQL (0.1ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20150915174007')  (0.2ms) COMMIT Migrating to AddUniqueIndexesToGemgentoOrders (20151009234207) Gemgento::Order Load (0.3ms) SELECT `gemgento_orders`.* FROM `gemgento_orders` ORDER BY `gemgento_orders`.`created_at` DESC Gemgento::Order Load (0.2ms) SELECT `gemgento_orders`.* FROM `gemgento_orders` ORDER BY `gemgento_orders`.`created_at` DESC  (25.2ms) CREATE UNIQUE INDEX `index_gemgento_orders_on_increment_id` ON `gemgento_orders` (`increment_id`)  (14.7ms) CREATE UNIQUE INDEX `index_gemgento_orders_on_magento_id` ON `gemgento_orders` (`magento_id`)   (0.2ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20151009234207')  (0.2ms) COMMIT Migrating to RemoveSyncNeededFromGemgentoCategories (20151123221906)  (29.6ms) ALTER TABLE `gemgento_categories` DROP `sync_needed`  (0.1ms) BEGIN SQL (0.1ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20151123221906')  (0.2ms) COMMIT Migrating to RemoveSyncNeededFromGemgentoProducts (20151130212918)  (28.5ms) ALTER TABLE `gemgento_products` DROP `sync_needed`  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20151130212918')  (0.3ms) COMMIT Migrating to AddUniqueMagentoIdConstraintToGemgentoLineItems (20151208153059) Gemgento::LineItem Load (0.3ms) SELECT `gemgento_line_items`.* FROM `gemgento_line_items` WHERE (`gemgento_line_items`.`magento_id` IS NOT NULL)  (24.4ms) CREATE UNIQUE INDEX `index_gemgento_line_items_on_magento_id_and_itemizable_type` ON `gemgento_line_items` (`magento_id`, `itemizable_type`)  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20151208153059')  (0.3ms) COMMIT Migrating to RemoveSyncNeededFromGemgentoUses (20151229145013)  (29.8ms) ALTER TABLE `gemgento_users` DROP `sync_needed`  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20151229145013')  (0.2ms) COMMIT Migrating to AddGiftvoucherTotalsToGemgentoOrders (20160105164938)  (29.7ms) ALTER TABLE `gemgento_orders` ADD `base_giftvoucher_discount_for_shipping` decimal  (17.1ms) ALTER TABLE `gemgento_orders` ADD `giftvoucher_discount_for_shipping` decimal  (15.5ms) ALTER TABLE `gemgento_orders` ADD `base_giftcredit_discount_for_shipping` decimal  (17.2ms) ALTER TABLE `gemgento_orders` ADD `giftcredit_discount_for_shipping` decimal  (19.1ms) ALTER TABLE `gemgento_orders` ADD `base_gift_voucher_discount` decimal  (15.5ms) ALTER TABLE `gemgento_orders` ADD `gift_voucher_discount` decimal  (15.6ms) ALTER TABLE `gemgento_orders` ADD `base_use_gift_credit_amount` decimal  (16.2ms) ALTER TABLE `gemgento_orders` ADD `use_gift_credit_amount` decimal  (18.1ms) ALTER TABLE `gemgento_orders` ADD `giftvoucher_base_hidden_tax_amount` decimal  (15.9ms) ALTER TABLE `gemgento_orders` ADD `giftvoucher_hidden_tax_amount` decimal  (18.8ms) ALTER TABLE `gemgento_orders` ADD `giftcredit_base_hidden_tax_amount` decimal  (14.7ms) ALTER TABLE `gemgento_orders` ADD `giftcredit_hidden_tax_amount` decimal  (14.4ms) ALTER TABLE `gemgento_orders` ADD `giftcredit_base_shipping_hidden_tax_amount` decimal  (16.4ms) ALTER TABLE `gemgento_orders` ADD `giftcredit_shipping_hidden_tax_amount` decimal  (0.2ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20160105164938')  (0.2ms) COMMIT Migrating to AddUniqeIndexForGemgentoProductCategories (20160105220854) Gemgento::ProductCategory Load (0.2ms) SELECT `gemgento_product_categories`.* FROM `gemgento_product_categories` ORDER BY `gemgento_product_categories`.`category_id` ASC, `gemgento_product_categories`.`position` ASC, `gemgento_product_categories`.`product_id` ASC, `gemgento_product_categories`.`id` ASC  (21.3ms) CREATE UNIQUE INDEX `uniqueness_constraint` ON `gemgento_product_categories` (`product_id`, `category_id`, `store_id`)  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20160105220854')  (0.2ms) COMMIT Migrating to RemoveSyncNeededFromGemgentoProductCategory (20160118220752)  (31.2ms) ALTER TABLE `gemgento_product_categories` DROP `sync_needed`  (0.1ms) BEGIN SQL (0.1ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20160118220752')  (0.2ms) COMMIT ActiveRecord::SchemaMigration Load (16.6ms) SELECT `schema_migrations`.* FROM `schema_migrations` Migrating to AddValidationIndexesToGemgentoProducts (20151201231300) Gemgento::Product Load (0.3ms) SELECT `gemgento_products`.* FROM `gemgento_products` ORDER BY `gemgento_products`.`deleted_at` ASC  (24.6ms) CREATE UNIQUE INDEX `index_gemgento_products_on_magento_id` ON `gemgento_products` (`magento_id`)   (14.7ms) CREATE UNIQUE INDEX `index_gemgento_products_on_sku_and_deleted_at` ON `gemgento_products` (`sku`, `deleted_at`)  (0.2ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20151201231300')  (8.4ms) COMMIT Migrating to Gemgento2 (20160122174450)  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20160122174450')  (6.2ms) COMMIT Migrating to AddTimestampsToGemgentoAssetFiles (20160219235858)  (32.8ms) ALTER TABLE `gemgento_asset_files` ADD `created_at` datetime  (17.0ms) ALTER TABLE `gemgento_asset_files` ADD `updated_at` datetime  (0.1ms) BEGIN SQL (0.2ms) INSERT INTO `schema_migrations` (`version`) VALUES ('20160219235858')  (0.3ms) COMMIT ActiveRecord::SchemaMigration Load (42.1ms) SELECT `schema_migrations`.* FROM `schema_migrations` ActiveRecord::SchemaMigration Load (0.3ms) SELECT `schema_migrations`.* FROM `schema_migrations`