lams-github / lams_tool_lamc / db

sql

Clone Tools

Stats

Commits this week: 0
Total Committers: 13
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 21 Sep 2022
1:56 pm

Marcin Cieslak

LDEV-5328 Squash DB patches and update versions

Options
    • -103
    • +92
    ./create_lams_tool_mc.sql
    • -0
    • +2
    ./tool_insert.sql
  3. … 153 more files in changeset.
Friday 29 Oct 2021
10:01 pm

Marcin Cieslak

LDEV-5250 Do not set obsolete PedPlanner URL when adding a tool

It causes problems when a tool is deployed after server starts for the

first time and PedPlanner tables are already gone via Autopatch.

Options
    • -2
    • +0
    ./tool_insert.sql
  2. … 18 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
    • -2
    • +0
    ./activity_insert.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
    • -31
    • +22
    ./create_lams_tool_mc.sql
    • -0
    • +2
    ./tool_insert.sql
  3. … 57 more files in changeset.
Tuesday 18 Feb 2020
10:21 pm

Andrey Balan

LDEV-4951 Remove traces of MCQ tool from other modules

Options
    • -28
    • +0
    ./activity_insert.sql
    • -124
    • +0
    ./create_lams_tool_mc.sql
    • -2
    • +0
    ./db_version_insert.sql
    • -14
    • +0
    ./library_insert.sql
    • -43
    • +0
    ./tool_insert.sql
  6. … 188 more files in changeset.
Tuesday 08 Jan 2019
6:59 am

Fiona Malikoff <Fiona.Malikoff@gmail.com>

LDEV-4743 Squash/Update SQL scripts ready for LAMS 3.1 release

Options
    • -5
    • +9
    ./create_lams_tool_mc.sql
    • -6
    • +6
    ./tool_insert.sql
  3. … 128 more files in changeset.
Wednesday 08 Mar 2017
7:02 pm

Marcin Cieslak

LDEV-4180: Allow NULL value for a column which has mistakenly marked as NOT NULL.

Options
    • -1
    • +1
    ./create_lams_tool_mc.sql
Thursday 02 Mar 2017
9:40 pm

Marcin Cieslak

LDEV-4253: Use a correct default content ID, broken by a commit for LDEV-4180.

Options
    • -1
    • +1
    ./create_lams_tool_mc.sql
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
    • -4
    • +0
    ./tool_insert.sql
  2. … 31 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
    • -2
    • +0
    ./activity_insert.sql
  2. … 28 more files in changeset.
12:40 pm

Marcin Cieslak

LDEV-4180: Remove patches for dropping DB tables as we never use them.

Options
    • -8
    • +0
    ./drop_lams_tool_mc.sql
  2. … 35 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
    • -49
    • +3
    ./activity_insert.sql
    • -56
    • +49
    ./create_lams_tool_mc.sql
    • -11
    • +1
    ./drop_lams_tool_mc.sql
    • -3
    • +1
    ./library_insert.sql
    • -30
    • +0
    ./table-schema.sql
    • -7
    • +1
    ./tool_insert.sql
  7. … 218 more files in changeset.
Wednesday 11 May 2016
3:54 pm

Marcin Cieslak

LDEV-3776: Remove $Id CVS keyword.

Options
    • -1
    • +1
    ./activity_insert.sql
    • -1
    • +1
    ./db_version_insert.sql
    • -1
    • +1
    ./drop_lams_tool_mc.sql
    • -1
    • +1
    ./library_insert.sql
    • -1
    • +1
    ./tool_insert.sql
  6. … 1025 more files in changeset.
3:38 pm

Marcin Cieslak

LDEV-3776: Remove $Id CVS keyword.

Options
    • -1
    • +1
    ./activity_insert.sql
    • -1
    • +1
    ./db_version_insert.sql
    • -1
    • +1
    ./drop_lams_tool_mc.sql
    • -1
    • +1
    ./library_insert.sql
    • -1
    • +1
    ./tool_insert.sql
  6. … 1275 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
    • -1
    • +1
    ./activity_insert.sql
  2. … 420 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
    • -4
    • +0
    ./tool_insert.sql
  2. … 371 more files in changeset.
