zencart后台设置常用sql操作语句

[Renville]

表 : configuration

-------------------------------------------------------------------------------
SQL: UPDATE 表名称 SET 列名称 = 新值 WHERE 列名称 = 某值
-------------------------------------------------------------------------------

configuration_title configuration_key configuration_value

-------------------------------------------------------------------------------

首页新进商品数量 MAX_DISPLAY_NEW_PRODUCTS

首页推荐商品数量 MAX_DISPLAY_SEARCH_RESULTS_FEATURED

首页特价商品数量 MAX_DISPLAY_SPECIAL_PRODUCTS_INDEX


UPDATE configuration SET configuration_value = '6'
WHERE configuration_key = 'MAX_DISPLAY_NEW_PRODUCTS'
or configuration_key = 'MAX_DISPLAY_SPECIAL_PRODUCTS_INDEX'
or configuration_key = 'MAX_DISPLAY_SEARCH_RESULTS_FEATURED';



********************************************************************************



特价商品列表数量 MAX_DISPLAY_SPECIAL_PRODUCTS

新进商品列表数量 MAX_DISPLAY_PRODUCTS_NEW

推荐商品列表数量 MAX_DISPLAY_PRODUCTS_FEATURED_PRODUCTS

所有商品列表数量 MAX_DISPLAY_PRODUCTS_ALL

分类商品列表数量 MAX_DISPLAY_PRODUCTS_LISTING

畅销商品数量 MAX_DISPLAY_BESTSELLERS

同时购买商品数量 MAX_DISPLAY_ALSO_PURCHASED



UPDATE configuration SET configuration_value = '9'
WHERE configuration_key = 'MAX_DISPLAY_SPECIAL_PRODUCTS'
or configuration_key = 'MAX_DISPLAY_PRODUCTS_NEW'
or configuration_key = 'MAX_DISPLAY_PRODUCTS_FEATURED_PRODUCTS'
or configuration_key = 'MAX_DISPLAY_PRODUCTS_ALL'
or configuration_key = 'MAX_DISPLAY_PRODUCTS_LISTING'
or configuration_key = 'MAX_DISPLAY_BESTSELLERS'
or configuration_key = 'MAX_DISPLAY_ALSO_PURCHASED';



********************************************************************************



边框中随机推荐商品数量 MAX_RANDOM_SELECT_FEATURED_PRODUCTS

边框中随机新进商品数量 MAX_RANDOM_SELECT_NEW

边框中随机特价商品数量 MAX_RANDOM_SELECT_SPECIALS

边框中随机商品评论数量 MAX_RANDOM_SELECT_REVIEWS



UPDATE configuration SET configuration_value = '2'
WHERE configuration_key = 'MAX_RANDOM_SELECT_FEATURED_PRODUCTS'
or configuration_key = 'MAX_RANDOM_SELECT_NEW'
or configuration_key = 'MAX_RANDOM_SELECT_SPECIALS'
or configuration_key = 'MAX_RANDOM_SELECT_REVIEWS' ;



********************************************************************************



每页商品评论数量 MAX_DISPLAY_NEW_REVIEWS



UPDATE configuration SET configuration_value = '6'
WHERE configuration_key = 'MAX_DISPLAY_NEW_REVIEWS';



********************************************************************************


商品信息 - 图像宽度 MEDIUM_IMAGE_WIDTH

商品信息 - 图像高度 MEDIUM_IMAGE_HEIGHT



UPDATE configuration SET configuration_value = '260'
WHERE configuration_key = 'MEDIUM_IMAGE_WIDTH'
or configuration_key = 'MEDIUM_IMAGE_HEIGHT';



********************************************************************************


图像 - 商品列表宽度 IMAGE_PRODUCT_LISTING_WIDTH

图像 - 商品列表高度 IMAGE_PRODUCT_LISTING_HEIGHT

图像 - 新进商品列表宽度 IMAGE_PRODUCT_NEW_LISTING_WIDTH

图像 - 新进商品列表高度 IMAGE_PRODUCT_NEW_LISTING_HEIGHT

图像 - 新进商品宽度 IMAGE_PRODUCT_NEW_WIDTH

图像 - 新进商品高度 IMAGE_PRODUCT_NEW_HEIGHT

图像 - 推荐商品宽度 IMAGE_FEATURED_PRODUCTS_LISTING_WIDTH

图像 - 推荐商品高度 IMAGE_FEATURED_PRODUCTS_LISTING_HEIGHT

图像 - 所有商品列表宽度 IMAGE_PRODUCT_ALL_LISTING_WIDTH

图像 - 所有商品列表高度 IMAGE_PRODUCT_ALL_LISTING_HEIGHT


