<div dir="ltr"><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small;color:rgb(0,0,0)">This looks just as messy (tons of tables, fields, and duplicated data) as I saw in the (in)famous osCommerce shopping cart software a few years ago. Furthermore, the tables and fields here (in OpenCart) look remarkably similar to those in osCommerce.<br>
<br></div><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small;color:rgb(0,0,0)">As a bit of an aside, I wouldn't trust or use anything derived from osCommerce, including the very pricey Magento cart.<br>
</div><div class="gmail_extra"><div class="gmail_default" style="font-family:verdana,sans-serif;font-size:small;color:rgb(0,0,0)"> </div><span style="font-family:verdana,sans-serif">Hartmut Sager<br></span><div><div dir="ltr">
<br></div></div>
<br><div class="gmail_quote">On 9 April 2014 16:40, Bradford C. Vokey <span dir="ltr"><<a href="mailto:brad@fsi.ca" target="_blank">brad@fsi.ca</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
Further to the number of database tables Opencart creates with its default modules:<br>
<br>
The answer is...<br>
MariaDB [spiritoos]> show tables;<br>
<br>
+-----------------------------<u></u>------+<br>
| Tables_in_spiritoos |<br>
+-----------------------------<u></u>------+<br>
| oc_address |<br>
| oc_affiliate |<br>
| oc_affiliate_transaction |<br>
| oc_attribute |<br>
| oc_attribute_description |<br>
| oc_attribute_group |<br>
| oc_attribute_group_description |<br>
| oc_banner |<br>
| oc_banner_image |<br>
| oc_banner_image_description |<br>
| oc_category |<br>
| oc_category_description |<br>
| oc_category_filter |<br>
| oc_category_path |<br>
| oc_category_to_layout |<br>
| oc_category_to_store |<br>
| oc_country |<br>
| oc_coupon |<br>
| oc_coupon_category |<br>
| oc_coupon_history |<br>
| oc_coupon_product |<br>
| oc_currency |<br>
| oc_custom_field |<br>
| oc_custom_field_description |<br>
| oc_custom_field_to_customer_<u></u>group |<br>
| oc_custom_field_value |<br>
| oc_custom_field_value_<u></u>description |<br>
| oc_customer |<br>
| oc_customer_ban_ip |<br>
| oc_customer_field |<br>
| oc_customer_group |<br>
| oc_customer_group_description |<br>
| oc_customer_history |<br>
| oc_customer_ip |<br>
| oc_customer_online |<br>
| oc_customer_reward |<br>
| oc_customer_transaction |<br>
| oc_download |<br>
| oc_download_description |<br>
| oc_extension |<br>
| oc_filter |<br>
| oc_filter_description |<br>
| oc_filter_group |<br>
| oc_filter_group_description |<br>
| oc_geo_zone |<br>
| oc_information |<br>
| oc_information_description |<br>
| oc_information_to_layout |<br>
| oc_information_to_store |<br>
| oc_language |<br>
| oc_layout |<br>
| oc_layout_route |<br>
| oc_length_class |<br>
| oc_length_class_description |<br>
| oc_manufacturer |<br>
| oc_manufacturer_to_store |<br>
| oc_option |<br>
| oc_option_description |<br>
| oc_option_value |<br>
| oc_option_value_description |<br>
| oc_order |<br>
| oc_order_download |<br>
| oc_order_field |<br>
| oc_order_fraud |<br>
| oc_order_history |<br>
| oc_order_option |<br>
| oc_order_product |<br>
| oc_order_status |<br>
| oc_order_total |<br>
| oc_order_voucher |<br>
| oc_product |<br>
| oc_product_attribute |<br>
| oc_product_description |<br>
| oc_product_discount |<br>
| oc_product_filter |<br>
| oc_product_image |<br>
| oc_product_option |<br>
| oc_product_option_value |<br>
| oc_product_related |<br>
| oc_product_reward |<br>
| oc_product_special |<br>
| oc_product_to_category |<br>
| oc_product_to_download |<br>
| oc_product_to_layout |<br>
| oc_product_to_store |<br>
| oc_return |<br>
| oc_return_action |<br>
| oc_return_history |<br>
| oc_return_reason |<br>
| oc_return_status |<br>
| oc_review |<br>
| oc_setting |<br>
| oc_stock_status |<br>
| oc_store |<br>
| oc_tax_class |<br>
| oc_tax_rate |<br>
| oc_tax_rate_to_customer_group |<br>
| oc_tax_rule |<br>
| oc_url_alias |<br>
| oc_user |<br>
| oc_user_group |<br>
| oc_voucher |<br>
| oc_voucher_history |<br>
| oc_voucher_theme |<br>
| oc_voucher_theme_description |<br>
| oc_weight_class |<br>
| oc_weight_class_description |<br>
| oc_zone |<br>
| oc_zone_to_geo_zone |<br>
+-----------------------------<u></u>------+<br>
109 rows in set (0.00 sec)<br>
<br>
... with LOTS of duplication of data... sigh...<br>
<br>
Brad.<br>
______________________________<u></u>_________________<br>
Roundtable mailing list<br>
<a href="mailto:Roundtable@muug.mb.ca" target="_blank">Roundtable@muug.mb.ca</a><br>
<a href="http://www.muug.mb.ca/mailman/listinfo/roundtable" target="_blank">http://www.muug.mb.ca/mailman/<u></u>listinfo/roundtable</a><br>
</blockquote></div><br></div></div>