OpenACS / openacs-4 / packages / acs-messaging / sql

postgresql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 14
Last Commit: 27 Dec
Commits this week: 0
Total Lines of Code (LoC): 2,860
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 8 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Wednesday 11 Sep
8:11 am

gustafn

merge with missing files

Options
    • -0
    • +0
    ./acs-messaging-packages.sql
  2. … 1464 more files in changeset.
Tuesday 03 Sep
5:37 pm

gustafn

merge from oacs-5-10

Options
    • -3
    • +7
    ./acs-messaging-packages.sql
    • -0
    • +114
    ./upgrade/upgrade-5.10.0d1-5.10.0d2.sql
  3. … 8098 more files in changeset.
Wednesday 24 Feb 2021
4:31 am

gustafn

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

Options
    • -0
    • +0
    ./upgrade/upgrade-5.10.0d1-5.10.0d2.sql
Tuesday 08 Aug 2017
1:47 am

gustafn

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

Options
    • -231
    • +110
    ./acs-messaging-packages.sql
    • -0
    • +108
    ./upgrade/upgrade-5.9.0-5.9.1d1.sql
    • -0
    • +103
    ./upgrade/upgrade-5.9.1d1-5.9.1d2.sql
    • -0
    • +198
    ./upgrade/upgrade-5.9.1d2-5.9.1d3.sql
  5. … 7831 more files in changeset.
Saturday 11 Feb 2017
6:05 pm

gustafn

file upgrade-5.9.1d2-5.9.1d3.sql was initially added on branch oacs-5-9.

Options
    • -0
    • +0
    ./upgrade/upgrade-5.9.1d2-5.9.1d3.sql
Tuesday 20 Sep 2016
5:35 pm

antoniop

file upgrade-5.9.1d1-5.9.1d2.sql was initially added on branch oacs-5-9.

Options
    • -0
    • +0
    ./upgrade/upgrade-5.9.1d1-5.9.1d2.sql
  2. … 1 more file in changeset.
Wednesday 17 Aug 2016
10:32 am

gustafn

file upgrade-5.9.0-5.9.1d1.sql was initially added on branch oacs-5-9.

Options
    • -0
    • +0
    ./upgrade/upgrade-5.9.0-5.9.1d1.sql
Tuesday 30 Jun 2015
1:39 pm

gustafn

- add function args missed by earlier upgrades

- bump version numbers

Options
    • -0
    • +18
    ./upgrade/upgrade-5.9.0d1-5.9.0d2.sql
  2. … 9 more files in changeset.
Saturday 30 Mar 2013
2:22 pm

gustafn

- update postgres function to modern style plpgsql definitions, avoid backslash escaping

- add missing function_args

Options
    • -16
    • +42
    ./acs-messaging-create.sql
    • -293
    • +471
    ./acs-messaging-packages.sql
    • -32
    • +40
    ./upgrade/upgrade-4.6.2-4.6.3.sql
    • -6
    • +15
    ./upgrade/upgrade-5.0.0b3-5.0.0b4.sql
    • -34
    • +42
    ./upgrade/upgrade-5.8.0d1-5.8.0d2.sql
Tuesday 06 Sep 2011
3:20 pm

victorg

