INSERT INTO `phpads_userlog` (`userlogid`, `timestamp`, `usertype`, `userid`, `action`, `object`, `details`) VALUES
(206239, 1346310192, 2, 0, 10, 0, 0x[BLOB]),
(206240, 1346313771, 2, 0, 10, 0, 0x[BLOB]),
(206241, 1346317370, 2, 0, 10, 0, 0x[BLOB]),
(206242, 1346320971, 2, 0, 10, 0, 0x[BLOB]),
(206237, 1346302969, 2, 0, 10, 0, 0x[BLOB]),
(206238, 1346306570, 2, 0, 10, 0, 0x[BLOB]),
(206236, 1346299370, 2, 0, 10, 0, 0x[BLOB]),
(206235, 1346295770, 2, 0, 10, 0, 0x[BLOB]),
(206234, 1346292171, 2, 0, 10, 0, 0x[BLOB]),
(206232, 1346284970, 2, 0, 10, 0, 0x[BLOB]),
(206233, 1346288570, 2, 0, 10, 0, 0x[BLOB]),
(206229, 1346277771, 2, 0, 30, 0, 0x5461626c65207068706164735f757365726c6f673a2064656c6574656420323520726f77730a),
(206230, 1346277772, 2, 0, 10, 0, 0x[BLOB]),
(206231, 1346281370, 2, 0, 10, 0, 0x[BLOB]);
INSERT INTO `phpads_userlog` (`userlogid`, `timestamp`, `usertype`, `userid`, `action`, `object`, `details`) VALUES
(206224, 1346259771, 2, 0, 10, 0, 0x[BLOB]),
(206109, 1345856576, 2, 0, 10, 0, 0x[BLOB]),
(206064, 1345701779, 2, 0, 10, 0, 0x[BLOB]),
(206065, 1345705382, 2, 0, 10, 0, 0x[BLOB]),
(206066, 1345708979, 2, 0, 10, 0, 0x[BLOB]),
(206067, 1345712579, 2, 0, 10, 0, 0x[BLOB]),
(206068, 1345716191, 2, 0, 10, 0, 0x[BLOB]),
(206069, 1345719780, 2, 0, 10, 0, 0x[BLOB]),
(206070, 1345723379, 2, 0, 10, 0, 0x[BLOB]),
(206071, 1345726979, 2, 0, 10, 0, 0x[BLOB]),
(206072, 1345730579, 2, 0, 10, 0, 0x[BLOB]),
(206005, 1345500186, 2, 0, 30, 0, 0x5461626c65207068706164735f757365726c6f673a2064656c6574656420323920726f77730a),
(206006, 1345500187, 2, 0, 10, 0, 0x[BLOB]),
(206076, 1345744979, 2, 0, 10, 0, 0x[BLOB]);
INSERT INTO `phpads_userlog` (`userlogid`, `timestamp`, `usertype`, `userid`, `action`, `object`, `details`) VALUES
(206059, 1345683779, 2, 0, 10, 0, 0x[BLOB]),
(206060, 1345687379, 2, 0, 10, 0, 0x[BLOB]),
(206061, 1345690979, 2, 0, 10, 0, 0x[BLOB]),
(206062, 1345694579, 2, 0, 10, 0, 0x[BLOB]),
(206063, 1345698179, 2, 0, 10, 0, 0x[BLOB]),
(206055, 1345672980, 2, 0, 30, 0, 0x5461626c65207068706164735f757365726c6f673a2064656c6574656420323520726f77730a),
(206056, 1345672981, 2, 0, 10, 0, 0x[BLOB]),
(206036, 1345604582, 2, 0, 10, 0, 0x[BLOB]),
(206058, 1345680179, 2, 0, 10, 0, 0x[BLOB]),
(206057, 1345676580, 2, 0, 10, 0, 0x[BLOB]),
(206309, 1346554966, 2, 0, 10, 0, 0x[BLOB]),
(206256, 1346367769, 2, 0, 10, 0, 0x[BLOB]),
(206114, 1345874577, 2, 0, 10, 0, 0x[BLOB]),
(206108, 1345852977, 2, 0, 10, 0, 0x[BLOB]);
INSERT INTO `phpads_userlog` (`userlogid`, `timestamp`, `usertype`, `userid`, `action`, `object`, `details`) VALUES
(206167, 1346076175, 2, 0, 10, 0, 0x[BLOB]),
(206164, 1346065374, 2, 0, 10, 0, 0x[BLOB]),
(206166, 1346072575, 2, 0, 10, 0, 0x[BLOB]),
(206165, 1346068974, 2, 0, 10, 0, 0x[BLOB]),
(206125, 1345932179, 2, 0, 30, 0, 0x5461626c65207068706164735f757365726c6f673a2064656c6574656420323520726f77730a),
(206126, 1345932179, 2, 0, 10, 0, 0x[BLOB]),
(206163, 1346061775, 2, 0, 10, 0, 0x[BLOB]),
(206162, 1346058174, 2, 0, 10, 0, 0x[BLOB]),
(206161, 1346054575, 2, 0, 10, 0, 0x[BLOB]),
(206160, 1346050987, 2, 0, 10, 0, 0x[BLOB]),
(206159, 1346047374, 2, 0, 10, 0, 0x[BLOB]),
(206153, 1346025774, 2, 0, 10, 0, 0x[BLOB]),
(206154, 1346029374, 2, 0, 10, 0, 0x[BLOB]),
(206158, 1346043775, 2, 0, 10, 0, 0x[BLOB]);
INSERT INTO `phpads_userlog` (`userlogid`, `timestamp`, `usertype`, `userid`, `action`, `object`, `details`) VALUES
(206157, 1346040174, 2, 0, 10, 0, 0x[BLOB]),
(206156, 1346036574, 2, 0, 10, 0, 0x[BLOB]),
(206155, 1346032975, 2, 0, 10, 0, 0x[BLOB]),
(206150, 1346018575, 2, 0, 30, 0, 0x5461626c65207068706164735f757365726c6f673a2064656c6574656420323520726f77730a),
(206151, 1346018576, 2, 0, 10, 0, 0x[BLOB]),
(206152, 1346022175, 2, 0, 10, 0, 0x[BLOB]),
(206091, 1345795379, 2, 0, 10, 0, 0x[BLOB]),
(206080, 1345759379, 2, 0, 30, 0, 0x5461626c65207068706164735f757365726c6f673a2064656c6574656420323420726f77730a),
(206081, 1345759380, 2, 0, 10, 0, 0x[BLOB]),
(206082, 1345762977, 2, 0, 10, 0, 0x[BLOB]);

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

