sip_oracle.sql

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

-- $Revision$
-- $Date$

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

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

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