数据库/ssmjyssmdoaxxqyzyglxthsg5168b6.sql

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

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

/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50160
Source Host           : localhost:3306
Source Database       : ssmjyssmdoaxxqyzyglxthsg5168b6

Target Server Type    : MYSQL
Target Server Version : 50160
File Encoding         : 65001

Date: 2019-03-22 15:03:06
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `allusers`
-- ----------------------------
DROP TABLE IF EXISTS `allusers`;
CREATE TABLE `allusers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) DEFAULT NULL,
  `pwd` varchar(50) DEFAULT NULL,
  `cx` varchar(50) DEFAULT '普通管理员',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Records of allusers
-- ----------------------------
INSERT INTO `allusers` VALUES ('2', 'hsg', 'hsg', '超级管理员', '2019-02-25 13:37:22');
INSERT INTO `allusers` VALUES ('6', '123456', '123456', '普通管理员', '2019-02-26 00:33:09');

-- ----------------------------
-- Table structure for `caiwu`
-- ----------------------------
DROP TABLE IF EXISTS `caiwu`;
CREATE TABLE `caiwu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `bianhao` varchar(50) DEFAULT NULL,
  `leixing` varchar(50) DEFAULT NULL,
  `xiangmuming` varchar(50) DEFAULT NULL,
  `jine` varchar(50) DEFAULT NULL,
  `riqi` date DEFAULT NULL,
  `fuzeren` varchar(50) DEFAULT NULL,
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Records of caiwu
-- ----------------------------
INSERT INTO `caiwu` VALUES ('2', '3201722492', '支出', '规范化规范化改的', '4456', '2019-04-17', '013', '2019-03-20 10:59:02');
INSERT INTO `caiwu` VALUES ('3', '3201792836', '支出', '鼓腹含和发个梵蒂冈和', '4344', '2019-04-19', '022', '2019-03-20 10:59:02');
INSERT INTO `caiwu` VALUES ('4', '3201722492', '收入', '回复黑寡妇发过火就', '8864', '2019-04-17', '018', '2019-03-20 10:59:02');
INSERT INTO `caiwu` VALUES ('5', '3201703266', '支出', '更稳定辅导费发', '5858', '2019-04-17', '026', '2019-03-20 10:59:02');
INSERT INTO `caiwu` VALUES ('6', '3201722565', '支出', 'SDGJH光伏发电', '555', '2019-03-21', '001', '2019-03-20 10:59:02');
INSERT INTO `caiwu` VALUES ('7', '03201110181695', '收入', '梵蒂冈的广泛地奉公守法', '5345', '2019-03-20', '发广', '2019-03-20 11:10:28');