drop procedure ec_apply_gift_cert_balance; drop procedure ec_reinst_gift_cert_on_order; drop function ec_total_price; drop function ec_total_shipping; drop function ec_total_tax; drop function ec_shipment_price; drop function ec_shipment_shipping; drop function ec_shipment_tax; drop function ec_order_gift_cert_amount; drop function ec_shipment_gift_certificate; drop function ec_tax; drop function ec_order_cost; drop function ec_shipment_cost; drop function ec_total_refund; drop function ec_gift_certificate_balance; drop function ec_order_amount_owed; drop function gift_certificate_amount_left; drop function ec_cash_amount_to_refund; drop function ec_one_gift_cert_on_one_order; drop function ec_earlier_certs_on_one_order; drop function ec_cert_unshipped_one_order; drop function ec_gift_cert_unshipped_amount; drop table ec_gift_cert_usage_ids; drop table ec_templates_audit; drop table ec_categories_audit; drop table ec_subcategories_audit; drop view ec_subcategories_augmented ; drop table ec_subsubcategories_audit; drop view ec_subsubcategories_augmented; drop view ec_products_displayable; drop view ec_products_searchable; drop table ec_products_audit; drop table ec_product_purchase_comb; drop table ec_sale_prices; drop view ec_sale_prices_current; drop table ec_sale_prices_audit; drop table ec_product_series_map; drop table ec_product_series_map_audit; drop table ec_user_classes_audit; drop table ec_product_user_class_prices; drop table ec_product_u_c_prices_audit; drop table ec_product_recommendations; drop table ec_product_recommend_audit; drop view ec_recommendations_cats_view; drop table ec_user_class_user_map; drop table ec_user_class_user_map_audit; drop table ec_product_links; drop table ec_product_links_audit; drop table ec_product_comments; drop table ec_product_comments_audit; drop table ec_product_reviews; drop table ec_product_reviews_audit; drop table ec_category_product_map; drop table ec_category_product_map_audit; drop table ec_subcategory_product_map; drop table ec_subcat_prod_map_audit; drop table ec_subsubcategory_product_map; drop table ec_subsubcat_prod_map_audit; drop table ec_category_template_map; drop table ec_custom_product_fields; drop table ec_custom_product_fields_audit; drop table ec_custom_product_field_values; drop table ec_custom_p_field_values_audit; drop table ec_user_session_info; drop table ec_user_session_offer_codes; drop view ec_orders_reportable; drop view ec_orders_shippable; drop table ec_shipments_audit; drop table ec_items; drop view ec_items_reportable ; drop view ec_items_refundable; drop view ec_items_shippable; drop view ec_items_money_view; drop table ec_state_change_order_ids; drop table ec_admin_settings; drop table ec_admin_settings_audit; drop table ec_sales_tax_by_state; drop table ec_sales_tax_by_state_audit; drop table ec_retailers_audit; drop table ec_offers; drop table ec_retailer_locations; drop table ec_retailer_locations_audit; drop view ec_offers_current; drop table ec_offers_audit; drop view ec_gift_certificates_approved; drop view ec_gift_certificates_purchased; drop view ec_gift_certificates_issued; drop table ec_gift_certificates_audit; drop table ec_gift_certificate_usage; drop view ec_customer_service_reps; drop table ec_cs_issue_type_map; drop table ec_cs_action_info_used_map; drop table ec_picklist_items; drop table ec_picklist_items_audit; drop table ec_canned_responses; drop table ec_email_templates_audit; drop table ec_cat_mailing_lists; drop table ec_spam_log; drop view ec_fin_transactions_reportable; drop table ec_cybercash_log; drop table ec_problems_log; drop table ec_automatic_email_log; begin acs_object_type.drop_type (object_type => 'ec_product'); end; / drop table ec_products; drop table ec_templates; drop table ec_subsubcategories; drop table ec_subcategories; drop table ec_categories; drop table ec_user_classes; drop table ec_retailers; drop table ec_financial_transactions; drop table ec_refunds; drop table ec_shipments; drop table ec_customer_service_actions; drop table ec_customer_serv_interactions; drop table ec_customer_service_issues; drop table ec_email_templates; drop table ec_user_identification; drop table ec_gift_certificates; drop table ec_orders; drop table ec_creditcards; drop table ec_addresses; drop table ec_user_sessions; drop sequence ec_template_id_sequence; drop sequence ec_category_id_sequence; drop sequence ec_subcategory_id_sequence; drop sequence ec_subsubcategory_id_sequence; -- drop sequence ec_product_id_sequence; drop sequence ec_sale_price_id_sequence; drop sequence ec_address_id_sequence; drop sequence ec_creditcard_id_sequence; drop sequence ec_user_class_id_sequence; drop sequence ec_recommendation_id_sequence; drop sequence ec_product_comment_id_sequence; drop sequence ec_product_review_id_sequence; -- drop sequence ec_user_session_sequence; drop sequence ec_order_id_sequence; drop sequence ec_shipment_id_sequence; drop sequence refund_id_sequence; drop sequence ec_item_id_sequence; drop sequence ec_retailer_sequence; drop sequence ec_retailer_location_sequence; drop sequence ec_offer_sequence; drop sequence ec_gift_cert_id_sequence; drop sequence ec_issue_id_sequence; drop sequence ec_action_id_sequence; drop sequence ec_interaction_id_sequence; drop sequence ec_user_ident_id_sequence; drop sequence ec_picklist_item_id_sequence; drop sequence ec_canned_response_id_sequence; drop sequence ec_email_template_id_sequence; drop sequence ec_spam_id_sequence; drop sequence ec_transaction_id_sequence; drop sequence ec_problem_id_sequence; @@ pl-sql-utilities-drop.sql @@ ec-product-package-drop.sql @@ acs-geo-tables-drop.sql