lightboxgallery
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): CREATE TABLE mdl_lightboxgallery (
id BIGINT(10) unsigned NOT NULL auto_increment,
course BIGINT(10) unsigned NOT NULL DEFAULT 0,
folder VARCHAR(255) NOT NULL DEFAULT '',
name VARCHAR(255) NOT NULL DEFAULT '',
perpage SMALLINT(3) unsigned NOT NULL DEFAULT 0,
comments TINYINT(1) unsigned NOT NULL DEFAULT 0,
ispublic TINYINT(1) unsigned NOT NULL DEFAULT 0,
rss TINYINT(1) unsigned NOT NULL DEFAULT 0,
autoresize TINYINT(1) unsigned NOT NULL DEFAULT 0,
resize TINYINT(1) unsigned NOT NULL DEFAULT 0,
extinfo TINYINT(1) unsigned NOT NULL DEFAULT 0,
description TEXT NOT NULL,
timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
)
Èxit
(mysql): ALTER TABLE mdl_lightboxgallery COMMENT='Defines lightboxgallery activities'
Èxit
(mysql): CREATE INDEX mdl_ligh_cou_ix ON mdl_lightboxgallery (course)
Èxit
(mysql): CREATE TABLE mdl_lightboxgallery_comments (
id BIGINT(10) unsigned NOT NULL auto_increment,
gallery BIGINT(10) unsigned NOT NULL DEFAULT 0,
userid BIGINT(10) unsigned NOT NULL DEFAULT 0,
comment TEXT NOT NULL,
timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
)
Èxit
(mysql): ALTER TABLE mdl_lightboxgallery_comments COMMENT='Contains comments attached to lightboxgallery resources'
Èxit
(mysql): CREATE INDEX mdl_lighcomm_gal_ix ON mdl_lightboxgallery_comments (gallery)
Èxit
(mysql): CREATE TABLE mdl_lightboxgallery_image_meta (
id BIGINT(10) unsigned NOT NULL auto_increment,
gallery BIGINT(10) unsigned NOT NULL DEFAULT 0,
image VARCHAR(255) NOT NULL DEFAULT '',
metatype enum('caption', 'tag') NOT NULL DEFAULT 'caption',
description TEXT NOT NULL,
CONSTRAINT PRIMARY KEY (id)
)
Èxit
(mysql): ALTER TABLE mdl_lightboxgallery_image_meta COMMENT='Meta data linked to gallery images'
Èxit
(mysql): CREATE INDEX mdl_lighimagmeta_gal_ix ON mdl_lightboxgallery_image_meta (gallery)
Èxit
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('lightboxgallery', 'update', 'lightboxgallery', 'name')
Èxit
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('lightboxgallery', 'view', 'lightboxgallery', 'name')
Èxit
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('lightboxgallery', 'comment', 'lightboxgallery', 'name')
Èxit
S'han configurat correctament les taules lightboxgallery