lams-github / lams_tool_survey / db

sql

Clone Tools

Stats

Commits this week: 0
Total Committers: 10
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
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.
Tuesday 08 Jan 2019
4:11 am

Andrey Balan

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

Options
    • -5
    • +5
    ./create_lams_tool_survey.sql
  2. … 139 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
    • -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
    • -9
    • +0
    ./drop_lams_tool_survey.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
    • -100
    • +90
    ./create_lams_tool_survey.sql
    • -10
    • +3
    ./drop_lams_tool_survey.sql
    • -5
    • +1
    ./library_insert.sql
    • -52
    • +0
    ./table-schema.sql
    • -9
    • +1
    ./tool_insert.sql
  7. … 218 more files in changeset.
Wednesday 11 May 2016
4:10 pm

Marcin Cieslak

LDEV-3776: Remove $Id CVS keyword.

Options
    • -1
    • +1
    ./db_version_insert.sql
  2. … 1004 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
    • -6
    • +0
    ./updatescripts/updateTo20070220.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
    • -7
    • +25
    ./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
    • -9
    • +9
    ./create_lams_tool_survey.sql
  2. … 52 more files in changeset.
Tuesday 10 May 2011
7:51 pm

erniegx <ernieg@gmail.com>

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

Options
    • -0
    • +1
    ./create_lams_tool_survey.sql
  2. … 5 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 22 Oct 2008
8:12 am

Marcin Cieslak

LDEV-1946: Added text search based conditions to Survey tool.

Options
    • -0
    • +20
    ./create_lams_tool_survey.sql
    • -0
    • +2
    ./drop_lams_tool_survey.sql
    • -2
    • +4
    ./tool_insert.sql
  4. … 30 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_survey.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
    • -18
    • +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
    • -10
    • +10
    ./updatescripts/updateTo20080229.sql
  2. … 3 more files in changeset.
8:09 am

jliew

LDEV-1511 add foreign key constraints to innodb tables

Options
    • -0
    • +10
    ./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_survey.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
    • -7
    • +2
    ./updatescripts/updateTo20070220.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/updateTo20070220.sql
  2. … 9 more files in changeset.
Tuesday 27 Feb 2007
10:32 am

fmalikoff

Added context application and classpath columns

Options
    • -1
    • +1
    ./tool_insert.sql
  2. … 26 more files in changeset.
8:52 am

fmalikoff

Only one update for each release - the tool deployer won't go back and apply multiple scripts, it will only look for the script with the same date as the tool release.

Options
    • -5
    • +0
    ./updatescripts/updateTo20070208.sql
    • -1
    • +4
    ./updatescripts/updateTo20070220.sql
Thursday 22 Feb 2007
1:00 pm

fmalikoff

LI-57: Upgrader needs to update the web.xml and manifest files for learning and monitoring.

Options
    • -2
    • +8
    ./tool_insert.sql
    • -0
    • +8
    ./updatescripts/updateTo20070220.sql
  3. … 4 more files in changeset.