Some time ago some plpgsql functions were changed in order to be compatible with pg 8.x, create scripts were modified but upgrade scripts were missing ( at least i couldn't find them) http://fisheye.openacs.org/changelog/OpenACS?cs=MAIN%3Ajeffd%3A20090210183154 . Bumping up package versions accordingly.

Options
    • -0
    • +98
    ./upgrade/upgrade-5.8.0d1-5.8.0d2.sql
  2. … 7 more files in changeset.
Tuesday 10 Feb 2009
7:31 pm

jeffd

switch foo_id_seq.netval to nextval('t_foo_id_seq') calls to placate postgresql 8.

Options
    • -2
    • +2
    ./acs-messaging-packages.sql
  2. … 8 more files in changeset.
Monday 25 Sep 2006
10:47 pm

byronl

Correction of name constraint

Options
    • -2
    • +2
    ./acs-messaging-create.sql
  2. … 2 more files in changeset.
Wednesday 30 Aug 2006
4:42 pm

emmar

Fix #2981: table_name and id_column must be null for acs_message_revision object type

Options
    • -3
    • +3
    ./acs-messaging-create.sql
    • -0
    • +1
    ./upgrade/upgrade-5.3.0d1-5.3.0d2.sql
  3. … 3 more files in changeset.
Saturday 12 Aug 2006
12:23 am

donb

Made tables etc lower-case to satisfy Jeff's coding standards automated

tests.

Options
    • -7
    • +7
    ./acs-messaging-create.sql
  2. … 1 more file in changeset.
Sunday 25 Apr 2004
11:24 am

donb

Applied patch 394

Options
    • -4
    • +0
    ./upgrade/upgrade-4.6.2-4.6.3.sql
Friday 12 Mar 2004
8:19 pm

jeffd

various bug fixes for package_id, title addition to acs_objects

Options
    • -2
    • +1
    ./acs-messaging-packages.sql
  2. … 12 more files in changeset.
7:48 pm

jeffd

Remerge Timo's changes for tip 42,43, cf tip 53

Options
    • -1
    • +12
    ./acs-messaging-drop.sql
    • -75
    • +224
    ./acs-messaging-packages.sql
    • -0
    • +8
    ./upgrade/upgrade-5.1.0d1-5.1.0d2.sql
  4. … 95 more files in changeset.
Thursday 04 Mar 2004
3:52 pm

jeffd

rollback of Timo's name, package_id commit; see TIP 53

Options
    • -11
    • +0
    ./acs-messaging-drop.sql
    • -223
    • +74
    ./acs-messaging-packages.sql
    • -8
    • +0
    ./upgrade/upgrade-5.1.0d1-5.1.0d2.sql
  4. … 94 more files in changeset.
Tuesday 02 Mar 2004
6:00 pm

timoh

TIP#42,43: adding package_id and title to acs_objects table

Options
    • -1
    • +12
    ./acs-messaging-drop.sql
    • -75
    • +224
    ./acs-messaging-packages.sql
    • -0
    • +8
    ./upgrade/upgrade-5.1.0d1-5.1.0d2.sql
  4. … 94 more files in changeset.
Thursday 11 Dec 2003
10:39 pm

jeffd

merge of changes on oacs-5-0 branch to oacs-5-0-0b4 tag

Options
    • -4
    • +4
    ./acs-messaging-create.sql
    • -8
    • +6
    ./acs-messaging-packages.sql
    • -0
    • +11
    ./upgrade/upgrade-5.0.0b3-5.0.0b4.sql
  4. … 596 more files in changeset.
Monday 24 Nov 2003
6:25 pm

jeffd

file upgrade-5.0.0b3-5.0.0b4.sql was initially added on branch oacs-5-0.

Options
    • -0
    • +0
    ./upgrade/upgrade-5.0.0b3-5.0.0b4.sql
  2. … 3 more files in changeset.
Thursday 28 Aug 2003
11:41 am

lars

Merged 4.6.4d1 (unreleased) to HEAD. This marks the end of the life of the oacs-4-6 branch.

Options
    • -18
    • +18
    ./acs-messaging-packages.sql
  2. … 816 more files in changeset.
Saturday 17 May 2003
11:45 am

jeffd

merge of 4.6.3b1 to HEAD

Options
    • -3
    • +4
    ./acs-messaging-create.sql
    • -10
    • +10
    ./acs-messaging-drop.sql
    • -15
    • +14
    ./acs-messaging-packages.sql
    • -0
    • +102
    ./upgrade/upgrade-4.6.2-4.6.3.sql
  5. … 40 more files in changeset.
Tuesday 22 Apr 2003
2:26 am

donb

file upgrade-4.6.2-4.6.3.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./upgrade/upgrade-4.6.2-4.6.3.sql
Saturday 21 Dec 2002
11:27 pm

bartt

Patches to make OpenACS PG 7.3 compatible.

Options
    • -3
    • +3
    ./acs-messaging-create.sql
    • -5
    • +5
    ./acs-messaging-packages.sql
  3. … 53 more files in changeset.
Sunday 09 Dec 2001
10:08 pm

donb

Fixed some errors in my earlier hacking on hierarchical queries...

Options
    • -1
    • +2
    ./acs-messaging-create.sql
  2. … 3 more files in changeset.
5:21 am

donb

Added code to make use of David Walker's wonderfully abusive hack on the

pg_proc table that showed me how to write recursive SQL functions. We now

have good use of the index on tree_sortkey when climbing the tree, woo-hoo!

Options
    • -1
    • +8
    ./acs-messaging-create.sql
    • -2
    • +2
    ./acs-messaging-packages.sql
  3. … 17 more files in changeset.
Saturday 08 Dec 2001
2:17 am

donb

Changed the representation of tree_sortkeys from "text" to "bit varying".

Options
    • -26
    • +20
    ./acs-messaging-create.sql
    • -6
    • +4
    ./acs-messaging-packages.sql
  3. … 61 more files in changeset.
Thursday 01 Nov 2001
8:01 pm

donb

Bug fixes in the postgres ports of these packages ...

Options
    • -24
    • +30
    ./acs-messaging-packages.sql
  2. … 2 more files in changeset.
Wednesday 19 Sep 2001
2:54 am

donb

Fixed all sorts of cruft uncovered when I decided to fix the bug preventing

file upload in bboard.

Options
    • -4
    • +7
    ./acs-messaging-packages.sql
  2. … 5 more files in changeset.