-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 20, 2010 at 02:41 PM
-- Server version: 5.1.40
-- PHP Version: 5.2.6

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: `bmcforu_transfer`
--

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

--
-- Table structure for table `rssfeed`
--

CREATE TABLE IF NOT EXISTS `rssfeed` (
  `rssfeedid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(250) NOT NULL DEFAULT '',
  `url` text,
  `port` smallint(5) unsigned NOT NULL DEFAULT '80',
  `ttl` smallint(5) unsigned NOT NULL DEFAULT '1500',
  `maxresults` smallint(6) NOT NULL DEFAULT '0',
  `userid` int(10) unsigned NOT NULL DEFAULT '0',
  `forumid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `iconid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `titletemplate` mediumtext NOT NULL,
  `bodytemplate` mediumtext NOT NULL,
  `searchwords` mediumtext NOT NULL,
  `itemtype` enum('thread','announcement') NOT NULL DEFAULT 'thread',
  `threadactiondelay` smallint(5) unsigned NOT NULL DEFAULT '0',
  `endannouncement` int(10) unsigned NOT NULL DEFAULT '0',
  `options` int(10) unsigned NOT NULL DEFAULT '0',
  `lastrun` int(10) unsigned NOT NULL DEFAULT '0',
  `prefixid` varchar(25) NOT NULL DEFAULT '',
  PRIMARY KEY (`rssfeedid`),
  KEY `lastrun` (`lastrun`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `rssfeed`
--