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: 14 Nov
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 54 mins ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Friday 28 Jun 2002
2:14 am

yon

optimized tree trigger a little bit

Options
    • -19
    • +18
    ./communities-tree-create.sql
  2. … 2 more files in changeset.
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
Monday 24 Jun 2002
11:10 pm

yon

tree.increment_key() now does the lpadding for us

Options
    • -2
    • +2
    ./communities-tree-create.sql
  2. … 2 more files in changeset.
Thursday 20 Jun 2002
10:33 pm

arjun

One of the index names was too long for oracle

Options
    • -2
    • +2
    ./communities-create.sql
Thursday 13 Jun 2002
6:34 am

arjun

Use icon and alt text attrs for groups

Options
    • -1
    • +12
    ./dotlrn-init.sql
  2. … 3 more files in changeset.
6:28 am

arjun

added for icon alt text change in groups

Options
    • -0
    • +29
    ./upgrade/upgrade-jun-12-2002.sql
Friday 07 Jun 2002
7:00 am

arjun

fix typo

Options
    • -1
    • +1
    ./upgrade/upgrade-jun-07-2002.sql
6:45 am

arjun

adding some indexes

Options
    • -0
    • +2
    ./upgrade/upgrade-jun-07-2002.sql
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.