-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathTweakDevelopment.sql
More file actions
110 lines (104 loc) · 27.8 KB
/
TweakDevelopment.sql
File metadata and controls
110 lines (104 loc) · 27.8 KB
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
SET session_replication_role = 'replica';
INSERT INTO public.card_setting (id, user_id, name, new_cards_steps_in_minutes, new_cards_max_per_day, new_cards_graduating_interval_in_days, new_cards_easy_interval_in_days, new_cards_starting_ease_factor_in_permille, new_cards_bury_related, mature_cards_max_per_day, mature_cards_ease_factor_easy_bonus_factor_in_permille, mature_cards_interval_factor_in_permille, mature_cards_maximum_interval_in_days, mature_cards_hard_interval_factor_in_permille, mature_cards_bury_related, lapsed_cards_steps_in_minutes, lapsed_cards_new_interval_factor_in_permille, lapsed_cards_minimum_interval_in_days, lapsed_cards_leech_threshold, show_answer_timer, automatically_play_audio, replay_question_audio_on_answer) VALUES ('00000000-0000-0000-0000-5e7700000004', '00000000-0000-0000-0000-000000000004', 'Default', '1 10', 20, 1, 4, 2500, true, 200, 1300, 1000, 32767, 1200, true, '10', 0, 1, 8, false, false, false);
INSERT INTO public.card_setting (id, user_id, name, new_cards_steps_in_minutes, new_cards_max_per_day, new_cards_graduating_interval_in_days, new_cards_easy_interval_in_days, new_cards_starting_ease_factor_in_permille, new_cards_bury_related, mature_cards_max_per_day, mature_cards_ease_factor_easy_bonus_factor_in_permille, mature_cards_interval_factor_in_permille, mature_cards_maximum_interval_in_days, mature_cards_hard_interval_factor_in_permille, mature_cards_bury_related, lapsed_cards_steps_in_minutes, lapsed_cards_new_interval_factor_in_permille, lapsed_cards_minimum_interval_in_days, lapsed_cards_leech_threshold, show_answer_timer, automatically_play_audio, replay_question_audio_on_answer) VALUES ('00000000-0000-0000-0000-5e7700000005', '00000000-0000-0000-0000-000000000005', 'Default', '1 10', 20, 1, 4, 2500, true, 200, 1300, 1000, 32767, 1200, true, '10', 0, 1, 8, false, false, false);
INSERT INTO public.card_setting (id, user_id, name, new_cards_steps_in_minutes, new_cards_max_per_day, new_cards_graduating_interval_in_days, new_cards_easy_interval_in_days, new_cards_starting_ease_factor_in_permille, new_cards_bury_related, mature_cards_max_per_day, mature_cards_ease_factor_easy_bonus_factor_in_permille, mature_cards_interval_factor_in_permille, mature_cards_maximum_interval_in_days, mature_cards_hard_interval_factor_in_permille, mature_cards_bury_related, lapsed_cards_steps_in_minutes, lapsed_cards_new_interval_factor_in_permille, lapsed_cards_minimum_interval_in_days, lapsed_cards_leech_threshold, show_answer_timer, automatically_play_audio, replay_question_audio_on_answer) VALUES ('00000000-0000-0000-0000-5e7700000006', '00000000-0000-0000-0000-000000000006', 'Default', '1 10', 20, 1, 4, 2500, true, 200, 1300, 1000, 32767, 1200, true, '10', 0, 1, 8, false, false, false);
INSERT INTO public.card_setting (id, user_id, name, new_cards_steps_in_minutes, new_cards_max_per_day, new_cards_graduating_interval_in_days, new_cards_easy_interval_in_days, new_cards_starting_ease_factor_in_permille, new_cards_bury_related, mature_cards_max_per_day, mature_cards_ease_factor_easy_bonus_factor_in_permille, mature_cards_interval_factor_in_permille, mature_cards_maximum_interval_in_days, mature_cards_hard_interval_factor_in_permille, mature_cards_bury_related, lapsed_cards_steps_in_minutes, lapsed_cards_new_interval_factor_in_permille, lapsed_cards_minimum_interval_in_days, lapsed_cards_leech_threshold, show_answer_timer, automatically_play_audio, replay_question_audio_on_answer) VALUES ('00000000-0000-0000-0000-5e7700000007', '00000000-0000-0000-0000-000000000007', 'Default', '1 10', 20, 1, 4, 2500, true, 200, 1300, 1000, 32767, 1200, true, '10', 0, 1, 8, false, false, false);
INSERT INTO public.card_setting (id, user_id, name, new_cards_steps_in_minutes, new_cards_max_per_day, new_cards_graduating_interval_in_days, new_cards_easy_interval_in_days, new_cards_starting_ease_factor_in_permille, new_cards_bury_related, mature_cards_max_per_day, mature_cards_ease_factor_easy_bonus_factor_in_permille, mature_cards_interval_factor_in_permille, mature_cards_maximum_interval_in_days, mature_cards_hard_interval_factor_in_permille, mature_cards_bury_related, lapsed_cards_steps_in_minutes, lapsed_cards_new_interval_factor_in_permille, lapsed_cards_minimum_interval_in_days, lapsed_cards_leech_threshold, show_answer_timer, automatically_play_audio, replay_question_audio_on_answer) VALUES ('00000000-0000-0000-0000-5e7700000008', '00000000-0000-0000-0000-000000000008', 'Default', '1 10', 20, 1, 4, 2500, true, 200, 1300, 1000, 32767, 1200, true, '10', 0, 1, 8, false, false, false);
INSERT INTO public.card_setting (id, user_id, name, new_cards_steps_in_minutes, new_cards_max_per_day, new_cards_graduating_interval_in_days, new_cards_easy_interval_in_days, new_cards_starting_ease_factor_in_permille, new_cards_bury_related, mature_cards_max_per_day, mature_cards_ease_factor_easy_bonus_factor_in_permille, mature_cards_interval_factor_in_permille, mature_cards_maximum_interval_in_days, mature_cards_hard_interval_factor_in_permille, mature_cards_bury_related, lapsed_cards_steps_in_minutes, lapsed_cards_new_interval_factor_in_permille, lapsed_cards_minimum_interval_in_days, lapsed_cards_leech_threshold, show_answer_timer, automatically_play_audio, replay_question_audio_on_answer) VALUES ('00000000-0000-0000-0000-5e7700000009', '00000000-0000-0000-0000-000000000009', 'Default', '1 10', 20, 1, 4, 2500, true, 200, 1300, 1000, 32767, 1200, true, '10', 0, 1, 8, false, false, false);
INSERT INTO public.card_setting (id, user_id, name, new_cards_steps_in_minutes, new_cards_max_per_day, new_cards_graduating_interval_in_days, new_cards_easy_interval_in_days, new_cards_starting_ease_factor_in_permille, new_cards_bury_related, mature_cards_max_per_day, mature_cards_ease_factor_easy_bonus_factor_in_permille, mature_cards_interval_factor_in_permille, mature_cards_maximum_interval_in_days, mature_cards_hard_interval_factor_in_permille, mature_cards_bury_related, lapsed_cards_steps_in_minutes, lapsed_cards_new_interval_factor_in_permille, lapsed_cards_minimum_interval_in_days, lapsed_cards_leech_threshold, show_answer_timer, automatically_play_audio, replay_question_audio_on_answer) VALUES ('00000000-0000-0000-0000-5e7700000010', '00000000-0000-0000-0000-000000000010', 'Default', '1 10', 20, 1, 4, 2500, true, 200, 1300, 1000, 32767, 1200, true, '10', 0, 1, 8, false, false, false);
INSERT INTO public.card_setting (id, user_id, name, new_cards_steps_in_minutes, new_cards_max_per_day, new_cards_graduating_interval_in_days, new_cards_easy_interval_in_days, new_cards_starting_ease_factor_in_permille, new_cards_bury_related, mature_cards_max_per_day, mature_cards_ease_factor_easy_bonus_factor_in_permille, mature_cards_interval_factor_in_permille, mature_cards_maximum_interval_in_days, mature_cards_hard_interval_factor_in_permille, mature_cards_bury_related, lapsed_cards_steps_in_minutes, lapsed_cards_new_interval_factor_in_permille, lapsed_cards_minimum_interval_in_days, lapsed_cards_leech_threshold, show_answer_timer, automatically_play_audio, replay_question_audio_on_answer) VALUES ('00000000-0000-0000-0000-5e7700000011', '00000000-0000-0000-0000-000000000011', 'Default', '1 10', 20, 1, 4, 2500, true, 200, 1300, 1000, 32767, 1200, true, '10', 0, 1, 8, false, false, false);
INSERT INTO public.card_setting (id, user_id, name, new_cards_steps_in_minutes, new_cards_max_per_day, new_cards_graduating_interval_in_days, new_cards_easy_interval_in_days, new_cards_starting_ease_factor_in_permille, new_cards_bury_related, mature_cards_max_per_day, mature_cards_ease_factor_easy_bonus_factor_in_permille, mature_cards_interval_factor_in_permille, mature_cards_maximum_interval_in_days, mature_cards_hard_interval_factor_in_permille, mature_cards_bury_related, lapsed_cards_steps_in_minutes, lapsed_cards_new_interval_factor_in_permille, lapsed_cards_minimum_interval_in_days, lapsed_cards_leech_threshold, show_answer_timer, automatically_play_audio, replay_question_audio_on_answer) VALUES ('00000000-0000-0000-0000-5e7700000012', '00000000-0000-0000-0000-000000000012', 'Default', '1 10', 20, 1, 4, 2500, true, 200, 1300, 1000, 32767, 1200, true, '10', 0, 1, 8, false, false, false);
INSERT INTO public.card_setting (id, user_id, name, new_cards_steps_in_minutes, new_cards_max_per_day, new_cards_graduating_interval_in_days, new_cards_easy_interval_in_days, new_cards_starting_ease_factor_in_permille, new_cards_bury_related, mature_cards_max_per_day, mature_cards_ease_factor_easy_bonus_factor_in_permille, mature_cards_interval_factor_in_permille, mature_cards_maximum_interval_in_days, mature_cards_hard_interval_factor_in_permille, mature_cards_bury_related, lapsed_cards_steps_in_minutes, lapsed_cards_new_interval_factor_in_permille, lapsed_cards_minimum_interval_in_days, lapsed_cards_leech_threshold, show_answer_timer, automatically_play_audio, replay_question_audio_on_answer) VALUES ('00000000-0000-0000-0000-5e7700000013', '00000000-0000-0000-0000-000000000013', 'Default', '1 10', 20, 1, 4, 2500, true, 200, 1300, 1000, 32767, 1200, true, '10', 0, 1, 8, false, false, false);
INSERT INTO public.deck (id, user_id, name, is_public, followers, tsv, created) VALUES ('00000000-0000-0000-0000-decc00000004', '00000000-0000-0000-0000-000000000004', 'Default Deck', false, 0, '''deck'':2 ''default'':1', '2020-08-14 00:00:00');
INSERT INTO public.deck (id, user_id, name, is_public, followers, tsv, created) VALUES ('00000000-0000-0000-0000-decc00000005', '00000000-0000-0000-0000-000000000005', 'Default Deck', false, 0, '''deck'':2 ''default'':1', '2020-08-14 00:00:00');
INSERT INTO public.deck (id, user_id, name, is_public, followers, tsv, created) VALUES ('00000000-0000-0000-0000-decc00000006', '00000000-0000-0000-0000-000000000006', 'Default Deck', false, 0, '''deck'':2 ''default'':1', '2020-08-14 00:00:00');
INSERT INTO public.deck (id, user_id, name, is_public, followers, tsv, created) VALUES ('00000000-0000-0000-0000-decc00000007', '00000000-0000-0000-0000-000000000007', 'Default Deck', false, 0, '''deck'':2 ''default'':1', '2020-08-14 00:00:00');
INSERT INTO public.deck (id, user_id, name, is_public, followers, tsv, created) VALUES ('00000000-0000-0000-0000-decc00000008', '00000000-0000-0000-0000-000000000008', 'Default Deck', false, 0, '''deck'':2 ''default'':1', '2020-08-14 00:00:00');
INSERT INTO public.deck (id, user_id, name, is_public, followers, tsv, created) VALUES ('00000000-0000-0000-0000-decc00000009', '00000000-0000-0000-0000-000000000009', 'Default Deck', false, 0, '''deck'':2 ''default'':1', '2020-08-14 00:00:00');
INSERT INTO public.deck (id, user_id, name, is_public, followers, tsv, created) VALUES ('00000000-0000-0000-0000-decc00000010', '00000000-0000-0000-0000-000000000010', 'Default Deck', false, 0, '''deck'':2 ''default'':1', '2020-08-14 00:00:00');
INSERT INTO public.deck (id, user_id, name, is_public, followers, tsv, created) VALUES ('00000000-0000-0000-0000-decc00000011', '00000000-0000-0000-0000-000000000011', 'Default Deck', false, 0, '''deck'':2 ''default'':1', '2020-08-14 00:00:00');
INSERT INTO public.deck (id, user_id, name, is_public, followers, tsv, created) VALUES ('00000000-0000-0000-0000-decc00000012', '00000000-0000-0000-0000-000000000012', 'Default Deck', false, 0, '''deck'':2 ''default'':1', '2020-08-14 00:00:00');
INSERT INTO public.deck (id, user_id, name, is_public, followers, tsv, created) VALUES ('00000000-0000-0000-0000-decc00000013', '00000000-0000-0000-0000-000000000013', 'Default Deck', false, 0, '''deck'':2 ''default'':1', '2020-08-14 00:00:00');
INSERT INTO public.padawan (id, display_name, default_deck_id, default_card_setting_id, show_next_review_time, show_remaining_card_count, mix_new_and_review, next_day_starts_at_x_hours_past_midnight, learn_ahead_limit_in_minutes, timebox_time_limit_in_minutes, is_night_mode, tsv) VALUES ('00000000-0000-0000-0000-000000000004', 'Nina', '00000000-0000-0000-0000-decc00000004', '00000000-0000-0000-0000-5e7700000004', false, false, 0, 0, 0, 0, false, '''nina'':1');
INSERT INTO public.padawan (id, display_name, default_deck_id, default_card_setting_id, show_next_review_time, show_remaining_card_count, mix_new_and_review, next_day_starts_at_x_hours_past_midnight, learn_ahead_limit_in_minutes, timebox_time_limit_in_minutes, is_night_mode, tsv) VALUES ('00000000-0000-0000-0000-000000000005', 'Alison', '00000000-0000-0000-0000-decc00000005', '00000000-0000-0000-0000-5e7700000005', false, false, 0, 0, 0, 0, false, '''alison'':1');
INSERT INTO public.padawan (id, display_name, default_deck_id, default_card_setting_id, show_next_review_time, show_remaining_card_count, mix_new_and_review, next_day_starts_at_x_hours_past_midnight, learn_ahead_limit_in_minutes, timebox_time_limit_in_minutes, is_night_mode, tsv) VALUES ('00000000-0000-0000-0000-000000000006', 'Mark', '00000000-0000-0000-0000-decc00000006', '00000000-0000-0000-0000-5e7700000006', false, false, 0, 0, 0, 0, false, '''mark'':1');
INSERT INTO public.padawan (id, display_name, default_deck_id, default_card_setting_id, show_next_review_time, show_remaining_card_count, mix_new_and_review, next_day_starts_at_x_hours_past_midnight, learn_ahead_limit_in_minutes, timebox_time_limit_in_minutes, is_night_mode, tsv) VALUES ('00000000-0000-0000-0000-000000000007', 'Caren', '00000000-0000-0000-0000-decc00000007', '00000000-0000-0000-0000-5e7700000007', false, false, 0, 0, 0, 0, false, '''caren'':1');
INSERT INTO public.padawan (id, display_name, default_deck_id, default_card_setting_id, show_next_review_time, show_remaining_card_count, mix_new_and_review, next_day_starts_at_x_hours_past_midnight, learn_ahead_limit_in_minutes, timebox_time_limit_in_minutes, is_night_mode, tsv) VALUES ('00000000-0000-0000-0000-000000000008', 'Heidi', '00000000-0000-0000-0000-decc00000008', '00000000-0000-0000-0000-5e7700000008', false, false, 0, 0, 0, 0, false, '''heidi'':1');
INSERT INTO public.padawan (id, display_name, default_deck_id, default_card_setting_id, show_next_review_time, show_remaining_card_count, mix_new_and_review, next_day_starts_at_x_hours_past_midnight, learn_ahead_limit_in_minutes, timebox_time_limit_in_minutes, is_night_mode, tsv) VALUES ('00000000-0000-0000-0000-000000000009', 'Christine', '00000000-0000-0000-0000-decc00000009', '00000000-0000-0000-0000-5e7700000009', false, false, 0, 0, 0, 0, false, '''christine'':1');
INSERT INTO public.padawan (id, display_name, default_deck_id, default_card_setting_id, show_next_review_time, show_remaining_card_count, mix_new_and_review, next_day_starts_at_x_hours_past_midnight, learn_ahead_limit_in_minutes, timebox_time_limit_in_minutes, is_night_mode, tsv) VALUES ('00000000-0000-0000-0000-000000000010', 'Lucas', '00000000-0000-0000-0000-decc00000010', '00000000-0000-0000-0000-5e7700000010', false, false, 0, 0, 0, 0, false, '''lucas'':1');
INSERT INTO public.padawan (id, display_name, default_deck_id, default_card_setting_id, show_next_review_time, show_remaining_card_count, mix_new_and_review, next_day_starts_at_x_hours_past_midnight, learn_ahead_limit_in_minutes, timebox_time_limit_in_minutes, is_night_mode, tsv) VALUES ('00000000-0000-0000-0000-000000000011', 'Mattics', '00000000-0000-0000-0000-decc00000011', '00000000-0000-0000-0000-5e7700000011', false, false, 0, 0, 0, 0, false, '''mattics'':1');
INSERT INTO public.padawan (id, display_name, default_deck_id, default_card_setting_id, show_next_review_time, show_remaining_card_count, mix_new_and_review, next_day_starts_at_x_hours_past_midnight, learn_ahead_limit_in_minutes, timebox_time_limit_in_minutes, is_night_mode, tsv) VALUES ('00000000-0000-0000-0000-000000000012', 'Dustin', '00000000-0000-0000-0000-decc00000012', '00000000-0000-0000-0000-5e7700000012', false, false, 0, 0, 0, 0, false, '''dustin'':1');
INSERT INTO public.padawan (id, display_name, default_deck_id, default_card_setting_id, show_next_review_time, show_remaining_card_count, mix_new_and_review, next_day_starts_at_x_hours_past_midnight, learn_ahead_limit_in_minutes, timebox_time_limit_in_minutes, is_night_mode, tsv) VALUES ('00000000-0000-0000-0000-000000000013', 'Steve', '00000000-0000-0000-0000-decc00000013', '00000000-0000-0000-0000-5e7700000013', false, false, 0, 0, 0, 0, false, '''steve'':1');
INSERT INTO public.user_2_templateRevision (user_id, templateRevision_id, default_card_setting_id) VALUES ('00000000-0000-0000-0000-000000000004', '00000000-0000-0000-0000-7e3900001001', '00000000-0000-0000-0000-5e7700000004');
INSERT INTO public.user_2_templateRevision (user_id, templateRevision_id, default_card_setting_id) VALUES ('00000000-0000-0000-0000-000000000004', '00000000-0000-0000-0000-7e3900001002', '00000000-0000-0000-0000-5e7700000004');
INSERT INTO public.user_2_templateRevision (user_id, templateRevision_id, default_card_setting_id) VALUES ('00000000-0000-0000-0000-000000000004', '00000000-0000-0000-0000-7e3900001003', '00000000-0000-0000-0000-5e7700000004');
INSERT INTO public.user_2_templateRevision (user_id, templateRevision_id, default_card_setting_id) VALUES ('00000000-0000-0000-0000-000000000004', '00000000-0000-0000-0000-7e3900001006', '00000000-0000-0000-0000-5e7700000004');
INSERT INTO public.user_2_templateRevision (user_id, templateRevision_id, default_card_setting_id) VALUES ('00000000-0000-0000-0000-000000000004', '00000000-0000-0000-0000-7e3900001005', '00000000-0000-0000-0000-5e7700000004');
INSERT INTO public.user_2_templateRevision (user_id, templateRevision_id, default_card_setting_id) VALUES ('00000000-0000-0000-0000-000000000005', '00000000-0000-0000-0000-7e3900001001', '00000000-0000-0000-0000-5e7700000005');
INSERT INTO public.user_2_templateRevision (user_id, templateRevision_id, default_card_setting_id) VALUES ('00000000-0000-0000-0000-000000000005', '00000000-0000-0000-0000-7e3900001002', '00000000-0000-0000-0000-5e7700000005');
INSERT INTO public.user_2_templateRevision (user_id, templateRevision_id, default_card_setting_id) VALUES ('00000000-0000-0000-0000-000000000005', '00000000-0000-0000-0000-7e3900001003', '00000000-0000-0000-0000-5e7700000005');
INSERT INTO public.user_2_templateRevision (user_id, templateRevision_id, default_card_setting_id) VALUES ('00000000-0000-0000-0000-000000000005', '00000000-0000-0000-0000-7e3900001006', '00000000-0000-0000-0000-5e7700000005');
INSERT INTO public.user_2_templateRevision (user_id, templateRevision_id, default_card_setting_id) VALUES ('00000000-0000-0000-0000-000000000005', '00000000-0000-0000-0000-7e3900001005', '00000000-0000-0000-0000-5e7700000005');
INSERT INTO public.user_2_templateRevision (user_id, templateRevision_id, default_card_setting_id) VALUES ('00000000-0000-0000-0000-000000000006', '00000000-0000-0000-0000-7e3900001001', '00000000-0000-0000-0000-5e7700000006');
INSERT INTO public.user_2_templateRevision (user_id, templateRevision_id, default_card_setting_id) VALUES ('00000000-0000-0000-0000-000000000006', '00000000-0000-0000-0000-7e3900001002', '00000000-0000-0000-0000-5e7700000006');
INSERT INTO public.user_2_templateRevision (user_id, templateRevision_id, default_card_setting_id) VALUES ('00000000-0000-0000-0000-000000000006', '00000000-0000-0000-0000-7e3900001003', '00000000-0000-0000-0000-5e7700000006');
INSERT INTO public.user_2_templateRevision (user_id, templateRevision_id, default_card_setting_id) VALUES ('00000000-0000-0000-0000-000000000006', '00000000-0000-0000-0000-7e3900001006', '00000000-0000-0000-0000-5e7700000006');
INSERT INTO public.user_2_templateRevision (user_id, templateRevision_id, default_card_setting_id) VALUES ('00000000-0000-0000-0000-000000000006', '00000000-0000-0000-0000-7e3900001005', '00000000-0000-0000-0000-5e7700000006');
INSERT INTO public.user_2_templateRevision (user_id, templateRevision_id, default_card_setting_id) VALUES ('00000000-0000-0000-0000-000000000007', '00000000-0000-0000-0000-7e3900001001', '00000000-0000-0000-0000-5e7700000007');
INSERT INTO public.user_2_templateRevision (user_id, templateRevision_id, default_card_setting_id) VALUES ('00000000-0000-0000-0000-000000000007', '00000000-0000-0000-0000-7e3900001002', '00000000-0000-0000-0000-5e7700000007');
INSERT INTO public.user_2_templateRevision (user_id, templateRevision_id, default_card_setting_id) VALUES ('00000000-0000-0000-0000-000000000007', '00000000-0000-0000-0000-7e3900001003', '00000000-0000-0000-0000-5e7700000007');
INSERT INTO public.user_2_templateRevision (user_id, templateRevision_id, default_card_setting_id) VALUES ('00000000-0000-0000-0000-000000000007', '00000000-0000-0000-0000-7e3900001006', '00000000-0000-0000-0000-5e7700000007');
INSERT INTO public.user_2_templateRevision (user_id, templateRevision_id, default_card_setting_id) VALUES ('00000000-0000-0000-0000-000000000007', '00000000-0000-0000-0000-7e3900001005', '00000000-0000-0000-0000-5e7700000007');
INSERT INTO public.user_2_templateRevision (user_id, templateRevision_id, default_card_setting_id) VALUES ('00000000-0000-0000-0000-000000000008', '00000000-0000-0000-0000-7e3900001001', '00000000-0000-0000-0000-5e7700000008');
INSERT INTO public.user_2_templateRevision (user_id, templateRevision_id, default_card_setting_id) VALUES ('00000000-0000-0000-0000-000000000008', '00000000-0000-0000-0000-7e3900001002', '00000000-0000-0000-0000-5e7700000008');
INSERT INTO public.user_2_templateRevision (user_id, templateRevision_id, default_card_setting_id) VALUES ('00000000-0000-0000-0000-000000000008', '00000000-0000-0000-0000-7e3900001003', '00000000-0000-0000-0000-5e7700000008');
INSERT INTO public.user_2_templateRevision (user_id, templateRevision_id, default_card_setting_id) VALUES ('00000000-0000-0000-0000-000000000008', '00000000-0000-0000-0000-7e3900001006', '00000000-0000-0000-0000-5e7700000008');
INSERT INTO public.user_2_templateRevision (user_id, templateRevision_id, default_card_setting_id) VALUES ('00000000-0000-0000-0000-000000000008', '00000000-0000-0000-0000-7e3900001005', '00000000-0000-0000-0000-5e7700000008');
INSERT INTO public.user_2_templateRevision (user_id, templateRevision_id, default_card_setting_id) VALUES ('00000000-0000-0000-0000-000000000009', '00000000-0000-0000-0000-7e3900001001', '00000000-0000-0000-0000-5e7700000009');
INSERT INTO public.user_2_templateRevision (user_id, templateRevision_id, default_card_setting_id) VALUES ('00000000-0000-0000-0000-000000000009', '00000000-0000-0000-0000-7e3900001002', '00000000-0000-0000-0000-5e7700000009');
INSERT INTO public.user_2_templateRevision (user_id, templateRevision_id, default_card_setting_id) VALUES ('00000000-0000-0000-0000-000000000009', '00000000-0000-0000-0000-7e3900001003', '00000000-0000-0000-0000-5e7700000009');
INSERT INTO public.user_2_templateRevision (user_id, templateRevision_id, default_card_setting_id) VALUES ('00000000-0000-0000-0000-000000000009', '00000000-0000-0000-0000-7e3900001006', '00000000-0000-0000-0000-5e7700000009');
INSERT INTO public.user_2_templateRevision (user_id, templateRevision_id, default_card_setting_id) VALUES ('00000000-0000-0000-0000-000000000009', '00000000-0000-0000-0000-7e3900001005', '00000000-0000-0000-0000-5e7700000009');
INSERT INTO public.user_2_templateRevision (user_id, templateRevision_id, default_card_setting_id) VALUES ('00000000-0000-0000-0000-000000000010', '00000000-0000-0000-0000-7e3900001001', '00000000-0000-0000-0000-5e7700000010');
INSERT INTO public.user_2_templateRevision (user_id, templateRevision_id, default_card_setting_id) VALUES ('00000000-0000-0000-0000-000000000010', '00000000-0000-0000-0000-7e3900001002', '00000000-0000-0000-0000-5e7700000010');
INSERT INTO public.user_2_templateRevision (user_id, templateRevision_id, default_card_setting_id) VALUES ('00000000-0000-0000-0000-000000000010', '00000000-0000-0000-0000-7e3900001003', '00000000-0000-0000-0000-5e7700000010');
INSERT INTO public.user_2_templateRevision (user_id, templateRevision_id, default_card_setting_id) VALUES ('00000000-0000-0000-0000-000000000010', '00000000-0000-0000-0000-7e3900001006', '00000000-0000-0000-0000-5e7700000010');
INSERT INTO public.user_2_templateRevision (user_id, templateRevision_id, default_card_setting_id) VALUES ('00000000-0000-0000-0000-000000000010', '00000000-0000-0000-0000-7e3900001005', '00000000-0000-0000-0000-5e7700000010');
INSERT INTO public.user_2_templateRevision (user_id, templateRevision_id, default_card_setting_id) VALUES ('00000000-0000-0000-0000-000000000011', '00000000-0000-0000-0000-7e3900001001', '00000000-0000-0000-0000-5e7700000011');
INSERT INTO public.user_2_templateRevision (user_id, templateRevision_id, default_card_setting_id) VALUES ('00000000-0000-0000-0000-000000000011', '00000000-0000-0000-0000-7e3900001002', '00000000-0000-0000-0000-5e7700000011');
INSERT INTO public.user_2_templateRevision (user_id, templateRevision_id, default_card_setting_id) VALUES ('00000000-0000-0000-0000-000000000011', '00000000-0000-0000-0000-7e3900001003', '00000000-0000-0000-0000-5e7700000011');
INSERT INTO public.user_2_templateRevision (user_id, templateRevision_id, default_card_setting_id) VALUES ('00000000-0000-0000-0000-000000000011', '00000000-0000-0000-0000-7e3900001006', '00000000-0000-0000-0000-5e7700000011');
INSERT INTO public.user_2_templateRevision (user_id, templateRevision_id, default_card_setting_id) VALUES ('00000000-0000-0000-0000-000000000011', '00000000-0000-0000-0000-7e3900001005', '00000000-0000-0000-0000-5e7700000011');
INSERT INTO public.user_2_templateRevision (user_id, templateRevision_id, default_card_setting_id) VALUES ('00000000-0000-0000-0000-000000000012', '00000000-0000-0000-0000-7e3900001001', '00000000-0000-0000-0000-5e7700000012');
INSERT INTO public.user_2_templateRevision (user_id, templateRevision_id, default_card_setting_id) VALUES ('00000000-0000-0000-0000-000000000012', '00000000-0000-0000-0000-7e3900001002', '00000000-0000-0000-0000-5e7700000012');
INSERT INTO public.user_2_templateRevision (user_id, templateRevision_id, default_card_setting_id) VALUES ('00000000-0000-0000-0000-000000000012', '00000000-0000-0000-0000-7e3900001003', '00000000-0000-0000-0000-5e7700000012');
INSERT INTO public.user_2_templateRevision (user_id, templateRevision_id, default_card_setting_id) VALUES ('00000000-0000-0000-0000-000000000012', '00000000-0000-0000-0000-7e3900001006', '00000000-0000-0000-0000-5e7700000012');
INSERT INTO public.user_2_templateRevision (user_id, templateRevision_id, default_card_setting_id) VALUES ('00000000-0000-0000-0000-000000000012', '00000000-0000-0000-0000-7e3900001005', '00000000-0000-0000-0000-5e7700000012');
INSERT INTO public.user_2_templateRevision (user_id, templateRevision_id, default_card_setting_id) VALUES ('00000000-0000-0000-0000-000000000013', '00000000-0000-0000-0000-7e3900001001', '00000000-0000-0000-0000-5e7700000013');
INSERT INTO public.user_2_templateRevision (user_id, templateRevision_id, default_card_setting_id) VALUES ('00000000-0000-0000-0000-000000000013', '00000000-0000-0000-0000-7e3900001002', '00000000-0000-0000-0000-5e7700000013');
INSERT INTO public.user_2_templateRevision (user_id, templateRevision_id, default_card_setting_id) VALUES ('00000000-0000-0000-0000-000000000013', '00000000-0000-0000-0000-7e3900001003', '00000000-0000-0000-0000-5e7700000013');
INSERT INTO public.user_2_templateRevision (user_id, templateRevision_id, default_card_setting_id) VALUES ('00000000-0000-0000-0000-000000000013', '00000000-0000-0000-0000-7e3900001006', '00000000-0000-0000-0000-5e7700000013');
INSERT INTO public.user_2_templateRevision (user_id, templateRevision_id, default_card_setting_id) VALUES ('00000000-0000-0000-0000-000000000013', '00000000-0000-0000-0000-7e3900001005', '00000000-0000-0000-0000-5e7700000013');
SET session_replication_role = 'origin';
do $$ -- Verifies FKs (only) https://dba.stackexchange.com/a/250252
declare r record;
BEGIN
FOR r IN (
SELECT FORMAT(
'UPDATE pg_constraint SET convalidated=false WHERE conname = TRIM(both ''"'' from ''%I''); ALTER TABLE %I VALIDATE CONSTRAINT %I;',
tc.constraint_name,
tc.table_name,
tc.constraint_name
) AS x
FROM information_schema.table_constraints AS tc
JOIN information_schema.tables t ON t.table_name = tc.table_name and t.table_type = 'BASE TABLE'
JOIN information_schema.key_column_usage AS kcu ON tc.constraint_name = kcu.constraint_name
JOIN information_schema.constraint_column_usage AS ccu ON ccu.constraint_name = tc.constraint_name
WHERE constraint_type = 'FOREIGN KEY'
AND tc.constraint_schema = 'public'
)
LOOP
EXECUTE (r.x);
END LOOP;
END;
$$;