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 11 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Friday 02 Oct 2015
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.
3:14 am

donb

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

them aren't. Oops!

Options
    • -2
    • +2
    ./oracle/portal-core-create.sql
    • -1
    • +1
    ./oracle/upgrade/upgrade-2.3.0d3-2.3.0d4.sql
    • -2
    • +2
    ./postgresql/api-create.sql
    • -2
    • +2
    ./postgresql/portal-core-create.sql
    • -2
    • +2
    ./postgresql/upgrade/upgrade-2.3.0d3-2.3.0d4.sql
2:43 am

donb

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

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-2.3.0d3-2.3.0d4.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-2.3.0d3-2.3.0d4.sql
2:43 am

donb

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

Options
    • -3
    • +5
    ./oracle/api-create.sql
    • -1
    • +3
    ./oracle/portal-core-create.sql
    • -0
    • +132
    ./oracle/upgrade/upgrade-2.3.0d3-2.3.0d4.sql
    • -13
    • +14
    ./postgresql/api-create.sql
    • -1
    • +3
    ./postgresql/portal-core-create.sql
    • -0
    • +56
    ./postgresql/upgrade/upgrade-2.3.0d3-2.3.0d4.sql
  7. … 4 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
    • -3
    • +5
    ./oracle/api-create.sql
    • -2
    • +3
    ./oracle/portal-core-create.sql
    • -0
    • +97
    ./oracle/upgrade/upgrade-2.3.0d2-2.3.0d3.sql
    • -10
    • +64
    ./postgresql/api-create.sql
    • -2
    • +3
    ./postgresql/portal-core-create.sql
    • -0
    • +90
    ./postgresql/upgrade/upgrade-2.3.0d2-2.3.0d3.sql
  7. … 4 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
    ./oracle/upgrade/upgrade-2.3.0d2-2.3.0d3.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-2.3.0d2-2.3.0d3.sql
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
    ./oracle/objects-create.sql
    • -3
    • +3
    ./postgresql/objects-create.sql
  3. … 3 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
    • -3
    • +5
    ./oracle/api-create.sql
    • -1
    • +1
    ./oracle/defaults.sql
    • -1
    • +6
    ./oracle/portal-core-create.sql
    • -0
    • +143
    ./oracle/upgrade/upgrade-2.1.2d1-2.1.2d2.sql
    • -10
    • +13
    ./postgresql/api-create.sql
    • -1
    • +1
    ./postgresql/defaults.sql
    • -1
    • +6
    ./postgresql/portal-core-create.sql
    • -0
    • +225
    ./postgresql/upgrade/upgrade-2.1.2d1-2.1.2d2.sql
  9. … 2471 more files in changeset.
Wednesday 28 Jun 2006
2:40 am

donb

Removed KELP portal theme

Options
    • -7
    • +1
    ./oracle/defaults.sql
    • -8
    • +1
    ./postgresql/defaults.sql
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
    • -3
    • +5
    ./oracle/api-create.sql
    • -1
    • +7
    ./oracle/defaults.sql
    • -1
    • +6
    ./oracle/portal-core-create.sql
    • -0
    • +143
    ./oracle/upgrade/upgrade-2.1.2d1-2.1.2d2.sql
    • -10
    • +13
    ./postgresql/api-create.sql
    • -1
    • +6
    ./postgresql/portal-core-create.sql
    • -0
    • +225
    ./postgresql/upgrade/upgrade-2.1.2d1-2.1.2d2.sql
  8. … 85 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
    ./postgresql/upgrade/upgrade-2.1.2d1-2.1.2d2.sql
5:20 pm

victorg

Hidden Pages in Portals ( for postgresql )

Options
    • -10
    • +13
    ./postgresql/api-create.sql
    • -1
    • +6
    ./postgresql/portal-core-create.sql
    • -0
    • +225
    ./postgresql/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
    ./postgresql/upgrade/upgrade-2.1.2d1-2.1.2d2.sql
Friday 15 Jul 2005
9:55 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
    ./oracle/upgrade/upgrade-2.1.2d1-2.1.2d2.sql
9:55 pm

andrewg

Fixing a numbering error, moving upgrade-2.1.1-2.1.2d1.sql to upgrade-2.1.2d1-2.1.2d2.sql

Options
    • -143
    • +0
    ./oracle/upgrade/upgrade-2.1.1-2.1.2d1.sql
    • -0
    • +143
    ./oracle/upgrade/upgrade-2.1.2d1-2.1.2d2.sql
9:55 pm

andrewg

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

Options
    • -0
    • +0
    ./oracle/upgrade/upgrade-2.1.2d1-2.1.2d2.sql
9:01 pm

andrewg

Adding a hidden_p flag to the portal_pages table, to provide a way to exclude certain portal pages from the main navigation. Visibility will typically be toggled from the Customize Layout page in dotlrn.

Options
    • -3
    • +5
    ./oracle/api-create.sql
    • -1
    • +6
    ./oracle/portal-core-create.sql
    • -0
    • +143
    ./oracle/upgrade/upgrade-2.1.1-2.1.2d1.sql
  4. … 3 more files in changeset.
9:01 pm

andrewg

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

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

maltes

Added KELP theme to the I18N

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

giancarlol

Added kelp-theme

Options
    • -1
    • +7
    ./oracle/defaults.sql
    • -1
    • +8
    ./postgresql/defaults.sql
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
    • -0
    • +570
    ./oracle/upgrade/upgrade-2.1.0a-2.1.0a2.sql
    • -1
    • +1
    ./postgresql/upgrade/upgrade-2.0.3-2.1.0a1.sql
  3. … 2274 more files in changeset.