Replace LeveledCompactionStrategy (LCS) with Cassandra 5.x default UnifiedCompactionStrategy (UCS) in schema.cql

Description

The Cassandra schema file /cassandra/temporal/schema.cql currently configures nearly all tables with LeveledCompactionStrategy (LCS). LCS is not a good general-purpose default — it's optimized for read-heavy workloads with low write amplification tolerance, and imposes unnecessary compaction overhead for tables that don't need it.

Cassandra 5.0 introduces UnifiedCompactionStrategy (UCS) as the new default, which is designed to work well as a general-purpose strategy across a broader range of workloads.

Describe the solution you'd like

Remove the explicit WITH COMPACTION = {...} clause from each table definition in schema.cql. Dropping the clause lets each table fall back to the engine's default compaction strategy:

On Cassandra 5.x, this will default to UnifiedCompactionStrategy (UCS).
On earlier Cassandra versions, this will default to SizeTieredCompactionStrategy (STCS), so backward compatibility is preserved.

This avoids hardcoding a compaction strategy choice in the schema and lets each Cassandra version apply its own sensible default.

Read /cassandra/temporal/schema.cql and locate the table definitions containing WITH COMPACTION clauses. Remove those explicit clauses from each table, then verify that schema.cql no longer hardcodes LCS while preserving the existing table definitions and version-compatible defaults.