lams / lams_common / db

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 19
Last Commit:
Commits this week: 0
Total Lines of Code (LoC): 2,833
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 a few seconds ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Thursday 20 Jul 2006
8:11 am

asukkar

Added Journal Service.

Options
    • -0
    • +2
    ./create_journal_tables.sql
    • -0
    • +2
    ./journal_table-schema.sql
  3. … 9 more files in changeset.
Thursday 06 Jul 2006
8:47 am

jliew

change lamskh01 country from 'nz' to 'au' (nz not currently in supported_locale)

Options
    • -2
    • +2
    ./insert_users.sql
Friday 30 Jun 2006
5:21 am

fyang

change 'null' to null

Options
    • -4
    • +4
    ./insert_users.sql
4:34 am

fyang

set country to null for some orgs

Options
    • -4
    • +4
    ./insert_users.sql
Thursday 29 Jun 2006
8:05 am

fmalikoff

Added the "course admin can do blah" fields

Options
    • -1
    • +6
    ./create_lams_11_tables.sql
  2. … 3 more files in changeset.
6:36 am

fyang

remove unsupported countries

Options
    • -6
    • +6
    ./insert_users.sql
6:34 am

fyang

reverted to previous version, to be synchronized with the list in lams community website

Options
    • -3
    • +1
    ./insert_types_data.sql
4:12 am

fyang

add/modify some data

Options
    • -2
    • +4
    ./insert_types_data.sql
Wednesday 28 Jun 2006
7:42 am

fmalikoff

Adding a combined language/country supported locale table

Options
    • -1
    • +15
    ./create_lams_11_tables.sql
    • -1
    • +38
    ./insert_types_data.sql
    • -1
    • +17
    ./lams_11.sql
    • -0
    • +13
    ./lams_supported_locale.sql
  5. … 4 more files in changeset.
Friday 23 Jun 2006
1:03 am

fmalikoff

Genericising the relationship between folders and workspaces - now one folder can be in many workspaces. Problem with the code though - when run from junit the relationship is set up okay, but when run in JBOSS the lams_workspace_workspace_folder records are not created.

Options
    • -7
    • +17
    ./create_lams_11_tables.sql
    • -39
    • +50
    ./insert_users.sql
    • -0
    • +841
    ./lams_11.sql
    • -3
    • +4
    ./shaun/lams_user_bulgarian.sql
    • -3
    • +4
    ./shaun/lams_user_chinese.sql
    • -3
    • +4
    ./shaun/lams_user_french.sql
    • -3
    • +4
    ./shaun/lams_user_german.sql
    • -4
    • +5
    ./shaun/lams_user_hungarian.sql
    • -3
    • +4
    ./shaun/lams_user_italian.sql
    • -3
    • +4
    ./shaun/lams_user_korean.sql
    • -3
    • +4
    ./shaun/lams_user_maori.sql
    • -3
    • +4
    ./shaun/lams_user_norwegian.sql
    • -3
    • +4
    ./shaun/lams_user_polish.sql
    • -3
    • +4
    ./shaun/lams_user_portbr.sql
    • -3
    • +4
    ./shaun/lams_user_spanish.sql
  16. … 19 more files in changeset.
Wednesday 21 Jun 2006
2:02 pm

fmalikoff

Implementing gate and grouping screens for export portfolio.

Options
    • -1
    • +5
    ./create_lams_11_tables.sql
    • -6
    • +9
    ./insert_types_data.sql
  3. … 41 more files in changeset.
3:44 am

fyang

sha1 passwords for shaun users

Options
    • binary
    ./shaun/sha1_shaun_user_password.sql
Tuesday 20 Jun 2006
8:25 am

fyang

sha1 password

Options
    • -9
    • +9
    ./insert_users.sql
  2. … 1 more file in changeset.
Thursday 08 Jun 2006
9:06 am

fyang

insert locale_language and locale_country into lams_organisation table

Options
    • -13
    • +13
    ./insert_users.sql
Wednesday 07 Jun 2006
12:36 am

fmalikoff

Adding unarchive functionality.

Options
    • -1
    • +2
    ./create_lams_11_tables.sql
    • -273
    • +0
    ./insert_users_org_test.sql
  3. … 11 more files in changeset.
Tuesday 06 Jun 2006
9:07 am

fyang

insert data lams_privilege, lams_role_privilege tables

modified data in lams_role table

Options
    • -3
    • +39
    ./insert_types_data.sql
4:36 am

fmalikoff

Implementation of jsp based chosen grouping, with the appropriate screen in monitoring.

Options
    • -2
    • +4
    ./insert_types_data.sql
  2. … 15 more files in changeset.
1:35 am

fyang

add commas between the common values to fix the sql syntax error. Sorry about the build failures

Options
    • -6
    • +6
    ./insert_types_data.sql
Monday 05 Jun 2006
8:36 am

fyang

insert some data into lams_country and lams_language

Options
    • -1
    • +7
    ./insert_types_data.sql
