Skip to content

A platform for community discussion. Free, open, simple.

2.0 KB
Raw Blame
-- This file is auto-generated from the FilesDB schema. To make changes,
-- update the configuration files in "migrations/tooling/config/schema/" and then run
-- `migrations/bin/disco schema generate` to regenerate this file.

CREATE TABLE downloads
(
    id                TEXT NOT NULL PRIMARY KEY,
    original_filename TEXT NOT NULL
);


CREATE TABLE optimized_images
(
    id         INTEGER  PRIMARY KEY,
    created_at DATETIME,
    etag       TEXT,
    extension  TEXT     NOT NULL,
    filesize   INTEGER,
    height     INTEGER  NOT NULL,
    sha1       TEXT     NOT NULL,
    upload_id  INTEGER  NOT NULL,
    url        TEXT     NOT NULL,
    version    INTEGER,
    width      INTEGER  NOT NULL
);

CREATE INDEX idx_optimized_images_upload_id ON optimized_images (upload_id);

CREATE TABLE upload_results
(
    id           TEXT         NOT NULL PRIMARY KEY,
    file_type    ENUM_INTEGER,
    markdown     TEXT,
    skip_details TEXT,
    skip_reason  ENUM_TEXT,
    status       ENUM_TEXT    NOT NULL,
    upload_id    INTEGER
);

CREATE INDEX idx_upload_results_upload_id ON upload_results (upload_id) WHERE upload_id IS NOT NULL;

CREATE TABLE uploads
(
    id                           INTEGER  PRIMARY KEY,
    animated                     BOOLEAN,
    created_at                   DATETIME,
    dominant_color               TEXT,
    etag                         TEXT,
    extension                    TEXT,
    filesize                     INTEGER  NOT NULL,
    height                       INTEGER,
    origin                       TEXT,
    original_filename            TEXT     NOT NULL,
    original_sha1                TEXT,
    secure                       BOOLEAN,
    security_last_changed_at     DATETIME,
    security_last_changed_reason TEXT,
    sha1                         TEXT,
    thumbnail_height             INTEGER,
    thumbnail_width              INTEGER,
    url                          TEXT     NOT NULL,
    verification_status          INTEGER,
    width                        INTEGER
);