some maintenance on the db scripts:

[mir.git] / dbscripts / update_all_sequences.sql

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