wp_ktmp_product_prices

Static

Stores product records and related data.

Column Definitions

ColumnTypeNullable
🔑idINTNO
product_idINTNO
marketplace_idINTNO
priceDECIMAL(10, 2)YES
old_priceDECIMAL(10, 2)YES

CREATE TABLE Statement

CREATE TABLE IF NOT EXISTS wp_ktmp_product_prices ( id INT NOT NULL AUTO_INCREMENT, product_id INT NOT NULL, marketplace_id INT NOT NULL, price DECIMAL(10, 2), old_price DECIMAL(10, 2), PRIMARY KEY (id), INDEX idx_marketplace_id (marketplace_id), UNIQUE KEY unique_product_marketplace (product_id, marketplace_id) ) ENGINE

Safe to delete?

If you have uninstalled Keskintech Marketplaces, this table is generally safe to remove. However, always back up your database first.

Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.

How to remove this table

DROP TABLE IF EXISTS `wp_ktmp_product_prices`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from Keskintech Marketplaces