  |
1 | | - | # $Id: oscommerce.sql 1157 2006-11-22 23:11:13Z hpdl $ |
| |
| 1 | + | # $Id: oscommerce.sql 1316 2007-03-05 05:06:50Z hpdl $ |
|
2 | 2 | | # |
| |
3 | 3 | | # osCommerce, Open Source E-Commerce Solutions |
| |
4 | 4 | | # http://www.oscommerce.com |
| |
5 | 5 | | # |
 |
6 | | - | # Copyright (c) 2006 osCommerce |
| |
| 6 | + | # Copyright (c) 2007 osCommerce |
|
7 | 7 | | # |
| |
8 | 8 | | # Released under the GNU General Public License |
| |
9 | 9 | | # |
| |
|
|
 |
… |
|
172 | 172 | | DROP TABLE IF EXISTS osc_customers; |
| |
173 | 173 | | CREATE TABLE osc_customers ( |
| |
174 | 174 | | customers_id int NOT NULL auto_increment, |
|
175 | | - | customers_gender char(1) NOT NULL, |
| |
| 175 | + | customers_gender char(1), |
|
176 | 176 | | customers_firstname varchar(32) NOT NULL, |
| |
177 | 177 | | customers_lastname varchar(32) NOT NULL, |
|
178 | | - | customers_dob datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, |
| |
| 178 | + | customers_dob datetime, |
|
179 | 179 | | customers_email_address varchar(96) NOT NULL, |
|
180 | | - | customers_default_address_id int NOT NULL, |
| |
181 | | - | customers_telephone varchar(32) NOT NULL, |
| |
| 180 | + | customers_default_address_id int, |
| |
| 181 | + | customers_telephone varchar(32), |
|
182 | 182 | | customers_fax varchar(32), |
|
183 | | - | customers_password varchar(40) NOT NULL, |
| |
| 183 | + | customers_password varchar(40), |
|
184 | 184 | | customers_newsletter char(1), |
| |
185 | 185 | | customers_status int(1) DEFAULT '0', |
| |
186 | 186 | | customers_ip_address varchar(15), |