User Tools

Site Tools


merkalt:setup_sql

This is an old revision of the document!


Setup Sql (instanceSetup.sql) could be taken from svn and comtains tables needed for instance setup and launch. This sql contains the next tables

  • (site)_coupons - list of coupons used on the instance (empty by default)
  • (site)_coupons_discounts - list of discounts schema assigned to coupons for the instance (empty by default)
  • (site)_cron_settings - list of pseudo cron commands setup (empty by default)
  • (site)_orders_header - list of orders (empty by default)
  • (site)_orders_details - list of product in the certain order (empty by default)
  • (site)_orders_details_lines - list of text lines assigned to the order product (empty by default)
  • (site)_payment_methods - list of payment methods available for the site. Fields `method_form_action`, `method_postback_url` should be checked for correct paths. {host_name} label as replacement of domain name could be used.
  • (site)_payment_methods_details - payments methods parameters. Fields `parameter_value` should be checked for correct paths. {host_name} label as replacement of domain name could be used.
  • (site)_payment_methods_settings - payments methods standard setup. Could be left as it is
merkalt/setup_sql.1354103416.txt.gz · Last modified: (external edit)