-- --------------------------------------------------------

--
-- Table structure for table `ans_audio`
--

DROP TABLE IF EXISTS `ans_audio`;
CREATE TABLE `ans_audio` (
  `audio_id` bigint(20) NOT NULL auto_increment,
  `content_id` bigint(20) default NULL,
  `user_id` bigint(20) NOT NULL default '0',
  `audio_for` enum('Question','Answer') collate latin1_general_ci NOT NULL default 'Question',
  `audio_ext` varchar(5) collate latin1_general_ci NOT NULL,
  `audio_size` double NOT NULL,
  `playing_time` varchar(25) collate latin1_general_ci NOT NULL,
  `total_views` int(11) NOT NULL default '0',
  `latest_viewed` datetime NOT NULL,
  `date_added` datetime default NULL,
  `audio_server_url` varchar(100) collate latin1_general_ci default NULL,
  `audio_url` varchar(255) collate latin1_general_ci NOT NULL,
  `audio_upload_type` enum('Normal','Youtube','Othersite') collate latin1_general_ci NOT NULL default 'Normal',
  `audio_status` enum('Ok','Deleted') collate latin1_general_ci NOT NULL default 'Ok',
  `audio_encoded_status` enum('No','Partial','Yes') collate latin1_general_ci NOT NULL default 'No',
  `external_url` text collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`audio_id`),
  KEY `total_views` (`total_views`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `video_audio_views`
--

DROP TABLE IF EXISTS `video_audio_views`;
CREATE TABLE `video_audio_views` (
  `id` bigint(20) NOT NULL auto_increment,
  `content_id` bigint(20) NOT NULL default '0',
  `user_id` bigint(20) NOT NULL default '0',
  `content_type` enum('Video','Audio') collate latin1_general_ci NOT NULL default 'Video',
  `content_for` enum('Answer','Question') collate latin1_general_ci NOT NULL default 'Question',
  `date_viewed` datetime NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

