5 lines
413 B
SQL
5 lines
413 B
SQL
-- This migration adds a new column `type` to the `glcc_settings` table
|
|
ALTER TABLE glcc_settings ADD COLUMN `type` VARCHAR(50) DEFAULT 'timeSetting' COMMENT '配置类型' AFTER `round`;
|
|
|
|
-- This migration adds a unique index to the `glcc_settings` table to prevent duplicate settings with the same name, round, and type
|
|
ALTER TABLE glcc_settings ADD UNIQUE KEY `unique_index_name_round` (`name`,`round`,`type`); |