OpenACS / openacs-4 / packages / dotlrn / sql

postgresql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

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

gustafn

merge with missing files

Options
    • -0
    • +0
    ./class-memberships-create.sql
  2. … 1464 more files in changeset.
Tuesday 03 Sep 2024
5:37 pm

gustafn

merge from oacs-5-10

Options
    • -5
    • +5
    ./class-memberships-create.sql
    • -43
    • +44
    ./custom-permissions.sql
    • -1
    • +1
    ./privacy-init.sql
    • -2
    • +2
    ./upgrade/upgrade-2.0a3-2.0.2.sql
    • -1
    • +1
    ./upgrade/upgrade-2.10.0d2-2.10.0d3.sql
  6. … 8095 more files in changeset.
Wednesday 15 Aug 2018
6:49 pm

gustafn

Removed obsolete @arch-tag

Options
    • -2
    • +1
    ./site-templates-create.sql
    • -2
    • +1
    ./site-templates-drop.sql
    • -2
    • +1
    ./upgrade/upgrade-2.2.0d1-2.2.0d2.sql
  4. … 24 more files in changeset.
Thursday 12 Jul 2018
1:13 pm

antoniop

Fix reference to acs_object_type.table_name so that it points to real tables (fixes automated tests)

Options
    • -4
    • +19
    ./dotlrn-init.sql
    • -4
    • +4
    ./privacy-init.sql
    • -0
    • +31
    ./upgrade/upgrade-2.10.0d2-2.10.0d3.sql
  4. … 4 more files in changeset.
Thursday 05 Jul 2018
1:16 pm

antoniop

Remove leftover acs_attribute without a database table counterpart (fixes regression test)

Options
    • -16
    • +1
    ./dotlrn-init.sql
  2. … 3 more files in changeset.
Tuesday 27 Mar 2018
4:22 pm

hectorr

Fix typos

Options
    • -1
    • +1
    ./upgrade/upgrade-2.9.0-2.9.1d1.sql
  2. … 68 more files in changeset.
Tuesday 08 Aug 2017
1:47 am

gustafn

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

Options
    • -2
    • +2
    ./admins-init.sql
    • -6
    • +6
    ./applet-sc-create.sql
    • -10
    • +8
    ./applets-create.sql
    • -13
    • +13
    ./class-memberships-create.sql
    • -6
    • +4
    ./communities-create.sql
    • -24
    • +11
    ./communities-package-create.sql
    • -18
    • +18
    ./dotlrn-init.sql
    • -2
    • +2
    ./externals-init.sql
    • -3
    • +3
    ./main-portlet-drop.sql
    • -3
    • +3
    ./privacy-init.sql
    • -2
    • +2
    ./privacy-package-create.sql
    • -2
    • +2
    ./professors-init.sql
    • -2
    • +2
    ./students-init.sql
    • -2
    • +2
    ./users-init.sql
    • -2
    • +2
    ./upgrade/upgrade-2.2.0d1-2.2.0d2.sql
  16. … 7820 more files in changeset.
Friday 24 Feb 2017
1:19 pm

gustafn

file upgrade-2.9.1b1-2.9.1b2.sql was initially added on branch oacs-5-9.

Options
    • -0
    • +0
    ./upgrade/upgrade-2.9.1b1-2.9.1b2.sql
  2. … 1 more file in changeset.
Wednesday 03 Aug 2016
12:08 pm

gustafn

file upgrade-2.9.1d3-2.9.1d4.sql was initially added on branch oacs-5-9.

Options
    • -0
    • +0
    ./upgrade/upgrade-2.9.1d3-2.9.1d4.sql
Sunday 12 Jun 2016
7:34 pm

gustafn

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

Options
    • -0
    • +0
    ./upgrade/upgrade-2.9.1d2-2.9.1d3.sql
Sunday 15 May 2016
8:34 pm

gustafn

file upgrade-2.9.0-2.9.1d1.sql was initially added on branch oacs-5-9.

Options
    • -0
    • +0
    ./upgrade/upgrade-2.9.0-2.9.1d1.sql
Monday 27 Oct 2014
5:38 pm

victorg

Merging back to HEAD branch oacs-5-8 (using tag vg-merge-oacs-5-8-from-20141027).

Options
    • -9
    • +5
    ./users-sanitize.sql
  2. … 2547 more files in changeset.
Friday 01 Nov 2013
10:08 pm

gustafn

- use $$ quoting in postgres SQL

- use name parameter for SQL functions

- provide compatility with pg9

- replace deprecated "acs_sc_call" by "acs_sc::invoke"

- replace deprecated "ad_maybe_redirect_for_registration" by "auth::require_login"

- brace expressions

- favor tcl-compilable string comparisons

- don't use numeric comparison operator for non-numeric arguments

- use numeric comparison operator for truth value comparisons

- use "in" or "ni" expression instead of "lsearch"

- bump version number to indicate compatibility with 5.8.1

Options
    • -25
    • +25
    ./admin-profile-provider-create.sql
    • -20
    • +27
    ./admin-profile-provider-drop.sql
    • -22
    • +29
    ./admins-init.sql
    • -18
    • +31
    ./admins-package-create.sql
    • -20
    • +34
    ./admins-sanitize.sql
    • -140
    • +140
    ./applet-sc-create.sql
    • -57
    • +57
    ./applet-sc-drop.sql
    • -15
    • +15
    ./class-membership-drop.sql
    • -55
    • +55
    ./class-memberships-create.sql
    • -57
    • +93
    ./classes-create.sql
    • -22
    • +34
    ./clubs-create.sql
    • -94
    • +174
    ./communities-package-create.sql
    • -14
    • +28
    ./communities-tree-create.sql
    • -105
    • +196
    ./community-memberships-packages-create.sql
    • -12
    • +21
    ./custom-permissions.sql
  16. … 132 more files in changeset.
