flashvideo
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): SHOW TABLES
(mysql): CREATE TABLE mdl_flashvideo (
id BIGINT(10) unsigned NOT NULL auto_increment,
course BIGINT(10) unsigned NOT NULL DEFAULT 0,
name VARCHAR(255) NOT NULL DEFAULT '',
intro MEDIUMTEXT,
introformat SMALLINT(4) unsigned NOT NULL DEFAULT 0,
flvtype TINYINT(2) unsigned NOT NULL DEFAULT 0,
mediafile MEDIUMTEXT,
autoplay TINYINT(2) unsigned NOT NULL DEFAULT 0,
playloop TINYINT(2) unsigned NOT NULL DEFAULT 0,
videowidth SMALLINT(4) unsigned NOT NULL DEFAULT 400,
videoheight SMALLINT(4) unsigned NOT NULL DEFAULT 400,
initscale TINYINT(2) unsigned NOT NULL DEFAULT 0,
streamingserver MEDIUMTEXT,
streamingflvname MEDIUMTEXT,
bufferlength SMALLINT(4) unsigned NOT NULL DEFAULT 0,
timecreated BIGINT(10) unsigned NOT NULL DEFAULT 0,
timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0,
teachernote LONGTEXT,
CONSTRAINT PRIMARY KEY (id)
)
Success
(mysql): ALTER TABLE mdl_flashvideo COMMENT='Default comment for flashvideo, please edit me'
Success
(mysql): CREATE INDEX mdl_flas_cou_ix ON mdl_flashvideo (course)
Success
(mysql): CREATE TABLE mdl_flashvideo_mynote (
id BIGINT(10) NOT NULL auto_increment,
fid BIGINT(10) unsigned NOT NULL,
userid BIGINT(10) unsigned NOT NULL,
mynote LONGTEXT,
timecreated BIGINT(10) unsigned NOT NULL DEFAULT 0,
timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
)
Success
(mysql): ALTER TABLE mdl_flashvideo_mynote COMMENT='Student\'s personal notes'
Success
(mysql): CREATE INDEX mdl_flasmyno_fid_ix ON mdl_flashvideo_mynote (fid)
Success
(mysql): CREATE INDEX mdl_flasmyno_use_ix ON mdl_flashvideo_mynote (userid)
Success
(mysql): CREATE UNIQUE INDEX mdl_flasmyno_fiduse_uix ON mdl_flashvideo_mynote (fid, userid)
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('flashvideo', 'add', 'flashvideo', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('flashvideo', 'update', 'flashvideo', 'name')
Success
(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('flashvideo', 'view', 'flashvideo', 'name')
Success
flashvideo tables have been set up correctly