Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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>​
 +
  

QR Code
QR Code tech:others:limesurvey_notes (generated for current page)