yimiaoyuyue.sql

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

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

/*
Navicat MySQL Data Transfer

Source Server         : 127.0.0.1
Source Server Version : 50714
Source Host           : localhost:3306
Source Database       : yimiaoyuyue

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

Date: 2021-04-25 22:48:59
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
  `userId` int(11) NOT NULL AUTO_INCREMENT,
  `userName` varchar(50) DEFAULT NULL,
  `userPw` varchar(66) DEFAULT NULL,
  `userXingming` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`userId`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES ('1', 'admin', '11', null);

-- ----------------------------
-- Table structure for jiaren
-- ----------------------------
DROP TABLE IF EXISTS `jiaren`;
CREATE TABLE `jiaren` (
  `jrID` int(11) NOT NULL AUTO_INCREMENT,
  `jrxingming` varchar(255) DEFAULT NULL,
  `jrxingbie` varchar(255) DEFAULT NULL,
  `jrchushengriqi` varchar(255) DEFAULT NULL,
  `jrnianling` varchar(255) DEFAULT NULL,
  `yonghuID` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`jrID`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of jiaren
-- ----------------------------
INSERT INTO `jiaren` VALUES ('1', '张铭', '男', '2020-08-04', '6月龄', '1609732471655');
INSERT INTO `jiaren` VALUES ('2', '张玲', '女', '2019-01-02', '2岁', '1609732471655');

-- ----------------------------
-- Table structure for news
-- ----------------------------
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news` (
  `newsid` varchar(50) NOT NULL,