src/db/migrations/02-strict-tables.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

ALTER TABLE "files" RENAME TO "files_non_strict";

CREATE TABLE IF NOT EXISTS "files" (
    id TEXT PRIMARY KEY,
    created_at TEXT NOT NULL,
    expires_at TEXT NOT NULL,
    filename TEXT NOT NULL,
    content_length INTEGER NOT NULL
) STRICT;

INSERT INTO files (id, created_at, expires_at, filename, content_length)
  SELECT id, created_at, expires_at, filename, content_length
  FROM files_non_strict;

DROP TABLE files_non_strict;