Is this correct for creating a table with a date field

[jewel464g]

CREATE TABLE calendar (id tinyint(4) DEFAULT '0' NOT NULL
AUTO_INCREMENT,
startDate date, endDate date, description blob, PRIMARY KEY (id), UNIQUE id (id));

http://www.scriptchick.com/

When faced with a decision, always ask, 'Which would be the most fun?'

 

[sleipnir214]

Sure, except I recommend that you use something larger than a tinyint for your id field. The largest number tinyint can store is 255 when used as an unsigned. Since you're using it a a signed column, the largest number is 127.

I would define the id colum to be:

id int unsigned not null auto_increment ______________________________________________________________________
TANSTAAFL!