init.sh (461B)
1 #!/bin/bash 2 3 DIR="$( cd "$( dirname "${BASH_SOURCE[0]}" )" >/dev/null 2>&1 && pwd )" 4 cd "$DIR" 5 6 if [ -f remailback.sqlite ] 7 then 8 echo "Database already exists -- not initializing" 9 exit 1 10 fi 11 12 echo "CREATE TABLE reminders(id INTEGER PRIMARY KEY AUTOINCREMENT, sendtime INTEGER, createtime INTEGER, messageid TEXT, filename TEXT, explanation TEXT, status TEXT);" | sqlite3 remailback.sqlite 13 14 mkdir -p sent sent_reminders scheduled scheduled_reminders deleted 15