OpenACS / openacs-4 / packages / new-portal / sql

postgresql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 18
Last Commit: 20 Dec
Commits this week: 0
Total Lines of Code (LoC): 3,546
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 6 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
    ./portal-core-create.sql
    • -0
    • +18
    ./upgrade/upgrade-2.10.0d3-2.10.0d4.sql
  3. … 3 more files 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
    ./upgrade/upgrade-2.10.0d3-2.10.0d4.sql
  2. … 1 more file in changeset.
Saturday 10 Aug 2019
4:33 pm

gustafn

improve spelling

Options
    • -2
    • +2
    ./portal-core-create.sql
  2. … 15 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
    ./api-create.sql
    • -0
    • +359
    ./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
    ./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
    ./objects-create.sql
    • -0
    • +14
    ./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
    • -49
    • +1
    ./objects-create.sql
  2. … 3 more files in changeset.
Tuesday 08 Aug 2017
1:47 am

gustafn

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

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

michaela

Fix constraint name

Options
    • -1
    • +1
    ./upgrade/upgrade-2.9.0-2.9.1d1.sql
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
    ./upgrade/upgrade-2.9.1d2-2.9.1d3.sql
5:16 pm

hectorr

Deleting old definition of portal_page__new/11

Options
    • -0
    • +5
    ./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
    ./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
    ./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
    ./api-create.sql
    • -29
    • +18
    ./portal-core-create.sql
    • -0
    • +151
    ./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
    ./upgrade/upgrade-2.9.0-2.9.1d1.sql
Friday 02 Oct 2015
2:54 pm

gustafn

- add change scripts

Options
    • -0
    • +1
    ./upgrade/upgrade-2.9.0b1-2.9.0b2.sql
  2. … 1 more file in changeset.
2:54 pm

gustafn

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

Options
    • -0
    • +0
    ./upgrade/upgrade-2.9.0b1-2.9.0b2.sql
  2. … 1 more file in changeset.
2:53 pm

gustafn

- add index on join column

Options
    • -1
    • +3
    ./portal-core-create.sql
  2. … 2 more files 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
    ./api-create.sql
    • -77
    • +77
    ./datasource-sc-create.sql
    • -34
    • +34
    ./datasource-sc-drop.sql
    • -40
    • +47
    ./defaults.sql
    • -6
    • +15
    ./upgrade/upgrade-2.0.3-2.1.0a1.sql
    • -12
    • +30
    ./upgrade/upgrade-2.1.0a1-2.1.0a2.sql
    • -38
    • +54
    ./upgrade/upgrade-2.1.2d1-2.1.2d2.sql
    • -38
    • +69
    ./upgrade/upgrade-2.3.0d2-2.3.0d3.sql
    • -39
    • +53
    ./upgrade/upgrade-2.3.0d3-2.3.0d4.sql
    • -22
    • +31
    ./upgrade/upgrade-2.3.1d1-2.3.1d2.sql
    • -36
    • +54
    ./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
    ./api-create.sql
    • -0
    • +185
    ./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
    ./api-create.sql
    • -0
    • +158
    ./upgrade/upgrade-2.3.1d1-2.3.1d2.sql
  3. … 186 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
    ./upgrade/upgrade-2.3.1d1-2.3.1d2.sql
  2. … 1 more file in changeset.
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
    ./api-create.sql
    • -0
    • +158
    ./upgrade/upgrade-2.3.1d1-2.3.1d2.sql
  3. … 4 more files in changeset.
Tuesday 15 May 2007
10:14 pm

donb

Merged changes to HEAD ...

Options
    • -29
    • +87
    ./api-create.sql
    • -3
    • +3
    ./objects-create.sql
    • -2
    • +5
    ./portal-core-create.sql
    • -0
    • +90
    ./upgrade/upgrade-2.3.0d2-2.3.0d3.sql
    • -0
    • +215
    ./upgrade/upgrade-2.3.0d3-2.3.0d4.sql
  6. … 1552 more files in changeset.
Thursday 29 Mar 2007
9:20 pm

donb

Initial install of accesskeys now works for PG

Options
    • -9
    • +11
    ./api-create.sql
    • -8
    • +12
    ./upgrade/upgrade-2.3.0d3-2.3.0d4.sql
  3. … 8 more files in changeset.
4:58 pm

donb

Partial fix to access key version initial install

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

donb

Access keys are single characters but ummm ... the message keys that define

them aren't. Oops!

Options
    • -2
    • +2
    ./api-create.sql
    • -2
    • +2
    ./portal-core-create.sql
    • -2
    • +2
    ./upgrade/upgrade-2.3.0d3-2.3.0d4.sql
  4. … 2 more files in changeset.
2:43 am

donb

file upgrade-2.3.0d3-2.3.0d4.sql was initially added on branch oacs-5-3.

Options
    • -0
    • +0
    ./upgrade/upgrade-2.3.0d3-2.3.0d4.sql
  2. … 1 more file in changeset.
2:43 am

donb

Added access keys to portal pages (oracle not tested yet)

Options
    • -13
    • +14
    ./api-create.sql
    • -1
    • +3
    ./portal-core-create.sql
    • -0
    • +56
    ./upgrade/upgrade-2.3.0d3-2.3.0d4.sql
  4. … 7 more files in changeset.
Monday 12 Mar 2007
4:00 am

donb

Added a column to portal_datasources so datasources can specify a directory

from which .css files should be linked to from the HTML <head> chunk of

the web page. Then I added the code to emit said link. And tested it for

Oracle and PG, fresh installs and upgrades both.

Options
    • -10
    • +64
    ./api-create.sql
    • -2
    • +3
    ./portal-core-create.sql
    • -0
    • +90
    ./upgrade/upgrade-2.3.0d2-2.3.0d3.sql
  4. … 7 more files in changeset.