lams / lams_common / db / sql

drop_lams_11_tables.sql

Tools

Line History

Line Count Graph
Line Count Graph

Stats

Commits this week: 0
Total Committers: 10
Last Commit: 11 May 16
Commits this week: 0
Total Lines of Code (LoC): 72
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
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
    • -75
    • +0
    ./drop_lams_11_tables.sql
  2. … 223 more files in changeset.
Wednesday 11 May 2016
3:28 pm

Marcin Cieslak

LDEV-3776: Remove $Id CVS keyword.

Options
    • -1
    • +1
    ./drop_lams_11_tables.sql
  2. … 1074 more files in changeset.
3:06 pm

Marcin Cieslak

LDEV-3776: Remove $Id CVS keyword.

Options
    • -1
    • +1
    ./drop_lams_11_tables.sql
  2. … 1351 more files in changeset.
Wednesday 16 Dec 2015
4:21 am

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.
Sunday 01 Nov 2015
1:39 am

Marcin Cieslak

LDEV-2903: Delete lams_lesson_learner table.

Options
    • -2
    • +1
    ./drop_lams_11_tables.sql
  2. … 2 more files in changeset.
1:37 am

Marcin Cieslak

LDEV-2903: Delete lams_lesson_learner table.

Options
    • -2
    • +1
    ./drop_lams_11_tables.sql
  2. … 3 more files in changeset.
Saturday 02 Oct 2010
4:30 am

Andrey Balan

LDEV-2544 Default Timezones

*merge from lams2_3_release

Options
    • -1
    • +2
    ./drop_lams_11_tables.sql
  2. … 35 more files in changeset.
Wednesday 31 Mar 2010
7:49 am

Andrey Balan

LDEV-2544 adding Timezone Manager

Options
    • -1
    • +2
    ./drop_lams_11_tables.sql
  2. … 33 more files in changeset.
Monday 01 Mar 2010
12:53 pm

lfoxton

LDEV-2517 Merging head theme changes with 2.3 branch for 2.3.4

Options
    • -4
    • +2
    ./drop_lams_11_tables.sql
  2. … 64 more files in changeset.
Saturday 27 Feb 2010
5:16 am

Andrey Balan

LDEV-2515 Backporting planner to 2.3.x

* making PedagogicalPlannerNodeRole work

Options
    • -1
    • +3
    ./drop_lams_11_tables.sql
  2. … 8 more files in changeset.
Thursday 20 Aug 2009
12:37 pm

lfoxton

LDEV-2420 Removing uneccessary data structures and tables from the db, as well as implementing the same theme settings for flash themes

Options
    • -4
    • +2
    ./drop_lams_11_tables.sql
  2. … 49 more files in changeset.
Saturday 14 Feb 2009
1:45 am

Marcin Cieslak

LDEV-1998: Added Pedagogical Planner editor with add/edit node functionality.

Options
    • -1
    • +2
    ./drop_lams_11_tables.sql
  2. … 46 more files in changeset.
Monday 25 Aug 2008
4:15 pm

Marcin Cieslak

Added event notification service.

Options
    • -1
    • +3
    ./drop_lams_11_tables.sql
  2. … 17 more files in changeset.
Tuesday 21 Mar 2006
12:57 pm

fmalikoff

Added cvs id - preparing for porting to postgreSQL

Options
    • -0
    • +2
    ./drop_lams_11_tables.sql
  2. … 8 more files in changeset.
Tuesday 14 Mar 2006
2:02 pm

mseaton

Add drop instructions for Quartz tables.

Options
    • -0
    • +13
    ./drop_lams_11_tables.sql
Monday 22 Aug 2005
7:47 am

fmalikoff

Added initial Theme support

Options
    • -0
    • +4
    ./drop_lams_11_tables.sql
  2. … 48 more files in changeset.
Thursday 05 May 2005
11:20 am

mminhas

*** empty log message ***

