91
Posts
Posts
201
Likes
Likes
Date: may 2023
Lines: 225748
Samples:
Download: https://anonfiles.com/FdC6q3q1z3/qntsport_in_sql
Lines: 225748
Samples:
Quote:DROP TABLE IF EXISTS `ps_customer`;
CREATE TABLE `ps_customer` (
`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(255) DEFAULT NULL,
`siret` varchar(14) DEFAULT NULL,
`ape` varchar(5) DEFAULT NULL,
`firstname` varchar(255) NOT NULL,
`lastname` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`passwd` varchar(255) NOT NULL,
`last_passwd_gen` timestamp NOT NULL DEFAULT current_timestamp(),
`birthday` date DEFAULT NULL,
`newsletter` tinyint(1) unsigned NOT NULL DEFAULT 0,
`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(100) DEFAULT NULL,
`reset_password_validity` datetime DEFAULT NULL,
PRIMARY KEY (`id_customer`),
KEY `customer_email` (`email`),
KEY `customer_login` (`email`,`passwd`),
KEY `id_customer_passwd` (`id_customer`,`passwd`),
KEY `id_gender` (`id_gender`),
KEY `id_shop_group` (`id_shop_group`),
KEY `id_shop` (`id_shop`,`date_add`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `ps_customer` (`id_customer`, `id_shop_group`, `id_shop`, `id_gender`, `id_default_group`, `id_lang`, `id_risk`, `company`, `siret`, `ape`, `firstname`, `lastname`, `email`, `passwd`, `last_passwd_gen`, `birthday`, `newsletter`, `ip_registration_newsletter`, `newsletter_date_add`, `optin`, `website`, `outstanding_allow_amount`, `show_public_prices`, `max_payment_days`, `secure_key`, `note`, `active`, `is_guest`, `deleted`, `date_add`, `date_upd`, `reset_password_token`, `reset_password_validity`) VALUES
(3, 1, 1, 0, 3, 2, 0, NULL, NULL, NULL, 'Valérie', 'Hubert', 'hubert.valerie@gmail.com', '9e735cdc868d17e9104219b9a4becaa2', '2015-07-10 16:13:41', '0000-00-00', 0, NULL, '0000-00-00 00:00:00', 0, NULL, 0.000000, 0, 0, '28b4a0eca0de969c9f19e88fcdebd8a3', NULL, 1, 0, 0, '2014-10-18 02:01:04', '2015-07-10 18:14:29', NULL, NULL),
(4, 1, 1, 1, 3, 2, 0, NULL, NULL, NULL, 'Francois', 'Saussez', 'francois@qntsport.com', '981a6de00b2ecc17246ddaa9a51347c4', '2014-10-18 02:47:41', '1977-05-11', 0, NULL, '0000-00-00 00:00:00', 0, NULL, 0.000000, 0, 0, 'a0ffeceaa66820b0f8d9639b6ea5468e', NULL, 1, 0, 0, '2014-10-18 10:17:41', '2014-10-18 10:17:41', NULL, NULL),
(5, 1, 7, 1, 3, 2, 0, NULL, NULL, NULL, 'Michel', 'Gourdin', 'gourdinmichel54@yahoo.fr', '80c30b84fbd59cbec4efddd84f475353', '2014-10-18 07:09:15', '1978-04-30', 0, NULL, '0000-00-00 00:00:00', 0, NULL, 0.000000, 0, 0, 'b7b84ebebd54a33b9e1c102905a1890e', NULL, 1, 0, 0, '2014-10-18 14:39:15', '2014-10-18 14:39:15', NULL, NULL),
(6, 1, 7, 1, 3, 2, 0, NULL, NULL, NULL, 'Frédéric ', 'garcia ', 'fredericgarcia81@sfr.fr', 'c82e82e14cc9901ebd1349a34b8f5fc6', '2014-10-19 04:46:07', '1979-02-24', 0, NULL, '0000-00-00 00:00:00', 0, NULL, 0.000000, 0, 0, '6df1ef9c06cf37d9173d2847479c0bf7', NULL, 1, 0, 0, '2014-10-19 12:16:07', '2014-10-19 12:16:07', NULL, NULL),
(7, 1, 1, 1, 3, 2, 0, NULL, NULL, NULL, 'Julien', 'ausser', 'julienausser@hotmail.com', '6756bf6f88f8383e3e3f9a765b529f75', '2014-10-19 05:14:56', '1995-08-23', 0, NULL, '0000-00-00 00:00:00', 1, NULL, 0.000000, 0, 0, '4baa974cbe73a0b08490af2bd45633a9', NULL, 1, 0, 0, '2014-10-19 12:44:56', '2014-10-19 12:44:56', NULL, NULL),
(8, 1, 7, 1, 3, 2, 0, NULL, NULL, NULL, 'Anthony', 'Graziani', 'anthograziani@hotmail.fr', 'b82a974911634831ffbd9c18e242c47a', '2014-10-19 07:26:32', '1992-06-12', 0, NULL, '0000-00-00 00:00:00', 0, NULL, 0.000000, 0, 0, '8c4a5414de2b1bfbb12434e55054ce6f', NULL, 1, 0, 0, '2014-10-19 14:56:32', '2014-10-19 14:56:32', NULL, NULL),
Download: https://anonfiles.com/FdC6q3q1z3/qntsport_in_sql