OpenACS / openacs-4 / packages / acs-content-repository / sql / postgresql

content-create.sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 15
Last Commit: 30 Apr
Commits this week: 0
Total Lines of Code (LoC): 1,456
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 17 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Tuesday 21 Jan 2003
2:45 pm

jeffd

merge bartt PG 7.3 fixes from HEAD

Options
    • -2
    • +2
    ./content-create.sql
  2. … 54 more files in changeset.
Saturday 21 Dec 2002
11:27 pm

bartt

Patches to make OpenACS PG 7.3 compatible.

Options
    • -2
    • +2
    ./content-create.sql
  2. … 54 more files in changeset.
Monday 18 Nov 2002
7:07 pm

lars

Added */* as unknown mime type, because otherwise files that didn't match one of the existing mime types wouldn't upload in file-storage.

Options
    • -1
    • +2
    ./content-create.sql
  2. … 1 more file in changeset.
Monday 23 Sep 2002
12:19 pm

jeffd

adds some common mime types to cr_mime_types

Options
    • -4
    • +25
    ./content-create.sql
  2. … 1 more file in changeset.
Wednesday 16 Jan 2002
9:07 pm

donb

1. home.tcl - applied patch from SDM to use ad_pvt_home rather than a

fixed value.

2. defs-procs.tcl - applied patch that fixed a "link within a link" problem.

3. content_item.tree_sortkey had no index (gulp!)

Options
    • -1
    • +2
    ./content-create.sql
  2. … 2 more files in changeset.
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
    • +15
    ./content-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
    • -40
    • +31
    ./content-create.sql
  2. … 62 more files in changeset.
Thursday 15 Nov 2001
2:47 am

donb

1. Fixed permissions bug in the PG version (missing OR clause in a view)

2. Added (untested thus far) site-wide-search to glossary

3. Added centralized support for importing files into the CR (either into

the filesystem or the database).

4. Fixed wp-slim. Fixed it some more. Fixed it again. It still needs

more fixing.

Options
    • -1
    • +3
    ./content-create.sql
  2. … 61 more files in changeset.
Wednesday 07 Nov 2001
11:55 pm

donb

1. Typo in the alter table in the PG version ...

2. Just folded the alter tables into the cr_folders table definition. This

is still pre-beta ...

Options
    • -4
    • +5
    ./content-create.sql
  2. … 1 more file in changeset.
5:12 am

jong

added a constraint

Options
    • -2
    • +5
    ./content-create.sql
4:54 am

jong

added package_id to cr_folders

Options
    • -1
    • +6
    ./content-create.sql
Wednesday 03 Oct 2001
6:41 am

danw

fixed infinite recursion problem with cr_keywords update trigger

Options
    • -2
    • +4
    ./content-create.sql
Friday 28 Sep 2001
12:48 am

danw

added support for multiple file storage areas

Options
    • -30
    • +74
    ./content-create.sql
  2. … 11 more files in changeset.
Monday 17 Sep 2001
7:16 am

danw

moved CMS stuff to CR so that content can be displayed by the search interface without requiring the user to load cms

Options
    • -2
    • +2
    ./content-create.sql
  2. … 21 more files in changeset.
Friday 14 Sep 2001
6:53 am

danw

updated search support to include templates and images

Options
    • -11
    • +9
    ./content-create.sql
  2. … 6 more files in changeset.
Monday 10 Sep 2001
2:43 pm

danw

added virtual url support for CR

Options
    • -0
    • +0
    ./content-create.sql
  2. … 5 more files in changeset.
Sunday 09 Sep 2001
8:09 pm

danw

removed DataProvider Contract Temporarily

Options
    • -2
    • +79
    ./content-create.sql
  2. … 1 more file in changeset.
1:38 am

danw

added dependency for acs-service-contract

Options
    • -5
    • +4
    ./content-create.sql
  2. … 1 more file in changeset.
Saturday 08 Sep 2001
5:20 pm

danw

modified CR to provide the FtsContentProvider interface

Options
    • -3
    • +2
    ./content-create.sql
  2. … 3 more files in changeset.
Wednesday 29 Aug 2001
7:12 am

danw

fixed folder deletion problem caused by pg RI bug

Options
    • -3
    • +47
    ./content-create.sql
  2. … 1 more file in changeset.
Wednesday 22 Aug 2001
2:33 am

danw

reimplemented RI triggers for live_revision and latest_revision as user triggers

Options
    • -5
    • +147
    ./content-create.sql
Tuesday 19 Jun 2001
6:36 am

danw

removed foreign key constraints on cr_item_publish_audit to work-aroudn a data-change violation bug in postgresql

Options
    • -10
    • +4
    ./content-create.sql
Saturday 12 May 2001
7:09 am

danw

cleaned up content repository data-model and converted oracle apm to use file storage in the content repository

Options
    • -25
    • +2
    ./content-create.sql
  2. … 11 more files in changeset.
Friday 04 May 2001
8:04 am

danw

converted apm to store package tarballs in the content repository

Options
    • -1
    • +8
    ./content-create.sql
  2. … 7 more files in changeset.
Thursday 03 May 2001
6:00 am

danw

tested lob support for content-repository. converted photo upload in acs-subsite to use lobs instead of files

Options
    • -6
    • +3
    ./content-create.sql
  2. … 9 more files in changeset.
Tuesday 01 May 2001
6:37 am

danw

finished porting portrait upload to work with CR

Options
    • -1
    • +25
    ./content-create.sql
  2. … 4 more files in changeset.
Monday 30 Apr 2001
3:34 am

danw

added file support to CR data-model

Options
    • -5
    • +5
    ./content-create.sql
  2. … 12 more files in changeset.
Saturday 28 Apr 2001
9:58 pm

donb

Removed more of the "default '' not null" kludge.

Options
    • -20
    • +20
    ./content-create.sql
  2. … 18 more files in changeset.
Tuesday 17 Apr 2001
6:10 am

danw

patch submitted by Steve Woodcock

Options
    • -3
    • +3
    ./content-create.sql
  2. … 13 more files in changeset.
Monday 09 Apr 2001
6:55 am

danw

fixed problem with infinite recursion on updates of tables with tree query triggers

Options
    • -2
    • +3
    ./content-create.sql
  2. … 4 more files in changeset.