有没有大神帮忙优化下这个SQL,或者说看看写的对不对 CREATE TABLE dl_digital_purchase.qrtz_blob_triggers ( sched_name varchar(120) NOT NULL COMMENT '调度名称', trigger_name varchar(200) NOT NULL COMMENT 'qrtz_triggers表trigger_name的外键', trigger_group varchar(200) NOT NULL COMMENT 'qrtz_triggers表trigger_group的外键', blob_data VARBINARY NULL COMMENT '存放持久化Trigger对象' ) UNIQUE KEY(sched_name, trigger_name, trigger_group) CONSTRAINT FOREIGN qrtz_blob_triggers_ibfk_1 KEY (sched_name, trigger_name, trigger_group) REFERENCES qrtz_triggers (sched_name, trigger_name, trigger_group) ON DELETE RESTRICT ON UPDATE RESTRICT COMMENT '代码生成业务表' DISTRIBUTED BY HASH(sched_name, trigger_name, trigger_group) BUCKETS 1 PROPERTIES ("replication_allocation" = "tag.location.default: 1") |