Sql © Chucky Credits [Sql Dump] Sbedirect.com 11K Customers
Today I have uploaded the SBEDIRECT Database for you to download, thanks for reading and enjoy!
SBEdirect offers everything necessary for the identification and security of goods and people in the company
╔═══════════════════════════════╗
█ Format - .sql
█ Size file - 31Mb
█ Rows - 230K / Customers 11k
█ Date - 23.12.2022
█ Website -
╚═══════════════════════════════╝
SBEdirect offers everything necessary for the identification and security of goods and people in the company
`id_customer` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id_shop_group` int(11) unsigned NOT NULL DEFAULT 1,
`id_shop` int(11) unsigned NOT NULL DEFAULT 1,
`id_gender` int(10) unsigned NOT NULL,
`id_default_group` int(10) unsigned NOT NULL DEFAULT 1,
`id_lang` int(10) unsigned DEFAULT NULL,
`id_risk` int(10) unsigned NOT NULL DEFAULT 1,
`company` varchar(64) DEFAULT NULL,
`siret` varchar(14) DEFAULT NULL,
`ape` varchar(5) DEFAULT NULL,
`firstname` varchar(255) NOT NULL,
`lastname` varchar(255) NOT NULL,
`email` varchar(128) NOT NULL,
`passwd` varchar(60) NOT NULL,
`last_passwd_gen` timestamp NOT NULL DEFAULT current_timestamp(),
`birthday` date DEFAULT NULL,
`newsletter` tinyint(1) unsigned NOT NULL DEFAULT 1,
`ip_registration_newsletter` varchar(15) DEFAULT NULL,
`newsletter_date_add` datetime DEFAULT NULL,
`optin` tinyint(1) unsigned NOT NULL DEFAULT 0,
`website` varchar(128) DEFAULT NULL,
`outstanding_allow_amount` decimal(20,6) NOT NULL DEFAULT 0.000000,
`show_public_prices` tinyint(1) unsigned NOT NULL DEFAULT 0,
`max_payment_days` int(10) unsigned NOT NULL DEFAULT 60,
`secure_key` varchar(32) NOT NULL DEFAULT '-1',
`note` text DEFAULT NULL,
`active` tinyint(1) unsigned NOT NULL DEFAULT 0,
`is_guest` tinyint(1) NOT NULL DEFAULT 0,
`deleted` tinyint(1) NOT NULL DEFAULT 0,
`date_add` datetime NOT NULL,
`date_upd` datetime NOT NULL,
`reset_password_token` varchar(40) DEFAULT NULL,
`reset_password_validity` datetime DEFAULT NULL,
`atoosync_compta_account` varchar(30) NOT NULL,
HTML:
('204','1','1','1','3','1','1','SECURITAS','30 449 785 202','8010Z','Eric','Vander-Maelen','eric.vandermaelen@securitas.fr','','2019-02-27 15:41:51',NULL,'1',NULL,NULL,'0',NULL,'0.000000','0','60','8f0db03a24f013ea5c356a7bd27e0501',NULL,'1','0','0','2019-02-27 15:41:48','2019-02-27 15:41:48',NULL,NULL,''),
('205','1','1','2','2','1','1','CENTRE HOSPITALIER DE CHOLET','26 490 039 000','8610Z','Sylvie','Roger','dsih@ch-cholet.fr','','2019-02-27 15:41:51',NULL,'1',NULL,NULL,'0',NULL,'0.000000','0','60','4593cfe3fdb7c2ead1a29da327111b97',NULL,'1','0','0','2019-02-27 15:41:48','2019-02-27 15:41:48',NULL,NULL,''),
('206','1','1','2','2','1','1','CENTRE HOSPITALIER DE CHOLET','26 490 039 000','8610Z','Veronique','Routier','veronique.routier@ch-cholet.fr','','2019-02-27 15:41:51',NULL,'1',NULL,NULL,'0',NULL,'0.000000','0','60','b9f5b149e1456c89f106badc8affe531',NULL,'1','0','0','2019-02-27 15:41:48','2019-02-27 15:41:48',NULL,NULL,''),
('207','1','1','1','3','1','1','CRPCEN','77 567 188 600','753A','Gérald','Dal','gerald.daldegan@crpcen.fr','','2019-02-27 15:41:51',NULL,'1',NULL,NULL,'0',NULL,'0.000000','0','60','7d07c04706e3351b3065c145f90a19dd',NULL,'1','0','0','2019-02-27 15:41:48','2019-02-27 15:41:48',NULL,NULL,''),
('208','1','1','2','2','1','1','PORT AUTONOME DE DUNKERQUE','44 993 746 500','4399B','Isabelle','Capon','icapon@portdedunkerque.fr','','2019-02-27 15:41:51',NULL,'1',NULL,NULL,'0',NULL,'0.000000','0','60','00be4c6a1f498f327efc44c118a02412',NULL,'1','0','0','2019-02-27 15:41:48','2019-02-27 15:41:48',NULL,NULL,''),
('209','1','1','1','3','1','1','CONSEIL DÉPARTEMENTAL DU VAUCLUSE','22 840 001 600','751K','Laurent','Fleury','laurent.fleury@cg84.fr','','2019-02-27 15:41:51',NULL,'1',NULL,NULL,'0',NULL,'0.000000','0','60','7560348629f625c2183512d4c7e363c3',NULL,'1','0','0','2019-02-27 15:41:48','2019-02-27 15:41:48',NULL,NULL,''),
('210','1','1','2','3','1','1','CONSEIL DÉPARTEMENTAL DU VAUCLUSE','22 840 001 600','751K','Isabelle','Martel','isabelle.martel@cg84.fr','','2019-02-27 15:41:51',NULL,'1',NULL,NULL,'0',NULL,'0.000000','0','60','5400c351a3196f884806cf6dc00321b5',NULL,'1','0','0','2019-02-27 15:41:48','2019-02-27 15:41:48',NULL,NULL,''),
('211','1','1','1','3','1','1','CONSEIL DÉPARTEMENTAL DU VAUCLUSE','22 840 001 600','751K','Didier','Nallet','didier.nallet@vaucluse.fr','','2019-02-27 15:41:51',NULL,'1',NULL,NULL,'0',NULL,'0.000000','0','60','d15c180c8f421f61194da74d838c774c',NULL,'1','0','0','2019-02-27 15:41:48','2019-02-27 15:41:48',NULL,NULL,''),
('212','1','1','2','3','1','1','GHEM ( HOPITAL SIMONE VEIL)','51 512 747 000','7022Z','Karine','Deschamps','karine.deschamps@ch-simoneveil.fr','','2019-02-27 15:41:51',NULL,'1',NULL,NULL,'0',NULL,'0.000000','0','60','312e5bb3dd5ae5cbb7989855e414c853',NULL,'1','0','0','2019-02-27 15:41:48','2019-02-27 15:41:48',NULL,NULL,''),
('213','1','1','1','2','1','1','CHU DE BREST','34 885 069 400','851A','','Douguet','jean-luc.douguet@chu-brest.fr','','2019-02-27 15:41:51',NULL,'0',NULL,NULL,'0',NULL,'0.000000','0','60','e23ca8b74209a7c1e0ed789312564b31',NULL,'1','0','0','2019-02-27 15:41:48','2019-02-27 15:41:48',NULL,NULL,''),
('214','1','1','1','2','1','1','TF6','43 445 792 500','7010Z','Damian','Deegan','ddeegan@tf6.fr','','2019-02-27 15:41:51',NULL,'1',NULL,NULL,'0',NULL,'0.000000','0','60','5c4f6f93626a105dfa232c423136f781',NULL,'1','0','0','2019-02-27 15:41:48','2019-02-27 15:41:48',NULL,NULL,''),
('215','1','1','2','3','1','1','ENSIMAG','49 247 975 300','9499Z','Carole','Meyrand','carole.meyrand@grenoble-inp.fr','','2019-02-27 15:41:51',NULL,'1',NULL,NULL,'0',NULL,'0.000000','0','60','7cb739f6889de5f48290f821149adfdc',NULL,'1','0','0','2019-02-27 15:41:48','2019-02-27 15:41:48',NULL,NULL,''),
('216','1','1','1','3','1','1','SERVICES DU PREMIER MINISTRE','12 000 103 700','8411z','Philippe','Beauclair','philippe.beauclair@pm.gouv.fr','','2019-02-27 15:41:51',NULL,'1',NULL,NULL,'0',NULL,'0.000000','0','60','9deef9a861b61c613d84a1e90fcc2e37',NULL,'1','0','0','2019-02-27 15:41:48','2019-02-27 15:41:48',NULL,NULL,''),
('217','1','1','1','3','1','1','SERVICES DU PREMIER MINISTRE','12 000 103 700','8411z','Gaël','Depienne','gael.depienne@pm.gouv.fr','','2019-02-27 15:41:51',NULL,'1',NULL,NULL,'0',NULL,'0.000000','0','60','6eb57e0d180cef3505d905c22121d3f5',NULL,'1','0','0','2019-02-27 15:41:48','2019-02-27 15:41:48',NULL,NULL,''),
('218','1','1','2','3','1','1','SERVICES DU PREMIER MINISTRE','12 000 103 700','8411z','Flore','Peretti-Esquivie','flore.peretti-esquivie@pm.gouv.fr','','2019-02-27 15:41:51',NULL,'1',NULL,NULL,'0',NULL,'0.000000','0','60','0f9d3fb019bb243802e2f400bd054c5e',NULL,'1','0','0','2019-02-27 15:41:48','2019-02-27 15:41:48',NULL,NULL,''),
('219','1','1','1','3','1','1','SERVICES DU PREMIER MINISTRE','12 000 103 700','8411z','Philippe','Rufas','philippe.rufas@pm.gouv.fr','','2019-02-27 15:41:51',NULL,'1',NULL,NULL,'0',NULL,'0.000000','0','60','2db4eea7dc37f598c981663bfa19f4f6',NULL,'1','0','0','2019-02-27 15:41:48','2019-02-27 15:41:48',NULL,NULL,''),
('220','1','1','1','2','1','1','MICAD INFORMATIQUE','39 540 755 400','4651Z','Stéphane','Jeannel','micadinfo@wanadoo.fr','','2019-02-27 15:41:51',NULL,'1',NULL,NULL,'0',NULL,'0.000000','0','60','6a12a6552636da24c46ee609d7951893',NULL,'1','0','0','2019-02-27 15:41:48','2019-02-27 15:41:48',NULL,NULL,''),
('221','1','1','1','3','1','1','SAP FRANCE SA','34 161 268 700','6202B','Raymond','Vierra','raymond.vierra@sap.com','','2019-02-27 15:41:51',NULL,'1',NULL,NULL,'0',NULL,'0.000000','0','60','1d89f3d64c3e2673e81b51946cd0671e',NULL,'1','0','0','2019-02-27 15:41:48','2019-02-27 15:41:48',NULL,NULL,''),
('222','1','1','2','3','1','1','SAP FRANCE SA','34 161 268 700','6202B','Rose-Marie','Giannone','rose-marie.giannone@sap.com','','2019-02-27 15:41:51',NULL,'1',NULL,NULL,'0',NULL,'0.000000','0','60','f81671c396dbc4d21a98a654cbd0f6b5',NULL,'1','0','0','2019-02-27 15:41:48','2019-02-27 15:41:48',NULL,NULL,''),
('223','1','1','1','3','1','1','EDR FRANCE','57 203 702 600','6419Z','','Robine','p.robine@edr.com','','2019-02-27 15:41:51',NULL,'1',NULL,NULL,'0',NULL,'0.000000','0','60','caa389c2620fc8dbfa960b520a9b7390',NULL,'1','0','0','2019-02-27 15:41:48','2019-02-27 15:41:48',NULL,NULL,''),
('224','1','1','2','3','1','1','EURECOM','38 318 157 500','8542Z','Marie-Laure','Victorin','marie-laure.victorin@eurecom.fr','','2019-02-27 15:41:51',NULL,'1',NULL,NULL,'0',NULL,'0.000000','0','60','b35e444d2a91d3c95d093fd3858b4da1',NULL,'1','0','0','2019-02-27 15:41:48','2019-02-27 15:41:48',NULL,NULL,''),
('225','1','1','2','3','1','1','CENTRE SCOLAIRE AUX LAZARISTES','30 461 408 400',NULL,'Patricia','Granjon','patricia.granjon@mail.auxlazaristes.fr','','2019-02-27 15:41:51',NULL,'1',NULL,NULL,'0',NULL,'0.000000','0','60','c0ec54e456c117b9cfce03f807e3655d',NULL,'1','0','0','2019-02-27 15:41:48','2019-02-27 15:41:48',NULL,NULL,''),
('226','1','1','2','3','1','1','CENTRE HOSPITALIER D'ORSAY','26 910 224 000','8610Z','Christine','Coupan','c.coupan@ch-orsay.fr','','2019-02-27 15:41:51',NULL,'1',NULL,NULL,'0',NULL,'0.000000','0','60','ac20612955f30bb57b5aa281252c7414',NULL,'1','0','0','2019-02-27 15:41:48','2019-02-27 15:41:48',NULL,NULL,''),
('227','1','1','1','3','1','1','EURINFOR','44 859 039 800','7733Z','Amancio','Ventuzelo','ave@eurinfor.fr','','2019-02-27 15:41:51',NULL,'1',NULL,NULL,'0',NULL,'0.000000','0','60','7b72a06da384bade64abccbafa0c1c03',NULL,'1','0','0','2019-02-27 15:41:48','2019-02-27 15:41:48',NULL,NULL,''),
('228','1','1','1','2','1','1','UFR GHSS Laboratoire SEDET Université de Jussieu P','19 751 722 000','803Z','Jacques','Tola','tola@paris7.jussieu.fr','','2019-02-27 15:41:51',NULL,'1',NULL,NULL,'0',NULL,'0.000000','0','60','c412ab4582fcd3403faed0509ac736e3',NULL,'1','0','0','2019-02-27 15:41:48','2019-02-27 15:41:48',NULL,NULL,''),
('229','1','1','1','2','1','1','TECNILAB','44 388 820 100','7112B','Philibert','Drevard','philibert.drevard@vxcd.fr','','2019-02-27 15:41:51',NULL,'1',NULL,NULL,'0',NULL,'0.000000','0','60','706f5b7c0a0c7ae709731013a8a846d1',NULL,'1','0','0','2019-02-27 15:41:48','2019-02-27 15:41:48',NULL,NULL,''),
('230','1','1','1','3','1','1','ESC ROUEN','63 204 104 224','8542Z','Frédéric','Dambrine','frederic.dambrine@groupe-esc-rouen.fr','','2019-02-27 15:41:51',NULL,'1',NULL,NULL,'0',NULL,'0.000000','0','60','16ed2f0aa466cc5db59d7334a36b5b70',NULL,'1','0','0','2019-02-27 15:41:48','2019-02-27 15:41:48',NULL,NULL,''),
('231','1','1','1','3','1','1','ESC ROUEN','63 204 104 224','8542Z','Frédéric','Dambrine','frederic.dambrine@esc-rouen.fr','','2019-02-27 15:41:51',NULL,'1',NULL,NULL,'0',NULL,'0.000000','0','60','9ac7328e823150daf0cdc6a8b4b51848',NULL,'1','0','0','2019-02-27 15:41:48','2019-02-27 15:41:48',NULL,NULL,''),
╔═══════════════════════════════╗
█ Format - .sql
█ Size file - 31Mb
█ Rows - 230K / Customers 11k
█ Date - 23.12.2022
█ Website -
You do not have permission to view link
Log in or register now.
╚═══════════════════════════════╝
Last edited: