DhF7ie5Y

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    Password VARCHAR(255) NOT NULL,
13    FirstName VARCHAR(255) NOT NULL,
14    LastName VARCHAR(255) NOT NULL,
15    Email VARCHAR(255),
16    ROLE_Id INT,
17    FOREIGN KEY (ROLE_Id)
18        REFERENCES Role (Id)
19);
20CREATE TABLE Friends (
21    Friends_id INT AUTO_INCREMENT PRIMARY KEY,
22    setFriendName VARCHAR(255),
23    setFriendID INT,
24    setFriendAddr VARCHAR(255),
25    setAge INT,
26    setFavouriteColor VARCHAR(255)
27);
28CREATE TABLE Profile (
29    Id INT AUTO_INCREMENT PRIMARY KEY,
30    Id_Article INT UNIQUE,
31    FOREIGN KEY (id)
32        REFERENCES User (NAME_id),
33    FOREIGN KEY (id)
34        REFERENCES Friends (Friends_id)
35);
36
37
38CREATE TABLE Interests (
39    Id INT AUTO_INCREMENT PRIMARY KEY,
40    Name_Id INT UNIQUE,
41    FOREIGN KEY (Name_Id)
42        REFERENCES User (NAME_Id),
43    Name_Of_The_Interest VARCHAR(255)
44);
45
46CREATE TABLE Article (
47    Id INT AUTO_INCREMENT PRIMARY KEY,
48    Topic VARCHAR(255) NOT NULL,
49    Mark INT,
50    Profile_id INT,
51    FOREIGN KEY (Profile_id)
52        REFERENCES Profile (id)
53);
54
55/*this 2 things down here are just a basic tests :D */
56SELECT 
57    *
58FROM
59    Article;
60SELECT 
61    *
62FROM
63    User;
64    
65    
66Insert into User(Username,Password,FirstName,LastName,Email, Role_id)values('vladmayser','palkia','Vladimir','Ivanov','kaska1997@abv.bg', 1);
67Insert into Evil_Proof.User(Username,Password,FirstName,LastName,Email,Role_id) Values(?,?,?,?,?,?)