-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathDatabaseExampleValues.sql
83 lines (79 loc) · 3.01 KB
/
DatabaseExampleValues.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
78
79
80
81
82
drop table if exists Project;
drop table if exists Card;
create table Project
(
id text primary key,
name text not null
);
create table Card
(
id text primary key,
content text not null,
color text not null,
projectId text not null,
foreign key (projectId) references Project (id)
);
insert into Project (id, name)
values ('1', 'Project 1');
insert into Project (id, name)
values ('2', 'Project 2');
insert into Card (id, content, color, projectId)
values ('1', 'Card 1', 'red', '1');
insert into Card (id, content, color, projectId)
values ('2', 'Card 2', 'blue', '1');
insert into Card (id, content, color, projectId)
values ('3', 'Card 3', 'green', '1');
insert into Card (id, content, color, projectId)
values ('4', 'Card 4', 'yellow', '1');
insert into Card (id, content, color, projectId)
values ('5', 'Card 5', 'red', '1');
insert into Card (id, content, color, projectId)
values ('6', 'Card 6', 'blue', '1');
insert into Card (id, content, color, projectId)
values ('7', 'Card 7', 'green', '1');
insert into Card (id, content, color, projectId)
values ('8', 'Card 8', 'yellow', '1');
insert into Card (id, content, color, projectId)
values ('9', 'Card 9', 'red', '1');
insert into Card (id, content, color, projectId)
values ('10', 'Card 10', 'blue', '1');
insert into Card (id, content, color, projectId)
values ('11', 'Card 11', 'green', '1');
insert into Card (id, content, color, projectId)
values ('12', 'Card 12', 'yellow', '1');
insert into Card (id, content, color, projectId)
values ('13', 'Card 13', 'red', '1');
insert into Card (id, content, color, projectId)
values ('14', 'Card 14', 'blue', '1');
insert into Card (id, content, color, projectId)
values ('15', 'Card 15', 'green', '1');
insert into Card (id, content, color, projectId)
values ('16', 'Card 16', 'red', '2');
insert into Card (id, content, color, projectId)
values ('17', 'Card 17', 'blue', '2');
insert into Card (id, content, color, projectId)
values ('18', 'Card 18', 'green', '2');
insert into Card (id, content, color, projectId)
values ('19', 'Card 19', 'yellow', '2');
insert into Card (id, content, color, projectId)
values ('20', 'Card 20', 'red', '2');
insert into Card (id, content, color, projectId)
values ('21', 'Card 21', 'blue', '2');
insert into Card (id, content, color, projectId)
values ('22', 'Card 22', 'green', '2');
insert into Card (id, content, color, projectId)
values ('23', 'Card 23', 'yellow', '2');
insert into Card (id, content, color, projectId)
values ('24', 'Card 24', 'red', '2');
insert into Card (id, content, color, projectId)
values ('25', 'Card 25', 'blue', '2');
insert into Card (id, content, color, projectId)
values ('26', 'Card 26', 'green', '2');
insert into Card (id, content, color, projectId)
values ('27', 'Card 27', 'yellow', '2');
insert into Card (id, content, color, projectId)
values ('28', 'Card 28', 'red', '2');
insert into Card (id, content, color, projectId)
values ('29', 'Card 29', 'blue', '2');
insert into Card (id, content, color, projectId)
values ('30', 'Card 30', 'green', '2');