qv

(mysql): SHOW TABLES

(mysql): CREATE TABLE mdl_qv ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(10) unsigned NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL DEFAULT '', description TEXT, assessmenturl VARCHAR(255) NOT NULL DEFAULT '', skin VARCHAR(20) NOT NULL DEFAULT '', assessmentlang VARCHAR(10) NOT NULL DEFAULT 'ca', maxdeliver SMALLINT(3) NOT NULL DEFAULT -1, showcorrection TINYINT(1) NOT NULL DEFAULT 1, showinteraction TINYINT(1) NOT NULL DEFAULT 1, ordersections TINYINT(1) DEFAULT 0, orderitems TINYINT(1) DEFAULT 0, target VARCHAR(10) NOT NULL DEFAULT 'self', maxgrade NUMERIC(10) unsigned DEFAULT NULL, width VARCHAR(10) DEFAULT NULL, height VARCHAR(10) DEFAULT NULL, CONSTRAINT PRIMARY KEY (id) )

Èxit

(mysql): ALTER TABLE mdl_qv COMMENT='Main information about each assessment'

Èxit

(mysql): CREATE INDEX mdl_qv_cou_ix ON mdl_qv (course)

Èxit

(mysql): CREATE TABLE mdl_qv_assignments ( id BIGINT(10) unsigned NOT NULL auto_increment, qvid BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, sectionorder BIGINT(10) unsigned NOT NULL DEFAULT 0, itemorder BIGINT(10) unsigned NOT NULL DEFAULT 0, idnumber VARCHAR(100) DEFAULT '', CONSTRAINT PRIMARY KEY (id) )

Èxit

(mysql): ALTER TABLE mdl_qv_assignments COMMENT='Stores user assignments for each course'

Èxit

(mysql): CREATE INDEX mdl_qvassi_use_ix ON mdl_qv_assignments (userid)

Èxit

(mysql): CREATE INDEX mdl_qvassi_qvi_ix ON mdl_qv_assignments (qvid)

Èxit

(mysql): CREATE TABLE mdl_qv_sections ( id BIGINT(10) unsigned NOT NULL auto_increment, assignmentid BIGINT(10) unsigned NOT NULL DEFAULT 0, sectionid VARCHAR(255) DEFAULT NULL, responses TEXT, scores TEXT, pending_scores TEXT, attempts MEDIUMINT(6) unsigned DEFAULT 0, state TINYINT(1) unsigned DEFAULT 0, time VARCHAR(8) NOT NULL DEFAULT '00:00:00', CONSTRAINT PRIMARY KEY (id) )

Èxit

(mysql): ALTER TABLE mdl_qv_sections COMMENT='Stores all user assignment sections'

Èxit

(mysql): CREATE INDEX mdl_qvsect_ass_ix ON mdl_qv_sections (assignmentid)

Èxit

(mysql): CREATE TABLE mdl_qv_messages ( id BIGINT(10) unsigned NOT NULL auto_increment, sid BIGINT(10) unsigned NOT NULL, itemid VARCHAR(255) NOT NULL DEFAULT '', userid BIGINT(10) unsigned NOT NULL, created BIGINT(10) unsigned DEFAULT NULL, message TEXT, CONSTRAINT PRIMARY KEY (id) )

Èxit

(mysql): ALTER TABLE mdl_qv_messages COMMENT='Stores user messages for each assignment'

Èxit

(mysql): CREATE INDEX mdl_qvmess_sid_ix ON mdl_qv_messages (sid)

Èxit

(mysql): CREATE TABLE mdl_qv_messages_read ( id BIGINT(10) unsigned NOT NULL auto_increment, sid BIGINT(10) unsigned NOT NULL, userid BIGINT(10) unsigned NOT NULL, timereaded BIGINT(10) unsigned DEFAULT NULL, CONSTRAINT PRIMARY KEY (id) )

Èxit

(mysql): ALTER TABLE mdl_qv_messages_read COMMENT='Stores user control access to messages'

Èxit

(mysql): CREATE INDEX mdl_qvmessread_sid_ix ON mdl_qv_messages_read (sid)

Èxit

S'han configurat correctament les taules qv