game

(mysql): SHOW TABLES

(mysql): CREATE TABLE mdl_game ( id BIGINT(10) unsigned NOT NULL auto_increment, name VARCHAR(255) DEFAULT NULL, course BIGINT(10) unsigned DEFAULT NULL, sourcemodule VARCHAR(50) DEFAULT NULL, quizid BIGINT(10) unsigned DEFAULT NULL, glossaryid BIGINT(10) unsigned DEFAULT NULL, glossarycategoryid BIGINT(10) unsigned DEFAULT NULL, questioncategoryid BIGINT(10) unsigned DEFAULT NULL, bookid BIGINT(10) unsigned DEFAULT NULL, gamekind VARCHAR(20) DEFAULT NULL, param1 BIGINT(10) unsigned DEFAULT NULL, param2 BIGINT(10) unsigned DEFAULT NULL, param3 BIGINT(10) unsigned DEFAULT NULL, param4 BIGINT(10) unsigned DEFAULT NULL, param5 BIGINT(10) unsigned DEFAULT NULL, param6 BIGINT(10) unsigned DEFAULT NULL, param7 BIGINT(10) unsigned DEFAULT NULL, param8 BIGINT(10) unsigned DEFAULT NULL, timemodified BIGINT(10) unsigned DEFAULT NULL, gameinputid BIGINT(10) unsigned DEFAULT NULL, bottomtext TEXT, grademethod TINYINT(2) unsigned DEFAULT NULL, grade BIGINT(10) unsigned DEFAULT NULL, decimalpoints TINYINT(2) unsigned DEFAULT NULL, popup SMALLINT(4) unsigned DEFAULT NULL, review BIGINT(10) unsigned DEFAULT NULL, attempts BIGINT(10) unsigned DEFAULT NULL, glossaryid2 BIGINT(10) unsigned DEFAULT NULL, glossarycategoryid2 BIGINT(10) unsigned DEFAULT NULL, language VARCHAR(10) DEFAULT NULL, subcategories TINYINT(1) unsigned DEFAULT NULL, CONSTRAINT PRIMARY KEY (id) )

Úspech

(mysql): ALTER TABLE mdl_game COMMENT='game'

Úspech

(mysql): CREATE TABLE mdl_game_attempts ( id BIGINT(10) unsigned NOT NULL auto_increment, gameid BIGINT(10) unsigned DEFAULT NULL, userid BIGINT(10) unsigned DEFAULT NULL, timestart BIGINT(10) unsigned NOT NULL, timefinish BIGINT(10) unsigned NOT NULL, timelastattempt BIGINT(10) unsigned DEFAULT NULL, lastip VARCHAR(30) DEFAULT NULL, lastremotehost VARCHAR(50) DEFAULT NULL, preview TINYINT(1) unsigned DEFAULT NULL, attempt BIGINT(10) unsigned DEFAULT NULL, score DOUBLE unsigned DEFAULT NULL, attempts BIGINT(10) unsigned DEFAULT NULL, CONSTRAINT PRIMARY KEY (id) )

Úspech

(mysql): ALTER TABLE mdl_game_attempts COMMENT='game_attempts'

Úspech

(mysql): CREATE INDEX mdl_gameatte_gamusetim_ix ON mdl_game_attempts (gameid, userid, timefinish)

Úspech

(mysql): CREATE TABLE mdl_game_grades ( id BIGINT(10) unsigned NOT NULL auto_increment, gameid BIGINT(10) unsigned DEFAULT NULL, userid BIGINT(10) unsigned DEFAULT NULL, score DOUBLE unsigned NOT NULL, timemodified BIGINT(10) unsigned NOT NULL, CONSTRAINT PRIMARY KEY (id) )

Úspech

(mysql): ALTER TABLE mdl_game_grades COMMENT='game_grades'

Úspech

(mysql): CREATE INDEX mdl_gamegrad_use_ix ON mdl_game_grades (userid)

Úspech

(mysql): CREATE INDEX mdl_gamegrad_gam_ix ON mdl_game_grades (gameid)

Úspech

(mysql): CREATE TABLE mdl_game_queries ( id BIGINT(10) unsigned NOT NULL auto_increment, attemptid BIGINT(10) unsigned DEFAULT NULL, gamekind VARCHAR(255) DEFAULT NULL, gameid BIGINT(10) unsigned DEFAULT NULL, userid BIGINT(10) unsigned DEFAULT NULL, sourcemodule VARCHAR(20) DEFAULT NULL, questionid BIGINT(10) unsigned DEFAULT NULL, glossaryentryid BIGINT(10) unsigned DEFAULT NULL, questiontext TEXT, score DOUBLE unsigned DEFAULT NULL, timelastattempt BIGINT(10) unsigned DEFAULT NULL, studentanswer TEXT, col BIGINT(10) unsigned DEFAULT NULL, row BIGINT(10) unsigned DEFAULT NULL, horizontal BIGINT(10) unsigned DEFAULT NULL, answertext TEXT, correct BIGINT(10) unsigned DEFAULT NULL, attachment VARCHAR(200) DEFAULT NULL, CONSTRAINT PRIMARY KEY (id) )

