CREATE TABLE IF NOT EXISTS `phpads_banners` (
  `bannerid` mediumint(9) NOT NULL auto_increment,
  `clientid` mediumint(9) NOT NULL default '0',
  `active` enum('t','f') NOT NULL default 't',
  `priority` int(11) NOT NULL default '0',
  `contenttype` enum('gif','jpeg','png','html','swf','dcr','rpm','mov','txt') NOT NULL default 'gif',
  `pluginversion` mediumint(9) NOT NULL default '0',
  `storagetype` enum('sql','web','url','html','network','txt') NOT NULL default 'sql',
  `filename` varchar(255) NOT NULL default '',
  `imageurl` varchar(255) NOT NULL default '',
  `htmltemplate` blob NOT NULL,
  `htmlcache` blob NOT NULL,
  `width` smallint(6) NOT NULL default '0',
  `height` smallint(6) NOT NULL default '0',
  `weight` tinyint(4) NOT NULL default '1',
  `seq` tinyint(4) NOT NULL default '0',
  `target` varchar(24) NOT NULL default '',
  `url` varchar(255) NOT NULL default '',
  `alt` varchar(255) NOT NULL default '',
  `status` varchar(255) NOT NULL default '',
  `keyword` varchar(255) NOT NULL default '',
  `bannertext` blob NOT NULL,
  `description` varchar(255) NOT NULL default '',
  `autohtml` enum('t','f') NOT NULL default 't',
  `block` int(11) NOT NULL default '0',
  `capping` int(11) NOT NULL default '0',
  `compiledlimitation` blob NOT NULL,
  `append` blob NOT NULL,
  `appendtype` tinyint(4) NOT NULL default '0',
  `bannertype` tinyint(4) NOT NULL default '0',
  `transparent` enum('t','f') NOT NULL default 'f',
  PRIMARY KEY  (`bannerid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin2 AUTO_INCREMENT=54 ;

--
-- Zrzut danych tabeli `phpads_banners`
--

INSERT INTO `phpads_banners` (`bannerid`, `clientid`, `active`, `priority`, `contenttype`, `pluginversion`, `storagetype`, `filename`, `imageurl`, `htmltemplate`, `htmlcache`, `width`, `height`, `weight`, `seq`, `target`, `url`, `alt`, `status`, `keyword`, `bannertext`, `description`, `autohtml`, `block`, `capping`, `compiledlimitation`, `append`, `appendtype`, `bannertype`, `transparent`) VALUES
(48, 45, 't', 0, 'html', 0, 'html', '', '', 0x[BLOB], 0x[BLOB], 750, 100, 1, 0, '', 'https://form.mbank.com.pl/wnioski/eK/index.html?option=mkiosk_mpok_MAZO_14&sprzedawca=aw11773', '', '', 'mkiosk', '', 'mkiosk', 'f', 0, 0, 0x74727565, '', 0, 0, 'f'),
(49, 46, 't', 0, 'html', 0, 'html', '', '', 0x[BLOB], 0x[BLOB], 750, 100, 1, 0, '', 'https://form.mbank.com.pl/wnioski/eK/index.html?option=mkiosk_mpok_MAZO_14&sprzedawca=aw11773', '', '', 'mkiosk', '', 'mkiosk', 'f', 0, 0, 0x74727565, '', 0, 0, 'f'),
(2, 3, 'f', 0, 'html', 0, 'html', '', '', 0x[BLOB], 0x[BLOB], 1, 1, 1, 0, '', '', '', '', 'google_1x1', '', 'google_1x1', 'f', 604800, 0, 0x74727565, '', 0, 0, 'f'),
(3, 5, 't', 1, 'html', 0, 'html', '', '', 0x[BLOB], 0x[BLOB], 750, 100, 1, 0, '', '', '', '', 'google web-rynek', '', 'google web-rynek', 'f', 0, 0, 0x74727565, '', 0, 0, 'f'),
(29, 30, 't', 1, 'swf', 5, 'sql', '750x100_gibo.swf', '{url_prefix}/adimage.php?filename=750x100_gibo.swf&amp;contenttype=swf', 0x[BLOB], 0x[BLOB], 750, 100, 1, 0, '', 'http://www.gibo.pl', '', '', '750x100 Gibo', '', '750x100 Gibo', 't', 900, 0, 0x74727565, '', 0, 0, 'f'),
(4, 6, 'f', 0, 'html', 0, 'html', '', '', 0x[BLOB], 0x[BLOB], 120, 600, 1, 0, '', '', '', '', 'google_160x600', '', 'google_160x600', 'f', 0, 0, 0x74727565, '', 0, 0, 'f'),
(51, 33, 'f', 0, 'html', 0, 'html', '', '', 0x[BLOB], 0x[BLOB], 1, 1, 1, 0, '', 'http://web-rynek.pl/Citroen_Berlingo_ogloszenie,1327.html', '', '', 'Web-Rynek_toplayer', '', 'Web-Rynek_toplayer', 'f', 86400, 0, 0x74727565, '', 0, 0, 'f'),
(37, 36, 't', 1, 'html', 0, 'html', '', '', 0x[BLOB], 0x[BLOB], 750, 100, 1, 0, '', '', '', '', 'Google 750x100 Sondy', '', 'Google 750x100 Sondy', 'f', 0, 0, 0x74727565, '', 0, 0, 'f'),
(38, 37, 't', 1, 'html', 0, 'html', '', '', 0x[BLOB], 0x[BLOB], 750, 100, 1, 0, '', '', '', '', 'Adsense 750x100', '', 'Adsense 750x100', 'f', 0, 0, 0x74727565, '', 0, 0, 'f');
INSERT INTO `phpads_banners` (`bannerid`, `clientid`, `active`, `priority`, `contenttype`, `pluginversion`, `storagetype`, `filename`, `imageurl`, `htmltemplate`, `htmlcache`, `width`, `height`, `weight`, `seq`, `target`, `url`, `alt`, `status`, `keyword`, `bannertext`, `description`, `autohtml`, `block`, `capping`, `compiledlimitation`, `append`, `appendtype`, `bannertype`, `transparent`) VALUES
(39, 39, 'f', 0, 'html', 0, 'html', '', '', 0x[BLOB], 0x[BLOB], 750, 100, 1, 0, '', '', '', '', 'Afilo - Polifreshya - bl+br v1', '', 'Afilo - Polifreshya - bl+br v1', 'f', 0, 1, 0x74727565, '', 0, 0, 'f'),
(30, 31, 't', 3, 'html', 0, 'html', '', '', 0x[BLOB], 0x[BLOB], 160, 600, 1, 0, '', '', '', '', 'Adsense 120x600', '', 'Adsense 120x600', 'f', 0, 0, 0x74727565, '', 0, 0, 'f'),
(9, 12, 't', 1, 'html', 0, 'html', '', '', 0x[BLOB], 0x[BLOB], 750, 100, 1, 0, '', '', '', '', 'Google_750x100', '', 'Google_750x100', 'f', 0, 0, 0x74727565, '', 0, 0, 'f'),
(10, 13, 't', 1, 'html', 0, 'html', '', '', 0x[BLOB], 0x[BLOB], 160, 600, 1, 0, '', '', '', '', 'Google_160x600', '', 'Google_160x600', 'f', 0, 0, 0x74727565, '', 0, 0, 'f'),
(40, 39, 'f', 0, 'html', 0, 'html', '', '', 0x[BLOB], 0x[BLOB], 750, 100, 1, 0, '', '', '', '', 'Afilo - Polifreshya - bl+br v2', '', 'Afilo - Polifreshya - bl+br v2', 'f', 0, 1, 0x74727565, '', 0, 0, 'f'),
(41, 40, 't', 0, 'html', 0, 'html', '', '', 0x[BLOB], 0x[BLOB], 750, 100, 1, 0, '', '', '', '', 'AFilo GPS24 billboard', '', 'AFilo GPS24 billboard', 'f', 0, 3, 0x74727565, '', 0, 0, 'f'),
(42, 42, 't', 0, 'html', 0, 'html', '', '', 0x[BLOB], 0x[BLOB], 750, 100, 1, 0, '', '', '', '', 'Traddoubler 750x100', '', 'Tradedoubler 750x100', 'f', 900, 0, 0x74727565, '', 0, 0, 'f'),
(44, 44, 't', 0, 'html', 0, 'html', '', '', 0x[BLOB], 0x[BLOB], 750, 100, 1, 0, '', 'https://form.mbank.com.pl/wnioski/eK/index.html?option=mkiosk_mpok_MAZO_14&sprzedawca=aw11773', '', '', 'mkiosk', '', 'mkiosk', 'f', 0, 0, 0x74727565, '', 0, 0, 'f'),
(45, 44, 't', 0, 'html', 0, 'html', '', '', 0x[BLOB], 0x[BLOB], 750, 100, 1, 0, '', 'https://form.mbank.com.pl/wnioski/kg/index.html?option=mkiosk_mpok_MAZO_14&sprzedawca=aw11773 ', '', '', 'Gotówka', '', 'Gotówka', 'f', 0, 0, 0x74727565, '', 0, 0, 'f'),
(46, 46, 't', 0, 'html', 0, 'html', '', '', 0x[BLOB], 0x[BLOB], 750, 100, 1, 0, '', 'https://form.mbank.com.pl/wnioski/kg/index.html?option=mkiosk_mpok_MAZO_14&sprzedawca=aw11773 ', '', '', 'Gotówka', '', 'Gotówka', 'f', 0, 0, 0x74727565, '', 0, 0, 'f'),
(47, 45, 't', 0, 'html', 0, 'html', '', '', 0x[BLOB], 0x[BLOB], 750, 100, 1, 0, '', 'https://form.mbank.com.pl/wnioski/kg/index.html?option=mkiosk_mpok_MAZO_14&sprzedawca=aw11773 ', '', '', 'Gotówka', '', 'Gotówka', 'f', 0, 0, 0x74727565, '', 0, 0, 'f'),
(19, 22, 'f', 0, 'html', 0, 'html', '', '', 0x3c696d67207372633d22687474703a2f2f6461726d6f7765736f6e64792e706c2f696d616765732f7078312e6769662220626f726465723d2230223e, 0x3c696d67207372633d22687474703a2f2f6461726d6f7765736f6e64792e706c2f696d616765732f7078312e6769662220626f726465723d2230223e, 750, 100, 1, 0, '', '', '', '', 'test_piksel', '', 'test_piksel', 'f', 0, 0, 0x74727565, '', 0, 0, 'f'),
(25, 22, 'f', 0, 'txt', 0, 'txt', '', '', 0x[BLOB], 0x[BLOB], 0, 0, 1, 0, '_blank', 'http://www.gibo.pl', '', 'Wejd? na Gibo.pl', 'Gibo_testowa_sondy', 0x[BLOB], 'Gibo_testowa_sondy', 't', 0, 0, 0x74727565, '', 0, 0, 'f'),
(26, 22, 't', 1, 'html', 0, 'html', '', '', 0x[BLOB], 0x[BLOB], 750, 100, 1, 0, '', '', '', '', 'Link_sponsorowany_sondy', '', 'Link_sponsorowany_sondy', 't', 0, 0, 0x74727565, '', 0, 0, 'f'),
(31, 32, 't', 1, 'jpeg', 0, 'sql', 'fin_2.jpg', '{url_prefix}/adimage.php?filename=fin_2.jpg&amp;contenttype=jpeg', 0x[BLOB], 0x[BLOB], 750, 100, 1, 0, '_blank', 'http://web-rynek.pl/Zadbaj_o_przyszlosc_swoja_i_bliskich__ogloszenie,104.html', '', '', 'Pawe? Sikorski', '', 'Pawe? Sikorski', 't', 0, 0, 0x74727565, '', 0, 0, 'f');
INSERT INTO `phpads_banners` (`bannerid`, `clientid`, `active`, `priority`, `contenttype`, `pluginversion`, `storagetype`, `filename`, `imageurl`, `htmltemplate`, `htmlcache`, `width`, `height`, `weight`, `seq`, `target`, `url`, `alt`, `status`, `keyword`, `bannertext`, `description`, `autohtml`, `block`, `capping`, `compiledlimitation`, `append`, `appendtype`, `bannertype`, `transparent`) VALUES
(32, 33, 'f', 0, 'html', 0, 'html', '', '', 0x[BLOB], 0x[BLOB], 1, 1, 1, 0, '', 'http://www.web-rynek.pl', '', '', 'Web_rynek', '', 'Web_rynek', 'f', 172800, 5, 0x74727565, '', 0, 0, 'f');
INSERT INTO `phpads_banners` (`bannerid`, `clientid`, `active`, `priority`, `contenttype`, `pluginversion`, `storagetype`, `filename`, `imageurl`, `htmltemplate`, `htmlcache`, `width`, `height`, `weight`, `seq`, `target`, `url`, `alt`, `status`, `keyword`, `bannertext`, `description`, `autohtml`, `block`, `capping`, `compiledlimitation`, `append`, `appendtype`, `bannertype`, `transparent`) VALUES
(50, 48, 'f', 0, 'html', 0, 'html', '', '', 0x[BLOB], 0x[BLOB], 1, 1, 1, 0, '', 'http://www.polki.pl/seks_zwiazki_artykul,10011514.html', '', '', 'Edipresse - Toplayer', '', 'Edipresse - Toplayer', 't', 0, 1, 0x74727565, '', 0, 0, 'f'),
(35, 35, 't', 1, 'swf', 5, 'sql', 'movie1.swf', '{url_prefix}/adimage.php?filename=movie1.swf&amp;contenttype=swf', 0x[BLOB], 0x[BLOB], 750, 100, 1, 0, '', 'http://www.web-rynek.pl', '', '', '750x100 Web-Rynek', '', '750x100 Web-Rynek', 't', 900, 0, 0x74727565, '', 0, 0, 'f'),
(52, 49, 't', 1, 'html', 0, 'html', '', '', 0x[BLOB], 0x[BLOB], 1, 1, 1, 0, '', 'http://www.gibo.pl', '', '', 'Toplayer_gibo_grudzien2008', '', 'Toplayer_gibo_grudzien2008', 't', 172800, 0, 0x74727565, '', 0, 0, 'f'),
(53, 50, 'f', 0, 'html', 0, 'html', '', '', 0x[BLOB], 0x[BLOB], 1, 1, 1, 0, '', '', '', '', 'Tymbark - Afilo', '', 'Tymbark - Afilo', 'f', 0, 1, 0x74727565, '', 0, 0, 'f');

-- --------------------------------------------------------

--
-- Struktura tabeli dla  `phpads_cache`
--

CREATE TABLE IF NOT EXISTS `phpads_cache` (
  `cacheid` varchar(255) NOT NULL default '',
  `content` blob NOT NULL,
  PRIMARY KEY  (`cacheid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2;

--
-- Zrzut danych tabeli `phpads_cache`
--

INSERT INTO `phpads_cache` (`cacheid`, `content`) VALUES
('what=zone:1', 0x[BLOB]),
('bannerid=52', 0x[BLOB]),
('what=zone:13', 0x[BLOB]),
('bannerid=31', 0x[BLOB]),
('what=zone:8', 0x[BLOB]),
('bannerid=9', 0x[BLOB]),
('what=zone:9', 0x[BLOB]),
('bannerid=10', 0x[BLOB]),
('bannerid=35', 0x[BLOB]),
('what=&clientid=0&remaining=true', 0x[BLOB]),
('bannerid=37', 0x[BLOB]);

-- --------------------------------------------------------

--
-- Struktura tabeli dla  `phpads_images`
--

CREATE TABLE IF NOT EXISTS `phpads_images` (
  `filename` varchar(128) NOT NULL default '',
  `contents` mediumblob NOT NULL,
  `t_stamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`filename`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2;

--
-- Zrzut danych tabeli `phpads_images`
--

INSERT INTO `phpads_images` (`filename`, `contents`, `t_stamp`) VALUES
('fin_2.jpg', 0x[BLOB], '2008-03-03 10:58:08');
INSERT INTO `phpads_images` (`filename`, `contents`, `t_stamp`) VALUES
('movie1.swf', 0x[BLOB], '2008-03-02 14:30:31');
INSERT INTO `phpads_images` (`filename`, `contents`, `t_stamp`) VALUES
('750x100_gibo.swf', 0x[BLOB], '2008-03-02 16:32:00');

-- --------------------------------------------------------

--
-- Struktura tabeli dla  `phpads_targetstats`
--

