OpenACS / openacs-4 / packages / photo-album

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 10
Last Commit: 14 Nov
Commits this week: 0
Total Lines of Code (LoC): 3,339
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 22 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Friday 26 May 2017
8:05 pm

gustafn

Fix typos

Options
    • -2
    • +2
    ./oracle/permissions.sql
    • -2
    • +2
    ./postgresql/permissions.sql
  3. … 13 more files in changeset.
Friday 15 Dec 2006
11:45 pm

emmar

Merging dotlrn-all and dotlrn-extras from oacs-5-2

Options
    • -4
    • +2
    ./postgresql/pl-pgsql.sql
  2. … 882 more files in changeset.
Tuesday 05 Dec 2006
12:31 am

donb

There was an oracle statement to raise an exception in this file. Someone

missed it while porting. I'm guessing that older PG didn't check that

functions exist while processing the file and that stricter error checking

in 8.x caused the bug to raise a compile-time error.

Options
    • -4
    • +2
    ./postgresql/pl-pgsql.sql
Saturday 12 Mar 2005
11:06 pm

andrewg

Fix for but 1599. Resetting the default for title pa_photo.new so that the specification and body match. We set to 'photo' because cr_revisions.title must be non null.

Options
    • -2
    • +2
    ./oracle/plsql-packages.sql
Thursday 29 Apr 2004
5:23 pm

jeffd

fix a couple translation errors, make pa_package_root_folder_map cascade deletes, bump version

Options
    • -4
    • +5
    ./oracle/photo-album-create.sql
    • -0
    • +11
    ./oracle/upgrade/upgrade-5.2.0d1-5.2.0d2.sql
    • -4
    • +6
    ./postgresql/photo-album-create.sql
    • -0
    • +11
    ./postgresql/upgrade/upgrade-5.2.0d1-5.2.0d2.sql
  5. … 3 more files in changeset.
Wednesday 17 Mar 2004
12:00 pm

jeffd

fixes the name method for collection object type create

Options
    • -3
    • +3
    ./postgresql/photo-album-clip.sql
Thursday 20 Nov 2003
3:46 pm

jlaine

Changed phrases with iconic photo to cover photo

Options
    • -2
    • +2
    ./oracle/photo-album-create.sql
    • -2
    • +2
    ./oracle/upgrade/upgrade-4.0.1-4.5.sql
    • -2
    • +2
    ./postgresql/photo-album-create.sql
    • -2
    • +2
    ./postgresql/upgrade/upgrade-4.0.1-4.5.sql
  5. … 1 more file in changeset.
2:03 pm

jlaine

Took away phrases with 'iconic photo'

Options
    • -2
    • +2
    ./oracle/photo-album-create.sql
    • -2
    • +2
    ./oracle/upgrade/upgrade-4.0.1-4.5.sql
    • -2
    • +2
    ./postgresql/photo-album-create.sql
    • -2
    • +2
    ./postgresql/upgrade/upgrade-4.0.1-4.5.sql
  5. … 1 more file in changeset.
Wednesday 08 Oct 2003
6:53 pm

mohanp

Added upgrade to upgrade to changes made for Oracle 9i support

Options
    • -0
    • +524
    ./oracle/upgrade/upgrade-4.6.0-5.0d1.sql
  2. … 23 more files in changeset.
Tuesday 30 Sep 2003
2:10 pm

mohanp

Oracle9i porting changes

- Changed procedure names from delete to del

- Changed view declaration to use actual column names

- Changed "rel_constraints_violated_one" and "rel_constraints_violated_two"

