search

CCALI / quizwright

CALI QuizWright :: a quiz builder and formative assessment tool
GNU General Public License v2.0
1 stars 0 forks source link

Change data column in page table to JSON data-type #122

Closed emasters closed 5 years ago

emasters commented 6 years ago

ALTER TABLE page MODIFY data JSON seems to do the trick but testing of PHP codes need to be done..

emasters commented 6 years ago

This is going to work but will require some rewriting especially of SELECT queries. Important to note it is a one way street. Once the conversion to JSON is done the data column cannot be converted back to longtext. Pushing to September 2018.