Spaces:
Running
Running
File size: 821 Bytes
c001f24 |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
-- 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);
|