Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Version 3 and Version 4 Database Differences Rate Topic   - - - - -

 
  • bluexpres
  • Member
  • Members
  • Join Date: 20-Jul 13
  • 45 posts

Posted 18 September 2013 - 09:58 AM #1

Hello,
I explored some of tables differences between ver3 & ver4. I changed my "product insertion bot". You know some of tables are removed in v4 and some of fileds implemented.
I think that values are required for auto insertion bot users.

I hope it helps.


FEATURES:

@@ -2,17 +2,19 @@ CREATE TABLE `cscart_product_features` (
`feature_id` mediumint(
<img src='http://forum.cs-cart.com/public/style_emoticons/<#EMO_DIR#>/icon_cool.gif' class='bbc_emoticon' alt='8)' />
unsigned NOT NULL AUTO_INCREMENT,
+ `feature_code` varchar(32) NOT NULL DEFAULT '',
`company_id` int(11) unsigned NOT NULL,
`feature_type` char(1) NOT NULL DEFAULT 'T',
`categories_path` text NOT NULL,
`parent_id` mediumint( 8) unsigned NOT NULL DEFAULT '0',
- `display_on_product` tinyint(1) unsigned NOT NULL DEFAULT '1',
- `display_on_catalog` tinyint(1) unsigned NOT NULL DEFAULT '1',
+ `display_on_product` char(1) NOT NULL DEFAULT 'Y',
+ `display_on_catalog` char(1) NOT NULL DEFAULT 'Y',
+ `display_on_header` char(1) NOT NULL DEFAULT 'N',
`status` char(1) NOT NULL DEFAULT 'A',
`position` smallint(5) unsigned NOT NULL DEFAULT '0',
`comparison` char(1) NOT NULL DEFAULT 'N',
PRIMARY KEY (`feature_id`),
KEY `status` (`status`),
KEY `company_id` (`company_id`)


@@ -6,7 +6,7 @@ CREATE TABLE `cscart_product_features_de
`full_description` mediumtext NOT NULL,
`prefix` varchar(128) NOT NULL DEFAULT '',
`suffix` varchar(128) NOT NULL DEFAULT '',
- `lang_code` char(2) NOT NULL DEFAULT 'EN',
+ `lang_code` char(2) NOT NULL DEFAULT '',
PRIMARY KEY (`feature_id`,`lang_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


@@ -3,10 +3,11 @@
CREATE TABLE `cscart_product_features_values` (
`feature_id` mediumint( 8) unsigned NOT NULL DEFAULT '0',
`product_id` mediumint( 8) unsigned NOT NULL DEFAULT '0',
- `variant_id` mediumint( 8) unsigned DEFAULT NULL,
+ `variant_id` mediumint( 8) unsigned NOT NULL DEFAULT '0',
`value` varchar(255) NOT NULL DEFAULT '',
`value_int` double(12,2) DEFAULT NULL,
- `lang_code` char(2) NOT NULL DEFAULT 'EN',
+ `lang_code` char(2) NOT NULL DEFAULT '',
+ PRIMARY KEY (`feature_id`,`product_id`,`variant_id`,`lang_code`),
KEY `fl` (`feature_id`,`lang_code`,`variant_id`,`value`,`value_int`),
KEY `variant_id` (`variant_id`),
KEY `lang_code` (`lang_code`)

IMAGES :

@@ -5,6 +5,7 @@ CREATE TABLE `cscart_images` (
`image_path` varchar(255) NOT NULL DEFAULT '',
`image_x` int(5) NOT NULL DEFAULT '0',
`image_y` int(5) NOT NULL DEFAULT '0',
+ KEY `image_path` (`image_path`)

PRODUCTS

@@ -5,7 +5,9 @@ CREATE TABLE `cscart_discussion` (
`object_id` mediumint( 8) unsigned NOT NULL DEFAULT '0',
`object_type` char(1) NOT NULL DEFAULT '',
`type` char(1) NOT NULL DEFAULT 'D',
+ `company_id` int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`thread_id`),
- UNIQUE KEY `object_id` (`object_id`,`object_type`)
-) ENGINE=MyISAM AUTO_INCREMENT=68811 DEFAULT CHARSET=utf8;
+ UNIQUE KEY `object_id` (`object_id`,`object_type`,`company_id`),
+ KEY `company_id` (`company_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;


@@ -2,7 +2,7 @@
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cscart_product_descriptions` (
`product_id` mediumint( 8) unsigned NOT NULL DEFAULT '0',
- `lang_code` char(2) NOT NULL DEFAULT 'EN',
+ `lang_code` char(2) NOT NULL DEFAULT '',
`product` varchar(255) NOT NULL DEFAULT '',
`shortname` varchar(255) NOT NULL DEFAULT '',
`short_description` mediumtext NOT NULL,


@@ -12,6 +12,7 @@ CREATE TABLE `cscart_product_description
`search_words` text NOT NULL,
`page_title` varchar(255) NOT NULL DEFAULT '',
`age_warning_message` text NOT NULL,
+ `promo_text` mediumtext NOT NULL,
PRIMARY KEY (`product_id`,`lang_code`),
KEY `product_id` (`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


@@ -43,8 +43,10 @@ CREATE TABLE `cscart_products` (
`exceptions_type` char(1) NOT NULL DEFAULT 'F',
`details_layout` varchar(50) NOT NULL DEFAULT '',
`shipping_params` varchar(255) NOT NULL DEFAULT '',
+ `buy_now_url` varchar(255) NOT NULL,
+ `facebook_obj_type` varchar(64) NOT NULL,
PRIMARY KEY (`product_id`),
KEY `age_verification` (`age_verification`,`age_limit`),
KEY `status` (`status`)

Edit : ( 8) are
<img src='http://forum.cs-cart.com/public/style_emoticons/<#EMO_DIR#>/icon_cool.gif' class='bbc_emoticon' alt='8)' />
sorry for copy-paste

Edit :
In payment module; $processor_data['params'] is changed to $processor_data['processor_params']