Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Database structure


Mikepo

Recommended Posts

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

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

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...