【H5完美运营】积分神兽源码+带架设教程.rar

/* Navicat MySQL Data Transfer Date: 2019-04-17 18:07:40 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for codepay_order -- ---------------------------- DROP TABLE IF EXISTS `codepay_order`; CREATE TABLE `codepay_order` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `pay_id` varchar(50) NOT NULL COMMENT '用户ID或订单ID', `money` decimal(6,2) unsigned NOT NULL COMMENT '实际金额', `price` decimal(6,2) unsigned NOT NULL COMMENT '原价', `type` int(1) NOT NULL DEFAULT '1' COMMENT '支付方式', `pay_no` varchar(100) NOT NULL COMMENT '流水号', `param` varchar(200) DEFAULT NULL COMMENT '自定义参数', `pay_time` bigint(11) NOT NULL DEFAULT '0' COMMENT '付款时间', `pay_tag` varchar(100) NOT NULL DEFAULT '0' COMMENT '金额的备注', `status` int(1) NOT NULL DEFAULT '0' COMMENT '订单状态', `creat_time` bigint(11) NOT NULL DEFAULT '0' COMMENT '创建时间', `up_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', PRIMARY KEY (`id`), UNIQUE KEY `main` (`pay_id`,`pay_time`,`money`,`type`,`pay_tag`), UNIQUE KEY `pay_no` (`pay_no`,`type`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='用于区分是否已经处理'; -- ---------------------------- -- Records of codepay_order -- ---------------------------- INSERT INTO `codepay_order` VALUES ('1', '87', '10.00', '10.00', '3', '1000050301180711033206000272082001446766', null, '1531319567', '0', '2', '1531319568', '2018-07-11 22:32:48'); INSERT INTO `codepay_order` VALUES ('4', '6612', '10.00', '10.00', '3', '1000050301180712033203000342088081155766', null, '1531402012', '0', '2', '1531402014', '2018-07-12 21:26:54'); -- ---------------------------- -- Table structure for codepay_user -- ---------------------------- DROP TABLE IF EXISTS `codepay_user`; CREATE TABLE `codepay_user` ( `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '用户ID', `user` varchar(100) NOT NULL DEFAULT '' COMMENT '用户名', `money` decimal(6,2) NOT NULL DEFAULT '0.00' COMMENT '金额', `vip` int(1) NOT NULL DEFAULT '0' COMMENT '会员开通', `status` int(1) NOT NULL DEFAULT '0' COMMENT '会员状态', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of codepay_user -- ---------------------------- INSERT INTO `codepay_user` VALUES ('1', 'admin', '0.00', '0', '0'); -- ---------------------------- -- Table structure for jz_ad -- ---------------------------- DROP TABLE IF EXISTS `jz_ad`; CREATE TABLE `jz_ad` ( `ad_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '广告id', `ad_name` varchar(255) NOT NULL COMMENT '广告名称', `ad_content` text COMMENT '广告内容', `status` int(2) NOT NULL DEFAULT '1' COMMENT '状态，1显示，0不显示', PRIMARY KEY (`ad_id`), KEY `ad_name` (`ad_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of jz_ad -- ---------------------------- -- ---------------------------- -- Table structure for jz_all_record -- ---------------------------- DROP TABLE IF EXISTS `jz_all_record`; CREATE TABLE `jz_all_record` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '商城用户注册登录表', `user_id` int(11) DEFAULT NULL, `user_login` varchar(60) NOT NULL DEFAULT '' COMMENT '登录账号', `UG_type` varchar(60) DEFAULT '' COMMENT '奖金分类', `UG_integral` decimal(15,4) DEFAULT '0.0000' COMMENT '当前账户种子币余额', `number` varchar(255) DEFAULT '0.0000' COMMENT '当前帐户金币余额', `create_time` datetime DEFAULT NULL COMMENT '结算时间', `UG_allGet` decimal(20,0) DEFAULT NULL COMMENT '用户密码', `UG_balance` decimal(20,0) DEFAULT NULL COMMENT '当前账户余额', `UG_regIP` varchar(30) DEFAULT '', `wallet` varchar(100) DEFAULT '' COMMENT '分红类型', `notice` text COMMENT '金币获取说明', `UG_othraccount` varchar(60) DEFAULT NULL COMMENT '推荐帐号/开单帐号', `yb` decimal(15,4) DEFAULT '0.0000', `ybhe` decimal(15,4) DEFAULT NULL, `zsb` decimal(15,4) DEFAULT NULL, `zsbhe` decimal(15,4) DEFAULT NULL, `yb1` decimal(15,4) DEFAULT NULL, `zsb1` decimal(15,4) DEFAULT NULL, `varid` int(11) NOT NULL DEFAULT '0', `type` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`), KEY `user_login` (`user_login`) ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of jz_all_record -- ---------------------------- INSERT INTO `jz_all_record` VALUES ('1', null, '8888', '', '0.0000', '+8888888', '2019-02-23 19:38:15', null, null, '', 'fk', '系统操作', null, '0.0000', null, null, null, null, null, '0', 'systerm'); INSERT INTO `jz_all_record` VALUES ('2', null, '8888', '', '0.0000', '+52000', '2019-02-23 19:38:18', null, null, '', 'credits', '系统操作', null, '0.0000', null, null, null, null, null, '0', 'systerm'); INSERT INTO `jz_all_record` VALUES ('3', null, '8888', '', '0.0000', '+9999', '2019-04-11 20:12:35', null, null, '', 'fk', '系统操作', null, '0.0000', null, null, null, null, null, '0', 'systerm'); INSERT INTO `jz_all_record` VALUES ('4', null, '8888', '', '0.0000', '+52000', '2019-04-11 20:12:58', null, null, '', 'credits', '系统操作', null, '0.0000', null, null, null, null, null, '0', 'systerm'); INSERT INTO `jz_all_record` VALUES ('5', null, '8888', '', '0.0000', '+10000', '2019-04-12 15:37:04', null, null, '', 'fk', '系统操作', null, '0.0000', null, null, null, null, null, '0', 'systerm'); INSERT INTO `jz_all_record` VALUES ('6', null, '17776', '', '0.0000', '+3000', '2019-04-16 19:36:10', null, null, '', 'fk', '系统操作', null, '0.0000', null, null, null, null, null, '0', 'systerm'); INSERT INTO `jz_all_record` VALUES ('7', '17776', 'test17776', '', '0.0000', '-100', '2019-04-16 19:49:49', null, null, '', 'fk', '制作房卡包', null, '0.0000', null, null, null, null, null, '0', ''); INSERT INTO `jz_all_record` VALUES ('8', '17776', 'test17776', '', '0.0000', '100', '2019-04-16 19:49:50', null, null, '', 'fk', '领取房卡包', null, '0.0000', null, null, null, null, null, '0', ''); INSERT INTO `jz_all_record` VALUES ('9', null, '17776', '', '0.0000', '+52000', '2019-04-16 20:41:53', null, null, '', 'credits', '系统操作', null, '0.0000', null, null, null, null, null, '0', 'systerm'); INSERT INTO `jz_all_record` VALUES ('10', null, '26664', '', '0.0000', '+600', '2019-04-17 15:50:11', null, null, '', 'fk', '系统操作', null, '0.0000', null, null, null, null, null, '0', 'systerm'); INSERT INTO `jz_all_record` VALUES ('11', null, '26664', '', '0.0000', '+52000', '2019-04-17 15:50:20', null, null, '', 'credits', '系统操作', null, '0.0000', null, null, null, null, null, '0', 'systerm'); -- ---------------------------- -- Table structure for jz_asset -- ---------------------------- DROP TABLE IF EXISTS `jz_asset`; CREATE TABLE `jz_asset` ( `aid` bigint(20) NOT NULL AUTO_INCREMENT, `uid` int(11) NOT NULL DEFAULT '0' COMMENT '用户 id', `key` varchar(50) NOT NULL COMMENT '资源 key', `filename` varchar(50) DEFAULT NULL COMMENT '文件名', `filesize` int(11) DEFAULT NULL COMMENT '文件大小,单位Byte', `filepath` varchar(200) NOT NULL COMMENT '文件路径，相对于 upload 目录，可以为 url', `uploadtime` int(11) NOT NULL COMMENT '上传时间', `status` int(2) NOT NULL DEFAULT '1' COMMENT '状态，1：可用，0：删除，不可用', `meta` text COMMENT '其它详细信息，JSON格式', `suffix` varchar(50) DEFAULT NULL COMMENT '文件后缀名，不包括点', `download_times` int(11) NOT NULL DEFAULT '0' COMMENT '下载次数', PRIMARY KEY (`aid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of jz_asset -- ---------------------------- -- ----------------------------