sip_db2.sql

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

-- $Revision$
-- $Date$

INSERT INTO jiveVersion (name, version) VALUES ('sip', 1);

create table sipUser (
	username VARCHAR(255) NOT NULL,
	sipUsername VARCHAR(255),
	sipAuthuser VARCHAR(255),
	sipDisplayName VARCHAR(255),
	sipPassword VARCHAR(255),
	sipServer VARCHAR(255),
	stunServer VARCHAR(255),
	stunPort VARCHAR(255),
	useStun INTEGER,
	voicemail VARCHAR(255),
	enabled INTEGER,
	status VARCHAR(255),
	outboundproxy VARCHAR(255),
	promptCredentials INTEGER,
    CONSTRAINT sipUser_pk PRIMARY KEY(username)
);

create table sipPhoneLog (
	username VARCHAR(255),
	addressFrom VARCHAR(255),
	addressTo VARCHAR(255),
	datetime BIGINT,
	duration INTEGER,
	callType VARCHAR(20)
 );