1
0
mirror of https://github.com/haiwen/seahub.git synced 2025-06-22 13:18:42 +00:00
seahub/scripts/upgrade/sql/13.0.0/mysql/ccnet.sql

5 lines
297 B
MySQL
Raw Permalink Normal View History

2025-03-15 04:09:31 +00:00
ALTER TABLE EmailUser ADD COLUMN `is_department_owner` BOOL NOT NULL DEFAULT 0;
CREATE INDEX EmailUser_is_active on EmailUser(is_active);
CREATE INDEX EmailUser_is_department_owenr on EmailUser(is_department_owner);
2025-03-17 09:57:14 +00:00
UPDATE `EmailUser` SET is_department_owner=1 WHERE email LIKE "%@seafile_group";