📄 db_zh_cn_gbk.sql
字号:
INSERT INTO mpshop_config VALUES (51, '会员积分名称', 'input', '30', 'CentName', '会员积分', '自定义显示积分的名称');
INSERT INTO mpshop_config VALUES (53, '是否按积分自动转换会员类型', 'YN', '30', 'CentUpdate', '0', '如果按积分自动转换会员类型,当达到设定的积分范围,再次登录时,将自动转变会员类型.自动转换会员类型的积分范围可在会员类型设置->参数设置中修改');
INSERT INTO mpshop_config VALUES (62, '默认计量单位', 'input', '30', 'ShopDw', '束', '在添加一种类型的商品前设定默认计量单位,可在输入时不需重复填写');
INSERT INTO mpshop_config VALUES (67, '是否人工确认订单', 'YN', '30', 'OrderNeedCheck', '0', '需要人工确认订单时,订单提交后处于未确认状态,经管理员确认后才能付款,适于需要协商调整价格的情况;不需人工确认订单时,订单提交后直接进入未完成订单,可直接付款');
INSERT INTO mpshop_config VALUES (52, '商品积分方式', 'CentMethod', '30', 'CentMethod', '1', '设置按商品指定积分时,不论以什么价格购买商品均按商品积分值计算积分;设置按购买价格积分时,在商品输入时填写的积分值无效');
INSERT INTO mpshop_config VALUES (50, '是否启用会员积分', 'YN', '30', 'UseCent', '1', '积分功能的总开关,当设置启用积分时,以下积分设置才起作用');
INSERT INTO mpshop_config VALUES (56, '商品缩图生成', 'YN', '30', 'ImgStMake', '1', '在商品详图片上传时,自动生成缩图,需PHP的GD库支持.但如果上传了缩图或填写了缩图网址,就不再生成缩图');
INSERT INTO mpshop_config VALUES (57, '商品缩图生成参考尺寸', 'input', '30', 'ImgStSize', '100', '以此数值作为参考尺寸,按比例智能确定缩图尺寸');
INSERT INTO mpshop_config VALUES (55, '商品评分星级设置', 'input', '30', 'StarMethod', '1,10,30,50,100', '将商品评分转换为星星数量时,1-5颗星分别对应的分数,以逗号分隔');
INSERT INTO mpshop_config VALUES (93, '前台图片上传尺寸限制(Byte)', 'input', '30', 'PicSizeLimit', '102400', '前台网站上传图片时单个图片尺寸的限制');
INSERT INTO mpshop_config VALUES (65, '是否启用非会员订购', 'YN', '30', 'NoMemberOrder', '1', '启用非会员订购时,允许未登录者在订单填写时填写简单会员资料,同时注册为会员;不启用非会员订购时,未登录者直接跳转到登录界面');
INSERT INTO mpshop_config VALUES (66, '非会员订购自动注册会员类型', 'NoMemberType', '30', 'NoMemberType', '10', '在启用非会员订购时,订购同时填写会员资料自动注册的会员类型');
INSERT INTO mpshop_config VALUES (68, '后台是否允许欠费扣款支付订单', 'YN', '30', 'OrderPayFu', '0', '后台从会员帐户扣款支付订单时,是否允许会员预付款帐户出现欠费');
INSERT INTO mpshop_config VALUES (69, '是否允许未付款发货和已发货退款', 'YN', '30', 'OrderYunNoPay', '0', '当订单处于未付款状态时,是否允许进行发货确认;当订单全部或部分发货时是否允许退款操作');
INSERT INTO mpshop_config VALUES (58, '商品搜索热门关键词', 'input', '30', 'GoodsHotWords', '生日送花,玫瑰,水晶礼品,手链,蛋稿', '显示在商品搜索表单的热门关键词,以逗号分隔');
INSERT INTO mpshop_config VALUES (72, '推广链盟提成比例(%)', 'input', '30', 'LmPercent', '0.5', '来自推广链盟成员网站的访问者在订购付款后,链盟成员获得提成的比例.按订单商品总金额的百分比计算');
INSERT INTO mpshop_config VALUES (70, '卖方订单通知', 'YN', '30', 'OrderSellerNotice', '0', '在顾客提交订单和订单支付时,发送邮件通知商家.适合不能经常进入后台查询订单的商家;如果订单量较多,有专人值守的商家,不推荐启用此功能,因邮件发送过程可能使顾客提交订单的速度受到影响');
INSERT INTO mpshop_config VALUES (71, '买方订单通知', 'YN', '30', 'OrderBuyerNotice', '0', '管理员审核确认订单时,订单发货完成时,发邮件通知顾客');
# --------------------------------------------------------
#
# 数据表的结构 `mpshop_cp_cat`
#
CREATE TABLE mpshop_cp_cat (
catid int(12) NOT NULL auto_increment,
pid int(12) default NULL,
menuid int(10) NOT NULL default '3',
cat char(100) default NULL,
xuhao int(12) default NULL,
catpath char(255) default NULL,
nums int(20) default NULL,
secure int(1) NOT NULL default '0',
tj int(1) NOT NULL default '0',
PRIMARY KEY (catid)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
#
# 导出下面的数据库内容 `mpshop_cp_cat`
#
# --------------------------------------------------------
#
# 数据表的结构 `mpshop_cp_con`
#
CREATE TABLE mpshop_cp_con (
id int(12) NOT NULL auto_increment,
menuid int(10) NOT NULL default '3',
catid int(12) default NULL,
catpath varchar(255) default NULL,
title varchar(255) default NULL,
memo text NOT NULL,
body text,
dtime int(11) default '0',
xuhao int(5) default '0',
cl int(20) default NULL,
tj int(1) default NULL,
iffb int(1) default '0',
ifbold int(1) default '0',
ifred int(1) default '0',
`type` varchar(30) NOT NULL default '',
src varchar(150) NOT NULL default '',
uptime int(11) default '0',
author varchar(100) default NULL,
source varchar(100) default NULL,
memberid varchar(100) default NULL,
proj varchar(255) NOT NULL default '',
secure int(11) NOT NULL default '0',
prop1 varchar(255) NOT NULL default '',
prop2 varchar(255) NOT NULL default '',
prop3 varchar(255) NOT NULL default '',
prop4 varchar(255) NOT NULL default '',
prop5 varchar(255) NOT NULL default '',
prop6 varchar(255) NOT NULL default '',
prop7 varchar(255) NOT NULL default '',
prop8 varchar(255) NOT NULL default '',
prop9 varchar(255) NOT NULL default '',
prop10 varchar(255) NOT NULL default '',
prop11 varchar(255) NOT NULL default '',
prop12 varchar(255) NOT NULL default '',
prop13 varchar(255) NOT NULL default '',
prop14 varchar(255) NOT NULL default '',
prop15 varchar(255) NOT NULL default '',
prop16 varchar(255) NOT NULL default '',
prop17 varchar(255) NOT NULL default '',
prop18 varchar(255) NOT NULL default '',
prop19 varchar(255) NOT NULL default '',
prop20 varchar(255) NOT NULL default '',
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
#
# 导出下面的数据库内容 `mpshop_cp_con`
#
# --------------------------------------------------------
#
# 数据表的结构 `mpshop_default_rights`
#
CREATE TABLE mpshop_default_rights (
id int(12) NOT NULL auto_increment,
membertypeid int(50) default NULL,
secureid int(50) default NULL,
securetype char(100) default NULL,
secureset int(100) default NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
#
# 导出下面的数据库内容 `mpshop_default_rights`
#
INSERT INTO mpshop_default_rights VALUES (144, 10, 30, 'func', 0);
INSERT INTO mpshop_default_rights VALUES (143, 10, 7, 'func', 0);
INSERT INTO mpshop_default_rights VALUES (142, 10, 4, 'con', 0);
INSERT INTO mpshop_default_rights VALUES (141, 10, 3, 'menu', 0);
INSERT INTO mpshop_default_rights VALUES (140, 10, 2, 'func', 0);
INSERT INTO mpshop_default_rights VALUES (139, 10, 6, 'func', 0);
INSERT INTO mpshop_default_rights VALUES (145, 10, 11, 'price', 1);
# --------------------------------------------------------
#
# 数据表的结构 `mpshop_down_cat`
#
CREATE TABLE mpshop_down_cat (
catid int(12) NOT NULL auto_increment,
pid int(12) default NULL,
menuid int(10) NOT NULL default '3',
cat char(100) default NULL,
xuhao int(12) default NULL,
catpath char(255) default NULL,
nums int(20) default NULL,
secure int(1) NOT NULL default '0',
tj int(1) NOT NULL default '0',
PRIMARY KEY (catid)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
#
# 导出下面的数据库内容 `mpshop_down_cat`
#
INSERT INTO mpshop_down_cat VALUES (1, 0, 5, '测试下载', 1, '0001:', 0, 0, 0);
# --------------------------------------------------------
#
# 数据表的结构 `mpshop_down_con`
#
CREATE TABLE mpshop_down_con (
id int(12) NOT NULL auto_increment,
menuid int(10) NOT NULL default '3',
catid int(12) default NULL,
catpath varchar(255) default NULL,
title varchar(255) default NULL,
memo text NOT NULL,
body text,
dtime int(11) default '0',
xuhao int(5) default '0',
cl int(20) default NULL,
tj int(1) default NULL,
iffb int(1) default '0',
filesize varchar(30) default NULL,
url varchar(255) default NULL,
`type` varchar(30) NOT NULL default '',
src varchar(150) NOT NULL default '',
uptime int(11) default '0',
author varchar(100) default NULL,
source varchar(100) default NULL,
memberid varchar(100) default NULL,
proj varchar(255) NOT NULL default '',
secure int(11) NOT NULL default '0',
prop1 varchar(255) NOT NULL default '',
prop2 varchar(255) NOT NULL default '',
prop3 varchar(255) NOT NULL default '',
prop4 varchar(255) NOT NULL default '',
prop5 varchar(255) NOT NULL default '',
prop6 varchar(255) NOT NULL default '',
prop7 varchar(255) NOT NULL default '',
prop8 varchar(255) NOT NULL default '',
prop9 varchar(255) NOT NULL default '',
prop10 varchar(255) NOT NULL default '',
prop11 varchar(255) NOT NULL default '',
prop12 varchar(255) NOT NULL default '',
prop13 varchar(255) NOT NULL default '',
prop14 varchar(255) NOT NULL default '',
prop15 varchar(255) NOT NULL default '',
prop16 varchar(255) NOT NULL default '',
prop17 varchar(255) NOT NULL default '',
prop18 varchar(255) NOT NULL default '',
prop19 varchar(255) NOT NULL default '',
prop20 varchar(255) NOT NULL default '',
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
#
# 导出下面的数据库内容 `mpshop_down_con`
#
# --------------------------------------------------------
#
# 数据表的结构 `mpshop_form`
#
CREATE TABLE mpshop_form (
id int(3) NOT NULL auto_increment,
field_caption varchar(200) NOT NULL default '',
field_type int(1) NOT NULL default '0',
field_size int(2) NOT NULL default '0',
field_name varchar(200) NOT NULL default '',
field_value varchar(255) NOT NULL default '',
field_null int(1) NOT NULL default '0',
value_repeat int(1) NOT NULL default '0',
field_intro varchar(255) NOT NULL default '',
use_field int(1) NOT NULL default '0',
moveable int(1) NOT NULL default '0',
xuhao int(3) NOT NULL default '0',
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
#
# 导出下面的数据库内容 `mpshop_form`
#
INSERT INTO mpshop_form VALUES (1, '留言标题', 1, 35, 'title', '', 1, 1, '', 1, 1, 1);
INSERT INTO mpshop_form VALUES (2, '留言内容', 2, 34, 'content', '', 1, 1, '', 1, 1, 2);
INSERT INTO mpshop_form VALUES (3, '您的姓名', 1, 35, 'name', '', 1, 1, '', 1, 1, 3);
INSERT INTO mpshop_form VALUES (5, '联系电话', 1, 30, 'tel', '', 0, 1, '', 0, 0, 5);
INSERT INTO mpshop_form VALUES (6, '联系地址', 1, 35, 'address', '', 0, 1, '', 0, 0, 6);
INSERT INTO mpshop_form VALUES (7, '电子邮件', 1, 35, 'email', '', 1, 1, '', 1, 1, 7);
INSERT INTO mpshop_form VALUES (8, '网址URL', 1, 35, 'url', '', 0, 1, '', 0, 0, 8);
INSERT INTO mpshop_form VALUES (9, 'QQ号码', 1, 16, 'qq', '', 0, 1, '', 0, 0, 9);
INSERT INTO mpshop_form VALUES (10, '公司名称', 1, 35, 'company', '', 0, 1, '', 0, 0, 10);
INSERT INTO mpshop_form VALUES (11, '公司地址', 1, 35, 'company_address', '', 0, 1, '', 0, 0, 11);
INSERT INTO mpshop_form VALUES (4, '性 别', 5, 21, 'sex', '男;女', 0, 1, '', 0, 0, 4);
INSERT INTO mpshop_form VALUES (12, '邮政编码', 1, 6, 'zip', '', 0, 1, '', 0, 0, 12);
INSERT INTO mpshop_form VALUES (13, '传真号码', 1, 30, 'fax', '', 0, 1, '', 0, 0, 13);
INSERT INTO mpshop_form VALUES (14, '产品编号', 1, 16, 'products_id', '', 0, 1, '', 0, 0, 14);
INSERT INTO mpshop_form VALUES (15, '产品名称', 1, 16, 'products_name', '', 0, 1, '', 0, 0, 15);
INSERT INTO mpshop_form VALUES (16, '订购数量', 1, 16, 'products_num', '', 0, 1, '', 0, 0, 16);
INSERT INTO mpshop_form VALUES (19, '自定义一', 5, 35, 'custom1', '100;200;300;400;500', 0, 1, '', 0, 0, 17);
INSERT INTO mpshop_form VALUES (18, '自定义二', 5, 35, 'custom2', '100;200;300;400;500', 0, 1, '', 0, 0, 18);
INSERT INTO mpshop_form VALUES (17, '自定义三', 5, 35, 'custom3', '100;200;300;400;500', 0, 1, '', 0, 0, 19);
INSERT INTO mpshop_form VALUES (20, '自定义四', 1, 35, 'custom4', '', 0, 1, '', 0, 0, 20);
INSERT INTO mpshop_form VALUES (21, '自定义五', 1, 35, 'custom5', '', 0, 1, '', 0, 0, 21);
INSERT INTO mpshop_form VALUES (22, '自定义六', 1, 35, 'custom6', '', 0, 1, '', 0, 0, 22);
INSERT INTO mpshop_form VALUES (23, '自定义七', 1, 35, 'custom7', '', 0, 1, '', 0, 0, 23);
# --------------------------------------------------------
#
# 数据表的结构 `mpshop_form_85`
#
CREATE TABLE mpshop_form_85 (
id int(3) NOT NULL auto_increment,
field_caption varchar(200) default NULL,
field_type int(1) default NULL,
field_size int(3) default NULL,
field_name varchar(200) default NULL,
field_value varchar(255) default NULL,
field_null int(1) default NULL,
value_repeat int(1) default NULL,
field_intro varchar(255) default NULL,
use_field int(1) default NULL,
moveable int(1) default NULL,
xuhao int(3) default NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
#
# 导出下面的数据库内容 `mpshop_form_85`
#
INSERT INTO mpshop_form_85 VALUES (1, '需求商品', 1, 35, 'title', '[缺货]{#title#}', 1, 1, '', 1, 1, 1);
INSERT INTO mpshop_form_85 VALUES (2, '需求描述', 2, 34, 'content', '', 1, 1, '', 1, 1, 2);
INSERT INTO mpshop_form_85 VALUES (3, '您的姓名', 1, 35, 'name', '', 1, 1, '', 1, 1, 3);
INSERT INTO mpshop_form_85 VALUES (5, '联系电话', 1, 30, 'tel', '', 0, 1, '', 1, 0, 4);
INSERT INTO mpshop_form_85 VALUES (6, '联系地址', 1, 35, 'address', '', 0, 1, '', 0, 0, 11);
INSERT INTO mpshop_form_85 VALUES (7, '电子邮件', 1, 35, 'email', '', 1, 1, '', 1, 1, 5);
INSERT INTO mpshop_form_85 VALUES (8, '网址URL', 1, 35, 'url', '', 0, 1, '', 0, 0, 11);
INSERT INTO mpshop_form_85 VALUES (9, 'QQ号码', 1, 16, 'qq', '', 0, 1, '', 0, 0, 6);
INSERT INTO mpshop_form_85 VALUES (10, '公司名称', 1, 35, 'company', '', 0, 1, '', 0, 0, 10);
INSERT INTO mpshop_form_85 VALUES (11, '公司地址', 1, 35, 'company_address', '', 0, 1, '', 0, 0, 11);
INSERT INTO mpshop_form_85 VALUES (4, '性 别', 5, 21, 'sex', '男;女', 0, 1, '', 0, 0, 11);
INSERT INTO mpshop_form_85 VALUES (12, '邮政编码', 1, 6, 'zip', '', 0, 1, '', 0, 0, 12);
INSERT INTO mpshop_form_85 VALUES (13, '传真号码', 1, 30, 'fax', '', 0, 1, '', 0, 0, 13);
INSERT INTO mpshop_form_85 VALUES (14, '产品编号', 1, 16, 'products_id', '', 0, 1, '', 0, 0, 14);
INSERT INTO mpshop_form_85 VALUES (15, '产品名称', 1, 16, 'products_name', '', 0, 1, '', 0, 0, 15);
INSERT INTO mpshop_form_85 VALUES (16, '订购数量', 1, 16, 'products_num', '', 0, 1, '', 0, 0, 16);
INSERT INTO mpshop_form_85 VALUES (19, '自定义一', 5, 35, 'custom1', '100;200;300;400;500', 0, 1, '', 0, 0, 17);
INSERT INTO mpshop_form_85 VALUES (18, '自定义二', 5, 35, 'custom2', '100;200;300;400;500', 0, 1, '', 0, 0, 18);
INSERT INTO mpshop_form_85 VALUES (17, '自定义三', 5, 35, 'custom3', '100;200;300;400;500', 0, 1, '', 0, 0, 19);
INSERT INTO mpshop_form_85 VALUES (20, '自定义四', 1, 35, 'custom4', '', 0, 1, '', 0, 0, 20);
INSERT INTO mpshop_form_85 VALUES (21, '自定义五', 1, 35, 'custom5', '', 0, 1, '', 0, 0, 21);
INSERT INTO mpshop_form_85 VALUES (22, '自定义六', 1, 35, 'custom6', '', 0, 1, '', 0, 0, 22);
INSERT INTO mpshop_form_85 VALUES (23, '自定义七', 1, 35, 'custom7', '', 0, 1, '', 0, 0, 23);
# --------------------------------------------------------
#
# 数据表的结构 `mpshop_form_feedback`
#
CREATE TABLE mpshop_form_feedback (
id int(12) NOT NULL auto_increment,
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -