In the context of creating a script to manage leased Teamspeak 3 servers, what are some best practices for structuring the database schema to efficiently store and retrieve time-related data?

To efficiently store and retrieve time-related data in a database schema for managing leased Teamspeak 3 servers, it is recommended to use timestamp data types for storing date and time information. Additionally, creating indexes on columns that are frequently used in time-based queries can improve performance. It is also important to properly handle time zone conversions to ensure accurate time calculations.

CREATE TABLE `leased_servers` (
  `server_id` INT PRIMARY KEY,
  `server_name` VARCHAR(50),
  `creation_date` TIMESTAMP,
  `expiration_date` TIMESTAMP,
  INDEX `creation_date_index` (`creation_date`),
  INDEX `expiration_date_index` (`expiration_date`)
);