Repository navigation
Expand file tree
/
Copy pathdelete_player_versions_after.sql
More file actions
26 lines (24 loc) · 2.25 KB
/
Copy pathdelete_player_versions_after.sql
File metadata and controls
26 lines (24 loc) · 2.25 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
begin;
delete from data.player_equipment_effect_versions where valid_from >= '2026-03-11T17:00:16.253892Z';
update data.player_equipment_effect_versions set valid_until=null where valid_until >= '2026-03-11T17:00:16.253892Z';
delete from data.player_equipment_versions where valid_from >= '2026-03-11T17:00:16.253892Z';
update data.player_equipment_versions set valid_until=null where valid_until >= '2026-03-11T17:00:16.253892Z';
delete from data.player_modification_versions where valid_from >= '2026-03-11T17:00:16.253892Z';
update data.player_modification_versions set valid_until=null where valid_until >= '2026-03-11T17:00:16.253892Z';
delete from data.player_pitch_category_bonus_versions where valid_from >= '2026-03-11T17:00:16.253892Z';
update data.player_pitch_category_bonus_versions set valid_until=null where valid_until >= '2026-03-11T17:00:16.253892Z';
delete from data.player_pitch_type_bonus_versions where valid_from >= '2026-03-11T17:00:16.253892Z';
update data.player_pitch_type_bonus_versions set valid_until=null where valid_until >= '2026-03-11T17:00:16.253892Z';
delete from data.player_pitch_type_versions where valid_from >= '2026-03-11T17:00:16.253892Z';
update data.player_pitch_type_versions set valid_until=null where valid_until >= '2026-03-11T17:00:16.253892Z';
delete from data.player_report_attribute_versions where valid_from >= '2026-03-11T17:00:16.253892Z';
update data.player_report_attribute_versions set valid_until=null where valid_until >= '2026-03-11T17:00:16.253892Z';
delete from data.player_report_versions where valid_from >= '2026-03-11T17:00:16.253892Z';
update data.player_report_versions set valid_until=null where valid_until >= '2026-03-11T17:00:16.253892Z';
delete from data.player_versions where valid_from >= '2026-03-11T17:00:16.253892Z';
update data.player_versions set valid_until=null where valid_until >= '2026-03-11T17:00:16.253892Z';
delete from data.versions_processed where kind='player' and valid_from >= '2026-03-11T17:00:16.253892Z';
delete from info.version_ingest_log where kind='player' and valid_from >= '2026-03-11T17:00:16.253892Z';
refresh materialized view info.entities_count;
refresh materialized view info.entities_with_issues_count;
end;