-- phpMyAdmin SQL Dump
-- version 2.11.8.1deb5+lenny4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 06, 2010 at 05:40 PM
-- Server version: 5.0.51
-- PHP Version: 5.2.6-1+lenny8

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `jobberbase`
--

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

--
-- Table structure for table `feed_db`
--

CREATE TABLE IF NOT EXISTS `feed_db` (
  `id` int(11) NOT NULL auto_increment,
  `database` varchar(255) NOT NULL,
  `is_active` int(4) NOT NULL default '0',
  `type_id` int(4) NOT NULL,
  `category_id` int(4) NOT NULL,
  `category_label` varchar(255) NOT NULL,
  `company` varchar(255) NOT NULL,
  `poster_email` varchar(255) NOT NULL,
  `url` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=23 ;

--
-- Dumping data for table `feed_db`
--

INSERT INTO `feed_db` (`id`, `database`, `is_active`, `type_id`, `category_id`, `category_label`, `company`, `poster_email`, `url`) VALUES
(1, 'jobberbase', 1, 1, 2, 'transportation - Auto Mechanic rss feed', 'freejoblistings.ca', '', 'http://freejoblistings.ca/transportation-logistics/rss/auto-mechanic-job-listings-in-canada/'),
(2, 'jobberbase', 1, 1, 3, 'transportation - Aircraft Technician pilot rss feed', 'freejoblistings.ca', '', 'http://freejoblistings.ca/transportation-logistics/rss/pilot-aircraft-technician-job-listings-in-canada/'),
(3, 'jobberbase', 1, 1, 4, 'transportation - Bus Driver rss feed', 'freejoblistings.ca', '', 'http://freejoblistings.ca/transportation-logistics/rss/bus-driver-job-listings-in-canada/'),
(4, 'jobberbase', 1, 1, 5, 'transportation - Courier rss feed', 'freejoblistings.ca', '', 'http://freejoblistings.ca/transportation-logistics/rss/courier-job-listings-in-canada/'),
(5, 'jobberbase', 1, 1, 6, 'transportation - Fleet Manager rss feed', 'freejoblistings.ca', '', 'http://freejoblistings.ca/transportation-logistics/rss/fleet-manager-job-listings-in-canada/');