  |
1 | | - | # $Id: oscommerce.sql 808 2006-08-26 18:53:33Z hpdl $ |
| |
| 1 | + | # $Id: oscommerce.sql 814 2006-08-27 15:28:23Z hpdl $ |
|
2 | 2 | | # |
| |
3 | 3 | | # osCommerce, Open Source E-Commerce Solutions |
| |
4 | 4 | | # http://www.oscommerce.com |
| |
|
|
 |
… |
|
166 | 166 | | |
| |
167 | 167 | | DROP TABLE IF EXISTS osc_customers; |
| |
168 | 168 | | CREATE TABLE osc_customers ( |
 |
169 | | - | customers_id int NOT NULL auto_increment, |
| |
170 | | - | customers_gender char(1) NOT NULL, |
| |
171 | | - | customers_firstname varchar(32) NOT NULL, |
| |
172 | | - | customers_lastname varchar(32) NOT NULL, |
| |
173 | | - | customers_dob datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, |
| |
174 | | - | customers_email_address varchar(96) NOT NULL, |
| |
175 | | - | customers_default_address_id int NOT NULL, |
| |
176 | | - | customers_telephone varchar(32) NOT NULL, |
| |
177 | | - | customers_fax varchar(32), |
| |
178 | | - | customers_password varchar(40) NOT NULL, |
| |
179 | | - | customers_newsletter char(1), |
| |
180 | | - | customers_status int(1) DEFAULT '0', |
| |
181 | | - | customers_ip_address varchar(15), |
| |
182 | | - | PRIMARY KEY (customers_id) |
| |
| 169 | + | customers_id int NOT NULL auto_increment, |
| |
| 170 | + | customers_gender char(1) NOT NULL, |
| |
| 171 | + | customers_firstname varchar(32) NOT NULL, |
| |
| 172 | + | customers_lastname varchar(32) NOT NULL, |
| |
| 173 | + | customers_dob datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, |
| |
| 174 | + | customers_email_address varchar(96) NOT NULL, |
| |
| 175 | + | customers_default_address_id int NOT NULL, |
| |
| 176 | + | customers_telephone varchar(32) NOT NULL, |
| |
| 177 | + | customers_fax varchar(32), |
| |
| 178 | + | customers_password varchar(40) NOT NULL, |
| |
| 179 | + | customers_newsletter char(1), |
| |
| 180 | + | customers_status int(1) DEFAULT '0', |
| |
| 181 | + | customers_ip_address varchar(15), |
| |
| 182 | + | date_last_logon datetime, |
| |
| 183 | + | number_of_logons int(5), |
| |
| 184 | + | date_account_created datetime, |
| |
| 185 | + | date_account_last_modified datetime, |
| |
| 186 | + | global_product_notifications int(1) DEFAULT '0', |
| |
| 187 | + | PRIMARY KEY (customers_id) |
|
183 | 188 | | ); |
| |
184 | 189 | | |
| |
185 | 190 | | DROP TABLE IF EXISTS osc_customers_basket; |
| |
|
|
|
… |
|
193 | 198 | | PRIMARY KEY (customers_basket_id) |
| |
194 | 199 | | ); |
| |
195 | 200 | | |
|
196 | | - | DROP TABLE IF EXISTS osc_customers_basket_attributes; |
| |
197 | | - | CREATE TABLE osc_customers_basket_attributes ( |
| |
198 | | - | customers_basket_attributes_id int NOT NULL auto_increment, |
| |
199 | | - | customers_id int NOT NULL, |
| |
200 | | - | products_id tinytext NOT NULL, |
| |
201 | | - | products_options_id int NOT NULL, |
| |
202 | | - | products_options_value_id int NOT NULL, |
| |
203 | | - | PRIMARY KEY (customers_basket_attributes_id) |
| |
204 | | - | ); |
| |
205 | | - | |
| |
206 | | - | DROP TABLE IF EXISTS osc_customers_info; |
| |
207 | | - | CREATE TABLE osc_customers_info ( |
| |
208 | | - | customers_info_id int NOT NULL, |
| |
209 | | - | customers_info_date_of_last_logon datetime, |
| |
210 | | - | customers_info_number_of_logons int(5), |
| |
211 | | - | customers_info_date_account_created datetime, |
| |
212 | | - | customers_info_date_account_last_modified datetime, |
| |
213 | | - | global_product_notifications int(1) DEFAULT '0', |
| |
214 | | - | PRIMARY KEY (customers_info_id) |
| |
215 | | - | ); |
| |
216 | | - | |
|
217 | 201 | | DROP TABLE IF EXISTS osc_languages; |
| |
218 | 202 | | CREATE TABLE osc_languages ( |
| |
219 | 203 | | languages_id int NOT NULL auto_increment, |