Re: storing start/end times

[Peter Brawley]

Doesn't look like a problem, eg given ...

stores( sid int unsigned primary key auto_increment, ... )
calendar( d date ); /* one row per day */

create table storesopen(    -- one row per store per open period
  id int unsigned primary key auto_increment, 
  sid int unsigned,         -- store id
  d date,                   -- date
  open time, 
  close time,
  foreign key(d) references calendar(d) on update cascade on delete cascade,
  foreign key(sid) references stores(sid) on update cascade on delete cascade
);