| set -e | |
| DIR="$(pwd)/data" | |
| DB="$DIR/nexova.db" | |
| mkdir -p "$DIR" | |
| if [ ! -f "$DB" ] || [ ! -s "$DB" ]; then | |
| rm -f "$DB" | |
| sqlite3 "$DB" <<'SQL' | |
| CREATE TABLE IF NOT EXISTS "notes" ( | |
| "id" TEXT NOT NULL PRIMARY KEY, | |
| "title" TEXT NOT NULL, | |
| "content" TEXT NOT NULL DEFAULT '', | |
| "color" TEXT NOT NULL DEFAULT '#fef08a', | |
| "pinned" BOOLEAN NOT NULL DEFAULT false, | |
| "created_at" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, | |
| "updated_at" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP | |
| ); | |
| SQL | |
| echo "[init] db created ($(wc -c < "$DB") bytes)" | |
| else | |
| echo "[init] db exists ($(wc -c < "$DB") bytes)" | |
| fi | |