lams-github / lams_tool_scribe / db

sql

Clone Tools

Stats

Commits this week: 0
Total Committers: 11
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
Friday 29 Oct 2021
4: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
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
    • -2
    • +0
    ./activity_insert.sql
  2. … 41 more files in changeset.
Monday 07 Jan 2019
9:11 pm

Andrey Balan

LDEV-4743 Update SQL script with autopatch changes for LAMS 3.1 release

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

Marcin Cieslak

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

Options
    • -7
    • +0
    ./drop_lams_tool_scribe.sql
  2. … 35 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
    • -49
    • +3
    ./activity_insert.sql
    • -29
    • +79
    ./create_lams_tool_scribe.sql
    • -9
    • +3
    ./drop_lams_tool_scribe.sql
    • -3
    • +1
    ./library_insert.sql
    • -1
    • +0
    ./make_activity_invalid.sql
    • -26
    • +0
    ./table-schema.sql
    • -7
    • +1
    ./tool_insert.sql
  8. … 217 more files in changeset.
Wednesday 11 May 2016
10:10 am

Marcin Cieslak

LDEV-3776: Remove $Id CVS keyword.

Options
    • -1
    • +1
    ./activity_insert.sql
    • -1
    • +1
    ./create_lams_tool_scribe.sql
    • -1
    • +1
    ./db_version_insert.sql
    • -1
    • +1
    ./drop_lams_tool_scribe.sql
    • -1
    • +1
    ./library_insert.sql
    • -1
    • +1
    ./tool_insert.sql
  7. … 999 more files in changeset.
9:38 am

Marcin Cieslak

LDEV-3776: Remove $Id CVS keyword.

Options
    • -1
    • +1
    ./activity_insert.sql
    • -1
    • +1
    ./create_lams_tool_scribe.sql
    • -1
    • +1
    ./db_version_insert.sql
    • -1
    • +1
    ./drop_lams_tool_scribe.sql
    • -1
    • +1
    ./library_insert.sql
    • -1
    • +1
    ./tool_insert.sql
  7. … 1274 more files in changeset.
Wednesday 16 Mar 2016
1: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
1: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
1: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
10:39 am

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
1: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
    • -4
    • +0
    ./updatescripts/updateTo20070227.sql
    • -4
    • +0
    ./updatescripts/updateTo20070315.sql
    • -5
    • +0
    ./updatescripts/updateTo20071113.sql
    • -4
    • +0
    ./updatescripts/updateTo20080229.sql
  5. … 46 more files in changeset.
Monday 30 Jul 2012
8:55 pm

Marcin Cieslak

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

Options
    • -7
    • +7
    ./table-schema.sql
  2. … 1313 more files in changeset.
Sunday 19 Feb 2012
9:26 pm

erniegx <ernieg@gmail.com>

LDEV-2807: Support for MySQL 5.5

Options
    • -6
    • +6
    ./create_lams_tool_scribe.sql
  2. … 52 more files in changeset.
Thursday 26 Mar 2009
11:00 am

jliew

merging improvements from lams2_3_spring_jboss_tune branch

Options
    • -4
    • +0
    ./tool_insert.sql
  2. … 118 more files in changeset.
Thursday 26 Feb 2009
8:20 pm

Marcin Cieslak

LDEV-1998: Added Scribe tool and Parallel Activities support. Adjusted design for IE.

Options
    • -0
    • +2
    ./tool_insert.sql
  2. … 17 more files in changeset.
Tuesday 23 Sep 2008
6:21 am

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.
Wednesday 11 Jun 2008
9:38 am

lfoxton

LDEV-1511

This has been changed again to prevent the tool deployer code failing during the update

Now all innodb alterations and adding contraints required for LDEV-1511 are done in this one script, in lams common alter_21_engine.sql which is allowed to fail.

Options
    • -14
    • +2
    ./updatescripts/updateTo20080229.sql
  2. … 4 more files in changeset.
Wednesday 14 May 2008
3:08 am

jliew

LDEV-1511 use original constraint names for consistency, and so that we don't get multiple constraints on the same keys if the tables happen to already be innodb and have their constraints (i.e. script failure is ok in this case)

Options
    • -7
    • +7
    ./updatescripts/updateTo20080229.sql
  2. … 3 more files in changeset.
2:09 am

jliew

LDEV-1511 add foreign key constraints to innodb tables

Options
    • -0
    • +7
    ./updatescripts/updateTo20080229.sql
  2. … 4 more files in changeset.
Friday 29 Feb 2008
4:46 am

jliew

LDEV-1511 make tables created as MyISAM into InnoDB by modifying create table statements and creating update scripts.

Options
    • -6
    • +6
    ./create_lams_tool_scribe.sql
    • -0
    • +9
    ./updatescripts/updateTo20080229.sql
  3. … 10 more files in changeset.
Friday 16 Nov 2007
8:54 am

fmalikoff

LDEV-1318: The reports for other groups may now be displayed using the show Aggregated Reports option in authoring.

Options
    • -3
    • +5
    ./create_lams_tool_scribe.sql
    • -0
    • +5
    ./updatescripts/updateTo20071113.sql
  3. … 18 more files in changeset.
Thursday 22 Mar 2007
9:58 pm

fmalikoff

Need to trigger an upgrade to scribe so that the valid_flag will be reset by the installer. Covers problems with a 2.0.1 -> 2.0.2 install.

Options
    • -0
    • +4
    ./updatescripts/updateTo20070315.sql
6:21 am

fmalikoff

Removing './' from jar name - added by the tool deployer

Options
    • -1
    • +1
    ./tool_insert.sql
  2. … 10 more files in changeset.
Thursday 08 Mar 2007
12:22 am

lfoxton

Change update scripts to have one lne commands instead of multi-line commands for the purposes of ant

Options
    • -5
    • +1
    ./updatescripts/updateTo20070227.sql
  2. … 10 more files in changeset.
12:08 am

fmalikoff

No need to have the ../ on the jar file name as it is added automatically by the tool deployer.

Options
    • -1
    • +1
    ./updatescripts/updateTo20070227.sql
  2. … 9 more files in changeset.
Tuesday 27 Feb 2007
3:32 am

fmalikoff

Added context application and classpath columns

Options
    • -1
    • +7
    ./tool_insert.sql
    • -0
    • +8
    ./updatescripts/updateTo20070227.sql
  3. … 25 more files in changeset.
Tuesday 13 Feb 2007
2:19 am

lfoxton

Changes to build, so the tool deployer can put the tool_version in the deploy.xml when the tool is build.

Now, the tool_version in tool_insert.sql must be replaced by @tool_version@, and the actual tool version goes in the buld.properties under tool.version

Options
    • -1
    • +1
    ./tool_insert.sql
  2. … 15 more files in changeset.