lemmy/migrations/2023-08-31-205559_add_image.../up.sql

11 lines
354 B
MySQL
Raw Permalink Normal View History

CREATE TABLE image_upload (
id serial PRIMARY KEY,
local_user_id int REFERENCES local_user ON UPDATE CASCADE ON DELETE CASCADE NOT NULL,
pictrs_alias text NOT NULL UNIQUE,
pictrs_delete_token text NOT NULL,
published timestamptz DEFAULT now() NOT NULL
);
CREATE INDEX idx_image_upload_local_user_id ON image_upload (local_user_id);