OpenACS / openacs-4 / packages / dotlrn / sql

oracle

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 19
Last Commit: 28 Dec 24
Commits this week: 0
Total Lines of Code (LoC): 9,412
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 1 hour ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Friday 07 Jun 2002
6:42 am

arjun

added some indexes

Options
    • -1
    • +4
    ./communities-create.sql
  2. … 1 more file in changeset.
Sunday 02 Jun 2002
2:05 am

yon

removing access_level column, it is the equivalent of the dotlrn_browse permission

Options
    • -4
    • +1
    ./admins-package-create.sql
    • -4
    • +1
    ./externals-package-create.sql
    • -4
    • +1
    ./professors-package-create.sql
    • -4
    • +1
    ./students-package-create.sql
    • -7
    • +1
    ./users-create.sql
    • -5
    • +3
    ./users-package-create.sql
  7. … 21 more files in changeset.
Friday 31 May 2002
8:23 am

yon

now using "tree_sortkey" instead of "connect by"

Options
    • -1
    • +3
    ./communities-create.sql
    • -1
    • +3
    ./communities-drop.sql
    • -338
    • +65
    ./communities-tree-create.sql
    • -0
    • +18
    ./communities-tree-drop.sql
  5. … 5 more files in changeset.
12:04 am

yon

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

Options
    • -0
    • +189
    ./applet-sc-drop.sql
    • -0
    • +196
    ./class-memberships-create.sql
    • -0
    • +67
    ./class-memberships-drop.sql
    • -15
    • +3
    ./classes-create.sql
    • -0
    • +40
    ./classes-drop.sql
    • -195
    • +0
    ./classes-memberships-create.sql
    • -16
    • +3
    ./clubs-create.sql
    • -0
    • +29
    ./clubs-drop.sql
    • -10
    • +12
    ./communities-create.sql
    • -0
    • +34
    ./communities-drop.sql
    • -0
    • +4
    ./communities-package-create.sql
    • -0
    • +21
    ./communities-package-drop.sql
    • -0
    • +366
    ./communities-tree-create.sql
    • -3
    • +2
    ./community-memberships-create.sql
    • -0
    • +30
    ./community-memberships-drop.sql
  16. … 16 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
    • -13
    • +2
    ./applet-sc-create.sql
    • -1
    • +7
    ./communities-create.sql
    • -0
    • +1
    ./dotlrn-create.sql
    • -15
    • +4
    ./dotlrn-init.sql
    • -0
    • +33
    ./portal-types-create.sql
    • -0
    • +24
    ./portal-types-drop.sql
  7. … 71 more files in changeset.
Tuesday 21 May 2002
9:56 am

yon

was missing the member role attributes

Options
    • -1
    • +23
    ./dotlrn-init.sql
9:46 am

yon

displaying role in community correctly everywhere

Options
    • -6
    • +4
    ./community-memberships-create.sql
  2. … 9 more files in changeset.
8:24 am

yon

fixed role attributes

Options
    • -3
    • +3
    ./dotlrn-init.sql
Monday 20 May 2002
11:55 pm

yon

added the plural versions of the attributes too

Options
    • -19
    • +85
    ./dotlrn-init.sql
11:39 pm

yon

added community attributes infrastructure and a few attributes we know we need already

Options
    • -40
    • +177
    ./dotlrn-init.sql
  2. … 2 more files in changeset.
Thursday 16 May 2002
3:37 pm

yon

defaulting ID to email address; made ID column 200 chars instead of 100

Options
    • -2
    • +2
    ./users-create.sql
  2. … 1 more file 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
11:39 pm

arjun

Update args for removeportlet and addportlet

Options
    • -7
    • +14
    ./applet-sc-create.sql
9:46 pm

yon

changing communities data model

Options
    • -14
    • +14
    ./classes-create.sql
    • -14
    • +14
    ./clubs-create.sql
    • -26
    • +36
    ./communities-create.sql
    • -48
    • +54
    ./communities-package-create.sql
    • -4
    • +4
    ./community-memberships-packages-create.sql
Friday 10 May 2002
8:35 am

arjun

Added 3 procs to applet contract and impls. Infrastructure for getting rid of dummy_comm_p, cloning, and community deleting

Options
    • -13
    • +75
    ./applet-sc-create.sql
  2. … 24 more files in changeset.
1:59 am

arjun

Big checkin. All portal elements tcl and sql have been cleaned up. cleaned up portal api's. still incomplete

Options
    • -26
    • +10
    ./main-portlet-create.sql
  2. … 76 more files in changeset.
Wednesday 08 May 2002
12:06 am

arjun

Mostly adding infrastructure for community delete. some misc cleanups and additions elsewhere

