lams-github / lams_tool_larsrc / db

sql

Clone Tools

Stats

Commits this week: 0
Total Committers: 12
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
Tuesday 28 Feb 2017
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_rsrc.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
    • -51
    • +3
    ./activity_insert.sql
    • -87
    • +87
    ./create_lams_tool_rsrc.sql
    • -7
    • +1
    ./drop_lams_tool_rsrc.sql
    • -5
    • +1
    ./library_insert.sql
    • -36
    • +0
    ./table-schema.sql
    • -9
    • +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
    ./db_version_insert.sql
  2. … 1029 more files in changeset.
3:38 pm

Marcin Cieslak

LDEV-3776: Remove $Id CVS keyword.

Options
    • -1
    • +1
    ./db_version_insert.sql
  2. … 1279 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
    • -4
    • +0
    ./updatescripts/updateTo20070227.sql
    • -2
    • +0
    ./updatescripts/updateTo20080229.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
    • -8
    • +8
    ./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_rsrc.sql
  2. … 52 more files in changeset.
Wednesday 10 Aug 2011
7:41 pm

Andrey Balan

LDEV-2705 Improve reporting for Share Resources

Options
    • -0
    • +1
    ./create_lams_tool_rsrc.sql
    • -1
    • +1
    ./table-schema.sql
  3. … 7 more files in changeset.
Tuesday 18 Aug 2009
12:29 pm

lfoxton

LDEV-2421 Ability for teacher to sort resource items - author part done

Options
    • -2
    • +3
    ./create_lams_tool_rsrc.sql
  2. … 11 more files in changeset.
Tuesday 07 Jul 2009
8:52 am

jliew

change to ascii

Options
    • -82
    • +82
    ./activity_insert.sql
    • -124
    • +124
    ./create_lams_tool_rsrc.sql
    • -14
    • +14
    ./drop_lams_tool_rsrc.sql
    • -18
    • +18
    ./library_insert.sql
    • -62
    • +62
    ./tool_insert.sql
  6. … 45 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.
Wednesday 21 Jan 2009
12:18 am

Marcin Cieslak

LDEV-1998: Added support for Share Resources tool.

Options
    • -0
    • +2
    ./tool_insert.sql
  2. … 10 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.
Wednesday 03 Sep 2008
10:11 am

Marcin Cieslak

LDEV-1891: Add an advanced option: monitoring teachers get notified when a student submits an assignment/resource/survey answer.

Removed duplicate key names in the database models.

Options
    • -1
    • +2
    ./create_lams_tool_rsrc.sql
    • -1
    • +1
    ./table-schema.sql
  3. … 44 more files in changeset.
Wednesday 11 Jun 2008
3:38 pm

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
    • -21
    • +0
    ./updatescripts/updateTo20080229.sql
  2. … 4 more files in changeset.
Wednesday 14 May 2008
9: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
    • -11
    • +13
    ./updatescripts/updateTo20080229.sql
  2. … 3 more files in changeset.
8:09 am

jliew

LDEV-1511 add foreign key constraints to innodb tables

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

jliew

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

Options
    • -7
    • +7
    ./create_lams_tool_rsrc.sql
    • -0
    • +10
    ./updatescripts/updateTo20080229.sql
  3. … 10 more files in changeset.
Thursday 22 Mar 2007
1:21 pm

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
7: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.
7: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
10: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
9: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.
Friday 03 Nov 2006
8:11 am

fmalikoff

Version number update for RC2

Options
    • -1
    • +1
    ./tool_insert.sql
  2. … 9 more files in changeset.
Thursday 02 Nov 2006
10:32 am

steven

change default content.

Options
    • -2
    • +2
    ./create_lams_tool_rsrc.sql
  2. … 3 more files in changeset.