-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathcreate_database.sql
91 lines (85 loc) · 3.93 KB
/
create_database.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
83
84
85
86
87
88
89
90
91
drop table if exists "document_sets";
create table if not exists "document_sets" (
"id" integer not null,
"name" varchar(128) not null,
"description" varchar(256));
insert into document_sets ("id", "name", "description")
values (1, "default", "Default document set when none is specified");
insert into document_sets ("id", "name", "description")
values (2, "gcpd", "Gotham City Police Department");
/* Documents */
drop table if exists "documents";
create table if not exists "documents" (
"set_id" integer not null,
"document_name" varchar(256) not null,
"path" varchar(256) not null);
/* Default documents */
insert into documents ("set_id", "document_name", "path")
values (1, "Test document one", "dir1/doc1.txt");
insert into documents ("set_id", "document_name", "path")
values (1, "Test document two", "dir1/doc2.txt");
/* Gotham City Police Department documents */
insert into documents ("set_id", "document_name", "path")
values (2, "GCPD document one", "gcpd/doc1.txt");
insert into documents ("set_id", "document_name", "path")
values (2, "GCPD document two", "gcpd/doc2.txt");
/* Substitutions */
drop table if exists "substitutions";
create table if not exists "substitutions" (
"set_id" integer not null,
"key" varchar(128) not null,
"value" varchar(128) not null);
/* Default substitutions */
insert into substitutions ("set_id", "key", "value")
values (1, "bullet1", "Custom bullet point one");
insert into substitutions ("set_id", "key", "value")
values (1, "bullet2", "Custom bullet point two");
insert into substitutions ("set_id", "key", "value")
values (1, "bullet3", "Custom bullet point three");
insert into substitutions ("set_id", "key", "value")
values (1, "client name", "Mom and Pop Stores");
insert into substitutions ("set_id", "key", "value")
values (1, "copyright notice", "Copyright © 2017");
insert into substitutions ("set_id", "key", "value")
values (1, "tlt", "Transformation Leadership Team");
insert into substitutions ("set_id", "key", "value")
values (1, "ivt", "Innovation and Verification Team");
insert into substitutions ("set_id", "key", "value")
values (1, "value stream", "Line of Business");
insert into substitutions ("set_id", "key", "value")
values (1, "portfolio team", "Portfolio Team");
insert into substitutions ("set_id", "key", "value")
values (1, "program team", "Program Team");
insert into substitutions ("set_id", "key", "value")
values (1, "delivery team", "Delivery Team");
insert into substitutions ("set_id", "key", "value")
values (1, "iteration", "Sprint");
insert into substitutions ("set_id", "key", "value")
values (1, "product owner", "Product Owner");
insert into substitutions ("set_id", "key", "value")
values (1, "foo", "amazing");
insert into substitutions ("set_id", "key", "value")
values (1, "bar", "dismal");
/* Gotham City Police Department */
insert into substitutions ("set_id", "key", "value")
values (2, "client name", "Gotham City Police Dept.");
insert into substitutions ("set_id", "key", "value")
values (2, "tlt", "Improvement Guidance Committee");
insert into substitutions ("set_id", "key", "value")
values (2, "ivt", "Architectural Guidance Committee");
insert into substitutions ("set_id", "key", "value")
values (2, "value stream", "Product Line");
insert into substitutions ("set_id", "key", "value")
values (2, "portfolio team", "Product Line Team");
insert into substitutions ("set_id", "key", "value")
values (2, "program team", "Coordination Team");
insert into substitutions ("set_id", "key", "value")
values (2, "delivery team", "Development Pod");
insert into substitutions ("set_id", "key", "value")
values (2, "iteration", "Development Cadence");
insert into substitutions ("set_id", "key", "value")
values (2, "product owner", "Capability Owner");
insert into substitutions ("set_id", "key", "value")
values (2, "foo", "Batman");
insert into substitutions ("set_id", "key", "value")
values (2, "bar", "Penguin");