OpenACS / openacs-4 / packages / views

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 6
Last Commit: 28 Dec 24
Commits this week: 0
Total Lines of Code (LoC): 1,018
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 7 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Wednesday 04 Apr 2018
10:11 am

hectorr

Fix typos

Options
    • -2
    • +2
    ./oracle/views-create.sql
    • -2
    • +2
    ./oracle/views-datamodel.sql
  3. … 22 more files in changeset.
Saturday 02 Nov 2013
5:15 pm

gustafn

- use $$ quoting in postgres SQL

- use named parameters for SQL functions

- fix/complete define_function_args

- fix return type of trigger

- brace expressions

- favor tcl-compilable string comparisons

- bump version number

Options
    • -14
    • +28
    ./postgresql/views-procs.sql
    • -13
    • +17
    ./postgresql/views-triggers.sql
    • -13
    • +22
    ./postgresql/upgrade/upgrade-0.1d-0.1d2.sql
    • -26
    • +47
    ./postgresql/upgrade/upgrade-0.1d2-0.1d3.sql
  5. … 3 more files in changeset.
Thursday 02 Aug 2007
10:31 am

marioa

Problem with PL/SQL function VIEWS_VIEW_BY_TYPE. Select return OCI_NO_DATA

Options
    • -4
    • +7
    ./oracle/views-procs.sql
    • -3
    • +6
    ./oracle/upgrade/upgrade-0.1d2-0.1d3.sql
Wednesday 01 Aug 2007
10:59 am

marioa

Change for oracle compatibility and upgrade script for this.

Options
    • -16
    • +16
    ./postgresql/views-datamodel.sql
    • -5
    • +8
    ./postgresql/views-drop.sql
    • -14
    • +14
    ./postgresql/views-procs.sql
    • -21
    • +21
    ./postgresql/views-triggers.sql
    • -0
    • +156
    ./postgresql/upgrade/upgrade-0.1d2-0.1d3.sql
10:59 am

marioa

Add oracle support and upgrade script from lors-oracle-port branch

Options
    • -0
    • +21
    ./oracle/views-create.sql
    • -0
    • +99
    ./oracle/views-datamodel.sql
    • -0
    • +18
    ./oracle/views-drop.sql
    • -0
    • +90
    ./oracle/views-procs.sql
    • -0
    • +69
    ./oracle/views-triggers.sql
    • -0
    • +111
    ./oracle/upgrade/upgrade-0.1d2-0.1d3.sql
Monday 23 Jul 2007
7:25 am

maltes

Added support for multiple view types

Options
    • -4
    • +39
    ./postgresql/views-datamodel.sql
    • -1
    • +28
    ./postgresql/views-procs.sql
    • -1
    • +37
    ./postgresql/views-triggers.sql
    • -0
    • +109
    ./postgresql/upgrade/upgrade-0.1d-0.1d2.sql
  5. … 2 more files in changeset.
Wednesday 22 Nov 2006
12:36 pm

marioa

Change parameters names for compatiblity

Options
    • -10
    • +12
    ./oracle/views-packages.sql
Monday 24 Jul 2006
1:32 pm

marioa

Datamodel, package and triggers to Oracle port

Options
    • -0
    • +20
    ./oracle/views-create.sql
    • -0
    • +57
    ./oracle/views-datamodel.sql
    • -0
    • +18
    ./oracle/views-drop.sql
    • -0
    • +49
    ./oracle/views-packages.sql
    • -0
    • +41
    ./oracle/views-triggers.sql
1:32 pm

marioa

file views-create.sql was initially added on branch lors-oracle-port.

Options
    • -0
    • +0
    ./oracle/views-create.sql
1:32 pm

marioa

file views-triggers.sql was initially added on branch lors-oracle-port.

Options
    • -0
    • +0
    ./oracle/views-triggers.sql
1:32 pm

marioa

file views-packages.sql was initially added on branch lors-oracle-port.

Options
    • -0
    • +0
    ./oracle/views-packages.sql
1:32 pm

marioa

file views-drop.sql was initially added on branch lors-oracle-port.

Options
    • -0
    • +0
    ./oracle/views-drop.sql
1:32 pm

marioa

file views-datamodel.sql was initially added on branch lors-oracle-port.

Options
    • -0
    • +0
    ./oracle/views-datamodel.sql
Friday 21 Jul 2006
1:32 pm

marioa

Modify to Oracle compatibility

Options
    • -18
    • +10
    ./postgresql/views-datamodel.sql
    • -4
    • +4
    ./postgresql/views-drop.sql
    • -6
    • +6
    ./postgresql/views-procs.sql
    • -12
    • +12
    ./postgresql/views-triggers.sql
1:29 pm

marioa

This file upgrade datamodel for Oracle compatibility

Options
    • -0
    • +83
    ./postgresql/upgrade/upgrade-0.2d1-0.2d2.sql
1:29 pm

marioa

file upgrade-0.2d1-0.2d2.sql was initially added on branch lors-oracle-port.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-0.2d1-0.2d2.sql
Wednesday 05 Jan 2005
6:15 pm

rocaelh

adding views to oacs-5-1 branch

Options
    • -1
    • +1
    ./postgresql/views-create.sql
    • -1
    • +1
    ./postgresql/views-datamodel.sql
    • -1
    • +1
    ./postgresql/views-drop.sql
    • -1
    • +1
    ./postgresql/views-procs.sql
    • -1
    • +1
    ./postgresql/views-triggers.sql
  6. … 2 more files in changeset.
Thursday 20 May 2004
3:01 pm

jeffd

break out view tracking stuff from cop-base

Options
    • -0
    • +21
    ./postgresql/views-create.sql
    • -0
    • +63
    ./postgresql/views-datamodel.sql
    • -0
    • +18
    ./postgresql/views-drop.sql
    • -0
    • +40
    ./postgresql/views-procs.sql
    • -0
    • +48
    ./postgresql/views-triggers.sql
  6. … 2 more files in changeset.