⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 db_zh_cn_utf8.sql

📁 推荐的一本书！！！！建议看 ！！！！！！！！！
💻 SQL
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
# phpMyAdmin MySQL-Dump
# version 2.3.0
# http://phpwizard.net/phpMyAdmin/
# http://www.phpmyadmin.net/ (download page)
#
# 主机: localhost
# 建立日期: Apr 10, 2007 at 01:43 PM
# 伺服机版本: 4.01.14
# PHP 版本: 4.3.8
# 数据库 : `dbebook`
# --------------------------------------------------------

#
# 数据表的结构 `mpshop_admin`
#

CREATE TABLE mpshop_admin (
  id int(6) NOT NULL auto_increment,
  `user` varchar(30) NOT NULL default '',
  `password` varchar(50) NOT NULL default '',
  name varchar(50) NOT NULL default '',
  moveable int(1) default NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# 导出下面的数据库内容 `mpshop_admin`
#

INSERT INTO mpshop_admin VALUES (3, 'admin', '21232f297a57a5a743894a0e4a801fc3', 'SystemMaster', 0);
# --------------------------------------------------------

#
# 数据表的结构 `mpshop_admin_auth`
#

CREATE TABLE mpshop_admin_auth (
  id int(6) NOT NULL auto_increment,
  auth char(20) default NULL,
  name char(50) default NULL,
  intro char(255) default NULL,
  xuhao int(10) default NULL,
  pid int(10) default NULL,
  pname char(20) default NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# 导出下面的数据库内容 `mpshop_admin_auth`
#

INSERT INTO mpshop_admin_auth VALUES (1, '1', '系统参数设置', '', 1, 0, '系统设置');
INSERT INTO mpshop_admin_auth VALUES (2, '2', '修改管理密码', '', 2, 0, '系统设置');
INSERT INTO mpshop_admin_auth VALUES (3, '3', '管理帐户设置', '', 3, 0, '系统设置');
INSERT INTO mpshop_admin_auth VALUES (4, '4', '会员类型设置', '', 4, 0, '系统设置');
INSERT INTO mpshop_admin_auth VALUES (5, '5', '地区行业设置', '', 5, 0, '系统设置');
INSERT INTO mpshop_admin_auth VALUES (6, '6', '货币类型设置', '', 6, 0, '系统设置');
INSERT INTO mpshop_admin_auth VALUES (7, '7', '支付方式设置', '', 7, 0, '系统设置');
INSERT INTO mpshop_admin_auth VALUES (8, '8', '配送方法设置', '', 8, 0, '系统设置');
INSERT INTO mpshop_admin_auth VALUES (9, '9', '积分算法设置', '', 9, 0, '系统设置');
INSERT INTO mpshop_admin_auth VALUES (10, '11', '网站栏目设置', '', 1, 1, '网站设置');
INSERT INTO mpshop_admin_auth VALUES (11, '12', '网站栏目删除', '', 2, 1, '网站设置');
INSERT INTO mpshop_admin_auth VALUES (12, '13', '网站页面设置', '', 3, 1, '网站设置');
INSERT INTO mpshop_admin_auth VALUES (13, '14', '界面风格设置', '', 4, 1, '网站设置');
INSERT INTO mpshop_admin_auth VALUES (14, '15', '自定表单设置', '', 5, 1, '网站设置');
INSERT INTO mpshop_admin_auth VALUES (15, '16', '社区分类设置', '', 6, 1, '网站设置');
INSERT INTO mpshop_admin_auth VALUES (16, '17', '网站专题设置', '', 7, 1, '网站设置');
INSERT INTO mpshop_admin_auth VALUES (17, '21', '文章频道管理', '', 1, 2, '内容管理');
INSERT INTO mpshop_admin_auth VALUES (18, '22', '图文频道管理', '', 2, 2, '内容管理');
INSERT INTO mpshop_admin_auth VALUES (19, '23', '下载频道管理', '', 3, 2, '内容管理');
INSERT INTO mpshop_admin_auth VALUES (20, '24', '网站标志管理', '', 4, 2, '内容管理');
INSERT INTO mpshop_admin_auth VALUES (21, '25', '网站广告管理', '', 5, 2, '内容管理');
INSERT INTO mpshop_admin_auth VALUES (22, '31', '商品类别管理', '', 1, 3, '商品管理');
INSERT INTO mpshop_admin_auth VALUES (23, '32', '商品查询管理', '', 2, 3, '商品管理');
INSERT INTO mpshop_admin_auth VALUES (24, '33', '商品发布修改', '', 3, 3, '商品管理');
INSERT INTO mpshop_admin_auth VALUES (25, '34', '商品删除权限', '', 4, 3, '商品管理');
INSERT INTO mpshop_admin_auth VALUES (26, '41', '未完订单查询', '', 1, 4, '订单管理');
INSERT INTO mpshop_admin_auth VALUES (27, '42', '存档订单查询', '', 2, 4, '订单管理');
INSERT INTO mpshop_admin_auth VALUES (28, '43', '订单审核确认', '', 3, 4, '订单管理');
INSERT INTO mpshop_admin_auth VALUES (29, '44', '订单发货确认', '', 4, 4, '订单管理');
INSERT INTO mpshop_admin_auth VALUES (30, '45', '订单退货确认', '', 5, 4, '订单管理');
INSERT INTO mpshop_admin_auth VALUES (31, '46', '修改订单金额', '', 6, 4, '订单管理');
INSERT INTO mpshop_admin_auth VALUES (32, '47', '订单存档退档', '', 7, 4, '订单管理');
INSERT INTO mpshop_admin_auth VALUES (33, '51', '会员审核管理', '', 1, 5, '会员管理');
INSERT INTO mpshop_admin_auth VALUES (34, '52', '会员查询管理', '', 2, 5, '会员管理');
INSERT INTO mpshop_admin_auth VALUES (35, '53', '会员资料查询', '', 3, 5, '会员管理');
INSERT INTO mpshop_admin_auth VALUES (36, '54', '会员资料修改', '', 4, 5, '会员管理');
INSERT INTO mpshop_admin_auth VALUES (37, '55', '会员邮件发送', '', 5, 5, '会员管理');
INSERT INTO mpshop_admin_auth VALUES (38, '56', '会员权限管理', '', 6, 5, '会员管理');
INSERT INTO mpshop_admin_auth VALUES (39, '57', '会员公告管理', '', 7, 5, '会员管理');
INSERT INTO mpshop_admin_auth VALUES (40, '58', '模拟会员登录', '', 8, 5, '会员管理');
INSERT INTO mpshop_admin_auth VALUES (41, '59', '会员帐务查询', '', 9, 5, '会员管理');
INSERT INTO mpshop_admin_auth VALUES (42, '61', '反馈信息管理', '', 1, 6, '信息管理');
INSERT INTO mpshop_admin_auth VALUES (43, '62', '社区评论管理', '', 2, 6, '信息管理');
INSERT INTO mpshop_admin_auth VALUES (44, '71', '访问统计系统', '', 1, 7, '辅助工具');
INSERT INTO mpshop_admin_auth VALUES (45, '72', '网站数据备份', '', 2, 7, '辅助工具');
INSERT INTO mpshop_admin_auth VALUES (46, '73', '投票调查系统', '', 3, 7, '辅助工具');
INSERT INTO mpshop_admin_auth VALUES (47, '74', '友情链接系统', '', 4, 7, '辅助工具');
INSERT INTO mpshop_admin_auth VALUES (48, '75', '软件升级更新', '', 5, 7, '辅助工具');
INSERT INTO mpshop_admin_auth VALUES (49, '76', '邮件群发权限', '', 6, 7, '辅助工具');
INSERT INTO mpshop_admin_auth VALUES (50, '77', '系统日志查询', '', 7, 7, '辅助工具');
INSERT INTO mpshop_admin_auth VALUES (51, '81', '预付帐户入帐', '', 1, 8, '帐务管理');
INSERT INTO mpshop_admin_auth VALUES (52, '82', '订单收款确认', '', 2, 8, '帐务管理');
INSERT INTO mpshop_admin_auth VALUES (53, '83', '订单退款确认', '', 3, 8, '帐务管理');
INSERT INTO mpshop_admin_auth VALUES (54, '84', '链盟提成结算', '', 4, 8, '帐务管理');
INSERT INTO mpshop_admin_auth VALUES (55, '85', '账务查询统计', '', 5, 8, '帐务管理');
INSERT INTO mpshop_admin_auth VALUES (56, '86', '订单查询统计', '', 6, 8, '帐务管理');
INSERT INTO mpshop_admin_auth VALUES (57, '87', '商品销售统计', '', 7, 8, '帐务管理');
INSERT INTO mpshop_admin_auth VALUES (58, '88', '特殊定价查询', '', 8, 8, '帐务管理');
INSERT INTO mpshop_admin_auth VALUES (59, '10', '商品类型设置', '', 10, 0, '系统设置');
INSERT INTO mpshop_admin_auth VALUES (60, '91', '商品促销管理', '', 1, 9, '促销管理');
# --------------------------------------------------------

#
# 数据表的结构 `mpshop_admin_log`
#

CREATE TABLE mpshop_admin_log (
  id int(20) NOT NULL auto_increment,
  `user` char(20) NOT NULL default '',
  eventtype char(50) NOT NULL default '',
  stat int(1) NOT NULL default '0',
  securetype int(1) NOT NULL default '0',
  daytime int(11) NOT NULL default '0',
  ip char(20) NOT NULL default '',
  msg char(255) NOT NULL default '',
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# 导出下面的数据库内容 `mpshop_admin_log`
#

INSERT INTO mpshop_admin_log VALUES (1, 'admin', '管理登录', 1, 0, 1176126688, '192.168.2.201', '登录成功');
INSERT INTO mpshop_admin_log VALUES (2, 'admin', '管理登录', 1, 0, 1176172581, '192.168.2.201', '登录成功');
# --------------------------------------------------------

#
# 数据表的结构 `mpshop_admin_rights`
#

CREATE TABLE mpshop_admin_rights (
  id int(50) NOT NULL auto_increment,
  auth char(20) default NULL,
  `user` char(50) default NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# 导出下面的数据库内容 `mpshop_admin_rights`
#

INSERT INTO mpshop_admin_rights VALUES (588, '10', 'admin');
INSERT INTO mpshop_admin_rights VALUES (587, '88', 'admin');
INSERT INTO mpshop_admin_rights VALUES (586, '87', 'admin');
INSERT INTO mpshop_admin_rights VALUES (585, '86', 'admin');
INSERT INTO mpshop_admin_rights VALUES (584, '85', 'admin');
INSERT INTO mpshop_admin_rights VALUES (583, '84', 'admin');
INSERT INTO mpshop_admin_rights VALUES (582, '83', 'admin');
INSERT INTO mpshop_admin_rights VALUES (581, '82', 'admin');
INSERT INTO mpshop_admin_rights VALUES (580, '81', 'admin');
INSERT INTO mpshop_admin_rights VALUES (579, '77', 'admin');
INSERT INTO mpshop_admin_rights VALUES (578, '76', 'admin');
INSERT INTO mpshop_admin_rights VALUES (577, '75', 'admin');
INSERT INTO mpshop_admin_rights VALUES (576, '74', 'admin');
INSERT INTO mpshop_admin_rights VALUES (575, '73', 'admin');
INSERT INTO mpshop_admin_rights VALUES (574, '72', 'admin');
INSERT INTO mpshop_admin_rights VALUES (573, '71', 'admin');
INSERT INTO mpshop_admin_rights VALUES (572, '62', 'admin');
INSERT INTO mpshop_admin_rights VALUES (571, '61', 'admin');
INSERT INTO mpshop_admin_rights VALUES (570, '59', 'admin');
INSERT INTO mpshop_admin_rights VALUES (569, '58', 'admin');
INSERT INTO mpshop_admin_rights VALUES (568, '57', 'admin');
INSERT INTO mpshop_admin_rights VALUES (567, '56', 'admin');
INSERT INTO mpshop_admin_rights VALUES (566, '55', 'admin');
INSERT INTO mpshop_admin_rights VALUES (565, '54', 'admin');
INSERT INTO mpshop_admin_rights VALUES (564, '53', 'admin');
INSERT INTO mpshop_admin_rights VALUES (563, '52', 'admin');
INSERT INTO mpshop_admin_rights VALUES (562, '51', 'admin');
INSERT INTO mpshop_admin_rights VALUES (561, '47', 'admin');
INSERT INTO mpshop_admin_rights VALUES (560, '46', 'admin');
INSERT INTO mpshop_admin_rights VALUES (559, '45', 'admin');
INSERT INTO mpshop_admin_rights VALUES (558, '44', 'admin');
INSERT INTO mpshop_admin_rights VALUES (557, '43', 'admin');
INSERT INTO mpshop_admin_rights VALUES (556, '42', 'admin');
INSERT INTO mpshop_admin_rights VALUES (555, '41', 'admin');
INSERT INTO mpshop_admin_rights VALUES (554, '34', 'admin');
INSERT INTO mpshop_admin_rights VALUES (553, '33', 'admin');
INSERT INTO mpshop_admin_rights VALUES (552, '32', 'admin');
INSERT INTO mpshop_admin_rights VALUES (551, '31', 'admin');
INSERT INTO mpshop_admin_rights VALUES (550, '25', 'admin');
INSERT INTO mpshop_admin_rights VALUES (549, '24', 'admin');
INSERT INTO mpshop_admin_rights VALUES (548, '23', 'admin');
INSERT INTO mpshop_admin_rights VALUES (547, '22', 'admin');
INSERT INTO mpshop_admin_rights VALUES (546, '21', 'admin');
INSERT INTO mpshop_admin_rights VALUES (545, '17', 'admin');
INSERT INTO mpshop_admin_rights VALUES (544, '16', 'admin');
INSERT INTO mpshop_admin_rights VALUES (543, '15', 'admin');
INSERT INTO mpshop_admin_rights VALUES (542, '14', 'admin');
INSERT INTO mpshop_admin_rights VALUES (541, '13', 'admin');
INSERT INTO mpshop_admin_rights VALUES (540, '12', 'admin');
INSERT INTO mpshop_admin_rights VALUES (539, '11', 'admin');
INSERT INTO mpshop_admin_rights VALUES (538, '9', 'admin');
INSERT INTO mpshop_admin_rights VALUES (537, '8', 'admin');
INSERT INTO mpshop_admin_rights VALUES (536, '7', 'admin');
INSERT INTO mpshop_admin_rights VALUES (535, '6', 'admin');
INSERT INTO mpshop_admin_rights VALUES (534, '5', 'admin');
INSERT INTO mpshop_admin_rights VALUES (533, '4', 'admin');
INSERT INTO mpshop_admin_rights VALUES (532, '3', 'admin');
INSERT INTO mpshop_admin_rights VALUES (531, '2', 'admin');
INSERT INTO mpshop_admin_rights VALUES (530, '1', 'admin');
INSERT INTO mpshop_admin_rights VALUES (589, '91', 'admin');
# --------------------------------------------------------

#
# 数据表的结构 `mpshop_advs_dl`
#

CREATE TABLE mpshop_advs_dl (
  id int(4) NOT NULL auto_increment,
  menuid int(12) NOT NULL default '0',
  title char(200) default NULL,
  width int(10) default NULL,
  height int(10) default NULL,
  `type` char(20) default NULL,
  src char(100) default NULL,
  url char(200) default NULL,
  target char(100) default NULL,
  border int(2) default NULL,
  hidden int(1) default NULL,
  toppadding int(20) default NULL,
  sidepadding int(20) default NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# 导出下面的数据库内容 `mpshop_advs_dl`
#

INSERT INTO mpshop_advs_dl VALUES (1, 1, '', 75, 180, 'gif', 'images/duilian.gif', 'http://', '_self', 0, 1, 5, 5);
# --------------------------------------------------------

#
# 数据表的结构 `mpshop_advs_float`
#

CREATE TABLE mpshop_advs_float (
  id int(4) NOT NULL auto_increment,
  menuid int(12) NOT NULL default '0',
  title varchar(200) default NULL,
  float_advs_type varchar(10) NOT NULL default '',
  hidden int(1) NOT NULL default '0',
  float_width int(3) NOT NULL default '0',
  float_height int(3) NOT NULL default '0',
  float_url varchar(255) NOT NULL default '',
  float_target varchar(40) NOT NULL default '',
  src varchar(255) NOT NULL default '',
  float_speed int(4) NOT NULL default '0',
  border int(3) default NULL,
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# 导出下面的数据库内容 `mpshop_advs_float`
#

INSERT INTO mpshop_advs_float VALUES (1, 1, '', 'gif', 1, 100, 100, 'http://', '_self', 'images/float.gif', 100, 0);
# --------------------------------------------------------

#
# 数据表的结构 `mpshop_advs_lb`
#

CREATE TABLE mpshop_advs_lb (
  id int(20) NOT NULL auto_increment,
  title char(100) NOT NULL default '',
  src char(100) NOT NULL default '',
  url char(100) NOT NULL default '',
  xuhao int(5) NOT NULL default '0',
  PRIMARY KEY  (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

#
# 导出下面的数据库内容 `mpshop_advs_lb`
#

INSERT INTO mpshop_advs_lb VALUES (4, '广告标题2', 'advs/1176174417.jpg', 'http://www', 3);
INSERT INTO mpshop_advs_lb VALUES (3, '广告标题1', 'advs/1176174428.jpg', 'http://www', 4);
INSERT INTO mpshop_advs_lb VALUES (5, '广告标题3', 'advs/1176174406.jpg', 'http://www', 2);
INSERT INTO mpshop_advs_lb VALUES (6, '广告标题', 'advs/1176174675.jpg', 'http://', 1);
INSERT INTO mpshop_advs_lb VALUES (7, '广告标题', 'advs/1176174723.jpg', 'http://', 5);
# --------------------------------------------------------

#
# 数据表的结构 `mpshop_advs_left`
#

CREATE TABLE mpshop_advs_left (
  id int(4) NOT NULL auto_increment,
  menuid int(12) NOT NULL default '0',
  title char(200) default NULL,
  width int(10) default NULL,
  height int(10) default NULL,
  `type` char(20) default NULL,
  src char(100) default NULL,
  url char(200) default NULL,
  target char(100) default NULL,
12345

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -