wp_easyadpicker_products

Static

Stores product records and related data.

Column Definitions

ColumnTypeNullable
product_idint(11)NO
advertiser_idint(11)NO
advertiser_property_idint(11)NO
titlevarchar(100)NO
searchvarchar(125)NO
materialvarchar(255)NO
linktextNO
pricedecimal(6,2)NO
price_olddecimal(6,2)NO
unique_idvarchar(35)NO
dateint(11)NO
newtinyint(1)NO

CREATE TABLE Statement

CREATE TABLE `wp_easyadpicker_products` ( `product_id` int(11) NOT NULL, `advertiser_id` int(11) NOT NULL, `advertiser_property_id` int(11) NOT NULL, `title` varchar(100) NOT NULL, `search` varchar(125) NOT NULL, `material` varchar(255) NOT NULL, `link` text NOT NULL, `price` decimal(6,2) NOT NULL, `price_old` decimal(6,2) NOT NULL, `unique_id` varchar(35) NOT NULL, `date` int(11) NOT NULL, `new` tinyint(1) NOT NULL ) ENGINE

Safe to delete?

If you have uninstalled Easy Ad Picker, 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_easyadpicker_products`;

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

Other tables from Easy Ad Picker