📄 db.sql

📁 购物网设计的购物系统是基于WEB开发的大型购物系统。　　它以构建电子商务网站为目标
💻 SQL
📖 第 1 页 / 共 5 页
字号:
12 3 4 5 下一页
# phpMyAdmin MySQL-Dump
# version 2.3.0
# http://phpwizard.net/phpMyAdmin/
# http://www.phpmyadmin.net/ (download page)
#
# 主机: localhost
# 建立日期: Oct 23, 2004 at 07:41 PM
# 伺服机版本: 3.23.41
# PHP 版本: 4.3.2
# 数据库 : `wastar_bookshop2`
# --------------------------------------------------------

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

DROP TABLE IF EXISTS bookshop_admin;
CREATE TABLE bookshop_admin (
  id int(6) NOT NULL auto_increment,
  user char(30) NOT NULL default '',
  password char(30) NOT NULL default '',
  moveable int(1) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

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

INSERT INTO bookshop_admin VALUES (1, 'admin', '43e9a4ab75570f5b', 0);
# --------------------------------------------------------

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

DROP TABLE IF EXISTS bookshop_admin_auth;
CREATE TABLE bookshop_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)
) TYPE=MyISAM;

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

INSERT INTO bookshop_admin_auth VALUES (1, '1', '系统参数设置', '系统参数设置,网站设置', 1, 0, '设置');
INSERT INTO bookshop_admin_auth VALUES (2, '2', '修改管理密码', '修改管理员自己的密码', 2, 0, '设置');
INSERT INTO bookshop_admin_auth VALUES (3, '3', '管理帐户设置', '新增管理帐户,修改管理权限,删除管理帐户', 3, 0, '设置');
INSERT INTO bookshop_admin_auth VALUES (4, '11', '新建网站栏目', '建立网站栏目的权限', 1, 1, '内容');
INSERT INTO bookshop_admin_auth VALUES (5, '21', '会员审核管理', '审核,删除未审核会员', 1, 2, '会员');
INSERT INTO bookshop_admin_auth VALUES (6, '81', '查询汇款通知', '查询会员从网站发来的汇款通知', 1, 8, '帐务');
INSERT INTO bookshop_admin_auth VALUES (7, '39', '网站广告管理', '发布修改网站广告', 9, 3, '广告');
INSERT INTO bookshop_admin_auth VALUES (8, '82', '会员付款入帐', '用于会员预付款帐户入帐的专用权限', 2, 8, '帐务');
INSERT INTO bookshop_admin_auth VALUES (10, '83', '汇款到帐确认', '用于将预付款确认为"款已到帐"状态', 3, 8, '帐务');
INSERT INTO bookshop_admin_auth VALUES (11, '17', '更换网站模版', '更换网站模版,自定编辑模版后禁用此功能可防止误操作', 7, 1, '内容');
INSERT INTO bookshop_admin_auth VALUES (12, '22', '会员查询管理', '查询,删除会员', 2, 2, '会员');
INSERT INTO bookshop_admin_auth VALUES (13, '23', '会员帐务管理', '查询会员帐户余额,付款总额,业务总额,付款记录,业务记录', 3, 2, '会员');
INSERT INTO bookshop_admin_auth VALUES (14, '24', '会员资料修改', '修改会员资料,到期时间,重设会员密码', 4, 2, '会员');
INSERT INTO bookshop_admin_auth VALUES (15, '25', '会员邮件发送', '会员邮件发送', 5, 2, '会员');
INSERT INTO bookshop_admin_auth VALUES (16, '26', '会员权限管理', '改变会员类型,修改个别会员的权限', 6, 2, '会员');
INSERT INTO bookshop_admin_auth VALUES (17, '4', '权限项目设置', '新增,修改和删除网站会员权限项目', 4, 0, '设置');
INSERT INTO bookshop_admin_auth VALUES (18, '5', '会员类型设置', '增加,删除会员类型;修改参数,注册表单,功能菜单和默认授权', 5, 0, '设置');
INSERT INTO bookshop_admin_auth VALUES (19, '6', '会员积分设置', '设置是否启用积分系统,积分方法', 7, 0, '设置');
INSERT INTO bookshop_admin_auth VALUES (20, '27', '会员积分管理', '查询管理会员积分', 8, 2, '会员');
INSERT INTO bookshop_admin_auth VALUES (21, '84', '帐务查询统计', '查询,统计会员付款的历史记录', 6, 8, '帐务');
INSERT INTO bookshop_admin_auth VALUES (22, '85', '商品销售统计', '查询,统计商品销售记录', 6, 8, '帐务');
INSERT INTO bookshop_admin_auth VALUES (23, '86', '订单查询统计', '查询,统计订单记录', 7, 8, '帐务');
INSERT INTO bookshop_admin_auth VALUES (24, '40', '新到订单受理', '查询未受理订单,受理订单', 1, 4, '订单');
INSERT INTO bookshop_admin_auth VALUES (25, '41', '未完订单查询', '查询未完成订单', 2, 4, '订单');
INSERT INTO bookshop_admin_auth VALUES (26, '42', '历史订单查询', '查询已完成订单,历史订单退回处理', 3, 4, '订单');
INSERT INTO bookshop_admin_auth VALUES (27, '43', '订单付款确认', '后台订单付款确认(注意:后台付款确认允许产生会员帐户欠款)', 4, 4, '订单');
INSERT INTO bookshop_admin_auth VALUES (28, '44', '订单配送确认', '将订单确认为已配送状态', 5, 4, '订单');
INSERT INTO bookshop_admin_auth VALUES (29, '45', '订单退订权限', '将订单退回到未受理状态,如已付款将做相应退款处理', 6, 4, '订单');
INSERT INTO bookshop_admin_auth VALUES (30, '12', '管理网站栏目', '管理各栏目的网站内容发布,修改', 2, 1, '内容');
INSERT INTO bookshop_admin_auth VALUES (31, '13', '网站页面设置', '页面设置权限', 3, 1, '内容');
INSERT INTO bookshop_admin_auth VALUES (32, '15', '商店栏目管理', '发布修改商品,商品定价,入库', 5, 1, '内容');
INSERT INTO bookshop_admin_auth VALUES (33, '16', '首页编辑管理', '管理和编辑网站首页内容的权限', 6, 1, '内容');
INSERT INTO bookshop_admin_auth VALUES (34, '14', '更换网站标志', '上传修改网站标志', 8, 1, '内容');
INSERT INTO bookshop_admin_auth VALUES (35, '18', '编辑网站模版', '在线编辑现有网站模版', 9, 1, '内容');
INSERT INTO bookshop_admin_auth VALUES (36, '10', '样 式 表管理', '设置网站默认样式表和菜单样式表', 10, 1, '内容');
INSERT INTO bookshop_admin_auth VALUES (37, '19', '修改版权信息', '修改网站的版权信息内容', 11, 1, '内容');
INSERT INTO bookshop_admin_auth VALUES (38, '30', '表单信息管理', '审核,查询,回复来自网站的表单信息', 1, 3, '信息');
INSERT INTO bookshop_admin_auth VALUES (39, '31', '评论审核管理', '审核,查询网站评论', 2, 3, '信息');
INSERT INTO bookshop_admin_auth VALUES (40, '7', '其他设置权限', '设置地区,行业,支付方法,配送方法等其他设置项目', 8, 0, '设置');
INSERT INTO bookshop_admin_auth VALUES (41, '50', '网站缓存系统', '设置和使用网站缓存系统的权限', 1, 5, '工具');
INSERT INTO bookshop_admin_auth VALUES (42, '51', '网站数据备份', '网站数据备份的权限', 2, 5, '工具');
INSERT INTO bookshop_admin_auth VALUES (43, '52', '访问统计系统', '设置,查询网站统计系统', 3, 5, '工具');
INSERT INTO bookshop_admin_auth VALUES (44, '53', '投票调查系统', '使用投票调查系统', 4, 5, '工具');
INSERT INTO bookshop_admin_auth VALUES (45, '54', '友情链接系统', '使用友情链接系统', 5, 5, '工具');
# --------------------------------------------------------

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

