MySql create calendar table

[paulnic]

Hi,

You would have thought there would have been many scripts out there that create calendar tables but i cant seem to find a simple one that does what i want...
Basically all i want is to create a table in mysql with a date field and a working day field. so like:

Date WorkingDay
01-01-2009 yes
02-01-2009 yes
03-01-2009 no

can someone point me in the right direction for creating this table please??

Thanks a lot

P

[svidgen]

You really just need a timestamp or date field and to make use of the date/time functions.