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
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
7:32 am

erniegx <ernieg@gmail.com>

LDEV-3970: Oops missed GMT+1

Options
    • -0
    • +1
    ./insert_types_data.sql
7:25 am

erniegx <ernieg@gmail.com>

LDEV-3970: set default timezones to be 'Etc/GMT*' The default timezone should be all GMT offset hourly timezone as minimum.

Options
    • -22
    • +15
    ./insert_types_data.sql
Thursday 30 Jun 2016
4:50 pm

Andrey Balan

LDEV-3549 Since only group managers and group admins can access Course gradebook, assigning the following users these roles by default: test4 - group manager, mmm - group admin in MATH111

Options
    • -0
    • +1
    ./insert_lams_users.sql
4:49 pm

Andrey Balan

LDEV-3549 Since only group managers and group admins can access Course gradebook, assigning the following users these roles by default: test4 - group manager, mmm - group admin in MATH111

Options
    • -35
    • +37
    ./insert_lams_users.sql
4:48 pm

Andrey Balan

LDEV-3549 Since only group managers and group admins can access Course gradebook, assigning the following users these roles by default: test4 - group manager, mmm - group admin in MATH111

Options
    • -35
    • +38
    ./insert_lams_users.sql
Wednesday 11 May 2016
3:30 pm

Marcin Cieslak

LDEV-3776: Remove $Id CVS keyword.

Options
    • -1
    • +1
    ./create_lams_11_db.sql
    • -1
    • +1
    ./create_quartz_table.sql
    • -1
    • +1
    ./drop_lams_11_tables.sql
    • -1
    • +1
    ./insert_lams_users.sql
    • -1
    • +1
    ./insert_types_data.sql
  6. … 1070 more files in changeset.
3:08 pm

Marcin Cieslak

LDEV-3776: Remove $Id CVS keyword.

Options
    • -1
    • +1
    ./create_lams_11_db.sql
    • -1
    • +1
    ./drop_lams_11_tables.sql
    • -1
    • +1
    ./insert_lams_users.sql
    • -1
    • +1
    ./insert_types_data.sql
  5. … 779 more files in changeset.
Wednesday 16 Mar 2016
8:14 pm

Marcin Cieslak

LDEV-3674: Remove multiple Flash elements: Authoring, icons, themes, i18n files, WDDX libraries and classes, methods, servlets etc. Rename/rewrite methods for Flashless use.

Options
    • -13
    • +1
    ./insert_lams_unix_config_data.sql
    • -12
    • +0
    ./insert_lams_windows_config_data.sql
  3. … 419 more files in changeset.
Wednesday 24 Feb 2016
8:36 pm

Marcin Cieslak

LDEV-3660: Remove export potfolio resources: Java classes, JPS, DB entries and labels. Remove localLinkPath attribute from CSS tag as it was only used for export portfolio.

Options
    • -44
    • +27
    ./insert_types_data.sql
  2. … 371 more files in changeset.
Wednesday 16 Dec 2015
4:21 am

Marcin Cieslak

LDEV-3633: Allow specyfing port which MySQL runs on. Disable SSL for building LAMS as it generates a warning message. New MySQL does not accept ALTER IGNORE TABLE statements.

Options
    • -0
    • +3
    ./drop_lams_11_tables.sql
  2. … 24 more files in changeset.