wp_adrotate_groups
StaticStores adrotate groups data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | mediumint(8) unsigned | NO |
| name | varchar(255) | NO |
| modus | tinyint(1) | NO |
| fallback | varchar(5) | NO |
| cat | longtext | NO |
| cat_loc | tinyint(1) | NO |
| cat_par | tinyint(2) | NO |
| page | longtext | NO |
| page_loc | tinyint(1) | NO |
| page_par | tinyint(2) | NO |
| woo_cat | longtext | NO |
| woo_loc | tinyint(1) | NO |
| bbpress | longtext | NO |
| bbpress_loc | tinyint(1) | NO |
| mobile | tinyint(1) | NO |
| geo | tinyint(1) | NO |
| wrapper_before | longtext | NO |
| wrapper_after | longtext | NO |
| align | tinyint(1) | NO |
| gridrows | int(3) | NO |
| gridcolumns | int(3) | NO |
| admargin | int(2) | NO |
| admargin_bottom | int(2) | NO |
| admargin_left | int(2) | NO |
| admargin_right | int(2) | NO |
| adwidth | varchar(6) | NO |
| adheight | varchar(6) | NO |
| adspeed | int(5) | NO |
| repeat_impressions | char(1) | NO |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS `wp_adrotate_groups` ( `id` mediumint(8) unsigned NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `modus` tinyint(1) NOT NULL default '0', `fallback` varchar(5) NOT NULL default '0', `cat` longtext NOT NULL, `cat_loc` tinyint(1) NOT NULL default '0', `cat_par` tinyint(2) NOT NULL default '0', `page` longtext NOT NULL, `page_loc` tinyint(1) NOT NULL default '0', `page_par` tinyint(2) NOT NULL default '0', `woo_cat` longtext NOT NULL, `woo_loc` tinyint(1) NOT NULL default '0', `bbpress` longtext NOT NULL, `bbpress_loc` tinyint(1) NOT NULL default '0', `mobile` tinyint(1) NOT NULL default '0', `geo` tinyint(1) NOT NULL default '0', `wrapper_before` longtext NOT NULL, `wrapper_after` longtext NOT NULL, `align` tinyint(1) NOT NULL default '0', `gridrows` int(3) NOT NULL DEFAULT '2', `gridcolumns` int(3) NOT NULL DEFAULT '2', `admargin` int(2) NOT NULL DEFAULT '0', `admargin_bottom` int(2) NOT NULL DEFAULT '0', `admargin_left` int(2) NOT NULL DEFAULT '0', `admargin_right` int(2) NOT NULL DEFAULT '0', `adwidth` varchar(6) NOT NULL DEFAULT '125', `adheight` varchar(6) NOT NULL DEFAULT '125', `adspeed` int(5) NOT NULL DEFAULT '6000', `repeat_impressions` char(1) NOT NULL DEFAULT 'Y', 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_groups`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from AdRotate Banner Manager