-- 策略身份与版本（plan.md §38/§39 生命周期）
-- 由 src/hdiv/data/schema.py 生成，请勿手工修改
CREATE TABLE IF NOT EXISTS `hd_strategy` (
  `strategy_id`   VARCHAR(32)  NOT NULL,
  `name`          VARCHAR(64)  NOT NULL,
  `version`       VARCHAR(16)  NOT NULL,
  `status`        VARCHAR(16)  NOT NULL DEFAULT 'DRAFT'
                  COMMENT 'DRAFT/RESEARCH/BACKTEST/VALIDATED/PAPER/LIVE/ARCHIVED',
  `description`   VARCHAR(500) NOT NULL DEFAULT '',
  `yaml_path`     VARCHAR(255) NULL,
  `config_json`   MEDIUMTEXT   NOT NULL,
  `config_hash`   VARCHAR(64)  NOT NULL,
  `parent_id`     VARCHAR(32)  NULL COMMENT '上一版本 strategy_id',
  `spec_type`     VARCHAR(16)  NOT NULL DEFAULT 'yaml',
  `created_at`    DATETIME     NOT NULL,
  `updated_at`    DATETIME     NOT NULL,
  PRIMARY KEY (`strategy_id`,`version`),
  UNIQUE KEY `uq_hd_strat_hash` (`config_hash`),
  KEY `ix_hd_strat_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='策略版本';