-- http://www.phpmyadmin.net
--
-- Versione del server: 5.6.19-0ubuntu0.14.04.1




--
-- Database: `ideasferadb_test`
--

--
-- Dump dei dati per la tabella `log_user_operations`
--

INSERT INTO `log_user_operations` (`id`, `user_id`, `opType`, `description`, `op_time`) VALUES
(6232, 22, 12, 'Campagna: prova, Brand: Vittabbella, data inizio: 18-03-2015, data fine:', '2015-03-18 09:56:41'),
(6233, 22, 13, 'Campagna: prova, Brand: Vittabbella, tipologia: Inserimento anagrafiche', '2015-03-18 18:00:56'),
(6234, 22, 12, 'Campagna: Tutti al mare!, Brand: Vittabbella, data inizio: 19-03-2015, data fine:26-03-2015', '2015-03-18 18:03:10');

--
-- Dump dei dati per la tabella `roles`
--

INSERT INTO `roles` (`id`, `Description`, `label`, `created_at`, `updated_at`, `order`) VALUES
(0, 'Gestione completa', 'Admin', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL),
(1, 'Gestione utenti', 'Utenti', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1),
(10, 'Importazione DB esterni', 'DB', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 2),
(11, 'Creazione e gestione di Campagne', 'Campagne', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 4),
(12, 'Creazione e gestione dei Concorsi', 'Concorso', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 5),
(13, 'Gestione dei menù e dei template di Analytics', 'Statistiche', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 7),
(14, 'Creazione e gestione di Gruppi e Clienti', 'Clienti&Brand', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 3),
(15, 'Gestione immagini dell''applicazione Concorso', 'Img', '2014-12-03 16:09:50', '2014-12-03 16:09:59', 6);

--
-- Dump dei dati per la tabella `role_users`
--

