OpenACS / openacs-4 / packages / dotlrn / sql / oracle

communities-create.sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 7
Last Commit: 16:32
Commits this week: 0
Total Lines of Code (LoC): 123
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 2 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Wednesday 22 Nov 2006
11:03 am

nimam

Reverted all changes from Mannheim

Options
    • -1
    • +0
    ./communities-create.sql
  2. … 222 more files in changeset.
Monday 20 Nov 2006
9:00 pm

nimam

Mannheim update, fix and merge bugbash

Options
    • -1
    • +2
    ./communities-create.sql
  2. … 197 more files in changeset.
Tuesday 08 Aug 2006
11:26 pm

donb

First shot at merging oacs-5-2 apps used in .LRN to HEAD.

Options
    • -2
    • +6
    ./communities-create.sql
  2. … 2478 more files in changeset.
Wednesday 01 Feb 2006
11:15 am

emmar

Fix #2762. Adding oracle sql for site-templates and member-emails.

Options
    • -2
    • +6
    ./communities-create.sql
  2. … 7 more files in changeset.
Wednesday 01 Jun 2005
1:13 am

hamiltonc

committing changes, improvements and fixes to assessment, assessment-portlet, dotlrn, dotlrn-assessment, dotlrn-catalog, dotlrn-evaluation, ecommerce, evaluation and evaluation-portlet

Options
    • -1
    • +1
    ./communities-create.sql
  2. … 913 more files in changeset.
Wednesday 04 Dec 2002
10:50 am

peterm

merging the dotlrn-1-0 branch down onto HEAD (the trunk)

Options
    • -2
    • +1
    ./communities-create.sql
  2. … 200 more files in changeset.
Friday 25 Oct 2002
11:02 pm

donb

I removed the composite index that checks for uniqueness of the community_type

and supertype pair. This index broke installation if the Oracle blocksize is

less than 8KB (which is true by default on at least some platforms).

The unique constraint was unnecessary since community_type was already declared as the

table's primary key. Because of this, only one row with a given community_type name

is possible, which means the composite key (community_type, supertype) is guaranteed

to be unique.

Removing the index will also speed community creation slightly, save a bit of

disk space, etc etc.

Note that the composite index was useless for lookups on the supertype alone

anyway (since community_type was the leftmost member of the composite key), and that

any queries on the type hierarchy ought to use the denormalized table defined

by acs-objects-metadata.sql anyway.

So the index seems entirely useless to me.

Options
    • -2
    • +1
    ./communities-create.sql
  2. … 1 more file in changeset.
Friday 09 Aug 2002
8:39 pm

yon

copyright OpenForce -> MIT

Options
    • -2
    • +2
    ./communities-create.sql
  2. … 546 more files in changeset.
Saturday 13 Jul 2002
2:13 am

yon

some changes regarding dotlrn applets. the data model has changed. some other

small api changes. most of these api are not used.

Options
    • -39
    • +1
    ./communities-create.sql
  2. … 33 more files in changeset.
Friday 28 Jun 2002
9:50 pm

arjun

fix typo

Options
    • -2
    • +2
    ./communities-create.sql
Wednesday 26 Jun 2002
12:21 am

yon

removed unused columns; you can just drop them and recreate any dependent views

Options
    • -7
    • +1
    ./communities-create.sql
Thursday 20 Jun 2002
10:33 pm

arjun

One of the index names was too long for oracle

Options
    • -2
    • +2
    ./communities-create.sql
Friday 07 Jun 2002
6:42 am

arjun

added some indexes

Options
    • -1
    • +4
    ./communities-create.sql
  2. … 1 more file in changeset.
Friday 31 May 2002
8:23 am

yon

now using "tree_sortkey" instead of "connect by"

Options
    • -1
    • +3
    ./communities-create.sql
  2. … 8 more files in changeset.
12:04 am

yon

added drop scripts. KEEP THEM UP TO DATE OR SUFFER THE WRATH OF YON

Options
    • -10
    • +12
    ./communities-create.sql
  2. … 30 more files in changeset.
Friday 24 May 2002
3:58 am

arjun

1. Added add_portlet/remove_portlet calls that accept portal_id as a param,

so that we can call this code from within the applet itself (e.g. add_user_to_community)

and be called directly so that we can create portal templates.

2. Infrastructure for applet cloning

3. New portal types system in dotlrn which replaces dummy_comm_p

4. Minor fixes to portal configuration, dotlrn-static

5. renamed add_element_or_append_id and remove_element_or_remove_id to

add_element_parameters and remove_element_parameters respectively

Options
    • -1
    • +7
    ./communities-create.sql
  2. … 76 more files in changeset.
Tuesday 14 May 2002
5:50 pm

yon

apparently we can't have a foreign key constraint on the package_id column of dotlrn_community_applets. i don't have time to look into why not right now so i am just removing the constraint

Options
    • -3
    • +2
    ./communities-create.sql
Monday 13 May 2002
9:46 pm

yon

changing communities data model

Options
    • -26
    • +36
    ./communities-create.sql
  2. … 4 more files in changeset.
Tuesday 07 May 2002
1:55 am

yon

removed anything pertaining to user's portals for a community, we don't support that anymore; renamed sql files

Options
    • -0
    • +142
    ./communities-create.sql
  2. … 131 more files in changeset.