--
-- Struktura tabeli dla  `phpads_zones`
--

CREATE TABLE IF NOT EXISTS `phpads_zones` (
  `zoneid` mediumint(9) NOT NULL auto_increment,
  `affiliateid` mediumint(9) default NULL,
  `zonename` varchar(245) NOT NULL default '',
  `description` varchar(255) NOT NULL default '',
  `delivery` smallint(6) NOT NULL default '0',
  `zonetype` smallint(6) NOT NULL default '0',
  `what` blob NOT NULL,
  `width` smallint(6) NOT NULL default '0',
  `height` smallint(6) NOT NULL default '0',
  `chain` blob NOT NULL,
  `prepend` blob NOT NULL,
  `append` blob NOT NULL,
  `appendtype` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`zoneid`),
  KEY `zonenameid` (`zonename`,`zoneid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin2 AUTO_INCREMENT=17 ;

--
-- Zrzut danych tabeli `phpads_zones`
--

INSERT INTO `phpads_zones` (`zoneid`, `affiliateid`, `zonename`, `description`, `delivery`, `zonetype`, `what`, `width`, `height`, `chain`, `prepend`, `append`, `appendtype`) VALUES
(1, 1, 'hit_1x1', 'hit_1x1', 0, 3, 0x636c69656e7469643a322c636c69656e7469643a332c636c69656e7469643a31362c636c69656e7469643a33332c636c69656e7469643a34382c636c69656e7469643a34392c636c69656e7469643a3530, 1, 1, '', '', '', 0),
(2, 1, 'test_1x1', 'test_1x1', 0, 3, '', 1, 1, '', '', '', 0),
(3, 2, 'sg_750x100', 'sg_750x100', 0, 3, 0x636c69656e7469643a352c636c69656e7469643a372c636c69656e7469643a392c636c69656e7469643a33302c636c69656e7469643a33322c636c69656e7469643a33392c636c69656e7469643a34302c636c69656e7469643a3436, 750, 100, '', '', '', 0),
(4, 2, 'sg_120x600', 'sg_120x600', 0, 3, 0x636c69656e7469643a362c636c69656e7469643a382c636c69656e7469643a3334, 120, 600, '', '', '', 0),
(5, 3, 'Gibo_streaming', '', 0, 3, 0x636c69656e7469643a3131, 1, 1, '', '', '', 0),
(6, 3, '750x100_SG', '750x10_SG', 0, 3, 0x[BLOB], 750, 100, '', '', '', 0),
(7, 3, '160x600_SG', '160x600_SG', 0, 3, 0x636c69656e7469643a31332c636c69656e7469643a31352c636c69656e7469643a31382c636c69656e7469643a3234, 160, 600, '', '', '', 0),
(8, 3, '750x100_ROS', '750x100_ROS', 0, 3, 0x[BLOB], 750, 100, '', '', '', 0),
(9, 3, '160x600_ROS', '160x600_ROS', 0, 3, 0x636c69656e7469643a31332c636c69656e7469643a31352c636c69656e7469643a31382c636c69656e7469643a3234, 160, 600, '', '', '', 0),
(10, 4, 'Okno_oddania_glosu_750x100', 'Okno_oddania_glosu_750x100', 0, 3, 0x636c69656e7469643a3232, 750, 100, '', '', '', 0),
(11, 5, '750x100_SG', '750x100_SG', 0, 3, 0x636c69656e7469643a33302c636c69656e7469643a33322c636c69656e7469643a33352c636c69656e7469643a33332c636c69656e7469643a33372c636c69656e7469643a33392c636c69656e7469643a34302c636c69656e7469643a3434, 750, 100, '', '', '', 0),
(12, 5, '160x600_SG', '', 0, 3, 0x636c69656e7469643a3331, 160, 600, '', '', '', 0),
(13, 5, '750x100 ROS', '', 0, 3, 0x636c69656e7469643a33302c636c69656e7469643a33322c636c69656e7469643a33352c636c69656e7469643a33332c636c69656e7469643a33372c636c69656e7469643a33392c636c69656e7469643a34302c636c69656e7469643a3434, 750, 100, '', '', '', 0),
(14, 5, '160x600_ROS', '', 0, 3, 0x636c69656e7469643a3331, 160, 600, '', '', '', 0),
(15, 4, '750x100 ROS', '750x100 ROS', 0, 3, 0x636c69656e7469643a33302c636c69656e7469643a33352c636c69656e7469643a33362c636c69656e7469643a3430, 750, 100, '', '', '', 0),
(16, 5, '750x100 Forum', '750x100 Forum', 0, 3, 0x636c69656e7469643a33302c636c69656e7469643a33352c636c69656e7469643a33372c636c69656e7469643a33392c636c69656e7469643a34302c636c69656e7469643a3434, -1, -1, '', '', '', 0);

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

--
-- Struktura tabeli dla  `phplist_listattr_bwheredoyo`
--

CREATE TABLE IF NOT EXISTS `phplist_listattr_bwheredoyo` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `listorder` int(11) default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

--
-- Zrzut danych tabeli `phplist_listattr_bwheredoyo`
--

INSERT INTO `phplist_listattr_bwheredoyo` (`id`, `name`, `listorder`) VALUES
(1, 'At home', 0),
(2, 'At work', 0),
(3, 'At school', 0),
(4, 'At the local library', 0),
(5, 'At a friend&rsquo;s home', 0),
(6, 'At the local postoffice', 0),
(7, 'At a cybercafe', 0);

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

--
-- Struktura tabeli dla  `pmnl_archives`
--

CREATE TABLE IF NOT EXISTS `pmnl_archives` (
  `id` int(65) NOT NULL default '0',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `type` text NOT NULL,
  `subject` text NOT NULL,
  `message` text NOT NULL,
  `list_id` int(11) NOT NULL default '0',
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Zrzut danych tabeli `pmnl_archives`
--

INSERT INTO `pmnl_archives` (`id`, `date`, `type`, `subject`, `message`, `list_id`) VALUES
(1, '0000-00-00 00:00:00', 'html', 'Testowa wiadomość', '<strong>Witaj</strong>\r\n<br />\r\nTo jest testowa wysyłka newslettera śćłóśą\r\n<a href="http://www.google.com">google</a>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\nWiadomość wysłana zgodnie z regulaminem DarmoweLiczniki.pl', 1);

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

--
-- Struktura tabeli dla  `pmnl_listsconfig`
--

CREATE TABLE IF NOT EXISTS `pmnl_listsconfig` (
  `list_id` tinyint(4) NOT NULL auto_increment,
  `newsletter_name` varchar(255) NOT NULL default '',
  `from_addr` varchar(255) NOT NULL default '',
  `from_name` varchar(255) NOT NULL default '',
  `subject` varchar(255) NOT NULL default '',
  `header` text NOT NULL,
  `footer` text NOT NULL,
  `subscription_subject` varchar(255) NOT NULL default '',
  `subscription_body` text NOT NULL,
  `welcome_subject` varchar(255) NOT NULL default '',
  `welcome_body` text NOT NULL,
  `quit_subject` varchar(255) NOT NULL default '',
  `quit_body` text NOT NULL,
  PRIMARY KEY  (`list_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Zrzut danych tabeli `pmnl_listsconfig`
--

INSERT INTO `pmnl_listsconfig` (`list_id`, `newsletter_name`, `from_addr`, `from_name`, `subject`, `header`, `footer`, `subscription_subject`, `subscription_body`, `welcome_subject`, `welcome_body`, `quit_subject`, `quit_body`) VALUES
(1, 'Testowy ', 'mailing@it-poland.com', 'IT-Poland.com', 'Testowa wiadomość', '', 'Wiadomość wysłana zgodnie z regulaminem DarmoweLiczniki.pl', 'Please confirm your subscription', 'Someone, probably you, request a subscription to this newsletter, please follow the instructions bellow', 'Welcome to this newsletter', 'Welcome to this newsletter !', 'Please confirm your unsubscription', 'Someone, probably you, request unsubscription from this newsletter, please follow the instructions bellow');

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

--
-- Struktura tabeli dla  `pmnl_sub`
--

CREATE TABLE IF NOT EXISTS `pmnl_sub` (
  `email` varchar(255) NOT NULL default '',
  `list_id` varchar(64) NOT NULL default '',
  KEY `list_id` (`list_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

