Redmine

select setval('attachments_id_seq',(select max(id)+1 from attachments));

select setval('auth_sources_id_seq',(select max(id)+1 from auth_sources));

select setval('boards_id_seq',(select max(id)+1 from boards));

select setval('changes_id_seq',(select max(id)+1 from changes));

select setval('changesets_id_seq',(select max(id)+1 from changesets));

select setval('comments_id_seq',(select max(id)+1 from comments));

select setval('custom_fields_id_seq',(select max(id)+1 from custom_fields));

select setval('custom_values_id_seq',(select max(id)+1 from custom_values));

select setval('documents_id_seq',(select max(id)+1 from documents));

select setval('enabled_modules_id_seq',(select max(id)+1 from enabled_modules));

select setval('enumerations_id_seq',(select max(id)+1 from enumerations));

select setval('hudson_settings_id_seq',(select max(id)+1 from hudson_settings));

select setval('issue_categories_id_seq',(select max(id)+1 from issue_categories));

select setval('issue_relations_id_seq',(select max(id)+1 from issue_relations));

select setval('issue_statuses_id_seq',(select max(id)+1 from issue_statuses));

select setval('issues_id_seq',(select max(id)+1 from issues));

select setval('journal_details_id_seq',(select max(id)+1 from journal_details));

select setval('journals_id_seq',(select max(id)+1 from journals));

select setval('members_id_seq',(select max(id)+1 from members));

select setval('messages_id_seq',(select max(id)+1 from messages));

select setval('newissuealerts_id_seq',(select max(id)+1 from newissuealerts));

select setval('news_id_seq',(select max(id)+1 from news));

select setval('projects_id_seq',(select max(id)+1 from projects));

select setval('queries_id_seq',(select max(id)+1 from queries));

select setval('repositories_id_seq',(select max(id)+1 from repositories));

select setval('roles_id_seq',(select max(id)+1 from roles));

select setval('settings_id_seq',(select max(id)+1 from settings));

select setval('time_entries_id_seq',(select max(id)+1 from time_entries));

select setval('tokens_id_seq',(select max(id)+1 from tokens));

select setval('trackers_id_seq',(select max(id)+1 from trackers));

select setval('user_preferences_id_seq',(select max(id)+1 from user_preferences));

select setval('users_id_seq',(select max(id)+1 from users));

select setval('versions_id_seq',(select max(id)+1 from versions));

select setval('watchers_id_seq',(select max(id)+1 from watchers));

select setval('wiki_content_versions_id_seq',(select max(id)+1 from wiki_content_versions));

select setval('wiki_contents_id_seq',(select max(id)+1 from wiki_contents));

select setval('wiki_pages_id_seq',(select max(id)+1 from wiki_pages));

select setval('wiki_redirects_id_seq',(select max(id)+1 from wiki_redirects));

select setval('wikis_id_seq',(select max(id)+1 from wikis));

select setval('workflows_id_seq',(select max(id)+1 from workflows));