· 10 years ago · Aug 16, 2016, 04:54 PM
1-- phpMyAdmin SQL Dump
2-- version 4.4.15.7
3-- http://www.phpmyadmin.net
4--
5-- Client : localhost
6-- Généré le : Mar 16 Août 2016 à 16:53
7-- Version du serveur : 5.5.49-0+deb7u1
8-- Version de PHP : 5.4.45-0+deb7u4
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8mb4 */;
18
19--
20-- Base de données : `user_07`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Structure de la table `tblclients`
27--
28
29CREATE TABLE IF NOT EXISTS `tblclients` (
30 `id` int(10) NOT NULL,
31 `uuid` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
32 `firstname` text COLLATE utf8_unicode_ci NOT NULL,
33 `lastname` text COLLATE utf8_unicode_ci NOT NULL,
34 `companyname` text COLLATE utf8_unicode_ci NOT NULL,
35 `email` text COLLATE utf8_unicode_ci NOT NULL,
36 `address1` text COLLATE utf8_unicode_ci NOT NULL,
37 `address2` text COLLATE utf8_unicode_ci NOT NULL,
38 `city` text COLLATE utf8_unicode_ci NOT NULL,
39 `state` text COLLATE utf8_unicode_ci NOT NULL,
40 `postcode` text COLLATE utf8_unicode_ci NOT NULL,
41 `country` text COLLATE utf8_unicode_ci NOT NULL,
42 `phonenumber` text COLLATE utf8_unicode_ci NOT NULL,
43 `password` text COLLATE utf8_unicode_ci NOT NULL,
44 `authmodule` text COLLATE utf8_unicode_ci NOT NULL,
45 `authdata` text COLLATE utf8_unicode_ci NOT NULL,
46 `currency` int(10) NOT NULL,
47 `defaultgateway` text COLLATE utf8_unicode_ci NOT NULL,
48 `credit` decimal(10,2) NOT NULL,
49 `taxexempt` tinyint(1) NOT NULL,
50 `latefeeoveride` tinyint(1) NOT NULL,
51 `overideduenotices` tinyint(1) NOT NULL,
52 `separateinvoices` tinyint(1) NOT NULL,
53 `disableautocc` tinyint(1) NOT NULL,
54 `datecreated` date NOT NULL,
55 `notes` text COLLATE utf8_unicode_ci NOT NULL,
56 `billingcid` int(10) NOT NULL,
57 `securityqid` int(10) NOT NULL,
58 `securityqans` text COLLATE utf8_unicode_ci NOT NULL,
59 `groupid` int(10) NOT NULL,
60 `cardtype` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
61 `cardlastfour` text COLLATE utf8_unicode_ci NOT NULL,
62 `cardnum` blob NOT NULL,
63 `startdate` blob NOT NULL,
64 `expdate` blob NOT NULL,
65 `issuenumber` blob NOT NULL,
66 `bankname` text COLLATE utf8_unicode_ci NOT NULL,
67 `banktype` text COLLATE utf8_unicode_ci NOT NULL,
68 `bankcode` blob NOT NULL,
69 `bankacct` blob NOT NULL,
70 `gatewayid` text COLLATE utf8_unicode_ci NOT NULL,
71 `lastlogin` datetime DEFAULT NULL,
72 `ip` text COLLATE utf8_unicode_ci NOT NULL,
73 `host` text COLLATE utf8_unicode_ci NOT NULL,
74 `status` enum('Active','Inactive','Closed') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Active',
75 `language` text COLLATE utf8_unicode_ci NOT NULL,
76 `pwresetkey` text COLLATE utf8_unicode_ci NOT NULL,
77 `emailoptout` int(1) NOT NULL,
78 `overrideautoclose` int(1) NOT NULL,
79 `allow_sso` tinyint(1) NOT NULL DEFAULT '1',
80 `email_verified` tinyint(1) NOT NULL DEFAULT '0',
81 `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
82 `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
83 `pwresetexpiry` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
84) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
85
86--
87-- Contenu de la table `tblclients`
88--
89
90INSERT INTO `tblclients` (`id`, `uuid`, `firstname`, `lastname`, `companyname`, `email`, `address1`, `address2`, `city`, `state`, `postcode`, `country`, `phonenumber`, `password`, `authmodule`, `authdata`, `currency`, `defaultgateway`, `credit`, `taxexempt`, `latefeeoveride`, `overideduenotices`, `separateinvoices`, `disableautocc`, `datecreated`, `notes`, `billingcid`, `securityqid`, `securityqans`, `groupid`, `cardtype`, `cardlastfour`, `cardnum`, `startdate`, `expdate`, `issuenumber`, `bankname`, `banktype`, `bankcode`, `bankacct`, `gatewayid`, `lastlogin`, `ip`, `host`, `status`, `language`, `pwresetkey`, `emailoptout`, `overrideautoclose`, `allow_sso`, `email_verified`, `created_at`, `updated_at`, `pwresetexpiry`) VALUES
91(1, '8837d0e2-e169-4db4-8dd7-c83280c43c5c', 'Fabien', 'Nexon', '', 'fabien.nexon95@gmail.com', '26 avenue de verdun', '', 'Argenteuil', 'Val-d'Oise', '95100', 'FR', '606060606', '$2y$10$tAw1gFwcPrOFNLniSdb7aeqFnEwDRFae/d0P/2gkGzgoOcJkGTK66', '', '', 1, '', 0.00, 0, 0, 0, 0, 0, '2016-08-05', 'Merci de bien vouloir vérifier l'adresse mail de votre compte RedCloud sous peine de fermeture permanente de votre espace client par l'équipe.', 0, 0, 'jgHuKtpCfe+ly4vfTO3k5M7riSM=', 0, '', '', '', '', '', '', '', '', '', '', '', '2016-08-05 21:53:31', '84.98.145.235', '235.145.98.84.rev.sfr.net', 'Active', '', '', 0, 0, 1, 0, '0000-00-00 00:00:00', '2016-08-05 21:53:31', '0000-00-00 00:00:00'),
92(2, '2e6babf8-7c19-4bf5-84f6-b0496ada28f0', 'Simon', 'Hogrel', 'SpaceHabbo', 'simon.hogrel@gmail.com', '38, rue des Cochereaux', '6, rue d'Aquitaine', 'Le Mans', 'Sarthe', '72000', 'FR', '0664542088', '$2y$10$Aq2fP88TjEEn10dNYeIA2.mBOq1jm046wBzwTs.WhGYKqBschCTRK', '', '', 1, '', 0.00, 0, 0, 0, 0, 0, '2016-08-06', '', 0, 0, 'RhvmzhEl/sQBhXp4vYhmXE+v3GU=', 0, '', '', '', '', '', '', '', '', '', '', '', '2016-08-12 13:23:28', '88.165.72.148', 'pas72-2-88-165-72-148.fbx.proxad.net', 'Active', '', '', 0, 0, 1, 1, '0000-00-00 00:00:00', '2016-08-12 13:23:28', '0000-00-00 00:00:00'),
93(3, '171a06da-b327-4df6-8cff-ab60655bcc53', 'Jordan', 'Red-Cloud', 'Red-cloud', 'jordan89400@outlook.com', 'ffffff', '', 'fxffxx', 'Alpes-de-Haute-Provence', '89400', 'FR', '0625256974', '$2y$10$CImWVdLDUXHxPPJjnLqxdu0mKciz1pZFc7EaDr96uGu1kIYIOB0Ei', '', '', 1, '', 0.00, 0, 0, 0, 0, 0, '2016-08-06', '', 0, 0, 'icEuWKFLlYf3ZnkScH1VD9iJDq0=', 0, '', '', '', '', '', '', '', '', '', '', '', '2016-08-13 00:43:16', '109.28.246.49', '49.246.28.109.rev.sfr.net', 'Active', '', '', 0, 0, 1, 1, '0000-00-00 00:00:00', '2016-08-13 00:43:16', '0000-00-00 00:00:00'),
94(4, 'a8deb7ed-64e5-4d3a-a09c-8af05e13615e', 'Mikael', 'DA CRUZ', 'Red-Cloud', 'mikael.benfica@live.fr', '1, place de la République', '', 'Paris', 'Paris', '75000', 'FR', '0600000000', '$2y$10$uUPuy2P1gT7Dc1qxbaAJPuCZMB62LWXYOzFyXuuGREWqzbUk6AVd.', '', '', 1, '', 0.50, 0, 0, 0, 0, 0, '2016-08-06', '', 0, 0, 'p0g6Qizj383ZMkVl6CMdgJnWOr8=', 0, '', '', '', '', '', '', '', '', '', '', '', '2016-08-06 18:13:35', '194.169.217.254', '194.169.217.254', 'Active', '', '', 0, 0, 1, 1, '0000-00-00 00:00:00', '2016-08-06 18:13:36', '0000-00-00 00:00:00'),
95(5, 'ae689ace-d887-4c65-bf21-f2f6838b2348', 'adrien', 'kapp', '', 'paypal@xvo.fr', '8 place anonymous', '', 'Strasbourg', 'Bas-Rhin', '67500', 'FR', '650550000', '$2y$10$SVxw0RU3v3kYxEXCAAFqCuSjZs92Ogu28lOvl.YzdSZeUvtqbU18u', '', '', 1, '', 0.00, 0, 0, 0, 0, 0, '2016-08-07', '', 0, 0, '9cA+QsTfXTrfoN5Z0GEyv/bRYhc=', 0, '', '', '', '', '', '', '', '', '', '', '', '2016-08-07 11:24:58', '78.119.231.113', '113.231.119.78.rev.sfr.net', 'Closed', '', '', 0, 0, 1, 0, '0000-00-00 00:00:00', '2016-08-07 11:24:59', '0000-00-00 00:00:00'),
96(7, '80536f1a-c8d8-4877-b0fc-17101d8d6d6c', 'Paul', 'Guillaume', 'Red-Cloud France', 'paul.guillaume37@hotmail.com', '59 Avenue Henri Adam', '', 'Saint-Avertin', 'Indre-et-Loire', '37550', 'FR', '0618852986', '$2y$10$TCJ.qKsiidNTkFrh/KgP/e6WomuWLj0COrNgBZaxAoWU897u/YY2.', '', '', 1, '', 0.00, 0, 0, 0, 0, 0, '2016-08-07', '', 0, 0, 'dpZ2TjIcyDsvsyBvgu6lyMtrRk0=', 0, '', '', '', '', '', '', '', '', '', '', '', '2016-08-07 22:19:45', '41.82.58.61', '41.82.58.61', 'Active', '', '', 0, 0, 1, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
97(8, '5ff3a0e4-c84e-4228-8720-c0829092de6c', 'benjamin', 'retroe', 'hébergeur', 'benjamin.qct@yopmail.com', '2 rue dla maladrerie', '113 rue dla maladrerie', 'reims', 'Marne', '51100', 'FR', '615243569', '$2y$10$Y4tF2XApwRwLRq66IckOt.FxY7WsfNMSNuzlKarfy48faFkZ6gTZC', '', '', 1, '', 0.00, 0, 0, 0, 0, 0, '2016-08-08', '', 0, 0, 'KYAn4xQR6stsFugRhDZ3Gnj3YCQ=', 0, '', '', '', '', '', '', '', '', '', '', '', '2016-08-08 00:35:08', '81.67.5.27', '81-67-5-27.rev.numericable.fr', 'Active', '', '', 0, 0, 1, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
98(9, '691747ab-847a-4a4e-9b81-cbb74455801c', 'maxime', 'clement', 'helpme', 'max2pcm@gmail.com', '55 rue du marchal leclerc', '', 'Saint-Maurice', 'Val-de-Marne', '94410', 'FR', '0650000571', '$2y$10$llgVwZ4xxnGn1cS5eNhHWeJDyZbNqVNvlKq18FC1n0.yi4H206vcq', '', '', 1, '', 0.00, 0, 0, 0, 0, 0, '2016-08-08', '', 0, 0, 'Coc7lzjFKRwmbE8euURhGWGE55Y=', 0, '', '', '', '', '', '', '', '', '', '', '', '2016-08-08 01:18:48', '93.25.166.50', '50.166.25.93.rev.sfr.net', 'Active', '', '', 0, 0, 1, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
99(10, '5bbce161-444c-4631-bdf5-8eac68baa773', 'benjamin', 'red-cloud', 'retro', 'benjamin51100@yopmail.com', '2 rue dla maladrerie', '113 rue dla maladrerie', 'reims', 'Marne', '51100', 'FR', '615243569', '$2y$10$tndnIWnY8gsdPawv576ybegl9T6wQZXSXTHBra.JIqlZLUbU7j3iS', '', '', 1, '', 0.00, 0, 0, 0, 0, 0, '2016-08-08', '', 0, 0, 'a1mUMLF7Tzk4S5vJSaknT/uEghY=', 0, '', '', '', '', '', '', '', '', '', '', '', '2016-08-08 02:21:34', '81.67.5.27', '81-67-5-27.rev.numericable.fr', 'Active', '', '', 0, 0, 1, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
100(11, '5c098794-7842-49ce-956f-7fbd4486a666', 'Oualid', 'Zaghar', 'FunHabbo', 'alphadirat45@gmail.com', '6 rue de la campagne', '', 'Toulouse', 'Haute-Garonne', '31000', 'FR', '05 23 65 23', '$2y$10$XyLiqpaS5F3RY0Oo3PWpge.73s13bNmgKZDefgt46PvBenJEELoiC', '', '', 1, '', 9.99, 0, 0, 0, 0, 0, '2016-08-08', '', 0, 0, '1OafVwwu3WS1oCmk1gZ/dpyfXkE=', 0, '', '', '', '', '', '', '', '', '', '', '', '2016-08-08 19:16:59', '88.124.170.143', 'es782-1-88-124-170-143.fbx.proxad.net', 'Active', '', '', 0, 0, 1, 0, '0000-00-00 00:00:00', '2016-08-08 19:16:59', '0000-00-00 00:00:00'),
101(12, 'd56e77f1-673b-426c-9f0d-c3183ea5d9f4', 'Enzo', 'Brizzi', 'ApZ', 'intoxfr1@gmail.com', '10 Rue du Pont', '', 'Tours', 'Indre-et-Loire', '37000', 'FR', '0682931541', '$2y$10$2gc0zRuw02Xy4q82DgD3h.Vod3cyzvHhbPqI2E1r79xb3s/s0TCpK', '', '', 1, '', 0.00, 0, 0, 0, 0, 0, '2016-08-08', '', 0, 0, 'P0s7/ItvtRpy77Dag208L/tlVrs=', 0, '', '', '', '', '', '', '', '', '', '', '', '2016-08-08 10:35:21', '90.20.135.231', 'AOrleans-651-1-124-231.w90-20.abo.wanadoo.fr', 'Active', '', '', 0, 0, 1, 1, '0000-00-00 00:00:00', '2016-08-08 10:35:21', '0000-00-00 00:00:00'),
102(13, 'f2fba1cd-1187-4772-9d54-f2257ab0bae9', 'Wolfiw', 'Web', 'Wolfiw - Developpeur', 'wolfiwofficial@gmail.com', 'Privée', 'Privée', 'Paris', 'Paris', '75000', 'FR', '0644557788', '$2y$10$1VgJKHlaS0sQjVll2JPztOMuEbV0dGIeP65hUPGTIrGyydK60/SsW', '', '', 1, '', 0.00, 0, 0, 0, 0, 0, '2016-08-08', '', 0, 0, '6YezhEwln4kFLAGW1Oi+eKCPtDM=', 0, '', '', '', '', '', '', '', '', '', '', '', '2016-08-12 11:56:31', '78.127.97.51', '51.97.127.78.rev.sfr.net', 'Active', '', '', 0, 0, 1, 1, '0000-00-00 00:00:00', '2016-08-12 11:56:31', '0000-00-00 00:00:00'),
103(14, 'a70eadf8-56ef-4a60-893d-991c3aa84855', 'Amhadou', 'Sylla', '', 'amhadou.bahi.sylla@facebook.com', '11 rue de la victoire', '', 'Paris', 'Seine-Maritime', '78000', 'FR', '0633289156', '$2y$10$uW0jD.AEAbqQLBEjRCgGCOWHsdSQfUOAyva/Z2mvDh0uIlmzxcUh.', '', '', 1, '', 0.00, 0, 0, 0, 0, 0, '2016-08-08', '', 0, 0, 'zl/N0micW1Gp0rclxO9Dl2t/ywE=', 0, '', '', '', '', '', '', '', '', '', '', '', '2016-08-08 13:03:09', '41.82.58.61', '41.82.58.61', 'Active', '', '', 0, 0, 1, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
104(15, '50abe561-9db1-4870-b23a-b3cd0851a55f', 'Grove', 'Dev', 'Toph', 'sanokyleroi@gmail.com', 'Nope', 'Nope', 'Nope', 'Hautes-Alpes', '93500', 'FR', '0631000000', '$2y$10$XWZD3RvaN7xCxKWyy50YFOEGTe/EfHMe.lx7bz03.db8mlokcMLe6', '', '', 1, '', 0.00, 0, 0, 0, 0, 0, '2016-08-08', '', 0, 0, 'ufXhYA4khGUTfNOH8k2Xgp50ADI=', 0, '', '', '', '', '', '', '', '', '', '', '', '2016-08-08 15:52:48', '92.156.2.217', 'AToulouse-651-1-67-217.w92-156.abo.wanadoo.fr', 'Active', '', '', 0, 0, 1, 0, '0000-00-00 00:00:00', '2016-08-08 15:52:48', '0000-00-00 00:00:00'),
105(16, '23a804c6-2d4a-414b-9b19-24ae3df4a7c6', 'Enzo', 'Métayer', '2001', 'petitfou42@gmail.com', '190 impasse de la loueve', '', 'Villerest', 'Loire', '42300', 'FR', '651120676', '$2y$10$PGB/dTQjzqf8Wy4xNBCwZO/w5yFlAqS1U95QqJWXp.6JxY2jnS4hC', '', '', 1, '', 0.00, 0, 0, 0, 0, 0, '2016-08-08', '', 0, 0, 'Mt18c6+w4ulTA7+iOdjHLYHQ/Gg=', 0, '', '', '', '', '', '', '', '', '', '', '', '2016-08-08 16:42:08', '176.157.11.104', '176.157.11.104', 'Active', '', '', 0, 0, 1, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
106(17, '2a733633-f88d-42c2-92d2-20e81ef108ff', 'sato', 'Retro', 'retro', 'sato.vevo@hotmail.com', '1, Rue Joseph Vernet', '', 'BAR-LE-DUC', 'Charente', '55000', 'FR', '318208469', '$2y$10$5GBRf.OmSCoq6D5XvI/0nuSYjdMwZmIOWnY9ScA0sHMFc/bywi3Q2', '', '', 1, '', 0.00, 0, 0, 0, 0, 0, '2016-08-08', '', 0, 0, 'brgsMRJIOeIRVPXbamm0+LsJsc0=', 0, '', '', '', '', '', '', '', '', '', '', '', '2016-08-08 18:58:03', '81.246.238.129', '129.238-246-81.adsl-dyn.isp.belgacom.be', 'Active', '', '', 0, 0, 1, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
107(18, 'ccd8b95d-8737-4999-a819-9e191bd03463', 'Maxime', 'Ls', 'Onhabbo', 'mxmgap79@gmail.com', 'Paris', '', 'Paris', 'Hautes-Alpes', '26151', 'FR', '0660875123', '$2y$10$y87108v96vFIH4sP/6xWE.ShSyUeS5CY5XQVQ35Hv5NptclGn7sqS', '', '', 1, '', 0.00, 0, 0, 0, 0, 0, '2016-08-08', '', 0, 0, 'XhGT3sUSp7QmuyKn2jQHm9gIS0g=', 0, '', '', '', '', '', '', '', '', '', '', '', '2016-08-15 14:15:32', '105.101.168.44', '105.101.168.44', 'Active', '', '', 0, 0, 1, 1, '0000-00-00 00:00:00', '2016-08-15 14:15:32', '0000-00-00 00:00:00'),
108(19, '0d485c33-79c3-4686-a191-99e988e27676', 'Mathis', 'Fouville', 'WakoWeb', 'wakomodz@gmail.com', 'Pont besnard', '7', 'Bédée', 'Ille-et-Vilaine', '35137', 'FR', '0299071659', '$2y$10$CBybDXhsln2mN87Iw.jM6Od38ZUHvuWfHRDJwCI18i.GDDMkoN6rO', '', '', 1, '', 0.00, 0, 0, 0, 0, 0, '2016-08-09', '', 0, 0, '+l6momAy9jXdpK5cgUugqQrdiRs=', 0, '', '', '', '', '', '', '', '', '', '', '', '2016-08-09 01:58:22', '77.131.63.236', '236.63.131.77.rev.sfr.net', 'Active', '', '', 0, 0, 1, 0, '0000-00-00 00:00:00', '2016-08-09 01:58:22', '0000-00-00 00:00:00'),
109(20, 'fc2b9604-0d5c-4d10-afb9-03fdd0f54243', 'mourchid', 'yussise', 'mourchid', 'goodboysse@gmail.com', 'Agadir', '', 'Agadir', 'Sous-Massa-Draa', '338800', 'MA', '0634728836', '$2y$10$nesTaEvBWQLvXzXM3UgU0ekbQOe5KAvi7D84WjGcR.z3Zg0PlQTb2', '', '', 1, '', 0.00, 0, 0, 0, 0, 0, '2016-08-12', '', 0, 0, 'khzpMMRp27GE+/pZS4zuyYnyNhc=', 0, '', '', '', '', '', '', '', '', '', '', '', '2016-08-12 19:57:42', '105.154.87.147', '105.154.87.147', 'Active', '', '', 0, 0, 1, 1, '0000-00-00 00:00:00', '2016-08-12 19:57:42', '0000-00-00 00:00:00'),
110(21, 'd946765e-47c5-4c96-ae8f-e7eeea4c21cf', 'Steven', 'Soulet', '', 'th3rmik@gmail.com', '57 rue de la mouraude', '', 'Noirmoutier', 'Vendée', '85330', 'FR', '0757502899', '$2y$10$pxn1pRdq/TnmFOdA6NV9cOINH7ZO60ludW2iRZ4CyO3CpEbAQ8jMe', '', '', 1, '', 0.00, 0, 0, 0, 0, 0, '2016-08-13', '', 0, 0, 'Z3kihMOUh3kSD7F7DhQVzll5oYo=', 0, '', '', '', '', '', '', '', '', '', '', '', '2016-08-15 00:40:36', '90.104.111.83', 'LFbn-1-4880-83.w90-104.abo.wanadoo.fr', 'Closed', '', '', 0, 0, 1, 1, '0000-00-00 00:00:00', '2016-08-15 00:40:36', '0000-00-00 00:00:00'),
111(22, '66e3528f-ac00-4a42-9f01-027906c9bf08', 'SII', 'GNAL', 'HTCHAT', 'anthony.77181@hotmail.fr', '6 CLOS DES GENETS', '', 'Brette les pins', 'Sarthe', '72250', 'FR', '777752336', '$2y$10$F.kzeq.aG/0fQ.iA.VatPuov2Z10RPXLQdb76g1U6gRqbbBwk8Ct.', '', '', 1, '', 0.00, 0, 0, 0, 0, 0, '2016-08-14', '', 0, 0, '0+qeaWa0pdKXrcF/QpuRNmXt/es=', 0, '', '', '', '', '', '', '', '', '', '', '', '2016-08-14 19:55:46', '78.116.96.70', '70.96.116.78.rev.sfr.net', 'Active', '', '', 0, 0, 1, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
112(23, '71c4e8b4-0c56-4bb8-8a5d-e5a3cd75abe5', 'wanted', 'rétro', 'your-cms', 'hubjojocedjon@gmail.com', '3rue de la mulousienne', '', 'france', 'Charente-Maritime', '68200', 'FR', '0698501709', '$2y$10$eY9rDZkl2rBmwPmZi8Ebi.azmEMnkNUnbTirBKX4aZqgfVoImyggm', '', '', 1, '', 0.00, 0, 0, 0, 0, 0, '2016-08-15', '', 0, 0, 'pIc9pe6DCUfuSIt2UXBKF6hrFx4=', 0, '', '', '', '', '', '', '', '', '', '', '', '2016-08-15 12:18:42', '88.173.122.153', 'arc68-4-88-173-122-153.fbx.proxad.net', 'Active', '', '', 0, 0, 1, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
113(24, '25118716-920e-4716-89f6-f0386e9388f3', 'Alex', 'Lrs', '', 'alex.officiel@gmx.fr', '10 rue des marreau ', '', 'Paris', 'Paris', '75001', 'FR', '0600000000', '$2y$10$PzzGm/I2a.V47FIdHcUbKu70URNfpiEpIAEl0sQXdH/8jEkTrpPMK', '', '', 1, '', 0.00, 0, 0, 0, 0, 0, '2016-08-15', '', 0, 0, '0Z1Tb0Oraa+lKix5fie3kbQJU54=', 0, '', '', '', '', '', '', '', '', '', '', '', '2016-08-15 21:32:44', '90.2.113.126', 'APuteaux-555-1-10-126.w90-2.abo.wanadoo.fr', 'Active', '', '', 0, 0, 1, 1, '0000-00-00 00:00:00', '2016-08-15 21:32:48', '0000-00-00 00:00:00');
114
115--
116-- Index pour les tables exportées
117--
118
119--
120-- Index pour la table `tblclients`
121--
122ALTER TABLE `tblclients`
123 ADD PRIMARY KEY (`id`),
124 ADD KEY `firstname_lastname` (`firstname`(32),`lastname`(32)),
125 ADD KEY `email` (`email`(64));
126
127--
128-- AUTO_INCREMENT pour les tables exportées
129--
130
131--
132-- AUTO_INCREMENT pour la table `tblclients`
133--
134ALTER TABLE `tblclients`
135 MODIFY `id` int(10) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=25;
136/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
137/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
138/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;