7 lines
425 B
SQL
7 lines
425 B
SQL
ALTER TABLE `session` ADD `impersonated_by` text;--> statement-breakpoint
|
|
ALTER TABLE `user` ADD `role` text;--> statement-breakpoint
|
|
ALTER TABLE `user` ADD `banned` integer DEFAULT false;--> statement-breakpoint
|
|
ALTER TABLE `user` ADD `ban_reason` text;--> statement-breakpoint
|
|
ALTER TABLE `user` ADD `ban_expires` integer;--> statement-breakpoint
|
|
UPDATE `user` SET `role` = 'admin' WHERE `role` IS NULL OR `role` = 'user';
|