-- rewind begin page null
CREATE TABLE `wp_adrotate` (
  `id` mediumint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `bannercode` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `thetime` int NOT NULL DEFAULT '0',
  `updated` int NOT NULL,
  `author` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',
  `imagetype` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `tracker` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'N',
  `show_everyone` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'Y',
  `desktop` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'Y',
  `mobile` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'Y',
  `tablet` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'Y',
  `os_ios` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'Y',
  `os_android` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'Y',
  `os_other` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'Y',
  `type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '0',
  `weight` int NOT NULL DEFAULT '6',
  `autodelete` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci 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) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'N',
  `cities` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `states` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  `countries` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;
INSERT INTO `wp_adrotate` (`id`,`title`,`bannercode`,`thetime`,`updated`,`author`,`imagetype`,`image`,`tracker`,`show_everyone`,`desktop`,`mobile`,`tablet`,`os_ios`,`os_android`,`os_other`,`type`,`weight`,`autodelete`,`budget`,`crate`,`irate`,`state_req`,`cities`,`states`,`countries`) VALUES('1','Demo banner 468x60','&lt;a href=\\&quot;http:\\/\\/ajdg.net/landing.php?src=adrotate\\&quot;&gt;&lt;img src=\\&quot;http://ajdg.solutions/assets/banners/adrotate-468x60.jpg\\&quot; /&gt;&lt;/a&gt;','1646116565','1646116565','newsbyte','','','N','Y','Y','Y','Y','Y','Y','Y','expired','6','N','0','0','0','N','a:0:{}','a:0:{}','a:0:{}');
INSERT INTO `wp_adrotate` (`id`,`title`,`bannercode`,`thetime`,`updated`,`author`,`imagetype`,`image`,`tracker`,`show_everyone`,`desktop`,`mobile`,`tablet`,`os_ios`,`os_android`,`os_other`,`type`,`weight`,`autodelete`,`budget`,`crate`,`irate`,`state_req`,`cities`,`states`,`countries`) VALUES('2','Demo banner 728x90','&lt;a href=\\&quot;http:\\/\\/ajdg.net/landing.php?src=adrotate\\&quot;&gt;&lt;img src=\\&quot;http://ajdg.solutions/assets/banners/adrotate-728x90.jpg\\&quot; /&gt;&lt;/a&gt;','1646116565','1646116565','newsbyte','','','Y','Y','Y','Y','Y','Y','Y','Y','expired','6','N','0','0','0','N','a:0:{}','a:0:{}','a:0:{}');
INSERT INTO `wp_adrotate` (`id`,`title`,`bannercode`,`thetime`,`updated`,`author`,`imagetype`,`image`,`tracker`,`show_everyone`,`desktop`,`mobile`,`tablet`,`os_ios`,`os_android`,`os_other`,`type`,`weight`,`autodelete`,`budget`,`crate`,`irate`,`state_req`,`cities`,`states`,`countries`) VALUES('3','Ad 3','&lt;a href=\\&quot;https://www.PortRoyalOVA.com\\&quot;%asset%\\&quot; /&gt;&lt;/a&gt;','1646388573','1646736816','newsbyte','field','https://yourislandnews.com/wp-content/uploads/2022/03/Crab-Festival-2022-Web.jpg','Y','Y','Y','Y','Y','Y','Y','Y','expired','6','N','0','0','0','N','a:0:{}','a:0:{}','a:0:{}');
INSERT INTO `wp_adrotate` (`id`,`title`,`bannercode`,`thetime`,`updated`,`author`,`imagetype`,`image`,`tracker`,`show_everyone`,`desktop`,`mobile`,`tablet`,`os_ios`,`os_android`,`os_other`,`type`,`weight`,`autodelete`,`budget`,`crate`,`irate`,`state_req`,`cities`,`states`,`countries`) VALUES('4','','<a href=\"\" target=\"_blank\"><img src=\"%asset%\" /></a>','1646736883','1646736883','newsbyte','dropdown','https://yourislandnews.com/wp-content/%folder%/','N','Y','Y','Y','Y','Y','Y','Y','generator','6','N','0','0','0','N','a:0:{}','','a:0:{}');
INSERT INTO `wp_adrotate` (`id`,`title`,`bannercode`,`thetime`,`updated`,`author`,`imagetype`,`image`,`tracker`,`show_everyone`,`desktop`,`mobile`,`tablet`,`os_ios`,`os_android`,`os_other`,`type`,`weight`,`autodelete`,`budget`,`crate`,`irate`,`state_req`,`cities`,`states`,`countries`) VALUES('5','','','1660560487','1660560487','newsbyte','dropdown','','N','Y','Y','Y','Y','Y','Y','Y','empty','6','N','0','0','0','N','a:0:{}','a:0:{}','a:0:{}');
-- rewind end page null
