X-Git-Url: http://erislabs.net/gitweb/?a=blobdiff_plain;f=dbscripts%2Fupdate_all_sequences.sql;fp=dbscripts%2Fupdate_all_sequences.sql;h=b7c48420d46910d4cb1e09db08e467e2749850ee;hb=e33f025803603a431ce701b3a66cd62e3a7f52f3;hp=0000000000000000000000000000000000000000;hpb=8af1c240eba4e0bffbce4a9134696e188a653a3d;p=mir.git

diff --git a/dbscripts/update_all_sequences.sql b/dbscripts/update_all_sequences.sql
new file mode 100755
index 00000000..b7c48420
--- /dev/null
+++ b/dbscripts/update_all_sequences.sql
@@ -0,0 +1,19 @@
+-- This script updates all sequences in a postgres mir database
+
+select setval('media_id_seq',         (select max(id) from media));
+select setval('media_folder_id_seq',  (select max(id) from media_folder));
+select setval('feature_id_seq',       (select max(id) from feature));
+select setval('topic_id_seq',         (select max(id) from topic));
+select setval('webdb_users_id_seq',   (select max(id) from webdb_users));
+select setval('comment_id_seq',       (select max(id) from comment));
+select setval('breaking_id_seq',      (select max(id) from breaking));
+select setval('messages_id_seq',      (select max(id) from messages));
+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));
+
+
+
+