shhVGPHv

1--password = ""
2
3CREATE DATABASE IF NOT EXISTS `62231_viktor_mirev` CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci
4
5USE `62231_viktor_mirev`;
6
7CREATE TABLE IF NOT EXISTS users (
8    id           INT AUTO_INCREMENT PRIMARY KEY,
9    first_name   VARCHAR(63) NOT NULL,
10    family_name  VARCHAR(63) NOT NULL,
11    course_year  INT NOT NULL,
12    course_major VARCHAR(127) NOT NULL,
13    faculty_num  VARCHAR(63) NOT NULL,
14    group_num    INT NOT NULL,
15    birthdate    DATE NOT NULL,
16    website      VARCHAR(255),
17    photo_dir    VARCHAR(255) NOT NULL,
18    motivation   TEXT
19);
20
21INSERT INTO
22    users (
23        first_name,
24        family_name,
25        course_year,
26        course_major,
27        faculty_num,
28        group_num,
29        birthdate,
30        website,
31        photo_dir,
32        motivation
33    )
34VALUES
35    (
36        'Viktor',
37        'Mirev',
38        3,
39        'SE',
40        '52231',
41        1,
42        '1998-06-06',
43        'www.example.com',
44        './pictures/example.png',
45        'I am motivated! OK?'
46    );