spring2020-dotnet-bloggr/setup.sql at master · BoiseCodeWorks/spring2020-dotnet-bloggr · 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
51
USE bloggr;

-- -- NOTE BLOGS
-- CREATE TABLE blogs (
--     id INT NOT NULL AUTO_INCREMENT,
--     title VARCHAR(255) NOT NULL,
--     body VARCHAR(255),
--     authorId VARCHAR(255) NOT NULL,
--     isPrivate TINYINT NOT NULL,
--     PRIMARY KEY (id)
-- )

-- NOTE Comments

-- CREATE TABLE comments (
--     id INT NOT NULL AUTO_INCREMENT,
--     body VARCHAR(255) NOT NULL,
--     authorId VARCHAR(255) NOT NULL,
--     blogId INT NOT NULL,
--     PRIMARY KEY (id),

--     FOREIGN KEY (blogId)
--         REFERENCES blogs(id)
--         ON DELETE CASCADE
-- )

-- -- NOTE Tags
-- CREATE TABLE tags (
--     id INT NOT NULL AUTO_INCREMENT,
--     name VARCHAR(255) NOT NULL,
--     PRIMARY KEY (id)
-- );

-- -- NOTE blogTags
-- CREATE TABLE blogtags (
--     id INT NOT NULL AUTO_INCREMENT,
--     blogId INT NOT NULL,
--     tagId INT NOT NULL,
--     authorId VARCHAR(255) NOT NULL,
--     PRIMARY KEY (id),

--     INDEX (blogId),

--     FOREIGN KEY (blogId)
--         REFERENCES blogs(id)
--         ON DELETE CASCADE,

--     FOREIGN KEY (tagId)
--         REFERENCES tags(id)
--         ON DELETE CASCADE
-- );