-- 
-- Database: `phpld`
-- 

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

-- 
-- Table structure for table `[[dbprefix]]CATEGORY`
-- 

CREATE TABLE `[[dbprefix]]CATEGORY` (
  `ID` int(11) NOT NULL auto_increment,
  `TITLE` varchar(255) NOT NULL default '',
  `TITLE_URL` varchar(255) default NULL,
  `DESCRIPTION` longtext,
  `PARENT_ID` int(11) NOT NULL default '0',
  `STATUS` int(11) NOT NULL default '1',
  `DATE_ADDED` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `HITS` int(11) NOT NULL default '0',
  `SYMBOLIC` int(11) NOT NULL default '0',
  `SYMBOLIC_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ID`),
  KEY `[[dbprefix]]CATEGORY_TITLE_IDX` (`TITLE`),
  KEY `[[dbprefix]]CATEGORY_TITLE_URL_IDX` (`TITLE_URL`),
  KEY `[[dbprefix]]CATEGORY_PARENT_ID_IDX` (`PARENT_ID`),
  KEY `[[dbprefix]]CATEGORY_STATUS_IDX` (`STATUS`),
  KEY `[[dbprefix]]CATEGORY_HITS_IDX` (`HITS`),
  FULLTEXT KEY `[[dbprefix]]CATEGORY_DESCRIPTION_IDX` (`DESCRIPTION`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `[[dbprefix]]CATEGORY`
-- 


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

-- 
-- Table structure for table `[[dbprefix]]CONFIG`
-- 

CREATE TABLE `[[dbprefix]]CONFIG` (
  `ID` varchar(255) NOT NULL default '',
  `VALUE` varchar(255) default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `[[dbprefix]]CONFIG`
-- 

INSERT INTO `[[dbprefix]]CONFIG` VALUES ('SITE_NAME', '[[site_name]]');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('SITE_URL', 'http://[[domhost]]');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('SITE_DESC', '[[site_desc]]');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('LINKS_PER_PAGE', '20');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('MAILS_PER_PAGE', '20');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('VISUAL_CONFIRM', '[[gd]]');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('REQUIRE_RECIPROCAL', '0');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('ALLOW_MULTIPLE', '1');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('CATS_PER_ROW', '2');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('ENABLE_REWRITE', '0');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('VERSION', 'CURRENT_VERSION');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('RECPR_NOFOLLOW', '1');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('EMAIL_METHOD', 'mail');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('EMAIL_SERVER', 'localhost');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('EMAIL_USER', '');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('EMAIL_PASS', '');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('EMAIL_SENDMAIL', '/usr/bin/sendmail');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('CATS_PREVIEW', '3');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('CATS_COUNT', '1');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('DIRECTORY_TITLE', '[[site_name]]');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('ENABLE_RSS', '1');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('ENABLE_PAGERANK', '1');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('DEBUG', '0');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('SHOW_PAGERANK', '1');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('DEFAULT_SORT', 'P');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('ENABLE_NEWS', '1');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('ADMIN_LANG', 'en');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('FRONTEND_LANG', 'en');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('LINKS_TOP', '20');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('NTF_SUBMIT_TPL', '');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('NTF_APPROVE_TPL', '');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('NTF_REJECT_TPL', '');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('NTF_PAYMENT_TPL', '');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('FTR_ENABLE', '0');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('FTR_MAX_LINKS', '5');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('PAY_ENABLE', '0');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('PAY_UM', '0');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('PAY_NORMAL', '0');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('PAY_FEATURED', '0');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('PAY_RECPR', '0');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('PAY_AUTO_ACCEPT', '');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('PAY_ENABLE_FREE', '0');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('PAYPAL_ENABLE', '0');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('PAYPAL_ACCOUNT', '');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('PAGER_LPP', '20');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('PAGER_GROUPINGS', '20');
INSERT INTO `[[dbprefix]]CONFIG` VALUES ('ENABLE_BLANK', '0');

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

-- 
-- Table structure for table `[[dbprefix]]EMAIL`
-- 

CREATE TABLE `[[dbprefix]]EMAIL` (
  `ID` int(11) NOT NULL auto_increment,
  `EMAIL` varchar(255) NOT NULL default '',
  `TITLE` varchar(255) NOT NULL default '',
  `NAME` varchar(255) default NULL,
  `URL` varchar(255) NOT NULL default '',
  `DATE_SENT` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `[[dbprefix]]EMAIL`
-- 


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

-- 
-- Table structure for table `[[dbprefix]]EMAIL_TPL`
-- 

CREATE TABLE `[[dbprefix]]EMAIL_TPL` (
  `ID` int(11) NOT NULL auto_increment,
  `TPL_TYPE` int(11) default '1',
  `TITLE` varchar(255) NOT NULL default '',
  `SUBJECT` varchar(255) NOT NULL default '',
  `BODY` longblob,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `[[dbprefix]]EMAIL_TPL`
-- 


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

-- 
-- Table structure for table `[[dbprefix]]LINK`
-- 

CREATE TABLE `[[dbprefix]]LINK` (
  `ID` int(11) NOT NULL auto_increment,
  `TITLE` varchar(255) NOT NULL default '',
  `DESCRIPTION` longtext,
  `URL` varchar(255) NOT NULL default '',
  `CATEGORY_ID` int(11) NOT NULL default '0',
  `RECPR_URL` varchar(255) default NULL,
  `RECPR_REQUIRED` tinyint(4) NOT NULL default '0',
  `STATUS` int(11) NOT NULL default '0',
  `VALID` tinyint(4) NOT NULL default '0',
  `RECPR_VALID` tinyint(4) NOT NULL default '0',
  `OWNER_ID` int(11) default NULL,
  `OWNER_NAME` varchar(255) default NULL,
  `OWNER_EMAIL` varchar(255) default NULL,
  `OWNER_NOTIF` int(11) NOT NULL default '0',
  `DATE_MODIFIED` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `DATE_ADDED` timestamp NOT NULL default '0000-00-00 00:00:00',
  `HITS` int(11) NOT NULL default '0',
  `LAST_CHECKED` datetime default NULL,
  `RECPR_LAST_CHECKED` datetime default NULL,
  `PAGERANK` int(11) NOT NULL default '-1',
  `RECPR_PAGERANK` int(11) NOT NULL default '-1',
  `FEATURED_MAIN` int(11) NOT NULL default '0',
  `FEATURED` int(11) NOT NULL default '0',
  `EXPIRY_DATE` datetime default NULL,
  `NOFOLLOW` tinyint(4) NOT NULL default '0',
  `PAYED` int(11) NOT NULL default '-1',
  `LINK_TYPE` int(11) NOT NULL default '0',
  `IPADDRESS` varchar(15) default NULL,
  PRIMARY KEY  (`ID`),
  KEY `[[dbprefix]]LINK_TITLE_IDX` (`TITLE`),
  KEY `[[dbprefix]]LINK_URL_IDX` (`URL`),
  KEY `[[dbprefix]]LINK_CATEGORY_ID_IDX` (`CATEGORY_ID`),
  KEY `[[dbprefix]]LINK_STATUS_CATEGORY_ID_IDX` (`STATUS`,`CATEGORY_ID`),
  KEY `[[dbprefix]]LINK_HITS_IDX` (`HITS`),
  KEY `[[dbprefix]]LINK_FEATURED_IDX` (`FEATURED`),
  KEY `[[dbprefix]]LINK_EXPIRY_DATE_IDX` (`EXPIRY_DATE`),
  FULLTEXT KEY `[[dbprefix]]LINK_DESCRIPTION_IDX` (`DESCRIPTION`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `[[dbprefix]]LINK`
-- 


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

-- 
-- Table structure for table `[[dbprefix]]PAYMENT`
-- 

CREATE TABLE `[[dbprefix]]PAYMENT` (
  `ID` int(11) NOT NULL auto_increment,
  `LINK_ID` varchar(15) NOT NULL default '',
  `NAME` varchar(255) default NULL,
  `EMAIL` varchar(255) default NULL,
  `IPADDRESS` varchar(15) NOT NULL default '',
  `AMOUNT` decimal(8,2) NOT NULL default '0.00',
  `QUANTITY` int(11) NOT NULL default '0',
  `TOTAL` decimal(8,2) NOT NULL default '0.00',
  `PAYED_TOTAL` decimal(8,2) NOT NULL default '0.00',
  `PAYED_QUANTITY` int(11) NOT NULL default '0',
  `UM` int(11) NOT NULL default '0',
  `CONFIRMED` int(11) NOT NULL default '0',
  `PAY_DATE` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `CONFIRM_DATE` datetime default NULL,
  `RAW_LOG` longtext,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `[[dbprefix]]PAYMENT`
-- 


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

-- 
-- Table structure for table `[[dbprefix]]USER`
-- 

CREATE TABLE `[[dbprefix]]USER` (
  `ID` int(11) NOT NULL auto_increment,
  `LOGIN` varchar(100) NOT NULL default '',
  `NAME` varchar(255) NOT NULL default '',
  `PASSWORD` varchar(46) NOT NULL default '',
  `EMAIL` varchar(255) NOT NULL default '',
  `ADMIN` tinyint(4) NOT NULL default '0',
  `SUBMIT_NOTIF` tinyint(4) NOT NULL default '1',
  `PAYMENT_NOTIF` tinyint(4) NOT NULL default '1',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `[[dbprefix]]USER`
-- 

INSERT INTO `[[dbprefix]]USER` VALUES (1, '[[admin_username]]', '[[admin_realname]]', '{sha1}[[admin_pass]]', '[[admin_email]]', 1, 0, 0);

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

-- 
-- Table structure for table `[[dbprefix]]USER_PERMISSION`
-- 

CREATE TABLE `[[dbprefix]]USER_PERMISSION` (
  `ID` int(11) NOT NULL auto_increment,
  `USER_ID` int(11) NOT NULL default '0',
  `CATEGORY_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `[[dbprefix]]USER_PERMISSION`
-- 


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

-- 
-- Table structure for table `[[dbprefix]]USER_SEQ`
-- 

CREATE TABLE `[[dbprefix]]USER_SEQ` (
  `id` int(11) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 
-- Dumping data for table `[[dbprefix]]USER_SEQ`
-- 

INSERT INTO `[[dbprefix]]USER_SEQ` VALUES (1);