#06.08.2013
CREATE TABLE IF NOT EXISTS `bibliography_bibliography_i18n` (
  `id` int(11) NOT NULL,
  `title` varchar(500) DEFAULT NULL,
  `abstract` text,
  `locale` varchar(5) NOT NULL DEFAULT 'en_US',
  KEY `id` (`id`),
  KEY `title` (`title`(255)),
  FULLTEXT KEY `keyword` (`title`,`abstract`),
  FULLTEXT KEY `abstract` (`abstract`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT EXISTS `bibliography_journal_i18n` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL DEFAULT '',
  `description` varchar(500) NULL DEFAULT '',
  `locale` varchar(5) NOT NULL DEFAULT 'en_US',
  KEY `id` (`id`),
  KEY `title` (`title`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT EXISTS `bibliography_publisher_i18n` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '',
  `description` varchar(500) NULL DEFAULT ' ',
  `locale` varchar(5) NOT NULL DEFAULT 'en_US',
  KEY `id` (`id`),
  KEY `title` (`title`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

INSERT INTO bibliography_bibliography_i18n (id, title, abstract) SELECT id, title, abstract FROM bibliography_bibliography;
INSERT INTO bibliography_journal_i18n (id, title, description) SELECT id, title, description FROM bibliography_journal;
INSERT INTO bibliography_publisher_i18n (id, title, description) SELECT id, title, description FROM bibliography_publisher;

ALTER TABLE `bibliography_bibliography` DROP `title`, DROP `abstract`;
ALTER TABLE `bibliography_journal` DROP `title`, DROP `description`;
ALTER TABLE `bibliography_publisher` DROP `title`, DROP `description`;
