SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `vidi103a`
--

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

--
-- Table structure for table `approval`
--

CREATE TABLE `approval` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Sitename` varchar(255) NOT NULL DEFAULT '',
  `Url` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `approval`
--


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

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

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

--
-- Dumping data for table `ban`
--


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

--
-- Table structure for table `bannerads`
--

CREATE TABLE `bannerads` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(50) NOT NULL DEFAULT '',
  `description` varchar(100) NOT NULL DEFAULT '',
  `link` varchar(255) NOT NULL DEFAULT '',
  `thumbnail` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `bannerads`
--


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

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

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

--
-- Dumping data for table `blocked`
--


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

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

CREATE TABLE `category` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `ptr` int(11) NOT NULL DEFAULT '0',
  `parent` int(11) NOT NULL DEFAULT '0',
  `url` varchar(255) NOT NULL DEFAULT '',
  `level` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=56 ;

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

INSERT INTO `category` VALUES(1, 'Main Category', 0, 0, 'Main_Category', 1);

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

--
-- Table structure for table `content`
--

CREATE TABLE `content` (
  `linkid` int(11) NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL DEFAULT '',
  `page` longtext NOT NULL,
  PRIMARY KEY (`linkid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `content`
--


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

--
-- Table structure for table `contest`
--

CREATE TABLE `contest` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `bkgrndP` varchar(7) NOT NULL DEFAULT '0',
  `bkgrndH` varchar(7) NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `img` varchar(255) NOT NULL DEFAULT '',
  `prizes` varchar(255) NOT NULL DEFAULT '',
  `numwinners` int(5) NOT NULL DEFAULT '0',
  `start` date NOT NULL DEFAULT '0000-00-00',
  `finish` date NOT NULL DEFAULT '0000-00-00',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `contest`
--


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

--
-- Table structure for table `counter`
--

