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
Friday 05 May 2006
2:59 pm

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.
1:35 pm

fmalikoff

Temporary test data to get getOrganisationByUserRole working

Options
    • -0
    • +273
    ./insert_users_org_test.sql
Friday 21 Apr 2006
10: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
1:09 pm

fmalikoff

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

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

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.
1:54 pm

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.
1:51 pm

fmalikoff

Trying to fix the binary/text status

Options
    • -0
    • +37
    ./create_lams_11_db.sql
1:48 pm

fmalikoff

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

Options
    • -37
    • +0
    ./create_lams_11_db.sql
1:47 pm

fmalikoff

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

Options
    • -1
    • +1
    ./create_lams_11_db.sql
1:46 pm

fmalikoff

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

Options
    • -0
    • +37
    ./create_lams_11_db.sql
1:44 pm

fmalikoff

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

Options
    • -37
    • +0
    ./create_lams_11_db.sql
1:00 pm

fmalikoff

Temporary file - should not have been checked in previously

Options
    • -764
    • +0
    ./lams_11.sql
12:58 pm

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
12:57 pm

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.
9: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.
Tuesday 14 Mar 2006
2:02 pm

mseaton

Add drop instructions for Quartz tables.

Options
    • -0
    • +13
    ./drop_lams_11_tables.sql
2:02 pm

mseaton

Updated for use in rebuild-db task.

Options
    • -15
    • +15
    ./create_lams_11_db.sql
Monday 13 Mar 2006
1:49 pm

steven

Add quartz persist table and upgrade to 1.5.2 from 1.5.0RC

Options
    • -0
    • +169
    ./create_quartz_table.sql
  2. … 24 more files in changeset.
Friday 10 Mar 2006
7:15 am

fmalikoff

Split learner and export urls (in Tool) to have separate urls for teacher, learner and authoring modes.

Options
    • -126
    • +151
    ./insert_test_data.sql
Thursday 09 Mar 2006
8:38 am

steven

Remove nv_id in lams_cr_node table.

Options
    • -1
    • +0
    ./create_lams_11_tables.sql
    • -2
    • +2
    ./insert_test_data.sql
  3. … 1 more file in changeset.
Wednesday 08 Mar 2006
8:02 pm

fmalikoff

Split learner and export urls (in Tool) to have separate urls for teacher, learner and authoring modes. Added language file columns to activity and tool - this will be used to internationalise the activity and tool name and descriptions that are currently in the database.

Options
    • -6
    • +12
    ./create_lams_11_tables.sql
    • -0
    • +764
    ./lams_11.sql
  3. … 34 more files in changeset.
Monday 20 Feb 2006
1:30 pm

fmalikoff

Added a survey only learning design to use when testing preview.

Options
    • -2
    • +33
    ./insert_test_data.sql
Thursday 16 Feb 2006
11:53 am

steven

upgrade for MySQL5.x

Options
    • -1
    • +0
    ./create_lams_11_tables.sql
    • -24
    • +24
    ./insert_test_data.sql
  3. … 1 more file in changeset.
Wednesday 08 Feb 2006
8:04 am

steven

change lams_tool test data to avoid conflict in submit tool.

Options
    • -1
    • +1
    ./insert_test_data.sql
  2. … 1 more file in changeset.
7:44 am

steven

Persist toolSessionName.

Options
    • -0
    • +1
    ./create_lams_11_tables.sql
  2. … 3 more files in changeset.
Monday 06 Feb 2006
11:28 am

steven

Add test record for chosen group

Options
    • -0
    • +35
    ./insert_test_data.sql
Thursday 02 Feb 2006
2:27 pm

steven

Add group name.

Options
    • -4
    • +4
    ./insert_test_data.sql
1:51 pm

steven

Add group name.

Options
    • -0
    • +1
    ./create_lams_11_tables.sql
  2. … 11 more files in changeset.
Wednesday 01 Feb 2006
7:21 am

fmalikoff

Changed name of parentLearningDesign to originalLearningDesign. This field links the lesson version of a design back to its original design, but the parent name suggests that the parent learning design contains the child learning design (this is the meaning in the activity table) so the name was changed.

Options
    • -1
    • +1
    ./insert_test_data.sql
Tuesday 31 Jan 2006
8:53 pm

fmalikoff

Changed name of parentLearningDesign to originalLearningDesign. This field links the lesson version of a design back to its original design, but the parent name suggests that the parent learning design contains the child learning design (this is the meaning in the activity table) so the name was changed.

Options
    • -4
    • +2
    ./create_lams_11_tables.sql
  2. … 9 more files in changeset.