qshub / migrations /003_project_state.sql
basel00omar's picture
THE QS HUB v2.0 - Complete React + FastAPI Platform (clean deploy)
1b4b6d2
Raw History Blame Contribute Delete
446 Bytes
-- Create table for saving active project states
CREATE TABLE IF NOT EXISTS qto_active_projects (
id INT AUTO_INCREMENT PRIMARY KEY,
user_id INT NOT NULL,
current_step INT DEFAULT 1,
state_data JSON,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
FOREIGN KEY (user_id) REFERENCES qto_users(id) ON DELETE CASCADE,
UNIQUE KEY (user_id)
);