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

content-image.sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 10
Last Commit: 13:02
Commits this week: 0
Total Lines of Code (LoC): 386
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 4 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Wednesday 21 Feb 2018
3:11 pm

antoniop

Add missing change in the data model from previous commit

Options
    • -2
    • +2
    ./content-image.sql
  2. … 1 more file in changeset.
Tuesday 08 Aug 2017
1:47 am

gustafn

merged changes from the oacs-5-9 branch and resolved conflicts

Options
    • -151
    • +15
    ./content-image.sql
  2. … 7834 more files in changeset.
Sunday 12 Feb 2017
1:15 am

gustafn

- Align type of parameter "storage_type" with type definition of cr_items.storage_type

- bump version to 5.9.1d27

Options
    • -2
    • +2
    ./content-image.sql
  2. … 3 more files in changeset.
Wednesday 10 Feb 2016
10:14 am

gustafn

Content-Repository Reform : Reduction of number of functions in

the content repository for PostgreSQL by using using argument defaults

(while providing compatibility for clients using old versions):

- reduced number of versions of content_item__new from 12 (!) to 6 by using defaults

- commented differences

- commented arguments of plpgsql functions with long argument lists

- reduced code duplication by basing one version of content_item__new/17 directly on /20

- marking on version of content_item__new/17 and content_item__new/6 as deprecated

- reduced number of versions of content_revision__new from 7 to 4 by using defaults

- commented differences

- marking on version of content_revision__new/7 as deprecated

- let automatically generated functions call directly content_revision__new/13

- remove space from automatically generated functions

- updated automatically generated functions for all types of the content repository

- reduced number of versions of image__new from 4 to 2by using defaults

- reduced number of versions of image__new_revision from 2 to 1 by using defaults

Options
    • -150
    • +14
    ./content-image.sql
  2. … 7 more files in changeset.
Thursday 07 Jul 2011
12:46 pm

gustafn

Bring PostgreSQL functions closer to the current level of PL/pgSQL:

- upgrade PL/pgSQL functions to the $$ notation (recommended since pg8.0, jan 2005).

- get rid of backslash usages in function definitions

- drop aliases in favor of named function arguments (recommended since pg8.0)

- fix wrong function_args, add missing function_args, align default semantics

with the defaults in pg (providing "null" as default means the argument is

optional).

- change return types of triggers from "opaque" to "trigger" (recommended since pg8.0)

- unify names of triggers *_tr

- removed some version dependencies of pg 7.2 and 7.3

Options
    • -133
    • +188
    ./content-image.sql
  2. … 54 more files in changeset.
Monday 25 Sep 2006
10:15 pm

byronl

Correction of name constraint

Options
    • -2
    • +2
    ./content-image.sql
  2. … 4 more files in changeset.
Friday 12 Mar 2004
8:19 pm

jeffd

various bug fixes for package_id, title addition to acs_objects

Options
    • -9
    • +9
    ./content-image.sql
  2. … 12 more files in changeset.
7:48 pm

jeffd

Remerge Timo's changes for tip 42,43, cf tip 53

Options
    • -9
    • +149
    ./content-image.sql
  2. … 97 more files in changeset.
Thursday 04 Mar 2004
3:52 pm

jeffd

rollback of Timo's name, package_id commit; see TIP 53

Options
    • -148
    • +8
    ./content-image.sql
  2. … 96 more files in changeset.
Tuesday 02 Mar 2004
6:00 pm

timoh

TIP#42,43: adding package_id and title to acs_objects table

Options
    • -9
    • +149
    ./content-image.sql
  2. … 96 more files in changeset.
Friday 06 Feb 2004
9:02 pm

donb

Added define_function_arg calls to non-content-revision objects and to

create_type and create_attributes, so we can do these operations via

Tcl. Content revisions, due to LOB/non-LOB issues and the incompatibility

of LOB operations between DBs need their own "smart" Tcl API.

Options
    • -1
    • +6
    ./content-image.sql
  2. … 10 more files in changeset.
Monday 10 Nov 2003
3:42 am

daveb

Fix content_item__move error and bug in content-image.sql.

Options
    • -5
    • +4
    ./content-image.sql
  2. … 1 more file in changeset.
Sunday 09 Nov 2003
4:33 am

daveb

Fixed missing declaration for v_revision_id in image__new_revision.

Options
    • -3
    • +3
    ./content-image.sql
  2. … 1 more file in changeset.
Saturday 17 May 2003
11:35 am

jeffd

merge of 4.6.3b1 to HEAD

Options
    • -21
    • +6
    ./content-image.sql
  2. … 101 more files in changeset.
Saturday 01 Mar 2003
10:20 pm

donb

Partial conversion from timestamp to timestamptz for PG 7.3 (need to keep

time zone timestamps so dumps from PG 7.2 installs will still work)

Options
    • -5
    • +5
    ./content-image.sql
  2. … 18 more files in changeset.
Thursday 06 Feb 2003
1:52 pm

jeffd

- Adds table cr_extension_mime_type_map,

- Adds function cr_filename_to_mime_type [-create] filename

- Adds function cr_create_mime_type -extension -mime_type -description

- Removes *_maybe_create_new_mime_type

- Updates acs-content-repository to 4.6.3. Ugrade scripts provided.

- Updates dependency information for several packages.

- Adds most mime types plus comprehensive list of extension to mime-typemappings.

- Maps .c .h .c++ .pl etc to text/plain

Options
    • -17
    • +1
    ./content-image.sql
  2. … 20 more files in changeset.
Tuesday 21 Jan 2003
2:45 pm

jeffd

merge bartt PG 7.3 fixes from HEAD

Options
    • -3
    • +3
    ./content-image.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-image.sql
  2. … 54 more files in changeset.
Saturday 30 Nov 2002
6:11 pm

jeffd

merge from oacs-4-6

Options
    • -1
    • +1
    ./content-image.sql
  2. … 110 more files in changeset.
Friday 04 Oct 2002
10:08 am

jeffd

undeclared variable in trigger bug 1769/patch 467 Dave Bauer

Options
    • -1
    • +1
    ./content-image.sql
  2. … 2 more files in changeset.
Tuesday 09 Jul 2002
5:43 pm

jeffd

Do not pass title to content_item__new since it forces it to create a

content revision in which to store it (and we are going to

create it ourselves as the next step).

Options
    • -1
    • +1
    ./content-image.sql
Sunday 12 May 2002
10:57 pm

donb

Merged with the 4.5 branch (oacs-4-5 tag "don-merge-1")

Options
    • -17
    • +4
    ./content-image.sql
  2. … 58 more files in changeset.
Sunday 31 Mar 2002
10:31 pm

donb

Applied Jowell Sabino's patch #215 which fixes a problem with image deletion.

Options
    • -17
    • +4
    ./content-image.sql
Wednesday 02 Jan 2002
8:54 pm

andrewg

Replacing call to non-existent content_revision__delete_revision with a call to content_revision__delete.

Options
    • -1
    • +1
    ./content-image.sql
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
    • +128
    ./content-image.sql
  2. … 61 more files in changeset.
Friday 28 Sep 2001
12:48 am

danw

added support for multiple file storage areas

Options
    • -0
    • +132
    ./content-image.sql
  2. … 11 more files in changeset.
Friday 30 Mar 2001
7:31 am

danw

fixed up content-repository code so that it will load. Dynamic trigger code commented out for now

Options
    • -10
    • +10
    ./content-image.sql
  2. … 13 more files in changeset.
Tuesday 27 Mar 2001
4:02 am

danw

initial port to postgresql

Options
    • -0
    • +91
    ./content-image.sql
  2. … 7 more files in changeset.