OpenACS / openacs-4 / packages / dotlrn

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 20
Last Commit: 16:56
Commits this week: 0
Total Lines of Code (LoC): 18,051
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 3 hours ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Monday 15 Jul 2002
8:32 pm

chak

dotlrn.. it keeps going, and going..

Options
    • -4
    • +4
    ./postgresql/communities-package-create.sql
    • -2
    • +2
    ./postgresql/community-memberships-packages-create.sql
  3. … 5 more files in changeset.
Saturday 13 Jul 2002
2:43 am

yon

update info file. fix referential constraint in dotlrn_applets table.

Options
    • -2
    • +2
    ./oracle/applets-create.sql
    • -2
    • +2
    ./postgresql/applets-create.sql
  3. … 1 more file in changeset.
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
    • -0
    • +65
    ./oracle/applets-create.sql
    • -0
    • +28
    ./oracle/applets-drop.sql
    • -39
    • +1
    ./oracle/communities-create.sql
    • -3
    • +1
    ./oracle/communities-drop.sql
    • -1
    • +2
    ./oracle/dotlrn-create.sql
    • -1
    • +2
    ./oracle/dotlrn-drop.sql
    • -0
    • +68
    ./postgresql/applets-create.sql
    • -0
    • +28
    ./postgresql/applets-drop.sql
    • -40
    • +1
    ./postgresql/communities-create.sql
    • -3
    • +1
    ./postgresql/communities-drop.sql
    • -0
    • +1
    ./postgresql/dotlrn-create.sql
    • -1
    • +2
    ./postgresql/dotlrn-drop.sql
  13. … 22 more files in changeset.
Friday 12 Jul 2002
11:26 pm

chak

lots of fixes to get the pg dotlrn working

Options
    • -2
    • +3
    ./postgresql/admins-package-create.sql
    • -4
    • +4
    ./postgresql/communities-package-create.sql
    • -1
    • +1
    ./postgresql/communities-tree-create.sql
    • -2
    • +2
    ./postgresql/externals-package-create.sql
    • -5
    • +5
    ./postgresql/professors-package-create.sql
    • -8
    • +20
    ./postgresql/students-package-create.sql
    • -1
    • +3
    ./postgresql/users-create.sql
    • -18
    • +20
    ./postgresql/users-package-create.sql
  9. … 9 more files in changeset.
Thursday 11 Jul 2002
5:54 pm

chak

some query porting, and bug fixes to support it

Options
    • -2
    • +4
    ./postgresql/classes-create.sql
    • -2
    • +4
    ./postgresql/clubs-create.sql
    • -9
    • +11
    ./postgresql/communities-package-create.sql
    • -21
    • +21
    ./postgresql/communities-tree-create.sql
  5. … 3 more files in changeset.
Tuesday 09 Jul 2002
12:09 am

chak

fixes to get dotlrn postgres port working

Options
    • -2
    • +2
    ./oracle/dotlrn-init.sql
  2. … 4 more files in changeset.
Monday 08 Jul 2002
11:50 pm

yon

fix include statement

Options
    • -2
    • +2
    ./postgresql/dotlrn-drop.sql
11:07 pm

chak

fixed name of file to correspond with oracle

Options
    • -33
    • +0
    ./postgresql/community-membership-packages-drop.sql
    • -0
    • +33
    ./postgresql/community-memberships-packages-drop.sql
    • -2
    • +2
    ./postgresql/dotlrn-drop.sql
11:04 pm

yon

renamed files to match oracle versions

Options
    • -0
    • +75
    ./postgresql/admin-profile-provider-create.sql
    • -0
    • +72
    ./postgresql/admin-profile-provider-drop.sql
    • -0
    • +34
    ./postgresql/admins-create.sql
    • -0
    • +28
    ./postgresql/admins-drop.sql
    • -0
    • +89
    ./postgresql/admins-init.sql
    • -0
    • +91
    ./postgresql/admins-package-create.sql
    • -0
    • +24
    ./postgresql/admins-package-drop.sql
    • -0
    • +91
    ./postgresql/admins-sanitize.sql
    • -0
    • +314
    ./postgresql/applet-sc-create.sql
    • -0
    • +197
    ./postgresql/applet-sc-drop.sql
    • -0
    • +72
    ./postgresql/class-membership-drop.sql
    • -0
    • +225
    ./postgresql/class-memberships-create.sql
    • -0
    • +341
    ./postgresql/classes-create.sql
    • -0
    • +39
    ./postgresql/classes-drop.sql
    • -0
    • +113
    ./postgresql/clubs-create.sql
  16. … 121 more files in changeset.
