Forums

Community Store addon help with site move

Permalink
I don't know where else to ask this. I'm trying to move a Concrete5 site with Community Store addon 0.9.9.9. I need to convert the mysql table names to CamelCase from all lower case for CommunityStore. How do I do this? Manually one by one? There is 42 of them.
 
mesuva replied on at Permalink Reply
mesuva
I'm not quite sure what tables would not be present in 0.9.9.9, and I'm only counting 37, but you could try something like this SQL command (obviously backup first):
RENAME TABLE btcommunitystoreproduct TO btCommunityStoreProduct;
RENAME TABLE btcommunitystoreproductlist TO btCommunityStoreProductList;
RENAME TABLE btcommunitystoreproductlistgroups TO btCommunityStoreProductListGroups;
RENAME TABLE communitystoredigitalfiles TO CommunityStoreDigitalFiles;
RENAME TABLE communitystorediscountcodes TO CommunityStoreDiscountCodes;
RENAME TABLE communitystorediscountrules TO CommunityStoreDiscountRules;
RENAME TABLE communitystoreflatratemethods TO CommunityStoreFlatRateMethods;
RENAME TABLE communitystorefreeshippingmethods TO CommunityStoreFreeShippingMethods;
RENAME TABLE communitystoregroups TO CommunityStoreGroups;
RENAME TABLE communitystoreorderattributekeyusergroups TO CommunityStoreOrderAttributeKeyUserGroups;
RENAME TABLE communitystoreorderattributekeys TO CommunityStoreOrderAttributeKeys;
RENAME TABLE communitystoreorderattributevalues TO CommunityStoreOrderAttributeValues;
RENAME TABLE communitystoreorderdiscounts TO CommunityStoreOrderDiscounts;
RENAME TABLE communitystoreorderitemdiscounts TO CommunityStoreOrderItemDiscounts;
RENAME TABLE communitystoreorderitemoptions TO CommunityStoreOrderItemOptions;
Viewing 15 lines of 37 lines. View entire code block.
scottg12 replied on at Permalink Reply
Thanks, that helps.