# phpMyAdmin MySQL-Dump
# version 2.5.1
# http://www.phpmyadmin.net/ (download page)
#
# --------------------------------------------------------

DROP TABLE IF EXISTS mos_banner;
DROP TABLE IF EXISTS mos_bannerclient;
DROP TABLE IF EXISTS mos_bannerfinish;
DROP TABLE IF EXISTS mos_categories;
DROP TABLE IF EXISTS mos_components;
DROP TABLE IF EXISTS mos_contact_details;
DROP TABLE IF EXISTS mos_content;
DROP TABLE IF EXISTS mos_content_frontpage;
DROP TABLE IF EXISTS mos_content_rating;
DROP TABLE IF EXISTS mos_core_acl_aro;
DROP TABLE IF EXISTS mos_core_acl_aro_groups;
DROP TABLE IF EXISTS mos_core_acl_aro_sections;
DROP TABLE IF EXISTS mos_core_acl_groups_aro_map;
DROP TABLE IF EXISTS mos_core_log_items;
DROP TABLE IF EXISTS mos_core_log_searches;
DROP TABLE IF EXISTS mos_groups;
DROP TABLE IF EXISTS mos_help;
DROP TABLE IF EXISTS mos_mambots;
DROP TABLE IF EXISTS mos_menu;
DROP TABLE IF EXISTS mos_messages;
DROP TABLE IF EXISTS mos_messages_cfg;
DROP TABLE IF EXISTS mos_modules;
DROP TABLE IF EXISTS mos_modules_menu;
DROP TABLE IF EXISTS mos_newsfeeds;
DROP TABLE IF EXISTS mos_newsflash;
DROP TABLE IF EXISTS mos_poll_data;
DROP TABLE IF EXISTS mos_poll_date;
DROP TABLE IF EXISTS mos_poll_menu;
DROP TABLE IF EXISTS mos_polls;
DROP TABLE IF EXISTS mos_sections;
DROP TABLE IF EXISTS mos_session;
DROP TABLE IF EXISTS mos_stats_agents;
DROP TABLE IF EXISTS mos_templates;
DROP TABLE IF EXISTS mos_template_positions;
DROP TABLE IF EXISTS mos_templates_menu;
DROP TABLE IF EXISTS mos_users;
DROP TABLE IF EXISTS mos_usertypes;
DROP TABLE IF EXISTS mos_weblinks;

############################################################
# DELETE TABLES FOR mambo-phpShop Component
############################################################

DROP TABLE IF EXISTS `mos_pshop_affiliate_sale`;
DROP TABLE IF EXISTS `mos_pshop_affiliate`;

DROP TABLE IF EXISTS  `mos_pshop_auth_user_vendor`;

DROP TABLE IF EXISTS  `mos_pshop_category`;

DROP TABLE IF EXISTS  `mos_pshop_category_xref`;

DROP TABLE IF EXISTS  `mos_pshop_country`;

DROP TABLE IF EXISTS  `mos_pshop_creditcard`;

DROP TABLE IF EXISTS  `mos_pshop_csv`;

DROP TABLE IF EXISTS  `mos_pshop_currency`;

DROP TABLE IF EXISTS `mos_pshop_coupons`;

DROP TABLE IF EXISTS  `mos_pshop_function`;

DROP TABLE IF EXISTS `mos_pshop_manufacturer`;

DROP TABLE IF EXISTS `mos_pshop_manufacturer_category`;

DROP TABLE IF EXISTS  `mos_pshop_module`;

DROP TABLE IF EXISTS  `mos_pshop_order_item`;

DROP TABLE IF EXISTS  `mos_pshop_order_payment`;

DROP TABLE IF EXISTS  `mos_pshop_order_status`;

DROP TABLE IF EXISTS  `mos_pshop_order_user_info`;

DROP TABLE IF EXISTS  `mos_pshop_orders`;

DROP TABLE IF EXISTS  `mos_pshop_payment_method`;

DROP TABLE IF EXISTS  `mos_pshop_product`;

DROP TABLE IF EXISTS  `mos_pshop_product_attribute`;

DROP TABLE IF EXISTS  `mos_pshop_product_attribute_sku`;

DROP TABLE IF EXISTS  `mos_pshop_product_category_xref`;

DROP TABLE IF EXISTS `mos_pshop_product_mf_xref`;

DROP TABLE IF EXISTS  `mos_pshop_product_price`;
DROP TABLE IF EXISTS  `mos_pshop_product_reviews`;
DROP TABLE IF EXISTS  `mos_pshop_product_votes`;

DROP TABLE IF EXISTS  `mos_pshop_shipping_carrier`;

DROP TABLE IF EXISTS  `mos_pshop_shipping_rate`;

DROP TABLE IF EXISTS  `mos_pshop_product_download`;

DROP TABLE IF EXISTS  `mos_pshop_shopper_group`;

DROP TABLE IF EXISTS  `mos_pshop_shopper_vendor_xref`;

DROP TABLE IF EXISTS  `mos_pshop_tax_rate`;

DROP TABLE IF EXISTS  `mos_pshop_user_info`;

DROP TABLE IF EXISTS  `mos_pshop_vendor`;

DROP TABLE IF EXISTS  `mos_pshop_vendor_category`;
DROP TABLE IF EXISTS `mos_pshop_visit`;
DROP TABLE IF EXISTS  `mos_pshop_waiting_list`;

DROP TABLE IF EXISTS  `mos_pshop_zone_shipping`;
