6 lines
509 B
SQL
6 lines
509 B
SQL
ALTER TABLE `users` MODIFY COLUMN `role` enum('admin','standard','readonly') NOT NULL DEFAULT 'standard';--> statement-breakpoint
|
|
ALTER TABLE `users` ADD `login` varchar(255);--> statement-breakpoint
|
|
ALTER TABLE `users` ADD `firstName` varchar(100);--> statement-breakpoint
|
|
ALTER TABLE `users` ADD `lastName` varchar(100);--> statement-breakpoint
|
|
ALTER TABLE `users` ADD `isActive` boolean DEFAULT true NOT NULL;--> statement-breakpoint
|
|
ALTER TABLE `users` ADD CONSTRAINT `users_login_unique` UNIQUE(`login`); |