wp_adrotate_schedule
StaticStores adrotate schedule data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | int(8) unsigned | NO |
| name | varchar(255) | NO |
| starttime | int(15) unsigned | NO |
| stoptime | int(15) unsigned | NO |
| maxclicks | int(15) unsigned | NO |
| maximpressions | int(15) unsigned | NO |
| spread | char(1) | NO |
| spread_all | char(1) | NO |
| daystarttime | char(4) | NO |
| daystoptime | char(4) | NO |
| day_mon | char(1) | NO |
| day_tue | char(1) | NO |
| day_wed | char(1) | NO |
| day_thu | char(1) | NO |
| day_fri | char(1) | NO |
| day_sat | char(1) | NO |
| day_sun | char(1) | NO |
| autodelete | char(1) | NO |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS `wp_adrotate_schedule` ( `id` int(8) unsigned NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `starttime` int(15) unsigned NOT NULL default '0', `stoptime` int(15) unsigned NOT NULL default '0', `maxclicks` int(15) unsigned NOT NULL default '0', `maximpressions` int(15) unsigned NOT NULL default '0', `spread` char(1) NOT NULL default 'N', `spread_all` char(1) NOT NULL default 'N', `daystarttime` char(4) NOT NULL default '0000', `daystoptime` char(4) NOT NULL default '0000', `day_mon` char(1) NOT NULL default 'Y', `day_tue` char(1) NOT NULL default 'Y', `day_wed` char(1) NOT NULL default 'Y', `day_thu` char(1) NOT NULL default 'Y', `day_fri` char(1) NOT NULL default 'Y', `day_sat` char(1) NOT NULL default 'Y', `day_sun` char(1) NOT NULL default 'Y', `autodelete` char(1) NOT NULL default 'N', PRIMARY KEY (`id`), KEY `starttime` (`starttime`) ) ".$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_schedule`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from AdRotate Banner Manager