CREATE TABLE `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,
            `link` longtext NOT NULL,
            `tracker` varchar(5) NOT NULL default 'N',
            `mobile` varchar(5) NOT NULL default 'N',
            `responsive` varchar(5) NOT NULL default 'N',
            `type` varchar(10) NOT NULL default '0',
            `weight` int(3) NOT NULL default '6',
            `sortorder` int(5) NOT NULL default '0',
            `budget` double NOT NULL default '0',
            `crate` double NOT NULL default '0',
            `irate` double NOT NULL default '0',
            `cities` text NOT NULL,
            `countries` text NOT NULL,
            PRIMARY KEY  (`id`)
            );

CREATE TABLE `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',
            `sortorder` int(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',
            `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',
            PRIMARY KEY  (`id`)
            );

CREATE TABLE `wp_adrotate_linkmeta` (
            `id` mediumint(8) unsigned NOT NULL auto_increment,
            `ad` int(5) unsigned NOT NULL default '0',
            `group` int(5) unsigned NOT NULL default '0',
            `user` int(5) unsigned NOT NULL default '0',
            `schedule` int(5) unsigned NOT NULL default '0',
            PRIMARY KEY  (`id`)
            );

CREATE TABLE `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` varchar(5) NOT NULL default 'N',
            `dayimpressions` int(15) unsigned NOT NULL default '0',
            PRIMARY KEY  (`id`),
                KEY `starttime` (`starttime`)
            );

CREATE TABLE `wp_adrotate_stats` (
            `id` bigint(9) unsigned NOT NULL auto_increment,
            `ad` int(5) unsigned NOT NULL default '0',
            `group` int(5) unsigned NOT NULL default '0',
            `thetime` int(15) unsigned NOT NULL default '0',
            `clicks` int(15) unsigned NOT NULL default '0',
            `impressions` int(15) unsigned NOT NULL default '0',
            PRIMARY KEY  (`id`),
            INDEX `ad` (`ad`),
            INDEX `thetime` (`thetime`)
            );

CREATE TABLE `wp_adrotate_tracker` (
            `id` bigint(9) unsigned NOT NULL auto_increment,
            `ipaddress` varchar(15) NOT NULL default '0',
            `timer` int(15) unsigned NOT NULL default '0',
            `bannerid` int(15) unsigned NOT NULL default '0',
            `stat` char(1) NOT NULL default 'c',
            `useragent` mediumtext NOT NULL,
            `country` text NOT NULL,
            `city` text NOT NULL,
            PRIMARY KEY  (`id`),
                KEY `ipaddress` (`ipaddress`),
                KEY `timer` (`timer`)
            );