CREATE TABLE Orders ( OrderId INT NOT NULL, ProductName VARCHAR(50) NOT NULL, OrderDate datetime NOT NULL DEFAULT curdate(), PRIMARY KEY (OrderId) )