import_sqlserver.sql

来自「openfire 服务器源码下载」· SQL 代码 · 共 9 行

INSERT INTO sipUser
(username, sipUsername, sipAuthuser, sipDisplayName, sipPassword, sipServer, stunServer, stunPort, useStun, voicemail, enabled, status, outboundproxy, promptCredentials)
SELECT username, sipUsername, sipAuthuser, sipDisplayName, sipPassword, sipServer, stunServer, stunPort, useStun, voicemail, enabled, status, outboundproxy, promptCredentials
FROM entSipUser;

INSERT INTO sipPhoneLog
(username, addressFrom, addressTo, datetime, duration, callType)
SELECT username, addressFrom, addressTo, datetime, duration, callType
FROM entPhoneLog;