CREATE TABLE IF NOT EXISTS `s3_video_analytics` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `video` varchar(200) NOT NULL,
  `started` int(30) NOT NULL,
  `finished` int(30) DEFAULT NULL,
  `client_ip` varchar(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

{table}

CREATE TABLE IF NOT EXISTS `s3_video_playlists` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `playlist_name` varchar(100) NOT NULL,
  `created` int(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

{table}

CREATE TABLE IF NOT EXISTS `s3_video_playlist_videos` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `video_file` varchar(200) NOT NULL,
  `video_playlist` int(11) NOT NULL,
  `video_weight` int(5) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

{table}

CREATE TABLE IF NOT EXISTS `s3_video_stills` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `video_file` varchar(200) NOT NULL,
  `image_file` varchar(200) NOT NULL,
  `created` bigint(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
