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: 17:24
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
Sunday 12 Jun 2016
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.
4:00 am

donb

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

Options
    • -0
    • +0
    ./upgrade/upgrade-2.3.0d2-2.3.0d3.sql
  2. … 1 more file in changeset.
Sunday 21 Jan 2007
12:35 am

donb

Someone decided that defining a non-existent package and table when declaring

the "portal_element_theme" object type was a brilliant thing to do, seeing

as it breaks package_instantiate_object and all.

Options
    • -3
    • +3
    ./objects-create.sql
  2. … 4 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
    • -10
    • +13
    ./api-create.sql
    • -1
    • +1
    ./defaults.sql
    • -1
    • +6
    ./portal-core-create.sql
    • -0
    • +225
    ./upgrade/upgrade-2.1.2d1-2.1.2d2.sql
  5. … 2475 more files in changeset.
Wednesday 28 Jun 2006
2:40 am

donb

Removed KELP portal theme

Options
    • -8
    • +1
    ./defaults.sql
  2. … 1 more file in changeset.
Monday 26 Sep 2005
10:57 am

victorg

commit to OACS-5-2 merge of changes on OACS-5-1

(using tag vg-merge-dotlrn-2-1-20050922) for packages under dotlrn-all

Options
    • -10
    • +13
    ./api-create.sql
    • -1
    • +6
    ./portal-core-create.sql
    • -0
    • +225
    ./upgrade/upgrade-2.1.2d1-2.1.2d2.sql
  4. … 89 more files in changeset.
Saturday 16 Jul 2005
5:20 pm

victorg

file upgrade-2.1.2d1-2.1.2d2.sql was added on branch oacs-5-2 on 2005-09-26 08:57:37 +0000

Options
    • -0
    • +0
    ./upgrade/upgrade-2.1.2d1-2.1.2d2.sql
5:20 pm

victorg

Hidden Pages in Portals ( for postgresql )

Options
    • -10
    • +13
    ./api-create.sql
    • -1
    • +6
    ./portal-core-create.sql
    • -0
    • +225
    ./upgrade/upgrade-2.1.2d1-2.1.2d2.sql
  4. … 2 more files in changeset.
5:20 pm

victorg

file upgrade-2.1.2d1-2.1.2d2.sql was initially added on branch oacs-5-1.

Options
    • -0
    • +0
    ./upgrade/upgrade-2.1.2d1-2.1.2d2.sql
Thursday 16 Jun 2005
5:54 pm

maltes

Added KELP theme to the I18N

Options
    • -1
    • +8
    ./defaults.sql
  2. … 1 more file in changeset.
Thursday 05 May 2005
12:17 pm

giancarlol

Added kelp-theme

Options
    • -1
    • +8
    ./defaults.sql
  2. … 1 more file in changeset.
Thursday 13 Jan 2005
2:54 pm

jeffd

commit to HEAD of merge of changes on oacs-5-1 branch between tags jcd-merge-5-1-20040724 and jcd-merge-5-1-20050111

Options
    • -1
    • +1
    ./upgrade/upgrade-2.0.3-2.1.0a1.sql
  2. … 2275 more files in changeset.
Thursday 26 Aug 2004
6:27 pm

maltes

It is wise to use create or replace with upgrades, as the function might already exist (especially if someone forgot to upgrade the version number when adding datamodell changes

Options
    • -1
    • +1
    ./upgrade/upgrade-2.0.3-2.1.0a1.sql