3hdLy9km

1DROP DATABASE IF exists Evil_Proof;
2Create database Evil_Proof;
3use Evil_Proof;
4
5CREATE TABLE Role (
6    Id INT AUTO_INCREMENT PRIMARY KEY,
7    ROLE_NAME VARCHAR(100) NOT NULL
8);
9CREATE TABLE User (
10    NAME_Id INT AUTO_INCREMENT PRIMARY KEY,
11    Username VARCHAR(255) NOT NULL,
12    Email VARCHAR(255),
13    Password VARCHAR(255) NOT NULL,
14    ROLE_Id INT,
15    FOREIGN KEY (ROLE_Id)
16        REFERENCES Role (Id)
17);
18
19CREATE TABLE Profile (
20    Id INT AUTO_INCREMENT PRIMARY KEY,
21    Id_Article INT,
22    FOREIGN KEY (id)
23        REFERENCES User (NAME_id)
24);
25
26
27CREATE TABLE Interests (
28    Id INT AUTO_INCREMENT PRIMARY KEY,
29    Name_Id INT UNIQUE,
30    FOREIGN KEY (Name_Id)
31        REFERENCES User (NAME_Id),
32    Name_Of_The_Interest VARCHAR(255)
33);
34
35CREATE TABLE Article (
36    Id INT AUTO_INCREMENT PRIMARY KEY,
37    NAME VARCHAR(255) NOT NULL,
38    Likes INT,
39    Dislikes INT
40);
41CREATE TABLE Topic (
42    Id INT AUTO_INCREMENT PRIMARY KEY,
43    Topic VARCHAR(255)
44);
45CREATE TABLE Article_Topic (
46    Article_Id INT,
47    FOREIGN KEY (Article_Id)
48        REFERENCES Article (Id),
49    Topic_Id INT,
50    FOREIGN KEY (Topic_Id)
51        REFERENCES Topic (Id),
52    PRIMARY KEY (Article_Id , Topic_Id)
53);
54/*this 2 things down here are just a basic tests :D */
55Insert into Article(Id,Name,Likes,Dislikes)
56Values(1,'Illusions',34,12);
57
58SELECT 
59    *
60FROM
61    User;