well what Slimdave suggested (second option) does not require drop and recreate partitions everyday

it´s just 7 partitions which stores day 1 to 7, reusing them, for example next monday will use this monday partitions.

if you cannot add a column how are you gonna use partitions...? what column are you going to use?