This topic is locked

Clone a Survey in the Survey Template

7/8/2016 3:10:22 PM
PHPRunner Tips and Tricks
K
klyle author

Clone the questions table to _1 per http://stackoverflow.com/questions/3280006/duplicating-a-mysql-table-indexes-and-data
Increment the IDs in the new table

Increment the Sid in the new table
insert into sv_questions SELECT * FROM sv_questions_1
Create the second survey. - instantly, the questions are available. Now the first survey can be activated, while development continues on the next version.
Enjoy!
N.B. This is NOT complete. There are some tables not included in these instructions....feel free to improve on this and post it below.