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(```php
+ `feature_code` varchar(32) NOT NULL DEFAULT '',<br />
`company_id` int(11) unsigned NOT NULL,<br />
`feature_type` char(1) NOT NULL DEFAULT 'T',<br />
`categories_path` text NOT NULL,<br />
`parent_id` mediumint( <img src="upload://oPnLkqdJc33Dyf2uA3TQwRkfhwd.gif" class="bbc_emoticon" alt="8)"> unsigned NOT NULL DEFAULT '0',<br />
- `display_on_product` tinyint(1) unsigned NOT NULL DEFAULT '1',<br />
- `display_on_catalog` tinyint(1) unsigned NOT NULL DEFAULT '1',<br />
+ `display_on_product` char(1) NOT NULL DEFAULT 'Y',<br />
+ `display_on_catalog` char(1) NOT NULL DEFAULT 'Y',<br />
+ `display_on_header` char(1) NOT NULL DEFAULT 'N',<br />
`status` char(1) NOT NULL DEFAULT 'A',<br />
`position` smallint(5) unsigned NOT NULL DEFAULT '0',<br />
`comparison` char(1) NOT NULL DEFAULT 'N',<br />
PRIMARY KEY (`feature_id`),<br />
KEY `status` (`status`),<br />
KEY `company_id` (`company_id`)<br />
<br />
<br />
@@ -6,7 +6,7 @@ CREATE TABLE `cscart_product_features_de<br />
`full_description` mediumtext NOT NULL,<br />
`prefix` varchar(128) NOT NULL DEFAULT '',<br />
`suffix` varchar(128) NOT NULL DEFAULT '',<br />
- `lang_code` char(2) NOT NULL DEFAULT 'EN',<br />
+ `lang_code` char(2) NOT NULL DEFAULT '',<br />
PRIMARY KEY (`feature_id`,`lang_code`)<br />
) ENGINE=MyISAM DEFAULT CHARSET=utf8;<br />
<br />
<br />
@@ -3,10 +3,11 @@<br />
CREATE TABLE `cscart_product_features_values` (<br />
`feature_id` mediumint( <img src="upload://oPnLkqdJc33Dyf2uA3TQwRkfhwd.gif" class="bbc_emoticon" alt="8)"> unsigned NOT NULL DEFAULT '0',<br />
`product_id` mediumint( <img src="upload://oPnLkqdJc33Dyf2uA3TQwRkfhwd.gif" class="bbc_emoticon" alt="8)"> unsigned NOT NULL DEFAULT '0',<br />
- `variant_id` mediumint( <img src="upload://oPnLkqdJc33Dyf2uA3TQwRkfhwd.gif" class="bbc_emoticon" alt="8)"> unsigned DEFAULT NULL,<br />
+ `variant_id` mediumint( <img src="upload://oPnLkqdJc33Dyf2uA3TQwRkfhwd.gif" class="bbc_emoticon" alt="8)"> unsigned NOT NULL DEFAULT '0',<br />
`value` varchar(255) NOT NULL DEFAULT '',<br />
`value_int` double(12,2) DEFAULT NULL,<br />
- `lang_code` char(2) NOT NULL DEFAULT 'EN',<br />
+ `lang_code` char(2) NOT NULL DEFAULT '',<br />
+ PRIMARY KEY (`feature_id`,`product_id`,`variant_id`,`lang_code`),<br />
KEY `fl` (`feature_id`,`lang_code`,`variant_id`,`value`,`value_int`),<br />
KEY `variant_id` (`variant_id`),<br />
KEY `lang_code` (`lang_code`)<br />
<br />
[b]IMAGES :[/b]<br />
<br />
@@ -5,6 +5,7 @@ CREATE TABLE `cscart_images` (<br />
`image_path` varchar(255) NOT NULL DEFAULT '',<br />
`image_x` int(5) NOT NULL DEFAULT '0',<br />
`image_y` int(5) NOT NULL DEFAULT '0',<br />
+ KEY `image_path` (`image_path`)<br />
<br />
[b]PRODUCTS[/b]<br />
<br />
@@ -5,7 +5,9 @@ CREATE TABLE `cscart_discussion` (<br />
`object_id` mediumint( <img src="upload://oPnLkqdJc33Dyf2uA3TQwRkfhwd.gif" class="bbc_emoticon" alt="8)"> unsigned NOT NULL DEFAULT '0',<br />
`object_type` char(1) NOT NULL DEFAULT '',<br />
`type` char(1) NOT NULL DEFAULT 'D',<br />
+ `company_id` int(11) unsigned NOT NULL DEFAULT '0',<br />
PRIMARY KEY (`thread_id`),<br />
- UNIQUE KEY `object_id` (`object_id`,`object_type`)<br />
-) ENGINE=MyISAM AUTO_INCREMENT=68811 DEFAULT CHARSET=utf8;<br />
+ UNIQUE KEY `object_id` (`object_id`,`object_type`,`company_id`),<br />
+ KEY `company_id` (`company_id`)<br />
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;<br />
<br />
<br />
@@ -2,7 +2,7 @@<br />
/*!40101 SET character_set_client = utf8 */;<br />
CREATE TABLE `cscart_product_descriptions` (<br />
`product_id` mediumint( <img src="upload://oPnLkqdJc33Dyf2uA3TQwRkfhwd.gif" class="bbc_emoticon" alt="8)"> unsigned NOT NULL DEFAULT '0',<br />
- `lang_code` char(2) NOT NULL DEFAULT 'EN',<br />
+ `lang_code` char(2) NOT NULL DEFAULT '',<br />
`product` varchar(255) NOT NULL DEFAULT '',<br />
`shortname` varchar(255) NOT NULL DEFAULT '',<br />
`short_description` mediumtext NOT NULL,<br />
<br />
<br />
@@ -12,6 +12,7 @@ CREATE TABLE `cscart_product_description<br />
`search_words` text NOT NULL,<br />
`page_title` varchar(255) NOT NULL DEFAULT '',<br />
`age_warning_message` text NOT NULL,<br />
+ `promo_text` mediumtext NOT NULL,<br />
PRIMARY KEY (`product_id`,`lang_code`),<br />
KEY `product_id` (`product_id`)<br />
) ENGINE=MyISAM DEFAULT CHARSET=utf8;<br />
<br />
<br />
@@ -43,8 +43,10 @@ CREATE TABLE `cscart_products` (<br />
`exceptions_type` char(1) NOT NULL DEFAULT 'F',<br />
`details_layout` varchar(50) NOT NULL DEFAULT '',<br />
`shipping_params` varchar(255) NOT NULL DEFAULT '',<br />
+ `buy_now_url` varchar(255) NOT NULL,<br />
+ `facebook_obj_type` varchar(64) NOT NULL,<br />
PRIMARY KEY (`product_id`),<br />
KEY `age_verification` (`age_verification`,`age_limit`),<br />
KEY `status` (`status`)<br />
<br />
Edit : ( <img src="upload://oPnLkqdJc33Dyf2uA3TQwRkfhwd.gif" class="bbc_emoticon" alt="8)"> are<br />
```php
<br />
<img src="upload://oPnLkqdJc33Dyf2uA3TQwRkfhwd.gif" class="bbc_emoticon" alt="8)"><br />
``` sorry for copy-paste<br />
<br />
Edit : <br />
In payment module; $processor_data['params'] is changed to $processor_data['processor_params']