Monday 05 May 2014
7:15 pm

Marcin Cieslak

LDEV-3225: Remove unused colums for tool contribution and moderation.

Options
    • -4
    • +0
    ./tool_insert.sql
  2. … 42 more files in changeset.
Wednesday 16 Apr 2014
4:39 pm

Marcin Cieslak

LDEV-3207: Remove unnecessary gate columns in each tool's initial insertion SQL.

Options
    • -4
    • +0
    ./activity_insert.sql
  2. … 27 more files in changeset.
Monday 01 Apr 2013
7:40 pm

Andrey Balan

LDEV-2899 There is no need for /db/sql/updatescripts/** sql updates anymore as we use autopatch ever since. So we can remove according folders

Options
    • -6
    • +0
    ./updatescripts/updateTo20070214.sql
    • -25
    • +0
    ./updatescripts/updateTo20070820.sql
  3. … 48 more files in changeset.
Tuesday 31 Jul 2012
2:55 am

Marcin Cieslak

LDEV-2847: Major changes to build.xml files. See JIRA comment for full explanation.

Options
    • -0
    • +30
    ./table-schema.sql
  2. … 1313 more files in changeset.
Monday 20 Feb 2012
4:26 am

erniegx <ernieg@gmail.com>

LDEV-2807: Support for MySQL 5.5

Options
    • -7
    • +7
    ./create_lams_tool_mc.sql
  2. … 52 more files in changeset.
Monday 16 May 2011
1:11 pm

erniegx <ernieg@gmail.com>

LDEV-2657 Date restrictions for MCQ (merge to HEAD)

Options
    • -0
    • +1
    ./create_lams_tool_mc.sql
  2. … 17 more files in changeset.
Thursday 26 Mar 2009
6:00 pm

jliew

merging improvements from lams2_3_spring_jboss_tune branch

Options
    • -4
    • +0
    ./tool_insert.sql
  2. … 118 more files in changeset.
Tuesday 09 Dec 2008
1:40 pm

Marcin Cieslak

LDEV-1998: Committing Pedagogical Planner base files and support for chat, forum, multiple choice, Q&A, noticeboard, notebook and vote tools.

Options
    • -0
    • +2
    ./tool_insert.sql
  2. … 111 more files in changeset.
Tuesday 23 Sep 2008
12:21 pm

jliew

LDEV-1916 adding autopatch to tools, including db_version_insert.sql script to tool deployer

Options
    • -0
    • +2
    ./db_version_insert.sql
  2. … 71 more files in changeset.
Friday 06 Jun 2008
11:59 am

lfoxton

Changing sql update scripts for vote, mc and forum so they have no multi-line commands, as the tooldeployer task in the updater seems to have difficulty with this. All commands changed to one-liners

Options
    • -15
    • +6
    ./updatescripts/updateTo20070820.sql
  2. … 2 more files in changeset.
Tuesday 18 Mar 2008
12:21 pm

fmalikoff

LDEV-1579: Tools now indicate whether or not they support tool outputs, which allows the authoring client to only list tools that should have conditions.

Options
    • -2
    • +4
    ./tool_insert.sql
    • -0
    • +2
    ./updatescripts/updateTo20070820.sql
  3. … 11 more files in changeset.
Wednesday 13 Feb 2008
2:13 pm

erniegx <ernieg@gmail.com>

Getting rid of the Candidate Answer label. Just leaving Answer instead

Options
    • -2
    • +2
    ./create_lams_tool_mc.sql
Thursday 11 Oct 2007
2:27 pm

erniegx <ernieg@gmail.com>

LDEV-1156: Adds Advance setting to display answers/results at the end of an MCQ (Authoring changes)

Options
    • -0
    • +1
    ./create_lams_tool_mc.sql
    • -0
    • +3
    ./updatescripts/updateTo20070820.sql
  3. … 9 more files in changeset.
Friday 24 Aug 2007
1:39 pm

fmalikoff

Fixed typo in script - missing ;

Options
    • -1
    • +1
    ./updatescripts/updateTo20070820.sql