/*
 Navicat Premium Data Transfer

 Source Server         : local
 Source Server Type    : MySQL
 Source Server Version : 50138
 Source Host           : localhost
 Source Database       : antville

 Target Server Type    : MySQL
 Target Server Version : 50138
 File Encoding         : iso-8859-1

 Date: 09/23/2009 10:29:16 AM
*/

SET NAMES latin1;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `parss_feed`
-- ----------------------------
DROP TABLE IF EXISTS `parss_feed`;
CREATE TABLE `parss_feed` (
  `id` int(10) unsigned NOT NULL,
  `url` text NOT NULL,
  `title` text NOT NULL,
  `status` enum('invalid','subscribe','verified','unsubscribe') NOT NULL DEFAULT 'invalid',
  `metadata` text NOT NULL,
  `creator_id` int(10) unsigned NOT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `modified` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
--  Table structure for `parss_subscription`
-- ----------------------------
DROP TABLE IF EXISTS `parss_subscription`;
CREATE TABLE `parss_subscription` (
  `id` int(10) unsigned NOT NULL,
  `site_id` int(10) unsigned NOT NULL,
  `feed_id` int(10) unsigned NOT NULL,
  `rating` int(10) unsigned NOT NULL,
  `creator_id` int(10) unsigned NOT NULL,
  `created` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

