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: 28 Dec 24
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 23 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
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.
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.
Saturday 06 Jul 2002
3:55 pm

jeffd

type in constraint name cr_revisions_storage_type rather than cr_items_storage_type fixes bug 1021 patch 305

Options
    • -2
    • +2
    ./content-create.sql
Friday 16 Nov 2001
4:11 am

donb

1. The PG port of apm__register_parameter had a tiny error which caused it

to not set the new parameter to its default value in any of the effected

package instances.

2. Glossary - added admin as a parent of glossary_admin so admins can admin.

3. edit-this-page PG: removed code that was written because of #1 above

4. edit-this-page Oracle: finished the datamodel port, added drop script

Options
    • -4
    • +3
    ./content-create.sql
  2. … 8 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
    • -8
    • +5
    ./content-create.sql
  2. … 1 more file in changeset.
5:13 am

jong

added package_id to cr_folders

Options
    • -1
    • +7
    ./content-create.sql
Tuesday 30 Oct 2001
6:45 am

danw

fixed mutating tables problem with cr_cleanup_cr_files_del_trg trigger

Options
    • -2
    • +2
    ./content-create.sql
6:15 am

danw

fixed mutating tables problem with cr_cleanup_cr_files_del_trg trigger

Options
    • -5
    • +4
    ./content-create.sql