quickwrite

A simple Tsugi tool to prompt users to respond to short answer questions.

TO CONVERT THE SCHEMA FROM THE OLD QUICK WRITE:

qw_main

Rename SetID to qw_id and update primary key
Rename UserID to user_id and make not null
Make context_id not null
Make link_id not null
Rename Modified to modified

qw_questions -> qw_question

Move all data from qw_questions to qw_question into correct columns with new names

qw_answer

Rename AnswerID to answer_id
Rename UserID to user_id and make not null
Remove SetID
Rename QID to question_id and make not null
Rename Answer to answer_txt
Rename Modified to modified