OpenACS / openacs-4 / packages / static-pages / sql

oracle

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 5
Last Commit: 14 Nov
Commits this week: 0
Total Lines of Code (LoC): 1,601
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 1 hour ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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
    • -9
    • +9
    ./static-page-pb.sql
    • -2
    • +2
    ./static-page-ph.sql
    • -2
    • +2
    ./static-pages-create.sql
  4. … 273 more files in changeset.
Thursday 16 Jan 2003
2:58 pm

jeffd

Merge of all changes from oacs-4-6 to HEAD. All changes up to tag jcd-merge-2

on oacs-4-6 are included.

Options
    • -0
    • +444
    ./static-page-pb.sql
    • -0
    • +161
    ./static-page-ph.sql
    • -589
    • +21
    ./static-pages-create.sql
    • -0
    • +45
    ./upgrade/upgrade-4.2a-4.3.sql
  5. … 31 more files in changeset.
Monday 16 Dec 2002
4:22 am

andrewp

Now correctly sets mime type using sp_maybe_create_new_mime_type,

rather than always using text/html.

Options
    • -2
    • +3
    ./static-page-pb.sql
    • -1
    • +2
    ./static-page-ph.sql
    • -1
    • +20
    ./upgrade/upgrade-4.2a-4.3.sql
  4. … 4 more files in changeset.
12:25 am

andrewp

Upgrade script now properly converts existing filenames from page to

server root relative, for both Oracle and Postgres.

Options
    • -4
    • +6
    ./upgrade/upgrade-4.2a-4.3.sql
  2. … 1 more file in changeset.
Thursday 12 Dec 2002
11:01 pm

andrewp

- Now supports multiple static-pages package instances, each with its

own fs_root parameter.

- static_pages.filename column is now relative to server root, not

page root. May still need an upgrade sript to convert old values in

db, see TODO comment in oracle upgrade-4.2a-4.3.sql.

- Added update to singleton_p = 'f' to upgrade scripts, which I left

out before.

- (Did NOT yet change www/page-visit.tcl to support files beneath the

packages/*/www/ directories.)

- Added other misc. comments.

Options
    • -5
    • +7
    ./static-pages-create.sql
    • -1
    • +10
    ./upgrade/upgrade-4.2a-4.3.sql
  3. … 5 more files in changeset.
9:02 pm

andrewp

file upgrade-4.2a-4.3.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./upgrade/upgrade-4.2a-4.3.sql
  2. … 1 more file in changeset.
9:02 pm

andrewp

- Name of root folder is now unique in the CR even if have multiple

package instances, for both Oracle and Postgres.

- All Postgres functions now defined with "create or replace".

Options
    • -2
    • +4
    ./static-page-pb.sql
    • -0
    • +15
    ./upgrade/upgrade-4.2a-4.3.sql
  3. … 2 more files in changeset.
7:39 pm

andrewp

Moved Oracle package headers and bodies out of static-pages-create.sql

into separate files - necessary to more cleanly support upgrade files.

Also added a few comments. No other changes.

Options
    • -0
    • +441
    ./static-page-pb.sql
    • -0
    • +160
    ./static-page-ph.sql
    • -589
    • +19
    ./static-pages-create.sql
7:39 pm

andrewp

file static-page-pb.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./static-page-pb.sql
7:39 pm

andrewp

file static-page-ph.sql was initially added on branch oacs-4-6.

Options
    • -0
    • +0
    ./static-page-ph.sql
Friday 20 Apr 2001
10:51 pm

donb

Forgot to define binary files before importing, so .gifs were messed up.

Options
    • -0
    • +0
    ./static-pages-create.sql
    • -0
    • +0
    ./static-pages-drop.sql
    • -0
    • +0
    ./static-pages-sws-drop.sql
    • -0
    • +0
    ./static-pages-sws.sql
  5. … 2476 more files in changeset.
10:51 pm

donb

Initial revision

Options
    • -0
    • +751
    ./static-pages-create.sql
    • -0
    • +48
    ./static-pages-drop.sql
    • -0
    • +42
    ./static-pages-sws-drop.sql
    • -0
    • +64
    ./static-pages-sws.sql
  5. … 2476 more files in changeset.