UPDATE configuration SET configuration_value = '180'
WHERE configuration_key = 'IMAGE_PRODUCT_LISTING_WIDTH'
or configuration_key = 'IMAGE_PRODUCT_LISTING_HEIGHT'
or configuration_key = 'IMAGE_PRODUCT_NEW_LISTING_WIDTH'
or configuration_key = 'IMAGE_PRODUCT_NEW_LISTING_HEIGHT'
or configuration_key = 'IMAGE_PRODUCT_NEW_WIDTH'
or configuration_key = 'IMAGE_PRODUCT_NEW_HEIGHT'
or configuration_key = 'IMAGE_FEATURED_PRODUCTS_LISTING_WIDTH'
or configuration_key = 'IMAGE_FEATURED_PRODUCTS_LISTING_HEIGHT'
or configuration_key = 'IMAGE_PRODUCT_ALL_LISTING_WIDTH'
or configuration_key = 'IMAGE_PRODUCT_ALL_LISTING_HEIGHT';



********************************************************************************



小图像宽度 SMALL_IMAGE_WIDTH

小图像高度 SMALL_IMAGE_HEIGHT



UPDATE configuration SET configuration_value = '150'
WHERE configuration_key = 'SMALL_IMAGE_WIDTH'
or configuration_key = 'SMALL_IMAGE_HEIGHT';



********************************************************************************


栏目宽度 - 左栏目 BOX_WIDTH_LEFT


UPDATE configuration SET configuration_value = '200'
WHERE configuration_key = 'BOX_WIDTH_LEFT';



********************************************************************************


分类栏 - 显示特价商品链接 SHOW_CATEGORIES_BOX_SPECIALS false

分类栏 - 显示新进商品链接 SHOW_CATEGORIES_BOX_PRODUCTS_NEW false

分类栏 - 显示推荐商品链接 SHOW_CATEGORIES_BOX_FEATURED_PRODUCTS false

分类栏 - 显示所有商品链接 SHOW_CATEGORIES_BOX_PRODUCTS_ALL false



UPDATE configuration SET configuration_value = 'false'
WHERE configuration_key = 'SHOW_CATEGORIES_BOX_SPECIALS'
or configuration_key = 'SHOW_CATEGORIES_BOX_PRODUCTS_NEW'
or configuration_key = 'SHOW_CATEGORIES_BOX_FEATURED_PRODUCTS'
or configuration_key = 'SHOW_CATEGORIES_BOX_PRODUCTS_ALL';



********************************************************************************


新进商品每行列数 SHOW_PRODUCT_INFO_COLUMNS_NEW_PRODUCTS

推荐商品每行列数 SHOW_PRODUCT_INFO_COLUMNS_FEATURED_PRODUCTS

特价商品每行列数 SHOW_PRODUCT_INFO_COLUMNS_SPECIALS_PRODUCTS

商品列表 - 每行列数 PRODUCT_LISTING_COLUMNS_PER_ROW



UPDATE configuration SET configuration_value = '3'
WHERE configuration_key = 'SHOW_PRODUCT_INFO_COLUMNS_NEW_PRODUCTS'
or configuration_key = 'SHOW_PRODUCT_INFO_COLUMNS_FEATURED_PRODUCTS'
or configuration_key = 'SHOW_PRODUCT_INFO_COLUMNS_SPECIALS_PRODUCTS'
or configuration_key = 'PRODUCT_LISTING_COLUMNS_PER_ROW';



********************************************************************************



商店名称 STORE_NAME

店主 STORE_OWNER

商店地址和电话 STORE_NAME_ADDRESS



UPDATE configuration SET configuration_value = '***'
WHERE configuration_key = 'STORE_NAME' ;



UPDATE configuration SET configuration_value = '***'
WHERE configuration_key = 'STORE_OWNER' ;



UPDATE configuration SET configuration_value = '***'
WHERE configuration_key = 'STORE_NAME_ADDRESS';



********************************************************************************


客户资料--> 称呼字段 ACCOUNT_GENDER

客户资料--> 创建帐号时的缺省国家 SHOW_CREATE_ACCOUNT_DEFAULT_COUNTRY

条款选项--> 结帐时确认顾客须知中条款 DISPLAY_CONDITIONS_ON_CHECKOUT

条款选项--> 创建帐号时确认隐私声明 DISPLAY_PRIVACY_CONDITIONS



UPDATE configuration SET configuration_value = '***'
WHERE configuration_key = 'ACCOUNT_GENDER' ;


UPDATE configuration SET configuration_value = '***'
WHERE configuration_key = 'SHOW_CREATE_ACCOUNT_DEFAULT_COUNTRY' ;



UPDATE configuration SET configuration_value = '***'
WHERE configuration_key = 'DISPLAY_CONDITIONS_ON_CHECKOUT'
or configuration_key = 'DISPLAY_PRIVACY_CONDITIONS';