Clone Tools
  • last updated a few seconds ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
changed authentication method table to match Fei's changes

changes for lessons

change SUB-ORGANIZATION as SUB-ORGANISATION

Altered LessonProgress: has a set of completed activities a set of attempted activities and one current activity

no message

    • -270
    • +0
    ./sql/create_learning_design_tables.sql
    • -142
    • +0
    ./sql/create_user_management_tables.sql
    • -140
    • +0
    ./sql/drop_learning_design_tables.sql
    • -31
    • +0
    ./sql/drop_user_management_tables.sql
    • -26
    • +0
    ./sql/insert_user_management_data.sql
updated db

    • -82
    • +101
    ./sql/create_lams_11_tables.sql
    • -287
    • +13
    ./sql/drop_lams_11_tables.sql
moved old scripts to old folder

    • -0
    • +31
    ./sql/old/add_workspace_tables.sql
    • -0
    • +462
    ./sql/old/create_lams_11_tables.sql
    • -0
    • +568
    ./sql/old/create_lams_db.sql
    • -0
    • +270
    ./sql/old/create_learning_design_tables.sql
    • -0
    • +142
    ./sql/old/create_user_management_tables.sql
    • -0
    • +114
    ./sql/old/drop_lams_11_tables.sql
    • -0
    • +140
    ./sql/old/drop_learning_design_tables.sql
    • -0
    • +31
    ./sql/old/drop_user_management_tables.sql
    • -0
    • +39
    ./sql/old/insert_test_data.sql
    • -0
    • +62
    ./sql/old/insert_types_data.sql
    • -0
    • +26
    ./sql/old/insert_user_management_data.sql
    • -0
    • +547
    ./sql/old/lams_11_scratch.sql
    • -0
    • +43
    ./sql/old/tables.txt
change tool session state default value

*** empty log message ***

change user names and authentication method names for testing

make base_organisation_id nullable (sysadmin has no base organisation)

add some test data

*** empty log message ***

remove user_organisation_id column

Added library_activity_ui_image to lams_learning_activity and max_no_of_groups to lams_grouping

change according to chris's change of create_lams_11_tables.sql

Changed PKs to auto generate for dymanic tables, add lams_tool_content table

*** empty log message ***

*** empty log message ***

all in one create lams database script

    • -0
    • +556
    ./sql/create_lams_db.sql
drop,create and populate 3 in 1 script

    • -0
    • +519
    ./sql/setup_lams_tables.sql
*** empty log message ***

    • -0
    • +33
    ./sql/insert_test_data.sql
  1. … 11 more files in changeset.
remove user_organisation_id column from lams_user table, because it shouldn't be there

Updated DB design: changes to lesson realted tables. lams_tool_content table removed. Added nee columns to lams_tool table.

    • -85
    • +115
    ./sql/create_lams_11_tables.sql
remove lams_authentication_method_parameter table; add authentication_method_name column to lams_authentication_method table

added lesson state

fix duplicate entry error

no message

no message

    • -0
    • +62
    ./sql/insert_types_data.sql
no message

    • -82
    • +181
    ./sql/create_lams_11_tables.sql