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
Tuesday 15 Aug 2006
10:46 am

fmalikoff

Some more translated names.

Options
    • -13
    • +13
    ./insert_types_data.sql
Monday 14 Aug 2006
7:46 pm

fmalikoff

Added correct UTF-8 versions of some of the locale descriptions

Options
    • -2
    • +2
    ./insert_types_data.sql
7:46 pm

fmalikoff

Added in error previously

Options
    • -48
    • +0
    ./lams_user.sql
2:18 pm

fyang

give course manager role to the foreign users

Options
    • -51
    • +51
    ./shaun/all.sql
8:54 am

fmalikoff

MySQL on Shaun won't take the foriegn key for the locale fields.

Options
    • -7
    • +1
    ./create_lams_11_tables.sql
8:04 am

fmalikoff

Clay model had wrong foriegn keys for organisation (mouse errors while updating), leading to bad foriegn keys in the script. The new locale foriegn key missing in the user script.

Options
    • -8
    • +7
    ./create_lams_11_tables.sql
    • -0
    • +48
    ./lams_user.sql
  3. … 1 more file in changeset.
7:09 am

fmalikoff

Removed redundant language and country tables - now just use the supported locale tables.

Options
    • -21
    • +12
    ./create_lams_11_tables.sql
    • -9
    • +1
    ./insert_types_data.sql
    • -19
    • +19
    ./insert_users.sql
    • -0
    • +433
    ./shaun/all.sql
    • -24
    • +0
    ./shaun/lams_user_bulgarian.sql
    • -25
    • +0
    ./shaun/lams_user_chinese.sql
    • -24
    • +0
    ./shaun/lams_user_french.sql
    • -24
    • +0
    ./shaun/lams_user_german.sql
    • -24
    • +0
    ./shaun/lams_user_hungarian.sql
    • -25
    • +0
    ./shaun/lams_user_italian.sql
    • -25
    • +0
    ./shaun/lams_user_korean.sql
    • -24
    • +0
    ./shaun/lams_user_maori.sql
    • -24
    • +0
    ./shaun/lams_user_norwegian.sql
    • -25
    • +0
    ./shaun/lams_user_polish.sql
    • -24
    • +0
    ./shaun/lams_user_portbr.sql
  16. … 20 more files in changeset.
Friday 11 Aug 2006
12:00 pm

fmalikoff

Attempted to translate some of the language names

Options
    • -5
    • +5
    ./insert_types_data.sql
Thursday 10 Aug 2006
11:22 am

fmalikoff

Remove unused lesson columns in Learning Design table

Options
    • -7
    • +2
    ./create_lams_11_tables.sql
    • -857
    • +0
    ./lams_11.sql
  3. … 9 more files in changeset.
Monday 07 Aug 2006
5:07 pm

fmalikoff

Added programatically controlled join class for the many-to-many relationship between workspace and workspace folder. Just can't seem to get Hibernate to create the record when we do it using Hibernate's many-to-many.

This should fix the problem with the folder for a new organisation not appearing in the authoring module.

Options
    • -2
    • +4
    ./create_lams_11_tables.sql
    • -11
    • +11
    ./insert_users.sql
  3. … 11 more files in changeset.
Thursday 03 Aug 2006
8:05 am

fmalikoff

Added Dutch to the list of supported locales

Options
    • -1
    • +3
    ./insert_types_data.sql
8:05 am

fmalikoff

Added accidently - temporary file used to create this table.

Options
    • -13
    • +0
    ./lams_supported_locale.sql
Wednesday 02 Aug 2006
2:15 pm

fmalikoff

Adding support for LAMS 1.0.2 import. Includes a table to map the old tool types to our new tool signatures. Can import a sequence with tool tasks, no grouping and no data.

Options
    • -1
    • +10
    ./create_lams_11_tables.sql
    • -2
    • +23
    ./insert_types_data.sql
  3. … 18 more files in changeset.
10:26 am

asukkar

Renamed variable for consistency.

Options
    • -1
    • +1
    ./create_notebook_tables.sql
    • -1
    • +1
    ./notebook_table-schema.sql
  3. … 2 more files in changeset.
Tuesday 01 Aug 2006
12:10 pm

asukkar

Added new field create_date and update_date

Options
    • -1
    • +1
    ./create_notebook_tables.sql
    • -1
    • +1
    ./notebook_table-schema.sql
  3. … 1 more file in changeset.
Monday 31 Jul 2006
1:20 pm

asukkar

Changed entry field to use text rather than varchar

Options
    • -1
    • +1
    ./create_notebook_tables.sql
    • -1
    • +1
    ./notebook_table-schema.sql
  3. … 3 more files in changeset.
Wednesday 26 Jul 2006
12:49 pm

Ernie Ghiglione

Changed the name of the licensing and all the LAMS Recommended license. Also we will use the license_id to sort the display licenses when presented in authoring (so re-ordered them appropriately

Options
    • -7
    • +7
    ./insert_types_data.sql
Tuesday 25 Jul 2006
3:12 pm

asukkar

Renamed Journal to Notebook. The Notebook is accessed via coreNotebookService

Options
    • -2
    • +0
    ./create_journal_tables.sql
    • -0
    • +2
    ./create_notebook_tables.sql
    • -2
    • +0
    ./journal_table-schema.sql
    • -0
    • +2
    ./notebook_table-schema.sql
  5. … 14 more files in changeset.
Thursday 20 Jul 2006
2:11 pm

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
2:47 pm

jliew

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

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

fyang

change 'null' to null

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

fyang

set country to null for some orgs

Options
    • -4
    • +4
    ./insert_users.sql
Thursday 29 Jun 2006
2:05 pm

fmalikoff

Added the "course admin can do blah" fields

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

fyang

remove unsupported countries

Options
    • -6
    • +6
    ./insert_users.sql
12:34 pm

fyang

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

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

fyang

add/modify some data

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

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
7: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
8: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.
9:44 am

fyang

sha1 passwords for shaun users

Options
    • binary
    ./shaun/sha1_shaun_user_password.sql