10:33 pm

chak

datamodel loading dropping works without errors\!

Options
    • -11
    • +11
    ./postgresql/dotlrn-class-memberships-create.sql
    • -2
    • +2
    ./postgresql/dotlrn-communities-drop.sql
    • -1
    • +5
    ./postgresql/dotlrn-communities-package-create.sql
    • -1
    • +1
    ./postgresql/dotlrn-communities-tree-create.sql
    • -2
    • +2
    ./postgresql/dotlrn-communities-tree-drop.sql
    • -18
    • +37
    ./postgresql/dotlrn-init.sql
    • -2
    • +1
    ./postgresql/dotlrn-professors-drop.sql
    • -3
    • +3
    ./postgresql/dotlrn-students-init.sql
6:12 am

chak

fixed functions in which variable names conflicted with function bodies

Options
    • -6
    • +8
    ./postgresql/dotlrn-admins-init.sql
    • -6
    • +8
    ./postgresql/dotlrn-externals-init.sql
    • -6
    • +6
    ./postgresql/dotlrn-professors-init.sql
    • -6
    • +6
    ./postgresql/dotlrn-students-init.sql
    • -48
    • +4
    ./postgresql/dotlrn-users-init.sql
Friday 05 Jul 2002
5:26 pm

chak

dangerously close to loading/dropping without errors

Options
    • -2
    • +1
    ./postgresql/dotlrn-admins-package-drop.sql
    • -2
    • +2
    ./postgresql/dotlrn-admins-sanitize.sql
    • -7
    • +7
    ./postgresql/dotlrn-class-membership-drop.sql
    • -2
    • +2
    ./postgresql/dotlrn-communities-package-create.sql
    • -2
    • +2
    ./postgresql/dotlrn-professors-drop.sql
    • -0
    • +68
    ./postgresql/dotlrn-security-drop.sql
    • -61
    • +0
    ./postgresql/dotlrn-security.drop.sql
Wednesday 03 Jul 2002
9:58 pm

chak

datamodel loading *almost* works

Options
    • -3
    • +3
    ./postgresql/dotlrn-admins-init.sql
    • -87
    • +95
    ./postgresql/dotlrn-applet-sc-drop.sql
    • -17
    • +24
    ./postgresql/dotlrn-class-membership-drop.sql
    • -52
    • +59
    ./postgresql/dotlrn-class-memberships-create.sql
    • -3
    • +3
    ./postgresql/dotlrn-classes-create.sql
    • -3
    • +3
    ./postgresql/dotlrn-clubs-create.sql
    • -3
    • +3
    ./postgresql/dotlrn-communities-create.sql
    • -10
    • +12
    ./postgresql/dotlrn-communities-package-create.sql
    • -2
    • +2
    ./postgresql/dotlrn-communities-tree-drop.sql
    • -3
    • +4
    ./postgresql/dotlrn-create.sql
    • -38
    • +0
    ./postgresql/dotlrn-dotlrn-drop.sql
    • -83
    • +91
    ./postgresql/dotlrn-dotlrn-sanitize.sql
    • -0
    • +38
    ./postgresql/dotlrn-drop.sql
    • -4
    • +5
    ./postgresql/dotlrn-externals-init.sql
    • -2
    • +2
    ./postgresql/dotlrn-externals-sanitize.sql
  16. … 7 more files in changeset.
Tuesday 02 Jul 2002
9:53 pm

chak

little closer to getting the data model to load...

Options
    • -27
    • +34
    ./postgresql/dotlrn-admin-profile-provider-create.sql
    • -4
    • +4
    ./postgresql/dotlrn-admins-create.sql
    • -125
    • +133
    ./postgresql/dotlrn-applet-sc-create.sql
    • -37
    • +37
    ./postgresql/dotlrn-applet-sc-drop.sql
    • -3
    • +4
    ./postgresql/dotlrn-communities-create.sql
    • -3
    • +3
    ./postgresql/dotlrn-communities-package-create.sql
    • -3
    • +3
    ./postgresql/dotlrn-communities-package-drop.sql
    • -2
    • +4
    ./postgresql/dotlrn-communities-tree-drop.sql
    • -2
    • +2
    ./postgresql/dotlrn-community-memberships-create.sql
    • -2
    • +2
    ./postgresql/dotlrn-dotlrn-drop.sql
    • -31
    • +31
    ./postgresql/dotlrn-dotlrn-sanitize.sql
    • -27
    • +35
    ./postgresql/dotlrn-external-profile-provider-create.sql
    • -31
    • +31
    ./postgresql/dotlrn-init.sql
    • -16
    • +16
    ./postgresql/dotlrn-main-portlet-create.sql
    • -11
    • +12
    ./postgresql/dotlrn-main-portlet-drop.sql
  16. … 9 more files in changeset.
