• last updated 9 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
improve spelling

  1. … 9 more files in changeset.
Chat Reform: reduce complexity by removing the 'chat_avatar_allow' privilege, 'chat_room_edit' should suffice.

  1. … 7 more files in changeset.
Major reform in the chat backend: use xotcl-core ORM to define all the relevant objects and data model

This greatly converges oracle and postgres codebase and will make easier to apply incremental updates to the data model in the future. It will also automatically update the acs_object_type metadata automatically

TODO: remove legacy procs, temporarly reimplemented using the new backend

  1. … 5 more files in changeset.
Chat data-model reform:

- introduce on delete cascade on foreign key constraints so package can be removed easily e.g. from the subsite UI

- remove remaining stored procedures (and function_args definitions) to relieve the burden on the development process and reduce divergency between oracle and postgres code

- converge oracle and postgres datamodels:

. oracle -> add missing messages_time_window column

. postgres -> remove creation_date from chat_transcripts, which was found to be still existing on old downstream installations

  1. … 9 more files in changeset.
Whitespace changes

  1. … 4 more files in changeset.
Chat Redesign: enable/disable avatar pictures by room, using the new attribute 'avatar_p', instead of by package instance, using the 'ShowAvatar' parameter.

  1. … 19 more files in changeset.
merged changes from the oacs-5-9 branch and resolved conflicts

  1. … 7834 more files in changeset.
Introduced new options to set chat rooms so login and/or logout message are not issued everytime a user enters/exits the chat.

  1. … 15 more files in changeset.
Rolled back HEAD to the version on the 5.3 branch

  1. … 110 more files in changeset.
reverting pablom's commits to oacs-5-2: see http://openacs.org/forums/message-view?message_id=1042586

  1. … 57 more files in changeset.
brought chat in cvs head to the same level as in oacs-5-2, normalized comparisons and expr (using eq etc.)

  1. … 81 more files in changeset.
fix SQL syntax

  1. … 1 more file in changeset.
Adding auto_flush and auto_transcript for chat_rooms

  1. … 1 more file in changeset.
Oracle9i porting changes

- Changed procedure names from delete to del

- Changed view declaration to use actual column names

- Changed "rel_constraints_violated_one" and "rel_constraints_violated_two"

(http://openacs.org/forums/message-view?message_id=81045)

  1. … 275 more files in changeset.

Forgot to define binary files before importing, so .gifs were messed up.

  1. … 2479 more files in changeset.
Initial revision

    • -0
    • +569
    ./chat-create.sql
  1. … 2479 more files in changeset.