Options
    • -204
    • +213
    ./applet-sc-create.sql
  2. … 20 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
    • +72
    ./admin-profile-provider-create.sql
    • -0
    • +66
    ./admin-profile-provider-drop.sql
    • -0
    • +33
    ./admins-create.sql
    • -0
    • +28
    ./admins-drop.sql
    • -0
    • +82
    ./admins-init.sql
    • -0
    • +112
    ./admins-package-create.sql
    • -0
    • +24
    ./admins-package-drop.sql
    • -0
    • +59
    ./admins-sanitize.sql
    • -0
    • +238
    ./applet-sc-create.sql
    • -0
    • +395
    ./classes-create.sql
    • -0
    • +195
    ./classes-memberships-create.sql
    • -0
    • +137
    ./clubs-create.sql
    • -0
    • +142
    ./communities-create.sql
    • -0
    • +360
    ./communities-package-create.sql
    • -0
    • +77
    ./community-memberships-create.sql
  16. … 117 more files in changeset.
Saturday 04 May 2002
2:12 pm

yon

making sure portal_id param is defaulting to null

Options
    • -26
    • +26
    ./dotlrn-community-memberships-packages-create.sql
Tuesday 30 Apr 2002
11:23 pm

arjun

adding subcomm rename funtionality, got rid of personal per comm portal creation, fixing drop community infrastructure (that's not done yet)

Options
    • -1
    • +1
    ./dotlrn-applet-sc-create.sql
  2. … 2 more files in changeset.
Sunday 28 Apr 2002
6:08 am

yon

access level is now a column in dotlrn_user_profile_rels, not a separate rel; so all the limited vs full rel stuff was removed and replaced by this simpler system

Options
    • -10
    • +3
    ./dotlrn-admins-create.sql
    • -2
    • +1
    ./dotlrn-admins-drop.sql
    • -43
    • +4
    ./dotlrn-admins-init.sql
    • -91
    • +13
    ./dotlrn-admins-package-create.sql
    • -2
    • +1
    ./dotlrn-admins-package-drop.sql
    • -24
    • +2
    ./dotlrn-admins-sanitize.sql
    • -10
    • +3
    ./dotlrn-externals-create.sql
    • -2
    • +1
    ./dotlrn-externals-drop.sql
    • -43
    • +4
    ./dotlrn-externals-init.sql
    • -91
    • +13
    ./dotlrn-externals-package-create.sql
    • -2
    • +1
    ./dotlrn-externals-package-drop.sql
    • -24
    • +2
    ./dotlrn-externals-sanitize.sql
    • -0
    • +1
    ./dotlrn-init.sql
    • -10
    • +3
    ./dotlrn-professors-create.sql
    • -2
    • +1
    ./dotlrn-professors-drop.sql
  16. … 35 more files in changeset.
Tuesday 16 Apr 2002
3:53 pm

arjun

dotlrn portal template stuff (not fully functional).

Options
    • -2
    • +4
    ./dotlrn-communities-create.sql
    • -0
    • +11
    ./dotlrn-init.sql
  3. … 21 more files in changeset.
Saturday 06 Apr 2002
8:27 am

yon

optimized dotlrn_users view

Options
    • -9
    • +13
    ./dotlrn-users-create.sql
  2. … 1 more file in changeset.
Thursday 04 Apr 2002
10:35 pm

yon

fully qualifying to avoid ambiguities that cause bugs

Options
    • -40
    • +49
    ./dotlrn-communities-package-create.sql
7:55 am

yon

speedup

Options
    • -11
    • +10
    ./dotlrn-communities-package-create.sql
  2. … 4 more files in changeset.
Wednesday 03 Apr 2002
2:33 am

arjun

some speedups and cleanups

Options
    • -0
    • +22
    ./dotlrn-communities-package-create.sql
  2. … 6 more files in changeset.
Monday 01 Apr 2002
9:33 am

ben

fixed order of loading for new dependencies

Options
    • -0
    • +200
    ./dotlrn-classes-memberships-create.sql
    • -222
    • +1
    ./dotlrn-community-memberships-create.sql
    • -3
    • +4
    ./dotlrn-create.sql
    • -0
    • +50
    ./dotlrn-init.sql
Friday 29 Mar 2002
9:21 pm

yon

separating packages from ddl

Options
    • -315
    • +1
    ./dotlrn-communities-create.sql
  2. … 3 more files in changeset.
9:02 pm

ben

fixed package creation

Options
    • -0
    • +330
    ./dotlrn-communities-package-create.sql
    • -0
    • +1
    ./dotlrn-create.sql
8:59 pm

yon

working around limitations in acs_object_types caused an error in the creation of the base dotlrn_community_types; this will be fixed once i fix the acs_object_types table

Options
    • -1
    • +5
    ./dotlrn-init.sql
  2. … 1 more file in changeset.