OpenACS / openacs-4 / packages / chat / sql / postgresql

chat-drop.sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 7
Last Commit: 12:40
Commits this week: 0
Total Lines of Code (LoC): 128
Net change in LoC this week: 0

Commit Activity

Commits By Day In Week
52 week commits volume
Commits By Day In Week
Commits by day
Commits By Day In Week
Commits by hour
Commits By Hour In Day
Commit calendar
 

Most active committers (90 days)

loading
loading
  • last updated 2 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Friday 09 Aug 2019
11:11 pm

gustafn

improve spelling

Options
    • -2
    • +2
    ./chat-drop.sql
  2. … 9 more files in changeset.
Friday 01 Mar 2019
6:40 pm

hectorr

Chat Reform: reduce complexity by removing the 'chat_avatar_allow' privilege, 'chat_room_edit' should suffice.

Options
    • -3
    • +1
    ./chat-drop.sql
  2. … 7 more files in changeset.
6:25 pm

antoniop

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

Options
    • -36
    • +4
    ./chat-drop.sql
  2. … 5 more files in changeset.
Thursday 28 Feb 2019
5:09 pm

antoniop

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

Options
    • -7
    • +1
    ./chat-drop.sql
  2. … 9 more files in changeset.
Tuesday 26 Feb 2019
7:26 pm

hectorr

Whitespace changes

Options
    • -22
    • +11
    ./chat-drop.sql
  2. … 4 more files in changeset.
7:06 pm

hectorr

Chat Redesign: enable/disable avatar pictures by room, using the new attribute 'avatar_p', instead of by package instance, using the 'ShowAvatar' parameter.

Options
    • -1
    • +3
    ./chat-drop.sql
  2. … 19 more files in changeset.
Tuesday 08 Aug 2017
1:47 am

gustafn

merged changes from the oacs-5-9 branch and resolved conflicts

Options
    • -90
    • +60
    ./chat-drop.sql
  2. … 7834 more files in changeset.
Wednesday 23 Nov 2016
8:51 pm

antoniop

Allow user to specify how far in the past people connecting to the chat will see.

This is important on Learn@WU because people joining the chat room later want to

see the full conversation and before this was not settable from the UI. (Now defaults

to 4 hours) Useful also when somebody accidentally refreshes the chat after the

timewindow has passed.

Took this chance to ease a bit every future development: removed stored procedures

slowing greatly any change on the data model in favor of plain sql statements.

Incremented usage of cache.

Removed duplicated database operation when managing transcripts.

Fixed transcript name not being shown when deleting.

Options
    • -38
    • +1
    ./chat-drop.sql
  2. … 12 more files in changeset.
Monday 20 Jun 2016
11:00 am

gustafn

- modernize SQL

Options
    • -53
    • +60
    ./chat-drop.sql
  2. … 8 more files in changeset.
Monday 19 Nov 2007
2:14 am

donb

Rolled back HEAD to the version on the 5.3 branch

Options
    • -39
    • +5
    ./chat-drop.sql
  2. … 110 more files in changeset.
Tuesday 03 Jul 2007
9:49 am

avni

reverting pablom's commits to oacs-5-2: see http://openacs.org/forums/message-view?message_id=1042586

Options
    • -4
    • +2
    ./chat-drop.sql
  2. … 57 more files in changeset.
Thursday 07 Jun 2007
11:14 am

pablom

"New version of the package"

Options
    • -5
    • +37
    ./chat-drop.sql
  2. … 88 more files in changeset.
Thursday 26 Oct 2006
1:11 pm

pablom

Improvements in order to increase the funcionalities, overall in the creation and using of chat rooms

Options
    • -3
    • +5
    ./chat-drop.sql
  2. … 12 more files in changeset.
Tuesday 14 Mar 2006
1:16 pm

emmar

Valencia chat package. Provides support for postgresql and few enhancements like user search.

Options
    • -0
    • +158
    ./chat-drop.sql
  2. … 90 more files in changeset.