質問編集履歴
2
誤字訂正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -18,7 +18,7 @@
|
|
|
18
18
|
|
|
19
19
|
CREATE TABLE posts
|
|
20
20
|
|
|
21
|
-
|
|
21
|
+
(`post_id` int, `author_id` int, `publicness` varchar(10), `parent_thread_id` int, `parent_comment_id` int, `kind` varchar(10), `text` varchar(1000), `post_date` datetime)
|
|
22
22
|
|
|
23
23
|
;
|
|
24
24
|
|
|
@@ -26,23 +26,23 @@
|
|
|
26
26
|
|
|
27
27
|
INSERT INTO posts
|
|
28
28
|
|
|
29
|
-
|
|
29
|
+
(`post_id`, `author_id`, `publicness`, `parent_thread_id`, `parent_comment_id`, `kind`, `text`, `post_date`)
|
|
30
30
|
|
|
31
31
|
VALUES
|
|
32
32
|
|
|
33
|
-
|
|
33
|
+
(1, 2, 'limited', 0, 0, 'thread', '掲示板1', '2020-01-01 00:00:00')
|
|
34
34
|
|
|
35
|
-
|
|
35
|
+
,(2, 2, null, 1, 0, 'comment', 'コメント2', '2020-01-02 00:00:00')
|
|
36
36
|
|
|
37
|
-
|
|
37
|
+
,(3, 1, null, 1, 2, 'reply', '返信3', '2020-01-03 00:00:00')
|
|
38
38
|
|
|
39
|
-
|
|
39
|
+
,(4, 3, 'public', 0, 0, 'thread', '掲示板4', '2020-01-04 00:00:00')
|
|
40
40
|
|
|
41
|
-
|
|
41
|
+
,(5, 1, 'limited', 0, 0, 'thread', '掲示板5', '2020-01-05 00:00:00')
|
|
42
42
|
|
|
43
|
-
|
|
43
|
+
,(6, 2, null, 5, 0, 'comment', 'コメント6', '2020-01-06 00:00:00')
|
|
44
44
|
|
|
45
|
-
|
|
45
|
+
,(7, 3, 'folllow', 4, 0, 'thread', '掲示板7', '2020-01-07 00:00:00')
|
|
46
46
|
|
|
47
47
|
;
|
|
48
48
|
|
|
@@ -50,7 +50,7 @@
|
|
|
50
50
|
|
|
51
51
|
CREATE TABLE limiteds
|
|
52
52
|
|
|
53
|
-
|
|
53
|
+
(`limited_id` int, `thread_id` int, `target_id` int)
|
|
54
54
|
|
|
55
55
|
;
|
|
56
56
|
|
|
@@ -58,23 +58,23 @@
|
|
|
58
58
|
|
|
59
59
|
INSERT INTO limiteds
|
|
60
60
|
|
|
61
|
-
|
|
61
|
+
(`limited_id`, `thread_id`, `target_id`)
|
|
62
62
|
|
|
63
63
|
VALUES
|
|
64
64
|
|
|
65
|
-
|
|
65
|
+
#thread1がuser1547105473に公開されてる
|
|
66
66
|
|
|
67
|
-
|
|
67
|
+
(1, 1, 1547105473)
|
|
68
68
|
|
|
69
|
-
|
|
69
|
+
#thread5がuser4902045731とuser2305478462に公開されてる
|
|
70
70
|
|
|
71
|
-
|
|
71
|
+
,(2, 5, 4902045731), (3, 5, 2305478462)
|
|
72
72
|
|
|
73
|
-
|
|
73
|
+
|
|
74
74
|
|
|
75
|
-
|
|
75
|
+
#もし１つのtureadが1000人に公開される場合
|
|
76
76
|
|
|
77
|
-
|
|
77
|
+
#それだけでここが1000レコードになってしまう
|
|
78
78
|
|
|
79
79
|
;
|
|
80
80
|
|
|
@@ -104,7 +104,7 @@
|
|
|
104
104
|
|
|
105
105
|
CREATE TABLE posts
|
|
106
106
|
|
|
107
|
-
|
|
107
|
+
(`post_id` int, `author_id` int, `publicness` varchar(10), `parent_thread_id` int, `parent_comment_id` int, `kind` varchar(10), `text` varchar(1000), `post_date` datetime, `limited_ids` text(10000))
|
|
108
108
|
|
|
109
109
|
;
|
|
110
110
|
|
|
@@ -112,23 +112,23 @@
|
|
|
112
112
|
|
|
113
113
|
INSERT INTO posts
|
|
114
114
|
|
|
115
|
-
|
|
115
|
+
(`post_id`, `author_id`, `publicness`, `parent_thread_id`, `parent_comment_id`, `kind`, `text`, `post_date`, `limited_ids`)
|
|
116
116
|
|
|
117
117
|
VALUES
|
|
118
118
|
|
|
119
|
-
|
|
119
|
+
(1, 2, 'limited', 0, 0, 'thread', '掲示板1', '2020-01-01 00:00:00', '1547105473')
|
|
120
120
|
|
|
121
|
-
|
|
121
|
+
,(2, 2, null, 1, 0, 'comment', 'コメント2', '2020-01-02 00:00:00', null)
|
|
122
122
|
|
|
123
|
-
|
|
123
|
+
,(3, 1, null, 1, 2, 'reply', '返信3', '2020-01-03 00:00:00', null)
|
|
124
124
|
|
|
125
|
-
|
|
125
|
+
,(4, 3, 'public', 0, 0, 'thread', '掲示板4', '2020-01-04 00:00:00', null)
|
|
126
126
|
|
|
127
|
-
|
|
127
|
+
,(5, 1, 'limited', 0, 0, 'thread', '掲示板5', '2020-01-05 00:00:00', '4902045731|2305478462')
|
|
128
128
|
|
|
129
|
-
|
|
129
|
+
,(6, 2, null, 5, 0, 'comment', 'コメント6', '2020-01-06 00:00:00', null)
|
|
130
130
|
|
|
131
|
-
|
|
131
|
+
,(7, 3, 'folllow', 4, 0, 'thread', '掲示板7', '2020-01-07 00:00:00', null)
|
|
132
132
|
|
|
133
133
|
;
|
|
134
134
|
|
1
カラム名誤字訂正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -18,7 +18,7 @@
|
|
|
18
18
|
|
|
19
19
|
CREATE TABLE posts
|
|
20
20
|
|
|
21
|
-
(`post_id` int, `author_id` int, `publicness` varchar(10), `parent_thread_id` int, `parent_comment_id` int, `kind` varchar(10), `text` varchar(1000), `date` datetime)
|
|
21
|
+
(`post_id` int, `author_id` int, `publicness` varchar(10), `parent_thread_id` int, `parent_comment_id` int, `kind` varchar(10), `text` varchar(1000), `post_date` datetime)
|
|
22
22
|
|
|
23
23
|
;
|
|
24
24
|
|
|
@@ -26,7 +26,7 @@
|
|
|
26
26
|
|
|
27
27
|
INSERT INTO posts
|
|
28
28
|
|
|
29
|
-
(`post_id`, `author_id`, `publicness`, `parent_thread_id`, `parent_comment_id`, `kind`, `text`, `date`)
|
|
29
|
+
(`post_id`, `author_id`, `publicness`, `parent_thread_id`, `parent_comment_id`, `kind`, `text`, `post_date`)
|
|
30
30
|
|
|
31
31
|
VALUES
|
|
32
32
|
|