Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040006.sql
===================================================================
diff -u -rd5a281b774f24a41894aac08200627f18e2b25e2 -rc1fca2519602334017fb46e34f8849184a7c541a
--- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040006.sql	(.../patch02040006.sql)	(revision d5a281b774f24a41894aac08200627f18e2b25e2)
+++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040006.sql	(.../patch02040006.sql)	(revision c1fca2519602334017fb46e34f8849184a7c541a)
@@ -136,6 +136,18 @@
   CONSTRAINT lams_ext_server_lesson_map_fk2 FOREIGN KEY (lesson_id) REFERENCES lams_lesson (lesson_id) ON DELETE CASCADE ON UPDATE CASCADE
 ) TYPE=InnoDB;
 
+-- LDEV-2642 and LDEV-2646 Move metadata to separate table. Use LD ID rather than ZIPed file for template.
+CREATE TABLE lams_planner_activity_metadata (
+       activity_id BIGINT(20) NOT NULL
+	 , collapsed TINYINT(1) DEFAULT 0
+	 , expanded TINYINT(1) DEFAULT 0
+	 , hidden TINYINT(1) DEFAULT 0
+	 , editing_advice VARCHAR(255)
+     , CONSTRAINT FK_lams_planner_metadata_primary FOREIGN KEY (activity_id)
+                  REFERENCES lams_learning_activity (activity_id) ON DELETE CASCADE ON UPDATE CASCADE
+)TYPE=InnoDB;
 
+ALTER TABLE lams_planner_nodes DROP COLUMN file_uuid, DROP COLUMN file_name, ADD COLUMN ld_id BIGINT(20), ADD COLUMN teachers_permissions TINYINT UNSIGNED;
+
 COMMIT;
 SET AUTOCOMMIT = 1;
\ No newline at end of file