insert_test_data.sql

  • last updated a few seconds ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Add test record for chosen group

Add group name.

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.

Changed db urls to not start with leading slash.

  1. … 6 more files in changeset.
changed the test data for survey template. changed the service_name from surveyService to srvyService, as the former clashes with the real service bean name of the actual survey tool.

Moved users and workspaces load to the initial database load.

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

  1. … 3 more files in changeset.
Changed name of local db login user to "mmm" and added learner and staff roles to organisations

Added initial Theme support

  1. … 48 more files in changeset.
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.

*** empty log message ***

  1. … 7 more files in changeset.
*** empty log message ***

  1. … 10 more files in changeset.
*** empty log message ***

workspaceFolder related data added

testing sequence modified - schedule gate and permission gate added

  1. … 1 more file in changeset.
Added test data for the content repository

new test data for gate activity

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)

  1. … 4 more files in changeset.
change some grouping data to make more sense.

update apply grouping flag test data

update java code against change in database

  1. … 5 more files in changeset.
change survey tool to real url

add test user to group

*** empty log message ***

  1. … 1 more file in changeset.
added table lams_workspace_folder_type (and values for it to insert_types sql)

|

lams_workspace_folder:

added user_id (implicit fk to user table)

added create_date_time

added last_modified_date_time

added lams_workspace_folder_type_id (fk to lasm_workspace_folder_type)

|

lams_learning_library:

added valid flag

|

lams_tool:

added valid_flag

added learning_library_id (fk to lams_learning_library)

|

lams_learning_design:

added last_modified_date_time

|

lams_lesson:

made name mandatory

|

lams_learner_progress

added requires_restart_flag

|

other: added values for workspace type to insert types

|

other moved values for auth method and activity category from insert test data to insert types data

added new lesson field and modify the problematic test data

  1. … 1 more file in changeset.
*** empty log message ***

  1. … 2 more files in changeset.
test data for transition modified

upgrade mysql connector to 3.1.7

  1. … 5 more files in changeset.
made from_ui_id and to_ui_id in transition table nullable

  1. … 3 more files in changeset.
Transitions for childActivities of ComplexActivities removed.