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
Monday 05 Jun 2006
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.
8:57 am

fmalikoff

Changing organisation structure to a simple root, course, class structure.

Options
    • -9
    • +1
    ./create_lams_11_tables.sql
    • -3
    • +3
    ./insert_types_data.sql
    • -168
    • +204
    ./insert_users.sql
  4. … 35 more files in changeset.
Wednesday 10 May 2006
7:43 am

fmalikoff

Moving gate and group url support to a lams_system_tool table - the first "inch" towards making these pluggable tools in a later version of LAMS.

Options
    • -1
    • +25
    ./create_lams_11_tables.sql
    • -4
    • +29
    ./insert_types_data.sql
  3. … 19 more files in changeset.
Monday 08 May 2006
9:24 am

fmalikoff

Reversed changes to test1. Breaks the build on Shaun - special language test users can no longer be added.

Options
    • -39
    • +1
    ./insert_users.sql
9:06 am

fmalikoff

Added extra test organisation data for test1

Options
    • -2
    • +40
    ./insert_users.sql
Friday 05 May 2006
8:59 am

fmalikoff

Added chat id to the user table (for the jabber id)

Options
    • -1
    • +2
    ./create_lams_11_tables.sql
    • -4
    • +4
    ./insert_users.sql
    • -4
    • +4
    ./insert_users_org_test.sql
  4. … 3 more files in changeset.
7:35 am

fmalikoff

Temporary test data to get getOrganisationByUserRole working

Options
    • -0
    • +273
    ./insert_users_org_test.sql
Friday 21 Apr 2006
4:02 am

fmalikoff

Renamed the disabled state to "removed". This will make it less confusing with the u/i which describes the suspended as disabled.

Options
    • -2
    • +2
    ./insert_types_data.sql
  2. … 1 more file in changeset.
Wednesday 12 Apr 2006
7:09 am

fmalikoff

Updated themes so that default is the default flash theme, and not ruby

Options
    • -7
    • +3
    ./insert_users.sql
Tuesday 21 Mar 2006
6:55 am

fmalikoff

Trying to change the type from Binary to Text, so that keyword expansion will work.

Options
    • -0
    • +171
    ./create_quartz_table.sql
    • -0
    • +23
    ./insert_survey_design.sql
    • -0
    • +926
    ./insert_test_data.sql
    • -0
    • +239
    ./insert_users.sql
  5. … 2 more files in changeset.
6:54 am

fmalikoff

Trying to change the type from Binary to Text, so that keyword expansion will work.

Options
    • -171
    • +0
    ./create_quartz_table.sql
    • -23
    • +0
    ./insert_survey_design.sql
    • -926
    • +0
    ./insert_test_data.sql
    • -239
    • +0
    ./insert_users.sql
  5. … 2 more files in changeset.
6:51 am

fmalikoff

Trying to fix the binary/text status

Options
    • -0
    • +37
    ./create_lams_11_db.sql
6:48 am

fmalikoff

Was checked in as binary - trying to convert it to text.

Options
    • -37
    • +0
    ./create_lams_11_db.sql
6:47 am

fmalikoff

No real change - just trying to get id macro to expand.

Options
    • -1
    • +1
    ./create_lams_11_db.sql
6:46 am

fmalikoff

Was checked in as binary - trying to convert it to text.

Options
    • -0
    • +37
    ./create_lams_11_db.sql
6:44 am

fmalikoff

Was checked in as binary - trying to convert it to text.

Options
    • -37
    • +0
    ./create_lams_11_db.sql
6:00 am

fmalikoff

Temporary file - should not have been checked in previously

Options
    • -764
    • +0
    ./lams_11.sql
5:58 am

fmalikoff

Old scripts contained details from initial project work. No longer applicable.

Options
    • -31
    • +0
    ./old/add_workspace_tables.sql
    • -462
    • +0
    ./old/create_lams_11_tables.sql
    • -566
    • +0
    ./old/create_lams_db.sql
    • -270
    • +0
    ./old/create_learning_design_tables.sql
    • -142
    • +0
    ./old/create_user_management_tables.sql
    • -114
    • +0
    ./old/drop_lams_11_tables.sql
    • -140
    • +0
    ./old/drop_learning_design_tables.sql
    • -31
    • +0
    ./old/drop_user_management_tables.sql
    • -39
    • +0
    ./old/insert_test_data.sql
    • -62
    • +0
    ./old/insert_types_data.sql
    • -26
    • +0
    ./old/insert_user_management_data.sql
    • -547
    • +0
    ./old/lams_11_scratch.sql
    • -43
    • +0
    ./old/tables.txt
5:57 am

fmalikoff

Added cvs id - preparing for porting to postgreSQL

Options
    • -5
    • +1
    ./create_lams_11_db.sql
    • -0
    • +2
    ./create_lams_11_tables.sql
    • -0
    • +2
    ./create_quartz_table.sql
    • -0
    • +2
    ./drop_lams_11_tables.sql
    • -0
    • +2
    ./insert_survey_design.sql
    • -0
    • +2
    ./insert_test_data.sql
    • -0
    • +2
    ./insert_types_data.sql
    • -0
    • +2
    ./insert_users.sql
  9. … 1 more file in changeset.
2:12 am

fmalikoff

For 1.1 we will have separate theme definitions - Flash will use a handcoded XML file and HTML (jsps) will use a handcoded css file. As these two may not be in sync, we need two entries in the user table to link to themes. The db has been changed to have two entries but none of the java code is changed to match yet.

Options
    • -4
    • +12
    ./create_lams_11_tables.sql
    • -13
    • +14
    ./insert_users.sql
  3. … 2 more files in changeset.