X-Git-Url: http://erislabs.net/gitweb/?a=blobdiff_plain;f=dbscripts%2Fupdate_all_sequences.sql;h=f82725226f78adbee846982dea84a012d46c2e24;hb=25d4e7462606788970b556c0637fb62cf1981e24;hp=a874112d60c3964ed88f34ec9e00d5fbc0d02c3e;hpb=c9758b0aba1df417bcd5db424e031995a7bdba71;p=mir.git

diff --git a/dbscripts/update_all_sequences.sql b/dbscripts/update_all_sequences.sql
index a874112d..f8272522 100755
--- 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
 
-select setval('media_id_seq',         (select max(id) from media));
+select 
+  CASE WHEN (select max(id) from content)>(select max(id) from uploaded_media)
+     THEN setval('media_id_seq', (select max(id) from content))
+     ELSE setval('media_id_seq', (select max(id) from uploaded_media))
+  END;
 select setval('media_folder_id_seq',  (select max(id) from media_folder));
 select setval('topic_id_seq',         (select max(id) from topic));
 select setval('webdb_users_id_seq',   (select max(id) from webdb_users));
@@ -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));
 select setval('article_type_id_seq',  (select max(id) from article_type));
 select setval('language_id_seq',      (select max(id) from language));
-
-
-
-