OpenACS / openacs-4 / packages / notifications

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 21
Last Commit: 02 Jul 04
Commits this week: 0
Total Lines of Code (LoC): 3,049
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 16 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Wednesday 04 Feb 2004
11:57 am

lars

Implemented a safe way to delete constraints, as these constraints didn't exist. It's most likely got to do with the PG upgrade from 7.2 to 7.3 not recording constraints properly. This is a workaround, not a fix. See bug #1294.

Options
    • -2
    • +30
    ./postgresql/upgrade/upgrade-5.0.0a5-5.0.0a6.sql
11:53 am

lars

Untabify

Options
    • -7
    • +7
    ./postgresql/upgrade/upgrade-4.6.4-5.0d1.sql
Tuesday 30 Dec 2003
6:48 am

tracya

delete--> del upgrade

Options
    • -0
    • +404
    ./oracle/upgrade/upgrade-4.6.4-5.0d1.sql
Thursday 04 Dec 2003
8:44 am

jeffd

fix inconsistency between notifications-replies-extra-create and upgrade scripts, hopefully this finally fixed 1231

Options
    • -1
    • +1
    ./oracle/notifications-replies-extra-create.sql
    • -1
    • +1
    ./oracle/upgrade/upgrade-4.6.4-5.0d1.sql
    • -3
    • +4
    ./postgresql/upgrade/upgrade-4.6.4-5.0d1.sql
Tuesday 02 Dec 2003
11:45 am

peterm

no need to drop table if you are just changing a constraint.

Options
    • -2
    • +4
    ./oracle/upgrade/upgrade-5.0.0a5-5.0.0a6.sql
    • -42
    • +11
    ./postgresql/upgrade/upgrade-5.0.0a5-5.0.0a6.sql
Friday 28 Nov 2003
3:52 pm

jeffd

the upgrade failed because notification_user_map constraint notif_user_map_notif_id_fk needed the pk on notifications_bak, now drops it and recreates it after the table is reloaded

Options
    • -0
    • +4
    ./postgresql/upgrade/upgrade-5.0.0a5-5.0.0a6.sql
Thursday 27 Nov 2003
11:46 am

jeffd

use clobs for to_addr, headers, body; fix load_qmail_mail_queue.holdinsert query, fix upgrade script, make constriant names conform to standards. Fixes bug 1231

Options
    • -5
    • +6
    ./oracle/upgrade/upgrade-4.6.4-5.0d1.sql
    • -2
    • +3
    ./postgresql/notifications-replies-extra-create.sql
  3. … 2 more files in changeset.
Wednesday 26 Nov 2003
6:11 pm

jeffd

text datatype should be clob for oracle

Options
    • -5
    • +6
    ./oracle/notifications-replies-extra-create.sql
Monday 24 Nov 2003
7:51 pm

peterm

making notifications cascade when acs objects are deleted, see bug 260

Options
    • -2
    • +3
    ./oracle/notifications-core-create.sql
    • -0
    • +6
    ./oracle/upgrade/upgrade-5.0.0a5-5.0.0a6.sql
    • -2
    • +3
    ./postgresql/notifications-core-create.sql
    • -0
    • +42
    ./postgresql/upgrade/upgrade-5.0.0a5-5.0.0a6.sql