INSERT INTO `role_users` (`user_id`, `role_id`, `created_at`, `updated_at`) VALUES
(1, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(3, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(18, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(22, 0, '2015-02-11 10:31:36', '2015-02-11 10:31:36'),
(9, 15, '2015-02-23 12:42:23', '2015-02-23 12:42:23'),
(10, 14, '2015-02-23 12:42:23', '2015-02-23 12:42:23'),
(10, 11, '2015-02-23 12:42:23', '2015-02-23 12:42:23'),
(10, 12, '2015-02-23 12:42:23', '2015-02-23 12:42:23'),
(10, 15, '2015-02-23 12:42:23', '2015-02-23 12:42:23'),
(10, 13, '2015-02-23 12:42:23', '2015-02-23 12:42:23'),
(11, 14, '2015-02-23 12:42:23', '2015-02-23 12:42:23'),
(11, 11, '2015-02-23 12:42:23', '2015-02-23 12:42:23'),
(11, 12, '2015-02-23 12:42:23', '2015-02-23 12:42:23'),
(15, 14, '2015-02-23 12:42:23', '2015-02-23 12:42:23'),
(15, 11, '2015-02-23 12:42:23', '2015-02-23 12:42:23'),
(16, 14, '2015-02-23 12:42:23', '2015-02-23 12:42:23'),
(16, 11, '2015-02-23 12:42:23', '2015-02-23 12:42:23'),
(19, 1, '2015-02-23 12:42:23', '2015-02-23 12:42:23'),
(19, 10, '2015-02-23 12:42:24', '2015-02-23 12:42:24'),
(19, 14, '2015-02-23 12:42:24', '2015-02-23 12:42:24'),
(19, 11, '2015-02-23 12:42:24', '2015-02-23 12:42:24'),
(19, 12, '2015-02-23 12:42:24', '2015-02-23 12:42:24'),
(19, 15, '2015-02-23 12:42:24', '2015-02-23 12:42:24'),
(19, 13, '2015-02-23 12:42:24', '2015-02-23 12:42:24');

--
-- Dump dei dati per la tabella `TANBindMobileEmail`
--

INSERT INTO `TANBindMobileEmail` (`TANBMEid_MobileNumber`, `TANBMEid_EmailAddress`) VALUES
(380257, 223525),
(380289, 223527),
(380268, 223528),
(380305, 223533),
(380275, 223538),
(380281, 223548),
(380282, 223550),
(380266, 223552),
(380253, 223553),
(380265, 223555),
(380247, 223556),
(380267, 223561),
(380263, 223569),
(380288, 223573),
(380291, 223575),
(380295, 223576),
(380296, 223580),
(380256, 223582),
(380303, 223584),
(380287, 223587),
(380298, 223588),
(380249, 223590),
(380241, 223592),
(380243, 223596),
(380294, 223603),
(380244, 223605),
(380255, 223609),
(380271, 223613),
(380293, 223617),
(380264, 223619),
(380286, 223623),
(380242, 223624),
(380261, 223636),
(380285, 223640),
(380283, 223645),
(380246, 223646),
(380301, 223649),
(380272, 223653),
(380248, 223659),
(380280, 223660),
(380274, 223662),
(380269, 223667),
(380258, 223668),
(380273, 223669),
(380304, 223671),
(380252, 223680),
(380277, 223686),
(380299, 223687),
(380302, 223695),
(380245, 223696),
(380276, 223699),
(380279, 223703),
(380259, 223704),
(380262, 223712),
(380260, 223714),
(380290, 223720),
(380292, 223724),
(380297, 223726),
(380300, 223729),
(380278, 223730),
(380284, 223739),
(380240, 223743),
(380251, 223744),
(380254, 223749),
(380250, 223752),
(380270, 223757);

--
-- Dump dei dati per la tabella `TANEmail`
--

INSERT INTO `TANEmail` (`TANEID`, `TANEBrandId`, `TANEEmailAddress`, `TANEVerificato`, `TANEConsensoInvioEmail`, `TANEDataUltimaSyncMailup`, `TANEDataUltimaModificaConsensoEmail`) VALUES
(223524, 67, '1renatosegala@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223525, 67, '56panda@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223526, 67, 'adiego68@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223527, 67, 'afuc@yahoo.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223528, 67, 'alberto.sartini@alice.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223529, 67, 'alessandrabertelli1972@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223530, 67, 'alexbarotto@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223531, 67, 'alicerasi@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223532, 67, 'altea.cremon@vodafone.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223533, 67, 'amer-elo@hotmail.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223534, 67, 'andrea.72@cheapnet.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223535, 67, 'andreazuliani@live.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223536, 67, 'angelo.trivellato@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223537, 67, 'angy.rossi1990@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223538, 67, 'annalaurente@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223539, 67, 'antomari23@yahoo.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223540, 67, 'arianna.brandolese@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223541, 67, 'astridmr@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223542, 67, 'avanzicinzia@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223543, 67, 'avecaesar@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223544, 67, 'babuhna@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223545, 67, 'barbara.guidi60@alice.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223546, 67, 'Bcomm@tin.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223547, 67, 'Beautybelle@hotmail.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223548, 67, 'begross@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223549, 67, 'betty.carlo@alice.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223550, 67, 'bindella.stefano@tiscali.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223551, 67, 'blugirl63@alice.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223552, 67, 'bogdan_brigitta22@yahoo.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223553, 67, 'bonfatti.sabrina@alice.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223554, 67, 'borghezio92@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223555, 67, 'c.bellini@juicegroup.net', 0, 0, NULL, '2015-03-17 17:38:31'),
(223556, 67, 'caberletti-trasporti@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223557, 67, 'carlo45020@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223558, 67, 'carrirolo.francesca@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223559, 67, 'cavaliere.melissa@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223560, 67, 'centro.comm.il.faro@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223561, 67, 'cindy850@alice.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223562, 67, 'crema.fede@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223563, 67, 'cri505@alice.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223564, 67, 'Cristianasop@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223565, 67, 'cristinafioravanti@alice.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223566, 67, 'cuoresportivo155@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223567, 67, 'czroberma@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223568, 67, 'dalligna.alessandra@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223569, 67, 'dalmalo@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223570, 67, 'dani71070@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223571, 67, 'dania.paolo@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223572, 67, 'danielamodrescu@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223573, 67, 'deborastrenghetto@yahoo.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223574, 67, 'deniseboniolo@hotmail.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223575, 67, 'diazzi.marilena@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223576, 67, 'elenaefamiglia@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223577, 67, 'ely.marchetto@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223578, 67, 'emanuelegiacomella@hotmail.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223579, 67, 'ermes@hotelvicinogardaland.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223580, 67, 'esa1967@live.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223581, 67, 'etiuscha@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223582, 67, 'everest@everest-adv.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223583, 67, 'fabiofurlani0@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223584, 67, 'federica.seno91@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223585, 67, 'federica_r2003@yahoo.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223586, 67, 'ferrari.albe@alice.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223587, 67, 'ferrarini.silvia@yahoo.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223588, 67, 'ferrarinigianluigi21@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223589, 67, 'fguolo@serbios.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223590, 67, 'franco.paliotto@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223591, 67, 'furiam91@live.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223592, 67, 'fuso.spider@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223593, 67, 'gbaraldi71@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223594, 67, 'giada.saltarelli@hotmail.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223595, 67, 'giadagaz@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223596, 67, 'gianlucamilan@virgilio.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223597, 67, 'giannavalentini1942@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223598, 67, 'giorgio.faliva@alice.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223599, 67, 'Giorgio.ferrighi@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223600, 67, 'giu.chu86@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223601, 67, 'giuber63@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223602, 67, 'giulia.turatti@hotmail.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223603, 67, 'giulia@bcomm.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223604, 67, 'Giuliafusetti@hotmail.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223605, 67, 'giuliamontefiori@yahoo.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223606, 67, 'giuliana.sarti@yahoo.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223607, 67, 'giulianabonin@alice.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223608, 67, 'giuliobert@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223609, 67, 'giuseppe.melloni@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223610, 67, 'gloria.iskra@alice.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223611, 67, 'gloriastef@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223612, 67, 'glugli@seve.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223613, 67, 'gomieromattia@yahoo.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223614, 67, 'graziellapigaiani@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223615, 67, 'gretato82@hotmail.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223616, 67, 'guerrino.corsato@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223617, 67, 'guidobroglio@hotmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223618, 67, 'gzzpla@yahoo.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223619, 67, 'ignazio.rigolin@alice.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223620, 67, 'igorstrapub@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223621, 67, 'ilenia_ruin@yahoo.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223622, 67, 'info@bcomm.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223623, 67, 'info@lucamantovani.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223624, 67, 'info@rswstudio.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223625, 67, 'Isabellamolinari@hotmail.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223626, 67, 'isaf1974@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223627, 67, 'jennybar@tiscali.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223628, 67, 'katiusciagambarin@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223629, 67, 'kcasaro@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223630, 67, 'kouje2010@hotmail.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223631, 67, 'l.frigato@berco.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223632, 67, 'laraquaglio@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223633, 67, 'lattemacchiatoalcacao@yahoo.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223634, 67, 'Laura.guerrato@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223635, 67, 'laura.sproccati@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223636, 67, 'lavezzoalice@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223637, 67, 'linda-massimo08@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223638, 67, 'linda.destro2006@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223639, 67, 'lorena.boldrin@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223640, 67, 'lorettaruggini@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223641, 67, 'lucam51@tin.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223642, 67, 'lucianobertelle@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223643, 67, 'lucianofistis@yahoo.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223644, 67, 'luigino_1946@alice.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223645, 67, 'lunardi.m@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223646, 67, 'luonica@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223647, 67, 'm.samanta@virgilio.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223648, 67, 'maikol2592@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223649, 67, 'manfred.gebauer@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223650, 67, 'manochieres67@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223651, 67, 'mara.bernardinello@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223652, 67, 'marbel66@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223653, 67, 'marco.faggion@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223654, 67, 'mariaelvira.vezzoli@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223655, 67, 'maridido2000@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223656, 67, 'marika.destro@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223657, 67, 'marizene@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223658, 67, 'mary.punzetti@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223659, 67, 'mattiagozzi@yahoo.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223660, 67, 'mauro.berian@alice.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223661, 67, 'mauro.verdaro@icloud.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223662, 67, 'max.benetti@yahoo.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223663, 67, 'mg.group05@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223664, 67, 'michaelbenetti@yahoo.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223665, 67, 'michela.saretta@alice.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223666, 67, 'michele.rauli@yahoo.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223667, 67, 'micheleelgamba@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223668, 67, 'mikimati@alice.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223669, 67, 'miki_house@live.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223670, 67, 'milenacorli@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223671, 67, 'milu-ml@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223672, 67, 'mingo2006@alice.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223673, 67, 'mitica.ada82@live.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223674, 67, 'mokia.ottoboni@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223675, 67, 'moniasor@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223676, 67, 'monica91267@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223677, 67, 'monicamaron4@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223678, 67, 'monikas2004@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223679, 67, 'montefiorigiovanni@hotmail.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223680, 67, 'natale.renzo@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223681, 67, 'natascia.stefani@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223682, 67, 'nicoleturunen@rocketmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223683, 67, 'ong.seg@tiscali.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223684, 67, 'pablito86@hotmail.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223685, 67, 'paola972@alice.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223686, 67, 'paolobarioni33@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223687, 67, 'pasettid@hotmail.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223688, 67, 'patty-1957@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223689, 67, 'pavan.serena@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223690, 67, 'pavstef@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223691, 67, 'pelucco.graziella@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223692, 67, 'perez1975@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223693, 67, 'pigozzo.luca@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223694, 67, 'pizzofabio@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223695, 67, 'pmaghini@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223696, 67, 'pomaricomariangela@hotmail.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223697, 67, 'r.locco@alice.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223698, 67, 'r1yzf1000@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223699, 67, 'raffaella.tramarin@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223700, 67, 'ramistenan1937@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223701, 67, 'riccardo.romani75@yahoo.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223702, 67, 'riccardozeggio@yahoo.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223703, 67, 'rizzi.angiolino@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223704, 67, 'rnd.nicola@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223705, 67, 'roberta.ghidotti@hotmail.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223706, 67, 'robertabozzi@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223707, 67, 'roberto.fin@alice.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223708, 67, 'robertogigs@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223709, 67, 'roberto_moira@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223710, 67, 'roger.cavallieri@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223711, 67, 'romano.ferrarin@alice.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223712, 67, 'rosa.vitali@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223713, 67, 'rosellina4u@yahoo.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223714, 67, 'rosyann13@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223715, 67, 'Ruaro242@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223716, 67, 'sabrina.andreasi@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223717, 67, 'sabry.974@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223718, 67, 'salametropolis13@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223719, 67, 'samantha.romagnolo@alice.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223720, 67, 'samanthapatuzzi@ymail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223721, 67, 'samuela.bruscagin@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223722, 67, 'sara.sostini@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223723, 67, 'sarsab@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223724, 67, 'sbersan@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223725, 67, 'segreteria@comune.melara.ro.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223726, 67, 'serenluigi@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223727, 67, 'silvia.mingotti@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223728, 67, 'simonemeneghinello@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223729, 67, 'simonetta.simon_2010@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223730, 67, 'simostura@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223731, 67, 'Sorrisoevia@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223732, 67, 'spas67@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223733, 67, 'stellazzurra1979@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223734, 67, 'studiorsw@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223735, 67, 'susannap61@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223736, 67, 'sweet1012@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223737, 67, 'tano.magri63@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223738, 67, 'tasia@aol.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223739, 67, 'theterror@alice.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223740, 67, 'thoriann88@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223741, 67, 'tisimo@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223742, 67, 'trevisanniko@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223743, 67, 'tur.andrei-84@mail.ru', 0, 0, NULL, '2015-03-17 17:38:31'),
(223744, 67, 'turatichiara@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223745, 67, 'v.perazzolo@alice.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223746, 67, 'vecchio.g.sura@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223747, 67, 'Ventagliosegreto@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223748, 67, 'Veronicamarabese@virgilio.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223749, 67, 'viadimezzo@yahoo.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223750, 67, 'vis.daniela@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223751, 67, 'visentinmoira74@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223752, 67, 'xbile@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223753, 67, 'xhanisaimir@yahoo.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223754, 67, 'za.rita@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223755, 67, 'zaleti@libero.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223756, 67, 'zeggiocinzia@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31'),
(223757, 67, 'zerby19@hotmail.it', 0, 0, NULL, '2015-03-17 17:38:31'),
(223758, 67, 'zerlottin.elisa@gmail.com', 0, 0, NULL, '2015-03-17 17:38:31');

--
-- Dump dei dati per la tabella `TANMobile`
--

INSERT INTO `TANMobile` (`TANMID`, `TANMBrandId`, `TANMMobileNumber`, `TANMValidita`, `TANMConsensoInvioSMS`) VALUES
(380240, 67, '3275538365', 10, 0),
(380241, 67, '3282210891', 10, 0),
(380242, 67, '32862344734', 10, 0),
(380243, 67, '3286330286', 10, 0),
(380244, 67, '3288778080', 10, 0),
(380245, 67, '3292243315', 10, 0),
(380246, 67, '3293422334', 10, 0),
(380247, 67, '3294344495', 10, 0),
(380248, 67, '3311127554', 10, 0),
(380249, 67, '3334213535', 10, 0),
(380250, 67, '3337669649', 10, 0),
(380251, 67, '3381998200', 10, 0),
(380252, 67, '3384219573', 10, 0),
(380253, 67, '3388373810', 10, 0),
(380254, 67, '3392177652', 10, 0),
(380255, 67, '3393321697', 10, 0),
(380256, 67, '3393637890', 10, 0),
(380257, 67, '3395619537', 10, 0),
(380258, 67, '3396329226', 10, 0),
(380259, 67, '3401158360', 10, 0),
(380260, 67, '3402402941', 10, 0),
(380261, 67, '3402623670', 10, 0),
(380262, 67, '3402675009', 10, 0),
(380263, 67, '3403134976', 10, 0),
(380264, 67, '3404047657', 10, 0),
(380265, 67, '3406511169', 10, 0),
(380266, 67, '3407376706', 10, 0),
(380267, 67, '3408085888', 10, 0),
(380268, 67, '3450563249', 10, 0),
(380269, 67, '3451169688', 10, 0),
(380270, 67, '3451413784', 10, 0),
(380271, 67, '3452986987', 10, 0),
(380272, 67, '3457050401', 10, 0),
(380273, 67, '3459062863', 10, 0),
(380274, 67, '3459277519', 10, 0),
(380275, 67, '3460770377', 10, 0),
(380276, 67, '3470051434', 10, 0),
(380277, 67, '3470491165', 10, 0),
(380278, 67, '3470779661', 10, 0),
(380279, 67, '3471520062', 10, 0),
(380280, 67, '3472488712', 10, 0),
(380281, 67, '3472749057', 10, 0),
(380282, 67, '3474111582', 10, 0),
(380283, 67, '3474247301', 10, 0),
(380284, 67, '3474337997', 10, 0),
(380285, 67, '3474810693', 10, 0),
(380286, 67, '3475967726', 10, 0),
(380287, 67, '3476014979', 10, 0),
(380288, 67, '3476867774', 10, 0),
(380289, 67, '3477314700', 10, 0),
(380290, 67, '3479158090', 10, 0),
(380291, 67, '3479274325', 10, 0),
(380292, 67, '3482323842', 10, 0),
(380293, 67, '3482380030', 10, 0),
(380294, 67, '3482511028', 10, 0),
(380295, 67, '3484753984', 10, 0),
(380296, 67, '3485166694', 10, 0),
(380297, 67, '3485424262', 10, 0),
(380298, 67, '3486964643', 10, 0),
(380299, 67, '3493528593', 10, 0),
(380300, 67, '3493713954', 10, 0),
(380301, 67, '3494205158', 10, 0),
(380302, 67, '3494524015', 10, 0),
(380303, 67, '3496838688', 10, 0),
(380304, 67, '3498428360', 10, 0),
(380305, 67, '3937144267', 10, 0);

--
-- Dump dei dati per la tabella `TANUserEmail`
--

INSERT INTO `TANUserEmail` (`TANUEID`, `TANUECampagnaId`, `TANUEFKEmailID`, `TANUEConsensoInvioEmail`, `TANUEConsensoInvioEmailData`, `TANUEDetails`, `TANUENome`, `TANUECognome`, `TANUEIndirizzo`, `TANUECivico`, `TANUELocalita`, `TANUECAP`, `TANUEProvincia`, `TANUESesso`, `TANUEDataNascita`, `TANUEProvenienza`) VALUES
(350236, 532, 223524, 0, NULL, NULL, 'Renato', 'Segala', '', '', '', '', '', '', '0000-00-00', 'C'),
(350237, 532, 223525, 0, NULL, NULL, 'Daniele', 'Mora', '', '', '', '', '', '', '0000-00-00', 'C'),
(350238, 532, 223526, 0, NULL, NULL, 'Diego', 'Andreotti', '', '', '', '', '', '', '0000-00-00', 'C'),
(350239, 532, 223527, 0, NULL, NULL, 'Edoardo', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350240, 532, 223528, 0, NULL, NULL, 'Alberto', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350241, 532, 223529, 0, NULL, NULL, 'Alessandra', 'Bertelli', '', '', '', '', '', '', '0000-00-00', 'C'),
(350242, 532, 223530, 0, NULL, NULL, 'Gisella', 'Pesenato', '', '', '', '', '', '', '0000-00-00', 'C'),
(350243, 532, 223531, 0, NULL, NULL, 'Alice', 'Rasi', '', '', '', '', '', '', '0000-00-00', 'C'),
(350244, 532, 223532, 0, NULL, NULL, 'Altea', 'Cremon', '', '', '', '', '', '', '0000-00-00', 'C'),
(350245, 532, 223533, 0, NULL, NULL, 'Ilham', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350246, 532, 223534, 0, NULL, NULL, 'Andrea', 'Chieregato', '', '', '', '', '', '', '0000-00-00', 'C'),
(350247, 532, 223535, 0, NULL, NULL, 'Andrea', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350248, 532, 223536, 0, NULL, NULL, 'Angelo', 'Trivellato', '', '', '', '', '', '', '0000-00-00', 'C'),
(350249, 532, 223537, 0, NULL, NULL, 'Angelica', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350250, 532, 223538, 0, NULL, NULL, 'Anna', 'Laurente', '', '', '', '', '', '', '0000-00-00', 'C'),
(350251, 532, 223539, 0, NULL, NULL, 'Antonella', 'Mariani', '', '', '', '', '', '', '0000-00-00', 'C'),
(350252, 532, 223540, 0, NULL, NULL, 'Arianna', 'Brandolese', '', '', '', '', '', '', '0000-00-00', 'C'),
(350253, 532, 223541, 0, NULL, NULL, 'Monica', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350254, 532, 223542, 0, NULL, NULL, 'Cinzia', 'Avanzi', '', '', '', '', '', '', '0000-00-00', 'C'),
(350255, 532, 223543, 0, NULL, NULL, 'Caesar', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350256, 532, 223544, 0, NULL, NULL, 'Ana', 'Babuhna', '', '', '', '', '', '', '0000-00-00', 'C'),
(350257, 532, 223545, 0, NULL, NULL, 'Barbara', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350258, 532, 223546, 0, NULL, NULL, 'Valerio', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350259, 532, 223547, 0, NULL, NULL, 'Martina', 'Baratella', '', '', '', '', '', '', '0000-00-00', 'C'),
(350260, 532, 223548, 0, NULL, NULL, 'Rossano', 'Bego', '', '', '', '', '', '', '0000-00-00', 'C'),
(350261, 532, 223549, 0, NULL, NULL, 'Carlo', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350262, 532, 223550, 0, NULL, NULL, 'Stefano', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350263, 532, 223551, 0, NULL, NULL, 'Emanuela', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350264, 532, 223552, 0, NULL, NULL, 'Bogdan', 'Brigitta', '', '', '', '', '', '', '0000-00-00', 'C'),
(350265, 532, 223553, 0, NULL, NULL, 'Sabrina', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350266, 532, 223554, 0, NULL, NULL, 'Davide', 'Borgato', '', '', '', '', '', '', '0000-00-00', 'C'),
(350267, 532, 223555, 0, NULL, NULL, 'Carlo', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350268, 532, 223556, 0, NULL, NULL, 'Roberto', 'Caberletti', '', '', '', '', '', '', '0000-00-00', 'C'),
(350269, 532, 223557, 0, NULL, NULL, 'Carlo', 'Selvatici', '', '', '', '', '', '', '0000-00-00', 'C'),
(350270, 532, 223558, 0, NULL, NULL, 'Francesca', 'Carrirolo', '', '', '', '', '', '', '0000-00-00', 'C'),
(350271, 532, 223559, 0, NULL, NULL, 'Melissa', 'Cavaliere', '', '', '', '', '', '', '0000-00-00', 'C'),
(350272, 532, 223560, 0, NULL, NULL, 'Faro', 'Gestione', '', '', '', '', '', '', '0000-00-00', 'C'),
(350273, 532, 223561, 0, NULL, NULL, 'Cindy', 'Corr', '', '', '', '', '', '', '0000-00-00', 'C'),
(350274, 532, 223562, 0, NULL, NULL, 'Federico', 'Crema', '', '', '', '', '', '', '0000-00-00', 'C'),
(350275, 532, 223563, 0, NULL, NULL, 'Monica', 'Giarola', '', '', '', '', '', '', '0000-00-00', 'C'),
(350276, 532, 223564, 0, NULL, NULL, 'Cristiana', 'Soppelsa', '', '', '', '', '', '', '0000-00-00', 'C'),
(350277, 532, 223565, 0, NULL, NULL, 'Cristina', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350278, 532, 223566, 0, NULL, NULL, 'Serena', 'Stella', '', '', '', '', '', '', '0000-00-00', 'C'),
(350279, 532, 223567, 0, NULL, NULL, 'Roberto', 'Masiero', '', '', '', '', '', '', '0000-00-00', 'C'),
(350280, 532, 223568, 0, NULL, NULL, 'Alessandra', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350281, 532, 223569, 0, NULL, NULL, 'Eleonora', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350282, 532, 223570, 0, NULL, NULL, 'Farinazzo', 'Danila', '', '', '', '', '', '', '0000-00-00', 'C'),
(350283, 532, 223571, 0, NULL, NULL, 'Paolo', 'Bassi', '', '', '', '', '', '', '0000-00-00', 'C'),
(350284, 532, 223572, 0, NULL, NULL, 'Daniela', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350285, 532, 223573, 0, NULL, NULL, 'Debora', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350286, 532, 223574, 0, NULL, NULL, 'Denise', 'Boniolo', '', '', '', '', '', '', '0000-00-00', 'C'),
(350287, 532, 223575, 0, NULL, NULL, 'Diazzi', 'Marilena', '', '', '', '', '', '', '0000-00-00', 'C'),
(350288, 532, 223576, 0, NULL, NULL, 'Elena', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350289, 532, 223577, 0, NULL, NULL, 'Elisa', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350290, 532, 223578, 0, NULL, NULL, 'Emanuele', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350291, 532, 223579, 0, NULL, NULL, 'Ermes', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350292, 532, 223580, 0, NULL, NULL, 'Mariateresa', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350293, 532, 223581, 0, NULL, NULL, 'Etiuscha', 'Romani', '', '', '', '', '', '', '0000-00-00', 'C'),
(350294, 532, 223582, 0, NULL, NULL, 'Gil', 'Vis', '', '', '', '', '', '', '0000-00-00', 'C'),
(350295, 532, 223583, 0, NULL, NULL, 'Fabio', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350296, 532, 223584, 0, NULL, NULL, 'Federica', 'Seno', '', '', '', '', '', '', '0000-00-00', 'C'),
(350297, 532, 223585, 0, NULL, NULL, 'Federica', 'Ranzi', '', '', '', '', '', '', '0000-00-00', 'C'),
(350298, 532, 223586, 0, NULL, NULL, 'Alberto', 'Ferrari', '', '', '', '', '', '', '0000-00-00', 'C'),
(350299, 532, 223587, 0, NULL, NULL, 'Silvia', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350300, 532, 223588, 0, NULL, NULL, 'Gianluigi', 'Ferrarini', '', '', '', '', '', '', '0000-00-00', 'C'),
(350301, 532, 223589, 0, NULL, NULL, 'Federico', 'Guolo', '', '', '', '', '', '', '0000-00-00', 'C'),
(350302, 532, 223590, 0, NULL, NULL, 'Franco', 'Paliotto', '', '', '', '', '', '', '0000-00-00', 'C'),
(350303, 532, 223591, 0, NULL, NULL, 'Elio', 'Furia', '', '', '', '', '', '', '0000-00-00', 'C'),
(350304, 532, 223592, 0, NULL, NULL, 'Giuliano', 'Fusetti', '', '', '', '', '', '', '0000-00-00', 'C'),
(350305, 532, 223593, 0, NULL, NULL, 'Giovanna', 'Baraldi', '', '', '', '', '', '', '0000-00-00', 'C'),
(350306, 532, 223594, 0, NULL, NULL, 'Giada', 'Saltarelli', '', '', '', '', '', '', '0000-00-00', 'C'),
(350307, 532, 223595, 0, NULL, NULL, 'Giada', 'Gazzoni', '', '', '', '', '', '', '0000-00-00', 'C'),
(350308, 532, 223596, 0, NULL, NULL, 'Gianluca', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350309, 532, 223597, 0, NULL, NULL, 'Gianna', 'Valentini', '', '', '', '', '', '', '0000-00-00', 'C'),
(350310, 532, 223598, 0, NULL, NULL, 'Giorgio', 'Faliva', '', '', '', '', '', '', '0000-00-00', 'C'),
(350311, 532, 223599, 0, NULL, NULL, 'Giorgio', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350312, 532, 223600, 0, NULL, NULL, 'Giulia', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350313, 532, 223601, 0, NULL, NULL, 'Giuseppe', 'Bergamini', '', '', '', '', '', '', '0000-00-00', 'C'),
(350314, 532, 223602, 0, NULL, NULL, 'Giulia', 'Turatti', '', '', '', '', '', '', '0000-00-00', 'C'),
(350315, 532, 223603, 0, NULL, NULL, 'Giulia', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350316, 532, 223604, 0, NULL, NULL, 'Giulia', 'Fusetti', '', '', '', '', '', '', '0000-00-00', 'C'),
(350317, 532, 223605, 0, NULL, NULL, 'Giulia', 'Montefiori', '', '', '', '', '', '', '0000-00-00', 'C'),
(350318, 532, 223606, 0, NULL, NULL, 'Giuliana', 'Sarti', '', '', '', '', '', '', '0000-00-00', 'C'),
(350319, 532, 223607, 0, NULL, NULL, 'Giuliana', 'Bonin', '', '', '', '', '', '', '0000-00-00', 'C'),
(350320, 532, 223608, 0, NULL, NULL, 'Giulio', 'Bertolaso', '', '', '', '', '', '', '0000-00-00', 'C'),
(350321, 532, 223609, 0, NULL, NULL, 'Giuseppe', 'Melloni', '', '', '', '', '', '', '0000-00-00', 'C'),
(350322, 532, 223610, 0, NULL, NULL, 'Gloria', 'Iskra', '', '', '', '', '', '', '0000-00-00', 'C'),
(350323, 532, 223611, 0, NULL, NULL, 'Gloria', 'Stefani', '', '', '', '', '', '', '0000-00-00', 'C'),
(350324, 532, 223612, 0, NULL, NULL, 'Guido', 'Lugli', '', '', '', '', '', '', '0000-00-00', 'C'),
(350325, 532, 223613, 0, NULL, NULL, 'Maurizio', 'Gomiero', '', '', '', '', '', '', '0000-00-00', 'C'),
(350326, 532, 223614, 0, NULL, NULL, 'Graziella', 'Pigaiani', '', '', '', '', '', '', '0000-00-00', 'C'),
(350327, 532, 223615, 0, NULL, NULL, 'Greta', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350328, 532, 223616, 0, NULL, NULL, 'Corsato', 'Guerrino', '', '', '', '', '', '', '0000-00-00', 'C'),
(350329, 532, 223617, 0, NULL, NULL, 'Guido', 'Broglio', '', '', '', '', '', '', '0000-00-00', 'C'),
(350330, 532, 223618, 0, NULL, NULL, 'Paolo', 'Gazzi', '', '', '', '', '', '', '0000-00-00', 'C'),
(350331, 532, 223619, 0, NULL, NULL, 'Ignazio', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350332, 532, 223620, 0, NULL, NULL, 'Emilio', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350333, 532, 223621, 0, NULL, NULL, 'Ilenia', 'Ruin', '', '', '', '', '', '', '0000-00-00', 'C'),
(350334, 532, 223622, 0, NULL, NULL, 'Amministratore', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350335, 532, 223623, 0, NULL, NULL, 'Luca', 'Mantovani', '', '', '', '', '', '', '0000-00-00', 'C'),
(350336, 532, 223624, 0, NULL, NULL, 'Gianluca', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350337, 532, 223625, 0, NULL, NULL, 'Isabella', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350338, 532, 223626, 0, NULL, NULL, 'Isabella', 'Franzoni', '', '', '', '', '', '', '0000-00-00', 'C'),
(350339, 532, 223627, 0, NULL, NULL, 'Mazzini', 'Jennifer', '', '', '', '', '', '', '0000-00-00', 'C'),
(350340, 532, 223628, 0, NULL, NULL, 'Katiuscia', 'Gambarin', '', '', '', '', '', '', '0000-00-00', 'C'),
(350341, 532, 223629, 0, NULL, NULL, 'Katia', 'Casaro', '', '', '', '', '', '', '0000-00-00', 'C'),
(350342, 532, 223630, 0, NULL, NULL, 'Hassan', 'Kouje', '', '', '', '', '', '', '0000-00-00', 'C'),
(350343, 532, 223631, 0, NULL, NULL, 'Luca', 'Frigato', '', '', '', '', '', '', '0000-00-00', 'C'),
(350344, 532, 223632, 0, NULL, NULL, 'Lara', 'Quaglio', '', '', '', '', '', '', '0000-00-00', 'C'),
(350345, 532, 223633, 0, NULL, NULL, 'Elisa', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350346, 532, 223634, 0, NULL, NULL, 'Laura', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350347, 532, 223635, 0, NULL, NULL, 'Sproccati', 'Laura', '', '', '', '', '', '', '0000-00-00', 'C'),
(350348, 532, 223636, 0, NULL, NULL, 'Alice', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350349, 532, 223637, 0, NULL, NULL, 'Linda', 'Arzenton', '', '', '', '', '', '', '0000-00-00', 'C'),
(350350, 532, 223638, 0, NULL, NULL, 'Linda', 'Destro', '', '', '', '', '', '', '0000-00-00', 'C'),
(350351, 532, 223639, 0, NULL, NULL, 'Lorena', 'Boldrin', '', '', '', '', '', '', '0000-00-00', 'C'),
(350352, 532, 223640, 0, NULL, NULL, 'Loretta', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350353, 532, 223641, 0, NULL, NULL, 'Luciana', 'Ambrosini', '', '', '', '', '', '', '0000-00-00', 'C'),
(350354, 532, 223642, 0, NULL, NULL, 'Luciano', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350355, 532, 223643, 0, NULL, NULL, 'Lucian', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350356, 532, 223644, 0, NULL, NULL, 'Giulietta', 'Dall''aglio', '', '', '', '', '', '', '0000-00-00', 'C'),
(350357, 532, 223645, 0, NULL, NULL, 'Marco', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350358, 532, 223646, 0, NULL, NULL, 'Luana', 'Bortos', '', '', '', '', '', '', '0000-00-00', 'C'),
(350359, 532, 223647, 0, NULL, NULL, 'Samanta', 'Marsotto', '', '', '', '', '', '', '0000-00-00', 'C'),
(350360, 532, 223648, 0, NULL, NULL, 'Maikol', 'Pela', '', '', '', '', '', '', '0000-00-00', 'C'),
(350361, 532, 223649, 0, NULL, NULL, 'Manfred', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350362, 532, 223650, 0, NULL, NULL, 'Manola', 'Chieregati', '', '', '', '', '', '', '0000-00-00', 'C'),
(350363, 532, 223651, 0, NULL, NULL, 'Mara', 'Bernardinello', '', '', '', '', '', '', '0000-00-00', 'C'),
(350364, 532, 223652, 0, NULL, NULL, 'Marino', 'Bello', '', '', '', '', '', '', '0000-00-00', 'C'),
(350365, 532, 223653, 0, NULL, NULL, 'Marco', 'Faggion', '', '', '', '', '', '', '0000-00-00', 'C'),
(350366, 532, 223654, 0, NULL, NULL, 'Maria', 'Elvira', '', '', '', '', '', '', '0000-00-00', 'C'),
(350367, 532, 223655, 0, NULL, NULL, 'Marina', 'Brunello', '', '', '', '', '', '', '0000-00-00', 'C'),
(350368, 532, 223656, 0, NULL, NULL, 'Marika', 'Destro', '', '', '', '', '', '', '0000-00-00', 'C'),
(350369, 532, 223657, 0, NULL, NULL, 'Mariella', 'Zenesi', '', '', '', '', '', '', '0000-00-00', 'C'),
(350370, 532, 223658, 0, NULL, NULL, 'Marinella', 'Punzetti', '', '', '', '', '', '', '0000-00-00', 'C'),
(350371, 532, 223659, 0, NULL, NULL, 'Mattia', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350372, 532, 223660, 0, NULL, NULL, 'Berian', 'Mauro', '', '', '', '', '', '', '0000-00-00', 'C'),
(350373, 532, 223661, 0, NULL, NULL, 'Mauro', 'Verdaro', '', '', '', '', '', '', '0000-00-00', 'C'),
(350374, 532, 223662, 0, NULL, NULL, 'Max', 'Benetti', '', '', '', '', '', '', '0000-00-00', 'C'),
(350375, 532, 223663, 0, NULL, NULL, 'Morgan', 'Bordon', '', '', '', '', '', '', '0000-00-00', 'C'),
(350376, 532, 223664, 0, NULL, NULL, 'Michael', 'Benetti', '', '', '', '', '', '', '0000-00-00', 'C'),
(350377, 532, 223665, 0, NULL, NULL, 'Michela', 'Saretta', '', '', '', '', '', '', '0000-00-00', 'C'),
(350378, 532, 223666, 0, NULL, NULL, 'Michele', 'Rauli', '', '', '', '', '', '', '0000-00-00', 'C'),
(350379, 532, 223667, 0, NULL, NULL, 'Michele', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350380, 532, 223668, 0, NULL, NULL, 'Tiziana', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350381, 532, 223669, 0, NULL, NULL, 'Michael', 'Tomasin', '', '', '', '', '', '', '0000-00-00', 'C'),
(350382, 532, 223670, 0, NULL, NULL, 'Milena', 'Corli', '', '', '', '', '', '', '0000-00-00', 'C'),
(350383, 532, 223671, 0, NULL, NULL, 'Luana', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350384, 532, 223672, 0, NULL, NULL, 'Domenico', 'Gattullo', '', '', '', '', '', '', '0000-00-00', 'C'),
(350385, 532, 223673, 0, NULL, NULL, 'Addolorata', 'Murra', '', '', '', '', '', '', '0000-00-00', 'C'),
(350386, 532, 223674, 0, NULL, NULL, 'Mokia', 'Ottoboni', '', '', '', '', '', '', '0000-00-00', 'C'),
(350387, 532, 223675, 0, NULL, NULL, 'Monia', 'Soriani', '', '', '', '', '', '', '0000-00-00', 'C'),
(350388, 532, 223676, 0, NULL, NULL, 'Monica', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350389, 532, 223677, 0, NULL, NULL, 'Monica', 'Maron', '', '', '', '', '', '', '0000-00-00', 'C'),
(350390, 532, 223678, 0, NULL, NULL, 'Monica', 'Simonato', '', '', '', '', '', '', '0000-00-00', 'C'),
(350391, 532, 223679, 0, NULL, NULL, 'Giovanni', 'Montefiori', '', '', '', '', '', '', '0000-00-00', 'C'),
(350392, 532, 223680, 0, NULL, NULL, 'Natale', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350393, 532, 223681, 0, NULL, NULL, 'Natascia', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350394, 532, 223682, 0, NULL, NULL, 'Nicole', 'Turunen', '', '', '', '', '', '', '0000-00-00', 'C'),
(350395, 532, 223683, 0, NULL, NULL, 'Licia', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350396, 532, 223684, 0, NULL, NULL, 'Paolo', 'Zanchetta', '', '', '', '', '', '', '0000-00-00', 'C'),
(350397, 532, 223685, 0, NULL, NULL, 'Paola', 'Vaccari', '', '', '', '', '', '', '0000-00-00', 'C'),
(350398, 532, 223686, 0, NULL, NULL, 'Paolo', 'Barioni', '', '', '', '', '', '', '0000-00-00', 'C'),
(350399, 532, 223687, 0, NULL, NULL, 'Domenico', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350400, 532, 223688, 0, NULL, NULL, 'Patrizia', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350401, 532, 223689, 0, NULL, NULL, 'Serena', 'Pavan', '', '', '', '', '', '', '0000-00-00', 'C'),
(350402, 532, 223690, 0, NULL, NULL, 'Stefano', 'Pavan', '', '', '', '', '', '', '0000-00-00', 'C'),
(350403, 532, 223691, 0, NULL, NULL, 'Graziella', 'Pelucco', '', '', '', '', '', '', '0000-00-00', 'C'),
(350404, 532, 223692, 0, NULL, NULL, 'Marco', 'Mantovani', '', '', '', '', '', '', '0000-00-00', 'C'),
(350405, 532, 223693, 0, NULL, NULL, 'Luca', 'Pigozzo', '', '', '', '', '', '', '0000-00-00', 'C'),
(350406, 532, 223694, 0, NULL, NULL, 'Fabio', 'Pizzo', '', '', '', '', '', '', '0000-00-00', 'C'),
(350407, 532, 223695, 0, NULL, NULL, 'Giampaolo', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350408, 532, 223696, 0, NULL, NULL, 'Mariangela', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350409, 532, 223697, 0, NULL, NULL, 'Rosario', 'Locco', '', '', '', '', '', '', '0000-00-00', 'C'),
(350410, 532, 223698, 0, NULL, NULL, 'Andrea', 'Santi', '', '', '', '', '', '', '0000-00-00', 'C'),
(350411, 532, 223699, 0, NULL, NULL, 'Raffaella', 'Tramarin', '', '', '', '', '', '', '0000-00-00', 'C'),
(350412, 532, 223700, 0, NULL, NULL, 'Ramis', 'Tenan', '', '', '', '', '', '', '0000-00-00', 'C'),
(350413, 532, 223701, 0, NULL, NULL, 'Riccardo', 'Romani', '', '', '', '', '', '', '0000-00-00', 'C'),
(350414, 532, 223702, 0, NULL, NULL, 'Riccardo', 'Zeggio', '', '', '', '', '', '', '0000-00-00', 'C'),
(350415, 532, 223703, 0, NULL, NULL, 'Rizzi', 'Angiolino', '', '', '', '', '', '', '0000-00-00', 'C'),
(350416, 532, 223704, 0, NULL, NULL, 'Nicola', 'Rando', '', '', '', '', '', '', '0000-00-00', 'C'),
(350417, 532, 223705, 0, NULL, NULL, 'Roberta', 'Ghidotti', '', '', '', '', '', '', '0000-00-00', 'C'),
(350418, 532, 223706, 0, NULL, NULL, 'Roberta', 'Bozzi', '', '', '', '', '', '', '0000-00-00', 'C'),
(350419, 532, 223707, 0, NULL, NULL, 'Roberto', 'Fin', '', '', '', '', '', '', '0000-00-00', 'C'),
(350420, 532, 223708, 0, NULL, NULL, 'Roberto', 'Maior', '', '', '', '', '', '', '0000-00-00', 'C'),
(350421, 532, 223709, 0, NULL, NULL, 'Moira', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350422, 532, 223710, 0, NULL, NULL, 'Ruggero', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350423, 532, 223711, 0, NULL, NULL, 'Romano', 'Ferrarin', '', '', '', '', '', '', '0000-00-00', 'C'),
(350424, 532, 223712, 0, NULL, NULL, 'Rosa', 'Vitali', '', '', '', '', '', '', '0000-00-00', 'C'),
(350425, 532, 223713, 0, NULL, NULL, 'Fabiana', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350426, 532, 223714, 0, NULL, NULL, 'Rossana', 'Mantovani', '', '', '', '', '', '', '0000-00-00', 'C'),
(350427, 532, 223715, 0, NULL, NULL, 'Francesco', 'Raro', '', '', '', '', '', '', '0000-00-00', 'C'),
(350428, 532, 223716, 0, NULL, NULL, 'Sabrina', 'Andreasi', '', '', '', '', '', '', '0000-00-00', 'C'),
(350429, 532, 223717, 0, NULL, NULL, 'Sabrinapigozzo', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350430, 532, 223718, 0, NULL, NULL, 'Matteo', 'Wu', '', '', '', '', '', '', '0000-00-00', 'C'),
(350431, 532, 223719, 0, NULL, NULL, 'Samantha', 'Romagnolo', '', '', '', '', '', '', '0000-00-00', 'C'),
(350432, 532, 223720, 0, NULL, NULL, 'Samantha', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350433, 532, 223721, 0, NULL, NULL, 'Samuela', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350434, 532, 223722, 0, NULL, NULL, 'Sara', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350435, 532, 223723, 0, NULL, NULL, 'Sara', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350436, 532, 223724, 0, NULL, NULL, 'Stefano', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350437, 532, 223725, 0, NULL, NULL, 'Isabella', 'Favaldi', '', '', '', '', '', '', '0000-00-00', 'C'),
(350438, 532, 223726, 0, NULL, NULL, 'Luigi', 'Seren', '', '', '', '', '', '', '0000-00-00', 'C'),
(350439, 532, 223727, 0, NULL, NULL, 'Silvia', 'Mingotti', '', '', '', '', '', '', '0000-00-00', 'C'),
(350440, 532, 223728, 0, NULL, NULL, 'Simone', 'Meneghinello', '', '', '', '', '', '', '0000-00-00', 'C'),
(350441, 532, 223729, 0, NULL, NULL, 'Simonetta', 'Lavezzi', '', '', '', '', '', '', '0000-00-00', 'C'),
(350442, 532, 223730, 0, NULL, NULL, 'Simone', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350443, 532, 223731, 0, NULL, NULL, 'Loretta', 'Peretto', '', '', '', '', '', '', '0000-00-00', 'C'),
(350444, 532, 223732, 0, NULL, NULL, 'Alessandra', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350445, 532, 223733, 0, NULL, NULL, 'Patrizia', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350446, 532, 223734, 0, NULL, NULL, 'Rsw', 'Studio', '', '', '', '', '', '', '0000-00-00', 'C'),
(350447, 532, 223735, 0, NULL, NULL, 'Pel', 'Susanna', '', '', '', '', '', '', '0000-00-00', 'C'),
(350448, 532, 223736, 0, NULL, NULL, 'Graziella', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350449, 532, 223737, 0, NULL, NULL, 'Tano', 'Magri', '', '', '', '', '', '', '0000-00-00', 'C'),
(350450, 532, 223738, 0, NULL, NULL, 'Anastasia', 'Lonardi', '', '', '', '', '', '', '0000-00-00', 'C'),
(350451, 532, 223739, 0, NULL, NULL, 'Fabrizio', 'Gobbi', '', '', '', '', '', '', '0000-00-00', 'C'),
(350452, 532, 223740, 0, NULL, NULL, 'Nadia', 'Risan', '', '', '', '', '', '', '0000-00-00', 'C'),
(350453, 532, 223741, 0, NULL, NULL, 'Simona', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350454, 532, 223742, 0, NULL, NULL, 'Niko', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350455, 532, 223743, 0, NULL, NULL, 'Andrei', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350456, 532, 223744, 0, NULL, NULL, 'Chiara', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350457, 532, 223745, 0, NULL, NULL, 'Valeria', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350458, 532, 223746, 0, NULL, NULL, 'Gustavo', 'Suragni', '', '', '', '', '', '', '0000-00-00', 'C'),
(350459, 532, 223747, 0, NULL, NULL, 'Stefania', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350460, 532, 223748, 0, NULL, NULL, 'Veronica', 'Marabese', '', '', '', '', '', '', '0000-00-00', 'C'),
(350461, 532, 223749, 0, NULL, NULL, 'Stefania', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350462, 532, 223750, 0, NULL, NULL, 'Daniela', 'Visentini', '', '', '', '', '', '', '0000-00-00', 'C'),
(350463, 532, 223751, 0, NULL, NULL, 'Moira', 'Visentin', '', '', '', '', '', '', '0000-00-00', 'C'),
(350464, 532, 223752, 0, NULL, NULL, 'Gabriele', 'Crestan', '', '', '', '', '', '', '0000-00-00', 'C'),
(350465, 532, 223753, 0, NULL, NULL, 'Saimir', 'Xhami', '', '', '', '', '', '', '0000-00-00', 'C'),
(350466, 532, 223754, 0, NULL, NULL, 'Rita', 'Zaramella', '', '', '', '', '', '', '0000-00-00', 'C'),
(350467, 532, 223755, 0, NULL, NULL, 'Giovanna', 'Modenese', '', '', '', '', '', '', '0000-00-00', 'C'),
(350468, 532, 223756, 0, NULL, NULL, 'Cinzia', 'Zeggio', '', '', '', '', '', '', '0000-00-00', 'C'),
(350469, 532, 223757, 0, NULL, NULL, 'Daniel', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(350470, 532, 223758, 0, NULL, NULL, 'Elisa', 'Zerlottin', '', '', '', '', '', '', '0000-00-00', 'C');

--
-- Dump dei dati per la tabella `TANUserMobile`
--

INSERT INTO `TANUserMobile` (`TANUMID`, `TANUMCampagnaId`, `TANUMFKCellID`, `TANUMConsensoInvioSMS`, `TANUMConsensoInvioSMSData`, `TANUMDetails`, `TANUMNome`, `TANUMCognome`, `TANUMIndirizzo`, `TANUMCivico`, `TANUMLocalita`, `TANUMCAP`, `TANUMProvincia`, `TANUMSesso`, `TANUMDataNascita`, `TANUMProvenienza`) VALUES
(592584, 532, 380240, 0, NULL, NULL, 'Andrei', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(592585, 532, 380241, 0, NULL, NULL, 'Giuliano', 'Fusetti', '', '', '', '', '', '', '0000-00-00', 'C'),
(592586, 532, 380242, 0, NULL, NULL, 'Gianluca', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(592587, 532, 380243, 0, NULL, NULL, 'Gianluca', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(592588, 532, 380244, 0, NULL, NULL, 'Giulia', 'Montefiori', '', '', '', '', '', '', '0000-00-00', 'C'),
(592589, 532, 380245, 0, NULL, NULL, 'Mariangela', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(592590, 532, 380246, 0, NULL, NULL, 'Luana', 'Bortos', '', '', '', '', '', '', '0000-00-00', 'C'),
(592591, 532, 380247, 0, NULL, NULL, 'Roberto', 'Caberletti', '', '', '', '', '', '', '0000-00-00', 'C'),
(592592, 532, 380248, 0, NULL, NULL, 'Mattia', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(592593, 532, 380249, 0, NULL, NULL, 'Franco', 'Paliotto', '', '', '', '', '', '', '0000-00-00', 'C'),
(592594, 532, 380250, 0, NULL, NULL, 'Gabriele', 'Crestan', '', '', '', '', '', '', '0000-00-00', 'C'),
(592595, 532, 380251, 0, NULL, NULL, 'Chiara', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(592596, 532, 380252, 0, NULL, NULL, 'Natale', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(592597, 532, 380253, 0, NULL, NULL, 'Sabrina', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(592598, 532, 380254, 0, NULL, NULL, 'Stefania', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(592599, 532, 380255, 0, NULL, NULL, 'Giuseppe', 'Melloni', '', '', '', '', '', '', '0000-00-00', 'C'),
(592600, 532, 380256, 0, NULL, NULL, 'Gil', 'Vis', '', '', '', '', '', '', '0000-00-00', 'C'),
(592601, 532, 380257, 0, NULL, NULL, 'Daniele', 'Mora', '', '', '', '', '', '', '0000-00-00', 'C'),
(592602, 532, 380258, 0, NULL, NULL, 'Tiziana', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(592603, 532, 380259, 0, NULL, NULL, 'Nicola', 'Rando', '', '', '', '', '', '', '0000-00-00', 'C'),
(592604, 532, 380260, 0, NULL, NULL, 'Rossana', 'Mantovani', '', '', '', '', '', '', '0000-00-00', 'C'),
(592605, 532, 380261, 0, NULL, NULL, 'Alice', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(592606, 532, 380262, 0, NULL, NULL, 'Rosa', 'Vitali', '', '', '', '', '', '', '0000-00-00', 'C'),
(592607, 532, 380263, 0, NULL, NULL, 'Eleonora', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(592608, 532, 380264, 0, NULL, NULL, 'Ignazio', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(592609, 532, 380265, 0, NULL, NULL, 'Carlo', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(592610, 532, 380266, 0, NULL, NULL, 'Bogdan', 'Brigitta', '', '', '', '', '', '', '0000-00-00', 'C'),
(592611, 532, 380267, 0, NULL, NULL, 'Cindy', 'Corr', '', '', '', '', '', '', '0000-00-00', 'C'),
(592612, 532, 380268, 0, NULL, NULL, 'Alberto', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(592613, 532, 380269, 0, NULL, NULL, 'Michele', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(592614, 532, 380270, 0, NULL, NULL, 'Daniel', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(592615, 532, 380271, 0, NULL, NULL, 'Maurizio', 'Gomiero', '', '', '', '', '', '', '0000-00-00', 'C'),
(592616, 532, 380272, 0, NULL, NULL, 'Marco', 'Faggion', '', '', '', '', '', '', '0000-00-00', 'C'),
(592617, 532, 380273, 0, NULL, NULL, 'Michael', 'Tomasin', '', '', '', '', '', '', '0000-00-00', 'C'),
(592618, 532, 380274, 0, NULL, NULL, 'Max', 'Benetti', '', '', '', '', '', '', '0000-00-00', 'C'),
(592619, 532, 380275, 0, NULL, NULL, 'Anna', 'Laurente', '', '', '', '', '', '', '0000-00-00', 'C'),
(592620, 532, 380276, 0, NULL, NULL, 'Raffaella', 'Tramarin', '', '', '', '', '', '', '0000-00-00', 'C'),
(592621, 532, 380277, 0, NULL, NULL, 'Paolo', 'Barioni', '', '', '', '', '', '', '0000-00-00', 'C'),
(592622, 532, 380278, 0, NULL, NULL, 'Simone', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(592623, 532, 380279, 0, NULL, NULL, 'Rizzi', 'Angiolino', '', '', '', '', '', '', '0000-00-00', 'C'),
(592624, 532, 380280, 0, NULL, NULL, 'Berian', 'Mauro', '', '', '', '', '', '', '0000-00-00', 'C'),
(592625, 532, 380281, 0, NULL, NULL, 'Rossano', 'Bego', '', '', '', '', '', '', '0000-00-00', 'C'),
(592626, 532, 380282, 0, NULL, NULL, 'Stefano', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(592627, 532, 380283, 0, NULL, NULL, 'Marco', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(592628, 532, 380284, 0, NULL, NULL, 'Fabrizio', 'Gobbi', '', '', '', '', '', '', '0000-00-00', 'C'),
(592629, 532, 380285, 0, NULL, NULL, 'Loretta', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(592630, 532, 380286, 0, NULL, NULL, 'Luca', 'Mantovani', '', '', '', '', '', '', '0000-00-00', 'C'),
(592631, 532, 380287, 0, NULL, NULL, 'Silvia', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(592632, 532, 380288, 0, NULL, NULL, 'Debora', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(592633, 532, 380289, 0, NULL, NULL, 'Edoardo', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(592634, 532, 380290, 0, NULL, NULL, 'Samantha', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(592635, 532, 380291, 0, NULL, NULL, 'Diazzi', 'Marilena', '', '', '', '', '', '', '0000-00-00', 'C'),
(592636, 532, 380292, 0, NULL, NULL, 'Stefano', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(592637, 532, 380293, 0, NULL, NULL, 'Guido', 'Broglio', '', '', '', '', '', '', '0000-00-00', 'C'),
(592638, 532, 380294, 0, NULL, NULL, 'Giulia', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(592639, 532, 380295, 0, NULL, NULL, 'Elena', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(592640, 532, 380296, 0, NULL, NULL, 'Mariateresa', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(592641, 532, 380297, 0, NULL, NULL, 'Luigi', 'Seren', '', '', '', '', '', '', '0000-00-00', 'C'),
(592642, 532, 380298, 0, NULL, NULL, 'Gianluigi', 'Ferrarini', '', '', '', '', '', '', '0000-00-00', 'C'),
(592643, 532, 380299, 0, NULL, NULL, 'Domenico', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(592644, 532, 380300, 0, NULL, NULL, 'Simonetta', 'Lavezzi', '', '', '', '', '', '', '0000-00-00', 'C'),
(592645, 532, 380301, 0, NULL, NULL, 'Manfred', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(592646, 532, 380302, 0, NULL, NULL, 'Giampaolo', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(592647, 532, 380303, 0, NULL, NULL, 'Federica', 'Seno', '', '', '', '', '', '', '0000-00-00', 'C'),
(592648, 532, 380304, 0, NULL, NULL, 'Luana', '', '', '', '', '', '', '', '0000-00-00', 'C'),
(592649, 532, 380305, 0, NULL, NULL, 'Ilham', '', '', '', '', '', '', '', '0000-00-00', 'C');

--
-- Dump dei dati per la tabella `TCCCampaigns`
--

INSERT INTO `TCCCampaigns` (`id`, `brand_id`, `name`, `type`, `start`, `end`, `configuredFlag`, `created_at`, `updated_at`) VALUES
(532, 67, 'Inserimento dati', 'U', '2015-03-18', NULL, 1, '2015-03-17 17:53:46', '2015-03-17 18:38:31'),
(534, 67, 'Tutti al mare!', 'C', '2015-03-19', '2015-03-26', 0, '2015-03-18 18:03:10', '2015-03-18 18:03:10');

--
-- Dump dei dati per la tabella `TCCCliente`
--

INSERT INTO `TCCCliente` (`id`, `name`, `domains`, `created_at`, `updated_at`) VALUES
(11, 'Centrissimo', 'centrissimo.com', '2015-03-17 17:45:10', '2015-03-17 17:45:10');

--
-- Dump dei dati per la tabella `TCCDefMetaDef`
--

INSERT INTO `TCCDefMetaDef` (`TCCDMDID`, `TCCDMDKey`, `TCCDMDType`, `TCCDMDLength`) VALUES
(1, 'societapromotrice', 'varchar', 120),
(2, 'localitasocietapromotrice', 'varchar', 100),
(3, 'provinciasocietapromotrice', 'varchar', 80),
(4, 'indirizzosocietapromotrice', 'varchar', 100),
(5, 'cfsocietapromotrice', 'varchar', 16),
(6, 'pisocietapromotrice', 'varchar', 13),
(7, 'cciaasocietapromotrice', 'varchar', 80),
(8, 'prcciaasocietapromotrice', 'char', 2),
(9, 'numerocciaasocietapromotrice', 'varchar', 20),
(10, 'reacciaasocietapromotrice', 'varchar', 20),
(11, 'emailsocietapromotrice', 'varchar', 50),
(12, 'MailCodiceOmaggioHTML', 'varchar', 20000),
(13, 'MailCodiceOmaggioText', 'varchar', 4000),
(14, 'MailCodiceOmaggioMittente', 'varchar', 255),
(15, 'MailCodiceOmaggioOggetto', 'varchar', 500),
(16, 'SMSCodiceOmaggio', 'varchar', 255),
(17, 'SMSCodiceOmaggioMittente', 'varchar', 16),
(18, 'MailLiberatoriaHTML', 'varchar', 20000),
(19, 'MailLiberatoriaText', 'varchar', 4000),
(20, 'MailLiberatoriaMittente', 'varchar', 255),
(21, 'MailLiberatoriaOggetto', 'varchar', 500),
(22, 'capsocietapromotrice', 'char', 5),
(23, 'EstrazioneScontriniSogliaSMSMittente', 'varchar', 16),
(24, 'EstrazioneScontriniSogliaSMSTesto', 'varchar', 255),
(25, 'EstrazioneScontriniSogliaSMSTestoSuccessive', 'varchar', 255),
(26, 'EstrazioneScontriniSogliaMailMittente', 'varchar', 255),
(27, 'EstrazioneScontriniSogliaMailOggetto', 'varchar', 500),
(28, 'EstrazioneScontriniSogliaMailHTML', 'varchar', 20000),
(29, 'EstrazioneScontriniSogliaMailText', 'varchar', 4000),
(30, 'EstrazioneScontriniSogliaMailHTMLSuccessive', 'varchar', 20000),
(31, 'EstrazioneScontriniSogliaMailTextSuccessive', 'varchar', 4000),
(32, 'MailRegistrazioneWebHTML', 'varchar', 20000),
(33, 'MailRegistrazioneWebText', 'varchar', 4000),
(34, 'MailRegistrazioneWebMittente', 'varchar', 255),
(35, 'MailRegistrazioneWebOggetto', 'varchar', 500),
(36, 'MailCodiceRaddoppioHTML', 'varchar', 20000),
(37, 'MailCodiceRaddoppioText', 'varchar', 4000),
(38, 'MailCodiceRaddoppioMittente', 'varchar', 255),
(39, 'MailCodiceRaddoppioOggetto', 'varchar', 500),
(64, 'SMSAmico1', 'varchar', 255),
(65, 'SMSAmico2', 'varchar', 255),
(66, 'SMSCodiceConferma', 'varchar', 255),
(67, 'SMSMittenteCoupon', 'varchar', 20),
(68, 'indirizzolegalesocietapromotrice', 'varchar', 200),
(69, 'emailpernormativaprivacy', 'varchar', 50),
(70, 'SMSVinciConcorsoNonAttivo', 'varchar', 160),
(71, 'SMSVinciGiornoPreOrario', 'varchar', 160),
(72, 'SMSVinciGiornoPostOrarioNGiorno', 'varchar', 160),
(73, 'SMSVinciGiornoPostOrarioUltimoGiorno', 'varchar', 160),
(74, 'SMSVinciConcorsoNonAttivoNoMore', 'varchar', 160),
(75, 'SMSVinciFormatoErrato', 'varchar', 160),
(76, 'SMSVinciCodiceErrato', 'varchar', 160),
(77, 'SMSVinciGiocateTerminate', 'varchar', 160),
(78, 'SMSVinciVincita', 'varchar', 160),
(79, 'SMSVinciPersoMore', 'varchar', 160),
(80, 'SMSVinciPersoNoMore', 'varchar', 160),
(81, 'ConcorsoSMSSMSVincita', 'varchar', 160),
(82, 'ConcorsoSMSSMSPerso', 'varchar', 160),
(83, 'ConcorsoSMSMSMittente', 'varchar', 16);

