lams / lams_common / db

sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 19
Last Commit:
Commits this week: 0
Total Lines of Code (LoC): 2,833
Net change in LoC this week: 0

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

Marcin Cieslak

file insert_lams_config_data.sql was initially added on branch lams2_head_wildfly.

Options
    • -0
    • +0
    ./insert_lams_config_data.sql
Tuesday 28 Feb 2017
9:53 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.
6:15 am

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
3: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
    • -117
    • +77
    ./insert_lams_users.sql
    • -39
    • +60
    ./insert_lams_windows_config_data.sql
    • -53
    • +33
    ./insert_types_data.sql
  11. … 214 more files in changeset.
Tuesday 03 Jan 2017
10:37 pm

Ernie Ghiglione

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
1:48 am

Ernie Ghiglione

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

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

Ernie Ghiglione

LDEV-3970: Oops missed GMT+1

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

Ernie Ghiglione

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
10:50 am

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
10:49 am

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
10:48 am

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
9:28 am

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.
9:06 am

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. … 1348 more files in changeset.
Wednesday 16 Mar 2016
1:12 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
1:35 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
    • -45
    • +28
    ./insert_types_data.sql
  2. … 371 more files in changeset.
Tuesday 15 Dec 2015
9:21 pm

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
    • -1
    • +4
    ./drop_lams_11_tables.sql
  2. … 24 more files in changeset.
Saturday 31 Oct 2015
6:39 pm

Marcin Cieslak

LDEV-2903: Delete lams_lesson_learner table.

Options
    • -11
    • +0
    ./create_lams_11_tables.sql
    • -2
    • +1
    ./drop_lams_11_tables.sql
  3. … 1 more file in changeset.
6:37 pm

Marcin Cieslak

LDEV-2903: Delete lams_lesson_learner table.

Options
    • -11
    • +0
    ./create_lams_11_tables.sql
    • -2
    • +1
    ./drop_lams_11_tables.sql
  3. … 2 more files in changeset.
Monday 29 Jun 2015
12:39 pm

Marcin Cieslak

LDEV-3337: Update Quartz DB schema for new builds.

Options
    • -158
    • +160
    ./create_quartz_table.sql
Monday 04 May 2015
11:19 am

Marcin Cieslak

LDEV-3471: Set session timeout to 30 minuts.

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

Marcin Cieslak

LDEV-3471: Set session timeout to 30 minuts.

Options
    • -1
    • +1
    ./insert_lams_unix_config_data.sql
    • -1
    • +1
    ./insert_lams_windows_config_data.sql
  3. … 2 more files in changeset.
Sunday 12 Oct 2014
8:01 pm

marek

LDEV-3319: update create_lams_11_tables.sql to create 'patches' table with compound primary key.

Options
    • -1
    • +1
    ./create_lams_11_tables.sql
Saturday 19 Apr 2014
12:39 am

Andrey Balan

LDEV-3219 Update database only using autopatch

Options
    • -9
    • +0
    ./insert_lams_unix_config_data.sql
    • -9
    • +0
    ./insert_lams_windows_config_data.sql