openfire数据库整合SQL语句

  
UPDATE `openfire`.`ofProperty` SET propValue='org.jivesoftware.openfire.user.JDBCUserProvider' WHERE name='provider.user.className';
UPDATE `openfire`.`ofProperty` SET propValue='org.jivesoftware.openfire.auth.JDBCAuthProvider' WHERE name='provider.auth.className';
      INSERT INTO `openfire`.`ofProperty` VALUES  ('jdbcProvider.driver','com.mysql.jdbc.Driver'),
      ('jdbcProvider.connectionString','jdbc:mysql://ip:3306/db?user=###&password=****'),
      ('admin.authorizedJIDs','####'),
      ('jdbcAuthProvider.passwordSQL','SELECT passwd FROM users WHERE mobile=?'),
      ('jdbcAuthProvider.passwordType','md5'),
      ('jdbcUserProvider.loadUserSQL','SELECT name,email FROM users WHERE mobile=?'),
      ('jdbcUserProvider.userCountSQL','SELECT COUNT(*) FROM users'),
      ('jdbcUserProvider.allUsersSQL','SELECT mobile FROM users'),
      ('jdbcUserProvider.searchSQL','SELECT mobile FROM users WHERE'),
      ('jdbcUserProvider.usernameField','mobile'),
      ('jdbcUserProvider.nameField','mobile'),
      ('jdbcUserProvider.emailField','email');