OpenACS / openacs-4 / packages / static-pages

sql

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 11
Last Commit: 12 Mar
Commits this week: 0
Total Lines of Code (LoC): 3,606
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 16 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Sunday 25 Oct 2020
7:57 pm

gustafn

make packages in principle installable under PG 13+

Options
    • -3
    • +3
    ./postgresql/static-pages-create.sql
  2. … 19 more files in changeset.
Thursday 29 Mar 2018
1:36 am

hectorr

Fix typos

Options
    • -1
    • +1
    ./oracle/upgrade/upgrade-5.2.0d1-5.2.0d2.sql
  2. … 17 more files in changeset.
Wednesday 20 Apr 2016
8:23 am

gustafn

- add "cascade" to make uninstall clean

Options
    • -3
    • +3
    ./postgresql/static-pages-drop.sql
Thursday 12 Sep 2013
3:32 pm

victorg

Merging commits from oacs-5-2 branch to HEAD.

Options
    • -3
    • +3
    ./postgresql/static-page-pb.sql
    • -0
    • +234
    ./postgresql/upgrade/upgrade-5.2.0d3-5.2.0d4.sql
  3. … 1 more file in changeset.
Wednesday 14 Dec 2005
8:38 pm

daveb

file upgrade-5.2.0d3-5.2.0d4.sql was initially added on branch oacs-5-2.

Options
    • -0
    • +0
    ./postgresql/upgrade/upgrade-5.2.0d3-5.2.0d4.sql
8:38 pm

daveb

Specify boolean as function parameter for security_inherit_p so we use the correct version of the content_folder__new function.

Options
    • -3
    • +3
    ./postgresql/static-page-pb.sql
    • -0
    • +234
    ./postgresql/upgrade/upgrade-5.2.0d3-5.2.0d4.sql
  3. … 1 more file in changeset.
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
    • -11
    • +603
    ./postgresql/static-page-pb.sql
    • -6
    • +5
    ./postgresql/upgrade/upgrade-4.2a-4.3.sql
  3. … 2274 more files in changeset.
Friday 15 Oct 2004
10:48 am

maltes

typos in the scripts

Options
    • -13
    • +605
    ./postgresql/static-page-pb.sql
    • -6
    • +5
    ./postgresql/upgrade/upgrade-4.2a-4.3.sql
Thursday 25 Mar 2004
11:52 am

jeffd

make static pages work with tip 43; bump to 5.2.0d2, upgrade oracle, postgres

Options
    • -3
    • +6
    ./oracle/static-page-pb.sql
    • -2
    • +4
    ./oracle/static-page-ph.sql
    • -0
    • +4
    ./oracle/upgrade/upgrade-5.2.0d1-5.2.0d2.sql
    • -31
    • +44
    ./postgresql/static-page-pb.sql
    • -0
    • +180
    ./postgresql/upgrade/upgrade-5.2.0d1-5.2.0d2.sql
  6. … 3 more files in changeset.
Tuesday 14 Oct 2003
9:06 pm

daveb

Fixed relative path, removed extra single quotes not needed outside plpgsql

function.

Options
    • -6
    • +6
    ./postgresql/upgrade/upgrade-4.2a-4.3.sql
Wednesday 08 Oct 2003
6:53 pm

mohanp

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

Options
    • -0
    • +605
    ./oracle/upgrade/upgrade-4.3-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
    • -9
    • +9
    ./oracle/static-page-pb.sql
    • -2
    • +2
    ./oracle/static-page-ph.sql
    • -2
    • +2
    ./oracle/static-pages-create.sql
  4. … 273 more files in changeset.
Saturday 17 May 2003
2:25 pm

jeffd

merge of 4.6.3b1 to HEAD

Options
    • -3
    • +3
    ./postgresql/static-page-pb.sql
  2. … 18 more files in changeset.
Sunday 02 Mar 2003
11:52 pm

donb

I've changed "timestamp" to "timestamptz" and have begun fixing some

code that used to be legal but as of PG 7.3 is not. You can no longer

subtract an integer from a timestamp but must cast to date, "timestamp"

disappeared (must use "interval" now), "datetime" disappeared ("timestamptz"),

