-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `listmessenger`
--

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

--
-- Table structure for table `cdata`
--

CREATE TABLE `cdata` (
  `cdata_id` int(12) NOT NULL,
  `user_id` int(12) NOT NULL DEFAULT 0,
  `cfield_id` int(12) NOT NULL DEFAULT 0,
  `value` longtext NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `cfields`
--

CREATE TABLE `cfields` (
  `cfields_id` int(12) NOT NULL,
  `field_type` varchar(16) NOT NULL DEFAULT '',
  `field_options` longtext DEFAULT NULL,
  `field_sname` varchar(16) DEFAULT NULL,
  `field_lname` varchar(64) DEFAULT NULL,
  `field_length` int(12) DEFAULT 0,
  `field_req` int(1) NOT NULL DEFAULT 0,
  `field_order` int(3) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `confirmation`
--

CREATE TABLE `confirmation` (
  `confirm_id` int(12) NOT NULL,
  `date` bigint(64) NOT NULL DEFAULT 0,
  `action` varchar(16) NOT NULL DEFAULT '',
  `remote_ip` varchar(32) NOT NULL DEFAULT '',
  `referrer` text NOT NULL,
  `user_agent` text NOT NULL,
  `email_address` varchar(128) NOT NULL DEFAULT '',
  `firstname` varchar(32) NOT NULL DEFAULT '',
  `lastname` varchar(64) NOT NULL DEFAULT '',
  `group_ids` text NOT NULL,
  `cdata` text NOT NULL,
  `hash` varchar(64) NOT NULL DEFAULT '',
  `confirmed` int(1) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `confirmation`
--

INSERT INTO `confirmation` (`confirm_id`, `date`, `action`, `remote_ip`, `referrer`, `user_agent`, `email_address`, `firstname`, `lastname`, `group_ids`, `cdata`, `hash`, `confirmed`) VALUES
(2, 1389811943, 'usr-subscribe', '62.167.28.103', 'http://www.coiffeursunshine.ch/index_listmessenger.html', 'Mozilla/5.0 (Windows NT 5.1; rv:26.0) Gecko/20100101 Firefox/26.0', 'info@avpers.com', 'Robin', 'Simons', 'a:1:{i:0;i:3;}', 'a:5:{s:9:\"group_ids\";a:1:{s:6:\"Kunden\";s:1:\"3\";}s:13:\"email_address\";s:15:\"info@avpers.com\";s:9:\"firstname\";s:5:\"Robin\";s:8:\"lastname\";s:6:\"Simons\";s:6:\"action\";s:9:\"subscribe\";}', '14bacd743d823e8cad724f01fdb5e38c', 1),
(6, 1389814069, 'usr-unsubscribe', '62.167.28.103', 'http://www.coiffeursunshine.ch/index_listmessenger.html', 'Mozilla/5.0 (Windows NT 5.1; rv:26.0) Gecko/20100101 Firefox/26.0', 'info@avpers.com', '', '', 'a:1:{i:0;i:3;}', 'a:0:{}', '2b592e2147372500096bbe6f5fd29419', 1),
(7, 1389814413, 'usr-unsubscribe', '62.167.28.103', 'http://www.coiffeursunshine.ch/index_listmessenger.html', 'Mozilla/5.0 (Windows NT 5.1; rv:26.0) Gecko/20100101 Firefox/26.0', 'info@avpers.com', '', '', 'a:1:{i:0;i:3;}', 'a:0:{}', '02b8645c1fc8b679edc2a98d1b4d326b', 1),
(12, 1390121371, 'usr-subscribe', '62.167.28.103', 'http://www.coiffeursunshine.ch/index_listmessenger.html', 'Mozilla/5.0 (Windows NT 5.1; rv:26.0) Gecko/20100101 Firefox/26.0', 'info@avpers.com', 'Robin', 'Simons', 'a:1:{i:0;i:3;}', 'a:5:{s:9:\"group_ids\";a:1:{s:6:\"Kunden\";s:1:\"3\";}s:13:\"email_address\";s:15:\"info@avpers.com\";s:9:\"firstname\";s:5:\"Robin\";s:8:\"lastname\";s:6:\"Simons\";s:6:\"action\";s:9:\"subscribe\";}', 'c284778a2786f16e1a31e9aa362d3531', 1),
(13, 1390235270, 'usr-subscribe', '31.164.149.144', 'http://www.coiffeursunshine.ch/index_listmessenger.html', 'Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko', 'monikawalser@vtxmail.ch', 'Monika', 'Walser', 'a:1:{i:0;i:3;}', 'a:5:{s:9:\"group_ids\";a:1:{s:6:\"Kunden\";s:1:\"3\";}s:13:\"email_address\";s:23:\"monikawalser@vtxmail.ch\";s:9:\"firstname\";s:6:\"Monika\";s:8:\"lastname\";s:6:\"Walser\";s:6:\"action\";s:9:\"subscribe\";}', 'da3d09c63c3211482c9a04ceec668745', 1),
(14, 1390235457, 'usr-unsubscribe', '31.164.149.144', 'http://www.coiffeursunshine.ch/listmessenger/public/unsubscribe.php?g=3&addr=info@avpers.com', 'Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko', 'info@avpers.com', '', '', 'a:1:{i:0;i:3;}', 'a:0:{}', '45cfe94125331be4f89fec3e187a6802', 1),
(15, 1390235754, 'adm-subscribe', '31.164.149.144', 'http://www.coiffeursunshine.ch/listmessenger/index.php?section=subscribers&action=add', 'Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko', 'monikawalser@vtxmail.ch', 'Monika', 'Walser', 'a:1:{i:0;s:1:\"3\";}', 'N;', '7f525b6190e1f74b322f3cc69ccef2c1', 1),
(16, 1390239315, 'usr-subscribe', '62.167.28.103', 'http://www.coiffeursunshine.ch/index_listmessenger.html', 'Mozilla/5.0 (Windows NT 5.1; rv:26.0) Gecko/20100101 Firefox/26.0', 'info@avpers.com', 'Robin', 'Simons', 'a:1:{i:0;i:3;}', 'a:5:{s:9:\"group_ids\";a:1:{s:6:\"Kunden\";s:1:\"3\";}s:13:\"email_address\";s:15:\"info@avpers.com\";s:9:\"firstname\";s:5:\"Robin\";s:8:\"lastname\";s:6:\"Simons\";s:6:\"action\";s:9:\"subscribe\";}', '4a32a7c5d34393f7de1bfdcca038b95e', 1),
(28, 1390243602, 'usr-subscribe', '62.167.28.103', 'http://www.coiffeursunshine.ch/index_listmessenger.html', 'Mozilla/5.0 (Windows NT 5.1; rv:26.0) Gecko/20100101 Firefox/26.0', 'info@avpers.com', 'Robin', 'Simons', 'a:1:{i:0;i:3;}', 'a:5:{s:9:\"group_ids\";a:1:{s:6:\"Kunden\";s:1:\"3\";}s:13:\"email_address\";s:15:\"info@avpers.com\";s:9:\"firstname\";s:5:\"Robin\";s:8:\"lastname\";s:6:\"Simons\";s:6:\"action\";s:9:\"subscribe\";}', 'cd407b80d32b46ebfa31d52c97ddd73e', 1),
(29, 1390244759, 'usr-subscribe', '62.167.28.103', 'http://www.coiffeursunshine.ch/index_listmessenger.html', 'Mozilla/5.0 (Windows NT 5.1; rv:26.0) Gecko/20100101 Firefox/26.0', 'info@avpers.com', 'Robin', 'Simons', 'a:1:{i:0;i:3;}', 'a:5:{s:9:\"group_ids\";a:1:{s:6:\"Kunden\";s:1:\"3\";}s:13:\"email_address\";s:15:\"info@avpers.com\";s:9:\"firstname\";s:5:\"Robin\";s:8:\"lastname\";s:6:\"Simons\";s:6:\"action\";s:9:\"subscribe\";}', '4b1953d9bae0f32080a3cf65f64304f5', 1),
(30, 1390293247, 'adm-subscribe', '31.164.149.144', 'http://www.coiffeursunshine.ch/listmessenger/index.php?section=subscribers&action=add', 'Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko', 'e.herb@gmx.ch', 'Elsbeth', 'Herb', 'a:1:{i:0;s:1:\"3\";}', 'N;', 'f79506f7a17334cab30f0d2e1069594d', 0),
(31, 1390293318, 'adm-subscribe', '31.164.149.144', 'http://www.coiffeursunshine.ch/listmessenger/index.php?section=subscribers&action=add', 'Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko', 'monika.spitzer@gmx.ch', 'Monika', 'Spitzer', 'a:1:{i:0;s:1:\"3\";}', 'N;', '20a270f24c1379da17c07f47bb36adea', 1),
(32, 1390293378, 'adm-subscribe', '31.164.149.144', 'http://www.coiffeursunshine.ch/listmessenger/index.php?section=subscribers&action=add', 'Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko', 'haeberling@mediaworld.ch', 'Heidi', 'H&auml;berling', 'a:1:{i:0;s:1:\"3\";}', 'N;', '47be299590f577a5310fb925784946ca', 0),
(33, 1390293424, 'adm-subscribe', '31.164.149.144', 'http://www.coiffeursunshine.ch/listmessenger/index.php?section=subscribers&action=add', 'Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko', 'familie.schneider@postmail.ch', 'Denise', 'Schneider', 'a:1:{i:0;s:1:\"3\";}', 'N;', '7d4a3ab696ac28895e2a5d47408236a7', 1),
(34, 1390293463, 'adm-subscribe', '31.164.149.144', 'http://www.coiffeursunshine.ch/listmessenger/index.php?section=subscribers&action=add', 'Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko', 'l.del-grosso@gmx.ch', 'Lydia', 'Del Grosso', 'a:1:{i:0;s:1:\"3\";}', 'N;', 'b9e6f21be8f5762e223f5a7457d3dcb3', 1),
(35, 1390293703, 'adm-subscribe', '31.164.149.144', 'http://www.coiffeursunshine.ch/listmessenger/index.php?section=subscribers&action=add', 'Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko', 'andreas.zehnder@amag.ch', 'Andreas', 'Zehnder', 'a:1:{i:0;s:1:\"3\";}', 'N;', 'b42738d76e40b81388ad351ba46d79da', 0),
(36, 1390293755, 'adm-subscribe', '31.164.149.144', 'http://www.coiffeursunshine.ch/listmessenger/index.php?section=subscribers&action=add', 'Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko', 'denise@gmx.ch', 'Denise', 'Meier', 'a:1:{i:0;s:1:\"3\";}', 'N;', '8c1983e5458c8325d4a2d0eb934f50ae', 0),
(37, 1390293886, 'adm-subscribe', '31.164.149.144', 'http://www.coiffeursunshine.ch/listmessenger/index.php?section=subscribers&action=add', 'Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko', 'simone.semmler@swiss-kurier.info', 'Simone', 'Semmler', 'a:1:{i:0;s:1:\"3\";}', 'N;', 'b75a3774734b38f95c6eb14e0414150e', 1),
(38, 1390293933, 'adm-subscribe', '31.164.149.144', 'http://www.coiffeursunshine.ch/listmessenger/index.php?section=subscribers&action=add', 'Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko', 'hzachmann@hotmail.com', 'Hermelinde', 'Zachmann', 'a:1:{i:0;s:1:\"3\";}', 'N;', '3d07539e38e5535e093a7622f978d2b0', 1),
(39, 1390293979, 'adm-subscribe', '31.164.149.144', 'http://www.coiffeursunshine.ch/listmessenger/index.php?section=subscribers&action=add', 'Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko', 'beatfuellemann@me.com', 'Beat', 'F&uuml;llemann', 'a:1:{i:0;s:1:\"3\";}', 'N;', '1dcffa0b5ed097c2d8d3472dd04da364', 0),
(40, 1390294018, 'adm-subscribe', '31.164.149.144', 'http://www.coiffeursunshine.ch/listmessenger/index.php?section=subscribers&action=add', 'Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko', 'petrazmoos@bluewin.ch', 'Petra', 'Zmoos', 'a:1:{i:0;s:1:\"3\";}', 'N;', 'bfa54cf7082468770f0a424bfe971b8b', 1),
(41, 1390294080, 'adm-subscribe', '31.164.149.144', 'http://www.coiffeursunshine.ch/listmessenger/index.php?section=subscribers&action=add', 'Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko', 'andre.keller@gmx.net', 'Andr&eacute;', 'Keller', 'a:1:{i:0;s:1:\"3\";}', 'N;', '4d5bbfc752c3dd0f18a77418c838d439', 1),
(42, 1390294128, 'adm-subscribe', '31.164.149.144', 'http://www.coiffeursunshine.ch/listmessenger/index.php?section=subscribers&action=add', 'Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko', 'nitschge66@gmx.ch', 'Anita', 'Balmer', 'a:1:{i:0;s:1:\"3\";}', 'N;', 'c8a51ad7ec71748e16fb27dc20bfce46', 0),
(43, 1390294179, 'adm-subscribe', '31.164.149.144', 'http://www.coiffeursunshine.ch/listmessenger/index.php?section=subscribers&action=add', 'Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko', 'dani.buehlmann@gmx.ch', 'Dani', 'B&uuml;hlmann', 'a:1:{i:0;s:1:\"3\";}', 'N;', 'f1e4777ed526b4e895955010c5667491', 1),
(44, 1390294221, 'adm-subscribe', '31.164.149.144', 'http://www.coiffeursunshine.ch/listmessenger/index.php?section=subscribers&action=add', 'Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko', 'kwt@bluewin.ch', 'Uschi', 'Griesser', 'a:1:{i:0;s:1:\"3\";}', 'N;', 'f620448f7c7b7ea25a5d0f15b14ba2e8', 0),
(45, 1390294267, 'adm-subscribe', '31.164.149.144', 'http://www.coiffeursunshine.ch/listmessenger/index.php?section=subscribers&action=add', 'Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko', 'hannyegli@bluewin.ch', 'Hanna', 'Egli', 'a:1:{i:0;s:1:\"3\";}', 'N;', '8989cc91891c9557d4334e0ab8b077e4', 0),
(46, 1390294309, 'adm-subscribe', '31.164.149.144', 'http://www.coiffeursunshine.ch/listmessenger/index.php?section=subscribers&action=add', 'Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko', 'hj.haller@bluewin.ch', 'Jeannine', 'Haller', 'a:1:{i:0;s:1:\"3\";}', 'N;', '293f91ce668f6e98d07384510feb9a5a', 1),
(47, 1390294367, 'adm-subscribe', '31.164.149.144', 'http://www.coiffeursunshine.ch/listmessenger/index.php?section=subscribers&action=add', 'Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko', 'nicole.scheid@trivadis.com', 'Nicole', 'Scheid', 'a:1:{i:0;s:1:\"3\";}', 'N;', 'fc013f620165ea061cc71e1ec3da252d', 1),
(48, 1390294415, 'adm-subscribe', '31.164.149.144', 'http://www.coiffeursunshine.ch/listmessenger/index.php?section=subscribers&action=add', 'Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko', 'ursina.kuhn@gmx.ch', 'Ursina', 'Kuhn', 'a:1:{i:0;s:1:\"3\";}', 'N;', '99454cf0ae10493b5e976d552c4f5ad3', 1),
(49, 1390317052, 'adm-subscribe', '31.164.149.144', 'http://www.coiffeursunshine.ch/listmessenger/index.php?section=subscribers&action=add', 'Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko', 'e.herb@gmx.ch', 'Elsbeth', 'Herb', 'a:1:{i:0;s:1:\"3\";}', 'N;', '082ed1c0bc12e26837a496c9e2c92c4c', 1),
(50, 1390317164, 'adm-subscribe', '31.164.149.144', 'http://www.coiffeursunshine.ch/listmessenger/index.php?section=subscribers&action=add', 'Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko', 'e.herb@gmx.ch', 'Elsbeth', 'Herb', 'a:1:{i:0;s:1:\"3\";}', 'N;', '', 0),
(51, 1390317267, 'adm-subscribe', '31.164.149.144', 'http://www.coiffeursunshine.ch/listmessenger/index.php?section=subscribers&action=add', 'Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko', 'haeberling@mediaworld.ch', 'Heidi', 'H&auml;berling', 'a:1:{i:0;s:1:\"3\";}', 'N;', '', 0),
(52, 1390317526, 'adm-subscribe', '31.164.149.144', 'http://www.coiffeursunshine.ch/listmessenger/index.php?section=subscribers&action=add', 'Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko', 'beatfuellemann@me.com', 'Beat', 'F&uuml;llemann', 'a:1:{i:0;s:1:\"3\";}', 'N;', '', 0);

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

--
-- Table structure for table `groups`
--

CREATE TABLE `groups` (
  `groups_id` int(12) NOT NULL,
  `group_name` varchar(64) NOT NULL DEFAULT '',
  `group_parent` int(12) NOT NULL DEFAULT 0,
  `group_private` enum('true','false') NOT NULL DEFAULT 'false'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `groups`
--

INSERT INTO `groups` (`groups_id`, `group_name`, `group_parent`, `group_private`) VALUES
(3, 'Kunden Coiffeur Sunshine', 0, 'false'),
(4, 'Natalie', 0, 'false');

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

--
-- Table structure for table `messages`
--

CREATE TABLE `messages` (
  `message_id` int(12) NOT NULL,
  `message_date` bigint(64) NOT NULL DEFAULT 0,
  `message_title` varchar(255) NOT NULL DEFAULT '',
  `message_subject` varchar(255) NOT NULL DEFAULT '(no subject)',
  `message_from` text NOT NULL,
  `message_reply` text NOT NULL,
  `message_priority` int(1) NOT NULL DEFAULT 0,
  `text_message` longtext NOT NULL,
  `text_template` int(12) DEFAULT NULL,
  `html_message` longtext NOT NULL,
  `html_template` int(12) DEFAULT NULL,
  `attachments` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `messages`
--

INSERT INTO `messages` (`message_id`, `message_date`, `message_title`, `message_subject`, `message_from`, `message_reply`, `message_priority`, `text_message`, `text_template`, `html_message`, `html_template`, `attachments`) VALUES
(3, 1390232927, 'Newsletter TEST 3', 'Coiffeur Sunshine Newsletter Februar 2014', '\"Coiffeur Sunshine\" <info@coiffeursunshine.ch>', '\"Coiffeur Sunshine\" <info@coiffeursunshine.ch>', 3, 'Suchst Du eine Lehrstelle auf Sommer 2014?\r\n\r\nDann melde Dich bei uns!!!\r\n\r\nWir freuen uns über eine fröhliche, aufgestellte,\r\nzuverlässige und freundliche Persönlichkeit.\r\n\r\nDas Sunshine- Team freut sich über Deine Bewerbung - mündlich\r\noder schriftlich.\r\n044 858 40 79 … bitte Frau Walser verlangen.\r\n\r\n************************************************************************\r\n\r\nDIE WELTNEUHEIT BEIM COIFFEURSTUDIO SUNSHINE!!!\r\n\r\nNacken, Schulter, Rücken Massagegerät!!!\r\nEntspannt die Muskulatur, steigert die Schlafqualität, lindert\r\nKopfschmerzen- und Migräneschmerzen, fördert die\r\nBlutzirkulation!!!\r\nMit Wärmefunktion durch Infrarot!!!\r\nLassen Sie sich beraten und massieren!!!\r\n\r\n************************************************************************\r\n\r\nMit dem neuen MIRA CURL in Sekunden fliessende Locken drehen!!!\r\n\r\nFür Festfrisuren etc. minimaler Zeitaufwand !!\r\nHaarschonend, mit Temperaturregler, Intensitätsregler,\r\nRichtungssteuerung und und und....\r\nLassen Sie sich im Sunshine- Team!!!! beraten!!', 0, '<p style=\"text-align: center;\">&nbsp;</p>\r\n<p style=\"text-align: center;\">&nbsp;</p>\r\n<p style=\"text-align: center;\">&nbsp;</p>\r\n<p style=\"text-align: center;\">&nbsp;</p>\r\n<p style=\"text-align: center;\">&nbsp;</p>\r\n<p style=\"text-align: center;\">&nbsp;</p>\r\n<p style=\"text-align: center;\">&nbsp;</p>\r\n<p style=\"text-align: center;\"><span style=\"text-decoration: underline;\"><span style=\"font-size: large; font-family: arial,helvetica,sans-serif;\"><strong>NEWSLETTER FEBRUAR 2014</strong></span></span></p>\r\n<p style=\"text-align: center;\">&nbsp;</p>\r\n<p style=\"text-align: center;\"><strong style=\"background-image: url(http://www.coiffeursunshine.ch/site_pics/Background_grad_1280x1024.jpeg);\">Suchst </strong><strong style=\"background-image: url(http://www.coiffeursunshine.ch/site_pics/Background_grad_1280x1024.jpeg);\"><img style=\"left: 20px; top: 20px; width: 175px; height: 113px; position: absolute;\" src=\"http://www.coiffeursunshine.ch/site_pics/logo_new_aug09_brighter.gif\" alt=\"Coiffeur Sunshine Logo\"></strong><strong style=\"background-image: url(http://www.coiffeursunshine.ch/site_pics/Background_grad_1280x1024.jpeg);\">Du eine</strong> <strong>Lehrstelle auf Sommer 2014?</strong><br> <br> <strong>Dann melde Dich bei uns!!!</strong><br> <br> Wir freuen uns &uuml;ber eine fr&ouml;hliche, aufgestellte, zuverl&auml;ssige und freundliche Pers&ouml;nlichkeit.<br> <br> Das Sunshine- Team freut sich &uuml;ber Deine Bewerbung - m&uuml;ndlich oder schriftlich.<br> <strong>044 858 40 79</strong> &hellip; bitte Frau Walser verlangen.</p>\r\n<p style=\"text-align: center;\">************************************************************************</p>\r\n<p style=\"text-align: center;\"><strong>DIE WELTNEUHEIT BEIM</strong> <strong>COIFFEURSTUDIO SUNSHINE!!!</strong></p>\r\n<p style=\"text-align: center;\"><strong><img src=\"http://www.coiffeursunshine.ch/images/aktuellespic_031113.jpg\" alt=\"\" width=\"332\" height=\"248\"><br></strong></p>\r\n<p style=\"text-align: center;\">Nacken, Schulter, R&uuml;cken Massageger&auml;t!!!<br> Entspannt die Muskulatur, steigert die Schlafqualit&auml;t, lindert  Kopfschmerzen- und Migr&auml;neschmerzen, f&ouml;rdert die Blutzirkulation!!!<br> Mit W&auml;rmefunktion durch Infrarot!!!<br> Lassen Sie sich beraten und massieren!!!</p>\r\n<p style=\"text-align: center;\">************************************************************************</p>\r\n<p style=\"text-align: center;\">Mit dem neuen <strong>MIRA CURL</strong> in Sekunden fliessende Locken drehen!!!</p>\r\n<p style=\"text-align: center;\"><img src=\"http://www.coiffeursunshine.ch/images/aktuellespic_281013.jpg\" alt=\"\" width=\"331\" height=\"248\"></p>\r\n<p style=\"text-align: center;\">F&uuml;r Festfrisuren etc. minimaler Zeitaufwand !!<br> Haarschonend, mit Temperaturregler, Intensit&auml;tsregler, Richtungssteuerung und und und....<br> Lassen Sie sich im <strong>Sunshine- Team!!!!</strong> beraten!!</p>', 0, '');

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

--
-- Table structure for table `preferences`
--

CREATE TABLE `preferences` (
  `preference_id` int(12) NOT NULL,
  `preference_value` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `preferences`
--

INSERT INTO `preferences` (`preference_id`, `preference_value`) VALUES
(1, '0571749e2ac330a7455809c6b0e7af90'),
(2, 'Coiffeur Sunshine'),
(3, 'info@coiffeursunshine.ch'),
(4, 'info@coiffeursunshine.ch'),
(5, '2.2.1'),
(6, 'www.coiffeursunshine.ch'),
(7, 'yes'),
(8, 'walser'),
(9, '25'),
(10, 'archive.php'),
(11, 'confirm.php'),
(12, 'help.php'),
(13, 'unsubscribe.php'),
(14, '/home/httpd/vhosts/coiffeursunshine.ch/httpdocs/listmessenger/'),
(15, 'http://www.coiffeursunshine.ch/listmessenger/'),
(16, '/home/httpd/vhosts/coiffeursunshine.ch/httpdocs/listmessenger/public/'),
(17, '76'),
(18, '75'),
(19, 'admin@coiffeursunshine.ch'),
(20, 'Coiffeur Sunshine'),
(21, 'info@coiffeursunshine.ch'),
(22, 'a4c793819562211b4f4f577765c8c915'),
(23, 'M jS Y g:ia'),
(24, '1'),
(25, 'mail'),
(26, ''),
(27, 'false'),
(28, ''),
(29, ''),
(30, 'tiny_mce'),
(31, 'yes'),
(32, 'no'),
(33, 'listmessenger.php'),
(34, 'template.html'),
(35, 'admin@coiffeursunshine.ch'),
(36, 'yes'),
(37, 'no'),
(38, ''),
(39, ''),
(40, 'german'),
(41, 'yes'),
(42, '60'),
(43, 'admin@coiffeursunshine.ch'),
(44, 'no'),
(45, 'yes'),
(46, 'yes'),
(47, 'http://www.coiffeursunshine.ch/listmessenger/public/'),
(48, '/home/httpd/vhosts/coiffeursunshine.ch/httpdocs/private/'),
(49, 'UTF-8'),
(50, '7'),
(51, 'yes'),
(52, '1'),
(53, '1391620624'),
(54, '0'),
(55, '0'),
(56, 'no'),
(57, 'profile.php'),
(58, 'no'),
(59, 'no'),
(60, ''),
(61, 'yes'),
(62, 'no'),
(63, 'no'),
(64, 'forward.php'),
(65, 'no'),
(66, 'htmlspecialchars'),
(67, 'yes'),
(68, ''),
(69, 'n'),
(70, 'yes');

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

--
-- Table structure for table `queue`
--

CREATE TABLE `queue` (
  `queue_id` int(12) NOT NULL,
  `message_id` int(12) NOT NULL DEFAULT 0,
  `date` bigint(64) NOT NULL DEFAULT 0,
  `touch` bigint(64) NOT NULL DEFAULT 0,
  `target` text NOT NULL,
  `progress` int(12) NOT NULL DEFAULT 0,
  `total` int(12) NOT NULL DEFAULT 0,
  `status` varchar(25) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `queue`
--

INSERT INTO `queue` (`queue_id`, `message_id`, `date`, `touch`, `target`, `progress`, `total`, `status`) VALUES
(1, 1, 1390122622, 0, 'a:1:{i:0;i:3;}', 1, 1, 'Complete'),
(2, 2, 1390232105, 0, 'a:1:{i:0;i:3;}', 1, 1, 'Complete'),
(3, 2, 1390232154, 0, 'a:1:{i:0;i:3;}', 1, 1, 'Complete'),
(4, 2, 1390232308, 0, 'a:1:{i:0;i:3;}', 1, 1, 'Complete'),
(5, 2, 1390232373, 0, 'a:1:{i:0;i:3;}', 1, 1, 'Complete'),
(6, 2, 1390232674, 0, 'a:1:{i:0;i:3;}', 1, 1, 'Complete'),
(7, 3, 1390233379, 0, 'a:1:{i:0;i:3;}', 1, 1, 'Complete'),
(8, 3, 1390233518, 0, 'a:1:{i:0;i:3;}', 1, 1, 'Complete'),
(9, 3, 1390233787, 0, 'a:1:{i:0;i:3;}', 1, 1, 'Complete');

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

--
-- Table structure for table `sending`
--

CREATE TABLE `sending` (
  `sending_id` int(12) NOT NULL,
  `email_address` varchar(128) NOT NULL DEFAULT '',
  `users_id` int(12) NOT NULL DEFAULT 0,
  `queue_id` int(12) NOT NULL DEFAULT 0,
  `sent` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `sesskey` varchar(64) NOT NULL DEFAULT '',
  `expiry` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `expireref` varchar(250) DEFAULT '',
  `created` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `sessdata` longtext DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `templates`
--

CREATE TABLE `templates` (
  `template_id` int(12) NOT NULL,
  `template_name` varchar(64) NOT NULL DEFAULT '',
  `template_type` varchar(4) NOT NULL DEFAULT 'html',
  `template_description` text DEFAULT NULL,
  `template_content` longtext NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `users_id` int(12) NOT NULL,
  `group_id` int(12) NOT NULL DEFAULT 0,
  `signup_date` bigint(64) NOT NULL DEFAULT 0,
  `firstname` varchar(32) DEFAULT NULL,
  `lastname` varchar(64) DEFAULT NULL,
  `email_address` varchar(128) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`users_id`, `group_id`, `signup_date`, `firstname`, `lastname`, `email_address`) VALUES
(4, 3, 1390235797, 'Monika', 'Walser', 'monikawalser@vtxmail.ch'),
(8, 3, 1390294352, 'Dani', 'Bühlmann', 'dani.buehlmann@gmx.ch'),
(9, 3, 1390294605, 'Nicole', 'Scheid', 'nicole.scheid@trivadis.com'),
(10, 3, 1390297018, 'Denise', 'Schneider', 'familie.schneider@postmail.ch'),
(11, 3, 1390310687, 'Ursina', 'Kuhn', 'ursina.kuhn@gmx.ch'),
(12, 3, 1390311087, 'Simone', 'Semmler', 'simone.semmler@swiss-kurier.info'),
(13, 3, 1390312477, 'Monika', 'Spitzer', 'monika.spitzer@gmx.ch'),
(14, 3, 1390317164, 'Elsbeth', 'Herb', 'e.herb@gmx.ch'),
(15, 3, 1390317267, 'Heidi', 'Häberling', 'haeberling@mediaworld.ch'),
(16, 3, 1390317526, 'Beat', 'Füllemann', 'beatfuellemann@me.com'),
(17, 3, 1390327716, 'Lydia', 'Del Grosso', 'l.del-grosso@gmx.ch'),
(18, 3, 1390373858, 'Petra', 'Zmoos', 'petrazmoos@bluewin.ch'),
(19, 3, 1390394096, 'Hermelinde', 'Zachmann', 'hzachmann@hotmail.com'),
(20, 3, 1390404103, 'Andr&eacute;', 'Keller', 'andre.keller@gmx.net'),
(21, 3, 1390558425, 'Jeannine', 'Haller', 'hj.haller@bluewin.ch');

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

--
-- Table structure for table `user_updates`
--

CREATE TABLE `user_updates` (
  `updates_id` int(12) NOT NULL,
  `hash` varchar(32) NOT NULL DEFAULT '',
  `date` bigint(64) NOT NULL DEFAULT 0,
  `email_address` varchar(128) NOT NULL DEFAULT '0',
  `completed` int(1) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `cdata`
--
ALTER TABLE `cdata`
  ADD PRIMARY KEY (`cdata_id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `cfield_id` (`cfield_id`);

--
-- Indexes for table `cfields`
--
ALTER TABLE `cfields`
  ADD PRIMARY KEY (`cfields_id`),
  ADD UNIQUE KEY `field_sname` (`field_sname`),
  ADD KEY `field_sname_2` (`field_sname`),
  ADD KEY `field_lname` (`field_lname`),
  ADD KEY `field_type` (`field_type`),
  ADD KEY `field_req` (`field_req`),
  ADD KEY `field_order` (`field_order`);

--
-- Indexes for table `confirmation`
--
ALTER TABLE `confirmation`
  ADD PRIMARY KEY (`confirm_id`);

--
-- Indexes for table `groups`
--
ALTER TABLE `groups`
  ADD PRIMARY KEY (`groups_id`);

--
-- Indexes for table `messages`
--
ALTER TABLE `messages`
  ADD PRIMARY KEY (`message_id`);

--
-- Indexes for table `preferences`
--
ALTER TABLE `preferences`
  ADD PRIMARY KEY (`preference_id`);

--
-- Indexes for table `queue`
--
ALTER TABLE `queue`
  ADD PRIMARY KEY (`queue_id`),
  ADD KEY `date` (`date`);

--
-- Indexes for table `sending`
--
ALTER TABLE `sending`
  ADD PRIMARY KEY (`sending_id`);

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`sesskey`),
  ADD KEY `sess2_expiry` (`expiry`),
  ADD KEY `sess2_expireref` (`expireref`);

--
-- Indexes for table `templates`
--
ALTER TABLE `templates`
  ADD PRIMARY KEY (`template_id`),
  ADD KEY `template_type` (`template_type`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`users_id`),
  ADD KEY `group_id` (`group_id`),
  ADD KEY `signup_date` (`signup_date`),
  ADD KEY `email_address` (`email_address`);

--
-- Indexes for table `user_updates`
--
ALTER TABLE `user_updates`
  ADD PRIMARY KEY (`updates_id`),
  ADD UNIQUE KEY `hash` (`hash`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `cdata`
--
ALTER TABLE `cdata`
  MODIFY `cdata_id` int(12) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cfields`
--
ALTER TABLE `cfields`
  MODIFY `cfields_id` int(12) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `confirmation`
--
ALTER TABLE `confirmation`
  MODIFY `confirm_id` int(12) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=53;

--
-- AUTO_INCREMENT for table `groups`
--
ALTER TABLE `groups`
  MODIFY `groups_id` int(12) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `messages`
--
ALTER TABLE `messages`
  MODIFY `message_id` int(12) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `preferences`
--
ALTER TABLE `preferences`
  MODIFY `preference_id` int(12) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=71;

--
-- AUTO_INCREMENT for table `queue`
--
ALTER TABLE `queue`
  MODIFY `queue_id` int(12) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `sending`
--
ALTER TABLE `sending`
  MODIFY `sending_id` int(12) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `templates`
--
ALTER TABLE `templates`
  MODIFY `template_id` int(12) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `users_id` int(12) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `user_updates`
--
ALTER TABLE `user_updates`
  MODIFY `updates_id` int(12) NOT NULL AUTO_INCREMENT;
COMMIT;

