TG-PlatformPlus/sqls/device.sql

10 lines
272 B
PL/PgSQL

PRAGMA foreign_keys = false;
-- 尝试添加 group_id 列,如果已经存在则忽略错误
BEGIN;
-- 添加 group_id 列,赋予默认值
ALTER TABLE device ADD COLUMN group_id TEXT DEFAULT '00000000-0000-0000-0000-000000000000';
COMMIT;
PRAGMA foreign_keys = true;