Úspech

(mysql): ALTER TABLE mdl_game_queries COMMENT='game_queries'

Úspech

(mysql): CREATE INDEX mdl_gamequer_att_ix ON mdl_game_queries (attemptid)

Úspech

(mysql): CREATE TABLE mdl_game_hangman ( id BIGINT(10) unsigned NOT NULL, queryid BIGINT(10) unsigned DEFAULT NULL, letters VARCHAR(100) DEFAULT NULL, allletters VARCHAR(100) DEFAULT NULL, try SMALLINT(4) unsigned DEFAULT NULL, maxtries SMALLINT(4) unsigned DEFAULT NULL, finishedword SMALLINT(4) unsigned DEFAULT NULL, corrects SMALLINT(4) unsigned DEFAULT NULL, iscorrect TINYINT(2) unsigned DEFAULT NULL, CONSTRAINT PRIMARY KEY (id) )

Úspech

(mysql): ALTER TABLE mdl_game_hangman COMMENT='game_hangman'

Úspech

(mysql): CREATE TABLE mdl_game_cross ( id BIGINT(10) unsigned NOT NULL, cols VARCHAR(50) DEFAULT NULL, rows SMALLINT(3) unsigned DEFAULT NULL, words SMALLINT(3) unsigned DEFAULT NULL, wordsall BIGINT(10) unsigned DEFAULT NULL, createscore SMALLINT(3) unsigned DEFAULT NULL, createtries BIGINT(10) unsigned DEFAULT NULL, createtimelimit BIGINT(10) unsigned DEFAULT NULL, createconnectors BIGINT(10) unsigned DEFAULT NULL, createfilleds BIGINT(10) unsigned DEFAULT NULL, createspaces BIGINT(10) unsigned DEFAULT NULL, triesplay BIGINT(10) unsigned DEFAULT NULL, CONSTRAINT PRIMARY KEY (id) )

Úspech

(mysql): ALTER TABLE mdl_game_cross COMMENT='game_cross'

Úspech

(mysql): CREATE TABLE mdl_game_cryptex ( id BIGINT(10) unsigned NOT NULL, letters TEXT, CONSTRAINT PRIMARY KEY (id) )

Úspech

(mysql): ALTER TABLE mdl_game_cryptex COMMENT='game_cryptex'

Úspech

(mysql): CREATE TABLE mdl_game_millionaire ( id BIGINT(10) unsigned NOT NULL, queryid BIGINT(10) unsigned DEFAULT NULL, state TINYINT(2) unsigned NOT NULL, level TINYINT(2) unsigned NOT NULL, CONSTRAINT PRIMARY KEY (id) )

Úspech

(mysql): ALTER TABLE mdl_game_millionaire COMMENT='game_millionaire'

Úspech

(mysql): CREATE TABLE mdl_game_sudoku ( id BIGINT(10) unsigned NOT NULL, level SMALLINT(4) unsigned NOT NULL, data VARCHAR(81) NOT NULL DEFAULT '', opened SMALLINT(4) unsigned DEFAULT NULL, guess VARCHAR(81) DEFAULT NULL, CONSTRAINT PRIMARY KEY (id) )

Úspech

(mysql): ALTER TABLE mdl_game_sudoku COMMENT='game_sudoku'

Úspech

(mysql): CREATE TABLE mdl_game_sudoku_database ( id BIGINT(10) unsigned NOT NULL auto_increment, level SMALLINT(3) unsigned DEFAULT NULL, opened TINYINT(2) unsigned DEFAULT NULL, data VARCHAR(81) DEFAULT NULL, CONSTRAINT PRIMARY KEY (id) )

Úspech

(mysql): ALTER TABLE mdl_game_sudoku_database COMMENT='game_sudoku_database'

Úspech

(mysql): CREATE UNIQUE INDEX mdl_gamesudodata_dat_uix ON mdl_game_sudoku_database (data)

Úspech

(mysql): CREATE TABLE mdl_game_bookquiz ( id BIGINT(10) unsigned NOT NULL, bookid BIGINT(10) unsigned NOT NULL, lastchapterid VARCHAR(81) NOT NULL DEFAULT '', CONSTRAINT PRIMARY KEY (id) )

Úspech

(mysql): ALTER TABLE mdl_game_bookquiz COMMENT='game_bookquiz'

Úspech

(mysql): CREATE TABLE mdl_game_bookquiz_chapters ( id BIGINT(10) unsigned NOT NULL auto_increment, attemptid BIGINT(10) unsigned NOT NULL, chapterid VARCHAR(81) NOT NULL DEFAULT '', CONSTRAINT PRIMARY KEY (id) )

