DROP TABLE IF EXISTS `lportal430`.`PasswordTracker`;
CREATE TABLE `lportal430`.`PasswordTracker` (
`passwordTrackerId` bigint(20) NOT NULL,
`userId` bigint(20) default NULL,
`createDate` datetime default NULL,
`password_` varchar(75) default NULL,
PRIMARY KEY (`passwordTrackerId`),
KEY `IX_326F75BD` (`userId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
用户修改完口令后在此表中都建立一条记录,如果直接修改_User表的password,liferay会自动用passwordTracker恢复原来的口令。
CREATE TABLE `lportal430`.`PasswordTracker` (
`passwordTrackerId` bigint(20) NOT NULL,
`userId` bigint(20) default NULL,
`createDate` datetime default NULL,
`password_` varchar(75) default NULL,
PRIMARY KEY (`passwordTrackerId`),
KEY `IX_326F75BD` (`userId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
用户修改完口令后在此表中都建立一条记录,如果直接修改_User表的password,liferay会自动用passwordTracker恢复原来的口令。