DB_51Aspx/ssmdb.sql

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

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

/*
Navicat MySQL Data Transfer

Source Server         : root
Source Server Version : 50621
Source Host           : localhost:3306
Source Database       : ssmdb

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

Date: 2019-11-23 15:07:59
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `t_log`
-- ----------------------------
DROP TABLE IF EXISTS `t_log`;
CREATE TABLE `t_log` (
  `id` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT,
  `visitTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '访问时间',
  `username` varchar(30) DEFAULT NULL COMMENT '操作人姓名',
  `ip` varchar(50) DEFAULT NULL COMMENT '访问ip',
  `url` varchar(200) DEFAULT NULL COMMENT '资源路径',
  `executionTime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '执行时长',
  `method` varchar(300) DEFAULT NULL COMMENT '访问方法',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_log
-- ----------------------------

-- ----------------------------
-- Table structure for `t_member`
-- ----------------------------
DROP TABLE IF EXISTS `t_member`;
CREATE TABLE `t_member` (
  `id` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL COMMENT '姓名',
  `nickName` varchar(50) DEFAULT NULL COMMENT '昵称',
  `phoneNum` varchar(20) DEFAULT NULL COMMENT '电话号码',
  `email` varchar(50) DEFAULT NULL COMMENT '邮箱',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_member
-- ----------------------------
INSERT INTO `t_member` VALUES ('0000000001', '张三', '迪迦', '4', '110@qq.com');
INSERT INTO `t_member` VALUES ('0000000002', '张四', '泰罗', '1', '120@qq.com');
INSERT INTO `t_member` VALUES ('0000000003', '张五', '雷欧', '2', '114@qq.com');
INSERT INTO `t_member` VALUES ('0000000004', '张六', '赛文', '3', '119@qq.com');

-- ----------------------------
-- Table structure for `t_order`
-- ----------------------------