and suchwhat.

Not done but closer than it was before ...

Options
    • -3
    • +3
    ./postgresql/static-page-pb.sql
  2. … 14 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
    ./oracle/static-page-pb.sql
    • -0
    • +161
    ./oracle/static-page-ph.sql
    • -589
    • +21
    ./oracle/static-pages-create.sql
    • -0
    • +45
    ./oracle/upgrade/upgrade-4.2a-4.3.sql
    • -0
    • +602
    ./postgresql/static-page-pb.sql
    • -585
    • +2
    ./postgresql/static-pages-create.sql
    • -0
    • +26
    ./postgresql/upgrade/upgrade-4.2a-4.3.sql
  8. … 28 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
    ./oracle/static-page-pb.sql
    • -1
    • +2
    ./oracle/static-page-ph.sql
    • -1
    • +20
    ./oracle/upgrade/upgrade-4.2a-4.3.sql
    • -3
    • +7
    ./postgresql/static-page-pb.sql
  5. … 3 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
    ./oracle/upgrade/upgrade-4.2a-4.3.sql
    • -1
    • +8
    ./postgresql/upgrade/upgrade-4.2a-4.3.sql
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
    ./oracle/static-pages-create.sql
    • -1
    • +10
    ./oracle/upgrade/upgrade-4.2a-4.3.sql
    • -1
    • +5
    ./postgresql/upgrade/upgrade-4.2a-4.3.sql
  4. … 4 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
    ./oracle/upgrade/upgrade-4.2a-4.3.sql
    • -0
    • +0
    ./postgresql/upgrade/upgrade-4.2a-4.3.sql
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
    ./oracle/static-page-pb.sql
    • -0
    • +15
    ./oracle/upgrade/upgrade-4.2a-4.3.sql
    • -15
    • +24
    ./postgresql/static-page-pb.sql
    • -0
    • +15
    ./postgresql/upgrade/upgrade-4.2a-4.3.sql
8:48 pm

andrewp

Moved Postgres functions and bodies out of static-pages-create.sql

into separate files (just like for Oracle) - necessary to more cleanly

support upgrade files. No other changes.

Options
    • -0
    • +589
    ./postgresql/static-page-pb.sql
    • -585
    • +2
    ./postgresql/static-pages-create.sql
8:48 pm

andrewp

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

Options
    • -0
    • +0
    ./postgresql/static-page-pb.sql
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
    ./oracle/static-page-pb.sql
    • -0
    • +160
    ./oracle/static-page-ph.sql
    • -589
    • +19
    ./oracle/static-pages-create.sql
7:39 pm

andrewp

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

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

andrewp

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

Options
    • -0
    • +0
    ./oracle/static-page-ph.sql
Friday 14 Dec 2001
11:45 pm

daveb

Added sp_folder_get_tree_sortkey function to the drop script

Options
    • -1
    • +2
    ./postgresql/static-pages-drop.sql
Sunday 09 Dec 2001
5:21 am

donb

Added code to make use of David Walker's wonderfully abusive hack on the

pg_proc table that showed me how to write recursive SQL functions. We now

have good use of the index on tree_sortkey when climbing the tree, woo-hoo!

Options
    • -1
    • +8
    ./postgresql/static-pages-create.sql
  2. … 18 more files in changeset.
Saturday 08 Dec 2001
2:17 am

donb

Changed the representation of tree_sortkeys from "text" to "bit varying".

Options
    • -77
    • +56
    ./postgresql/static-pages-create.sql
  2. … 62 more files in changeset.
Monday 03 Dec 2001
8:17 pm

daveb

Removing unused static-pages-sws files from sql/postgresql

Options
    • -2
    • +2
    ./postgresql/static-pages-drop.sql
    • -40
    • +0
    ./postgresql/static-pages-sws-drop.sql
    • -61
    • +0
    ./postgresql/static-pages-sws.sql
5:58 pm

daveb

Fixed file update error in postgreql. It adds an mtime column, update your

datamodel on PG. Code checks for storage_type to run the correct queries/code

for Oracle/PG.

Options
    • -7
    • +19
    ./postgresql/static-pages-create.sql
  2. … 4 more files in changeset.