SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE TABLE `catalog_product_bundle_option`;
TRUNCATE TABLE `catalog_product_bundle_option_value`;
TRUNCATE TABLE `catalog_product_bundle_selection`;
TRUNCATE TABLE `catalog_product_entity_datetime`;
TRUNCATE TABLE `catalog_product_entity_decimal`;
TRUNCATE TABLE `catalog_product_entity_gallery`;
TRUNCATE TABLE `catalog_product_entity_int`;
TRUNCATE TABLE `catalog_product_entity_media_gallery`;
TRUNCATE TABLE `catalog_product_entity_media_gallery_value`;
TRUNCATE TABLE `catalog_product_entity_text`;
TRUNCATE TABLE `catalog_product_entity_tier_price`;
TRUNCATE TABLE `catalog_product_entity_varchar`;
TRUNCATE TABLE `catalog_product_link`;
TRUNCATE TABLE `catalog_product_link_attribute`;
TRUNCATE TABLE `catalog_product_link_attribute_decimal`;
TRUNCATE TABLE `catalog_product_link_attribute_int`;
TRUNCATE TABLE `catalog_product_link_attribute_varchar`;
TRUNCATE TABLE `catalog_product_link_type`;
TRUNCATE TABLE `catalog_product_option`;
TRUNCATE TABLE `catalog_product_option_price`;
TRUNCATE TABLE `catalog_product_option_title`;
TRUNCATE TABLE `catalog_product_option_type_price`;
TRUNCATE TABLE `catalog_product_option_type_title`;
TRUNCATE TABLE `catalog_product_option_type_value`;
TRUNCATE TABLE `catalog_product_super_attribute_label`;
TRUNCATE TABLE `catalog_product_super_attribute_pricing`;
TRUNCATE TABLE `catalog_product_super_attribute`;
TRUNCATE TABLE `catalog_product_super_link`;
TRUNCATE TABLE `catalog_product_enabled_index`;
TRUNCATE TABLE `catalog_product_website`;
TRUNCATE TABLE `catalog_category_product_index`;
TRUNCATE TABLE `catalog_category_product`;
TRUNCATE TABLE `cataloginventory_stock_item`;
TRUNCATE TABLE `cataloginventory_stock_status`;
TRUNCATE TABLE `cataloginventory_stock`;
INSERT INTO `catalog_product_link_type`(`link_type_id`,`code`) VALUES (1,'relation'),(2,'bundle'),(3,'super'),(4,'up_sell'),(5,'cross_sell');
INSERT INTO `catalog_product_link_attribute`(`product_link_attribute_id`,`link_type_id`,`product_link_attribute_code`,`data_type`) VALUES (1,2,'qty','decimal'),(2,1,'position','int'),(3,4,'position','int'),(4,5,'position','int'),(6,1,'qty','decimal'),(7,3,'position','int'),(8,3,'qty','decimal');
INSERT INTO `cataloginventory_stock`(`stock_id`,`stock_name`) VALUES (1,'Default');
TRUNCATE TABLE `catalog_product_entity`;
SET FOREIGN_KEY_CHECKS = 1;
2018年3月8日星期四
订阅:
博文评论 (Atom)
Also Read:
-
Vernee是由中国深圳新英国网络技术有限公司生产的手机品牌。 该品牌成立于2016年2月,标志着New Bund从OEM/ODM转移到公共市场的第一步。 Vernee手机使用Android操作系统。 该公司的定价政策使他们能够将中型硬件放在低端价格上,并附有Android OS...
-
Content URL http://download.cnet.com/Leawo-Video-Converter/3000-2194_4-209074.html http://sfree.ru/Konvertoryi/leawo-video-converter-ultim...
-
We all want to create the best content possible, but with more than a BILLION active websites and blogs on the internet today… it’s getti...
-
For every marketer, online branding is a puzzle that they must piece together themselves. Let’s face it, the guides you can find online c...
-
作者:奔跑者聊网络营销 快速排名点击软件算法实现过程 一、IP环境 地区相关性限制,非本地区的IP点击不计分(PS:部分行业有此限制,比如地区旅游行业网站,如上海旅行社必须需要上海本地的IP点击,否则不加分,多次使用外地IP点击不仅不会加分还会使网站进...
-
Content URL https://www.gearbest.com/action-cameras/pp_608129.html https://www.forbes.com/sites/bensin/2017/07/31/mgcool-explorer-es-re...
-
How to Update the Firmware of Your 3D Printer Here's how to update the firmware of your 3D printer: Download the latest firmware file...
-
如果这个世界上没有SEO 网站给用户解决了什么问题? 用户上我的网站和别人的网站有什么区别?在我的网站上会获得更好的信息还是更好的体验? 用户是否会记得我的网站? 如果你的网站不能解决上面这几个问题,那SEO也不会好到哪里去。
-
除了删除已无法使用的工具、增加新工具,修正新形势下的SEO观点外,还大幅增加了SEO行业近年最新发展,如: · 移动SEO部分扩充完善并独立成章 · 增加搜索引擎算法更新一章 · 增加人工智能与SEO小节 · 增加近年常见的SEO作弊方法讨论,如伪原创、百度快排、负面SEO等...
-
进行行业研究 报告获取外链|林子超博客 进行行业研究 从您所在领域的权威博客和新闻网站获取反向链接的最佳方式是什么? 一项行业研究。 事实上,BuzzSumo 发现发布行业研究可以为您带来大量流量、社交媒体分享和媒体提及。 编辑搜图 不久前,我注意到很多 SEO 博客都在谈论语...
Do you need to increase your credit score?
回复删除Do you intend to upgrade your school grade?
Do you want to hack your cheating spouse Email, whatsapp, Facebook, instagram or any social network?
Do you need any information concerning any database.
Do you need to retrieve deleted files?
Do you need to clear your criminal records or DMV?
Do you want to remove any site or link from any blog?
you should contact this hacker, he is reliable and good at the hack jobs..
contact : cybergoldenhacker at gmail dot com
I can’t say much but with my experience through divorce, I had no one until I met hackingsetting50@gmail.com online then I contacted him, surprisingly he helped me hack into my partner's phone and all his social media platforms and i can now access everything and even documented and printed stuffs to show as evidence , now I’m happy with my kids and working for Riches. I hope this helps anyone in need.
回复删除Thanks.