Diff
366
448
448
oscommerce_sample_data.sql
  |
1 | | - | # $Id: oscommerce_sample_data.sql 366 2005-12-22 15:45:34Z hpdl $ |
| |
| 1 | + | # $Id: oscommerce_sample_data.sql 448 2006-02-21 06:27:28Z hpdl $ |
|
2 | 2 | | # |
| |
3 | 3 | | # osCommerce, Open Source E-Commerce Solutions |
| |
4 | 4 | | # http://www.oscommerce.com |
| |
5 | 5 | | # |
  |
6 | | - | # Copyright (c) 2004 osCommerce |
| |
| 6 | + | # Copyright (c) 2006 osCommerce |
|
7 | 7 | | # |
| |
8 | 8 | | # Released under the GNU General Public License |
| |
9 | 9 | | # |
| |
|
|
 |
… |
|
19 | 19 | | # * Comments should be like these, full line comments. |
| |
20 | 20 | | # (don't use inline comments) |
| |
21 | 21 | | |
  |
22 | | - | INSERT INTO osc_address_book VALUES ( '1', '1', 'm', 'ACME Inc.', 'John', 'Doe', '1 Way Street', '', '12345', 'NeverNever', '', '223', '12', '12345', ''); |
| |
23 | | - | |
|
24 | 22 | | INSERT INTO osc_banners VALUES (1, 'osCommerce', '', '', '468x60', '<script language=\'JavaScript\' type=\'text/javascript\' src=\'http://adserver.oscommerce.com/adx.js\'></script> |
| |
25 | 23 | | <script language=\'JavaScript\' type=\'text/javascript\'> |
| |
26 | 24 | | <!-- |
| |
|
|
 |
… |
|
119 | 117 | | INSERT INTO osc_categories_description VALUES ( '19', '3', 'Accion'); |
| |
120 | 118 | | INSERT INTO osc_categories_description VALUES ( '20', '3', 'Estrategia'); |
| |
121 | 119 | | |
  |
122 | | - | INSERT INTO osc_customers VALUES ( '1', 'm', 'John', 'doe', '2001-01-01 00:00:00', 'root@localhost', '1', '12345', '', 'd95e8fa7f20a009372eb3477473fcd34:1c', '0', '1', '127.0.0.1'); |
| |
123 | | - | |
| |
124 | | - | INSERT INTO osc_customers_info VALUES('1', null, '0', now(), null, '0'); |
| |
125 | | - | |
|
126 | 120 | | INSERT INTO osc_manufacturers VALUES (1,'Matrox','manufacturer_matrox.gif', now(), null); |
| |
127 | 121 | | INSERT INTO osc_manufacturers VALUES (2,'Microsoft','manufacturer_microsoft.gif', now(), null); |
| |
128 | 122 | | INSERT INTO osc_manufacturers VALUES (3,'Warner','manufacturer_warner.gif', now(), null); |
| |
|
|
 |
… |
|
377 | 371 | | INSERT INTO osc_products_to_categories VALUES (26,9); |
| |
378 | 372 | | INSERT INTO osc_products_to_categories VALUES (27,5); |
| |
379 | 373 | | |
  |
380 | | - | INSERT INTO osc_reviews VALUES (1,19,1,'John doe',5,1, 'this has to be one of the funniest movies released for 1999!', now(),null,0, 1); |
| |
| 374 | + | INSERT INTO osc_reviews VALUES (1,19,0,'John doe',5,1, 'this has to be one of the funniest movies released for 1999!', now(),null,0, 1); |
  |
381 | 375 | | |
| |
382 | 376 | | INSERT INTO osc_specials VALUES (1,3, 39.99, now(), null, null, null, null, '1'); |
| |
383 | 377 | | INSERT INTO osc_specials VALUES (2,5, 30.00, now(), null, null, null, null, '1'); |
|