diff options
Diffstat (limited to 'internal/db/migrations/control')
| -rw-r--r-- | internal/db/migrations/control/00002_upload_limit.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/internal/db/migrations/control/00002_upload_limit.sql b/internal/db/migrations/control/00002_upload_limit.sql new file mode 100644 index 0000000..9a1ec90 --- /dev/null +++ b/internal/db/migrations/control/00002_upload_limit.sql @@ -0,0 +1,6 @@ +-- +goose Up +-- Per-blog upload limit set by the superadmin; NULL means the server default (MAX_UPLOAD_MB). +ALTER TABLE blogs ADD COLUMN max_upload_bytes bigint CHECK (max_upload_bytes IS NULL OR max_upload_bytes > 0); + +-- +goose Down +ALTER TABLE blogs DROP COLUMN max_upload_bytes; |