CREATE TABLE `heads` (
  `id` bigint(20) NOT NULL auto_increment,
  `title` varchar(80) collate latin1_general_ci NOT NULL,
  `link` varchar(255) collate latin1_general_ci NOT NULL,
  `description` varchar(120) collate latin1_general_ci NOT NULL,
  `pubDate` datetime NOT NULL,
  `language` char(2) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `heads`
-- 


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

-- 
-- Table structure for table `items`
-- 

CREATE TABLE `items` (
  `id` bigint(20) NOT NULL auto_increment,
  `head_id` bigint(20) NOT NULL,
  `title` varchar(80) collate latin1_general_ci NOT NULL,
  `link` varchar(255) collate latin1_general_ci NOT NULL,
  `description` varchar(120) collate latin1_general_ci NOT NULL,
  `pubDate` datetime NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;