8:40 pm

chak

first hack at pg compatibility

Options
    • -22
    • +28
    ./postgresql/dotlrn-admin-profile-provider-drop.sql
    • -9
    • +1
    ./postgresql/dotlrn-admins-create.sql
    • -5
    • +4
    ./postgresql/dotlrn-admins-drop.sql
    • -49
    • +6
    ./postgresql/dotlrn-admins-init.sql
    • -81
    • +15
    ./postgresql/dotlrn-admins-package-create.sql
    • -3
    • +3
    ./postgresql/dotlrn-admins-package-drop.sql
    • -20
    • +30
    ./postgresql/dotlrn-admins-sanitize.sql
    • -99
    • +112
    ./postgresql/dotlrn-applet-sc-create.sql
    • -0
    • +189
    ./postgresql/dotlrn-applet-sc-drop.sql
    • -0
    • +65
    ./postgresql/dotlrn-class-membership-drop.sql
    • -0
    • +218
    ./postgresql/dotlrn-class-memberships-create.sql
    • -37
    • +35
    ./postgresql/dotlrn-classes-create.sql
    • -0
    • +39
    ./postgresql/dotlrn-classes-drop.sql
    • -25
    • +17
    ./postgresql/dotlrn-clubs-create.sql
    • -0
    • +29
    ./postgresql/dotlrn-clubs-drop.sql
  16. … 47 more files in changeset.
Friday 28 Jun 2002
9:50 pm

arjun

fix typo

Options
    • -2
    • +2
    ./oracle/communities-create.sql
2:14 am

yon

optimized tree trigger a little bit

Options
    • -19
    • +18
    ./oracle/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
    ./oracle/communities-create.sql
Monday 24 Jun 2002
11:10 pm

yon

tree.increment_key() now does the lpadding for us

Options
    • -2
    • +2
    ./oracle/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
    ./oracle/communities-create.sql
Thursday 13 Jun 2002
6:34 am

arjun

Use icon and alt text attrs for groups

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

arjun

added for icon alt text change in groups

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

arjun

fix typo

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

arjun

adding some indexes

Options
    • -0
    • +2
    ./oracle/upgrade/upgrade-jun-07-2002.sql
6:42 am

arjun

added some indexes

Options
    • -1
    • +4
    ./oracle/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
    ./oracle/admins-package-create.sql
    • -4
    • +1
    ./oracle/externals-package-create.sql
    • -4
    • +1
    ./oracle/professors-package-create.sql
    • -4
    • +1
    ./oracle/students-package-create.sql
    • -7
    • +1
    ./oracle/users-create.sql
    • -5
    • +3
    ./oracle/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
    ./oracle/communities-create.sql
    • -1
    • +3
    ./oracle/communities-drop.sql
    • -338
    • +65
    ./oracle/communities-tree-create.sql
    • -0
    • +18
    ./oracle/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
    ./oracle/applet-sc-drop.sql
    • -0
    • +196
    ./oracle/class-memberships-create.sql
    • -0
    • +67
    ./oracle/class-memberships-drop.sql
    • -15
    • +3
    ./oracle/classes-create.sql
    • -0
    • +40
    ./oracle/classes-drop.sql
    • -195
    • +0
    ./oracle/classes-memberships-create.sql
    • -16
    • +3
    ./oracle/clubs-create.sql
    • -0
    • +29
    ./oracle/clubs-drop.sql
    • -10
    • +12
    ./oracle/communities-create.sql
    • -0
    • +34
    ./oracle/communities-drop.sql
    • -0
    • +4
    ./oracle/communities-package-create.sql
    • -0
    • +21
    ./oracle/communities-package-drop.sql
    • -0
    • +366
    ./oracle/communities-tree-create.sql
    • -3
    • +2
    ./oracle/community-memberships-create.sql
    • -0
    • +30
    ./oracle/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
    ./oracle/applet-sc-create.sql
    • -1
    • +7
    ./oracle/communities-create.sql
    • -0
    • +1
    ./oracle/dotlrn-create.sql
    • -15
    • +4
    ./oracle/dotlrn-init.sql
    • -0
    • +33
    ./oracle/portal-types-create.sql
    • -0
    • +24
    ./oracle/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
    ./oracle/dotlrn-init.sql