wp_cjenik_price_history
StaticStores cjenik price history data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) unsigned | NO |
| product_id | bigint(20) unsigned | NO |
| variation_id | bigint(20) unsigned | NO |
| item_id | bigint(20) unsigned | NO |
| price | decimal(19,4) | NO |
| regular_price | decimal(19,4) | NO |
| is_sale | tinyint(1) | NO |
| sale_name | varchar(191) | NO |
| source | varchar(20) | NO |
| valid_from | datetime | NO |
| valid_to | datetime | YES |
CREATE TABLE Statement
CREATE TABLE wp_cjenik_price_history ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, product_id bigint(20) unsigned NOT NULL, variation_id bigint(20) unsigned NOT NULL DEFAULT 0, item_id bigint(20) unsigned NOT NULL, price decimal(19,4) NOT NULL, regular_price decimal(19,4) NOT NULL, is_sale tinyint(1) NOT NULL DEFAULT 0, sale_name varchar(191) NOT NULL DEFAULT '', source varchar(20) NOT NULL DEFAULT 'observed', valid_from datetime NOT NULL, valid_to datetime DEFAULT NULL, PRIMARY KEY (id), KEY item_from (item_id,valid_from), KEY item_to (item_id,valid_to) ) $charset;" );
Safe to delete?
If you have uninstalled Meridian Digital Cjenik i Sidrena Cijena, 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_cjenik_price_history`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Meridian Digital Cjenik i Sidrena Cijena