table-schema.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-2847: Major changes to build.xml files. See JIRA comment for full explanation.

  1. … 1313 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.
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.
Sql schema produced by xdoclet. Generated from chat model classes.