  |
1 | | - | # $Id: oscommerce.sql 1498 2007-03-29 14:04:50Z hpdl $ |
| |
| 1 | + | # $Id: oscommerce.sql 1512 2007-03-29 23:46:41Z hpdl $ |
|
2 | 2 | | # |
| |
3 | 3 | | # osCommerce, Open Source E-Commerce Solutions |
| |
4 | 4 | | # http://www.oscommerce.com |
| |
|
|
 |
… |
|
8 | 8 | | # This program is free software; you can redistribute it and/or modify |
| |
9 | 9 | | # it under the terms of the GNU General Public License v2 (1991) |
| |
10 | 10 | | # as published by the Free Software Foundation. |
 |
11 | | - | # |
| |
12 | | - | # NOTE: * Please make any modifications to this file by hand! |
| |
13 | | - | # * DO NOT use a mysqldump created file for new changes! |
| |
14 | | - | # * Please take note of the table structure, and use this |
| |
15 | | - | # structure as a standard for future modifications! |
| |
16 | | - | # * Any tables you add here should be added in admin/backup.php |
| |
17 | | - | # and in catalog/install/includes/functions/database.php |
| |
18 | | - | # * To see the 'diff'erence between MySQL databases, use |
| |
19 | | - | # the mysqldiff perl script located in the extras |
| |
20 | | - | # directory of the 'catalog' module. |
| |
21 | | - | # * Comments should be like these, full line comments. |
| |
22 | | - | # (don't use inline comments) |
|
23 | 11 | | |
| |
24 | 12 | | DROP TABLE IF EXISTS osc_address_book; |
| |
25 | 13 | | CREATE TABLE osc_address_book ( |
| |
|
|
|
… |
|
234 | 222 | | currencies_id int NOT NULL, |
| |
235 | 223 | | numeric_separator_decimal varchar(12) NOT NULL, |
| |
236 | 224 | | numeric_separator_thousands varchar(12) NOT NULL, |
|
| 225 | + | parent_id int DEFAULT 0, |
|
237 | 226 | | sort_order int(3), |
| |
238 | 227 | | PRIMARY KEY (languages_id) |
| |
239 | 228 | | ); |
| |
|
|
|
… |
|
1079 | 1068 | | INSERT INTO osc_currencies VALUES (2,'Euro','EUR','€','','2','1.2076', now()); |
| |
1080 | 1069 | | INSERT INTO osc_currencies VALUES (3,'British Pounds','GBP','£','','2','1.7587', now()); |
| |
1081 | 1070 | | |
|
1082 | | - | INSERT INTO osc_languages VALUES (1,'English','en_US','en_US.UTF-8,en_US,english','utf-8','%m/%d/%Y','%A %d %B, %Y','%H:%M:%S','ltr',1,'.',',',1); |
| |
| 1071 | + | INSERT INTO osc_languages VALUES (1,'English','en_US','en_US.UTF-8,en_US,english','utf-8','%m/%d/%Y','%A %d %B, %Y','%H:%M:%S','ltr',1,'.',',',0,1); |
|
1083 | 1072 | | |
| |
1084 | 1073 | | INSERT INTO osc_orders_status VALUES ( '1', '1', 'Pending'); |
| |
1085 | 1074 | | INSERT INTO osc_orders_status VALUES ( '2', '1', 'Processing'); |