/*
Navicat MySQL Data Transfer

Source Server         : boot
Source Server Version : 50720
Source Host           : localhost:3306
Source Database       : boot

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

Date: 2021-09-11 13:22:53
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for activities
-- ----------------------------
DROP TABLE IF EXISTS `activities`;
CREATE TABLE `activities` (
  `name` varchar(255) NOT NULL,
  `admin_phone` varchar(255) DEFAULT NULL,
  `starting_time` date DEFAULT NULL,
  `ending_time` date DEFAULT NULL,
  `max_step` int(11) DEFAULT NULL,
  `min_step` int(11) DEFAULT NULL,
  `ranking_rule` varchar(255) DEFAULT NULL,
  `statement` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`name`),
  KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for history
-- ----------------------------
DROP TABLE IF EXISTS `history`;
CREATE TABLE `history` (
  `phone` varchar(255) NOT NULL,
  `act_name` varchar(255) NOT NULL,
  PRIMARY KEY (`phone`,`act_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for participates
-- ----------------------------
DROP TABLE IF EXISTS `participates`;
CREATE TABLE `participates` (
  `name` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `starting_time` date DEFAULT NULL,
  `ending_time` date DEFAULT NULL,
  `max_step` int(255) DEFAULT NULL,
  `min_step` int(255) DEFAULT NULL,
  `ranking_rule` varchar(255) DEFAULT NULL,
  `statement` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`name`,`phone`),
  CONSTRAINT `fk_name` FOREIGN KEY (`name`) REFERENCES `activities` (`name`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for records
-- ----------------------------
DROP TABLE IF EXISTS `records`;
CREATE TABLE `records` (
  `date` date DEFAULT NULL,
  `user_phone` varchar(255) DEFAULT NULL,
  `step_num` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `name` varchar(255) DEFAULT NULL,
  `uid` varchar(255) DEFAULT NULL,
  `phone` varchar(255) NOT NULL,
  `role` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`phone`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;