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

content-create.sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 15
Last Commit: 03 Nov
Commits this week: 0
Total Lines of Code (LoC): 877
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 18 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Wednesday 11 Sep
8:11 am

gustafn

merge with missing files

Options
    • -0
    • +0
    ./content-create.sql
  2. … 1464 more files in changeset.
Tuesday 03 Sep
5:37 pm

gustafn

merge from oacs-5-10

Options
    • -3
    • +11
    ./content-create.sql
  2. … 8099 more files in changeset.
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.
Tuesday 08 Aug 2017
1:47 am

gustafn

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

Options
    • -2
    • +2
    ./content-create.sql
  2. … 7834 more files in changeset.
Friday 03 Mar 2017
9:41 am

gustafn

fix issue #3303: wrong identifier due to different database structure in oracle

Options
    • -2
    • +2
    ./content-create.sql
  2. … 1 more file 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
    • -2
    • +3
    ./content-create.sql
  2. … 2547 more files in changeset.
Thursday 29 Aug 2013
12:47 am

michaels

exclude null paths from cr_files_to_delete for oracle - previously committed fix for postgresql

Options
    • -2
    • +3
    ./content-create.sql
  2. … 1 more file in changeset.
Monday 11 Apr 2011
3:08 am

donb

Added a couple of CR revision attributes - the oracle equivalent of the

previous PG commit.

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

donb

Merged from 5.4.2

Options
    • -18
    • +2
    ./content-create.sql
  2. … 283 more files in changeset.
Tuesday 13 May 2008
6:47 pm

daveb

Remove cr_doc_filter table, it is not used and the index is not allowed

in 10g.

Options
    • -17
    • +1
    ./content-create.sql
  2. … 2 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.
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
    • -2
    • +3
    ./content-create.sql
  2. … 6 more files in changeset.
Tuesday 26 Sep 2006
4:48 pm

byronl

Correction of name constraint

Options
    • -28
    • +30
    ./content-create.sql
  2. … 13 more files in changeset.
Sunday 04 Jun 2006
2:45 am

donb

Merged acs-core oacs-5-2 (currently 5.2.3) -> HEAD.

TODO:

1. Bump acs-core package version numbers to 5.3.0d1

2. Would be nice to do a test install, wouldn't it?

Options
    • -3
    • +3
    ./content-create.sql
  2. … 721 more files in changeset.
Thursday 29 Dec 2005
2:24 am

daveb

Changes to make the root of parentless items = -4 (security context root) instead of 0 (unregistered visitor)

Sites upgradeed from 4.6-4.6.1 have been operating with -4 as the parent_id for years (for example openacs.org) while new installs had

parent_id = 0. This caused problems with the new package_id code that calls content_item__get_root_folder which was assuming the root =

0. It looks like the new install code did not accomodate parent_id=-4 and that is now fixed.

Needs testing on Oracle.

Options
    • -3
    • +3
    ./content-create.sql
  2. … 7 more files in changeset.
Tuesday 29 Mar 2005
3:50 pm

timoh

provided default template in oracle

Options
    • -1
    • +53
    ./content-create.sql
  2. … 5 more files in changeset.
Wednesday 23 Feb 2005
12:52 pm

leed

Page root and template root registered as magic objects.

Options
    • -1
    • +13
    ./content-create.sql
  2. … 1 more file in changeset.
Monday 24 Jan 2005
12:16 am

jeffd

add index on cr_revisions(publish_date), upgrade bump to 5.2.0d12

Options
    • -1
    • +4
    ./content-create.sql
  2. … 4 more files 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
    • -1
    • +2
    ./content-create.sql
  2. … 2275 more files in changeset.
Monday 06 Sep 2004
6:43 pm

rocaelh

adding cr_items(name) index on the creation of the pkg

Options
    • -1
    • +2
    ./content-create.sql
  2. … 1 more file 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
    • -3
    • +1
    ./content-create.sql
  2. … 275 more files in changeset.
Saturday 17 May 2003
11:35 am

jeffd

merge of 4.6.3b1 to HEAD

Options
    • -34
    • +46
    ./content-create.sql
  2. … 101 more files in changeset.
Thursday 27 Feb 2003
2:44 pm

jeffd

register_child_type would only register one type per parent since it

ignored relation tag when checking if the relation existed.

is_valid_type failed with more than one type since it wanted to count

max_n but did not sum.

needs an upgrade script.

Options
    • -3
    • +3
    ./content-create.sql
  2. … 4 more files in changeset.
Sunday 23 Feb 2003
5:22 pm

danw

forgot about all of the trigger work-arounds for data-change violation problem that no longer exists. Fixed now.

Options
    • -1
    • +3
    ./content-create.sql
  2. … 4 more files in changeset.
Monday 10 Feb 2003
6:37 pm

lars

Adding new mime-types, which I forgot to add back when I added the new richtext widget. Jeff will probably go in and rename them something else for me, and hopefully he'll propagate the change to the richtext widget and acs-tcl/tcl/text-html-procs as well.

Options
    • -2
    • +4
    ./content-create.sql
  2. … 3 more files in changeset.
Thursday 06 Feb 2003
5:47 pm

jeffd

moved the includes back up to where they belong, add the 4.6.3 upgrade scripts

Options
    • -5
    • +4
    ./content-create.sql
  2. … 3 more files in changeset.
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
    • -29
    • +24
    ./content-create.sql
  2. … 20 more files in changeset.
Monday 03 Feb 2003
4:13 pm

jeffd

adds indexes for fk constraint children, bumps version to 4.6.2, upgrades supplied

Options
    • -2
    • +23
    ./content-create.sql
  2. … 4 more files in changeset.
Wednesday 22 Jan 2003
9:21 pm

jeffd

adds */* mime type, bump version from 4.6 to 4.6.1 and provide an upgrade script (*/* added by Lars on HEAD)

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