db scripts updates for filter, filter_group

diff --git a/dbscripts/extra/changedbowner.sh b/dbscripts/extra/changedbowner.sh
index 1a20147..f4bbc2b 100755 (executable)
--- a/dbscripts/extra/changedbowner.sh
+++ b/dbscripts/extra/changedbowner.sh
@@ -46,6 +46,8 @@ echo "grant all on video           to $2;"   >> ${SCRIPT_FILE}
 echo "grant all on content         to $2;"   >> ${SCRIPT_FILE}
 echo "grant all on comment         to $2;"   >> ${SCRIPT_FILE}
 echo "grant all on media_folder    to $2;"   >> ${SCRIPT_FILE}
+echo "grant all on filter          to $2;"   >> ${SCRIPT_FILE}
+echo "grant all on filter_group    to $2;"   >> ${SCRIPT_FILE}
                          
 
 echo "grant all on media_id_seq    to $2;"   >> ${SCRIPT_FILE}
@@ -61,6 +63,8 @@ echo "grant all on links_imcs_id_seq to $2;"   >> ${SCRIPT_FILE}
 echo "grant all on comment_status_id_seq to $2;"   >> ${SCRIPT_FILE}
 echo "grant all on article_type_id_seq to $2;"   >> ${SCRIPT_FILE}
 echo "grant all on language_id_seq to $2;"   >> ${SCRIPT_FILE}
+echo "grant all on filter_id_seq to $2;"   >> ${SCRIPT_FILE}
+echo "grant all on filter_group_id_seq to $2;"   >> ${SCRIPT_FILE}
 
 
 # execute the script

diff --git a/dbscripts/update_all_sequences.sql b/dbscripts/update_all_sequences.sql
index f827252..43352f1 100755 (executable)
--- a/dbscripts/update_all_sequences.sql
+++ b/dbscripts/update_all_sequences.sql
@@ -15,3 +15,5 @@ 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
+select setval('filter_id_seq',        (select max(id) from filter));\r
+select setval('filter_group_id_seq',  (select max(id) from filter_group));\r