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
Wednesday 10 May 2023
3:57 am

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
1:56 pm

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
11: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
2:00 pm

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
11: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
5:05 pm

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
3:49 pm

Ernie Ghiglione

LDEV-5122 Updating LAMS version and language pack date

Options
    • -1
    • +1
    ./insert_lams_config_data.sql
Friday 20 Nov 2020
4:51 am

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
2:46 pm

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

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.
Saturday 22 Feb 2020
12:32 am

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
10: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
9: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
6: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.
Tuesday 28 Aug 2018
5:53 am

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
3:21 pm

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
2:14 pm

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
5:50 pm

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
3:54 pm

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

Marcin Cieslak

LDEV-4180: Add missing tables.

Options
    • -0
    • +31
    ./create_lams_11_tables.sql
1:53 pm

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

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

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

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

Marcin Cieslak

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

Options
    • -1
    • +0
    ./create_lams_11_tables.sql
  2. … 28 more files in changeset.
Monday 27 Feb 2017
10:00 pm

Marcin Cieslak

LDEV-4180: Make DB patches produce up-to-date structure during build instead of applying multiple patches. Get rid of unnecessary tables and keys. Modify boolean columns to tinyint(1) Simplify patches where possible.

Options
    • -84
    • +0
    ./create_integration_tables.sql
    • -30
    • +1
    ./create_lams_11_db.sql
    • -377
    • +678
    ./create_lams_11_tables.sql
    • -2
    • +0
    ./create_notebook_tables.sql
    • -11
    • +0
    ./create_presence_chat_tables.sql
    • -75
    • +0
    ./drop_lams_11_tables.sql
    • -38
    • +58
    ./insert_lams_unix_config_data.sql
    • -120
    • +80
    ./insert_lams_users.sql
    • -39
    • +60
    ./insert_lams_windows_config_data.sql
    • -55
    • +35
    ./insert_types_data.sql
  11. … 214 more files in changeset.
Wednesday 04 Jan 2017
5:40 am

erniegx <ernieg@gmail.com>

LDEV-4180: Updating release details to version 3.0

Options
    • -6
    • +7
    ./insert_lams_unix_config_data.sql
    • -6
    • +6
    ./insert_lams_windows_config_data.sql
  3. … 1 more file in changeset.
Friday 25 Nov 2016
8:48 am

erniegx <ernieg@gmail.com>

LDEV-3970: updating default users to be on the 'Etc/GMT' timezone

Options
    • -8
    • +8
    ./insert_lams_users.sql