7 lines
251 B
SQL
7 lines
251 B
SQL
-- Add full_name, department, position, and role to the users table
|
|
ALTER TABLE `users`
|
|
ADD COLUMN `full_name` VARCHAR(255) NULL,
|
|
ADD COLUMN `department` VARCHAR(255) NULL,
|
|
ADD COLUMN `position` VARCHAR(255) NULL,
|
|
ADD COLUMN `role` VARCHAR(255) NULL;
|