merkalt:setup_sql
This is an old revision of the document!
Setup Sql (instanceSetup.sql) could be taken from svn (core branch) 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
Another SQL required is initial filling query which fills database (instanceConfigSetup.sql)
merkalt/setup_sql.1355251096.txt.gz · Last modified: (external edit)