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

upgrade

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 6
Last Commit: 28 Dec 24
Commits this week: 0
Total Lines of Code (LoC): 1,171
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 1 hour ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Wednesday 11 Sep 2024
8:11 am

gustafn

merge with missing files

Options
    • -0
    • +0
    ./upgrade-5.0.1d5-5.0.1d6.sql
    • -0
    • +0
    ./upgrade-6.0.0d1-6.0.0d2.sql
  3. … 1463 more files in changeset.
Tuesday 03 Sep 2024
5:37 pm

gustafn

merge from oacs-5-10

Options
    • -0
    • +16
    ./upgrade-5.0.1d5-5.0.1d6.sql
    • -0
    • +28
    ./upgrade-5.0.1d6-5.0.1d7.sql
    • -0
    • +12
    ./upgrade-6.0.0d1-6.0.0d2.sql
  4. … 8097 more files in changeset.
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-5.0.1d6-5.0.1d7.sql
  2. … 8 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-5.0.1d5-5.0.1d6.sql
  2. … 1 more file in changeset.
Friday 01 Mar 2019
6:40 pm

hectorr

file upgrade-6.0.0d1-6.0.0d2.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./upgrade-6.0.0d1-6.0.0d2.sql
  2. … 1 more file in changeset.
6:40 pm

hectorr

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

Options
    • -0
    • +12
    ./upgrade-6.0.0d1-6.0.0d2.sql
  2. … 7 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
    • -0
    • +28
    ./upgrade-5.0.1d6-5.0.1d7.sql
  2. … 9 more files in changeset.
5:09 pm

antoniop

file upgrade-5.0.1d6-5.0.1d7.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./upgrade-5.0.1d6-5.0.1d7.sql
  2. … 1 more file in changeset.
Tuesday 26 Feb 2019
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
    • -0
    • +26
    ./upgrade-5.0.1d5-5.0.1d6.sql
  2. … 19 more files in changeset.
7:06 pm

hectorr

file upgrade-5.0.1d5-5.0.1d6.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./upgrade-5.0.1d5-5.0.1d6.sql
  2. … 1 more file in changeset.
Tuesday 08 Aug 2017
1:47 am

gustafn

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

Options
    • -0
    • +255
    ./upgrade-5.0d10-5.0d11.sql
  2. … 7834 more files in changeset.
Friday 28 Oct 2016
8:57 pm

antoniop

Introduced new options to set chat rooms so login and/or logout message are not issued everytime a user enters/exits the chat.

Options
    • -0
    • +255
    ./upgrade-5.0d10-5.0d11.sql
  2. … 15 more files in changeset.
8:57 pm

antoniop

file upgrade-5.0d10-5.0d11.sql was initially added on branch oacs-5-9.

Options
    • -0
    • +0
    ./upgrade-5.0d10-5.0d11.sql
  2. … 1 more file in changeset.
Wednesday 05 Mar 2008
10:44 am

avni

upgrade script for 2.3.0->2.4 which is really a downgrade ; does the same as upgrade-5.0d4-5.0d5.sql

Options
    • -0
    • +264
    ./upgrade-5.0d6-5.0d7.sql
Saturday 24 Jun 2006
4:23 pm

gustafn

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

Options
    • -0
    • +252
    ./upgrade-5.0d4-5.0d5.sql
  2. … 81 more files in changeset.
Monday 10 Apr 2006
1:52 pm

emmar

fix SQL syntax

Options
    • -20
    • +19
    ./upgrade-5.0d4-5.0d5.sql
  2. … 1 more file in changeset.
Sunday 09 Apr 2006
6:31 pm

emmar

Adding auto_flush and auto_transcript for chat_rooms

Options
    • -0
    • +253
    ./upgrade-5.0d4-5.0d5.sql
  2. … 1 more file in changeset.
6:31 pm

emmar

file upgrade-5.0d4-5.0d5.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./upgrade-5.0d4-5.0d5.sql
Wednesday 08 Oct 2003
6:32 pm

mohanp

Added upgrade to upgrade to changes made for Oracle 9i support

Options
    • -0
    • +344
    ./upgrade-4.0.0-5.0d1.sql
  2. … 3 more files in changeset.