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

--
-- Table structure for table `ban`
--

CREATE TABLE IF NOT EXISTS `ban` (
  `ip` varchar(15) NOT NULL default '',
  PRIMARY KEY  (`ip`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `blocked`
--

CREATE TABLE IF NOT EXISTS `blocked` (
  `blocker_id` int(11) NOT NULL default '0',
  `blockee_id` int(11) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `category`
--

CREATE TABLE IF NOT EXISTS `category` (
  `id` int(255) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=28 ;

--
-- Dumping data for table `category`
--

LOCK TABLES `category` WRITE;
/*!40000 ALTER TABLE `category` DISABLE KEYS */;
INSERT INTO `category` VALUES (1,'Main category');
/*!40000 ALTER TABLE `category` ENABLE KEYS */;
UNLOCK TABLES;

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

--
-- Table structure for table `email_text`
--

CREATE TABLE IF NOT EXISTS `email_text` (
  `ident` varchar(255) NOT NULL default '',
  `phrase` text NOT NULL,
  PRIMARY KEY  (`ident`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `email_text`
--

LOCK TABLES `email_text` WRITE;
/*!40000 ALTER TABLE `email_text` DISABLE KEYS */;
INSERT INTO `email_text` VALUES ('email_forgot','Hello,\r\nYou have requested a new username and password for [SITENAME].\r\n\r\nUsername: [USERNAME]\r\nPassword: [PASSWORD]\r\n\r\nThanks\r\n\r\nAdmin'),('email_activate','Hello,\r\nsomeone, probably you, has registered this e-mail address with us at [SITEURL].\r\n\r\nTo complete the registration process please activate your account by clicking on the following link:\r\n\r\n[ACTLINK]\r\n\r\nThank you for registering\r\n\r\n[SITENAME]'),('email_approved_friend','Hallo [USERNAME],\r\n\r\nYou receive this email because you are a friend of user: [POSTER] on [SITENAME]\r\nHe/She uploaded a video with the title: [TITLE]\r\n\r\nYou can see the video on: [MEDIALINK]\r\n\r\nGreetings,\r\n[SITEURL]'),('email_approved_admin','Hallo admin,\r\n\r\nThere is uploaded a new video to [SITEURL] By user: [POSTER]\r\nThe title is: [TITLE]\r\n\r\nGo to your admin panel to approve the video.\r\n\r\nGreetings,\r\n[SITEURL]'),('email_approved','Hallo [USERNAME],\r\n\r\nYour uploaded to [SITENAME] video with the title: [TITLE]  is approved by the admin.\r\nYou can see the video on: [MEDIALINK]\r\n\r\nGreetings,\r\n[SITEURL]'),('email_approved_subscriber','Hallo [USERNAME],\r\n\r\nYou receive this email because you subscribed to user: [POSTER] on [SITENAME]\r\nHe/She uploaded a video with the title: [TITLE]\r\n\r\nYou can see the video on: [MEDIALINK]\r\n\r\n\r\nGreetings,\r\n[SITEURL]'),('email_rejected','Hallo [USERNAME],\r\n\r\nYour uploaded to [SITENAME] video with the title: [TITLE]  is rejected by the admin.\r\n\r\nGreetings,\r\n[SITEURL]'),('email_request_friend','Hallo [USERNAME],\r\n\r\nYou received a new friend request from: [FRIENDREQUEST]\r\nLogin to your account to accept or reject this request.\r\n\r\nGreetings,\r\n[SITEURL]'),('email_friend_pm','Hallo [USERNAME],\r\nYou received a new message from user: [POSTER]\r\nTo view your message login to your account and go to inbox.\r\n\r\nGreetings,\r\n[SITEURL]');
/*!40000 ALTER TABLE `email_text` ENABLE KEYS */;
UNLOCK TABLES;

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

--
-- Table structure for table `favorite`
--

CREATE TABLE IF NOT EXISTS `favorite` (
  `userid` int(11) NOT NULL default '0',
  `vidid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`userid`,`vidid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `friend`
--

CREATE TABLE IF NOT EXISTS `friend` (
  `userid` int(11) NOT NULL default '0',
  `friendid` int(11) NOT NULL default '0',
  `friend_approved` tinyint(1) NOT NULL default '0',
  `friend_removed` tinyint(11) NOT NULL default '0',
  PRIMARY KEY  (`userid`,`friendid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `media`
--

CREATE TABLE IF NOT EXISTS `media` (
  `id` int(255) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `category` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  `tags` varchar(255) NOT NULL default '',
  `fileid` varchar(255) NOT NULL default '',
  `poster` varchar(255) NOT NULL default '0',
  `added` varchar(255) NOT NULL default '',
  `status` varchar(255) NOT NULL default 'false',
  `mobile` int(1) NOT NULL default '0',
  `hd` int(1) NOT NULL default '0',
  `embed` longtext NOT NULL,
  `featured` tinyint(1) NOT NULL default '0',
  `dayviews` int(11) NOT NULL default '0',
  `weekviews` int(11) NOT NULL default '0',
  `monthviews` int(11) NOT NULL default '0',
  `allviews` int(11) NOT NULL default '0',
  `checkday` varchar(64) NOT NULL default '',
  `checkweek` int(11) NOT NULL default '0',
  `checkmonth` int(11) NOT NULL default '0',
  `mediatype` varchar(10) NOT NULL default '',
  `flagged` tinyint(1) NOT NULL default '0',
  `lastviewed` bigint(20) NOT NULL,
  `vidad` text,
  `duration` varchar(255) NOT NULL default '0',
  `mainthumb` int(2) NOT NULL default '1',
  PRIMARY KEY  (`id`),
  FULLTEXT KEY `title` (`title`),
  FULLTEXT KEY `tags` (`tags`),
  FULLTEXT KEY `discription` (`description`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `media_comment`
--

CREATE TABLE IF NOT EXISTS `media_comment` (
  `id` int(255) NOT NULL auto_increment,
  `vid_id` int(25) NOT NULL default '0',
  `date` varchar(255) NOT NULL default '',
  `text` text NOT NULL,
  `leftbyname` varchar(40) NOT NULL default '',
  `regdposter` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `member`
--

CREATE TABLE IF NOT EXISTS `member` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(20) NOT NULL default '',
  `password` varchar(40) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `cookie` varchar(40) NOT NULL default '',
  `session` varchar(40) NOT NULL default '',
  `ip` varchar(15) NOT NULL default '',
  `activationkey` varchar(40) NOT NULL default '',
  `history` text NOT NULL,
  `avatar` varchar(255) NOT NULL default '',
  `profile_privacy` smallint(6) NOT NULL default '0',
  `gender` tinyint(1) NOT NULL default '0',
  `age` int(11) default NULL,
  `aboutme` varchar(255) default '',
  `location` varchar(64) NOT NULL default '',
  `created` varchar(255) NOT NULL default '',
  `lastlogin` varchar(255) NOT NULL default '0',
  `profileviews` int(11) NOT NULL default '0',
  `agreed` tinyint(1) NOT NULL default '0',
  `viewerhistory` text NOT NULL,
  `optoutofviewerlist` tinyint(1) NOT NULL default '0',
  `banned` tinyint(1) NOT NULL default '0',
  `friendmail_privacy` int(1) default '1',
  `favmovie` varchar(255) default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `message`
--

CREATE TABLE IF NOT EXISTS `message` (
  `messageid` int(11) NOT NULL auto_increment,
  `fromid` int(11) NOT NULL default '0',
  `toid` int(11) NOT NULL default '0',
  `body` text NOT NULL,
  `sentdate` varchar(255) NOT NULL default '0',
  `msgread` tinyint(4) NOT NULL default '0',
  `auto` int(11) NOT NULL default '0',
  PRIMARY KEY  (`messageid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `plugin_menu`
--

CREATE TABLE IF NOT EXISTS `plugin_menu` (
  `id` int(10) NOT NULL auto_increment,
  `menuname` varchar(255) NOT NULL default '',
  `menuclass` varchar(255) NOT NULL default '',
  `loaded` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `plugin_menu`
--

LOCK TABLES `plugin_menu` WRITE;
/*!40000 ALTER TABLE `plugin_menu` DISABLE KEYS */;
INSERT INTO `plugin_menu` (`id`, `menuname`, `menuclass`, `loaded`) VALUES (10, 'Server tester', 'servertest', 1);
/*!40000 ALTER TABLE `plugin_menu` ENABLE KEYS */;
UNLOCK TABLES;


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

--
-- Table structure for table `rating`
--

CREATE TABLE IF NOT EXISTS `rating` (
  `id` varchar(11) NOT NULL default '',
  `total_votes` int(11) NOT NULL default '0',
  `total_value` int(11) NOT NULL default '0',
  `which_id` int(11) NOT NULL default '0',
  `used_ips` longtext,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `setting`
--

CREATE TABLE IF NOT EXISTS `setting` (
  `setting` varchar(255) NOT NULL default '',
  `value` text NOT NULL,
  PRIMARY KEY  (`setting`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `setting`
--

INSERT INTO `setting` (`setting`, `value`) VALUES
('keepencodelog', '0'),
('mail_video_admin', '1'),
('mail_video_approved', '1'),
('mail_video_rejected', '1'),
('mail_video_friends', '1'),
('mail_friend_request', '1'),
('mail_friend_pm', '1'),
('mail_friend_subscribed', '1'),
('sitename', 'test2'),
('activation', '1'),
('membervideodelete', '0'),
('downmobileGuest', '0'),
('downnormalmembers', '1'),
('downmobilemember', '1'),
('restrictpc', '0'),
('audiobitrate', '128'),
('accountpageon', '1'),
('thumb_w1', '160'),
('hdvideo', '0'),
('thumb_h1', '120'),
('mobilevideo', '1'),
('sitetemplate', 'JAVS_green'),
('avatar_w', '160'),
('avatar_h', '120'),
('contact_email', ''),
('mediamaxsize', '209715200'),
('meta_toprated_key', 'Top Rated, Media'),
('videobitrate', '1024'),
('framerate', '12'),
('encodesize', '640x480'),
('meta_toprated_desc', 'Top Rated Media'),
('url_clean', '1'),
('comment_length', '300'),
('default_from', 'admin'),
('default_thumbtime', '20'),
('mp_toprated', '25'),
('mp_inbox', '8'),
('downmembers', '1'),
('sitetitle', 'Just Another Video Script'),
('mp_allvideos', '25'),
('sitefolder', '/'),
('meta_mostviewed_header', 'Most Viewed Media'),
('relateduserpage', '10'),
('ffmpegpath', ''),
('curlpath', ''),
('flvtool2path', ''),
('meta_home_header', 'Home'),
('player', 'jwplayer'),
('audiofrequency', '44100'),
('downGuest', '0'),
('mp_outbox', '8'),
('maxresolution_w', '1280'),
('maxresolution_h', '720'),
('mp_mostviewed', '25'),
('mp_uploadedvideos', '8'),
('showdesc', '1'),
('mp4box', ''),
('meta_toprated_header', 'Top Rated Media'),
('mp_friend', '10'),
('mp_fav', '10'),
('mp_sub', '10'),
('mp_media', '10'),
('captchaformembers', '0'),
('mp_sentrequests', '8'),
('mp_profileviews', '8'),
('mp_blockedmembers', '8'),
('showcommunity', '1'),
('mp_community', '25'),
('mp_category', '25'),
('meta_home_desc', 'Home Media'),
('embed_videos', '1'),
('downhdguest', '0'),
('titledisplaylength', '25'),
('mp_favoritevideos', '8'),
('meta_home_key', 'Home, Media'),
('mp_receivedrequests', '8'),
('mp_friends', '8'),
('videoaspect', '4:3'),
('mp_viewinghistory', '8'),
('removeorifile', '1'),
('autoacceptvideo', '1'),
('passcron', 'test'),
('downhdmember', '1'),
('maxsizememberavatar', '524288'),
('mp_mediasearch', '25'),
('directencode', '1'),
('skinjw', 'beelden.zip'),
('meta_mostviewed_key', 'Most Viewed, media'),
('meta_mostviewed_desc', 'Most viewed media'),
('meta_allvideos_header', 'Javs demo video list'),
('meta_allvideos_key', 'Javs demo, video list, all movies'),
('meta_allvideos_desc', 'A list of videos to demonstrated javs demo'),
('meta_community_header', 'Community'),
('meta_community_key', 'community, video'),
('meta_community_desc', 'Community list'),
('meta_profile_header', 'Profile'),
('meta_profile_key', 'Profile, members'),
('meta_profile_desc', 'User Profile'),
('meta_category_header', 'Category'),
('meta_category_key', 'Category'),
('meta_category_desc', 'Category'),
('meta_search_header', 'Search'),
('meta_search_key', 'Search, find'),
('meta_search_desc', 'Search'),
('mobile_encodesize_height', '320'),
('mobile_encodesize_width', '480'),
('showdmca', '1'),
('showsocial', '1'),
('show2257', '1'),
('showallvideos', '1'),
('showtoprated', '1'),
('showmostviewed', '1'),
('showcategorie', '1'),
('showembed', '1'),
('enablelogin', '1'),
('showmembers', '1'),
('showupload', '1'),
('showfrontpage', 'home'),
('meta_catlist_header', 'categories List'),
('meta_catlist_key', 'Category, list, Categories'),
('meta_catlist_desc', 'A list of Categories, here you can pick the category you like very easy by clicking a sample picture.'),
('thumbsnumber', '12');

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

--
-- Table structure for table `sitead`
--

CREATE TABLE IF NOT EXISTS `sitead` (
  `adid` int(255) NOT NULL auto_increment,
  `addesc` varchar(255) default NULL,
  `adspace` varchar(20) NOT NULL default '',
  `adsize` varchar(40) NOT NULL default '',
  `adtext` text NOT NULL,
  PRIMARY KEY  (`adid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=23 ;

--
-- Dumping data for table `sitead`
--

INSERT INTO `sitead` (`adid`, `addesc`, `adspace`, `adsize`, `adtext`) VALUES
(1, '1 In the header on all pages', 'allheader', '468x60', '<div style="width:468px; height:80px; border:1px solid #505050;" align="center"><br/>Ad space 1<br/>468px 60px\n</div>'),
(2, '2 Top of home videos', 'homeabove', '728x90', '<div style="width:970px; height:90px; border:1px solid #505050;" align="center"><br/>Ad space 2<br/>Any size up to 970px wide<br/><b>Note:</b> The border will be removed when you add your ad code. Its seen here as an example of how your ad may look.\n</div>'),
(3, '3 Right side of home videos', 'homeright', '300x250', '<div style="width:310px; height:500px; border:1px solid #505050;" align="center"><br/>Ad space 3<br/>2 x 300x250<br/>Advertisement Here</div>'),
(4, '4 Middle of home videos', 'homemiddle', '728x90', '<div style="width:970px; height:90px; border:1px solid #505050;" align="center"><br/>Ad space 4<br/>Any size up to 970px wide<br/><b>Note:</b> The border will be removed when you add your ad code. Its seen here as an example of how your ad may look.\n</div>'),
(5, '5 Bottom of home videos', 'homeunder', '728x90', '<div style="width:970px; height:90px; border:1px solid #505050;" align="center"><br/>Ad space 5<br/>Any size up to 970px wide<br/><b>Note:</b> The border will be removed when you add your ad code. Its seen here as an example of how your ad may look.\n</div>'),
(6, '6 Top of top rated page', 'topratedabove', '728x90', '<div style="width:970px; height:90px; border:1px solid #505050;" align="center"><br/>Ad space 6<br/>Any size up to 970px wide<br/><b>Note:</b> The border will be removed when you add your ad code. Its seen here as an example of how your ad may look.\n</div>'),
(7, '7 Bottom of top rated page', 'topratedunder', '728x90', '<div style="width:970px; height:90px; border:1px solid #505050;" align="center"><br/>Ad space 7<br/>Any size up to 970px wide<br/><b>Note:</b> The border will be removed when you add your ad code. Its seen here as an example of how your ad may look.\n</div>'),
(8, '8  Top of mostviewed videos', 'populairabove', '728x90', '<div style="width:970px; height:90px; border:1px solid #505050;" align="center"><br/>Ad space 8<br/>Any size up to 970px wide<br/><b>Note:</b> The border will be removed when you add your ad code. Its seen here as an example of how your ad may look.\n</div>'),
(9, '9 Bottom of mostviewed videos', 'populairunder', '728x90', '<div style="width:970px; height:90px; border:1px solid #505050;" align="center"><br/>Ad space 9<br/>Any size up to 970px wide<br/><b>Note:</b> The border will be removed when you add your ad code. Its seen here as an example of how your ad may look.\n</div>'),
(10, '10 Top of video page', 'videoabove', '728x90', '<div style="width:970px; height:90px; border:1px solid #505050;" align="center"><br/>Ad space 10<br/>Any size up to 970px wide<br/><b>Note:</b> The border will be removed when you add your ad code. Its seen here as an example of how your ad may look.\n</div>'),
(11, '11 Bottom of video page', 'videounder', '728x90', '<div style="width:970px; height:90px; border:1px solid #505050;" align="center"><br/>Ad space 11<br/>Any size up to 970px wide<br/><b>Note:</b> The border will be removed when you add your ad code. Its seen here as an example of how your ad may look.\n</div>'),
(12, '12 Top above video player', 'playerabove', '728x90', '<div style="width:970px; height:90px; border:1px solid #505050;" align="center"><br/>Ad space 12<br/>Any size up to 970px wide<br/><b>Note:</b> The border will be removed when you add your ad code. Its seen here as an example of how your ad may look.\n</div>'),
(13, '13 Right side of video player', 'playerright', '300x250', '<div style="width:310px; height:515px; border:1px solid #505050;" align="center"><br/>Ad space 13<br/>2 x 300x250<br/>Advertisement Here</div>'),
(14, '14 Bottom of player', 'playunder', '728x90', '<div style="width:970px; height:90px; border:1px solid #505050;" align="center"><br/>Ad space 14<br/>Any size up to 970px wide<br/><b>Note:</b> The border will be removed when you add your ad code. Its seen here as an example of how your ad may look.\n</div>'),
(15, '15 Top of related videos', 'playrelated', '728x90', '<div style="width:970px; height:90px; border:1px solid #505050;" align="center"><br/>Ad space 15<br/>Any size up to 970px wide<br/><b>Note:</b> The border will be removed when you add your ad code. Its seen here as an example of how your ad may look.\n</div>'),
(16, '16 Bottom of related videos', 'playrelated2', '728x90', '<div style="width:970px; height:90px; border:1px solid #505050;" align="center"><br/>Ad space 16<br/>Any size up to 970px wide<br/><b>Note:</b> The border will be removed when you add your ad code. Its seen here as an example of how your ad may look.\n</div>'),
(17, '17  Top of member page', 'communityabove', '728x90', '<div style="width:970px; height:90px; border:1px solid #505050;" align="center"><br/>Ad space 17<br/>Any size up to 970px wide<br/><b>Note:</b> The border will be removed when you add your ad code. Its seen here as an example of how your ad may look.\n</div>'),
(18, '18 Bottom of member page', 'communitybelow', '728x90', '<div style="width:970px; height:90px; border:1px solid #505050;" align="center"><br/>Ad space 18<br/>Any size up to 970px wide<br/><b>Note:</b> The border will be removed when you add your ad code. Its seen here as an example of how your ad may look.\n</div>'),
(19, '19 Top of categorie page', 'catlistabove', '728x90', '<div style="width:970px; height:90px; border:1px solid #505050;" align="center"><br/>Ad space 19<br/>Any size up to 970px wide<br/><b>Note:</b> The border will be removed when you add your ad code. Its seen here as an example of how your ad may look.\n</div>\n\n\n'),
(20, '20 Bottom of categorie page', 'catlistunder', '728x90', '<div style="width:970px; height:90px; border:1px solid #505050;" align="center"><br/>Ad space 20<br/>Any size up to 970px wide<br/><b>Note:</b> The border will be removed when you add your ad code. Its seen here as an example of how your ad may look.\n</div>'),
(21, '21 Top of categorie page thumbs', 'catunder', '728x90', '<div style="width:970px; height:90px; border:1px solid #505050;" align="center"><br/>Ad space 21<br/>Any size up to 970px wide<br/><b>Note:</b> The border will be removed when you add your ad code. Its seen here as an example of how your ad may look.\n</div>'),
(22, '22 Bottom of categorie page thumbs', 'catabove', '728x90', '<div style="width:970px; height:90px; border:1px solid #505050;" align="center"><br/>Ad space 22<br/>Any size up to 970px wide<br/><b>Note:</b> The border will be removed when you add your ad code. Its seen here as an example of how your ad may look.\n</div>'),
(23, '23 In the footer on all pages', 'footer', '300x250', '<div style="width:970px; height:250px; border:1px solid #505050;" align="center"><br/>Ad space 23<br/>Any size up to 970px wide<br/><b>Note:</b> The border will be removed when you add your ad code. Its seen here as an example of how your ad may look.\n</div>');

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

--
-- Table structure for table `subscription`
--

CREATE TABLE IF NOT EXISTS `subscription` (
  `userid` int(11) NOT NULL default '0',
  `subscribedtoid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`userid`,`subscribedtoid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
