questionnaire

(mysql): SHOW TABLES

(mysql): CREATE TABLE mdl_questionnaire ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(11) unsigned NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL DEFAULT '', summary TEXT NOT NULL, qtype BIGINT(10) NOT NULL DEFAULT 0, respondenttype enum('fullname', 'anonymous') NOT NULL DEFAULT 'fullname', resp_eligible enum('all', 'students', 'teachers') NOT NULL DEFAULT 'all', resp_view TINYINT(2) unsigned NOT NULL DEFAULT 0, opendate BIGINT(10) unsigned NOT NULL DEFAULT 0, closedate BIGINT(10) unsigned NOT NULL DEFAULT 0, resume TINYINT(2) unsigned NOT NULL DEFAULT 0, navigate TINYINT(2) unsigned NOT NULL DEFAULT 0, grade BIGINT(10) NOT NULL DEFAULT 0, sid BIGINT(11) unsigned NOT NULL DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Èxit

(mysql): ALTER TABLE mdl_questionnaire COMMENT='Main questionnaire table.'

Èxit

(mysql): CREATE INDEX mdl_ques_sid_ix ON mdl_questionnaire (sid)

Èxit

(mysql): CREATE TABLE mdl_questionnaire_survey ( id BIGINT(10) unsigned NOT NULL auto_increment, name VARCHAR(64) NOT NULL DEFAULT '', owner VARCHAR(16) NOT NULL DEFAULT '', realm VARCHAR(64) NOT NULL DEFAULT '', status BIGINT(10) unsigned NOT NULL DEFAULT 0, title VARCHAR(255) NOT NULL DEFAULT '', email VARCHAR(255) DEFAULT NULL, subtitle TEXT, info TEXT, theme VARCHAR(64) DEFAULT NULL, thanks_page VARCHAR(255) DEFAULT NULL, thank_head VARCHAR(255) DEFAULT NULL, thank_body TEXT, CONSTRAINT PRIMARY KEY (id) )

Èxit

(mysql): ALTER TABLE mdl_questionnaire_survey COMMENT='questionnaire_survey table retrofitted from MySQL'

Èxit

(mysql): CREATE INDEX mdl_quessurv_nam_ix ON mdl_questionnaire_survey (name)

Èxit

(mysql): CREATE INDEX mdl_quessurv_own_ix ON mdl_questionnaire_survey (owner)

Èxit

