j7TT16Wn

1DROP DATABASE IF EXISTS forum;
2CREATE DATABASE forum;
3USE forum;
4
5CREATE TABLE Articles
6(
7	Id INT PRIMARY KEY AUTO_INCREMENT NOT NULL,
8	name NVARCHAR(50) NOT NULL,
9    text NVARCHAR(1000) NOT NULL
10);
11
12CREATE TABLE Users(
13	Id INT PRIMARY KEY AUTO_INCREMENT NOT NULL,
14	Username NVARCHAR(50) NOT NULL,
15	Password NVARCHAR(50) NOT NULL,
16    IsAdmin BIT NOT NULL
17);
18
19CREATE TABLE Comments
20(
21	Id INT PRIMARY KEY AUTO_INCREMENT NOT NULL,
22	Text NVARCHAR(1000) NOT NULL,
23    userId INT NOT NULL,
24    FOREIGN KEY (UserId) REFERENCES Users(Id),
25	ArticleId INT NOT NULL,
26    FOREIGN KEY (ArticleId) REFERENCES Articles(Id)
27);
28
29CREATE TABLE ArticlesUsers
30(
31	Id INT PRIMARY KEY AUTO_INCREMENT NOT NULL,
32	UserAdminId INT NOT NULL,
33    FOREIGN KEY (UserAdminId) REFERENCES Users(Id),
34	ArticleId INT NOT NULL,
35    FOREIGN KEY (ArticleId) REFERENCES Articles(Id)
36);
37
38SELECT * FROM articles;
39SELECT * FROM users;
40SELECT * FROM comments;
41SELECT * FROM articlesusers;
42
43
44INSERT INTO articles (name, text)
45VALUES  ('SQL', 'Това е статия за въведение в SQL'),
46		('Java', 'Това е статия за въведение в Java'),
47        ('C++', 'Това е статия за въведение в C++');
48        
49INSERT INTO users (Username, Password, IsAdmin)
50VALUES  ('IvanP', 'IvanP123', TRUE),
51		('GeorgiT', 'GeorgiT123', TRUE),
52        ('IlianG', 'IlianG123', FALSE),
53        ('PeturY', 'PeturT123', FALSE);
54        
55INSERT INTO comments (Text, userId, ArticleId)
56VALUES  ('Това е много полезна статия', 2, 2),
57		('Това е много интересно', 4, 1),
58        ('Скукааааа!!!', 3, 3);
59        
60INSERT INTO articlesusers (UserAdminId, ArticleId)
61VALUES  (, ),
62		(, ),
63        (, ),
64        (, );