b02S80Nn

1-- Tabellenstruktur für Tabelle `customers`
2--
3
4CREATE TABLE IF NOT EXISTS `customers` (
5  `customers_id` int(11) NOT NULL AUTO_INCREMENT,
6  `customers_cid` varchar(32) COLLATE latin1_german1_ci NOT NULL,
7  `customers_vat_id` varchar(20) COLLATE latin1_german1_ci DEFAULT NULL,
8  `customers_vat_id_status` int(2) NOT NULL DEFAULT '0',
9  `customers_warning` varchar(32) COLLATE latin1_german1_ci DEFAULT NULL,
10  `customers_status` int(5) NOT NULL DEFAULT '1',
11  `customers_gender` char(1) COLLATE latin1_german1_ci NOT NULL,
12  `customers_firstname` varchar(32) COLLATE latin1_german1_ci NOT NULL,
13  `customers_lastname` varchar(32) COLLATE latin1_german1_ci NOT NULL,
14  `customers_dob` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
15  `customers_email_address` varchar(96) COLLATE latin1_german1_ci NOT NULL,
16  `customers_default_address_id` int(11) NOT NULL,
17  `customers_telephone` varchar(32) COLLATE latin1_german1_ci NOT NULL,
18  `customers_fax` varchar(32) COLLATE latin1_german1_ci DEFAULT NULL,
19  `customers_mobile` varchar(32) COLLATE latin1_german1_ci DEFAULT NULL,
20  `customers_password` varchar(40) COLLATE latin1_german1_ci NOT NULL,
21  `customers_newsletter` char(1) COLLATE latin1_german1_ci DEFAULT NULL,
22  `customers_newsletter_mode` char(1) COLLATE latin1_german1_ci NOT NULL DEFAULT '0',
23  `member_flag` char(1) COLLATE latin1_german1_ci NOT NULL DEFAULT '0',
24  `delete_user` char(1) COLLATE latin1_german1_ci NOT NULL DEFAULT '1',
25  `account_type` int(1) NOT NULL DEFAULT '0',
26  `password_request_key` varchar(32) COLLATE latin1_german1_ci NOT NULL,
27  `payment_unallowed` varchar(255) COLLATE latin1_german1_ci NOT NULL,
28  `shipping_unallowed` varchar(255) COLLATE latin1_german1_ci NOT NULL,
29  `refferers_id` varchar(32) COLLATE latin1_german1_ci NOT NULL DEFAULT '0',
30  `customers_date_added` datetime DEFAULT '0000-00-00 00:00:00',
31  `customers_last_modified` datetime DEFAULT '0000-00-00 00:00:00',
32  `birthday_mail` tinyint(1) unsigned NOT NULL DEFAULT '0',
33  PRIMARY KEY (`customers_id`)
34) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci AUTO_INCREMENT=47 ;