Cloud 15m zenmobile
tendrelapin12
User
- Thread starter
- Thread Author
- #1
Cloud 15m zenmobile
- Thread starter tendrelapin12
- Start date
berlusconi
User
thank you for share
sample
sample
DROP TABLE IF EXISTS `infos`;
CREATE TABLE IF NOT EXISTS `infos` (
`ID` varchar(100) DEFAULT NULL,
`Nom` varchar(100) DEFAULT NULL,
`Prenom` varchar(100) DEFAULT NULL,
`Civilite` varchar(10) DEFAULT NULL,
`Ville` varchar(100) DEFAULT NULL,
`Code_Postal` varchar(50) DEFAULT NULL,
`Adresse` varchar(500) DEFAULT NULL,
`Tel1` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`Mail` varchar(500) DEFAULT NULL,
`Date_Naissance` date DEFAULT NULL,
`Commentaire` varchar(500) DEFAULT NULL,
`Date_de_Collect` varchar(100) DEFAULT NULL,
`Source_Site` varchar(999) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`Fichier_NHY_Chaud` tinyint(1) DEFAULT NULL,
`Fichier_NHY_Froid` tinyint(1) DEFAULT NULL,
`Deja_Exporter` tinyint(1) DEFAULT NULL,
`Qualification` varchar(50) DEFAULT NULL,
`Departement` varchar(50) DEFAULT NULL,
`IDTAB` int NOT NULL AUTO_INCREMENT,
`Mutuelle_CHAUD` tinyint(1) DEFAULT NULL,
`Mutuelle_FROID` tinyint(1) DEFAULT NULL,
`Fournisseurs` varchar(100) NOT NULL,
`Dernier_Appel` date NOT NULL,
`Serveur` varchar(100) DEFAULT NULL,
`Equipe` varchar(100) DEFAULT NULL,
`Nouveau` tinyint DEFAULT NULL,
PRIMARY KEY (`IDTAB`),
UNIQUE KEY `Tel1` (`Tel1`),
KEY `FZEN` (`Fichier_NHY_Chaud`),
KEY `dejaExpo` (`Deja_Exporter`),
KEY `Qualif` (`Qualification`),
KEY `DEP` (`Departement`),
KEY `DATECollect` (`Date_de_Collect`) USING BTREE,
KEY `MutORITEL` (`Mutuelle_FROID`),
KEY `DateNaiss` (`Date_Naissance`),
KEY `Nom` (`Nom`),
KEY `Prenom` (`Prenom`),
KEY `CodeP` (`Code_Postal`),
KEY `FORITEL` (`Fichier_NHY_Froid`) USING BTREE,
KEY `Mail` (`Mail`(250)),
KEY `IX_fourni` (`Fournisseurs`),
KEY `der_app` (`Dernier_Appel`) USING BTREE,
KEY `IX_serv` (`Serveur`),
KEY `IX_equipe` (`Equipe`),
KEY `MutZEN` (`Mutuelle_CHAUD`) USING BTREE,
KEY `IX_NV` (`Nouveau`)
) ENGINE=MyISAM AUTO_INCREMENT=184851077 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- Дамп данных таблицы `infos`
--
INSERT INTO `infos` (`ID`, `Nom`, `Prenom`, `Civilite`, `Ville`, `Code_Postal`, `Adresse`, `Tel1`, `Mail`, `Date_Naissance`, `Commentaire`, `Date_de_Collect`, `Source_Site`, `Fichier_NHY_Chaud`, `Fichier_NHY_Froid`, `Deja_Exporter`, `Qualification`, `Departement`, `IDTAB`, `Mutuelle_CHAUD`, `Mutuelle_FROID`, `Fournisseurs`, `Dernier_Appel`, `Serveur`, `Equipe`, `Nouveau`) VALUES
('2,03E+15', 'nejjari', 'assia', 'Mme', 'paris', '75017', '17 boulevard bessieres, batiment a2', '616668648', 'assia.nejjari80@outlook.fr', '1980-05-20', '', '01/12/2021', 'You must be logged in to see this link.', 1, 0, 0, 'In Queue', 'DEP75', 1, 0, 0, 'WebRivage', '2023-02-03', 'kpc.b', '', 0),
('2,33E+14', 'pagnier', 'manon', 'Mme', 'pusey', '70000', '7 rue gustave courtois', '777829104', 'manon.pagnier@outlook.fr', '1997-07-11', '', '01/12/2021', 'You must be logged in to see this link.', 1, 0, 1, 'Argumenté', 'DEP70', 2, 0, 0, 'WebRivage', '2022-01-07', 'oritelmobile', 'ACTUDATA ZEN', 0),
('2,53E+14', 'raoaufi', 'sounia', 'Mme', 'nice', '6300', 'boulevard louis braille', '646920775', 'sousoutounsia06@hotmail.fr', '1982-11-01', '', '01/12/2021', 'You must be logged in to see this link.', 1, 0, 0, 'Non argumenté', 'DEP06', 3, 0, 0, 'WebRivage', '2023-02-22', 'kpc.b', 'PREVIANCE', 0),
('2,93E+15', 'lebdiri', 'sabiha', 'Mme', 'mont st aignan', '76130', '37 rue du marechal juin, residence du bois monet log 346', '753890342', 'sabihalebdiri@gmail.com', '1995-03-22', '', '01/12/2021', 'You must be logged in to see this link.', 1, 0, 1, 'S_NRP', 'DEP76', 4, 0, 0, 'WebRivage', '2022-08-29', 'zensante2mobile', '', 0),
('2,13E+15', 'Lorillier', 'Sacha', 'Mr', 'rennes', '35000', '23 rue de la visitation', '782892346', 'sacha.lorillier@gmail.com', '1999-09-06', '', '01/12/2021', 'You must be logged in to see this link.', 1, 0, 0, 'In Queue', 'DEP35', 5, 0, 0, 'WebRivage', '2023-02-17', 'kpc.b', '', 0),
('2,73E+14', 'Dehmane', 'Nadia', 'Mme', 'serres', '5700', '29 rue henri peuzin', '622221438', 'ndehmane@yahoo.fr', '1969-10-08', '', '01/12/2021', 'You must be logged in to see this link.', 1, 0, 0, 'Answering Machine', 'DEP05', 6, 0, 0, 'WebRivage', '2023-02-21', 'kpc.b', '', 0),
('2,73E+15', 'Thirion', 'Jessica', 'Mme', 'dreux', '28100', '44 rue saint denis', '644266881', 'miss280001@live.fr', '1990-04-07', '', '01/12/2021', 'You must be logged in to see this link.', 1, 0, 1, 'S_REPONDEUR', 'DEP28', 7, 0, 0, 'WebRivage', '2022-09-24', 'zensante2mobile', '', 0),
('2,33E+15', 'FIGIEL', 'Audrey', 'Mme', 'nevers', '58000', '4 rue du 8 mai 1945, 513', '662745944', 'daday58@outlook.fr', '1977-08-02', '', '01/12/2021', 'You must be logged in to see this link.', 1, 0, 0, 'Non argumenté', 'DEP58', 8, 0, 0, 'WebRivage', '2023-02-09', 'kpc.b', 'PREVIANCE', 0),
('2,63E+15', 'dumas-lawless', 'claire', 'Mme', 'fargues st hilaire', '33370', '11 residence le tertre des forges', '613310569', 'claire.dumas20@hotmail.fr', '1972-04-20', '', '01/12/2021', 'You must be logged in to see this link.', 1, 0, 0, 'Answering Machine', 'DEP33', 9, 0, 0, 'WebRivage', '2023-02-03', 'kpc.b', '', 0),
('2,93E+15', 'Lebel', 'Elodie', 'Mme', 'hirson', '2500', '26 parc brisset', '683594038', 'lebelelodie21@gmail.com', '1987-09-18', '', '01/12/2021', 'You must be logged in to see this link.', 1, 0, 1, '', 'DEP02', 10, 0, 0, 'WebRivage', '0000-00-00', '', '', 0),
('2,13E+14', 'hubach', 'daniel', 'Mr', 'strasbourg', '67100', '138 avenue de colmar', '777045040', 'hubach67100@gmail.com', '1959-07-12', '02/14/2023 15:32:11: TECH.B (190) xfered dispos from: 0Equipe_A (315) to: 0backup (314) | 02/14/2023 15:09:24: [auto] turned off from 0 Voice Broadcasts and 1 Campaigns | 02/14/2023 15:09:24: 1DANIEL ZEN1 removed all future calls via Custom Calls Off | 02/14/2023 15:09:23: 1DANIEL ZEN1 marked contact as Non argumenté | 02/14/2023 15:07:54: Initiated a predictive call from Q: 0Equipe_A |', '01/12/2021', 'You must be logged in to see this link.', 1, 0, 0, 'Non argumenté', 'DEP67', 11, 0, 0, 'WebRivage', '2023-02-14', 'kpc.b', 'NHY KPC', 0),
('2,23E+15', 'Trumeau', 'Mickaël', 'Mr', 'caudry', '59540', '66 rue gambetta', '648051185', 'mickael.trumeau@live.fr', '1996-12-11', '02/15/2023 14:55:31: KPC.B@GMAIL.COM (46) xfered all from: 0Equipe_A (322) to: 0backup (321) | 02/15/2023 13:10:36: TECH.B (190) xfered all from: 0Equipe_A (322) to: 0Equipe_A (322) | 02/15/2023 13:09:44: Initiated a predictive call from Q: 0Equipe_A | 02/15/2023 12:01:18: Added to Campaign: 0Equipe_A |', '01/12/2021', 'You must be logged in to see this link.', 1, 0, 0, 'In Queue', 'DEP59', 12, 0, 0, 'WebRivage', '2023-02-15', 'kpc.b', '', 0),
('2,73E+15', 'currat', 'virginie', 'Mme', 'ceyzeriat', '1250', '18 chemin des billets', '672247324', 'lvda01@hotmail.fr', '1974-08-13', '', '01/12/2021', 'You must be logged in to see this link.', 1, 0, 0, 'Answering Machine', 'DEP01', 13, 0, 0, 'WebRivage', '2023-02-09', 'kpc.b', '', 0),
('2,43E+14', 'Dos santos', 'Julie', 'Mme', 'tarnos', '40220', '11 rue des palombes', '610149375', 'july_ny_6@hotmail.fr', '1988-09-06', '', '01/12/2021', 'You must be logged in to see this link.', 1, 0, 1, 'Argumenté', 'DEP40', 14, 0, 0, 'WebRivage', '2022-01-05', 'oritelmobile', 'PREVIANCE', 0),
('2,43E+15', 'ahamadi', 'nahida', 'Mme', 'loudeac', '22600', '34 rue anatole le braz, residence', '623632164', 'ahamadinahida@gmail.com', '2002-03-05', '', '01/12/2021', 'You must be logged in to see this link.', 1, 0, 1, '', 'DEP22', 15, 0, 0, 'WebRivage', '0000-00-00', '', '', 0),
('2,83E+15', 'Chhuth', 'Sonia', 'Mme', 'frontignan', '34110', 'avenue pierre curie', '695602250', 'taissane@gmail.com', '1981-09-05', '', '01/12/2021', 'You must be logged in to see this link.', 1, 0, 1, '', 'DEP34', 16, 0, 0, 'WebRivage', '0000-00-00', 'zensante2mobile', '', 0),
CREATE TABLE IF NOT EXISTS `infos` (
`ID` varchar(100) DEFAULT NULL,
`Nom` varchar(100) DEFAULT NULL,
`Prenom` varchar(100) DEFAULT NULL,
`Civilite` varchar(10) DEFAULT NULL,
`Ville` varchar(100) DEFAULT NULL,
`Code_Postal` varchar(50) DEFAULT NULL,
`Adresse` varchar(500) DEFAULT NULL,
`Tel1` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`Mail` varchar(500) DEFAULT NULL,
`Date_Naissance` date DEFAULT NULL,
`Commentaire` varchar(500) DEFAULT NULL,
`Date_de_Collect` varchar(100) DEFAULT NULL,
`Source_Site` varchar(999) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`Fichier_NHY_Chaud` tinyint(1) DEFAULT NULL,
`Fichier_NHY_Froid` tinyint(1) DEFAULT NULL,
`Deja_Exporter` tinyint(1) DEFAULT NULL,
`Qualification` varchar(50) DEFAULT NULL,
`Departement` varchar(50) DEFAULT NULL,
`IDTAB` int NOT NULL AUTO_INCREMENT,
`Mutuelle_CHAUD` tinyint(1) DEFAULT NULL,
`Mutuelle_FROID` tinyint(1) DEFAULT NULL,
`Fournisseurs` varchar(100) NOT NULL,
`Dernier_Appel` date NOT NULL,
`Serveur` varchar(100) DEFAULT NULL,
`Equipe` varchar(100) DEFAULT NULL,
`Nouveau` tinyint DEFAULT NULL,
PRIMARY KEY (`IDTAB`),
UNIQUE KEY `Tel1` (`Tel1`),
KEY `FZEN` (`Fichier_NHY_Chaud`),
KEY `dejaExpo` (`Deja_Exporter`),
KEY `Qualif` (`Qualification`),
KEY `DEP` (`Departement`),
KEY `DATECollect` (`Date_de_Collect`) USING BTREE,
KEY `MutORITEL` (`Mutuelle_FROID`),
KEY `DateNaiss` (`Date_Naissance`),
KEY `Nom` (`Nom`),
KEY `Prenom` (`Prenom`),
KEY `CodeP` (`Code_Postal`),
KEY `FORITEL` (`Fichier_NHY_Froid`) USING BTREE,
KEY `Mail` (`Mail`(250)),
KEY `IX_fourni` (`Fournisseurs`),
KEY `der_app` (`Dernier_Appel`) USING BTREE,
KEY `IX_serv` (`Serveur`),
KEY `IX_equipe` (`Equipe`),
KEY `MutZEN` (`Mutuelle_CHAUD`) USING BTREE,
KEY `IX_NV` (`Nouveau`)
) ENGINE=MyISAM AUTO_INCREMENT=184851077 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
--
-- Дамп данных таблицы `infos`
--
INSERT INTO `infos` (`ID`, `Nom`, `Prenom`, `Civilite`, `Ville`, `Code_Postal`, `Adresse`, `Tel1`, `Mail`, `Date_Naissance`, `Commentaire`, `Date_de_Collect`, `Source_Site`, `Fichier_NHY_Chaud`, `Fichier_NHY_Froid`, `Deja_Exporter`, `Qualification`, `Departement`, `IDTAB`, `Mutuelle_CHAUD`, `Mutuelle_FROID`, `Fournisseurs`, `Dernier_Appel`, `Serveur`, `Equipe`, `Nouveau`) VALUES
('2,03E+15', 'nejjari', 'assia', 'Mme', 'paris', '75017', '17 boulevard bessieres, batiment a2', '616668648', 'assia.nejjari80@outlook.fr', '1980-05-20', '', '01/12/2021', 'You must be logged in to see this link.', 1, 0, 0, 'In Queue', 'DEP75', 1, 0, 0, 'WebRivage', '2023-02-03', 'kpc.b', '', 0),
('2,33E+14', 'pagnier', 'manon', 'Mme', 'pusey', '70000', '7 rue gustave courtois', '777829104', 'manon.pagnier@outlook.fr', '1997-07-11', '', '01/12/2021', 'You must be logged in to see this link.', 1, 0, 1, 'Argumenté', 'DEP70', 2, 0, 0, 'WebRivage', '2022-01-07', 'oritelmobile', 'ACTUDATA ZEN', 0),
('2,53E+14', 'raoaufi', 'sounia', 'Mme', 'nice', '6300', 'boulevard louis braille', '646920775', 'sousoutounsia06@hotmail.fr', '1982-11-01', '', '01/12/2021', 'You must be logged in to see this link.', 1, 0, 0, 'Non argumenté', 'DEP06', 3, 0, 0, 'WebRivage', '2023-02-22', 'kpc.b', 'PREVIANCE', 0),
('2,93E+15', 'lebdiri', 'sabiha', 'Mme', 'mont st aignan', '76130', '37 rue du marechal juin, residence du bois monet log 346', '753890342', 'sabihalebdiri@gmail.com', '1995-03-22', '', '01/12/2021', 'You must be logged in to see this link.', 1, 0, 1, 'S_NRP', 'DEP76', 4, 0, 0, 'WebRivage', '2022-08-29', 'zensante2mobile', '', 0),
('2,13E+15', 'Lorillier', 'Sacha', 'Mr', 'rennes', '35000', '23 rue de la visitation', '782892346', 'sacha.lorillier@gmail.com', '1999-09-06', '', '01/12/2021', 'You must be logged in to see this link.', 1, 0, 0, 'In Queue', 'DEP35', 5, 0, 0, 'WebRivage', '2023-02-17', 'kpc.b', '', 0),
('2,73E+14', 'Dehmane', 'Nadia', 'Mme', 'serres', '5700', '29 rue henri peuzin', '622221438', 'ndehmane@yahoo.fr', '1969-10-08', '', '01/12/2021', 'You must be logged in to see this link.', 1, 0, 0, 'Answering Machine', 'DEP05', 6, 0, 0, 'WebRivage', '2023-02-21', 'kpc.b', '', 0),
('2,73E+15', 'Thirion', 'Jessica', 'Mme', 'dreux', '28100', '44 rue saint denis', '644266881', 'miss280001@live.fr', '1990-04-07', '', '01/12/2021', 'You must be logged in to see this link.', 1, 0, 1, 'S_REPONDEUR', 'DEP28', 7, 0, 0, 'WebRivage', '2022-09-24', 'zensante2mobile', '', 0),
('2,33E+15', 'FIGIEL', 'Audrey', 'Mme', 'nevers', '58000', '4 rue du 8 mai 1945, 513', '662745944', 'daday58@outlook.fr', '1977-08-02', '', '01/12/2021', 'You must be logged in to see this link.', 1, 0, 0, 'Non argumenté', 'DEP58', 8, 0, 0, 'WebRivage', '2023-02-09', 'kpc.b', 'PREVIANCE', 0),
('2,63E+15', 'dumas-lawless', 'claire', 'Mme', 'fargues st hilaire', '33370', '11 residence le tertre des forges', '613310569', 'claire.dumas20@hotmail.fr', '1972-04-20', '', '01/12/2021', 'You must be logged in to see this link.', 1, 0, 0, 'Answering Machine', 'DEP33', 9, 0, 0, 'WebRivage', '2023-02-03', 'kpc.b', '', 0),
('2,93E+15', 'Lebel', 'Elodie', 'Mme', 'hirson', '2500', '26 parc brisset', '683594038', 'lebelelodie21@gmail.com', '1987-09-18', '', '01/12/2021', 'You must be logged in to see this link.', 1, 0, 1, '', 'DEP02', 10, 0, 0, 'WebRivage', '0000-00-00', '', '', 0),
('2,13E+14', 'hubach', 'daniel', 'Mr', 'strasbourg', '67100', '138 avenue de colmar', '777045040', 'hubach67100@gmail.com', '1959-07-12', '02/14/2023 15:32:11: TECH.B (190) xfered dispos from: 0Equipe_A (315) to: 0backup (314) | 02/14/2023 15:09:24: [auto] turned off from 0 Voice Broadcasts and 1 Campaigns | 02/14/2023 15:09:24: 1DANIEL ZEN1 removed all future calls via Custom Calls Off | 02/14/2023 15:09:23: 1DANIEL ZEN1 marked contact as Non argumenté | 02/14/2023 15:07:54: Initiated a predictive call from Q: 0Equipe_A |', '01/12/2021', 'You must be logged in to see this link.', 1, 0, 0, 'Non argumenté', 'DEP67', 11, 0, 0, 'WebRivage', '2023-02-14', 'kpc.b', 'NHY KPC', 0),
('2,23E+15', 'Trumeau', 'Mickaël', 'Mr', 'caudry', '59540', '66 rue gambetta', '648051185', 'mickael.trumeau@live.fr', '1996-12-11', '02/15/2023 14:55:31: KPC.B@GMAIL.COM (46) xfered all from: 0Equipe_A (322) to: 0backup (321) | 02/15/2023 13:10:36: TECH.B (190) xfered all from: 0Equipe_A (322) to: 0Equipe_A (322) | 02/15/2023 13:09:44: Initiated a predictive call from Q: 0Equipe_A | 02/15/2023 12:01:18: Added to Campaign: 0Equipe_A |', '01/12/2021', 'You must be logged in to see this link.', 1, 0, 0, 'In Queue', 'DEP59', 12, 0, 0, 'WebRivage', '2023-02-15', 'kpc.b', '', 0),
('2,73E+15', 'currat', 'virginie', 'Mme', 'ceyzeriat', '1250', '18 chemin des billets', '672247324', 'lvda01@hotmail.fr', '1974-08-13', '', '01/12/2021', 'You must be logged in to see this link.', 1, 0, 0, 'Answering Machine', 'DEP01', 13, 0, 0, 'WebRivage', '2023-02-09', 'kpc.b', '', 0),
('2,43E+14', 'Dos santos', 'Julie', 'Mme', 'tarnos', '40220', '11 rue des palombes', '610149375', 'july_ny_6@hotmail.fr', '1988-09-06', '', '01/12/2021', 'You must be logged in to see this link.', 1, 0, 1, 'Argumenté', 'DEP40', 14, 0, 0, 'WebRivage', '2022-01-05', 'oritelmobile', 'PREVIANCE', 0),
('2,43E+15', 'ahamadi', 'nahida', 'Mme', 'loudeac', '22600', '34 rue anatole le braz, residence', '623632164', 'ahamadinahida@gmail.com', '2002-03-05', '', '01/12/2021', 'You must be logged in to see this link.', 1, 0, 1, '', 'DEP22', 15, 0, 0, 'WebRivage', '0000-00-00', '', '', 0),
('2,83E+15', 'Chhuth', 'Sonia', 'Mme', 'frontignan', '34110', 'avenue pierre curie', '695602250', 'taissane@gmail.com', '1981-09-05', '', '01/12/2021', 'You must be logged in to see this link.', 1, 0, 1, '', 'DEP34', 16, 0, 0, 'WebRivage', '0000-00-00', 'zensante2mobile', '', 0),
