mirror of
https://github.com/LemmyNet/lemmy.git
synced 2024-11-25 10:51:03 +00:00
17 lines
249 B
MySQL
17 lines
249 B
MySQL
|
ALTER TABLE person
|
||
|
|
ADD COLUMN admin boolean DEFAULT FALSE NOT NULL;
|
||
|
|
|
||
|
|
UPDATE
|
||
|
|
person
|
||
|
|
SET
|
||
|
|
admin = TRUE
|
||
|
|
FROM
|
||
|
|
local_user
|
||
|
|
WHERE
|
||
|
|
local_user.person_id = person.id
|
||
|
|
AND local_user.admin;
|
||
|
|
|
||
|
|
ALTER TABLE local_user
|
||
|
|
DROP COLUMN admin;
|
||
|
|
|