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: 05 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 8 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Wednesday 24 Mar 2021
11:09 am

gustafn

added constraint cr_items_parent_id_ck to avoid certain simple loops on parent_ids

An item must not be equal to its own parent. Note that this constraint is not

guaranteed to avoid all loops; it is still possible to create indirect recursive

loops but excludes some real-world problems.

Options
    • -2
    • +10
    ./content-create.sql
  2. … 4 more files in changeset.
Wednesday 14 Aug 2019
9:31 am

gustafn

improve spelling

Options
    • -2
    • +2
    ./content-create.sql
  2. … 33 more files in changeset.
Wednesday 21 Feb 2018
3:11 pm

antoniop

Add missing change in the data model from previous commit

Options
    • -2
    • +2
    ./content-create.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
    • -31
    • +37
    ./content-create.sql
  2. … 7834 more files in changeset.
Friday 21 Apr 2017
4:53 pm

gustafn

Fix spelling errors

Options
    • -2
    • +2
    ./content-create.sql
  2. … 49 more files in changeset.
Wednesday 04 Jan 2017
4:54 pm

gustafn

- fix bug when updateing a user portrait, which was saved as "lob"

Options
    • -3
    • +3
    ./content-create.sql
  2. … 2 more files in changeset.
Friday 01 Jul 2016
11:34 am

gustafn

- use consistently varchar(1000) for object_types

- bump version number to 5.9.1d19

Options
    • -9
    • +9
    ./content-create.sql
  2. … 2 more files in changeset.
Thursday 26 May 2016
9:23 pm

gustafn

- add missing enumeration type to create script

- fix ambiguity for content_item__new in template__new

- add/update mime types for text/csv text/vcard, text/calendar

- bump version number to 5.9.1d17

Options
    • -1
    • +2
    ./content-create.sql
  2. … 6 more files in changeset.
Monday 16 May 2016
12:38 pm

gustafn

- Change text enumeration field "storage_type" in cr_items to native

SQL enumeration type

- bump version number to 5.9.1d15

Options
    • -4
    • +2
    ./content-create.sql
  2. … 3 more files in changeset.
Friday 12 Feb 2016
8:56 am

gustafn

- fix install scripts

Options
    • -6
    • +5
    ./content-create.sql
  2. … 1 more file in changeset.
Thursday 11 Feb 2016
9:07 am

gustafn

Content-Repository Reform: reduce dependency on cr_child_rels and simplify content_item__del() via cascading delete operations

- remove manual deletion operations from content_item__del() via

* delete cr_child_rels via "ON DELETE CASCADE" on parent_id and child_id

* delete cr_item_rels via "ON DELETE CASCADE" on item_id

* delete acs_object_context_index entries via "ON DELETE CASCADE" on ancestor_id and object_id

* delete acs_objects entries via "ON DELETE CASCADE" on context_id

- remove manual deletion operations for symlinks amd journal entries,

since db constrains handle the deletion already

- use cr_items.parent_id instead of cr_child_rels to determine direct children

of items

- remove deletion trigger for content search content_search__dtrg

since "ON DELETE CASCADE" removes entries already

Options
    • -6
    • +11
    ./content-create.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
    • -9
    • +12
    ./content-create.sql
  2. … 7 more files in changeset.
Monday 17 Aug 2015
12:47 am

gustafn

- follow naming conventions proposed by regression test

- bump version number

Options
    • -3
    • +3
    ./content-create.sql
  2. … 3 more files in changeset.
Sunday 03 May 2015
2:32 pm

gustafn

Scalability reform part 3 (content-repository):

- content_revision__del:

* Removed manual nulling of live_revision and latest_revision

by using appropriate ond delete actions on foreign keys

* Removed manual deletion of old_revision and new_revision in

cr_item_publish_audit by using "on delete cascade"

- content_item__del:

* Removed manual deletion of item_id in cr_item_publish_audit

by using "on delete cascade"

* Removed manual deletion of item_id in cr_release_periods

by using "on delete cascade"

* Removed manual deletion of item_id in cr_item_template_map

by using "on delete cascade"

* Removed manual deletion of item_id in cr_item_keyword_map

