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: 22 Oct
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 10 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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.