Create table survey (ID not int not null auto_increment,
    name varchar(255), LastUpdate date, DateCreated Date, 
    OwnerID number, Description varchar(255), 
    IsClosed smallint, primary key(ID));

Example 1: The Survey table.