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

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

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

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


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

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

CREATE TABLE IF NOT EXISTS `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`)
) TYPE=MyISAM  AUTO_INCREMENT=7 ;

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


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

--
-- 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'
) TYPE=MyISAM;

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


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

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

CREATE TABLE IF NOT EXISTS `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`)
) TYPE=MyISAM  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 IF NOT EXISTS `content` (
  `linkid` int(11) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `page` longtext NOT NULL,
  PRIMARY KEY  (`linkid`)
) TYPE=MyISAM;

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


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

--
-- 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`)
) TYPE=MyISAM;

--
-- 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 `extra`
--

CREATE TABLE IF NOT EXISTS `extra` (
  `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`)
) TYPE=MyISAM  AUTO_INCREMENT=15 ;

--
-- Dumping data for table `extra`
--

INSERT INTO `extra` VALUES(1, '', 0, 'Pro Media Player', 0, '', '', '0', '', '', '0', '', '', '0', '', '', '0', '', '', '0', 0, '');
INSERT INTO `extra` VALUES(2, '', 0, 'Copyright Message', 1, 'Message HTML', 'text', 'Your copyright message here', '', '', '0', '', '', '0', '', '', '0', '', '', '0', 0, '');
INSERT INTO `extra` 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 ''extras'' on the admin menu', 'Replace Thumbnails With Default Image', 'bool', '1', '', 'bool', '0', '', '', '0', '', '', '0', 0, '');
INSERT INTO `extra` VALUES(4, '', 0, 'Bad Words Filter', 0, NULL, '', '0', '', '', '0', '', '', '0', '', '', '0', '', '', '0', 0, '');
INSERT INTO `extra` VALUES(5, '', 0, 'Flash Scroller', 0, NULL, '', '0', '', '', '0', '', '', '0', '', '', '0', '', '', '0', 0, '');

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

--
-- 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`)
) TYPE=MyISAM;

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


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

--
-- 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`)
) TYPE=MyISAM;

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


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

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

CREATE TABLE IF NOT EXISTS `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`)
) TYPE=MyISAM  AUTO_INCREMENT=35 ;

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


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

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

CREATE TABLE IF NOT EXISTS `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`)
) TYPE=MyISAM  AUTO_INCREMENT=49 ;

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


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

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

CREATE TABLE IF NOT EXISTS `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`)
) TYPE=MyISAM;

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


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

--
-- 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 '',
  `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',
  PRIMARY KEY  (`id`),
  FULLTEXT KEY `title` (`title`),
  FULLTEXT KEY `tags` (`tags`),
  FULLTEXT KEY `discription` (`description`)
) TYPE=MyISAM  AUTO_INCREMENT=281 ;

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


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

--
-- 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',
  `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`)
) TYPE=MyISAM  AUTO_INCREMENT=34 ;

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


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

--
-- 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(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`)
) TYPE=MyISAM  AUTO_INCREMENT=39 ;

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


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

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

CREATE TABLE IF NOT EXISTS `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`)
) TYPE=MyISAM  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>\r\n<li><a href="<?=$sitepath?>?id=117">Manage Video Ads</a></li><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?>?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">Buy & Manage Extras</a></li>\r\n<li><a href="http://forums.vidiscript.com">VidiScript Forums</a></li>\r\n</ul></div></div>', 10, 0, 1, 0, 0, 0);

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

--
-- 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`)
) TYPE=MyISAM  AUTO_INCREMENT=173 ;

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


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

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

CREATE TABLE IF NOT EXISTS `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`)
) TYPE=MyISAM  AUTO_INCREMENT=17 ;

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


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

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

CREATE TABLE IF NOT EXISTS `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`)
) TYPE=MyISAM  AUTO_INCREMENT=110 ;

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


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

--
-- 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`)
) TYPE=MyISAM;

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


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

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

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

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

INSERT INTO `setting` VALUES('sitename', 'VidiScript.com');
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', 'email@yoursite.com');
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', '400');
INSERT INTO `setting` VALUES('framerate', '25');
INSERT INTO `setting` VALUES('encodesize', 'qvga');
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', 'My Video Site');
INSERT INTO `setting` VALUES('membersperpage', '10');
INSERT INTO `setting` VALUES('watermarkpath', '');
INSERT INTO `setting` VALUES('sitefolder', 'test/myvideosite');
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('encoder', 'ffmpeg');
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');

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

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

CREATE TABLE IF NOT EXISTS `sitead` (
  `adname` varchar(20) NOT NULL default '',
  `adtext` text NOT NULL,
  PRIMARY KEY  (`adname`)
) TYPE=MyISAM;

--
-- 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 IF NOT EXISTS `subscription` (
  `userid` int(11) NOT NULL default '0',
  `subscribedtoid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`userid`,`subscribedtoid`)
) TYPE=MyISAM;

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