WaStar网上商店系统 v4.3

# MySQL dump 8.14 # # Host: localhost Database: ws_webshop4x6 #-------------------------------------------------------- # Server version 3.23.41-nt # # Table structure for table 'webshop_admin' # CREATE TABLE webshop_admin ( id int(6) NOT NULL auto_increment, user char(30) NOT NULL default '', password char(50) default NULL, moveable int(1) default NULL, PRIMARY KEY (id) ) TYPE=MyISAM; # # Dumping data for table 'webshop_admin' # INSERT INTO webshop_admin VALUES (3,'admin','6804a8ff007779f9',0); # # Table structure for table 'webshop_admin_auth' # CREATE TABLE webshop_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; # # Dumping data for table 'webshop_admin_auth' # INSERT INTO webshop_admin_auth VALUES (1,'1','系统参数设置','系统参数设置,网站设置',1,0,'设置'); INSERT INTO webshop_admin_auth VALUES (2,'2','修改管理密码','修改管理员自己的密码',2,0,'设置'); INSERT INTO webshop_admin_auth VALUES (3,'3','管理帐户设置','新增管理帐户,修改管理权限,删除管理帐户',3,0,'设置'); INSERT INTO webshop_admin_auth VALUES (4,'11','新建网站栏目','建立网站栏目的权限',1,1,'内容'); INSERT INTO webshop_admin_auth VALUES (5,'21','会员审核管理','审核,删除未审核会员',1,2,'会员'); INSERT INTO webshop_admin_auth VALUES (6,'81','查询汇款通知','查询会员从网站发来的汇款通知',1,8,'帐务'); INSERT INTO webshop_admin_auth VALUES (7,'39','网站广告管理','发布修改网站广告',9,3,'广告'); INSERT INTO webshop_admin_auth VALUES (8,'82','会员付款入帐','用于会员预付款帐户入帐的专用权限',2,8,'帐务'); INSERT INTO webshop_admin_auth VALUES (10,'83','汇款到帐确认','用于将预付款确认为\"款已到帐\"状态',3,8,'帐务'); INSERT INTO webshop_admin_auth VALUES (11,'17','更换网站模版','更换和在线编辑网站模版',7,1,'内容'); INSERT INTO webshop_admin_auth VALUES (12,'22','会员查询管理','查询,删除会员',2,2,'会员'); INSERT INTO webshop_admin_auth VALUES (13,'23','会员帐务管理','查询会员帐户余额,付款总额,业务总额,付款记录,业务记录',3,2,'会员'); INSERT INTO webshop_admin_auth VALUES (14,'24','会员资料修改','修改会员资料,到期时间,重设会员密码',4,2,'会员'); INSERT INTO webshop_admin_auth VALUES (15,'25','会员邮件发送','会员邮件发送',5,2,'会员'); INSERT INTO webshop_admin_auth VALUES (16,'26','会员权限管理','改变会员类型,修改个别会员的权限',6,2,'会员'); INSERT INTO webshop_admin_auth VALUES (17,'4','权限项目设置','新增,修改和删除网站会员权限项目',4,0,'设置'); INSERT INTO webshop_admin_auth VALUES (18,'5','会员类型设置','增加,删除会员类型;修改参数,注册表单,功能菜单和默认授权',5,0,'设置'); INSERT INTO webshop_admin_auth VALUES (19,'6','会员积分设置','设置是否启用积分系统,积分方法',7,0,'设置'); INSERT INTO webshop_admin_auth VALUES (20,'27','会员积分管理','查询管理会员积分',8,2,'会员'); INSERT INTO webshop_admin_auth VALUES (21,'84','帐务查询统计','查询,统计会员付款的历史记录',6,8,'帐务'); INSERT INTO webshop_admin_auth VALUES (22,'85','商品销售统计','查询,统计商品销售记录',6,8,'帐务'); INSERT INTO webshop_admin_auth VALUES (23,'86','订单查询统计','查询,统计订单记录',7,8,'帐务'); INSERT INTO webshop_admin_auth VALUES (24,'40','新到订单受理','查询未受理订单,受理订单',1,4,'订单'); INSERT INTO webshop_admin_auth VALUES (25,'41','未完订单查询','查询未完成订单',2,4,'订单'); INSERT INTO webshop_admin_auth VALUES (26,'42','历史订单查询','查询已完成订单,历史订单退回处理',3,4,'订单'); INSERT INTO webshop_admin_auth VALUES (27,'43','订单付款确认','后台订单付款确认(注意:后台付款确认允许产生会员帐户欠款)',4,4,'订单'); INSERT INTO webshop_admin_auth VALUES (28,'44','订单配送确认','将订单确认为已配送状态',5,4,'订单'); INSERT INTO webshop_admin_auth VALUES (29,'45','订单退订权限','将订单退回到未受理状态,如已付款将做相应退款处理',6,4,'订单'); INSERT INTO webshop_admin_auth VALUES (30,'12','管理网站栏目','管理各栏目的网站内容发布,修改',2,1,'内容'); INSERT INTO webshop_admin_auth VALUES (31,'13','网站页面设置','页面设置权限',3,1,'内容'); INSERT INTO webshop_admin_auth VALUES (32,'15','商店栏目管理','发布修改商品,商品定价,入库',5,1,'内容'); INSERT INTO webshop_admin_auth VALUES (33,'16','首页编辑管理','管理和编辑网站首页内容的权限',6,1,'内容'); INSERT INTO webshop_admin_auth VALUES (34,'14','更换网站标志','上传修改网站标志',8,1,'内容'); INSERT INTO webshop_admin_auth VALUES (35,'18','文章栏目管理','文章分类、文章发布和修改',9,1,'内容'); INSERT INTO webshop_admin_auth VALUES (36,'10','样 式 表管理','设置网站默认样式表和菜单样式表',10,1,'内容'); INSERT INTO webshop_admin_auth VALUES (37,'19','修改版权信息','修改网站的版权信息内容',11,1,'内容'); INSERT INTO webshop_admin_auth VALUES (38,'30','表单信息管理','审核,查询,回复来自网站的表单信息',1,3,'信息'); INSERT INTO webshop_admin_auth VALUES (39,'31','评论审核管理','审核,查询网站评论',2,3,'信息'); INSERT INTO webshop_admin_auth VALUES (40,'7','其他设置权限','设置地区,行业,支付方法,配送方法等其他设置项目',8,0,'设置'); INSERT INTO webshop_admin_auth VALUES (41,'50','网站缓存系统','设置和使用网站缓存系统的权限',1,5,'工具'); INSERT INTO webshop_admin_auth VALUES (42,'51','网站数据备份','网站数据备份的权限',2,5,'工具'); INSERT INTO webshop_admin_auth VALUES (43,'52','访问统计系统','设置,查询网站统计系统',3,5,'工具'); INSERT INTO webshop_admin_auth VALUES (44,'53','投票调查系统','使用投票调查系统',4,5,'工具'); INSERT INTO webshop_admin_auth VALUES (45,'54','友情链接系统','使用友情链接系统',5,5,'工具'); INSERT INTO webshop_admin_auth VALUES (46,'87','联盟提成管理','管理联盟成员，结算联盟提成',8,8,'帐务'); INSERT INTO webshop_admin_auth VALUES (47,'88','联盟提成统计','联盟提成查询统计',9,8,'帐务'); INSERT INTO webshop_admin_auth VALUES (48,'89','在线支付查询','查询支付单号对照表',10,8,'帐务'); # # Table structure for table 'webshop_admin_func' # CREATE TABLE webshop_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; # # Dumping data for table 'webshop_admin_func' # INSERT INTO webshop_admin_func VALUES (38,'payment','其他支付方法设置','member_payother.php',3,''); INSERT INTO webshop_admin_func VALUES (28,'membernotice','会员公告管理','d_member_notice.php',1,''); INSERT INTO webshop_admin_func VALUES (29,'membernotice','发布会员公告','d_member_notice_add.php',2,''); INSERT INTO webshop_admin_func VALUES (37,'payment','实时支付方式设置','member_payment_online.php',2,''); INSERT INTO webshop_admin_func VALUES (36,'payment','汇款类支付方式设置','member_payment.php',1,''); INSERT INTO webshop_admin_func VALUES (32,'membertype','类型参数修改','member_type_setup.php',1,''); INSERT INTO webshop_admin_func VALUES (33,'membertype','注册表单设置','member_type_regform.php',2,''); INSERT INTO webshop_admin_func VALUES (34,'membertype','默认授权设置','member_type_rights.php',3,''); INSERT INTO webshop_admin_func VALUES (35,'membertype','功能菜单设置','member_type_func.php',4,''); # # Table structure for table 'webshop_admin_log' # CREATE TABLE webshop_admin_log ( id int(20) NOT NULL auto_increment, user char(20) default NULL, eventtype char(30) default NULL, daytime int(11) default NULL, ip char(20) default NULL, msg char(255) default NULL, PRIMARY KEY (id) ) TYPE=MyISAM; # # Dumping data for table 'webshop_admin_log' # INSERT INTO webshop_admin_log VALUES (1,'admin','管理登录',1109183709,'192.168.2.101','登录成功'); INSERT INTO webshop_admin_log VALUES (2,'admin','管理登录',1109258090,'192.168.2.101','登录成功'); INSERT INTO webshop_admin_log VALUES (3,'admin','管理登录',1109261984,'192.168.2.101','登录成功'); INSERT INTO webshop_admin_log VALUES (4,'admin','管理登录',1109262819,'192.168.2.101','登录成功'); INSERT INTO we