Differences
This shows you the differences between two versions of the page.
| — |
tech:others:limesurvey_notes [2014/11/15 09:13] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | ====== Notes on LimeSurvey ====== | ||
| + | ===== Table Structure ===== | ||
| + | ==== Tables with Survey Id - sid column name ==== | ||
| + | ^Column Name^Position^ | ||
| + | |lr_surveys|1| | ||
| + | |lr_survey_permissions|1| | ||
| + | |lr_assessments|2| | ||
| + | |lr_groups|2| | ||
| + | |lr_quota|2| | ||
| + | |lr_quota_members|2| | ||
| + | |lr_saved_control|2| | ||
| + | |lr_questions|3| | ||
| + | |||
| + | ==== Tables with Question Id - qid column name ==== | ||
| + | ^Column Name^Position^ | ||
| + | |lr_questions|1| | ||
| + | |lr_defaultvalues|1| | ||
| + | |lr_answers|1| | ||
| + | |lr_conditions|2| | ||
| + | |lr_question_attributes|2| | ||
| + | |lr_quota_members|3| | ||
| + | |||
| + | |||
| + | ==== Tables with Group Id - gid column name ==== | ||
| + | ^Column Name^Position^ | ||
| + | |lr_groups|1| | ||
| + | |lr_assessments|4| | ||
| + | |lr_questions|4| | ||
| + | |||
| + | ===== SQLs used to get Table Structure ===== | ||
| + | <code sql> | ||
| + | SELECT * FROM `COLUMNS` WHERE `TABLE_SCHEMA` = 'a22_limesurvey' and column_name = 'sid' | ||
| + | </code> | ||
| + | |||
| + | <code sql> | ||
| + | SELECT concat('|',table_name,'|',ORDINAL_POSITION,'|') FROM `COLUMNS` | ||
| + | WHERE `TABLE_SCHEMA` = 'a22_limesurvey' and column_name = 'gid' | ||
| + | order by COLUMN_KEY desc, ORDINAL_POSITION, TABLE_NAME | ||
| + | </code> | ||
| + | |||
| + | <code sql> | ||
| + | SELECT concat('|',table_name,'|') FROM `COLUMNS` WHERE `TABLE_SCHEMA` = 'a22_limesurvey' and column_name = 'qid' | ||
| + | </code> | ||
| + | |||
| + | <code sql> | ||
| + | select group_name, question, code, answer | ||
| + | from | ||
| + | lr_groups, lr_questions, lr_answers | ||
| + | where | ||
| + | lr_groups.gid = lr_questions.gid | ||
| + | and | ||
| + | lr_answers.qid = lr_questions.qid | ||
| + | and | ||
| + | lr_questions.sid = 88593 | ||
| + | order by group_order, question_order, sortorder | ||
| + | </code> | ||
| + | |||
| + | <code sql> | ||
| + | select group_name, question | ||
| + | from | ||
| + | lr_groups, lr_questions | ||
| + | where | ||
| + | lr_groups.gid = lr_questions.gid | ||
| + | and | ||
| + | lr_questions.sid = 88593 | ||
| + | order by group_order, question_order | ||
| + | </code> | ||
| + | |||
| + | <code sql> | ||
| + | </code> | ||
| + | |||
| + | <code sql> | ||
| + | </code> | ||
| + | |||
| + | <code sql> | ||
| + | </code> | ||
| + | |||
