openfire_postgresql.sql

来自「开源OA办公系统！！！！！！！！！！！！！！！！！！！！！」· SQL 代码 · 共 7 行

-- add wildcard column to ofExtComponentConf
ALTER TABLE ofExtComponentConf ADD COLUMN wildcard INTEGER;
UPDATE ofExtComponentConf SET wildcard = 0;

-- Update version
UPDATE ofVersion SET version = 20 WHERE name = 'openfire';