blob: aa5ee697faa57c145a029ebe17f5129b1f3fedb0 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
|
-- =========================
-- Directories table
-- =========================
CREATE TABLE IF NOT EXISTS directories (
directory_id BIGSERIAL PRIMARY KEY,
path TEXT NOT NULL,
created_at TIMESTAMPTZ NOT NULL DEFAULT now(),
CONSTRAINT directories_path_unique UNIQUE (path)
);
-- =========================
-- Files table
-- =========================
CREATE TABLE IF NOT EXISTS files (
file_id BIGSERIAL PRIMARY KEY,
disc_channel_id VARCHAR(255) NOT NULL,
disc_message_id VARCHAR(255) NOT NULL,
directory_id BIGINT NOT NULL
REFERENCES directories(directory_id)
ON DELETE RESTRICT,
file_name TEXT NOT NULL,
file_description TEXT,
size BIGINT,
mime_type TEXT,
created_at TIMESTAMPTZ NOT NULL DEFAULT now(),
CONSTRAINT files_unique_name_per_directory
UNIQUE (directory_id, file_name)
);
-- =========================
-- Indexes
-- =========================
CREATE INDEX IF NOT EXISTS idx_directories_path
ON directories (path);
CREATE INDEX IF NOT EXISTS idx_files_directory
ON files (directory_id);
INSERT INTO directories (path)
VALUES ('')
ON CONFLICT (path) DO NOTHING;
|
