jclic

(mysql): SHOW TABLES

(mysql): CREATE TABLE mdl_jclic ( id BIGINT(10) unsigned NOT NULL auto_increment, course BIGINT(10) unsigned NOT NULL DEFAULT 0, name VARCHAR(255) NOT NULL DEFAULT '', description TEXT, url VARCHAR(255) NOT NULL DEFAULT '', skin VARCHAR(20) NOT NULL DEFAULT '', maxattempts SMALLINT(3) DEFAULT 0, width MEDIUMINT(5) unsigned DEFAULT 600, height MEDIUMINT(5) unsigned DEFAULT 400, avaluation VARCHAR(10) DEFAULT NULL, maxgrade VARCHAR(15) DEFAULT NULL, lang VARCHAR(10) DEFAULT NULL, exiturl VARCHAR(255) DEFAULT NULL, CONSTRAINT PRIMARY KEY (id) )

Èxit

(mysql): ALTER TABLE mdl_jclic COMMENT='Main information about each jclic activity'

Èxit

(mysql): CREATE INDEX mdl_jcli_cou_ix ON mdl_jclic (course)

Èxit

(mysql): CREATE TABLE mdl_jclic_sessions ( id BIGINT(10) unsigned NOT NULL auto_increment, jclicid BIGINT(10) unsigned NOT NULL DEFAULT 0, session_id VARCHAR(50) NOT NULL DEFAULT '', user_id VARCHAR(50) NOT NULL DEFAULT '0', session_datetime DATETIME NOT NULL, project_name VARCHAR(100) NOT NULL DEFAULT '', session_key VARCHAR(50) DEFAULT NULL, session_code VARCHAR(50) DEFAULT NULL, session_context VARCHAR(50) DEFAULT NULL, CONSTRAINT PRIMARY KEY (id) )

Èxit

(mysql): ALTER TABLE mdl_jclic_sessions COMMENT='Main information about each jclic session'

Èxit

(mysql): CREATE UNIQUE INDEX mdl_jclisess_ses_uix ON mdl_jclic_sessions (session_id)

Èxit

(mysql): CREATE INDEX mdl_jclisess_use_ix ON mdl_jclic_sessions (user_id)

Èxit

(mysql): CREATE INDEX mdl_jclisess_jcl_ix ON mdl_jclic_sessions (jclicid)

Èxit

(mysql): CREATE TABLE mdl_jclic_activities ( id BIGINT(10) unsigned NOT NULL auto_increment, session_id VARCHAR(50) NOT NULL DEFAULT '', activity_id MEDIUMINT(5) unsigned NOT NULL DEFAULT 0, activity_name VARCHAR(50) NOT NULL DEFAULT '', num_actions SMALLINT(4) unsigned DEFAULT NULL, score SMALLINT(4) unsigned DEFAULT NULL, activity_solved TINYINT(1) unsigned DEFAULT NULL, qualification SMALLINT(3) unsigned DEFAULT NULL, total_time MEDIUMINT(5) unsigned DEFAULT NULL, activity_code VARCHAR(50) DEFAULT NULL, CONSTRAINT PRIMARY KEY (id) )

Èxit

(mysql): ALTER TABLE mdl_jclic_activities COMMENT='Stores user information for each jclic activity'

Èxit

(mysql): CREATE INDEX mdl_jcliacti_ses_ix ON mdl_jclic_activities (session_id)

Èxit

(mysql): CREATE TABLE mdl_jclic_settings ( setting_key VARCHAR(255) NOT NULL DEFAULT '', setting_value VARCHAR(255) NOT NULL DEFAULT '', CONSTRAINT PRIMARY KEY (setting_key) )

Èxit

(mysql): ALTER TABLE mdl_jclic_settings COMMENT='Stores settings information'

Èxit

(mysql): CREATE TABLE mdl_jclic_groups ( id BIGINT(10) unsigned NOT NULL auto_increment, group_id VARCHAR(50) NOT NULL DEFAULT '', group_name VARCHAR(80) NOT NULL DEFAULT '', group_description VARCHAR(255) DEFAULT NULL, group_icon VARCHAR(255) DEFAULT NULL, group_code VARCHAR(50) DEFAULT NULL, group_keywords VARCHAR(255) DEFAULT NULL, CONSTRAINT PRIMARY KEY (id) )

Èxit

(mysql): ALTER TABLE mdl_jclic_groups COMMENT='Compatibility with JClic Reports'

Èxit

(mysql): CREATE TABLE mdl_jclic_users ( id BIGINT(10) unsigned NOT NULL auto_increment, user_id VARCHAR(50) NOT NULL DEFAULT '', group_id VARCHAR(50) NOT NULL DEFAULT '', user_name VARCHAR(80) NOT NULL DEFAULT '', user_pwd VARCHAR(255) DEFAULT NULL, user_icon VARCHAR(255) DEFAULT NULL, user_code VARCHAR(50) DEFAULT NULL, user_keywords VARCHAR(255) DEFAULT NULL, CONSTRAINT PRIMARY KEY (id) )

Èxit

(mysql): ALTER TABLE mdl_jclic_users COMMENT='Compatibility with JClic Reports'

Èxit

(mysql): INSERT INTO mdl_jclic_settings(setting_key, setting_value) VALUES ('ALLOW_CREATE_GROUPS', 'false')

Èxit

(mysql): INSERT INTO mdl_jclic_settings(setting_key, setting_value) VALUES ('ALLOW_CREATE_USERS', 'false')

Èxit

(mysql): INSERT INTO mdl_jclic_settings(setting_key, setting_value) VALUES ('SHOW_GROUP_LIST', 'false')

Èxit

(mysql): INSERT INTO mdl_jclic_settings(setting_key, setting_value) VALUES ('SHOW_USER_LIST', 'false')

Èxit

(mysql): INSERT INTO mdl_jclic_settings(setting_key, setting_value) VALUES ('USER_TABLES', 'true')

Èxit

(mysql): INSERT INTO mdl_jclic_settings(setting_key, setting_value) VALUES ('TIME_LAP', '10')

Èxit

S'han configurat correctament les taules jclic