Hugging Face's logo

Spaces:
Jaimodiji
/
Report-Generator
Runtime error

App Files Community
Report-Generator / migrations /add_v3_fields.sql
Jaimodiji's picture
Jaimodiji
Upload folder using huggingface_hub
c001f24
Raw History Blame Contribute Delete
821 Bytes
-- Add new columns to the 'questions' table
ALTER TABLE questions ADD COLUMN topic TEXT;
ALTER TABLE questions ADD COLUMN time_taken INTEGER;
ALTER TABLE questions ADD COLUMN difficulty TEXT;
ALTER TABLE questions ADD COLUMN source TEXT DEFAULT 'manual';
ALTER TABLE questions ADD COLUMN test_id TEXT;
ALTER TABLE questions ADD COLUMN test_mapping_id TEXT;
-- Add new columns to the 'sessions' table
ALTER TABLE sessions ADD COLUMN test_id TEXT;
ALTER TABLE sessions ADD COLUMN test_mapping_id TEXT;
ALTER TABLE sessions ADD COLUMN source TEXT DEFAULT 'manual';
ALTER TABLE sessions ADD COLUMN metadata TEXT;
-- Create indexes for performance
CREATE INDEX IF NOT EXISTS idx_questions_test_mapping_id ON questions (test_mapping_id);
CREATE INDEX IF NOT EXISTS idx_sessions_test_mapping_id ON sessions (test_mapping_id);