SQLI/SQL.txt at main · VoidGravity/SQLI · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
CREATE TABLE Utilisateur (
	UserID int PRIMARY KEY AUTO_INCREMENT,
    Name varchar(50),
    Email varchar (100)
)

CREATE TABLE Project (
	ProjecrID int PRIMARY KEY AUTO_INCREMENT,
    Name varchar(50),
    Description varchar (200),
    dates date
)
CREATE TABLE Squad (
    SquadID int PRIMARY KEY AUTO_INCREMENT,
    ProjectID int,
    UserID int,
    FOREIGN KEY (ProjectID) REFERENCES Project(ProjecrID),
    FOREIGN KEY (UserID) REFERENCES Utilisateur(UserID),
    Name varchar(50),
    Description varchar (200),
    dates date
)

CREATE TABLE Subcategory (
    SubcategoryID int PRIMARY KEY AUTO_INCREMENT,
    SubcategoryName varchar(50)
)

CREATE TABLE category (
    CategoryID int PRIMARY KEY AUTO_INCREMENT,
    SubcategoryID int,
    FOREIGN KEY (SubcategoryID) REFERENCES
    Subcategory(SubcategoryID),
    CategoryName varchar(50)
)
CREATE TABLE Ressource (
    ResourceID int PRIMARY KEY AUTO_INCREMENT,
    categoryID int,
    subcategoryId int,
    SquadID int,
    projectID int,
    FOREIGN KEY (categoryID) REFERENCES
    category(CategoryID),
    FOREIGN KEY (subcategoryId) REFERENCES
    Subcategory(SubcategoryID ),
    FOREIGN KEY (SquadID) REFERENCES
    Squad (SquadID),
    FOREIGN KEY (projectID)
    REFERENCES Project(ProjecrID)
);