Index: branches/unlabeled/unlabeled-1.74.2/admin/install/inportal_data.sql
===================================================================
diff -u -r7775 -r7811
--- branches/unlabeled/unlabeled-1.74.2/admin/install/inportal_data.sql	(.../inportal_data.sql)	(revision 7775)
+++ branches/unlabeled/unlabeled-1.74.2/admin/install/inportal_data.sql	(.../inportal_data.sql)	(revision 7811)
@@ -225,4 +225,4 @@
 
 INSERT INTO Stylesheets VALUES (8, 'Default', 'In-Portal Default Theme', '', 1124952555, 1);
 
-INSERT INTO Modules (Name, Path, Var, Version, Loaded, LoadOrder, TemplatePath, RootCat, BuildDate) VALUES ('In-Portal', 'kernel/', 'm', '4.0.1', 1, 0, '', 0, '1054738405');
\ No newline at end of file
+INSERT INTO Modules (Name, Path, Var, Version, Loaded, LoadOrder, TemplatePath, RootCat, BuildDate) VALUES ('In-Portal', 'kernel/', 'm', '4.0.2', 1, 0, '', 0, '1054738405');
\ No newline at end of file
Index: branches/unlabeled/unlabeled-1.1.2/admin/install/upgrades/inportal_upgrade_v4.0.2.sql
===================================================================
diff -u
--- branches/unlabeled/unlabeled-1.1.2/admin/install/upgrades/inportal_upgrade_v4.0.2.sql	(revision 0)
+++ branches/unlabeled/unlabeled-1.1.2/admin/install/upgrades/inportal_upgrade_v4.0.2.sql	(revision 7811)
@@ -0,0 +1,3 @@
+ALTER TABLE EmailMessage ADD ReplacementTags TEXT NOT NULL AFTER Template;
+
+UPDATE Modules SET Version = '4.0.2' WHERE Name = 'In-Portal';
\ No newline at end of file
Index: branches/unlabeled/unlabeled-1.4.2/core/install/install_schema.sql
===================================================================
diff -u -r7782 -r7811
--- branches/unlabeled/unlabeled-1.4.2/core/install/install_schema.sql	(.../install_schema.sql)	(revision 7782)
+++ branches/unlabeled/unlabeled-1.4.2/core/install/install_schema.sql	(.../install_schema.sql)	(revision 7811)
@@ -61,10 +61,11 @@
 CREATE TABLE EmailMessage (
   EmailMessageId int(10) NOT NULL auto_increment,
   Template longtext,
+  ReplacementTags text NOT NULL,
   MessageType enum('html','text') NOT NULL default 'text',
   LanguageId int(11) NOT NULL default '0',
   EventId int(11) NOT NULL default '0',
-  Subject text,
+  `Subject` text,
   PRIMARY KEY  (EmailMessageId)
 );
 
Index: branches/unlabeled/unlabeled-1.2.2/core/install/upgrades.sql
===================================================================
diff -u -r7783 -r7811
--- branches/unlabeled/unlabeled-1.2.2/core/install/upgrades.sql	(.../upgrades.sql)	(revision 7783)
+++ branches/unlabeled/unlabeled-1.2.2/core/install/upgrades.sql	(.../upgrades.sql)	(revision 7811)
@@ -6,3 +6,6 @@
 
 ALTER TABLE PersistantSessionData DROP PRIMARY KEY ;
 ALTER TABLE PersistantSessionData ADD INDEX ( `PortalUserId` ) ;
+
+# ===== v 4.0.2 =====
+ALTER TABLE EmailMessage ADD ReplacementTags TEXT NOT NULL AFTER Template;