« Back to History
tasks.sql
|
20260722_120325.php
Initial Domain Snapshot
Copy Code
CREATE TABLE IF NOT EXISTS dev_sprints ( id BIGINT UNSIGNED PRIMARY KEY AUTO_INCREMENT, name VARCHAR(100) NOT NULL, start_date DATE NULL, end_date DATE NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE TABLE IF NOT EXISTS dev_tasks ( id BIGINT UNSIGNED PRIMARY KEY AUTO_INCREMENT, title VARCHAR(255) NOT NULL, description TEXT NULL, module VARCHAR(100) NULL, assignee BIGINT UNSIGNED NULL, points INT NOT NULL DEFAULT 1, due DATE NULL, status ENUM('todo','in_progress','review','done','archived') NOT NULL DEFAULT 'todo', sprint_id BIGINT UNSIGNED NULL, rank DECIMAL(12,6) NOT NULL DEFAULT 0, created_by BIGINT UNSIGNED NULL, updated_by BIGINT UNSIGNED NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP, INDEX (status, rank), INDEX (sprint_id), INDEX (assignee), INDEX (due) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE TABLE IF NOT EXISTS dev_history ( id BIGINT UNSIGNED PRIMARY KEY AUTO_INCREMENT, task_id BIGINT UNSIGNED NOT NULL, field VARCHAR(50) NOT NULL, old_value TEXT NULL, new_value TEXT NULL, changed_by BIGINT UNSIGNED NULL, changed_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, INDEX (task_id), INDEX (field) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE TABLE IF NOT EXISTS su_users ( id BIGINT UNSIGNED PRIMARY KEY AUTO_INCREMENT, name VARCHAR(100) NOT NULL, email VARCHAR(191) NOT NULL UNIQUE, password_hash VARCHAR(255) NOT NULL, role VARCHAR(20) NOT NULL DEFAULT 'Owner', created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, INDEX(email) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;