#!/bin/bash
echo '.dump'|sqlite3 famille.db>famille.sql
sed -i -e 's/string/text/' \
       -e 's/address_line1/address\_line1 text/' \
       -e 's/address_line2/address\_line2 text/' \
       -e 's/address_city_line/address_city_line text/' famille.sql
sqlite3 famille-fixed.db<famille.sql