FishEye: diff osCommerce/trunk/oscommerce/install/oscommerce_sample

1

-

# $Id: oscommerce_sample_data.sql 1498 2007-03-29 14:04:50Z hpdl $

1

+

# $Id: oscommerce_sample_data.sql 1862 2009-03-06 23:34:07Z hpdl $

2

#

3

# osCommerce, Open Source E-Commerce Solutions

4

# http://www.oscommerce.com

5

#

6

-

6

+

7

#

8

# This program is free software; you can redistribute it and/or modify

9

# it under the terms of the GNU General Public License v2 (1991)

31

32

INSERT INTO osc_manufacturers_info VALUES (1, 1, 'http://www.apress.com', 0, null);

33

34

-

INSERT INTO osc_products VALUES (1, 10, 44.99, now(), now(), null, 1.8, 4, 1, 1, 1, 0);

34

+

INSERT INTO osc_products VALUES (1, 0, 10, 44.99, '1590595084', now(), now(), 1.8, 4, 1, 1, 1, 0, 0);

35

36

-

INSERT INTO osc_products_description VALUES (1, 1, 'Pro PHP Security', '<p><i>Pro PHP Security</i> is one of the first books devoted solely to PHP security. It will serve as your complete guide for taking defensive and proactive security measures within your PHP applications. (And the methods discussed are compatible with PHP versions 3, 4, and 5.)</p><p>The knowledge you\'ll gain from this comprehensive guide will help you prevent attackers from potentially disrupting site operation or destroying data. And you\'ll learn about various security measures, for example, creating and deploying "captchas," validating e-mail, fending off SQL injection attacks, and preventing cross-site scripting attempts.</p><h3>Author Information</h3><p align="justify"><h4>Chris Snyder</h4><p>Chris Snyder is a software engineer at Fund for the City of New York, where he helps develop next-generation websites and services for nonprofit organizations. He is a member of the Executive Board of New York PHP, and has been looking for new ways to build scriptable, linked, multimedia content since he saw his first Hypercard stack in 1988.</p></p><p align="justify"><h4>Michael Southwell</h4><p>Michael Southwell is a retired English professor who has been developing websites for more than 10 years in the small business, nonprofit, and educational areas, with special interest in problems of accessibility. He has authored and co-authored 8 books and numerous articles about writing, writing and computers, and writing education. He is a member of the Executive Board of New York PHP, and a Zend Certified Engineer.</p></p>', '1590595084', 'pro_php_security', 'pro php security book apress', '', 0);

36

+

INSERT INTO osc_products_description VALUES (1, 1, 'Pro PHP Security', '<p><i>Pro PHP Security</i> is one of the first books devoted solely to PHP security. It will serve as your complete guide for taking defensive and proactive security measures within your PHP applications. (And the methods discussed are compatible with PHP versions 3, 4, and 5.)</p><p>The knowledge you\'ll gain from this comprehensive guide will help you prevent attackers from potentially disrupting site operation or destroying data. And you\'ll learn about various security measures, for example, creating and deploying "captchas," validating e-mail, fending off SQL injection attacks, and preventing cross-site scripting attempts.</p><h3>Author Information</h3><p align="justify"><h4>Chris Snyder</h4><p>Chris Snyder is a software engineer at Fund for the City of New York, where he helps develop next-generation websites and services for nonprofit organizations. He is a member of the Executive Board of New York PHP, and has been looking for new ways to build scriptable, linked, multimedia content since he saw his first Hypercard stack in 1988.</p></p><p align="justify"><h4>Michael Southwell</h4><p>Michael Southwell is a retired English professor who has been developing websites for more than 10 years in the small business, nonprofit, and educational areas, with special interest in problems of accessibility. He has authored and co-authored 8 books and numerous articles about writing, writing and computers, and writing education. He is a member of the Executive Board of New York PHP, and a Zend Certified Engineer.</p></p>', 'pro_php_security', 'pro php security book apress', '', 0);

37

38

#INSERT INTO osc_products_attributes VALUES (1,1,4,1,0.00,'+');

39

#INSERT INTO osc_products_attributes VALUES (2,1,4,2,50.00,'+');

87

88

#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);

89

90

+

INSERT INTO osc_shipping_availability values (1, 1, 'Ships within 24 hours.', 'ships24hours');

91

+

90

92

#INSERT INTO osc_specials VALUES (1,3, 39.99, now(), null, null, null, null, '1');

91

93

#INSERT INTO osc_specials VALUES (2,5, 30.00, now(), null, null, null, null, '1');

92

94

#INSERT INTO osc_specials VALUES (3,6, 30.00, now(), null, null, null, null, '1');

FishEye

Mode

Context

Other Diffs

Ignore

Diff