in akd_mysql/src/mysql_storables.rs [222:250]
fn get_batch_create_temp_table<St: Storable>() -> Option<String> {
match St::data_type() {
StorageType::Azks => None,
StorageType::HistoryNodeState => {
Some(
format!(
"CREATE TEMPORARY TABLE `{}`(`label_len` INT UNSIGNED NOT NULL, `label_val` VARBINARY(32) NOT NULL, `epoch` BIGINT UNSIGNED NOT NULL, PRIMARY KEY(`label_len`, `label_val`, `epoch`))",
TEMP_IDS_TABLE
)
)
},
StorageType::HistoryTreeNode => {
Some(
format!(
"CREATE TEMPORARY TABLE `{}`(`label_len` INT UNSIGNED NOT NULL, `label_val` VARBINARY(32) NOT NULL, PRIMARY KEY(`label_len`, `label_val`))",
TEMP_IDS_TABLE
)
)
},
StorageType::ValueState => {
Some(
format!(
"CREATE TEMPORARY TABLE `{}`(`username` VARCHAR(256) NOT NULL, `epoch` BIGINT UNSIGNED NOT NULL, PRIMARY KEY(`username`, `epoch`))",
TEMP_IDS_TABLE
)
)
},
}
}