restoring head

[mir.git] / dbscripts / update_all_sequences.sql

diff --git a/dbscripts/update_all_sequences.sql b/dbscripts/update_all_sequences.sql
index a874112..f827252 100755 (executable)
--- a/dbscripts/update_all_sequences.sql
+++ b/dbscripts/update_all_sequences.sql
@@ -1,6 +1,10 @@
 -- This script updates all sequences in a postgres mir database\r
 \r
-select setval('media_id_seq',         (select max(id) from media));\r
+select \r
+  CASE WHEN (select max(id) from content)>(select max(id) from uploaded_media)\r
+     THEN setval('media_id_seq', (select max(id) from content))\r
+     ELSE setval('media_id_seq', (select max(id) from uploaded_media))\r
+  END;\r
 select setval('media_folder_id_seq',  (select max(id) from media_folder));\r
 select setval('topic_id_seq',         (select max(id) from topic));\r
 select setval('webdb_users_id_seq',   (select max(id) from webdb_users));\r
@@ -11,7 +15,3 @@ select setval('media_type_id_seq',    (select max(id) from media_type));
 select setval('comment_status_id_seq',(select max(id) from comment_status));\r
 select setval('article_type_id_seq',  (select max(id) from article_type));\r
 select setval('language_id_seq',      (select max(id) from language));\r
-\r
-\r
-\r
-\r