Skip to content

Instantly share code, notes, and snippets.

@robrap
Created April 3, 2020 20:50
Show Gist options
  • Save robrap/b3acc84c18432c2176fdd59196097071 to your computer and use it in GitHub Desktop.
Save robrap/b3acc84c18432c2176fdd59196097071 to your computer and use it in GitHub Desktop.
Ecommerce Django 2.2 Upgrade Migration SQL
root@ecommerce:/edx/app/ecommerce/ecommerce# python manage.py sqlmigrate voucher 0011_auto_20200403_2046 --settings=ecommerce.settings.devstack
BEGIN;
--
-- Alter field offers on voucher
--
ALTER TABLE `voucher_voucher_offers` DROP FOREIGN KEY `vouche_conditionaloffer_id_f9682bfb_fk_offer_conditionaloffer_id`;
ALTER TABLE `voucher_voucher_offers` ADD CONSTRAINT `voucher_voucher_offe_conditionaloffer_id_f9682bfb_fk_offer_con` FOREIGN KEY (`conditionaloffer_id`) REFERENCES `offer_conditionaloffer` (`id`);
ALTER TABLE `voucher_voucher_offers` DROP FOREIGN KEY `voucher_voucher_offers_voucher_id_7f9c575d_fk_voucher_voucher_id`;
ALTER TABLE `voucher_voucher_offers` ADD CONSTRAINT `voucher_voucher_offers_voucher_id_7f9c575d_fk_voucher_voucher_id` FOREIGN KEY (`voucher_id`) REFERENCES `voucher_voucher` (`id`);
--
-- Alter field offer on voucherset
--
ALTER TABLE `voucher_voucherset` DROP FOREIGN KEY `voucher_voucherset_offer_id_1d10d5d6_fk_offer_con`;
ALTER TABLE `voucher_voucherset` ADD CONSTRAINT `voucher_voucherset_offer_id_1d10d5d6_fk_offer_con` FOREIGN KEY (`offer_id`) REFERENCES `offer_conditionaloffer` (`id`);
COMMIT;
root@ecommerce:/edx/app/ecommerce/ecommerce# python manage.py sqlmigrate core 0061_auto_20200403_2046 --settings=ecommerce.settings.devstack
BEGIN;
--
-- Alter field enable_enrollment_codes on siteconfiguration
--
--
-- Alter field enable_microfrontend_for_basket_page on siteconfiguration
--
--
-- Alter field enable_partial_program on siteconfiguration
--
--
-- Alter field send_refund_notifications on siteconfiguration
--
--
-- Alter field last_name on user
--
ALTER TABLE `ecommerce_user` MODIFY `last_name` varchar(150) NOT NULL;
COMMIT;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment