OpenACS / openacs-4 / packages / new-portal

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 21
Last Commit: 20 Dec
Commits this week: 0
Total Lines of Code (LoC): 7,763
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
Monday 23 Nov 2020
4:49 pm

gernst

Package new-portal: additional database indices for tables "portal_element_map", "portal_element_parameters" and "portal_datasource_def_params"; bumped package version to 2.10.0d4

Options
    • -1
    • +8
    ./oracle/portal-core-create.sql
    • -0
    • +18
    ./oracle/upgrade/upgrade-2.10.0d3-2.10.0d4.sql
    • -1
    • +8
    ./postgresql/portal-core-create.sql
    • -0
    • +18
    ./postgresql/upgrade/upgrade-2.10.0d3-2.10.0d4.sql
  5. … 1 more file in changeset.
4:49 pm

gernst

file upgrade-2.10.0d3-2.10.0d4.sql was initially added on branch oacs-5-10.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-2.10.0d3-2.10.0d4.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-2.10.0d3-2.10.0d4.sql
Thursday 15 Aug 2019
12:31 pm

gustafn

improve spelling

Options
    • -2
    • +2
    ./oracle/portal-core-create.sql
  2. … 3 more files in changeset.
Saturday 10 Aug 2019
4:33 pm

gustafn

improve spelling

Options
    • -2
    • +2
    ./oracle/portal-core-create.sql
    • -2
    • +2
    ./postgresql/portal-core-create.sql
  3. … 14 more files in changeset.
Friday 14 Sep 2018
4:11 pm

gernst

prefer acs_object__new/9 over acs_object__new/7

Options
    • -136
    • +134
    ./postgresql/api-create.sql
    • -0
    • +359
    ./postgresql/upgrade/upgrade-2.10.0d2-2.10.0d3.sql
  3. … 1 more file in changeset.
Wednesday 15 Aug 2018
6:49 pm

gustafn

Removed obsolete @arch-tag

Options
    • -2
    • +1
    ./postgresql/upgrade/upgrade-2.1.2d1-2.1.2d2.sql
  2. … 26 more files in changeset.
Wednesday 11 Jul 2018
6:32 pm

antoniop

Align case of acs_object_type with that of the actual table (fixes automated tests)

This change intentionally ingores Oracle, as its behavior with respect to case is not clear to me.

Options
    • -10
    • +10
    ./postgresql/objects-create.sql
    • -0
    • +14
    ./postgresql/upgrade/upgrade-2.10.0d1-2.10.0d2.sql
  3. … 1 more file in changeset.
Monday 09 Jul 2018
6:36 pm

antoniop

Remove leftover acs_attribute definitions with no database table counterpart (fixes tests)

Options
    • -25
    • +1
    ./oracle/objects-create.sql
    • -49
    • +1
    ./postgresql/objects-create.sql
  3. … 2 more files in changeset.
Thursday 12 Apr 2018
9:47 am

hectorr

Fix typos

Options
    • -2
    • +2
    ./oracle/api-create.sql
    • -2
    • +2
    ./oracle/upgrade/upgrade-0.1a-0.2d1.sql
    • -1
    • +1
    ./oracle/upgrade/upgrade-2.1.0a-2.1.0a2.sql
    • -1
    • +1
    ./oracle/upgrade/upgrade-2.3.0d3-2.3.0d4.sql
    • -2
    • +2
    ./oracle/upgrade/upgrade-2.3.1d1-2.3.1d2.sql
  6. … 17 more files in changeset.
Tuesday 08 Aug 2017
1:47 am

gustafn

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

Options
    • -3
    • +3
    ./oracle/datasource-sc-create.sql
    • -1
    • +3
    ./oracle/portal-core-create.sql
    • -0
    • +1
    ./oracle/upgrade/upgrade-2.9.0b1-2.9.0b2.sql
    • -33
    • +5
    ./postgresql/api-create.sql
    • -29
    • +20
    ./postgresql/portal-core-create.sql
    • -0
    • +151
    ./postgresql/upgrade/upgrade-2.9.0-2.9.1d1.sql
    • -0
    • +1
    ./postgresql/upgrade/upgrade-2.9.0b1-2.9.0b2.sql
    • -0
    • +8
    ./postgresql/upgrade/upgrade-2.9.1d1-2.9.1d2.sql
    • -0
    • +5
    ./postgresql/upgrade/upgrade-2.9.1d2-2.9.1d3.sql
  10. … 7826 more files in changeset.
Wednesday 31 May 2017
2:29 pm

michaela

Fix constraint name

Options
    • -1
    • +1
    ./postgresql/upgrade/upgrade-2.9.0-2.9.1d1.sql
Saturday 22 Apr 2017
2:25 pm

gustafn

Fix spelling errors

Options
    • -3
    • +3
    ./oracle/datasource-sc-create.sql
  2. … 22 more files in changeset.
Tuesday 23 Aug 2016
5:16 pm

hectorr

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

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-2.9.1d2-2.9.1d3.sql
5:16 pm

hectorr

Deleting old definition of portal_page__new/11

Options
    • -0
    • +5
    ./postgresql/upgrade/upgrade-2.9.1d2-2.9.1d3.sql
  2. … 1 more file in changeset.
Sunday 12 Jun 2016
7:31 pm

gustafn

- cleanup for last commit (remove old function defs with varchar for boolean attributes)

Options
    • -0
    • +8
    ./postgresql/upgrade/upgrade-2.9.1d1-2.9.1d2.sql
7:31 pm

gustafn

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

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-2.9.1d1-2.9.1d2.sql
Saturday 14 May 2016
7:08 pm

gustafn

Alter caveman style booleans (type character(1)) to real SQL boolean types.

Options
    • -33
    • +5
    ./postgresql/api-create.sql
    • -29
    • +18
    ./postgresql/portal-core-create.sql
    • -0
    • +151
    ./postgresql/upgrade/upgrade-2.9.0-2.9.1d1.sql
  4. … 1 more file in changeset.
7:08 pm

gustafn

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

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-2.9.0-2.9.1d1.sql
Friday 02 Oct 2015
2:54 pm

gustafn

- add change scripts

Options
    • -0
    • +1
    ./oracle/upgrade/upgrade-2.9.0b1-2.9.0b2.sql
    • -0
    • +1
    ./postgresql/upgrade/upgrade-2.9.0b1-2.9.0b2.sql
2:54 pm

gustafn

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

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-2.9.0b1-2.9.0b2.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-2.9.0b1-2.9.0b2.sql
2:53 pm

gustafn

- add index on join column

Options
    • -1
    • +3
    ./oracle/portal-core-create.sql
    • -1
    • +3
    ./postgresql/portal-core-create.sql
  3. … 1 more file in changeset.
Friday 01 Nov 2013
10:45 pm

gustafn

- use $$ quoting in postgres SQL

- use name parameter for SQL functions

- favor tcl-compilable string comparisons

- brace expressions

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

- bump version number to indicate compatibility with 5.8.1

Options
    • -197
    • +336
    ./postgresql/api-create.sql
    • -77
    • +77
    ./postgresql/datasource-sc-create.sql
    • -34
    • +34
    ./postgresql/datasource-sc-drop.sql
    • -40
    • +47
    ./postgresql/defaults.sql
    • -6
    • +15
    ./postgresql/upgrade/upgrade-2.0.3-2.1.0a1.sql
    • -12
    • +30
    ./postgresql/upgrade/upgrade-2.1.0a1-2.1.0a2.sql
    • -38
    • +54
    ./postgresql/upgrade/upgrade-2.1.2d1-2.1.2d2.sql
    • -38
    • +69
    ./postgresql/upgrade/upgrade-2.3.0d2-2.3.0d3.sql
    • -39
    • +53
    ./postgresql/upgrade/upgrade-2.3.0d3-2.3.0d4.sql
    • -22
    • +31
    ./postgresql/upgrade/upgrade-2.3.1d1-2.3.1d2.sql
    • -36
    • +54
    ./postgresql/upgrade/upgrade-2.6.0d1-2.6.0d2.sql
  12. … 9 more files in changeset.
Monday 08 Nov 2010
8:23 am

victorg

PG 9.0 compatibility. Avoiding fetching next value of sequences using a view.

Options
    • -4
    • +4
    ./postgresql/api-create.sql
    • -0
    • +185
    ./postgresql/upgrade/upgrade-2.6.0d1-2.6.0d2.sql
  3. … 4 more files in changeset.
Monday 08 Oct 2007
12:36 am

donb

Merged oacs-5-3 branch to HEAD

Options
    • -2
    • +3
    ./oracle/api-create.sql
    • -0
    • +610
    ./oracle/upgrade/upgrade-2.3.1d1-2.3.1d2.sql
    • -2
    • +3
    ./postgresql/api-create.sql
    • -0
    • +158
    ./postgresql/upgrade/upgrade-2.3.1d1-2.3.1d2.sql
  5. … 184 more files in changeset.
Friday 06 Jul 2007
12:02 am

daveb

file upgrade-2.3.1d1-2.3.1d2.sql was initially added on branch oacs-5-3.

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-2.3.1d1-2.3.1d2.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-2.3.1d1-2.3.1d2.sql
12:02 am

daveb

Fix bug where database does not magically return portal pages in sorted

order, causing user confusion when the pages end up out of order.

No upgrade for existing pages since I don't want to stomp all over

portals that may have been customized.

Options
    • -2
    • +3
    ./oracle/api-create.sql
    • -0
    • +610
    ./oracle/upgrade/upgrade-2.3.1d1-2.3.1d2.sql
    • -2
    • +3
    ./postgresql/api-create.sql
    • -0
    • +158
    ./postgresql/upgrade/upgrade-2.3.1d1-2.3.1d2.sql
  5. … 2 more files in changeset.
Tuesday 15 May 2007
10:14 pm

donb

Merged changes to HEAD ...

Options
    • -5
    • +13
    ./oracle/api-create.sql
    • -3
    • +3
    ./oracle/objects-create.sql
    • -2
    • +5
    ./oracle/portal-core-create.sql
    • -0
    • +97
    ./oracle/upgrade/upgrade-2.3.0d2-2.3.0d3.sql
    • -0
    • +324
    ./oracle/upgrade/upgrade-2.3.0d3-2.3.0d4.sql
    • -29
    • +87
    ./postgresql/api-create.sql
    • -3
    • +3
    ./postgresql/objects-create.sql
    • -2
    • +5
    ./postgresql/portal-core-create.sql
    • -0
    • +90
    ./postgresql/upgrade/upgrade-2.3.0d2-2.3.0d3.sql
    • -0
    • +215
    ./postgresql/upgrade/upgrade-2.3.0d3-2.3.0d4.sql
  11. … 1547 more files in changeset.
Thursday 29 Mar 2007
9:29 pm

donb

Typo in oracle upgrade script

Options
    • -1
    • +1
    ./oracle/upgrade/upgrade-2.3.0d3-2.3.0d4.sql
9:20 pm

donb

Initial install of accesskeys now works for PG

Options
    • -1
    • +5
    ./oracle/api-create.sql
    • -0
    • +192
    ./oracle/upgrade/upgrade-2.3.0d3-2.3.0d4.sql
    • -9
    • +11
    ./postgresql/api-create.sql
    • -8
    • +12
    ./postgresql/upgrade/upgrade-2.3.0d3-2.3.0d4.sql
  5. … 6 more files in changeset.
4:58 pm

donb

Partial fix to access key version initial install

Options
    • -1
    • +2
    ./postgresql/api-create.sql
    • -0
    • +155
    ./postgresql/upgrade/upgrade-2.3.0d3-2.3.0d4.sql
  3. … 2 more files in changeset.