-- индексирование
DROP TABLE IF EXISTS `bff_sphinx`;
CREATE TABLE `bff_sphinx` (
  `module` varchar(50) NOT NULL DEFAULT '',
  `indexed` timestamp NOT NULL default '0000-00-00 00:00:00',
  UNIQUE KEY  (`module`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;

-- словоформы
DROP TABLE IF EXISTS `bff_sphinx_wordforms`;
CREATE TABLE `bff_sphinx_wordforms` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `module` varchar(50) NOT NULL DEFAULT '',
  `src` varchar(250) NOT NULL default '',
  `dest` varchar(250) NOT NULL default '',
  `created` timestamp NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `module` (`module`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;