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

--
-- Table structure for table `ans_video`
--

DROP TABLE IF EXISTS `ans_video`;
CREATE TABLE `ans_video` (
  `video_id` bigint(20) NOT NULL auto_increment,
  `content_id` bigint(20) default NULL,
  `user_id` bigint(20) NOT NULL default '0',
  `video_for` enum('Question','Answer') collate latin1_general_ci NOT NULL default 'Question',
  `video_ext` varchar(5) collate latin1_general_ci NOT NULL,
  `video_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,
  `t_width` int(11) default '0',
  `t_height` int(11) default '0',
  `video_server_url` varchar(100) collate latin1_general_ci default NULL,
  `video_flv_url` varchar(255) collate latin1_general_ci NOT NULL,
  `flv_upload_type` enum('Normal','Youtube','Othersite') collate latin1_general_ci NOT NULL default 'Normal',
  `personalized_url` text collate latin1_general_ci NOT NULL,
  `video_status` enum('Ok','Deleted') collate latin1_general_ci NOT NULL default 'Ok',
  `video_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  (`video_id`),
  KEY `content_id` (`content_id`),
  KEY `video_for` (`video_for`),
  KEY `total_views` (`total_views`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

--
-- Table structure for table `ans_video_advertisement`
--

DROP TABLE IF EXISTS `ans_video_advertisement`;
CREATE TABLE `ans_video_advertisement` (
  `advertisement_id` int(11) NOT NULL auto_increment,
  `user_id` bigint(20) NOT NULL,
  `advertisement_name` varchar(100) collate latin1_general_ci NOT NULL,
  `advertisement_description` text collate latin1_general_ci NOT NULL,
  `advertisement_url` varchar(500) collate latin1_general_ci NOT NULL,
  `advertisement_duration` int(11) NOT NULL,
  `advertisement_expiry_date` datetime NOT NULL,
  `advertisement_impressions` int(11) NOT NULL,
  `advertisement_channel` text collate latin1_general_ci NOT NULL,
  `advertisement_image` varchar(100) collate latin1_general_ci NOT NULL,
  `advertisement_ext` varchar(10) collate latin1_general_ci NOT NULL,
  `advertisement_show_at` enum('Beginning','Ending','Both') collate latin1_general_ci NOT NULL default 'Beginning',
  `advertisement_status` enum('Activate','Inactive') collate latin1_general_ci NOT NULL default 'Inactive',
  `date_added` datetime NOT NULL,
  `advertisement_current_impressions` int(11) NOT NULL,
  `views_revenue` double NOT NULL default '0',
  `clicks_revenue` double NOT NULL default '0',
  `total_views` bigint(20) NOT NULL default '0',
  `total_clicks` bigint(20) NOT NULL default '0',
  `site_earnings` double NOT NULL default '0',
  `members_earnings` double NOT NULL default '0',
  `add_type` enum('Porn','General') collate latin1_general_ci NOT NULL default 'General',
  PRIMARY KEY  (`advertisement_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

--
-- Table structure for table `ans_video_logo`
--

DROP TABLE IF EXISTS `ans_video_logo`;
CREATE TABLE `ans_video_logo` (
  `logo_id` tinyint(4) NOT NULL auto_increment,
  `logo_name` varchar(100) collate latin1_general_ci NOT NULL,
  `logo_description` text collate latin1_general_ci NOT NULL,
  `logo_url` varchar(500) collate latin1_general_ci NOT NULL,
  `logo_position` enum('Left_bottom','Left_top','Right_bottom','Right_top') collate latin1_general_ci NOT NULL default 'Left_bottom',
  `logo_transparency` int(11) NOT NULL,
  `logo_rollover_transparency` int(11) NOT NULL,
  `animated_logo` enum('yes','no') collate latin1_general_ci NOT NULL default 'no',
  `logo_image` varchar(100) collate latin1_general_ci NOT NULL,
  `logo_ext` varchar(10) collate latin1_general_ci NOT NULL,
  `mini_logo_image` varchar(100) collate latin1_general_ci NOT NULL,
  `mini_logo` enum('1','0') collate latin1_general_ci NOT NULL default '1',
  `mini_logo_ext` varchar(10) collate latin1_general_ci NOT NULL,
  `logo_status` enum('yes','no') collate latin1_general_ci NOT NULL default 'yes',
  `date_added` datetime NOT NULL,
  PRIMARY KEY  (`logo_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

--
-- Table structure for table `ans_video_player_settings`
--

DROP TABLE IF EXISTS `ans_video_player_settings`;
CREATE TABLE `ans_video_player_settings` (
  `player_settings_id` int(11) NOT NULL auto_increment,
  `play_settings` enum('1','0') collate latin1_general_ci NOT NULL default '1',
  `title` enum('1','0') collate latin1_general_ci NOT NULL default '0',
  `share_link` enum('1','0') collate latin1_general_ci NOT NULL default '0',
  `repeat_link` enum('1','0') collate latin1_general_ci NOT NULL default '1',
  `skin` varchar(50) collate latin1_general_ci NOT NULL,
  `play_list_settings` enum('1','0') collate latin1_general_ci NOT NULL default '1',
  `show_play_list_by` enum('tags','channel','random') collate latin1_general_ci NOT NULL default 'tags',
  `date_added` datetime NOT NULL,
  PRIMARY KEY  (`player_settings_id`)
) 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;

--
-- Dumping data for table `ans_video_player_settings`
--

INSERT INTO `ans_video_player_settings` (`player_settings_id`, `play_settings`, `title`, `share_link`, `repeat_link`, `skin`, `play_list_settings`, `show_play_list_by`, `date_added`) VALUES (1, '0', '', '', '1', 'blacktheme', '', 'tags', NOW());

--
-- Dumping data for table `rightbar_settings`
--

INSERT INTO `rightbar_settings` (`title`, `order_value`) VALUES ('best_video', 1);
