CREATE TABLE orders ( order_id INT PRIMARY KEY, product_name VARCHAR(100), order_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP );