wp_adrotate
StaticStores adrotate data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | mediumint(8) unsigned | NO |
| title | varchar(255) | NO |
| bannercode | longtext | NO |
| thetime | int(15) | NO |
| updated | int(15) | NO |
| author | varchar(60) | NO |
| imagetype | varchar(10) | NO |
| image | varchar(255) | NO |
| tracker | char(1) | NO |
| show_everyone | char(1) | NO |
| desktop | char(1) | NO |
| mobile | char(1) | NO |
| tablet | char(1) | NO |
| os_ios | char(1) | NO |
| os_android | char(1) | NO |
| type | varchar(10) | NO |
| weight | int(3) | NO |
| autodelete | char(1) | NO |
| autodisable | char(1) | NO |
| budget | double | NO |
| crate | double | NO |
| irate | double | NO |
| state_req | char(1) | NO |
| cities | text | NO |
| states | text | NO |
| countries | text | NO |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS `wp_adrotate` ( `id` mediumint(8) unsigned NOT NULL auto_increment, `title` varchar(255) NOT NULL DEFAULT '', `bannercode` longtext NOT NULL, `thetime` int(15) NOT NULL default '0', `updated` int(15) NOT NULL, `author` varchar(60) NOT NULL default '', `imagetype` varchar(10) NOT NULL, `image` varchar(255) NOT NULL, `tracker` char(1) NOT NULL default 'N', `show_everyone` char(1) NOT NULL default 'Y', `desktop` char(1) NOT NULL default 'Y', `mobile` char(1) NOT NULL default 'Y', `tablet` char(1) NOT NULL default 'Y', `os_ios` char(1) NOT NULL default 'Y', `os_android` char(1) NOT NULL default 'Y', `type` varchar(10) NOT NULL default '0', `weight` int(3) NOT NULL default '6', `autodelete` char(1) NOT NULL default 'N', `autodisable` char(1) NOT NULL default 'N', `budget` double NOT NULL default '0', `crate` double NOT NULL default '0', `irate` double NOT NULL default '0', `state_req` char(1) NOT NULL default 'N', `cities` text NOT NULL, `states` text NOT NULL, `countries` text NOT NULL, PRIMARY KEY (`id`) ) ".$charset_collate.$engine.";");
Safe to delete?
If you have uninstalled AdRotate Banner Manager, 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_adrotate`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from AdRotate Banner Manager