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.9 -r1.13.2.10 --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0015_updateFrom22.sql 6 May 2009 00:46:00 -0000 1.13.2.9 +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch0015_updateFrom22.sql 6 May 2009 01:29:28 -0000 1.13.2.10 @@ -128,6 +128,9 @@ -- 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; + ----------------------Put all sql statements above here------------------------- -- If there were no errors, commit and restore autocommit to on