Created
March 26, 2020 16:58
-
-
Save robrap/310b0b2d414c3dcb99a01825c0023564 to your computer and use it in GitHub Desktop.
Django Oscar 2.0.4 Upgrade Migration SQL
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| root@ecommerce:/edx/app/ecommerce/ecommerce# ./manage.py sqlmigrate address 0006_auto_20181115_1953; wait | |
| /edx/app/ecommerce/ecommerce/ecommerce/settings/production.py:59: YAMLLoadWarning: calling yaml.load() without Loader=... is deprecated, as the default Loader is unsafe. Please read https://msg.pyyaml.org/load for full details. | |
| config_from_yaml = yaml.load(f) | |
| BEGIN; | |
| -- | |
| -- Alter field printable_name on country | |
| -- | |
| CREATE INDEX `address_country_printable_name_450b016c` ON `address_country` (`printable_name`); | |
| COMMIT; | |
| root@ecommerce:/edx/app/ecommerce/ecommerce# ./manage.py sqlmigrate basket 0013_auto_20200305_1448; wait | |
| /edx/app/ecommerce/ecommerce/ecommerce/settings/production.py:59: YAMLLoadWarning: calling yaml.load() without Loader=... is deprecated, as the default Loader is unsafe. Please read https://msg.pyyaml.org/load for full details. | |
| config_from_yaml = yaml.load(f) | |
| BEGIN; | |
| -- | |
| -- Alter field date_created on line | |
| -- | |
| ALTER TABLE `basket_line` ALTER COLUMN `date_created` SET DEFAULT b"'2020-03-26 16:51:51.738774'"; | |
| CREATE INDEX `basket_line_date_created_eb0dfb1b` ON `basket_line` (`date_created`); | |
| ALTER TABLE `basket_line` ALTER COLUMN `date_created` DROP DEFAULT; | |
| COMMIT; | |
| root@ecommerce:/edx/app/ecommerce/ecommerce# ./manage.py sqlmigrate catalogue 0048_auto_20200311_1240; wait | |
| /edx/app/ecommerce/ecommerce/ecommerce/settings/production.py:59: YAMLLoadWarning: calling yaml.load() without Loader=... is deprecated, as the default Loader is unsafe. Please read https://msg.pyyaml.org/load for full details. | |
| config_from_yaml = yaml.load(f) | |
| BEGIN; | |
| -- | |
| -- Add field is_public to historicalproduct | |
| -- | |
| ALTER TABLE `catalogue_historicalproduct` ADD COLUMN `is_public` bool DEFAULT b'1' NOT NULL; | |
| ALTER TABLE `catalogue_historicalproduct` ALTER COLUMN `is_public` DROP DEFAULT; | |
| -- | |
| -- Add field is_public to product | |
| -- | |
| ALTER TABLE `catalogue_product` ADD COLUMN `is_public` bool DEFAULT b'1' NOT NULL; | |
| ALTER TABLE `catalogue_product` ALTER COLUMN `is_public` DROP DEFAULT; | |
| -- | |
| -- Alter field date_created on historicalproduct | |
| -- | |
| CREATE INDEX `catalogue_historicalproduct_date_created_236cc17e` ON `catalogue_historicalproduct` (`date_created`); | |
| -- | |
| -- Alter field value_boolean on historicalproductattributevalue | |
| -- | |
| CREATE INDEX `catalogue_historicalproductattributevalue_value_boolean_79128283` ON `catalogue_historicalproductattributevalue` (`value_boolean`); | |
| -- | |
| -- Alter field value_date on historicalproductattributevalue | |
| -- | |
| CREATE INDEX `catalogue_historicalproductattributevalue_value_date_aad9b6b2` ON `catalogue_historicalproductattributevalue` (`value_date`); | |
| -- | |
| -- Alter field value_datetime on historicalproductattributevalue | |
| -- | |
| CREATE INDEX `catalogue_historicalproduct_value_datetime_e61e4058` ON `catalogue_historicalproductattributevalue` (`value_datetime`); | |
| -- | |
| -- Alter field value_float on historicalproductattributevalue | |
| -- | |
| CREATE INDEX `catalogue_historicalproductattributevalue_value_float_79557818` ON `catalogue_historicalproductattributevalue` (`value_float`); | |
| -- | |
| -- Alter field value_integer on historicalproductattributevalue | |
| -- | |
| CREATE INDEX `catalogue_historicalproductattributevalue_value_integer_5e216649` ON `catalogue_historicalproductattributevalue` (`value_integer`); | |
| -- | |
| -- Alter field date_created on product | |
| -- | |
| ALTER TABLE `catalogue_product` ALTER COLUMN `date_created` SET DEFAULT b"'2020-03-26 16:51:54.909507'"; | |
| CREATE INDEX `catalogue_product_date_created_d66f485a` ON `catalogue_product` (`date_created`); | |
| ALTER TABLE `catalogue_product` ALTER COLUMN `date_created` DROP DEFAULT; | |
| -- | |
| -- Alter field value_boolean on productattributevalue | |
| -- | |
| CREATE INDEX `catalogue_productattributevalue_value_boolean_c5b0d66a` ON `catalogue_productattributevalue` (`value_boolean`); | |
| -- | |
| -- Alter field value_date on productattributevalue | |
| -- | |
| CREATE INDEX `catalogue_productattributevalue_value_date_d18775c1` ON `catalogue_productattributevalue` (`value_date`); | |
| -- | |
| -- Alter field value_datetime on productattributevalue | |
| -- | |
| CREATE INDEX `catalogue_productattributevalue_value_datetime_b474ac38` ON `catalogue_productattributevalue` (`value_datetime`); | |
| -- | |
| -- Alter field value_float on productattributevalue | |
| -- | |
| CREATE INDEX `catalogue_productattributevalue_value_float_5ef8d3db` ON `catalogue_productattributevalue` (`value_float`); | |
| -- | |
| -- Alter field value_integer on productattributevalue | |
| -- | |
| CREATE INDEX `catalogue_productattributevalue_value_integer_55fbb7d6` ON `catalogue_productattributevalue` (`value_integer`); | |
| -- | |
| -- Alter field display_order on productimage | |
| -- | |
| CREATE INDEX `catalogue_productimage_display_order_9fa741ac` ON `catalogue_productimage` (`display_order`); | |
| -- | |
| -- Alter field ranking on productrecommendation | |
| -- | |
| CREATE INDEX `catalogue_productrecommendation_ranking_e7a0f7fd` ON `catalogue_productrecommendation` (`ranking`); | |
| COMMIT; | |
| root@ecommerce:/edx/app/ecommerce/ecommerce# ./manage.py sqlmigrate customer 0006_auto_20200305_1448; wait | |
| /edx/app/ecommerce/ecommerce/ecommerce/settings/production.py:59: YAMLLoadWarning: calling yaml.load() without Loader=... is deprecated, as the default Loader is unsafe. Please read https://msg.pyyaml.org/load for full details. | |
| config_from_yaml = yaml.load(f) | |
| BEGIN; | |
| -- | |
| -- Alter field date_sent on notification | |
| -- | |
| ALTER TABLE `customer_notification` ALTER COLUMN `date_sent` SET DEFAULT b"'2020-03-26 16:51:58.044881'"; | |
| CREATE INDEX `customer_notification_date_sent_9b6baeda` ON `customer_notification` (`date_sent`); | |
| ALTER TABLE `customer_notification` ALTER COLUMN `date_sent` DROP DEFAULT; | |
| COMMIT; | |
| root@ecommerce:/edx/app/ecommerce/ecommerce# ./manage.py sqlmigrate offer 0033_auto_20200311_1240; wait | |
| /edx/app/ecommerce/ecommerce/ecommerce/settings/production.py:59: YAMLLoadWarning: calling yaml.load() without Loader=... is deprecated, as the default Loader is unsafe. Please read https://msg.pyyaml.org/load for full details. | |
| config_from_yaml = yaml.load(f) | |
| BEGIN; | |
| -- | |
| -- Alter field priority on conditionaloffer | |
| -- | |
| CREATE INDEX `offer_conditionaloffer_priority_4c2fc582` ON `offer_conditionaloffer` (`priority`); | |
| -- | |
| -- Alter field priority on historicalconditionaloffer | |
| -- | |
| CREATE INDEX `offer_historicalconditionaloffer_priority_bf718df5` ON `offer_historicalconditionaloffer` (`priority`); | |
| -- | |
| -- Alter field date_uploaded on rangeproductfileupload | |
| -- | |
| ALTER TABLE `offer_rangeproductfileupload` ALTER COLUMN `date_uploaded` SET DEFAULT b"'2020-03-26 16:52:01.190268'"; | |
| CREATE INDEX `offer_rangeproductfileupload_date_uploaded_f0a4f9ae` ON `offer_rangeproductfileupload` (`date_uploaded`); | |
| ALTER TABLE `offer_rangeproductfileupload` ALTER COLUMN `date_uploaded` DROP DEFAULT; | |
| COMMIT; | |
| root@ecommerce:/edx/app/ecommerce/ecommerce# ./manage.py sqlmigrate order 0023_auto_20200305_1448; wait | |
| /edx/app/ecommerce/ecommerce/ecommerce/settings/production.py:59: YAMLLoadWarning: calling yaml.load() without Loader=... is deprecated, as the default Loader is unsafe. Please read https://msg.pyyaml.org/load for full details. | |
| config_from_yaml = yaml.load(f) | |
| BEGIN; | |
| -- | |
| -- Create model OrderStatusChange | |
| -- | |
| CREATE TABLE `order_orderstatuschange` (`id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY, `old_status` varchar(100) NOT NULL, `new_status` varchar(100) NOT NULL, `date_created` datetime(6) NOT NULL, `order_id` integer NOT NULL); | |
| -- | |
| -- Alter field date_created on communicationevent | |
| -- | |
| ALTER TABLE `order_communicationevent` ALTER COLUMN `date_created` SET DEFAULT b"'2020-03-26 16:52:04.154530'"; | |
| CREATE INDEX `order_communicationevent_date_created_ce404d62` ON `order_communicationevent` (`date_created`); | |
| ALTER TABLE `order_communicationevent` ALTER COLUMN `date_created` DROP DEFAULT; | |
| -- | |
| -- Alter field date_created on paymentevent | |
| -- | |
| ALTER TABLE `order_paymentevent` ALTER COLUMN `date_created` SET DEFAULT b"'2020-03-26 16:52:04.183097'"; | |
| CREATE INDEX `order_paymentevent_date_created_05d8c079` ON `order_paymentevent` (`date_created`); | |
| ALTER TABLE `order_paymentevent` ALTER COLUMN `date_created` DROP DEFAULT; | |
| -- | |
| -- Alter field date_created on shippingevent | |
| -- | |
| ALTER TABLE `order_shippingevent` ALTER COLUMN `date_created` SET DEFAULT b"'2020-03-26 16:52:04.212551'"; | |
| CREATE INDEX `order_shippingevent_date_created_74c4a6fa` ON `order_shippingevent` (`date_created`); | |
| ALTER TABLE `order_shippingevent` ALTER COLUMN `date_created` DROP DEFAULT; | |
| ALTER TABLE `order_orderstatuschange` ADD CONSTRAINT `order_orderstatuschange_order_id_43efdbe5_fk_order_order_id` FOREIGN KEY (`order_id`) REFERENCES `order_order` (`id`); | |
| CREATE INDEX `order_orderstatuschange_date_created_a5107b93` ON `order_orderstatuschange` (`date_created`); | |
| COMMIT; | |
| root@ecommerce:/edx/app/ecommerce/ecommerce# ./manage.py sqlmigrate partner 0017_auto_20200305_1448; wait | |
| /edx/app/ecommerce/ecommerce/ecommerce/settings/production.py:59: YAMLLoadWarning: calling yaml.load() without Loader=... is deprecated, as the default Loader is unsafe. Please read https://msg.pyyaml.org/load for full details. | |
| config_from_yaml = yaml.load(f) | |
| BEGIN; | |
| -- | |
| -- Alter field name on historicalpartner | |
| -- | |
| CREATE INDEX `partner_historicalpartner_name_63933fe9` ON `partner_historicalpartner` (`name`); | |
| -- | |
| -- Alter field name on partner | |
| -- | |
| CREATE INDEX `partner_partner_name_caa0c2ee` ON `partner_partner` (`name`); | |
| -- | |
| -- Alter field date_created on stockalert | |
| -- | |
| ALTER TABLE `partner_stockalert` ALTER COLUMN `date_created` SET DEFAULT b"'2020-03-26 16:52:07.170775'"; | |
| CREATE INDEX `partner_stockalert_date_created_832cf043` ON `partner_stockalert` (`date_created`); | |
| ALTER TABLE `partner_stockalert` ALTER COLUMN `date_created` DROP DEFAULT; | |
| COMMIT; | |
| root@ecommerce:/edx/app/ecommerce/ecommerce# ./manage.py sqlmigrate payment 0026_auto_20200305_1448; wait | |
| /edx/app/ecommerce/ecommerce/ecommerce/settings/production.py:59: YAMLLoadWarning: calling yaml.load() without Loader=... is deprecated, as the default Loader is unsafe. Please read https://msg.pyyaml.org/load for full details. | |
| config_from_yaml = yaml.load(f) | |
| BEGIN; | |
| -- | |
| -- Alter field date_created on transaction | |
| -- | |
| ALTER TABLE `payment_transaction` ALTER COLUMN `date_created` SET DEFAULT b"'2020-03-26 16:52:10.168611'"; | |
| CREATE INDEX `payment_transaction_date_created_f887f6bc` ON `payment_transaction` (`date_created`); | |
| ALTER TABLE `payment_transaction` ALTER COLUMN `date_created` DROP DEFAULT; | |
| COMMIT; | |
| root@ecommerce:/edx/app/ecommerce/ecommerce# ./manage.py sqlmigrate shipping 0003_auto_20181115_1953; wait | |
| /edx/app/ecommerce/ecommerce/ecommerce/settings/production.py:59: YAMLLoadWarning: calling yaml.load() without Loader=... is deprecated, as the default Loader is unsafe. Please read https://msg.pyyaml.org/load for full details. | |
| config_from_yaml = yaml.load(f) | |
| BEGIN; | |
| -- | |
| -- Alter field name on orderanditemcharges | |
| -- | |
| -- | |
| -- Alter field upper_limit on weightband | |
| -- | |
| CREATE INDEX `shipping_weightband_upper_limit_9edc5097` ON `shipping_weightband` (`upper_limit`); | |
| -- | |
| -- Alter field name on weightbased | |
| -- | |
| COMMIT; | |
| root@ecommerce:/edx/app/ecommerce/ecommerce# ./manage.py sqlmigrate voucher 0010_auto_20200305_1448; wait | |
| /edx/app/ecommerce/ecommerce/ecommerce/settings/production.py:59: YAMLLoadWarning: calling yaml.load() without Loader=... is deprecated, as the default Loader is unsafe. Please read https://msg.pyyaml.org/load for full details. | |
| config_from_yaml = yaml.load(f) | |
| BEGIN; | |
| -- | |
| -- Alter field end_datetime on voucher | |
| -- | |
| CREATE INDEX `voucher_voucher_end_datetime_db182297` ON `voucher_voucher` (`end_datetime`); | |
| -- | |
| -- Alter field start_datetime on voucher | |
| -- | |
| CREATE INDEX `voucher_voucher_start_datetime_bfb7df84` ON `voucher_voucher` (`start_datetime`); | |
| COMMIT; | |
| root@ecommerce:/edx/app/ecommerce/ecommerce# ./manage.py sqlmigrate wishlists 0003_auto_20181115_1953; wait | |
| /edx/app/ecommerce/ecommerce/ecommerce/settings/production.py:59: YAMLLoadWarning: calling yaml.load() without Loader=... is deprecated, as the default Loader is unsafe. Please read https://msg.pyyaml.org/load for full details. | |
| config_from_yaml = yaml.load(f) | |
| BEGIN; | |
| -- | |
| -- Alter field date_created on wishlist | |
| -- | |
| ALTER TABLE `wishlists_wishlist` ALTER COLUMN `date_created` SET DEFAULT b"'2020-03-26 16:52:24.323284'"; | |
| CREATE INDEX `wishlists_wishlist_date_created_c05d5e7f` ON `wishlists_wishlist` (`date_created`); | |
| ALTER TABLE `wishlists_wishlist` ALTER COLUMN `date_created` DROP DEFAULT; | |
| COMMIT; | |
| root@ecommerce:/edx/app/ecommerce/ecommerce# |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment