Store a Shop's Hours of Operation MySQL

When you refer to the "open and close time of shops" means, am I to assume that you mean the daily schedule for opening and closing the shops (as in the "normal hours of the shop") or the on going history of when each shop _actually_ opens and closes?

In the case of the normal operating hours, I would create a table (ShopTimes) containing the following columns:
TableName: ShopTimes
ShopTimeID int Auto_Increment
ShopID int -- Note: This assumes another table with the ShopID, ShopName, etc.
WeekDayNo int -- Note: This assumes the use of DayOfWeek() to get this number
OpeningTime DateTime -- Note: Use of DateTime should make it easier to calculate calendar
ClosingTime DateTime -- DateTimes based on a date plus these column values


In the case of actual shop openings and closings:
TableName: ShopTimesHistory
ShopTimeHistoryID int Auto_Increment
ShopID int -- Note: This assumes another table with the ShopID, ShopName, etc.
WeekDayNo int -- Note: This assumes the use of DayOfWeek() to get this number
OpeningTime DateTime -- Note: In this case, the complete datetime from the actual opening
ClosingTime DateTime -- and closing should be recorded