Sql © Chucky Database Machado-malcher.pt SHOP
- Thread starter
- Administrator
- Moderator
- Thread Author
- #1
Database Machado-malcher.pt SHOP
HTML:
DROP TABLE IF EXISTS `pscn_customer`;
CREATE TABLE `pscn_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(64) DEFAULT NULL,
`siret` varchar(14) DEFAULT NULL,
`ape` varchar(5) DEFAULT NULL,
`firstname` varchar(32) NOT NULL,
`lastname` varchar(32) NOT NULL,
`email` varchar(128) NOT NULL,
`passwd` varchar(32) 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,
`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,
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 AUTO_INCREMENT=304 DEFAULT CHARSET=utf8;
INSERT INTO `pscn_customer` VALUES
('1','1','1','1','3','1','0',NULL,NULL,NULL,'John','DOE','pub@prestashop.com','87b77eec3db46c68dd9dfa0dcf8c717d','2017-01-17 03:04:14','1970-01-15','1',NULL,'2013-12-13 08:19:15','1',NULL,'0.000000','0','0','5ceacb92081bad43622a667346d8e336',NULL,'1','0','0','2017-02-26 19:02:04','2017-02-26 19:02:04'),
('2','1','1','2','3','2','0',NULL,NULL,NULL,'Maria','Aguiar','marianeves2020@gmail.com','80cfc53c5cf700a854e5156ae0c8f13d','2018-05-02 20:23:17','1965-02-11','1','89.155.117.109','2017-03-28 20:17:08','1',NULL,'0.000000','0','0','6245938d50881ea6df0154624ef38a80',NULL,'1','0','0','2017-03-28 20:17:10','2018-05-02 20:23:17'),
('3','1','1','1','3','2','1',NULL,NULL,NULL,'Mário','Aguiar','mario.aguiar@outlook.pt','809d6c9ba9d523f1378d8eb3769582a1','2018-06-04 18:03:07','0000-00-00','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','0e0e133e09be6f4a87773ba6588fb736',NULL,'1','0','0','2018-03-06 22:38:53','2018-06-10 16:27:03'),
('4','1','1','1','3','2','0',NULL,NULL,NULL,'Paulo','Leite','paulo.leite@machado-malcher.pt','5f03f86a72b003c048857d617dc82571','2018-03-08 12:51:39','0000-00-00','1',NULL,'2019-03-21 18:12:46','0',NULL,'0.000000','0','0','c26e7c80fe390b1d27d628b168b6f50f',NULL,'1','0','0','2018-03-08 18:51:39','2019-03-21 18:12:46'),
('6','1','1','2','3','2','0',NULL,NULL,NULL,'Rita','Ponceano','ritaponc@gmail.com','cab4d5439ec4a37533c89defd37a3dbe','2019-01-22 08:46:40','1986-06-19','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','e2dae191c208ca0f4a1c6ae2baed1d27',NULL,'1','0','0','2019-01-22 14:46:40','2019-01-22 14:46:40'),
('7','1','1','1','3','2','0','MRN Clínicas Lda',NULL,NULL,'Carlos','Ribeiro','clinicaintegraldent@gmail.com','47210bbba5bca978928eb8cd4c6be468','2019-02-21 06:54:29','1985-01-25','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','af0c2c2f4c0de7cd993ffa03dc37dd63',NULL,'1','0','0','2019-02-21 12:54:29','2019-02-21 12:54:29'),
('8','1','1','1','3','2','0','Vontade de Sorrir Unipessoal Lda',NULL,NULL,'Celso','Moreira','celso.mrr@gmail.com','75211c9bd7590558727adbb71a47f909','2019-02-22 18:14:34','1988-03-21','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','85eb6acbf592406845540ddc4db5e4bf',NULL,'1','0','0','2019-02-23 00:14:34','2019-02-23 00:14:34'),
('9','1','1','1','3','2','0','Machado, Malcher, Lda',NULL,NULL,'Marco','Aguiar','marco.aguiar@machado-malcher.pt','affb554a4d6b336784d9f66ed7697279','2019-03-13 05:27:29','1964-08-06','1',NULL,'2019-03-21 18:12:31','0',NULL,'0.000000','0','0','64d00f14153df9e399c62376c21cbaa4',NULL,'1','0','0','2019-03-13 11:27:29','2019-03-21 18:12:31'),
('10','1','1','2','3','2','0','JOANA ISABEL CARVALHO LOPES DA SILVA',NULL,NULL,'JOANA','SILVA','JOANASILVA.CMD@GMAIL.COM','b19d594d750754a13c9b39430fbe5af1','2019-05-21 10:26:19','1986-01-20','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','e185cf46884c9d2d551fef435d81f209',NULL,'1','0','0','2019-05-21 16:26:19','2019-05-21 16:26:19'),
('11','1','1','1','3','2','0','Clínica Medica Arrifana de Sousa',NULL,NULL,'Henrique','Silva','hicasteam@gmail.com','53448daf42ae953be4e0ba17eaa74559','2019-05-31 10:26:14','1994-03-14','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','6c74abbd36bcc8012d8fa7868cde32fb',NULL,'1','0','0','2019-05-31 16:26:14','2019-05-31 16:26:14'),
('12','1','1','0','3','2','0','Cristina Gomes',NULL,NULL,'Cristina','Gomes','krisoliv40@hotmail.com','b143d943269b143d855fc3449fdca436','2019-07-02 05:48:13','1969-10-03','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','119658872f1ddf4ddea2a9f480316920',NULL,'1','0','0','2019-07-02 11:48:13','2019-07-02 11:48:13'),
('13','1','1','0','3','2','0','PNS CLINIC, LDA',NULL,NULL,'Patricia ','Silva','geral@clinicadrapatriciasilva.com','73c6e3739b93a0c0bfd4b7be52a6d6e6','2022-06-17 15:53:50','1982-02-18','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','954496a1ec20a32587652a29dbf49db7',NULL,'1','0','0','2019-08-23 12:51:39','2022-06-17 15:53:50'),
('14','1','1','0','3','2','0','Consultorio de medicina dentaria Dr. Joao Sampaio',NULL,NULL,'Joao ','Sampaio','cdjoaosampaio@gmail.com','3da7b9a11c76989b11a56439952850bb','2019-09-06 13:37:43','1970-03-22','0',NULL,'0000-00-00 00:00:00','0',NULL,'0.000000','0','0','1df3b092e338f40fd30d3ad41de9f383',NULL,'1','0','0','2019-09-06 19:37:43','2019-09-06 19:37:43'),
