📄 db_zh_cn_utf8.mysql3x.sql
字号:
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)
);
#
# 导出下面的数据库内容 `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)
);
#
# 导出下面的数据库内容 `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)
);
#
# 导出下面的数据库内容 `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)
);
#
# 导出下面的数据库内容 `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)
);
#
# 导出下面的数据库内容 `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)
);
#
# 导出下面的数据库内容 `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)
);
#
# 导出下面的数据库内容 `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,
menuid int(12) NOT NULL default '0',
title varchar(255) NOT NULL default '',
content text NOT NULL,
name varchar(200) NOT NULL default '',
sex varchar(10) NOT NULL default '',
tel varchar(100) NOT NULL default '',
address varchar(255) NOT NULL default '',
email varchar(255) NOT NULL default '',
url varchar(255) NOT NULL default '',
qq varchar(20) NOT NULL default '',
company varchar(255) NOT NULL default '',
company_address varchar(255) NOT NULL default '',
zip varchar(6) NOT NULL default '',
fax varchar(20) NOT NULL default '',
products_id varchar(100) NOT NULL default '',
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -