create_lams_tool_chat.sql

Clone Tools
  • last updated a few seconds ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
LDEV-4180: Make DB patches produce up-to-date structure during build instead of applying multiple patches. Get rid of unnecessary tables and keys. Modify boolean columns to tinyint(1) Simplify patches where possible.

  1. … 223 more files in changeset.
LDEV-3776: Remove $Id CVS keyword.

  1. … 1029 more files in changeset.
LDEV-3776: Remove $Id CVS keyword.

  1. … 568 more files in changeset.
LDEV-2949: Revert DB creation script for Chat Tool as autopatch takes care of changes. The update script should be merged to creation script on 2.4.1 release and Tool version in build.properties file should be updated.

LDEV-2949: Use Ajax to poll and send messages, instead of Jabber. Remove code supporting Jabber from Chat Tool. Adjust chat layout.

  1. … 26 more files in changeset.
LDEV-2807: Support for MySQL 5.5

  1. … 52 more files in changeset.
LDEV-2657 Date restrictions for Chat (merge to HEAD)

  1. … 12 more files in changeset.
LDEV-1945: Added text search based conditions to Chat tool.

  1. … 37 more files in changeset.
LDEV-1511 make tables created as MyISAM into InnoDB by modifying create table statements and creating update scripts.

  1. … 11 more files in changeset.
Updated how jabber room names are allocated.

When a chat tool session is created, it is assigned a jabber room name.

A 'room_created' boolean field was added to the lachat11_session table. This indicated whether the room has been created on the jabber server.

  1. … 5 more files in changeset.
Updated default content.

  1. … 3 more files in changeset.
Force tables to be INNODB tables

  1. … 2 more files in changeset.
Added reflect on chat.

  1. … 27 more files in changeset.
Change the field 'body' to use text instead of varchar in message table.

  1. … 2 more files in changeset.
Updated the column names from_user_id and to_user_id to from_user_uid and to_user_uid respectively

  1. … 2 more files in changeset.
Changed the nickname used to join the jabber chat group from the users login name to the user full name. The nickname is constructed by taking the users first name and last name followed by an optional number to ensure the nickname is unique for each session.

  1. … 11 more files in changeset.
Added finishedActivity flag to ChatUser, updated corresponding db tables.

  1. … 2 more files in changeset.
Modified chat model to including filtering fields. Modified message model to include send date, hidden, and chat session fields.

  1. … 2 more files in changeset.
Added message table to chat data model.

  1. … 5 more files in changeset.
Added new fields in session and user to store the jabber room and jabber id.

  1. … 2 more files in changeset.
Contains no new changes. Commit is being used to expand the the $id$ keyword. Previous file property was ASCII -kk, the property was changed to -kkv

  1. … 31 more files in changeset.
Update to the chat tool. Added struts tiles support, tabs to monitoring and authoring screens and basic service method in ChatServices.

  1. … 33 more files in changeset.
First check in for chat tool. Based on example_tool template.

    • -0
    • +71
    ./create_lams_tool_chat.sql
  1. … 81 more files in changeset.