aboutsummaryrefslogtreecommitdiffstats
path: root/fix_database.sh
diff options
context:
space:
mode:
Diffstat (limited to 'fix_database.sh')
-rwxr-xr-xfix_database.sh7
1 files changed, 7 insertions, 0 deletions
diff --git a/fix_database.sh b/fix_database.sh
new file mode 100755
index 0000000..3427233
--- /dev/null
+++ b/fix_database.sh
@@ -0,0 +1,7 @@
+#!/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