# $Id$
#
# osCommerce, Open Source E-Commerce Solutions
# http://www.oscommerce.com
#
# Copyright (c) 2009 osCommerce
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License v2 (1991)
# as published by the Free Software Foundation.
#
# NOTE: * Please make any modifications to this file by hand!
#       * DO NOT use a mysqldump created file for new changes!
#       * Please take note of the table structure, and use this
#         structure as a standard for future modifications!
#       * Any tables you add here should be added in admin/backup.php
#         and in catalog/install/includes/functions/database.php
#       * To see the 'diff'erence between MySQL databases, use
#         the mysqldiff perl script located in the extras
#         directory of the 'catalog' module.
#       * Comments should be like these, full line comments.
#         (don't use inline comments)

INSERT INTO osc_products_variants_groups VALUES (1, 1, 'Size', 1, 'pull_down_menu');
INSERT INTO osc_products_variants_groups VALUES (2, 1, 'Colour', 2, 'pull_down_menu');
INSERT INTO osc_products_variants_groups VALUES (3, 1, 'Material', 3, 'radio_buttons');
INSERT INTO osc_products_variants_groups VALUES (4, 1, 'Text', 4, 'text_field');

INSERT INTO osc_products_variants_values VALUES (1, 1, 1, 'Small', 1);
INSERT INTO osc_products_variants_values VALUES (2, 1, 1, 'Medium', 2);
INSERT INTO osc_products_variants_values VALUES (3, 1, 1, 'Large', 3);
INSERT INTO osc_products_variants_values VALUES (4, 1, 2, 'White', 1);
INSERT INTO osc_products_variants_values VALUES (5, 1, 2, 'Black', 2);
INSERT INTO osc_products_variants_values VALUES (6, 1, 3, 'Soft', 1);
INSERT INTO osc_products_variants_values VALUES (7, 1, 3, 'Hard', 2);
INSERT INTO osc_products_variants_values VALUES (8, 1, 4, 'Front', 1);
INSERT INTO osc_products_variants_values VALUES (9, 1, 4, 'Back', 2);

INSERT INTO osc_categories VALUES (1, 'books.gif', 0, 1, now(), null);
INSERT INTO osc_categories VALUES (2, 'php.gif', 1, 1, now(), null);
INSERT INTO osc_categories VALUES (3, '', 0, 2, now(), null);
INSERT INTO osc_categories VALUES (4, '', 0, 3, now(), null);

INSERT INTO osc_categories_description VALUES (1, 1, 'Books');
INSERT INTO osc_categories_description VALUES (2, 1, 'PHP');
INSERT INTO osc_categories_description VALUES (3, 1, 'Gadgets');
INSERT INTO osc_categories_description VALUES (4, 1, 'Merchandise');

INSERT INTO osc_manufacturers VALUES (1, 'Apress', 'apress.gif', now(), null);
INSERT INTO osc_manufacturers VALUES (2, 'Dymo', 'dymo.gif', now(), null);

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

INSERT INTO osc_products VALUES (1, 0, 10, 44.99, '1590595084', now(), now(), 1.8, 4, 1, 1, 1, 0, 0);
INSERT INTO osc_products VALUES (2, 0, 0, 0, '', now(), now(), 0, 0, 1, 0, 2, 0, 1);
INSERT INTO osc_products VALUES (3, 2, 50, 139, 'DYMO400B', now(), null, 1, 2, 1, 1, 2, 0, 0);
INSERT INTO osc_products VALUES (4, 2, 20, 139, 'DYMO400W', now(), null, 1, 2, 1, 1, 2, 0, 0);
INSERT INTO osc_products VALUES (5, 0, 0, 0, '', now(), now(), 0, 0, 1, 0, 0, 0, 1);
INSERT INTO osc_products VALUES (6, 5, 20, 20, 'OSCSHIRTM', now(), null, 1, 2, 1, 1, 0, 0, 0);
INSERT INTO osc_products VALUES (7, 5, 20, 25, 'OSCSHIRTL', now(), null, 1, 2, 1, 1, 0, 0, 0);

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><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>', 'pro_php_security', 'pro php security book apress', '', 0);
INSERT INTO osc_products_description VALUES (2, 1, 'LabelWriter 400 Turbo', '<p>Compact, lightning-quick and easy to use – this LabelWriter is the fastest PC-and-Mac compatible label printer in its class. A customer favorite, 400 Turbo prints high-resolution labels for envelopes, packages, files, folders, media, name badges and more – directly from Microsoft® Word, WordPerfect®, Outlook®, QuickBooks®, ACT!® and other popular software.</p><h4>Features & Benefits</h4><ul><li>Eliminates the hassle of printing labels with a standard office printer.</li><li>Direct thermal printing means you never change a ribbon, toner or ink cartridges. The only supplies you ever need are the labels.</li><li>Super fast print speed. About 1 second per label, 55 labels per minute. Very quiet.</li></ul>', 'labelwriter_400_turbo', 'label printer', 'http://global.dymo.com/enUS/Products/LabelWriter_400_Turbo.html', 0);
INSERT INTO osc_products_description VALUES (5, 1, 'osCommerce T-Shirt', '<p>osCommerce t-shirt made from 100% cotton.</p>', 'oscommerce-tshirt', 'tshirt', '', 0);

INSERT INTO osc_products_variants VALUES (3, 5, 1);
INSERT INTO osc_products_variants VALUES (4, 4, 0);
INSERT INTO osc_products_variants VALUES (6, 2, 1);
INSERT INTO osc_products_variants VALUES (6, 8, 1);
INSERT INTO osc_products_variants VALUES (7, 3, 0);
INSERT INTO osc_products_variants VALUES (7, 8, 0);

INSERT INTO osc_products_to_categories VALUES (1, 2);
INSERT INTO osc_products_to_categories VALUES (2, 3);
INSERT INTO osc_products_to_categories VALUES (5, 4);

INSERT INTO osc_products_images VALUES (1, 1, 'pro_php_security.jpg', 1, 1, now());
INSERT INTO osc_products_images VALUES (2, 2, 'dymo400.png', 1, 1, now());
INSERT INTO osc_products_images VALUES (3, 5, 'front.png', 1, 1, now());
INSERT INTO osc_products_images VALUES (4, 5, 'back.png', 0, 2, now());

INSERT INTO osc_product_attributes VALUES (21, 1, 0, 1);
INSERT INTO osc_product_attributes VALUES (21, 2, 0, 2);

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

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

#INSERT INTO osc_specials VALUES (1,3, 39.99, now(), null, null, null, null, '1');
#INSERT INTO osc_specials VALUES (2,5, 30.00, now(), null, null, null, null, '1');
#INSERT INTO osc_specials VALUES (3,6, 30.00, now(), null, null, null, null, '1');
#INSERT INTO osc_specials VALUES (4,16, 29.99, now(), null, null, null, null, '1');
