File: //var/softaculous/weby/weby.sql
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!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: `weby12`
--
-- --------------------------------------------------------
--
-- Table structure for table `admin_area`
--
CREATE TABLE `admin_area` (
`ip` varchar(50) default '',
`usr` varchar(255) NOT NULL,
`pass` varchar(255) NOT NULL,
`last_login` varchar(150) default NULL,
PRIMARY KEY (`usr`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `admin_area`
--
INSERT INTO `admin_area` VALUES
('', '[[admin_username]]', '[[admin_pass]]', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `categories`
--
CREATE TABLE `categories` (
`id` int(11) unsigned NOT NULL auto_increment,
`catname` text,
`parrentcatid` int(11) unsigned NOT NULL,
`info` text,
`meta_desc` varchar(255) default '',
`catpath` text,
`chid` text,
`numlinks` int(11) unsigned default '0',
PRIMARY KEY (`id`),
KEY `parrentcatid` (`parrentcatid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `comments`
--
CREATE TABLE `comments` (
`ip` varchar(50) default NULL,
`name` varchar(100) default NULL,
`comment` text,
`idpic` int(11) unsigned default NULL,
`approved` varchar(3) default 'no',
`id` int(11) unsigned NOT NULL auto_increment,
PRIMARY KEY (`id`),
KEY `idpic` (`idpic`),
KEY `approved` (`approved`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `contacts`
--
CREATE TABLE `contacts` (
`id` int(11) unsigned NOT NULL auto_increment,
`ip` varchar(50) default NULL,
`fullname` varchar(255) default NULL,
`subject` varchar(255) default '',
`message` varchar(255) default NULL,
`timehour` varchar(50) default NULL,
`mail` varchar(100) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `hits`
--
CREATE TABLE `hits` (
`ipkey` varchar(40) NOT NULL,
`timestamp` int(11) unsigned default NULL,
PRIMARY KEY (`ipkey`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `link`
--
CREATE TABLE `link` (
`id` int(10) unsigned NOT NULL auto_increment,
`ip` varchar(50) NOT NULL default '',
`timehour` varchar(30) NOT NULL default '',
`name` varchar(80) default NULL,
`mail` varchar(80) NOT NULL default '',
`caption` varchar(255) NOT NULL default '',
`url` varchar(255) NOT NULL,
`sitedesc` text,
`hits` int(10) unsigned NOT NULL default '0',
`categoryid` int(10) unsigned NOT NULL default '0',
`approved` varchar(3) NOT NULL default 'no',
`featured` smallint(3) unsigned NOT NULL default '0',
`pr` smallint(3) default '-1',
`reciurl` varchar(255) default '',
`stime` varchar(20) default NULL,
PRIMARY KEY (`id`),
KEY `featured` (`featured`,`approved`,`categoryid`),
KEY `approved` (`approved`),
KEY `categoryid` (`categoryid`),
KEY `reciurl` (`reciurl`),
KEY `url` (`url`),
FULLTEXT KEY `cdu` (`caption`,`sitedesc`,`url`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `mailreports`
--
CREATE TABLE `mailreports` (
`id` int(10) unsigned NOT NULL auto_increment,
`maildata` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `mailtemplates`
--
CREATE TABLE `mailtemplates` (
`id` int(10) unsigned NOT NULL auto_increment,
`mtplname` varchar(255) default NULL,
`mtplsubject` varchar(255) default NULL,
`mtplmessage` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `mailtemplates`
--
INSERT INTO `mailtemplates` VALUES
(1, 'Submission', 'Your link is received at {$TITLE}', 'Hello {$LINK_OWNER},<br />\r\n<br />\r\nYour site is received at our directory and it is<br />\r\nin pending state. After approval it will appear here:<br />\r\n<br />\r\n{$LINK_CATEGORY}<br />\r\n<br />\r\nThanks,<br />\r\nAdmin center'),
(3, 'Reject', 'Your link was rejected', 'Hello {$LINK_OWNER},<br />\r\n<br />\r\nYour link was rejected at {$TITLE} directory,<br />\r\nPossible reasons why the link is rejected:<br />\r\n<br />\r\nYou submitted the link in wrong category.<br />\r\nYou submitted MFA(made for adsense) site.<br />\r\nYour site does not comply with our guidelines.<br />\r\n<br />\r\nAdmin center {$URL}'),
(2, 'Approval', 'Your link is activated at {$TITLE}', 'Hello {$LINK_OWNER},<br />\r\n<br />\r\nWe are glad to inform you that your link was accepted at our directory.<br />\r\n<br />\r\nYou can find your link here:<br />\r\n{$LINK_CATEGORY}<br />\r\n<br />\r\nThanks,<br />\r\nAdmin center {$URL}');
-- --------------------------------------------------------
--
-- Table structure for table `options`
--
CREATE TABLE `options` (
`id` varchar(255) NOT NULL default '',
`value` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `options`
--
INSERT INTO `options` VALUES
('SITE_DESC', '[[site_desc]]'),
('SITE_TITLE', '[[site_name]]'),
('ENABLE_NUMLINKS', '0'),
('RSS_ENABLE', '0'),
('REWRITE_ENABLED', '0'),
('META_DESC', ''),
('TEMPLATE', 'b'),
('HAVE_FEATURED', '0'),
('SITE_ROOT', '[[relativeurl]]'),
('PREMIUM_PRICE', ''),
('SITE_URL', '[[softurl]]/'),
('PHPLD', '0'),
('REGULAR_PRICE', ''),
('LINKS_PER_PAGE', '10'),
('FEAT_PER_CAT', '20'),
('LINKS_PER_PAGE_TOP', '15'),
('ALLOW_MULTIPLE', '0'),
('SEND_MAIL_ON_SUBMISSION', '0'),
('SEND_MAIL_ON_APPROVAL', '0'),
('RECIPROCAL_PRICE', ''),
('SEND_MAIL_ON_DECLINE', '0'),
('ADMIN_MAIL', '[[admin_email]]'),
('SEND_MAIL_ON_SUBMISSION_TEMPLATE', '1'),
('SEND_MAIL_ON_APPROVAL_TEMPLATE', '2'),
('ADMIN_NAME', '[[admin_fname]]'),
('SEND_MAIL_ON_DECLINE_TEMPLATE', '3'),
('SHOW_RECIPROCAL_LINK', '1'),
('HTML_CURRENCY_CODE', '$'),
('CATEGS_PER_COLUMN', '4'),
('SUBCATEGS_PER_COLUMN', '4'),
('PAYPAL_MAIL', ''),
('FRONT_SUBCATEGS_PER_COLUMN', '5'),
('SITE_DESC_MAX_CHARS', '500'),
('AUTO_VALIDATE', '0'),
('SHOW_LATEST_LINKS', '1'),
('CHECK_PAGERANK', '0'),
('CATEGORY_DESCRIPTION', '1'),
('META_CATEGORY_DESCRIPTION', '1'),
('LINK_NEW_WINDOW', '0'),
('SHOW_PREMIUM_LINKS', '1'),
('CAPTCHA', '0'),
('ITEM_DUPLICATE_CHECKING_TYPE', 'exact'),
('ITEM_DEFAULT_ORDER', 'id desc'),
('SITE_RECI', '[[softurl]]/'),
('SITE_RECI_TITLE', 'Directory'),
('ITEM_BAN_KEYWORD', ''),
('ITEM_BAN_IP', ''),
('RECIPROCAL_PAYMENT_TYPE', 'I'),
('FEATURED_PAYMENT_TYPE', 'I'),
('REGULAR_PAYMENT_TYPE', 'I'),
('REGULAR_PAYMENT_TYPE_NUM', '1'),
('FEATURED_PAYMENT_TYPE_NUM', '1'),
('RECIPROCAL_PAYMENT_TYPE_NUM', '1'),
('ENABLE_RATINGS', '0'),
('ENABLE_COMMENTS', '0'),
('ITEM_HITS_UNIQUE', '1');
-- --------------------------------------------------------
--
-- Table structure for table `payments`
--
CREATE TABLE `payments` (
`id` int(11) unsigned NOT NULL auto_increment,
`payer_mail` varchar(255) default NULL,
`pay_processor` varchar(255) default '',
`link_id` int(11) unsigned default NULL,
`transx_id` varchar(255) default NULL,
`data` varchar(255) default NULL,
`payer_name` varchar(255) default '',
`quantity` int(11) default NULL,
`price` decimal(11,3) default NULL,
`last_s` smallint(3) unsigned default '1',
PRIMARY KEY (`id`),
KEY `link_id` (`link_id`),
KEY `last_s` (`last_s`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `rating`
--
CREATE TABLE `rating` (
`ipkey` varchar(30) NOT NULL,
`rating` smallint(3) unsigned default NULL,
`idpic` int(11) unsigned NOT NULL,
PRIMARY KEY (`ipkey`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `ratings`
--
CREATE TABLE `ratings` (
`idpic` int(11) unsigned NOT NULL,
`numbervotes` mediumint(9) unsigned default '0',
`sumvotes` mediumint(9) unsigned default '0',
`itemrating` decimal(5,2) default NULL,
PRIMARY KEY (`idpic`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;