Index: trunk/admin/install/upgrades/inportal_upgrade_v1.0.10.sql
===================================================================
diff -u -N -r1176 -r1185
--- trunk/admin/install/upgrades/inportal_upgrade_v1.0.10.sql	(.../inportal_upgrade_v1.0.10.sql)	(revision 1176)
+++ trunk/admin/install/upgrades/inportal_upgrade_v1.0.10.sql	(.../inportal_upgrade_v1.0.10.sql)	(revision 1185)
@@ -2,9 +2,18 @@
 ALTER TABLE PortalGroup DROP INDEX ResourceId, ADD UNIQUE ResourceId (ResourceId);
 ALTER TABLE PortalUser DROP INDEX ResourceId, ADD UNIQUE ResourceId (ResourceId);
 
+ALTER TABLE PortalUser ADD PwResetConfirm VARCHAR(255);
+ALTER TABLE PortalUser ADD UNIQUE (PwResetConfirm);
+ALTER TABLE PortalUser ADD PwRequestTime BIGINT(20);
+ALTER TABLE PortalUser ADD MinPwResetDelay INT DEFAULT '1800' NOT NULL;
+
+ALTER TABLE CustomMetaData ADD INDEX (ResourceId);
+ALTER TABLE CustomMetaData ADD INDEX (CustomFieldId);
+
 ALTER TABLE PortalUser ADD PassResetTime BIGINT(20);
 
 INSERT INTO Events VALUES (67, 'USER.PSWDC', '1', '0', 'In-Portal:Users', 'la_event_user.pswd_confirm', '0');
+INSERT INTO Events VALUES (45, 'USER.ADD.PENDING', 2, 0, 'In-Portal:Users', 'la_event_user.add.pending', 1)
 
 INSERT INTO ConfigurationAdmin VALUES ('Users_AllowReset', 'la_Text_General', 'la_prompt_allow_reset', 'text', NULL, NULL, 3, 0);
 
@@ -16,11 +25,3 @@
 DELETE FROM ConfigurationAdmin WHERE VariableName = 'Smtp_SendHTML';
 
 UPDATE Modules SET Version = '1.0.10' WHERE Name = 'In-Portal';
-
-ALTER TABLE PortalUser ADD PwResetConfirm VARCHAR(255);
-ALTER TABLE PortalUser ADD UNIQUE (PwResetConfirm);
-ALTER TABLE PortalUser ADD PwRequestTime BIGINT(20);
-ALTER TABLE PortalUser ADD MinPwResetDelay INT DEFAULT '1800' NOT NULL;
-
-ALTER TABLE CustomMetaData ADD INDEX (ResourceId);
-ALTER TABLE CustomMetaData ADD INDEX (CustomFieldId);
\ No newline at end of file