CREATE TABLE `counter` (
  `hits` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`hits`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `counter`
--


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

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

CREATE TABLE `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`
--

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');
INSERT INTO `email_text` VALUES('email_newmedia', 'Hello, \r\nNew media has been posted by [POSTER]. To view it click the following link.\r\n\r\n[MEDIALINK]\r\n\r\nYou have received this message because you are subscribed to the above user.\r\n\r\nThanks\r\n\r\n[SITENAME]');
INSERT INTO `email_text` VALUES('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]');
INSERT INTO `email_text` VALUES('email_upload', 'Hello, \nNew media has been posted by [POSTER]. To view it click the following link: [MEDIALINK]\nLink to file: [FILELINK]\nManage Videos: [MANAGELINK]');
INSERT INTO `email_text` VALUES('admin_acc_act', 'Hello, [USERNAME];\r\n\r\nYour account has been activated by an administrator, on [SITENAME].');
INSERT INTO `email_text` VALUES('taf_subject', 'Subject of tell a friend email');
INSERT INTO `email_text` VALUES('taf_body', 'Hey,\r\n\r\n[NAME] has sent you this email from [SITENAME] because they want to share this media with you:\r\n\r\n[URL]\r\n\r\nThanks!\r\n\r\n');

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

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

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

--
-- Dumping data for table `favorite`
--


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

--
-- Table structure for table `feature`
--

CREATE TABLE `feature` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `key` varchar(255) DEFAULT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `var_count` int(255) NOT NULL DEFAULT '0',
  `data_name_1` varchar(50) DEFAULT NULL,
  `data_type1` varchar(11) NOT NULL DEFAULT '',
  `data_1` text,
  `data_name_2` varchar(50) NOT NULL DEFAULT '',
  `data_type2` varchar(11) NOT NULL DEFAULT '',
  `data_2` text,
  `data_name_3` varchar(50) NOT NULL DEFAULT '',
  `data_type3` varchar(11) NOT NULL DEFAULT '',
  `data_3` text,
  `data_name_4` varchar(50) NOT NULL DEFAULT '',
  `data_type4` varchar(11) NOT NULL DEFAULT '',
  `data_4` text,
  `data_name_5` varchar(50) NOT NULL DEFAULT '',
  `data_type5` varchar(11) NOT NULL DEFAULT '',
  `data_5` text,
  `installable` tinyint(1) NOT NULL DEFAULT '0',
  `filename` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;

--
-- Dumping data for table `feature`
--

INSERT INTO `feature` VALUES(3, '', 0, 'Mature Content Agreement', 2, 'Agreement Text (HTML)', 'text', 'Some text goes here for the mature content agreement, the site owner can edit the message in Site Features on the admin menu', 'Replace Thumbnails With Default Image', 'bool', '1', '', 'bool', '0', '', '', '0', '', '', '0', 0, '');
INSERT INTO `feature` VALUES(4, '', 0, 'Bad Words Filter', 0, NULL, '', '0', '', '', '0', '', '', '0', '', '', '0', '', '', '0', 0, '');
INSERT INTO `feature` VALUES(5, '', 0, 'Flash Scroller', 0, NULL, '', '0', '', '', '0', '', '', '0', '', '', '0', '', '', '0', 0, '');
INSERT INTO `feature` VALUES(15, '', 0, 'Watching Now Flash', 0, NULL, '', '0', '', '', '0', '', '', '0', '', '', '0', '', '', '0', 0, '');
INSERT INTO `feature` VALUES(16, '', 1, 'Video Preview Thumbnails', 2, 'Frames Per Second', 'TEXT', '12', 'Length Of Preview (Seconds)', 'TEXT', '7', '', '', '0', '', '', '0', '', '', '0', 0, '');

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

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

CREATE TABLE `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;

--
-- Dumping data for table `friend`
--


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

--
-- Table structure for table `group`
--

CREATE TABLE `group` (
  `group_id` int(11) NOT NULL AUTO_INCREMENT,
  `owner_id` int(11) NOT NULL DEFAULT '0',
  `name` varchar(64) NOT NULL DEFAULT '',
  `group_description` text NOT NULL,
  `privacy` tinyint(4) NOT NULL DEFAULT '0',
  `icon` varchar(255) NOT NULL DEFAULT '',
  `suspended` tinyint(1) NOT NULL DEFAULT '0',
  `created` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`group_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=35 ;

--
-- Dumping data for table `group`
--


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

--
-- Table structure for table `group_comment`
--

CREATE TABLE `group_comment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `group_id` int(11) NOT NULL DEFAULT '0',
  `poster_id` int(11) NOT NULL DEFAULT '0',
  `comment` text NOT NULL,
  `date` varchar(255) NOT NULL DEFAULT '',
  `leftbyname` varchar(40) NOT NULL DEFAULT '',
  `regdposter` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=49 ;

--
-- Dumping data for table `group_comment`
--


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

--
-- Table structure for table `group_member`
--

CREATE TABLE `group_member` (
  `group_id_g` int(11) NOT NULL DEFAULT '0',
  `member_id` int(11) NOT NULL DEFAULT '0',
  `approved` tinyint(1) NOT NULL DEFAULT '0',
  `joined` varchar(64) NOT NULL DEFAULT '',
  PRIMARY KEY (`group_id_g`,`member_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `group_member`
--


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

--
-- Table structure for table `ips`
--

CREATE TABLE `ips` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ip` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

--
-- Dumping data for table `ips`
--


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

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

CREATE TABLE `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 '',
  `mediaurl` varchar(255) NOT NULL DEFAULT '',
  `extern` varchar(255) NOT NULL DEFAULT 'false',
  `thumb` varchar(255) NOT NULL DEFAULT '',
  `visits` int(25) NOT NULL DEFAULT '0',
  `poster` varchar(255) NOT NULL DEFAULT '0',
  `added` varchar(255) NOT NULL DEFAULT '',
  `status` varchar(255) NOT NULL DEFAULT 'false',
  `useraw` varchar(5) NOT NULL DEFAULT 'false',
  `embed` longtext NOT NULL,
  `url` varchar(255) NOT NULL DEFAULT '',
  `featured` tinyint(1) NOT NULL DEFAULT '0',
  `groupid` int(11) NOT NULL DEFAULT '0',
  `requires_agreement` 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 '',
  `defaultthumb` tinyint(1) NOT NULL DEFAULT '0',
  `flagged` tinyint(1) NOT NULL DEFAULT '0',
  `mediaAD` text,
  `size` int(11) NOT NULL,
  `md5` varchar(64) NOT NULL,
  `lastviewed` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `title` (`title`),
  FULLTEXT KEY `tags` (`tags`),
  FULLTEXT KEY `discription` (`description`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=281 ;

--
-- Dumping data for table `media`
--


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

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

CREATE TABLE `media_comment` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `vid_id` int(25) NOT NULL DEFAULT '0',
  `name` varchar(25) NOT NULL DEFAULT '',
  `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=34 ;

--
-- Dumping data for table `media_comment`
--


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

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

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

--
-- Dumping data for table `member`
--

INSERT INTO `member` VALUES(40, '[[admin_username]]', '[[admin_pass]]', '[[admin_email]]', '', '', '', '0', 7, '', '', 1, 1, 0, 0, NULL, NULL, '', '', '', 0, 0, 0, '', 0, 0);

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

--
-- Table structure for table `menu`
--

CREATE TABLE `menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `header` varchar(255) NOT NULL DEFAULT '',
  `attributes` text NOT NULL,
  `content` text NOT NULL,
  `position` int(11) NOT NULL DEFAULT '0',
  `useronly` tinyint(4) NOT NULL DEFAULT '0',
  `adminonly` tinyint(4) NOT NULL DEFAULT '0',
  `showindex` tinyint(4) NOT NULL DEFAULT '0',
  `showlist` tinyint(4) NOT NULL DEFAULT '0',
  `showplayer` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `menu`
--

INSERT INTO `menu` VALUES(1, 'Categories', '', '<div id="right-col-content"><div class="spacing"><h2><img src="<?=templateimagepath()?>icn_categories.jpg" alt="" />Categories</h2>					<ul id="categories" class="no-format"><?=categoryList()?></ul></div></div>', 20, 0, 0, 0, 0, 0);
INSERT INTO `menu` VALUES(2, 'Admin Menu', '', '<div id="right-col-content"><div class="spacing"><h2>Admin Menu</h2><?require_once "includes/admin/index.inc"?><ul>\r\n<li><a href="<?=$sitepath?>?id=104">New Uploads (<?=$numNewVideos?> New)</a></li>\r\n<li><a href="<?=$sitepath?>?id=103">Manage Media</a></li>\r\n<li><a href="<?=$sitepath?>?id=105">Manage Users</a></li><li><a href="<?=$sitepath?>?id=117">Manage Video Ads</a></li>\r\n<li><a href="<?=$sitepath?>?id=118">Manage Site Ads</a></li>\r\n<li><a href="<?=$sitepath?>?id=102">Manage Categories</a></li>\r\n<li><a href="<?=$sitepath?>?id=111">Manage Email Text</a></li>\r\n<li><a href="<?=$sitepath?>?id=109">Manage Menus</a></li>\r\n<li><a href="<?=$sitepath?>news">Manage News</a></li>\r\n<li><a href="<?=$sitepath?>?id=113">Bad Words Filter</a></li>\r\n<li><a href="<?=$sitepath?>?id=106">Site Settings</a></li>\r\n<li><a href="<?=$sitepath?>?id=150">Site Features</a></li>\r\n</ul></div></div>', 10, 0, 1, 0, 0, 0);
INSERT INTO `menu` VALUES(3, 'VidiScript Support', '', '<div id="right-col-content"><div class="spacing"><h2>VidiScript Support</h2><?require_once "includes/admin/index.inc"?><ul>\r\n<li><a href="http://www.vidiscript.co.uk/vidiscriptinstallation-instructions">Installation Help</a></li>\r\n<li><a href="http://www.vidiscript.co.uk/vidiscript-requirements">Server Set-Up</a></li>\r\n<li><a href="http://www.vidiscript.co.uk/vidiscript-webhosting">VidiScript Hosting</a></li>\r\n<li><a href="http://www.vidiscript.co.uk/vidiscript-support">Vidiscript Support</a></li>\r\n<li><a href="http://www.vidiscript.co.uk/support-forum">VidiScript Forums</a></li>\r\n</ul></div></div>', 11, 0, 1, 0, 0, 0);

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

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

CREATE TABLE `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=173 ;

--
-- Dumping data for table `message`
--


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

--
-- Table structure for table `news`
--

CREATE TABLE `news` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `message` text NOT NULL,
  `date` date NOT NULL DEFAULT '0000-00-00',
  `title` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

--
-- Dumping data for table `news`
--


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

--
-- Table structure for table `prepostrollads`
--

CREATE TABLE `prepostrollads` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `path` varchar(255) NOT NULL DEFAULT '',
  `text` varchar(100) NOT NULL DEFAULT '',
  `link` varchar(255) NOT NULL DEFAULT '',
  `preorpost` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;

--
-- Dumping data for table `prepostrollads`
--


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

--
-- Table structure for table `profile_comment`
--

CREATE TABLE `profile_comment` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `userid` int(11) NOT NULL DEFAULT '0',
  `leftbyname` varchar(40) NOT NULL DEFAULT '0',
  `comment` text NOT NULL,
  `date` varchar(255) NOT NULL DEFAULT '',
  `regdposter` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=110 ;

--
-- Dumping data for table `profile_comment`
--


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

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

CREATE TABLE `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;

--
-- Dumping data for table `rating`
--


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

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

CREATE TABLE `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` VALUES('sitename', '[[site_name]]');
INSERT INTO `setting` VALUES('activation', '1');
INSERT INTO `setting` VALUES('restrictpc', '1');
INSERT INTO `setting` VALUES('audiobitrate', '64');
INSERT INTO `setting` VALUES('accountpageon', '1');
INSERT INTO `setting` VALUES('thumb_w1', '96');
INSERT INTO `setting` VALUES('thumb_w2', '96');
INSERT INTO `setting` VALUES('thumb_h1', '96');
INSERT INTO `setting` VALUES('thumb_h2', '96');
INSERT INTO `setting` VALUES('autostart', '1');
INSERT INTO `setting` VALUES('sitetemplate', 'Mainstream');
INSERT INTO `setting` VALUES('avatar_w', '96');
INSERT INTO `setting` VALUES('avatar_h', '96');
INSERT INTO `setting` VALUES('contact_email', '[[admin_email]]');
INSERT INTO `setting` VALUES('moderate_media', '0');
INSERT INTO `setting` VALUES('watermarklink', '');
INSERT INTO `setting` VALUES('mediamaxsize', '10000000000');
INSERT INTO `setting` VALUES('admin_perpage', '30');
INSERT INTO `setting` VALUES('admin_notified', '1');
INSERT INTO `setting` VALUES('vidbuffer', '5');
INSERT INTO `setting` VALUES('admin_automod', '1');
INSERT INTO `setting` VALUES('show_embedcode', '1');
INSERT INTO `setting` VALUES('videobitrate', '750');
INSERT INTO `setting` VALUES('framerate', '25');
INSERT INTO `setting` VALUES('encodesize', '320x240');
INSERT INTO `setting` VALUES('thumbtime', '4');
INSERT INTO `setting` VALUES('url_clean', '1');
INSERT INTO `setting` VALUES('comment_length', '300');
INSERT INTO `setting` VALUES('default_from', 'admin');
INSERT INTO `setting` VALUES('savatar_h', '96');
INSERT INTO `setting` VALUES('savatar_w', '96');
INSERT INTO `setting` VALUES('default_thumbtime', '8');
INSERT INTO `setting` VALUES('searchpp', '10');
INSERT INTO `setting` VALUES('textlink_url', '');
INSERT INTO `setting` VALUES('textlink_text', '');
INSERT INTO `setting` VALUES('restrictdown', '0');
INSERT INTO `setting` VALUES('sitetitle', '[[site_desc]]');
INSERT INTO `setting` VALUES('membersperpage', '10');
INSERT INTO `setting` VALUES('watermarkpath', '');
INSERT INTO `setting` VALUES('sitefolder', '[[relativeurl]]/');
INSERT INTO `setting` VALUES('buffertime', '4');
INSERT INTO `setting` VALUES('relateduserpage', '6');
INSERT INTO `setting` VALUES('ffmpegpath', '/usr/bin/ffmpeg');
INSERT INTO `setting` VALUES('mencoderpath', '/usr/bin/mencoder');
INSERT INTO `setting` VALUES('flvtool2path', '/usr/bin/flvtool2');
INSERT INTO `setting` VALUES('encoder', 'ffmpeg');
INSERT INTO `setting` VALUES('player', 'vidi');
INSERT INTO `setting` VALUES('audiofrequency', '22050');
INSERT INTO `setting` VALUES('restrictdv', '0');
INSERT INTO `setting` VALUES('groupmempp', '10');
INSERT INTO `setting` VALUES('blockedpp', '10');
INSERT INTO `setting` VALUES('subscriptionspp', '10');
INSERT INTO `setting` VALUES('favoritespp', '10');
INSERT INTO `setting` VALUES('mediapp', '10');
INSERT INTO `setting` VALUES('historypp', '10');
INSERT INTO `setting` VALUES('groupslistpp', '10');
INSERT INTO `setting` VALUES('friendspp', '10');
INSERT INTO `setting` VALUES('recfriendpp', '10');
INSERT INTO `setting` VALUES('sentfriendpp', '10');
INSERT INTO `setting` VALUES('messagepp', '10');
INSERT INTO `setting` VALUES('sentmesspp', '10');
INSERT INTO `setting` VALUES('friendlistpp', '5');
INSERT INTO `setting` VALUES('groupmediapp', '20');
INSERT INTO `setting` VALUES('groupcommentspp', '5');
INSERT INTO `setting` VALUES('newestpp', '5');
INSERT INTO `setting` VALUES('groupaddnotify', '1');
INSERT INTO `setting` VALUES('topratedpp', '10');
INSERT INTO `setting` VALUES('mainpp', '7');
INSERT INTO `setting` VALUES('maxgroupiconsize', '400');
INSERT INTO `setting` VALUES('allgroupspp', '10');
INSERT INTO `setting` VALUES('profsubspp', '5');
INSERT INTO `setting` VALUES('profmedpp', '5');
INSERT INTO `setting` VALUES('proffrdpp', '5');
INSERT INTO `setting` VALUES('proffavpp', '5');
INSERT INTO `setting` VALUES('categorypp', '10');
INSERT INTO `setting` VALUES('profilehistorypp', '10');
INSERT INTO `setting` VALUES('profgrppp', '5');
INSERT INTO `setting` VALUES('captchaformembers', '0');
INSERT INTO `setting` VALUES('showpreroll', '1');
INSERT INTO `setting` VALUES('showpostroll', '1');
INSERT INTO `setting` VALUES('prerollimagedelay', '2');
INSERT INTO `setting` VALUES('postrollimagedelay', '2');
INSERT INTO `setting` VALUES('bannerstart', '1');
INSERT INTO `setting` VALUES('bannerend', '12');
INSERT INTO `setting` VALUES('featuredpp', '5');
INSERT INTO `setting` VALUES('mostviewedpp', '10');
INSERT INTO `setting` VALUES('showbanner', '1');
INSERT INTO `setting` VALUES('groupmemberpp', '20');
INSERT INTO `setting` VALUES('sitelicense', '');
INSERT INTO `setting` VALUES('upload_videos', '1');
INSERT INTO `setting` VALUES('upload_images', '1');
INSERT INTO `setting` VALUES('upload_games', '1');
INSERT INTO `setting` VALUES('upload_music', '1');
INSERT INTO `setting` VALUES('allow_embed', '0');
INSERT INTO `setting` VALUES('game_width', '476');
INSERT INTO `setting` VALUES('game_height', '371');
INSERT INTO `setting` VALUES('leavefileonserver', '0');
INSERT INTO `setting` VALUES('titledisplaylength', '100');
INSERT INTO `setting` VALUES('traffic', '10');
INSERT INTO `setting` VALUES('tags', '12');
INSERT INTO `setting` VALUES('approval', '0');
INSERT INTO `setting` VALUES('stags', '1');
INSERT INTO `setting` VALUES('straffic', '0');
INSERT INTO `setting` VALUES('PRupload', '3');
INSERT INTO `setting` VALUES('PRcommentM', '2');
INSERT INTO `setting` VALUES('PRcommentP', '2');
INSERT INTO `setting` VALUES('PRinvite', '1');
INSERT INTO `setting` VALUES('Ronoroff', '0');
INSERT INTO `setting` VALUES('news', '');
INSERT INTO `setting` VALUES('useredit', '0');
INSERT INTO `setting` VALUES('language', 'en');
INSERT INTO `setting` VALUES('new_template', '1');
INSERT INTO `setting` VALUES('new_uploader', '0');

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

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

CREATE TABLE `sitead` (
  `adname` varchar(20) NOT NULL DEFAULT '',
  `adtext` text NOT NULL,
  PRIMARY KEY (`adname`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `sitead` VALUES('ad1', '');
INSERT INTO `sitead` VALUES('ad2', '');
INSERT INTO `sitead` VALUES('ad3', '');
INSERT INTO `sitead` VALUES('ad4', '');

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

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

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

--
-- Dumping data for table `subscription`
--


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

--
-- Table structure for table `traffic`
--

CREATE TABLE `traffic` (
  `id` int(80) NOT NULL AUTO_INCREMENT,
  `Sitename` varchar(50) NOT NULL DEFAULT '',
  `Url` varchar(100) NOT NULL DEFAULT '',
  `In` int(80) NOT NULL DEFAULT '0',
  `Out` int(80) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

--
-- Dumping data for table `traffic`
--