5 lines
289 B
MySQL
5 lines
289 B
MySQL
|
-- 为terminals表添加当前绑定用户ID字段
|
||
|
|
ALTER TABLE `terminals`
|
||
|
|
ADD COLUMN `current_user_id` INT DEFAULT NULL COMMENT '当前绑定/使用的用户ID',
|
||
|
|
ADD CONSTRAINT `fk_terminals_current_user` FOREIGN KEY (`current_user_id`) REFERENCES `users` (`user_id`) ON DELETE SET NULL;
|