8:27 am

fyang

Added lams_language and lams_country tables

Options
    • -1
    • +11
    ./create_lams_11_tables.sql
Wednesday 31 May 2006
2:33 pm

fmalikoff

Enforce uniqueness of lesson/user id relationship in learner progress table. Ensures that the query based on lesson, user id will only return one row.

Options
    • -1
    • +2
    ./create_lams_11_tables.sql
  2. … 1 more file in changeset.
2:32 pm

fmalikoff

Fixed typo in name

Options
    • -2
    • +2
    ./insert_users.sql
Tuesday 30 May 2006
2:37 pm

fmalikoff

Updated users so that all are staff - now mmm should appear on the staff list in the wizard.

Options
    • -17
    • +17
    ./insert_users.sql
Tuesday 23 May 2006
6:17 am

fmalikoff

Adding organisation status

Options
    • -1
    • +11
    ./create_lams_11_tables.sql
    • -1
    • +6
    ./insert_types_data.sql
    • -13
    • +13
    ./insert_users.sql
  4. … 1 more file in changeset.
4:09 am

fmalikoff

Adding new org columns and the privilege tables

Options
    • -2
    • +27
    ./create_lams_11_tables.sql
    • -13
    • +13
    ./insert_users.sql
  3. … 1 more file in changeset.
Friday 19 May 2006
5:37 am

fmalikoff

Had overlapped the workspace id with a value used by a language test user.

Options
    • -5
    • +5
    ./insert_users.sql
5:22 am

fmalikoff

Adding a run sequence folder to a course's workspace.

Fixing bugs in authoring relating to grouped activities.

Options
    • -1
    • +5
    ./create_lams_11_tables.sql
    • -3
    • +9
    ./insert_users.sql
  3. … 15 more files in changeset.
Friday 12 May 2006
7:15 am

fmalikoff

Hadn't set up the user's personal folders correctly.

Options
    • -1
    • +1
    ./shaun/lams_user_bulgarian.sql
    • -1
    • +1
    ./shaun/lams_user_chinese.sql
    • -1
    • +1
    ./shaun/lams_user_french.sql
    • -1
    • +1
    ./shaun/lams_user_german.sql
    • -1
    • +1
    ./shaun/lams_user_hungarian.sql
    • -1
    • +1
    ./shaun/lams_user_italian.sql
    • -1
    • +1
    ./shaun/lams_user_korean.sql
    • -1
    • +1
    ./shaun/lams_user_maori.sql
    • -1
    • +1
    ./shaun/lams_user_norwegian.sql
    • -1
    • +1
    ./shaun/lams_user_polish.sql
    • -1
    • +1
    ./shaun/lams_user_portbr.sql
    • -1
    • +1
    ./shaun/lams_user_spanish.sql
3:06 am

fmalikoff

Fixed the roles - had made them author, staff and teacher, not author, learner and teacher!

Options
    • -3
    • +3
    ./shaun/lams_user_bulgarian.sql
    • -3
    • +3
    ./shaun/lams_user_chinese.sql
    • -3
    • +3
    ./shaun/lams_user_french.sql
    • -3
    • +3
    ./shaun/lams_user_german.sql
    • -3
    • +3
    ./shaun/lams_user_hungarian.sql
    • -3
    • +3
    ./shaun/lams_user_italian.sql
    • -3
    • +3
    ./shaun/lams_user_korean.sql
    • -3
    • +3
    ./shaun/lams_user_maori.sql
    • -3
    • +3
    ./shaun/lams_user_norwegian.sql
    • -3
    • +3
    ./shaun/lams_user_polish.sql
    • -4
    • +4
    ./shaun/lams_user_portbr.sql
    • -3
    • +3
    ./shaun/lams_user_spanish.sql
    • -3
    • +3
    ./shaun/lams_user_swedish.sql
Thursday 11 May 2006
1:07 pm

fmalikoff

Updated the SQL scripts to load the language test users to suit the new organisations.

Options
    • -0
    • +23
    ./shaun/lams_user_bulgarian.sql
    • -0
    • +24
    ./shaun/lams_user_chinese.sql
    • -0
    • +23
    ./shaun/lams_user_french.sql
    • -0
    • +23
    ./shaun/lams_user_german.sql
    • -0
    • +23
    ./shaun/lams_user_hungarian.sql
    • -0
    • +24
    ./shaun/lams_user_italian.sql
    • -0
    • +24
    ./shaun/lams_user_korean.sql
    • -0
    • +23
    ./shaun/lams_user_maori.sql
    • -0
    • +23
    ./shaun/lams_user_norwegian.sql
    • -0
    • +24
    ./shaun/lams_user_polish.sql
    • -0
    • +23
    ./shaun/lams_user_portbr.sql
    • -0
    • +24
    ./shaun/lams_user_spanish.sql
    • -0
    • +24
    ./shaun/lams_user_swedish.sql
  14. … 1 more file in changeset.