-
Notifications
You must be signed in to change notification settings - Fork 19
/
0032.sql
611 lines (582 loc) · 54.3 KB
/
0032.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
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
-- Dec 10, 2015
-- Add new questions to the human survey
----------------------------------------------------------
-- survey_question
----------------------------------------------------------
INSERT INTO survey_question (survey_question_id, question_shortname, american, british) VALUES
(148, 'country_residence', 'Country of residence:', 'Country of residence:'),
(149, 'pets_other', 'Do you have any other pet(s)?', 'Do you have any other pet(s)?'),
(150, 'pets_other_freetext', 'Please list pets', 'Please list pets'),
(153, 'mental_illness', 'Have you ever been diagnosed mental health illness?', 'Have you ever been diagnosed mental health illness?'),
(154, 'mental_illness_type', 'Please select which disorder(s) from the following list:', 'Please select which disorder(s) from the following list:'),
(155, 'diabetes_type', 'which type of diabetes?', 'which type of diabetes?'),
(156, 'vivid_dreams', 'Do you have vivid and/or frightening dreams?', 'Do you have vivid and/or frightening dreams?'),
(157, 'artificial_sweeteners', 'Consume diet beverages with artificial sweeteners?', 'Consume diet beverages with artificial sweeteners?'),
(158, 'cancer', 'Have you ever been diagnosed with cancer?', 'Have you ever been diagnosed with cancer?'),
(159, 'cancer_treatment', 'If you have been diagnosed with cancer, how was it treated?', 'If you have been diagnosed with cancer, how was it treated?'),
(160, 'acid_reflux', 'Have you ever been diagnosed with acid reflux or GERD (gastro-esophageal reflux disease)?', 'Have you ever been diagnosed with acid reflux or GERD (gastro-esophageal reflux disease)?');
--Retire question 97 (Old mental health question specific to depression, etc) and 52 (willing to be contacted)
UPDATE survey_question SET retired = true WHERE survey_question_id IN (97, 52);
--Update questions that need rewording
UPDATE survey_question SET
american = 'Describe the quality of your bowel movements. Use the chart below as a reference:<br/><img src="/static/img/bristol_stool.jpg">',
british = 'Describe the quality of your bowel movements. Use the chart below as a reference:<br/><img src="/static/img/bristol_stool.jpg">'
WHERE survey_question_id = 38;
UPDATE survey_question SET
american = 'Have you ever been diagnosed with Asthma, Cystic fibrosis, or COPD (chronic obstructive pulmonary disease?',
british = 'Have you ever been diagnosed with Asthma, Cystic fibrosis, or COPD (chronic obstructive pulmonary disease?'
WHERE survey_question_id = 93;
UPDATE survey_question SET
american = 'Have you been diagnosed with autoimmune disease such as Lupus (systemic lupus erythematosus), R.A. (rheumatoid arthritis), MS (multiple sclerosis), Hashimoto''s thyroiditis, or any other auto-immune disease?',
british = 'Have you been diagnosed with autoimmune disease such as Lupus (systemic lupus erythematosus), R.A. (rheumatoid arthritis), MS (multiple sclerosis), Hashimoto''s thyroiditis, or any other auto-immune disease?'
WHERE survey_question_id = 87;
UPDATE survey_question SET
american = 'Have you ever been diagnosed with coronary artery disease, heart disease, or suffered a heart attack and/or stroke?',
british = 'Have you ever been diagnosed with coronary artery disease, heart disease, or suffered a heart attack and/or stroke?'
WHERE survey_question_id = 89;
UPDATE survey_question SET
american = 'Have you ever been diagnosed with a skin condition?',
british = 'Have you ever been diagnosed with a skin condition?'
WHERE survey_question_id = 88;
UPDATE survey_question SET
american = 'In an average week, how often to you consume at least 2-3 servings of fruit in a day? (1 serving = 1/2 cup fruit; 1 medium sized fruit; 4 oz. 100% fruit juice.)',
british = 'In an average week, how often to you consume at least 2-3 servings of fruit in a day? (1 serving = 1/2 cup fruit; 1 medium sized fruit; 4 oz. 100% fruit juice.)'
WHERE survey_question_id = 61;
UPDATE survey_question SET
american = '8. In an average week, how often do you consume at least 2-3 servings of vegetables, including potatoes in a day? (1 serving = 1/2 cup vegetables/potatoes; 1 cup leafy raw vegetables)',
british = '8. In an average week, how often do you consume at least 2-3 servings of vegetables, including potatoes in a day? (1 serving = 1/2 cup vegetables/potatoes; 1 cup leafy raw vegetables)'
WHERE survey_question_id = 62;
UPDATE survey_question SET
american = 'How often do you consume one or more servings of fermented vegetables in or plant products a day in an average week? (1 serving = 1/2 cup sauerkraut, kimchi or fermented vegetable or 1 cup of kombucha)',
british = 'How often do you consume one or more servings of fermented vegetables in or plant products a day in an average week? (1 serving = 1/2 cup sauerkraut, kimchi or fermented vegetable or 1 cup of kombucha)'
WHERE survey_question_id = 63;
UPDATE survey_question SET
american = 'In an average week, how often do you consume at least 2 servings of milk or cheese a day? (1 serving = 1 cup milk or yogurt; 1 1/2 - 2 ounces cheese)',
british = 'In an average week, how often do you consume at least 2 servings of milk or cheese a day? (1 serving = 1 cup milk or yogurt; 1 1/2 - 2 ounces cheese)'
WHERE survey_question_id = 64;
UPDATE survey_question SET
american = 'How many days in an average week do you consume poultry (chicken, turkey, etc.) at least once a day?',
british = 'How many days in an average week do you consume poultry (chicken, turkey, etc.) at least once a day?'
WHERE survey_question_id = 69;
UPDATE survey_question SET
american = 'How many days in average week do you cook with olive oil (including salad dressing)?',
british = 'How many days in average week do you cook with olive oil (including salad dressing)?'
WHERE survey_question_id = 73;
UPDATE survey_question SET
american = 'Drink 16 ounces or more of a sugar sweetened beverage such as non-diet soda or fruit drink/punch (however, not including 100 % fruit juice) in a day? (1 can of soda = 12 ounces)',
british = 'Drink 16 ounces or more of a sugar sweetened beverage such as non-diet soda or fruit drink/punch (however, not including 100 % fruit juice) in a day? (1 can of soda = 12 ounces)'
WHERE survey_question_id = 75;
--Bring back and update wording on plants question
UPDATE survey_question SET
american = 'In an average week, how many different plant species do you eat? e.g. If you consume a can of soup that contains carrots, potatoes, and onion, you can count this as 3 different plants; If you consume multi-grain bread, each different grain counts as a plant.',
british = 'In an average week, how many different plant species do you eat? e.g. If you consume a can of soup that contains carrots, potatoes, and onion, you can count this as 3 different plants; If you consume multi-grain bread, each different grain counts as a plant.',
retired = false
WHERE survey_question_id = 146;
----------------------------------------------------------
-- group_questions
----------------------------------------------------------
--Reorder every question on the survey
ALTER TABLE group_questions DROP CONSTRAINT idx_group_questions;
UPDATE group_questions SET survey_group = -1, display_index = 0 WHERE survey_question_id = 107;
UPDATE group_questions SET survey_group = -1, display_index = 1 WHERE survey_question_id = 108;
UPDATE group_questions SET survey_group = -1, display_index = 2 WHERE survey_question_id = 109;
UPDATE group_questions SET survey_group = -1, display_index = 3 WHERE survey_question_id = 110;
INSERT INTO group_questions (survey_group, display_index, survey_question_id) VALUES (-1, 4, 148);
UPDATE group_questions SET survey_group = -1, display_index = 5 WHERE survey_question_id = 111;
UPDATE group_questions SET survey_group = -1, display_index = 6 WHERE survey_question_id = 112;
UPDATE group_questions SET survey_group = -1, display_index = 7 WHERE survey_question_id = 113;
UPDATE group_questions SET survey_group = -1, display_index = 8 WHERE survey_question_id = 114;
UPDATE group_questions SET survey_group = -1, display_index = 9 WHERE survey_question_id = 115;
UPDATE group_questions SET survey_group = 0, display_index = 0 WHERE survey_question_id = 1;
UPDATE group_questions SET survey_group = 0, display_index = 1 WHERE survey_question_id = 2;
UPDATE group_questions SET survey_group = 0, display_index = 2 WHERE survey_question_id = 3;
UPDATE group_questions SET survey_group = 0, display_index = 3 WHERE survey_question_id = 4;
UPDATE group_questions SET survey_group = 0, display_index = 4 WHERE survey_question_id = 5;
UPDATE group_questions SET survey_group = 0, display_index = 5 WHERE survey_question_id = 6;
UPDATE group_questions SET survey_group = 0, display_index = 6 WHERE survey_question_id = 104;
UPDATE group_questions SET survey_group = 0, display_index = 7 WHERE survey_question_id = 10;
UPDATE group_questions SET survey_group = 0, display_index = 8 WHERE survey_question_id = 11;
UPDATE group_questions SET survey_group = 0, display_index = 9 WHERE survey_question_id = 12;
UPDATE group_questions SET survey_group = 0, display_index = 10 WHERE survey_question_id = 118;
UPDATE group_questions SET survey_group = 0, display_index = 11 WHERE survey_question_id = 13;
UPDATE group_questions SET survey_group = 1, display_index = 0 WHERE survey_question_id = 14;
UPDATE group_questions SET survey_group = 1, display_index = 1 WHERE survey_question_id = 103;
UPDATE group_questions SET survey_group = 1, display_index = 2 WHERE survey_question_id = 15;
UPDATE group_questions SET survey_group = 1, display_index = 3 WHERE survey_question_id = 16;
UPDATE group_questions SET survey_group = 1, display_index = 4 WHERE survey_question_id = 119;
UPDATE group_questions SET survey_group = 1, display_index = 5 WHERE survey_question_id = 17;
UPDATE group_questions SET survey_group = 1, display_index = 6 WHERE survey_question_id = 18;
UPDATE group_questions SET survey_group = 1, display_index = 7 WHERE survey_question_id = 19;
UPDATE group_questions SET survey_group = 1, display_index = 8 WHERE survey_question_id = 120;
UPDATE group_questions SET survey_group = 1, display_index = 9 WHERE survey_question_id = 20;
UPDATE group_questions SET survey_group = 1, display_index = 10 WHERE survey_question_id = 105;
UPDATE group_questions SET survey_group = 1, display_index = 11 WHERE survey_question_id = 101;
UPDATE group_questions SET survey_group = 1, display_index = 12 WHERE survey_question_id = 21;
UPDATE group_questions SET survey_group = 1, display_index = 13 WHERE survey_question_id = 122;
UPDATE group_questions SET survey_group = 1, display_index = 14 WHERE survey_question_id = 117;
INSERT INTO group_questions (survey_group, display_index, survey_question_id) VALUES (1, 15, 149);
INSERT INTO group_questions (survey_group, display_index, survey_question_id) VALUES (1, 16, 150);
UPDATE group_questions SET survey_group = 1, display_index = 17 WHERE survey_question_id = 22;
UPDATE group_questions SET survey_group = 1, display_index = 18 WHERE survey_question_id = 23;
UPDATE group_questions SET survey_group = 2, display_index = 0 WHERE survey_question_id = 24;
UPDATE group_questions SET survey_group = 2, display_index = 1 WHERE survey_question_id = 25;
UPDATE group_questions SET survey_group = 2, display_index = 2 WHERE survey_question_id = 26;
UPDATE group_questions SET survey_group = 2, display_index = 3 WHERE survey_question_id = 27;
UPDATE group_questions SET survey_group = 2, display_index = 4 WHERE survey_question_id = 28;
UPDATE group_questions SET survey_group = 2, display_index = 5 WHERE survey_question_id = 29;
UPDATE group_questions SET survey_group = 2, display_index = 6 WHERE survey_question_id = 30;
UPDATE group_questions SET survey_group = 2, display_index = 7 WHERE survey_question_id = 31;
UPDATE group_questions SET survey_group = 2, display_index = 8 WHERE survey_question_id = 32;
UPDATE group_questions SET survey_group = 2, display_index = 9 WHERE survey_question_id = 33;
UPDATE group_questions SET survey_group = 2, display_index = 10 WHERE survey_question_id = 34;
UPDATE group_questions SET survey_group = 2, display_index = 11 WHERE survey_question_id = 35;
UPDATE group_questions SET survey_group = 2, display_index = 12 WHERE survey_question_id = 36;
UPDATE group_questions SET survey_group = 3, display_index = -2 WHERE survey_question_id = 52;
UPDATE group_questions SET survey_group = 3, display_index = -1 WHERE survey_question_id = 97;
UPDATE group_questions SET survey_group = 3, display_index = 0 WHERE survey_question_id = 37;
UPDATE group_questions SET survey_group = 3, display_index = 1 WHERE survey_question_id = 38;
UPDATE group_questions SET survey_group = 3, display_index = 2 WHERE survey_question_id = 39;
UPDATE group_questions SET survey_group = 3, display_index = 3 WHERE survey_question_id = 40;
UPDATE group_questions SET survey_group = 3, display_index = 4 WHERE survey_question_id = 41;
UPDATE group_questions SET survey_group = 3, display_index = 5 WHERE survey_question_id = 42;
UPDATE group_questions SET survey_group = 3, display_index = 6 WHERE survey_question_id = 98;
UPDATE group_questions SET survey_group = 3, display_index = 7 WHERE survey_question_id = 43;
UPDATE group_questions SET survey_group = 3, display_index = 8 WHERE survey_question_id = 44;
UPDATE group_questions SET survey_group = 3, display_index = 9 WHERE survey_question_id = 45;
UPDATE group_questions SET survey_group = 3, display_index = 10 WHERE survey_question_id = 46;
UPDATE group_questions SET survey_group = 3, display_index = 11 WHERE survey_question_id = 47;
UPDATE group_questions SET survey_group = 3, display_index = 12 WHERE survey_question_id = 48;
UPDATE group_questions SET survey_group = 3, display_index = 13 WHERE survey_question_id = 49;
UPDATE group_questions SET survey_group = 3, display_index = 14 WHERE survey_question_id = 99;
UPDATE group_questions SET survey_group = 3, display_index = 15 WHERE survey_question_id = 50;
UPDATE group_questions SET survey_group = 3, display_index = 16 WHERE survey_question_id = 51;
UPDATE group_questions SET survey_group = 3, display_index = 17 WHERE survey_question_id = 85;
UPDATE group_questions SET survey_group = 3, display_index = 18 WHERE survey_question_id = 84;
UPDATE group_questions SET survey_group = 3, display_index = 19 WHERE survey_question_id = 93;
UPDATE group_questions SET survey_group = 3, display_index = 20 WHERE survey_question_id = 77;
UPDATE group_questions SET survey_group = 3, display_index = 21 WHERE survey_question_id = 87;
UPDATE group_questions SET survey_group = 3, display_index = 22 WHERE survey_question_id = 95;
UPDATE group_questions SET survey_group = 3, display_index = 23 WHERE survey_question_id = 80;
UPDATE group_questions SET survey_group = 3, display_index = 24 WHERE survey_question_id = 89;
INSERT INTO group_questions (survey_group, display_index, survey_question_id) VALUES (3, 26, 153);
INSERT INTO group_questions (survey_group, display_index, survey_question_id) VALUES (3, 27, 154);
UPDATE group_questions SET survey_group = 3, display_index = 28 WHERE survey_question_id = 82;
INSERT INTO group_questions (survey_group, display_index, survey_question_id) VALUES (3, 29, 155);
UPDATE group_questions SET survey_group = 3, display_index = 30 WHERE survey_question_id = 90;
UPDATE group_questions SET survey_group = 3, display_index = 31 WHERE survey_question_id = 83;
UPDATE group_questions SET survey_group = 3, display_index = 32 WHERE survey_question_id = 79;
UPDATE group_questions SET survey_group = 3, display_index = 33 WHERE survey_question_id = 92;
UPDATE group_questions SET survey_group = 3, display_index = 34 WHERE survey_question_id = 60;
UPDATE group_questions SET survey_group = 3, display_index = 35 WHERE survey_question_id = 86;
UPDATE group_questions SET survey_group = 3, display_index = 36 WHERE survey_question_id = 94;
UPDATE group_questions SET survey_group = 3, display_index = 37 WHERE survey_question_id = 78;
UPDATE group_questions SET survey_group = 3, display_index = 38 WHERE survey_question_id = 88;
UPDATE group_questions SET survey_group = 3, display_index = 39 WHERE survey_question_id = 96;
INSERT INTO group_questions (survey_group, display_index, survey_question_id) VALUES (3, 40, 158);
INSERT INTO group_questions (survey_group, display_index, survey_question_id) VALUES (3, 41, 159);
INSERT INTO group_questions (survey_group, display_index, survey_question_id) VALUES (3, 42, 160);
UPDATE group_questions SET survey_group = 3, display_index = 43 WHERE survey_question_id = 81;
UPDATE group_questions SET survey_group = 3, display_index = 44 WHERE survey_question_id = 106;
UPDATE group_questions SET survey_group = 3, display_index = 45 WHERE survey_question_id = 53;
UPDATE group_questions SET survey_group = 3, display_index = 46 WHERE survey_question_id = 54;
UPDATE group_questions SET survey_group = 3, display_index = 47 WHERE survey_question_id = 54;
UPDATE group_questions SET survey_group = 3, display_index = 48 WHERE survey_question_id = 7;
UPDATE group_questions SET survey_group = 3, display_index = 49 WHERE survey_question_id = 8;
UPDATE group_questions SET survey_group = 3, display_index = 50 WHERE survey_question_id = 9;
INSERT INTO group_questions (survey_group, display_index, survey_question_id) VALUES (3, 51, 156);
UPDATE group_questions SET survey_group = 4, display_index = 0 WHERE survey_question_id = 55;
UPDATE group_questions SET survey_group = 4, display_index = 1 WHERE survey_question_id = 56;
UPDATE group_questions SET survey_group = 4, display_index = 2 WHERE survey_question_id = 57;
UPDATE group_questions SET survey_group = 4, display_index = 3 WHERE survey_question_id = 58;
UPDATE group_questions SET survey_group = 4, display_index = 4 WHERE survey_question_id = 59;
UPDATE group_questions SET survey_group = 4, display_index = 5 WHERE survey_question_id = 91;
UPDATE group_questions SET survey_group = 4, display_index = 6 WHERE survey_question_id = 61;
UPDATE group_questions SET survey_group = 4, display_index = 7 WHERE survey_question_id = 62;
UPDATE group_questions SET survey_group = 4, display_index = 8 WHERE survey_question_id = 146;
UPDATE group_questions SET survey_group = 4, display_index = 9 WHERE survey_question_id = 63;
UPDATE group_questions SET survey_group = 4, display_index = 10 WHERE survey_question_id = 64;
UPDATE group_questions SET survey_group = 4, display_index = 11 WHERE survey_question_id = 65;
UPDATE group_questions SET survey_group = 4, display_index = 12 WHERE survey_question_id = 66;
UPDATE group_questions SET survey_group = 4, display_index = 13 WHERE survey_question_id = 67;
UPDATE group_questions SET survey_group = 4, display_index = 14 WHERE survey_question_id = 68;
UPDATE group_questions SET survey_group = 4, display_index = 15 WHERE survey_question_id = 69;
UPDATE group_questions SET survey_group = 4, display_index = 16 WHERE survey_question_id = 70;
UPDATE group_questions SET survey_group = 4, display_index = 17 WHERE survey_question_id = 71;
UPDATE group_questions SET survey_group = 4, display_index = 18 WHERE survey_question_id = 72;
UPDATE group_questions SET survey_group = 4, display_index = 19 WHERE survey_question_id = 73;
UPDATE group_questions SET survey_group = 4, display_index = 20 WHERE survey_question_id = 74;
UPDATE group_questions SET survey_group = 4, display_index = 21 WHERE survey_question_id = 75;
INSERT INTO group_questions (survey_group, display_index, survey_question_id) VALUES (4, 22, 157);
UPDATE group_questions SET survey_group = 4, display_index = 23 WHERE survey_question_id = 76;
UPDATE group_questions SET survey_group = 5, display_index = 0 WHERE survey_question_id = 116;
ALTER TABLE group_questions ADD CONSTRAINT idx_group_questions UNIQUE ( survey_group, display_index );
----------------------------------------------------------
-- survey_question_response_type
----------------------------------------------------------
INSERT INTO survey_question_response_type (survey_question_id, survey_response_type) VALUES
(148, 'SINGLE'), (149, 'SINGLE'), (150, 'TEXT'), (153, 'SINGLE'),
(154, 'MULTIPLE'), (155, 'SINGLE'), (156, 'SINGLE'), (157, 'SINGLE'), (158, 'SINGLE'),
(159, 'SINGLE'), (160, 'SINGLE');
----------------------------------------------------------
-- survey_response
----------------------------------------------------------
INSERT INTO survey_response (american, british) VALUES
('2+ times/day', '2+ times/day'),
('1-2 times/day', '1-2 times/day'),
('Once a day', 'Once a day'),
('I tend to be constipated (have difficulty passing stool) - Type 1 and 2', 'I tend to be constipated (have difficulty passing stool) - Type 1 and 2'),
('I tend to have diarrhea (watery stool) - Type 5, 6 and 7', 'I tend to have diarrhea (watery stool) - Type 5, 6 and 7'),
('I tend to have normal formed stool - Type 3 and 4', 'I tend to have normal formed stool - Type 3 and 4'),
('Depression', 'Depression'),
('Bipolar disorder', 'Bipolar disorder'),
('PTSD (post-traumatic stress disorder)', 'PTSD (post-traumatic stress disorder)'),
('Schizophrenia', 'Schizophrenia'),
('Anorexia nervosa', 'Anorexia nervosa'),
('Bulimia nervosa', 'Bulimia nervosa'),
('Substance abuse', 'Substance abuse'),
('Prediabetes', 'Prediabetes'),
('Type I diabetes', 'Type I diabetes'),
('Type II diabetes', 'Type II diabetes'),
('Gestational diabetes', 'Gestational diabetes'),
('Libya', 'Libya'),
('Vietnam', 'Vietnam'),
('Taiwan', 'Taiwan'),
('No treatment', 'No treatment'),
('Surgery only', 'Surgery only'),
('Chemotherapy', 'Chemotherapy'),
('Radiation therapy', 'Radiation therapy');
----------------------------------------------------------
-- survey_question_response
----------------------------------------------------------
--Update responses from stool quality
--Add new responses as valid for the question
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES
(38, 'I tend to be constipated (have difficulty passing stool) - Type 1 and 2', 21),
(38, 'I tend to have diarrhea (watery stool) - Type 5, 6 and 7', 22),
(38, 'I tend to have normal formed stool - Type 3 and 4', 23);
--Update answers
UPDATE survey_answers SET response = 'I tend to be constipated (have difficulty passing stool) - Type 1 and 2' WHERE survey_question_id = 38 AND response = 'I tend to be constipated (have difficulty passing stool)';
UPDATE survey_answers SET response = 'I tend to have diarrhea (watery stool) - Type 5, 6 and 7' WHERE survey_question_id = 38 AND response = 'I tend to have diarrhea (watery stool)';
UPDATE survey_answers SET response = 'I tend to have normal formed stool - Type 3 and 4' WHERE survey_question_id = 38 AND response = 'I tend to have normal formed stool';
--Update allowed responses for new responses, without breaking FKs
DELETE FROM survey_question_response WHERE survey_question_id = 38 AND response = 'I tend to be constipated (have difficulty passing stool)';
DELETE FROM survey_question_response WHERE survey_question_id = 38 AND response = 'I tend to have diarrhea (watery stool)';
DELETE FROM survey_question_response WHERE survey_question_id = 38 AND response = 'I tend to have normal formed stool';
UPDATE survey_question_response SET display_index = 1 WHERE response = 'I tend to be constipated (have difficulty passing stool) - Type 1 and 2' AND survey_question_id = 38;
UPDATE survey_question_response SET display_index = 2 WHERE response = 'I tend to have diarrhea (watery stool) - Type 5, 6 and 7' AND survey_question_id = 38;
UPDATE survey_question_response SET display_index = 3 WHERE response = 'I tend to have normal formed stool - Type 3 and 4' AND survey_question_id = 38;
-- country of residence
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Unspecified', 0);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Afghanistan', 1);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Aland Islands', 2);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Albania', 3);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Algeria', 4);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'American Samoa', 5);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Andorra', 6);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Angola', 7);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Anguilla', 8);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Antarctica', 9);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Antigua and Barbuda', 10);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Argentina', 11);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Armenia', 12);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Aruba', 13);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Australia', 14);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Austria', 15);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Azerbaijan', 16);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Bahamas', 17);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Bahrain', 18);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Bangladesh', 19);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Barbados', 20);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Belarus', 21);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Belgium', 22);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Belize', 23);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Benin', 24);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Bermuda', 25);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Bhutan', 26);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Bolivia', 27);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Bosnia and Herzegovina', 28);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Botswana', 29);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Bouvet Island', 30);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Brazil', 31);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'British Indian Ocean Territory', 32);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Brunei Darussalam', 33);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Bulgaria', 34);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Burkina Faso', 35);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Burundi', 36);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Cambodia', 37);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Cameroon', 38);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Canada', 39);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Cape Verde', 40);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Cayman Islands', 41);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Central African Republic', 42);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Chad', 43);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Chile', 44);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'China', 45);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Christmas Island', 46);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Cocos (Keeling) Islands', 47);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Colombia', 48);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Comoros', 49);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Congo', 50);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Congo, The Democratic Republic of The', 51);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Cook Islands', 52);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Costa Rica', 53);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Cote D''ivoire', 54);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Croatia', 55);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Cuba', 56);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Cyprus', 57);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Czech Republic', 58);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Denmark', 59);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Djibouti', 60);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Dominica', 61);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Dominican Republic', 62);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Ecuador', 63);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Egypt', 64);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'El Salvador', 65);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Equatorial Guinea', 66);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Eritrea', 67);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Estonia', 68);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Ethiopia', 69);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Falkland Islands (Malvinas)', 70);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Faroe Islands', 71);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Fiji', 72);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Finland', 73);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'France', 74);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'French Guiana', 75);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'French Polynesia', 76);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'French Southern Territories', 77);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Gabon', 78);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Gambia', 79);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Georgia', 80);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Germany', 81);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Ghana', 82);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Gibraltar', 83);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Greece', 84);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Greenland', 85);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Grenada', 86);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Guadeloupe', 87);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Guam', 88);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Guatemala', 89);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Guernsey', 90);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Guinea', 91);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Guinea-bissau', 92);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Guyana', 93);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Haiti', 94);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Heard Island and Mcdonald Islands', 95);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Holy See (Vatican City State)', 96);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Honduras', 97);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Hong Kong', 98);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Hungary', 99);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Iceland', 100);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'India', 101);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Indonesia', 102);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Iran, Islamic Republic of', 103);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Iraq', 104);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Ireland', 105);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Isle of Man', 106);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Israel', 107);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Italy', 108);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Jamaica', 109);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Japan', 110);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Jersey', 111);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Jordan', 112);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Kazakhstan', 113);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Kenya', 114);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Kiribati', 115);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Korea, Democratic People''s Republic of', 116);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Korea, Republic of', 117);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Kuwait', 118);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Kyrgyzstan', 119);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Lao People''s Democratic Republic', 120);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Latvia', 121);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Lebanon', 122);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Lesotho', 123);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Liberia', 124);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Libya', 125);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Liechtenstein', 126);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Lithuania', 127);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Luxembourg', 128);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Macao', 129);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Macedonia, The Former Yugoslav Republic of', 130);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Madagascar', 131);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Malawi', 132);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Malaysia', 133);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Maldives', 134);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Mali', 135);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Malta', 136);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Marshall Islands', 137);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Martinique', 138);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Mauritania', 139);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Mauritius', 140);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Mayotte', 141);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Mexico', 142);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Micronesia, Federated States of', 143);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Moldova, Republic of', 144);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Monaco', 145);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Mongolia', 146);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Montenegro', 147);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Montserrat', 148);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Morocco', 149);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Mozambique', 150);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Myanmar', 151);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Namibia', 152);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Nauru', 153);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Nepal', 154);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Netherlands', 155);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Netherlands Antilles', 156);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'New Caledonia', 157);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'New Zealand', 158);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Nicaragua', 159);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Niger', 160);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Nigeria', 161);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Niue', 162);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Norfolk Island', 163);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Northern Mariana Islands', 164);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Norway', 165);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Oman', 166);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Pakistan', 167);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Palau', 168);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Palestinian Territory, Occupied', 169);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Panama', 170);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Papua New Guinea', 171);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Paraguay', 172);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Peru', 173);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Philippines', 174);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Pitcairn', 175);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Poland', 176);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Portugal', 177);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Puerto Rico', 178);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Qatar', 179);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Reunion', 180);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Romania', 181);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Russian Federation', 182);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Rwanda', 183);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Saint Helena', 184);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Saint Kitts and Nevis', 185);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Saint Lucia', 186);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Saint Pierre and Miquelon', 187);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Saint Vincent and The Grenadines', 188);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Samoa', 189);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'San Marino', 190);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Sao Tome and Principe', 191);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Saudi Arabia', 192);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Senegal', 193);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Serbia', 194);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Seychelles', 195);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Sierra Leone', 196);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Singapore', 197);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Slovakia', 198);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Slovenia', 199);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Solomon Islands', 200);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Somalia', 201);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'South Africa', 202);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'South Georgia and The South Sandwich Islands', 203);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Spain', 204);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Sri Lanka', 205);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Sudan', 206);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Suriname', 207);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Svalbard and Jan Mayen', 208);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Swaziland', 209);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Sweden', 210);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Switzerland', 211);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Syrian Arab Republic', 212);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Taiwan', 213);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Tajikistan', 214);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Tanzania, United Republic of', 215);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Thailand', 216);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Timor-leste', 217);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Togo', 218);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Tokelau', 219);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Tonga', 220);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Trinidad and Tobago', 221);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Tunisia', 222);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Turkey', 223);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Turkmenistan', 224);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Turks and Caicos Islands', 225);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Tuvalu', 226);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Uganda', 227);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Ukraine', 228);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'United Arab Emirates', 229);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'United Kingdom', 230);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'United States', 231);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'United States Minor Outlying Islands', 232);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Uruguay', 233);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Uzbekistan', 234);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Vanuatu', 235);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Venezuela', 236);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Vietnam', 237);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Virgin Islands, British', 238);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Virgin Islands, U.S.', 239);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Wallis and Futuna', 240);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Western Sahara', 241);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Yemen', 242);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Zambia', 243);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES (148, 'Zimbabwe', 244);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES
(149, 'Unspecified', 0), (149, 'Yes', 1), (149, 'No', 2);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES
(153, 'Unspecified', 0), (153, 'Yes', 1), (153, 'No', 2);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES
(154, 'Unspecified', 0),
(154, 'Depression', 1),
(154, 'Bipolar disorder', 2),
(154, 'PTSD (post-traumatic stress disorder)', 3),
(154, 'Schizophrenia', 4),
(154, 'Anorexia nervosa', 5),
(154, 'Bulimia nervosa', 6),
(154, 'Substance abuse', 7);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES
(155, 'Unspecified', 0),
(155, 'Type I diabetes', 1),
(155, 'Type II diabetes', 2),
(155, 'Gestational diabetes', 3);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES
(156, 'Unspecified', 0),
(156, 'Never', 1),
(156, 'Rarely (a few times/month)', 2),
(156, 'Occasionally (1-2 times/week)', 3),
(156, 'Regularly (3-5 times/week)', 4),
(156, 'Daily', 5);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES
(157, 'Unspecified', 0),
(157, 'Never', 1),
(157, 'Rarely (a few times/month)', 2),
(157, 'Occasionally (1-2 times/week)', 3),
(157, 'Regularly (3-5 times/week)', 4),
(157, 'Daily', 5);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES
(158, 'Unspecified', 0),
(158, 'I do not have this condition', 1),
(158, 'Diagnosed by a medical professional (doctor, physician assistant)', 2),
(158, 'Diagnosed by an alternative medicine practitioner', 3),
(158, 'Self-diagnosed', 4);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES
(159, 'Unspecified', 0),
(159, 'No treatment', 1),
(159, 'Surgery only', 2),
(159, 'Chemotherapy', 3),
(159, 'Radiation therapy', 4);
INSERT INTO survey_question_response (survey_question_id, response, display_index) VALUES
(160, 'Unspecified', 0),
(160, 'I do not have this condition', 1),
(160, 'Diagnosed by a medical professional (doctor, physician assistant)', 2),
(160, 'Diagnosed by an alternative medicine practitioner', 3),
(160, 'Self-diagnosed', 4);
---------------------------------------------------------
-- survey_question_triggers
----------------------------------------------------------
-- Other pets
INSERT INTO survey_question_triggers (survey_question_id, triggered_question, triggering_response) VALUES (149, 150, 'Yes');
-- Mental Illness
INSERT INTO survey_question_triggers (survey_question_id, triggered_question, triggering_response) VALUES (153, 154, 'Yes');
-- Diabetes type
INSERT INTO survey_question_triggers (survey_question_id, triggered_question, triggering_response) VALUES
(82, 155, 'Diagnosed by a medical professional (doctor, physician assistant)'),
(82, 155, 'Diagnosed by an alternative medicine practitioner'),
(82, 155, 'Self-diagnosed');
--Cancer treatment
INSERT INTO survey_question_triggers (survey_question_id, triggered_question, triggering_response) VALUES
(158, 159, 'Diagnosed by a medical professional (doctor, physician assistant)'),
(158, 159, 'Diagnosed by an alternative medicine practitioner'),
(158, 159, 'Self-diagnosed');
-- Fix testing issue: Remove types of plants answer from animal survey.
DELETE FROM survey_answers WHERE survey_id = 'cb367dcf9a9af7e9' AND survey_question_id = 146;