Index: lams_common/db/sql/insert_types_data.sql
===================================================================
diff -u -r5df0d44b0e94fca808f5d4f70fc01c0c428c3dfe -r92ba83d36853a962c09b60a4a14f0320efd8edc6
--- lams_common/db/sql/insert_types_data.sql	(.../insert_types_data.sql)	(revision 5df0d44b0e94fca808f5d4f70fc01c0c428c3dfe)
+++ lams_common/db/sql/insert_types_data.sql	(.../insert_types_data.sql)	(revision 92ba83d36853a962c09b60a4a14f0320efd8edc6)
@@ -318,4 +318,4 @@
 INSERT INTO lams_rating_criteria_type VALUES (4, 'LESSON');
    
 -- initialise db version
-INSERT INTO patches VALUES ('lams', 3000001, NOW(), 'F');
\ No newline at end of file
+INSERT INTO patches VALUES ('lams', 20170101, NOW(), 'F');
\ No newline at end of file
Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20170101.sql
===================================================================
diff -u
--- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20170101.sql	(revision 0)
+++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20170101.sql	(revision 92ba83d36853a962c09b60a4a14f0320efd8edc6)
@@ -0,0 +1,53 @@
+-- Turn off autocommit, so nothing is committed if there is an error
+SET AUTOCOMMIT = 0;
+SET FOREIGN_KEY_CHECKS=0;
+----------------------Put all sql statements below here-------------------------
+
+-- LDEV-4180
+ALTER TABLE lams_user RENAME KEY html_theme_id TO theme_id,
+					  MODIFY COLUMN change_password TINYINT(1);
+
+ALTER TABLE lams_input_activity DROP KEY activity_id_2;
+
+ALTER TABLE lams_notification_event DROP KEY uid;
+ALTER TABLE lams_notification_subscription DROP KEY uid;
+
+ALTER TABLE lams_competence DROP KEY competence_id;
+ALTER TABLE lams_competence_mapping DROP KEY competence_mapping_id;
+
+ALTER TABLE lams_learning_design MODIFY COLUMN valid_design_flag TINYINT(1),
+								 MODIFY COLUMN read_only_flag TINYINT(1),
+								 MODIFY COLUMN edit_override_lock TINYINT(1);
+								 
+ALTER TABLE lams_grouping MODIFY COLUMN equal_number_of_learners_per_group TINYINT(1),
+						  MODIFY COLUMN view_students_before_selection TINYINT(1);
+						  
+ALTER TABLE lams_learning_activity DROP COLUMN define_later_flag,
+								   DROP COLUMN run_offline_flag,
+								   DROP COLUMN help_text,
+								   MODIFY COLUMN readonly TINYINT(1),
+								   MODIFY COLUMN initialised TINYINT(1),
+								   MODIFY COLUMN stop_after_activity TINYINT(1);
+								   
+ALTER TABLE lams_branch_activity_entry MODIFY COLUMN open_gate TINYINT(1);
+
+ALTER TABLE lams_lesson MODIFY COLUMN locked_for_edit TINYINT(1),
+						MODIFY COLUMN marks_released TINYINT(1);
+						
+ALTER TABLE lams_configuration MODIFY COLUMN required TINYINT(1);
+
+ALTER TABLE lams_timezone MODIFY COLUMN server_timezone TINYINT(1);
+
+-- fix a typo
+UPDATE lams_configuration SET config_key = 'ConfigCacheRefreshInterval' WHERE config_key = 'ConfigCacheRefresInterval';
+
+-- LDEV-3147 Get rid of 'supports_run_offline_flag' and 'define_later_url' columns from lams_tool table
+ALTER TABLE lams_tool DROP COLUMN supports_run_offline_flag;
+ALTER TABLE lams_tool DROP COLUMN define_later_url;
+
+----------------------Put all sql statements above here-------------------------
+
+-- If there were no errors, commit and restore autocommit to on
+COMMIT;
+SET AUTOCOMMIT = 1;
+SET FOREIGN_KEY_CHECKS=1;
Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20170209.sql
===================================================================
diff -u
--- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20170209.sql	(revision 0)
+++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20170209.sql	(revision 92ba83d36853a962c09b60a4a14f0320efd8edc6)
@@ -0,0 +1,16 @@
+-- Turn off autocommit, so nothing is committed if there is an error
+SET AUTOCOMMIT = 0;
+SET FOREIGN_KEY_CHECKS=0;
+----------------------Put all sql statements below here-------------------------
+
+-- LDEV-4217 Remove LAMS Community integration
+DROP TABLE IF EXISTS `lams_registration`;
+ALTER TABLE `lams_user` DROP COLUMN `lams_community_username`, DROP COLUMN `lams_community_token`;
+DELETE FROM `lams_configuration` WHERE `config_key`='LAMS_Community_enable';
+
+----------------------Put all sql statements above here-------------------------
+
+-- If there were no errors, commit and restore autocommit to on
+COMMIT;
+SET AUTOCOMMIT = 1;
+SET FOREIGN_KEY_CHECKS=1;
Fisheye: Tag 92ba83d36853a962c09b60a4a14f0320efd8edc6 refers to a dead (removed) revision in file `lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch3000001.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 92ba83d36853a962c09b60a4a14f0320efd8edc6 refers to a dead (removed) revision in file `lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch3000002.sql'.
Fisheye: No comparison available.  Pass `N' to diff?