/
Sergei777333
/
TaskTrecker
Обзор
Документация
Войти
/
Sergei777333
/
TaskTrecker
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
main
base.sql
30 строк
1022 B
Lesnik
TaskTrecker
07 авг 2026, 21:52
07 авг 2026, 21:52
5fb2241
Код
Авторство
О чём код?
CREATE TABLE Users ( user_id INTEGER PRIMARY KEY AUTOINCREMENT, username TEXT NOT NULL, email TEXT UNIQUE NOT NULL, created_at TEXT DEFAULT CURRENT_TIMESTAMP ); CREATE TABLE Projects ( project_id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL, description TEXT NOT NULL, created_at TEXT DEFAULT CURRENT_TIMESTAMP ); CREATE TABLE Tasks ( task_id INTEGER PRIMARY KEY AUTOINCREMENT, title TEXT NOT NULL, description TEXT NOT NULL, status TEXT CHECK(status IN ('todo', 'in_progress', 'done')), priority TEXT CHECK(priority IN ('low', 'medium', 'high')), deadline TEXT NOT NULL, created_at TEXT DEFAULT CURRENT_TIMESTAMP, updated_at TEXT DEFAULT CURRENT_TIMESTAMP, project_id INTEGER, assigned_to INTEGER, FOREIGN KEY (project_id) REFERENCES Projects(project_id) ON DELETE CASCADE, FOREIGN KEY (assigned_to) REFERENCES Users(user_id) ON DELETE SET NULL ); CREATE INDEX idx_tasks_assigned_status ON Tasks(assigned_to, status);