Generally we do not support directly altering the database because circumventing the product's business rules can have unintended consequences. Before making any changes to the database we strongly recommended making a full backup first.
1A) You will need to upgrade to Checkbox first. Once you have done so you should be able to associate individual responses to users by altering the ckbx_Response table. For each response you would like to associate with a particular user you will need to ensure that the ckbx_Response.UniqueIdentifier is set to the user's UniqueIdentifier and that the RespondentGUID is set to null. You can find a user's UniqueIdentifier in the ckbx_Credential table.
2A) Deleting a question or altering the order of item options will result in the loss of all responses associated with that question. You can add additional questions with out impacting collected responses. It is our recommendation that you make a copy of the survey and edit the copy if you intended to make significant changes.
|