Skip to content

Instantly share code, notes, and snippets.

@gabrielke

gabrielke/gist:abde69e2def47f8f97846392ae066f4d

Last active October 30, 2023 05:19
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save gabrielke/abde69e2def47f8f97846392ae066f4d to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save gabrielke/abde69e2def47f8f97846392ae066f4d to your computer and use it in GitHub Desktop.
Download ZIP
Home assistant repair sequences
Raw
gistfile1.txt
select setval ('event_data_data_id_seq',(select max(data_id) from event_data ));
select setval ('event_types_event_type_id_seq',(select max(event_type_id) from event_types ));
select setval ('events_event_id_seq',(select max(event_id) from events ));
select setval ('recorder_runs_run_id_seq',(select max(run_id) from recorder_runs ));
select setval ('schema_changes_change_id_seq',(select max(change_id) from schema_changes ));
select setval ('state_attributes_attributes_id_seq',(select max(attributes_id) from state_attributes ));
select setval ('states_meta_metadata_id_seq',(select max(metadata_id) from states_meta ));
select setval ('states_state_id_seq',(select max(state_id) from states ));
select setval ('statistics_id_seq',(select max(id) from "statistics" ));
select setval ('statistics_meta_id_seq',(select max(id) from statistics_meta ));
select setval ('statistics_runs_run_id_seq',(select max(run_id) from statistics_runs ));
select setval ('statistics_short_term_id_seq',(select max(id) from statistics_short_term ));
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment