book
(mysql): CREATE TABLE mdl_book (
id BIGINT(10) unsigned NOT NULL auto_increment,
course BIGINT(10) unsigned NOT NULL DEFAULT 0,
name VARCHAR(255) NOT NULL DEFAULT '',
summary MEDIUMTEXT NOT NULL,
numbering SMALLINT(4) unsigned NOT NULL DEFAULT 0,
disableprinting TINYINT(2) unsigned NOT NULL DEFAULT 2,
customtitles TINYINT(2) unsigned NOT NULL DEFAULT 0,
timecreated BIGINT(10) unsigned NOT NULL DEFAULT 0,
timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
)
Èxit
(mysql): ALTER TABLE mdl_book COMMENT='Defines book'
Èxit
(mysql): CREATE TABLE mdl_book_chapters (
id BIGINT(10) NOT NULL auto_increment,
bookid BIGINT(10) unsigned NOT NULL DEFAULT 0,
pagenum BIGINT(10) unsigned NOT NULL DEFAULT 0,
subchapter BIGINT(10) unsigned NOT NULL DEFAULT 0,
title VARCHAR(255) NOT NULL DEFAULT '',
content LONGTEXT NOT NULL,
hidden TINYINT(2) unsigned NOT NULL DEFAULT 0,
timecreated BIGINT(10) unsigned NOT NULL DEFAULT 0,
timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0,
importsrc VARCHAR(255) NOT NULL DEFAULT '',
CONSTRAINT PRIMARY KEY (id)
)
Èxit
(mysql): ALTER TABLE mdl_book_chapters COMMENT='Defines book_chapters'
Èxit
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('book', 'update', 'book', 'name')
Èxit
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('book', 'view', 'book', 'name')
Èxit
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('book', 'view all', 'book', 'name')
Èxit
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('book', 'print', 'book', 'name')
Èxit
S'han configurat correctament les taules book