insert email into borrower_message_preferences

diff --git a/borrower_message_preferences/add-missing.sh b/borrower_message_preferences/add-missing.sh
index bcd0cf4..72b7ec8 100755 (executable)
--- a/borrower_message_preferences/add-missing.sh
+++ b/borrower_message_preferences/add-missing.sh
@@ -9,3 +9,10 @@ wc -l /dev/shm/[12]
 
 diff /dev/shm/[12] | grep '^< ' | cut -d' ' -f2 | xargs -i mysql -e 'insert into borrower_message_preferences (borrowernumber,message_attribute_id,days_in_advance) values ({},2,0),({},1,null),({},4,null),({},5,null),({},6,null) ;'
 
+mysql --batch -e 'select distinct borrower_message_preference_id from borrower_message_transport_preferences order by borrower_message_preference_id asc' koha_fer > /dev/shm/3
+
+mysql --batch -e 'select borrower_message_preference_id from borrower_message_preferences where message_attribute_id = 4 order by borrower_message_preference_id asc' > /dev/shm/4
+
+diff /dev/shm/[34] | grep '^> ' | cut -d' ' -f2 | xargs -i mysql -e "insert into borrower_message_transport_preferences (borrower_message_preference_id,message_transport_type) values ({},'email')"
+
+