by using "on delete cascade"

* Removed manual deletion of direct permissions (was already

cascading)

- Added missing index for child_id to cr_child_rels.

This index was in the create scripts (with a non-conformant name),

but not in the upgrade scripts

- bump version number of acs-content-repository to 5.9.0d3

Options
    • -10
    • +11
    ./content-create.sql
  2. … 4 more files in changeset.
Saturday 02 May 2015
7:23 pm

gustafn

- Scalability reform part 2:

* remove cases in the content repository where referencial

integrity was handled manually. Ancient versions of

PostgresSQL seemed to have a bug, which was adressed

via extra triggers in OpenACS

* drop some leftover form ancient versions, were some

update scripts were missing

- bump version number of acs-content-repository to 5.9.0d2

Options
    • -157
    • +144
    ./content-create.sql
  2. … 2 more files in changeset.
Monday 27 Oct 2014
5:38 pm

victorg

Merging back to HEAD branch oacs-5-8 (using tag vg-merge-oacs-5-8-from-20141027).

Options
    • -1
    • +4
    ./content-create.sql
  2. … 2547 more files in changeset.
Wednesday 25 Dec 2013
5:10 pm

gustafn

- use external command "find" instead of tcllib package fileutil for speed and better filtering

- add index for much quicker reverse lookup file names in the content repository

Options
    • -1
    • +2
    ./content-create.sql
  2. … 6 more files in changeset.
Monday 16 Sep 2013
11:49 am

gustafn

*** empty log message ***

Options
    • -1
    • +3
    ./content-create.sql
Monday 06 Aug 2012
8:06 pm

michaels

make sure we exclude null paths from cr_files_to_delete

Options
    • -2
    • +3
    ./content-create.sql
  2. … 1 more file in changeset.
Thursday 04 Aug 2011
10:26 am

gustafn

- missing index and foreign key constraints on cr_item_publish_audit fixed

Options
    • -4
    • +9
    ./content-create.sql
  2. … 2 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
    • -123
    • +230
    ./content-create.sql
  2. … 54 more files in changeset.
Sunday 20 Feb 2011
1:34 am

donb

Moved table building and column adding code from content repository to

kernel, so all objects can benefit. Part of the acs object management package

work.

Options
    • -27
    • +1
    ./content-create.sql
  2. … 5 more files in changeset.
Friday 03 Apr 2009
12:31 am

donb

Fixed a problem with the deletion of lob.sql-based ("pseudo-lob") binary

storage.

Options
    • -2
    • +3
    ./content-create.sql
  2. … 2 more files in changeset.
Tuesday 10 Feb 2009
7:31 pm

jeffd

switch foo_id_seq.netval to nextval('t_foo_id_seq') calls to placate postgresql 8.

Options
    • -2
    • +2
    ./content-create.sql
  2. … 8 more files in changeset.
Saturday 07 Jun 2008
10:28 pm

donb

Merged from 5.4.2

Options
    • -47
    • +3
    ./content-create.sql
  2. … 283 more files in changeset.
Friday 02 May 2008
11:45 pm

donb

Made naming constraints follow our standard so PG core AA tests won't bitch

Options
    • -2
    • +2
    ./content-create.sql
  2. … 1 more file in changeset.
Friday 25 Apr 2008
9:29 pm

daveb

Remove unecessary upgrades.

Fix RI trigger now that we require PG 8 we don't need the workaround in

cr_folders.

Options
    • -47
    • +3
    ./content-create.sql
  2. … 4 more files in changeset.
Wednesday 29 Aug 2007
8:28 pm

maltes

Support for relative file locations which might even reside on a windows drive and therefore start with d:\

Options
    • -1
    • +2
    ./content-create.sql
  2. … 6 more files in changeset.
Monday 14 May 2007
10:30 pm

donb

Merged the 5.3 branch with HEAD. Look for tags with the pattern

drb-*-20070513

Options
    • -2
    • +2
    ./content-create.sql
  2. … 324 more files in changeset.
Wednesday 03 Jan 2007
10:00 pm

daveb

Update default template to use text instead of content tag to property grab

text from filesystem stored revisions.

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