(mysql): CREATE TABLE mdl_questionnaire_attempts ( id BIGINT(11) unsigned NOT NULL auto_increment, qid BIGINT(11) unsigned NOT NULL DEFAULT 0, userid BIGINT(11) unsigned NOT NULL DEFAULT 0, rid BIGINT(10) unsigned NOT NULL DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Èxit

(mysql): ALTER TABLE mdl_questionnaire_attempts COMMENT='questionnaire_attempts table retrofitted from MySQL'

Èxit

(mysql): CREATE TABLE mdl_questionnaire_question ( id BIGINT(10) unsigned NOT NULL auto_increment, survey_id BIGINT(10) unsigned NOT NULL DEFAULT 0, name VARCHAR(30) DEFAULT NULL, type_id BIGINT(10) unsigned NOT NULL DEFAULT 0, result_id BIGINT(10) unsigned DEFAULT NULL, length BIGINT(11) unsigned NOT NULL DEFAULT 0, precise BIGINT(11) unsigned NOT NULL DEFAULT 0, position BIGINT(10) unsigned NOT NULL DEFAULT 0, content TEXT NOT NULL, required enum('y', 'n') NOT NULL DEFAULT 'n', deleted enum('y', 'n') NOT NULL DEFAULT 'n', CONSTRAINT PRIMARY KEY (id) )

Èxit

(mysql): ALTER TABLE mdl_questionnaire_question COMMENT='questionnaire_question table retrofitted from MySQL'

Èxit

(mysql): CREATE TABLE mdl_questionnaire_quest_choice ( id BIGINT(10) unsigned NOT NULL auto_increment, question_id BIGINT(10) unsigned NOT NULL DEFAULT 0, content TEXT NOT NULL, value TEXT, CONSTRAINT PRIMARY KEY (id) )

Èxit

(mysql): ALTER TABLE mdl_questionnaire_quest_choice COMMENT='questionnaire_quest_choice table retrofitted from MySQL'

Èxit

(mysql): CREATE TABLE mdl_questionnaire_question_type ( id BIGINT(10) unsigned NOT NULL auto_increment, typeid BIGINT(10) unsigned NOT NULL DEFAULT 0, type VARCHAR(32) NOT NULL DEFAULT '', has_choices enum('y', 'n') NOT NULL DEFAULT 'y', response_table VARCHAR(32) DEFAULT NULL, CONSTRAINT PRIMARY KEY (id) )

Èxit

(mysql): ALTER TABLE mdl_questionnaire_question_type COMMENT='questionnaire_question_type table retrofitted from MySQL'

Èxit

(mysql): CREATE UNIQUE INDEX mdl_quesquestype_typ_uix ON mdl_questionnaire_question_type (typeid)

Èxit

(mysql): CREATE TABLE mdl_questionnaire_response ( id BIGINT(10) unsigned NOT NULL auto_increment, survey_id BIGINT(10) unsigned NOT NULL DEFAULT 0, submitted BIGINT(10) unsigned NOT NULL DEFAULT 0, complete enum('y', 'n') NOT NULL DEFAULT 'n', grade BIGINT(10) NOT NULL DEFAULT 0, username VARCHAR(64) DEFAULT NULL, CONSTRAINT PRIMARY KEY (id) )

Èxit

(mysql): ALTER TABLE mdl_questionnaire_response COMMENT='questionnaire_response table retrofitted from MySQL'

Èxit

(mysql): CREATE TABLE mdl_questionnaire_response_bool ( id BIGINT(11) unsigned NOT NULL auto_increment, response_id BIGINT(10) unsigned NOT NULL DEFAULT 0, question_id BIGINT(10) unsigned NOT NULL DEFAULT 0, choice_id enum('y', 'n') NOT NULL DEFAULT 'y', CONSTRAINT PRIMARY KEY (id) )

Èxit

(mysql): ALTER TABLE mdl_questionnaire_response_bool COMMENT='questionnaire_response_bool table retrofitted from MySQL'

Èxit

(mysql): CREATE INDEX mdl_quesrespbool_resque_ix ON mdl_questionnaire_response_bool (response_id, question_id)

Èxit

(mysql): CREATE TABLE mdl_questionnaire_response_date ( id BIGINT(11) unsigned NOT NULL auto_increment, response_id BIGINT(10) unsigned NOT NULL DEFAULT 0, question_id BIGINT(10) unsigned NOT NULL DEFAULT 0, response TEXT, CONSTRAINT PRIMARY KEY (id) )

Èxit

(mysql): ALTER TABLE mdl_questionnaire_response_date COMMENT='questionnaire_response_date table retrofitted from MySQL'

Èxit

(mysql): CREATE INDEX mdl_quesrespdate_resque_ix ON mdl_questionnaire_response_date (response_id, question_id)

Èxit

(mysql): CREATE TABLE mdl_questionnaire_resp_multiple ( id BIGINT(10) unsigned NOT NULL auto_increment, response_id BIGINT(10) unsigned NOT NULL DEFAULT 0, question_id BIGINT(10) unsigned NOT NULL DEFAULT 0, choice_id BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Èxit

(mysql): ALTER TABLE mdl_questionnaire_resp_multiple COMMENT='questionnaire_resp_multiple table retrofitted from MySQL'

Èxit

(mysql): CREATE INDEX mdl_quesrespmult_resquecho_ix ON mdl_questionnaire_resp_multiple (response_id, question_id, choice_id)

Èxit

(mysql): CREATE TABLE mdl_questionnaire_response_other ( id BIGINT(11) unsigned NOT NULL auto_increment, response_id BIGINT(10) unsigned NOT NULL DEFAULT 0, question_id BIGINT(10) unsigned NOT NULL DEFAULT 0, choice_id BIGINT(10) unsigned NOT NULL DEFAULT 0, response TEXT, CONSTRAINT PRIMARY KEY (id) )

Èxit

(mysql): ALTER TABLE mdl_questionnaire_response_other COMMENT='questionnaire_response_other table retrofitted from MySQL'

Èxit

(mysql): CREATE INDEX mdl_quesrespothe_resquecho_ix ON mdl_questionnaire_response_other (response_id, question_id, choice_id)

Èxit

(mysql): CREATE TABLE mdl_questionnaire_response_rank ( id BIGINT(11) unsigned NOT NULL auto_increment, response_id BIGINT(10) unsigned NOT NULL DEFAULT 0, question_id BIGINT(10) unsigned NOT NULL DEFAULT 0, choice_id BIGINT(10) unsigned NOT NULL DEFAULT 0, rank BIGINT(11) NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Èxit

(mysql): ALTER TABLE mdl_questionnaire_response_rank COMMENT='questionnaire_response_rank table retrofitted from MySQL'

Èxit

(mysql): CREATE INDEX mdl_quesresprank_resquecho_ix ON mdl_questionnaire_response_rank (response_id, question_id, choice_id)

Èxit

(mysql): CREATE TABLE mdl_questionnaire_resp_single ( id BIGINT(11) unsigned NOT NULL auto_increment, response_id BIGINT(10) unsigned NOT NULL DEFAULT 0, question_id BIGINT(10) unsigned NOT NULL DEFAULT 0, choice_id BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Èxit

(mysql): ALTER TABLE mdl_questionnaire_resp_single COMMENT='questionnaire_resp_single table retrofitted from MySQL'

Èxit

(mysql): CREATE INDEX mdl_quesrespsing_resque_ix ON mdl_questionnaire_resp_single (response_id, question_id)

Èxit

(mysql): CREATE TABLE mdl_questionnaire_response_text ( id BIGINT(11) unsigned NOT NULL auto_increment, response_id BIGINT(10) unsigned NOT NULL DEFAULT 0, question_id BIGINT(10) unsigned NOT NULL DEFAULT 0, response TEXT, CONSTRAINT PRIMARY KEY (id) )

Èxit

(mysql): ALTER TABLE mdl_questionnaire_response_text COMMENT='questionnaire_response_text table retrofitted from MySQL'

Èxit

(mysql): CREATE INDEX mdl_quesresptext_resque_ix ON mdl_questionnaire_response_text (response_id, question_id)

Èxit

(mysql): INSERT INTO mdl_questionnaire_question_type(typeid, type, has_choices, response_table) VALUES ('1', 'Yes/No', 'n', 'response_bool')

Èxit

(mysql): INSERT INTO mdl_questionnaire_question_type(typeid, type, has_choices, response_table) VALUES ('2', 'Text Box', 'n', 'response_text')

Èxit

(mysql): INSERT INTO mdl_questionnaire_question_type(typeid, type, has_choices, response_table) VALUES ('3', 'Essay Box', 'n', 'response_text')

Èxit

(mysql): INSERT INTO mdl_questionnaire_question_type(typeid, type, has_choices, response_table) VALUES ('4', 'Radio Buttons', 'y', 'resp_single')

Èxit

(mysql): INSERT INTO mdl_questionnaire_question_type(typeid, type, has_choices, response_table) VALUES ('5', 'Check Boxes', 'y', 'resp_multiple')

Èxit

(mysql): INSERT INTO mdl_questionnaire_question_type(typeid, type, has_choices, response_table) VALUES ('6', 'Dropdown Box', 'y', 'resp_single')

Èxit

(mysql): INSERT INTO mdl_questionnaire_question_type(typeid, type, has_choices, response_table) VALUES ('8', 'Rate (scale 1..5)', 'y', 'response_rank')

Èxit

(mysql): INSERT INTO mdl_questionnaire_question_type(typeid, type, has_choices, response_table) VALUES ('9', 'Date', 'n', 'response_date')

Èxit

(mysql): INSERT INTO mdl_questionnaire_question_type(typeid, type, has_choices, response_table) VALUES ('10', 'Numeric', 'n', 'response_text')

Èxit

(mysql): INSERT INTO mdl_questionnaire_question_type(typeid, type, has_choices, response_table) VALUES ('99', 'Page Break', 'n', '')

Èxit

(mysql): INSERT INTO mdl_questionnaire_question_type(typeid, type, has_choices, response_table) VALUES ('100', 'Section Text', 'n', '')

Èxit

S'han configurat correctament les taules questionnaire