openfire 快速整合第三方用户表

UPDATE `wmq`.`ofProperty` SET propValue='org.jivesoftware.openfire.user.JDBCUserProvider' WHERE name='provider.user.className'; 
UPDATE `wmq`.`ofProperty` SET propValue='org.jivesoftware.openfire.auth.JDBCAuthProvider' WHERE name='provider.auth.className'; 
INSERT INTO `wmq`.`ofProperty` VALUES 
('jdbcProvider.driver','com.mysql.jdbc.Driver'),
('jdbcProvider.connectionString','jdbc:mysql://localhost:3306/wmq?user=root&password='),
('admin.authorizedJIDs','8324554@localhost'),
('jdbcAuthProvider.passwordSQL','SELECT pass FROM wmq_member WHERE card=?'),
('jdbcAuthProvider.passwordType','md5'),
('jdbcUserProvider.loadUserSQL','SELECT card, appid FROM wmq_member WHERE card=?'),
('jdbcUserProvider.userCountSQL','SELECT COUNT(*) FROM wmq_member'),
('jdbcUserProvider.allUsersSQL','SELECT card FROM wmq_member'),
('jdbcUserProvider.searchSQL','SELECT card FROM wmq_member WHERE'),
('jdbcUserProvider.usernameField','card'),
('jdbcUserProvider.nameField','nickname'),
('jdbcUserProvider.emailField','appid');