#!/bin/bash # # Make a new empty database using the schema file # BASEDIR="$HOME/HPR/feed_watcher" DB="$BASEDIR/feedWatcher.db" SCHEMA="$BASEDIR/feedWatcher_schema.sql" if [[ -e $DB ]]; then rm -f "$DB" fi sqlite3 "$DB" < "$SCHEMA"