CREATE TABLE `test_lot` (
`lot_id` bigint unsigned NOT NULL,
`trade_date` date NOT NULL,
PRIMARY KEY (`lot_id`,`trade_date`)
) ENGINE=InnoDB
ALTER TABLE test_lot ADD COLUMN event_ref_type_id INTEGER, algorithm=instant, ADD COLUMN event_ref_id BIGINT, algorithm=instant;