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

postgresql

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 9
Last Commit: 12 Mar
Commits this week: 0
Total Lines of Code (LoC): 2,005
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 28 mins 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
    ./static-pages-create.sql
  2. … 19 more files in changeset.
Wednesday 20 Apr 2016
8:23 am

gustafn

- add "cascade" to make uninstall clean

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

victorg

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

Options
    • -3
    • +3
    ./static-page-pb.sql
    • -0
    • +234
    ./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
    ./upgrade/upgrade-5.2.0d3-5.2.0d4.sql
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
    ./static-page-pb.sql
    • -6
    • +5
    ./upgrade/upgrade-4.2a-4.3.sql
  3. … 2274 more files in changeset.
Thursday 25 Mar 2004
11:52 am

jeffd

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

Options
    • -31
    • +44
    ./static-page-pb.sql
    • -0
    • +180
    ./upgrade/upgrade-5.2.0d1-5.2.0d2.sql
  3. … 6 more files in changeset.
Saturday 17 May 2003
2:25 pm

jeffd

merge of 4.6.3b1 to HEAD

Options
    • -3
    • +3
    ./static-page-pb.sql
  2. … 18 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
    • +602
    ./static-page-pb.sql
    • -585
    • +2
    ./static-pages-create.sql
    • -0
    • +26
    ./upgrade/upgrade-4.2a-4.3.sql
  4. … 32 more files in changeset.
Thursday 12 Dec 2002
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.
8:48 pm

andrewp

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

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

daveb

Added sp_folder_get_tree_sortkey function to the drop script

Options
    • -1
    • +2
    ./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
    ./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
    ./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
    ./static-pages-drop.sql
    • -40
    • +0
    ./static-pages-sws-drop.sql
    • -61
    • +0
    ./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
    ./static-pages-create.sql
  2. … 4 more files in changeset.
1:32 am

donb

Removed some misnamed files from file-storage and removed a garbage file

from static-pages.

Options
    • -846
    • +0
    ./#static-pages-create.sql#
  2. … 6 more files in changeset.
Wednesday 31 Oct 2001
6:47 pm

daveb

fixed static_page__delete

Options
    • -4
    • +2
    ./static-pages-create.sql
6:15 pm

daveb

More fixes to static_page__grant/revoke permission and static-pagses-procs-postgresql.xql

Options
    • -5
    • +5
    ./static-pages-create.sql
  2. … 4 more files in changeset.
Tuesday 30 Oct 2001
10:53 pm

daveb

Fixed commentability on nested folders

Options
    • -2
    • +2
    ./static-pages-create.sql
9:59 pm

daveb

more adds

Options
    • -0
    • +846
    ./#static-pages-create.sql#
    • -0
    • +25
    ./static-pages-sc-create.sql
    • -0
    • +7
    ./static-pages-sc-drop.sql
Friday 26 Oct 2001
9:26 pm

daveb

Fixed more bugs in static-pages-create. Drop script now works.

Options
    • -8
    • +6
    ./static-pages-create.sql
5:31 am

daveb

Fixed static_page content type and static_page__new

Options
    • -2
    • +2
    ./static-pages-create.sql
Wednesday 24 Oct 2001
3:10 am

daveb

*** empty log message ***

Options
    • -2
    • +7
    ./static-pages-create.sql
    • -6
    • +13
    ./static-pages-drop.sql
Tuesday 23 Oct 2001
8:53 pm

daveb

Fixed static folders. Now stores file path relative to installation root and uses cr_fs_path to get the full file path.

Options
    • -67
    • +92
    ./static-pages-create.sql
  2. … 4 more files in changeset.
Friday 19 Oct 2001
4:11 am

donb

*** empty log message ***

Options
    • -2
    • +2
    ./static-pages-create.sql
  2. … 7 more files in changeset.
Tuesday 04 Sep 2001
7:04 pm

daveb

Fixed info file for postgresql and fixed Oracle version

Options
    • -3
    • +3
    ./static-pages-create.sql
  2. … 8 more files in changeset.
Saturday 04 Aug 2001
4:58 am

daveb

Postgresql ported - still needs modifications to work with static-pages. Oracle not tested and probably broken

Options
    • -12
    • +12
    ./static-pages-create.sql
  2. … 6 more files in changeset.
Friday 27 Jul 2001
5:56 pm

daveb

Fixed seq/sequence in static-pages-create.sql

Options
    • -3
    • +3
    ./static-pages-create.sql
Tuesday 24 Jul 2001
9:51 pm

daveb

Datamodel loads in postgresql. Beginning work on Tcl

Options
    • -96
    • +246
    ./static-pages-create.sql
    • -6
    • +11
    ./static-pages-drop.sql
  3. … 1 more file in changeset.
Monday 02 Jul 2001
9:39 pm

rmello

Created the view corresponding to sp_session_id_seq.

Options
    • -1
    • +2
    ./static-pages-create.sql