Created
April 3, 2020 20:50
-
-
Save robrap/b3acc84c18432c2176fdd59196097071 to your computer and use it in GitHub Desktop.
Ecommerce Django 2.2 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# 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