how_to_create_test_data
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Today2017-10-11
2
3
article
4
displayedidtitleauthor_idopenopen_daydeleted
5
YES1title1112017-10-100
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (1, 'title1', 1, 1, '2017-10-10', 0);
6
NO2title2102017-10-100
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (2, 'title2', 1, 0, '2017-10-10', 0);
7
NO3title3112017-10-101
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (3, 'title3', 1, 1, '2017-10-10', 1);
8
NO4title4102017-10-101
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (4, 'title4', 1, 0, '2017-10-10', 1);
9
YES5title5112017-10-110
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (5, 'title5', 1, 1, '2017-10-11', 0);
10
NO6title6102017-10-110
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (6, 'title6', 1, 0, '2017-10-11', 0);
11
NO7title7112017-10-111
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (7, 'title7', 1, 1, '2017-10-11', 1);
12
NO8title8102017-10-111
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (8, 'title8', 1, 0, '2017-10-11', 1);
13
NO9title9112017-10-120
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (9, 'title9', 1, 1, '2017-10-12', 0);
14
NO10title10102017-10-120
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (10, 'title10', 1, 0, '2017-10-12', 0);
15
NO11title11112017-10-121
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (11, 'title11', 1, 1, '2017-10-12', 1);
16
NO12title12102017-10-121
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (12, 'title12', 1, 0, '2017-10-12', 1);
17
NO13title13212017-10-100
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (13, 'title13', 2, 1, '2017-10-10', 0);
18
NO14title14202016-08-030
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (14, 'title14', 2, 0, '2016-08-03', 0);
19
NO15title15212016-08-031
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (15, 'title15', 2, 1, '2016-08-03', 1);
20
NO16title16202016-08-031
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (16, 'title16', 2, 0, '2016-08-03', 1);
21
NO17title17212017-10-110
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (17, 'title17', 2, 1, '2017-10-11', 0);
22
NO18title18202016-08-040
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (18, 'title18', 2, 0, '2016-08-04', 0);
23
NO19title19212016-08-041
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (19, 'title19', 2, 1, '2016-08-04', 1);
24
NO20title20202016-08-041
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (20, 'title20', 2, 0, '2016-08-04', 1);
25
NO21title21212017-10-120
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (21, 'title21', 2, 1, '2017-10-12', 0);
26
NO22title22202016-08-050
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (22, 'title22', 2, 0, '2016-08-05', 0);
27
NO23title23212016-08-051
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (23, 'title23', 2, 1, '2016-08-05', 1);
28
NO24title24202016-08-051
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (24, 'title24', 2, 0, '2016-08-05', 1);
29
YES25title25112017-10-100
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (25, 'title25', 1, 1, '2017-10-10', 0);
30
NO26title26102016-08-030
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (26, 'title26', 1, 0, '2016-08-03', 0);
31
NO27title27112016-08-031
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (27, 'title27', 1, 1, '2016-08-03', 1);
32
NO28title28102016-08-031
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (28, 'title28', 1, 0, '2016-08-03', 1);
33
YES29title29112017-10-110
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (29, 'title29', 1, 1, '2017-10-11', 0);
34
NO30title30102016-08-040
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (30, 'title30', 1, 0, '2016-08-04', 0);
35
NO31title31112016-08-041
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (31, 'title31', 1, 1, '2016-08-04', 1);
36
NO32title32102016-08-041
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (32, 'title32', 1, 0, '2016-08-04', 1);
37
NO33title33112017-10-120
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (33, 'title33', 1, 1, '2017-10-12', 0);
38
NO34title34102016-08-050
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (34, 'title34', 1, 0, '2016-08-05', 0);
39
NO35title35112016-08-051
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (35, 'title35', 1, 1, '2016-08-05', 1);
40
NO36title36102016-08-051
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (36, 'title36', 1, 0, '2016-08-05', 1);
41
NO37title37212017-10-100
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (37, 'title37', 2, 1, '2017-10-10', 0);
42
NO38title38202016-08-030
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (38, 'title38', 2, 0, '2016-08-03', 0);
43
NO39title39212016-08-031
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (39, 'title39', 2, 1, '2016-08-03', 1);
44
NO40title40202016-08-031
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (40, 'title40', 2, 0, '2016-08-03', 1);
45
NO41title41212017-10-110
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (41, 'title41', 2, 1, '2017-10-11', 0);
46
NO42title42202016-08-040
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (42, 'title42', 2, 0, '2016-08-04', 0);
47
NO43title43212016-08-041
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (43, 'title43', 2, 1, '2016-08-04', 1);
48
NO44title44202016-08-041
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (44, 'title44', 2, 0, '2016-08-04', 1);
49
NO45title45212017-10-120
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (45, 'title45', 2, 1, '2017-10-12', 0);
50
NO46title46202016-08-050
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (46, 'title46', 2, 0, '2016-08-05', 0);
51
NO47title47212016-08-051
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (47, 'title47', 2, 1, '2016-08-05', 1);
52
NO48title48202016-08-051
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (48, 'title48', 2, 0, '2016-08-05', 1);
53
YES49title49112017-10-100
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (49, 'title49', 1, 1, '2017-10-10', 0);
54
NO50title50102016-08-030
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (50, 'title50', 1, 0, '2016-08-03', 0);
55
NO51title51112016-08-031
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (51, 'title51', 1, 1, '2016-08-03', 1);
56
NO52title52102016-08-031
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (52, 'title52', 1, 0, '2016-08-03', 1);
57
YES53title53112017-10-110
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (53, 'title53', 1, 1, '2017-10-11', 0);
58
NO54title54102016-08-040
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (54, 'title54', 1, 0, '2016-08-04', 0);
59
NO55title55112016-08-041
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (55, 'title55', 1, 1, '2016-08-04', 1);
60
NO56title56102016-08-041
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (56, 'title56', 1, 0, '2016-08-04', 1);
61
NO57title57112017-10-120
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (57, 'title57', 1, 1, '2017-10-12', 0);
62
NO58title58102016-08-050
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (58, 'title58', 1, 0, '2016-08-05', 0);
63
NO59title59112016-08-051
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (59, 'title59', 1, 1, '2016-08-05', 1);
64
NO60title60102016-08-051
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (60, 'title60', 1, 0, '2016-08-05', 1);
65
NO61title61212017-10-100
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (61, 'title61', 2, 1, '2017-10-10', 0);
66
NO62title62202016-08-030
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (62, 'title62', 2, 0, '2016-08-03', 0);
67
NO63title63212016-08-031
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (63, 'title63', 2, 1, '2016-08-03', 1);
68
NO64title64202016-08-031
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (64, 'title64', 2, 0, '2016-08-03', 1);
69
NO65title65212017-10-110
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (65, 'title65', 2, 1, '2017-10-11', 0);
70
NO66title66202016-08-040
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (66, 'title66', 2, 0, '2016-08-04', 0);
71
NO67title67212016-08-041
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (67, 'title67', 2, 1, '2016-08-04', 1);
72
NO68title68202016-08-041
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (68, 'title68', 2, 0, '2016-08-04', 1);
73
NO69title69212017-10-120
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (69, 'title69', 2, 1, '2017-10-12', 0);
74
NO70title70202016-08-050
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (70, 'title70', 2, 0, '2016-08-05', 0);
75
NO71title71212016-08-051
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (71, 'title71', 2, 1, '2016-08-05', 1);
76
NO72title72202016-08-051
INSERT INTO article (id, title, author_id, open, open_day, deleted) VALUES (72, 'title72', 2, 0, '2016-08-05', 1);
77
78
79
author
80
displayedidnamedeleted
81
YES1author10
INSERT INTO author (id, name, deleted) VALUES (1, 'author1', 0);
82
NO2author21
INSERT INTO author (id, name, deleted) VALUES (2, 'author2', 1);
83
84
85
favorite
86
displayedidarticle_id
87
YES11
INSERT INTO favorite (id, article_id) VALUES (1, 1);
88
NO22
INSERT INTO favorite (id, article_id) VALUES (2, 2);
89
NO33
INSERT INTO favorite (id, article_id) VALUES (3, 3);
90
NO44
INSERT INTO favorite (id, article_id) VALUES (4, 4);
91
YES55
INSERT INTO favorite (id, article_id) VALUES (5, 5);
92
NO66
INSERT INTO favorite (id, article_id) VALUES (6, 6);
93
NO77
INSERT INTO favorite (id, article_id) VALUES (7, 7);
94
NO88
INSERT INTO favorite (id, article_id) VALUES (8, 8);
95
NO99
INSERT INTO favorite (id, article_id) VALUES (9, 9);
96
NO1010
INSERT INTO favorite (id, article_id) VALUES (10, 10);
97
NO1111
INSERT INTO favorite (id, article_id) VALUES (11, 11);
98
NO1212
INSERT INTO favorite (id, article_id) VALUES (12, 12);
99
NO1313
INSERT INTO favorite (id, article_id) VALUES (13, 13);
100
NO1414
INSERT INTO favorite (id, article_id) VALUES (14, 14);
Loading...
 
 
 
Ideal
Better