kemono2/db/migrations/20240120_00_TID85-password-field-for-files.py

18 lines
292 B
Python
Raw Permalink Normal View History

2024-07-04 22:08:17 +02:00
"""
Add table to keep track of files passwords
"""
from yoyo import step
__depends__ = {'20231123_00_OFL42-unapproved-dms-and-dms-remade'}
steps = [
step("""
CREATE TABLE archive_files (
file_id int NOT NULL REFERENCES files (id),
files TEXT[] NOT NULL,
password TEXT
);
"""),
]