Options
    • -1
    • +2
    ./drop_lams_11_tables.sql
  2. … 10 more files in changeset.
Monday 11 Apr 2005
12:46 pm

jfang

get rid of comments that cause the failure of ant run

Options
    • -20
    • +0
    ./drop_lams_11_tables.sql
Thursday 07 Apr 2005
1:13 pm

cperfect

removed the "use lams" clause: makes testing very difficult

Options
    • -2
    • +0
    ./drop_lams_11_tables.sql
Sunday 27 Mar 2005
10:58 pm

yoichi

table names alphabetically sorted

Options
    • -36
    • +40
    ./drop_lams_11_tables.sql
Friday 18 Mar 2005
12:32 pm

cperfect

added table lams_log_event_type

added table lams_log_event (includes fk to lams_log_event_type)

modified table lams_tool:

added create_date_time

modified insert_types_data.sql:

added values for lasm_log_event_type

Options
    • -0
    • +10
    ./drop_lams_11_tables.sql
  2. … 3 more files in changeset.
Tuesday 15 Mar 2005
10:54 am

cperfect

Added table:

lams_grouping_support_type

Modified table lams_tool:

added supports_contribution_flag

added supports_moderation_flag

added grouping_support_type_id (fk to lams_grouping_support_type)

Modifed table lams_learning_activity:

added online_instructions

added grouping_support_type_id (fk to lams_grouping_support_type)

Modified insert_types_data.sql to include 3 values for lams_grouping_support: NONE, OPTIONAL, REQUIRED

Options
    • -0
    • +5
    ./drop_lams_11_tables.sql
  2. … 3 more files in changeset.
Thursday 10 Mar 2005
11:26 am

cperfect

added table lams_workspace_folder_type (and values for it to insert_types sql)

|

lams_workspace_folder:

added user_id (implicit fk to user table)

added create_date_time

added last_modified_date_time

added lams_workspace_folder_type_id (fk to lasm_workspace_folder_type)

|

lams_learning_library:

added valid flag

|

lams_tool:

added valid_flag

added learning_library_id (fk to lams_learning_library)

|

lams_learning_design:

added last_modified_date_time

|

lams_lesson:

made name mandatory

|

lams_learner_progress

added requires_restart_flag

|

other: added values for workspace type to insert types

|

other moved values for auth method and activity category from insert test data to insert types data

Options
    • -0
    • +5
    ./drop_lams_11_tables.sql
  2. … 3 more files in changeset.
Monday 28 Feb 2005
3:06 pm

fmalikoff

Added content repository tables

Options
    • -0
    • +6
    ./drop_lams_11_tables.sql
7:47 am

cperfect

made from_ui_id and to_ui_id in transition table nullable

Options
    • -0
    • +1
    ./drop_lams_11_tables.sql
  2. … 3 more files in changeset.
Thursday 17 Feb 2005
6:17 am

jfang

get rid of the # comment which make ant call failure

Options
    • -5
    • +1
    ./drop_lams_11_tables.sql
Wednesday 16 Feb 2005
1:02 pm

cperfect

added changes for monitoring to gate activities (gate_open, gate_start_date_time, gate_end_date_time), plus changed lesson_copy_flag to copy_type_id and added lams_copy_type table, added help_text to lams_activity table, added supports_moderation_flag and contribute_url lams_tool table

Options
    • -0
    • +5
    ./drop_lams_11_tables.sql
  2. … 3 more files in changeset.
Tuesday 15 Feb 2005
10:18 am

dgarth

added set foreign_key_checks

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

cperfect

added license table and fields in ld table

Options
    • -0
    • +5
    ./drop_lams_11_tables.sql
  2. … 2 more files in changeset.
Wednesday 09 Feb 2005
12:05 pm

jfang

add IF EXISTS to ensure it is always working

Options
    • -32
    • +32
    ./drop_lams_11_tables.sql