Mikepo Posted June 14, 2018 Share Posted June 14, 2018 Just a quick question: Are there any changes in the DB structure between, 2.3.4BS Gold and 2.3.4.1 CE (frozen)? thanks Mike osC CE live - developing osC Phoenix adding modules with no core changes(awesome and easy!) Link to comment Share on other sites More sharing options...
MrPhil Posted June 14, 2018 Share Posted June 14, 2018 I'm pretty sure things have changed since Gold (which is quite old now), but I don't have any references. The easiest way to check what's changed would be to make a database backup of your Gold (.sql file with table creation code) and compare it to oscommerce.sql in Frozen (assuming you don't have Frozen installed yet). The differences should be fairly minor, but there are likely to be a few. Link to comment Share on other sites More sharing options...
burt Posted June 14, 2018 Share Posted June 14, 2018 @Mikepo https://github.com/gburton/Responsive-osCommerce/commits/master/install/oscommerce.sql Link to comment Share on other sites More sharing options...
burt Posted June 14, 2018 Share Posted June 14, 2018 ps, you can do that for any file, just navigate to the file (at github) and then hit the history button. Link to comment Share on other sites More sharing options...
Mikepo Posted June 14, 2018 Author Share Posted June 14, 2018 I think the differences are as follows: TABLE `categories_description` `categories_seo_title` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL (NEW) TABLE `manufacturers_info` `manufacturers_seo_title` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL (NEW) TABLE `orders_products` `products_model` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, (CHANGE) TABLE `products` `products_model` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, (CHANGE) CREATE TABLE `sessions` `sesskey` varchar(128) COLLATE utf8_unicode_ci NOT NULL, (CHANGE) CREATE TABLE `testimonials` ( `testimonials_id` int(11) NOT NULL, `customers_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `date_added` datetime DEFAULT NULL, `last_modified` datetime DEFAULT NULL, `testimonials_status` tinyint(1) NOT NULL DEFAULT '1' (NEW) osC CE live - developing osC Phoenix adding modules with no core changes(awesome and easy!) Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.