feedback

(mysql): SHOW TABLES

(mysql): CREATE TABLE mdl_feedback ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(10) unsigned NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL DEFAULT '', summary TEXT NOT NULL, anonymous TINYINT(1) unsigned NOT NULL DEFAULT 1, email_notification TINYINT(1) unsigned NOT NULL DEFAULT 1, multiple_submit TINYINT(1) unsigned NOT NULL DEFAULT 1, page_after_submit TEXT NOT NULL, publish_stats TINYINT(1) unsigned NOT NULL DEFAULT 0, timeopen BIGINT(10) unsigned NOT NULL DEFAULT 0, timeclose BIGINT(10) unsigned NOT NULL DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_feedback COMMENT='all feedbacks'

Success

(mysql): CREATE INDEX mdl_feed_cou_ix ON mdl_feedback (course)

Success

(mysql): CREATE TABLE mdl_feedback_template ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(10) unsigned NOT NULL DEFAULT 0, ispublic TINYINT(1) unsigned NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL DEFAULT '', CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_feedback_template COMMENT='templates of feedbackstructures'

Success

(mysql): CREATE INDEX mdl_feedtemp_cou_ix ON mdl_feedback_template (course)

Success

(mysql): CREATE TABLE mdl_feedback_item ( id BIGINT(10) unsigned NOT NULL auto_increment, feedback BIGINT(10) unsigned NOT NULL DEFAULT 0, template BIGINT(10) unsigned NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL DEFAULT '', presentation TEXT NOT NULL, typ VARCHAR(255) NOT NULL DEFAULT '', hasvalue TINYINT(1) unsigned NOT NULL DEFAULT 0, position SMALLINT(3) unsigned NOT NULL DEFAULT 0, required TINYINT(1) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_feedback_item COMMENT='feedback_items'

Success

(mysql): CREATE INDEX mdl_feeditem_fee_ix ON mdl_feedback_item (feedback)

Success

(mysql): CREATE INDEX mdl_feeditem_tem_ix ON mdl_feedback_item (template)

Success

(mysql): CREATE TABLE mdl_feedback_completed ( id BIGINT(10) unsigned NOT NULL auto_increment, feedback BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, random_response BIGINT(10) unsigned NOT NULL DEFAULT 0, anonymous_response TINYINT(1) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_feedback_completed COMMENT='filled out feedback'

Success

(mysql): CREATE INDEX mdl_feedcomp_use_ix ON mdl_feedback_completed (userid)

Success

(mysql): CREATE INDEX mdl_feedcomp_fee_ix ON mdl_feedback_completed (feedback)

Success

(mysql): CREATE TABLE mdl_feedback_completedtmp ( id BIGINT(10) unsigned NOT NULL auto_increment, feedback BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, guestid VARCHAR(255) NOT NULL DEFAULT '', timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, random_response BIGINT(10) unsigned NOT NULL DEFAULT 0, anonymous_response TINYINT(1) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_feedback_completedtmp COMMENT='filled out feedback'

Success

(mysql): CREATE INDEX mdl_feedcomp_use2_ix ON mdl_feedback_completedtmp (userid)

Success

(mysql): CREATE INDEX mdl_feedcomp_fee2_ix ON mdl_feedback_completedtmp (feedback)

Success

(mysql): CREATE TABLE mdl_feedback_value ( id BIGINT(10) unsigned NOT NULL auto_increment, course_id BIGINT(10) unsigned NOT NULL DEFAULT 0, item BIGINT(10) unsigned NOT NULL DEFAULT 0, completed BIGINT(10) unsigned NOT NULL DEFAULT 0, tmp_completed BIGINT(10) unsigned NOT NULL DEFAULT 0, value TEXT NOT NULL, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_feedback_value COMMENT='values of the completeds'

Success

(mysql): CREATE INDEX mdl_feedvalu_cou_ix ON mdl_feedback_value (course_id)

Success

(mysql): CREATE INDEX mdl_feedvalu_ite_ix ON mdl_feedback_value (item)

Success

(mysql): CREATE TABLE mdl_feedback_valuetmp ( id BIGINT(10) unsigned NOT NULL auto_increment, course_id BIGINT(10) unsigned NOT NULL DEFAULT 0, item BIGINT(10) unsigned NOT NULL DEFAULT 0, completed BIGINT(10) unsigned NOT NULL DEFAULT 0, tmp_completed BIGINT(10) unsigned NOT NULL DEFAULT 0, value TEXT NOT NULL, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_feedback_valuetmp COMMENT='values of the completedstmp'

Success

(mysql): CREATE INDEX mdl_feedvalu_cou2_ix ON mdl_feedback_valuetmp (course_id)

Success

(mysql): CREATE INDEX mdl_feedvalu_ite2_ix ON mdl_feedback_valuetmp (item)

Success

(mysql): CREATE TABLE mdl_feedback_tracking ( id BIGINT(10) unsigned NOT NULL auto_increment, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, feedback BIGINT(10) unsigned NOT NULL DEFAULT 0, completed BIGINT(10) unsigned NOT NULL DEFAULT 0, tmp_completed BIGINT(10) unsigned NOT NULL DEFAULT 0, count BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_feedback_tracking COMMENT='feedback trackingdata'

Success

(mysql): CREATE INDEX mdl_feedtrac_use_ix ON mdl_feedback_tracking (userid)

Success

(mysql): CREATE INDEX mdl_feedtrac_fee_ix ON mdl_feedback_tracking (feedback)

Success

(mysql): CREATE INDEX mdl_feedtrac_com_ix ON mdl_feedback_tracking (completed)

Success

(mysql): CREATE TABLE mdl_feedback_sitecourse_map ( id BIGINT(10) unsigned NOT NULL auto_increment, feedbackid BIGINT(10) unsigned NOT NULL DEFAULT 0, courseid BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

Success

(mysql): ALTER TABLE mdl_feedback_sitecourse_map COMMENT='feedback sitecourse map'

Success

(mysql): CREATE INDEX mdl_feedsitemap_cou_ix ON mdl_feedback_sitecourse_map (courseid)

Success

(mysql): CREATE INDEX mdl_feedsitemap_fee_ix ON mdl_feedback_sitecourse_map (feedbackid)

Success

feedback tables have been set up correctly