-
Notifications
You must be signed in to change notification settings - Fork 0
/
dd.sql
78 lines (50 loc) · 2.58 KB
/
dd.sql
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
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
CREATE TABLE blog(
id INT(11) AUTO_INCREMENT PRIMARY KEY,
status INT(11) NOT NULL,
user_id INT(11) NOT NULL,
stamp TIMESTAMP NULL DEFAULT NULL,
heading VARCHAR(64) NOT NULL,
body TEXT,
slug VARCHAR(64) NULL,
FOREIGN KEY (user_id) REFERENCES e_user(id)) ENGINE=InnoDB;
CREATE TABLE tag(
id INT(11) AUTO_INCREMENT PRIMARY KEY,
tag VARCHAR(128) NOT NULL) ENGINE=InnoDB;
CREATE TABLE blog_tag(
blog_id INT(11) NOT NULL,
tag_id INT(11) NOT NULL,
PRIMARY KEY(blog_id, tag_id),
FOREIGN KEY(blog_id) REFERENCES blog(id),
FOREIGN KEY(tag_id) REFERENCES tag(id)) ENGINE=InnoDB;
CREATE TABLE blog_image(
id INT(11) AUTO_INCREMENT PRIMARY KEY,
blog_id INT(11) NOT NULL,
filename VARCHAR(64) NOT NULL,
FOREIGN KEY(blog_id) REFERENCES blog(id)) ENGINE=InnoDB;
CREATE TABLE blog_comment(
id INT(11) AUTO_INCREMENT PRIMARY KEY,
blog_id INT(11) NOT NULL,
user_id INT(11) NOT NULL,
status INT(11) NOT NULL,
stamp TIMESTAMP NOT NULL,
heading VARCHAR(64) NULL,
body TEXT,
FOREIGN KEY(blog_id) REFERENCES blog(id),
FOREIGN KEY(user_id) REFERENCES e_user(id)) ENGINE=InnoDB;
CREATE TABLE blog_category(
id INT(11) AUTO_INCREMENT PRIMARY KEY,
blog_category_id INT(11) NULL,
label VARCHAR(64) NOT NULL,
FOREIGN KEY(blog_category_id) REFERENCES blog_category(id)) ENGINE=InnoDB;
CREATE TABLE blog_item_category(
blog_id INT(11) NOT NULL,
blog_category_id INT(11) NOT NULL,
FOREIGN KEY(blog_id) REFERENCES blog(id),
FOREIGN KEY(blog_category_id) REFERENCES blog_category(id),
PRIMARY KEY(blog_id, blog_category_id));
CREATE TABLE blog_attachment(
id INT(11) AUTO_INCREMENT PRIMARY KEY,
blog_id INT(11) NOT NULL,
filename VARCHAR(128) NULL,
url VARCHAR(128) NULL,
FOREIGN KEY(blog_id) REFERENCES blog(id)) ENGINE=InnoDB;