forked from shuup/shuup
-
Notifications
You must be signed in to change notification settings - Fork 0
/
shoop-to-shuup.sql
170 lines (170 loc) · 13.7 KB
/
shoop-to-shuup.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
ALTER TABLE shoop_customertaxgroup RENAME TO shuup_customertaxgroup;
ALTER TABLE shoop_manufacturer RENAME TO shuup_manufacturer;
ALTER TABLE shoop_producttype RENAME TO shuup_producttype;
ALTER TABLE shoop_producttype_attributes RENAME TO shuup_producttype_attributes;
ALTER TABLE shoop_salesunit RENAME TO shuup_salesunit;
ALTER TABLE shoop_shopproduct_categories RENAME TO shuup_shopproduct_categories;
ALTER TABLE shoop_shopproduct_payment_methods RENAME TO shuup_shopproduct_payment_methods;
ALTER TABLE shoop_shopproduct_shipping_methods RENAME TO shuup_shopproduct_shipping_methods;
ALTER TABLE shoop_taxclass RENAME TO shuup_taxclass;
ALTER TABLE shoop_shopproduct_visibility_groups RENAME TO shuup_shopproduct_visibility_groups;
ALTER TABLE shoop_contactgroup_members RENAME TO shuup_contactgroup_members;
ALTER TABLE shoop_category_visibility_groups RENAME TO shuup_category_visibility_groups;
ALTER TABLE shoop_taxclass_translation RENAME TO shuup_taxclass_translation;
ALTER TABLE shoop_productvariationvariablevalue_translation RENAME TO shuup_productvariationvariablevalue_translation;
ALTER TABLE shoop_productvariationvariable_translation RENAME TO shuup_productvariationvariable_translation;
ALTER TABLE shoop_producttype_translation RENAME TO shuup_producttype_translation;
ALTER TABLE shoop_product_translation RENAME TO shuup_product_translation;
ALTER TABLE shoop_productmedia_translation RENAME TO shuup_productmedia_translation;
ALTER TABLE shoop_customertaxgroup_translation RENAME TO shuup_customertaxgroup_translation;
ALTER TABLE shoop_contactgroup_translation RENAME TO shuup_contactgroup_translation;
ALTER TABLE shoop_category_translation RENAME TO shuup_category_translation;
ALTER TABLE shoop_orderlinetax RENAME TO shuup_orderlinetax;
ALTER TABLE shoop_tax RENAME TO shuup_tax;
ALTER TABLE shoop_tax_translation RENAME TO shuup_tax_translation;
ALTER TABLE shoop_category RENAME TO shuup_category;
ALTER TABLE shoop_attribute RENAME TO shuup_attribute;
ALTER TABLE shoop_attribute_translation RENAME TO shuup_attribute_translation;
ALTER TABLE shoop_category_shops RENAME TO shuup_category_shops;
ALTER TABLE shoop_categorylogentry RENAME TO shuup_categorylogentry;
ALTER TABLE shoop_companycontact_members RENAME TO shuup_companycontact_members;
ALTER TABLE shoop_companycontact RENAME TO shuup_companycontact;
ALTER TABLE shoop_configurationitem RENAME TO shuup_configurationitem;
ALTER TABLE shoop_counter RENAME TO shuup_counter;
ALTER TABLE shoop_immutableaddress RENAME TO shuup_immutableaddress;
ALTER TABLE shoop_mutableaddress RENAME TO shuup_mutableaddress;
ALTER TABLE shoop_orderline RENAME TO shuup_orderline;
ALTER TABLE shoop_orderlogentry RENAME TO shuup_orderlogentry;
ALTER TABLE shoop_orderstatus RENAME TO shuup_orderstatus;
ALTER TABLE shoop_orderstatus_translation RENAME TO shuup_orderstatus_translation;
ALTER TABLE shoop_payment RENAME TO shuup_payment;
ALTER TABLE shoop_persistentcacheentry RENAME TO shuup_persistentcacheentry;
ALTER TABLE shoop_product RENAME TO shuup_product;
ALTER TABLE shoop_productattribute RENAME TO shuup_productattribute;
ALTER TABLE shoop_productattribute_translation RENAME TO shuup_productattribute_translation;
ALTER TABLE shoop_productcrosssell RENAME TO shuup_productcrosssell;
ALTER TABLE shoop_productlogentry RENAME TO shuup_productlogentry;
ALTER TABLE shoop_productmedia RENAME TO shuup_productmedia;
ALTER TABLE shoop_productmedia_shops RENAME TO shuup_productmedia_shops;
ALTER TABLE shoop_productpackagelink RENAME TO shuup_productpackagelink;
ALTER TABLE shoop_productvariationresult RENAME TO shuup_productvariationresult;
ALTER TABLE shoop_productvariationvariable RENAME TO shuup_productvariationvariable;
ALTER TABLE shoop_productvariationvariablevalue RENAME TO shuup_productvariationvariablevalue;
ALTER TABLE shoop_salesunit_translation RENAME TO shuup_salesunit_translation;
ALTER TABLE shoop_savedaddress RENAME TO shuup_savedaddress;
ALTER TABLE shoop_shipmentproduct RENAME TO shuup_shipmentproduct;
ALTER TABLE shoop_shopproduct_suppliers RENAME TO shuup_shopproduct_suppliers;
ALTER TABLE shoop_shop_translation RENAME TO shuup_shop_translation;
ALTER TABLE shoop_suppliedproduct RENAME TO shuup_suppliedproduct;
ALTER TABLE shoop_supplier RENAME TO shuup_supplier;
ALTER TABLE shoop_front_storedbasket_products RENAME TO shuup_front_storedbasket_products;
ALTER TABLE shoop_front_storedbasket RENAME TO shuup_front_storedbasket;
ALTER TABLE shoop_notify_notification RENAME TO shuup_notify_notification;
ALTER TABLE shoop_notify_script RENAME TO shuup_notify_script;
ALTER TABLE shoop_simple_cms_page_translation RENAME TO shuup_simple_cms_page_translation;
ALTER TABLE shoop_xtheme_savedviewconfig RENAME TO shuup_xtheme_savedviewconfig;
ALTER TABLE shoop_xtheme_themesettings RENAME TO shuup_xtheme_themesettings;
ALTER TABLE shoop_shopproduct RENAME TO shuup_shopproduct;
ALTER TABLE shoop_shop RENAME TO shuup_shop;
ALTER TABLE shoop_customer_group_pricing_cgpprice RENAME TO shuup_customer_group_pricing_cgpprice;
ALTER TABLE shoop_contactgroup RENAME TO shuup_contactgroup;
ALTER TABLE shoop_simple_cms_page RENAME TO shuup_simple_cms_page;
ALTER TABLE shoop_personcontact RENAME TO shuup_personcontact;
ALTER TABLE shoop_paymentmethod_translation RENAME TO shuup_paymentmethod_translation;
ALTER TABLE shoop_shippingmethod_translation RENAME TO shuup_shippingmethod_translation;
ALTER TABLE shoop_carrier RENAME TO shuup_carrier;
ALTER TABLE shoop_fixedcostbehaviorcomponent RENAME TO shuup_fixedcostbehaviorcomponent;
ALTER TABLE shoop_paymentprocessor RENAME TO shuup_paymentprocessor;
ALTER TABLE shoop_waivingcostbehaviorcomponent RENAME TO shuup_waivingcostbehaviorcomponent;
ALTER TABLE shoop_weightlimitsbehaviorcomponent RENAME TO shuup_weightlimitsbehaviorcomponent;
ALTER TABLE shoop_serviceprovider RENAME TO shuup_serviceprovider;
ALTER TABLE shoop_servicebehaviorcomponent RENAME TO shuup_servicebehaviorcomponent;
ALTER TABLE shoop_paymentmethod_behavior_components RENAME TO shuup_paymentmethod_behavior_components;
ALTER TABLE shoop_shippingmethod_behavior_components RENAME TO shuup_shippingmethod_behavior_components;
ALTER TABLE shoop_customcarrier RENAME TO shuup_customcarrier;
ALTER TABLE shoop_custompaymentprocessor RENAME TO shuup_custompaymentprocessor;
ALTER TABLE shoop_serviceprovider_translation RENAME TO shuup_serviceprovider_translation;
ALTER TABLE shoop_waivingcostbehaviorcomponent_translation RENAME TO shuup_waivingcostbehaviorcomponent_translation;
ALTER TABLE shoop_fixedcostbehaviorcomponent_translation RENAME TO shuup_fixedcostbehaviorcomponent_translation;
ALTER TABLE shoop_paymentmethod RENAME TO shuup_paymentmethod;
ALTER TABLE shoop_shippingmethod RENAME TO shuup_shippingmethod;
ALTER TABLE shoop_weightbasedpricingbehaviorcomponent RENAME TO shuup_weightbasedpricingbehaviorcomponent;
ALTER TABLE shoop_weightbasedpricerange RENAME TO shuup_weightbasedpricerange;
ALTER TABLE shoop_weightbasedpricerange_translation RENAME TO shuup_weightbasedpricerange_translation;
ALTER TABLE shoop_shipment RENAME TO shuup_shipment;
ALTER TABLE shoop_contact RENAME TO shuup_contact;
ALTER TABLE shoop_groupavailabilitybehaviorcomponent RENAME TO shuup_groupavailabilitybehaviorcomponent;
ALTER TABLE shoop_groupavailabilitybehaviorcomponent_groups RENAME TO shuup_groupavailabilitybehaviorcomponent_groups;
ALTER TABLE shoop_roundingbehaviorcomponent RENAME TO shuup_roundingbehaviorcomponent;
ALTER TABLE shoop_order RENAME TO shuup_order;
ALTER TABLE shoop_staffonlybehaviorcomponent RENAME TO shuup_staffonlybehaviorcomponent;
ALTER TABLE shoop_testing_expensiveswedenbehaviorcomponent RENAME TO shuup_testing_expensiveswedenbehaviorcomponent;
ALTER TABLE shoop_testing_paymentwithcheckoutphase RENAME TO shuup_testing_paymentwithcheckoutphase;
ALTER TABLE shoop_testing_pseudopaymentprocessor RENAME TO shuup_testing_pseudopaymentprocessor;
ALTER TABLE shoop_testing_carrierwithcheckoutphase RENAME TO shuup_testing_carrierwithcheckoutphase;
DELETE FROM django_migrations WHERE app='shoop_addons' AND name != '0001_initial';
UPDATE django_migrations SET app='shuup_addons' WHERE app='shoop_addons';
DELETE FROM django_migrations WHERE app='shoop_admin' AND name != '0001_initial';
UPDATE django_migrations SET app='shuup_admin' WHERE app='shoop_admin';
DELETE FROM django_migrations WHERE app='shoop_api' AND name != '0001_initial';
UPDATE django_migrations SET app='shuup_api' WHERE app='shoop_api';
DELETE FROM django_migrations WHERE app='shoop' AND name != '0001_initial';
UPDATE django_migrations SET app='shuup' WHERE app='shoop';
DELETE FROM django_migrations WHERE app='shoop_customer_group_pricing' AND name != '0001_initial';
UPDATE django_migrations SET app='shuup_customer_group_pricing' WHERE app='shoop_customer_group_pricing';
DELETE FROM django_migrations WHERE app='default_tax' AND name != '0001_initial';
UPDATE django_migrations SET app='default_tax' WHERE app='default_tax';
DELETE FROM django_migrations WHERE app='shoop_front' AND name != '0001_initial';
UPDATE django_migrations SET app='shuup_front' WHERE app='shoop_front';
DELETE FROM django_migrations WHERE app='shoop_front.auth' AND name != '0001_initial';
UPDATE django_migrations SET app='shuup_front.auth' WHERE app='shoop_front.auth';
DELETE FROM django_migrations WHERE app='shoop_front.customer_information' AND name != '0001_initial';
UPDATE django_migrations SET app='shuup_front.customer_information' WHERE app='shoop_front.customer_information';
DELETE FROM django_migrations WHERE app='shoop_front.personal_order_history' AND name != '0001_initial';
UPDATE django_migrations SET app='shuup_front.personal_order_history' WHERE app='shoop_front.personal_order_history';
DELETE FROM django_migrations WHERE app='shoop_front.registration' AND name != '0001_initial';
UPDATE django_migrations SET app='shuup_front.registration' WHERE app='shoop_front.registration';
DELETE FROM django_migrations WHERE app='shoop_front.simple_order_notification' AND name != '0001_initial';
UPDATE django_migrations SET app='shuup_front.simple_order_notification' WHERE app='shoop_front.simple_order_notification';
DELETE FROM django_migrations WHERE app='shoop_front.simple_search' AND name != '0001_initial';
UPDATE django_migrations SET app='shuup_front.simple_search' WHERE app='shoop_front.simple_search';
DELETE FROM django_migrations WHERE app='shoop_notify' AND name != '0001_initial';
UPDATE django_migrations SET app='shuup_notify' WHERE app='shoop_notify';
DELETE FROM django_migrations WHERE app='shoop_order_printouts' AND name != '0001_initial';
UPDATE django_migrations SET app='shuup_order_printouts' WHERE app='shoop_order_printouts';
DELETE FROM django_migrations WHERE app='shoop_simple_cms' AND name != '0001_initial';
UPDATE django_migrations SET app='shuup_simple_cms' WHERE app='shoop_simple_cms';
DELETE FROM django_migrations WHERE app='simple_supplier' AND name != '0001_initial';
UPDATE django_migrations SET app='simple_supplier' WHERE app='simple_supplier';
DELETE FROM django_migrations WHERE app='shoop_testing' AND name != '0001_initial';
UPDATE django_migrations SET app='shuup_testing' WHERE app='shoop_testing';
DELETE FROM django_migrations WHERE app='shoop.themes.classic_gray' AND name != '0001_initial';
UPDATE django_migrations SET app='shuup.themes.classic_gray' WHERE app='shoop.themes.classic_gray';
DELETE FROM django_migrations WHERE app='shoop_utils' AND name != '0001_initial';
UPDATE django_migrations SET app='shuup_utils' WHERE app='shoop_utils';
DELETE FROM django_migrations WHERE app='shoop_xtheme' AND name != '0001_initial';
UPDATE django_migrations SET app='shuup_xtheme' WHERE app='shoop_xtheme';
DELETE FROM django_migrations WHERE app='shoop_tests_core' AND name != '0001_initial';
UPDATE django_migrations SET app='shuup_tests_core' WHERE app='shoop_tests_core';
UPDATE django_content_type SET app_label='shuup_addons' WHERE app_label='shoop_addons';
UPDATE django_content_type SET app_label='shuup_admin' WHERE app_label='shoop_admin';
UPDATE django_content_type SET app_label='shuup_api' WHERE app_label='shoop_api';
UPDATE django_content_type SET app_label='shuup' WHERE app_label='shoop';
UPDATE django_content_type SET app_label='shuup_customer_group_pricing' WHERE app_label='shoop_customer_group_pricing';
UPDATE django_content_type SET app_label='default_tax' WHERE app_label='default_tax';
UPDATE django_content_type SET app_label='shuup_front' WHERE app_label='shoop_front';
UPDATE django_content_type SET app_label='shuup_front.auth' WHERE app_label='shoop_front.auth';
UPDATE django_content_type SET app_label='shuup_front.customer_information' WHERE app_label='shoop_front.customer_information';
UPDATE django_content_type SET app_label='shuup_front.personal_order_history' WHERE app_label='shoop_front.personal_order_history';
UPDATE django_content_type SET app_label='shuup_front.registration' WHERE app_label='shoop_front.registration';
UPDATE django_content_type SET app_label='shuup_front.simple_order_notification' WHERE app_label='shoop_front.simple_order_notification';
UPDATE django_content_type SET app_label='shuup_front.simple_search' WHERE app_label='shoop_front.simple_search';
UPDATE django_content_type SET app_label='shuup_notify' WHERE app_label='shoop_notify';
UPDATE django_content_type SET app_label='shuup_order_printouts' WHERE app_label='shoop_order_printouts';
UPDATE django_content_type SET app_label='shuup_simple_cms' WHERE app_label='shoop_simple_cms';
UPDATE django_content_type SET app_label='simple_supplier' WHERE app_label='simple_supplier';
UPDATE django_content_type SET app_label='shuup_testing' WHERE app_label='shoop_testing';
UPDATE django_content_type SET app_label='shuup.themes.classic_gray' WHERE app_label='shoop.themes.classic_gray';
UPDATE django_content_type SET app_label='shuup_utils' WHERE app_label='shoop_utils';
UPDATE django_content_type SET app_label='shuup_xtheme' WHERE app_label='shoop_xtheme';
UPDATE django_content_type SET app_label='shuup_tests_core' WHERE app_label='shoop_tests_core';