-- 
-- Database: `lalina`
-- 

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

-- 
-- Table structure for table `lalina_feeds`
-- 

DROP TABLE IF EXISTS `lalina_feeds`;
CREATE TABLE IF NOT EXISTS `lalina_feeds` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `url` varchar(255) NOT NULL default '',
  `name` varchar(255) default NULL,
  `lastmod` varchar(255) default NULL,
  `etag` varchar(255) default NULL,
  `added` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `url` (`url`)
) TYPE=MyISAM ;

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

-- 
-- Table structure for table `lalina_items`
-- 

DROP TABLE IF EXISTS `lalina_items`;
CREATE TABLE IF NOT EXISTS `lalina_items` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `feed_id` int(10) unsigned NOT NULL default '0',
  `url` varchar(255) NOT NULL default '',
  `title` varchar(255) NOT NULL default '''no title''',
  `body` text,
  `dt` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `feed_id` (`feed_id`,`url`)
) TYPE=MyISAM ;

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

-- 
-- Table structure for table `lalina_userfeeds`
-- 

DROP TABLE IF EXISTS `lalina_userfeeds`;
CREATE TABLE IF NOT EXISTS `lalina_userfeeds` (
  `feed_id` int(10) unsigned NOT NULL default '0',
  `user_id` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`feed_id`,`user_id`)
) TYPE=MyISAM;

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

-- 
-- Table structure for table `lalina_users`
-- 

DROP TABLE IF EXISTS `lalina_users`;
CREATE TABLE IF NOT EXISTS `lalina_users` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `login` varchar(255) NOT NULL default '',
  `pass` varchar(255) NOT NULL default '',
  `magic` varchar(32) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `login` (`login`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;