gym.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for adminuser
-- ----------------------------
DROP TABLE IF EXISTS `adminuser`;
CREATE TABLE `adminuser` (
  `adminId` int(20) NOT NULL AUTO_INCREMENT,
  `adminName` varchar(20) DEFAULT NULL,
  `adminPassword` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`adminId`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of adminuser
-- ----------------------------
INSERT INTO `adminuser` VALUES ('1', 'admin', '0192023a7bbd73250516f069df18b500');
INSERT INTO `adminuser` VALUES ('7', 'liujian', '0192023a7bbd73250516f069df18b500');

-- ----------------------------
-- Table structure for chongzhi
-- ----------------------------
DROP TABLE IF EXISTS `chongzhi`;
CREATE TABLE `chongzhi` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Memberid` int(11) DEFAULT NULL,
  `Typeid` int(11) DEFAULT NULL,
  `Money` int(11) DEFAULT NULL,
  `ssmoney` int(11) DEFAULT NULL,
  `zlmoney` int(11) DEFAULT NULL,
  `Date` datetime DEFAULT NULL,
  `czjine` int(11) DEFAULT NULL,
  `beizhu` varchar(50) DEFAULT NULL,
  `czStatic` int(11) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of chongzhi
-- ----------------------------
INSERT INTO `chongzhi` VALUES ('6', '38', '2', '150', '150', '0', '2020-04-07 18:58:24', '0', '', '2');
INSERT INTO `chongzhi` VALUES ('8', '34', '1', '500', '1000', '0', '2020-04-08 15:29:09', '0', '', '2');
INSERT INTO `chongzhi` VALUES ('10', '34', null, '500', '500', '0', '2020-04-08 15:31:49', '0', '', '1');
INSERT INTO `chongzhi` VALUES ('11', '25', null, '500', '500', '0', '2020-04-08 15:33:08', '0', '', '1');
INSERT INTO `chongzhi` VALUES ('12', '26', '5', '50', '100', '50', '2020-04-08 15:37:17', '0', '', '2');
INSERT INTO `chongzhi` VALUES ('13', '26', '1', '500', '1000', '500', '2020-04-08 15:38:22', '0', '', '2');
INSERT INTO `chongzhi` VALUES ('14', '26', '1', '500', '500', '0', '2020-04-08 15:40:44', '0', '', '2');
INSERT INTO `chongzhi` VALUES ('15', '26', '1', '500', '500', '0', '2020-04-08 15:42:03', '0', '', '2');
INSERT INTO `chongzhi` VALUES ('16', '34', '5', '50', '50', '0', '2020-04-08 15:43:00', '0', '', '2');
INSERT INTO `chongzhi` VALUES ('17', '34', '3', '1000', '1000', '0', '2020-04-08 15:43:33', '0', '', '2');
INSERT INTO `chongzhi` VALUES ('18', '34', '1', '500', '500', '0', '2020-04-08 15:43:51', '0', '', '2');
INSERT INTO `chongzhi` VALUES ('19', '34', '2', '150', '1000', '850', '2020-04-08 15:44:37', '0', '', '2');
INSERT INTO `chongzhi` VALUES ('20', '34', '1', '500', '500', '0', '2020-04-08 15:46:55', '0', '', '2');
INSERT INTO `chongzhi` VALUES ('32', '25', '1', '500', '500', '0', '2020-04-08 17:43:37', '0', '', '2');
INSERT INTO `chongzhi` VALUES ('57', '26', null, '-10', '200', '0', '2020-04-08 18:25:19', '0', '', '1');
INSERT INTO `chongzhi` VALUES ('58', '26', null, '50', '200', '0', '2020-04-08 18:25:35', '0', '', '1');
INSERT INTO `chongzhi` VALUES ('60', '26', '5', '50', '100', '50', '2020-04-08 18:37:19', '0', '', '2');
INSERT INTO `chongzhi` VALUES ('61', '25', '2', '150', '200', '50', '2020-04-11 16:28:03', '0', '', '2');