Manage schedule time or datetime

Databases
1

Hi,
I should manage a web tv schedule
and I’m in two minds about the way
to cope with it.


CREATE TABLE  `schedule` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `date` date NOT NULL,
  `channel_id` int(10) unsigned NOT NULL,
  `video_id` int(10) unsigned NOT NULL,
  `start` time NOT NULL,
  `end` time NOT NULL,
  `description` varchar(255) NOT NULL,
  `language` varchar(2) NOT NULL default 'it',
  PRIMARY KEY  (`id`)
) DEFAULT CHARSET=utf8;
or
CREATE TABLE  `schedule` (
  `id` int(10) unsigned NOT NULL auto_increment,
   `channel_id` int(10) unsigned NOT NULL,
  `video_id` int(10) unsigned NOT NULL,
  `start` datetime NOT NULL,
  `end` datetime NOT NULL,
  `description` varchar(255) NOT NULL,
  `language` varchar(2) NOT NULL default 'en',
  PRIMARY KEY  (`id`)
) DEFAULT CHARSET=utf8;

What’s the best way.
I’m also looking for links about this topic.
Thanks in advance.

Bye

2

second one is better, because of videos which might run across midnight

3

:d