From fdd2199d01c46416a9befb537d882d83836b6243 Mon Sep 17 00:00:00 2001 From: Guillaume Horel Date: Tue, 17 Sep 2013 21:44:00 -0400 Subject: 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 --- fix_database.sh | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100755 fix_database.sh (limited to 'fix_database.sh') 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