1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
| ps_customer
CREATE TABLE `ps_customer` (
`id_customer` bigint(25) unsigned NOT NULL AUTO_INCREMENT,
`id_gender` int(10) unsigned NOT NULL,
`id_default_group` int(10) unsigned NOT NULL DEFAULT '1',
`secure_key` varchar(32) NOT NULL DEFAULT '-1',
`email` varchar(128) NOT NULL,
`passwd` varchar(32) NOT NULL,
`last_passwd_gen` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`birthday` date DEFAULT NULL,
`lastname` varchar(32) NOT 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',
`firstname` varchar(32) NOT NULL,
`dni` varchar(16) DEFAULT NULL,
`active` tinyint(1) unsigned 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`),
UNIQUE KEY `customer_email` (`email`),
KEY `customer_login` (`email`,`passwd`),
KEY `id_customer_passwd` (`id_customer`,`passwd`),
KEY `id_gender` (`id_gender`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 |
Partager