Update schema of the database

since sqlite3 doesn't have support for alter besides renaming a table
we use some sed fu to fix the dump

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