packetfilter_sqlserver.sql

openfire 服务器源码下载

DROP TABLE pfRules;
CREATE TABLE pfRules (
   id           BIGINT IDENTITY(10,2),
   ruleorder    BIGINT,
   type         varchar(255),
   tojid       varchar(255),
   fromjid     varchar(255),
   rulef       varchar(255),
   disabled     bit,
   log          bit,
   description  varchar(255),
   sourcetype   varchar(255),
   desttype     varchar(255),
   PRIMARY KEY (id)
);
UPDATE jiveVersion set version=1 where name='packetfilter';