/
t3
/
s3-server
Обзор
Документация
Войти
/
t3
/
s3-server
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
CI/CD
Аналитика
master
internal/storage/sqlite/schema.sql
51 строка
1 KB
Ivan
migrations
17 июл 2026, 11:28
17 июл 2026, 11:28
8b5cc59
Код
Авторство
О чём код?
CREATE TABLE IF NOT EXISTS buckets ( name TEXT PRIMARY KEY, owner TEXT NOT NULL, created_at INTEGER NOT NULL ); CREATE TABLE IF NOT EXISTS objects ( bucket TEXT NOT NULL, key TEXT NOT NULL, hash TEXT NOT NULL, size INTEGER NOT NULL, content_type TEXT, disk_indexes TEXT, is_composite INTEGER DEFAULT 0, created_at INTEGER NOT NULL, updated_at INTEGER NOT NULL, deleted INTEGER DEFAULT 0, version_id TEXT, PRIMARY KEY (bucket, key), FOREIGN KEY (bucket) REFERENCES buckets(name) ON DELETE CASCADE ) WITHOUT ROWID; CREATE INDEX IF NOT EXISTS idx_objects_hash ON objects(hash); CREATE INDEX IF NOT EXISTS idx_objects_prefix ON objects(bucket, key) WHERE deleted = 0; CREATE TABLE IF NOT EXISTS multipart_uploads ( upload_id TEXT PRIMARY KEY, bucket TEXT NOT NULL, key TEXT NOT NULL, content_type TEXT, created_at INTEGER NOT NULL ); CREATE TABLE IF NOT EXISTS multipart_parts ( upload_id TEXT NOT NULL, part_number INTEGER NOT NULL, hash TEXT NOT NULL, size INTEGER NOT NULL, disk_indexes TEXT NOT NULL, PRIMARY KEY (upload_id, part_number) ); -- НОВАЯ ТАБЛИЦА для составных объектов CREATE TABLE IF NOT EXISTS object_parts ( object_hash TEXT NOT NULL, part_number INTEGER NOT NULL, hash TEXT NOT NULL, size INTEGER NOT NULL, disk_indexes TEXT NOT NULL, PRIMARY KEY (object_hash, part_number) );