000017_add_file_info.up.sql

TLDR

This file creates a table called file_info in the database, with columns to store file information such as ID, creation time, deletion time, name, extension, size, and archived flag.

END

CREATE TABLE IF NOT EXISTS {{.prefix}}file_info (
    id varchar(26) NOT NULL,
    create_at BIGINT NOT NULL,
    delete_at BIGINT,
    name TEXT NOT NULL,
    extension VARCHAR(50) NOT NULL,
    size BIGINT NOT NULL,
    archived BOOLEAN
) {{if .mysql}}DEFAULT CHARACTER SET utf8mb4{{end}};