synapse/synapse/storage/schema/full_schemas/54/zzz-inserts.sql

INSERT INTO user_directory_stream_pos (stream_id) VALUES (null);

INSERT INTO appservice_stream_position (stream_ordering)
    SELECT COALESCE(MAX(stream_ordering), 0) FROM events;

INSERT INTO device_max_stream_id (stream_id)
    SELECT COALESCE(MAX(stream_id), 0) FROM device_inbox;

INSERT INTO event_push_summary_stream_ordering (stream_ordering) VALUES (0);

INSERT INTO federation_stream_position (type, stream_id) VALUES ('federation', -1);
INSERT INTO federation_stream_position (type, stream_id) SELECT 'events', coalesce(max(stream_ordering), -1) FROM events;