(http://openacs.org/forums/message-view?message_id=81045)

Options
    • -2
    • +2
    ./oracle/pa-clip-drop.sql
    • -5
    • +5
    ./oracle/photo-album-clip.sql
    • -5
    • +5
    ./oracle/photo-album-drop.sql
    • -14
    • +14
    ./oracle/plsql-packages.sql
  5. … 272 more files in changeset.
Wednesday 03 Sep 2003
1:44 am

vinodk

- drop all_photo_images view in drop script

Options
    • -1
    • +3
    ./postgresql/photo-album-drop.sql
Tuesday 02 Sep 2003
6:06 am

vinodk

- tried to drop a view that didn't exist. Thanks Jade!

Options
    • -2
    • +1
    ./postgresql/upgrade/upgrade-4.0.1-4.5.sql
Thursday 26 Jun 2003
4:45 am

vinodk

- few more 7.3 fixes

- upgrade to 4.6.2 with simple upgrade script

Options
    • -2
    • +2
    ./postgresql/pa-clip-drop.sql
    • -6
    • +6
    ./postgresql/photo-album-clip.sql
    • -3
    • +3
    ./postgresql/photo-album-drop.sql
    • -0
    • +45
    ./postgresql/upgrade/upgrade-4.6.1-4.6.2.sql
  5. … 2 more files in changeset.
Wednesday 18 Jun 2003
2:11 pm

peterm

adding provides for Photo Album in info file so that portlet and applet packages can depend on it. Setting context_id of root folders to be the package id so that objects in a package inherit permissions from the package instance. This is a pattern all packages should follow

Options
    • -2
    • +3
    ./oracle/plsql-packages.sql
    • -2
    • +7
    ./postgresql/pl-pgsql.sql
  3. … 1 more file in changeset.
Monday 16 Jun 2003
2:59 pm

daveb

Change timestamp plpgsql parameters to timestamptz for 7.3.x compatability.

Upgrade file relaods plpgsql file. Bump version number to 4.6 so upgrade file

will work.

Options
    • -5
    • +5
    ./postgresql/pl-pgsql.sql
    • -0
    • +3
    ./postgresql/upgrade/upgrade-4.5-4.6.sql
Thursday 12 Jun 2003
8:55 am

vinodk

- Integrated changes from myself and Michael Steigman. If it doesn't work, it's probably my fault. Includes the following:

- oracle support

- oracle and pg upgrade scripts (from v4.0.1)

- working drop scripts

- bump of version to 4.5

Options
    • -14
    • +0
    ./test.sql
    • -0
    • +32
    ./oracle/pa-clip-drop.sql
    • -1
    • +1
    ./oracle/permissions.sql
    • -0
    • +159
    ./oracle/photo-album-clip.sql
    • -21
    • +167
    ./oracle/photo-album-create.sql
    • -34
    • +49
    ./oracle/photo-album-drop.sql
    • -33
    • +29
    ./oracle/plsql-packages.sql
    • -0
    • +178
    ./oracle/upgrade/upgrade-4.0.1-4.5.sql
    • -0
    • +35
    ./postgresql/pa-clip-drop.sql
    • -1
    • +1
    ./postgresql/permissions.sql
    • -4
    • +4
    ./postgresql/photo-album-clip.sql
    • -3
    • +1
    ./postgresql/photo-album-create.sql
    • -28
    • +21
    ./postgresql/photo-album-drop.sql
    • -137
    • +0
    ./postgresql/photo-album-upgrade.sql
    • -1
    • +1
    ./postgresql/pl-pgsql.sql
  16. … 68 more files in changeset.
Wednesday 11 Jun 2003
3:36 pm

jlaine

Added collections-specific stuff to dotlrn-homework-drop.sql and fixed a broken function drop call.

Options
    • -3
    • +15
    ./postgresql/photo-album-drop.sql
Tuesday 10 Jun 2003
12:04 pm

jeffd

initial commit

Options
    • -0
    • +14
    ./test.sql
    • -0
    • +27
    ./oracle/permissions.sql
    • -0
    • +214
    ./oracle/photo-album-create.sql
    • -0
    • +212
    ./oracle/photo-album-drop.sql
    • -0
    • +442
    ./oracle/plsql-packages.sql
    • -0
    • +26
    ./postgresql/permissions.sql
    • -0
    • +134
    ./postgresql/photo-album-clip.sql
    • -0
    • +390
    ./postgresql/photo-album-create.sql
    • -0
    • +226
    ./postgresql/photo-album-drop.sql
    • -0
    • +137
    ./postgresql/photo-album-upgrade.sql
    • -0
    • +324
    ./postgresql/pl-pgsql.sql
    • -0
    • +13
    ./postgresql/upgrade.sql
  13. … 115 more files in changeset.