Monday 08 Nov 2010
2:17 pm

victorg

PG 9.0 compatibility. Changes regarding the usage of sequences in order to avoid errors of 'missing FROM-clause message' on queries.

Options
    • -2
    • +2
    ./communities-package-create.sql
    • -2
    • +2
    ./site-templates-create.sql
    • -0
    • +73
    ./upgrade/upgrade-2.6.0d1-2.6.0d2.sql
  4. … 6 more files in changeset.
Sunday 01 Feb 2009
10:56 pm

donb

Upgrade scripts for application groups added to .lrn

Options
    • -11
    • +11
    ./communities-package-create.sql
    • -0
    • +192
    ./upgrade/upgrade-2.5.0d2-2.5.0d3.sql
  3. … 2 more files in changeset.
Tuesday 08 Aug 2006
11:26 pm

donb

First shot at merging oacs-5-2 apps used in .LRN to HEAD.

Options
    • -1
    • +1
    ./admin-profile-provider-create.sql
    • -1
    • +1
    ./admin-profile-provider-drop.sql
    • -1
    • +1
    ./admins-create.sql
    • -1
    • +1
    ./admins-drop.sql
    • -1
    • +1
    ./admins-init.sql
    • -1
    • +1
    ./admins-package-create.sql
    • -1
    • +1
    ./admins-package-drop.sql
    • -1
    • +1
    ./admins-sanitize.sql
    • -1
    • +1
    ./applets-create.sql
    • -1
    • +1
    ./applets-drop.sql
    • -1
    • +1
    ./class-membership-drop.sql
    • -1
    • +1
    ./class-memberships-create.sql
    • -1
    • +1
    ./classes-create.sql
    • -1
    • +1
    ./classes-drop.sql
    • -1
    • +1
    ./clubs-create.sql
  16. … 2464 more files in changeset.
Tuesday 28 Mar 2006
1:58 am

donb

file upgrade-2.2.0d1-2.2.0d2.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./upgrade/upgrade-2.2.0d1-2.2.0d2.sql
Tuesday 14 Mar 2006
4:04 am

donb

file upgrade-2.1.4a1-2.2.0a3.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./upgrade/upgrade-2.1.4a1-2.2.0a3.sql
Tuesday 13 Dec 2005
4:32 pm

victorg

file site-templates-create.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./site-templates-create.sql
4:32 pm

victorg

file upgrade-2.1.3-2.2.0a1.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./upgrade/upgrade-2.1.3-2.2.0a1.sql
4:32 pm

victorg

file site-templates-drop.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./site-templates-drop.sql
Monday 12 Dec 2005
3:09 pm

maltes

file upgrade-2.1.3-2.2.0d1.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./upgrade/upgrade-2.1.3-2.2.0d1.sql
Sunday 27 Nov 2005
7:57 am

maltes

file upgrade-2.1-2.2.0d1.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./upgrade/upgrade-2.1-2.2.0d1.sql
Tuesday 22 Feb 2005
9:28 pm

jeffd

remove upgrade scripts that were created in darkages for which there is no relevant deployed instance

Options
    • -27
    • +0
    ./upgrade/upgrade-july-25-2002.sql
  2. … 3 more files in changeset.
Tuesday 20 Apr 2004
11:12 pm

jeffd

merge all the changes on the oacs-5-1 and dotlrn-2-0 branches up to tag jcd-merge-20040420

Options
    • -0
    • +2
    ./dotlrn-create.sql
    • -0
    • +99
    ./privacy-init.sql
    • -0
    • +123
    ./privacy-package-create.sql
    • -0
    • +203
    ./upgrade/upgrade-2.0a3-2.0.2.sql
  5. … 644 more files in changeset.
Monday 01 Mar 2004
5:40 pm

andrewg

file upgrade-2.0a3-2.0.2.sql was initially added on branch dotlrn-2-0.

Options
    • -0
    • +0
    ./upgrade/upgrade-2.0a3-2.0.2.sql
  2. … 1 more file in changeset.
Wednesday 25 Feb 2004
10:24 pm

andrewg

file upgrade-feb-20-2004.sql was initially added on branch dotlrn-2-0.

Options
    • -0
    • +0
    ./upgrade/upgrade-feb-20-2004.sql
Tuesday 24 Feb 2004
8:56 pm

andrewg

file privacy-package-create.sql was initially added on branch dotlrn-2-0.

Options
    • -0
    • +0
    ./privacy-package-create.sql
  2. … 1 more file in changeset.
Saturday 21 Feb 2004
3:34 am

andrewg

file privacy-init.sql was initially added on branch dotlrn-2-0.

Options
    • -0
    • +0
    ./privacy-init.sql
  2. … 1 more file in changeset.
Friday 29 Aug 2003
12:06 pm

peterm

removing the admin role as it already exists in the acs-kernel now

Options
    • -2
    • +1
    ./dotlrn-init.sql
  2. … 1 more file in changeset.