Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0015_updateFrom22.sql =================================================================== RCS file: /usr/local/cvsroot/lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0015_updateFrom22.sql,v diff -u -r1.13.2.10 -r1.13.2.11 --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0015_updateFrom22.sql 6 May 2009 01:29:28 -0000 1.13.2.10 +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0015_updateFrom22.sql 13 May 2009 04:41:17 -0000 1.13.2.11 @@ -128,9 +128,24 @@ -- LDEV-2054 ALTER TABLE lams_grouping ADD COLUMN view_students_before_selection TINYINT DEFAULT 0; --- Creting presence chat table -create table lams_presence_chat_msgs (uid bigint not null auto_increment, room_name varchar(255), from_user varchar(255), to_user varchar(255), date_sent datetime, message varchar(1023), primary key (uid))type=innodb; +-- LDEV-2197 ------------ Presence Chat Logging +CREATE TABLE lams_presence_chat_msgs ( + uid bigint NOT NULL auto_increment, + room_name VARCHAR(255), + from_user VARCHAR(255), + to_user VARCHAR(255), + date_sent DATETIME, + message VARCHAR(1023), + PRIMARY KEY (uid) +)TYPE=InnoDB; +-- LDEV-2005 Video Recorder configuration stuff -------------- +insert into lams_configuration (config_key, config_value, description_key, header_name, format, required) +values ('Red5ServerUrl','', 'config.red5.server.url', 'config.header.red5', 'STRING', 0); + +insert into lams_configuration (config_key, config_value, description_key, header_name, format, required) +values ('Red5RecordingsUrl','', 'config.red5.recordings.url', 'config.header.red5', 'STRING', 0); + ----------------------Put all sql statements above here------------------------- -- If there were no errors, commit and restore autocommit to on