You are viewing an old revision of this post, from October 28, 2014 @ 13:42:05. See below for differences between this version and the current revision.

Deleting All Products from a magento database with SQL

It doesn’t happen often, but sometimes I need to wipe all products from a magento database during development. Either an import was written slightly off, or it was just full of test data and it’s cleaner to wipe the products instead of deleting them through the admin.

A simple script for this found in a few spots on the internet, but the most updated one for Magento 1.8 is:

SET FOREIGN_KEY_CHECKS = 0;

TRUNCATE TABLE `catalog_product_bundle_price_index`;
TRUNCATE TABLE `catalog_product_bundle_selection`;
TRUNCATE TABLE `catalog_product_bundle_selection_price`;
TRUNCATE TABLE `catalog_product_bundle_option_value`;
TRUNCATE TABLE `catalog_product_bundle_option`;
TRUNCATE TABLE `catalog_product_entity_datetime`;
TRUNCATE TABLE `catalog_product_entity_decimal`;
TRUNCATE TABLE `catalog_product_entity_gallery`;
truncate table `catalog_product_entity_group_price`;
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_flat_1`;
TRUNCATE TABLE `catalog_product_link`;
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_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 `catalog_product_entity`;
TRUNCATE TABLE `catalog_product_relation`;

TRUNCATE TABLE `cataloginventory_stock_item`;
TRUNCATE TABLE `cataloginventory_stock_status`;
SET FOREIGN_KEY_CHECKS = 1;

Revisions

Revision Differences

October 28, 2014 @ 13:42:05Current Revision
Content
Unchanged: <div class="entry-content" style="border: 0px;margin: 0px;padding: 12px 0px 0px;vertical-align: baseline;clear: both;font-family: Georgia, 'Bitstream Charter', serif;font-size: 16px;line-height: 24px"> Unchanged: <div class="entry-content" style="border: 0px;margin: 0px;padding: 12px 0px 0px;vertical-align: baseline;clear: both;font-family: Georgia, 'Bitstream Charter', serif;font-size: 16px;line-height: 24px">
Unchanged: <p style="border: 0px;margin: 0px 0px 24px;padding: 0px;vertical-align: baseline;background: transparent"> Unchanged: <p style="border: 0px;margin: 0px 0px 24px;padding: 0px;vertical-align: baseline;background: transparent">
Unchanged: It doesn&rsquo;t happen often, but sometimes I need to wipe all products from a magento database during development. Either an import was written slightly off, or it was just full of test data and it&rsquo;s cleaner to wipe the products instead of deleting them through the admin. Unchanged: It doesn&rsquo;t happen often, but sometimes I need to wipe all products from a magento database during development. Either an import was written slightly off, or it was just full of test data and it&rsquo;s cleaner to wipe the products instead of deleting them through the admin.
Unchanged: </p> Unchanged: </p>
Unchanged: <p style="border: 0px;margin: 0px 0px 24px;padding: 0px;vertical-align: baseline;background: transparent"> Unchanged: <p style="border: 0px;margin: 0px 0px 24px;padding: 0px;vertical-align: baseline;background: transparent">
Unchanged: A simple script for this found in a few spots on the internet, but the most updated one for Magento 1.8 is: Unchanged: A simple script for this found in a few spots on the internet, but the most updated one for Magento 1.8 is:
Unchanged: </p> Unchanged: </p>
Deleted: <div class="syntaxhighlighter " id="highlighter_673078">  
Deleted: <div class="lines" style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <div class="line alt1" style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important">  
Deleted: <table>  
Deleted: <tbody style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <tr style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <td class="number">  
Deleted: <code style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px 0.3em 0px 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;text-align: right !important;float: none !important;height: auto !important;width: 2.7em !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">1</code>  
Deleted: </td>  
Deleted: <td class="content">  
Deleted: <code class="keyword" >SET</code>&nbsp;<code class="plain" style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">FOREIGN_KEY_CHECKS = 0;</code>  
Deleted: </td>  
Deleted: </tr>  
Deleted: </tbody>  
Deleted: </table>  
Deleted: </div>  
Deleted: <div class="line alt2">  
Deleted: <table>  
Deleted: <tbody style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <tr style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <td class="number">  
Deleted: <code style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px 0.3em 0px 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;text-align: right !important;float: none !important;height: auto !important;width: 2.7em !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">2</code>  
Deleted: </td>  
Deleted: <td class="content">  
Deleted: &nbsp;  
Deleted: </td>  
Deleted: </tr>  
Deleted: </tbody>  
Deleted: </table>  
Deleted: </div>  
Deleted: <div class="line alt1" style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important">  
Deleted: <table>  
Deleted: <tbody style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <tr style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <td class="number">  
Deleted: <code style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px 0.3em 0px 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;text-align: right !important;float: none !important;height: auto !important;width: 2.7em !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">3</code>  
Deleted: </td>  
Deleted: <td class="content">  
Deleted: <code class="keyword" >TRUNCATE</code>&nbsp;<code class="keyword" >TABLE</code>&nbsp;<code class="plain" style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">`catalog_ product_bundle_ price_index`;</code>  
Deleted: </td>  
Deleted: </tr>  
Deleted: </tbody>  
Deleted: </table>  
Deleted: </div>  
Deleted: <div class="line alt2">  
Deleted: <table>  
Deleted: <tbody style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <tr style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <td class="number">  
Deleted: <code style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px 0.3em 0px 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;text-align: right !important;float: none !important;height: auto !important;width: 2.7em !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">4</code>  
Deleted: </td>  
Deleted: <td class="content">  
Deleted: <code class="keyword" >TRUNCATE</code>&nbsp;<code class="keyword" >TABLE</code>&nbsp;<code class="plain" style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">`catalog_ product_bundle_ selection`;</code>  
Deleted: </td>  
Deleted: </tr>  
Deleted: </tbody>  
Deleted: </table>  
Deleted: </div>  
Deleted: <div class="line alt1" style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important">  
Deleted: <table>  
Deleted: <tbody style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <tr style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <td class="number">  
Deleted: <code style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px 0.3em 0px 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;text-align: right !important;float: none !important;height: auto !important;width: 2.7em !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">5</code>  
Deleted: </td>  
Deleted: <td class="content">  
Deleted: <code class="keyword" >TRUNCATE</code>&nbsp;<code class="keyword" >TABLE</code>&nbsp;<code class="plain" style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">`catalog_ product_bundle_selection_ price`;</code>  
Deleted: </td>  
Deleted: </tr>  
Deleted: </tbody>  
Deleted: </table>  
Deleted: </div>  
Deleted: <div class="line alt2">  
Deleted: <table>  
Deleted: <tbody style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <tr style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <td class="number">  
Deleted: <code style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px 0.3em 0px 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;text-align: right !important;float: none !important;height: auto !important;width: 2.7em !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">6</code>  
Deleted: </td>  
Deleted: <td class="content">  
Deleted: <code class="keyword" >TRUNCATE</code>&nbsp;<code class="keyword" >TABLE</code>&nbsp;<code class="plain" style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">`catalog_ product_bundle_ option_value`;</code>  
Deleted: </td>  
Deleted: </tr>  
Deleted: </tbody>  
Deleted: </table>  
Deleted: </div>  
Deleted: <div class="line alt1" style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important">  
Deleted: <table>  
Deleted: <tbody style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <tr style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <td class="number">  
Deleted: <code style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px 0.3em 0px 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;text-align: right !important;float: none !important;height: auto !important;width: 2.7em !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">7</code>  
Deleted: </td>  
Deleted: <td class="content">  
Deleted: <code class="keyword" >TRUNCATE</code>&nbsp;<code class="keyword" >TABLE</code>&nbsp;<code class="plain" style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">`catalog_ product_bundle_ option`;</code>  
Deleted: </td>  
Deleted: </tr>  
Deleted: </tbody>  
Deleted: </table>  
Deleted: </div>  
Deleted: <div class="line alt2">  
Deleted: <table>  
Deleted: <tbody style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <tr style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <td class="number">  
Deleted: <code style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px 0.3em 0px 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;text-align: right !important;float: none !important;height: auto !important;width: 2.7em !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">8</code>  
Deleted: </td>  
Deleted: <td class="content">  
Deleted: <code class="keyword" >TRUNCATE</code>&nbsp;<code class="keyword" >TABLE</code>&nbsp;<code class="plain" style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">`catalog_ product_entity_ datetime`;</code>  
Deleted: </td>  
Deleted: </tr>  
Deleted: </tbody>  
Deleted: </table>  
Deleted: </div>  
Deleted: <div class="line alt1" style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important">  
Deleted: <table>  
Deleted: <tbody style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <tr style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <td class="number">  
Deleted: <code style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px 0.3em 0px 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;text-align: right !important;float: none !important;height: auto !important;width: 2.7em !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">9</code>  
Deleted: </td>  
Deleted: <td class="content">  
Deleted: <code class="keyword" >TRUNCATE</code>&nbsp;<code class="keyword" >TABLE</code>&nbsp;<code class="plain" style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">`catalog_ product_entity_ decimal`;</code>  
Deleted: </td>  
Deleted: </tr>  
Deleted: </tbody>  
Deleted: </table>  
Deleted: </div>  
Deleted: <div class="line alt2">  
Deleted: <table>  
Deleted: <tbody style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <tr style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <td class="number">  
Deleted: <code style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px 0.3em 0px 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;text-align: right !important;float: none !important;height: auto !important;width: 2.7em !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">10</code>  
Deleted: </td>  
Deleted: <td class="content">  
Deleted: <code class="keyword" >TRUNCATE</code>&nbsp;<code class="keyword" >TABLE</code>&nbsp;<code class="plain" style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">`catalog_ product_entity_ gallery`;</code>  
Deleted: </td>  
Deleted: </tr>  
Deleted: </tbody>  
Deleted: </table>  
Deleted: </div>  
Deleted: <div class="line alt1" style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important">  
Deleted: <table>  
Deleted: <tbody style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <tr style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <td class="number">  
Deleted: <code style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px 0.3em 0px 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;text-align: right !important;float: none !important;height: auto !important;width: 2.7em !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">11</code>  
Deleted: </td>  
Deleted: <td class="content">  
Deleted: <code class="keyword" >truncate</code>&nbsp;<code class="keyword" >table</code>&nbsp;<code class="plain" style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">`catalog_ product_entity_ group_price`;</code>  
Deleted: </td>  
Deleted: </tr>  
Deleted: </tbody>  
Deleted: </table>  
Deleted: </div>  
Deleted: <div class="line alt2">  
Deleted: <table>  
Deleted: <tbody style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <tr style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <td class="number">  
Deleted: <code style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px 0.3em 0px 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;text-align: right !important;float: none !important;height: auto !important;width: 2.7em !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">12</code>  
Deleted: </td>  
Deleted: <td class="content">  
Deleted: <code class="keyword" >TRUNCATE</code>&nbsp;<code class="keyword" >TABLE</code>&nbsp;<code class="plain" style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">`catalog_ product_entity_ int`;</code>  
Deleted: </td>  
Deleted: </tr>  
Deleted: </tbody>  
Deleted: </table>  
Deleted: </div>  
Deleted: <div class="line alt1" style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important">  
Deleted: <table>  
Deleted: <tbody style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <tr style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <td class="number">  
Deleted: <code style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px 0.3em 0px 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;text-align: right !important;float: none !important;height: auto !important;width: 2.7em !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">13</code>  
Deleted: </td>  
Deleted: <td class="content">  
Deleted: <code class="keyword" >TRUNCATE</code>&nbsp;<code class="keyword" >TABLE</code>&nbsp;<code class="plain" style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">`catalog_ product_entity_ media_gallery`;</code>  
Deleted: </td>  
Deleted: </tr>  
Deleted: </tbody>  
Deleted: </table>  
Deleted: </div>  
Deleted: <div class="line alt2">  
Deleted: <table>  
Deleted: <tbody style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
  Added: <p>
  Added: SET FOREIGN_KEY_CHECKS = 0;
  Added: </p>
  Added: <p>
  Added: TRUNCATE TABLE `catalog_product_ bundle_price_index`;<br />
  Added: TRUNCATE TABLE `catalog_product_ bundle_selection`;<br />
  Added: TRUNCATE TABLE `catalog_product_ bundle_selection_price`;<br />
  Added: TRUNCATE TABLE `catalog_product_ bundle_option_value`;<br />
  Added: TRUNCATE TABLE `catalog_product_ bundle_option`;<br />
  Added: TRUNCATE TABLE `catalog_product_ entity_datetime`;<br />
  Added: TRUNCATE TABLE `catalog_product_ entity_decimal`;<br />
  Added: TRUNCATE TABLE `catalog_product_ entity_gallery`;<br />
Deleted: <tr style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important"> Added: truncate table `catalog_product_ entity_group_price`;<br />
Deleted: <td class="number">  
Deleted: <code style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px 0.3em 0px 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;text-align: right !important;float: none !important;height: auto !important;width: 2.7em !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">14</code>  
Deleted: </td>  
Deleted: <td class="content">  
  Added: TRUNCATE TABLE `catalog_product_ entity_int`;<br />
  Added: TRUNCATE TABLE `catalog_product_ entity_media_ gallery`;<br />
Deleted: <code class="keyword" >TRUNCATE</code>&nbsp;<code class="keyword" >TABLE</code>&nbsp;<code class="plain" style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">`catalog_ product_entity_ media_gallery_ value`;</code> Added: TRUNCATE TABLE `catalog_product_ entity_media_ gallery_value`;<br />
Deleted: </td>  
Deleted: </tr>  
Deleted: </tbody>  
Deleted: </table>  
Deleted: </div>  
Deleted: <div class="line alt1" style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important">  
Deleted: <table>  
Deleted: <tbody style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <tr style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <td class="number">  
Deleted: <code style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px 0.3em 0px 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;text-align: right !important;float: none !important;height: auto !important;width: 2.7em !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">15</code>  
Deleted: </td>  
Deleted: <td class="content">  
Deleted: <code class="keyword" >TRUNCATE</code>&nbsp;<code class="keyword" >TABLE</code>&nbsp;<code class="plain" style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">`catalog_ product_entity_ text`;</code>  
Deleted: </td>  
Deleted: </tr>  
Deleted: </tbody>  
Deleted: </table>  
Deleted: </div>  
Deleted: <div class="line alt2">  
Deleted: <table>  
Deleted: <tbody style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <tr style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <td class="number">  
Deleted: <code style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px 0.3em 0px 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;text-align: right !important;float: none !important;height: auto !important;width: 2.7em !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">16</code>  
Deleted: </td>  
Deleted: <td class="content">  
Deleted: <code class="keyword" >TRUNCATE</code>&nbsp;<code class="keyword" >TABLE</code>&nbsp;<code class="plain" style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">`catalog_ product_entity_ tier_price`;</code>  
Deleted: </td>  
Deleted: </tr>  
Deleted: </tbody>  
Deleted: </table>  
Deleted: </div>  
Deleted: <div class="line alt1" style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important">  
Deleted: <table>  
Deleted: <tbody style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <tr style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <td class="number">  
Deleted: <code style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px 0.3em 0px 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;text-align: right !important;float: none !important;height: auto !important;width: 2.7em !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">17</code>  
Deleted: </td>  
Deleted: <td class="content">  
Deleted: <code class="keyword" >TRUNCATE</code>&nbsp;<code class="keyword" >TABLE</code>&nbsp;<code class="plain" style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">`catalog_ product_entity_ varchar`;</code>  
Deleted: </td>  
Deleted: </tr>  
Deleted: </tbody>  
Deleted: </table>  
Deleted: </div>  
Deleted: <div class="line alt2">  
Deleted: <table>  
Deleted: <tbody style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <tr style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <td class="number">  
Deleted: <code style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px 0.3em 0px 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;text-align: right !important;float: none !important;height: auto !important;width: 2.7em !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">18</code>  
Deleted: </td>  
Deleted: <td class="content">  
Deleted: <code class="keyword" >TRUNCATE</code>&nbsp;<code class="keyword" >TABLE</code>&nbsp;<code class="plain" style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">`catalog_ product_flat_1`;</code>  
Deleted: </td>  
Deleted: </tr>  
Deleted: </tbody>  
Deleted: </table>  
Deleted: </div>  
Deleted: <div class="line alt1" style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important">  
Deleted: <table>  
Deleted: <tbody style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <tr style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <td class="number">  
Deleted: <code style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px 0.3em 0px 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;text-align: right !important;float: none !important;height: auto !important;width: 2.7em !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">19</code>  
Deleted: </td>  
Deleted: <td class="content">  
Deleted: <code class="keyword" >TRUNCATE</code>&nbsp;<code class="keyword" >TABLE</code>&nbsp;<code class="plain" style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">`catalog_ product_link`;</code>  
Deleted: </td>  
Deleted: </tr>  
Deleted: </tbody>  
Deleted: </table>  
Deleted: </div>  
Deleted: <div class="line alt2">  
Deleted: <table>  
Deleted: <tbody style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <tr style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <td class="number">  
Deleted: <code style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px 0.3em 0px 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;text-align: right !important;float: none !important;height: auto !important;width: 2.7em !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">20</code>  
Deleted: </td>  
Deleted: <td class="content">  
Deleted: <code class="keyword" >TRUNCATE</code>&nbsp;<code class="keyword" >TABLE</code>&nbsp;<code class="plain" style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">`catalog_ product_link_ attribute_decimal`;</code>  
Deleted: </td>  
Deleted: </tr>  
Deleted: </tbody>  
Deleted: </table>  
Deleted: </div>  
Deleted: <div class="line alt1" style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important">  
Deleted: <table>  
Deleted: <tbody style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <tr style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <td class="number">  
Deleted: <code style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px 0.3em 0px 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;text-align: right !important;float: none !important;height: auto !important;width: 2.7em !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">21</code>  
Deleted: </td>  
Deleted: <td class="content">  
Deleted: <code class="keyword" >TRUNCATE</code>&nbsp;<code class="keyword" >TABLE</code>&nbsp;<code class="plain" style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">`catalog_ product_link_ attribute_int`;</code>  
Deleted: </td>  
Deleted: </tr>  
Deleted: </tbody>  
Deleted: </table>  
Deleted: </div>  
Deleted: <div class="line alt2">  
Deleted: <table>  
Deleted: <tbody style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <tr style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <td class="number">  
Deleted: <code style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px 0.3em 0px 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;text-align: right !important;float: none !important;height: auto !important;width: 2.7em !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">22</code>  
Deleted: </td>  
Deleted: <td class="content">  
Deleted: <code class="keyword" >TRUNCATE</code>&nbsp;<code class="keyword" >TABLE</code>&nbsp;<code class="plain" style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">`catalog_ product_link_ attribute_varchar`;</code>  
Deleted: </td>  
Deleted: </tr>  
Deleted: </tbody>  
Deleted: </table>  
Deleted: </div>  
Deleted: <div class="line alt1" style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important">  
Deleted: <table>  
Deleted: <tbody style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <tr style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <td class="number">  
Deleted: <code style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px 0.3em 0px 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;text-align: right !important;float: none !important;height: auto !important;width: 2.7em !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">23</code>  
Deleted: </td>  
Deleted: <td class="content">  
Deleted: <code class="keyword" >TRUNCATE</code>&nbsp;<code class="keyword" >TABLE</code>&nbsp;<code class="plain" style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">`catalog_ product_option`;</code>  
Deleted: </td>  
Deleted: </tr>  
Deleted: </tbody>  
Deleted: </table>  
Deleted: </div>  
Deleted: <div class="line alt2">  
Deleted: <table>  
Deleted: <tbody style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <tr style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <td class="number">  
Deleted: <code style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px 0.3em 0px 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;text-align: right !important;float: none !important;height: auto !important;width: 2.7em !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">24</code>  
Deleted: </td>  
Deleted: <td class="content">  
Deleted: <code class="keyword" >TRUNCATE</code>&nbsp;<code class="keyword" >TABLE</code>&nbsp;<code class="plain" style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">`catalog_ product_option_ price`;</code>  
Deleted: </td>  
Deleted: </tr>  
Deleted: </tbody>  
Deleted: </table>  
Deleted: </div>  
Deleted: <div class="line alt1" style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important">  
Deleted: <table>  
Deleted: <tbody style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <tr style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <td class="number">  
Deleted: <code style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px 0.3em 0px 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;text-align: right !important;float: none !important;height: auto !important;width: 2.7em !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">25</code>  
Deleted: </td>  
Deleted: <td class="content">  
Deleted: <code class="keyword" >TRUNCATE</code>&nbsp;<code class="keyword" >TABLE</code>&nbsp;<code class="plain" style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">`catalog_ product_option_ title`;</code>  
Deleted: </td>  
Deleted: </tr>  
Deleted: </tbody>  
Deleted: </table>  
Deleted: </div>  
Deleted: <div class="line alt2">  
Deleted: <table>  
Deleted: <tbody style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <tr style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <td class="number">  
Deleted: <code style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px 0.3em 0px 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;text-align: right !important;float: none !important;height: auto !important;width: 2.7em !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">26</code>  
Deleted: </td>  
Deleted: <td class="content">  
Deleted: <code class="keyword" >TRUNCATE</code>&nbsp;<code class="keyword" >TABLE</code>&nbsp;<code class="plain" style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">`catalog_ product_option_ type_price`;</code>  
Deleted: </td>  
Deleted: </tr>  
Deleted: </tbody>  
Deleted: </table>  
Deleted: </div>  
Deleted: <div class="line alt1" style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important">  
Deleted: <table>  
Deleted: <tbody style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <tr style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <td class="number">  
Deleted: <code style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px 0.3em 0px 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;text-align: right !important;float: none !important;height: auto !important;width: 2.7em !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">27</code>  
Deleted: </td>  
Deleted: <td class="content">  
Deleted: <code class="keyword" >TRUNCATE</code>&nbsp;<code class="keyword" >TABLE</code>&nbsp;<code class="plain" style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">`catalog_ product_option_ type_title`;</code>  
Deleted: </td>  
Deleted: </tr>  
Deleted: </tbody>  
Deleted: </table>  
Deleted: </div>  
Deleted: <div class="line alt2">  
Deleted: <table>  
Deleted: <tbody style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <tr style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <td class="number">  
Deleted: <code style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px 0.3em 0px 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;text-align: right !important;float: none !important;height: auto !important;width: 2.7em !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">28</code>  
Deleted: </td>  
Deleted: <td class="content">  
Deleted: <code class="keyword" >TRUNCATE</code>&nbsp;<code class="keyword" >TABLE</code>&nbsp;<code class="plain" style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">`catalog_ product_option_ type_value`;</code>  
Deleted: </td>  
Deleted: </tr>  
Deleted: </tbody>  
Deleted: </table>  
Deleted: </div>  
Deleted: <div class="line alt1" style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important">  
Deleted: <table>  
Deleted: <tbody style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <tr style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <td class="number">  
Deleted: <code style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px 0.3em 0px 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;text-align: right !important;float: none !important;height: auto !important;width: 2.7em !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">29</code>  
Deleted: </td>  
Deleted: <td class="content">  
Deleted: <code class="keyword" >TRUNCATE</code>&nbsp;<code class="keyword" >TABLE</code>&nbsp;<code class="plain" style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">`catalog_ product_super_ attribute_label`;</code>  
Deleted: </td>  
Deleted: </tr>  
Deleted: </tbody>  
Deleted: </table>  
Deleted: </div>  
Deleted: <div class="line alt2">  
Deleted: <table>  
Deleted: <tbody style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <tr style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <td class="number">  
Deleted: <code style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px 0.3em 0px 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;text-align: right !important;float: none !important;height: auto !important;width: 2.7em !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">30</code>  
Deleted: </td>  
Deleted: <td class="content">  
Deleted: <code class="keyword" >TRUNCATE</code>&nbsp;<code class="keyword" >TABLE</code>&nbsp;<code class="plain" style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">`catalog_ product_super_ attribute_pricing`;</code>  
Deleted: </td>  
Deleted: </tr>  
Deleted: </tbody>  
Deleted: </table>  
Deleted: </div>  
Deleted: <div class="line alt1" style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important">  
Deleted: <table>  
Deleted: <tbody style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <tr style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <td class="number">  
Deleted: <code style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px 0.3em 0px 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;text-align: right !important;float: none !important;height: auto !important;width: 2.7em !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">31</code>  
Deleted: </td>  
Deleted: <td class="content">  
Deleted: <code class="keyword" >TRUNCATE</code>&nbsp;<code class="keyword" >TABLE</code>&nbsp;<code class="plain" style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">`catalog_ product_super_ attribute`;</code>  
Deleted: </td>  
Deleted: </tr>  
Deleted: </tbody>  
Deleted: </table>  
Deleted: </div>  
Deleted: <div class="line alt2">  
Deleted: <table>  
Deleted: <tbody style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <tr style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <td class="number">  
Deleted: <code style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px 0.3em 0px 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;text-align: right !important;float: none !important;height: auto !important;width: 2.7em !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">32</code>  
  Added: TRUNCATE TABLE `catalog_product_ entity_text`;<br />
  Added: TRUNCATE TABLE `catalog_product_ entity_tier_price`;<br />
  Added: TRUNCATE TABLE `catalog_product_ entity_varchar`;<br />
  Added: TRUNCATE TABLE `catalog_product_flat_1`;<br />
  Added: TRUNCATE TABLE `catalog_product_link`;<br />
  Added: TRUNCATE TABLE `catalog_product_ link_attribute_ decimal`;<br />
  Added: TRUNCATE TABLE `catalog_product_ link_attribute_int`;<br />
  Added: TRUNCATE TABLE `catalog_product_ link_attribute_ varchar`;<br />
  Added: TRUNCATE TABLE `catalog_product_option`;<br />
  Added: TRUNCATE TABLE `catalog_product_ option_price`;<br />
  Added: TRUNCATE TABLE `catalog_product_ option_title`;<br />
  Added: TRUNCATE TABLE `catalog_product_ option_type_price`;<br />
  Added: TRUNCATE TABLE `catalog_product_ option_type_title`;<br />
  Added: TRUNCATE TABLE `catalog_product_ option_type_value`;<br />
  Added: TRUNCATE TABLE `catalog_product_ super_attribute_label`;<br />
  Added: TRUNCATE TABLE `catalog_product_ super_attribute_ pricing`;<br />
  Added: TRUNCATE TABLE `catalog_product_ super_attribute`;<br />
  Added: TRUNCATE TABLE `catalog_product_ super_link`;<br />
  Added: TRUNCATE TABLE `catalog_product_ enabled_index`;<br />
  Added: TRUNCATE TABLE `catalog_product_ website`;<br />
  Added: TRUNCATE TABLE `catalog_category_ product_index`;
Deleted: </td>  Added: </p>
Deleted: <td class="content">  
Deleted: <code class="keyword" >TRUNCATE</code>&nbsp;<code class="keyword" >TABLE</code>&nbsp;<code class="plain" style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">`catalog_ product_super_ link`;</code>  
Deleted: </td>  
Deleted: </tr>  
Deleted: </tbody>  
Deleted: </table>  
Deleted: </div>  
Deleted: <div class="line alt1" style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important">  
Deleted: <table>  
Deleted: <tbody style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <tr style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <td class="number">  
Deleted: <code style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px 0.3em 0px 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;text-align: right !important;float: none !important;height: auto !important;width: 2.7em !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">33</code>  
Deleted: </td>  
Deleted: <td class="content">  
Deleted: <code class="keyword" >TRUNCATE</code>&nbsp;<code class="keyword" >TABLE</code>&nbsp;<code class="plain" style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">`catalog_ product_enabled_ index`;</code>  
Deleted: </td>  
Deleted: </tr>  
Deleted: </tbody>  
Deleted: </table>  
Deleted: </div>  
Deleted: <div class="line alt2">  
Deleted: <table>  
Deleted: <tbody style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <tr style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <td class="number">  
Deleted: <code style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px 0.3em 0px 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;text-align: right !important;float: none !important;height: auto !important;width: 2.7em !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">34</code>  
Deleted: </td>  
Deleted: <td class="content">  
Deleted: <code class="keyword" >TRUNCATE</code>&nbsp;<code class="keyword" >TABLE</code>&nbsp;<code class="plain" style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">`catalog_ product_website`;</code>  
Deleted: </td>  
Deleted: </tr>  
Deleted: </tbody>  
Deleted: </table>  
Deleted: </div>  
Deleted: <div class="line alt1" style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important">  
Deleted: <table>  
Deleted: <tbody style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <tr style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <td class="number">  
Deleted: <code style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px 0.3em 0px 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;text-align: right !important;float: none !important;height: auto !important;width: 2.7em !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">35</code>  
Deleted: </td>  
Deleted: <td class="content">  
Deleted: <code class="keyword" >TRUNCATE</code>&nbsp;<code class="keyword" >TABLE</code>&nbsp;<code class="plain" style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">`catalog_ category_product_ index`;</code>  
Deleted: </td>  
Deleted: </tr>  
Deleted: </tbody>  
Deleted: </table>  
Deleted: </div>  
Deleted: <div class="line alt2">  
Deleted: <table>  
Deleted: <tbody style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <tr style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <td class="number">  
Deleted: <code style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px 0.3em 0px 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;text-align: right !important;float: none !important;height: auto !important;width: 2.7em !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">36</code>  
Deleted: </td>  
Deleted: <td class="content">  
Deleted: &nbsp;  
Deleted: </td>  
Deleted: </tr>  
Deleted: </tbody>  
Deleted: </table>  
Deleted: </div>  
Deleted: <div class="line alt1" style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important">  
Deleted: <table>  
Deleted: <tbody style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <tr style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <td class="number">  
Deleted: <code style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px 0.3em 0px 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;text-align: right !important;float: none !important;height: auto !important;width: 2.7em !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">37</code>  
Deleted: </td>  
Deleted: <td class="content">  
Deleted: <code class="keyword" >TRUNCATE</code>&nbsp;<code class="keyword" >TABLE</code>&nbsp;<code class="plain" style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">`catalog_ category_product`;</code>  
Deleted: </td>  
Deleted: </tr>  
Deleted: </tbody>  
Deleted: </table>  
Deleted: </div>  
Deleted: <div class="line alt2">  
Deleted: <table>  
Deleted: <tbody style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <tr style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <td class="number">  
Deleted: <code style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px 0.3em 0px 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;text-align: right !important;float: none !important;height: auto !important;width: 2.7em !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">38</code>  
Deleted: </td>  
Deleted: <td class="content">  
Deleted: &nbsp;  
Deleted: </td>  
Deleted: </tr>  
Deleted: </tbody>  
Deleted: </table>  
Deleted: </div>  
Deleted: <div class="line alt1" style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important">  
Deleted: <table>  
Deleted: <tbody style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <tr style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <td class="number">  
Deleted: <code style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px 0.3em 0px 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;text-align: right !important;float: none !important;height: auto !important;width: 2.7em !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">39</code>  
Deleted: </td>  
Deleted: <td class="content">  
Deleted: <code class="keyword" >TRUNCATE</code>&nbsp;<code class="keyword" >TABLE</code>&nbsp;<code class="plain" style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">`catalog_ product_entity`;</code>  
Deleted: </td>  
Deleted: </tr>  
Deleted: </tbody>  
Deleted: </table>  
Deleted: </div>  
Deleted: <div class="line alt2">  
Deleted: <table>  
Deleted: <tbody style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <tr style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <td class="number">  
Deleted: <code style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px 0.3em 0px 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;text-align: right !important;float: none !important;height: auto !important;width: 2.7em !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">40</code>  
Deleted: </td>  
Deleted: <td class="content">  
Deleted: <code class="keyword" >truncate</code>&nbsp;<code class="keyword" >table</code>&nbsp;<code class="plain" style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">`catalog_ product_relation`;</code>  
Deleted: </td>  
Deleted: </tr>  
Deleted: </tbody>  
Deleted: </table>  
Deleted: </div>  
Deleted: <div class="line alt1" style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important">  
Deleted: <table>  
Deleted: <tbody style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <tr style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <td class="number">  
Deleted: <code style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px 0.3em 0px 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;text-align: right !important;float: none !important;height: auto !important;width: 2.7em !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">41</code>  
Deleted: </td>  
Deleted: <td class="content">  
Deleted: &nbsp;  
Deleted: </td>  
Deleted: </tr>  
Deleted: </tbody>  
Deleted: </table>  
Deleted: </div>  
Deleted: <div class="line alt2">  
Deleted: <table>  
Deleted: <tbody style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <tr style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <td class="number">  
Deleted: <code style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px 0.3em 0px 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;text-align: right !important;float: none !important;height: auto !important;width: 2.7em !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">42</code>  
Deleted: </td>  
Deleted: <td class="content">  
Deleted: <code class="keyword" >TRUNCATE</code>&nbsp;<code class="keyword" >TABLE</code>&nbsp;<code class="plain" style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">`cataloginventory_ stock_item`;</code>  
Deleted: </td>  
Deleted: </tr>  
Deleted: </tbody>  
Deleted: </table>  
Deleted: </div>  
Deleted: <div class="line alt1" style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important">  
Deleted: <table>  
Deleted: <tbody style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <tr style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <td class="number">  
Deleted: <code style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px 0.3em 0px 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;text-align: right !important;float: none !important;height: auto !important;width: 2.7em !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">43</code>  
Deleted: </td>  
Deleted: <td class="content">  
Deleted: <code class="keyword" >TRUNCATE</code>&nbsp;<code class="keyword" >TABLE</code>&nbsp;<code class="plain" style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">`cataloginventory_ stock_status`;</code>  
Deleted: </td>  
Deleted: </tr>  
Deleted: </tbody>  
Deleted: </table>  
Deleted: </div>  
Deleted: <div class="line alt2">  
Deleted: <table>  
Deleted: <tbody style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <tr style="border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;font-size: 1em !important;direction: ltr !important;background: none !important">  
Deleted: <td class="number">  
Deleted: <code style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px 0.3em 0px 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;text-align: right !important;float: none !important;height: auto !important;width: 2.7em !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">44</code>  
Deleted: </td>  
Deleted: <td class="content">  
Deleted: <code class="keyword" >SET</code>&nbsp;<code class="plain" style="font-size: 13px;border: 0px !important;margin: 0px !important;padding: 0px !important;vertical-align: baseline !important;font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important;float: none !important;height: auto !important;width: auto !important;line-height: 1.1em !important;direction: ltr !important;background: none !important">FOREIGN_KEY_CHECKS = 1;</code>  
Deleted: </td>  
Deleted: </tr>  
Deleted: </tbody>  
Deleted: </table>  
Deleted: </div>  
Deleted: </div>  
Deleted: </div>  
Deleted: </div>  
Deleted: <div class="entry-utility">  
Deleted: &nbsp;  
  Added: <p>
  Added: TRUNCATE TABLE `catalog_category_product`;
  Added: </p>
  Added: <p>
  Added: TRUNCATE TABLE `catalog_product_entity`;<br />
  Added: TRUNCATE TABLE `catalog_product_relation`;
  Added: </p>
  Added: <p>
  Added: TRUNCATE TABLE `cataloginventory_ stock_item`;<br />
  Added: TRUNCATE TABLE `cataloginventory_ stock_status`;<br />
  Added: SET FOREIGN_KEY_CHECKS = 1;
  Added: </p>
Unchanged: </div> Unchanged: </div>

Note: Spaces may be added to comparison text to allow better line wrapping.

No comments yet.

Leave a Reply