1 -- This script updates all sequences in a postgres mir database
\r
3 select setval('media_id_seq', (select max(id) from media));
\r
4 select setval('media_folder_id_seq', (select max(id) from media_folder));
\r
5 select setval('feature_id_seq', (select max(id) from feature));
\r
6 select setval('topic_id_seq', (select max(id) from topic));
\r
7 select setval('webdb_users_id_seq', (select max(id) from webdb_users));
\r
8 select setval('comment_id_seq', (select max(id) from comment));
\r
9 select setval('breaking_id_seq', (select max(id) from breaking));
\r
10 select setval('messages_id_seq', (select max(id) from messages));
\r
11 select setval('media_type_id_seq', (select max(id) from media_type));
\r
13 select setval('comment_status_id_seq',(select max(id) from comment_status));
\r
14 select setval('article_type_id_seq', (select max(id) from article_type));
\r
15 select setval('language_id_seq', (select max(id) from language));
\r