oleggorfinkel wrote: So, what would be the "right" design?

The typical design is distributed via different tables with a maptable.

Depending on additional features, you end up with a handful of tables.

To get an impression, take a look at this here:
www.sawtoothsoftware.com/help/lighthouse...d_web_howstored.html

Long answer code : bugs.limesurvey.org/view.php?id=7593#c52401

@ollehar open a mantis issue about separate database (in some condition)

I don't find it

jelo wrote:

oleggorfinkel wrote: So, what would be the "right" design?

The typical design is distributed via different tables with a maptable.

Depending on additional features, you end up with a handful of tables.

To get an impression, take a look at this here:
www.sawtoothsoftware.com/help/lighthouse...d_web_howstored.html

Yes, that's exactly what I was talking about as option #1 in my previous message.

I need to manually override the answer code length this for one of my surveys.

I see the table _answers has the column code varchar(5). I need to change this to varchar(.

When I change it, I see that LS still restricts the length to varchar(5), so I'm guessing somewhere in the LS codebase, the max length of _answers.code is defined?

Can anyone point me to the location where max length of 5 is defined, so I can override it to 8?

Digging a bit deeper into this, I've tested with these changes, and it appears to work:

/application/views/admin/survey/Question/subquestionsAndAnswers/_answer_option.twig : ln #53

/application/models/Answer.php : ln #75

/application/views/admin/labels/_labelviewtabcontent_view.php : ln #47

And update database columns:

ALTER TABLE `lime_answers` CHANGE `code` `code` VARCHAR(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '';

ALTER TABLE `lime_labels` CHANGE `code` `code` VARCHAR(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '';