dnk

1
-- phpMyAdmin SQL Dump
2
-- version 4.9.0.1
3
-- https://www.phpmyadmin.net/
4
--
5
-- Хост: sql303.byetcluster.com
6
-- Время создания: Дек 21 2022 г., 12:30
7
-- Версия сервера: 10.3.27-MariaDB
8
-- Версия PHP: 7.2.22
9

10
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11
SET AUTOCOMMIT = 0;
12
START TRANSACTION;
13
SET time_zone = "+00:00";
14

15

16
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19
/*!40101 SET NAMES utf8mb4 */;
20

21
--
22
-- База данных: `b11_32810043_users`
23
--
24

25
-- --------------------------------------------------------
26

27
--
28
-- Структура таблицы `Users`
29
--
30

31
CREATE TABLE `Users` (
32
  `ID` int(11) NOT NULL COMMENT 'ID, Autogenerate',
33
  `Name` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
34
  `Surname` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
35
  `Patronymic` text DEFAULT NULL,
36
  `Email` text NOT NULL,
37
  `Phone` text NOT NULL,
38
  `Password` text NOT NULL,
39
  `Role` int(11) NOT NULL DEFAULT 1 COMMENT '1-pa, 2-препод, 3-админ',
40
  `Courses` text DEFAULT NULL,
41
  `PassOne` text DEFAULT NULL,
42
  `PassTwo` text DEFAULT NULL,
43
  `PassThree` text DEFAULT NULL,
44
  `Verification` tinyint(1) NOT NULL DEFAULT 0,
45
  `Hashphrase` text DEFAULT NULL COMMENT 'Admin only'
46
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
47

48
--
49
-- Индексы таблицы `Users`
50
--
51
ALTER TABLE `Users`
52
  ADD PRIMARY KEY (`ID`);
53

54
--
55
-- AUTO_INCREMENT для таблицы `Users`
56
--
57
ALTER TABLE `Users`
58
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID, Autogenerate', AUTO_INCREMENT=106;
59
COMMIT;
60

61
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
62
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
63
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
64