inwicast
(mysql): CREATE TABLE mdl_inwi_map_medias (
id BIGINT(11) unsigned NOT NULL auto_increment,
mediamap_ref VARCHAR(20) NOT NULL DEFAULT '',
media_ref VARCHAR(20) NOT NULL DEFAULT '',
label VARCHAR(250) NOT NULL DEFAULT '',
html TEXT NOT NULL,
lat VARCHAR(10) NOT NULL DEFAULT '0',
lng VARCHAR(10) NOT NULL DEFAULT '0',
icon VARCHAR(30) NOT NULL DEFAULT 'default',
date_created DATETIME DEFAULT NULL,
visible SMALLINT(4) unsigned NOT NULL DEFAULT 1,
CONSTRAINT PRIMARY KEY (id)
)
Success
(mysql): ALTER TABLE mdl_inwi_map_medias COMMENT='inwi_map_medias table retrofitted from MySQL'
Success
(mysql): CREATE TABLE mdl_inwi_cours_medias (
id BIGINT(10) unsigned NOT NULL auto_increment,
code_cours VARCHAR(40) NOT NULL DEFAULT '0',
media_ref VARCHAR(40) NOT NULL DEFAULT '0',
visible SMALLINT(4) unsigned NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
)
Success
(mysql): ALTER TABLE mdl_inwi_cours_medias COMMENT='inwi_cours_medias table retrofitted from MySQL'
Success
(mysql): CREATE TABLE mdl_inwi_medias (
id BIGINT(11) unsigned NOT NULL auto_increment,
media_ref VARCHAR(20) NOT NULL DEFAULT '',
user_name VARCHAR(30) NOT NULL DEFAULT '',
media_type VARCHAR(20) NOT NULL DEFAULT '',
media_format VARCHAR(20) NOT NULL DEFAULT '',
title VARCHAR(100) NOT NULL DEFAULT '',
description VARCHAR(250) NOT NULL DEFAULT '',
author VARCHAR(250) NOT NULL DEFAULT '',
copyright VARCHAR(250) NOT NULL DEFAULT '',
media_url VARCHAR(100) NOT NULL DEFAULT '',
preview_url VARCHAR(250) NOT NULL DEFAULT '',
embedded_player TEXT NOT NULL,
tags VARCHAR(250) NOT NULL DEFAULT '',
status BIGINT(11) unsigned NOT NULL DEFAULT 0,
width SMALLINT(4) unsigned NOT NULL DEFAULT 480,
height SMALLINT(4) unsigned NOT NULL DEFAULT 360,
date_created DATETIME DEFAULT NULL,
date_started DATETIME DEFAULT NULL,
date_ended DATETIME DEFAULT NULL,
viewed SMALLINT(4) unsigned NOT NULL DEFAULT 0,
votes SMALLINT(4) unsigned NOT NULL DEFAULT 0,
is_public SMALLINT(4) unsigned NOT NULL DEFAULT 0,
is_downloadable SMALLINT(4) unsigned NOT NULL DEFAULT 1,
contentid BIGINT(11) unsigned NOT NULL DEFAULT 0,
catid BIGINT(11) unsigned NOT NULL DEFAULT 0,
channelid BIGINT(11) unsigned NOT NULL DEFAULT 0,
module_ref VARCHAR(30) NOT NULL DEFAULT '',
map_lat VARCHAR(20) NOT NULL DEFAULT '',
map_lng VARCHAR(20) NOT NULL DEFAULT '',
map_type VARCHAR(20) NOT NULL DEFAULT 'G_NORMAL_MAP',
map_zoom SMALLINT(4) unsigned NOT NULL,
CONSTRAINT PRIMARY KEY (id)
)
Success
(mysql): ALTER TABLE mdl_inwi_medias COMMENT='inwi_medias table retrofitted from MySQL'
Success
Mediacenter tables have been set up correctly