-- sys_license_infos 增加 request_code 字段
|
-- 用途：按当前机器请求码筛选并激活对应许可证
|
-- 适用数据库：MySQL
|
|
SET @current_db := DATABASE();
|
|
SET @column_exists := (
|
SELECT COUNT(1)
|
FROM information_schema.COLUMNS
|
WHERE TABLE_SCHEMA = @current_db
|
AND TABLE_NAME = 'sys_license_infos'
|
AND COLUMN_NAME = 'request_code'
|
);
|
|
SET @add_column_sql := IF(
|
@column_exists = 0,
|
'ALTER TABLE sys_license_infos ADD COLUMN request_code VARCHAR(2048) NULL COMMENT ''许可证请求码'' AFTER license_time',
|
'SELECT ''column request_code already exists'' '
|
);
|
PREPARE stmt_add_column FROM @add_column_sql;
|
EXECUTE stmt_add_column;
|
DEALLOCATE PREPARE stmt_add_column;
|
|
SET @index_exists := (
|
SELECT COUNT(1)
|
FROM information_schema.STATISTICS
|
WHERE TABLE_SCHEMA = @current_db
|
AND TABLE_NAME = 'sys_license_infos'
|
AND INDEX_NAME = 'idx_sys_license_infos_request_code_create_time'
|
);
|
|
SET @add_index_sql := IF(
|
@index_exists = 0,
|
'ALTER TABLE sys_license_infos ADD INDEX idx_sys_license_infos_request_code_create_time (request_code(191), create_time)',
|
'SELECT ''index idx_sys_license_infos_request_code_create_time already exists'' '
|
);
|
PREPARE stmt_add_index FROM @add_index_sql;
|
EXECUTE stmt_add_index;
|
DEALLOCATE PREPARE stmt_add_index;
|
|
SHOW COLUMNS FROM sys_license_infos LIKE 'request_code';
|
SHOW INDEX FROM sys_license_infos WHERE Key_name = 'idx_sys_license_infos_request_code_create_time';
|
