CREATE TABLE events (
    id INT AUTO_INCREMENT PRIMARY KEY,
    event_name VARCHAR(100),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

CREATE TABLE historical_dates (
    id INT AUTO_INCREMENT PRIMARY KEY,
    event_description TEXT,
    event_date DATETIME
);

CREATE TABLE log_entries (
    id INT AUTO_INCREMENT PRIMARY KEY,
    log_message TEXT,
    timestamp_unix BIGINT
);

-- 创建包含多种时间类型的表
CREATE TABLE time_examples (
    id INT AUTO_INCREMENT PRIMARY KEY,
    event_name VARCHAR(100),
    ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    dt DATETIME,
    unix_ts BIGINT
);

-- 插入数据
INSERT INTO time_examples (event_name, dt, unix_ts) 
VALUES ('Test Event', '2023-10-01 12:00:00', UNIX_TIMESTAMP());

-- 查询数据
SELECT 
    id,
    event_name,
    ts AS timestamp_value,
    dt AS datetime_value,
    FROM_UNIXTIME(unix_ts) AS from_unix_time
FROM time_examples;