packetfilter_mysql.sql

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

CREATE TABLE pfRules (
   id           BIGINT          NOT NULL AUTO_INCREMENT,
   ruleorder    BIGINT      ,
   type         varchar(255)     ,
   tojid       varchar(255)    ,
   fromjid     varchar(255)    ,
   rulef         varchar(255)   ,
   disabled     boolean,
   log          boolean,
   description  varchar(255),
   sourcetype   varchar(255),
   desttype     varchar(255),
   PRIMARY KEY (id)
);
INSERT INTO jiveVersion(name,version) values('packetfilter',1);