Úspech

(mysql): ALTER TABLE mdl_game_bookquiz_chapters COMMENT='game_bookquiz_chapters'

Úspech

(mysql): CREATE INDEX mdl_gamebookchap_attcha_ix ON mdl_game_bookquiz_chapters (attemptid, chapterid)

Úspech

(mysql): CREATE TABLE mdl_game_bookquiz_questions ( id BIGINT(10) unsigned NOT NULL auto_increment, gameid BIGINT(10) unsigned DEFAULT NULL, chapterid BIGINT(10) unsigned DEFAULT NULL, questioncategoryid BIGINT(10) unsigned DEFAULT NULL, CONSTRAINT PRIMARY KEY (id) )

Úspech

(mysql): ALTER TABLE mdl_game_bookquiz_questions COMMENT='game_bookquiz'

Úspech

(mysql): CREATE INDEX mdl_gamebookques_gamcha_ix ON mdl_game_bookquiz_questions (gameid, chapterid)

Úspech

(mysql): CREATE TABLE mdl_game_export_javame ( id BIGINT(10) unsigned NOT NULL auto_increment, gameid BIGINT(10) unsigned DEFAULT NULL, filename VARCHAR(20) DEFAULT NULL, icon VARCHAR(100) DEFAULT NULL, createdby VARCHAR(50) DEFAULT NULL, vendor VARCHAR(50) DEFAULT NULL, name VARCHAR(20) DEFAULT NULL, description VARCHAR(100) DEFAULT NULL, version VARCHAR(10) DEFAULT NULL, CONSTRAINT PRIMARY KEY (id) )

Úspech

(mysql): ALTER TABLE mdl_game_export_javame COMMENT='game_export_javame'

Úspech

(mysql): CREATE UNIQUE INDEX mdl_gameexpojava_gam_uix ON mdl_game_export_javame (gameid)

Úspech

(mysql): CREATE TABLE mdl_game_snakes ( id BIGINT(10) unsigned NOT NULL, snakesdatabaseid BIGINT(10) unsigned DEFAULT NULL, position BIGINT(10) unsigned DEFAULT NULL, queryid BIGINT(10) unsigned DEFAULT NULL, dice TINYINT(1) unsigned DEFAULT NULL, CONSTRAINT PRIMARY KEY (id) )

Úspech

(mysql): ALTER TABLE mdl_game_snakes COMMENT='game_snakes'

Úspech

(mysql): CREATE TABLE mdl_game_snakes_database ( id BIGINT(10) unsigned NOT NULL auto_increment, name VARCHAR(100) DEFAULT NULL, cols SMALLINT(3) unsigned DEFAULT NULL, rows SMALLINT(3) unsigned DEFAULT NULL, data TEXT, file VARCHAR(100) DEFAULT NULL, direction TINYINT(2) unsigned DEFAULT NULL, headerx BIGINT(10) unsigned DEFAULT NULL, headery BIGINT(10) unsigned DEFAULT NULL, footerx BIGINT(10) unsigned DEFAULT NULL, footery BIGINT(10) unsigned DEFAULT NULL, width BIGINT(10) unsigned DEFAULT NULL, height BIGINT(10) unsigned DEFAULT NULL, CONSTRAINT PRIMARY KEY (id) )

Úspech

(mysql): ALTER TABLE mdl_game_snakes_database COMMENT='game_snakes_database'

Úspech

(mysql): CREATE TABLE mdl_game_course ( id BIGINT(10) unsigned NOT NULL auto_increment, messagewin TEXT, messageloose TEXT, CONSTRAINT PRIMARY KEY (id) )

Úspech

(mysql): ALTER TABLE mdl_game_course COMMENT='game_course'

Úspech

(mysql): CREATE TABLE mdl_game_course_inputs ( id BIGINT(10) unsigned NOT NULL auto_increment, name VARCHAR(100) DEFAULT NULL, course BIGINT(10) unsigned DEFAULT NULL, sourcemodule VARCHAR(20) DEFAULT NULL, ids TEXT, CONSTRAINT PRIMARY KEY (id) )

Úspech

(mysql): ALTER TABLE mdl_game_course_inputs COMMENT='game_course_inputs'

Úspech

(mysql): CREATE TABLE mdl_game_hiddenpicture ( id BIGINT(10) unsigned NOT NULL, correct SMALLINT(4) unsigned NOT NULL, wrong SMALLINT(4) unsigned NOT NULL, found SMALLINT(4) unsigned NOT NULL, CONSTRAINT PRIMARY KEY (id) )

Úspech

(mysql): ALTER TABLE mdl_game_hiddenpicture COMMENT='game_hiddenpicture'

Úspech

game tabuľky boli nastavené správne