📄 db.sql
字号:
INSERT INTO bookshop_admin_menu VALUES (76, 74, '会员积分管理', 'member_cent_frame.php', 1, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (77, 9, '网站标志', '', 1, 1, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (82, 49, '浮动广告', '', 2, 1, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (80, 64, '新到会员审核', 'member_new_frame.php', 0, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (83, 82, '新建浮动广告', 'advs_float_frame.php?type=add', 1, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (84, 82, '管理浮动广告', 'advs_float_frame.php', 1, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (85, 0, '工具(<u>T</u>)', '', 8, 1, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (179, 135, '后台菜单设置', 'super_admmenu_frame.php', 1, 0, 'mainframe', 'supervisor');
INSERT INTO bookshop_admin_menu VALUES (123, 122, '未受理订单', 'order_frame.php?type=new', 1, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (88, 49, '通栏广告', '', 5, 1, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (89, 88, '新建通栏广告', 'advs_flh_frame.php?type=add', 1, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (90, 88, '管理通栏广告', 'advs_flh_frame.php', 2, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (176, 3, '首页参数设置', 'config_frame.php?type=index', 2, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (94, 49, '旗帜广告', '', 4, 1, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (95, 94, '新建旗帜广告', 'advs_banner_frame.php?type=add', 1, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (96, 94, '管理旗帜广告', 'advs_banner_frame.php', 2, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (97, 49, '对联广告', '', 5, 1, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (98, 97, '新建对联广告', 'advs_dl_frame.php?type=add', 1, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (99, 97, '管理对联广告', 'advs_dl_frame.php', 2, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (100, 49, '左侧挂角广告', '', 8, 1, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (101, 100, '新建挂角广告', 'advs_left_frame.php?type=add', 1, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (102, 100, '管理挂角广告', 'advs_left_frame.php', 2, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (103, 49, '右侧挂角广告', '', 9, 1, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (104, 103, '新建挂角广告', 'advs_right_frame.php?type=add', 1, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (105, 103, '管理挂角广告', 'advs_right_frame.php', 2, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (106, 85, '网站数据备份', 'data_frame.php', 2, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (151, 114, '管理栏目主题广告', 'advs_menu_frame.php', 2, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (180, 135, '更换网站模版', 'design_temp.php', 2, 0, 'mainframe', 'supervisor');
INSERT INTO bookshop_admin_menu VALUES (155, 142, '订单查询统计', 'account_frame.php?type=order', 5, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (110, 85, '网站缓存系统', 'catch_frame.php', 1, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (135, 0, '高级(<u>H</u>)', '', 17, 1, 'mainframe', 'supervisor');
INSERT INTO bookshop_admin_menu VALUES (141, 132, '表单信息管理', 'bbs_frame.php?type=form', 3, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (142, 0, '帐务(<u>A</u>)', '', 7, 1, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (143, 142, '汇款通知查询', 'account_frame.php?type=notice', 1, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (144, 142, '付款到帐确认', 'account_frame.php?type=check', 2, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (145, 142, '帐务查询统计', 'account_frame.php?type=look', 3, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (147, 3, '地区区域设置', 'config_frame.php?type=zone', 6, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (148, 3, '行业分类设置', 'config_frame.php?type=cat', 7, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (150, 77, '管理网站标志', 'logo_frame.php', 2, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (158, 85, '友情链接系统', 'link_frame.php', 6, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (159, 9, '版权信息', 'design_frame.php?type=copyright', 8, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (160, 9, '菜单样式', 'design_frame.php?type=menu', 7, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (161, 22, '高级页面设置', 'd_page_frame.php', 4, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (178, 1, '系统版本信息', 'javascript:Hpop()', 4, 0, 'mainframe', 'admin');
INSERT INTO bookshop_admin_menu VALUES (181, 3, '包装方式设置', 'config_frame.php?type=paper', 8, 0, 'mainframe', 'admin');
# --------------------------------------------------------
#
# 数据表的结构 `bookshop_admin_rights`
#
DROP TABLE IF EXISTS bookshop_admin_rights;
CREATE TABLE bookshop_admin_rights (
id int(50) NOT NULL auto_increment,
auth char(20) default NULL,
user char(50) default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;
#
# 导出下面的数据库内容 `bookshop_admin_rights`
#
INSERT INTO bookshop_admin_rights VALUES (222, '54', 'admin');
INSERT INTO bookshop_admin_rights VALUES (221, '53', 'admin');
INSERT INTO bookshop_admin_rights VALUES (220, '52', 'admin');
INSERT INTO bookshop_admin_rights VALUES (219, '51', 'admin');
INSERT INTO bookshop_admin_rights VALUES (218, '50', 'admin');
INSERT INTO bookshop_admin_rights VALUES (217, '7', 'admin');
INSERT INTO bookshop_admin_rights VALUES (216, '31', 'admin');
INSERT INTO bookshop_admin_rights VALUES (215, '30', 'admin');
INSERT INTO bookshop_admin_rights VALUES (214, '19', 'admin');
INSERT INTO bookshop_admin_rights VALUES (213, '10', 'admin');
INSERT INTO bookshop_admin_rights VALUES (212, '18', 'admin');
INSERT INTO bookshop_admin_rights VALUES (211, '14', 'admin');
INSERT INTO bookshop_admin_rights VALUES (210, '16', 'admin');
INSERT INTO bookshop_admin_rights VALUES (209, '15', 'admin');
INSERT INTO bookshop_admin_rights VALUES (208, '13', 'admin');
INSERT INTO bookshop_admin_rights VALUES (207, '12', 'admin');
INSERT INTO bookshop_admin_rights VALUES (206, '45', 'admin');
INSERT INTO bookshop_admin_rights VALUES (205, '44', 'admin');
INSERT INTO bookshop_admin_rights VALUES (204, '43', 'admin');
INSERT INTO bookshop_admin_rights VALUES (203, '42', 'admin');
INSERT INTO bookshop_admin_rights VALUES (202, '41', 'admin');
INSERT INTO bookshop_admin_rights VALUES (201, '40', 'admin');
INSERT INTO bookshop_admin_rights VALUES (200, '86', 'admin');
INSERT INTO bookshop_admin_rights VALUES (199, '85', 'admin');
INSERT INTO bookshop_admin_rights VALUES (198, '84', 'admin');
INSERT INTO bookshop_admin_rights VALUES (197, '27', 'admin');
INSERT INTO bookshop_admin_rights VALUES (196, '6', 'admin');
INSERT INTO bookshop_admin_rights VALUES (195, '5', 'admin');
INSERT INTO bookshop_admin_rights VALUES (194, '4', 'admin');
INSERT INTO bookshop_admin_rights VALUES (193, '26', 'admin');
INSERT INTO bookshop_admin_rights VALUES (192, '25', 'admin');
INSERT INTO bookshop_admin_rights VALUES (191, '24', 'admin');
INSERT INTO bookshop_admin_rights VALUES (190, '23', 'admin');
INSERT INTO bookshop_admin_rights VALUES (189, '22', 'admin');
INSERT INTO bookshop_admin_rights VALUES (188, '17', 'admin');
INSERT INTO bookshop_admin_rights VALUES (187, '83', 'admin');
INSERT INTO bookshop_admin_rights VALUES (186, '82', 'admin');
INSERT INTO bookshop_admin_rights VALUES (185, '39', 'admin');
INSERT INTO bookshop_admin_rights VALUES (184, '81', 'admin');
INSERT INTO bookshop_admin_rights VALUES (183, '21', 'admin');
INSERT INTO bookshop_admin_rights VALUES (182, '11', 'admin');
INSERT INTO bookshop_admin_rights VALUES (181, '3', 'admin');
INSERT INTO bookshop_admin_rights VALUES (180, '2', 'admin');
INSERT INTO bookshop_admin_rights VALUES (179, '1', 'admin');
# --------------------------------------------------------
#
# 数据表的结构 `bookshop_advs_banner`
#
DROP TABLE IF EXISTS bookshop_advs_banner;
CREATE TABLE bookshop_advs_banner (
id int(4) NOT NULL auto_increment,
menuid int(20) 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,
PRIMARY KEY (id)
) TYPE=MyISAM;
#
# 导出下面的数据库内容 `bookshop_advs_banner`
#
INSERT INTO bookshop_advs_banner VALUES (1, 1, '旗帜广告', 468, 60, 'gif', 'advs/1098172938.gif', 'http://www.wastar.net', '_blank', 0, 0);
INSERT INTO bookshop_advs_banner VALUES (2, 2, '旗帜广告', 468, 60, 'gif', 'advs/1098172938.gif', 'http://www.wastar.net', '_blank', 0, 0);
INSERT INTO bookshop_advs_banner VALUES (3, 275, '旗帜广告', 468, 60, 'gif', 'advs/1098172938.gif', 'http://www.wastar.net', '_blank', 0, 0);
INSERT INTO bookshop_advs_banner VALUES (4, 150, '旗帜广告', 468, 60, 'gif', 'advs/1098172938.gif', 'http://www.wastar.net', '_blank', 0, 0);
INSERT INTO bookshop_advs_banner VALUES (5, 291, '旗帜广告', 468, 60, 'gif', 'advs/1098172938.gif', 'http://www.wastar.net', '_blank', 0, 0);
INSERT INTO bookshop_advs_banner VALUES (6, 292, '旗帜广告', 468, 60, 'gif', 'advs/1098172938.gif', 'http://www.wastar.net', '_blank', 0, 0);
INSERT INTO bookshop_advs_banner VALUES (7, 293, '旗帜广告', 468, 60, 'gif', 'advs/1098172938.gif', 'http://www.wastar.net', '_blank', 0, 0);
INSERT INTO bookshop_advs_banner VALUES (8, 287, '旗帜广告', 468, 60, 'gif', 'advs/1098172938.gif', 'http://www.wastar.net', '_blank', 0, 0);
INSERT INTO bookshop_advs_banner VALUES (9, 294, '旗帜广告', 468, 60, 'gif', 'advs/1098172938.gif', 'http://www.wastar.net', '_blank', 0, 0);
INSERT INTO bookshop_advs_banner VALUES (10, 295, '旗帜广告', 468, 60, 'gif', 'advs/1098172938.gif', 'http://www.wastar.net', '_blank', 0, 0);
INSERT INTO bookshop_advs_banner VALUES (11, 296, '旗帜广告', 468, 60, 'gif', 'advs/1098172938.gif', 'http://www.wastar.net', '_blank', 0, 0);
INSERT INTO bookshop_advs_banner VALUES (12, 297, '旗帜广告', 468, 60, 'gif', 'advs/1098172938.gif', 'http://www.wastar.net', '_blank', 0, 0);
INSERT INTO bookshop_advs_banner VALUES (13, 298, '旗帜广告', 468, 60, 'gif', 'advs/1098172938.gif', 'http://www.wastar.net', '_blank', 0, 0);
INSERT INTO bookshop_advs_banner VALUES (14, 299, '旗帜广告', 468, 60, 'gif', 'advs/1098172938.gif', 'http://www.wastar.net', '_blank', 0, 0);
INSERT INTO bookshop_advs_banner VALUES (15, 300, '旗帜广告', 468, 60, 'gif', 'advs/1098172938.gif', 'http://www.wastar.net', '_blank', 0, 0);
INSERT INTO bookshop_advs_banner VALUES (16, 301, '旗帜广告', 468, 60, 'gif', 'advs/1098172938.gif', 'http://www.wastar.net', '_blank', 0, 0);
# --------------------------------------------------------
#
# 数据表的结构 `bookshop_advs_dl`
#
DROP TABLE IF EXISTS bookshop_advs_dl;
CREATE TABLE bookshop_advs_dl (
id int(4) NOT NULL auto_increment,
menuid int(20) 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)
) TYPE=MyISAM;
#
# 导出下面的数据库内容 `bookshop_advs_dl`
#
INSERT INTO bookshop_advs_dl VALUES (10, 1, '对联广告', 150, 400, 'swf', 'advs/1092487784.swf', 'http://', '_blank', 0, 1, 10, 5);
# --------------------------------------------------------
#
# 数据表的结构 `bookshop_advs_flh`
#
DROP TABLE IF EXISTS bookshop_advs_flh;
CREATE TABLE bookshop_advs_flh (
id int(4) NOT NULL auto_increment,
menuid int(20) 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,
PRIMARY KEY (id)
) TYPE=MyISAM;
#
# 导出下面的数据库内容 `bookshop_advs_flh`
#
# --------------------------------------------------------
#
# 数据表的结构 `bookshop_advs_float`
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -