lams-github / lams_common / db

sql

Clone Tools

Stats

Commits this week: 0
Total Committers: 26
Last Commit:
Commits this week: 0

Lines of code count not available

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
Sunday 31 Dec 2023
3:42 pm

Ernie Ghiglione

LDEV-5395 Update release

- Disable tools to be deprecated in next release (either 4.9 or 5.0)

- Set server version

- Update default user details

Options
    • -30
    • +30
    ./insert_lams_users.sql
  2. … 1 more file in changeset.
Friday 29 Dec 2023
10:38 am

Marcin Cieslak

Merge remote-tracking branch 'origin/v4.7' into v4.8

# Conflicts:

# lams_common/db/sql/insert_lams_config_data.sql

# lams_tool_assessment/conf/language/lams/ApplicationResources.properties

# lams_tool_scratchie/conf/language/lams/ApplicationResources.properties

# lams_tool_scratchie/src/java/org/lamsfoundation/lams/tool/scratchie/ScratchieConstants.java

Merge remote-tracking branch 'origin/LDEV-5397' into v4.8

Options
    • -6
    • +2
    ./insert_lams_config_data.sql
  2. … 9 more files in changeset.
Friday 22 Dec 2023
4:00 pm

Marcin Cieslak

LDEV-5433 Squash DB patches and update versions

Options
    • -1388
    • +1540
    ./create_lams_11_tables.sql
    • -116
    • +128
    ./create_quartz_table.sql
    • -7
    • +3
    ./insert_lams_config_data.sql
    • -1
    • +2
    ./insert_lams_users.sql
    • -11
    • +12
    ./insert_types_data.sql
  6. … 103 more files in changeset.
Thursday 05 Oct 2023
4:09 pm

Marcin Cieslak

LDEV-5416 Fix inconsistent initial data in fresh build

Options
    • -1
    • +0
    ./insert_lams_users.sql
  2. … 2 more files in changeset.
Tuesday 09 May 2023
9:57 pm

Ernie Ghiglione

LDEV-5395 Updating version info

I've been working in LAMS for 20 years (almost) and I always forgot to tag the development versions at the beginning. This is the first time I've done so properly. Hopefully this sets a precedent :-)

Options
    • -2
    • +2
    ./insert_lams_config_data.sql
  2. … 1 more file in changeset.
Wednesday 21 Sep 2022
7:56 am

Marcin Cieslak

LDEV-5328 Squash DB patches and update versions

Options
    • -498
    • +544
    ./create_lams_11_tables.sql
    • -224
    • +179
    ./create_quartz_table.sql
    • -12
    • +114
    ./insert_lams_config_data.sql
    • -48
    • +124
    ./insert_lams_users.sql
    • -235
    • +259
    ./insert_types_data.sql
  6. … 150 more files in changeset.
Tuesday 10 May 2022
5:45 pm

Marcin Cieslak

LDEV-5081 Merge changes made for monitor in LDEV-5083

Options
    • -1847
    • +1410
    ./create_lams_11_tables.sql
    • -5
    • +3
    ./insert_lams_config_data.sql
    • -4
    • +4
    ./insert_types_data.sql
  4. … 34 more files in changeset.
Thursday 20 Jan 2022
7:00 am

Ernie Ghiglione

LDEV-5280 fix timezones and default user details

Now all users have the land down under as country.

Options
    • -1
    • +1
    ./insert_lams_users.sql
4:34 am

Ernie Ghiglione

LDEV-5280 fix timezones and default user details

Options
    • -2
    • +2
    ./insert_lams_users.sql
    • -2
    • +2
    ./insert_types_data.sql
Wednesday 30 Dec 2020
10:05 am

Marcin Cieslak

Merge remote-tracking branch 'origin/v4.0' into LDEV-5016

Conflicts:

lams_build/3rdParty.userlibraries

lams_central/conf/language/lams/ApplicationResources_en_AU.properties

lams_central/src/java/org/lamsfoundation/lams/authoring/template/web/LdTemplateController.java

lams_central/src/java/org/lamsfoundation/lams/authoring/template/web/TBLTemplateController.java

lams_central/src/java/org/lamsfoundation/lams/web/QuestionsController.java

lams_central/web/qb/collection.jsp

lams_central/web/questions/questionFile.jsp

lams_common/db/sql/create_lams_11_tables.sql

lams_common/db/sql/insert_lams_config_data.sql

lams_common/db/sql/insert_types_data.sql

lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20200129.sql

lams_common/src/java/org/lamsfoundation/lams/questions/QuestionWordParser.java

lams_common/src/java/org/lamsfoundation/lams/tool/service/LamsToolService.java

lams_gradebook/src/java/org/lamsfoundation/lams/gradebook/service/GradebookService.java

lams_tool_assessment/conf/language/lams/ApplicationResources_en_AU.properties

lams_tool_assessment/db/sql/create_lams_tool_assessment.sql

lams_tool_lamc/conf/language/lams/ApplicationResources.properties

lams_tool_lamc/conf/language/lams/ApplicationResources_en_AU.properties

lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/model/McContent.java

lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/model/McUsrAttempt.java

lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/service/McService.java

lams_tool_lamc/web/WEB-INF/tags/Arrow.tag

lams_tool_lamc/web/WEB-INF/tags/CKEditor.tag

lams_tool_lamc/web/WEB-INF/tags/Etherpad.tag

lams_tool_lamc/web/WEB-INF/tags/Rating.tag

lams_tool_lamc/web/WEB-INF/tags/StyledRating.tag

lams_tool_lamc/web/authoring/candidateAnswersList.jsp

lams_tool_lamc/web/authoring/itemlist.jsp

lams_tool_scratchie/web/pages/authoring/basic.jsp

lams_tool_scratchie/web/pages/authoring/parts/itemlist.jsp

Options
    • -1
    • +2
    ./create_lams_11_tables.sql
    • -1
    • +4
    ./insert_lams_config_data.sql
    • -2
    • +2
    ./insert_types_data.sql
  4. … 27 more files in changeset.
Tuesday 24 Nov 2020
8:49 am

Ernie Ghiglione

LDEV-5122 Updating LAMS version and language pack date

Options
    • -1
    • +1
    ./insert_lams_config_data.sql
Thursday 19 Nov 2020
9:51 pm

Marcin Cieslak

LDEV-5122 Modify DB structure to produce 3.1 version

Till now DB structure was compliant with 3.0 version and patches

upgraded it to 3.1. Now we produce DB compliant with 3.1 and patches in

branch 4.0 upgrade it to version 4.0.

Options
    • -2160
    • +1710
    ./create_lams_11_tables.sql
    • -1
    • +1
    ./insert_lams_config_data.sql
    • -3
    • +3
    ./insert_types_data.sql
  4. … 38 more files in changeset.
Thursday 20 Aug 2020
8:46 am

Marcin Cieslak

Merge remote-tracking branch 'origin/v4.0' into v5.0

Conflicts:

lams_central/conf/language/lams/ApplicationResources_en_AU.properties

lams_central/src/java/org/lamsfoundation/lams/authoring/template/web/LdTemplateController.java

lams_central/src/java/org/lamsfoundation/lams/authoring/template/web/TBLTemplateController.java

lams_central/src/java/org/lamsfoundation/lams/web/QuestionsController.java

lams_central/web/questions/questionFile.jsp

lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190722.sql

lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20190724.sql

lams_tool_assessment/conf/language/lams/ApplicationResources_en_AU.properties

lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/web/controller/MonitoringController.java

lams_tool_assessment/web/pages/monitoring/summary.jsp

lams_tool_lamc/conf/language/lams/ApplicationResources.properties

lams_tool_lamc/conf/language/lams/ApplicationResources_el_GR.properties

lams_tool_lamc/conf/language/lams/ApplicationResources_en_AU.properties

lams_tool_lamc/conf/language/lams/ApplicationResources_es_ES.properties

lams_tool_lamc/conf/language/lams/ApplicationResources_fr_FR.properties

lams_tool_lamc/conf/language/lams/ApplicationResources_no_NO.properties

lams_tool_lamc/db/sql/activity_insert.sql

lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/mcApplicationContext.xml

lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/service/McService.java

lams_tool_lamc/web/WEB-INF/tags/Etherpad.tag

lams_tool_lamc/web/WEB-INF/tags/OutcomeAuthor.tag

lams_tool_lamc/web/WEB-INF/tags/Rating.tag

lams_tool_lamc/web/WEB-INF/tags/StyledRating.tag

lams_tool_lamc/web/authoring/BasicContent.jsp

lams_tool_lamc/web/authoring/editQuestionBox.jsp

lams_tool_lamc/web/authoring/itemlist.jsp

Options
    • -1
    • +1
    ./create_lams_11_tables.sql
  2. … 25 more files in changeset.
Monday 10 Aug 2020
6:49 am

Marcin Cieslak

LDEV-5058 Allow tool adding both on fresh build and afterwards

As a column got removed from a LAMS core table, we need to make sure

that all scenarios work well: an upgrade from previous version, a fresh

build and adding extra tools afterwards.

Options
    • -1
    • +1
    ./create_lams_11_tables.sql
  2. … 41 more files in changeset.
Friday 21 Feb 2020
5:32 pm

Andrey Balan

LDEV-4979 Update SQL scripts for LAMS 4.0 release

1. Update SQL scripts (create_lams_tool_*.sql), to avoid running 3.1 to

4.0 autopatch scripts on every build.

2. Update module version to 20200219 in build.properties.

3. Squash patches that upgrade from 3.1 to 4.0 into a single one.

Options
    • -25
    • +220
    ./create_lams_11_tables.sql
    • -1
    • +15
    ./insert_lams_config_data.sql
    • -4
    • +16
    ./insert_types_data.sql
  4. … 56 more files in changeset.
Thursday 04 Apr 2019
4:46 pm

Marcin Cieslak

LDEV-4440 Do not put Quartz jobs via DB script

The jobs will be initialised via commonContext.xml

Options
    • -24
    • +0
    ./create_quartz_table.sql
Saturday 05 Jan 2019
2:16 am

Ernie Ghiglione <ernieg@gmail.com>

LDEV-4743 update SQL core tables

Updating all core tables for 3.1 release.

Options
    • -1531
    • +2445
    ./create_lams_11_tables.sql
    • -173
    • +252
    ./create_quartz_table.sql
    • -299
    • +9
    ./insert_lams_config_data.sql
    • -235
    • +38
    ./insert_lams_users.sql
    • -321
    • +235
    ./insert_types_data.sql
Friday 31 Aug 2018
12:03 am

Joanna Mielczarek <amielczarek.web@gmail.com>

LDEV-4440 updated sql - monitoring rows

Options
    • -66
    • +0
    ./patch20180827.sql
  2. … 1 more file in changeset.
Monday 27 Aug 2018
11:53 pm

Joanna Mielczarek <amielczarek.web@gmail.com>

LDEV-4440 Monitoring migration - necessary changes at central (changed paths for monitoring), removed controllers connected with branching

Options
    • -0
    • +66
    ./patch20180827.sql
  2. … 15 more files in changeset.
Monday 07 Aug 2017
9:21 am

Marcin Cieslak

LDEV-4402 Upgrade Quartz

From version 2.2.1 to 2.2.3

Options
    • -1
    • +1
    ./create_quartz_table.sql
  2. … 5 more files in changeset.
Monday 10 Apr 2017
8:14 am

erniegx <ernieg@gmail.com>

LDEV-4311: increasing default file upload sizes to 10MB for students and 100MB for teahers. Only for new installations, existing ones will maintain their currents

Options
    • -3
    • +3
    ./insert_lams_config_data.sql
Sunday 26 Mar 2017
11:50 am

erniegx <ernieg@gmail.com>

LDEV-4180: change table and fields name from TEXT to text as in unix these aren't the same

Options
    • -6
    • +6
    ./create_lams_11_tables.sql
Thursday 02 Mar 2017
8:54 am

Marcin Cieslak

LDEV-4251: Do not create roles for an user which was excluded from the initial DB build script.

Options
    • -8
    • +12
    ./insert_lams_users.sql
6:54 am

Marcin Cieslak

LDEV-4180: Add missing tables.

Options
    • -0
    • +31
    ./create_lams_11_tables.sql
6:53 am

Marcin Cieslak

LDEV-4251: Do not create roles for an user which was excluded from the initial DB build script.

Options
    • -18
    • +0
    ./insert_lams_users.sql
Wednesday 01 Mar 2017
1:10 pm

Marcin Cieslak

LDEV-4180, LDEV-4217: Apply date-based naming convention to SQL patches.

Options
    • -1
    • +1
    ./insert_types_data.sql
  2. … 4 more files in changeset.
1:00 pm

Marcin Cieslak

LDEV-4180: Merge Windows and Unix configuration SQL script into one file.

Options
    • -0
    • +302
    ./insert_lams_config_data.sql
    • -302
    • +0
    ./insert_lams_unix_config_data.sql
    • -302
    • +0
    ./insert_lams_windows_config_data.sql
  4. … 2 more files in changeset.
Tuesday 28 Feb 2017
9:54 am

Andrey Balan

LDEV-3147 Get rid of 'supports_run_offline_flag' and 'define_later_url' columns from lams_tool table

Options
    • -2
    • +0
    ./create_lams_11_tables.sql
  2. … 31 more files in changeset.
6:52 am

Marcin Cieslak

LDEV-4180: Remove help_text from lams_learning_activity as it is taken from i18n files anyway.

Options
    • -1
    • +1
    ./create_lams_11_tables.sql
  2. … 9 more files in changeset.
6:19 am

Marcin Cieslak

LDEV-3254, LDEV-4180: Fix a typo in a configuration key.

Options
    • -1
    • +1
    ./insert_lams_unix_config_data.sql
    • -1
    • +1
    ./insert_lams_windows_config_data.sql
  3. … 2 more files in changeset.