aboutsummaryrefslogtreecommitdiff
path: root/resources/migrations/01.sql
blob: 1acccddaab999966ec904f8c0fddff9704ab2d32 (plain)
1
2
3
4
5
6
CREATE TABLE IF NOT EXISTS "books" (
    "id" TEXT PRIMARY KEY,
    "created_at" TEXT NOT NULL DEFAULT (datetime()),
    "updated_at" TEXT NOT NULL DEFAULT (datetime()),
    "data" BLOB NOT NULL
) STRICT;