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 26 Sep 2005
2:04 am

fmalikoff

Removed '/lams' from the image urls as per Dave's request. He will include the 'lams' bit.

Options
    • -14
    • +14
    ./insert_test_data.sql
  2. … 3 more files in changeset.
Monday 19 Sep 2005
4:22 am

fmalikoff

Changed name of local db login user to "mmm" and added learner and staff roles to organisations

Options
    • -2
    • +11
    ./insert_test_data.sql
Monday 22 Aug 2005
1:57 am

fmalikoff

Added in error - is a temporary file.

Options
    • -743
    • +0
    ./lams_11.sql
1:47 am

fmalikoff

Added initial Theme support

Options
    • -82
    • +125
    ./create_lams_11_tables.sql
    • -0
    • +4
    ./drop_lams_11_tables.sql
    • -4
    • +4
    ./insert_survey_design.sql
    • -144
    • +159
    ./insert_test_data.sql
    • -0
    • +743
    ./lams_11.sql
  6. … 44 more files in changeset.
Wednesday 22 Jun 2005
12:46 am

fmalikoff

Added tool icon paths. The icons have come from Dave, and are yet to reconciled to our list of tools. They are stuck in lams_central for now but should go into the tool projects.

Options
    • -28
    • +28
    ./insert_test_data.sql
Friday 17 Jun 2005
3:53 am

fmalikoff

Changed name of constraints - sometimes causes problems with creating the database.

Options
    • -4
    • +4
    ./create_lams_11_tables.sql
  2. … 2 more files in changeset.
Saturday 28 May 2005
5:43 am

mminhas

*** empty log message ***

Options
    • -82
    • +69
    ./insert_test_data.sql
  2. … 7 more files in changeset.
Thursday 05 May 2005
5:20 am

mminhas

*** empty log message ***

Options
    • -0
    • +27
    ./create_lams_11_tables.sql
    • -1
    • +2
    ./drop_lams_11_tables.sql
    • -1
    • +14
    ./insert_test_data.sql
    • -0
    • +2
    ./insert_types_data.sql
  5. … 7 more files in changeset.
Wednesday 27 Apr 2005
3:29 am

jfang

changed test learning desing foreign key

Options
    • -1
    • +1
    ./insert_survey_design.sql
Tuesday 26 Apr 2005
6:09 am

jfang

test learning design

Options
    • -0
    • +21
    ./insert_survey_design.sql
Thursday 14 Apr 2005
1:56 am

mminhas

*** empty log message ***

Options
    • -74
    • +8
    ./insert_test_data.sql
Wednesday 13 Apr 2005
1:48 am

mminhas

workspaceFolder related data added

Options
    • -27
    • +209
    ./insert_test_data.sql
1:44 am

mminhas

*** empty log message ***

Options
    • -8
    • +0
    ./insert_types_data.sql
Tuesday 12 Apr 2005
7:01 am

jfang

testing sequence modified - schedule gate and permission gate added

Options
    • -5
    • +81
    ./insert_test_data.sql
  2. … 1 more file in changeset.
Monday 11 Apr 2005
6:46 am

jfang

get rid of comments that cause the failure of ant run

Options
    • -20
    • +0
    ./drop_lams_11_tables.sql
Friday 08 Apr 2005
8:55 am

fmalikoff

Added test data for the content repository

Options
    • -0
    • +27
    ./insert_test_data.sql
Thursday 07 Apr 2005
7:13 am

cperfect

removed the "use lams" clause: makes testing very difficult

Options
    • -2
    • +0
    ./drop_lams_11_tables.sql
4:18 am

jfang

new test data for gate activity

Options
    • -7
    • +45
    ./insert_test_data.sql
Wednesday 06 Apr 2005
5:50 am

fmalikoff

DB Changes:

lams_tool: columns learning_library_id and default_tool_content_id made nullable (C Perfect's request).

lams_user: column user_organisation_id removed (checked with F Yang)

Options
    • -5
    • +9
    ./create_lams_11_tables.sql
    • -3
    • +3
    ./insert_test_data.sql
  3. … 3 more files in changeset.
Thursday 31 Mar 2005
2:47 am

jfang

change some grouping data to make more sense.

Options
    • -2
    • +2
    ./insert_test_data.sql
Sunday 27 Mar 2005
4:58 pm

yoichi

table names alphabetically sorted

Options
    • -36
    • +40
    ./drop_lams_11_tables.sql
4:32 pm

yoichi

create tables and insert statementsd are out of date and removed

Options
    • -526
    • +0
    ./create_lams_11_db.sql
12:37 pm

yoichi

DEFAULT CHARACTER SET utf8 is added to CREATE DATABASE

DEFAULT 0 is removed from AUTO_INCREMENT

Options
    • -18
    • +19
    ./create_lams_11_db.sql
Tuesday 22 Mar 2005
2:30 am

jfang

update apply grouping flag test data

Options
    • -11
    • +11
    ./insert_test_data.sql
1:40 am

cperfect

Modified table lams_workspace:

made root_folder_id nullable

Options
    • -1
    • +1
    ./create_lams_11_tables.sql
  2. … 1 more file in changeset.
Monday 21 Mar 2005
7:34 am

jfang

update java code against change in database

Options
    • -2
    • +2
    ./create_lams_11_tables.sql
    • -104
    • +176
    ./insert_test_data.sql
  3. … 4 more files in changeset.
Friday 18 Mar 2005
5:32 am

cperfect

added table lams_log_event_type

added table lams_log_event (includes fk to lams_log_event_type)

modified table lams_tool:

added create_date_time

modified insert_types_data.sql:

added values for lasm_log_event_type

Options
    • -53
    • +73
    ./create_lams_11_tables.sql
    • -0
    • +10
    ./drop_lams_11_tables.sql
    • -1
    • +12
    ./insert_types_data.sql
  4. … 1 more file in changeset.
Wednesday 16 Mar 2005
1:20 am

jfang

change survey tool to real url

add test user to group

Options
    • -1
    • +2
    ./insert_test_data.sql
Tuesday 15 Mar 2005
4:10 am

cperfect

altered table lams_learning_activity:

added apply_grouping_flag

Options
    • -0
    • +2
    ./create_lams_11_tables.sql
  2. … 1 more file in changeset.
3:54 am

cperfect

Added table:

lams_grouping_support_type

Modified table lams_tool:

added supports_contribution_flag

added supports_moderation_flag

added grouping_support_type_id (fk to lams_grouping_support_type)

Modifed table lams_learning_activity:

added online_instructions

added grouping_support_type_id (fk to lams_grouping_support_type)

Modified insert_types_data.sql to include 3 values for lams_grouping_support: NONE, OPTIONAL, REQUIRED

Options
    • -2
    • +17
    ./create_lams_11_tables.sql
    • -0
    • +5
    ./drop_lams_11_tables.sql
    • -0
    • +8
    ./insert_types_data.sql
  4. … 1 more file in changeset.