OpenACS / openacs-4 / packages / chat / sql

oracle

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 7
Last Commit: 21 Jul
Commits this week: 0
Total Lines of Code (LoC): -491
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 7 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Saturday 12 Feb 2022
9:11 pm

gustafn

improving Oracle upgrade scripts

Oracle has no "ALTER TABLE ADD COLUMN ...."

Oracle has no "ALTER TABLE ADD COLUMN if exists .."

Options
    • -1
    • +1
    ./upgrade/upgrade-5.0.1d6-5.0.1d7.sql
  2. … 8 more files in changeset.
Friday 09 Aug 2019
11:11 pm

gustafn

improve spelling

Options
    • -2
    • +2
    ./chat-create.sql
  2. … 9 more files in changeset.
Wednesday 19 Jun 2019
12:51 pm

antoniop

Fix oracle upgrade, remembering to keep privilege creation, which should indeed happen in the upgrade

Options
    • -11
    • +1
    ./upgrade/upgrade-5.0.1d5-5.0.1d6.sql
  2. … 1 more file 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
    • -4
    • +1
    ./chat-create.sql
    • -3
    • +1
    ./chat-drop.sql
    • -0
    • +12
    ./upgrade/upgrade-6.0.0d1-6.0.0d2.sql
  4. … 5 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
    • -188
    • +1
    ./chat-create.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
    • -367
    • +12
    ./chat-create.sql
    • -4
    • +1
    ./chat-drop.sql
    • -0
    • +28
    ./upgrade/upgrade-5.0.1d6-5.0.1d7.sql
  4. … 7 more files in changeset.
Tuesday 26 Feb 2019
7:26 pm

hectorr

Whitespace changes

Options
    • -151
    • +149
    ./chat-create.sql
    • -14
    • +5
    ./chat-drop.sql
  3. … 3 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
    • -17
    • +29
    ./chat-create.sql
    • -1
    • +3
    ./chat-drop.sql
    • -0
    • +26
    ./upgrade/upgrade-5.0.1d5-5.0.1d6.sql
  4. … 17 more files in changeset.