-
Notifications
You must be signed in to change notification settings - Fork 0
/
povoar.sql
287 lines (271 loc) · 19.4 KB
/
povoar.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
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
PRAGMA foreign_keys = ON;
INSERT INTO Company (Cname, NIF, address) VALUES ('Modelo Continente Hipermercados, S.A.', 502011475, 'Rua João Mendonça, N 505, 4464-503 Senhora da Hora');
INSERT INTO Company (Cname, NIF, address) VALUES ('Lidl & Companhia', 503340855, 'Rua Pé de Mouro 18, 2710-297 Sintra');
INSERT INTO Company (Cname, NIF, address) VALUES ('Talkdesk Inc. Portugal , Unipessoal Lda', 514480343, 'Rua Tierno Galvan, Torre 3, 15º Piso - Campo de Ourique 1070-274 Lisboa');
INSERT INTO Company (Cname, NIF, address) VALUES ('Efacec Electric Mobility, S.A.', 510893376, 'Via de Francisco Sá Carneiro, AP 3078, 4471-907 Moreira da Maia');
INSERT INTO Company (Cname, NIF, address) VALUES ('Super Bock Group, SGPS, S.A.', 505195607, 'Via Norte, 4465-764 Leça do Balio');
INSERT INTO Language (Lname) VALUES ('Portuguese');
INSERT INTO Language (Lname) VALUES ('English');
INSERT INTO Language (Lname) VALUES ('French');
INSERT INTO Language (Lname) VALUES ('German');
INSERT INTO Language (Lname) VALUES ('Dutch');
INSERT INTO Language (Lname) VALUES ('Mandarin');
INSERT INTO Worker (Wname) VALUES ('João Andrade Amorim');
INSERT INTO Worker (Wname) VALUES ('Maria Santos Freitas');
INSERT INTO Worker (Wname) VALUES ('Alberto Lopes Pestana');
INSERT INTO Worker (Wname) VALUES ('Joaquim Rodrigues Cunhal');
INSERT INTO Worker (Wname) VALUES ('Inês Poiares Marques');
INSERT INTO Worker (Wname) VALUES ('Marta Castro Lago');
INSERT INTO Worker (Wname) VALUES ('Sónia Pereira Simões');
INSERT INTO Worker (Wname) VALUES ('Clara Vale Santana');
INSERT INTO Worker (Wname) VALUES ('Liliana Pires Ramada');
INSERT INTO Worker (Wname) VALUES ('André Daniel Gomes');
INSERT INTO Worker (Wname) VALUES ('Luís Filipe Recharte');
INSERT INTO Worker (Wname) VALUES ('António Cadilha Bezerra');
INSERT INTO CompanyRole (CRname) VALUES ('Manager');
INSERT INTO CompanyRole (CRname) VALUES ('Engineer');
INSERT INTO CompanyRole (CRname) VALUES ('Accountant');
INSERT INTO CompanyRole (CRname) VALUES ('Financial Analyst');
INSERT INTO CompanyRole (CRname) VALUES ('Lawyer');
INSERT INTO CompanyRole (CRname) VALUES ('Data Analyst');
INSERT INTO CompanyRole (CRname) VALUES ('Graphic Designer');
INSERT INTO CompanyRole (CRname) VALUES ('Marketing Specialist');
INSERT INTO ProjectRole (PRname) VALUES ('Collaborator');
INSERT INTO ProjectRole (PRname) VALUES ('Adviser');
INSERT INTO ProjectRole (PRname) VALUES ('Reviewer');
INSERT INTO Belongs VALUES (1, 7);
INSERT INTO Belongs VALUES (2, 5);
INSERT INTO Belongs VALUES (3, 3);
INSERT INTO Belongs VALUES (4, 6);
INSERT INTO Belongs VALUES (5, 8);
INSERT INTO Belongs VALUES (6, 4);
INSERT INTO Belongs VALUES (7, 6);
INSERT INTO Belongs VALUES (8, 3);
INSERT INTO Belongs VALUES (9, 2);
INSERT INTO Belongs VALUES (10, 1);
INSERT INTO Belongs VALUES (10, 2);
INSERT INTO Belongs VALUES (11, 2);
INSERT INTO Belongs VALUES (12, 2);
INSERT INTO Type (Tname, status, remarks) VALUES ('Financial Evaluation', 1, 'Financial report determining overall financial health and stability.');
INSERT INTO Type (Tname, status, remarks) VALUES ('Technical Mockup', 1, 'Technical mockup of a product or component by specefication.');
INSERT INTO Type (Tname, status, remarks, last_mod_date) VALUES ('Tax Evasion Aid', 0, 'Legal advice on how to defraud the state of tax-income for maximum profit.', '2020-3-18');
INSERT INTO Type (Tname, status, remarks) VALUES ('Market Study', 1, 'Data analysis insight on market performance of a product.');
INSERT INTO Type (Tname, status, remarks) VALUES ('Digital Image Design', 1, 'Personalized branding and digital imagery for your brand.');
INSERT INTO Modified VALUES (3, 10);
INSERT INTO Status (sDescription) VALUES ('On-going');
INSERT INTO Status (sDescription) VALUES ('Complete');
INSERT INTO Status (sDescription) VALUES ('Delayed');
INSERT INTO Status (sDescription) VALUES ('In review');
INSERT INTO Status (sDescription) VALUES ('Pending');
INSERT INTO DocAttribute (DAname, DAvalue) VALUES ('Under NDA', 'All work developed under this document is under a Non-Disclosure Agreement.');
INSERT INTO DocAttribute (DAname, DAvalue) VALUES ('Time Critical', 'Document is time critical, delays should be avoided at all costs');
INSERT INTO RevisionAttribute (RAname, RAvalue) VALUES ('Initial', 'Initial revision');
INSERT INTO RevisionAttribute (RAname, RAvalue) VALUES ('Final', 'Final revision');
INSERT INTO RevisionAttribute (RAname, RAvalue) VALUES ('WIP', 'Work in progress revision, better not change if not the author');
INSERT INTO RevisionAttribute (RAname, RAvalue) VALUES ('Stable', 'Stable revision, may change');
INSERT INTO Document (dNAME, date_ini, date_fin, type, ownerID) VALUES ('Market Study Continente Online', '2019-10-10', '2019-12-5', 4, 9);
INSERT INTO Request (docID, CID, SID, propose_date) VALUES (1, 1, 2, '2019-10-10');
INSERT INTO File (docID, Fname, size, extension) VALUES (1, '/files/MCH/Market_S_Continente_Online/brief.txt', 18000, 'txt');
INSERT INTO File (docID, Fname, size, extension) VALUES (1, '/files/MCH/Market_S_Continente_Online/data_collection.xml', 27854446, 'xml');
INSERT INTO File (docID, Fname, size, extension) VALUES (1, '/files/MCH/Market_S_Continente_Online/report_pt.pdf', 35466, 'pdf');
INSERT INTO File (docID, Fname, size, extension) VALUES (1, '/files/MCH/Market_S_Continente_Online/report_eng.pdf', 35466, 'pdf');
INSERT INTO File (docID, Fname, size, extension) VALUES (1, '/files/MCH/Market_S_Continente_Online/analyse.py', 17560, 'py');
INSERT INTO File (docID, Fname, size, extension) VALUES (1, '/files/MCH/Market_S_Continente_Online/analyse_out.csv', 275655, 'csv');
INSERT INTO Stated VALUES (2, 1);
INSERT INTO Stated VALUES (1, 1);
INSERT INTO DocumentRoleWorker VALUES (1, 4, 1);
INSERT INTO DocumentRoleWorker VALUES (1, 9, 1);
INSERT INTO DocumentRoleWorker VALUES (1, 5, 2);
INSERT INTO DocumentRoleWorker VALUES (1, 7, 3);
INSERT INTO DocumentRoleWorker VALUES (1, 10, 3);
INSERT INTO Revision (docID, authorID, version, date) VALUES (1, 9, 'Initial revision', '2019-10-10');
INSERT INTO RevPossesses VALUES (1, 1);
INSERT INTO CheckOut VALUES (1, 9, '2019-10-11');
INSERT INTO Revision (docID, authorID, version, date) VALUES (1, 9, 'Added brief', '2019-10-11');
INSERT INTO RevPossesses VALUES (4, 2);
INSERT INTO CheckOut VALUES (2, 4, '2019-10-11');
INSERT INTO Revision (docID, authorID, version, date) VALUES (1, 4, 'Started data mining', '2019-10-12');
INSERT INTO RevPossesses VALUES (3, 3);
INSERT INTO CheckOut VALUES (3, 9, '2019-10-12');
INSERT INTO Revision (docID, authorID, version, date) VALUES (1, 9, 'Started scripting', '2019-10-13');
INSERT INTO RevPossesses VALUES (3, 4);
INSERT INTO CheckOut VALUES (4, 4, '2019-10-11');
INSERT INTO Revision (docID, authorID, version, date) VALUES (1, 4, 'Finished data mining', '2019-10-18');
INSERT INTO RevPossesses VALUES (4, 5);
INSERT INTO CheckOut VALUES (5, 9, '2019-10-20');
INSERT INTO Revision (docID, authorID, version, date) VALUES (1, 9, 'Finished scripting. Results extracted', '2019-10-25');
INSERT INTO RevPossesses VALUES (4, 6);
INSERT INTO CheckOut VALUES (6, 5, '2019-11-10');
INSERT INTO Revision (docID, authorID, version, date) VALUES (1, 5, 'Marketing insight added', '2019-11-14');
INSERT INTO RevPossesses VALUES (4, 7);
INSERT INTO CheckOut VALUES (7, 9, '2019-11-11');
INSERT INTO Revision (docID, authorID, version, date) VALUES (1, 9, 'Report written.', '2019-11-21');
INSERT INTO RevPossesses VALUES (4, 8);
INSERT INTO CheckOut VALUES (8, 7, '2019-11-27');
INSERT INTO Revision (docID, authorID, version, date) VALUES (1, 7, 'Review done. Final', '2019-12-4');
INSERT INTO RevPossesses VALUES (2, 9);
INSERT INTO Document (dNAME, date_ini, date_fin, type, ownerID) VALUES ('Talkdesk Financial Evaluation', '2020-2-17', '2020-3-17', 1, 10);
INSERT INTO Request (docID, CID, SID, propose_date) VALUES (2, 3, 2, '2020-2-17');
INSERT INTO File (docID, Fname, size, extension) VALUES (2, '/files/Talkdesk/Fin_Eval_Talkdesk/brief.txt', 18000, 'txt');
INSERT INTO File (docID, Fname, size, extension) VALUES (2, '/files/Talkdesk/Fin_Eval_Talkdesk/financial_results.xlsx', 3689547, 'xlsx');
INSERT INTO File (docID, Fname, size, extension) VALUES (2, '/files/Talkdesk/Fin_Eval_Talkdesk/bank_statements.xml', 547989, 'xml');
INSERT INTO File (docID, Fname, size, extension) VALUES (2, '/files/Talkdesk/Fin_Eval_Talkdesk/report.pdf', 38466, 'pdf');
INSERT INTO File (docID, Fname, size, extension) VALUES (2, '/files/Talkdesk/Fin_Eval_Talkdesk/analyse.py', 17560, 'py');
INSERT INTO File (docID, Fname, size, extension) VALUES (2, '/files/Talkdesk/Fin_Eval_Talkdesk/analyse_out.csv', 279675, 'csv');
INSERT INTO Stated VALUES (2, 2);
INSERT INTO Stated VALUES (1, 2);
INSERT INTO DocumentRoleWorker VALUES (2, 10, 1);
INSERT INTO DocumentRoleWorker VALUES (2, 6, 1);
INSERT INTO DocumentRoleWorker VALUES (2, 2, 2);
INSERT INTO DocumentRoleWorker VALUES (2, 2, 3);
INSERT INTO DocumentRoleWorker VALUES (2, 7, 1);
INSERT INTO DocPossesses VALUES (1, 2);
INSERT INTO Revision (docID, authorID, version, date) VALUES (2, 10, 'Initial revision', '2020-2-17');
INSERT INTO RevPossesses VALUES (1, 10);
INSERT INTO CheckOut VALUES (10, 9, '2020-2-17');
INSERT INTO Revision (docID, authorID, version, date) VALUES (2, 10, 'Added brief', '2020-2-17');
INSERT INTO RevPossesses VALUES (4, 11);
INSERT INTO CheckOut VALUES (11, 6, '2020-2-18');
INSERT INTO Revision (docID, authorID, version, date) VALUES (2, 6, 'Started analysing financials', '2020-2-22');
INSERT INTO RevPossesses VALUES (3, 12);
INSERT INTO CheckOut VALUES (12, 10, '2020-2-23');
INSERT INTO Revision (docID, authorID, version, date) VALUES (2, 10, 'Started scripting', '2020-2-27');
INSERT INTO RevPossesses VALUES (3, 13);
INSERT INTO CheckOut VALUES (13, 6, '2020-2-27');
INSERT INTO Revision (docID, authorID, version, date) VALUES (2, 6, 'Finished finantial analysis', '2020-3-5');
INSERT INTO RevPossesses VALUES (4, 14);
INSERT INTO CheckOut VALUES (14, 10, '2020-3-6');
INSERT INTO Revision (docID, authorID, version, date) VALUES (2, 10, 'Finished scripting. Results extracted', '2020-3-10');
INSERT INTO RevPossesses VALUES (4, 15);
INSERT INTO CheckOut VALUES (15, 2, '2020-3-10');
INSERT INTO Revision (docID, authorID, version, date) VALUES (2, 2, 'Legal insight added', '2020-3-12');
INSERT INTO RevPossesses VALUES (4, 16);
INSERT INTO CheckOut VALUES (16, 10, '2020-3-12');
INSERT INTO Revision (docID, authorID, version, date) VALUES (2, 10, 'Report written.', '2020-3-15');
INSERT INTO RevPossesses VALUES (4, 17);
INSERT INTO CheckOut VALUES (17, 2, '2020-3-15');
INSERT INTO Revision (docID, authorID, version, date) VALUES (2, 2, 'Review done. Final', '2020-3-17');
INSERT INTO RevPossesses VALUES (2, 18);
INSERT INTO Document (dNAME, date_ini, date_fin, type, ownerID) VALUES ('SB Group New Bottling Line', '2020-3-1', '2020-4-31', 2, 11);
INSERT INTO Request (docID, CID, SID, propose_date) VALUES (3, 5, 1, '2020-3-1');
INSERT INTO File (docID, Fname, size, extension) VALUES (3, '/files/SBG/Tech_Mock_SBG_BottlingLine/brief.txt', 18000, 'txt');
INSERT INTO File (docID, Fname, size, extension) VALUES (3, '/files/SBG/Tech_Mock_SBG_BottlingLine/prod_line_model.cad', 54786954, 'cad');
INSERT INTO File (docID, Fname, size, extension) VALUES (3, '/files/SBG/Tech_Mock_SBG_BottlingLine/prod_line_module1.cad', 65478, 'cad');
INSERT INTO File (docID, Fname, size, extension) VALUES (3, '/files/SBG/Tech_Mock_SBG_BottlingLine/prod_line_module2.cad', 326574, 'cad');
INSERT INTO File (docID, Fname, size, extension) VALUES (3, '/files/SBG/Tech_Mock_SBG_BottlingLine/prod_line_module3.cad', 78795, 'cad');
INSERT INTO File (docID, Fname, size, extension) VALUES (3, '/files/SBG/Tech_Mock_SBG_BottlingLine/report_pt.pdf', 38476, 'pdf');
INSERT INTO File (docID, Fname, size, extension) VALUES (3, '/files/SBG/Tech_Mock_SBG_BottlingLine/highlights_mandarin.pdf', 38476, 'pdf');
INSERT INTO File (docID, Fname, size, extension) VALUES (3, '/files/SBG/Tech_Mock_SBG_BottlingLine/production_projections.xlsx', 19664, 'xlsx');
INSERT INTO Stated VALUES (6, 3);
INSERT INTO Stated VALUES (1, 3);
INSERT INTO DocumentRoleWorker VALUES (3, 1, 1);
INSERT INTO DocumentRoleWorker VALUES (3, 11, 1);
INSERT INTO DocumentRoleWorker VALUES (3, 10, 3);
INSERT INTO DocumentRoleWorker VALUES (3, 9, 1);
INSERT INTO DocumentRoleWorker VALUES (3, 12, 1);
INSERT INTO DocPossesses VALUES (1, 3);
INSERT INTO DocPossesses VALUES (2, 3);
INSERT INTO Revision (docID, authorID, version, date) VALUES (3, 11, 'Initial revision', '2020-3-1');
INSERT INTO RevPossesses VALUES (1, 19);
INSERT INTO CheckOut VALUES (19, 10, '2020-3-1');
INSERT INTO Revision (docID, authorID, version, date) VALUES (3, 10, 'Added brief', '2020-3-1');
INSERT INTO RevPossesses VALUES (4, 20);
INSERT INTO CheckOut VALUES (20, 9, '2020-3-2');
INSERT INTO Revision (docID, authorID, version, date) VALUES (3, 9, 'Started drawing modules', '2020-3-10');
INSERT INTO RevPossesses VALUES (3, 21);
INSERT INTO CheckOut VALUES (21, 11, '2020-3-11');
INSERT INTO Revision (docID, authorID, version, date) VALUES (3, 11, 'Started modelling work', '2020-3-22');
INSERT INTO RevPossesses VALUES (3, 22);
INSERT INTO CheckOut VALUES (22, 12, '2020-3-22');
INSERT INTO Revision (docID, authorID, version, date) VALUES (3, 12, 'Finished modules composition', '2020-4-5');
INSERT INTO RevPossesses VALUES (4, 23);
INSERT INTO CheckOut VALUES (23, 11, '2020-4-6');
INSERT INTO Revision (docID, authorID, version, date) VALUES (3, 11, 'Finished modelling', '2020-4-10');
INSERT INTO RevPossesses VALUES (4, 24);
INSERT INTO CheckOut VALUES (24, 1, '2020-4-10');
INSERT INTO Revision (docID, authorID, version, date) VALUES (3, 1, 'Added graphic details', '2020-4-17');
INSERT INTO RevPossesses VALUES (4, 25);
INSERT INTO CheckOut VALUES (25, 11, '2020-4-18');
INSERT INTO Revision (docID, authorID, version, date) VALUES (3, 11, 'Report written.', '2020-4-20');
INSERT INTO RevPossesses VALUES (4, 26);
INSERT INTO CheckOut VALUES (26, 10, '2020-4-21');
INSERT INTO Revision (docID, authorID, version, date) VALUES (3, 10, 'Review done. Final', '2020-4-30');
INSERT INTO RevPossesses VALUES (2, 27);
INSERT INTO Document (dNAME, date_ini, date_fin, type, ownerID) VALUES ('Lidl Fraud Assistance', '2019-11-1', '2019-12-5', 3, 3);
INSERT INTO Request (docID, CID, SID, propose_date) VALUES (4, 2, 2, '2020-3-1');
INSERT INTO File (docID, Fname, size, extension) VALUES (4, '/files/Lidl/Tax_Fraud_LIDL_2019/brief.txt', 18000, 'txt');
INSERT INTO File (docID, Fname, size, extension) VALUES (4, '/files/Lidl/Tax_Fraud_LIDL_2019/legal_notes.docx', 32564, 'docx');
INSERT INTO File (docID, Fname, size, extension) VALUES (4, '/files/Lidl/Tax_Fraud_LIDL_2019/regulamento_fiscal_atual.docx', 65478, 'docx');
INSERT INTO File (docID, Fname, size, extension) VALUES (4, '/files/Lidl/Tax_Fraud_LIDL_2019/scenarios.pptx', 513266, 'pptx');
INSERT INTO File (docID, Fname, size, extension) VALUES (4, '/files/Lidl/Tax_Fraud_LIDL_2019/report_sum_ger.pdf', 16547, 'pdf');
INSERT INTO File (docID, Fname, size, extension) VALUES (4, '/files/Lidl/Tax_Fraud_LIDL_2019/report_pt.pdf', 38476, 'pdf');
INSERT INTO Stated VALUES (4, 4);
INSERT INTO Stated VALUES (1, 4);
INSERT INTO DocumentRoleWorker VALUES (4, 3, 1);
INSERT INTO DocumentRoleWorker VALUES (4, 8, 1);
INSERT INTO DocumentRoleWorker VALUES (4, 6, 1);
INSERT INTO DocumentRoleWorker VALUES (4, 2, 1);
INSERT INTO DocumentRoleWorker VALUES (4, 10, 3);
INSERT INTO DocPossesses VALUES (1, 4);
INSERT INTO Revision (docID, authorID, version, date) VALUES (4, 3, 'Initial revision', '2019-11-1');
INSERT INTO RevPossesses VALUES (1, 28);
INSERT INTO CheckOut VALUES (28, 9, '2019-11-1');
INSERT INTO Revision (docID, authorID, version, date) VALUES (4, 3, 'Added brief', '2019-11-1');
INSERT INTO RevPossesses VALUES (4, 29);
INSERT INTO CheckOut VALUES (29, 2, '2019-11-2');
INSERT INTO Revision (docID, authorID, version, date) VALUES (4, 2, 'Started legal analysis', '2019-11-10');
INSERT INTO RevPossesses VALUES (3, 30);
INSERT INTO CheckOut VALUES (30, 8, '2019-11-10');
INSERT INTO Revision (docID, authorID, version, date) VALUES (4, 8, 'Started analysing accounting', '2019-11-15');
INSERT INTO RevPossesses VALUES (3, 31);
INSERT INTO CheckOut VALUES (31, 2, '2019-11-15');
INSERT INTO Revision (docID, authorID, version, date) VALUES (4, 2, 'Finished legal', '2019-11-18');
INSERT INTO RevPossesses VALUES (4, 32);
INSERT INTO CheckOut VALUES (32, 3, '2019-11-18');
INSERT INTO Revision (docID, authorID, version, date) VALUES (4, 3, 'Finished accounting', '2019-11-18');
INSERT INTO RevPossesses VALUES (4, 33);
INSERT INTO CheckOut VALUES (33, 6, '2019-11-18');
INSERT INTO Revision (docID, authorID, version, date) VALUES (4, 6, 'Scenarios drawn and annotated', '2019-11-23');
INSERT INTO RevPossesses VALUES (4, 34);
INSERT INTO CheckOut VALUES (34, 3, '2019-11-23');
INSERT INTO Revision (docID, authorID, version, date) VALUES (4, 3, 'Report written.', '2019-11-29');
INSERT INTO RevPossesses VALUES (4, 35);
INSERT INTO CheckOut VALUES (35, 10, '2019-11-27');
INSERT INTO Revision (docID, authorID, version, date) VALUES (4, 10, 'Review done. Final', '2019-12-4');
INSERT INTO RevPossesses VALUES (2, 36);
INSERT INTO Document (dNAME, date_ini, date_fin, type, ownerID) VALUES ('Efacec Rebranding', '2020-3-14', '2020-4-10', 5, 1);
INSERT INTO Request (docID, CID, SID, propose_date) VALUES (5, 4, 4, '2020-3-14');
INSERT INTO File (docID, Fname, size, extension) VALUES (5, '/files/Efacec/DID_Efacec_2020_Rebrand/brief.txt', 18000, 'txt');
INSERT INTO File (docID, Fname, size, extension) VALUES (5, '/files/Efacec/DID_Efacec_2020_Rebrand/logo.svg', 25895, 'svg');
INSERT INTO File (docID, Fname, size, extension) VALUES (5, '/files/Efacec/DID_Efacec_2020_Rebrand/banner.svg', 65478, 'svg');
INSERT INTO File (docID, Fname, size, extension) VALUES (5, '/files/Efacec/DID_Efacec_2020_Rebrand/rollup.svg', 53266, 'svg');
INSERT INTO File (docID, Fname, size, extension) VALUES (5, '/files/Efacec/DID_Efacec_2020_Rebrand/digital_ad.js', 16547, 'js');
INSERT INTO Stated VALUES (1, 5);
INSERT INTO DocumentRoleWorker VALUES (5, 1, 1);
INSERT INTO DocumentRoleWorker VALUES (5, 5, 1);
INSERT INTO DocumentRoleWorker VALUES (5, 11, 3);
INSERT INTO DocumentRoleWorker VALUES (5, 10, 3);
INSERT INTO Revision (docID, authorID, version, date) VALUES (5, 1, 'Initial revision', '2020-3-14');
INSERT INTO RevPossesses VALUES (1, 37);
INSERT INTO CheckOut VALUES (37, 1, '2020-3-15');
INSERT INTO Revision (docID, authorID, version, date) VALUES (5, 1, 'Added brief', '2020-3-15');
INSERT INTO RevPossesses VALUES (4, 38);
INSERT INTO CheckOut VALUES (38, 1, '2020-3-15');
INSERT INTO Revision (docID, authorID, version, date) VALUES (5, 1, 'Logo design added', '2020-3-19');
INSERT INTO RevPossesses VALUES (4, 39);
INSERT INTO CheckOut VALUES (39, 1, '2020-3-20');
INSERT INTO Revision (docID, authorID, version, date) VALUES (5, 1, 'Banner design added', '2020-3-23');
INSERT INTO RevPossesses VALUES (4, 40);
INSERT INTO CheckOut VALUES (40, 1, '2020-3-23');
INSERT INTO Revision (docID, authorID, version, date) VALUES (5, 1, 'Rollup design added', '2020-3-25');
INSERT INTO RevPossesses VALUES (4, 41);
INSERT INTO CheckOut VALUES (41, 5, '2020-3-26');
INSERT INTO Revision (docID, authorID, version, date) VALUES (5, 5, 'Digital ad started', '2020-3-28');
INSERT INTO RevPossesses VALUES (4, 42);
INSERT INTO CheckOut VALUES (42, 5, '2020-3-29');
INSERT INTO Revision (docID, authorID, version, date) VALUES (5, 5, 'Digital ad finished', '2020-4-1');
INSERT INTO RevPossesses VALUES (4, 43);
INSERT INTO CheckOut VALUES (43, 1, '2020-4-1');
INSERT INTO Revision (docID, authorID, version, date) VALUES (5, 1, 'Minor ad touch-ups', '2020-4-2');
INSERT INTO RevPossesses VALUES (4, 44);
INSERT INTO CheckOut VALUES (44, 11, '2020-4-2');