T4fwWNHw

1-- Adminer 4.7.7 MySQL dump
2
3SET NAMES utf8;
4SET time_zone = '+00:00';
5SET foreign_key_checks = 0;
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8SET NAMES utf8mb4;
9
10DROP TABLE IF EXISTS `Statistic`;
11CREATE TABLE `Statistic` (
12  `statistic_id` int(11) NOT NULL AUTO_INCREMENT,
13  `user_id` int(11) NOT NULL,
14  `progress` int(11) NOT NULL,
15  `count of right answers` int(11) NOT NULL,
16  PRIMARY KEY (`statistic_id`),
17  KEY `user_id` (`user_id`),
18  CONSTRAINT `Statistic_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `Users` (`user_id`)
19) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
20
21
22DROP TABLE IF EXISTS `Users`;
23CREATE TABLE `Users` (
24  `user_id` int(11) NOT NULL AUTO_INCREMENT,
25  `fio` text NOT NULL,
26  `password` int(11) NOT NULL,
27  `progress` int(11) NOT NULL,
28  PRIMARY KEY (`user_id`)
29) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
30
31
32-- 2021-06-02 18:49:14