36 lines
841 B
SQL
36 lines
841 B
SQL
-- +goose Up
|
|
-- +goose StatementBegin
|
|
-- create medias table
|
|
CREATE TABLE medias (
|
|
id SERIAL8 PRIMARY KEY,
|
|
created_at timestamp NOT NULL default now(),
|
|
storage_id INT8 NOT NULL,
|
|
hash VARCHAR(32) NOT NULL,
|
|
name VARCHAR(255) NOT NULL default '',
|
|
mime_type VARCHAR(128) NOT NULL default '',
|
|
size INT8 NOT NULL default 0,
|
|
path VARCHAR(255) NOT NULL default ''
|
|
);
|
|
|
|
-- index
|
|
CREATE UNIQUE INDEX medias_hash_idx ON medias (hash);
|
|
|
|
|
|
-- user medias
|
|
CREATE TABLE user_medias (
|
|
id SERIAL8 PRIMARY KEY,
|
|
created_at timestamp NOT NULL default now(),
|
|
updated_at timestamp NOT NULL default now(),
|
|
|
|
tenant_id INT8 NOT NULL,
|
|
user_id INT8 NOT NULL,
|
|
media_id INT8 NOT NULL
|
|
)
|
|
-- +goose StatementEnd
|
|
|
|
-- +goose Down
|
|
-- +goose StatementBegin
|
|
DROP TABLE medias;
|
|
DROP TABLE user_medias;
|
|
-- +goose StatementEnd
|