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: 20 Dec
Commits this week: 0
Total Lines of Code (LoC): 1,318
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 12 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Wednesday 11 Sep
8:11 am

gustafn

merge with missing files

Options
    • -0
    • +0
    ./chat-create.sql
    • -0
    • +0
    ./chat-drop.sql
    • -0
    • +0
    ./upgrade/upgrade-5.0.1d5-5.0.1d6.sql
    • -0
    • +0
    ./upgrade/upgrade-6.0.0d1-6.0.0d2.sql
  5. … 1461 more files in changeset.
Tuesday 03 Sep
5:37 pm

gustafn

merge from oacs-5-10

Options
    • -540
    • +5
    ./chat-create.sql
    • -17
    • +5
    ./chat-drop.sql
    • -0
    • +16
    ./upgrade/upgrade-5.0.1d5-5.0.1d6.sql
    • -0
    • +28
    ./upgrade/upgrade-5.0.1d6-5.0.1d7.sql
    • -0
    • +12
    ./upgrade/upgrade-6.0.0d1-6.0.0d2.sql
  6. … 8095 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/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

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

Options
    • -0
    • +0
    ./upgrade/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
    • -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.
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/upgrade-5.0.1d6-5.0.1d7.sql
  2. … 1 more file 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.
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/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
    • -4
    • +19
    ./chat-create.sql
    • -0
    • +255
    ./upgrade/upgrade-5.0d10-5.0d11.sql
  3. … 7833 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
    • -4
    • +19
    ./chat-create.sql
    • -0
    • +255
    ./upgrade/upgrade-5.0d10-5.0d11.sql
  3. … 14 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/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/upgrade-5.0d6-5.0d7.sql
Monday 19 Nov 2007
2:14 am

donb

Rolled back HEAD to the version on the 5.3 branch

Options
    • -1
    • +1
    ./chat-create.sql
    • -1
    • +1
    ./chat-drop.sql
  3. … 109 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
    • -0
    • +0
    ./chat-create.sql
    • -0
    • +0
    ./chat-drop.sql
  3. … 56 more files in changeset.
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
    • -19
    • +38
    ./chat-create.sql
    • -1
    • +2
    ./chat-drop.sql
    • -0
    • +252
    ./upgrade/upgrade-5.0d4-5.0d5.sql
  4. … 79 more files in changeset.
Tuesday 11 Apr 2006
9:18 am

emmar

deleting room_admin privilege was missing

Options
    • -1
    • +2
    ./chat-drop.sql
Monday 10 Apr 2006
1:52 pm

emmar

fix SQL syntax

Options
    • -20
    • +18
    ./chat-create.sql
    • -20
    • +19
    ./upgrade/upgrade-5.0d4-5.0d5.sql
Sunday 09 Apr 2006
6:31 pm

emmar

Adding auto_flush and auto_transcript for chat_rooms

Options
    • -12
    • +33
    ./chat-create.sql
    • -0
    • +253
    ./upgrade/upgrade-5.0d4-5.0d5.sql
6:31 pm

emmar

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

Options
    • -0
    • +0
    ./upgrade/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/upgrade-4.0.0-5.0d1.sql
  2. … 3 more files in changeset.
Tuesday 30 Sep 2003
2:10 pm

mohanp

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)

Options
    • -14
    • +14
    ./chat-create.sql
  2. … 275 more files in changeset.
Friday 20 Apr 2001
10:51 pm

donb

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

Options
    • -0
    • +0
    ./chat-create.sql
    • -0
    • +0
    ./chat-drop.sql
  3. … 2478 more files in changeset.
10:51 pm

donb

Initial revision

Options
    • -0
    • +569
    ./chat-create.sql
    • -0
    • +90
    ./chat-drop.sql
  3. … 2478 more files in changeset.