UdYnw3Ma

1CREATE DATABASE IF NOT EXISTS unquale
2DEFAULT CHARACTER SET utf8
3DEFAULT COLLATE utf8_general_ci;
4use unquale;
5
6CREATE TABLE IF NOT EXISTS users (
7  id INT NOT NULL AUTO_INCREMENT,
8  fullname VARCHAR(75) NOT NULL,
9  email VARCHAR(45) NOT NULL,
10  gender VARCHAR(45) NULL,
11  password CHAR(76) NOT NULL,
12  country VARCHAR(45) NULL,
13  registrationDate DATETIME NOT NULL DEFAULT NOW(),
14  lastLoginDate DATETIME NOT NULL DEFAULT NOW(),
15  role VARCHAR(45) NOT NULL,
16  PRIMARY KEY (id)
17);
18
19CREATE TABLE IF NOT EXISTS courses (
20  id INT NOT NULL AUTO_INCREMENT,
21  title VARCHAR(255) NOT NULL,
22  description TEXT,
23  language VARCHAR(45),
24  duration INT,
25  difficulty VARCHAR(45),
26  creationDate DATETIME NOT NULL DEFAULT NOW(),
27  lastUpdateDate DATETIME NOT NULL DEFAULT NOW(),
28  cover VARCHAR(255),
29  category VARCHAR(255),
30  subcateogry VARCHAR(255),
31  status VARCHAR(255),
32  author INT NOT NULL,
33  user INT NOT NULL,
34  PRIMARY KEY (id),
35  FOREIGN KEY (author) REFERENCES users(id),
36  FOREIGN KEY (user) REFERENCES users(id),
37);
38
39CREATE TABLE IF NOT EXISTS parts (
40  id INT NOT NULL AUTO_INCREMENT,
41  title VARCHAR(255) NOT NULL,
42  course INT NOT NULL,
43  PRIMARY KEY (id),
44  FOREIGN KEY (course) REFERENCES courses(id)
45);
46
47CREATE TABLE IF NOT EXISTS chapters (
48  id INT NOT NULL AUTO_INCREMENT,
49  title VARCHAR(255) NOT NULL,
50  content TEXT,
51  part INT NOT NULL,
52  PRIMARY KEY (id),
53  FOREIGN KEY (part) REFERENCES parts(id)
54);