DROP TABLE IF EXISTS bookshop_admin_func;
CREATE TABLE bookshop_admin_func (
  id int(12) NOT NULL auto_increment,
  coltype varchar(30) default NULL,
  func varchar(50) default NULL,
  link varchar(255) default NULL,
  xuhao int(3) default NULL,
  pages varchar(255) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

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

INSERT INTO bookshop_admin_func VALUES (38, 'payment', '其他支付方法设置', 'member_payother.php', 3, '');
INSERT INTO bookshop_admin_func VALUES (28, 'membernotice', '会员公告管理', 'd_member_notice.php', 1, '');
INSERT INTO bookshop_admin_func VALUES (29, 'membernotice', '发布会员公告', 'd_member_notice_add.php', 2, '');
INSERT INTO bookshop_admin_func VALUES (37, 'payment', '实时支付方式设置', 'member_payment_online.php', 2, '');
INSERT INTO bookshop_admin_func VALUES (36, 'payment', '汇款类支付方式设置', 'member_payment.php', 1, '');
INSERT INTO bookshop_admin_func VALUES (32, 'membertype', '类型参数修改', 'member_type_setup.php', 1, '');
INSERT INTO bookshop_admin_func VALUES (33, 'membertype', '注册表单设置', 'member_type_regform.php', 2, '');
INSERT INTO bookshop_admin_func VALUES (34, 'membertype', '默认授权设置', 'member_type_rights.php', 3, '');
INSERT INTO bookshop_admin_func VALUES (35, 'membertype', '功能菜单设置', 'member_type_func.php', 4, '');
# --------------------------------------------------------

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

DROP TABLE IF EXISTS bookshop_admin_menu;
CREATE TABLE bookshop_admin_menu (
  id int(12) NOT NULL auto_increment,
  pid int(6) default NULL,
  menu char(50) default NULL,
  url char(200) default NULL,
  xuhao int(4) default NULL,
  haveson int(1) default NULL,
  target char(30) default NULL,
  type char(20) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

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

INSERT INTO bookshop_admin_menu VALUES (1, 0, '系统(<u>S</u>)', '', 9, 1, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (2, 1, '管理帐户设置', '', 3, 1, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (3, 1, '系统参数设置', '', 1, 1, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (4, 1, '修改管理密码', 'auth_frame.php?type=modpass', 3, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (5, 0, '退出(<u>Q</u>)', 'logout.php', 19, 0, '_top', 'admin');
INSERT INTO bookshop_admin_menu VALUES (6, 2, '新增管理帐户', 'auth_frame.php?type=addauth', 2, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (7, 2, '修改管理权限', 'auth_frame.php?type=modauth', 3, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (8, 2, '删除管理帐户', 'auth_frame.php?type=delauth', 4, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (9, 0, '设计(<u>D</u>)', '', 2, 1, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (11, 9, '模版编辑', 'design_frame.php?type=tempedit', 5, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (132, 0, '信息(<u>D</u>)', '', 5, 1, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (16, 9, '网站样式', 'design_frame.php?type=style', 6, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (120, 3, '配送方法设置', 'config_frame.php?type=yun', 5, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (177, 22, '栏目菜单设置', 'd_col_frame.php', 2, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (149, 77, '新建网站标志', 'logo_frame.php?type=add', 1, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (21, 0, '预览(<u>P</u>)', '../', 18, 0, '_blank', 'admin');
INSERT INTO bookshop_admin_menu VALUES (22, 0, '栏目(<u>C</u>)', '', 1, 1, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (23, 22, '新建功能栏目', '', 1, 1, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (112, 23, '章节文章', 'd_col_frame.php?type=add&coltype=document', 4, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (25, 22, '栏目内容管理', 'd_col_frame.php?type=col', 3, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (133, 132, '网站评论审核', 'bbs_frame.php?type=new', 1, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (49, 0, '广告(<u>A</u>)', '', 8, 1, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (28, 23, '群组网页', 'd_col_frame.php?type=add&coltype=show', 3, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (29, 23, '分类文章', 'd_col_frame.php?type=add&coltype=ns', 5, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (30, 23, '图文展示', 'd_col_frame.php?type=add&coltype=cp', 5, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (31, 23, '文件下载', 'd_col_frame.php?type=add&coltype=down', 6, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (118, 3, '基本参数设置', 'config_frame.php?type=config', 1, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (33, 23, '自定表单', 'd_col_frame.php?type=add&coltype=form', 7, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (34, 23, '自定链接', 'd_col_frame.php?type=add&coltype=url', 1, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (119, 3, '支付方法设置', 'config_frame.php?type=pay', 4, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (116, 23, '网上商店', 'd_col_frame.php?type=add&coltype=shop', 12, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (115, 114, '新建栏目主题广告', 'advs_menu_frame.php?type=add', 1, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (114, 49, '栏目主题广告', '', 11, 1, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (122, 0, '订单(<u>O</u>)', '', 6, 1, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (43, 23, '模版网页', 'd_col_frame.php?type=add&coltype=htm', 2, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (51, 50, '新建弹出窗口', 'advs_pop_frame.php?type=add', 1, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (50, 49, '弹出窗口', '', 1, 1, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (52, 50, '管理弹出窗口', 'advs_pop_frame.php', 2, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (156, 85, '投票调查系统', 'poll_frame.php', 4, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (54, 85, '访问统计系统', 'stat_frame.php', 3, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (55, 54, '功能插件', 'inst_func.php', 1, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (56, 54, '动态插件', 'inst_news.php', 2, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (57, 0, '会员(<u>M</u>)', '', 4, 1, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (58, 57, '会员类型设置', '', 5, 1, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (59, 58, '新建会员类型', 'member_type.php?type=new', 1, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (60, 58, '管理会员类型', 'member_type.php', 1, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (61, 57, '权限项目设置', '', 4, 1, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (62, 61, '新建权限项目', 'secure_frame.php?type=new', 1, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (63, 61, '管理权限项目', 'secure_frame.php', 2, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (64, 57, '会员管理', '', 1, 1, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (126, 122, '已存档订单', 'order_frame.php?type=ok', 3, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (125, 122, '未完成订单', 'order_frame.php?type=yun', 2, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (67, 64, '会员查询管理', 'member_common_frame.php', 1, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (68, 64, '会员帐务管理', 'member_account_frame.php', 3, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (134, 132, '网站评论管理', 'bbs_frame.php?type=mod', 2, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (129, 142, '商品销售统计', 'account_frame.php?type=sale', 4, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (128, 3, '商店参数设置', 'config_frame.php?type=shop', 3, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (74, 57, '会员积分', '', 2, 1, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (75, 74, '会员积分设置', 'member_cent_frame.php?type=setup', 1, 0, 'mainframe', 'admin');
12 3 4 5 下一页
💿 文件大小 6032 K
👤 上传用户 KMPlayer33
📂 所属分类百货/超市行业
🏷️ 相关标签

#WEB #大型 #电子商务
⌨️ 快捷键说明

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